1932: )
1933: VALUES (
1934: l_act_metrics_rec.activity_metric_id,
1935: l_today,
1936: Fnd_Global.User_ID,
1937: l_today,
1938: Fnd_Global.User_ID,
1939: Fnd_Global.Conc_Login_ID,
1940: 1, --Object Version Number
1934: l_act_metrics_rec.activity_metric_id,
1935: l_today,
1936: Fnd_Global.User_ID,
1937: l_today,
1938: Fnd_Global.User_ID,
1939: Fnd_Global.Conc_Login_ID,
1940: 1, --Object Version Number
1941: l_act_metrics_rec.act_metric_used_by_id,
1942: l_act_metrics_rec.arc_act_metric_used_by,
1935: l_today,
1936: Fnd_Global.User_ID,
1937: l_today,
1938: Fnd_Global.User_ID,
1939: Fnd_Global.Conc_Login_ID,
1940: 1, --Object Version Number
1941: l_act_metrics_rec.act_metric_used_by_id,
1942: l_act_metrics_rec.arc_act_metric_used_by,
1943: NVL(l_act_metrics_rec.purchase_req_raised_flag,'N'),
2449: published_flag = l_actmet_rec.published_flag,
2450: pre_function_name = l_actmet_rec.pre_function_name,
2451: post_function_name = l_actmet_rec.post_function_name,
2452: last_update_date = SYSDATE,
2453: last_updated_by = Fnd_Global.User_ID,
2454: last_update_login = Fnd_Global.Conc_Login_ID,
2455: attribute_category = l_actmet_rec.attribute_category,
2456: attribute1 = l_actmet_rec.attribute1,
2457: attribute2 = l_actmet_rec.attribute2,
2450: pre_function_name = l_actmet_rec.pre_function_name,
2451: post_function_name = l_actmet_rec.post_function_name,
2452: last_update_date = SYSDATE,
2453: last_updated_by = Fnd_Global.User_ID,
2454: last_update_login = Fnd_Global.Conc_Login_ID,
2455: attribute_category = l_actmet_rec.attribute_category,
2456: attribute1 = l_actmet_rec.attribute1,
2457: attribute2 = l_actmet_rec.attribute2,
2458: attribute3 = l_actmet_rec.attribute3,
4193: -- choang - 11-may-2005 - validate edit metric access
4194: IF AMS_Access_PVT.check_update_access (
4195: p_object_id => l_act_metrics_rec.act_metric_used_by_id,
4196: p_object_type => l_act_metrics_rec.arc_act_metric_used_by,
4197: p_user_or_role_id => AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id),
4198: p_user_or_role_type => 'USER') <> 'F' THEN
4199: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4200: FND_MESSAGE.set_name ('AMS', 'AMS_NO_METRIC_UPDATE_ACCESS');
4201: FND_MESSAGE.set_token('OBJECT',
7149: UPDATE ams_act_metrics_all
7150: SET
7151: object_version_number = object_version_number + 1,
7152: last_update_date = SYSDATE,
7153: last_updated_by = Fnd_Global.User_ID,
7154: last_update_login = Fnd_Global.Conc_Login_ID,
7155: variable_value = metrics_rec.variable_value,
7156: forecasted_variable_value = metrics_rec.forecasted_variable_value
7157: WHERE activity_metric_id = l_activity_metric_id
7150: SET
7151: object_version_number = object_version_number + 1,
7152: last_update_date = SYSDATE,
7153: last_updated_by = Fnd_Global.User_ID,
7154: last_update_login = Fnd_Global.Conc_Login_ID,
7155: variable_value = metrics_rec.variable_value,
7156: forecasted_variable_value = metrics_rec.forecasted_variable_value
7157: WHERE activity_metric_id = l_activity_metric_id
7158: and metric_id = metrics_rec.metric_id