eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MO_GLOBAL dependencies on FND_PROFILE

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 817: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL', l_security_profile_id);

813: IF is_multi_org_enabled = 'Y' THEN
814: --
815: -- Get the profile values and call set_org_access API
816: --
817: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL', l_security_profile_id);
818: fnd_profile.get('ORG_ID', l_org_id);
819:
820: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
821: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

Line 818: fnd_profile.get('ORG_ID', l_org_id);

814: --
815: -- Get the profile values and call set_org_access API
816: --
817: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL', l_security_profile_id);
818: fnd_profile.get('ORG_ID', l_org_id);
819:
820: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
821: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
822: 'fnd.plsql.MO_GLOBAL.INIT.config',

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 925: fnd_profile.get('FND_MO_INIT_CI_DEBUG', l_ci_debug);

921:
922: --
923: -- Interim solution for MFG teams
924: --
925: fnd_profile.get('FND_MO_INIT_CI_DEBUG', l_ci_debug);
926: IF l_ci_debug = 'Y' THEN
927: RETURN 'org_id = substrb(userenv(''CLIENT_INFO''),1,10)';
928: ELSE
929: RETURN '1=2';

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 966: fnd_profile.get('FND_MO_INIT_CI_DEBUG', l_ci_debug);

962: ',MO: Security Profile=>'||p_sp_id_char||
963: ',p_appl_short_name=>'||p_appl_short_name);
964: END IF;
965:
966: fnd_profile.get('FND_MO_INIT_CI_DEBUG', l_ci_debug);
967: -- Set up the Operating Unit context in the client info area
968: IF l_ci_debug = 'Y' THEN
969: fnd_client_info.set_org_context(p_org_id_char);
970: END IF;

Line 1453: FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NOT NULL THEN

1449:
1450: /* May consider the following logic to execute MO init w/in the proc in future.
1451:
1452: IF g_ou_count = 0 AND
1453: FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NOT NULL THEN
1454: mo_global.init('M');
1455:
1456: ELSIF g_ou_count = 0 AND
1457: FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NULL AND

Line 1457: FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NULL AND

1453: FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NOT NULL THEN
1454: mo_global.init('M');
1455:
1456: ELSIF g_ou_count = 0 AND
1457: FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NULL AND
1458: FND_PROFILE.VALUE('ORG_ID') is NOT NULL THEN
1459: mo_global.init('S');
1460: END IF;
1461: */

Line 1458: FND_PROFILE.VALUE('ORG_ID') is NOT NULL THEN

1454: mo_global.init('M');
1455:
1456: ELSIF g_ou_count = 0 AND
1457: FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NULL AND
1458: FND_PROFILE.VALUE('ORG_ID') is NOT NULL THEN
1459: mo_global.init('S');
1460: END IF;
1461: */
1462:

Line 1465: IF FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NOT NULL

1461: */
1462:
1463: STATUS := 'F'; -- initialize the variable to F
1464:
1465: IF FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NOT NULL
1466: AND g_ou_count = 0 THEN
1467: FND_MESSAGE.SET_NAME('FND','FND_MO_NOINIT_SP_PUB_API');
1468: FND_MSG_PUB.ADD;
1469: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1496: ELSIF FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NULL THEN

1492: APP_EXCEPTION.RAISE_EXCEPTION;
1493: END IF;
1494: END IF;
1495:
1496: ELSIF FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NULL THEN
1497: -- mo initialization is not done.
1498: -- check if org_id passed id valid with MO:OU
1499: -- for backword compatibilty
1500: FND_PROFILE.GET('ORG_ID',l_org_id);

Line 1500: FND_PROFILE.GET('ORG_ID',l_org_id);

1496: ELSIF FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NULL THEN
1497: -- mo initialization is not done.
1498: -- check if org_id passed id valid with MO:OU
1499: -- for backword compatibilty
1500: FND_PROFILE.GET('ORG_ID',l_org_id);
1501: IF ORG_ID = l_org_id THEN
1502: set_policy_context('S',l_org_id); -- setting org context for synonym
1503: STATUS := 'O';
1504:

Line 1529: ELSIF FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NULL THEN

1525: END IF;
1526: END IF;
1527:
1528: -- for backword compatibility support. Return status O
1529: ELSIF FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NULL THEN
1530: FND_PROFILE.GET('ORG_ID',l_org_id);
1531: ORG_ID := l_org_id;
1532: set_policy_context('S',l_org_id); -- setting org context for synonym
1533: STATUS := 'O';

Line 1530: FND_PROFILE.GET('ORG_ID',l_org_id);

1526: END IF;
1527:
1528: -- for backword compatibility support. Return status O
1529: ELSIF FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NULL THEN
1530: FND_PROFILE.GET('ORG_ID',l_org_id);
1531: ORG_ID := l_org_id;
1532: set_policy_context('S',l_org_id); -- setting org context for synonym
1533: STATUS := 'O';
1534: END IF;

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 1576: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL', l_current_sp_id);

1572: -- if SP is not same application should re-initialize the MOAC
1573: -- hence return 'N'
1574: --
1575:
1576: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL', l_current_sp_id);
1577: fnd_profile.get('ORG_ID', l_current_org_id);
1578:
1579: l_user_id:=sys_context('FND','USER_ID');
1580: l_resp_id:=sys_context('FND','RESP_ID');

Line 1577: fnd_profile.get('ORG_ID', l_current_org_id);

1573: -- hence return 'N'
1574: --
1575:
1576: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL', l_current_sp_id);
1577: fnd_profile.get('ORG_ID', l_current_org_id);
1578:
1579: l_user_id:=sys_context('FND','USER_ID');
1580: l_resp_id:=sys_context('FND','RESP_ID');
1581:

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

Line 1670: fnd_profile.get('FND_MO_INIT_CI_DEBUG', l_ci_debug);

1666: ELSE
1667: --
1668: -- Interim solution for MFG teams
1669: --
1670: fnd_profile.get('FND_MO_INIT_CI_DEBUG', l_ci_debug);
1671: IF l_ci_debug = 'Y' THEN
1672: RETURN 'org_id = substrb(userenv(''CLIENT_INFO''),1,10)';
1673: ELSE
1674: RETURN '1=2';