APPS.PER_HRTCA_MERGE dependencies on FND_GLOBAL

Line 1908: fnd_global.login_id,

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

Line 1910: fnd_global.login_id);

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

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

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

Line 2900: fnd_global.lookup_security_group(LOOKUP_TYPE, VIEW_APPLICATION_ID)

2896: and view_application_id = 222
2897: and trunc(sysdate) between nvl(start_date_active,sysdate)
2898: and nvl(end_date_active,sysdate)
2899: and SECURITY_GROUP_ID =
2900: fnd_global.lookup_security_group(LOOKUP_TYPE, VIEW_APPLICATION_ID)
2901: and language = userenv('LANG');
2902: --
2903: begin
2904: --

Line 4354: fnd_global.user_id,

4350: l_person_rec.party_id ,
4351: l_person_rec.created_by,
4352: l_person_rec.creation_date,
4353: sysdate,
4354: fnd_global.user_id,
4355: fnd_global.login_id,
4356: l_global_name,
4357: l_local_name,
4358: l_person_rec.npw_number, -- 5123559

Line 4355: fnd_global.login_id,

4351: l_person_rec.created_by,
4352: l_person_rec.creation_date,
4353: sysdate,
4354: fnd_global.user_id,
4355: fnd_global.login_id,
4356: l_global_name,
4357: l_local_name,
4358: l_person_rec.npw_number, -- 5123559
4359: l_person_rec.current_npw_flag); -- 5123559

Line 4929: fnd_global.user_id,

4925: l_person_rec.party_id ,
4926: l_person_rec.created_by,
4927: l_person_rec.creation_date,
4928: sysdate,
4929: fnd_global.user_id,
4930: fnd_global.login_id,
4931: l_global_name,
4932: l_local_name,
4933: l_person_rec.npw_number, -- 5123559

Line 4930: fnd_global.login_id,

4926: l_person_rec.created_by,
4927: l_person_rec.creation_date,
4928: sysdate,
4929: fnd_global.user_id,
4930: fnd_global.login_id,
4931: l_global_name,
4932: l_local_name,
4933: l_person_rec.npw_number, -- 5123559
4934: l_person_rec.current_npw_flag); -- 5123559

Line 5337: fnd_global.user_id,

5333: party_id ,
5334: created_by,
5335: creation_date,
5336: sysdate,
5337: fnd_global.user_id,
5338: fnd_global.login_id,
5339: global_name,
5340: local_name
5341: from per_all_people_f

Line 5338: fnd_global.login_id,

5334: created_by,
5335: creation_date,
5336: sysdate,
5337: fnd_global.user_id,
5338: fnd_global.login_id,
5339: global_name,
5340: local_name
5341: from per_all_people_f
5342: where person_id = l_person(l_count).person_id

Line 5666: fnd_global.user_id,

5662: party_id ,
5663: created_by,
5664: creation_date,
5665: sysdate,
5666: fnd_global.user_id,
5667: fnd_global.login_id,
5668: global_name,
5669: local_name
5670: from per_all_people_f

Line 5667: fnd_global.login_id,

5663: created_by,
5664: creation_date,
5665: sysdate,
5666: fnd_global.user_id,
5667: fnd_global.login_id,
5668: global_name,
5669: local_name
5670: from per_all_people_f
5671: where person_id = l_person(l_count).person_id