116: X_Quota_Id
117: ,X_Comp_Plan_Id
118: ,X_Quota_Assign_Id
119: ,X_Quota_Sequence
120: ,fnd_global.user_id
121: ,sysdate
122: ,fnd_global.user_id
123: ,sysdate
124: ,fnd_global.login_id
118: ,X_Quota_Assign_Id
119: ,X_Quota_Sequence
120: ,fnd_global.user_id
121: ,sysdate
122: ,fnd_global.user_id
123: ,sysdate
124: ,fnd_global.login_id
125: ,0
126: ,X_ORG_ID );
120: ,fnd_global.user_id
121: ,sysdate
122: ,fnd_global.user_id
123: ,sysdate
124: ,fnd_global.login_id
125: ,0
126: ,X_ORG_ID );
127:
128: FOR rep_rec IN reps(x_comp_plan_id) LOOP
241: UPDATE cn_quota_assigns
242: SET quota_id = x_quota_id
243: ,comp_plan_id = x_comp_plan_id
244: ,quota_sequence = X_Quota_Sequence
245: ,last_updated_by = fnd_global.user_id
246: ,last_update_date = sysdate
247: ,last_update_login = fnd_global.login_id
248: ,object_version_number = object_version_number + 1
249: WHERE quota_assign_id = x_quota_assign_id;
243: ,comp_plan_id = x_comp_plan_id
244: ,quota_sequence = X_Quota_Sequence
245: ,last_updated_by = fnd_global.user_id
246: ,last_update_date = sysdate
247: ,last_update_login = fnd_global.login_id
248: ,object_version_number = object_version_number + 1
249: WHERE quota_assign_id = x_quota_assign_id;
250:
251: IF (SQL%NOTFOUND) THEN