DBA Data[Home] [Help]

APPS.IBC_GRANT_GROUPS_PKG dependencies on FND_GLOBAL

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

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

Line 99: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

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