APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on DUAL

Line 2858: from dual)

2854: l_temp_responder,
2855: fnd_global.user_id,
2856: fnd_global.login_id,
2857: sysdate
2858: from dual)
2859: where pcr1.change_request_group_id in
2860: (select parent_change_request_id
2861: from po_change_requests
2862: where change_request_group_id=p_change_request_group_id

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

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
9269: into l_preparer_id, l_req_num
9270: from po_requisition_headers_all

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

10781: -- check for shipment quantity, shipment amount(% and Functional currency) tolerances
10782:
10783: SELECT 'N'
10784: INTO l_return_val
10785: FROM dual
10786: WHERE exists (
10787: SELECT 'N'
10788: FROM
10789: po_change_requests pcr, -- for quantity/amount change

Line 10885: FROM dual

10881: BEGIN
10882:
10883: SELECT 'N'
10884: INTO l_return_val
10885: FROM dual
10886: WHERE exists (
10887: SELECT 'N'
10888: FROM po_change_requests pcr
10889: WHERE change_request_group_id = p_pochggrp_id

Line 10916: FROM dual

10912:
10913: BEGIN
10914: SELECT 'N'
10915: INTO l_return_val
10916: FROM dual
10917: WHERE exists (
10918: SELECT 'N'
10919: FROM po_change_requests pcr
10920: WHERE change_request_group_id = p_pochggrp_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 11866: FROM sys.dual;

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

Line 12869: -- populate the secondary qty and update on req line for dual UOM item line.

12865: SELECT PRIMARY_UOM_CODE, SECONDARY_UOM_CODE
12866: INTO l_prim_uom_cde, l_sec_uom_code
12867: FROM mtl_system_items_b
12868: WHERE INVENTORY_ITEM_ID =l_item_id AND ORGANIZATION_ID =l_source_org;
12869: -- populate the secondary qty and update on req line for dual UOM item line.
12870: IF( l_sec_uom_code IS NOT NULL) THEN
12871: x_progress := '014';
12872: l_sec_cancelled_qty := INV_CONVERT.inv_um_convert(item_id =>l_item_id, --item id
12873: lot_number=> null,