DBA Data[Home] [Help]

APPS.RCV_BUSINESS_EVENTS dependencies on PO_WF_ITEMKEY_S

Line 60: SELECT po_wf_itemkey_s.NEXTVAL

56: wf_event.setdispatchmode('ASYNC');
57:
58: BEGIN
59: FOR grh IN get_rcv_headers LOOP
60: SELECT po_wf_itemkey_s.NEXTVAL
61: INTO l_wf_item_seq
62: FROM DUAL;
63:
64: l_event_key := TO_CHAR(grh.shipment_header_id) || '-' || TO_CHAR(l_wf_item_seq);

Line 88: select po_wf_itemkey_s.nextval into l_wf_item_seq from dual;

84: -------Modified For OPSM--
85: ----------------------------
86: BEGIN
87: For grhr in get_rcv_headers_rma loop
88: select po_wf_itemkey_s.nextval into l_wf_item_seq from dual;
89: wf_event.addparametertolist(p_name => 'SHIPMENT_HEADER_ID',
90: p_value => grhr.shipment_header_id,
91: p_parameterlist => l_parameter_list);
92: wf_event.addparametertolist(p_name => 'GROUP_ID',