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.PO_RCO_VALIDATION_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 398: l_req_num po_requisition_headers_all.segment1%TYPE;

394: l_old_quantity NUMBER;
395: l_new_quantity NUMBER;
396: l_req_user_id NUMBER;
397: l_req_header_id NUMBER;
398: l_req_num po_requisition_headers_all.segment1%TYPE;
399: l_requester_id NUMBER;
400: l_matching_basis po_requisition_lines_all.matching_basis%TYPE;
401: l_old_amount NUMBER;
402: l_new_amount NUMBER;

Line 1537: FROM po_requisition_headers_all

1533: -- validate_change_request API set's org id context
1534: -- to the PO document's org, we need to set it back
1535: SELECT org_id
1536: INTO l_req_org_id
1537: FROM po_requisition_headers_all
1538: WHERE requisition_header_id = p_req_hdr_id;
1539:
1540: -- set org context back to req's org
1541: po_moac_utils_pvt.set_org_context(l_req_org_id) ; --

Line 2102: l_req_num po_requisition_headers_all.segment1%TYPE;

2098: l_non_recoverable_tax NUMBER;
2099: l_po_request_level po_change_requests.request_level%TYPE;
2100: l_req_request_level po_change_requests.request_level%TYPE;
2101: l_req_header_id NUMBER;
2102: l_req_num po_requisition_headers_all.segment1%TYPE;
2103: l_req_line_number NUMBER;
2104: l_req_dist_number NUMBER;
2105: l_new_functional_price NUMBER;
2106: l_old_curr_unit_price NUMBER;

Line 2211: po_requisition_headers_all prha,

2207: po_lines_all pla,
2208: po_line_locations_all plla,
2209: po_req_distributions_all prda,
2210: po_requisition_lines_all prla,
2211: po_requisition_headers_all prha,
2212: po_distributions_all pda
2213: WHERE
2214: prda.distribution_id = req_change_record_tbl(req_index).document_distribution_id
2215: AND prda.requisition_line_id = prla.requisition_line_id

Line 2291: po_requisition_headers_all prha

2287: po_headers_all pha,
2288: po_lines_all pla,
2289: po_line_locations_all plla,
2290: po_requisition_lines_all prla,
2291: po_requisition_headers_all prha
2292: WHERE
2293: prla.requisition_line_id = req_change_record_tbl(req_index).document_line_id
2294: AND prla.line_location_id = plla.line_location_id
2295: AND plla.po_line_id = pla.po_line_id

Line 2383: po_requisition_headers_all prha

2379: po_line_locations_all plla,
2380: po_distributions_all pda,
2381: po_req_distributions_all prda,
2382: po_requisition_lines_all prla,
2383: po_requisition_headers_all prha
2384: WHERE
2385: prda.distribution_id = req_change_record_tbl(req_index).document_distribution_id
2386: AND prda.distribution_id = pda.req_distribution_id
2387: AND pda.line_location_id = plla.line_location_id

Line 2464: po_requisition_headers_all prha

2460: po_releases_all pra,
2461: po_lines_all pla,
2462: po_line_locations_all plla,
2463: po_requisition_lines_all prla,
2464: po_requisition_headers_all prha
2465: WHERE
2466: prla.requisition_line_id = req_change_record_tbl(req_index).document_line_id
2467: AND prla.line_location_id = plla.line_location_id
2468: AND plla.po_release_id = pra.po_release_id

Line 2738: po_requisition_headers_all prha

2734: l_transferred_to_oe_flag,
2735: l_cancelled
2736: FROM
2737: po_requisition_lines_all prla,
2738: po_requisition_headers_all prha
2739: WHERE
2740: prla.requisition_line_id = p_req_line_id AND
2741: prla.requisition_header_id = prha.requisition_header_id;
2742:

Line 2796: po_requisition_headers_all prha

2792: l_req_change_pending_flag,
2793: l_modified_by_agent
2794: FROM
2795: po_requisition_lines_all prla,
2796: po_requisition_headers_all prha
2797: WHERE
2798: prla.requisition_line_id = p_req_line_id AND
2799: prla.requisition_header_id = prha.requisition_header_id;
2800: END IF;

Line 3267: po_requisition_headers_all prha

3263: l_destination_type_code,
3264: l_transferred_to_oe_flag
3265: FROM
3266: po_requisition_lines_all prla,
3267: po_requisition_headers_all prha
3268: WHERE
3269: prla.requisition_line_id = p_req_line_id AND
3270: prla.requisition_header_id = prha.requisition_header_id;
3271:

Line 3848: l_req_num po_requisition_headers_all.segment1%TYPE;

3844: p_grp_id IN NUMBER)
3845: IS
3846: l_api_name VARCHAR2(50) := 'Save_ReqCancel';
3847: l_chn_req_id NUMBER;
3848: l_req_num po_requisition_headers_all.segment1%TYPE;
3849: l_req_line_num NUMBER;
3850: l_req_user_id NUMBER;
3851: l_line_loc_id NUMBER;
3852: l_po_header_id NUMBER;

Line 3900: po_requisition_headers_all prha,

3896: l_req_quantity,
3897: l_req_date,
3898: l_req_currency_price
3899: FROM
3900: po_requisition_headers_all prha,
3901: po_requisition_lines_all prla
3902: WHERE prla.requisition_line_id = p_cancel_table.req_line_id(i)
3903: AND prla.requisition_header_id = prha.requisition_header_id;
3904:

Line 4039: l_req_num po_requisition_headers_all.segment1%TYPE;

4035: --l_FC_Tbl po_fcin_type;
4036: l_req_dist_id NUMBER;
4037: l_req_line_id NUMBER;
4038: l_req_hdr_id NUMBER;
4039: l_req_num po_requisition_headers_all.segment1%TYPE;
4040: l_po_num po_headers_all.segment1%TYPE;
4041: l_header_id NUMBER;
4042: l_release_id NUMBER;
4043: l_line_id NUMBER;

Line 4148: po_requisition_headers_all prha

4144: FROM
4145: po_req_distributions_all prda,
4146: po_requisition_lines_all prla,
4147: po_change_requests pcr,
4148: po_requisition_headers_all prha
4149: WHERE
4150: prha.requisition_header_id = prla.requisition_header_id AND
4151: prla.requisition_line_id = prda.requisition_line_id AND
4152: pcr.document_line_id = prla.requisition_line_id AND

Line 4865: po_requisition_headers_all prh --

4861: INTO
4862: l_req_line_id,
4863: l_req_header_id
4864: FROM po_requisition_lines prl,
4865: po_requisition_headers_all prh --
4866: WHERE prl.requisition_line_id = p_req_line_id AND
4867: prh.requisition_header_id = prl.requisition_header_id AND
4868: (NOT EXISTS
4869: (SELECT 'so line is not cancelled'

Line 4872: po_requisition_headers_all PORH, --

4868: (NOT EXISTS
4869: (SELECT 'so line is not cancelled'
4870: FROM
4871: po_requisition_lines PORL,
4872: po_requisition_headers_all PORH, --
4873: po_system_parameters POSP
4874: WHERE
4875: PORL.requisition_line_id = p_req_line_id AND
4876: PORL.requisition_header_id = PORH.requisition_header_id AND

Line 5024: po_requisition_headers_all prh --

5020: INTO
5021: l_req_line_id,
5022: l_req_header_id
5023: FROM po_requisition_lines prl,
5024: po_requisition_headers_all prh --
5025: WHERE prl.requisition_line_id = p_req_line_id AND
5026: prh.requisition_header_id = prl.requisition_header_id ;
5027:
5028: l_progress := '001';

Line 5209: l_req_num po_requisition_headers_all.segment1%TYPE;

5205: p_grp_id IN NUMBER)
5206: IS
5207: l_api_name VARCHAR2(50) := 'Save_IReqCancel';
5208: l_chn_req_id NUMBER;
5209: l_req_num po_requisition_headers_all.segment1%TYPE;
5210: l_req_line_num NUMBER;
5211: l_req_user_id NUMBER;
5212: l_line_loc_id NUMBER;
5213: l_po_header_id NUMBER;

Line 5277: po_requisition_headers_all prha,

5273: l_req_price,
5274: l_req_quantity,
5275: l_req_date
5276: FROM
5277: po_requisition_headers_all prha,
5278: po_requisition_lines_all prla
5279: WHERE prla.requisition_line_id = p_cancel_table.req_line_id(i)
5280: AND prla.requisition_header_id = prha.requisition_header_id;
5281:

Line 5510: po_requisition_headers_all prha,

5506: l_old_amount,
5507: l_preparer_id
5508: FROM
5509: po_requisition_lines_all prla,
5510: po_requisition_headers_all prha,
5511: po_req_distributions_all prda
5512: WHERE
5513: prha.requisition_header_id = p_req_hdr_id
5514: AND prha.requisition_header_id = prla.requisition_header_id

Line 5805: FROM po_requisition_headers_all

5801: x_preparer_display_name varchar2(360);
5802: BEGIN
5803:
5804: SELECT preparer_id into l_preparer_id
5805: FROM po_requisition_headers_all
5806: WHERE requisition_header_id = p_req_hdr_id;
5807:
5808: WF_DIRECTORY.GetUserName( 'PER',
5809: l_preparer_id,

Line 6176: l_req_num po_requisition_headers_all.segment1%TYPE;

6172:
6173: l_req_dist_id NUMBER;
6174: l_req_line_id NUMBER;
6175: l_req_hdr_id NUMBER;
6176: l_req_num po_requisition_headers_all.segment1%TYPE;
6177: l_budget_account_id NUMBER;
6178: l_gl_date DATE;
6179: l_old_quantity NUMBER;
6180: l_old_tax NUMBER;

Line 6272: po_requisition_headers_all prha

6268: FROM
6269: po_req_distributions_all prda,
6270: po_requisition_lines_all prla,
6271: po_change_requests pcr,
6272: po_requisition_headers_all prha
6273: WHERE
6274: prha.requisition_header_id = prla.requisition_header_id AND
6275: prla.requisition_line_id = prda.requisition_line_id AND
6276: pcr.document_line_id = prla.requisition_line_id AND

Line 6759: , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE

6755:
6756: /*Procedure Call_Process_Order_for_IReq -- Specification definition
6757: ( P_API_Version IN NUMBER
6758: , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE
6759: , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE
6760: , P_Mode IN VARCHAR2
6761: , P_Cancel_ISO IN BOOLEAN DEFAULT FALSE
6762: , P_Cancel_ISO_lines IN BOOLEAN DEFAULT FALSE
6763: , P_New_Request_Date IN DATE DEFAULT NULL