[Home] [Help]
1934: ,x_top_model_tbl IN OUT NOCOPY Top_Model_Tbl_Type
1935: )
1936: IS
1937: l_top_model_index NUMBER;
1938: l_line_id OE_Order_LINES.Line_id%Type;
1939: l_cpy_category VARCHAR2(30);
1940: l_line_category VARCHAR2(30);
1941: l_line_rec OE_Order_PUB.Line_Rec_Type;
1942:
2707: -- Set foreign keys
2708: p_x_line_tbl(k).header_id := FND_API.G_MISS_NUM;
2709:
2710: -- Pre-populate the line_id to load G_Line_Num_Rec
2711: SELECT OE_ORDER_LINES_S.NEXTVAL
2712: INTO p_x_line_tbl(k).line_id
2713: FROM dual;
2714: G_Line_Num_Rec.new_line_id(J) := p_x_line_tbl(k).line_id;
2715: IF l_debug_level > 0 THEN
3529: IN ('CREDIT_CARD','ACH','DIRECT_DEBIT','CASH','CHECK','WIRE_TRANSFER') THEN
3530:
3531: Select oit.customer_id, ooh.invoice_to_org_id
3532: Into l_invoice_to_cust_id, l_invoice_to_org_id
3533: From oe_order_lines_all ooh,Oe_invoice_to_orgs_v oit
3534: Where ooh.line_id = x_line_payment_tbl(I).line_id
3535: And oit.organization_id = ooh.invoice_to_org_id;
3536:
3537: -- need to create a new trxn extension id and populate
3931: BEGIN
3932:
3933: Select header_id
3934: Into l_line_header_id
3935: From oe_order_lines
3936: Where line_id = l_line_id;
3937:
3938: EXCEPTION
3939:
4832: item_type_code,
4833: service_reference_line_id,
4834: link_to_line_id,
4835: top_model_line_id --9534576
4836: FROM oe_order_lines
4837: WHERE header_id = p_header_id
4838: ORDER BY line_number , shipment_number ,NVL(option_number, -1),
4839: NVL(component_number,-1),NVL(service_number,-1);
4840: l_split_by VARCHAR2(30);
5276: IF l_debug_level > 0 THEN
5277: oe_debug_pub.add( 'UPDATE ORDER LINES IN BULK' , 1 ) ;
5278: END IF;
5279: FORALL i in 1..K
5280: UPDATE OE_ORDER_LINES
5281: SET line_number = l_copied_rec.line_number(i)
5282: , shipment_number = l_copied_rec.shipment_number(i)
5283: , option_number = l_copied_rec.option_number(i)
5284: , component_number = l_copied_rec.component_number(i)
5359: , FND_GLOBAL.USER_ID
5360: , sysdate
5361: , sysdate
5362: , 1001
5363: FROM OE_ORDER_LINES l
5364: WHERE line_id = p_src_line_id;
5365:
5366: END Create_Line_Set;
5367:
5464: 'Y',
5465: l.top_model_line_id,
5466: l.item_type_code
5467: FROM
5468: oe_order_lines_history l
5469: WHERE l.line_id = l_line_id(i)
5470: --and l.version_number = NVL(p_version_number,l.version_number) -- bug 7443507
5471: and l.version_number = p_version_number -- bug 7443507
5472: and l.phase_change_flag = 'Y';
5501: 'Y',
5502: l.top_model_line_id,
5503: l.item_type_code
5504: FROM
5505: oe_order_lines_history l
5506: WHERE l.line_id = l_line_id(i)
5507: and l.phase_change_flag = 'Y';
5508:
5509: -- bug 7443507 new code ends.
5549: 'Y',
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
5587: 'Y',
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')
5627: l.service_number,
5628: l.top_model_line_id,
5629: l.item_type_code
5630: FROM
5631: oe_order_lines l,
5632: oe_order_headers h
5633: WHERE l.line_id = l_line_id(i)
5634: and l.header_id = h.header_id
5635: --and h.version_number = NVL(p_version_number,h.version_number) -- bug 7443507
5646: l.service_number,
5647: l.top_model_line_id,
5648: l.item_type_code
5649: FROM
5650: oe_order_lines_history l
5651: WHERE l.line_id = l_line_id(i)
5652: --and l.version_number = NVL(p_version_number,-1) --bug 7443507
5653: and l.version_number = p_version_number -- bug 7443507
5654: and l.version_flag = 'Y';
5680: l.service_number,
5681: l.top_model_line_id,
5682: l.item_type_code
5683: FROM
5684: oe_order_lines l,
5685: oe_order_headers h
5686: WHERE l.line_id = l_line_id(i)
5687: and l.header_id = h.header_id;
5688:
5730: l.service_number,
5731: l.top_model_line_id,
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
5753: l.service_number,
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
5790: l.service_number,
5791: l.top_model_line_id,
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
6021: -- Cursor for finding all lines belonging to a particular ship set from source order.
6022: CURSOR line_cur_ship(p_set_id IN NUMBER)
6023: IS
6024: SELECT l.line_id
6025: FROM oe_order_lines_all l
6026: WHERE l.ship_set_id = p_set_id;
6027:
6028: -- Cursor for finding all lines belonging to a particular arrival set from source order.
6029: CURSOR line_cur_arrival(p_set_id IN NUMBER)
6028: -- Cursor for finding all lines belonging to a particular arrival set from source order.
6029: CURSOR line_cur_arrival(p_set_id IN NUMBER)
6030: IS
6031: SELECT l.line_id
6032: FROM oe_order_lines_all l
6033: WHERE l.arrival_set_id = p_set_id;
6034:
6035: -- Cursor for finding all lines belonging to a particular fulfillment set from source order.
6036: CURSOR line_cur_fulfill(p_set_id IN NUMBER)
6035: -- Cursor for finding all lines belonging to a particular fulfillment set from source order.
6036: CURSOR line_cur_fulfill(p_set_id IN NUMBER)
6037: IS
6038: SELECT l.line_id
6039: FROM oe_order_lines_all l,
6040: oe_line_sets ols
6041: WHERE l.line_id = ols.line_id
6042: AND l.header_id = p_old_header_id
6043: AND ols.set_id = p_set_id;