[Home] [Help]
9: -- of a split, then use split_from_line_id in the call to the cursor.
10: -- 04/20/2007 inanaiah fixed bug 5975678 - handled creation/update of ozf_order_group_prod records for Splits
11: -- 05/10/2007 nirprasa fixed bug 6021635 - changed cursor c_offer_id_om for backdated adjustments created for booked orders.
12: -- 05/14/2007 kdass fixed bug 6008340
13: -- 06/22/2007 nirprasa fixed bug 6140749 - changed OE_ORDER_LINES to OE_ORDER_LINES_ALL
14: -- 09/19/2008 nirprasa fixed bug 6998502 - VOLUME OFFERS ARE NOT APPLIED CORRECTLY ON A SALES ORDER
15: -- 09/19/2008 nirprasa fixed bug 7353241 - VOLUME OFFER CALCULATIONS INCORRECT FOR SINGLE UNIT ACCRUALS
16: -- 11/24/2008 nirprasa fixed bug 7030415 - R12SIP WE CAN'T SETUP CURRENY CONVERSION TYPE FOR SPECIFIC OPERATING UNIT
17: ------------------------------------------------------------------------------
87: --kdass fixed bug 6008340
88: l_group_prod_order_line_id := p_order_line_id;
89:
90: IF x_indirect_flag = 'O' THEN
91: select split_from_line_id into l_split_from_line_id from OE_ORDER_LINES_ALL where line_id = p_order_line_id;
92: IF (l_split_from_line_id IS NOT NULL) THEN
93: l_group_prod_order_line_id := l_split_from_line_id;
94: END IF;
95: END IF;
199: WHERE offer_id = p_offer_id;
200:
201: CURSOR c_order_line_type(p_line_id NUMBER) IS
202: SELECT reference_header_id, reference_line_id, line_category_code, return_context, return_attribute1, return_attribute2
203: FROM oe_order_lines_all
204: WHERE line_id = p_line_id;
205: l_order_line_type c_order_line_type%ROWTYPE;
206:
207: CURSOR c_rma_ref_line_detail(p_offer_id NUMBER, p_line_id NUMBER, p_indirect_flag VARCHAR2) IS
309: FETCH c_group_prod INTO l_group_no, l_volume_track_type, l_combine_schedule_yn, l_pbh_line_id, l_volume_type, l_include_volume;
310: CLOSE c_group_prod;
311:
312: IF p_indirect_flag = 'O' THEN
313: select split_from_line_id into l_split_from_line_id from OE_ORDER_LINES_ALL where line_id = p_volume_detail_rec.line_id;
314: IF (l_split_from_line_id IS NOT NULL) THEN
315: ozf_utility_pvt.write_conc_log('split_from_line_id: ' || l_split_from_line_id);
316: OPEN c_group_prod(p_offer_id, l_split_from_line_id, p_indirect_flag);
317: FETCH c_group_prod INTO l_group_no, l_volume_track_type, l_combine_schedule_yn, l_pbh_line_id, l_volume_type, l_include_volume;
1428: FETCH c_combine_schedule INTO l_offer_id, l_combine_schedule, l_apply_discount, l_group_no, l_volume_track_type, l_pbh_line_id;
1429: CLOSE c_combine_schedule;
1430:
1431: IF p_source_code = 'OM' THEN
1432: SELECT split_from_line_id into l_split_from_line_id from OE_ORDER_LINES_ALL where line_id = p_order_line_id;
1433: IF (l_split_from_line_id IS NOT NULL) then
1434: OPEN c_combine_schedule(p_qp_list_header_id, l_split_from_line_id);
1435: FETCH c_combine_schedule INTO l_offer_id, l_combine_schedule, l_apply_discount, l_group_no, l_volume_track_type, l_pbh_line_id;
1436: CLOSE c_combine_schedule;
1522: AND q.list_line_id = p_list_line_id;
1523:
1524: CURSOR c_order_detail IS
1525: SELECT unit_selling_price, pricing_quantity, sold_to_org_id, ship_to_org_id, invoice_to_org_id, actual_shipment_date
1526: FROM oe_order_lines_all
1527: WHERE line_id = p_order_line_id;
1528:
1529: CURSOR c_resale_detail IS
1530: SELECT quantity, amount, sold_from_cust_account_id, sold_to_cust_account_id, ship_to_site_use_id, bill_to_site_use_id, transaction_date
1683: --kdass fixed bug 6008340
1684: l_group_prod_order_line_id := p_order_line_id;
1685:
1686: IF l_indirect_flag = 'O' THEN
1687: select split_from_line_id into l_split_from_line_id from OE_ORDER_LINES_ALL where line_id = p_order_line_id;
1688: IF (l_split_from_line_id IS NOT NULL) THEN
1689: --l_group_prod_order_line_id := l_split_from_line_id;
1690: -- inanaiah: Added for bug 5975678 fix
1691: IF (p_order_line_id = l_split_from_line_id) THEN