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

Line 292: FROM po_line_locations_interface intf_locs,

288: NVL(draft_headers.currency_code,txn_headers.currency_code),-- Bug 9294987
289:
290: -- set initial value for error_flag
291: FND_API.g_FALSE
292: FROM po_line_locations_interface intf_locs,
293: po_lines_interface intf_lines,
294: po_headers_interface intf_headers,
295: po_lines_draft_all draft_lines,
296: po_headers_draft_all draft_headers,

Line 649: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',

645: p_interface_header_id => x_line_locs.intf_header_id_tbl(i),
646: p_interface_line_id => x_line_locs.intf_line_id_tbl(i),
647: p_interface_line_location_id => x_line_locs.intf_line_loc_id_tbl(i),
648: p_error_message_name => 'PO_PDOI_DERV_ERROR',
649: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',
650: p_column_name => 'SHIP_TO_ORGANIZATION_ID',
651: p_column_value => x_line_locs.ship_to_org_id_tbl(i),
652: p_token1_name => 'COLUMN_NAME',
653: p_token1_value => 'SHIP_TO_ORGANIZATION_CODE',

Line 677: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',

673: p_interface_header_id => x_line_locs.intf_header_id_tbl(i),
674: p_interface_line_id => x_line_locs.intf_line_id_tbl(i),
675: p_interface_line_location_id => x_line_locs.intf_line_loc_id_tbl(i),
676: p_error_message_name => 'PO_PDOI_DERV_ERROR',
677: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',
678: p_column_name => 'SHIP_TO_LOCATION_ID',
679: p_column_value => x_line_locs.ship_to_loc_id_tbl(i),
680: p_token1_name => 'COLUMN_NAME',
681: p_token1_value => 'SHIP_TO_LOCATION_CODE',

Line 705: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',

701: p_interface_header_id => x_line_locs.intf_header_id_tbl(i),
702: p_interface_line_id => x_line_locs.intf_line_id_tbl(i),
703: p_interface_line_location_id => x_line_locs.intf_line_loc_id_tbl(i),
704: p_error_message_name => 'PO_PDOI_DERV_ERROR',
705: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',
706: p_column_name => 'TERMS_ID',
707: p_column_value => x_line_locs.terms_id_tbl(i),
708: p_token1_name => 'COLUMN_NAME',
709: p_token1_value => 'PAYMENT_TERMS',

Line 731: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',

727: p_interface_header_id => x_line_locs.intf_header_id_tbl(i),
728: p_interface_line_id => x_line_locs.intf_line_id_tbl(i),
729: p_interface_line_location_id => x_line_locs.intf_line_loc_id_tbl(i),
730: p_error_message_name => 'PO_PDOI_DERV_ERROR',
731: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',
732: p_column_name => 'RECEIVING_ROUTING_ID',
733: p_column_value => x_line_locs.receiving_routing_id_tbl(i),
734: p_token1_name => 'COLUMN_NAME',
735: p_token1_value => 'RECEIVING_ROUTING',

Line 760: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',

756: p_interface_header_id => x_line_locs.intf_header_id_tbl(i),
757: p_interface_line_id => x_line_locs.intf_line_id_tbl(i),
758: p_interface_line_location_id => x_line_locs.intf_line_loc_id_tbl(i),
759: p_error_message_name => 'PO_PDOI_DERV_ERROR',
760: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',
761: p_column_name => 'TAX_NAME',
762: p_column_value => x_line_locs.tax_name_tbl(i),
763: p_token1_name => 'COLUMN_NAME',
764: p_token1_value => 'TAX_CODE_ID',

Line 815: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',

811: (p_interface_header_id => x_line_locs.intf_header_id_tbl(i),
812: p_interface_line_id => x_line_locs.intf_line_id_tbl(i),
813: p_interface_line_location_id => x_line_locs.intf_line_loc_id_tbl(i),
814: p_error_message_name => 'PO_PDOI_TXN_FLOW_API_ERROR ',
815: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',
816: p_column_name => 'SHIP_TO_ORGANIZATION_ID ',
817: p_column_value => x_line_locs.ship_to_org_id_tbl(i),
818: p_token1_name => 'COLUMN_NAME',
819: p_token1_value => 'SHIP_TO_ORGANIZATION_CODE ',

Line 1098: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',

1094:
1095: PO_PDOI_ERR_UTL.process_val_type_errors
1096: (
1097: x_results => l_results,
1098: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',
1099: p_line_locs => x_line_locs
1100: );
1101:
1102: d_position := 30;

Line 1145: -- be updated in po_line_locations_interface table

1141: --Parameters:
1142: --IN:
1143: --p_intf_line_loc_id_tbl
1144: -- list of interface_line_location_ids. Used to identify the rows to
1145: -- be updated in po_line_locations_interface table
1146: --p_line_loc_id_tbl
1147: -- list of the new line_location_ids which is going to be set in
1148: -- po_line_locations_interface table
1149: --p_error_flag_tbl

Line 1148: -- po_line_locations_interface table

1144: -- list of interface_line_location_ids. Used to identify the rows to
1145: -- be updated in po_line_locations_interface table
1146: --p_line_loc_id_tbl
1147: -- list of the new line_location_ids which is going to be set in
1148: -- po_line_locations_interface table
1149: --p_error_flag_tbl
1150: -- list of error_flags which indicates whether there is any error
1151: -- found in the processing logic for the corresponding location record
1152: --IN OUT:

Line 1178: UPDATE po_line_locations_interface

1174: END IF;
1175:
1176: -- update line_location_interface table with the new line_location_id
1177: FORALL i IN 1..p_intf_line_loc_id_tbl.COUNT
1178: UPDATE po_line_locations_interface
1179: SET line_location_id = p_line_loc_id_tbl(i),
1180: process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED
1181: WHERE interface_line_location_id = p_intf_line_loc_id_tbl(i)
1182: AND p_error_flag_tbl(i) = FND_API.g_FALSE;