182: delete_flag )
183: VALUES(
184: l_access_rec.activity_access_id,
185: SYSDATE,
186: FND_GLOBAL.user_id,
187: SYSDATE,
188: FND_GLOBAL.user_id,
189: FND_GLOBAL.conc_login_id,
190: 1, -- object_version_number
184: l_access_rec.activity_access_id,
185: SYSDATE,
186: FND_GLOBAL.user_id,
187: SYSDATE,
188: FND_GLOBAL.user_id,
189: FND_GLOBAL.conc_login_id,
190: 1, -- object_version_number
191: l_access_rec.act_access_to_object_id,
192: l_access_rec.arc_act_access_to_object,
185: SYSDATE,
186: FND_GLOBAL.user_id,
187: SYSDATE,
188: FND_GLOBAL.user_id,
189: FND_GLOBAL.conc_login_id,
190: 1, -- object_version_number
191: l_access_rec.act_access_to_object_id,
192: l_access_rec.arc_act_access_to_object,
193: l_access_rec.user_or_role_id,
290: delete_flag )
291: SELECT
292: l_access_rec.activity_access_id,
293: SYSDATE,
294: FND_GLOBAL.user_id,
295: SYSDATE,
296: FND_GLOBAL.user_id,
297: FND_GLOBAL.conc_login_id,
298: 1, -- object_version_number
292: l_access_rec.activity_access_id,
293: SYSDATE,
294: FND_GLOBAL.user_id,
295: SYSDATE,
296: FND_GLOBAL.user_id,
297: FND_GLOBAL.conc_login_id,
298: 1, -- object_version_number
299: l_schedule_rec.schedule_id,
300: 'CSCH',
293: SYSDATE,
294: FND_GLOBAL.user_id,
295: SYSDATE,
296: FND_GLOBAL.user_id,
297: FND_GLOBAL.conc_login_id,
298: 1, -- object_version_number
299: l_schedule_rec.schedule_id,
300: 'CSCH',
301: l_access_rec.user_or_role_id,
625:
626: UPDATE ams_act_access
627: SET delete_flag = 'Y',
628: last_update_date = sysdate,
629: last_update_login = fnd_global.conc_login_id,
630: last_updated_by = fnd_global.user_id
631: WHERE activity_access_id = p_access_id
632: AND object_version_number = p_object_version;
633:
626: UPDATE ams_act_access
627: SET delete_flag = 'Y',
628: last_update_date = sysdate,
629: last_update_login = fnd_global.conc_login_id,
630: last_updated_by = fnd_global.user_id
631: WHERE activity_access_id = p_access_id
632: AND object_version_number = p_object_version;
633:
634: IF (SQL%NOTFOUND) THEN
661: EXIT WHEN c_access_camp_schedules%NOTFOUND ;
662: UPDATE ams_act_access
663: SET delete_flag = 'Y',
664: last_update_date = sysdate,
665: last_update_login = fnd_global.conc_login_id,
666: last_updated_by = fnd_global.user_id
667: WHERE act_access_to_object_id = l_schedule_rec.schedule_id
668: AND arc_act_access_to_object = 'CSCH'
669: AND user_or_role_id = l_role_id
662: UPDATE ams_act_access
663: SET delete_flag = 'Y',
664: last_update_date = sysdate,
665: last_update_login = fnd_global.conc_login_id,
666: last_updated_by = fnd_global.user_id
667: WHERE act_access_to_object_id = l_schedule_rec.schedule_id
668: AND arc_act_access_to_object = 'CSCH'
669: AND user_or_role_id = l_role_id
670: AND arc_user_or_role_type = l_role_type;
1029: END IF;
1030:
1031: UPDATE ams_act_access SET
1032: last_update_date = SYSDATE,
1033: last_updated_by = FND_GLOBAL.user_id,
1034: last_update_login = FND_GLOBAL.conc_login_id,
1035: object_version_number = l_access_rec.object_version_number + 1,
1036: act_access_to_object_id = l_access_rec.act_access_to_object_id,
1037: arc_act_access_to_object = l_access_rec.arc_act_access_to_object,
1030:
1031: UPDATE ams_act_access SET
1032: last_update_date = SYSDATE,
1033: last_updated_by = FND_GLOBAL.user_id,
1034: last_update_login = FND_GLOBAL.conc_login_id,
1035: object_version_number = l_access_rec.object_version_number + 1,
1036: act_access_to_object_id = l_access_rec.act_access_to_object_id,
1037: arc_act_access_to_object = l_access_rec.arc_act_access_to_object,
1038: user_or_role_id = l_access_rec.user_or_role_id,
1065: CLOSE c_get_key_id;
1066:
1067: UPDATE ams_act_access SET
1068: last_update_date = SYSDATE,
1069: last_updated_by = FND_GLOBAL.user_id,
1070: last_update_login = FND_GLOBAL.conc_login_id,
1071: object_version_number = object_version_number + 1,
1072: act_access_to_object_id = l_schedule_rec.schedule_id,
1073: arc_act_access_to_object = 'CSCH',
1066:
1067: UPDATE ams_act_access SET
1068: last_update_date = SYSDATE,
1069: last_updated_by = FND_GLOBAL.user_id,
1070: last_update_login = FND_GLOBAL.conc_login_id,
1071: object_version_number = object_version_number + 1,
1072: act_access_to_object_id = l_schedule_rec.schedule_id,
1073: arc_act_access_to_object = 'CSCH',
1074: user_or_role_id = l_access_rec.user_or_role_id,
1333: END IF; -- added by sveerave on 06-jun-2002
1334: -- ELSE -- update owner to new resource
1335: UPDATE ams_act_access SET
1336: last_update_date = SYSDATE,
1337: last_updated_by = FND_GLOBAL.user_id,
1338: last_update_login = FND_GLOBAL.conc_login_id,
1339: object_version_number = object_version_number + 1,
1340: act_access_to_object_id = p_object_id,
1341: arc_act_access_to_object = p_object_type,
1334: -- ELSE -- update owner to new resource
1335: UPDATE ams_act_access SET
1336: last_update_date = SYSDATE,
1337: last_updated_by = FND_GLOBAL.user_id,
1338: last_update_login = FND_GLOBAL.conc_login_id,
1339: object_version_number = object_version_number + 1,
1340: act_access_to_object_id = p_object_id,
1341: arc_act_access_to_object = p_object_type,
1342: user_or_role_id = p_resource_id
2289: /*
2290: IF AMS_Utility_PVT.check_lookup_exists(
2291: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
2292: p_lookup_code => p_Access_rec.arc_user_or_role_type,
2293: p_view_application_id => fnd_global.resp_appl_id
2294: ) = FND_API.g_false
2295: THEN
2296: */
2297: -- Correcting the p_lookup_code value getting passed for bug# 2419540
2303: -- So, changing code to check in 530 if not found in appl_id. -- bug#2421583
2304: IF AMS_Utility_PVT.check_lookup_exists(
2305: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
2306: p_lookup_code => p_Access_rec.arc_act_access_to_object,
2307: p_view_application_id => fnd_global.resp_appl_id
2308: ) = FND_API.g_false
2309: THEN
2310: IF AMS_Utility_PVT.check_lookup_exists(
2311: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',