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.IBC_GRANT_GROUPS_PKG dependencies on FND_API

Line 35: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date),

31: LAST_UPDATE_LOGIN
32: ) VALUES (
33: P_OBJECT_VERSION_NUMBER,
34: P_GRANT_GROUP_ID,
35: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date),
36: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_created_by),
37: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_last_update_date),
38: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_last_updated_by),
39: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,NULL, FND_GLOBAL.login_id, p_last_update_login)

Line 36: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_created_by),

32: ) VALUES (
33: P_OBJECT_VERSION_NUMBER,
34: P_GRANT_GROUP_ID,
35: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date),
36: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_created_by),
37: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_last_update_date),
38: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_last_updated_by),
39: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,NULL, FND_GLOBAL.login_id, p_last_update_login)
40: );

Line 37: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_last_update_date),

33: P_OBJECT_VERSION_NUMBER,
34: P_GRANT_GROUP_ID,
35: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date),
36: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_created_by),
37: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_last_update_date),
38: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_last_updated_by),
39: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,NULL, FND_GLOBAL.login_id, p_last_update_login)
40: );
41:

Line 38: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_last_updated_by),

34: P_GRANT_GROUP_ID,
35: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date),
36: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_created_by),
37: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_last_update_date),
38: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_last_updated_by),
39: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,NULL, FND_GLOBAL.login_id, p_last_update_login)
40: );
41:
42: OPEN c;

Line 39: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,NULL, FND_GLOBAL.login_id, p_last_update_login)

35: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date),
36: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_created_by),
37: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_last_update_date),
38: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_last_updated_by),
39: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,NULL, FND_GLOBAL.login_id, p_last_update_login)
40: );
41:
42: OPEN c;
43: FETCH c INTO PX_ROWID;

Line 93: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,

89: ) IS
90: BEGIN
91: UPDATE IBC_GRANT_GROUPS SET
92: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
93: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
94: NULL, SYSDATE, p_last_update_date),
95: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
96: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
97: p_last_updated_by),

Line 95: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,

91: UPDATE IBC_GRANT_GROUPS SET
92: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
93: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
94: NULL, SYSDATE, p_last_update_date),
95: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
96: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
97: p_last_updated_by),
98: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
99: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

Line 98: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,

94: NULL, SYSDATE, p_last_update_date),
95: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
96: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
97: p_last_updated_by),
98: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
99: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
100: p_last_update_login)
101: WHERE GRANT_GROUP_ID = P_GRANT_GROUP_ID
102: AND object_version_number = DECODE(p_object_version_number,

Line 103: FND_API.G_MISS_NUM,object_version_number,

99: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
100: p_last_update_login)
101: WHERE GRANT_GROUP_ID = P_GRANT_GROUP_ID
102: AND object_version_number = DECODE(p_object_version_number,
103: FND_API.G_MISS_NUM,object_version_number,
104: NULL,object_version_number,
105: p_object_version_number);
106:
107: IF (SQL%NOTFOUND) THEN