Home » Applications » Oracle Fusion Apps & E-Business Suite » problem with po receipts confirmation customization
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
Previous Topic: I would like to learn more about the API associated
Next Topic: Creating a new balance element and populating it
Goto Forum:
  


Current Time: Tue Dec 06 06:09:07 CST 2016

Total time taken to generate the page: 0.11357 seconds