[Home] [Help]
89: end if;
90:
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: l_request_rec := oe_delayed_requests_pvt.g_delayed_requests(p_index);
94:
95: IF l_request_rec.request_type = 'CREATE_MODIFIER_LIST' THEN
96:
97: l_blanket_header_id := l_request_rec.entity_id;
160: -- Loop over the requests table, identify blanket lines where discounts
161: -- were entered inline and add to modifier lines table.
162: -------------------------------------------------------------------
163:
164: I := oe_delayed_requests_pvt.g_delayed_requests.first;
165: J := 1;
166:
167: WHILE I IS NOT NULL LOOP
168:
165: J := 1;
166:
167: WHILE I IS NOT NULL LOOP
168:
169: l_request_rec := oe_delayed_requests_pvt.g_delayed_requests(I);
170: oe_debug_pub.add('Req Type :'||l_request_rec.request_type);
171:
172: IF l_request_rec.request_type = 'ADD_MODIFIER_LIST_LINE' THEN
173:
181: IF l_debug_level > 0
182: THEN
183: oe_debug_pub.add('Skip for null values');
184: END IF;
185: oe_delayed_requests_pvt.g_delayed_requests.delete(I);
186: GOTO SKIP_LINE;
187: END IF;
188: --end bug 3229225
189: -- simple discount line
244:
245: END IF;
246: --for bug 3229225
247: <
248: I := oe_delayed_requests_pvt.g_delayed_requests.next(I);
249:
250: END LOOP;
251:
252:
371: from oe_blanket_headers_all
372: where header_id = l_blanket_header_id
373: and org_id = mo_global.get_current_org_id);
374:
375: oe_delayed_requests_pvt.g_delayed_requests.delete(l_hdr_req_index);
376: oe_blanket_util.g_header_rec.new_modifier_list_id := l_x_modifier_list_rec.list_header_id;
377:
378: END IF;
379:
395: update oe_blanket_lines_ext
396: set modifier_list_line_id = l_x_modifiers_tbl(I).list_line_id
397: where line_id = l_line_id_tbl(I);
398:
399: oe_delayed_requests_pvt.g_delayed_requests.delete
400: (l_line_req_index_tbl(I));
401:
402: I := l_line_id_tbl.NEXT(I);
403: