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_HEADER_PROCESS_PVT dependencies on PO_HEADERS

Line 347: FROM po_headers_interface

343: clm_contract_officer,
344: clm_source_document_disp,
345: null --draft_type
346:
347: FROM po_headers_interface
348: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
349: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num
350: AND interface_header_id > p_max_intf_header_id
351: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

Line 561: FROM po_headers_interface

557: clm_contract_officer,
558: clm_source_document_disp,
559: null --draft_type
560:
561: FROM po_headers_interface
562: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
563: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num
564: AND po_header_id = p_intf_po_header_id
565: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

Line 1057: p_table_name => 'PO_HEADERS_INTERFACE',

1053: PO_PDOI_ERR_UTL.add_fatal_error
1054: (
1055: p_interface_header_id => x_headers.intf_header_id_tbl(i),
1056: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1057: p_table_name => 'PO_HEADERS_INTERFACE',
1058: p_column_name => 'RATE_TYPE_CODE',
1059: p_column_value => x_headers.rate_type_code_tbl(i),
1060: p_token1_name => 'COLUMN_NAME',
1061: p_token1_value => 'RATE_TYPE',

Line 1082: p_table_name => 'PO_HEADERS_INTERFACE',

1078: PO_PDOI_ERR_UTL.add_fatal_error
1079: (
1080: p_interface_header_id => x_headers.intf_header_id_tbl(i),
1081: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1082: p_table_name => 'PO_HEADERS_INTERFACE',
1083: p_column_name => 'AGENT_ID',
1084: p_column_value => x_headers.agent_id_tbl(i),
1085: p_token1_name => 'COLUMN_NAME',
1086: p_token1_value => 'AGENT_NAME',

Line 1105: p_table_name => 'PO_HEADERS_INTERFACE',

1101: PO_PDOI_ERR_UTL.add_fatal_error
1102: (
1103: p_interface_header_id => x_headers.intf_header_id_tbl(i),
1104: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1105: p_table_name => 'PO_HEADERS_INTERFACE',
1106: p_column_name => 'SHIP_TO_LOCATION_ID',
1107: p_column_value => x_headers.ship_to_loc_id_tbl(i),
1108: p_token1_name => 'COLUMN_NAME',
1109: p_token1_value => 'SHIP_TO_LOCATION_CODE',

Line 1128: p_table_name => 'PO_HEADERS_INTERFACE',

1124: PO_PDOI_ERR_UTL.add_fatal_error
1125: (
1126: p_interface_header_id => x_headers.intf_header_id_tbl(i),
1127: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1128: p_table_name => 'PO_HEADERS_INTERFACE',
1129: p_column_name => 'BILL_TO_LOCATION_ID',
1130: p_column_value => x_headers.bill_to_loc_id_tbl(i),
1131: p_token1_name => 'COLUMN_NAME',
1132: p_token1_value => 'BILL_TO_LOCATION_CODE',

Line 1151: p_table_name => 'PO_HEADERS_INTERFACE',

1147: PO_PDOI_ERR_UTL.add_fatal_error
1148: (
1149: p_interface_header_id => x_headers.intf_header_id_tbl(i),
1150: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1151: p_table_name => 'PO_HEADERS_INTERFACE',
1152: p_column_name => 'TERMS_ID',
1153: p_column_value => x_headers.terms_id_tbl(i),
1154: p_token1_name => 'COLUMN_NAME',
1155: p_token1_value => 'PAYMENT_TERMS',

Line 1182: p_table_name => 'PO_HEADERS_INTERFACE',

1178: PO_PDOI_ERR_UTL.add_fatal_error
1179: (
1180: p_interface_header_id => x_headers.intf_header_id_tbl(i),
1181: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1182: p_table_name => 'PO_HEADERS_INTERFACE',
1183: p_column_name => 'VENDOR_ID',
1184: p_column_value => x_headers.vendor_id_tbl(i),
1185: p_token1_name => 'COLUMN_NAME',
1186: p_token1_value => l_column_name,

Line 1206: p_table_name => 'PO_HEADERS_INTERFACE',

1202: PO_PDOI_ERR_UTL.add_fatal_error
1203: (
1204: p_interface_header_id => x_headers.intf_header_id_tbl(i),
1205: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1206: p_table_name => 'PO_HEADERS_INTERFACE',
1207: p_column_name => 'VENDOR_SITE_ID',
1208: p_column_value => x_headers.vendor_site_id_tbl(i),
1209: p_token1_name => 'COLUMN_NAME',
1210: p_token1_value => 'VENDOR_SITE_CODE',

Line 1229: p_table_name => 'PO_HEADERS_INTERFACE',

1225: PO_PDOI_ERR_UTL.add_fatal_error
1226: (
1227: p_interface_header_id => x_headers.intf_header_id_tbl(i),
1228: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1229: p_table_name => 'PO_HEADERS_INTERFACE',
1230: p_column_name => 'VENDOR_CONTACT_ID',
1231: p_column_value => x_headers.vendor_contact_id_tbl(i),
1232: p_token1_name => 'COLUMN_NAME',
1233: p_token1_value => 'VENDOR_CONTACT',

Line 1252: p_table_name => 'PO_HEADERS_INTERFACE',

1248: PO_PDOI_ERR_UTL.add_fatal_error
1249: (
1250: p_interface_header_id => x_headers.intf_header_id_tbl(i),
1251: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1252: p_table_name => 'PO_HEADERS_INTERFACE',
1253: p_column_name => 'STYLE_ID',
1254: p_column_value => x_headers.style_id_tbl(i),
1255: p_token1_name => 'COLUMN_NAME',
1256: p_token1_value => 'STYLE_DISPLAY_NAME',

Line 1277: p_table_name => 'PO_HEADERS_INTERFACE',

1273: PO_PDOI_ERR_UTL.add_fatal_error
1274: (
1275: p_interface_header_id => x_headers.intf_header_id_tbl(i),
1276: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1277: p_table_name => 'PO_HEADERS_INTERFACE',
1278: p_column_name => 'FROM_HEADER_ID',
1279: p_column_value => x_headers.from_header_id_tbl(i),
1280: p_token1_name => 'COLUMN_NAME',
1281: p_token1_value => 'FROM_RFQ_NUM',

Line 1305: p_table_name => 'PO_HEADERS_INTERFACE',

1301: PO_PDOI_ERR_UTL.add_fatal_error
1302: (
1303: p_interface_header_id => x_headers.intf_header_id_tbl(i),
1304: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1305: p_table_name => 'PO_HEADERS_INTERFACE',
1306: p_column_name => 'CLM_AWARD_TYPE',
1307: p_column_value => x_headers.clm_award_type_tbl(i),
1308: p_token1_name => 'COLUMN_NAME',
1309: p_token1_value => 'CLM_AWARD_TYPE_DISP',

Line 1328: p_table_name => 'PO_HEADERS_INTERFACE',

1324: PO_PDOI_ERR_UTL.add_fatal_error
1325: (
1326: p_interface_header_id => x_headers.intf_header_id_tbl(i),
1327: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1328: p_table_name => 'PO_HEADERS_INTERFACE',
1329: p_column_name => 'CLM_AWARD_ADMINISTRATOR',
1330: p_column_value => x_headers.clm_award_administrator_tbl(i),
1331: p_token1_name => 'COLUMN_NAME',
1332: p_token1_value => 'CLM_AWARD_ADMINISTRATOR_DISP',

Line 1351: p_table_name => 'PO_HEADERS_INTERFACE',

1347: PO_PDOI_ERR_UTL.add_fatal_error
1348: (
1349: p_interface_header_id => x_headers.intf_header_id_tbl(i),
1350: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1351: p_table_name => 'PO_HEADERS_INTERFACE',
1352: p_column_name => 'CLM_CONTRACT_OFFICER',
1353: p_column_value => x_headers.clm_contract_officer_tbl(i),
1354: p_token1_name => 'COLUMN_NAME',
1355: p_token1_value => 'CLM_CONTRACT_OFFICER_DISP',

Line 1374: p_table_name => 'PO_HEADERS_INTERFACE',

1370: PO_PDOI_ERR_UTL.add_fatal_error
1371: (
1372: p_interface_header_id => x_headers.intf_header_id_tbl(i),
1373: p_error_message_name => 'PO_PDOI_DERV_ERROR',
1374: p_table_name => 'PO_HEADERS_INTERFACE',
1375: p_column_name => 'CLM_SOURCE_DOCUMENT_ID',
1376: p_column_value => x_headers.clm_source_document_id_tbl(i),
1377: p_token1_name => 'COLUMN_NAME',
1378: p_token1_value => 'CLM_SOURCE_DOCUMENT_DISP',

Line 2035: l_headers PO_HEADERS_VAL_TYPE := PO_HEADERS_VAL_TYPE();

2031: d_api_name CONSTANT VARCHAR2(30) := 'validate_headers';
2032: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2033: d_position NUMBER;
2034:
2035: l_headers PO_HEADERS_VAL_TYPE := PO_HEADERS_VAL_TYPE();
2036: l_result_type VARCHAR2(30);
2037: l_results po_validation_results_type;
2038: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
2039: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();

Line 2142: p_table_name => 'PO_HEADERS_INTERFACE',

2138:
2139: PO_PDOI_ERR_UTL.process_val_type_errors
2140: (
2141: x_results => l_results,
2142: p_table_name => 'PO_HEADERS_INTERFACE',
2143: p_headers => x_headers
2144: );
2145:
2146: d_position := 30;

Line 3028: FROM po_headers

3024: INSERT INTO po_session_gt(key, num1, num2)
3025: SELECT p_key,
3026: p_index_tbl(i),
3027: po_header_id
3028: FROM po_headers
3029: WHERE x_from_header_id_tbl(i) IS NULL
3030: AND p_from_rfq_num_tbl(i) IS NOT NULL
3031: AND segment1 = p_from_rfq_num_tbl(i)
3032: AND type_lookup_code = 'RFQ'; -- PO_PDOI_CONSTANTS.g_DOC_TYPE_RFQ;

Line 4111: FROM po_headers_all

4107: INSERT INTO po_session_gt(key, num1, num2)
4108: SELECT p_key,
4109: p_index_tbl(i),
4110: po_header_id
4111: FROM po_headers_all
4112: WHERE x_clm_source_document_id_tbl(i) IS NULL
4113: AND p_clm_source_document_disp_tbl(i) IS NOT null
4114: AND clm_document_number = p_clm_source_document_disp_tbl(i);
4115:

Line 4179: FROM po_headers_all

4175: INSERT INTO po_session_gt(key, num1, num2)
4176: SELECT p_key,
4177: p_index_tbl(i),
4178: vendor_id
4179: FROM po_headers_all
4180: WHERE x_vendor_id_tbl(i) IS NULL
4181: AND p_clm_source_document_id_tbl(i) IS NOT NULL
4182: AND po_header_id = p_clm_source_document_id_tbl(i)
4183: AND p_doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD;

Line 4247: FROM po_headers_all

4243: INSERT INTO po_session_gt(key, num1, num2)
4244: SELECT p_key,
4245: p_index_tbl(i),
4246: vendor_site_id
4247: FROM po_headers_all
4248: WHERE x_vendor_site_id_tbl(i) IS NULL
4249: AND p_clm_source_document_id_tbl(i) IS NOT NULL
4250: AND po_header_id = p_clm_source_document_id_tbl(i)
4251: AND p_doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD;