DBA Data[Home] [Help]

APPS.PER_HRTCA_MERGE dependencies on FND_PROFILE

Line 2182: -- and (nvl(fnd_profile.value('HR:TCA_UNMERGE_PROCESS_OPTION'),'I') ='D'

2178: --
2179: if csr_get_release_name%found and
2180: l_release_name not in ('11.5.1','11.5.2','11.5.3','11.5.4',
2181: '11.5.5') then
2182: -- and (nvl(fnd_profile.value('HR:TCA_UNMERGE_PROCESS_OPTION'),'I') ='D'
2183: -- or nvl(fnd_profile.value('HR:TCA_UNMERGE_PROCESS_OPTION'),'I') ='P') then
2184: --
2185: open get_rowid_range;
2186: fetch get_rowid_range into l_start_rowid,l_end_rowid;

Line 2183: -- or nvl(fnd_profile.value('HR:TCA_UNMERGE_PROCESS_OPTION'),'I') ='P') then

2179: if csr_get_release_name%found and
2180: l_release_name not in ('11.5.1','11.5.2','11.5.3','11.5.4',
2181: '11.5.5') then
2182: -- and (nvl(fnd_profile.value('HR:TCA_UNMERGE_PROCESS_OPTION'),'I') ='D'
2183: -- or nvl(fnd_profile.value('HR:TCA_UNMERGE_PROCESS_OPTION'),'I') ='P') then
2184: --
2185: open get_rowid_range;
2186: fetch get_rowid_range into l_start_rowid,l_end_rowid;
2187: close get_rowid_range;

Line 2657: if nvl(fnd_profile.value('HZ_PROTECT_HR_PERSON_INFO'),'-1') <> 'Y' then

2653: --
2654: -- WWBUG 2689895
2655: -- Mask data if HZ profile set.
2656: --
2657: if nvl(fnd_profile.value('HZ_PROTECT_HR_PERSON_INFO'),'-1') <> 'Y' then
2658: --
2659: l_person_rec.date_of_birth := p_rec.date_of_birth;
2660: --
2661: if p_rec.sex is null then

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 2766: l_hzprofile_value := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');

2762: --Modified for Bug 2648797
2763: -- api version,p_commit and p_validation_level have been commented as TCA V2 does
2764: -- not include them
2765: -- START risgupta bug 4375792
2766: l_hzprofile_value := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');
2767: if nvl(l_hzprofile_value, 'Y') = 'N' then
2768: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
2769: l_hzprofile_changed := 'Y';
2770: end if;

Line 2768: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');

2764: -- not include them
2765: -- START risgupta bug 4375792
2766: l_hzprofile_value := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');
2767: if nvl(l_hzprofile_value, 'Y') = 'N' then
2768: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
2769: l_hzprofile_changed := 'Y';
2770: end if;
2771: -- END risgupta bug 4375792
2772:

Line 2789: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', l_hzprofile_value);

2785: -- p_validation_level => 100
2786: );
2787: -- START risgupta bug 4375792
2788: if nvl(l_hzprofile_changed,'N') = 'Y' then
2789: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', l_hzprofile_value);
2790: l_hzprofile_changed := 'N';
2791: end if;
2792: -- END risgupta bug 4375792
2793: --

Line 2811: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', l_hzprofile_value);

2807: exception
2808: when others then
2809: -- START risgupta bug 4375792
2810: if nvl(l_hzprofile_changed,'N') = 'Y' then
2811: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', l_hzprofile_value);
2812: l_hzprofile_changed := 'N';
2813: end if;
2814: -- END risgupta bug 4375792
2815: --

Line 3031: if nvl(fnd_profile.value('HZ_PROTECT_HR_PERSON_INFO'),'-1') <> 'Y' then

3027: --
3028: -- WWBUG 2689895
3029: -- Mask data if HZ profile set.
3030: --
3031: if nvl(fnd_profile.value('HZ_PROTECT_HR_PERSON_INFO'),'-1') <> 'Y' then
3032: --
3033: if p_rec.sex is null then
3034: l_person_rec.gender := 'UNSPECIFIED';
3035: elsif p_rec.sex = 'F' then

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 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 3240: fnd_profile.put('HZ_CREATED_BY_MODULE','NON HR');

3236: exception
3237: --
3238: when others then
3239: --
3240: fnd_profile.put('HZ_CREATED_BY_MODULE','NON HR');
3241: raise;
3242: --
3243: end;
3244: --

Line 3309: if nvl(fnd_profile.value('HR_PROPAGATE_DATA_CHANGES'),'N') <> 'Y' then

3305: hr_utility.set_location('Entering '||l_proc,10);
3306: --
3307: -- Bug fix 3598173. NVL added to if condition.
3308:
3309: if nvl(fnd_profile.value('HR_PROPAGATE_DATA_CHANGES'),'N') <> 'Y' then
3310: --
3311: return;
3312: --
3313: end if;

Line 5836: if nvl(fnd_profile.value('HR_PROPAGATE_DATA_CHANGES'),'N') <> 'Y' then

5832: l_rec per_per_shd.g_rec_type;
5833: --
5834: begin
5835: --
5836: if nvl(fnd_profile.value('HR_PROPAGATE_DATA_CHANGES'),'N') <> 'Y' then
5837: --
5838: return l_rec;
5839: --
5840: end if;

Line 6041: if nvl(fnd_profile.value('HR_PROPAGATE_DATA_CHANGES'),'N') <> 'Y' then

6037: --
6038:
6039: hr_utility.set_location('Entering '||l_proc,10);
6040:
6041: if nvl(fnd_profile.value('HR_PROPAGATE_DATA_CHANGES'),'N') <> 'Y' then
6042: --
6043: return l_rec;
6044: --
6045: end if;