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 505: l_security_profile_id fnd_profile_option_values.profile_option_value%TYPE := p_sp_id_char;

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);

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

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:

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

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: --

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

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

Line 722: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL', l_security_profile_id);

718: IF is_multi_org_enabled = 'Y' THEN
719: --
720: -- Get the profile values and call set_org_access API
721: --
722: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL', l_security_profile_id);
723: fnd_profile.get('ORG_ID', l_org_id);
724:
725: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
726: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

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

719: --
720: -- Get the profile values and call set_org_access API
721: --
722: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL', l_security_profile_id);
723: fnd_profile.get('ORG_ID', l_org_id);
724:
725: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
726: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
727: 'fnd.plsql.MO_GLOBAL.INIT.config',

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

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

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

814:
815: --
816: -- Interim solution for MFG teams
817: --
818: fnd_profile.get('FND_MO_INIT_CI_DEBUG', l_ci_debug);
819: IF l_ci_debug = 'Y' THEN
820: RETURN 'org_id = substrb(userenv(''CLIENT_INFO''),1,10)';
821: ELSE
822: RETURN '1=2';

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

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,

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

855: ',MO: Security Profile=>'||p_sp_id_char||
856: ',p_appl_short_name=>'||p_appl_short_name);
857: END IF;
858:
859: fnd_profile.get('FND_MO_INIT_CI_DEBUG', l_ci_debug);
860: -- Set up the Operating Unit context in the client info area
861: IF l_ci_debug = 'Y' THEN
862: fnd_client_info.set_org_context(p_org_id_char);
863: END IF;

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

1314:
1315: /* May consider the following logic to execute MO init w/in the proc in future.
1316:
1317: IF g_ou_count = 0 AND
1318: FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NOT NULL THEN
1319: mo_global.init('M');
1320:
1321: ELSIF g_ou_count = 0 AND
1322: FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NULL AND

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

1318: FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NOT NULL THEN
1319: mo_global.init('M');
1320:
1321: ELSIF g_ou_count = 0 AND
1322: FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NULL AND
1323: FND_PROFILE.VALUE('ORG_ID') is NOT NULL THEN
1324: mo_global.init('S');
1325: END IF;
1326: */

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

1319: mo_global.init('M');
1320:
1321: ELSIF g_ou_count = 0 AND
1322: FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NULL AND
1323: FND_PROFILE.VALUE('ORG_ID') is NOT NULL THEN
1324: mo_global.init('S');
1325: END IF;
1326: */
1327:

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

1326: */
1327:
1328: STATUS := 'F'; -- initialize the variable to F
1329:
1330: IF FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NOT NULL
1331: AND g_ou_count = 0 THEN
1332: FND_MESSAGE.SET_NAME('FND','FND_MO_NOINIT_SP_PUB_API');
1333: FND_MSG_PUB.ADD;
1334: APP_EXCEPTION.RAISE_EXCEPTION;

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

1357: APP_EXCEPTION.RAISE_EXCEPTION;
1358: END IF;
1359: END IF;
1360:
1361: ELSIF FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NULL THEN
1362: -- mo initialization is not done.
1363: -- check if org_id passed id valid with MO:OU
1364: -- for backword compatibilty
1365: FND_PROFILE.GET('ORG_ID',l_org_id);

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

1361: ELSIF FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NULL THEN
1362: -- mo initialization is not done.
1363: -- check if org_id passed id valid with MO:OU
1364: -- for backword compatibilty
1365: FND_PROFILE.GET('ORG_ID',l_org_id);
1366: IF ORG_ID = l_org_id THEN
1367: set_policy_context('S',l_org_id); -- setting org context for synonym
1368: STATUS := 'O';
1369:

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

1390: END IF;
1391: END IF;
1392:
1393: -- for backword compatibility support. Return status O
1394: ELSIF FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NULL THEN
1395: FND_PROFILE.GET('ORG_ID',l_org_id);
1396: ORG_ID := l_org_id;
1397: set_policy_context('S',l_org_id); -- setting org context for synonym
1398: STATUS := 'O';

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

1391: END IF;
1392:
1393: -- for backword compatibility support. Return status O
1394: ELSIF FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NULL THEN
1395: FND_PROFILE.GET('ORG_ID',l_org_id);
1396: ORG_ID := l_org_id;
1397: set_policy_context('S',l_org_id); -- setting org context for synonym
1398: STATUS := 'O';
1399: END IF;

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

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

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

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: --

Line 1441: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL', l_current_sp_id);

1437: -- if SP is not same application should re-initialize the MOAC
1438: -- hence return 'N'
1439: --
1440:
1441: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL', l_current_sp_id);
1442: fnd_profile.get('ORG_ID', l_current_org_id);
1443:
1444: l_user_id:=sys_context('FND','USER_ID');
1445: l_resp_id:=sys_context('FND','RESP_ID');

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

1438: -- hence return 'N'
1439: --
1440:
1441: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL', l_current_sp_id);
1442: fnd_profile.get('ORG_ID', l_current_org_id);
1443:
1444: l_user_id:=sys_context('FND','USER_ID');
1445: l_resp_id:=sys_context('FND','RESP_ID');
1446:

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

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

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

1520: ELSE
1521: --
1522: -- Interim solution for MFG teams
1523: --
1524: fnd_profile.get('FND_MO_INIT_CI_DEBUG', l_ci_debug);
1525: IF l_ci_debug = 'Y' THEN
1526: RETURN 'org_id = substrb(userenv(''CLIENT_INFO''),1,10)';
1527: ELSE
1528: RETURN '1=2';