DBA Data[Home] [Help]

APPS.AMS_ACCESS_PVT dependencies on FND_GLOBAL

Line 186: FND_GLOBAL.user_id,

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

Line 188: FND_GLOBAL.user_id,

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,

Line 189: FND_GLOBAL.conc_login_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,
193: l_access_rec.user_or_role_id,

Line 294: FND_GLOBAL.user_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

Line 296: FND_GLOBAL.user_id,

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',

Line 297: FND_GLOBAL.conc_login_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',
301: l_access_rec.user_or_role_id,

Line 629: last_update_login = fnd_global.conc_login_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:

Line 630: last_updated_by = fnd_global.user_id

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

Line 665: last_update_login = fnd_global.conc_login_id,

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

Line 666: last_updated_by = fnd_global.user_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;

Line 1033: last_updated_by = FND_GLOBAL.user_id,

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,

Line 1034: last_update_login = FND_GLOBAL.conc_login_id,

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,

Line 1069: last_updated_by = FND_GLOBAL.user_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',

Line 1070: last_update_login = FND_GLOBAL.conc_login_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',
1074: user_or_role_id = l_access_rec.user_or_role_id,

Line 1337: last_updated_by = FND_GLOBAL.user_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,

Line 1338: last_update_login = FND_GLOBAL.conc_login_id,

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

Line 2293: p_view_application_id => fnd_global.resp_appl_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

Line 2307: p_view_application_id => fnd_global.resp_appl_id

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',