[Home] [Help]
92: end if;
93:
94: x_return_status := FND_API.G_RET_STS_SUCCESS;
95:
96: l_request_rec := oe_delayed_requests_pvt.g_delayed_requests(p_index);
97:
98: IF l_request_rec.request_type = 'CREATE_MODIFIER_LIST' THEN
99:
100: l_blanket_header_id := l_request_rec.entity_id;
181: -- Loop over the requests table, identify blanket lines where discounts
182: -- were entered inline and add to modifier lines table.
183: -------------------------------------------------------------------
184:
185: I := oe_delayed_requests_pvt.g_delayed_requests.first;
186: J := 1;
187:
188: WHILE I IS NOT NULL LOOP
189:
186: J := 1;
187:
188: WHILE I IS NOT NULL LOOP
189:
190: l_request_rec := oe_delayed_requests_pvt.g_delayed_requests(I);
191: oe_debug_pub.add('Req Type :'||l_request_rec.request_type);
192:
193: IF l_request_rec.request_type = 'ADD_MODIFIER_LIST_LINE' THEN
194:
202: IF l_debug_level > 0
203: THEN
204: oe_debug_pub.add('Skip for null values');
205: END IF;
206: oe_delayed_requests_pvt.g_delayed_requests.delete(I);
207: GOTO SKIP_LINE;
208: END IF;
209: --end bug 3229225
210: -- simple discount line
265:
266: END IF;
267: --for bug 3229225
268: <
269: I := oe_delayed_requests_pvt.g_delayed_requests.next(I);
270:
271: END LOOP;
272:
273:
392: from oe_blanket_headers_all
393: where header_id = l_blanket_header_id
394: and org_id = mo_global.get_current_org_id);
395:
396: oe_delayed_requests_pvt.g_delayed_requests.delete(l_hdr_req_index);
397: oe_blanket_util.g_header_rec.new_modifier_list_id := l_x_modifier_list_rec.list_header_id;
398:
399: END IF;
400:
416: update oe_blanket_lines_ext
417: set modifier_list_line_id = l_x_modifiers_tbl(I).list_line_id
418: where line_id = l_line_id_tbl(I);
419:
420: oe_delayed_requests_pvt.g_delayed_requests.delete
421: (l_line_req_index_tbl(I));
422:
423: I := l_line_id_tbl.NEXT(I);
424: