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.22.12020000.3 2013/03/22 06:39:25 absandhw ship $ */
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.22.12020000.3 2013/03/22 06:39:25 absandhw ship $ */
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.22.12020000.3 2013/03/22 06:39:25 absandhw ship $ */
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 269: if (fnd_data_security.DISALLOW_DEPRECATED = 'Y') then

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

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

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

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

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

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

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

Line 2061: fnd_data_security.get_functions

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

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

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

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

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

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

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

Line 5344: fnd_data_security.get_security_predicate_intrnl(

5340: x_return_status := 'U'; /* Unexpected Error */
5341: return;
5342: END IF;
5343:
5344: fnd_data_security.get_security_predicate_intrnl(
5345: p_api_version, p_function, p_object_name, p_grant_instance_type,
5346: p_user_name, p_statement_type, p_table_alias,'Y',
5347: x_predicate, x_return_status,
5348: x_function_id, x_object_id, x_bind_order);

Line 5421: fnd_data_security.get_security_predicate_intrnl(

5417: x_return_status := 'U'; /* Unexpected Error */
5418: return;
5419: END IF;
5420:
5421: fnd_data_security.get_security_predicate_intrnl(
5422: p_api_version, p_function, p_object_name, p_grant_instance_type,
5423: p_user_name, p_statement_type, p_table_alias, 'N',
5424: x_predicate, x_return_status,
5425: x_function_id, x_object_id, x_bind_order);

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

5493: x_return_status := 'U'; /* Unexpected Error */
5494: return;
5495: end if;
5496:
5497: if (fnd_data_security.DISALLOW_DEPRECATED = 'Y') then
5498: /* In R12 this routine is deprecated */
5499: /* So we raise a runtime exception to help people to know */
5500: /* they need to change their code. */
5501: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

Line 5530: fnd_data_security.get_security_predicate(

5526: fnd_message.raise_error;
5527: end if;
5528:
5529:
5530: fnd_data_security.get_security_predicate(
5531: p_api_version, p_function, p_object_name, p_grant_instance_type,
5532: p_user_name, p_statement_type, x_predicate, x_return_status);
5533: end;
5534:

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

5575: ', p_user_name=>'|| p_user_name ||
5576: ')');
5577: end if;
5578:
5579: if (fnd_data_security.DISALLOW_DEPRECATED = 'Y') then
5580: /* In R12 this routine is deprecated, because it effectively */
5581: /* does a blind query, potentially returning zillions of */
5582: /* records, which is unsupportable from a performance */
5583: /* perspective. */

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

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

Line 6289: END FND_DATA_SECURITY;

6285: RETURN FALSE;
6286: END GET_FUNCTIONS_BY_PROMPT;
6287:
6288:
6289: END FND_DATA_SECURITY;