[Home] [Help]
3479: --
3480: begin
3481:
3482: G_ERROR_LOCATION := 16;
3483: insert into oe_upgrade_log
3484: (
3485: header_id,
3486: old_line_id,
3487: old_line_detail_id,
3736: and parent_line_id is null -- To filter out option lines
3737: and line_id in
3738: (select shipment_schedule_line_id from so_lines_all
3739: where line_id in
3740: (select old_line_id from oe_upgrade_log_v
3741: where new_line_id in
3742: (select line_id from oe_order_lines_all
3743: where line_set_id is null)))
3744: order by header_id, line_id;
3748: line_id,
3749: line_number
3750: from oe_order_lines_all oola
3751: where line_id in
3752: (select new_line_id from oe_upgrade_log oul, so_lines_all sla
3753: where oul.old_line_id = sla.line_id
3754: and sla.shipment_schedule_line_id = v_line_id)
3755: and item_type_code in ('KIT','MODEL','STANDARD')
3756: order by line_id;
3769: and parent_line_id is null -- To filter out options (included on Leena's instn.)
3770: and parent_line_id is null -- To filter out options (included on Leena's instn.)
3771: and sla.line_id in
3772: (select lg.old_line_id
3773: from oe_upgrade_log_v lg, oe_order_lines_all ln
3774: where lg.new_line_id = ln.line_id
3775: and ln.item_type_code not in ('INCLUDED','CONFIG')
3776: group by lg.old_line_id
3777: having count(*) > 1);
3779: cursor c7 is
3780: select
3781: new_line_id line_id,
3782: new_line_number line_number
3783: from oe_upgrade_log
3784: where old_line_id = v_line_id
3785: and old_line_id is not null;
3786: v_ctr number;
3787: p_line_number number;
3995: for c2 in c1 loop
3996: begin
3997: select oul2.new_line_id into v_new_line_id
3998: from
3999: oe_upgrade_log_v oul1,
4000: oe_upgrade_log_v oul2,
4001: so_lines_all sla1,
4002: so_lines_all sla2
4003: where oul1.new_line_id = c2.line_id
3996: begin
3997: select oul2.new_line_id into v_new_line_id
3998: from
3999: oe_upgrade_log_v oul1,
4000: oe_upgrade_log_v oul2,
4001: so_lines_all sla1,
4002: so_lines_all sla2
4003: where oul1.new_line_id = c2.line_id
4004: and oul1.old_line_id = sla1.line_id
4868: /* bring old_line_id from log table using the L_Line_id as the new_line_id */
4869:
4870: G_OLD_LINE_ID := 0;
4871: begin
4872: select max(old_line_id) into G_OLD_LINE_ID from oe_upgrade_log_v
4873: where new_line_id = p_orig_line_id;
4874: exception
4875: when others then
4876: G_OLD_LINE_ID := 0;
6252: and l1.upgraded_flag in ('Y','P')
6253: and nvl(l1.open_flag,'-') = 'Y'
6254: and l1.line_id not in (
6255: Select u.new_line_id
6256: from oe_upgrade_log u
6257: where u.module = 'RI') ;
6258: begin
6259:
6260: For l_rec in C1 LOOP
6268:
6269: Insert_Return_Included_Items(l_line_id,'Process_Returns');
6270:
6271: -- Insert the header_id,line_id entry into the upgrade Log
6272: insert into oe_upgrade_log(header_id,new_line_id,creation_date, module)
6273: values (l_header_id,l_line_id,sysdate, 'RI');
6274:
6275: exception
6276: when others then
6328: and l2.ato_line_id = l2.line_id
6329: and l1.upgraded_flag in ('Y','P')
6330: and l1.line_id not in(
6331: Select new_line_id
6332: from oe_upgrade_log u
6333: where u.module = 'RA');
6334: l_line_rec OE_Order_PUB.Line_Rec_Type;
6335: l_line_rec2 OE_Order_PUB.Line_Rec_Type;
6336: BEGIN
6390: Insert_Row(l_line_rec2,l_line_id,'Y','N');
6391:
6392:
6393: -- Insert the header_id,line_id entry into the upgrade Log
6394: insert into oe_upgrade_log(header_id,new_line_id,creation_date, module)
6395: values (l_header_id,l_line_id,sysdate, l_rec.item_type);
6396:
6397: exception
6398: when others then