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_GRANTS_PKG dependencies on FND_GRANTS

Line 1: package body FND_GRANTS_PKG as

1: package body FND_GRANTS_PKG as
2: /* $Header: AFSCGNTB.pls 120.6 2006/04/29 02:28:43 stadepal ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'FND_GRANTS_PKG';
5: G_LOG_HEAD CONSTANT VARCHAR2(30):= 'fnd.plsql.FND_GRANTS_PKG.';

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

1: package body FND_GRANTS_PKG as
2: /* $Header: AFSCGNTB.pls 120.6 2006/04/29 02:28:43 stadepal ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'FND_GRANTS_PKG';
5: G_LOG_HEAD CONSTANT VARCHAR2(30):= 'fnd.plsql.FND_GRANTS_PKG.';
6:
7: procedure INSERT_ROW (
8: X_ROWID in out nocopy VARCHAR2,

Line 5: G_LOG_HEAD CONSTANT VARCHAR2(30):= 'fnd.plsql.FND_GRANTS_PKG.';

1: package body FND_GRANTS_PKG as
2: /* $Header: AFSCGNTB.pls 120.6 2006/04/29 02:28:43 stadepal ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'FND_GRANTS_PKG';
5: G_LOG_HEAD CONSTANT VARCHAR2(30):= 'fnd.plsql.FND_GRANTS_PKG.';
6:
7: procedure INSERT_ROW (
8: X_ROWID in out nocopy VARCHAR2,
9: X_GRANT_GUID in RAW,

Line 47: cursor C is select ROWID from FND_GRANTS

43: X_CTX_ORG_ID in NUMBER default -1,
44: X_NAME in VARCHAR2 default null,
45: X_DESCRIPTION in varchar2 default null
46: ) is
47: cursor C is select ROWID from FND_GRANTS
48: where GRANT_GUID = HEXTORAW(X_GRANT_GUID)
49: ;
50: -- Bug 5059644. Added an explicit HEXTORAW to improve the performance.
51: -- HEXTORAW is added for all grant_guid bindvariables used in FND_GRANTS

Line 51: -- HEXTORAW is added for all grant_guid bindvariables used in FND_GRANTS

47: cursor C is select ROWID from FND_GRANTS
48: where GRANT_GUID = HEXTORAW(X_GRANT_GUID)
49: ;
50: -- Bug 5059644. Added an explicit HEXTORAW to improve the performance.
51: -- HEXTORAW is added for all grant_guid bindvariables used in FND_GRANTS
52: -- SQL statement.
53:
54: l_orig_system varchar2(48) := NULL;
55: l_orig_system_id number := NULL;

Line 111: insert into FND_GRANTS (

107: else
108: l_instance_pk5_value := x_instance_pk5_value;
109: end if;
110:
111: insert into FND_GRANTS (
112: GRANT_GUID,
113: GRANTEE_TYPE,
114: GRANTEE_KEY,
115: MENU_ID,

Line 276: from FND_GRANTS

272: PROGRAM_NAME,
273: PROGRAM_TAG,
274: NAME,
275: DESCRIPTION
276: from FND_GRANTS
277: where GRANT_GUID = hextoraw(X_GRANT_GUID)
278: for update of GRANT_GUID nowait;
279: recinfo c%rowtype;
280:

Line 519: update FND_GRANTS set

515: app_exception.raise_exception;
516: end if;
517:
518: /* First version of update does not include name, description */
519: update FND_GRANTS set
520: GRANTEE_TYPE = X_GRANTEE_TYPE,
521: GRANTEE_KEY = L_GRANTEE_KEY,
522: MENU_ID = X_MENU_ID,
523: START_DATE = X_START_DATE,

Line 557: update FND_GRANTS set

553: GRANTEE_ORIG_SYSTEM_ID = l_orig_system_id
554: where GRANT_GUID = hextoraw(X_GRANT_GUID);
555: else
556: /* Second version of update includes name, description */
557: update FND_GRANTS set
558: GRANTEE_TYPE = X_GRANTEE_TYPE,
559: GRANTEE_KEY = L_GRANTEE_KEY,
560: MENU_ID = X_MENU_ID,
561: START_DATE = X_START_DATE,

Line 633: fnd_grants_pkg.LOAD_ROW (

629: X_CUSTOM_MODE in VARCHAR2
630: ) is
631: begin
632:
633: fnd_grants_pkg.LOAD_ROW (
634: X_GRANT_GUID => X_GRANT_GUID,
635: X_GRANTEE_TYPE => X_GRANTEE_TYPE,
636: X_GRANTEE_KEY => X_GRANTEE_KEY,
637: X_MENU_NAME => X_MENU_NAME,

Line 917: from fnd_grants

913: /* If there isn't yet any row, this will raise a no_data_found*/
914: /* exception and a new row will get inserted. */
915: select last_updated_by, last_update_date
916: into db_luby, db_ludate
917: from fnd_grants
918: where grant_guid = hextoraw(X_GRANT_GUID);
919:
920: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
921: db_ludate, X_CUSTOM_MODE)) then

Line 922: FND_GRANTS_PKG.UPDATE_ROW(

918: where grant_guid = hextoraw(X_GRANT_GUID);
919:
920: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
921: db_ludate, X_CUSTOM_MODE)) then
922: FND_GRANTS_PKG.UPDATE_ROW(
923: X_GRANT_GUID => hextoraw(X_GRANT_GUID),
924: X_GRANTEE_TYPE => X_GRANTEE_TYPE,
925: X_GRANTEE_KEY => L_GRANTEE_KEY,
926: X_MENU_ID => mnu_id,

Line 978: FND_GRANTS_PKG.INSERT_ROW(

974: l_description := x_description;
975: end if;
976:
977:
978: FND_GRANTS_PKG.INSERT_ROW(
979: X_ROWID => row_id,
980: X_GRANT_GUID => hextoraw(X_GRANT_GUID),
981: X_GRANTEE_TYPE => X_GRANTEE_TYPE,
982: X_GRANTEE_KEY => L_GRANTEE_KEY,

Line 1074: l_menu_id fnd_grants.menu_id%TYPE;

1070: -- to change i.e. for eg. 1.X to 2.X.
1071: -- On addition of any Optional parameters the minor version needs
1072: -- to change i.e. for eg. X.6 to X.7.
1073: l_api_version CONSTANT NUMBER := 1.0;
1074: l_menu_id fnd_grants.menu_id%TYPE;
1075: l_sys_date DATE := Sysdate;
1076: l_user_id number:=fnd_global.user_id;
1077: l_grant_guid raw(16);
1078: l_row_id varchar2(18) ;

Line 1361: UPDATE fnd_grants

1357: ||P_GRANT_GUID);
1358: app_exception.raise_exception;
1359: end if;
1360: /* Don't update name and description */
1361: UPDATE fnd_grants
1362: SET start_date=p_start_date,
1363: end_date=p_end_date
1364: WHERE grant_guid= hextoraw(p_grant_guid);
1365: else

Line 1367: UPDATE fnd_grants

1363: end_date=p_end_date
1364: WHERE grant_guid= hextoraw(p_grant_guid);
1365: else
1366: /* This version updates name and description */
1367: UPDATE fnd_grants
1368: SET start_date=p_start_date,
1369: end_date=p_end_date,
1370: name = p_name,
1371: description = p_description

Line 1379: from fnd_grants

1375: -- Added for Function Security Cache Invalidation Project
1376: -- bug 3554601 added object_id to verify Function Security
1377: select grantee_type, grantee_key, object_id
1378: into l_grantee_type, l_grantee_key, l_object_id
1379: from fnd_grants
1380: where grant_guid= hextoraw(p_grant_guid);
1381:
1382: -- bug 3554601 - Only raise the event if it is Function Security not for
1383: -- Data Security events.

Line 1482: from fnd_grants

1478: -- Pick out the row first, before it gets deleted.
1479: -- bug 3554601 added object_id to verify Function Security
1480: select grantee_type, grantee_key, object_id
1481: into l_grantee_type, l_grantee_key, l_object_id
1482: from fnd_grants
1483: where grant_guid= hextoraw(X_GRANT_GUID);
1484:
1485: delete from FND_GRANTS
1486: where GRANT_GUID = hextoraw(X_GRANT_GUID);

Line 1485: delete from FND_GRANTS

1481: into l_grantee_type, l_grantee_key, l_object_id
1482: from fnd_grants
1483: where grant_guid= hextoraw(X_GRANT_GUID);
1484:
1485: delete from FND_GRANTS
1486: where GRANT_GUID = hextoraw(X_GRANT_GUID);
1487:
1488: if (sql%notfound) then
1489: raise no_data_found;

Line 1548: 'FND_GRANTS_DELETE_PKG.delete_grant()');

1544: IF(p_grantee_type is NULL AND p_object_name is NULL AND p_menu_name IS NULL
1545: AND p_program_name is NULL) THEN
1546: fnd_message.set_name('FND','FND_ROUTINE_INVALID_ARGS');
1547: fnd_message.set_token('ROUTINE',
1548: 'FND_GRANTS_DELETE_PKG.delete_grant()');
1549: fnd_msg_pub.ADD; /* Add for backward compatibility because in */
1550: /* the past this API put messages on fnd_msg_pub */
1551: /* stack. That's obsolete. FND_MESSAGE is now */
1552: /* used. */

Line 1555: 'FND_GRANTS_DELETE_PKG.delete_grant()');

1551: /* stack. That's obsolete. FND_MESSAGE is now */
1552: /* used. */
1553: fnd_message.set_name('FND','FND_ROUTINE_INVALID_ARGS');
1554: fnd_message.set_token('ROUTINE',
1555: 'FND_GRANTS_DELETE_PKG.delete_grant()');
1556: x_success := 'F';
1557: x_errcode := -1;
1558: return;
1559: END IF;

Line 1563: del_sql_stmt := 'DELETE FROM FND_GRANTS';

1559: END IF;
1560:
1561: -- bug3625804 initialize the delete and select statement
1562:
1563: del_sql_stmt := 'DELETE FROM FND_GRANTS';
1564: sel_sql_stmt := 'SELECT GRANT_GUID FROM FND_GRANTS';
1565: where_clause := fnd_global.newline||'WHERE 1=1 ';
1566:
1567: grantee_stmt := fnd_global.newline||'AND grantee_type = '''||

Line 1564: sel_sql_stmt := 'SELECT GRANT_GUID FROM FND_GRANTS';

1560:
1561: -- bug3625804 initialize the delete and select statement
1562:
1563: del_sql_stmt := 'DELETE FROM FND_GRANTS';
1564: sel_sql_stmt := 'SELECT GRANT_GUID FROM FND_GRANTS';
1565: where_clause := fnd_global.newline||'WHERE 1=1 ';
1566:
1567: grantee_stmt := fnd_global.newline||'AND grantee_type = '''||
1568: replace(p_grantee_type, '''', '''''')||''' AND grantee_key = '''||

Line 1723: from fnd_grants

1719: begin
1720: -- bug 3554601 added object_id to verify Function Security
1721: select grantee_type, grantee_key, object_id
1722: into l_grantee_type, l_grantee_key, l_object_id
1723: from fnd_grants
1724: where grant_guid = hextoraw(p_grant_guid);
1725:
1726: wf_directory.GetRoleOrigSysInfo(
1727: Role => l_grantee_key,

Line 1731: UPDATE fnd_grants

1727: Role => l_grantee_key,
1728: Orig_System => l_orig_system,
1729: Orig_System_Id => l_orig_system_id);
1730:
1731: UPDATE fnd_grants
1732: SET grantee_orig_system = l_orig_system,
1733: grantee_orig_system_id = l_orig_system_id
1734: WHERE grant_guid= hextoraw(p_grant_guid);
1735:

Line 1758: from fnd_grants

1754: -- the need to call this routine.
1755: procedure fill_in_missing_orig_columns is
1756: cursor find_missing_cols_c is
1757: select grant_guid
1758: from fnd_grants
1759: where grantee_key is not NULL
1760: and grantee_orig_system is NULL;
1761: begin
1762: for c1 in find_missing_cols_c loop

Line 1769: /* columns INSTANCE_PKX_VALUE in the table FND_GRANTS. */

1765: end fill_in_missing_orig_columns;
1766:
1767: /* CONVERT_NULLS- For install time use only, not a */
1768: /* runtime routine. This routine will convert NULL to '*NULL*' in the */
1769: /* columns INSTANCE_PKX_VALUE in the table FND_GRANTS. */
1770: /* The reason for this routine is that we decided to have those columns be */
1771: /* non-NULL in order to speed up queries that go against different numbers */
1772: /* of pk columns. This should be run once at patch application time and */
1773: /* should never need to be run again. This will be included in the ATG */

Line 1788: from fnd_grants

1784: instance_pk2_value,
1785: instance_pk3_value,
1786: instance_pk4_value,
1787: instance_pk5_value
1788: from fnd_grants
1789: where (instance_pk1_value is NULL)
1790: or (instance_pk2_value is NULL)
1791: or (instance_pk3_value is NULL)
1792: or (instance_pk4_value is NULL)

Line 1831: from fnd_grants

1827:
1828: -- bug 3554601 added object_id to verify Function Security
1829: select grantee_type, grantee_key, object_id
1830: into l_grantee_type, l_grantee_key, l_object_id
1831: from fnd_grants
1832: where grant_guid = hextoraw(l_guid);
1833:
1834: update fnd_grants set
1835: instance_pk1_value = l_pk1,

Line 1834: update fnd_grants set

1830: into l_grantee_type, l_grantee_key, l_object_id
1831: from fnd_grants
1832: where grant_guid = hextoraw(l_guid);
1833:
1834: update fnd_grants set
1835: instance_pk1_value = l_pk1,
1836: instance_pk2_value = l_pk2,
1837: instance_pk3_value = l_pk3,
1838: instance_pk4_value = l_pk4,

Line 1860: end FND_GRANTS_PKG;

1856: commit;
1857: return i;
1858: end;
1859:
1860: end FND_GRANTS_PKG;