DBA Data[Home] [Help]

APPS.POS_ACK_PO dependencies on PO_WF_ITEMKEY_S

Line 496: select po_wf_itemkey_s.nextval into l_seq_val from dual;

492: l_progress := '10';
493:
494: --dbms_output.put_line('Calling Workflow');
495: -- call workflow to send the notification
496: select po_wf_itemkey_s.nextval into l_seq_val from dual;
497:
498: l_item_key := 'POSACKNT_' || l_doc || '_' || to_char(l_seq_val);
499:
500: --dbms_output.put_line('Item Key is ' ||l_item_key);

Line 602: select po_wf_itemkey_s.nextval into l_seq_val

598: else
599: l_doc := pos_po_release_id;
600: end if;
601:
602: select po_wf_itemkey_s.nextval into l_seq_val
603: from dual;
604:
605: l_item_key := 'POS_PODATE_CHG_' || l_doc || '_' || to_char(l_seq_val);
606: pos_item_type := l_item_type;