APPS.PER_HRTCA_MERGE dependencies on FND_GLOBAL

Line 1905: fnd_global.login_id,

1901: values (l_batchid,
1902: 'HR Contact Purge - '||l_batchid,
1903: l_subset_sql,
1904: sysdate,
1905: fnd_global.login_id,
1906: sysdate,
1907: fnd_global.login_id);
1908:
1909: /* Process the batch and determine the candidate parties for the purge..

Line 1907: fnd_global.login_id);

1903: l_subset_sql,
1904: sysdate,
1905: fnd_global.login_id,
1906: sysdate,
1907: fnd_global.login_id);
1908:
1909: /* Process the batch and determine the candidate parties for the purge..
1910: */
1911: hr_utility.set_location(l_proc,50);

Line 2425: and SECURITY_GROUP_ID = fnd_global.lookup_security_group(LOOKUP_TYPE, VIEW_APPLICATION_ID)

2421: and enabled_flag = 'Y'
2422: and view_application_id = 222
2423: and trunc(sysdate) between nvl(start_date_active,sysdate)
2424: and nvl(end_date_active,sysdate)
2425: and SECURITY_GROUP_ID = fnd_global.lookup_security_group(LOOKUP_TYPE, VIEW_APPLICATION_ID)
2426: and language = userenv('LANG');
2427: --
2428: l_dummy varchar2(1);
2429: l_tca_merge_action varchar2(30);

Line 2894: fnd_global.lookup_security_group(LOOKUP_TYPE, VIEW_APPLICATION_ID)

2890: and view_application_id = 222
2891: and trunc(sysdate) between nvl(start_date_active,sysdate)
2892: and nvl(end_date_active,sysdate)
2893: and SECURITY_GROUP_ID =
2894: fnd_global.lookup_security_group(LOOKUP_TYPE, VIEW_APPLICATION_ID)
2895: and language = userenv('LANG');
2896: --
2897: begin
2898: --

Line 4339: fnd_global.user_id,

4335: l_person_rec.party_id ,
4336: l_person_rec.created_by,
4337: l_person_rec.creation_date,
4338: sysdate,
4339: fnd_global.user_id,
4340: fnd_global.login_id,
4341: l_global_name,
4342: l_local_name,
4343: l_person_rec.npw_number, -- 5123559

Line 4340: fnd_global.login_id,

4336: l_person_rec.created_by,
4337: l_person_rec.creation_date,
4338: sysdate,
4339: fnd_global.user_id,
4340: fnd_global.login_id,
4341: l_global_name,
4342: l_local_name,
4343: l_person_rec.npw_number, -- 5123559
4344: l_person_rec.current_npw_flag); -- 5123559

Line 4912: fnd_global.user_id,

4908: l_person_rec.party_id ,
4909: l_person_rec.created_by,
4910: l_person_rec.creation_date,
4911: sysdate,
4912: fnd_global.user_id,
4913: fnd_global.login_id,
4914: l_global_name,
4915: l_local_name);
4916: else

Line 4913: fnd_global.login_id,

4909: l_person_rec.created_by,
4910: l_person_rec.creation_date,
4911: sysdate,
4912: fnd_global.user_id,
4913: fnd_global.login_id,
4914: l_global_name,
4915: l_local_name);
4916: else
4917: close csr_get_person_details;

Line 5318: fnd_global.user_id,

5314: party_id ,
5315: created_by,
5316: creation_date,
5317: sysdate,
5318: fnd_global.user_id,
5319: fnd_global.login_id,
5320: global_name,
5321: local_name
5322: from per_all_people_f

Line 5319: fnd_global.login_id,

5315: created_by,
5316: creation_date,
5317: sysdate,
5318: fnd_global.user_id,
5319: fnd_global.login_id,
5320: global_name,
5321: local_name
5322: from per_all_people_f
5323: where person_id = l_person(l_count).person_id

Line 5647: fnd_global.user_id,

5643: party_id ,
5644: created_by,
5645: creation_date,
5646: sysdate,
5647: fnd_global.user_id,
5648: fnd_global.login_id,
5649: global_name,
5650: local_name
5651: from per_all_people_f

Line 5648: fnd_global.login_id,

5644: created_by,
5645: creation_date,
5646: sysdate,
5647: fnd_global.user_id,
5648: fnd_global.login_id,
5649: global_name,
5650: local_name
5651: from per_all_people_f
5652: where person_id = l_person(l_count).person_id