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: );
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;
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;
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)
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,