APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on DUAL

Line 2736: from dual)

2732: l_temp_responder,
2733: fnd_global.user_id,
2734: fnd_global.login_id,
2735: sysdate
2736: from dual)
2737: where pcr1.change_request_group_id in
2738: (select parent_change_request_id
2739: from po_change_requests
2740: where change_request_group_id=p_change_request_group_id

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 8879: FROM sys.dual;

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
8882: into l_preparer_id, l_req_num
8883: from po_requisition_headers_all

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 10395: FROM dual

10391: -- check for shipment quantity, shipment amount(% and Functional currency) tolerances
10392:
10393: SELECT 'N'
10394: INTO l_return_val
10395: FROM dual
10396: WHERE exists (
10397: SELECT 'N'
10398: FROM
10399: po_change_requests pcr, -- for quantity/amount change

Line 10495: FROM dual

10491: BEGIN
10492:
10493: SELECT 'N'
10494: INTO l_return_val
10495: FROM dual
10496: WHERE exists (
10497: SELECT 'N'
10498: FROM po_change_requests pcr
10499: WHERE change_request_group_id = p_pochggrp_id

Line 10526: FROM dual

10522:
10523: BEGIN
10524: SELECT 'N'
10525: INTO l_return_val
10526: FROM dual
10527: WHERE exists (
10528: SELECT 'N'
10529: FROM po_change_requests pcr
10530: WHERE change_request_group_id = p_pochggrp_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 11462: FROM sys.dual;

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:
11465: SELECT preparer_id, segment1,TYPE_LOOKUP_CODE
11466: INTO l_preparer_id, l_req_num,p_document_subtype