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

Line 1: PACKAGE BODY EGO_DATA_SECURITY AS

1: PACKAGE BODY EGO_DATA_SECURITY AS
2: /* $Header: EGOPFDSB.pls 120.37.12020000.2 2013/01/15 03:08:16 jawan ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'EGO_DATA_SECURITY';
5: G_LOG_HEAD CONSTANT VARCHAR2(40):= 'fnd.plsql.ego.EGO_DATA_SECURITY.';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'EGO_DATA_SECURITY';

1: PACKAGE BODY EGO_DATA_SECURITY AS
2: /* $Header: EGOPFDSB.pls 120.37.12020000.2 2013/01/15 03:08:16 jawan ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'EGO_DATA_SECURITY';
5: G_LOG_HEAD CONSTANT VARCHAR2(40):= 'fnd.plsql.ego.EGO_DATA_SECURITY.';
6: G_TYPE_SET CONSTANT VARCHAR2(30):= 'SET';
7: G_TYPE_INSTANCE CONSTANT VARCHAR2(30):= 'INSTANCE';
8: G_TYPE_UNIVERSAL CONSTANT VARCHAR2(30):= 'UNIVERSAL';

Line 5: G_LOG_HEAD CONSTANT VARCHAR2(40):= 'fnd.plsql.ego.EGO_DATA_SECURITY.';

1: PACKAGE BODY EGO_DATA_SECURITY AS
2: /* $Header: EGOPFDSB.pls 120.37.12020000.2 2013/01/15 03:08:16 jawan ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'EGO_DATA_SECURITY';
5: G_LOG_HEAD CONSTANT VARCHAR2(40):= 'fnd.plsql.ego.EGO_DATA_SECURITY.';
6: G_TYPE_SET CONSTANT VARCHAR2(30):= 'SET';
7: G_TYPE_INSTANCE CONSTANT VARCHAR2(30):= 'INSTANCE';
8: G_TYPE_UNIVERSAL CONSTANT VARCHAR2(30):= 'UNIVERSAL';
9:

Line 3915: FND_MESSAGE.SET_TOKEN('ROUTINE', 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');

3911:
3912: if ((lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
3913: AND (p_statement_type = 'BASE')) then
3914: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
3915: FND_MESSAGE.SET_TOKEN('ROUTINE', 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
3916: FND_MESSAGE.SET_TOKEN('REASON',
3917: 'The predicate was longer than the database VPD limit of '||
3918: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
3919: x_return_status := 'L'; /* Indicate Error */

Line 4403: 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');

4399: if ((lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
4400: AND (p_statement_type = 'BASE'))then
4401: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
4402: FND_MESSAGE.SET_TOKEN('ROUTINE',
4403: 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
4404: FND_MESSAGE.SET_TOKEN('REASON',
4405: 'The predicate was longer than the database VPD limit of '||
4406: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
4407: x_return_status := 'L'; /* Indicate Error */

Line 4888: FND_MESSAGE.SET_TOKEN('ROUTINE','EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');

4884:
4885: if ( (lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
4886: AND (p_statement_type = 'BASE'))then
4887: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
4888: FND_MESSAGE.SET_TOKEN('ROUTINE','EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
4889: FND_MESSAGE.SET_TOKEN('REASON',
4890: 'The predicate was longer than the database VPD limit of '||
4891: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
4892: x_return_status := 'L'; /* Indicate Error */

Line 4950: EGO_DATA_SECURITY.get_inherited_predicate

4946: IS
4947: BEGIN
4948: --null;
4949:
4950: EGO_DATA_SECURITY.get_inherited_predicate
4951: (
4952: p_api_version => p_api_version,
4953: p_function => p_function,
4954: p_object_name => p_object_name,

Line 5002: EGO_DATA_SECURITY.get_inherited_predicate

4998: ) IS
4999: l_clob_predicate CLOB;
5000: BEGIN
5001:
5002: EGO_DATA_SECURITY.get_inherited_predicate
5003: (
5004: p_api_version => p_api_version,
5005: p_function => p_function,
5006: p_object_name => p_object_name,

Line 5742: --dbms_output.put_line('EGO_DATA_SECURITY: l_table_index ' || l_table_index);

5738: if (p_statement_type = 'EXISTS') then
5739: l_parent_predicate := l_parent_predicate ||
5740: ' WHERE grants.INSTANCE_PK1_VALUE=to_char('|| p_parent_obj_pk1alias_tbl(l_table_index)||')';
5741:
5742: --dbms_output.put_line('EGO_DATA_SECURITY: l_table_index ' || l_table_index);
5743:
5744: --dbms_output.put_line('EGO_DATA_SECURITY: p_parent_obj_pk2alias_tbl ' || p_parent_obj_pk2alias_tbl(l_table_index));
5745: IF (p_parent_obj_pk2alias_tbl IS NOT NULL AND
5746: p_parent_obj_pk2alias_tbl.exists(l_table_index)) THEN

Line 5744: --dbms_output.put_line('EGO_DATA_SECURITY: p_parent_obj_pk2alias_tbl ' || p_parent_obj_pk2alias_tbl(l_table_index));

5740: ' WHERE grants.INSTANCE_PK1_VALUE=to_char('|| p_parent_obj_pk1alias_tbl(l_table_index)||')';
5741:
5742: --dbms_output.put_line('EGO_DATA_SECURITY: l_table_index ' || l_table_index);
5743:
5744: --dbms_output.put_line('EGO_DATA_SECURITY: p_parent_obj_pk2alias_tbl ' || p_parent_obj_pk2alias_tbl(l_table_index));
5745: IF (p_parent_obj_pk2alias_tbl IS NOT NULL AND
5746: p_parent_obj_pk2alias_tbl.exists(l_table_index)) THEN
5747: --dbms_output.put_line('EGO_DATA_SECURITY: p_parent_obj_pk2alias_tbl in if statement');
5748: l_parent_predicate := l_parent_predicate ||

Line 5747: --dbms_output.put_line('EGO_DATA_SECURITY: p_parent_obj_pk2alias_tbl in if statement');

5743:
5744: --dbms_output.put_line('EGO_DATA_SECURITY: p_parent_obj_pk2alias_tbl ' || p_parent_obj_pk2alias_tbl(l_table_index));
5745: IF (p_parent_obj_pk2alias_tbl IS NOT NULL AND
5746: p_parent_obj_pk2alias_tbl.exists(l_table_index)) THEN
5747: --dbms_output.put_line('EGO_DATA_SECURITY: p_parent_obj_pk2alias_tbl in if statement');
5748: l_parent_predicate := l_parent_predicate ||
5749: ' AND grants.INSTANCE_PK2_VALUE= to_char('|| p_parent_obj_pk2alias_tbl(l_table_index)||')';
5750: END IF;
5751:

Line 5909: 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');

5905: if ( (lengthb(l_aggregate_predicate) > g_vpd_buf_limit)
5906: AND (p_statement_type = 'BASE'))then
5907: FND_MESSAGE.SET_NAME('FND', 'GENERIC-INTERNAL ERROR');
5908: FND_MESSAGE.SET_TOKEN('ROUTINE',
5909: 'EGO_DATA_SECURITY.GET_SECURITY_PREDICATE');
5910: FND_MESSAGE.SET_TOKEN('REASON',
5911: 'The predicate was longer than the database VPD limit of '||
5912: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
5913: x_return_status := 'L'; /* Indicate Error */

Line 8233: END EGO_DATA_SECURITY;

8229: RETURN G_RETURN_UNEXP_ERR;
8230: END check_inherited_function;
8231:
8232: ----------------------------------------------------------------
8233: END EGO_DATA_SECURITY;