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_AUTO_LINE_LOC_PROCESS_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 1065: l_req_tax_code_id PO_REQUISITION_LINES_ALL.tax_code_id%TYPE;

1061: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
1062: l_payitem_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;
1063: l_payitem_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
1064: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;
1065: l_req_tax_code_id PO_REQUISITION_LINES_ALL.tax_code_id%TYPE;
1066: l_req_tax_user_override_flag PO_REQUISITION_LINES_ALL.tax_user_override_flag%TYPE;
1067: l_req_tax_status_indicator PO_REQUISITION_LINES_ALL.tax_status_indicator%TYPE;
1068: l_tax_name AP_TAX_CODES.name%TYPE;
1069: l_tax_code_id AP_TAX_CODES.tax_id%TYPE;

Line 1066: l_req_tax_user_override_flag PO_REQUISITION_LINES_ALL.tax_user_override_flag%TYPE;

1062: l_payitem_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;
1063: l_payitem_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
1064: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;
1065: l_req_tax_code_id PO_REQUISITION_LINES_ALL.tax_code_id%TYPE;
1066: l_req_tax_user_override_flag PO_REQUISITION_LINES_ALL.tax_user_override_flag%TYPE;
1067: l_req_tax_status_indicator PO_REQUISITION_LINES_ALL.tax_status_indicator%TYPE;
1068: l_tax_name AP_TAX_CODES.name%TYPE;
1069: l_tax_code_id AP_TAX_CODES.tax_id%TYPE;
1070: l_tax_type AP_TAX_CODES.tax_type%TYPE;

Line 1067: l_req_tax_status_indicator PO_REQUISITION_LINES_ALL.tax_status_indicator%TYPE;

1063: l_payitem_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
1064: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;
1065: l_req_tax_code_id PO_REQUISITION_LINES_ALL.tax_code_id%TYPE;
1066: l_req_tax_user_override_flag PO_REQUISITION_LINES_ALL.tax_user_override_flag%TYPE;
1067: l_req_tax_status_indicator PO_REQUISITION_LINES_ALL.tax_status_indicator%TYPE;
1068: l_tax_name AP_TAX_CODES.name%TYPE;
1069: l_tax_code_id AP_TAX_CODES.tax_id%TYPE;
1070: l_tax_type AP_TAX_CODES.tax_type%TYPE;
1071: l_tax_description AP_TAX_CODES.description%TYPE;

Line 1404: FROM po_requisition_lines_all prl

1400: INTO l_req_tax_code_id ,
1401: l_req_tax_user_override_flag ,
1402: l_req_tax_status_indicator ,
1403: g_line_requesting_ou_id
1404: FROM po_requisition_lines_all prl
1405: WHERE prl.requisition_line_id = p_lines.requisition_line_id_tbl(i);
1406:
1407: l_tax_code_id := l_req_tax_code_id;
1408: ELSE

Line 2226: PO_REQUISITION_LINES_ALL

2222: Name: update_req_lines
2223: Pre-reqs:
2224: PO shipment has been created
2225: Modifies:
2226: PO_REQUISITION_LINES_ALL
2227: Locks:
2228: None
2229: Function:
2230: Updates the Requistion lines' Line Location Id, Reqs in Pool flag for autocreated lines.

Line 2248: TYPE number_table IS TABLE OF po_requisition_lines_all.requisition_line_id%TYPE index by binary_integer;

2244: l_progress VARCHAR2(3) := '000';
2245: l_api_name VARCHAR2(30) := 'update_req_lines';
2246: l_bid_number NUMBER;
2247:
2248: TYPE number_table IS TABLE OF po_requisition_lines_all.requisition_line_id%TYPE index by binary_integer;
2249:
2250: l_req_line_ids_tbl number_table;
2251: l_return_status VARCHAR2(1);
2252: l_error_msg VARCHAR2(1000);

Line 2273: UPDATE po_requisition_lines_all l

2269: LOOP
2270: /* Bug : 13695551 : From Sourcing, when one req line is awarded to multiple suppliers, populate
2271: * po_line_id, line_location_id to -1.
2272: */
2273: UPDATE po_requisition_lines_all l
2274: SET
2275: -- po_line_id = p_lines.po_line_id_tbl(i)),
2276: po_line_id = Decode(PO_AUTOCREATE_PARAMS.g_interface_source_code,'SOURCING',
2277: Decode(Nvl(po_line_id, -999),-999, p_lines.po_line_id_tbl(i),-1), p_lines.po_line_id_tbl(i)),

Line 2306: UPDATE po_requisition_lines_all

2302: -- added for Linking requisition to modification project
2303: IF (po_autocreate_params.g_is_clm_po ='Y' AND po_autocreate_params.g_process_code = 'ADD_FUNDS') THEN
2304:
2305: l_progress := '020';
2306: UPDATE po_requisition_lines_all
2307: SET po_draft_id = po_autocreate_params.g_draft_id,
2308: LINKED_TO_FUND = 'Y'
2309: WHERE requisition_line_id = p_lines.requisition_line_id_tbl(i);
2310:

Line 2325: --Update the po_requisition_lines_all for all the linked prs when creating the PO from Sourcing

2321:
2322: END LOOP;
2323:
2324: --Line Type and Structure Changes
2325: --Update the po_requisition_lines_all for all the linked prs when creating the PO from Sourcing
2326:
2327: l_progress := '030';
2328:
2329: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 2335: UPDATE po_requisition_lines_all prl

2331: p_message => 'l_bid_number: ' || l_bid_number);
2332: END IF;
2333:
2334:
2335: UPDATE po_requisition_lines_all prl
2336: SET PO_LINE_ID = -1,
2337: LINE_LOCATION_ID = -1,
2338: PO_DRAFT_ID = NULL,
2339: LINKED_PO_COUNT = Nvl(LINKED_PO_COUNT,0) + (SELECT Count(*) FROM pon_award_allocations paa1

Line 2363: FROM po_requisition_lines_all

2359: IF l_count > 0 THEN
2360: FOR i in 1..l_req_line_ids_tbl.COUNT LOOP
2361:
2362: SELECT requisition_header_id INTO l_requisition_header_id
2363: FROM po_requisition_lines_all
2364: WHERE requisition_line_id = l_req_line_ids_tbl(i);
2365:
2366: l_progress := '040';
2367:

Line 2373: UPDATE po_requisition_lines_all

2369: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
2370: p_message => 'Before update statment l_count: row i is : ' || i || ' header id : ' || l_requisition_header_id);
2371: END IF;
2372:
2373: UPDATE po_requisition_lines_all
2374: SET reqs_in_pool_flag = null,
2375: last_update_date = SYSDATE,
2376: last_updated_by = FND_GLOBAL.USER_ID,
2377: last_update_login = FND_GLOBAL.LOGIN_ID

Line 2383: OR (requisition_line_id IN (SELECT group_line_id from po_requisition_lines_all

2379: WHERE requisition_header_id = l_requisition_header_id
2380: AND Nvl(reqs_in_pool_flag, 'N') = 'Y'
2381: AND ((requisition_line_id = l_req_line_ids_tbl(i))
2382: OR (group_line_id = l_req_line_ids_tbl(i))
2383: OR (requisition_line_id IN (SELECT group_line_id from po_requisition_lines_all
2384: WHERE requisition_line_id = l_req_line_ids_tbl(i)
2385: AND requisition_header_id = l_requisition_header_id))
2386: OR (group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2387: WHERE requisition_line_id = l_req_line_ids_tbl(i)

Line 2386: OR (group_line_id IN (SELECT group_line_id from po_requisition_lines_all

2382: OR (group_line_id = l_req_line_ids_tbl(i))
2383: OR (requisition_line_id IN (SELECT group_line_id from po_requisition_lines_all
2384: WHERE requisition_line_id = l_req_line_ids_tbl(i)
2385: AND requisition_header_id = l_requisition_header_id))
2386: OR (group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2387: WHERE requisition_line_id = l_req_line_ids_tbl(i)
2388: AND requisition_header_id = l_requisition_header_id))
2389: OR (clm_base_line_num = l_req_line_ids_tbl(i))
2390: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all

Line 2390: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all

2386: OR (group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2387: WHERE requisition_line_id = l_req_line_ids_tbl(i)
2388: AND requisition_header_id = l_requisition_header_id))
2389: OR (clm_base_line_num = l_req_line_ids_tbl(i))
2390: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all
2391: WHERE requisition_line_id = l_req_line_ids_tbl(i)
2392: AND requisition_header_id = l_requisition_header_id))
2393: OR (group_line_id IN (SELECT requisition_line_id FROM po_requisition_lines_all
2394: WHERE clm_base_line_num = l_req_line_ids_tbl(i)

Line 2393: OR (group_line_id IN (SELECT requisition_line_id FROM po_requisition_lines_all

2389: OR (clm_base_line_num = l_req_line_ids_tbl(i))
2390: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all
2391: WHERE requisition_line_id = l_req_line_ids_tbl(i)
2392: AND requisition_header_id = l_requisition_header_id))
2393: OR (group_line_id IN (SELECT requisition_line_id FROM po_requisition_lines_all
2394: WHERE clm_base_line_num = l_req_line_ids_tbl(i)
2395: AND requisition_header_id = l_requisition_header_id))
2396: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2397: WHERE clm_base_line_num = l_req_line_ids_tbl(i)

Line 2396: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

2392: AND requisition_header_id = l_requisition_header_id))
2393: OR (group_line_id IN (SELECT requisition_line_id FROM po_requisition_lines_all
2394: WHERE clm_base_line_num = l_req_line_ids_tbl(i)
2395: AND requisition_header_id = l_requisition_header_id))
2396: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2397: WHERE clm_base_line_num = l_req_line_ids_tbl(i)
2398: AND requisition_header_id = l_requisition_header_id))
2399: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2400: WHERE clm_base_line_num = l_req_line_ids_tbl(i)

Line 2399: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

2395: AND requisition_header_id = l_requisition_header_id))
2396: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2397: WHERE clm_base_line_num = l_req_line_ids_tbl(i)
2398: AND requisition_header_id = l_requisition_header_id))
2399: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2400: WHERE clm_base_line_num = l_req_line_ids_tbl(i)
2401: AND requisition_header_id = l_requisition_header_id))
2402: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2403: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

Line 2402: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all

2398: AND requisition_header_id = l_requisition_header_id))
2399: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2400: WHERE clm_base_line_num = l_req_line_ids_tbl(i)
2401: AND requisition_header_id = l_requisition_header_id))
2402: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2403: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2404: WHERE requisition_line_id = l_req_line_ids_tbl(i)
2405: AND requisition_header_id = l_requisition_header_id )
2406: AND requisition_header_id = l_requisition_header_id))

Line 2403: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

2399: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2400: WHERE clm_base_line_num = l_req_line_ids_tbl(i)
2401: AND requisition_header_id = l_requisition_header_id))
2402: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2403: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2404: WHERE requisition_line_id = l_req_line_ids_tbl(i)
2405: AND requisition_header_id = l_requisition_header_id )
2406: AND requisition_header_id = l_requisition_header_id))
2407: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

Line 2407: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

2403: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2404: WHERE requisition_line_id = l_req_line_ids_tbl(i)
2405: AND requisition_header_id = l_requisition_header_id )
2406: AND requisition_header_id = l_requisition_header_id))
2407: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2408: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2409: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2410: WHERE requisition_line_id = l_req_line_ids_tbl(i)
2411: AND requisition_header_id = l_requisition_header_id)

Line 2408: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all

2404: WHERE requisition_line_id = l_req_line_ids_tbl(i)
2405: AND requisition_header_id = l_requisition_header_id )
2406: AND requisition_header_id = l_requisition_header_id))
2407: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2408: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2409: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2410: WHERE requisition_line_id = l_req_line_ids_tbl(i)
2411: AND requisition_header_id = l_requisition_header_id)
2412: AND requisition_header_id = l_requisition_header_id)

Line 2409: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

2405: AND requisition_header_id = l_requisition_header_id )
2406: AND requisition_header_id = l_requisition_header_id))
2407: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2408: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2409: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2410: WHERE requisition_line_id = l_req_line_ids_tbl(i)
2411: AND requisition_header_id = l_requisition_header_id)
2412: AND requisition_header_id = l_requisition_header_id)
2413: AND requisition_header_id = l_requisition_header_id))

Line 2414: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

2410: WHERE requisition_line_id = l_req_line_ids_tbl(i)
2411: AND requisition_header_id = l_requisition_header_id)
2412: AND requisition_header_id = l_requisition_header_id)
2413: AND requisition_header_id = l_requisition_header_id))
2414: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2415: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2416: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2417: WHERE requisition_line_id = l_req_line_ids_tbl(i)
2418: AND requisition_header_id = l_requisition_header_id)

Line 2415: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all

2411: AND requisition_header_id = l_requisition_header_id)
2412: AND requisition_header_id = l_requisition_header_id)
2413: AND requisition_header_id = l_requisition_header_id))
2414: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2415: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2416: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2417: WHERE requisition_line_id = l_req_line_ids_tbl(i)
2418: AND requisition_header_id = l_requisition_header_id)
2419: AND requisition_header_id = l_requisition_header_id)

Line 2416: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

2412: AND requisition_header_id = l_requisition_header_id)
2413: AND requisition_header_id = l_requisition_header_id))
2414: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2415: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2416: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2417: WHERE requisition_line_id = l_req_line_ids_tbl(i)
2418: AND requisition_header_id = l_requisition_header_id)
2419: AND requisition_header_id = l_requisition_header_id)
2420: AND requisition_header_id = l_requisition_header_id)));