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 652: l_contact_point_rec.created_by_module := 'HR API';

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

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

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

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

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

Line 1048: l_effective_date date := hr_api.g_eot;

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

Line 1989: l_effective_date date := hr_api.g_eot;

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

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

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

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

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

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

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

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

2912: --
2913: end if;
2914: --
2915:
2916: if p_rec.effective_end_date <> hr_api.g_eot then
2917: --
2918: -- Record being updated isn't for the end of time so call replicate
2919: -- routine and then return to the calling procedure.
2920: --

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

3141: --
3142: -- Call TCA API and update the person.
3143: --
3144: -- Set HR security profile as HR can only update these records.
3145: --Modified Created by Module Code to 'HR API'
3146: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');
3147: --
3148: begin
3149: --Modified for Bug 2648797

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

3142: -- Call TCA API and update the person.
3143: --
3144: -- Set HR security profile as HR can only update these records.
3145: --Modified Created by Module Code to 'HR API'
3146: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');
3147: --
3148: begin
3149: --Modified for Bug 2648797
3150: -- api version,p_commit,p_party_last_update_date and p_validation_level have been commented as TCA V2 does

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

3204: if (SQL%NOTFOUND) then
3205: select 1 into l_dummy from dual;
3206: end if;
3207: --
3208: --Modified Created by Module Code to 'HR API'
3209: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');
3210: --
3211: g_count := g_count + 1;
3212: --

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

3205: select 1 into l_dummy from dual;
3206: end if;
3207: --
3208: --Modified Created by Module Code to 'HR API'
3209: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');
3210: --
3211: g_count := g_count + 1;
3212: --
3213: if g_count = 1 then

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

3399: --
3400: elsif l_person(l_count).effective_start_date < p_rec.effective_start_date and
3401: l_person(l_count).effective_end_date <= p_rec.effective_end_date then
3402: --
3403: if l_person(l_count).effective_end_date <> hr_api.g_eot then
3404: --
3405: l_datetrack_mode := 'UPDATE_CHANGE_INSERT';
3406: --
3407: elsif l_person(l_count).effective_end_date = hr_api.g_eot then

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

3403: if l_person(l_count).effective_end_date <> hr_api.g_eot then
3404: --
3405: l_datetrack_mode := 'UPDATE_CHANGE_INSERT';
3406: --
3407: elsif l_person(l_count).effective_end_date = hr_api.g_eot then
3408: --
3409: l_datetrack_mode := 'UPDATE';
3410: --
3411: end if;

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

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

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

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

Line 4196: hr_api.g_eot,

4192: VALUES
4193: -- ----------------------- +
4194: (l_person(l_count).person_id,
4195: p_rec.effective_start_date,
4196: hr_api.g_eot,
4197: l_person_rec.business_group_id,
4198: l_person_rec.person_type_id,
4199: p_rec.last_name,
4200: l_full_name,

Line 5175: hr_api.g_eot,

5171: local_name)
5172: select
5173: l_person(l_count).person_id,
5174: p_rec.effective_end_date+1,
5175: hr_api.g_eot,
5176: business_group_id,
5177: person_type_id,
5178: p_rec.last_name,
5179: start_date,

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

5792: set party_id = l_person.party_id
5793: where person_id = l_person.person_id
5794: and effective_start_date = l_person.effective_start_date;
5795: --
5796: if l_person.effective_end_date = hr_api.g_eot then
5797: --
5798: update_child_tables(p_rec => l_person);
5799: --
5800: end if;

Line 5900: and ppf.effective_end_date = hr_api.g_eot

5896: select *
5897: from per_all_people_f ppf
5898: where ppf.email_address is not null
5899: and mod(ppf.person_id,p_number_of_workers) = p_current_worker-1
5900: and ppf.effective_end_date = hr_api.g_eot
5901: and ppf.party_id is not null
5902: and not exists(select null
5903: from hz_contact_points
5904: where owner_table_name = 'HZ_PARTIES'

Line 5968: and ppf.effective_end_date = hr_api.g_eot

5964: cursor c_person is
5965: select *
5966: from per_all_people_f ppf
5967: where mod(ppf.person_id,p_number_of_workers) = p_current_worker-1
5968: and ppf.effective_end_date = hr_api.g_eot
5969: and ppf.party_id is not null
5970: and exists(select null
5971: from hz_person_profiles
5972: where party_id = ppf.party_id

Line 6119: and effective_end_date = hr_api.g_eot;

6115: select person_id
6116: from per_all_people_f
6117: where party_id is null
6118: and rowid between p_start_rowid and p_end_rowid
6119: and effective_end_date = hr_api.g_eot;
6120: --
6121: -- Cursor to fecth the details for a person.
6122: --
6123: cursor csr_per_details(p_person_id number) is

Line 6127: and effective_end_date = hr_api.g_eot;

6123: cursor csr_per_details(p_person_id number) is
6124: select *
6125: from per_all_people_f
6126: where person_id = p_person_id
6127: and effective_end_date = hr_api.g_eot;
6128: --
6129: l_per_rec csr_per_details%rowtype;
6130: --
6131: begin

Line 6275: and ppf.effective_end_date = hr_api.g_eot

6271: select /*+ rowid(ppf) */ *
6272: from per_all_people_f ppf
6273: where ppf.email_address is not null
6274: and ppf.ROWID between p_start_rowid and p_end_rowid
6275: and ppf.effective_end_date = hr_api.g_eot
6276: and ppf.party_id is not null
6277: and not exists(select /*+ no_unnest */ null
6278: from hz_contact_points
6279: where owner_table_name = 'HZ_PARTIES'