39: ,p_fin_plan_version_id
40: ,p_task_id
41: ,1
42: ,sysdate
43: ,fnd_global.user_id
44: ,sysdate
45: ,fnd_global.user_id
46: ,fnd_global.login_id)
47: RETURNING rowid INTO x_row_id;
41: ,1
42: ,sysdate
43: ,fnd_global.user_id
44: ,sysdate
45: ,fnd_global.user_id
46: ,fnd_global.login_id)
47: RETURNING rowid INTO x_row_id;
48:
49: EXCEPTION
42: ,sysdate
43: ,fnd_global.user_id
44: ,sysdate
45: ,fnd_global.user_id
46: ,fnd_global.login_id)
47: RETURNING rowid INTO x_row_id;
48:
49: EXCEPTION
50: WHEN OTHERS THEN
93: ,record_version_number = DECODE(p_record_version_number,
94: FND_API.G_MISS_NUM, Null,
95: nvl(p_record_version_number,nvl(record_version_number,0)) + 1)
96: ,last_update_date = SYSDATE
97: ,last_updated_by = FND_GLOBAL.USER_ID
98: ,last_update_login = FND_GLOBAL.LOGIN_ID
99: WHERE rowid = p_row_id
100: AND nvl(record_version_number,0) = nvl(p_record_version_number, nvl(record_version_number,0));
101:
94: FND_API.G_MISS_NUM, Null,
95: nvl(p_record_version_number,nvl(record_version_number,0)) + 1)
96: ,last_update_date = SYSDATE
97: ,last_updated_by = FND_GLOBAL.USER_ID
98: ,last_update_login = FND_GLOBAL.LOGIN_ID
99: WHERE rowid = p_row_id
100: AND nvl(record_version_number,0) = nvl(p_record_version_number, nvl(record_version_number,0));
101:
102: IF (SQL%NOTFOUND) THEN