[Home] [Help]
3800:
3801:
3802:
3803: IF PG_DEBUG <> 0 THEN
3804: oe_debug_pub.add(lpad(' ',g_pg_level) || 'insert_blanket_line: ' || 'Inerting into po_lines_interface',1);
3805:
3806: oe_debug_pub.add(lpad(' ',g_pg_level) || 'insert_blanket_line: ' || 'Start date = '||to_char(p_start_date),2);
3807:
3808: oe_debug_pub.add(lpad(' ',g_pg_level) || 'insert_blanket_line: ' || 'End date ='||to_char(p_end_date),2);
3822: -- Done by Renga Kannan on 04/30/04
3823: -- Allow_price_override_flag and not_to_exceed_price should not be
3824: -- copied from model as it will not make any sense. And there
3825: -- no way to derive these fileds also.
3826: Insert into po_lines_interface(
3827: interface_line_id,
3828: interface_header_id,
3829: Line_num,
3830: line_type_id,
3854: tax_code_id,
3855: effective_date,
3856: expiration_date)
3857: select
3858: po_lines_interface_s.nextval,
3859: p_int_header_id,
3860: null,
3861: pol.line_type_id,
3862: p_item_id,
3900:
3901: -- Modified by Renga Kannan on 04/16/2002
3902: -- Added ship_to_location_id in the interface table.
3903:
3904: Insert into Po_lines_interface(
3905: interface_line_id,
3906: interface_header_id,
3907: line_num,
3908: shipment_num,
3942: shipment_attribute15,
3943: last_update_date)
3944: --price_override) -- Check with Beth
3945: select
3946: po_lines_interface_s.nextval,
3947: p_int_header_id,
3948: null,
3949: poll.shipment_num,
3950: poll.shipment_type,