DBA Data[Home] [Help]

APPS.PER_HRTCA_MERGE dependencies on FND_PROFILE

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

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

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

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

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

2656: --
2657: -- WWBUG 2689895
2658: -- Mask data if HZ profile set.
2659: --
2660: if nvl(fnd_profile.value('HZ_PROTECT_HR_PERSON_INFO'),'-1') <> 'Y' then
2661: --
2662: l_person_rec.date_of_birth := p_rec.date_of_birth;
2663: --
2664: if p_rec.sex is null or p_rec.sex = 'N' then -- changes for bug13935045

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

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

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

2769: -- not include them
2770: -- START risgupta bug 4375792
2771: l_hzprofile_value := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');
2772: if nvl(l_hzprofile_value, 'Y') = 'N' then
2773: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
2774: l_hzprofile_changed := 'Y';
2775: end if;
2776: -- END risgupta bug 4375792
2777:

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

2790: -- p_validation_level => 100
2791: );
2792: -- START risgupta bug 4375792
2793: if nvl(l_hzprofile_changed,'N') = 'Y' then
2794: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', l_hzprofile_value);
2795: l_hzprofile_changed := 'N';
2796: end if;
2797: -- END risgupta bug 4375792
2798: --

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

2812: exception
2813: when others then
2814: -- START risgupta bug 4375792
2815: if nvl(l_hzprofile_changed,'N') = 'Y' then
2816: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', l_hzprofile_value);
2817: l_hzprofile_changed := 'N';
2818: end if;
2819: -- END risgupta bug 4375792
2820: --

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

3039: --
3040: -- WWBUG 2689895
3041: -- Mask data if HZ profile set.
3042: --
3043: if nvl(fnd_profile.value('HZ_PROTECT_HR_PERSON_INFO'),'-1') <> 'Y' then
3044: --
3045: if p_rec.sex is null or p_rec.sex = 'N' then -- changes for bug13935045
3046: l_person_rec.gender := 'UNSPECIFIED';
3047: elsif p_rec.sex = 'F' then

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

3251: exception
3252: --
3253: when others then
3254: --
3255: fnd_profile.put('HZ_CREATED_BY_MODULE','NON HR');
3256: raise;
3257: --
3258: end;
3259: --

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

3320: hr_utility.set_location('Entering '||l_proc,10);
3321: --
3322: -- Bug fix 3598173. NVL added to if condition.
3323:
3324: if nvl(fnd_profile.value('HR_PROPAGATE_DATA_CHANGES'),'N') <> 'Y' then
3325: --
3326: return;
3327: --
3328: end if;

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

5851: l_rec per_per_shd.g_rec_type;
5852: --
5853: begin
5854: --
5855: if nvl(fnd_profile.value('HR_PROPAGATE_DATA_CHANGES'),'N') <> 'Y' then
5856: --
5857: return l_rec;
5858: --
5859: end if;

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

6057: --
6058:
6059: hr_utility.set_location('Entering '||l_proc,10);
6060:
6061: if nvl(fnd_profile.value('HR_PROPAGATE_DATA_CHANGES'),'N') <> 'Y' then
6062: --
6063: return l_rec;
6064: --
6065: end if;