APPS.PO_REQAPPROVAL_INIT1 dependencies on DUAL

Line 806: SELECT TO_CHAR(PO_WF_ITEMKEY_S.NEXTVAL) INTO l_seq_for_item_key FROM sys.dual;

802: END IF;
803: END IF;
804: -- Mod Project
805: IF (ItemKey IS NULL) THEN
806: SELECT TO_CHAR(PO_WF_ITEMKEY_S.NEXTVAL) INTO l_seq_for_item_key FROM sys.dual;
807:
808: l_itemkey := TO_CHAR(DocumentID) || '-' || l_seq_for_item_key;
809: ELSE
810: l_itemkey := ItemKey;

Line 894: select po_ame_approvals_s.nextval into l_ame_approval_id from dual;

890: WHERE po_header_id = DocumentID;
891:
892: if l_ame_transaction_type is not null AND ( l_ame_approval_id IS NULL or l_ame_approval_id = 0) THEN
893: --if l_ame_approval_id = 0 then
894: select po_ame_approvals_s.nextval into l_ame_approval_id from dual;
895: update po_headers_all
896: set ame_approval_id = l_ame_approval_id,
897: ame_transaction_type = l_ame_transaction_type
898: where po_header_id = DocumentID;

Line 916: select po_ame_approvals_s.nextval into l_ame_approval_id from dual;

912: AND phda.draft_id = DraftID
913: AND phda.draft_id = pd.draft_id;
914:
915: if l_ame_approval_id = 0 then
916: select po_ame_approvals_s.nextval into l_ame_approval_id from dual;
917: update po_headers_draft_all
918: set ame_approval_id = l_ame_approval_id
919: where po_header_id = DocumentID
920: and draft_id = DraftID;

Line 1360: FROM dual

1356: l_drop_ship_flag := 'N';
1357: IF DocumentTypeCode = 'RELEASE' THEN
1358: SELECT 'Y'
1359: INTO l_drop_ship_flag
1360: FROM dual
1361: WHERE EXISTS
1362: (SELECT 'Release DropShip Shipment Exists'
1363: FROM po_line_locations
1364: WHERE po_release_id = DocumentId

Line 1370: FROM dual

1366: );
1367: ELSIF DocumentTypeCode = 'PO' THEN
1368: SELECT 'Y'
1369: INTO l_drop_ship_flag
1370: FROM dual
1371: WHERE EXISTS
1372: (SELECT 'PO DropShip Shipment Exists'
1373: FROM po_line_locations
1374: WHERE po_header_id = DocumentId

Line 7091: SELECT TO_CHAR(PO_WF_ITEMKEY_S.NEXTVAL) INTO l_seq FROM sys.dual;

7087: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
7088: ELSE
7089: l_document_id := document_id;
7090: END IF;
7091: SELECT TO_CHAR(PO_WF_ITEMKEY_S.NEXTVAL) INTO l_seq FROM sys.dual;
7092:
7093: Err_ItemKey := TO_CHAR(l_document_id) || '-' || l_seq;
7094: x_progress := 'PO_REQAPPROVAL_INIT1.send_error_notif: 50' ||' Parent Itemtype: '|| ItemType ||' Parent Itemkey: '|| ItemKey ||' Error Itemtype: '|| Err_ItemType ||' Error Itemkey: '|| Err_ItemKey;
7095: IF (g_po_wf_debug = 'Y') THEN

Line 7790: -- SELECT po_acceptances_s.nextval into x_Acceptance_id FROM sys.dual;

7786: l_accepting_party VARCHAR2(1);
7787: BEGIN
7788: -- Bug 2850566
7789: -- Commented out the select statement as it is handled in the PO_ACCEPTANCES rowhandler
7790: -- SELECT po_acceptances_s.nextval into x_Acceptance_id FROM sys.dual;
7791: -- commented out the usage of accptance_type (FPI)
7792: /* x_Acceptance_Lookup_Code := wf_engine.GetItemAttrText( itemtype => itemtype,
7793: itemkey => itemkey,
7794: aname => 'ACCEPTANCE_LOOKUP_CODE'); */