APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on PO_REQUESTER_CHANGE_WF_S

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

4185:
4186: begin
4187:
4188: x_progress :='StartInformBuyerWF:001';
4189: select PO_REQUESTER_CHANGE_WF_S.nextval into l_count from dual;
4190: item_key:='INFORM_'||to_char(p_change_request_group_id)||'_'||to_char(l_count);
4191: x_progress :='StartInformBuyerWF:key:'||item_key;
4192:
4193: open get_parent_info_csr(p_change_request_group_id);

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

9002: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
9003: itemkey => itemkey,
9004: aname => 'DOCUMENT_TYPE');
9005:
9006: select PO_REQUESTER_CHANGE_WF_S.nextval into l_seq from dual;
9007:
9008: if(l_document_type = 'RELEASE') then
9009: l_item_key := 'RC_REL'||'-'||l_document_id||'-'||l_seq;
9010: else

Line 9264: || to_char(PO_REQUESTER_CHANGE_WF_S.nextval)

9260: close change_request_group_id;
9261:
9262: SELECT to_char(p_req_header_id) || '-'
9263: ||to_char(l_change_request_group_id)||'-'
9264: || to_char(PO_REQUESTER_CHANGE_WF_S.nextval)
9265: INTO p_item_key
9266: FROM sys.dual;
9267:
9268: select preparer_id, segment1

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

9335: and pcr.wf_item_type is not null;
9336:
9337: begin
9338:
9339: select PO_REQUESTER_CHANGE_WF_S.nextval into l_count from dual;
9340: item_key:='RESPONSE_'||to_char(p_change_request_group_id)||'_'||to_char(l_count);
9341:
9342: open get_parent_info_csr(p_change_request_group_id);
9343: fetch get_parent_info_csr into l_parent_item_type, l_parent_item_key;

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

9506: END IF;
9507:
9508: x_progress:='001';
9509: x_return_status := FND_API.g_ret_sts_success;
9510: select PO_REQUESTER_CHANGE_WF_S.nextval into l_count from dual;
9511: item_key:='RESPONSE_'||to_char(p_change_request_group_id)||'_'||to_char(l_count);
9512:
9513: x_progress:='002';
9514: open get_parent_info_csr(p_change_request_group_id);

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

11463: BEGIN
11464:
11465: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_NotifyRequesterProcess: 01' || ' P_PO_CHANGE_REQUEST_GROUP_ID:' || p_po_change_request_group_id;
11466:
11467: SELECT po_requester_change_wf_s.nextval INTO l_count FROM dual;
11468:
11469: l_item_key:='NOTIFREQ_'||to_char(p_po_change_request_group_id)||'_'||to_char(l_count);
11470:
11471: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_NotifyRequesterProcess: 02' || ' ITEM KEY:' || l_item_key;

Line 11864: || to_char(po_requester_change_wf_s.nextval)

11860:
11861: l_progress := '003';
11862: SELECT to_char(p_req_header_id) || '-'
11863: || to_char(l_change_request_group_id) || '-'
11864: || to_char(po_requester_change_wf_s.nextval)
11865: INTO p_item_key
11866: FROM sys.dual;
11867:
11868: