DBA Data[Home] [Help]

APPS.IBC_GRANTS_PKG dependencies on FND_GLOBAL

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 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 167: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

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,
171: p_last_update_login)

Line 170: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

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,
174: FND_API.G_MISS_NUM,object_version_number,