[Home] [Help]
513: ----------------------------------------------------------------------------
514: -- {Start Of Comments}
515: --
516: -- Description:
517: -- This procedure updates the hr_soft_coding_keyflex table after the flexfield
518: -- segments have been inserted to keep the concatenated segment field up to
519: -- date.
520: --
521: -- Prerequisites:
518: -- segments have been inserted to keep the concatenated segment field up to
519: -- date.
520: --
521: -- Prerequisites:
522: -- A row must exist in the hr_soft_coding_keyflex table for p_soft_coding_keyflex_id
523: --
524: -- In Parameters:
525: -- Name Reqd Type Description
526: -- p_soft_coding_keyflex_id Yes number The primary key
544: --
545: --
546: CURSOR csr_chk_scl is
547: SELECT null
548: FROM hr_soft_coding_keyflex
549: where soft_coding_keyflex_id = p_soft_coding_keyflex_id
550: and (concatenated_segments <> p_concatenated_segments
551: or concatenated_segments is null);
552: --
560: PRAGMA AUTONOMOUS_TRANSACTION;
561: --
562: CURSOR csr_scl_lock is
563: SELECT null
564: FROM hr_soft_coding_keyflex
565: where soft_coding_keyflex_id = p_soft_coding_keyflex_id
566: for update nowait;
567: --
568: l_exists varchar2(30);
599: --
600: -- Lock obtained by this transaction, updating the concatenated
601: -- segment string should be performed.
602: --
603: update hr_soft_coding_keyflex
604: set concatenated_segments = p_concatenated_segments
605: where soft_coding_keyflex_id = p_soft_coding_keyflex_id
606: and (concatenated_segments <> p_concatenated_segments
607: or concatenated_segments is null);
713: --
714: --
715: l_proc VARCHAR2(72) := g_package||'validate_scl';
716: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
717: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
718: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
719: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
720: l_scl_null_ind number(1) := 0;
721:
714: --
715: l_proc VARCHAR2(72) := g_package||'validate_scl';
716: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
717: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
718: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
719: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
720: l_scl_null_ind number(1) := 0;
721:
722: l_scl_segment1 varchar2(60) := p_segment1;
815: segment27,
816: segment28,
817: segment29,
818: segment30
819: from hr_soft_coding_keyflex
820: where soft_coding_keyflex_id = l_soft_coding_keyflex_id;
821:
822: --
823: -- Start of Fix for Bug 2643451
820: where soft_coding_keyflex_id = l_soft_coding_keyflex_id;
821:
822: --
823: -- Start of Fix for Bug 2643451
824: l_old_conc_segs hr_soft_coding_keyflex.concatenated_segments%TYPE;
825: l_old_scl_segments c_scl_segments%rowtype;
826: -- End of Fix for Bug 2643451
827: --
828:
3060: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3061: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3062: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3063: l_comment_id per_all_assignments_f.comment_id%TYPE;
3064: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3065: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3066: l_group_name pay_people_groups.group_name%TYPE;
3067: l_old_group_name pay_people_groups.group_name%TYPE;
3068: l_other_manager_warning boolean;
3061: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3062: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3063: l_comment_id per_all_assignments_f.comment_id%TYPE;
3064: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3065: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3066: l_group_name pay_people_groups.group_name%TYPE;
3067: l_old_group_name pay_people_groups.group_name%TYPE;
3068: l_other_manager_warning boolean;
3069: l_effective_date date;
3497: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3498: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3499: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3500: l_comment_id per_all_assignments_f.comment_id%TYPE;
3501: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3502: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3503: l_group_name pay_people_groups.group_name%TYPE;
3504: l_old_group_name pay_people_groups.group_name%TYPE;
3505: l_other_manager_warning boolean;
3498: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3499: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3500: l_comment_id per_all_assignments_f.comment_id%TYPE;
3501: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3502: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3503: l_group_name pay_people_groups.group_name%TYPE;
3504: l_old_group_name pay_people_groups.group_name%TYPE;
3505: l_other_manager_warning boolean;
3506: l_effective_date date;
3931: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3932: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3933: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3934: l_comment_id per_all_assignments_f.comment_id%TYPE;
3935: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3936: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3937: l_group_name pay_people_groups.group_name%TYPE;
3938: l_old_group_name pay_people_groups.group_name%TYPE;
3939: l_other_manager_warning boolean;
3932: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3933: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3934: l_comment_id per_all_assignments_f.comment_id%TYPE;
3935: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3936: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3937: l_group_name pay_people_groups.group_name%TYPE;
3938: l_old_group_name pay_people_groups.group_name%TYPE;
3939: l_other_manager_warning boolean;
3940: l_hourly_salaried_warning boolean;
4380: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4381: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4382: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4383: l_comment_id per_all_assignments_f.comment_id%TYPE;
4384: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4385: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4386: l_group_name pay_people_groups.group_name%TYPE;
4387: l_old_group_name pay_people_groups.group_name%TYPE;
4388: l_other_manager_warning boolean;
4381: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4382: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4383: l_comment_id per_all_assignments_f.comment_id%TYPE;
4384: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4385: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4386: l_group_name pay_people_groups.group_name%TYPE;
4387: l_old_group_name pay_people_groups.group_name%TYPE;
4388: l_other_manager_warning boolean;
4389: l_hourly_salaried_warning boolean;
4595: segment30
4596: from pay_people_groups
4597: where people_group_id = l_people_group_id;
4598: --
4599: -- bug 2359997 get hr_soft_coding_keyflex segment values where
4600: -- soft_coding_keyflex_id is known
4601: --
4602: cursor c_scl_segments is
4603: select segment1,
4629: segment27,
4630: segment28,
4631: segment29,
4632: segment30
4633: from hr_soft_coding_keyflex
4634: where soft_coding_keyflex_id = l_soft_coding_keyflex_id;
4635: --
4636: -- bug 2359997 get per_cagr_grades_def segment values where
4637: -- cagr_grade_def_id is known
4686: l_old_group_name:=p_pgp_concat_segments;
4687: --
4688: -- Bug 2359997 - if p_people_group_id enters with
4689: -- a value then get segment values from pay_people_groups.
4690: -- Do the same with the key flex ids for hr_soft_coding_keyflex and
4691: -- per_cagr_grades_def
4692: --
4693: --
4694: if g_debug then
5895: -- Declare LOCAL Variables
5896: --
5897: l_proc VARCHAR2(72) := g_package||'create_secondary_cwk_asg';
5898: l_effective_date DATE;
5899: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
5900: l_old_group_name pay_people_groups.group_name%TYPE;
5901: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
5902: l_other_manager_warning BOOLEAN;
5903: l_hourly_salaried_warning BOOLEAN;
5908: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
5909: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
5910: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
5911: l_comment_id per_all_assignments_f.comment_id%TYPE;
5912: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
5913: l_group_name pay_people_groups.group_name%TYPE;
5914: l_session_id NUMBER;
5915: l_business_group_id per_business_groups.business_group_id%TYPE;
5916: l_legislation_code per_business_groups.legislation_code%TYPE;
7173: l_legislation_code per_business_groups.legislation_code%TYPE;
7174: l_proc varchar2(72);
7175: --
7176: -- Declare dummy variables
7177: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
7178: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
7179: --
7180: -- Declare cursors
7181: --
7482: l_legislation_code per_business_groups.legislation_code%TYPE;
7483: l_proc varchar2(72);
7484: --
7485: -- Declare dummy variables
7486: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
7487: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
7488: --
7489: -- Declare cursors
7490: --
8957: l_no_managers_warning boolean;
8958: l_other_manager_warning boolean;
8959: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
8960: := p_soft_coding_keyflex_id; -- bug 2359997
8961: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
8962: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
8963: l_effective_date date;
8964: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
8965: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
8958: l_other_manager_warning boolean;
8959: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
8960: := p_soft_coding_keyflex_id; -- bug 2359997
8961: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
8962: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
8963: l_effective_date date;
8964: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
8965: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
8966: l_organization_id per_all_assignments_f.organization_id%type;
9280: l_other_manager_warning boolean;
9281: l_hourly_salaried_warning boolean;
9282: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
9283: := p_soft_coding_keyflex_id; -- bug 2359997
9284: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9285: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9286: l_effective_date date;
9287: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9288: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9281: l_hourly_salaried_warning boolean;
9282: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
9283: := p_soft_coding_keyflex_id; -- bug 2359997
9284: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9285: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9286: l_effective_date date;
9287: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9288: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9289: l_organization_id per_all_assignments_f.organization_id%type;
9615: l_no_managers_warning boolean;
9616: l_other_manager_warning boolean;
9617: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
9618: := p_soft_coding_keyflex_id; -- bug 2359997
9619: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9620: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9621: l_effective_date date;
9622: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9623: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9616: l_other_manager_warning boolean;
9617: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
9618: := p_soft_coding_keyflex_id; -- bug 2359997
9619: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9620: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9621: l_effective_date date;
9622: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9623: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9624: l_organization_id per_all_assignments_f.organization_id%type;
9971: l_no_managers_warning boolean;
9972: l_other_manager_warning boolean;
9973: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
9974: := p_soft_coding_keyflex_id; -- bug 2359997
9975: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9976: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9977: l_effective_date date;
9978: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9979: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9972: l_other_manager_warning boolean;
9973: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
9974: := p_soft_coding_keyflex_id; -- bug 2359997
9975: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9976: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9977: l_effective_date date;
9978: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9979: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9980: l_organization_id per_all_assignments_f.organization_id%type;
10121: where plr2.legislation_code = plr.legislation_code
10122: and plr2.rule_type = 'SDL'
10123: and plr2.rule_mode = 'A') ;
10124: --
10125: -- bug 2359997 get hr_soft_coding_keyflex segment values where
10126: -- soft_coding_keyflex_id is known
10127: --
10128: cursor c_scl_segments is
10129: select segment1,
10155: segment27,
10156: segment28,
10157: segment29,
10158: segment30
10159: from hr_soft_coding_keyflex
10160: where soft_coding_keyflex_id = l_soft_coding_keyflex_id;
10161: END */
10162: --
10163: -- bug 2359997 get per_cagr_grades_def segment values where
11279: l_no_managers_warning BOOLEAN;
11280: l_other_manager_warning BOOLEAN;
11281: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
11282: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
11283: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11284: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11285: l_hourly_salaried_warning BOOLEAN;
11286: l_session_id NUMBER;
11287: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
11280: l_other_manager_warning BOOLEAN;
11281: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
11282: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
11283: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11284: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11285: l_hourly_salaried_warning BOOLEAN;
11286: l_session_id NUMBER;
11287: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
11288: l_payroll_id_updated BOOLEAN;
11304: l_po_header_id NUMBER := p_po_header_id;
11305: l_vendor_id NUMBER := p_vendor_id;
11306: --
11307: /*
11308: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11309: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
11310: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
11311: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
11312: l_unused_start_date date;
14787: l_spp_delete_warning boolean;
14788: l_tax_district_changed_warning boolean;
14789:
14790: l_soft_coding_keyflex_id number;
14791: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
14792: l_contract_id number;
14793: l_establishment_id number;
14794: l_scl_segment1 varchar2(60);
14795: l_proc varchar2(72) := g_package||'update_emp_asg_criteria';
15030: g_package || 'update_emp_asg_criteria';
15031:
15032: -- Start of Fix for Bug 2622747
15033: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
15034: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15035: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15036: -- End of Fix for Bug 2622747
15037:
15038: l_gsp_post_process_warning varchar2(2000); -- bug 2999562
15031:
15032: -- Start of Fix for Bug 2622747
15033: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
15034: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15035: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15036: -- End of Fix for Bug 2622747
15037:
15038: l_gsp_post_process_warning varchar2(2000); -- bug 2999562
15039:
15252: l_step_id per_spinal_point_steps_f.step_id%TYPE;
15253:
15254: -- Start of Fix for Bug 2622747
15255: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
15256: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15257: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15258: -- End of Fix for Bug 2622747
15259:
15260: --
15253:
15254: -- Start of Fix for Bug 2622747
15255: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
15256: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15257: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15258: -- End of Fix for Bug 2622747
15259:
15260: --
15261: -- bug 2359997 new variable to indicate whether people group key flex
16722: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;
16723: l_group_name pay_people_groups.group_name%TYPE;
16724: l_old_group_name pay_people_groups.group_name%TYPE;
16725: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
16726: l_scl_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE ;
16727: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
16728: l_proc varchar2(72) := g_package||'update_apl_asg';
16729: l_api_updating boolean;
16730: l_session_id number;
16723: l_group_name pay_people_groups.group_name%TYPE;
16724: l_old_group_name pay_people_groups.group_name%TYPE;
16725: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
16726: l_scl_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE ;
16727: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
16728: l_proc varchar2(72) := g_package||'update_apl_asg';
16729: l_api_updating boolean;
16730: l_session_id number;
16731: l_old_asg_status per_assignment_status_types.per_system_status%type;
16927: segment30
16928: from pay_people_groups
16929: where people_group_id = l_people_group_id;
16930: --
16931: -- bug 2230915 get hr_soft_coding_keyflex segment values where
16932: -- soft_coding_keyflex_id is known
16933: --
16934: cursor c_scl_segments is
16935: select segment1,
16961: segment27,
16962: segment28,
16963: segment29,
16964: segment30
16965: from hr_soft_coding_keyflex
16966: where soft_coding_keyflex_id = l_soft_coding_keyflex_id;
16967: --
16968: -- bug 2230915 get per_cagr_grades_def segment values where
16969: -- cagr_grade_def_id is known
17086: -- Populate l_people_group_id from g_old_rec for upd_or_sel_key_flex
17087: -- 2230915 only populate l_people_group_id from g_old_rec
17088: -- if p_people_group_id did not enter with a value. If it did enter with
17089: -- a value then get segment values from pay_people_groups.
17090: -- Do the same with the key flex ids for hr_soft_coding_keyflex and
17091: -- per_cagr_grades_def
17092: --
17093: l_business_group_id := per_asg_shd.g_old_rec.business_group_id;
17094: --
18369: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
18370: l_effective_date date;
18371: l_date_probation_end date;
18372: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
18373: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
18374: l_cagr_concatenated_segments varchar2(2000);
18375: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE;
18376: --
18377:
18376: --
18377:
18378: -- Bug 944911
18379: -- added an new var to handle in and out
18380: l_concat_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
18381: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;
18382: --
18383: -- Internal working variables
18384: --
18377:
18378: -- Bug 944911
18379: -- added an new var to handle in and out
18380: l_concat_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
18381: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;
18382: --
18383: -- Internal working variables
18384: --
18385: l_business_group_id per_business_groups.business_group_id%TYPE;
19102: l_proc varchar2(72) := g_package||'create_secondary_apl_asg';
19103: l_effective_date date;
19104: l_date_probation_end date;
19105: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
19106: l_scl_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE ;
19107: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
19108: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
19109: l_session_id number;
19110: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
19103: l_effective_date date;
19104: l_date_probation_end date;
19105: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
19106: l_scl_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE ;
19107: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
19108: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
19109: l_session_id number;
19110: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
19111: l_cagr_concatenated_segments varchar2(2000);
19307: segment30
19308: from pay_people_groups
19309: where people_group_id = l_people_group_id;
19310: --
19311: -- bug 2230915 get hr_soft_coding_keyflex segment values where
19312: -- soft_coding_keyflex_id is known
19313: --
19314: cursor c_scl_segments is
19315: select segment1,
19341: segment27,
19342: segment28,
19343: segment29,
19344: segment30
19345: from hr_soft_coding_keyflex
19346: where soft_coding_keyflex_id = l_soft_coding_keyflex_id;
19347: --
19348: -- bug 2230915 get per_cagr_grades_def segment values where
19349: -- cagr_grade_def_id is known
19441: close csr_get_derived_details;
19442: --
19443: -- Bug 2230915 - if p_people_group_id enters with
19444: -- a value then get segment values from pay_people_groups.
19445: -- Do the same with the key flex ids for hr_soft_coding_keyflex and
19446: -- per_cagr_grades_def
19447: --
19448: --
19449: if g_debug then
20815: l_legislation_code per_business_groups.legislation_code%TYPE;
20816: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
20817: l_proc varchar2(72);
20818: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
20819: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
20820: l_effective_date date;
20821: l_date_probation_end date;
20822: l_cagr_concatenated_segments varchar2(3000);
20823: l_cagr_grade_def_id number;