DBA Data[Home] [Help]

APPS.PO_PDOI_HEADER_PROCESS_PVT dependencies on PO_HEADERS_INTERFACE

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 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;