eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POR_UTIL_PKG dependencies on PO_REQUISITION_HEADERS_ALL

Line 33: l_DocumentTypeCode po_requisition_headers_all.type_lookup_code%TYPE;

29: l_award_ids dbms_sql.NUMBER_TABLE;
30: l_status VARCHAR2(1);
31: l_err_msg VARCHAR2(4000);
32: l_progress VARCHAR2(4) := '000';
33: l_DocumentTypeCode po_requisition_headers_all.type_lookup_code%TYPE;
34: BEGIN
35:
36: --Put this check as part of fix for bug#6368269. If the flow to delete requisition comes
37: --from "Purge System Saved Requisition", concurrent request, it will skip the code snippet

Line 52: DELETE FROM po_requisition_headers_all

48: end if;
49:
50:
51: -- delete the header
52: DELETE FROM po_requisition_headers_all
53: WHERE requisition_header_id = p_header_id;
54:
55: l_progress := '010';
56:

Line 202: FROM po_requisition_headers_all

198: l_header_id NUMBER;
199: BEGIN
200: SELECT requisition_header_id
201: INTO l_header_id
202: FROM po_requisition_headers_all
203: WHERE segment1 = p_req_number;
204:
205: delete_requisition_internal(l_header_id, TRUE);
206:

Line 374: FROM po_requisition_headers_all

370: FUNCTION req_header_id_exist(p_req_header_id IN NUMBER) RETURN CHAR IS
371: l_count NUMBER := 0;
372: BEGIN
373: SELECT 1 into l_count
374: FROM po_requisition_headers_all
375: WHERE requisition_header_id = p_req_header_id;
376:
377: RETURN 'Y';
378:

Line 997: l_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;

993: END update_gms_distributions;
994:
995: PROCEDURE update_notif_header_attr(p_header_id IN NUMBER) IS
996:
997: l_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
998: l_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
999: l_child_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
1000: l_child_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
1001:

Line 998: l_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;

994:
995: PROCEDURE update_notif_header_attr(p_header_id IN NUMBER) IS
996:
997: l_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
998: l_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
999: l_child_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
1000: l_child_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
1001:
1002: l_notif_id number;

Line 999: l_child_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;

995: PROCEDURE update_notif_header_attr(p_header_id IN NUMBER) IS
996:
997: l_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
998: l_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
999: l_child_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
1000: l_child_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
1001:
1002: l_notif_id number;
1003: l_description varchar2(240);

Line 1000: l_child_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;

996:
997: l_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
998: l_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
999: l_child_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
1000: l_child_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
1001:
1002: l_notif_id number;
1003: l_description varchar2(240);
1004: l_req_total varchar2(240);

Line 1035: FROM PO_REQUISITION_HEADERS_ALL

1031: l_progress := '001';
1032:
1033: SELECT wf_item_type, wf_item_key
1034: INTO l_wf_itemtype, l_wf_itemkey
1035: FROM PO_REQUISITION_HEADERS_ALL
1036: WHERE REQUISITION_HEADER_ID = p_header_id;
1037:
1038: l_progress := '002';
1039:

Line 1180: l_origReqNumber po_requisition_headers_all.segment1%TYPE;

1176: p_tempReqSupplierIds IN PO_TBL_NUMBER,
1177: p_origPriceDiffIds IN PO_TBL_NUMBER,
1178: p_tempPriceDiffIds IN PO_TBL_NUMBER) IS
1179:
1180: l_origReqNumber po_requisition_headers_all.segment1%TYPE;
1181: l_progress VARCHAR2(4) := '000';
1182: l_status po_requisition_headers_all.authorization_status%TYPE;
1183: l_contractor_requisition_flag po_requisition_headers_all.contractor_requisition_flag%TYPE;
1184:

Line 1182: l_status po_requisition_headers_all.authorization_status%TYPE;

1178: p_tempPriceDiffIds IN PO_TBL_NUMBER) IS
1179:
1180: l_origReqNumber po_requisition_headers_all.segment1%TYPE;
1181: l_progress VARCHAR2(4) := '000';
1182: l_status po_requisition_headers_all.authorization_status%TYPE;
1183: l_contractor_requisition_flag po_requisition_headers_all.contractor_requisition_flag%TYPE;
1184:
1185: BEGIN
1186: -- get the original req number and status

Line 1183: l_contractor_requisition_flag po_requisition_headers_all.contractor_requisition_flag%TYPE;

1179:
1180: l_origReqNumber po_requisition_headers_all.segment1%TYPE;
1181: l_progress VARCHAR2(4) := '000';
1182: l_status po_requisition_headers_all.authorization_status%TYPE;
1183: l_contractor_requisition_flag po_requisition_headers_all.contractor_requisition_flag%TYPE;
1184:
1185: BEGIN
1186: -- get the original req number and status
1187: SELECT segment1, authorization_status, contractor_requisition_flag

Line 1189: FROM po_requisition_headers_all

1185: BEGIN
1186: -- get the original req number and status
1187: SELECT segment1, authorization_status, contractor_requisition_flag
1188: INTO l_origReqNumber, l_status, l_contractor_requisition_flag
1189: FROM po_requisition_headers_all
1190: WHERE requisition_header_id = p_origHeaderId;
1191:
1192: l_progress := '010';
1193:

Line 1215: UPDATE po_requisition_headers_all

1211:
1212: l_progress := '020';
1213:
1214: -- flip the header id in headers
1215: UPDATE po_requisition_headers_all
1216: SET requisition_header_id = p_origHeaderId,
1217: -- segment1 = l_origReqNumber,
1218: segment1=LTrim(segment1,'##'),
1219: authorization_status = l_status

Line 1453: UPDATE PO_REQUISITION_HEADERS_ALL

1449: IF X_CONTRACTOR_REQ_FLAG = 'Y' AND X_SUPPL_NOTIFIED_FLAG = 'Y' THEN
1450: /*
1451: Set the Contractor Status at Header level to 'ASSIGNED'
1452: */
1453: UPDATE PO_REQUISITION_HEADERS_ALL
1454: SET CONTRACTOR_STATUS = 'ASSIGNED'
1455: WHERE REQUISITION_HEADER_ID = req_Header_Id
1456: AND CONTRACTOR_STATUS = 'PENDING';
1457:

Line 1481: update po_requisition_headers_all

1477: END IF;
1478: --ABORT THE EXISTING WF
1479: WF_Engine.AbortProcess(X_WF_ITEM_TYPE, X_WF_ITEM_KEY);
1480: WF_PURGE.total (X_WF_ITEM_TYPE, X_WF_ITEM_KEY);
1481: update po_requisition_headers_all
1482: set WF_ITEM_TYPE = NULL, WF_ITEM_KEY = NULL
1483: where REQUISITION_HEADER_ID = req_Header_Id;
1484: END IF;
1485: END IF;

Line 1504: from po_requisition_headers_all

1500: begin
1501:
1502: select segment1, preparer_id
1503: into p_req_num, p_preparer_id
1504: from po_requisition_headers_all
1505: where requisition_header_id =req_Header_Id;
1506:
1507:
1508: select EMPLOYEE_ID into p_approver_id

Line 1544: p_document_subtype PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE := 'PURCHASE';

1540: p_submitter_action VARCHAR2(20) := 'APPROVE';
1541: p_workflow_process VARCHAR2(30);
1542: p_resume_contractor VARCHAR2(1) := 'N';
1543:
1544: p_document_subtype PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE := 'PURCHASE';
1545: X_AUTHORIZATION_STATUS PO_REQUISITION_HEADERS_ALL.authorization_status%TYPE;
1546: X_SUPPL_NOTIFIED_FLAG PO_REQUISITION_HEADERS_ALL.supplier_notified_flag%TYPE;
1547: X_CONTRACTOR_REQ_FLAG PO_REQUISITION_HEADERS_ALL.contractor_requisition_flag%TYPE;
1548: X_WF_ITEM_KEY PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;

Line 1545: X_AUTHORIZATION_STATUS PO_REQUISITION_HEADERS_ALL.authorization_status%TYPE;

1541: p_workflow_process VARCHAR2(30);
1542: p_resume_contractor VARCHAR2(1) := 'N';
1543:
1544: p_document_subtype PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE := 'PURCHASE';
1545: X_AUTHORIZATION_STATUS PO_REQUISITION_HEADERS_ALL.authorization_status%TYPE;
1546: X_SUPPL_NOTIFIED_FLAG PO_REQUISITION_HEADERS_ALL.supplier_notified_flag%TYPE;
1547: X_CONTRACTOR_REQ_FLAG PO_REQUISITION_HEADERS_ALL.contractor_requisition_flag%TYPE;
1548: X_WF_ITEM_KEY PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
1549: X_WF_ITEM_TYPE PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;

Line 1546: X_SUPPL_NOTIFIED_FLAG PO_REQUISITION_HEADERS_ALL.supplier_notified_flag%TYPE;

1542: p_resume_contractor VARCHAR2(1) := 'N';
1543:
1544: p_document_subtype PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE := 'PURCHASE';
1545: X_AUTHORIZATION_STATUS PO_REQUISITION_HEADERS_ALL.authorization_status%TYPE;
1546: X_SUPPL_NOTIFIED_FLAG PO_REQUISITION_HEADERS_ALL.supplier_notified_flag%TYPE;
1547: X_CONTRACTOR_REQ_FLAG PO_REQUISITION_HEADERS_ALL.contractor_requisition_flag%TYPE;
1548: X_WF_ITEM_KEY PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
1549: X_WF_ITEM_TYPE PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
1550: BEGIN

Line 1547: X_CONTRACTOR_REQ_FLAG PO_REQUISITION_HEADERS_ALL.contractor_requisition_flag%TYPE;

1543:
1544: p_document_subtype PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE := 'PURCHASE';
1545: X_AUTHORIZATION_STATUS PO_REQUISITION_HEADERS_ALL.authorization_status%TYPE;
1546: X_SUPPL_NOTIFIED_FLAG PO_REQUISITION_HEADERS_ALL.supplier_notified_flag%TYPE;
1547: X_CONTRACTOR_REQ_FLAG PO_REQUISITION_HEADERS_ALL.contractor_requisition_flag%TYPE;
1548: X_WF_ITEM_KEY PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
1549: X_WF_ITEM_TYPE PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
1550: BEGIN
1551:

Line 1548: X_WF_ITEM_KEY PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;

1544: p_document_subtype PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE := 'PURCHASE';
1545: X_AUTHORIZATION_STATUS PO_REQUISITION_HEADERS_ALL.authorization_status%TYPE;
1546: X_SUPPL_NOTIFIED_FLAG PO_REQUISITION_HEADERS_ALL.supplier_notified_flag%TYPE;
1547: X_CONTRACTOR_REQ_FLAG PO_REQUISITION_HEADERS_ALL.contractor_requisition_flag%TYPE;
1548: X_WF_ITEM_KEY PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
1549: X_WF_ITEM_TYPE PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
1550: BEGIN
1551:
1552: begin

Line 1549: X_WF_ITEM_TYPE PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;

1545: X_AUTHORIZATION_STATUS PO_REQUISITION_HEADERS_ALL.authorization_status%TYPE;
1546: X_SUPPL_NOTIFIED_FLAG PO_REQUISITION_HEADERS_ALL.supplier_notified_flag%TYPE;
1547: X_CONTRACTOR_REQ_FLAG PO_REQUISITION_HEADERS_ALL.contractor_requisition_flag%TYPE;
1548: X_WF_ITEM_KEY PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
1549: X_WF_ITEM_TYPE PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
1550: BEGIN
1551:
1552: begin
1553:

Line 1562: FROM PO_REQUISITION_HEADERS_ALL

1558: type_lookup_code
1559: INTO X_AUTHORIZATION_STATUS, X_SUPPL_NOTIFIED_FLAG,
1560: X_CONTRACTOR_REQ_FLAG, X_WF_ITEM_KEY, X_WF_ITEM_TYPE,
1561: p_document_subtype
1562: FROM PO_REQUISITION_HEADERS_ALL
1563: WHERE REQUISITION_HEADER_ID = req_Header_Id;
1564:
1565: IF (g_po_wf_debug = 'Y') THEN
1566:

Line 2388: l_doc_sub_type PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

2384: l_activity_status VARCHAR2(8);
2385: l_progress VARCHAR2(4) := '000';
2386:
2387: l_pending_action PO_ACTION_HISTORY.ACTION_CODE%TYPE;
2388: l_doc_sub_type PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
2389: l_pending_emp_id PO_ACTION_HISTORY.EMPLOYEE_ID%TYPE;
2390:
2391: -- Logging Infra
2392: l_procedure_name CONSTANT VARCHAR2(30) := 'withdraw_req';

Line 2438: FROM po_requisition_headers_all

2434: END IF;
2435: -- abort workflow
2436: SELECT wf_item_type, wf_item_key, type_lookup_code
2437: INTO l_item_type, l_item_key, l_doc_sub_type
2438: FROM po_requisition_headers_all
2439: WHERE requisition_header_id= p_headerId;
2440:
2441: l_progress := '010';
2442:

Line 2444: UPDATE po_requisition_headers_all

2440:
2441: l_progress := '010';
2442:
2443: -- update wf keys and status
2444: UPDATE po_requisition_headers_all
2445: SET wf_item_type = NULL,
2446: wf_item_key = NULL,
2447: authorization_status = 'INCOMPLETE'
2448: WHERE requisition_header_id = p_headerId;

Line 2612: l_active_req_header_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%TYPE;

2608: -- Parameter:
2609: -- p_user_id IN Number: The user id of the user whose active req need to be deactivate.
2610:
2611: PROCEDURE deactivate_active_req(p_user_id IN NUMBER) IS
2612: l_active_req_header_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%TYPE;
2613: l_req_description PO_REQUISITION_HEADERS_ALL.DESCRIPTION%TYPE;
2614: l_authorization_status PO_REQUISITION_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
2615: l_update_header_required BOOLEAN;
2616: l_progress VARCHAR2(4) := '000';

Line 2613: l_req_description PO_REQUISITION_HEADERS_ALL.DESCRIPTION%TYPE;

2609: -- p_user_id IN Number: The user id of the user whose active req need to be deactivate.
2610:
2611: PROCEDURE deactivate_active_req(p_user_id IN NUMBER) IS
2612: l_active_req_header_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%TYPE;
2613: l_req_description PO_REQUISITION_HEADERS_ALL.DESCRIPTION%TYPE;
2614: l_authorization_status PO_REQUISITION_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
2615: l_update_header_required BOOLEAN;
2616: l_progress VARCHAR2(4) := '000';
2617:

Line 2614: l_authorization_status PO_REQUISITION_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;

2610:
2611: PROCEDURE deactivate_active_req(p_user_id IN NUMBER) IS
2612: l_active_req_header_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%TYPE;
2613: l_req_description PO_REQUISITION_HEADERS_ALL.DESCRIPTION%TYPE;
2614: l_authorization_status PO_REQUISITION_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
2615: l_update_header_required BOOLEAN;
2616: l_progress VARCHAR2(4) := '000';
2617:
2618: CURSOR active_req_header_cursor IS

Line 2620: FROM po_requisition_headers_all

2616: l_progress VARCHAR2(4) := '000';
2617:
2618: CURSOR active_req_header_cursor IS
2619: SELECT requisition_header_id, authorization_status, description
2620: FROM po_requisition_headers_all
2621: WHERE last_updated_by = p_user_id
2622: AND active_shopping_cart_flag = 'Y';
2623:
2624: CURSOR item_desc_cursor IS

Line 2668: UPDATE po_requisition_headers_all

2664: END IF;
2665:
2666: IF (l_update_header_required ) THEN
2667: l_progress := '080';
2668: UPDATE po_requisition_headers_all
2669: SET description = l_req_description,
2670: authorization_status = l_authorization_status
2671: WHERE requisition_header_id = l_active_req_header_id;
2672: END IF;

Line 2676: update po_requisition_headers_all

2672: END IF;
2673:
2674: l_progress := '090';
2675:
2676: update po_requisition_headers_all
2677: set active_shopping_cart_flag = null
2678: where last_updated_by = p_user_id
2679: and active_shopping_cart_flag = 'Y';
2680:

Line 3103: UPDATE po_requisition_headers_all

3099: END IF;
3100:
3101: l_progress := '030';
3102:
3103: UPDATE po_requisition_headers_all
3104: SET authorization_status = 'APPROVED'
3105: WHERE requisition_header_id = l_header_id
3106: AND authorization_status = 'PRE-APPROVED';
3107:

Line 3201: UPDATE po_requisition_headers_all

3197: END IF;
3198:
3199: l_progress := '030';
3200:
3201: UPDATE po_requisition_headers_all
3202: SET authorization_status = 'PRE-APPROVED'
3203: WHERE requisition_header_id = l_header_id
3204: AND authorization_status = 'APPROVED';
3205:

Line 3591: FROM po_requisition_lines_all prl, po_requisition_headers_all prh

3587: UNION
3588: SELECT document_id
3589: FROM fnd_attached_documents
3590: WHERE entity_name = 'REQ_LINES' AND pk1_value IN (SELECT to_char(requisition_line_id)
3591: FROM po_requisition_lines_all prl, po_requisition_headers_all prh
3592: WHERE prl.requisition_header_id = prh.requisition_header_id AND prh.requisition_header_id=to_number(p_req_header_id));
3593:
3594: BEGIN
3595: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 3634: from po_requisition_headers_all prh,

3630: l_enc_dist_count number := 0;
3631:
3632: BEGIN
3633: select count(*) into l_enc_dist_count
3634: from po_requisition_headers_all prh,
3635: po_requisition_lines_all prl,
3636: po_req_distributions_all prd
3637: where prh.requisition_header_id = p_req_header_id
3638: and prh.requisition_header_id = prl.requisition_header_id

Line 3930: FROM po_requisition_headers_all

3926: FETCH c_get_req_details INTO l_req_header_id, l_suggested_buyer_id, l_auction_header_id, l_line_loc_id;
3927: CLOSE c_get_req_details;
3928:
3929: SELECT AUTHORIZATION_STATUS INTO l_req_status
3930: FROM po_requisition_headers_all
3931: WHERE requisition_header_id = l_req_header_id;
3932:
3933: IF (l_req_status IS NULL) THEN
3934: l_line_status := NULL;

Line 4018: FROM po_requisition_headers_all

4014: FOR c_get_req_details_rec IN c_get_req_details(p_req_header_id)
4015: LOOP
4016:
4017: SELECT AUTHORIZATION_STATUS INTO l_req_status
4018: FROM po_requisition_headers_all
4019: WHERE requisition_header_id = c_get_req_details_rec.REQUISITION_HEADER_ID;
4020:
4021: IF (l_req_status IS NULL) THEN
4022: l_line_status := NULL;

Line 5881: from po_requisition_headers_all

5877: 'Progress: ' || l_progress || 'PDF Exists: ' || l_pdf_exists);
5878: END IF;
5879:
5880: select max(revision_num) into l_revision_num
5881: from po_requisition_headers_all
5882: where requisition_header_id = p_document_id
5883: and authorization_status = 'APPROVED';
5884:
5885: -- select max(revision_num) would not raise a no_data_found

Line 5948: l_document_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;

5944: l_user_exists NUMBER;
5945: l_notification_preference varchar2(20) := 'MAILHTM2';
5946: l_orgid number;
5947: l_operating_unit hr_all_organization_units.name%TYPE;
5948: l_document_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;
5949: l_docNumber PO_HEADERS_ALL.SEGMENT1%TYPE;
5950: l_release_num PO_RELEASES.release_num%TYPE;
5951: l_notification_id NUMBER;
5952: l_segment1 VARCHAR2(30);

Line 5961: from po_requisition_headers_all

5957: l_itemtype := 'REQAPPRV';
5958: l_progress := 'POR_UTIL_PKG.Start_Email_WF_Process: at beginning of Start_Email_WF_Process';
5959:
5960: SELECT segment1 into l_segment1
5961: from po_requisition_headers_all
5962: where requisition_header_id = p_document_id;
5963:
5964: l_progress := 'POR_UTIL_PKG.Start_Email_WF_Process: Verify whether the role exists in wf_users';
5965: