DBA Data[Home] [Help]

APPS.OE_BLANKET_UTIL dependencies on MO_GLOBAL

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

331: --11i10 Pricing Changes End
332:
333: gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_CREATE;
334: --MOAC changes to force the PL tobe created in a ORG
335: gpr_price_list_rec.org_id := mo_global.get_current_org_id;
336: gpr_price_list_rec.global_flag := 'N';
337: lheader_id := oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;
338:
339: I := oe_delayed_requests_pvt.g_delayed_requests.first;

Line 3485: OR orig_org_id = mo_global.get_current_org_id)

3481: FROM qp_list_headers_vl
3482: WHERE list_type_code in ('PRL' ,'AGR')
3483: AND p_header_rec.price_list_name = name
3484: AND (((nvl(global_flag,'Y') = 'Y'
3485: OR orig_org_id = mo_global.get_current_org_id)
3486: AND qp_security.security_on = 'Y') or qp_security.security_on = 'N');
3487: -- END
3488: EXCEPTION
3489: WHEN NO_DATA_FOUND THEN

Line 4201: , mo_global.get_current_org_id

4197: , 'N'
4198: , p_header_rec.version_number
4199: , p_header_rec.shipping_instructions
4200: , p_header_rec.packing_instructions
4201: , mo_global.get_current_org_id
4202: , 'B'
4203: , 'ORDER'
4204: , p_header_rec.source_document_type_id
4205: , p_header_rec.source_document_id

Line 4755: , MO_GLOBAL.GET_CURRENT_ORG_ID

4751: , p_line_rec.last_update_login
4752: , p_line_rec.line_id
4753: , p_line_rec.line_type_id
4754: , p_line_rec.line_number
4755: , MO_GLOBAL.GET_CURRENT_ORG_ID
4756: , p_line_rec.payment_term_id
4757: , p_line_rec.preferred_grade --OPM 02/JUN/00
4758: , p_line_rec.price_list_id
4759: , p_line_rec.program_application_id

Line 6338: AND ORG_ID = MO_GLOBAL.get_current_org_id

6334: SELECT /* MOAC_SQL_CHANGE */ bh.lock_control
6335: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_HEADERS_EXT BHX
6336: WHERE BH.ORDER_NUMBER = BHX.ORDER_NUMBER
6337: AND BH.ORDER_NUMBER = p_blanket_id
6338: AND ORG_ID = MO_GLOBAL.get_current_org_id
6339: AND BH.SALES_DOCUMENT_TYPE_CODE = 'B'
6340: FOR UPDATE NOWAIT;
6341:
6342: CURSOR c_blanket_lines IS

Line 6347: AND BL.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID

6343: SELECT /* MOAC_SQL_CHANGE */ bl.line_id, bl.lock_control
6344: FROM OE_BLANKET_LINES_ALL BL, OE_BLANKET_LINES_EXT BLX
6345: WHERE BL.LINE_ID = BLX.LINE_ID
6346: AND BLX.ORDER_NUMBER = l_blanket_id
6347: AND BL.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID
6348: AND BL.SALES_DOCUMENT_TYPE_CODE = 'B'
6349: FOR UPDATE NOWAIT;
6350:
6351: --