DBA Data[Home] [Help]

APPS.PO_CHANGEORDERWF_PVT dependencies on PO_SUPPLIER_CHANGE_WF_S

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

103: if(p_requestor_id is null or p_chg_req_grp_id is null) then
104: return;
105: end if;
106:
107: select PO_SUPPLIER_CHANGE_WF_S.nextval into l_seq from dual;
108: if(p_release_id is null) then
109: l_item_key := 'NRSC-'||to_char(p_requestor_id)||'-'||to_char(p_header_id)||'-'||to_char(p_revision_num)||'-'||to_char(l_seq);
110: else
111: l_item_key := 'NRSC-'||to_char(p_requestor_id)||'-'||to_char(p_release_id)||'-'||to_char(p_revision_num)||'-'||to_char(l_seq);

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

197: if(p_planner_id is null or p_chg_req_grp_id is null) then
198: return;
199: end if;
200:
201: select PO_SUPPLIER_CHANGE_WF_S.nextval into l_seq from dual;
202:
203: if(p_release_id is null) then
204: l_item_key := 'NPSC-'||to_char(p_planner_id)||'-'||to_char(p_header_id)||'-'||to_char(p_revision_num)||'-'||to_char(l_seq);
205: else

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

6580: aname => 'DOCUMENT_TYPE');
6581:
6582:
6583:
6584: select PO_SUPPLIER_CHANGE_WF_S.nextval into l_seq from dual;
6585:
6586: if(l_document_type = 'RELEASE') then
6587: l_item_key := 'SC_REL'||'-'||l_document_id||'-'||l_seq;
6588: else

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

6884: AND fndu.user_id = pcr.responded_by;
6885:
6886:
6887: BEGIN
6888: select PO_SUPPLIER_CHANGE_WF_S.nextval into l_seq from dual;
6889: if(p_release_id is not null) then
6890: l_document_id := p_release_id;
6891: l_item_key := 'NSCR'||'-'||to_char(p_release_id)||'-'||to_char(p_revision_num)||'-'||to_char(l_seq);
6892: else

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

7730: l_api_name || 'start',p_header_id||'*'||p_release_id||'*'||p_revision_num||'*'||p_chg_req_grp_id);
7731: END IF;
7732:
7733: -- Start Workflow
7734: select PO_SUPPLIER_CHANGE_WF_S.nextval into l_seq from dual;
7735: if(p_release_id is not null) then
7736: l_doc_type_code := 'R';
7737: l_item_key := p_release_id||'-'||p_revision_num||'-'||l_doc_type_code||'-'||to_char(l_seq);
7738: else