APPS.PO_PDOI_MAINPROC_PVT dependencies on PO_HEADERS_INTERFACE

Line 172: -- from po_headers_interface table

168: --Locks:
169: -- None
170: --Function:
171: -- handle the logic to derive, default, validate and insert records
172: -- from po_headers_interface table
173: --Parameters:
174: --IN: None
175: --IN OUT: None
176: --OUT: None

Line 539: from po_headers_interface

535: /*
536: -- code added for debugging purpose
537: select interface_header_id
538: into PO_PDOI_PARAMS.g_request.interface_header_id
539: from po_headers_interface
540: where processing_id = PO_PDOI_PARAMS.g_processing_id
541: and processing_round_num = 1;
542: */
543:

Line 1114: po_headers_interface intf_headers

1110: BULK COLLECT INTO l_rej_intf_line_id_tbl
1111: FROM po_lines_interface intf_line1,
1112: (SELECT intf_line2.interface_line_id, max(intf_line3.interface_line_id) AS match_intf_line_id
1113: FROM po_lines_interface intf_line2, po_lines_interface intf_line3,
1114: po_headers_interface intf_headers
1115: WHERE intf_line2.interface_header_id = intf_headers.interface_header_id
1116: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1117: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1118: AND intf_line2.price_break_flag = 'Y'

Line 1146: po_headers_interface intf_headers

1142: BULK COLLECT INTO l_notified_intf_line_id_tbl
1143: FROM po_lines_interface intf_line1,
1144: (SELECT intf_line2.interface_line_id, max(intf_line3.interface_line_id) AS match_intf_line_id
1145: FROM po_lines_interface intf_line2, po_lines_interface intf_line3,
1146: po_headers_interface intf_headers
1147: WHERE intf_line2.interface_header_id = intf_headers.interface_header_id
1148: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1149: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1150: AND intf_line2.price_break_flag = 'Y'