[Home] [Help]
1824: ,x_top_model_tbl IN OUT NOCOPY Top_Model_Tbl_Type
1825: )
1826: IS
1827: l_top_model_index NUMBER;
1828: l_line_id OE_Order_LINES.Line_id%Type;
1829: l_cpy_category VARCHAR2(30);
1830: l_line_category VARCHAR2(30);
1831: l_line_rec OE_Order_PUB.Line_Rec_Type;
1832:
2588: -- Set foreign keys
2589: p_x_line_tbl(k).header_id := FND_API.G_MISS_NUM;
2590:
2591: -- Pre-populate the line_id to load G_Line_Num_Rec
2592: SELECT OE_ORDER_LINES_S.NEXTVAL
2593: INTO p_x_line_tbl(k).line_id
2594: FROM dual;
2595: G_Line_Num_Rec.new_line_id(J) := p_x_line_tbl(k).line_id;
2596: IF l_debug_level > 0 THEN
3379: IN ('CREDIT_CARD','ACH','DIRECT_DEBIT','CASH','CHECK','WIRE_TRANSFER') THEN
3380:
3381: Select oit.customer_id, ooh.invoice_to_org_id
3382: Into l_invoice_to_cust_id, l_invoice_to_org_id
3383: From oe_order_lines_all ooh,Oe_invoice_to_orgs_v oit
3384: Where ooh.line_id = x_line_payment_tbl(I).line_id
3385: And oit.organization_id = ooh.invoice_to_org_id;
3386:
3387: -- need to create a new trxn extension id and populate
3781: BEGIN
3782:
3783: Select header_id
3784: Into l_line_header_id
3785: From oe_order_lines
3786: Where line_id = l_line_id;
3787:
3788: EXCEPTION
3789:
4681: line_set_id,
4682: item_type_code,
4683: service_reference_line_id,
4684: link_to_line_id
4685: FROM oe_order_lines
4686: WHERE header_id = p_header_id
4687: ORDER BY line_number , shipment_number ,NVL(option_number, -1),
4688: NVL(component_number,-1),NVL(service_number,-1);
4689: l_split_by VARCHAR2(30);
5105: IF l_debug_level > 0 THEN
5106: oe_debug_pub.add( 'UPDATE ORDER LINES IN BULK' , 1 ) ;
5107: END IF;
5108: FORALL i in 1..K
5109: UPDATE OE_ORDER_LINES
5110: SET line_number = l_copied_rec.line_number(i)
5111: , shipment_number = l_copied_rec.shipment_number(i)
5112: , option_number = l_copied_rec.option_number(i)
5113: , component_number = l_copied_rec.component_number(i)
5188: , FND_GLOBAL.USER_ID
5189: , sysdate
5190: , sysdate
5191: , 1001
5192: FROM OE_ORDER_LINES l
5193: WHERE line_id = p_src_line_id;
5194:
5195: END Create_Line_Set;
5196:
5293: 'Y',
5294: l.top_model_line_id,
5295: l.item_type_code
5296: FROM
5297: oe_order_lines_history l
5298: WHERE l.line_id = l_line_id(i)
5299: --and l.version_number = NVL(p_version_number,l.version_number) -- bug 7443507
5300: and l.version_number = p_version_number -- bug 7443507
5301: and l.phase_change_flag = 'Y';
5330: 'Y',
5331: l.top_model_line_id,
5332: l.item_type_code
5333: FROM
5334: oe_order_lines_history l
5335: WHERE l.line_id = l_line_id(i)
5336: and l.phase_change_flag = 'Y';
5337:
5338: -- bug 7443507 new code ends.
5378: 'Y',
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
5416: 'Y',
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')
5456: l.service_number,
5457: l.top_model_line_id,
5458: l.item_type_code
5459: FROM
5460: oe_order_lines l,
5461: oe_order_headers h
5462: WHERE l.line_id = l_line_id(i)
5463: and l.header_id = h.header_id
5464: --and h.version_number = NVL(p_version_number,h.version_number) -- bug 7443507
5475: l.service_number,
5476: l.top_model_line_id,
5477: l.item_type_code
5478: FROM
5479: oe_order_lines_history l
5480: WHERE l.line_id = l_line_id(i)
5481: --and l.version_number = NVL(p_version_number,-1) --bug 7443507
5482: and l.version_number = p_version_number -- bug 7443507
5483: and l.version_flag = 'Y';
5509: l.service_number,
5510: l.top_model_line_id,
5511: l.item_type_code
5512: FROM
5513: oe_order_lines l,
5514: oe_order_headers h
5515: WHERE l.line_id = l_line_id(i)
5516: and l.header_id = h.header_id;
5517:
5559: l.service_number,
5560: l.top_model_line_id,
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
5582: l.service_number,
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
5619: l.service_number,
5620: l.top_model_line_id,
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
5829: -- Cursor for finding all lines belonging to a particular ship set from source order.
5830: CURSOR line_cur_ship(p_set_id IN NUMBER)
5831: IS
5832: SELECT l.line_id
5833: FROM oe_order_lines_all l
5834: WHERE l.ship_set_id = p_set_id;
5835:
5836: -- Cursor for finding all lines belonging to a particular arrival set from source order.
5837: CURSOR line_cur_arrival(p_set_id IN NUMBER)
5836: -- Cursor for finding all lines belonging to a particular arrival set from source order.
5837: CURSOR line_cur_arrival(p_set_id IN NUMBER)
5838: IS
5839: SELECT l.line_id
5840: FROM oe_order_lines_all l
5841: WHERE l.arrival_set_id = p_set_id;
5842:
5843: -- Cursor for finding all lines belonging to a particular fulfillment set from source order.
5844: CURSOR line_cur_fulfill(p_set_id IN NUMBER)
5843: -- Cursor for finding all lines belonging to a particular fulfillment set from source order.
5844: CURSOR line_cur_fulfill(p_set_id IN NUMBER)
5845: IS
5846: SELECT l.line_id
5847: FROM oe_order_lines_all l,
5848: oe_line_sets ols
5849: WHERE l.line_id = ols.line_id
5850: AND l.header_id = p_old_header_id
5851: AND ols.set_id = p_set_id;