[Home] [Help]
1074: ----------------------------------------------------------------------------
1075: -- {Start Of Comments}
1076: --
1077: -- Description:
1078: -- This procedure updates the hr_soft_coding_keyflex table after the flexfield
1079: -- segments have been inserted to keep the concatenated segment field up to
1080: -- date.
1081: --
1082: -- Prerequisites:
1079: -- segments have been inserted to keep the concatenated segment field up to
1080: -- date.
1081: --
1082: -- Prerequisites:
1083: -- A row must exist in the hr_soft_coding_keyflex table for p_soft_coding_keyflex_id
1084: --
1085: -- In Parameters:
1086: -- Name Reqd Type Description
1087: -- p_soft_coding_keyflex_id Yes number The primary key
1105: --
1106: --
1107: CURSOR csr_chk_scl is
1108: SELECT null
1109: FROM hr_soft_coding_keyflex
1110: where soft_coding_keyflex_id = p_soft_coding_keyflex_id
1111: and (concatenated_segments <> p_concatenated_segments
1112: or concatenated_segments is null);
1113: --
1121: PRAGMA AUTONOMOUS_TRANSACTION;
1122: --
1123: CURSOR csr_scl_lock is
1124: SELECT null
1125: FROM hr_soft_coding_keyflex
1126: where soft_coding_keyflex_id = p_soft_coding_keyflex_id
1127: for update nowait;
1128: --
1129: l_exists varchar2(30);
1160: --
1161: -- Lock obtained by this transaction, updating the concatenated
1162: -- segment string should be performed.
1163: --
1164: update hr_soft_coding_keyflex
1165: set concatenated_segments = p_concatenated_segments
1166: where soft_coding_keyflex_id = p_soft_coding_keyflex_id
1167: and (concatenated_segments <> p_concatenated_segments
1168: or concatenated_segments is null);
1274: --
1275: --
1276: l_proc VARCHAR2(72) := g_package||'validate_scl';
1277: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
1278: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
1279: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
1280: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
1281: l_scl_null_ind number(1) := 0;
1282:
1275: --
1276: l_proc VARCHAR2(72) := g_package||'validate_scl';
1277: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
1278: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
1279: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
1280: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
1281: l_scl_null_ind number(1) := 0;
1282:
1283: l_scl_segment1 varchar2(60) := p_segment1;
1376: segment27,
1377: segment28,
1378: segment29,
1379: segment30
1380: from hr_soft_coding_keyflex
1381: where soft_coding_keyflex_id = l_soft_coding_keyflex_id;
1382:
1383: --
1384: -- Start of Fix for Bug 2643451
1381: where soft_coding_keyflex_id = l_soft_coding_keyflex_id;
1382:
1383: --
1384: -- Start of Fix for Bug 2643451
1385: l_old_conc_segs hr_soft_coding_keyflex.concatenated_segments%TYPE;
1386: l_old_scl_segments c_scl_segments%rowtype;
1387: -- End of Fix for Bug 2643451
1388: --
1389:
3627: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3628: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3629: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3630: l_comment_id per_all_assignments_f.comment_id%TYPE;
3631: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3632: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3633: l_group_name pay_people_groups.group_name%TYPE;
3634: l_old_group_name pay_people_groups.group_name%TYPE;
3635: l_other_manager_warning boolean;
3628: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3629: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3630: l_comment_id per_all_assignments_f.comment_id%TYPE;
3631: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3632: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3633: l_group_name pay_people_groups.group_name%TYPE;
3634: l_old_group_name pay_people_groups.group_name%TYPE;
3635: l_other_manager_warning boolean;
3636: l_effective_date date;
4064: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4065: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4066: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4067: l_comment_id per_all_assignments_f.comment_id%TYPE;
4068: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4069: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4070: l_group_name pay_people_groups.group_name%TYPE;
4071: l_old_group_name pay_people_groups.group_name%TYPE;
4072: l_other_manager_warning boolean;
4065: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4066: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4067: l_comment_id per_all_assignments_f.comment_id%TYPE;
4068: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4069: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4070: l_group_name pay_people_groups.group_name%TYPE;
4071: l_old_group_name pay_people_groups.group_name%TYPE;
4072: l_other_manager_warning boolean;
4073: l_effective_date date;
4498: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4499: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4500: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4501: l_comment_id per_all_assignments_f.comment_id%TYPE;
4502: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4503: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4504: l_group_name pay_people_groups.group_name%TYPE;
4505: l_old_group_name pay_people_groups.group_name%TYPE;
4506: l_other_manager_warning boolean;
4499: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4500: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4501: l_comment_id per_all_assignments_f.comment_id%TYPE;
4502: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4503: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4504: l_group_name pay_people_groups.group_name%TYPE;
4505: l_old_group_name pay_people_groups.group_name%TYPE;
4506: l_other_manager_warning boolean;
4507: l_hourly_salaried_warning boolean;
4947: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4948: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4949: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4950: l_comment_id per_all_assignments_f.comment_id%TYPE;
4951: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4952: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4953: l_group_name pay_people_groups.group_name%TYPE;
4954: l_old_group_name pay_people_groups.group_name%TYPE;
4955: l_other_manager_warning boolean;
4948: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4949: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4950: l_comment_id per_all_assignments_f.comment_id%TYPE;
4951: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4952: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4953: l_group_name pay_people_groups.group_name%TYPE;
4954: l_old_group_name pay_people_groups.group_name%TYPE;
4955: l_other_manager_warning boolean;
4956: l_hourly_salaried_warning boolean;
5162: segment30
5163: from pay_people_groups
5164: where people_group_id = l_people_group_id;
5165: --
5166: -- bug 2359997 get hr_soft_coding_keyflex segment values where
5167: -- soft_coding_keyflex_id is known
5168: --
5169: cursor c_scl_segments is
5170: select segment1,
5196: segment27,
5197: segment28,
5198: segment29,
5199: segment30
5200: from hr_soft_coding_keyflex
5201: where soft_coding_keyflex_id = l_soft_coding_keyflex_id;
5202: --
5203: -- bug 2359997 get per_cagr_grades_def segment values where
5204: -- cagr_grade_def_id is known
5253: l_old_group_name:=p_pgp_concat_segments;
5254: --
5255: -- Bug 2359997 - if p_people_group_id enters with
5256: -- a value then get segment values from pay_people_groups.
5257: -- Do the same with the key flex ids for hr_soft_coding_keyflex and
5258: -- per_cagr_grades_def
5259: --
5260: --
5261: if g_debug then
6462: -- Declare LOCAL Variables
6463: --
6464: l_proc VARCHAR2(72) := g_package||'create_secondary_cwk_asg';
6465: l_effective_date DATE;
6466: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
6467: l_old_group_name pay_people_groups.group_name%TYPE;
6468: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
6469: l_other_manager_warning BOOLEAN;
6470: l_hourly_salaried_warning BOOLEAN;
6475: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
6476: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
6477: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
6478: l_comment_id per_all_assignments_f.comment_id%TYPE;
6479: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
6480: l_group_name pay_people_groups.group_name%TYPE;
6481: l_session_id NUMBER;
6482: l_business_group_id per_business_groups.business_group_id%TYPE;
6483: l_legislation_code per_business_groups.legislation_code%TYPE;
7740: l_legislation_code per_business_groups.legislation_code%TYPE;
7741: l_proc varchar2(72);
7742: --
7743: -- Declare dummy variables
7744: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
7745: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
7746: --
7747: -- Declare cursors
7748: --
8049: l_legislation_code per_business_groups.legislation_code%TYPE;
8050: l_proc varchar2(72);
8051: --
8052: -- Declare dummy variables
8053: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
8054: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
8055: --
8056: -- Declare cursors
8057: --
9524: l_no_managers_warning boolean;
9525: l_other_manager_warning boolean;
9526: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
9527: := p_soft_coding_keyflex_id; -- bug 2359997
9528: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9529: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9530: l_effective_date date;
9531: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9532: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9525: l_other_manager_warning boolean;
9526: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
9527: := p_soft_coding_keyflex_id; -- bug 2359997
9528: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9529: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9530: l_effective_date date;
9531: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9532: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9533: l_organization_id per_all_assignments_f.organization_id%type;
9847: l_other_manager_warning boolean;
9848: l_hourly_salaried_warning boolean;
9849: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
9850: := p_soft_coding_keyflex_id; -- bug 2359997
9851: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9852: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9853: l_effective_date date;
9854: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9855: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9848: l_hourly_salaried_warning boolean;
9849: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
9850: := p_soft_coding_keyflex_id; -- bug 2359997
9851: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9852: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9853: l_effective_date date;
9854: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9855: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9856: l_organization_id per_all_assignments_f.organization_id%type;
10182: l_no_managers_warning boolean;
10183: l_other_manager_warning boolean;
10184: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
10185: := p_soft_coding_keyflex_id; -- bug 2359997
10186: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
10187: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
10188: l_effective_date date;
10189: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
10190: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
10183: l_other_manager_warning boolean;
10184: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
10185: := p_soft_coding_keyflex_id; -- bug 2359997
10186: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
10187: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
10188: l_effective_date date;
10189: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
10190: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
10191: l_organization_id per_all_assignments_f.organization_id%type;
10538: l_no_managers_warning boolean;
10539: l_other_manager_warning boolean;
10540: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
10541: := p_soft_coding_keyflex_id; -- bug 2359997
10542: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
10543: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
10544: l_effective_date date;
10545: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
10546: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
10539: l_other_manager_warning boolean;
10540: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
10541: := p_soft_coding_keyflex_id; -- bug 2359997
10542: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
10543: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
10544: l_effective_date date;
10545: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
10546: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
10547: l_organization_id per_all_assignments_f.organization_id%type;
10688: where plr2.legislation_code = plr.legislation_code
10689: and plr2.rule_type = 'SDL'
10690: and plr2.rule_mode = 'A') ;
10691: --
10692: -- bug 2359997 get hr_soft_coding_keyflex segment values where
10693: -- soft_coding_keyflex_id is known
10694: --
10695: cursor c_scl_segments is
10696: select segment1,
10722: segment27,
10723: segment28,
10724: segment29,
10725: segment30
10726: from hr_soft_coding_keyflex
10727: where soft_coding_keyflex_id = l_soft_coding_keyflex_id;
10728: END */
10729: --
10730: -- bug 2359997 get per_cagr_grades_def segment values where
11880: l_no_managers_warning BOOLEAN;
11881: l_other_manager_warning BOOLEAN;
11882: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
11883: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
11884: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11885: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11886: l_hourly_salaried_warning BOOLEAN;
11887: l_session_id NUMBER;
11888: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
11881: l_other_manager_warning BOOLEAN;
11882: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
11883: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
11884: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11885: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11886: l_hourly_salaried_warning BOOLEAN;
11887: l_session_id NUMBER;
11888: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
11889: l_payroll_id_updated BOOLEAN;
11905: l_po_header_id NUMBER := p_po_header_id;
11906: l_vendor_id NUMBER := p_vendor_id;
11907: --
11908: /*
11909: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11910: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
11911: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
11912: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
11913: l_unused_start_date date;
15388: l_spp_delete_warning boolean;
15389: l_tax_district_changed_warning boolean;
15390:
15391: l_soft_coding_keyflex_id number;
15392: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15393: l_contract_id number;
15394: l_establishment_id number;
15395: l_scl_segment1 varchar2(60);
15396: l_proc varchar2(72) := g_package||'update_emp_asg_criteria';
15631: g_package || 'update_emp_asg_criteria';
15632:
15633: -- Start of Fix for Bug 2622747
15634: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
15635: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15636: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15637: -- End of Fix for Bug 2622747
15638:
15639: l_gsp_post_process_warning varchar2(2000); -- bug 2999562
15632:
15633: -- Start of Fix for Bug 2622747
15634: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
15635: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15636: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15637: -- End of Fix for Bug 2622747
15638:
15639: l_gsp_post_process_warning varchar2(2000); -- bug 2999562
15640:
15854: l_step_id per_spinal_point_steps_f.step_id%TYPE;
15855:
15856: -- Start of Fix for Bug 2622747
15857: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
15858: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15859: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15860: -- End of Fix for Bug 2622747
15861:
15862: --
15855:
15856: -- Start of Fix for Bug 2622747
15857: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
15858: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15859: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15860: -- End of Fix for Bug 2622747
15861:
15862: --
15863: -- bug 2359997 new variable to indicate whether people group key flex
17568: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;
17569: l_group_name pay_people_groups.group_name%TYPE;
17570: l_old_group_name pay_people_groups.group_name%TYPE;
17571: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
17572: l_scl_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE ;
17573: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
17574: l_proc varchar2(72) := g_package||'update_apl_asg';
17575: l_api_updating boolean;
17576: l_session_id number;
17569: l_group_name pay_people_groups.group_name%TYPE;
17570: l_old_group_name pay_people_groups.group_name%TYPE;
17571: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
17572: l_scl_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE ;
17573: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
17574: l_proc varchar2(72) := g_package||'update_apl_asg';
17575: l_api_updating boolean;
17576: l_session_id number;
17577: l_old_asg_status per_assignment_status_types.per_system_status%type;
17773: segment30
17774: from pay_people_groups
17775: where people_group_id = l_people_group_id;
17776: --
17777: -- bug 2230915 get hr_soft_coding_keyflex segment values where
17778: -- soft_coding_keyflex_id is known
17779: --
17780: cursor c_scl_segments is
17781: select segment1,
17807: segment27,
17808: segment28,
17809: segment29,
17810: segment30
17811: from hr_soft_coding_keyflex
17812: where soft_coding_keyflex_id = l_soft_coding_keyflex_id;
17813: --
17814: -- bug 2230915 get per_cagr_grades_def segment values where
17815: -- cagr_grade_def_id is known
17933: -- Populate l_people_group_id from g_old_rec for upd_or_sel_key_flex
17934: -- 2230915 only populate l_people_group_id from g_old_rec
17935: -- if p_people_group_id did not enter with a value. If it did enter with
17936: -- a value then get segment values from pay_people_groups.
17937: -- Do the same with the key flex ids for hr_soft_coding_keyflex and
17938: -- per_cagr_grades_def
17939: --
17940: l_business_group_id := per_asg_shd.g_old_rec.business_group_id;
17941: --
19232: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
19233: l_effective_date date;
19234: l_date_probation_end date;
19235: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
19236: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
19237: l_cagr_concatenated_segments varchar2(2000);
19238: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE;
19239: --
19240:
19239: --
19240:
19241: -- Bug 944911
19242: -- added an new var to handle in and out
19243: l_concat_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
19244: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;
19245: --
19246: -- Internal working variables
19247: --
19240:
19241: -- Bug 944911
19242: -- added an new var to handle in and out
19243: l_concat_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
19244: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;
19245: --
19246: -- Internal working variables
19247: --
19248: l_business_group_id per_business_groups.business_group_id%TYPE;
19965: l_proc varchar2(72) := g_package||'create_secondary_apl_asg';
19966: l_effective_date date;
19967: l_date_probation_end date;
19968: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
19969: l_scl_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE ;
19970: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
19971: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
19972: l_session_id number;
19973: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
19966: l_effective_date date;
19967: l_date_probation_end date;
19968: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
19969: l_scl_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE ;
19970: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
19971: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
19972: l_session_id number;
19973: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
19974: l_cagr_concatenated_segments varchar2(2000);
20170: segment30
20171: from pay_people_groups
20172: where people_group_id = l_people_group_id;
20173: --
20174: -- bug 2230915 get hr_soft_coding_keyflex segment values where
20175: -- soft_coding_keyflex_id is known
20176: --
20177: cursor c_scl_segments is
20178: select segment1,
20204: segment27,
20205: segment28,
20206: segment29,
20207: segment30
20208: from hr_soft_coding_keyflex
20209: where soft_coding_keyflex_id = l_soft_coding_keyflex_id;
20210: --
20211: -- bug 2230915 get per_cagr_grades_def segment values where
20212: -- cagr_grade_def_id is known
20304: close csr_get_derived_details;
20305: --
20306: -- Bug 2230915 - if p_people_group_id enters with
20307: -- a value then get segment values from pay_people_groups.
20308: -- Do the same with the key flex ids for hr_soft_coding_keyflex and
20309: -- per_cagr_grades_def
20310: --
20311: --
20312: if g_debug then
21678: l_legislation_code per_business_groups.legislation_code%TYPE;
21679: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
21680: l_proc varchar2(72);
21681: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
21682: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
21683: l_effective_date date;
21684: l_date_probation_end date;
21685: l_cagr_concatenated_segments varchar2(3000);
21686: l_cagr_grade_def_id number;