[Home] [Help]
5229: l_source T_V1 := T_V1();
5230: l_line_rec OE_Order_PUB.Line_Rec_Type;
5231: CURSOR C_MODEL IS
5232: SELECT line_id
5233: FROM OE_COPY_LINE_SORT_TMP
5234: WHERE top_model_line_id = line_id;
5235:
5236: BEGIN
5237: IF l_debug_level > 0 THEN
5267:
5268: IF p_version_number IS NOT NULL THEN --bug 7443507
5269:
5270: FORALL i IN 1..l_line_id.COUNT
5271: INSERT INTO OE_COPY_LINE_SORT_TMP(
5272: line_id,
5273: version_number,
5274: header_id,
5275: line_number,
5304:
5305: FORALL i IN 1..l_line_id.COUNT
5306:
5307: -- bug 7443507 new code added
5308: INSERT INTO OE_COPY_LINE_SORT_TMP(
5309: line_id,
5310: version_number,
5311: header_id,
5312: line_number,
5340:
5341: -- For line level copy, we are exploding the full config if
5342: -- top model line has been selected for copy.
5343: IF G_NEED_TO_EXPLODE_CONFIG THEN
5344: DELETE FROM OE_COPY_LINE_SORT_TMP a
5345: WHERE a.top_model_line_id is NOT NULL
5346: AND a.line_id <> a.top_model_line_id
5347: AND EXISTS (select b.line_id
5348: from OE_COPY_LINE_SORT_TMP b
5344: DELETE FROM OE_COPY_LINE_SORT_TMP a
5345: WHERE a.top_model_line_id is NOT NULL
5346: AND a.line_id <> a.top_model_line_id
5347: AND EXISTS (select b.line_id
5348: from OE_COPY_LINE_SORT_TMP b
5349: WHERE b.line_id = a.top_model_line_id);
5350:
5351: -- Select records for Model Line, get all child lines except
5352: -- for CONFIG item and INCLUDED items as we do not copy them.
5352: -- for CONFIG item and INCLUDED items as we do not copy them.
5353:
5354: IF p_version_number IS NOT NULL THEN -- bug 7443507
5355:
5356: INSERT INTO OE_COPY_LINE_SORT_TMP(
5357: line_id,
5358: version_number,
5359: header_id,
5360: line_number,
5379: l.top_model_line_id,
5380: l.item_type_code
5381: FROM
5382: oe_order_lines_history l,
5383: oe_copy_line_sort_tmp c
5384: WHERE c.line_id = c.top_model_line_id
5385: and l.top_model_line_id = c.line_id
5386: --and l.line_id <> l.top_model_line_id -- bug 7443507
5387: and l.item_type_code not in ('CONFIG','INCLUDED','MODEL','KIT') -- bug 7443507
5390: and l.phase_change_flag = 'Y';
5391:
5392: ELSE --bug 7443507
5393: -- bug 7443507 new code added
5394: INSERT INTO OE_COPY_LINE_SORT_TMP(
5395: line_id,
5396: version_number,
5397: header_id,
5398: line_number,
5417: l.top_model_line_id,
5418: l.item_type_code
5419: FROM
5420: oe_order_lines_history l,
5421: oe_copy_line_sort_tmp c
5422: WHERE c.line_id = c.top_model_line_id
5423: and l.top_model_line_id = c.line_id
5424: and l.item_type_code not in ('CONFIG','INCLUDED','MODEL','KIT')
5425: and l.phase_change_flag = 'Y';
5432:
5433: IF p_version_number IS NOT NULL THEN -- bug 7443507
5434:
5435: FORALL i IN 1..l_line_id.COUNT
5436: INSERT INTO OE_COPY_LINE_SORT_TMP(
5437: line_id,
5438: version_number,
5439: header_id,
5440: line_number,
5485: ELSE --bug 7443507
5486:
5487: FORALL i IN 1..l_line_id.COUNT
5488: --bug 7443507 new code added
5489: INSERT INTO OE_COPY_LINE_SORT_TMP(
5490: line_id,
5491: version_number,
5492: header_id,
5493: line_number,
5523: -- top model line has been selected for copy.
5524:
5525: IF G_NEED_TO_EXPLODE_CONFIG THEN
5526:
5527: DELETE FROM OE_COPY_LINE_SORT_TMP a
5528: WHERE a.top_model_line_id is NOT NULL
5529: AND a.line_id <> a.top_model_line_id
5530: AND EXISTS (select b.line_id
5531: from OE_COPY_LINE_SORT_TMP b
5527: DELETE FROM OE_COPY_LINE_SORT_TMP a
5528: WHERE a.top_model_line_id is NOT NULL
5529: AND a.line_id <> a.top_model_line_id
5530: AND EXISTS (select b.line_id
5531: from OE_COPY_LINE_SORT_TMP b
5532: WHERE b.line_id = a.top_model_line_id);
5533:
5534: -- Select records for Model Line, get all child lines except
5535: -- for CONFIG item and INCLUDED items as we do not copy them.
5535: -- for CONFIG item and INCLUDED items as we do not copy them.
5536:
5537: IF p_version_number IS NOT NULL THEN -- bug 7443507
5538:
5539: INSERT INTO OE_COPY_LINE_SORT_TMP(
5540: line_id,
5541: version_number,
5542: header_id,
5543: line_number,
5561: l.item_type_code
5562: FROM
5563: oe_order_lines l,
5564: oe_order_headers h,
5565: oe_copy_line_sort_tmp c
5566: WHERE c.line_id = c.top_model_line_id
5567: and l.top_model_line_id = c.line_id
5568: --and l.line_id <> l.top_model_line_id --bug 7443507
5569: and l.item_type_code not in ('CONFIG','INCLUDED','MODEL','KIT') --bug 7443507
5583: l.top_model_line_id,
5584: l.item_type_code
5585: FROM
5586: oe_order_lines_history l,
5587: oe_copy_line_sort_tmp c
5588: WHERE c.line_id = c.top_model_line_id
5589: and l.top_model_line_id = c.line_id
5590: --and l.line_id <> l.top_model_line_id -- bug 7443507
5591: and l.item_type_code not in ('CONFIG','INCLUDED','MODEL','KIT') -- bug 7443507
5595:
5596: ELSE --bug 7443507
5597: --bug 7443507 new code added
5598:
5599: INSERT INTO OE_COPY_LINE_SORT_TMP(
5600: line_id,
5601: version_number,
5602: header_id,
5603: line_number,
5621: l.item_type_code
5622: FROM
5623: oe_order_lines l,
5624: oe_order_headers h,
5625: oe_copy_line_sort_tmp c
5626: WHERE c.line_id = c.top_model_line_id
5627: and l.top_model_line_id = c.line_id
5628: and l.item_type_code not in ('CONFIG','INCLUDED','MODEL','KIT')
5629: and l.header_id = h.header_id;
5645:
5646: SELECT line_id
5647: BULK COLLECT INTO
5648: l_line_id
5649: FROM OE_COPY_LINE_SORT_TMP
5650: ORDER BY header_id, line_number, shipment_number, NVL(option_number, -1),
5651: NVL(component_number,-1),NVL(service_number,-1);
5652:
5653: -- Populate the full line record by calling the oe_line_util.query_row