DBA Data[Home] [Help]

APPS.MO_GLOBAL dependencies on FND_PROFILE_OPTION_VALUES

Line 12: g_old_sp_id fnd_profile_option_values.profile_option_value%TYPE := NULL;

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:

Line 13: g_old_org_id fnd_profile_option_values.profile_option_value%TYPE := NULL;

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

Line 577: l_security_profile_id fnd_profile_option_values.profile_option_value%TYPE := p_sp_id_char;

573: p_sp_id_char VARCHAR2,
574: p_appl_short_name VARCHAR2)
575: IS
576: l_access_ctrl_enabled VARCHAR2(1);
577: l_security_profile_id fnd_profile_option_values.profile_option_value%TYPE := p_sp_id_char;
578: l_org_id fnd_profile_option_values.profile_option_value%TYPE := p_org_id_char;
579:
580: l_current_org_id hr_operating_units.name%TYPE;
581: l_view_all_orgs VARCHAR2(1);

Line 578: l_org_id fnd_profile_option_values.profile_option_value%TYPE := p_org_id_char;

574: p_appl_short_name VARCHAR2)
575: IS
576: l_access_ctrl_enabled VARCHAR2(1);
577: l_security_profile_id fnd_profile_option_values.profile_option_value%TYPE := p_sp_id_char;
578: l_org_id fnd_profile_option_values.profile_option_value%TYPE := p_org_id_char;
579:
580: l_current_org_id hr_operating_units.name%TYPE;
581: l_view_all_orgs VARCHAR2(1);
582:

Line 801: l_security_profile_id fnd_profile_option_values.profile_option_value%TYPE := NULL;

797:
798: PROCEDURE init(p_appl_short_name VARCHAR2, p_sync VARCHAR2)
799: IS
800:
801: l_security_profile_id fnd_profile_option_values.profile_option_value%TYPE := NULL;
802: l_org_id fnd_profile_option_values.profile_option_value%TYPE := NULL;
803:
804: BEGIN
805: --

Line 802: l_org_id fnd_profile_option_values.profile_option_value%TYPE := NULL;

798: PROCEDURE init(p_appl_short_name VARCHAR2, p_sync VARCHAR2)
799: IS
800:
801: l_security_profile_id fnd_profile_option_values.profile_option_value%TYPE := NULL;
802: l_org_id fnd_profile_option_values.profile_option_value%TYPE := NULL;
803:
804: BEGIN
805: --
806: -- Check if multi-org is enabled

Line 879: l_ci_debug fnd_profile_option_values.profile_option_value%TYPE := NULL;

875: --
876: FUNCTION org_security(obj_schema VARCHAR2,
877: obj_name VARCHAR2) RETURN VARCHAR2
878: IS
879: l_ci_debug fnd_profile_option_values.profile_option_value%TYPE := NULL;
880: BEGIN
881:
882: --
883: -- Returns different predicates based on the access_mode

Line 955: l_ci_debug fnd_profile_option_values.profile_option_value%TYPE := NULL;

951: PROCEDURE set_org_context(p_org_id_char VARCHAR2,
952: p_sp_id_char VARCHAR2,
953: p_appl_short_name VARCHAR2) is
954:
955: l_ci_debug fnd_profile_option_values.profile_option_value%TYPE := NULL;
956:
957: BEGIN
958: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
959: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

Line 1565: l_current_sp_id fnd_profile_option_values.profile_option_value%TYPE := NULL;

1561: --
1562:
1563: FUNCTION is_mo_init_done RETURN VARCHAR2
1564: IS
1565: l_current_sp_id fnd_profile_option_values.profile_option_value%TYPE := NULL;
1566: l_current_org_id fnd_profile_option_values.profile_option_value%TYPE := NULL;
1567: l_user_id NUMBER:=NULL;
1568: l_resp_id NUMBER:=NULL;
1569: BEGIN

Line 1566: l_current_org_id fnd_profile_option_values.profile_option_value%TYPE := NULL;

1562:
1563: FUNCTION is_mo_init_done RETURN VARCHAR2
1564: IS
1565: l_current_sp_id fnd_profile_option_values.profile_option_value%TYPE := NULL;
1566: l_current_org_id fnd_profile_option_values.profile_option_value%TYPE := NULL;
1567: l_user_id NUMBER:=NULL;
1568: l_resp_id NUMBER:=NULL;
1569: BEGIN
1570: --

Line 1626: l_ci_debug fnd_profile_option_values.profile_option_value%TYPE := NULL;

1622: -- This is a restricted policy function to support global data -3116.
1623: FUNCTION org_security_global(obj_schema VARCHAR2,
1624: obj_name VARCHAR2) RETURN VARCHAR2
1625: IS
1626: l_ci_debug fnd_profile_option_values.profile_option_value%TYPE := NULL;
1627: BEGIN
1628:
1629: --
1630: -- Returns different predicates based on the access_mode