DBA Data[Home] [Help]

APPS.AMS_ACCESS_PVT dependencies on FND_GLOBAL

Line 211: FND_GLOBAL.user_id,

207: delete_flag )
208: VALUES(
209: l_access_rec.activity_access_id,
210: SYSDATE,
211: FND_GLOBAL.user_id,
212: SYSDATE,
213: FND_GLOBAL.user_id,
214: FND_GLOBAL.conc_login_id,
215: 1, -- object_version_number

Line 213: FND_GLOBAL.user_id,

209: l_access_rec.activity_access_id,
210: SYSDATE,
211: FND_GLOBAL.user_id,
212: SYSDATE,
213: FND_GLOBAL.user_id,
214: FND_GLOBAL.conc_login_id,
215: 1, -- object_version_number
216: l_access_rec.act_access_to_object_id,
217: l_access_rec.arc_act_access_to_object,

Line 214: FND_GLOBAL.conc_login_id,

210: SYSDATE,
211: FND_GLOBAL.user_id,
212: SYSDATE,
213: FND_GLOBAL.user_id,
214: FND_GLOBAL.conc_login_id,
215: 1, -- object_version_number
216: l_access_rec.act_access_to_object_id,
217: l_access_rec.arc_act_access_to_object,
218: l_access_rec.user_or_role_id,

Line 319: FND_GLOBAL.user_id,

315: delete_flag )
316: SELECT
317: l_access_rec.activity_access_id,
318: SYSDATE,
319: FND_GLOBAL.user_id,
320: SYSDATE,
321: FND_GLOBAL.user_id,
322: FND_GLOBAL.conc_login_id,
323: 1, -- object_version_number

Line 321: FND_GLOBAL.user_id,

317: l_access_rec.activity_access_id,
318: SYSDATE,
319: FND_GLOBAL.user_id,
320: SYSDATE,
321: FND_GLOBAL.user_id,
322: FND_GLOBAL.conc_login_id,
323: 1, -- object_version_number
324: l_schedule_rec.schedule_id,
325: 'CSCH',

Line 322: FND_GLOBAL.conc_login_id,

318: SYSDATE,
319: FND_GLOBAL.user_id,
320: SYSDATE,
321: FND_GLOBAL.user_id,
322: FND_GLOBAL.conc_login_id,
323: 1, -- object_version_number
324: l_schedule_rec.schedule_id,
325: 'CSCH',
326: l_access_rec.user_or_role_id,

Line 422: FND_GLOBAL.user_id,

418: SELECT
419:
420: l_access_rec.activity_access_id,
421: SYSDATE,
422: FND_GLOBAL.user_id,
423: SYSDATE,
424: FND_GLOBAL.user_id,
425: FND_GLOBAL.conc_login_id,
426: 1, -- object_version_number

Line 424: FND_GLOBAL.user_id,

420: l_access_rec.activity_access_id,
421: SYSDATE,
422: FND_GLOBAL.user_id,
423: SYSDATE,
424: FND_GLOBAL.user_id,
425: FND_GLOBAL.conc_login_id,
426: 1, -- object_version_number
427: l_qp_list_header_id, --l_access_rec.act_access_to_object_id,
428: 'OFFR',--l_access_rec.arc_act_access_to_object,

Line 425: FND_GLOBAL.conc_login_id,

421: SYSDATE,
422: FND_GLOBAL.user_id,
423: SYSDATE,
424: FND_GLOBAL.user_id,
425: FND_GLOBAL.conc_login_id,
426: 1, -- object_version_number
427: l_qp_list_header_id, --l_access_rec.act_access_to_object_id,
428: 'OFFR',--l_access_rec.arc_act_access_to_object,
429: l_access_rec.user_or_role_id,

Line 838: last_update_login = fnd_global.conc_login_id,

834:
835: UPDATE ams_act_access
836: SET delete_flag = 'Y',
837: last_update_date = sysdate,
838: last_update_login = fnd_global.conc_login_id,
839: last_updated_by = fnd_global.user_id
840: WHERE activity_access_id = p_access_id
841: AND object_version_number = p_object_version;
842:

Line 839: last_updated_by = fnd_global.user_id

835: UPDATE ams_act_access
836: SET delete_flag = 'Y',
837: last_update_date = sysdate,
838: last_update_login = fnd_global.conc_login_id,
839: last_updated_by = fnd_global.user_id
840: WHERE activity_access_id = p_access_id
841: AND object_version_number = p_object_version;
842:
843: IF (SQL%NOTFOUND) THEN

Line 874: last_update_login = fnd_global.conc_login_id,

870: EXIT WHEN c_access_camp_schedules%NOTFOUND ;
871: UPDATE ams_act_access
872: SET delete_flag = 'Y',
873: last_update_date = sysdate,
874: last_update_login = fnd_global.conc_login_id,
875: last_updated_by = fnd_global.user_id
876: WHERE act_access_to_object_id = l_schedule_rec.schedule_id
877: AND arc_act_access_to_object = 'CSCH'
878: AND user_or_role_id = l_role_id

Line 875: last_updated_by = fnd_global.user_id

871: UPDATE ams_act_access
872: SET delete_flag = 'Y',
873: last_update_date = sysdate,
874: last_update_login = fnd_global.conc_login_id,
875: last_updated_by = fnd_global.user_id
876: WHERE act_access_to_object_id = l_schedule_rec.schedule_id
877: AND arc_act_access_to_object = 'CSCH'
878: AND user_or_role_id = l_role_id
879: AND arc_user_or_role_type = l_role_type;

Line 907: last_update_login = fnd_global.conc_login_id,

903:
904: UPDATE ams_act_access
905: SET delete_flag = 'Y',
906: last_update_date = sysdate,
907: last_update_login = fnd_global.conc_login_id,
908: last_updated_by = fnd_global.user_id
909: WHERE act_access_to_object_id = l_qp_list_header_id
910: AND arc_act_access_to_object = 'OFFR'
911: AND user_or_role_id = l_role_id

Line 908: last_updated_by = fnd_global.user_id

904: UPDATE ams_act_access
905: SET delete_flag = 'Y',
906: last_update_date = sysdate,
907: last_update_login = fnd_global.conc_login_id,
908: last_updated_by = fnd_global.user_id
909: WHERE act_access_to_object_id = l_qp_list_header_id
910: AND arc_act_access_to_object = 'OFFR'
911: AND user_or_role_id = l_role_id
912: AND arc_user_or_role_type = l_role_type;

Line 1304: last_updated_by = FND_GLOBAL.user_id,

1300:
1301:
1302: UPDATE ams_act_access SET
1303: last_update_date = SYSDATE,
1304: last_updated_by = FND_GLOBAL.user_id,
1305: last_update_login = FND_GLOBAL.conc_login_id,
1306: object_version_number = l_access_rec.object_version_number + 1,
1307: act_access_to_object_id = l_access_rec.act_access_to_object_id,
1308: arc_act_access_to_object = l_access_rec.arc_act_access_to_object,

Line 1305: last_update_login = FND_GLOBAL.conc_login_id,

1301:
1302: UPDATE ams_act_access SET
1303: last_update_date = SYSDATE,
1304: last_updated_by = FND_GLOBAL.user_id,
1305: last_update_login = FND_GLOBAL.conc_login_id,
1306: object_version_number = l_access_rec.object_version_number + 1,
1307: act_access_to_object_id = l_access_rec.act_access_to_object_id,
1308: arc_act_access_to_object = l_access_rec.arc_act_access_to_object,
1309: user_or_role_id = l_access_rec.user_or_role_id,

Line 1340: last_updated_by = FND_GLOBAL.user_id,

1336: CLOSE c_get_key_id;
1337:
1338: UPDATE ams_act_access SET
1339: last_update_date = SYSDATE,
1340: last_updated_by = FND_GLOBAL.user_id,
1341: last_update_login = FND_GLOBAL.conc_login_id,
1342: object_version_number = object_version_number + 1,
1343: act_access_to_object_id = l_schedule_rec.schedule_id,
1344: arc_act_access_to_object = 'CSCH',

Line 1341: last_update_login = FND_GLOBAL.conc_login_id,

1337:
1338: UPDATE ams_act_access SET
1339: last_update_date = SYSDATE,
1340: last_updated_by = FND_GLOBAL.user_id,
1341: last_update_login = FND_GLOBAL.conc_login_id,
1342: object_version_number = object_version_number + 1,
1343: act_access_to_object_id = l_schedule_rec.schedule_id,
1344: arc_act_access_to_object = 'CSCH',
1345: user_or_role_id = l_access_rec.user_or_role_id,

Line 1411: last_updated_by = FND_GLOBAL.user_id,

1407:
1408:
1409: UPDATE ams_act_access SET
1410: last_update_date = SYSDATE,
1411: last_updated_by = FND_GLOBAL.user_id,
1412: last_update_login = FND_GLOBAL.conc_login_id,
1413: object_version_number = object_version_number + 1,
1414: act_access_to_object_id = l_qp_list_header_id,
1415: arc_act_access_to_object = 'OFFR',

Line 1412: last_update_login = FND_GLOBAL.conc_login_id,

1408:
1409: UPDATE ams_act_access SET
1410: last_update_date = SYSDATE,
1411: last_updated_by = FND_GLOBAL.user_id,
1412: last_update_login = FND_GLOBAL.conc_login_id,
1413: object_version_number = object_version_number + 1,
1414: act_access_to_object_id = l_qp_list_header_id,
1415: arc_act_access_to_object = 'OFFR',
1416: user_or_role_id = l_access_rec.user_or_role_id,

Line 1680: last_updated_by = FND_GLOBAL.user_id,

1676: END IF; -- added by sveerave on 06-jun-2002
1677: -- ELSE -- update owner to new resource
1678: UPDATE ams_act_access SET
1679: last_update_date = SYSDATE,
1680: last_updated_by = FND_GLOBAL.user_id,
1681: last_update_login = FND_GLOBAL.conc_login_id,
1682: object_version_number = object_version_number + 1,
1683: act_access_to_object_id = p_object_id,
1684: arc_act_access_to_object = p_object_type,

Line 1681: last_update_login = FND_GLOBAL.conc_login_id,

1677: -- ELSE -- update owner to new resource
1678: UPDATE ams_act_access SET
1679: last_update_date = SYSDATE,
1680: last_updated_by = FND_GLOBAL.user_id,
1681: last_update_login = FND_GLOBAL.conc_login_id,
1682: object_version_number = object_version_number + 1,
1683: act_access_to_object_id = p_object_id,
1684: arc_act_access_to_object = p_object_type,
1685: user_or_role_id = p_resource_id

Line 2636: p_view_application_id => fnd_global.resp_appl_id

2632: /*
2633: IF AMS_Utility_PVT.check_lookup_exists(
2634: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
2635: p_lookup_code => p_Access_rec.arc_user_or_role_type,
2636: p_view_application_id => fnd_global.resp_appl_id
2637: ) = FND_API.g_false
2638: THEN
2639: */
2640: -- Correcting the p_lookup_code value getting passed for bug# 2419540

Line 2650: p_view_application_id => fnd_global.resp_appl_id

2646: -- So, changing code to check in 530 if not found in appl_id. -- bug#2421583
2647: IF AMS_Utility_PVT.check_lookup_exists(
2648: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
2649: p_lookup_code => p_Access_rec.arc_act_access_to_object,
2650: p_view_application_id => fnd_global.resp_appl_id
2651: ) = FND_API.g_false
2652: THEN
2653: IF AMS_Utility_PVT.check_lookup_exists(
2654: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',