DBA Data[Home] [Help]

APPS.OKC_IMP_TERMS_TEMPLATES_PVT dependencies on MO_GLOBAL

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

31: CURSOR cur_validate_ou (p_org_id IN NUMBER)
32: IS
33: SELECT 'Y'
34: FROM hr_operating_units ou, hr_organization_information oi
35: WHERE mo_global.check_access (ou.organization_id) = 'Y'
36: AND oi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
37: AND oi.organization_id = ou.organization_id
38: AND NVL (date_to, SYSDATE) >= SYSDATE
39: AND ou.organization_id = p_org_id;

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

836: CURSOR cur_val_ou (p_org_id IN NUMBER)
837: IS
838: SELECT 'X'
839: FROM hr_operating_units ou, hr_organization_information oi
840: WHERE mo_global.check_access (ou.organization_id) = 'Y'
841: AND oi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
842: AND oi.organization_id = ou.organization_id
843: AND NVL (date_to, SYSDATE) >= SYSDATE
844: AND ou.organization_id = p_org_id;

Line 1207: mo_global.set_policy_context ('S', TO_CHAR (p_template_rec.org_id));

1203: RAISE fnd_api.g_exc_error;
1204: END IF;
1205:
1206: -- Set Policy context
1207: mo_global.set_policy_context ('S', TO_CHAR (p_template_rec.org_id));
1208: ELSE
1209: okc_api.set_message (p_app_name => g_app_name,
1210: p_msg_name => 'OKC_I_NOT_NULL',
1211: p_token1 => 'FIELD',

Line 1776: mo_global.set_policy_context ('S', TO_CHAR (l_template_db_rec.org_id));

1772: END IF; -- g_headerinfo_update_allowed = 'N'
1773:
1774: l_progress := '100';
1775: -- set the policy context
1776: mo_global.set_policy_context ('S', TO_CHAR (l_template_db_rec.org_id));
1777: l_progress := '110';
1778: -- Default values for coulmns from table for which the values are not provided by user
1779: default_row (p_template_rec => p_template_rec,
1780: p_template_db_rec => l_template_db_rec