APPS.PO_CHANGEORDERWF_PVT dependencies on DUAL

Line 129: select PO_SUPPLIER_CHANGE_WF_S.nextval into l_seq from dual;

125: if(p_requestor_id is null or p_chg_req_grp_id is null) then
126: return;
127: end if;
128:
129: select PO_SUPPLIER_CHANGE_WF_S.nextval into l_seq from dual;
130: if(p_release_id is null) then
131: l_item_key := 'NRSC-'||to_char(p_requestor_id)||'-'||to_char(p_header_id)||'-'||to_char(p_revision_num)||'-'||to_char(l_seq);
132: else
133: l_item_key := 'NRSC-'||to_char(p_requestor_id)||'-'||to_char(p_release_id)||'-'||to_char(p_revision_num)||'-'||to_char(l_seq);

Line 223: select PO_SUPPLIER_CHANGE_WF_S.nextval into l_seq from dual;

219: if(p_planner_id is null or p_chg_req_grp_id is null) then
220: return;
221: end if;
222:
223: select PO_SUPPLIER_CHANGE_WF_S.nextval into l_seq from dual;
224:
225: if(p_release_id is null) then
226: l_item_key := 'NPSC-'||to_char(p_planner_id)||'-'||to_char(p_header_id)||'-'||to_char(p_revision_num)||'-'||to_char(l_seq);
227: else

Line 941: SELECT po_acceptances_s.nextval into l_Acceptance_id FROM sys.dual;

937: l_rspndr_usr_name fnd_user.user_name%TYPE := '';
938: l_accepting_party varchar2(1);
939: begin
940:
941: SELECT po_acceptances_s.nextval into l_Acceptance_id FROM sys.dual;
942:
943: -- commented out the usage of accptance_type (FPI)
944: /*
945: l_Acceptance_Lookup_Code := wf_engine.GetItemAttrText( itemtype => p_itemtype,

Line 1403: select to_char(PO_WF_ITEMKEY_S.NEXTVAL) into l_seq from sys.dual;

1399: from PO_DOCUMENT_TYPES_V
1400: where DOCUMENT_TYPE_CODE = l_Document_Type_Code
1401: and DOCUMENT_SUBTYPE = l_Document_Subtype;
1402:
1403: select to_char(PO_WF_ITEMKEY_S.NEXTVAL) into l_seq from sys.dual;
1404: l_Item_Key := to_char(l_Document_ID) || '-' || l_seq;
1405:
1406:
1407:

Line 6742: select PO_SUPPLIER_CHANGE_WF_S.nextval into l_seq from dual;

6738: aname => 'DOCUMENT_TYPE');
6739:
6740:
6741:
6742: select PO_SUPPLIER_CHANGE_WF_S.nextval into l_seq from dual;
6743:
6744: if(l_document_type = 'RELEASE') then
6745: l_item_key := 'SC_REL'||'-'||l_document_id||'-'||l_seq;
6746: else

Line 7046: select PO_SUPPLIER_CHANGE_WF_S.nextval into l_seq from dual;

7042: AND fndu.user_id = pcr.responded_by;
7043:
7044:
7045: BEGIN
7046: select PO_SUPPLIER_CHANGE_WF_S.nextval into l_seq from dual;
7047: if(p_release_id is not null) then
7048: l_document_id := p_release_id;
7049: l_item_key := 'NSCR'||'-'||to_char(p_release_id)||'-'||to_char(p_revision_num)||'-'||to_char(l_seq);
7050: else

Line 7892: select PO_SUPPLIER_CHANGE_WF_S.nextval into l_seq from dual;

7888: l_api_name || 'start',p_header_id||'*'||p_release_id||'*'||p_revision_num||'*'||p_chg_req_grp_id);
7889: END IF;
7890:
7891: -- Start Workflow
7892: select PO_SUPPLIER_CHANGE_WF_S.nextval into l_seq from dual;
7893: if(p_release_id is not null) then
7894: l_doc_type_code := 'R';
7895: l_item_key := p_release_id||'-'||p_revision_num||'-'||l_doc_type_code||'-'||to_char(l_seq);
7896: else

Line 8488: FROM DUAL

8484: l_ship_invalid_for_ctrl_actn varchar2(1);
8485: BEGIN
8486: SELECT 'N'
8487: INTO l_ship_invalid_for_ctrl_actn
8488: FROM DUAL
8489: WHERE EXISTS(
8490: SELECT 1
8491: FROM po_line_locations_all poll1,
8492: po_line_locations_all poll2