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 276: FROM po_line_locations_interface intf_locs,

272: NVL(draft_headers.style_id, txn_headers.style_id),
273:
274: -- set initial value for error_flag
275: FND_API.g_FALSE
276: FROM po_line_locations_interface intf_locs,
277: po_lines_interface intf_lines,
278: po_headers_interface intf_headers,
279: po_lines_draft_all draft_lines,
280: po_headers_draft_all draft_headers,

Line 609: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',

605: p_interface_header_id => x_line_locs.intf_header_id_tbl(i),
606: p_interface_line_id => x_line_locs.intf_line_id_tbl(i),
607: p_interface_line_location_id => x_line_locs.intf_line_loc_id_tbl(i),
608: p_error_message_name => 'PO_PDOI_DERV_ERROR',
609: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',
610: p_column_name => 'SHIP_TO_ORGANIZATION_ID',
611: p_column_value => x_line_locs.ship_to_org_id_tbl(i),
612: p_token1_name => 'COLUMN_NAME',
613: p_token1_value => 'SHIP_TO_ORGANIZATION_CODE',

Line 637: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',

633: p_interface_header_id => x_line_locs.intf_header_id_tbl(i),
634: p_interface_line_id => x_line_locs.intf_line_id_tbl(i),
635: p_interface_line_location_id => x_line_locs.intf_line_loc_id_tbl(i),
636: p_error_message_name => 'PO_PDOI_DERV_ERROR',
637: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',
638: p_column_name => 'SHIP_TO_LOCATION_ID',
639: p_column_value => x_line_locs.ship_to_loc_id_tbl(i),
640: p_token1_name => 'COLUMN_NAME',
641: p_token1_value => 'SHIP_TO_LOCATION_CODE',

Line 665: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',

661: p_interface_header_id => x_line_locs.intf_header_id_tbl(i),
662: p_interface_line_id => x_line_locs.intf_line_id_tbl(i),
663: p_interface_line_location_id => x_line_locs.intf_line_loc_id_tbl(i),
664: p_error_message_name => 'PO_PDOI_DERV_ERROR',
665: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',
666: p_column_name => 'TERMS_ID',
667: p_column_value => x_line_locs.terms_id_tbl(i),
668: p_token1_name => 'COLUMN_NAME',
669: p_token1_value => 'PAYMENT_TERMS',

Line 691: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',

687: p_interface_header_id => x_line_locs.intf_header_id_tbl(i),
688: p_interface_line_id => x_line_locs.intf_line_id_tbl(i),
689: p_interface_line_location_id => x_line_locs.intf_line_loc_id_tbl(i),
690: p_error_message_name => 'PO_PDOI_DERV_ERROR',
691: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',
692: p_column_name => 'RECEIVING_ROUTING_ID',
693: p_column_value => x_line_locs.receiving_routing_id_tbl(i),
694: p_token1_name => 'COLUMN_NAME',
695: p_token1_value => 'RECEIVING_ROUTING',

Line 720: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',

716: p_interface_header_id => x_line_locs.intf_header_id_tbl(i),
717: p_interface_line_id => x_line_locs.intf_line_id_tbl(i),
718: p_interface_line_location_id => x_line_locs.intf_line_loc_id_tbl(i),
719: p_error_message_name => 'PO_PDOI_DERV_ERROR',
720: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',
721: p_column_name => 'TAX_NAME',
722: p_column_value => x_line_locs.tax_name_tbl(i),
723: p_token1_name => 'COLUMN_NAME',
724: p_token1_value => 'TAX_CODE_ID',

Line 995: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',

991:
992: PO_PDOI_ERR_UTL.process_val_type_errors
993: (
994: x_results => l_results,
995: p_table_name => 'PO_LINE_LOCATIONS_INTERFACE',
996: p_line_locs => x_line_locs
997: );
998:
999: d_position := 30;

Line 1042: -- be updated in po_line_locations_interface table

1038: --Parameters:
1039: --IN:
1040: --p_intf_line_loc_id_tbl
1041: -- list of interface_line_location_ids. Used to identify the rows to
1042: -- be updated in po_line_locations_interface table
1043: --p_line_loc_id_tbl
1044: -- list of the new line_location_ids which is going to be set in
1045: -- po_line_locations_interface table
1046: --p_error_flag_tbl

Line 1045: -- po_line_locations_interface table

1041: -- list of interface_line_location_ids. Used to identify the rows to
1042: -- be updated in po_line_locations_interface table
1043: --p_line_loc_id_tbl
1044: -- list of the new line_location_ids which is going to be set in
1045: -- po_line_locations_interface table
1046: --p_error_flag_tbl
1047: -- list of error_flags which indicates whether there is any error
1048: -- found in the processing logic for the corresponding location record
1049: --IN OUT:

Line 1075: UPDATE po_line_locations_interface

1071: END IF;
1072:
1073: -- update line_location_interface table with the new line_location_id
1074: FORALL i IN 1..p_intf_line_loc_id_tbl.COUNT
1075: UPDATE po_line_locations_interface
1076: SET line_location_id = p_line_loc_id_tbl(i),
1077: process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED
1078: WHERE interface_line_location_id = p_intf_line_loc_id_tbl(i)
1079: AND p_error_flag_tbl(i) = FND_API.g_FALSE;