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

984: d_api_name CONSTANT VARCHAR2(30) := 'validate_line_locs';
985: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
986: d_position NUMBER;
987:
988: l_line_locations PO_LINE_LOCATIONS_VAL_TYPE := PO_LINE_LOCATIONS_VAL_TYPE();
989: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
990: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
991: l_result_type VARCHAR2(30);
992: l_results po_validation_results_type;

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;

Line 1241: FROM po_line_locations_draft_all

1237: SET (amount, quantity,secondary_quantity) =
1238: (select sum(Decode(Nvl(payment_type,'DELIVERY'),'RATE',Nvl(quantity,0)*Nvl(price_override,0),amount)),
1239: sum(Decode(Nvl(payment_type,'DELIVERY'),'RATE',NULL,quantity)),
1240: sum(secondary_quantity)
1241: FROM po_line_locations_draft_all
1242: WHERE po_line_id = draft_lines.po_line_id
1243: AND draft_id = draft_lines.draft_id
1244: AND (payment_type IS NULL OR payment_type NOT IN ('ADVANCE','DELIVERY')))
1245: -- PDOI for Complex PO Project

Line 1313: FROM po_line_locations_all

1309: INSERT INTO po_session_gt(key, num1, num2)
1310: SELECT l_key,
1311: line_location_id,
1312: p_draft_id_tbl(i)
1313: FROM po_line_locations_all
1314: WHERE po_line_id = p_po_line_id_tbl(i);
1315:
1316: d_position := 10;
1317:

Line 1329: PO_LINE_LOCATIONS_DRAFT_PKG.sync_draft_from_txn

1325: FOR i IN 1..l_line_loc_id_tbl.COUNT
1326: LOOP
1327: l_delete_flag_tbl(i) := 'Y';
1328: END LOOP;
1329: PO_LINE_LOCATIONS_DRAFT_PKG.sync_draft_from_txn
1330: (
1331: p_line_location_id_tbl => l_line_loc_id_tbl,
1332: p_draft_id_tbl => l_draft_id_tbl,
1333: p_delete_flag_tbl => l_delete_flag_tbl,

Line 1409: FROM po_line_locations

1405: INSERT INTO po_session_gt(key, num1, num2)
1406: SELECT p_key,
1407: p_index_tbl(i),
1408: line_location_id
1409: FROM po_line_locations
1410: WHERE p_shipment_num_tbl(i) IS NOT NULL
1411: AND x_line_loc_id_tbl(i) IS NULL
1412: AND po_line_id = p_po_line_id_tbl(i)
1413: AND shipment_num = p_shipment_num_tbl(i)