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.FND_DATA_SECURITY dependencies on FND_DATA_SECURITY

Line 1: PACKAGE BODY FND_DATA_SECURITY AS

1: PACKAGE BODY FND_DATA_SECURITY AS
2: /* $Header: AFSCDSCB.pls 120.18 2006/11/15 07:26:42 stadepal noship $ */
3:
4: C_PKG_NAME CONSTANT VARCHAR2(30) := 'FND_DATA_SECURITY';
5: C_LOG_HEAD CONSTANT VARCHAR2(30) := 'fnd.plsql.FND_DATA_SECURITY.';

Line 4: C_PKG_NAME CONSTANT VARCHAR2(30) := 'FND_DATA_SECURITY';

1: PACKAGE BODY FND_DATA_SECURITY AS
2: /* $Header: AFSCDSCB.pls 120.18 2006/11/15 07:26:42 stadepal noship $ */
3:
4: C_PKG_NAME CONSTANT VARCHAR2(30) := 'FND_DATA_SECURITY';
5: C_LOG_HEAD CONSTANT VARCHAR2(30) := 'fnd.plsql.FND_DATA_SECURITY.';
6: C_TYPE_SET CONSTANT VARCHAR2(30) := 'SET';
7: C_TYPE_GLOBAL CONSTANT VARCHAR2(30) := 'GLOBAL';
8: C_TYPE_INSTANCE CONSTANT VARCHAR2(30) := 'INSTANCE';

Line 5: C_LOG_HEAD CONSTANT VARCHAR2(30) := 'fnd.plsql.FND_DATA_SECURITY.';

1: PACKAGE BODY FND_DATA_SECURITY AS
2: /* $Header: AFSCDSCB.pls 120.18 2006/11/15 07:26:42 stadepal noship $ */
3:
4: C_PKG_NAME CONSTANT VARCHAR2(30) := 'FND_DATA_SECURITY';
5: C_LOG_HEAD CONSTANT VARCHAR2(30) := 'fnd.plsql.FND_DATA_SECURITY.';
6: C_TYPE_SET CONSTANT VARCHAR2(30) := 'SET';
7: C_TYPE_GLOBAL CONSTANT VARCHAR2(30) := 'GLOBAL';
8: C_TYPE_INSTANCE CONSTANT VARCHAR2(30) := 'INSTANCE';
9: C_TYPE_UNIVERSAL CONSTANT VARCHAR2(30) := 'UNIVERSAL';

Line 268: if (fnd_data_security.DISALLOW_DEPRECATED = 'Y') then

264: c_pkg_name || '.' ||l_api_name|| '(' ||
265: 'p_user_name =>'|| p_user_name ||');');
266: end if;
267:
268: if (fnd_data_security.DISALLOW_DEPRECATED = 'Y') then
269: /* In R12 this routine is deprecated, because it effectively */
270: /* does a blind query, potentially returning zillions of */
271: /* records, which is unsupportable from a performance */
272: /* perspective. */

Line 953: if ( (fnd_data_security.DISALLOW_DEPRECATED = 'Y')

949: -- Default the user name if not passed in.
950: if(p_user_name is NULL) then
951: l_user_name := SYS_CONTEXT('FND','USER_NAME');
952: else
953: if ( (fnd_data_security.DISALLOW_DEPRECATED = 'Y')
954: and (substr(p_user_name, 1, LENGTH('GET_MNUIDS_NBVCXDS')) <>
955: 'GET_MNUIDS_NBVCXDS')
956: and ( (p_user_name <> SYS_CONTEXT('FND','USER_NAME'))
957: or ( (p_user_name is not null)

Line 1296: if ( (fnd_data_security.DISALLOW_DEPRECATED = 'Y')

1292: -- Default the user name if not passed in.
1293: if(p_user_name is NULL) then
1294: l_user_name := SYS_CONTEXT('FND','USER_NAME');
1295: else
1296: if ( (fnd_data_security.DISALLOW_DEPRECATED = 'Y')
1297: and (substr(p_user_name, 1, LENGTH('GET_MNUIDS_NBVCXDS')) <>
1298: 'GET_MNUIDS_NBVCXDS')
1299: and ( (p_user_name <> SYS_CONTEXT('FND','USER_NAME'))
1300: or ( (p_user_name is not null)

Line 1793: if ( (fnd_data_security.DISALLOW_DEPRECATED = 'Y')

1789: -- Default the user name if not passed in.
1790: if(p_user_name is NULL) then
1791: l_user_name := SYS_CONTEXT('FND','USER_NAME');
1792: else
1793: if ( (fnd_data_security.DISALLOW_DEPRECATED = 'Y')
1794: and (substr(p_user_name, 1, LENGTH('GET_MNUIDS_NBVCXDS')) <>
1795: 'GET_MNUIDS_NBVCXDS')
1796: and ( (p_user_name <> SYS_CONTEXT('FND','USER_NAME'))
1797: or ( (p_user_name is not null)

Line 2060: fnd_data_security.get_functions

2056: else
2057: l_user_id_str := 'GET_MNUIDS_NBVCXDS:'||p_user_name;
2058: end if;
2059:
2060: fnd_data_security.get_functions
2061: (
2062: p_api_version => 1.0,
2063: p_object_name => p_object_name,
2064: p_instance_pk1_value => p_instance_pk1_value,

Line 2331: if ( (fnd_data_security.DISALLOW_DEPRECATED = 'Y')

2327: 'GET_MNUIDS_NBVCXDS') then
2328: l_menulist_flag := TRUE; /* For a special mode called from java */
2329: if(substr(p_user_name, 1, LENGTH('GET_MNUIDS_NBVCXDS:')) =
2330: 'GET_MNUIDS_NBVCXDS:') then
2331: if ( (fnd_data_security.DISALLOW_DEPRECATED = 'Y')
2332: and (substr(p_user_name, 1, LENGTH('GET_MNUIDS_NBVCXDS')) <>
2333: 'GET_MNUIDS_NBVCXDS')
2334: and ( (p_user_name <> SYS_CONTEXT('FND','USER_NAME'))
2335: or ( (p_user_name is not null)

Line 2387: if ( (fnd_data_security.DISALLOW_DEPRECATED = 'Y')

2383: c_log_head || l_api_name || '.null_username',
2384: 'l_user_name= '||l_user_name);
2385: end if;
2386: else
2387: if ( (fnd_data_security.DISALLOW_DEPRECATED = 'Y')
2388: and (substr(p_user_name, 1, LENGTH('GET_MNUIDS_NBVCXDS')) <>
2389: 'GET_MNUIDS_NBVCXDS')
2390: and ( (p_user_name <> SYS_CONTEXT('FND','USER_NAME'))
2391: or ( (p_user_name is not null)

Line 3778: if ( (fnd_data_security.DISALLOW_DEPRECATED = 'Y')

3774: c_log_head || l_api_name || '.passed_uname',
3775: 'l_user_name= '||l_user_name);
3776: end if;
3777:
3778: if ( (fnd_data_security.DISALLOW_DEPRECATED = 'Y')
3779: and (substr(p_user_name, 1, LENGTH('GET_MNUIDS_NBVCXDS')) <>
3780: 'GET_MNUIDS_NBVCXDS')
3781: and ( (p_user_name <> SYS_CONTEXT('FND','USER_NAME'))
3782: or ( (p_user_name is not null)

Line 5303: fnd_data_security.get_security_predicate_intrnl(

5299: x_return_status := 'U'; /* Unexpected Error */
5300: return;
5301: END IF;
5302:
5303: fnd_data_security.get_security_predicate_intrnl(
5304: p_api_version, p_function, p_object_name, p_grant_instance_type,
5305: p_user_name, p_statement_type, p_table_alias,'Y',
5306: x_predicate, x_return_status,
5307: x_function_id, x_object_id, x_bind_order);

Line 5380: fnd_data_security.get_security_predicate_intrnl(

5376: x_return_status := 'U'; /* Unexpected Error */
5377: return;
5378: END IF;
5379:
5380: fnd_data_security.get_security_predicate_intrnl(
5381: p_api_version, p_function, p_object_name, p_grant_instance_type,
5382: p_user_name, p_statement_type, p_table_alias, 'N',
5383: x_predicate, x_return_status,
5384: x_function_id, x_object_id, x_bind_order);

Line 5456: if (fnd_data_security.DISALLOW_DEPRECATED = 'Y') then

5452: x_return_status := 'U'; /* Unexpected Error */
5453: return;
5454: end if;
5455:
5456: if (fnd_data_security.DISALLOW_DEPRECATED = 'Y') then
5457: /* In R12 this routine is deprecated */
5458: /* So we raise a runtime exception to help people to know */
5459: /* they need to change their code. */
5460: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

Line 5489: fnd_data_security.get_security_predicate(

5485: fnd_message.raise_error;
5486: end if;
5487:
5488:
5489: fnd_data_security.get_security_predicate(
5490: p_api_version, p_function, p_object_name, p_grant_instance_type,
5491: p_user_name, p_statement_type, x_predicate, x_return_status);
5492: end;
5493:

Line 5538: if (fnd_data_security.DISALLOW_DEPRECATED = 'Y') then

5534: ', p_user_name=>'|| p_user_name ||
5535: ')');
5536: end if;
5537:
5538: if (fnd_data_security.DISALLOW_DEPRECATED = 'Y') then
5539: /* In R12 this routine is deprecated, because it effectively */
5540: /* does a blind query, potentially returning zillions of */
5541: /* records, which is unsupportable from a performance */
5542: /* perspective. */

Line 5970: ** rows are not filtered before going through the fnd_data_security.to_int()

5966: ** this is being called on non-numerical data, just returns -11111.
5967: ** The reason that it is essential that this is called instead of to_number()
5968: ** on grant parameters is that this routine will not cause an exception if
5969: ** the generated predicate ends up being evaluated such that the grant
5970: ** rows are not filtered before going through the fnd_data_security.to_int()
5971: ** routine. Some grant rows may have non-numeric data if they are for other
5972: ** object instance sets. We need to make sure that the data security
5973: ** clause will not generate an exception no matter what order the database
5974: ** decides to evaluate the statement in.

Line 6040: END FND_DATA_SECURITY;

6036: end;
6037: return outval;
6038: end;
6039:
6040: END FND_DATA_SECURITY;