DBA Data[Home] [Help]

APPS.ARI_SELF_REG_CONFIG dependencies on MO_GLOBAL

Line 42: select organization_id org_id from hr_operating_units where mo_global.check_access(organization_id) = 'Y';

38: l_answer varchar2(200);
39: i PLS_INTEGER := 1 ;
40:
41: CURSOR cust_site_cur IS
42: select organization_id org_id from hr_operating_units where mo_global.check_access(organization_id) = 'Y';
43:
44: cust_site_rec cust_site_cur%ROWTYPE;
45: BEGIN
46:

Line 64: mo_global.init('AR');

60: FROM hz_cust_site_uses
61: WHERE site_use_id = p_customer_site_use_id ;
62: else
63: -- added below lines to avoid error when navigated from preferences->Access Request -> additional access for new Oracle apps user who doesn't have iRec access.
64: mo_global.init('AR');
65: mo_global.set_policy_context('M',null);
66:
67: --check if rule exist for the default org id.
68: if(mo_utils.get_default_org_id is NOT NULL and FUN_RULE_OBJECTS_PUB.rule_object_instance_exists(222,'ARI_VALIDATE_SITE_ACCESS', NULL,mo_utils.get_default_org_id)) then

Line 65: mo_global.set_policy_context('M',null);

61: WHERE site_use_id = p_customer_site_use_id ;
62: else
63: -- added below lines to avoid error when navigated from preferences->Access Request -> additional access for new Oracle apps user who doesn't have iRec access.
64: mo_global.init('AR');
65: mo_global.set_policy_context('M',null);
66:
67: --check if rule exist for the default org id.
68: if(mo_utils.get_default_org_id is NOT NULL and FUN_RULE_OBJECTS_PUB.rule_object_instance_exists(222,'ARI_VALIDATE_SITE_ACCESS', NULL,mo_utils.get_default_org_id)) then
69: cust_site_org_id := mo_utils.get_default_org_id;

Line 498: mo_global.init('AR');

494: ' and hcsu.cust_acct_site_id = hcas.cust_acct_site_id and hcas.party_site_id = hps.party_site_id and hps.'||p_hz_join_column||' = anstable.'||p_answer_join_column;
495:
496: else
497:
498: mo_global.init('AR');
499: mo_global.set_policy_context('M',null);
500: arp_standard.debug('apps context initialized');
501:
502: SELECT site_use_id into l_site_use_id FROM

Line 499: mo_global.set_policy_context('M',null);

495:
496: else
497:
498: mo_global.init('AR');
499: mo_global.set_policy_context('M',null);
500: arp_standard.debug('apps context initialized');
501:
502: SELECT site_use_id into l_site_use_id FROM
503: ( SELECT site_uses.site_use_id FROM