| problem with po receipts confirmation customization [message #188593] |
Sun, 20 August 2006 08:02 |
sesh8
Messages: 9
Registered: August 2006
|
Junior Member |
|
|
hi
i have a problem with po receipts confirmation customization
previously once po is approved and run the po receipts confirm concurrent
program then work flow will be triggered
they add 15 days more to the due date
but my requirement i s have to add 15 days to the po approved date.
in the PORCPTWF .get_order_info procedure they wrote a code
due date is standard attribute in the po confirm receipts workflow....
they assign due date to
x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,
itemkey => itemkey,
aname => 'DUE_DATE');
and then
x_due_date_plus_15 := x_exp_receipt_date + 15;
wf_engine.SetItemAttrText ( itemtype => Itemtype,
itemkey => Itemkey,
aname => 'DUE_DATE_PLUS_15',
avalue => x_due_date_plus_15 );
but i need to get po aproved date so there is a select statement in the same procedure i have added approved_date from po_headers and retrived into
a variable x_approved_date;
SELECT poh.segment1,
pov.vendor_name,
poh.agent_id,
poh.note_to_receiver,
poh.approved_date -- i added this
INTO x_po_number,
x_supplier_name,
x_buyer_id,
x_note_to_receiver,
x_approved_date -- i added this
FROM PO_HEADERS poh,
PO_VENDORS pov
WHERE po_header_id = x_po_header_id
AND poh.vendor_id = pov.vendor_id (+);
then
i have created a approved_date attribute in the po confirm receipt workflow
since there is no standard attribute related to approved dat
and in this procedure i wrote
x_approved_date_plus_15 := x_approved_date + 15;
wf_engine.SetItemAttrText ( itemtype => Itemtype,
itemkey => Itemkey,
aname => 'APPROVED_DATE',
avalue => x_approved_date_plus_15 );
....
but its not working
any suggestions....please
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
