DBA Data[Home] [Help]

APPS.CN_QUOTA_ASSIGNS_PKG dependencies on FND_GLOBAL

Line 120: ,fnd_global.user_id

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

Line 122: ,fnd_global.user_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 );

Line 124: ,fnd_global.login_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

Line 245: ,last_updated_by = fnd_global.user_id

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;

Line 247: ,last_update_login = fnd_global.login_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