APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PO_PRICE_DIFF_INTERFACE

Line 3571: INSERT INTO po_price_diff_interface

3567: pbip.line_number <= l_batch_end ;
3568:
3569:
3570: -- Insert Line Price Differentials
3571: INSERT INTO po_price_diff_interface
3572: (price_diff_interface_id,
3573: price_differential_num,
3574: entity_type,
3575: interface_header_id,

Line 3587: po_price_diff_interface_s.NEXTVAL, -- price_diff_interface_id

3583: creation_date,
3584: created_by,
3585: last_update_login)
3586: SELECT
3587: po_price_diff_interface_s.NEXTVAL, -- price_diff_interface_id
3588: ppd.price_differential_number, -- price_differential_num
3589: 'BLANKET LINE', -- entity_type
3590: x_interface_header_id, -- interface_line_id
3591: pli.interface_line_id, -- interface_line_id

Line 3624: INSERT INTO po_price_diff_interface

3620: AND pbip.line_number >= l_batch_start
3621: AND pbip.line_number <= l_batch_end;
3622:
3623: -- Insert Price Break Price Differentials
3624: INSERT INTO po_price_diff_interface
3625: (price_diff_interface_id,
3626: price_differential_num,
3627: entity_type,
3628: interface_header_id,

Line 3640: po_price_diff_interface_s.NEXTVAL, -- price_diff_interface_id

3636: creation_date,
3637: created_by,
3638: last_update_login)
3639: SELECT
3640: po_price_diff_interface_s.NEXTVAL, -- price_diff_interface_id
3641: ppd.price_differential_number, -- price_differential_num
3642: 'PRICE BREAK', -- entity_type
3643: x_interface_header_id, -- interface_header_id
3644: pli.interface_line_id, -- interface_line_id

Line 3693: INSERT INTO po_price_diff_interface_debug

3689:
3690: INSERT INTO po_lines_interface_debug
3691: (SELECT * FROM po_lines_interface WHERE interface_header_id = x_interface_header_id);
3692:
3693: INSERT INTO po_price_diff_interface_debug
3694: (SELECT * FROM po_price_diff_interface WHERE interface_header_id = x_interface_header_id);
3695: */
3696:
3697: x_progress := '38: CREATE_PO_STRUCTURE: BLANKET CASE: END OF BULK INSERT';

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

3690: INSERT INTO po_lines_interface_debug
3691: (SELECT * FROM po_lines_interface WHERE interface_header_id = x_interface_header_id);
3692:
3693: INSERT INTO po_price_diff_interface_debug
3694: (SELECT * FROM po_price_diff_interface WHERE interface_header_id = x_interface_header_id);
3695: */
3696:
3697: x_progress := '38: CREATE_PO_STRUCTURE: BLANKET CASE: END OF BULK INSERT';
3698: