DBA Data[Home] [Help]

APPS.OE_BLANKET_UTIL dependencies on MO_GLOBAL

Line 445: gpr_price_list_rec.org_id := mo_global.get_current_org_id;

441: --11i10 Pricing Changes End
442:
443: gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_CREATE;
444: --MOAC changes to force the PL tobe created in a ORG
445: gpr_price_list_rec.org_id := mo_global.get_current_org_id;
446: gpr_price_list_rec.global_flag := 'N';
447: lheader_id := oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;
448:
449: I := oe_delayed_requests_pvt.g_delayed_requests.first;

Line 3676: OR orig_org_id = mo_global.get_current_org_id)

3672: FROM qp_list_headers_vl
3673: WHERE list_type_code in ('PRL' ,'AGR')
3674: AND p_header_rec.price_list_name = name
3675: AND (((nvl(global_flag,'Y') = 'Y'
3676: OR orig_org_id = mo_global.get_current_org_id)
3677: AND qp_security.security_on = 'Y') or qp_security.security_on = 'N');
3678: -- END
3679: EXCEPTION
3680: WHEN NO_DATA_FOUND THEN

Line 4395: , mo_global.get_current_org_id

4391: , 'N'
4392: , p_header_rec.version_number
4393: , p_header_rec.shipping_instructions
4394: , p_header_rec.packing_instructions
4395: , mo_global.get_current_org_id
4396: , 'B'
4397: , 'ORDER'
4398: , p_header_rec.source_document_type_id
4399: , p_header_rec.source_document_id

Line 4949: , MO_GLOBAL.GET_CURRENT_ORG_ID

4945: , p_line_rec.last_update_login
4946: , p_line_rec.line_id
4947: , p_line_rec.line_type_id
4948: , p_line_rec.line_number
4949: , MO_GLOBAL.GET_CURRENT_ORG_ID
4950: , p_line_rec.payment_term_id
4951: , p_line_rec.preferred_grade --OPM 02/JUN/00
4952: , p_line_rec.price_list_id
4953: , p_line_rec.program_application_id

Line 6532: AND ORG_ID = MO_GLOBAL.get_current_org_id

6528: SELECT /* MOAC_SQL_CHANGE */ bh.lock_control
6529: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_HEADERS_EXT BHX
6530: WHERE BH.ORDER_NUMBER = BHX.ORDER_NUMBER
6531: AND BH.ORDER_NUMBER = p_blanket_id
6532: AND ORG_ID = MO_GLOBAL.get_current_org_id
6533: AND BH.SALES_DOCUMENT_TYPE_CODE = 'B'
6534: FOR UPDATE NOWAIT;
6535:
6536: CURSOR c_blanket_lines IS

Line 6541: AND BL.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID

6537: SELECT /* MOAC_SQL_CHANGE */ bl.line_id, bl.lock_control
6538: FROM OE_BLANKET_LINES_ALL BL, OE_BLANKET_LINES_EXT BLX
6539: WHERE BL.LINE_ID = BLX.LINE_ID
6540: AND BLX.ORDER_NUMBER = l_blanket_id
6541: AND BL.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID
6542: AND BL.SALES_DOCUMENT_TYPE_CODE = 'B'
6543: FOR UPDATE NOWAIT;
6544:
6545: --