APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on PO_REQUESTER_CHANGE_WF_S

Line 4036: select PO_REQUESTER_CHANGE_WF_S.nextval into l_count from dual;

4032:
4033: begin
4034:
4035: x_progress :='StartInformBuyerWF:001';
4036: select PO_REQUESTER_CHANGE_WF_S.nextval into l_count from dual;
4037: item_key:='INFORM_'||to_char(p_change_request_group_id)||'_'||to_char(l_count);
4038: x_progress :='StartInformBuyerWF:key:'||item_key;
4039:
4040: open get_parent_info_csr(p_change_request_group_id);

Line 8619: select PO_REQUESTER_CHANGE_WF_S.nextval into l_seq from dual;

8615: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8616: itemkey => itemkey,
8617: aname => 'DOCUMENT_TYPE');
8618:
8619: select PO_REQUESTER_CHANGE_WF_S.nextval into l_seq from dual;
8620:
8621: if(l_document_type = 'RELEASE') then
8622: l_item_key := 'RC_REL'||'-'||l_document_id||'-'||l_seq;
8623: else

Line 8877: || to_char(PO_REQUESTER_CHANGE_WF_S.nextval)

8873: close change_request_group_id;
8874:
8875: SELECT to_char(p_req_header_id) || '-'
8876: ||to_char(l_change_request_group_id)||'-'
8877: || to_char(PO_REQUESTER_CHANGE_WF_S.nextval)
8878: INTO p_item_key
8879: FROM sys.dual;
8880:
8881: select preparer_id, segment1

Line 8952: select PO_REQUESTER_CHANGE_WF_S.nextval into l_count from dual;

8948: and pcr.wf_item_type is not null;
8949:
8950: begin
8951:
8952: select PO_REQUESTER_CHANGE_WF_S.nextval into l_count from dual;
8953: item_key:='RESPONSE_'||to_char(p_change_request_group_id)||'_'||to_char(l_count);
8954:
8955: open get_parent_info_csr(p_change_request_group_id);
8956: fetch get_parent_info_csr into l_parent_item_type, l_parent_item_key;

Line 9123: select PO_REQUESTER_CHANGE_WF_S.nextval into l_count from dual;

9119: END IF;
9120:
9121: x_progress:='001';
9122: x_return_status := FND_API.g_ret_sts_success;
9123: select PO_REQUESTER_CHANGE_WF_S.nextval into l_count from dual;
9124: item_key:='RESPONSE_'||to_char(p_change_request_group_id)||'_'||to_char(l_count);
9125:
9126: x_progress:='002';
9127: open get_parent_info_csr(p_change_request_group_id);

Line 11063: SELECT po_requester_change_wf_s.nextval INTO l_count FROM dual;

11059: BEGIN
11060:
11061: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_NotifyRequesterProcess: 01' || ' P_PO_CHANGE_REQUEST_GROUP_ID:' || p_po_change_request_group_id;
11062:
11063: SELECT po_requester_change_wf_s.nextval INTO l_count FROM dual;
11064:
11065: l_item_key:='NOTIFREQ_'||to_char(p_po_change_request_group_id)||'_'||to_char(l_count);
11066:
11067: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_NotifyRequesterProcess: 02' || ' ITEM KEY:' || l_item_key;

Line 11460: || to_char(po_requester_change_wf_s.nextval)

11456:
11457: l_progress := '003';
11458: SELECT to_char(p_req_header_id) || '-'
11459: || to_char(l_change_request_group_id) || '-'
11460: || to_char(po_requester_change_wf_s.nextval)
11461: INTO p_item_key
11462: FROM sys.dual;
11463:
11464: