51: ,ADJUSTMENT_COMMENTS
52: ) values (
53: px_adj_element_id
54: ,sysdate
55: ,fnd_global.user_id
56: ,fnd_global.login_id
57: ,fnd_global.user_id
58: ,sysdate
59: ,DECODE( p_budget_version_id, FND_API.G_MISS_NUM, NULL, p_budget_version_id)
52: ) values (
53: px_adj_element_id
54: ,sysdate
55: ,fnd_global.user_id
56: ,fnd_global.login_id
57: ,fnd_global.user_id
58: ,sysdate
59: ,DECODE( p_budget_version_id, FND_API.G_MISS_NUM, NULL, p_budget_version_id)
60: ,DECODE( p_project_id, FND_API.G_MISS_NUM, NULL, p_project_id)
53: px_adj_element_id
54: ,sysdate
55: ,fnd_global.user_id
56: ,fnd_global.login_id
57: ,fnd_global.user_id
58: ,sysdate
59: ,DECODE( p_budget_version_id, FND_API.G_MISS_NUM, NULL, p_budget_version_id)
60: ,DECODE( p_project_id, FND_API.G_MISS_NUM, NULL, p_project_id)
61: ,DECODE( p_task_id, FND_API.G_MISS_NUM, NULL, p_task_id)
93: IS
94: BEGIN
95: UPDATE pa_fp_adj_elements
96: SET
97: last_update_login = fnd_global.login_id
98: ,last_updated_by = fnd_global.user_id
99: ,last_update_date = sysdate
100: ,adj_element_id = DECODE( p_adj_element_id, FND_API.G_MISS_NUM,
101: adj_element_id, p_adj_element_id)
94: BEGIN
95: UPDATE pa_fp_adj_elements
96: SET
97: last_update_login = fnd_global.login_id
98: ,last_updated_by = fnd_global.user_id
99: ,last_update_date = sysdate
100: ,adj_element_id = DECODE( p_adj_element_id, FND_API.G_MISS_NUM,
101: adj_element_id, p_adj_element_id)
102: ,budget_version_id = DECODE( p_budget_version_id, FND_API.G_MISS_NUM,