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

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

58: P_CASCADE_FLAG,
59: P_OBJECT_VERSION_NUMBER,
60: P_GRANT_ID,
61: P_OBJECT_ID,
62: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date),
63: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_created_by),
64: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_last_update_date),
65: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_last_updated_by),
66: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,NULL, FND_GLOBAL.login_id, p_last_update_login)

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

59: P_OBJECT_VERSION_NUMBER,
60: P_GRANT_ID,
61: P_OBJECT_ID,
62: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date),
63: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_created_by),
64: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_last_update_date),
65: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_last_updated_by),
66: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,NULL, FND_GLOBAL.login_id, p_last_update_login)
67: );

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

60: P_GRANT_ID,
61: P_OBJECT_ID,
62: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date),
63: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_created_by),
64: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_last_update_date),
65: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_last_updated_by),
66: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,NULL, FND_GLOBAL.login_id, p_last_update_login)
67: );
68:

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

61: P_OBJECT_ID,
62: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date),
63: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_created_by),
64: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_last_update_date),
65: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_last_updated_by),
66: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,NULL, FND_GLOBAL.login_id, p_last_update_login)
67: );
68:
69: OPEN c;

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

62: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date),
63: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_created_by),
64: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_last_update_date),
65: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,NULL, FND_GLOBAL.user_id, p_last_updated_by),
66: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,NULL, FND_GLOBAL.login_id, p_last_update_login)
67: );
68:
69: OPEN c;
70: FETCH c INTO PX_ROWID;

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

160: GRANT_LEVEL = P_GRANT_LEVEL,
161: CASCADE_FLAG = P_CASCADE_FLAG,
162: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
163: OBJECT_ID = P_OBJECT_ID,
164: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
165: NULL, SYSDATE, p_last_update_date),
166: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
167: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
168: p_last_updated_by),

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

162: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
163: OBJECT_ID = P_OBJECT_ID,
164: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
165: NULL, SYSDATE, p_last_update_date),
166: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
167: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
168: p_last_updated_by),
169: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
170: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

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

165: NULL, SYSDATE, p_last_update_date),
166: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
167: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
168: p_last_updated_by),
169: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
170: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
171: p_last_update_login)
172: WHERE GRANT_ID = P_GRANT_ID
173: AND object_version_number = DECODE(p_object_version_number,

Line 174: FND_API.G_MISS_NUM,object_version_number,

170: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
171: p_last_update_login)
172: WHERE GRANT_ID = P_GRANT_ID
173: AND object_version_number = DECODE(p_object_version_number,
174: FND_API.G_MISS_NUM,object_version_number,
175: NULL,object_version_number,
176: p_object_version_number);
177:
178: IF (SQL%NOTFOUND) THEN