89: ) values (
90: px_forecast_line_id
91: ,1
92: ,sysdate
93: ,fnd_global.user_id
94: ,fnd_global.login_id
95: ,fnd_global.user_id
96: ,sysdate
97: ,DECODE( p_forecast_element_id, FND_API.G_MISS_NUM, NULL,
90: px_forecast_line_id
91: ,1
92: ,sysdate
93: ,fnd_global.user_id
94: ,fnd_global.login_id
95: ,fnd_global.user_id
96: ,sysdate
97: ,DECODE( p_forecast_element_id, FND_API.G_MISS_NUM, NULL,
98: p_forecast_element_id)
91: ,1
92: ,sysdate
93: ,fnd_global.user_id
94: ,fnd_global.login_id
95: ,fnd_global.user_id
96: ,sysdate
97: ,DECODE( p_forecast_element_id, FND_API.G_MISS_NUM, NULL,
98: p_forecast_element_id)
99: ,DECODE( p_budget_version_id, FND_API.G_MISS_NUM, NULL,
172: BEGIN
173: UPDATE pa_org_forecast_lines
174: SET
175: record_version_number = nvl(record_version_number,0) +1
176: ,last_update_login = fnd_global.login_id
177: ,last_updated_by = fnd_global.user_id
178: ,last_update_date = sysdate
179: ,forecast_element_id = DECODE( p_forecast_element_id, FND_API.G_MISS_NUM,
180: forecast_element_id, p_forecast_element_id)
173: UPDATE pa_org_forecast_lines
174: SET
175: record_version_number = nvl(record_version_number,0) +1
176: ,last_update_login = fnd_global.login_id
177: ,last_updated_by = fnd_global.user_id
178: ,last_update_date = sysdate
179: ,forecast_element_id = DECODE( p_forecast_element_id, FND_API.G_MISS_NUM,
180: forecast_element_id, p_forecast_element_id)
181: ,budget_version_id = DECODE( p_budget_version_id, FND_API.G_MISS_NUM,