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_LINES_INTERFACE

Line 239: FROM po_lines_interface

235: BULK COLLECT
236: INTO l_intf_line_id_tbl,
237: l_price_chg_accept_flag_tbl,
238: l_price_break_flag_tbl
239: FROM po_lines_interface
240: WHERE interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
241: AND NVL(process_code, PO_PDOI_CONSTANTS.g_process_code_PENDING) =
242: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
243: ORDER BY po_line_id, interface_line_id;

Line 275: UPDATE po_lines_interface

271:
272: -- update price change accept flag for price break lines
273: IF (l_update_flag_value_idx_tbl.COUNT > 0) THEN
274: FORALL i IN VALUES OF l_update_flag_value_idx_tbl
275: UPDATE po_lines_interface
276: SET price_chg_accept_flag = l_price_chg_accept_flag_tbl(i)
277: WHERE interface_line_id = l_intf_line_id_tbl(i);
278: END IF;
279:

Line 288: UPDATE po_lines_interface lines

284:
285: -- bug5149827
286: -- Set the acceptance status of the child record to be the same as
287: -- the parent
288: UPDATE po_lines_interface lines
289: SET lines.price_chg_accept_flag =
290: ( SELECT parent_lines.price_chg_accept_flag
291: FROM po_lines_interface parent_lines
292: WHERE lines.parent_interface_line_id =

Line 291: FROM po_lines_interface parent_lines

287: -- the parent
288: UPDATE po_lines_interface lines
289: SET lines.price_chg_accept_flag =
290: ( SELECT parent_lines.price_chg_accept_flag
291: FROM po_lines_interface parent_lines
292: WHERE lines.parent_interface_line_id =
293: parent_lines.interface_line_id )
294: WHERE lines.interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
295: AND NVL(lines.process_code, PO_PDOI_CONSTANTS.g_process_code_PENDING) =

Line 307: UPDATE po_lines_interface

303:
304: d_position := 40;
305:
306: -- Reject all records that have not been accepted
307: UPDATE po_lines_interface
308: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED
309: WHERE interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
310: AND process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
311: AND price_chg_accept_flag = 'N';

Line 467: UPDATE po_lines_interface

463:
464: d_position := 40;
465: -- Line level assignment
466: FORALL i IN 1..l_intf_header_id_tbl.COUNT
467: UPDATE po_lines_interface
468: SET processing_id = PO_PDOI_PARAMS.g_processing_id,
469: action = DECODE (action,
470: PO_PDOI_CONSTANTS.g_action_ADD, action,
471: NULL), -- null out process code unless it is force add

Line 1984: FROM po_lines_interface

1980: -- case we need to populate the information to line location information
1981: -- for processing later on
1982: CURSOR c_line_intf IS
1983: SELECT rowid
1984: FROM po_lines_interface
1985: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
1986: AND NVL(line_loc_populated_flag, 'N') = 'N';
1987:
1988: --SQL What: Get line location records that are just being populated

Line 1996: po_lines_interface PLI

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';
2000:

Line 2196: FROM po_lines_interface PLI

2192: PLI.taxable_flag,
2193: PLI.tax_code_id,
2194: PLI.tax_name,
2195: PLI.qty_rcv_tolerance
2196: FROM po_lines_interface PLI
2197: WHERE PLI.rowid = l_rowid_tbl(i);
2198:
2199: /* PDOI for Complex PO Project: Logic for creating Pay items: Start */
2200: BEGIN

Line 2210: po_lines_interface PLI

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)
2212: AND PLI.interface_header_id = PHI.interface_header_id;
2213: EXCEPTION
2214: WHEN OTHERS THEN

Line 2243: FROM po_lines_interface PLI

2239:
2240: UPDATE po_distributions_interface
2241: SET prevent_encumbrance_flag = 'Y'
2242: WHERE interface_line_id = (SELECT PLI.interface_line_id
2243: FROM po_lines_interface PLI
2244: WHERE PLI.rowid = l_rowid_tbl(i));
2245: END IF;
2246:
2247: IF (PO_LOG.d_stmt) THEN

Line 2379: UPDATE po_lines_interface

2375: d_position := 50;
2376:
2377: -- Since the default line location has been populated,
2378: -- populate 'S' to line_loc_populated_flag
2379: UPDATE po_lines_interface
2380: SET line_loc_populated_flag = 'S'
2381: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
2382: AND NVL(line_loc_populated_flag, 'N') = 'N';
2383:

Line 2671: FROM po_lines_interface PLI

2667: PLI.taxable_flag,
2668: PLI.tax_code_id,
2669: PLI.tax_name,
2670: PLI.qty_rcv_tolerance
2671: FROM po_lines_interface PLI
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

Line 2985: FROM po_lines_interface PLI

2981: PLI.taxable_flag,
2982: PLI.tax_code_id,
2983: PLI.tax_name,
2984: PLI.qty_rcv_tolerance
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

Line 3165: FROM po_lines_interface PLI,po_headers_interface phi

3161: l_intf_line_id_tbl,
3162: l_line_num_disp_tbl,
3163: l_clm_info_flag_tbl,
3164: l_po_header_id_tbl
3165: FROM po_lines_interface PLI,po_headers_interface phi
3166: WHERE PLI.processing_id = PO_PDOI_PARAMS.g_processing_id
3167: AND PLI.interface_header_id = phi.interface_header_id
3168: ORDER BY PLI.interface_header_id, PLI.line_num_display;
3169:

Line 3221: UPDATE po_lines_interface

3217: );
3218:
3219: --update line_num & group_line_id to lines interface
3220: FORALL i IN 1..l_intf_line_id_tbl.COUNT
3221: UPDATE po_lines_interface
3222: SET line_num = l_line_num_tbl(i),
3223: group_line_id = l_group_line_id_tbl(i)
3224: WHERE interface_header_id = l_intf_header_id_tbl(i)
3225: AND interface_line_id = l_intf_line_id_tbl(i)

Line 3235: p_table_name => 'PO_LINES_INTERFACE',

3231: THEN
3232: PO_PDOI_ERR_UTL.add_fatal_error
3233: ( p_interface_header_id => l_intf_header_id_tbl(i),
3234: p_error_message_name => 'PO_PDOI_DERV_ERROR',
3235: p_table_name => 'PO_LINES_INTERFACE',
3236: p_column_name => 'LINE_NUM_DISPLAY',
3237: p_column_value => l_line_num_disp_tbl(i)
3238: );
3239: l_reject_list.extend;