DBA Data[Home] [Help]

APPS.OKC_XPRT_RULE_PVT dependencies on MO_GLOBAL

Line 776: WHERE mo_global.check_access (ou.organization_id) = 'Y'

772: CURSOR cur_val_ou (p_org_id NUMBER)
773: IS
774: SELECT 'X'
775: FROM hr_operating_units ou, hr_organization_information oi
776: WHERE mo_global.check_access (ou.organization_id) = 'Y'
777: AND oi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
778: AND oi.organization_id = ou.organization_id
779: AND NVL (date_to, SYSDATE) >= SYSDATE
780: AND ou.organization_id = p_org_id;

Line 1025: mo_global.set_policy_context ('S', TO_CHAR (p_rule_header_rec.org_id));

1021:
1022: l_validate_flag := NULL;
1023:
1024: -- Set Policy context
1025: mo_global.set_policy_context ('S', TO_CHAR (p_rule_header_rec.org_id));
1026: -- Validate Rule Header
1027: -- Rules
1028: -- Rule_Id => Can be generated from sequence OKC_XPRT_RULE_HDRS_ALL_S
1029: -- Org_Id => Derive or get it from the user input

Line 2422: mo_global.set_policy_context ('S', TO_CHAR (l_rule_header_row.org_id));

2418: END IF;
2419:
2420: l_progress := '100';
2421: -- set the policy context
2422: mo_global.set_policy_context ('S', TO_CHAR (l_rule_header_row.org_id));
2423: l_progress := '110';
2424: -- Default values for coulmns from table for which the values are not provided by user
2425: default_row (p_rule_header_rec => p_rule_header_rec,
2426: p_db_rule_header => l_rule_header_row