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

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 43: FROM po_requisition_headers

39: --and deletes the requisitions for all OUs.
40: if p_is_purge_req_process = false then
41: SELECT type_lookup_code
42: INTO l_DocumentTypeCode
43: FROM po_requisition_headers
44: WHERE requisition_header_id = p_header_id;
45:
46: --Bug#5360109 : cancel pending workflows for this requisition
47: PO_APPROVAL_REMINDER_SV.Cancel_Notif (l_DocumentTypeCode, p_header_id, 'N');

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 192: FROM po_requisition_headers_all

188: l_header_id NUMBER;
189: BEGIN
190: SELECT requisition_header_id
191: INTO l_header_id
192: FROM po_requisition_headers_all
193: WHERE segment1 = p_req_number;
194:
195: delete_requisition_internal(l_header_id, TRUE);
196:

Line 342: FROM po_requisition_headers

338: FUNCTION req_number_invalid(req_num IN NUMBER) RETURN BOOLEAN IS
339: l_count NUMBER := 0;
340: BEGIN
341: SELECT 1 into l_count
342: FROM po_requisition_headers
343: WHERE segment1 = to_char(req_num);
344:
345: RETURN true;
346:

Line 970: l_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;

966: END update_gms_distributions;
967:
968: PROCEDURE update_notif_header_attr(p_header_id IN NUMBER) IS
969:
970: l_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
971: l_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
972: l_child_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
973: l_child_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
974:

Line 971: l_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;

967:
968: PROCEDURE update_notif_header_attr(p_header_id IN NUMBER) IS
969:
970: l_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
971: l_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
972: l_child_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
973: l_child_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
974:
975: l_notif_id number;

Line 972: l_child_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;

968: PROCEDURE update_notif_header_attr(p_header_id IN NUMBER) IS
969:
970: l_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
971: l_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
972: l_child_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
973: l_child_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
974:
975: l_notif_id number;
976: l_description varchar2(240);

Line 973: l_child_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;

969:
970: l_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
971: l_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
972: l_child_wf_itemtype PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
973: l_child_wf_itemkey PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
974:
975: l_notif_id number;
976: l_description varchar2(240);
977: l_req_total varchar2(240);

Line 1008: FROM PO_REQUISITION_HEADERS_ALL

1004: l_progress := '001';
1005:
1006: SELECT wf_item_type, wf_item_key
1007: INTO l_wf_itemtype, l_wf_itemkey
1008: FROM PO_REQUISITION_HEADERS_ALL
1009: WHERE REQUISITION_HEADER_ID = p_header_id;
1010:
1011: l_progress := '002';
1012:

Line 1153: l_origReqNumber po_requisition_headers_all.segment1%TYPE;

1149: p_tempReqSupplierIds IN PO_TBL_NUMBER,
1150: p_origPriceDiffIds IN PO_TBL_NUMBER,
1151: p_tempPriceDiffIds IN PO_TBL_NUMBER) IS
1152:
1153: l_origReqNumber po_requisition_headers_all.segment1%TYPE;
1154: l_progress VARCHAR2(4) := '000';
1155: l_status po_requisition_headers_all.authorization_status%TYPE;
1156: l_contractor_requisition_flag po_requisition_headers_all.contractor_requisition_flag%TYPE;
1157:

Line 1155: l_status po_requisition_headers_all.authorization_status%TYPE;

1151: p_tempPriceDiffIds IN PO_TBL_NUMBER) IS
1152:
1153: l_origReqNumber po_requisition_headers_all.segment1%TYPE;
1154: l_progress VARCHAR2(4) := '000';
1155: l_status po_requisition_headers_all.authorization_status%TYPE;
1156: l_contractor_requisition_flag po_requisition_headers_all.contractor_requisition_flag%TYPE;
1157:
1158: BEGIN
1159: -- get the original req number and status

Line 1156: l_contractor_requisition_flag po_requisition_headers_all.contractor_requisition_flag%TYPE;

1152:
1153: l_origReqNumber po_requisition_headers_all.segment1%TYPE;
1154: l_progress VARCHAR2(4) := '000';
1155: l_status po_requisition_headers_all.authorization_status%TYPE;
1156: l_contractor_requisition_flag po_requisition_headers_all.contractor_requisition_flag%TYPE;
1157:
1158: BEGIN
1159: -- get the original req number and status
1160: SELECT segment1, authorization_status, contractor_requisition_flag

Line 1162: FROM po_requisition_headers_all

1158: BEGIN
1159: -- get the original req number and status
1160: SELECT segment1, authorization_status, contractor_requisition_flag
1161: INTO l_origReqNumber, l_status, l_contractor_requisition_flag
1162: FROM po_requisition_headers_all
1163: WHERE requisition_header_id = p_origHeaderId;
1164:
1165: l_progress := '010';
1166:

Line 1187: UPDATE po_requisition_headers_all

1183:
1184: l_progress := '020';
1185:
1186: -- flip the header id in headers
1187: UPDATE po_requisition_headers_all
1188: SET requisition_header_id = p_origHeaderId,
1189: segment1 = l_origReqNumber,
1190: authorization_status = l_status
1191: WHERE requisition_header_id = p_tempHeaderId;

Line 1341: UPDATE PO_REQUISITION_HEADERS_ALL

1337: IF X_CONTRACTOR_REQ_FLAG = 'Y' AND X_SUPPL_NOTIFIED_FLAG = 'Y' THEN
1338: /*
1339: Set the Contractor Status at Header level to 'ASSIGNED'
1340: */
1341: UPDATE PO_REQUISITION_HEADERS_ALL
1342: SET CONTRACTOR_STATUS = 'ASSIGNED'
1343: WHERE REQUISITION_HEADER_ID = req_Header_Id
1344: AND CONTRACTOR_STATUS = 'PENDING';
1345:

Line 1369: update po_requisition_headers_all

1365: END IF;
1366: --ABORT THE EXISTING WF
1367: WF_Engine.AbortProcess(X_WF_ITEM_TYPE, X_WF_ITEM_KEY);
1368: WF_PURGE.total (X_WF_ITEM_TYPE, X_WF_ITEM_KEY);
1369: update po_requisition_headers_all
1370: set WF_ITEM_TYPE = NULL, WF_ITEM_KEY = NULL
1371: where REQUISITION_HEADER_ID = req_Header_Id;
1372: END IF;
1373: END IF;

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

1392: p_submitter_action VARCHAR2(20) := 'APPROVE';
1393: p_workflow_process VARCHAR2(30);
1394: p_resume_contractor VARCHAR2(1) := 'N';
1395:
1396: p_document_subtype PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE := 'PURCHASE';
1397: X_AUTHORIZATION_STATUS PO_REQUISITION_HEADERS_ALL.authorization_status%TYPE;
1398: X_SUPPL_NOTIFIED_FLAG PO_REQUISITION_HEADERS_ALL.supplier_notified_flag%TYPE;
1399: X_CONTRACTOR_REQ_FLAG PO_REQUISITION_HEADERS_ALL.contractor_requisition_flag%TYPE;
1400: X_WF_ITEM_KEY PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;

Line 1397: X_AUTHORIZATION_STATUS PO_REQUISITION_HEADERS_ALL.authorization_status%TYPE;

1393: p_workflow_process VARCHAR2(30);
1394: p_resume_contractor VARCHAR2(1) := 'N';
1395:
1396: p_document_subtype PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE := 'PURCHASE';
1397: X_AUTHORIZATION_STATUS PO_REQUISITION_HEADERS_ALL.authorization_status%TYPE;
1398: X_SUPPL_NOTIFIED_FLAG PO_REQUISITION_HEADERS_ALL.supplier_notified_flag%TYPE;
1399: X_CONTRACTOR_REQ_FLAG PO_REQUISITION_HEADERS_ALL.contractor_requisition_flag%TYPE;
1400: X_WF_ITEM_KEY PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
1401: X_WF_ITEM_TYPE PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;

Line 1398: X_SUPPL_NOTIFIED_FLAG PO_REQUISITION_HEADERS_ALL.supplier_notified_flag%TYPE;

1394: p_resume_contractor VARCHAR2(1) := 'N';
1395:
1396: p_document_subtype PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE := 'PURCHASE';
1397: X_AUTHORIZATION_STATUS PO_REQUISITION_HEADERS_ALL.authorization_status%TYPE;
1398: X_SUPPL_NOTIFIED_FLAG PO_REQUISITION_HEADERS_ALL.supplier_notified_flag%TYPE;
1399: X_CONTRACTOR_REQ_FLAG PO_REQUISITION_HEADERS_ALL.contractor_requisition_flag%TYPE;
1400: X_WF_ITEM_KEY PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
1401: X_WF_ITEM_TYPE PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
1402: BEGIN

Line 1399: X_CONTRACTOR_REQ_FLAG PO_REQUISITION_HEADERS_ALL.contractor_requisition_flag%TYPE;

1395:
1396: p_document_subtype PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE := 'PURCHASE';
1397: X_AUTHORIZATION_STATUS PO_REQUISITION_HEADERS_ALL.authorization_status%TYPE;
1398: X_SUPPL_NOTIFIED_FLAG PO_REQUISITION_HEADERS_ALL.supplier_notified_flag%TYPE;
1399: X_CONTRACTOR_REQ_FLAG PO_REQUISITION_HEADERS_ALL.contractor_requisition_flag%TYPE;
1400: X_WF_ITEM_KEY PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
1401: X_WF_ITEM_TYPE PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
1402: BEGIN
1403:

Line 1400: X_WF_ITEM_KEY PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;

1396: p_document_subtype PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE := 'PURCHASE';
1397: X_AUTHORIZATION_STATUS PO_REQUISITION_HEADERS_ALL.authorization_status%TYPE;
1398: X_SUPPL_NOTIFIED_FLAG PO_REQUISITION_HEADERS_ALL.supplier_notified_flag%TYPE;
1399: X_CONTRACTOR_REQ_FLAG PO_REQUISITION_HEADERS_ALL.contractor_requisition_flag%TYPE;
1400: X_WF_ITEM_KEY PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
1401: X_WF_ITEM_TYPE PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
1402: BEGIN
1403:
1404: begin

Line 1401: X_WF_ITEM_TYPE PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;

1397: X_AUTHORIZATION_STATUS PO_REQUISITION_HEADERS_ALL.authorization_status%TYPE;
1398: X_SUPPL_NOTIFIED_FLAG PO_REQUISITION_HEADERS_ALL.supplier_notified_flag%TYPE;
1399: X_CONTRACTOR_REQ_FLAG PO_REQUISITION_HEADERS_ALL.contractor_requisition_flag%TYPE;
1400: X_WF_ITEM_KEY PO_REQUISITION_HEADERS_ALL.wf_item_key%TYPE;
1401: X_WF_ITEM_TYPE PO_REQUISITION_HEADERS_ALL.wf_item_type%TYPE;
1402: BEGIN
1403:
1404: begin
1405:

Line 1414: FROM PO_REQUISITION_HEADERS_ALL

1410: type_lookup_code
1411: INTO X_AUTHORIZATION_STATUS, X_SUPPL_NOTIFIED_FLAG,
1412: X_CONTRACTOR_REQ_FLAG, X_WF_ITEM_KEY, X_WF_ITEM_TYPE,
1413: p_document_subtype
1414: FROM PO_REQUISITION_HEADERS_ALL
1415: WHERE REQUISITION_HEADER_ID = req_Header_Id;
1416:
1417: IF (g_po_wf_debug = 'Y') THEN
1418:

Line 2056: l_doc_sub_type PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

2052: l_activity_status VARCHAR2(8);
2053: l_progress VARCHAR2(4) := '000';
2054:
2055: l_pending_action PO_ACTION_HISTORY.ACTION_CODE%TYPE;
2056: l_doc_sub_type PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
2057: l_pending_emp_id PO_ACTION_HISTORY.EMPLOYEE_ID%TYPE;
2058:
2059: -- Logging Infra
2060: l_procedure_name CONSTANT VARCHAR2(30) := 'withdraw_req';

Line 2088: FROM po_requisition_headers_all

2084:
2085: -- abort workflow
2086: SELECT wf_item_type, wf_item_key, type_lookup_code
2087: INTO l_item_type, l_item_key, l_doc_sub_type
2088: FROM po_requisition_headers_all
2089: WHERE requisition_header_id= p_headerId;
2090:
2091: l_progress := '010';
2092:

Line 2094: UPDATE po_requisition_headers_all

2090:
2091: l_progress := '010';
2092:
2093: -- update wf keys and status
2094: UPDATE po_requisition_headers_all
2095: SET wf_item_type = NULL,
2096: wf_item_key = NULL,
2097: authorization_status = 'INCOMPLETE'
2098: WHERE requisition_header_id = p_headerId;

Line 2262: l_active_req_header_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%TYPE;

2258: -- Parameter:
2259: -- p_user_id IN Number: The user id of the user whose active req need to be deactivate.
2260:
2261: PROCEDURE deactivate_active_req(p_user_id IN NUMBER) IS
2262: l_active_req_header_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%TYPE;
2263: l_req_description PO_REQUISITION_HEADERS_ALL.DESCRIPTION%TYPE;
2264: l_authorization_status PO_REQUISITION_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
2265: l_update_header_required BOOLEAN;
2266: l_progress VARCHAR2(4) := '000';

Line 2263: l_req_description PO_REQUISITION_HEADERS_ALL.DESCRIPTION%TYPE;

2259: -- p_user_id IN Number: The user id of the user whose active req need to be deactivate.
2260:
2261: PROCEDURE deactivate_active_req(p_user_id IN NUMBER) IS
2262: l_active_req_header_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%TYPE;
2263: l_req_description PO_REQUISITION_HEADERS_ALL.DESCRIPTION%TYPE;
2264: l_authorization_status PO_REQUISITION_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
2265: l_update_header_required BOOLEAN;
2266: l_progress VARCHAR2(4) := '000';
2267:

Line 2264: l_authorization_status PO_REQUISITION_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;

2260:
2261: PROCEDURE deactivate_active_req(p_user_id IN NUMBER) IS
2262: l_active_req_header_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%TYPE;
2263: l_req_description PO_REQUISITION_HEADERS_ALL.DESCRIPTION%TYPE;
2264: l_authorization_status PO_REQUISITION_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
2265: l_update_header_required BOOLEAN;
2266: l_progress VARCHAR2(4) := '000';
2267:
2268: CURSOR active_req_header_cursor IS

Line 2270: FROM po_requisition_headers_all

2266: l_progress VARCHAR2(4) := '000';
2267:
2268: CURSOR active_req_header_cursor IS
2269: SELECT requisition_header_id, authorization_status, description
2270: FROM po_requisition_headers_all
2271: WHERE last_updated_by = p_user_id
2272: AND active_shopping_cart_flag = 'Y';
2273:
2274: CURSOR item_desc_cursor IS

Line 2318: UPDATE po_requisition_headers_all

2314: END IF;
2315:
2316: IF (l_update_header_required ) THEN
2317: l_progress := '080';
2318: UPDATE po_requisition_headers_all
2319: SET description = l_req_description,
2320: authorization_status = l_authorization_status
2321: WHERE requisition_header_id = l_active_req_header_id;
2322: END IF;

Line 2326: update po_requisition_headers_all

2322: END IF;
2323:
2324: l_progress := '090';
2325:
2326: update po_requisition_headers_all
2327: set active_shopping_cart_flag = null
2328: where last_updated_by = p_user_id
2329: and active_shopping_cart_flag = 'Y';
2330:

Line 2734: UPDATE po_requisition_headers_all

2730: END IF;
2731:
2732: l_progress := '030';
2733:
2734: UPDATE po_requisition_headers_all
2735: SET authorization_status = 'APPROVED'
2736: WHERE requisition_header_id = l_header_id
2737: AND authorization_status = 'PRE-APPROVED';
2738:

Line 2832: UPDATE po_requisition_headers_all

2828: END IF;
2829:
2830: l_progress := '030';
2831:
2832: UPDATE po_requisition_headers_all
2833: SET authorization_status = 'PRE-APPROVED'
2834: WHERE requisition_header_id = l_header_id
2835: AND authorization_status = 'APPROVED';
2836:

Line 2897: from po_requisition_headers

2893:
2894: -- get item_type and item_key
2895: select wf_item_type, wf_item_key
2896: into itype, ikey
2897: from po_requisition_headers
2898: where requisition_header_id = p_headerId;
2899:
2900: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2901: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' p_headerId = ' || p_headerId);

Line 3221: (select requisition_line_id from po_requisition_lines_all prl, po_requisition_headers_all prh where

3217: and pk1_value = p_req_header_id
3218: union
3219: select document_id from fnd_attached_documents where entity_name = 'REQ_LINES'
3220: and pk1_value in
3221: (select requisition_line_id from po_requisition_lines_all prl, po_requisition_headers_all prh where
3222: prl.requisition_header_id = prh.requisition_header_id and prh.requisition_header_id=p_req_header_id));
3223:
3224: l_progress := '030';
3225: