DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_API dependencies on HR_KFLEX_UTILITY

Line 1587: hr_kflex_utility.upd_or_sel_keyflex_comb

1583: --
1584: --
1585: -- Update or select the soft_coding_keyflex_id
1586: --
1587: hr_kflex_utility.upd_or_sel_keyflex_comb
1588: (p_appl_short_name => 'PER'
1589: ,p_flex_code => 'SCL'
1590: ,p_flex_num => l_flex_num
1591: ,p_segment1 => l_scl_segment1

Line 5645: hr_kflex_utility.set_profiles

5641: --
5642: -- insert the profile options and effective date for the flexfield
5643: -- validation to work
5644: --
5645: hr_kflex_utility.set_profiles
5646: (p_business_group_id => l_business_group_id
5647: ,p_assignment_id => l_assignment_id
5648: ,p_organization_id => p_organization_id
5649: ,p_location_id => p_location_id);

Line 5651: hr_kflex_utility.set_session_date

5647: ,p_assignment_id => l_assignment_id
5648: ,p_organization_id => p_organization_id
5649: ,p_location_id => p_location_id);
5650: --
5651: hr_kflex_utility.set_session_date
5652: (p_effective_date => l_effective_date
5653: ,p_session_id => l_session_id);
5654: --
5655: open csr_grp_idsel;

Line 5736: hr_kflex_utility.ins_or_sel_keyflex_comb

5732: end if;
5733: --
5734: -- Insert or select the soft_coding_keyflex_id
5735: --
5736: hr_kflex_utility.ins_or_sel_keyflex_comb
5737: (p_appl_short_name => 'PER'
5738: ,p_flex_code => 'SCL'
5739: ,p_flex_num => l_scl_flex_num
5740: ,p_segment1 => l_scl_segment1

Line 5794: hr_kflex_utility.ins_or_sel_keyflex_comb

5790: then
5791: --
5792: -- Insert or select the people_group_id.
5793: --
5794: hr_kflex_utility.ins_or_sel_keyflex_comb
5795: (p_appl_short_name => 'PAY'
5796: ,p_flex_code => 'GRP'
5797: ,p_flex_num => l_grp_flex_num
5798: ,p_segment1 => l_pgp_segment1

Line 6237: hr_kflex_utility.unset_session_date

6233: p_hourly_salaried_warning := l_hourly_salaried_warning;
6234: p_gsp_post_process_warning := l_gsp_post_process_warning; -- bug 2999562
6235: --
6236: -- remove data from the session table
6237: hr_kflex_utility.unset_session_date
6238: (p_session_id => l_session_id);
6239: --
6240: if g_debug then
6241: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 6803: hr_kflex_utility.set_profiles

6799: --
6800: -- insert the profile options and effective date for the flexfield
6801: -- validation to work
6802: --
6803: hr_kflex_utility.set_profiles
6804: (p_business_group_id => l_business_group_id
6805: ,p_assignment_id => l_assignment_id
6806: ,p_organization_id => p_organization_id
6807: ,p_location_id => p_location_id);

Line 6809: hr_kflex_utility.set_session_date

6805: ,p_assignment_id => l_assignment_id
6806: ,p_organization_id => p_organization_id
6807: ,p_location_id => p_location_id);
6808: --
6809: hr_kflex_utility.set_session_date
6810: (p_effective_date => l_effective_date
6811: ,p_session_id => l_session_id);
6812: --
6813: open csr_grp_idsel;

Line 6892: hr_kflex_utility.ins_or_sel_keyflex_comb

6888: end if;
6889: --
6890: -- Insert or select the soft_coding_keyflex_id
6891: --
6892: hr_kflex_utility.ins_or_sel_keyflex_comb
6893: (p_appl_short_name => 'PER'
6894: ,p_flex_code => 'SCL'
6895: ,p_flex_num => l_scl_flex_num
6896: ,p_segment1 => p_scl_segment1

Line 6943: hr_kflex_utility.ins_or_sel_keyflex_comb

6939: end if;
6940: --
6941: -- Insert of select the people_group_id.
6942: --
6943: hr_kflex_utility.ins_or_sel_keyflex_comb
6944: (p_appl_short_name => 'PAY'
6945: ,p_flex_code => 'GRP'
6946: ,p_flex_num => l_grp_flex_num
6947: ,p_segment1 => p_pgp_segment1

Line 7362: hr_kflex_utility.unset_session_date

7358: p_hourly_salaried_warning := l_hourly_salaried_warning;
7359: --
7360: -- remove data from the session table
7361: --
7362: hr_kflex_utility.unset_session_date
7363: (p_session_id => l_session_id);
7364: --
7365: if g_debug then
7366: hr_utility.set_location(' Leaving:'||l_proc, 999);

Line 11078: hr_kflex_utility.set_profiles

11074: if g_debug then
11075: hr_utility.set_location('EMP Asg B Profile:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);
11076: hr_utility.set_location('EMP Asg l_organization_id:' || l_organization_id, 13163);
11077: end if;
11078: hr_kflex_utility.set_profiles
11079: (p_business_group_id => l_business_group_id
11080: ,p_assignment_id => p_assignment_id
11081: ,p_organization_id => NVL(per_qh_maintain_update.p_qh_organization_id,l_organization_id) -- Fix For Bug # 8238220
11082: ,p_location_id => l_location_id);

Line 11085: hr_kflex_utility.set_session_date

11081: ,p_organization_id => NVL(per_qh_maintain_update.p_qh_organization_id,l_organization_id) -- Fix For Bug # 8238220
11082: ,p_location_id => l_location_id);
11083: --
11084: per_qh_maintain_update.p_qh_organization_id := NULL; --- Added For Bug # 8238220
11085: hr_kflex_utility.set_session_date
11086: (p_effective_date => l_effective_date
11087: ,p_session_id => l_session_id);
11088: if g_debug then
11089: hr_utility.set_location('EMP Asg A Profile:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);

Line 11205: hr_kflex_utility.upd_or_sel_keyflex_comb

11201: --
11202: --
11203: -- Update or select the soft_coding_keyflex_id
11204: --
11205: hr_kflex_utility.upd_or_sel_keyflex_comb
11206: (p_appl_short_name => 'PER'
11207: ,p_flex_code => 'SCL'
11208: ,p_flex_num => l_flex_num
11209: ,p_segment1 => l_scl_segment1

Line 11697: hr_kflex_utility.unset_session_date

11693: p_hourly_salaried_warning := l_hourly_salaried_warning;
11694: p_gsp_post_process_warning := l_gsp_post_process_warning; -- bug 2999562
11695: --
11696: -- remove data from the session table
11697: hr_kflex_utility.unset_session_date
11698: (p_session_id => l_session_id);
11699: --
11700: if g_debug then
11701: hr_utility.set_location(' Leaving:'||l_proc, 30);

Line 12193: hr_kflex_utility.set_profiles

12189: --
12190: -- insert the profile options and effective date for the flexfield
12191: -- validation to work
12192: --
12193: hr_kflex_utility.set_profiles
12194: (p_business_group_id => l_business_group_id
12195: ,p_assignment_id => p_assignment_id
12196: ,p_organization_id => l_organization_id
12197: ,p_location_id => l_location_id);

Line 12199: hr_kflex_utility.set_session_date

12195: ,p_assignment_id => p_assignment_id
12196: ,p_organization_id => l_organization_id
12197: ,p_location_id => l_location_id);
12198: --
12199: hr_kflex_utility.set_session_date
12200: (p_effective_date => l_effective_date
12201: ,p_session_id => l_session_id);
12202: --
12203: -- Bug 944911

Line 12294: hr_kflex_utility.upd_or_sel_keyflex_comb

12290: -- Process Logic
12291: --
12292: -- Update or select the soft_coding_keyflex_id
12293: --
12294: hr_kflex_utility.upd_or_sel_keyflex_comb
12295: (p_appl_short_name => 'PER'
12296: ,p_flex_code => 'SCL'
12297: ,p_flex_num => l_flex_num
12298: ,p_segment1 => p_scl_segment1

Line 12706: hr_kflex_utility.unset_session_date

12702: p_hourly_salaried_warning := l_hourly_salaried_warning;
12703: --
12704: -- remove data from the session table
12705: --
12706: hr_kflex_utility.unset_session_date
12707: (p_session_id => l_session_id);
12708: --
12709: if g_debug then
12710: hr_utility.set_location(' Leaving:'||l_proc, 999);

Line 13154: hr_kflex_utility.set_profiles

13150: l_location_id:=p_location_id;
13151: --
13152: END IF;
13153: --
13154: hr_kflex_utility.set_profiles
13155: (p_business_group_id => l_business_group_id
13156: ,p_assignment_id => p_assignment_id
13157: ,p_organization_id => l_organization_id
13158: ,p_location_id => l_location_id);

Line 13160: hr_kflex_utility.set_session_date

13156: ,p_assignment_id => p_assignment_id
13157: ,p_organization_id => l_organization_id
13158: ,p_location_id => l_location_id);
13159: --
13160: hr_kflex_utility.set_session_date
13161: (p_effective_date => l_effective_date
13162: ,p_session_id => l_session_id);
13163: --
13164: OPEN csr_grp_idsel;

Line 13221: hr_kflex_utility.upd_or_sel_keyflex_comb

13217: or nvl(p_segment29,'X') <> hr_api.g_varchar2
13218: or nvl(p_segment30,'X') <> hr_api.g_varchar2
13219: or nvl(l_old_group_name,'X') <> hr_api.g_varchar2 THEN
13220: --
13221: hr_kflex_utility.upd_or_sel_keyflex_comb
13222: (p_appl_short_name => 'PAY'
13223: ,p_flex_code => 'GRP'
13224: ,p_flex_num => l_flex_num
13225: ,p_segment1 => p_segment1

Line 13617: hr_kflex_utility.unset_session_date

13613: --
13614: --
13615: -- remove data from the session table
13616: --
13617: hr_kflex_utility.unset_session_date
13618: (p_session_id => l_session_id);
13619: --
13620: if g_debug then
13621: hr_utility.set_location(' Leaving:'||l_proc, 999);

Line 16489: hr_kflex_utility.set_profiles

16485: if g_debug then
16486: hr_utility.set_location(l_proc, 220);
16487: end if;
16488: --
16489: hr_kflex_utility.set_profiles
16490: (p_business_group_id => l_business_group_id
16491: ,p_assignment_id => p_assignment_id
16492: ,p_organization_id => l_organization_id
16493: ,p_location_id => l_location_id);

Line 16499: hr_kflex_utility.set_session_date

16495: if g_debug then
16496: hr_utility.set_location(l_proc, 230);
16497: end if;
16498: --
16499: hr_kflex_utility.set_session_date
16500: (p_effective_date => l_effective_date
16501: ,p_session_id => l_session_id);
16502: --
16503: if g_debug then

Line 16585: hr_kflex_utility.upd_or_sel_keyflex_comb

16581: or nvl(p_segment30, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment30, hr_api.g_varchar2)
16582: or nvl(l_old_group_name,hr_api.g_varchar2) <> nvl(l_old_pgp_segments.group_name, hr_api.g_varchar2)
16583: or l_people_group_id is null -- fix for bug 4633742.
16584: then
16585: hr_kflex_utility.upd_or_sel_keyflex_comb
16586: (p_appl_short_name => 'PAY'
16587: ,p_flex_code => 'GRP'
16588: ,p_flex_num => l_flex_num
16589: ,p_segment1 => l_pgp_segment1

Line 17264: hr_kflex_utility.unset_session_date

17260: p_gsp_post_process_warning := l_gsp_post_process_warning; -- bug 2999562
17261: --
17262: --
17263: -- remove data from the session table
17264: hr_kflex_utility.unset_session_date
17265: (p_session_id => l_session_id);
17266: --
17267: if g_debug then
17268: hr_utility.set_location(' Leaving:'||l_proc, 997);

Line 18301: hr_kflex_utility.set_profiles

18297: else
18298: l_location_id:=p_location_id;
18299: end if;
18300: --
18301: hr_kflex_utility.set_profiles
18302: (p_business_group_id => l_business_group_id
18303: ,p_assignment_id => p_assignment_id
18304: ,p_organization_id => l_organization_id
18305: ,p_location_id => l_location_id);

Line 18307: hr_kflex_utility.set_session_date

18303: ,p_assignment_id => p_assignment_id
18304: ,p_organization_id => l_organization_id
18305: ,p_location_id => l_location_id);
18306: --
18307: hr_kflex_utility.set_session_date
18308: (p_effective_date => l_effective_date
18309: ,p_session_id => l_session_id);
18310: --
18311: -- Maintain the people group key flexfields.

Line 18327: hr_kflex_utility.upd_or_sel_keyflex_comb

18323: close csr_grp_idsel;
18324: --
18325: if l_pgp_null_ind = 0
18326: then
18327: hr_kflex_utility.upd_or_sel_keyflex_comb
18328: (p_appl_short_name => 'PAY'
18329: ,p_flex_code => 'GRP'
18330: ,p_flex_num => l_flex_num
18331: ,p_segment1 => l_pgp_segment1

Line 18470: hr_kflex_utility.upd_or_sel_keyflex_comb

18466: --
18467: --
18468: -- Update or select the soft_coding_keyflex_id
18469: --
18470: hr_kflex_utility.upd_or_sel_keyflex_comb
18471: (p_appl_short_name => 'PER'
18472: ,p_flex_code => 'SCL'
18473: ,p_flex_num => l_flex_num
18474: ,p_segment1 => l_scl_segment1

Line 19036: hr_kflex_utility.unset_session_date

19032: p_cagr_grade_def_id := l_cagr_grade_def_id;
19033: p_cagr_concatenated_segments := l_cagr_concatenated_segments;
19034: --
19035: -- remove data from the session table
19036: hr_kflex_utility.unset_session_date
19037: (p_session_id => l_session_id);
19038: --
19039: if g_debug then
19040: hr_utility.set_location(' Leaving:'||l_proc, 6);

Line 20660: hr_kflex_utility.set_profiles

20656: -- insert the profile options and effective date for the flexfield
20657: -- validation to work
20658: --
20659: --
20660: hr_kflex_utility.set_profiles
20661: (p_business_group_id => l_business_group_id
20662: ,p_assignment_id => l_assignment_id
20663: ,p_organization_id => p_organization_id
20664: ,p_location_id => p_location_id);

Line 20666: hr_kflex_utility.set_session_date

20662: ,p_assignment_id => l_assignment_id
20663: ,p_organization_id => p_organization_id
20664: ,p_location_id => p_location_id);
20665: --
20666: hr_kflex_utility.set_session_date
20667: (p_effective_date => l_effective_date
20668: ,p_session_id => l_session_id);
20669: --
20670: -- Maintain the people group key flexfields.

Line 20705: hr_kflex_utility.upd_or_sel_keyflex_comb

20701: --
20702: if l_people_group_id is null
20703: then
20704: --
20705: hr_kflex_utility.upd_or_sel_keyflex_comb
20706: (p_appl_short_name => 'PAY'
20707: ,p_flex_code => 'GRP'
20708: ,p_flex_num => l_flex_num
20709: ,p_segment1 => l_pgp_segment1

Line 20850: hr_kflex_utility.ins_or_sel_keyflex_comb

20846: end if;
20847: --
20848: -- Insert or select the soft_coding_keyflex_id
20849: --
20850: hr_kflex_utility.ins_or_sel_keyflex_comb
20851: (p_appl_short_name => 'PER'
20852: ,p_flex_code => 'SCL'
20853: ,p_flex_num => l_flex_num
20854: ,p_segment1 => l_scl_segment1

Line 21476: hr_kflex_utility.unset_session_date

21472:
21473: --
21474: --
21475: -- remove data from the session table
21476: hr_kflex_utility.unset_session_date
21477: (p_session_id => l_session_id);
21478: --
21479: if g_debug then
21480: hr_utility.set_location(' Leaving:'||l_proc, 50);