8: g_sync varchar2(1);
9: g_init_access_mode varchar2(1);
10: g_ou_id_tab OrgIdTab;
11:
12: g_old_sp_id fnd_profile_option_values.profile_option_value%TYPE := NULL;
13: g_old_org_id fnd_profile_option_values.profile_option_value%TYPE := NULL;
14: g_old_user_id NUMBER;
15: g_old_resp_id NUMBER;
16:
9: g_init_access_mode varchar2(1);
10: g_ou_id_tab OrgIdTab;
11:
12: g_old_sp_id fnd_profile_option_values.profile_option_value%TYPE := NULL;
13: g_old_org_id fnd_profile_option_values.profile_option_value%TYPE := NULL;
14: g_old_user_id NUMBER;
15: g_old_resp_id NUMBER;
16:
17: TYPE ApplShortNameTab is TABLE OF fnd_mo_product_init.application_short_name%TYPE
501: p_appl_short_name VARCHAR2)
502: IS
503: PRAGMA AUTONOMOUS_TRANSACTION;
504: l_access_ctrl_enabled VARCHAR2(1);
505: l_security_profile_id fnd_profile_option_values.profile_option_value%TYPE := p_sp_id_char;
506: l_org_id fnd_profile_option_values.profile_option_value%TYPE := p_org_id_char;
507:
508: l_current_org_id hr_operating_units.name%TYPE;
509: l_view_all_orgs VARCHAR2(1);
502: IS
503: PRAGMA AUTONOMOUS_TRANSACTION;
504: l_access_ctrl_enabled VARCHAR2(1);
505: l_security_profile_id fnd_profile_option_values.profile_option_value%TYPE := p_sp_id_char;
506: l_org_id fnd_profile_option_values.profile_option_value%TYPE := p_org_id_char;
507:
508: l_current_org_id hr_operating_units.name%TYPE;
509: l_view_all_orgs VARCHAR2(1);
510:
702:
703: PROCEDURE init(p_appl_short_name VARCHAR2, p_sync VARCHAR2)
704: IS
705:
706: l_security_profile_id fnd_profile_option_values.profile_option_value%TYPE := NULL;
707: l_org_id fnd_profile_option_values.profile_option_value%TYPE := NULL;
708:
709: BEGIN
710: --
703: PROCEDURE init(p_appl_short_name VARCHAR2, p_sync VARCHAR2)
704: IS
705:
706: l_security_profile_id fnd_profile_option_values.profile_option_value%TYPE := NULL;
707: l_org_id fnd_profile_option_values.profile_option_value%TYPE := NULL;
708:
709: BEGIN
710: --
711: -- Check if multi-org is enabled
780: --
781: FUNCTION org_security(obj_schema VARCHAR2,
782: obj_name VARCHAR2) RETURN VARCHAR2
783: IS
784: l_ci_debug fnd_profile_option_values.profile_option_value%TYPE := NULL;
785: BEGIN
786:
787: --
788: -- Returns different predicates based on the access_mode
844: PROCEDURE set_org_context(p_org_id_char VARCHAR2,
845: p_sp_id_char VARCHAR2,
846: p_appl_short_name VARCHAR2) is
847:
848: l_ci_debug fnd_profile_option_values.profile_option_value%TYPE := NULL;
849:
850: BEGIN
851: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
852: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
1426: --
1427:
1428: FUNCTION is_mo_init_done RETURN VARCHAR2
1429: IS
1430: l_current_sp_id fnd_profile_option_values.profile_option_value%TYPE := NULL;
1431: l_current_org_id fnd_profile_option_values.profile_option_value%TYPE := NULL;
1432: l_user_id NUMBER:=NULL;
1433: l_resp_id NUMBER:=NULL;
1434: BEGIN
1427:
1428: FUNCTION is_mo_init_done RETURN VARCHAR2
1429: IS
1430: l_current_sp_id fnd_profile_option_values.profile_option_value%TYPE := NULL;
1431: l_current_org_id fnd_profile_option_values.profile_option_value%TYPE := NULL;
1432: l_user_id NUMBER:=NULL;
1433: l_resp_id NUMBER:=NULL;
1434: BEGIN
1435: --
1487: -- This is a restricted policy function to support global data -3116.
1488: FUNCTION org_security_global(obj_schema VARCHAR2,
1489: obj_name VARCHAR2) RETURN VARCHAR2
1490: IS
1491: l_ci_debug fnd_profile_option_values.profile_option_value%TYPE := NULL;
1492: BEGIN
1493:
1494: --
1495: -- Returns different predicates based on the access_mode