152: l_act_category_rec.activity_category_id,
153:
154: -- standard who columns
155: sysdate,
156: FND_GLOBAL.User_Id,
157: sysdate,
158: FND_GLOBAL.User_Id,
159: FND_GLOBAL.Conc_Login_Id,
160:
154: -- standard who columns
155: sysdate,
156: FND_GLOBAL.User_Id,
157: sysdate,
158: FND_GLOBAL.User_Id,
159: FND_GLOBAL.Conc_Login_Id,
160:
161: 1, -- object_version_number
162: l_act_category_rec.act_category_used_by_id,
155: sysdate,
156: FND_GLOBAL.User_Id,
157: sysdate,
158: FND_GLOBAL.User_Id,
159: FND_GLOBAL.Conc_Login_Id,
160:
161: 1, -- object_version_number
162: l_act_category_rec.act_category_used_by_id,
163: l_act_category_rec.arc_act_category_used_by,
330:
331: update AMS_ACT_CATEGORIES
332: set
333: last_update_date = sysdate
334: ,last_updated_by = FND_GLOBAL.User_Id
335: ,last_update_login = FND_GLOBAL.Conc_Login_Id
336:
337: ,object_version_number = l_act_category_rec.object_version_number+1
338: ,act_category_used_by_id = l_act_category_rec.act_category_used_by_id
331: update AMS_ACT_CATEGORIES
332: set
333: last_update_date = sysdate
334: ,last_updated_by = FND_GLOBAL.User_Id
335: ,last_update_login = FND_GLOBAL.Conc_Login_Id
336:
337: ,object_version_number = l_act_category_rec.object_version_number+1
338: ,act_category_used_by_id = l_act_category_rec.act_category_used_by_id
339: ,arc_act_category_used_by = l_act_category_rec.arc_act_category_used_by