DBA Data[Home] [Help]

APPS.PO_CHANGEORDERWF_PVT dependencies on PO_SUPPLIER_CHANGE_WF_S

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 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