eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_HRTCA_MERGE dependencies on HR_API

Line 504: and effective_end_date = hr_api.g_eot;

500: select *
501: from per_all_people_f
502: where party_id is null
503: and mod(person_id,p_number_of_workers) = p_current_worker-1
504: and effective_end_date = hr_api.g_eot;
505: --
506: cursor c_old_person(p_person_id number) is
507: select *
508: from per_all_people_f

Line 510: and effective_end_date <> hr_api.g_eot

506: cursor c_old_person(p_person_id number) is
507: select *
508: from per_all_people_f
509: where party_id is null
510: and effective_end_date <> hr_api.g_eot
511: and person_id = p_person_id;
512: --
513: l_person c_person%rowtype;
514: l_old_person c_old_person%rowtype;

Line 654: l_contact_point_rec.created_by_module := 'HR API';

650: --
651: hr_utility.set_location('Entering '||l_proc,10);
652: --
653: --Added for bug 2648797
654: l_contact_point_rec.created_by_module := 'HR API';
655: --
656: --
657: --
658: --bug no 5546586 starts here

Line 756: l_contact_point_rec.created_by_module := 'HR API';

752: -- api version has been commented as TCA V2 does not include it
753: --Added for 4697454
754: -- Set Created by Module only when creatinbg
755: -- set to null when updating.
756: l_contact_point_rec.created_by_module := 'HR API';
757: hz_contact_point_v2pub.create_contact_point
758: (
759: --p_api_version => 1.0,
760: p_contact_point_rec => l_contact_point_rec,

Line 927: l_contact_point_rec.created_by_module := 'HR API';

923: -- api version has been commented as TCA V2 does not include it
924: --Added for 4697454
925: -- Set Created by Module only when creatinbg
926: -- set to null when updating.
927: l_contact_point_rec.created_by_module := 'HR API';
928: --
929: hz_contact_point_v2pub.create_contact_point
930: (
931: --p_api_version => 1.0,

Line 1051: l_effective_date date := hr_api.g_eot;

1047: -- Bug fix 3260686. l_sytem_person_type changed to varchar2(2000).
1048: -- l_system_person_type per_person_types.system_person_type%type;
1049: l_system_person_type varchar2(2000);
1050: --
1051: l_effective_date date := hr_api.g_eot;
1052: l_return_value varchar2(30);
1053: l_proc varchar2(80) := g_package||'.get_tca_merge_actions';
1054: --
1055: -- Cursor to check for persons of a valid person_type for given party_id

Line 1992: l_effective_date date := hr_api.g_eot;

1988: and not exists (select null
1989: from hr_tca_party_unmerge ptyun
1990: where ptyun.party_id = p.party_id);
1991: --
1992: l_effective_date date := hr_api.g_eot;
1993: l_return_value varchar2(30);
1994: --
1995: -- Cursor to check for persons of a valid person_type for given party_id
1996: --

Line 2472: l_person_rec.created_by_module := 'HR API';

2468: --
2469: hr_utility.set_location('Party unmerge '||l_proc,10);
2470: --
2471: --Added for bug 2648797
2472: l_person_rec.created_by_module := 'HR API';
2473: --
2474: l_tca_merge_action := per_hrtca_merge.get_tca_merge_actions
2475: (p_person_id => p_rec.person_id
2476: ,p_party_id => p_rec.party_id

Line 2759: --Modified Created by Module Code to 'HR API'

2755: --
2756: hr_utility.set_location(substr(l_person_rec.person_first_name,1,70),10);
2757: --
2758: -- Bug 4149356 End of Fix
2759: --Modified Created by Module Code to 'HR API'
2760: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');
2761: --
2762: -- declare added by risgupta for bug 4375792
2763: declare

Line 2760: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');

2756: hr_utility.set_location(substr(l_person_rec.person_first_name,1,70),10);
2757: --
2758: -- Bug 4149356 End of Fix
2759: --Modified Created by Module Code to 'HR API'
2760: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');
2761: --
2762: -- declare added by risgupta for bug 4375792
2763: declare
2764: l_hzprofile_value varchar2(20);

Line 2922: if p_rec.effective_end_date <> hr_api.g_eot then

2918: --
2919: end if;
2920: --
2921:
2922: if p_rec.effective_end_date <> hr_api.g_eot then
2923: --
2924: -- Record being updated isn't for the end of time so call replicate
2925: -- routine and then return to the calling procedure.
2926: --

Line 3159: --Modified Created by Module Code to 'HR API'

3155: --
3156: -- Call TCA API and update the person.
3157: --
3158: -- Set HR security profile as HR can only update these records.
3159: --Modified Created by Module Code to 'HR API'
3160: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');
3161: --
3162: begin
3163: --Modified for Bug 2648797

Line 3160: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');

3156: -- Call TCA API and update the person.
3157: --
3158: -- Set HR security profile as HR can only update these records.
3159: --Modified Created by Module Code to 'HR API'
3160: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');
3161: --
3162: begin
3163: --Modified for Bug 2648797
3164: -- api version,p_commit,p_party_last_update_date and p_validation_level have been commented as TCA V2 does

Line 3222: --Modified Created by Module Code to 'HR API'

3218: if (SQL%NOTFOUND) then
3219: select 1 into l_dummy from dual;
3220: end if;
3221: --
3222: --Modified Created by Module Code to 'HR API'
3223: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');
3224: --
3225: g_count := g_count + 1;
3226: --

Line 3223: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');

3219: select 1 into l_dummy from dual;
3220: end if;
3221: --
3222: --Modified Created by Module Code to 'HR API'
3223: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');
3224: --
3225: g_count := g_count + 1;
3226: --
3227: if g_count = 1 then

Line 3418: if l_person(l_count).effective_end_date <> hr_api.g_eot then

3414: --
3415: elsif l_person(l_count).effective_start_date < p_rec.effective_start_date and
3416: l_person(l_count).effective_end_date <= p_rec.effective_end_date then
3417: --
3418: if l_person(l_count).effective_end_date <> hr_api.g_eot then
3419: --
3420: l_datetrack_mode := 'UPDATE_CHANGE_INSERT';
3421: --
3422: elsif l_person(l_count).effective_end_date = hr_api.g_eot then

Line 3422: elsif l_person(l_count).effective_end_date = hr_api.g_eot then

3418: if l_person(l_count).effective_end_date <> hr_api.g_eot then
3419: --
3420: l_datetrack_mode := 'UPDATE_CHANGE_INSERT';
3421: --
3422: elsif l_person(l_count).effective_end_date = hr_api.g_eot then
3423: --
3424: l_datetrack_mode := 'UPDATE';
3425: --
3426: end if;

Line 3431: if l_person(l_count).effective_end_date <> hr_api.g_eot then

3427: --
3428: elsif l_person(l_count).effective_start_date < p_rec.effective_start_date and
3429: l_person(l_count).effective_end_date > p_rec.effective_end_date then
3430: --
3431: if l_person(l_count).effective_end_date <> hr_api.g_eot then
3432: --
3433: l_datetrack_mode := 'UPDATE_CHANGE_INSERT';
3434: --
3435: elsif l_person(l_count).effective_end_date = hr_api.g_eot then

Line 3435: elsif l_person(l_count).effective_end_date = hr_api.g_eot then

3431: if l_person(l_count).effective_end_date <> hr_api.g_eot then
3432: --
3433: l_datetrack_mode := 'UPDATE_CHANGE_INSERT';
3434: --
3435: elsif l_person(l_count).effective_end_date = hr_api.g_eot then
3436: --
3437: l_datetrack_mode := 'UPDATE';
3438: --
3439: end if;

Line 4211: hr_api.g_eot,

4207: VALUES
4208: -- ----------------------- +
4209: (l_person(l_count).person_id,
4210: p_rec.effective_start_date,
4211: hr_api.g_eot,
4212: l_person_rec.business_group_id,
4213: l_person_rec.person_type_id,
4214: p_rec.last_name,
4215: l_full_name,

Line 5194: hr_api.g_eot,

5190: local_name)
5191: select
5192: l_person(l_count).person_id,
5193: p_rec.effective_end_date+1,
5194: hr_api.g_eot,
5195: business_group_id,
5196: person_type_id,
5197: p_rec.last_name,
5198: start_date,

Line 5815: if l_person.effective_end_date = hr_api.g_eot then

5811: set party_id = l_person.party_id
5812: where person_id = l_person.person_id
5813: and effective_start_date = l_person.effective_start_date;
5814: --
5815: if l_person.effective_end_date = hr_api.g_eot then
5816: --
5817: update_child_tables(p_rec => l_person);
5818: --
5819: end if;

Line 5919: and ppf.effective_end_date = hr_api.g_eot

5915: select party_id,email_address
5916: from per_all_people_f ppf
5917: where ppf.email_address is not null
5918: and mod(ppf.person_id,p_number_of_workers) = p_current_worker-1
5919: and ppf.effective_end_date = hr_api.g_eot
5920: and ppf.party_id is not null
5921: and not exists(select null
5922: from hz_contact_points
5923: where owner_table_name = 'HZ_PARTIES'

Line 5988: and ppf.effective_end_date = hr_api.g_eot

5984: cursor c_person is
5985: select *
5986: from per_all_people_f ppf
5987: where mod(ppf.person_id,p_number_of_workers) = p_current_worker-1
5988: and ppf.effective_end_date = hr_api.g_eot
5989: and ppf.party_id is not null
5990: and exists(select null
5991: from hz_person_profiles
5992: where party_id = ppf.party_id

Line 6139: and effective_end_date = hr_api.g_eot;

6135: select person_id
6136: from per_all_people_f
6137: where party_id is null
6138: and rowid between p_start_rowid and p_end_rowid
6139: and effective_end_date = hr_api.g_eot;
6140: --
6141: -- Cursor to fecth the details for a person.
6142: --
6143: cursor csr_per_details(p_person_id number) is

Line 6147: and effective_end_date = hr_api.g_eot;

6143: cursor csr_per_details(p_person_id number) is
6144: select *
6145: from per_all_people_f
6146: where person_id = p_person_id
6147: and effective_end_date = hr_api.g_eot;
6148: --
6149: l_per_rec csr_per_details%rowtype;
6150: --
6151: begin

Line 6295: and ppf.effective_end_date = hr_api.g_eot

6291: select party_id,email_address -- fix for bug 12933615
6292: from per_all_people_f ppf
6293: where ppf.email_address is not null
6294: and ppf.ROWID between p_start_rowid and p_end_rowid
6295: and ppf.effective_end_date = hr_api.g_eot
6296: and ppf.party_id is not null
6297: and not exists(select /*+ no_unnest */ null
6298: from hz_contact_points
6299: where owner_table_name = 'HZ_PARTIES'