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 275: FROM po_headers_interface

271:
272: -- blanket dist columns
273: NULL -- po_dist_id -- bug5252250
274:
275: FROM po_headers_interface
276: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
277: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num
278: AND interface_header_id > p_max_intf_header_id
279: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

Line 686: p_table_name => 'PO_HEADERS_INTERFACE',

682: PO_PDOI_ERR_UTL.add_fatal_error
683: (
684: p_interface_header_id => x_headers.intf_header_id_tbl(i),
685: p_error_message_name => 'PO_PDOI_DERV_ERROR',
686: p_table_name => 'PO_HEADERS_INTERFACE',
687: p_column_name => 'RATE_TYPE_CODE',
688: p_column_value => x_headers.rate_type_code_tbl(i),
689: p_token1_name => 'COLUMN_NAME',
690: p_token1_value => 'RATE_TYPE',

Line 711: p_table_name => 'PO_HEADERS_INTERFACE',

707: PO_PDOI_ERR_UTL.add_fatal_error
708: (
709: p_interface_header_id => x_headers.intf_header_id_tbl(i),
710: p_error_message_name => 'PO_PDOI_DERV_ERROR',
711: p_table_name => 'PO_HEADERS_INTERFACE',
712: p_column_name => 'AGENT_ID',
713: p_column_value => x_headers.agent_id_tbl(i),
714: p_token1_name => 'COLUMN_NAME',
715: p_token1_value => 'AGENT_NAME',

Line 734: p_table_name => 'PO_HEADERS_INTERFACE',

730: PO_PDOI_ERR_UTL.add_fatal_error
731: (
732: p_interface_header_id => x_headers.intf_header_id_tbl(i),
733: p_error_message_name => 'PO_PDOI_DERV_ERROR',
734: p_table_name => 'PO_HEADERS_INTERFACE',
735: p_column_name => 'SHIP_TO_LOCATION_ID',
736: p_column_value => x_headers.ship_to_loc_id_tbl(i),
737: p_token1_name => 'COLUMN_NAME',
738: p_token1_value => 'SHIP_TO_LOCATION_CODE',

Line 757: p_table_name => 'PO_HEADERS_INTERFACE',

753: PO_PDOI_ERR_UTL.add_fatal_error
754: (
755: p_interface_header_id => x_headers.intf_header_id_tbl(i),
756: p_error_message_name => 'PO_PDOI_DERV_ERROR',
757: p_table_name => 'PO_HEADERS_INTERFACE',
758: p_column_name => 'BILL_TO_LOCATION_ID',
759: p_column_value => x_headers.bill_to_loc_id_tbl(i),
760: p_token1_name => 'COLUMN_NAME',
761: p_token1_value => 'BILL_TO_LOCATION_CODE',

Line 780: p_table_name => 'PO_HEADERS_INTERFACE',

776: PO_PDOI_ERR_UTL.add_fatal_error
777: (
778: p_interface_header_id => x_headers.intf_header_id_tbl(i),
779: p_error_message_name => 'PO_PDOI_DERV_ERROR',
780: p_table_name => 'PO_HEADERS_INTERFACE',
781: p_column_name => 'TERMS_ID',
782: p_column_value => x_headers.terms_id_tbl(i),
783: p_token1_name => 'COLUMN_NAME',
784: p_token1_value => 'PAYMENT_TERMS',

Line 811: p_table_name => 'PO_HEADERS_INTERFACE',

807: PO_PDOI_ERR_UTL.add_fatal_error
808: (
809: p_interface_header_id => x_headers.intf_header_id_tbl(i),
810: p_error_message_name => 'PO_PDOI_DERV_ERROR',
811: p_table_name => 'PO_HEADERS_INTERFACE',
812: p_column_name => 'VENDOR_ID',
813: p_column_value => x_headers.vendor_id_tbl(i),
814: p_token1_name => 'COLUMN_NAME',
815: p_token1_value => l_column_name,

Line 835: p_table_name => 'PO_HEADERS_INTERFACE',

831: PO_PDOI_ERR_UTL.add_fatal_error
832: (
833: p_interface_header_id => x_headers.intf_header_id_tbl(i),
834: p_error_message_name => 'PO_PDOI_DERV_ERROR',
835: p_table_name => 'PO_HEADERS_INTERFACE',
836: p_column_name => 'VENDOR_SITE_ID',
837: p_column_value => x_headers.vendor_site_id_tbl(i),
838: p_token1_name => 'COLUMN_NAME',
839: p_token1_value => 'VENDOR_SITE_CODE',

Line 858: p_table_name => 'PO_HEADERS_INTERFACE',

854: PO_PDOI_ERR_UTL.add_fatal_error
855: (
856: p_interface_header_id => x_headers.intf_header_id_tbl(i),
857: p_error_message_name => 'PO_PDOI_DERV_ERROR',
858: p_table_name => 'PO_HEADERS_INTERFACE',
859: p_column_name => 'VENDOR_CONTACT_ID',
860: p_column_value => x_headers.vendor_contact_id_tbl(i),
861: p_token1_name => 'COLUMN_NAME',
862: p_token1_value => 'VENDOR_CONTACT',

Line 881: p_table_name => 'PO_HEADERS_INTERFACE',

877: PO_PDOI_ERR_UTL.add_fatal_error
878: (
879: p_interface_header_id => x_headers.intf_header_id_tbl(i),
880: p_error_message_name => 'PO_PDOI_DERV_ERROR',
881: p_table_name => 'PO_HEADERS_INTERFACE',
882: p_column_name => 'STYLE_ID',
883: p_column_value => x_headers.style_id_tbl(i),
884: p_token1_name => 'COLUMN_NAME',
885: p_token1_value => 'STYLE_DISPLAY_NAME',

Line 906: p_table_name => 'PO_HEADERS_INTERFACE',

902: PO_PDOI_ERR_UTL.add_fatal_error
903: (
904: p_interface_header_id => x_headers.intf_header_id_tbl(i),
905: p_error_message_name => 'PO_PDOI_DERV_ERROR',
906: p_table_name => 'PO_HEADERS_INTERFACE',
907: p_column_name => 'FROM_HEADER_ID',
908: p_column_value => x_headers.from_header_id_tbl(i),
909: p_token1_name => 'COLUMN_NAME',
910: p_token1_value => 'FROM_RFQ_NUM',

Line 1537: l_headers PO_HEADERS_VAL_TYPE := PO_HEADERS_VAL_TYPE();

1533: d_api_name CONSTANT VARCHAR2(30) := 'validate_headers';
1534: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1535: d_position NUMBER;
1536:
1537: l_headers PO_HEADERS_VAL_TYPE := PO_HEADERS_VAL_TYPE();
1538: l_result_type VARCHAR2(30);
1539: l_results po_validation_results_type;
1540: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
1541: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();

Line 1633: p_table_name => 'PO_HEADERS_INTERFACE',

1629:
1630: PO_PDOI_ERR_UTL.process_val_type_errors
1631: (
1632: x_results => l_results,
1633: p_table_name => 'PO_HEADERS_INTERFACE',
1634: p_headers => x_headers
1635: );
1636:
1637: d_position := 30;

Line 2519: FROM po_headers

2515: INSERT INTO po_session_gt(key, num1, num2)
2516: SELECT p_key,
2517: p_index_tbl(i),
2518: po_header_id
2519: FROM po_headers
2520: WHERE x_from_header_id_tbl(i) IS NULL
2521: AND p_from_rfq_num_tbl(i) IS NOT NULL
2522: AND segment1 = p_from_rfq_num_tbl(i)
2523: AND type_lookup_code = 'RFQ'; -- PO_PDOI_CONSTANTS.g_DOC_TYPE_RFQ;