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

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 890: l_line_locations PO_LINE_LOCATIONS_VAL_TYPE := PO_LINE_LOCATIONS_VAL_TYPE();

886: d_api_name CONSTANT VARCHAR2(30) := 'validate_line_locs';
887: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
888: d_position NUMBER;
889:
890: l_line_locations PO_LINE_LOCATIONS_VAL_TYPE := PO_LINE_LOCATIONS_VAL_TYPE();
891: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
892: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
893: l_result_type VARCHAR2(30);
894: l_results po_validation_results_type;

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;

Line 1134: FROM po_line_locations_draft_all

1130: FORALL i IN 1..p_po_line_id_tbl.COUNT
1131: UPDATE po_lines_draft_all draft_lines
1132: SET (amount, quantity) =
1133: (select sum(amount), sum(quantity)
1134: FROM po_line_locations_draft_all
1135: WHERE po_line_id = draft_lines.po_line_id
1136: AND draft_id = draft_lines.draft_id)
1137: WHERE po_line_id = p_po_line_id_tbl(i)
1138: AND draft_id = p_draft_id_tbl(i);

Line 1204: FROM po_line_locations_all

1200: INSERT INTO po_session_gt(key, num1, num2)
1201: SELECT l_key,
1202: line_location_id,
1203: p_draft_id_tbl(i)
1204: FROM po_line_locations_all
1205: WHERE po_line_id = p_po_line_id_tbl(i);
1206:
1207: d_position := 10;
1208:

Line 1220: PO_LINE_LOCATIONS_DRAFT_PKG.sync_draft_from_txn

1216: FOR i IN 1..l_line_loc_id_tbl.COUNT
1217: LOOP
1218: l_delete_flag_tbl(i) := 'Y';
1219: END LOOP;
1220: PO_LINE_LOCATIONS_DRAFT_PKG.sync_draft_from_txn
1221: (
1222: p_line_location_id_tbl => l_line_loc_id_tbl,
1223: p_draft_id_tbl => l_draft_id_tbl,
1224: p_delete_flag_tbl => l_delete_flag_tbl,

Line 1300: FROM po_line_locations

1296: INSERT INTO po_session_gt(key, num1, num2)
1297: SELECT p_key,
1298: p_index_tbl(i),
1299: line_location_id
1300: FROM po_line_locations
1301: WHERE p_shipment_num_tbl(i) IS NOT NULL
1302: AND x_line_loc_id_tbl(i) IS NULL
1303: AND po_line_id = p_po_line_id_tbl(i)
1304: AND shipment_num = p_shipment_num_tbl(i)