[Home] [Help]
110: l_modifier_list_rec.orig_system_header_ref := l_blanket_header_id;
111: l_modifier_list_rec.list_source_code := 'BSO';
112: l_modifier_list_rec.shareable_flag := 'N';
113: --Add MOAC changes
114: l_modifier_list_rec.org_id := mo_global.get_current_org_id;
115: l_modifier_list_rec.global_flag := 'N';
116: -- Bug 3210361 -
117: -- Blanket modifiers were not being applied
118: l_modifier_list_rec.start_date_active := trunc(sysdate);
165: INTO l_modifier_list_id
166: FROM oe_blanket_headers_ext he, oe_blanket_headers_all h
167: WHERE h.header_id = l_blanket_header_id
168: AND he.order_number = h.order_number
169: AND h.org_id = mo_global.get_current_org_id;
170:
171: -- If there is no new modifier list at header level, this should
172: -- have been caught in entity validation hence raise unexp error.
173: IF l_modifier_list_id IS NULL THEN
390: set new_modifier_list_id = l_x_modifier_list_rec.list_header_id
391: where order_number = (select /* MOAC_SQL_CHANGE */ order_number
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:
760: select /* MOAC_SQL_CHANGE */ header_id
761: into l_blanket_header_id
762: from oe_blanket_headers_all
763: where order_number = p_blanket_number
764: and org_id = mo_global.get_current_org_id;
765: END IF;
766:
767: if l_debug_level > 0 then
768: oe_debug_pub.add('Return Get_Blanket_Header_ID :'||l_blanket_header_id);
935: ,l_blanket_header_id
936: from oe_blanket_headers_ext bhe, oe_blanket_headers_all bh
937: where bhe.order_number = p_blanket_number
938: and bhe.order_number = bh.order_number
939: and bh.org_id = mo_global.get_current_orG_id;
940: oe_debug_pub.add('current blkt rel amt :'||l_released_amount);
941: oe_debug_pub.add('current blkt ret amt :'||l_returned_amount);
942:
943: l_blanket_header_id := MOD(l_blanket_header_id,G_BINARY_LIMIT);--bug8465849