[Home] [Help]
5400: l_source T_V1 := T_V1();
5401: l_line_rec OE_Order_PUB.Line_Rec_Type;
5402: CURSOR C_MODEL IS
5403: SELECT line_id
5404: FROM OE_COPY_LINE_SORT_TMP
5405: WHERE top_model_line_id = line_id;
5406:
5407: BEGIN
5408: IF l_debug_level > 0 THEN
5438:
5439: IF p_version_number IS NOT NULL THEN --bug 7443507
5440:
5441: FORALL i IN 1..l_line_id.COUNT
5442: INSERT INTO OE_COPY_LINE_SORT_TMP(
5443: line_id,
5444: version_number,
5445: header_id,
5446: line_number,
5475:
5476: FORALL i IN 1..l_line_id.COUNT
5477:
5478: -- bug 7443507 new code added
5479: INSERT INTO OE_COPY_LINE_SORT_TMP(
5480: line_id,
5481: version_number,
5482: header_id,
5483: line_number,
5511:
5512: -- For line level copy, we are exploding the full config if
5513: -- top model line has been selected for copy.
5514: IF G_NEED_TO_EXPLODE_CONFIG THEN
5515: DELETE FROM OE_COPY_LINE_SORT_TMP a
5516: WHERE a.top_model_line_id is NOT NULL
5517: AND a.line_id <> a.top_model_line_id
5518: AND EXISTS (select b.line_id
5519: from OE_COPY_LINE_SORT_TMP b
5515: DELETE FROM OE_COPY_LINE_SORT_TMP a
5516: WHERE a.top_model_line_id is NOT NULL
5517: AND a.line_id <> a.top_model_line_id
5518: AND EXISTS (select b.line_id
5519: from OE_COPY_LINE_SORT_TMP b
5520: WHERE b.line_id = a.top_model_line_id);
5521:
5522: -- Select records for Model Line, get all child lines except
5523: -- for CONFIG item and INCLUDED items as we do not copy them.
5523: -- for CONFIG item and INCLUDED items as we do not copy them.
5524:
5525: IF p_version_number IS NOT NULL THEN -- bug 7443507
5526:
5527: INSERT INTO OE_COPY_LINE_SORT_TMP(
5528: line_id,
5529: version_number,
5530: header_id,
5531: line_number,
5550: l.top_model_line_id,
5551: l.item_type_code
5552: FROM
5553: oe_order_lines_history l,
5554: oe_copy_line_sort_tmp c
5555: WHERE c.line_id = c.top_model_line_id
5556: and l.top_model_line_id = c.line_id
5557: --and l.line_id <> l.top_model_line_id -- bug 7443507
5558: and l.item_type_code not in ('CONFIG','INCLUDED','MODEL','KIT') -- bug 7443507
5561: and l.phase_change_flag = 'Y';
5562:
5563: ELSE --bug 7443507
5564: -- bug 7443507 new code added
5565: INSERT INTO OE_COPY_LINE_SORT_TMP(
5566: line_id,
5567: version_number,
5568: header_id,
5569: line_number,
5588: l.top_model_line_id,
5589: l.item_type_code
5590: FROM
5591: oe_order_lines_history l,
5592: oe_copy_line_sort_tmp c
5593: WHERE c.line_id = c.top_model_line_id
5594: and l.top_model_line_id = c.line_id
5595: and l.item_type_code not in ('CONFIG','INCLUDED','MODEL','KIT')
5596: and l.phase_change_flag = 'Y';
5603:
5604: IF p_version_number IS NOT NULL THEN -- bug 7443507
5605:
5606: FORALL i IN 1..l_line_id.COUNT
5607: INSERT INTO OE_COPY_LINE_SORT_TMP(
5608: line_id,
5609: version_number,
5610: header_id,
5611: line_number,
5656: ELSE --bug 7443507
5657:
5658: FORALL i IN 1..l_line_id.COUNT
5659: --bug 7443507 new code added
5660: INSERT INTO OE_COPY_LINE_SORT_TMP(
5661: line_id,
5662: version_number,
5663: header_id,
5664: line_number,
5694: -- top model line has been selected for copy.
5695:
5696: IF G_NEED_TO_EXPLODE_CONFIG THEN
5697:
5698: DELETE FROM OE_COPY_LINE_SORT_TMP a
5699: WHERE a.top_model_line_id is NOT NULL
5700: AND a.line_id <> a.top_model_line_id
5701: AND EXISTS (select b.line_id
5702: from OE_COPY_LINE_SORT_TMP b
5698: DELETE FROM OE_COPY_LINE_SORT_TMP a
5699: WHERE a.top_model_line_id is NOT NULL
5700: AND a.line_id <> a.top_model_line_id
5701: AND EXISTS (select b.line_id
5702: from OE_COPY_LINE_SORT_TMP b
5703: WHERE b.line_id = a.top_model_line_id);
5704:
5705: -- Select records for Model Line, get all child lines except
5706: -- for CONFIG item and INCLUDED items as we do not copy them.
5706: -- for CONFIG item and INCLUDED items as we do not copy them.
5707:
5708: IF p_version_number IS NOT NULL THEN -- bug 7443507
5709:
5710: INSERT INTO OE_COPY_LINE_SORT_TMP(
5711: line_id,
5712: version_number,
5713: header_id,
5714: line_number,
5732: l.item_type_code
5733: FROM
5734: oe_order_lines l,
5735: oe_order_headers h,
5736: oe_copy_line_sort_tmp c
5737: WHERE c.line_id = c.top_model_line_id
5738: and l.top_model_line_id = c.line_id
5739: --and l.line_id <> l.top_model_line_id --bug 7443507
5740: and l.item_type_code not in ('CONFIG','INCLUDED','MODEL','KIT') --bug 7443507
5754: l.top_model_line_id,
5755: l.item_type_code
5756: FROM
5757: oe_order_lines_history l,
5758: oe_copy_line_sort_tmp c
5759: WHERE c.line_id = c.top_model_line_id
5760: and l.top_model_line_id = c.line_id
5761: --and l.line_id <> l.top_model_line_id -- bug 7443507
5762: and l.item_type_code not in ('CONFIG','INCLUDED','MODEL','KIT') -- bug 7443507
5766:
5767: ELSE --bug 7443507
5768: --bug 7443507 new code added
5769:
5770: INSERT INTO OE_COPY_LINE_SORT_TMP(
5771: line_id,
5772: version_number,
5773: header_id,
5774: line_number,
5792: l.item_type_code
5793: FROM
5794: oe_order_lines l,
5795: oe_order_headers h,
5796: oe_copy_line_sort_tmp c
5797: WHERE c.line_id = c.top_model_line_id
5798: and l.top_model_line_id = c.line_id
5799: and l.item_type_code not in ('CONFIG','INCLUDED','MODEL','KIT')
5800: and l.header_id = h.header_id;
5816:
5817: SELECT line_id
5818: BULK COLLECT INTO
5819: l_line_id
5820: FROM OE_COPY_LINE_SORT_TMP
5821: ORDER BY header_id, line_number, shipment_number, NVL(option_number, -1),
5822: NVL(component_number,-1),NVL(service_number,-1);
5823:
5824: -- Populate the full line record by calling the oe_line_util.query_row