[Home] [Help]
3408:
3409:
3410:
3411: IF PG_DEBUG <> 0 THEN
3412: oe_debug_pub.add(lpad(' ',g_pg_level) || 'insert_blanket_line: ' || 'Inerting into po_lines_interface',1);
3413:
3414: oe_debug_pub.add(lpad(' ',g_pg_level) || 'insert_blanket_line: ' || 'Start date = '||to_char(p_start_date),2);
3415:
3416: oe_debug_pub.add(lpad(' ',g_pg_level) || 'insert_blanket_line: ' || 'End date ='||to_char(p_end_date),2);
3420: -- Done by Renga Kannan on 04/30/04
3421: -- Allow_price_override_flag and not_to_exceed_price should not be
3422: -- copied from model as it will not make any sense. And there
3423: -- no way to derive these fileds also.
3424: Insert into po_lines_interface(
3425: interface_line_id,
3426: interface_header_id,
3427: Line_num,
3428: line_type_id,
3452: tax_code_id,
3453: effective_date,
3454: expiration_date)
3455: select
3456: po_lines_interface_s.nextval,
3457: p_int_header_id,
3458: null,
3459: pol.line_type_id,
3460: p_item_id,
3496:
3497: -- Modified by Renga Kannan on 04/16/2002
3498: -- Added ship_to_location_id in the interface table.
3499:
3500: Insert into Po_lines_interface(
3501: interface_line_id,
3502: interface_header_id,
3503: line_num,
3504: shipment_num,
3538: shipment_attribute15,
3539: last_update_date)
3540: --price_override) -- Check with Beth
3541: select
3542: po_lines_interface_s.nextval,
3543: p_int_header_id,
3544: null,
3545: poll.shipment_num,
3546: poll.shipment_type,