DBA Data[Home] [Help]

APPS.POS_ACK_PO dependencies on PO_WF_ITEMKEY_S

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

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

Line 603: select po_wf_itemkey_s.nextval into l_seq_val

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