DBA Data[Home] [Help]

APPS.OE_BLANKET_PRICING_UTIL dependencies on MO_GLOBAL

Line 111: l_modifier_list_rec.org_id := mo_global.get_current_org_id;

107: l_modifier_list_rec.orig_system_header_ref := l_blanket_header_id;
108: l_modifier_list_rec.list_source_code := 'BSO';
109: l_modifier_list_rec.shareable_flag := 'N';
110: --Add MOAC changes
111: l_modifier_list_rec.org_id := mo_global.get_current_org_id;
112: l_modifier_list_rec.global_flag := 'N';
113: -- Bug 3210361 -
114: -- Blanket modifiers were not being applied
115: l_modifier_list_rec.start_date_active := trunc(sysdate);

Line 148: AND h.org_id = mo_global.get_current_org_id;

144: INTO l_modifier_list_id
145: FROM oe_blanket_headers_ext he, oe_blanket_headers_all h
146: WHERE h.header_id = l_blanket_header_id
147: AND he.order_number = h.order_number
148: AND h.org_id = mo_global.get_current_org_id;
149:
150: -- If there is no new modifier list at header level, this should
151: -- have been caught in entity validation hence raise unexp error.
152: IF l_modifier_list_id IS NULL THEN

Line 373: and org_id = mo_global.get_current_org_id);

369: set new_modifier_list_id = l_x_modifier_list_rec.list_header_id
370: where order_number = (select /* MOAC_SQL_CHANGE */ order_number
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:

Line 743: and org_id = mo_global.get_current_org_id;

739: select /* MOAC_SQL_CHANGE */ header_id
740: into l_blanket_header_id
741: from oe_blanket_headers_all
742: where order_number = p_blanket_number
743: and org_id = mo_global.get_current_org_id;
744: END IF;
745:
746: if l_debug_level > 0 then
747: oe_debug_pub.add('Return Get_Blanket_Header_ID :'||l_blanket_header_id);

Line 918: and bh.org_id = mo_global.get_current_orG_id;

914: ,l_blanket_header_id
915: from oe_blanket_headers_ext bhe, oe_blanket_headers_all bh
916: where bhe.order_number = p_blanket_number
917: and bhe.order_number = bh.order_number
918: and bh.org_id = mo_global.get_current_orG_id;
919: oe_debug_pub.add('current blkt rel amt :'||l_released_amount);
920: oe_debug_pub.add('current blkt ret amt :'||l_returned_amount);
921:
922: IF nvl(p_transaction_phase_code,'F') = 'F' THEN