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_PDOI_PREPROC_PVT dependencies on PO_LINE_LOCATIONS_INTERFACE

Line 502: UPDATE po_line_locations_interface

498: END IF;
499:
500: d_position := 50;
501: FORALL i IN 1..l_intf_line_id_tbl.COUNT
502: UPDATE po_line_locations_interface
503: SET processing_id = PO_PDOI_PARAMS.g_processing_id
504: WHERE interface_line_id = l_intf_line_id_tbl(i);
505:
506: IF (PO_LOG.d_stmt) THEN

Line 1995: FROM po_line_locations_interface PLLI,

1991: -- lines interface records.
1992: CURSOR c_line_loc_intf IS
1993: SELECT PLLI.interface_line_id,
1994: PLLI.interface_line_location_id
1995: FROM po_line_locations_interface PLLI,
1996: po_lines_interface PLI
1997: WHERE PLLI.processing_id = PO_PDOI_PARAMS.g_processing_id
1998: AND PLLI.interface_line_id = PLI.interface_line_id
1999: AND NVL(PLI.line_loc_populated_flag, 'N') = 'N';

Line 2037: INSERT INTO po_line_locations_interface

2033: END IF;
2034:
2035: FOR i IN 1..l_rowid_tbl.COUNT LOOP -- PDOI for Complex PO Project
2036: d_position := 20;
2037: INSERT INTO po_line_locations_interface
2038: (
2039: interface_line_location_id,
2040: interface_header_id,
2041: interface_line_id,

Line 2118: SELECT po_line_locations_interface_s.nextval,

2114: tax_code_id,
2115: tax_name,
2116: qty_rcv_tolerance
2117: )
2118: SELECT po_line_locations_interface_s.nextval,
2119: PLI.interface_header_id,
2120: PLI.interface_line_id,
2121: PLI.processing_id,
2122: PLI.process_code,

Line 2207: po_line_locations_interface_s.currval

2203: WHERE PH.po_header_id = PHI.po_header_id)),1),
2204: -- In 'UPDATE' mode, the style_id corresponding to the base PO
2205: -- needs to be considered.
2206: PLI.interface_line_id,
2207: po_line_locations_interface_s.currval
2208: INTO l_style_id, l_interface_line_id, l_interface_line_location_id
2209: FROM po_headers_interface PHI,
2210: po_lines_interface PLI
2211: WHERE PLI.rowid = l_rowid_tbl(i)

Line 2228: UPDATE po_line_locations_interface

2224: IF l_is_complex_work_style THEN
2225:
2226: d_position := 30;
2227:
2228: UPDATE po_line_locations_interface
2229: SET payment_type = DECODE(quantity,NULL,'LUMPSUM','MILESTONE'),
2230: price_override = DECODE(quantity,NULL,NULL,0)
2231: WHERE interface_line_location_id = l_interface_line_location_id;
2232:

Line 2235: UPDATE po_line_locations_interface

2231: WHERE interface_line_location_id = l_interface_line_location_id;
2232:
2233: IF l_is_financing_style THEN
2234:
2235: UPDATE po_line_locations_interface
2236: SET shipment_type = 'PREPAYMENT',
2237: shipment_num = DECODE(shipment_num,NULL,1,shipment_num)
2238: WHERE interface_line_location_id = l_interface_line_location_id;
2239:

Line 2506: INSERT INTO po_line_locations_interface

2502: IF (PO_LOG.d_proc) THEN
2503: PO_LOG.proc_begin (d_module);
2504: END IF;
2505:
2506: INSERT INTO po_line_locations_interface
2507: (
2508: interface_line_location_id,
2509: interface_header_id,
2510: interface_line_id,

Line 2590: SELECT po_line_locations_interface_s.nextval,

2586: tax_code_id,
2587: tax_name,
2588: qty_rcv_tolerance
2589: )
2590: SELECT po_line_locations_interface_s.nextval,
2591: PLI.interface_header_id,
2592: PLI.interface_line_id,
2593: PLI.processing_id,
2594: PLI.process_code,

Line 2676: SELECT po_line_locations_interface_s.CURRVAL

2672: WHERE PLI.interface_line_id = p_interface_line_id
2673: AND Nvl(PLI.advance_amount,0) > 0;
2674:
2675: IF (SQL%ROWCOUNT > 0) THEN
2676: SELECT po_line_locations_interface_s.CURRVAL
2677: INTO l_interface_line_location_id
2678: FROM DUAL;
2679:
2680: populate_advance_payitem_dist

Line 2774: FROM po_line_locations_interface PLL

2770: PLL.request_id,
2771: PLL.program_application_id,
2772: PLL.program_id,
2773: PLL.program_update_date
2774: FROM po_line_locations_interface PLL
2775: WHERE PLL.interface_line_location_id = p_interface_line_location_id;
2776:
2777: IF (PO_LOG.d_proc) THEN
2778: PO_LOG.proc_end (d_module);

Line 2824: INSERT INTO po_line_locations_interface

2820: IF (PO_LOG.d_proc) THEN
2821: PO_LOG.proc_begin (d_module);
2822: END IF;
2823:
2824: INSERT INTO po_line_locations_interface
2825: (
2826: interface_line_location_id,
2827: interface_header_id,
2828: interface_line_id,

Line 2906: SELECT po_line_locations_interface_s.nextval,

2902: tax_code_id,
2903: tax_name,
2904: qty_rcv_tolerance
2905: )
2906: SELECT po_line_locations_interface_s.nextval,
2907: PLI.interface_header_id,
2908: PLI.interface_line_id,
2909: PLI.processing_id,
2910: PLI.process_code,

Line 2989: SELECT po_line_locations_interface_s.CURRVAL

2985: FROM po_lines_interface PLI
2986: WHERE PLI.interface_line_id = p_interface_line_id;
2987:
2988: IF (SQL%ROWCOUNT > 0) THEN
2989: SELECT po_line_locations_interface_s.CURRVAL
2990: INTO l_interface_line_location_id
2991: FROM DUAL;
2992:
2993: populate_progress_payitem_dist

Line 3089: FROM po_line_locations_interface PLL

3085: PLL.request_id,
3086: PLL.program_application_id,
3087: PLL.program_id,
3088: PLL.program_update_date
3089: FROM po_line_locations_interface PLL
3090: WHERE PLL.interface_line_location_id = p_interface_line_location_id;
3091:
3092: IF (PO_LOG.d_proc) THEN
3093: PO_LOG.proc_end (d_module);