APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PO_PRICE_DIFF_INTERFACE

Line 2928: INSERT INTO po_price_diff_interface

2924: pbip.line_number <= l_batch_end ;
2925:
2926:
2927: -- Insert Line Price Differentials
2928: INSERT INTO po_price_diff_interface
2929: (price_diff_interface_id,
2930: price_differential_num,
2931: entity_type,
2932: interface_header_id,

Line 2944: po_price_diff_interface_s.NEXTVAL, -- price_diff_interface_id

2940: creation_date,
2941: created_by,
2942: last_update_login)
2943: SELECT
2944: po_price_diff_interface_s.NEXTVAL, -- price_diff_interface_id
2945: ppd.price_differential_number, -- price_differential_num
2946: 'BLANKET LINE', -- entity_type
2947: x_interface_header_id, -- interface_line_id
2948: pli.interface_line_id, -- interface_line_id

Line 2981: INSERT INTO po_price_diff_interface

2977: AND pbip.line_number >= l_batch_start
2978: AND pbip.line_number <= l_batch_end;
2979:
2980: -- Insert Price Break Price Differentials
2981: INSERT INTO po_price_diff_interface
2982: (price_diff_interface_id,
2983: price_differential_num,
2984: entity_type,
2985: interface_header_id,

Line 2997: po_price_diff_interface_s.NEXTVAL, -- price_diff_interface_id

2993: creation_date,
2994: created_by,
2995: last_update_login)
2996: SELECT
2997: po_price_diff_interface_s.NEXTVAL, -- price_diff_interface_id
2998: ppd.price_differential_number, -- price_differential_num
2999: 'PRICE BREAK', -- entity_type
3000: x_interface_header_id, -- interface_header_id
3001: pli.interface_line_id, -- interface_line_id

Line 3050: INSERT INTO po_price_diff_interface_debug

3046:
3047: INSERT INTO po_lines_interface_debug
3048: (SELECT * FROM po_lines_interface WHERE interface_header_id = x_interface_header_id);
3049:
3050: INSERT INTO po_price_diff_interface_debug
3051: (SELECT * FROM po_price_diff_interface WHERE interface_header_id = x_interface_header_id);
3052: */
3053:
3054: x_progress := '38: CREATE_PO_STRUCTURE: BLANKET CASE: END OF BULK INSERT';

Line 3051: (SELECT * FROM po_price_diff_interface WHERE interface_header_id = x_interface_header_id);

3047: INSERT INTO po_lines_interface_debug
3048: (SELECT * FROM po_lines_interface WHERE interface_header_id = x_interface_header_id);
3049:
3050: INSERT INTO po_price_diff_interface_debug
3051: (SELECT * FROM po_price_diff_interface WHERE interface_header_id = x_interface_header_id);
3052: */
3053:
3054: x_progress := '38: CREATE_PO_STRUCTURE: BLANKET CASE: END OF BULK INSERT';
3055: