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_PROCESS_PVT dependencies on PO_LINES_INTERFACE

Line 14: ** - Group lines in po_lines_interface

10: ** This package contains logic for AutoCreate Line processing stage
11: ** This API calls the subroutines to handle the derivation, defaulting,
12: ** validation and insert/update of the Lines.
13: **
14: ** - Group lines in po_lines_interface
15: ** - Fetch data from po_lines_interface
16: ** - Derive Line
17: ** - Default Line
18: ** - Validate Line

Line 15: ** - Fetch data from po_lines_interface

11: ** This API calls the subroutines to handle the derivation, defaulting,
12: ** validation and insert/update of the Lines.
13: **
14: ** - Group lines in po_lines_interface
15: ** - Fetch data from po_lines_interface
16: ** - Derive Line
17: ** - Default Line
18: ** - Validate Line
19: ** - Insert into po_lines_draft_all

Line 223: l_clin_num_display po_lines_interface.line_num_display%TYPE;

219: l_api_name VARCHAR2(30) := 'setup_interface_data';
220: l_ship_to_org_id HR_LOCATIONS_ALL.inventory_organization_id%TYPE;
221: l_count_dist NUMBER;
222: -- Added for Linking requisition to Modification project
223: l_clin_num_display po_lines_interface.line_num_display%TYPE;
224: l_slin_num_display po_lines_interface.line_num_display%TYPE;
225: l_slin_count NUMBER :=0;
226: l_is_first_slin VARCHAR2(1) :='Y';
227:

Line 224: l_slin_num_display po_lines_interface.line_num_display%TYPE;

220: l_ship_to_org_id HR_LOCATIONS_ALL.inventory_organization_id%TYPE;
221: l_count_dist NUMBER;
222: -- Added for Linking requisition to Modification project
223: l_clin_num_display po_lines_interface.line_num_display%TYPE;
224: l_slin_num_display po_lines_interface.line_num_display%TYPE;
225: l_slin_count NUMBER :=0;
226: l_is_first_slin VARCHAR2(1) :='Y';
227:
228: CURSOR c_slin

Line 232: FROM po_lines_interface

228: CURSOR c_slin
229: IS
230: SELECT INTERFACE_LINE_ID INTERFACE_LINE_ID,
231: group_line_id group_line_id
232: FROM po_lines_interface
233: WHERE group_line_id IS NOT NULL
234: AND interface_header_id =PO_AUTOCREATE_PARAMS.x_interface_header_id;
235:
236: CURSOR c_clin(p_req_line_id IN NUMBER)

Line 239: FROM po_lines_interface

235:
236: CURSOR c_clin(p_req_line_id IN NUMBER)
237: IS
238: SELECT INTERFACE_LINE_ID
239: FROM po_lines_interface
240: WHERE 1 =1
241: AND interface_header_id=PO_AUTOCREATE_PARAMS.x_interface_header_id
242: AND REQUISITION_LINE_ID=p_req_line_id;
243:

Line 248: FROM po_lines_interface

244: CURSOR c_option
245: IS
246: SELECT INTERFACE_LINE_ID,
247: CLM_BASE_LINE_NUM
248: FROM po_lines_interface
249: WHERE clm_base_line_num IS NOT NULL
250: AND interface_header_id =PO_AUTOCREATE_PARAMS.x_interface_header_id;
251:
252: CURSOR c_base(p_req_line_id IN NUMBER)

Line 255: FROM po_lines_interface

251:
252: CURSOR c_base(p_req_line_id IN NUMBER)
253: IS
254: SELECT INTERFACE_LINE_ID
255: FROM po_lines_interface
256: WHERE 1 =1
257: AND interface_header_id=PO_AUTOCREATE_PARAMS.x_interface_header_id
258: AND REQUISITION_LINE_ID=p_req_line_id;
259:

Line 280: FROM po_lines_interface pli,

276: phi.rate,
277: phi.rate_date,
278: phi.document_subtype,
279: pli.unit_price
280: FROM po_lines_interface pli,
281: po_headers_interface phi,
282: po_line_types plt
283: WHERE phi.interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id
284: AND phi.interface_header_id = pli.interface_header_id

Line 314: UPDATE po_lines_interface pli

310: -- and prl.auction_line_number<>pli.auction_line_number)" in the
311: --following sql.
312: l_progress := '010';
313:
314: UPDATE po_lines_interface pli
315: SET pli.requisition_line_id = NULL
316: WHERE pli.interface_header_id= PO_AUTOCREATE_PARAMS.x_interface_header_id
317: AND EXISTS
318: (SELECT requisition_line_id

Line 339: UPDATE po_lines_interface pli

335: IF g_debug_stmt THEN
336: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Before the update for withdrawn reqs');
337: END IF;
338:
339: UPDATE po_lines_interface pli
340: SET pli.requisition_line_id = NULL
341: WHERE pli.interface_header_id= PO_AUTOCREATE_PARAMS.x_interface_header_id
342: AND NOT EXISTS
343: (SELECT requisition_line_id

Line 365: UPDATE po_lines_interface pli2

361: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
362: p_message => 'Before setting priced lines in interface tables');
363: END IF;
364:
365: UPDATE po_lines_interface pli2
366: SET
367: (
368: line_num,
369: item_id,

Line 498: FROM po_lines_interface pli,

494: NVL(pli.clm_funded_flag, prl.clm_funded_flag) ,
495: NVL(pli.clm_base_line_num,prl.clm_base_line_num) ,
496: NVL(pli.contract_type,prl.contract_type) ,
497: NVL(pli.cost_constraint,prl.cost_constraint)
498: FROM po_lines_interface pli,
499: po_headers_interface phi,
500: po_requisition_lines_all prl,
501: po_line_types plt
502: WHERE pli.interface_line_id = pli2.interface_line_id

Line 519: UPDATE po_lines_interface pli2

515: p_message => 'Before setting Info lines in interface tables');
516: END IF;
517:
518: /* For Info-Lines */
519: UPDATE po_lines_interface pli2
520: SET
521: (
522: line_num,
523: item_id,

Line 643: FROM po_lines_interface pli,

639: NVL(pli.CLM_OPTION_TO_DATE, prl.CLM_OPTION_TO_DATE) ,
640: NVL(pli.CLM_FUNDED_FLAG, prl.CLM_FUNDED_FLAG) ,
641: NVL(pli.CLM_BASE_LINE_NUM,prl.CLM_BASE_LINE_NUM)
642: --
643: FROM po_lines_interface pli,
644: po_headers_interface phi,
645: po_requisition_lines_all prl --
646: WHERE pli.interface_line_id = pli2.interface_line_id
647: AND pli.interface_header_id = phi.interface_header_id

Line 687: UPDATE po_lines_interface

683: FETCH c_clin INTO l_parent_line_id;
684: CLOSE c_clin;
685:
686: l_progress :='062';
687: UPDATE po_lines_interface
688: SET group_line_id = l_parent_line_id
689: WHERE INTERFACE_LINE_ID = crec.INTERFACE_LINE_ID
690: AND INTERFACE_HEADER_ID = PO_AUTOCREATE_PARAMS.x_interface_header_id;
691: -- Added for Linking requisition to modification project

Line 703: FROM po_lines_interface

699: WHERE PO_HEADER_ID = po_autocreate_params.g_po_header_id
700: AND draft_id = po_autocreate_params.g_draft_id
701: AND LINE_NUM =
702: (SELECT line_num
703: FROM po_lines_interface
704: WHERE interface_line_id = l_parent_line_id
705: AND INTERFACE_HEADER_ID = PO_AUTOCREATE_PARAMS.x_interface_header_id
706: );
707:

Line 725: UPDATE po_lines_interface

721: p_message => 'Setting line_num_display for slins of ' || l_clin_num_display || ' for slin ' || l_slin_num_display);
722: END IF;
723:
724: l_progress :='066';
725: UPDATE po_lines_interface
726: SET line_num_display = l_slin_num_display
727: WHERE INTERFACE_LINE_ID = crec.INTERFACE_LINE_ID
728: AND INTERFACE_HEADER_ID = PO_AUTOCREATE_PARAMS.x_interface_header_id
729: AND clm_info_flag ='Y';

Line 752: UPDATE po_lines_interface

748: FETCH c_base INTO l_parent_line_id;
749: CLOSE c_base;
750:
751: l_progress :='071';
752: UPDATE po_lines_interface
753: SET CLM_BASE_LINE_NUM = l_parent_line_id
754: WHERE INTERFACE_LINE_ID = crec.INTERFACE_LINE_ID
755: AND INTERFACE_HEADER_ID = PO_AUTOCREATE_PARAMS.x_interface_header_id;
756:

Line 882: po_lines_interface pli,

878: prd.quantity_funded, --
879: prd.amount_funded --
880: FROM po_requisition_lines_all prl, --
881: po_req_distributions_all prd, --
882: po_lines_interface pli,
883: po_headers_interface phi
884: WHERE prd.requisition_line_id = prl.requisition_line_id
885: AND prl.requisition_line_id = pli.requisition_line_id
886: AND pli.interface_header_id = phi.interface_header_id

Line 936: po_lines_interface pli --option

932: prl.destination_organization_id,
933: prl.destination_subinventory,
934: prl.destination_context
935: FROM po_requisition_lines_all prl,
936: po_lines_interface pli --option
937: WHERE pli.interface_header_id = po_autocreate_params.x_interface_header_id
938: AND (( pli.clm_option_indicator = 'O' AND NVL(pli.clm_exercised_flag,'N') = 'N') -- Bug 9960752
939: OR prl.fund_source_not_known = 'Y' )
940: --CLM Phase 2 Changes : PR Lines with no distributions should be handled like

Line 971: FROM po_lines_interface pi

967:
968: UPDATE po_distributions_interface pdi
969: SET group_line_id =
970: (SELECT interface_line_id
971: FROM po_lines_interface pi
972: WHERE pi.requisition_line_id = pdi.group_line_id
973: AND pi.interface_header_id = po_autocreate_params.x_interface_header_id
974: )
975: WHERE pdi.interface_header_id = po_autocreate_params.x_interface_header_id;

Line 1579: FROM po_lines_interface intf_lines,

1575: p_lines.clm_pop_duration_tbl,
1576: p_lines.clm_delivery_period_uom_tbl,
1577: p_lines.clm_promise_period_uom_tbl,
1578: p_lines.clm_pop_duration_uom_tbl
1579: FROM po_lines_interface intf_lines,
1580: po_headers_interface intf_headers,
1581: po_headers_draft_all draft_headers
1582: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1583: AND intf_headers.draft_id = draft_headers.draft_id

Line 1670: l_quantity_in_ga_uom PO_LINES_INTERFACE.quantity%TYPE;

1666: l_manual_price_change_flag po_lines_all.manual_price_change_flag%TYPE := NULL;
1667: l_from_type_lookup_code PO_HEADERS.type_lookup_code%type;
1668: l_uom_convert VARCHAR2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
1669: l_ga_uom PO_LINES.unit_meas_lookup_code%TYPE;
1670: l_quantity_in_ga_uom PO_LINES_INTERFACE.quantity%TYPE;
1671: l_conversion_rate NUMBER :=1;
1672: l_outsourced_assembly po_line_locations_all.outsourced_assembly%type;
1673: l_retainage_rate PO_VENDOR_SITES_ALL.retainage_rate%type;
1674: --

Line 1754: FROM po_lines_interface

1750: CURSOR c_price_break(p_line_num NUMBER,p_intf_line_id NUMBER)
1751: IS
1752: SELECT interface_line_id,
1753: need_by_date
1754: FROM po_lines_interface
1755: WHERE interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id
1756: AND line_num = p_line_num
1757: AND shipment_num IS NOT NULL
1758: AND interface_line_id <> p_intf_line_id

Line 3401: UPDATE po_lines_interface

3397:
3398: /*CLM Phase-2 Autocreate grouping*/
3399: --Stamping back the po_line_id back to the interface table
3400: FORALL i IN 1 .. p_lines.intf_line_id_tbl.Count
3401: UPDATE po_lines_interface
3402: SET po_line_id = p_lines.po_line_id_tbl(i)
3403: WHERE
3404: interface_line_id = p_lines.intf_line_id_tbl(i);
3405:

Line 4927: FROM po_lines_interface pli,pon_award_allocations paa

4923: TFU*(di/d1+d2)*/
4924:
4925: BEGIN
4926: SELECT PLI.auction_header_id INTO l_auction_header_id
4927: FROM po_lines_interface pli,pon_award_allocations paa
4928: WHERE PLI.interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id
4929: AND pli.auction_header_id = paa.auction_header_id
4930: AND paa.is_linked_pr_line_yn = 'Y'
4931: AND ROWNUM <2;

Line 5042: FROM po_lines_interface pli,

5038: Decode(plb.matching_basis, 'QUANTITY',(paa.allocated_funds * (prd.funds_remaining/ req_dist_amt.tot_funds_remaining))/ pli.unit_price,
5039: null),--quantity_funded,
5040: Decode(plb.matching_basis, 'AMOUNT',(paa.allocated_funds * (prd.funds_remaining/ req_dist_amt.tot_funds_remaining)),
5041: NULL ) --amount_funded
5042: FROM po_lines_interface pli,
5043: po_headers_interface phi,
5044: pon_award_allocations paa,
5045: po_clmreq_dist_details_v prd,
5046: (SELECT requisition_line_id, Sum(prd.funds_remaining) AS tot_funds_remaining