APPS.ASO_VALIDATE_PVT dependencies on MO_GLOBAL

Line 421: WHERE price_list_id = p_price_list_id and (orig_org_id = mo_global.get_current_org_id or global_flag ='Y'); --bug5188699

417: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
418: IS
419: CURSOR C_Price_List IS
420: SELECT (start_date_active), (end_date_active) FROM QP_PRICELISTS_LOV_V
421: WHERE price_list_id = p_price_list_id and (orig_org_id = mo_global.get_current_org_id or global_flag ='Y'); --bug5188699
422: /* Verified with QP this UNION is not necessary dgyawali verified with spgopal 08/12/02*/
423: /**
424: UNION
425: select qlhv.start_date_active, qlhv.end_date_active

Line 435: l_org_id NUMBER := mo_global.get_current_org_id;

431:
432:
433: l_start_date DATE;
434: l_end_date DATE;
435: l_org_id NUMBER := mo_global.get_current_org_id;
436: BEGIN
437: -- Initialize message list if p_init_msg_list is set to TRUE.
438: IF FND_API.to_Boolean( p_init_msg_list ) THEN
439: FND_MSG_PUB.initialize;

Line 447: aso_debug_pub.add('Validate_PriceList :mo_global.get_current_org_id '||l_org_id, 1, 'N');

443: x_return_status := FND_API.G_RET_STS_SUCCESS;
444:
445: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
446: aso_debug_pub.add('Validate_PriceList Begin: p_price_list_id: '||p_price_list_id, 1, 'N');
447: aso_debug_pub.add('Validate_PriceList :mo_global.get_current_org_id '||l_org_id, 1, 'N');
448: END IF;
449:
450:
451:

Line 5742: select DECODE(MO_GLOBAL.CHECK_ACCESS(p_org_id),'Y','Y','N',NULL,NULL) from dual ;

5738: select 1 from dual where trunc(p_request_date) >= trunc(sysdate)
5739: );
5740:
5741: CURSOR C_OPERATING_UNIT(p_org_id varchar2) is
5742: select DECODE(MO_GLOBAL.CHECK_ACCESS(p_org_id),'Y','Y','N',NULL,NULL) from dual ;
5743:
5744:
5745: CURSOR C_CHARGE_PERIODICITY_CODE(p_periodicity_code VARCHAR2,p_periodicity_profile VARCHAR2) is --CHARGE_PERIODICITY
5746: SELECT 1 FROM DUAL WHERE exists

Line 9605: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID;

9601: l_access_mode varchar2(1);
9602:
9603: BEGIN
9604: --Getting the current org_id
9605: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID;
9606:
9607: --Getting the Context Mode
9608: l_access_mode := MO_GLOBAL.GET_ACCESS_MODE ;
9609:

Line 9608: l_access_mode := MO_GLOBAL.GET_ACCESS_MODE ;

9604: --Getting the current org_id
9605: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID;
9606:
9607: --Getting the Context Mode
9608: l_access_mode := MO_GLOBAL.GET_ACCESS_MODE ;
9609:
9610: --when access mode is set to 'S'
9611: --Check if the current org_id matches with the org_id in p_qte_header_rec
9612: IF l_access_mode IS NOT NULL AND l_access_mode = 'S' THEN