APPS.PO_UDA_AUTOCREATE_PKG dependencies on PON_BID_HEADERS

Line 715: l_src_table_name := 'PON_BID_HEADERS';

711: l_doc_style := NULL;
712:
713: IF p_doc_level = 'HEADER' THEN
714: x_pk1_col_name := 'BID_NUMBER';
715: l_src_table_name := 'PON_BID_HEADERS';
716: ELSIF p_doc_level = 'LINE' THEN
717: x_pk1_col_name := 'BID_NUMBER';
718: x_pk2_col_name := 'LINE_NUMBER';
719: l_src_table_name := 'PON_BID_ITEM_PRICES';

Line 832: FROM pon_bid_headers

828: l_progress := '060';
829:
830: SELECT AUCTION_HEADER_ID
831: INTO x_pk1_value
832: FROM pon_bid_headers
833: WHERE BID_NUMBER=
834: (SELECT bid_number
835: FROM po_lines_interface
836: WHERE interface_header_id=po_autocreate_params.g_interface_header_id

Line 882: FROM pon_bid_headers

878:
879: -- We can get it from po_lines_interface.from_header_id
880: SELECT IDV_HEADER_ID , -1
881: INTO x_pk1_value , x_pk2_value
882: FROM pon_bid_headers
883: WHERE BID_NUMBER=
884: (SELECT bid_number
885: FROM po_lines_interface
886: WHERE interface_header_id=po_autocreate_params.g_interface_header_id

Line 984: FROM pon_bid_headers

980: l_progress := '190';
981:
982: SELECT bid_number
983: INTO x_pk1_value
984: FROM pon_bid_headers
985: WHERE po_header_id = x_pk1_value;
986:
987:
988: IF x_pk1_value IS NOT NULL AND p_doc_level='LINE' AND p_intf_line_id IS NOT NULL

Line 1016: FROM pon_bid_headers

1012:
1013: l_progress := '230';
1014: SELECT auction_header_id
1015: INTO x_pk1_value
1016: FROM pon_bid_headers
1017: WHERE po_header_id = x_pk1_value;
1018:
1019:
1020: IF x_pk1_value IS NOT NULL AND p_doc_level='LINE' AND p_intf_line_id IS NOT NULL