eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ASSIGNMENT_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 212: from per_all_assignments_f

208: select date_end ,date_received, application_id
209: from per_applications papp
210: where application_id =
211: ( select distinct (application_id)
212: from per_all_assignments_f
213: where assignment_id = p_assignment_id and
214: business_group_id = p_business_group_id )
215: for update nowait;
216:

Line 219: from per_all_assignments_f a

215: for update nowait;
216:
217: cursor c2 is
218: select 1
219: from per_all_assignments_f a
220: where assignment_id = p_assignment_id
221: and exists
222: (select null
223: from per_assignment_status_types b

Line 263: from per_all_assignments_f

259: and p_effective_date between effective_start_date and effective_end_date;
260:
261: cursor csr_chk_asg_exists is
262: select 1
263: from per_all_assignments_f
264: where business_group_id = p_business_group_id
265: and person_id = p_person_id
266: and assignment_id = p_assignment_id;
267: --and p_effective_date between effective_start_date and effective_end_date;

Line 379: from per_all_assignments_f

375: hr_utility.set_location('reverse_term_apln_fut - l_date_end:'|| l_date_end, 10);
376:
377:
378: select effective_start_date, effective_end_date,object_version_number into l_asg_start_date,l_asg_end_date,l_ovn
379: from per_all_assignments_f
380: where assignment_id = p_assignment_id
381: and effective_end_date = (select max(effective_end_date)
382: from per_all_assignments_f
383: where assignment_id = p_assignment_id );

Line 382: from per_all_assignments_f

378: select effective_start_date, effective_end_date,object_version_number into l_asg_start_date,l_asg_end_date,l_ovn
379: from per_all_assignments_f
380: where assignment_id = p_assignment_id
381: and effective_end_date = (select max(effective_end_date)
382: from per_all_assignments_f
383: where assignment_id = p_assignment_id );
384:
385: hr_utility.set_location('reverse_term_apln_fut - l_asg_end_date:'|| l_asg_end_date, 20);
386:

Line 388: from per_all_assignments_f

384:
385: hr_utility.set_location('reverse_term_apln_fut - l_asg_end_date:'|| l_asg_end_date, 20);
386:
387: select assignment_status_type_id into l_assignment_status_id
388: from per_all_assignments_f
389: where assignment_id = p_assignment_id
390: and effective_end_date = l_asg_end_date ;
391:
392: hr_utility.set_location('reverse_term_apln_fut - l_assignment_status_id:'|| l_assignment_status_id, 30);

Line 447: update per_all_assignments_f

443:
444:
445: hr_utility.set_location('Entering:'|| l_proc, 70);
446:
447: update per_all_assignments_f
448: set effective_end_date = l_eot
449: where assignment_id = p_assignment_id
450: and person_id=p_person_id
451: and business_group_id= p_business_group_id

Line 586: update per_all_assignments_f

582: -- update the future asgs with the application ID
583: for apl in future_apl(l_date_recieved)
584: loop
585:
586: update per_all_assignments_f
587: set application_id = l_application_id
588: where person_id = p_person_id
589: and application_id =apl.application_id
590: and effective_start_date >= apl.date_received

Line 603: update per_all_assignments_f

599: hr_utility.set_location('At reverse_term_apln_fut',188);
600:
601: -- now update the assignments table
602:
603: update per_all_assignments_f
604: set effective_end_date = l_eot
605: where assignment_id = p_assignment_id
606: and person_id=p_person_id
607: and business_group_id= p_business_group_id

Line 642: -- data must exists in the table per_all_assignments_f for an Person

638: -- This procedure is used to reverse the termination of an applicant at
639: -- application level.
640: --
641: -- Prerequisites:
642: -- data must exists in the table per_all_assignments_f for an Person
643: --
644: -- In Parameters:
645: -- Name Reqd Type Description
646: -- p_effective_date yes Effective date

Line 693: from per_all_assignments_f

689: select date_end ,date_received, application_id
690: from per_applications papp
691: where application_id =
692: ( select distinct (application_id)
693: from per_all_assignments_f
694: where assignment_id = p_assignment_id and
695: business_group_id = p_business_group_id )
696: for update nowait;
697:

Line 700: from per_all_assignments_f a

696: for update nowait;
697:
698: cursor c2 is
699: select 1
700: from per_all_assignments_f a
701: where assignment_id = p_assignment_id
702: and exists
703: (select null
704: from per_assignment_status_types b

Line 741: from per_all_assignments_f

737: and p_effective_date between effective_start_date and effective_end_date;
738:
739: cursor csr_chk_asg_exists is
740: select 1
741: from per_all_assignments_f
742: where business_group_id = p_business_group_id
743: and person_id = p_person_id
744: and assignment_id = p_assignment_id;
745: --and p_effective_date between effective_start_date and effective_end_date;

Line 843: from per_all_assignments_f

839: hr_utility.set_location('REVERSE_TERM_APLN - l_date_end:'|| l_date_end, 10);
840:
841:
842: select effective_start_date, effective_end_date,object_version_number into l_asg_start_date,l_asg_end_date,l_ovn
843: from per_all_assignments_f
844: where assignment_id = p_assignment_id
845: and effective_end_date = (select max(effective_end_date)
846: from per_all_assignments_f
847: where assignment_id = p_assignment_id );

Line 846: from per_all_assignments_f

842: select effective_start_date, effective_end_date,object_version_number into l_asg_start_date,l_asg_end_date,l_ovn
843: from per_all_assignments_f
844: where assignment_id = p_assignment_id
845: and effective_end_date = (select max(effective_end_date)
846: from per_all_assignments_f
847: where assignment_id = p_assignment_id );
848:
849: hr_utility.set_location('REVERSE_TERM_APLN - l_asg_end_date:'|| l_asg_end_date, 20);
850:

Line 852: from per_all_assignments_f

848:
849: hr_utility.set_location('REVERSE_TERM_APLN - l_asg_end_date:'|| l_asg_end_date, 20);
850:
851: select assignment_status_type_id into l_assignment_status_id
852: from per_all_assignments_f
853: where assignment_id = p_assignment_id
854: and effective_end_date = l_asg_end_date ;
855:
856: hr_utility.set_location('REVERSE_TERM_APLN - l_assignment_status_id:'|| l_assignment_status_id, 30);

Line 911: update per_all_assignments_f

907:
908:
909: hr_utility.set_location('Entering:'|| l_proc, 70);
910:
911: update per_all_assignments_f
912: set effective_end_date = l_eot
913: where assignment_id = p_assignment_id
914: and person_id=p_person_id
915: and business_group_id= p_business_group_id

Line 1044: update per_all_assignments_f

1040: p_validation_start_date =>l_validation_start_date,
1041: p_validation_end_date => l_validation_end_date);
1042:
1043:
1044: update per_all_assignments_f
1045: set effective_end_date = l_eot
1046: where assignment_id = p_assignment_id
1047: and person_id=p_person_id
1048: and business_group_id= p_business_group_id

Line 1277: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;

1273: -- Local Variables
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;

Line 1319: from per_all_assignments_f asg

1315: -- Cursor Defination.
1316: --
1317: cursor csr_get_soft_coding_keyflex is
1318: select asg.soft_coding_keyflex_id
1319: from per_all_assignments_f asg
1320: where asg.assignment_id = p_assignment_id
1321: and p_effective_date between asg.effective_start_date
1322: and asg.effective_end_date;
1323:

Line 1721: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

1717: --
1718: -- {End of Comments}
1719: --
1720: FUNCTION last_apl_asg
1721: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1722: ,p_effective_date IN DATE
1723: )
1724: RETURN BOOLEAN
1725: IS

Line 1736: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

1732: --
1733: -- Local cursors
1734: --
1735: CURSOR csr_last_apl_asg
1736: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1737: ,p_effective_date IN DATE
1738: )
1739: IS
1740: SELECT as2.assignment_id

Line 1741: FROM per_all_assignments_f as2

1737: ,p_effective_date IN DATE
1738: )
1739: IS
1740: SELECT as2.assignment_id
1741: FROM per_all_assignments_f as2
1742: ,per_all_assignments_f as1
1743: WHERE as2.person_id = as1.person_id
1744: AND as2.assignment_type = as1.assignment_type
1745: AND csr_last_apl_asg.p_effective_date BETWEEN as2.effective_start_date

Line 1742: ,per_all_assignments_f as1

1738: )
1739: IS
1740: SELECT as2.assignment_id
1741: FROM per_all_assignments_f as2
1742: ,per_all_assignments_f as1
1743: WHERE as2.person_id = as1.person_id
1744: AND as2.assignment_type = as1.assignment_type
1745: AND csr_last_apl_asg.p_effective_date BETWEEN as2.effective_start_date
1746: AND as2.effective_end_date

Line 1808: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

1804: l_effective_date date;
1805: --
1806: -- Out variables
1807: --
1808: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
1809: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1810: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
1811: --
1812: lv_object_version_number number := p_object_version_number ;

Line 1809: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

1805: --
1806: -- Out variables
1807: --
1808: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
1809: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1810: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
1811: --
1812: lv_object_version_number number := p_object_version_number ;
1813: --

Line 1810: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

1806: -- Out variables
1807: --
1808: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
1809: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1810: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
1811: --
1812: lv_object_version_number number := p_object_version_number ;
1813: --
1814: l_proc varchar2(72);

Line 1976: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

1972: l_effective_date date;
1973: --
1974: -- Out variables
1975: --
1976: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
1977: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1978: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
1979: --
1980: lv_object_version_number number := p_object_version_number ;

Line 1977: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

1973: --
1974: -- Out variables
1975: --
1976: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
1977: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1978: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
1979: --
1980: lv_object_version_number number := p_object_version_number ;
1981: --

Line 1978: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

1974: -- Out variables
1975: --
1976: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
1977: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1978: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
1979: --
1980: lv_object_version_number number := p_object_version_number ;
1981: --
1982: l_proc varchar2(72);

Line 2145: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

2141: -- Out variables
2142: --
2143: l_asg_future_changes_warning boolean := FALSE;
2144: l_pay_proposal_warning boolean := FALSE;
2145: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2146: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2147: l_entries_changed_warning varchar2(1) := 'N';
2148: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2149: --

Line 2146: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

2142: --
2143: l_asg_future_changes_warning boolean := FALSE;
2144: l_pay_proposal_warning boolean := FALSE;
2145: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2146: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2147: l_entries_changed_warning varchar2(1) := 'N';
2148: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2149: --
2150: l_assignment_status_type_id

Line 2148: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

2144: l_pay_proposal_warning boolean := FALSE;
2145: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2146: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2147: l_entries_changed_warning varchar2(1) := 'N';
2148: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2149: --
2150: l_assignment_status_type_id
2151: per_all_assignments_f.assignment_status_type_id%TYPE;
2152: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

Line 2151: per_all_assignments_f.assignment_status_type_id%TYPE;

2147: l_entries_changed_warning varchar2(1) := 'N';
2148: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2149: --
2150: l_assignment_status_type_id
2151: per_all_assignments_f.assignment_status_type_id%TYPE;
2152: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
2153: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
2154: l_exists varchar2(1);
2155: l_last_standard_process_date

Line 2152: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

2148: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2149: --
2150: l_assignment_status_type_id
2151: per_all_assignments_f.assignment_status_type_id%TYPE;
2152: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
2153: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
2154: l_exists varchar2(1);
2155: l_last_standard_process_date
2156: per_periods_of_service.last_standard_process_date%TYPE;

Line 2153: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;

2149: --
2150: l_assignment_status_type_id
2151: per_all_assignments_f.assignment_status_type_id%TYPE;
2152: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
2153: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
2154: l_exists varchar2(1);
2155: l_last_standard_process_date
2156: per_periods_of_service.last_standard_process_date%TYPE;
2157: l_actual_termination_date

Line 2160: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

2156: per_periods_of_service.last_standard_process_date%TYPE;
2157: l_actual_termination_date
2158: per_periods_of_service.actual_termination_date%TYPE;
2159: l_legislation_code per_business_groups.legislation_code%TYPE;
2160: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
2161: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
2162: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
2163: l_proc varchar2(72)
2164: := g_package || 'actual_termination_cwk_asg';

Line 2162: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

2158: per_periods_of_service.actual_termination_date%TYPE;
2159: l_legislation_code per_business_groups.legislation_code%TYPE;
2160: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
2161: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
2162: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
2163: l_proc varchar2(72)
2164: := g_package || 'actual_termination_cwk_asg';
2165: --
2166: lv_object_version_number number := p_object_version_number ;

Line 2174: from per_all_assignments_f asg

2170: , asg.payroll_id
2171: , asg.primary_flag
2172: , bus.business_group_id
2173: , bus.legislation_code
2174: from per_all_assignments_f asg
2175: , per_business_groups_perf bus
2176: where asg.assignment_id = p_assignment_id
2177: and l_actual_termination_date between asg.effective_start_date
2178: and asg.effective_end_date

Line 2183: from per_all_assignments_f asg

2179: and bus.business_group_id+0 = asg.business_group_id;
2180: --
2181: cursor csr_invalid_term_assign is
2182: select null
2183: from per_all_assignments_f asg
2184: , per_assignment_status_types ast
2185: where asg.assignment_id = p_assignment_id
2186: and asg.effective_end_date >= l_actual_termination_date
2187: and ast.assignment_status_type_id = asg.assignment_status_type_id

Line 2553: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

2549: --
2550: -- Out variables
2551: --
2552: l_asg_future_changes_warning boolean := FALSE;
2553: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2554: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2555: l_entries_changed_warning varchar2(1) := 'N';
2556: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2557: l_org_now_no_manager_warning boolean := FALSE;

Line 2554: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

2550: -- Out variables
2551: --
2552: l_asg_future_changes_warning boolean := FALSE;
2553: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2554: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2555: l_entries_changed_warning varchar2(1) := 'N';
2556: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2557: l_org_now_no_manager_warning boolean := FALSE;
2558: --

Line 2556: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

2552: l_asg_future_changes_warning boolean := FALSE;
2553: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2554: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2555: l_entries_changed_warning varchar2(1) := 'N';
2556: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2557: l_org_now_no_manager_warning boolean := FALSE;
2558: --
2559: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
2560: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

Line 2559: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

2555: l_entries_changed_warning varchar2(1) := 'N';
2556: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2557: l_org_now_no_manager_warning boolean := FALSE;
2558: --
2559: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
2560: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
2561: l_proc varchar2(72)
2562: := g_package || 'final_process_cwk_asg';
2563: l_actual_termination_date date;

Line 2560: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

2556: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2557: l_org_now_no_manager_warning boolean := FALSE;
2558: --
2559: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
2560: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
2561: l_proc varchar2(72)
2562: := g_package || 'final_process_cwk_asg';
2563: l_actual_termination_date date;
2564: l_final_process_date date;

Line 2572: from per_all_assignments_f asg

2568: --
2569: cursor csr_get_derived_details is
2570: select asg.assignment_type
2571: , asg.primary_flag
2572: from per_all_assignments_f asg
2573: where asg.assignment_id = p_assignment_id
2574: and l_final_process_date between asg.effective_start_date
2575: and asg.effective_end_date;
2576: --

Line 2579: from per_all_assignments_f asg

2575: and asg.effective_end_date;
2576: --
2577: cursor csr_valid_term_assign is
2578: select min(asg.effective_start_date) - 1
2579: from per_all_assignments_f asg
2580: where asg.assignment_id = p_assignment_id
2581: and exists ( select null
2582: from per_assignment_status_types ast
2583: where ast.assignment_status_type_id

Line 2590: from per_all_assignments_f asg

2586:
2587: --
2588: cursor csr_invalid_term_assign is
2589: select max(asg.effective_end_date)
2590: from per_all_assignments_f asg
2591: where asg.assignment_id = p_assignment_id
2592: and exists ( select null
2593: from per_assignment_status_types ast
2594: where ast.assignment_status_type_id

Line 2899: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

2895: l_effective_date date;
2896: --
2897: -- Out variables
2898: --
2899: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2900: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2901: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2902: --
2903: l_proc varchar2(72);

Line 2900: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

2896: --
2897: -- Out variables
2898: --
2899: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2900: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2901: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2902: --
2903: l_proc varchar2(72);
2904: --

Line 2901: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

2897: -- Out variables
2898: --
2899: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2900: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2901: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2902: --
2903: l_proc varchar2(72);
2904: --
2905: begin

Line 3061: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

3057: -- Out variables
3058: --
3059: l_asg_future_changes_warning boolean := FALSE;
3060: l_pay_proposal_warning boolean := FALSE;
3061: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3062: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3063: l_entries_changed_warning varchar2(1) := 'N';
3064: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3065: --

Line 3062: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

3058: --
3059: l_asg_future_changes_warning boolean := FALSE;
3060: l_pay_proposal_warning boolean := FALSE;
3061: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3062: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3063: l_entries_changed_warning varchar2(1) := 'N';
3064: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3065: --
3066: l_assignment_status_type_id

Line 3064: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

3060: l_pay_proposal_warning boolean := FALSE;
3061: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3062: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3063: l_entries_changed_warning varchar2(1) := 'N';
3064: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3065: --
3066: l_assignment_status_type_id
3067: per_all_assignments_f.assignment_status_type_id%TYPE;
3068: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

Line 3067: per_all_assignments_f.assignment_status_type_id%TYPE;

3063: l_entries_changed_warning varchar2(1) := 'N';
3064: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3065: --
3066: l_assignment_status_type_id
3067: per_all_assignments_f.assignment_status_type_id%TYPE;
3068: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
3069: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
3070: l_exists varchar2(1);
3071: l_last_standard_process_date

Line 3068: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

3064: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3065: --
3066: l_assignment_status_type_id
3067: per_all_assignments_f.assignment_status_type_id%TYPE;
3068: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
3069: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
3070: l_exists varchar2(1);
3071: l_last_standard_process_date
3072: per_periods_of_service.last_standard_process_date%TYPE;

Line 3069: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;

3065: --
3066: l_assignment_status_type_id
3067: per_all_assignments_f.assignment_status_type_id%TYPE;
3068: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
3069: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
3070: l_exists varchar2(1);
3071: l_last_standard_process_date
3072: per_periods_of_service.last_standard_process_date%TYPE;
3073: l_actual_termination_date

Line 3076: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

3072: per_periods_of_service.last_standard_process_date%TYPE;
3073: l_actual_termination_date
3074: per_periods_of_service.actual_termination_date%TYPE;
3075: l_legislation_code per_business_groups.legislation_code%TYPE;
3076: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
3077: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
3078: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
3079: l_proc varchar2(72)
3080: := g_package || 'actual_termination_emp_asg';

Line 3078: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

3074: per_periods_of_service.actual_termination_date%TYPE;
3075: l_legislation_code per_business_groups.legislation_code%TYPE;
3076: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
3077: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
3078: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
3079: l_proc varchar2(72)
3080: := g_package || 'actual_termination_emp_asg';
3081: --
3082: lv_object_version_number number := p_object_version_number ;

Line 3090: from per_all_assignments_f asg

3086: , asg.payroll_id
3087: , asg.primary_flag
3088: , bus.business_group_id
3089: , bus.legislation_code
3090: from per_all_assignments_f asg
3091: , per_business_groups_perf bus
3092: where asg.assignment_id = p_assignment_id
3093: and l_actual_termination_date between asg.effective_start_date
3094: and asg.effective_end_date

Line 3099: from per_all_assignments_f asg

3095: and bus.business_group_id+0 = asg.business_group_id;
3096: --
3097: cursor csr_invalid_term_assign is
3098: select null
3099: from per_all_assignments_f asg
3100: , per_assignment_status_types ast
3101: where asg.assignment_id = p_assignment_id
3102: and asg.effective_end_date >= l_actual_termination_date
3103: and ast.assignment_status_type_id = asg.assignment_status_type_id

Line 3620: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

3616: -- Declare cursors and local variables
3617: --
3618: -- Out variables
3619: --
3620: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3621: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
3622: := p_soft_coding_keyflex_id; -- bug 2359997
3623: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3624: := p_people_group_id; -- bug 2359997

Line 3621: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

3617: --
3618: -- Out variables
3619: --
3620: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3621: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
3622: := p_soft_coding_keyflex_id; -- bug 2359997
3623: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3624: := p_people_group_id; -- bug 2359997
3625: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

Line 3623: l_people_group_id per_all_assignments_f.people_group_id%TYPE

3619: --
3620: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3621: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
3622: := p_soft_coding_keyflex_id; -- bug 2359997
3623: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3624: := p_people_group_id; -- bug 2359997
3625: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3626: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3627: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

Line 3625: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

3621: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
3622: := p_soft_coding_keyflex_id; -- bug 2359997
3623: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3624: := p_people_group_id; -- bug 2359997
3625: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3626: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 3626: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

3622: := p_soft_coding_keyflex_id; -- bug 2359997
3623: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3624: := p_people_group_id; -- bug 2359997
3625: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3626: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 3627: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

3623: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3624: := p_people_group_id; -- bug 2359997
3625: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3626: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 3628: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

3624: := p_people_group_id; -- bug 2359997
3625: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3626: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 3629: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

3625: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3626: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 3630: l_comment_id per_all_assignments_f.comment_id%TYPE;

3626: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 3637: l_date_probation_end per_all_assignments_f.date_probation_end%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;
3637: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
3638: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3639: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3640: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3641: --

Line 3644: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

3640: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3641: --
3642: l_business_group_id per_business_groups.business_group_id%TYPE;
3643: l_legislation_code per_business_groups.legislation_code%TYPE;
3644: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
3645: l_proc varchar2(72);
3646: l_session_id number;
3647: l_cagr_grade_def_id number;
3648: l_cagr_concatenated_segments number;

Line 4055: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

4051: -- Declare cursors and local variables
4052: --
4053: -- Out variables
4054: --
4055: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4056: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
4057: := p_soft_coding_keyflex_id; -- bug 2359997 added initialization
4058: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4059: := p_people_group_id; -- bug 2359997 added initialization

Line 4056: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

4052: --
4053: -- Out variables
4054: --
4055: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4056: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
4057: := p_soft_coding_keyflex_id; -- bug 2359997 added initialization
4058: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4059: := p_people_group_id; -- bug 2359997 added initialization
4060: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

Line 4058: l_people_group_id per_all_assignments_f.people_group_id%TYPE

4054: --
4055: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4056: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
4057: := p_soft_coding_keyflex_id; -- bug 2359997 added initialization
4058: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4059: := p_people_group_id; -- bug 2359997 added initialization
4060: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
4061: := p_cagr_grade_def_id; -- bug 2359997, added this local variable
4062: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

Line 4062: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

4058: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4059: := p_people_group_id; -- bug 2359997 added initialization
4060: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
4061: := p_cagr_grade_def_id; -- bug 2359997, added this local variable
4062: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4063: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 4063: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

4059: := p_people_group_id; -- bug 2359997 added initialization
4060: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
4061: := p_cagr_grade_def_id; -- bug 2359997, added this local variable
4062: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4063: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 4064: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

4060: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
4061: := p_cagr_grade_def_id; -- bug 2359997, added this local variable
4062: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4063: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 4065: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

4061: := p_cagr_grade_def_id; -- bug 2359997, added this local variable
4062: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4063: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 4066: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

4062: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4063: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 4067: l_comment_id per_all_assignments_f.comment_id%TYPE;

4063: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 4074: l_date_probation_end per_all_assignments_f.date_probation_end%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;
4074: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4075: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4076: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4077: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4078: l_hourly_salaried_warning boolean;

Line 4491: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

4487: -- Declare cursors and local variables
4488: --
4489: -- Out variables
4490: --
4491: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4492: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
4493: := p_soft_coding_keyflex_id;
4494: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4495: := p_people_group_id;

Line 4492: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

4488: --
4489: -- Out variables
4490: --
4491: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4492: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
4493: := p_soft_coding_keyflex_id;
4494: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4495: := p_people_group_id;
4496: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

Line 4494: l_people_group_id per_all_assignments_f.people_group_id%TYPE

4490: --
4491: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4492: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
4493: := p_soft_coding_keyflex_id;
4494: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4495: := p_people_group_id;
4496: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4497: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4498: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

Line 4496: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

4492: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
4493: := p_soft_coding_keyflex_id;
4494: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4495: := p_people_group_id;
4496: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4497: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 4497: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

4493: := p_soft_coding_keyflex_id;
4494: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4495: := p_people_group_id;
4496: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4497: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 4498: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

4494: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4495: := p_people_group_id;
4496: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4497: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 4499: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

4495: := p_people_group_id;
4496: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4497: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 4500: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

4496: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4497: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 4501: l_comment_id per_all_assignments_f.comment_id%TYPE;

4497: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 4509: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

4505: l_old_group_name pay_people_groups.group_name%TYPE;
4506: l_other_manager_warning boolean;
4507: l_hourly_salaried_warning boolean;
4508: l_effective_date date;
4509: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4510: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4511: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4512: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4513: --

Line 4516: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

4512: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4513: --
4514: l_business_group_id per_business_groups.business_group_id%TYPE;
4515: l_legislation_code per_business_groups.legislation_code%TYPE;
4516: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
4517: l_proc varchar2(72) := g_package||
4518: 'create_secondary_emp_asg';
4519: l_session_id number;
4520: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

Line 4940: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

4936: -- Declare cursors and local variables
4937: --
4938: -- Out variables
4939: --
4940: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4941: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
4942: := p_soft_coding_keyflex_id;
4943: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4944: := p_people_group_id;

Line 4941: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

4937: --
4938: -- Out variables
4939: --
4940: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4941: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
4942: := p_soft_coding_keyflex_id;
4943: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4944: := p_people_group_id;
4945: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

Line 4943: l_people_group_id per_all_assignments_f.people_group_id%TYPE

4939: --
4940: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4941: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
4942: := p_soft_coding_keyflex_id;
4943: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4944: := p_people_group_id;
4945: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4946: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4947: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

Line 4945: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

4941: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
4942: := p_soft_coding_keyflex_id;
4943: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4944: := p_people_group_id;
4945: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4946: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 4946: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

4942: := p_soft_coding_keyflex_id;
4943: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4944: := p_people_group_id;
4945: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4946: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 4947: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

4943: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4944: := p_people_group_id;
4945: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4946: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 4948: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

4944: := p_people_group_id;
4945: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4946: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 4949: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

4945: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4946: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 4950: l_comment_id per_all_assignments_f.comment_id%TYPE;

4946: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
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;

Line 4958: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

4954: l_old_group_name pay_people_groups.group_name%TYPE;
4955: l_other_manager_warning boolean;
4956: l_hourly_salaried_warning boolean;
4957: l_effective_date date;
4958: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4959: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4960: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4961: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4962: --

Line 4965: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

4961: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4962: --
4963: l_business_group_id per_business_groups.business_group_id%TYPE;
4964: l_legislation_code per_business_groups.legislation_code%TYPE;
4965: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
4966: l_proc varchar2(72) := g_package||
4967: 'create_secondary_emp_asg';
4968: l_session_id number;
4969: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

Line 5085: from per_all_assignments_f asg

5081: and bus.business_group_id = per.business_group_id;
5082: --
5083: cursor csr_get_period_of_service is
5084: select asg.period_of_service_id
5085: from per_all_assignments_f asg
5086: where asg.person_id = p_person_id
5087: and l_effective_date between asg.effective_start_date
5088: and asg.effective_end_date
5089: and asg.primary_flag = 'Y'

Line 6468: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

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;
6471: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
6472: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

Line 6471: l_assignment_id per_all_assignments_f.assignment_id%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;
6471: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
6472: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
6473: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
6474: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
6475: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

Line 6472: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

6468: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
6469: l_other_manager_warning BOOLEAN;
6470: l_hourly_salaried_warning BOOLEAN;
6471: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
6472: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
6473: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
6474: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
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;

Line 6473: l_people_group_id per_all_assignments_f.people_group_id%TYPE;

6469: l_other_manager_warning BOOLEAN;
6470: l_hourly_salaried_warning BOOLEAN;
6471: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
6472: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
6473: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
6474: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
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;

Line 6474: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

6470: l_hourly_salaried_warning BOOLEAN;
6471: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
6472: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
6473: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
6474: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
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;

Line 6475: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

6471: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
6472: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
6473: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
6474: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
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;

Line 6476: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

6472: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
6473: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
6474: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
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;

Line 6477: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

6473: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
6474: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
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;

Line 6478: l_comment_id per_all_assignments_f.comment_id%TYPE;

6474: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
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;

Line 6485: --l_date_probation_end per_all_assignments_f.date_probation_end%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;
6484: l_pop_date_start DATE;
6485: --l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
6486: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
6487: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
6488: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
6489: l_vendor_id NUMBER := p_vendor_id;

Line 6512: from per_all_assignments_f asg

6508: and bus.business_group_id = per.business_group_id;
6509: --
6510: cursor csr_get_period_of_placement is
6511: select asg.period_of_placement_date_start
6512: from per_all_assignments_f asg
6513: where asg.person_id = p_person_id
6514: and l_effective_date between asg.effective_start_date
6515: and asg.effective_end_date
6516: and asg.primary_flag = 'Y'

Line 7738: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;

7734: --
7735: -- Declare cursors and local variables
7736: --
7737: -- Assigned the value p_assignment_number for fix of #2823013
7738: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
7739: l_effective_date date;
7740: l_legislation_code per_business_groups.legislation_code%TYPE;
7741: l_proc varchar2(72);
7742: --

Line 7745: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%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: --
7749: cursor csr_legislation is

Line 7751: from per_all_assignments_f paf,

7747: -- Declare cursors
7748: --
7749: cursor csr_legislation is
7750: select null
7751: from per_all_assignments_f paf,
7752: per_business_groups_perf pbg
7753: where paf.person_id = p_person_id
7754: and l_effective_date between paf.effective_start_date
7755: and paf.effective_end_date

Line 8047: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;

8043: --
8044: -- Declare cursors and local variables
8045: --
8046: -- Assigned the value p_assignment_number for fix of #2823013
8047: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
8048: l_effective_date date;
8049: l_legislation_code per_business_groups.legislation_code%TYPE;
8050: l_proc varchar2(72);
8051: --

Line 8054: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%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: --
8058: cursor csr_legislation is

Line 8060: from per_all_assignments_f paf,

8056: -- Declare cursors
8057: --
8058: cursor csr_legislation is
8059: select null
8060: from per_all_assignments_f paf,
8061: per_business_groups_perf pbg
8062: where paf.person_id = p_person_id
8063: and l_effective_date between paf.effective_start_date
8064: and paf.effective_end_date

Line 8371: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;

8367: --
8368: -- Declare variables
8369: --
8370: -- WWBUG 2539685
8371: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
8372: l_effective_date date;
8373: --
8374: l_business_group_id per_business_groups.business_group_id%TYPE;
8375: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 8382: from per_all_assignments_f paf,

8378: -- Declare cursors
8379: --
8380: cursor csr_legislation is
8381: select null
8382: from per_all_assignments_f paf,
8383: per_business_groups_perf pbg
8384: where paf.person_id = p_person_id
8385: and l_effective_date between paf.effective_start_date
8386: and paf.effective_end_date

Line 8704: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;

8700: --
8701: -- Declare variables
8702: --
8703: -- Assigned the value p_assignment_number for fix of #2823013
8704: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
8705: l_effective_date date;
8706: --
8707: l_business_group_id per_business_groups.business_group_id%TYPE;
8708: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 8715: from per_all_assignments_f paf,

8711: -- Declare cursors
8712: --
8713: cursor csr_legislation is
8714: select null
8715: from per_all_assignments_f paf,
8716: per_business_groups_perf pbg
8717: where paf.person_id = p_person_id
8718: and l_effective_date between paf.effective_start_date
8719: and paf.effective_end_date

Line 8917: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

8913: --
8914: -- Out variables
8915: --
8916: l_asg_future_changes_warning boolean := FALSE;
8917: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
8918: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
8919: l_entries_changed_warning varchar2(1) := 'N';
8920: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
8921: l_org_now_no_manager_warning boolean := FALSE;

Line 8918: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

8914: -- Out variables
8915: --
8916: l_asg_future_changes_warning boolean := FALSE;
8917: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
8918: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
8919: l_entries_changed_warning varchar2(1) := 'N';
8920: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
8921: l_org_now_no_manager_warning boolean := FALSE;
8922: --

Line 8920: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

8916: l_asg_future_changes_warning boolean := FALSE;
8917: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
8918: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
8919: l_entries_changed_warning varchar2(1) := 'N';
8920: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
8921: l_org_now_no_manager_warning boolean := FALSE;
8922: --
8923: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
8924: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

Line 8923: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

8919: l_entries_changed_warning varchar2(1) := 'N';
8920: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
8921: l_org_now_no_manager_warning boolean := FALSE;
8922: --
8923: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
8924: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
8925: l_proc varchar2(72)
8926: := g_package || 'final_process_emp_asg';
8927: l_actual_termination_date date;

Line 8924: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

8920: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
8921: l_org_now_no_manager_warning boolean := FALSE;
8922: --
8923: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
8924: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
8925: l_proc varchar2(72)
8926: := g_package || 'final_process_emp_asg';
8927: l_actual_termination_date date;
8928: l_final_process_date date;

Line 8936: from per_all_assignments_f asg

8932: --
8933: cursor csr_get_derived_details is
8934: select asg.assignment_type
8935: , asg.primary_flag
8936: from per_all_assignments_f asg
8937: where asg.assignment_id = p_assignment_id
8938: and l_final_process_date between asg.effective_start_date
8939: and asg.effective_end_date;
8940: --

Line 8943: from per_all_assignments_f asg

8939: and asg.effective_end_date;
8940: --
8941: cursor csr_valid_term_assign is
8942: select min(asg.effective_start_date) - 1
8943: from per_all_assignments_f asg
8944: where asg.assignment_id = p_assignment_id
8945: and exists ( select null
8946: from per_assignment_status_types ast
8947: where ast.assignment_status_type_id

Line 8954: from per_all_assignments_f asg

8950:
8951: --
8952: cursor csr_invalid_term_assign is
8953: select max(asg.effective_end_date)
8954: from per_all_assignments_f asg
8955: where asg.assignment_id = p_assignment_id
8956: and exists ( select null
8957: from per_assignment_status_types ast
8958: where ast.assignment_status_type_id

Line 9259: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

9255: l_effective_date date;
9256: --
9257: -- Out variables
9258: --
9259: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9260: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9261: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9262: --
9263: lv_object_version_number number := p_object_version_number ;

Line 9260: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

9256: --
9257: -- Out variables
9258: --
9259: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9260: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9261: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9262: --
9263: lv_object_version_number number := p_object_version_number ;
9264: --

Line 9261: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

9257: -- Out variables
9258: --
9259: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9260: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9261: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9262: --
9263: lv_object_version_number number := p_object_version_number ;
9264: --
9265: l_proc varchar2(72);

Line 9520: l_comment_id per_all_assignments_f.comment_id%TYPE;

9516: -- Declare cursors and local variables
9517: --
9518: -- Out variables
9519: --
9520: l_comment_id per_all_assignments_f.comment_id%TYPE;
9521: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9522: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9523: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9524: l_no_managers_warning boolean;

Line 9521: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

9517: --
9518: -- Out variables
9519: --
9520: l_comment_id per_all_assignments_f.comment_id%TYPE;
9521: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9522: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9523: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9524: l_no_managers_warning boolean;
9525: l_other_manager_warning boolean;

Line 9522: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

9518: -- Out variables
9519: --
9520: l_comment_id per_all_assignments_f.comment_id%TYPE;
9521: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9522: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9523: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
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

Line 9523: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

9519: --
9520: l_comment_id per_all_assignments_f.comment_id%TYPE;
9521: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9522: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9523: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
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

Line 9526: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

9522: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9523: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
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;

Line 9531: l_date_probation_end per_all_assignments_f.date_probation_end%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;
9534: l_location_id per_all_assignments_f.location_id%type;
9535: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE;

Line 9533: l_organization_id per_all_assignments_f.organization_id%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;
9534: l_location_id per_all_assignments_f.location_id%type;
9535: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE;
9536: l_cagr_concatenated_segments varchar2(2000);
9537: l_proc varchar2(72);

Line 9534: l_location_id per_all_assignments_f.location_id%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;
9534: l_location_id per_all_assignments_f.location_id%type;
9535: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE;
9536: l_cagr_concatenated_segments varchar2(2000);
9537: l_proc varchar2(72);
9538: --

Line 9842: l_comment_id per_all_assignments_f.comment_id%TYPE;

9838: -- Declare cursors and local variables
9839: --
9840: -- Out variables
9841: --
9842: l_comment_id per_all_assignments_f.comment_id%TYPE;
9843: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9844: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9845: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9846: l_no_managers_warning boolean;

Line 9843: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

9839: --
9840: -- Out variables
9841: --
9842: l_comment_id per_all_assignments_f.comment_id%TYPE;
9843: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9844: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9845: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9846: l_no_managers_warning boolean;
9847: l_other_manager_warning boolean;

Line 9844: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

9840: -- Out variables
9841: --
9842: l_comment_id per_all_assignments_f.comment_id%TYPE;
9843: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9844: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9845: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9846: l_no_managers_warning boolean;
9847: l_other_manager_warning boolean;
9848: l_hourly_salaried_warning boolean;

Line 9845: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

9841: --
9842: l_comment_id per_all_assignments_f.comment_id%TYPE;
9843: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9844: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9845: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9846: l_no_managers_warning boolean;
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

Line 9849: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

9845: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9846: l_no_managers_warning boolean;
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;

Line 9854: l_date_probation_end per_all_assignments_f.date_probation_end%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;
9857: l_location_id per_all_assignments_f.location_id%type;
9858: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

Line 9856: l_organization_id per_all_assignments_f.organization_id%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;
9857: l_location_id per_all_assignments_f.location_id%type;
9858: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
9859: := p_cagr_grade_def_id; -- bug 2359997
9860: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;

Line 9857: l_location_id per_all_assignments_f.location_id%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;
9857: l_location_id per_all_assignments_f.location_id%type;
9858: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
9859: := p_cagr_grade_def_id; -- bug 2359997
9860: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
9861: l_cagr_concatenated_segments varchar2(2000);

Line 10178: l_comment_id per_all_assignments_f.comment_id%TYPE;

10174: -- Declare cursors and local variables
10175: --
10176: -- Out variables
10177: --
10178: l_comment_id per_all_assignments_f.comment_id%TYPE;
10179: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
10180: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
10181: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
10182: l_no_managers_warning boolean;

Line 10179: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

10175: --
10176: -- Out variables
10177: --
10178: l_comment_id per_all_assignments_f.comment_id%TYPE;
10179: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
10180: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
10181: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
10182: l_no_managers_warning boolean;
10183: l_other_manager_warning boolean;

Line 10180: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

10176: -- Out variables
10177: --
10178: l_comment_id per_all_assignments_f.comment_id%TYPE;
10179: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
10180: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
10181: l_object_version_number per_all_assignments_f.object_version_number%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

Line 10181: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

10177: --
10178: l_comment_id per_all_assignments_f.comment_id%TYPE;
10179: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
10180: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
10181: l_object_version_number per_all_assignments_f.object_version_number%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

Line 10184: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

10180: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
10181: l_object_version_number per_all_assignments_f.object_version_number%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;

Line 10189: l_date_probation_end per_all_assignments_f.date_probation_end%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;
10192: l_location_id per_all_assignments_f.location_id%type;
10193: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

Line 10191: l_organization_id per_all_assignments_f.organization_id%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;
10192: l_location_id per_all_assignments_f.location_id%type;
10193: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
10194: := p_cagr_grade_def_id; -- bug 2359997
10195: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;

Line 10192: l_location_id per_all_assignments_f.location_id%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;
10192: l_location_id per_all_assignments_f.location_id%type;
10193: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
10194: := p_cagr_grade_def_id; -- bug 2359997
10195: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
10196: l_cagr_concatenated_segments varchar2(2000);

Line 10202: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

10198: l_gsp_post_process_warning varchar2(2000); -- bug 2999562
10199: --
10200: -- Internal working variables
10201: --
10202: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
10203: l_business_group_id per_business_groups.business_group_id%TYPE;
10204: l_payroll_id_updated boolean;
10205: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
10206: l_org_now_no_manager_warning boolean;

Line 10205: l_people_group_id per_all_assignments_f.people_group_id%TYPE;

10201: --
10202: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
10203: l_business_group_id per_business_groups.business_group_id%TYPE;
10204: l_payroll_id_updated boolean;
10205: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
10206: l_org_now_no_manager_warning boolean;
10207: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
10208: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
10209: l_proc varchar2(72) := g_package||'update_emp_asg';

Line 10207: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;

10203: l_business_group_id per_business_groups.business_group_id%TYPE;
10204: l_payroll_id_updated boolean;
10205: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
10206: l_org_now_no_manager_warning boolean;
10207: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
10208: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
10209: l_proc varchar2(72) := g_package||'update_emp_asg';
10210: l_session_id number;
10211: l_unused_start_date date;

Line 10208: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;

10204: l_payroll_id_updated boolean;
10205: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
10206: l_org_now_no_manager_warning boolean;
10207: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
10208: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
10209: l_proc varchar2(72) := g_package||'update_emp_asg';
10210: l_session_id number;
10211: l_unused_start_date date;
10212: l_unused_end_date date;

Line 10534: l_comment_id per_all_assignments_f.comment_id%TYPE;

10530: -- Declare cursors and local variables
10531: --
10532: -- Out variables
10533: --
10534: l_comment_id per_all_assignments_f.comment_id%TYPE;
10535: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
10536: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
10537: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
10538: l_no_managers_warning boolean;

Line 10535: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

10531: --
10532: -- Out variables
10533: --
10534: l_comment_id per_all_assignments_f.comment_id%TYPE;
10535: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
10536: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
10537: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
10538: l_no_managers_warning boolean;
10539: l_other_manager_warning boolean;

Line 10536: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

10532: -- Out variables
10533: --
10534: l_comment_id per_all_assignments_f.comment_id%TYPE;
10535: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
10536: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
10537: l_object_version_number per_all_assignments_f.object_version_number%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

Line 10537: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

10533: --
10534: l_comment_id per_all_assignments_f.comment_id%TYPE;
10535: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
10536: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
10537: l_object_version_number per_all_assignments_f.object_version_number%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

Line 10540: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

10536: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
10537: l_object_version_number per_all_assignments_f.object_version_number%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;

Line 10545: l_date_probation_end per_all_assignments_f.date_probation_end%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;
10548: l_location_id per_all_assignments_f.location_id%type;
10549: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

Line 10547: l_organization_id per_all_assignments_f.organization_id%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;
10548: l_location_id per_all_assignments_f.location_id%type;
10549: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
10550: := p_cagr_grade_def_id; -- bug 2359997
10551: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;

Line 10548: l_location_id per_all_assignments_f.location_id%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;
10548: l_location_id per_all_assignments_f.location_id%type;
10549: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
10550: := p_cagr_grade_def_id; -- bug 2359997
10551: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
10552: l_cagr_concatenated_segments varchar2(2000);

Line 10558: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

10554: l_gsp_post_process_warning varchar2(2000); -- bug 2999562
10555: --
10556: -- Internal working variables
10557: --
10558: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
10559: l_business_group_id per_business_groups.business_group_id%TYPE;
10560: l_payroll_id_updated boolean;
10561: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
10562: l_org_now_no_manager_warning boolean;

Line 10561: l_people_group_id per_all_assignments_f.people_group_id%TYPE;

10557: --
10558: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
10559: l_business_group_id per_business_groups.business_group_id%TYPE;
10560: l_payroll_id_updated boolean;
10561: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
10562: l_org_now_no_manager_warning boolean;
10563: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
10564: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
10565: l_proc varchar2(72) := g_package||'update_emp_asg';

Line 10563: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;

10559: l_business_group_id per_business_groups.business_group_id%TYPE;
10560: l_payroll_id_updated boolean;
10561: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
10562: l_org_now_no_manager_warning boolean;
10563: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
10564: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
10565: l_proc varchar2(72) := g_package||'update_emp_asg';
10566: l_session_id number;
10567: l_unused_start_date date;

Line 10564: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;

10560: l_payroll_id_updated boolean;
10561: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
10562: l_org_now_no_manager_warning boolean;
10563: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
10564: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
10565: l_proc varchar2(72) := g_package||'update_emp_asg';
10566: l_session_id number;
10567: l_unused_start_date date;
10568: l_unused_end_date date;

Line 10640: per_all_assignments_f asg

10636: l_projected_assignment_end date;--fix for bug 6595592.
10637: cursor csr_old_asg_status is
10638: select ast.per_system_status
10639: from per_assignment_status_types ast,
10640: per_all_assignments_f asg
10641: where ast.assignment_status_type_id = asg.assignment_status_type_id
10642: and asg.assignment_id = p_assignment_id
10643: and l_effective_date between asg.effective_start_date
10644: and asg.effective_end_date;

Line 10657: from per_all_assignments_f asg

10653: , asg.business_group_id
10654: -- , asg.soft_coding_keyflex_id -- bug 2359997
10655: , asg.organization_id
10656: , asg.location_id
10657: from per_all_assignments_f asg
10658: where asg.assignment_id = p_assignment_id
10659: and l_effective_date between asg.effective_start_date
10660: and asg.effective_end_date;
10661: --

Line 10665: from per_all_assignments_f asg

10661: --
10662: /* Added By Fs
10663: cursor csr_get_soft_coding_keyflex is -- bug 2359997
10664: select asg.soft_coding_keyflex_id
10665: from per_all_assignments_f asg
10666: where asg.assignment_id = p_assignment_id
10667: and l_effective_date between asg.effective_start_date
10668: and asg.effective_end_date;
10669: --

Line 11877: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

11873: --
11874: -- Out variables
11875: --
11876: l_org_now_no_manager_warning BOOLEAN;
11877: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
11878: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
11879: l_comment_id per_all_assignments_f.comment_id%TYPE;
11880: l_no_managers_warning BOOLEAN;
11881: l_other_manager_warning BOOLEAN;

Line 11878: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

11874: -- Out variables
11875: --
11876: l_org_now_no_manager_warning BOOLEAN;
11877: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
11878: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
11879: l_comment_id per_all_assignments_f.comment_id%TYPE;
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;

Line 11879: l_comment_id per_all_assignments_f.comment_id%TYPE;

11875: --
11876: l_org_now_no_manager_warning BOOLEAN;
11877: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
11878: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
11879: l_comment_id per_all_assignments_f.comment_id%TYPE;
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;

Line 11882: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

11878: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
11879: l_comment_id per_all_assignments_f.comment_id%TYPE;
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;

Line 11883: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

11879: l_comment_id per_all_assignments_f.comment_id%TYPE;
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;

Line 11896: l_organization_id per_all_assignments_f.organization_id%TYPE;

11892: --
11893: l_proc VARCHAR2(72) := g_package||'update_cwk_asg';
11894: l_effective_date DATE;
11895: l_projected_assignment_end DATE;
11896: l_organization_id per_all_assignments_f.organization_id%TYPE;
11897: l_business_group_id per_business_groups.business_group_id%TYPE;
11898: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
11899: l_location_id per_all_assignments_f.location_id%TYPE;
11900: l_old_asg_status per_assignment_status_types.per_system_status%TYPE;

Line 11898: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

11894: l_effective_date DATE;
11895: l_projected_assignment_end DATE;
11896: l_organization_id per_all_assignments_f.organization_id%TYPE;
11897: l_business_group_id per_business_groups.business_group_id%TYPE;
11898: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
11899: l_location_id per_all_assignments_f.location_id%TYPE;
11900: l_old_asg_status per_assignment_status_types.per_system_status%TYPE;
11901: l_new_asg_status per_assignment_status_types.per_system_status%TYPE;
11902: l_cagr_grade_def_id NUMBER;

Line 11899: l_location_id per_all_assignments_f.location_id%TYPE;

11895: l_projected_assignment_end DATE;
11896: l_organization_id per_all_assignments_f.organization_id%TYPE;
11897: l_business_group_id per_business_groups.business_group_id%TYPE;
11898: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
11899: l_location_id per_all_assignments_f.location_id%TYPE;
11900: l_old_asg_status per_assignment_status_types.per_system_status%TYPE;
11901: l_new_asg_status per_assignment_status_types.per_system_status%TYPE;
11902: l_cagr_grade_def_id NUMBER;
11903: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;

Line 11903: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;

11899: l_location_id per_all_assignments_f.location_id%TYPE;
11900: l_old_asg_status per_assignment_status_types.per_system_status%TYPE;
11901: l_new_asg_status per_assignment_status_types.per_system_status%TYPE;
11902: l_cagr_grade_def_id NUMBER;
11903: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
11904: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
11905: l_po_header_id NUMBER := p_po_header_id;
11906: l_vendor_id NUMBER := p_vendor_id;
11907: --

Line 11904: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;

11900: l_old_asg_status per_assignment_status_types.per_system_status%TYPE;
11901: l_new_asg_status per_assignment_status_types.per_system_status%TYPE;
11902: l_cagr_grade_def_id NUMBER;
11903: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
11904: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
11905: l_po_header_id NUMBER := p_po_header_id;
11906: l_vendor_id NUMBER := p_vendor_id;
11907: --
11908: /*

Line 11910: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

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;
11914: l_unused_end_date date;

Line 11911: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

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;
11914: l_unused_end_date date;
11915: */

Line 11912: l_people_group_id per_all_assignments_f.people_group_id%TYPE;

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;
11914: l_unused_end_date date;
11915: */
11916: --

Line 11922: per_all_assignments_f asg

11918: --
11919: cursor csr_old_asg_status is
11920: select ast.per_system_status
11921: from per_assignment_status_types ast,
11922: per_all_assignments_f asg
11923: where ast.assignment_status_type_id = asg.assignment_status_type_id
11924: and asg.assignment_id = p_assignment_id
11925: and l_effective_date between asg.effective_start_date and asg.effective_end_date;
11926: --

Line 11938: from per_all_assignments_f asg

11934: , asg.business_group_id
11935: , asg.soft_coding_keyflex_id
11936: , asg.organization_id
11937: , asg.location_id
11938: from per_all_assignments_f asg
11939: where asg.assignment_id = p_assignment_id
11940: and l_effective_date between asg.effective_start_date
11941: and asg.effective_end_date;
11942: --

Line 11974: per_all_assignments_f paf

11970: l_vendor_site_id_1 number default null;
11971:
11972: cursor po_cwk is
11973: select vendor_id,vendor_site_id from
11974: per_all_assignments_f paf
11975: where paf.assignment_id = p_assignment_id
11976: and nvl(l_effective_date,sysdate) between paf.effective_start_date
11977: and paf.effective_end_date;
11978: --end code for bug 6961562

Line 12834: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

12830: -- Declare cursors and local variables
12831: --
12832: -- Out variables
12833: --
12834: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
12835: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
12836: l_entries_changed_warning varchar2(1) := 'N';
12837: l_people_group_name pay_people_groups.group_name%TYPE;
12838: l_old_group_name pay_people_groups.group_name%TYPE;

Line 12835: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

12831: --
12832: -- Out variables
12833: --
12834: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
12835: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
12836: l_entries_changed_warning varchar2(1) := 'N';
12837: l_people_group_name pay_people_groups.group_name%TYPE;
12838: l_old_group_name pay_people_groups.group_name%TYPE;
12839: l_no_managers_warning boolean;

Line 12840: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

12836: l_entries_changed_warning varchar2(1) := 'N';
12837: l_people_group_name pay_people_groups.group_name%TYPE;
12838: l_old_group_name pay_people_groups.group_name%TYPE;
12839: l_no_managers_warning boolean;
12840: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
12841: l_org_now_no_manager_warning boolean;
12842: l_other_manager_warning boolean;
12843: l_hourly_salaried_warning boolean;
12844: l_payroll_id_updated boolean;

Line 12845: l_people_group_id per_all_assignments_f.people_group_id%TYPE;

12841: l_org_now_no_manager_warning boolean;
12842: l_other_manager_warning boolean;
12843: l_hourly_salaried_warning boolean;
12844: l_payroll_id_updated boolean;
12845: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
12846: l_spp_delete_warning boolean := false; -- Bug 3545065
12847: l_tax_district_changed_warning boolean;
12848: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
12849: --

Line 12851: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

12847: l_tax_district_changed_warning boolean;
12848: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
12849: --
12850: l_api_updating boolean;
12851: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
12852: l_comment_id per_all_assignments_f.comment_id%TYPE;
12853: l_entries_changed varchar2(1);
12854: l_legislation_code per_business_groups.legislation_code%TYPE;
12855: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;

Line 12852: l_comment_id per_all_assignments_f.comment_id%TYPE;

12848: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
12849: --
12850: l_api_updating boolean;
12851: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
12852: l_comment_id per_all_assignments_f.comment_id%TYPE;
12853: l_entries_changed varchar2(1);
12854: l_legislation_code per_business_groups.legislation_code%TYPE;
12855: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
12856: l_proc varchar2(72) :=

Line 12855: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;

12851: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
12852: l_comment_id per_all_assignments_f.comment_id%TYPE;
12853: l_entries_changed varchar2(1);
12854: l_legislation_code per_business_groups.legislation_code%TYPE;
12855: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
12856: l_proc varchar2(72) :=
12857: g_package || 'update_cwk_asg_criteria';
12858: l_validation_end_date date;
12859: l_validation_start_date date;

Line 12862: l_organization_id per_all_assignments_f.organization_id%type;

12858: l_validation_end_date date;
12859: l_validation_start_date date;
12860: l_effective_date date;
12861: l_element_entry_id number;
12862: l_organization_id per_all_assignments_f.organization_id%type;
12863: l_location_id per_all_assignments_f.location_id%type;
12864: l_session_id number;
12865: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
12866: --

Line 12863: l_location_id per_all_assignments_f.location_id%type;

12859: l_validation_start_date date;
12860: l_effective_date date;
12861: l_element_entry_id number;
12862: l_organization_id per_all_assignments_f.organization_id%type;
12863: l_location_id per_all_assignments_f.location_id%type;
12864: l_session_id number;
12865: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
12866: --
12867: lv_object_version_number number := p_object_version_number ;

Line 12865: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

12861: l_element_entry_id number;
12862: l_organization_id per_all_assignments_f.organization_id%type;
12863: l_location_id per_all_assignments_f.location_id%type;
12864: l_session_id number;
12865: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
12866: --
12867: lv_object_version_number number := p_object_version_number ;
12868: l_grade_id number := Null; -- Bug 3545065
12869: --

Line 12892: from per_all_assignments_f asg

12888: --
12889: cursor get_sec_date_range is
12890: select asg.effective_start_date
12891: , asg.effective_end_date
12892: from per_all_assignments_f asg
12893: where asg.assignment_id=p_assignment_id
12894: and ((sysdate between asg.effective_start_date
12895: and asg.effective_end_date)
12896: or

Line 12900: from per_all_assignments_f asg2

12896: or
12897: (sysdate 12898: and not exists
12899: (select 1
12900: from per_all_assignments_f asg2
12901: where asg2.person_id=asg.person_id
12902: and asg2.period_of_service_id=asg.period_of_service_id
12903: and asg2.effective_start_date 12904: )

Line 12909: from per_all_assignments_f asg

12905: );
12906: --
12907: cursor csr_get_assignment_type is
12908: select asg.assignment_type
12909: from per_all_assignments_f asg
12910: where asg.assignment_id = p_assignment_id
12911: and l_effective_date between asg.effective_start_date
12912: and asg.effective_end_date;
12913: --

Line 13741: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

13737: -- Declare cursors and local variables
13738: --
13739: l_proc varchar2(72);
13740: l_effective_date date;
13741: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
13742: l_concatenated_segments varchar2(2000);
13743: l_legislation_code per_business_groups.legislation_code%TYPE;
13744: l_cagr_concatenated_segments varchar2(300);
13745: l_cagr_grade_def_id number;

Line 13926: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

13922: -- Declare cursors and local variables
13923: --
13924: l_proc varchar2(72);
13925: l_effective_date date;
13926: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
13927: l_concatenated_segments varchar2(2000);
13928: l_legislation_code per_business_groups.legislation_code%TYPE;
13929: --
13930: cursor check_legislation

Line 13931: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,

13927: l_concatenated_segments varchar2(2000);
13928: l_legislation_code per_business_groups.legislation_code%TYPE;
13929: --
13930: cursor check_legislation
13931: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,
13932: c_effective_date date
13933: )
13934: is
13935: select bgp.legislation_code

Line 13936: from per_all_assignments_f asg,

13932: c_effective_date date
13933: )
13934: is
13935: select bgp.legislation_code
13936: from per_all_assignments_f asg,
13937: per_business_groups_perf bgp
13938: where asg.business_group_id = bgp.business_group_id
13939: and asg.assignment_id = c_assignment_id
13940: and c_effective_date

Line 14163: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

14159: -- Declare cursors and local variables
14160: --
14161: l_proc varchar2(72);
14162: l_effective_date date;
14163: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
14164: l_concatenated_segments varchar2(2000);
14165: l_legislation_code per_business_groups.legislation_code%TYPE;
14166: --
14167: cursor check_legislation

Line 14168: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,

14164: l_concatenated_segments varchar2(2000);
14165: l_legislation_code per_business_groups.legislation_code%TYPE;
14166: --
14167: cursor check_legislation
14168: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,
14169: c_effective_date date
14170: )
14171: is
14172: select bgp.legislation_code

Line 14173: from per_all_assignments_f asg,

14169: c_effective_date date
14170: )
14171: is
14172: select bgp.legislation_code
14173: from per_all_assignments_f asg,
14174: per_business_groups_perf bgp
14175: where asg.business_group_id = bgp.business_group_id
14176: and asg.assignment_id = c_assignment_id
14177: and c_effective_date

Line 14616: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,

14612: l_legislation_code per_business_groups.legislation_code%TYPE;
14613:
14614: --
14615: cursor check_legislation
14616: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,
14617: c_effective_date date
14618: )
14619: is
14620: select bgp.legislation_code

Line 14621: from per_all_assignments_f asg,

14617: c_effective_date date
14618: )
14619: is
14620: select bgp.legislation_code
14621: from per_all_assignments_f asg,
14622: per_business_groups_perf bgp
14623: where asg.business_group_id = bgp.business_group_id
14624: and asg.assignment_id = c_assignment_id
14625: and c_effective_date

Line 14882: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,

14878: l_gsp_post_process_warning varchar2(2000); -- bug 2999562
14879:
14880: --
14881: cursor check_legislation
14882: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,
14883: c_effective_date date
14884: )
14885: is
14886: select bgp.legislation_code

Line 14887: from per_all_assignments_f asg,

14883: c_effective_date date
14884: )
14885: is
14886: select bgp.legislation_code
14887: from per_all_assignments_f asg,
14888: per_business_groups_perf bgp
14889: where asg.business_group_id = bgp.business_group_id
14890: and asg.assignment_id = c_assignment_id
14891: and c_effective_date

Line 15150: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,

15146: l_legislation_code per_business_groups.legislation_code%TYPE;
15147:
15148: --
15149: cursor check_legislation
15150: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,
15151: c_effective_date date
15152: )
15153: is
15154: select bgp.legislation_code

Line 15155: from per_all_assignments_f asg,

15151: c_effective_date date
15152: )
15153: is
15154: select bgp.legislation_code
15155: from per_all_assignments_f asg,
15156: per_business_groups_perf bgp
15157: where asg.business_group_id = bgp.business_group_id
15158: and asg.assignment_id = c_assignment_id
15159: and c_effective_date

Line 15377: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

15373: -- Declare cursors and local variables
15374: --
15375: -- Out variables
15376: --
15377: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
15378: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
15379: l_entries_changed_warning varchar2(1) := 'N';
15380: l_group_name pay_people_groups.group_name%TYPE;
15381: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

Line 15378: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

15374: --
15375: -- Out variables
15376: --
15377: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
15378: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
15379: l_entries_changed_warning varchar2(1) := 'N';
15380: l_group_name pay_people_groups.group_name%TYPE;
15381: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
15382: l_org_now_no_manager_warning boolean;

Line 15381: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

15377: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
15378: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
15379: l_entries_changed_warning varchar2(1) := 'N';
15380: l_group_name pay_people_groups.group_name%TYPE;
15381: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
15382: l_org_now_no_manager_warning boolean;
15383: l_other_manager_warning boolean;
15384: l_people_group_id per_all_assignments_f.people_group_id%TYPE
15385: := p_people_group_id; -- bug 2359997

Line 15384: l_people_group_id per_all_assignments_f.people_group_id%TYPE

15380: l_group_name pay_people_groups.group_name%TYPE;
15381: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
15382: l_org_now_no_manager_warning boolean;
15383: l_other_manager_warning boolean;
15384: l_people_group_id per_all_assignments_f.people_group_id%TYPE
15385: := p_people_group_id; -- bug 2359997
15386: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE
15387: := p_special_ceiling_step_id; --3485599
15388: l_spp_delete_warning boolean;

Line 15386: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE

15382: l_org_now_no_manager_warning boolean;
15383: l_other_manager_warning boolean;
15384: l_people_group_id per_all_assignments_f.people_group_id%TYPE
15385: := p_people_group_id; -- bug 2359997
15386: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE
15387: := p_special_ceiling_step_id; --3485599
15388: l_spp_delete_warning boolean;
15389: l_tax_district_changed_warning boolean;
15390:

Line 15605: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

15601: -- Declare cursors and local variables
15602: --
15603: -- Out variables
15604: --
15605: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
15606: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
15607: l_entries_changed_warning varchar2(1) := 'N';
15608: l_group_name pay_people_groups.group_name%TYPE;
15609: l_old_group_name pay_people_groups.group_name%TYPE;

Line 15606: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

15602: --
15603: -- Out variables
15604: --
15605: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
15606: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
15607: l_entries_changed_warning varchar2(1) := 'N';
15608: l_group_name pay_people_groups.group_name%TYPE;
15609: l_old_group_name pay_people_groups.group_name%TYPE;
15610: l_no_managers_warning boolean;

Line 15611: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

15607: l_entries_changed_warning varchar2(1) := 'N';
15608: l_group_name pay_people_groups.group_name%TYPE;
15609: l_old_group_name pay_people_groups.group_name%TYPE;
15610: l_no_managers_warning boolean;
15611: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
15612: l_org_now_no_manager_warning boolean;
15613: l_other_manager_warning boolean;
15614: l_hourly_salaried_warning boolean;
15615: l_payroll_id_updated boolean;

Line 15616: l_people_group_id per_all_assignments_f.people_group_id%TYPE

15612: l_org_now_no_manager_warning boolean;
15613: l_other_manager_warning boolean;
15614: l_hourly_salaried_warning boolean;
15615: l_payroll_id_updated boolean;
15616: l_people_group_id per_all_assignments_f.people_group_id%TYPE
15617: := p_people_group_id; -- bug 2359997
15618: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE
15619: := p_special_ceiling_step_id; -- bug 3485599
15620: l_spp_delete_warning boolean;

Line 15618: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE

15614: l_hourly_salaried_warning boolean;
15615: l_payroll_id_updated boolean;
15616: l_people_group_id per_all_assignments_f.people_group_id%TYPE
15617: := p_people_group_id; -- bug 2359997
15618: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE
15619: := p_special_ceiling_step_id; -- bug 3485599
15620: l_spp_delete_warning boolean;
15621: l_tax_district_changed_warning boolean;
15622: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 15625: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

15621: l_tax_district_changed_warning boolean;
15622: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
15623: --
15624: l_api_updating boolean;
15625: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
15626: l_comment_id per_all_assignments_f.comment_id%TYPE;
15627: l_entries_changed varchar2(1);
15628: l_legislation_code per_business_groups.legislation_code%TYPE;
15629: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;

Line 15626: l_comment_id per_all_assignments_f.comment_id%TYPE;

15622: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
15623: --
15624: l_api_updating boolean;
15625: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
15626: l_comment_id per_all_assignments_f.comment_id%TYPE;
15627: l_entries_changed varchar2(1);
15628: l_legislation_code per_business_groups.legislation_code%TYPE;
15629: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
15630: l_proc varchar2(72) :=

Line 15629: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;

15625: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
15626: l_comment_id per_all_assignments_f.comment_id%TYPE;
15627: l_entries_changed varchar2(1);
15628: l_legislation_code per_business_groups.legislation_code%TYPE;
15629: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
15630: l_proc varchar2(72) :=
15631: g_package || 'update_emp_asg_criteria';
15632:
15633: -- Start of Fix for Bug 2622747

Line 15634: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;

15630: l_proc varchar2(72) :=
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:

Line 15820: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

15816: -- Declare cursors and local variables
15817: --
15818: -- Out variables
15819: --
15820: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
15821: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
15822: l_entries_changed_warning varchar2(1) := 'N';
15823: l_group_name pay_people_groups.group_name%TYPE;
15824: l_old_group_name pay_people_groups.group_name%TYPE;

Line 15821: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

15817: --
15818: -- Out variables
15819: --
15820: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
15821: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
15822: l_entries_changed_warning varchar2(1) := 'N';
15823: l_group_name pay_people_groups.group_name%TYPE;
15824: l_old_group_name pay_people_groups.group_name%TYPE;
15825: l_no_managers_warning boolean;

Line 15826: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

15822: l_entries_changed_warning varchar2(1) := 'N';
15823: l_group_name pay_people_groups.group_name%TYPE;
15824: l_old_group_name pay_people_groups.group_name%TYPE;
15825: l_no_managers_warning boolean;
15826: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
15827: l_org_now_no_manager_warning boolean;
15828: l_other_manager_warning boolean;
15829: l_hourly_salaried_warning boolean;
15830: l_payroll_id_updated boolean;

Line 15831: l_people_group_id per_all_assignments_f.people_group_id%TYPE

15827: l_org_now_no_manager_warning boolean;
15828: l_other_manager_warning boolean;
15829: l_hourly_salaried_warning boolean;
15830: l_payroll_id_updated boolean;
15831: l_people_group_id per_all_assignments_f.people_group_id%TYPE
15832: := p_people_group_id; -- bug 2359997
15833: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
15834: l_spp_delete_warning boolean;
15835: l_tax_district_changed_warning boolean;

Line 15833: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;

15829: l_hourly_salaried_warning boolean;
15830: l_payroll_id_updated boolean;
15831: l_people_group_id per_all_assignments_f.people_group_id%TYPE
15832: := p_people_group_id; -- bug 2359997
15833: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
15834: l_spp_delete_warning boolean;
15835: l_tax_district_changed_warning boolean;
15836: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
15837: l_gsp_post_process_warning varchar2(2000); -- bug2999562

Line 15840: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

15836: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
15837: l_gsp_post_process_warning varchar2(2000); -- bug2999562
15838: --
15839: l_api_updating boolean;
15840: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
15841: l_comment_id per_all_assignments_f.comment_id%TYPE;
15842: l_entries_changed varchar2(1);
15843: l_legislation_code per_business_groups.legislation_code%TYPE;
15844: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;

Line 15841: l_comment_id per_all_assignments_f.comment_id%TYPE;

15837: l_gsp_post_process_warning varchar2(2000); -- bug2999562
15838: --
15839: l_api_updating boolean;
15840: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
15841: l_comment_id per_all_assignments_f.comment_id%TYPE;
15842: l_entries_changed varchar2(1);
15843: l_legislation_code per_business_groups.legislation_code%TYPE;
15844: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
15845: l_proc varchar2(72) :=

Line 15844: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;

15840: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
15841: l_comment_id per_all_assignments_f.comment_id%TYPE;
15842: l_entries_changed varchar2(1);
15843: l_legislation_code per_business_groups.legislation_code%TYPE;
15844: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
15845: l_proc varchar2(72) :=
15846: g_package || 'update_emp_asg_criteria';
15847: l_validation_end_date date;
15848: l_validation_start_date date;

Line 15851: l_organization_id per_all_assignments_f.organization_id%type;

15847: l_validation_end_date date;
15848: l_validation_start_date date;
15849: l_effective_date date;
15850: l_element_entry_id number;
15851: l_organization_id per_all_assignments_f.organization_id%type;
15852: l_location_id per_all_assignments_f.location_id%type;
15853: l_session_id number;
15854: l_step_id per_spinal_point_steps_f.step_id%TYPE;
15855:

Line 15852: l_location_id per_all_assignments_f.location_id%type;

15848: l_validation_start_date date;
15849: l_effective_date date;
15850: l_element_entry_id number;
15851: l_organization_id per_all_assignments_f.organization_id%type;
15852: l_location_id per_all_assignments_f.location_id%type;
15853: l_session_id number;
15854: l_step_id per_spinal_point_steps_f.step_id%TYPE;
15855:
15856: -- Start of Fix for Bug 2622747

Line 15857: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;

15853: l_session_id number;
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:

Line 16014: from per_all_assignments_f asg

16010: --
16011: cursor get_sec_date_range is
16012: select asg.effective_start_date
16013: , asg.effective_end_date
16014: from per_all_assignments_f asg
16015: where asg.assignment_id=p_assignment_id
16016: and ((sysdate between asg.effective_start_date
16017: and asg.effective_end_date)
16018: or

Line 16022: from per_all_assignments_f asg2

16018: or
16019: (sysdate 16020: and not exists
16021: (select 1
16022: from per_all_assignments_f asg2
16023: where asg2.person_id=asg.person_id
16024: and asg2.period_of_service_id=asg.period_of_service_id
16025: and asg2.effective_start_date 16026: )

Line 16039: from per_all_assignments_f

16035: and sps.step_id = p_special_ceiling_step_id;
16036:
16037: cursor csr_get_people_group_id is
16038: select people_group_id
16039: from per_all_assignments_f
16040: where assignment_id = p_assignment_id
16041: and p_effective_date between effective_start_date and effective_end_date;
16042:
16043: --

Line 17540: l_comment_id per_all_assignments_f.comment_id%TYPE;

17536: -- Declare cursors and local variables
17537: --
17538: -- Out variables
17539: --
17540: l_comment_id per_all_assignments_f.comment_id%TYPE;
17541: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
17542: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
17543: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
17544: l_dummy_payroll boolean;

Line 17541: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

17537: --
17538: -- Out variables
17539: --
17540: l_comment_id per_all_assignments_f.comment_id%TYPE;
17541: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
17542: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
17543: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
17544: l_dummy_payroll boolean;
17545: l_dummy_manager1 boolean;

Line 17542: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

17538: -- Out variables
17539: --
17540: l_comment_id per_all_assignments_f.comment_id%TYPE;
17541: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
17542: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
17543: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
17544: l_dummy_payroll boolean;
17545: l_dummy_manager1 boolean;
17546: l_dummy_manager2 boolean;

Line 17543: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

17539: --
17540: l_comment_id per_all_assignments_f.comment_id%TYPE;
17541: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
17542: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
17543: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
17544: l_dummy_payroll boolean;
17545: l_dummy_manager1 boolean;
17546: l_dummy_manager2 boolean;
17547: l_dummy_manager3 boolean;

Line 17549: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;

17545: l_dummy_manager1 boolean;
17546: l_dummy_manager2 boolean;
17547: l_dummy_manager3 boolean;
17548: l_hourly_salaried_warning boolean;
17549: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
17550: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
17551: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
17552: l_effective_date date;
17553: l_date_probation_end date;

Line 17550: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;

17546: l_dummy_manager2 boolean;
17547: l_dummy_manager3 boolean;
17548: l_hourly_salaried_warning boolean;
17549: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
17550: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
17551: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
17552: l_effective_date date;
17553: l_date_probation_end date;
17554: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 17551: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

17547: l_dummy_manager3 boolean;
17548: l_hourly_salaried_warning boolean;
17549: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
17550: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
17551: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
17552: l_effective_date date;
17553: l_date_probation_end date;
17554: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
17555: l_organization_id per_all_assignments_f.organization_id%type;

Line 17555: l_organization_id per_all_assignments_f.organization_id%type;

17551: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
17552: l_effective_date date;
17553: l_date_probation_end date;
17554: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
17555: l_organization_id per_all_assignments_f.organization_id%type;
17556: l_location_id per_all_assignments_f.location_id%type;
17557: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
17558: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
17559: l_unused_start_date date;

Line 17556: l_location_id per_all_assignments_f.location_id%type;

17552: l_effective_date date;
17553: l_date_probation_end date;
17554: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
17555: l_organization_id per_all_assignments_f.organization_id%type;
17556: l_location_id per_all_assignments_f.location_id%type;
17557: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
17558: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
17559: l_unused_start_date date;
17560: l_unused_end_date date;

Line 17568: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;

17564: --
17565: l_assignment_status_id number;
17566: l_asg_status_ovn number;
17567: --
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 ;

Line 17571: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;

17567: --
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;

Line 17681: per_all_assignments_f asg

17677: --
17678: cursor csr_old_asg_status is
17679: select ast.per_system_status
17680: from per_assignment_status_types ast,
17681: per_all_assignments_f asg
17682: where ast.assignment_status_type_id = asg.assignment_status_type_id
17683: and asg.assignment_id = p_assignment_id
17684: and l_effective_date between asg.effective_start_date and asg.effective_end_date;
17685: --

Line 17722: from per_all_assignments_f asg

17718: --
17719: cursor get_sec_date_range is
17720: select asg.effective_start_date
17721: , asg.effective_end_date
17722: from per_all_assignments_f asg
17723: where asg.assignment_id=p_assignment_id
17724: and ((sysdate between asg.effective_start_date
17725: and asg.effective_end_date)
17726: or

Line 17730: from per_all_assignments_f asg2

17726: or
17727: (sysdate 17728: and not exists
17729: (select 1
17730: from per_all_assignments_f asg2
17731: where asg2.person_id=asg.person_id
17732: and asg2.application_id=asg.application_id
17733: and asg2.effective_start_date 17734: )

Line 17842: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

17838: from per_cagr_grades_def
17839: where cagr_grade_def_id = l_cagr_grade_def_id;
17840: --
17841: -- fix for bug 5938120 starts here.
17842: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
17843:
17844: cursor csr_get_assign(csr_person_id number) is
17845: select assignment_id
17846: from per_all_assignments_f

Line 17846: from per_all_assignments_f

17842: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
17843:
17844: cursor csr_get_assign(csr_person_id number) is
17845: select assignment_id
17846: from per_all_assignments_f
17847: where person_id=csr_person_id
17848: and business_group_id=l_business_group_id
17849: and l_effective_date between effective_start_date and effective_end_date
17850: and assignment_type not in ('B','O'); -- added for the bug 6925339

Line 19223: l_comment_id per_all_assignments_f.comment_id%TYPE;

19219: -- Declare cursors and local variables
19220: --
19221: -- Out variables
19222: --
19223: l_comment_id per_all_assignments_f.comment_id%TYPE;
19224: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
19225: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
19226: l_dummy_payroll boolean;
19227: l_dummy_manager1 boolean;

Line 19224: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

19220: --
19221: -- Out variables
19222: --
19223: l_comment_id per_all_assignments_f.comment_id%TYPE;
19224: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
19225: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
19226: l_dummy_payroll boolean;
19227: l_dummy_manager1 boolean;
19228: l_dummy_manager2 boolean;

Line 19225: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

19221: -- Out variables
19222: --
19223: l_comment_id per_all_assignments_f.comment_id%TYPE;
19224: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
19225: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
19226: l_dummy_payroll boolean;
19227: l_dummy_manager1 boolean;
19228: l_dummy_manager2 boolean;
19229: l_dummy_manager3 boolean;

Line 19230: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;

19226: l_dummy_payroll boolean;
19227: l_dummy_manager1 boolean;
19228: l_dummy_manager2 boolean;
19229: l_dummy_manager3 boolean;
19230: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
19231: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
19232: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
19233: l_effective_date date;
19234: l_date_probation_end date;

Line 19231: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;

19227: l_dummy_manager1 boolean;
19228: l_dummy_manager2 boolean;
19229: l_dummy_manager3 boolean;
19230: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
19231: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
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;

Line 19232: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

19228: l_dummy_manager2 boolean;
19229: l_dummy_manager3 boolean;
19230: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
19231: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
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;

Line 19249: l_people_group_id per_all_assignments_f.people_group_id%TYPE;

19245: --
19246: -- Internal working variables
19247: --
19248: l_business_group_id per_business_groups.business_group_id%TYPE;
19249: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
19250: l_group_name pay_people_groups.group_name%TYPE;
19251: l_proc varchar2(72);
19252: l_api_updating boolean;
19253: --

Line 19951: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

19947: -- Declare cursors and local variables
19948: --
19949: -- Out variables
19950: --
19951: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
19952: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;
19953: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
19954: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
19955: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

Line 19952: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;

19948: --
19949: -- Out variables
19950: --
19951: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
19952: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;
19953: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
19954: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
19955: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
19956: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

Line 19953: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

19949: -- Out variables
19950: --
19951: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
19952: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;
19953: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
19954: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
19955: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
19956: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
19957: l_comment_id per_all_assignments_f.comment_id%TYPE;

Line 19954: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

19950: --
19951: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
19952: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;
19953: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
19954: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
19955: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
19956: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
19957: l_comment_id per_all_assignments_f.comment_id%TYPE;
19958: l_group_name pay_people_groups.group_name%TYPE;

Line 19955: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

19951: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
19952: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;
19953: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
19954: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
19955: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
19956: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
19957: l_comment_id per_all_assignments_f.comment_id%TYPE;
19958: l_group_name pay_people_groups.group_name%TYPE;
19959: l_old_group_name pay_people_groups.group_name%TYPE;

Line 19956: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

19952: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;
19953: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
19954: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
19955: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
19956: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
19957: l_comment_id per_all_assignments_f.comment_id%TYPE;
19958: l_group_name pay_people_groups.group_name%TYPE;
19959: l_old_group_name pay_people_groups.group_name%TYPE;
19960: --

Line 19957: l_comment_id per_all_assignments_f.comment_id%TYPE;

19953: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
19954: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
19955: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
19956: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
19957: l_comment_id per_all_assignments_f.comment_id%TYPE;
19958: l_group_name pay_people_groups.group_name%TYPE;
19959: l_old_group_name pay_people_groups.group_name%TYPE;
19960: --
19961: l_application_id per_applications.application_id%TYPE;

Line 19964: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

19960: --
19961: l_application_id per_applications.application_id%TYPE;
19962: l_business_group_id per_business_groups.business_group_id%TYPE;
19963: l_legislation_code per_business_groups.legislation_code%TYPE;
19964: l_period_of_service_id per_all_assignments_f.period_of_service_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;

Line 19968: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;

19964: l_period_of_service_id per_all_assignments_f.period_of_service_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;

Line 20102: from per_all_assignments_f asg

20098: and nvl(apl.date_end,hr_api.g_eot);
20099: -- <<
20100: cursor csr_get_apl_asg is
20101: select asg.application_id
20102: from per_all_assignments_f asg
20103: where asg.person_id = p_person_id
20104: and l_effective_date between asg.effective_start_date
20105: and asg.effective_end_date
20106: and asg.assignment_type = 'A';

Line 20238: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;

20234: segment20
20235: from per_cagr_grades_def
20236: where cagr_grade_def_id = l_cagr_grade_def_id;
20237: --
20238: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;
20239: --
20240: begin
20241: --
20242: if g_debug then

Line 21667: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

21663: -- Declare cursors and local variables
21664: --
21665: -- Out variables
21666: --
21667: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
21668: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
21669: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
21670: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21671: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

Line 21668: l_people_group_id per_all_assignments_f.people_group_id%TYPE;

21664: --
21665: -- Out variables
21666: --
21667: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
21668: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
21669: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
21670: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21671: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
21672: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

Line 21669: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

21665: -- Out variables
21666: --
21667: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
21668: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
21669: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
21670: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21671: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
21672: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
21673: l_comment_id per_all_assignments_f.comment_id%TYPE;

Line 21670: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

21666: --
21667: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
21668: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
21669: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
21670: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21671: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
21672: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
21673: l_comment_id per_all_assignments_f.comment_id%TYPE;
21674: l_group_name pay_people_groups.group_name%TYPE;

Line 21671: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

21667: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
21668: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
21669: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
21670: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21671: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
21672: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
21673: l_comment_id per_all_assignments_f.comment_id%TYPE;
21674: l_group_name pay_people_groups.group_name%TYPE;
21675: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 21672: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

21668: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
21669: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
21670: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21671: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
21672: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
21673: l_comment_id per_all_assignments_f.comment_id%TYPE;
21674: l_group_name pay_people_groups.group_name%TYPE;
21675: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
21676: l_application_id per_applications.application_id%TYPE;

Line 21673: l_comment_id per_all_assignments_f.comment_id%TYPE;

21669: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
21670: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21671: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
21672: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
21673: l_comment_id per_all_assignments_f.comment_id%TYPE;
21674: l_group_name pay_people_groups.group_name%TYPE;
21675: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
21676: l_application_id per_applications.application_id%TYPE;
21677: l_business_group_id per_business_groups.business_group_id%TYPE;

Line 21679: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

21675: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
21676: l_application_id per_applications.application_id%TYPE;
21677: l_business_group_id per_business_groups.business_group_id%TYPE;
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;

Line 21681: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

21677: l_business_group_id per_business_groups.business_group_id%TYPE;
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);

Line 21842: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

21838: l_effective_date date;
21839: --
21840: -- Out variables
21841: --
21842: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
21843: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21844: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
21845: --
21846: lv_object_version_number number := p_object_version_number ;

Line 21843: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

21839: --
21840: -- Out variables
21841: --
21842: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
21843: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21844: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
21845: --
21846: lv_object_version_number number := p_object_version_number ;
21847: --

Line 21844: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

21840: -- Out variables
21841: --
21842: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
21843: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21844: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
21845: --
21846: lv_object_version_number number := p_object_version_number ;
21847: --
21848: l_proc varchar2(72);

Line 22007: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

22003: l_effective_date date;
22004: --
22005: -- Out variables
22006: --
22007: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
22008: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
22009: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
22010: --
22011: lv_object_version_number number := p_object_version_number ;

Line 22008: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

22004: --
22005: -- Out variables
22006: --
22007: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
22008: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
22009: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
22010: --
22011: lv_object_version_number number := p_object_version_number ;
22012: --

Line 22009: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

22005: -- Out variables
22006: --
22007: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
22008: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
22009: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
22010: --
22011: lv_object_version_number number := p_object_version_number ;
22012: --
22013: l_proc varchar2(72);

Line 22147: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

22143: PROCEDURE activate_apl_asg
22144: (p_validate IN BOOLEAN
22145: ,p_effective_date IN DATE
22146: ,p_datetrack_update_mode IN VARCHAR2
22147: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22148: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22149: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
22150: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
22151: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

Line 22148: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

22144: (p_validate IN BOOLEAN
22145: ,p_effective_date IN DATE
22146: ,p_datetrack_update_mode IN VARCHAR2
22147: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22148: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22149: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
22150: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
22151: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22152: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

Line 22150: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE

22146: ,p_datetrack_update_mode IN VARCHAR2
22147: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22148: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22149: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
22150: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
22151: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22152: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22153: )
22154: IS

Line 22151: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

22147: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22148: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22149: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
22150: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
22151: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22152: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22153: )
22154: IS
22155: --

Line 22152: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

22148: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22149: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
22150: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
22151: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22152: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22153: )
22154: IS
22155: --
22156: -- Local variables

Line 22162: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;

22158: l_proc VARCHAR2(72);
22159: --
22160: l_effective_date DATE;
22161: --
22162: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
22163: --
22164: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'ACTIVE_APL';
22165: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
22166: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

Line 22165: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

22161: --
22162: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
22163: --
22164: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'ACTIVE_APL';
22165: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
22166: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
22167: --
22168: lv_object_version_number number := p_object_version_number ;
22169: --

Line 22166: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

22162: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
22163: --
22164: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'ACTIVE_APL';
22165: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
22166: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
22167: --
22168: lv_object_version_number number := p_object_version_number ;
22169: --
22170: --

Line 22311: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

22307: --
22308: PROCEDURE terminate_apl_asg
22309: (p_validate IN BOOLEAN
22310: ,p_effective_date IN DATE
22311: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22312: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
22313: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22314: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22315: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

Line 22312: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

22308: PROCEDURE terminate_apl_asg
22309: (p_validate IN BOOLEAN
22310: ,p_effective_date IN DATE
22311: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22312: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
22313: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22314: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22315: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22316: )

Line 22313: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

22309: (p_validate IN BOOLEAN
22310: ,p_effective_date IN DATE
22311: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22312: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
22313: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22314: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22315: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22316: )
22317: IS

Line 22314: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

22310: ,p_effective_date IN DATE
22311: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22312: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
22313: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22314: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22315: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22316: )
22317: IS
22318: BEGIN

Line 22315: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

22311: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22312: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
22313: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22314: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22315: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22316: )
22317: IS
22318: BEGIN
22319: hr_assignment_api.terminate_apl_asg

Line 22338: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

22334: --
22335: PROCEDURE terminate_apl_asg
22336: (p_validate IN BOOLEAN
22337: ,p_effective_date IN DATE
22338: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22339: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
22340: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
22341: ,p_status_change_comments IN irc_assignment_statuses.status_change_comments%TYPE -- bug 8732296
22342: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

Line 22339: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

22335: PROCEDURE terminate_apl_asg
22336: (p_validate IN BOOLEAN
22337: ,p_effective_date IN DATE
22338: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22339: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
22340: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
22341: ,p_status_change_comments IN irc_assignment_statuses.status_change_comments%TYPE -- bug 8732296
22342: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22343: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

Line 22340: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579

22336: (p_validate IN BOOLEAN
22337: ,p_effective_date IN DATE
22338: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22339: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
22340: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
22341: ,p_status_change_comments IN irc_assignment_statuses.status_change_comments%TYPE -- bug 8732296
22342: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22343: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22344: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

Line 22342: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

22338: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22339: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
22340: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
22341: ,p_status_change_comments IN irc_assignment_statuses.status_change_comments%TYPE -- bug 8732296
22342: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22343: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22344: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22345: )
22346: IS

Line 22343: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

22339: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
22340: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
22341: ,p_status_change_comments IN irc_assignment_statuses.status_change_comments%TYPE -- bug 8732296
22342: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22343: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22344: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22345: )
22346: IS
22347: --

Line 22344: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

22340: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
22341: ,p_status_change_comments IN irc_assignment_statuses.status_change_comments%TYPE -- bug 8732296
22342: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22343: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22344: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22345: )
22346: IS
22347: --
22348: -- Local variables

Line 22354: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;

22350: l_proc VARCHAR2(72) := g_package||'terminate_apl_asg';
22351: --
22352: l_effective_date DATE;
22353: --
22354: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
22355: --
22356: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
22357: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
22358: --

Line 22356: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

22352: l_effective_date DATE;
22353: --
22354: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
22355: --
22356: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
22357: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
22358: --
22359: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;
22360: l_business_group_id hr_all_organization_units.organization_id%TYPE;

Line 22357: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

22353: --
22354: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
22355: --
22356: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
22357: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
22358: --
22359: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;
22360: l_business_group_id hr_all_organization_units.organization_id%TYPE;
22361: l_validation_start_date DATE;

Line 22359: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;

22355: --
22356: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
22357: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
22358: --
22359: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;
22360: l_business_group_id hr_all_organization_units.organization_id%TYPE;
22361: l_validation_start_date DATE;
22362: l_validation_end_date DATE;
22363: l_org_now_no_manager_warning BOOLEAN;

Line 22389: per_all_assignments_f.assignment_id%TYPE

22385: --
22386: -- fix for bug 7577823 starts
22387: CURSOR csr_applicant_userid
22388: (p_assignment_id IN
22389: per_all_assignments_f.assignment_id%TYPE
22390: ,p_effective_date IN DATE
22391: )
22392: IS
22393: select user_id

Line 22394: from per_all_assignments_f paf, fnd_user usr, per_all_people_f ppf,

22390: ,p_effective_date IN DATE
22391: )
22392: IS
22393: select user_id
22394: from per_all_assignments_f paf, fnd_user usr, per_all_people_f ppf,
22395: per_all_people_f linkppf
22396: where p_effective_date between paf.effective_start_date and
22397: paf.effective_end_date
22398: and p_effective_date between usr.start_date and

Line 22412: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

22408: and usr.user_id = fnd_global.user_id;
22409: -- fix for bug 7577823 ends
22410:
22411: CURSOR csr_assignments
22412: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22413: ,p_effective_date IN DATE
22414: )
22415: IS
22416: SELECT asg.assignment_type

Line 22422: FROM per_all_assignments_f asg

22418: ,bus.legislation_code
22419: ,person_id ,effective_end_date, application_id
22420: ,asg.assignment_status_type_id --7229710
22421: ,asg.effective_start_date -- Added for bug 9875744
22422: FROM per_all_assignments_f asg
22423: ,per_business_groups_perf bus
22424: WHERE asg.assignment_id = p_assignment_id
22425: AND bus.business_group_id = asg.business_group_id
22426: AND p_effective_date BETWEEN asg.effective_start_date

Line 22432: FROM per_all_assignments_f as2

22428: -- 3652025 >>
22429: CURSOR csr_get_current_apl_asg(cp_asg_id number, cp_effective_date date) IS
22430: SELECT as2.assignment_id, as2.effective_start_date
22431: ,as2.effective_end_date
22432: FROM per_all_assignments_f as2
22433: ,per_all_assignments_f as1
22434: WHERE as2.person_id = as1.person_id
22435: AND as2.assignment_type = as1.assignment_type
22436: AND cp_effective_date BETWEEN as2.effective_start_date

Line 22433: ,per_all_assignments_f as1

22429: CURSOR csr_get_current_apl_asg(cp_asg_id number, cp_effective_date date) IS
22430: SELECT as2.assignment_id, as2.effective_start_date
22431: ,as2.effective_end_date
22432: FROM per_all_assignments_f as2
22433: ,per_all_assignments_f as1
22434: WHERE as2.person_id = as1.person_id
22435: AND as2.assignment_type = as1.assignment_type
22436: AND cp_effective_date BETWEEN as2.effective_start_date
22437: AND as2.effective_end_date

Line 22445: FROM per_all_assignments_f as2

22441: CURSOR csr_get_future_apl_asg(cp_asg_id number, cp_effective_date date) IS
22442: SELECT as2.assignment_id, as2.business_group_id
22443: , as2.effective_start_date, as2.effective_end_date
22444: , as2.application_id, as2.person_id, as2.object_version_number
22445: FROM per_all_assignments_f as2
22446: ,per_all_assignments_f as1
22447: WHERE as2.person_id = as1.person_id
22448: AND as2.assignment_type = as1.assignment_type
22449: AND as2.effective_start_date > cp_effective_date

Line 22446: ,per_all_assignments_f as1

22442: SELECT as2.assignment_id, as2.business_group_id
22443: , as2.effective_start_date, as2.effective_end_date
22444: , as2.application_id, as2.person_id, as2.object_version_number
22445: FROM per_all_assignments_f as2
22446: ,per_all_assignments_f as1
22447: WHERE as2.person_id = as1.person_id
22448: AND as2.assignment_type = as1.assignment_type
22449: AND as2.effective_start_date > cp_effective_date
22450: AND as2.assignment_id <> as1.assignment_id

Line 22462: from per_all_assignments_f paaf

22458:
22459: -- Start changes for bug 9875744
22460: CURSOR chk_ae_assignment(lp_application_id number, lp_person_id number, lp_effective_start_date date) is
22461: select assignment_id
22462: from per_all_assignments_f paaf
22463: where paaf.person_id = lp_person_id
22464: and paaf.assignment_type = 'A'
22465: and lp_effective_start_date between paaf.effective_start_date and paaf.effective_end_date
22466: and paaf.assignment_id <> p_assignment_id

Line 22470: from per_all_assignments_f paaf1

22466: and paaf.assignment_id <> p_assignment_id
22467: and paaf.application_id = lp_application_id
22468: and exists
22469: ( select 1
22470: from per_all_assignments_f paaf1
22471: where paaf1.person_id = paaf.person_id
22472: and paaf1.assignment_id = paaf.assignment_id
22473: and paaf1.assignment_type = 'E' );
22474:

Line 22487: l_emp_min_start_date per_all_assignments_f.effective_start_date%type;

22483: where apa.application_id = cp_appl_id
22484: and apa.date_end is not null
22485: and apa.date_end >= apl.effective_end_date));
22486:
22487: l_emp_min_start_date per_all_assignments_f.effective_start_date%type;
22488: l_apl_min_start_date per_all_assignments_f.effective_start_date%type;
22489: l_ae_assignment_id per_all_assignments_f.assignment_id%type;
22490: l_person_type_id per_all_people_f.person_type_id%type;
22491: l_exists varchar2(10);

Line 22488: l_apl_min_start_date per_all_assignments_f.effective_start_date%type;

22484: and apa.date_end is not null
22485: and apa.date_end >= apl.effective_end_date));
22486:
22487: l_emp_min_start_date per_all_assignments_f.effective_start_date%type;
22488: l_apl_min_start_date per_all_assignments_f.effective_start_date%type;
22489: l_ae_assignment_id per_all_assignments_f.assignment_id%type;
22490: l_person_type_id per_all_people_f.person_type_id%type;
22491: l_exists varchar2(10);
22492: -- Start changes for bug 9875744

Line 22489: l_ae_assignment_id per_all_assignments_f.assignment_id%type;

22485: and apa.date_end >= apl.effective_end_date));
22486:
22487: l_emp_min_start_date per_all_assignments_f.effective_start_date%type;
22488: l_apl_min_start_date per_all_assignments_f.effective_start_date%type;
22489: l_ae_assignment_id per_all_assignments_f.assignment_id%type;
22490: l_person_type_id per_all_people_f.person_type_id%type;
22491: l_exists varchar2(10);
22492: -- Start changes for bug 9875744
22493:

Line 22514: From per_all_assignments_f

22510: l_person_id number;
22511:
22512: Cursor csr_vacancy_id(l_assg_id number) is
22513: Select vacancy_id
22514: From per_all_assignments_f
22515: Where assignment_id = l_assg_id
22516: And p_effective_date between effective_start_date and effective_end_date;
22517:
22518: cursor csr_person_id(l_assg_id number) is

Line 22520: from per_all_assignments_f

22516: And p_effective_date between effective_start_date and effective_end_date;
22517:
22518: cursor csr_person_id(l_assg_id number) is
22519: select person_id
22520: from per_all_assignments_f
22521: where assignment_id=l_assg_id;
22522: --fix for bug 7229710 Ends here.
22523:
22524: begin

Line 22912: from per_all_assignments_f

22908: close chk_ae_assignment;
22909:
22910: if l_ae_assignment_id is not null then
22911: select min(effective_start_date) into l_apl_min_start_date
22912: from per_all_assignments_f
22913: where assignment_id = l_ae_assignment_id;
22914:
22915: select min(effective_start_date) into l_emp_min_start_date
22916: from per_all_assignments_f

Line 22916: from per_all_assignments_f

22912: from per_all_assignments_f
22913: where assignment_id = l_ae_assignment_id;
22914:
22915: select min(effective_start_date) into l_emp_min_start_date
22916: from per_all_assignments_f
22917: where assignment_id = l_ae_assignment_id
22918: and assignment_type = 'E';
22919:
22920: hr_utility.set_location('l_ae_assignment_id:'||l_ae_assignment_id,68);

Line 23251: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

23247: PROCEDURE set_new_primary_asg
23248: (p_validate IN BOOLEAN
23249: ,p_effective_date IN DATE
23250: ,p_person_id IN per_all_people_f.person_id%TYPE
23251: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23252: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23253: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23254: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
23255: )

Line 23252: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

23248: (p_validate IN BOOLEAN
23249: ,p_effective_date IN DATE
23250: ,p_person_id IN per_all_people_f.person_id%TYPE
23251: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23252: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23253: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23254: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
23255: )
23256: IS

Line 23253: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

23249: ,p_effective_date IN DATE
23250: ,p_person_id IN per_all_people_f.person_id%TYPE
23251: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23252: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23253: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23254: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
23255: )
23256: IS
23257: --

Line 23254: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

23250: ,p_person_id IN per_all_people_f.person_id%TYPE
23251: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23252: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23253: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23254: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
23255: )
23256: IS
23257: --
23258: -- Local Variables

Line 23263: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;

23259: --
23260: l_proc VARCHAR2(72) := g_package||'set_new_primary_asg';
23261: --
23262: l_effective_date DATE;
23263: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
23264: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
23265: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
23266: --
23267: lv_object_version_number number := p_object_version_number ;

Line 23264: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

23260: l_proc VARCHAR2(72) := g_package||'set_new_primary_asg';
23261: --
23262: l_effective_date DATE;
23263: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
23264: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
23265: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
23266: --
23267: lv_object_version_number number := p_object_version_number ;
23268: --

Line 23265: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

23261: --
23262: l_effective_date DATE;
23263: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
23264: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
23265: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
23266: --
23267: lv_object_version_number number := p_object_version_number ;
23268: --
23269: -- Local cursors

Line 23272: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

23268: --
23269: -- Local cursors
23270: --
23271: CURSOR csr_new_assignment
23272: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23273: ,p_effective_date IN DATE
23274: )
23275: IS
23276: SELECT asg.object_version_number

Line 23285: FROM per_all_assignments_f asg

23281: ,asg.effective_start_date
23282: ,asg.effective_end_date
23283: ,MAX(mxa.effective_end_date) AS max_effective_end_date
23284: ,pds.actual_termination_date
23285: FROM per_all_assignments_f asg
23286: ,per_all_assignments_f mxa
23287: ,per_periods_of_service pds
23288: WHERE pds.period_of_service_id(+) = asg.period_of_service_id
23289: AND mxa.assignment_id = asg.assignment_id

Line 23286: ,per_all_assignments_f mxa

23282: ,asg.effective_end_date
23283: ,MAX(mxa.effective_end_date) AS max_effective_end_date
23284: ,pds.actual_termination_date
23285: FROM per_all_assignments_f asg
23286: ,per_all_assignments_f mxa
23287: ,per_periods_of_service pds
23288: WHERE pds.period_of_service_id(+) = asg.period_of_service_id
23289: AND mxa.assignment_id = asg.assignment_id
23290: AND asg.assignment_id = csr_new_assignment.p_assignment_id

Line 23315: FROM per_all_assignments_f asg

23311: ,asg.primary_flag
23312: ,asg.person_id
23313: ,asg.effective_start_date
23314: ,asg.effective_end_date
23315: FROM per_all_assignments_f asg
23316: WHERE asg.person_id = csr_old_assignment.p_person_id
23317: AND csr_old_assignment.p_effective_date BETWEEN asg.effective_start_date
23318: AND asg.effective_end_date
23319: AND asg.primary_flag = 'Y'

Line 23594: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

23590: PROCEDURE set_new_primary_cwk_asg
23591: (p_validate IN BOOLEAN
23592: ,p_effective_date IN DATE
23593: ,p_person_id IN per_all_people_f.person_id%TYPE
23594: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23595: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23596: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23597: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
23598: )

Line 23595: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

23591: (p_validate IN BOOLEAN
23592: ,p_effective_date IN DATE
23593: ,p_person_id IN per_all_people_f.person_id%TYPE
23594: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23595: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23596: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23597: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
23598: )
23599: IS

Line 23596: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

23592: ,p_effective_date IN DATE
23593: ,p_person_id IN per_all_people_f.person_id%TYPE
23594: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23595: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23596: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23597: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
23598: )
23599: IS
23600: --

Line 23597: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

23593: ,p_person_id IN per_all_people_f.person_id%TYPE
23594: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23595: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23596: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23597: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
23598: )
23599: IS
23600: --
23601: -- Local Variables

Line 23606: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;

23602: --
23603: l_proc VARCHAR2(72) := g_package||'set_new_primary_cwk_asg';
23604: --
23605: l_effective_date DATE;
23606: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
23607: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
23608: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
23609: --
23610: lv_object_version_number number := p_object_version_number ;

Line 23607: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

23603: l_proc VARCHAR2(72) := g_package||'set_new_primary_cwk_asg';
23604: --
23605: l_effective_date DATE;
23606: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
23607: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
23608: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
23609: --
23610: lv_object_version_number number := p_object_version_number ;
23611: --

Line 23608: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

23604: --
23605: l_effective_date DATE;
23606: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
23607: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
23608: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
23609: --
23610: lv_object_version_number number := p_object_version_number ;
23611: --
23612: -- Local cursors

Line 23615: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

23611: --
23612: -- Local cursors
23613: --
23614: CURSOR csr_new_assignment
23615: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23616: ,p_effective_date IN DATE) IS
23617: SELECT asg.object_version_number
23618: ,asg.assignment_type
23619: ,asg.period_of_placement_date_start

Line 23626: FROM per_all_assignments_f asg

23622: ,asg.effective_start_date
23623: ,asg.effective_end_date
23624: ,MAX(mxa.effective_end_date) AS max_effective_end_date
23625: ,pop.actual_termination_date
23626: FROM per_all_assignments_f asg
23627: ,per_all_assignments_f mxa
23628: ,per_periods_of_placement pop
23629: WHERE pop.person_id (+) = asg.person_id
23630: AND pop.date_start (+) = asg.period_of_placement_date_start

Line 23627: ,per_all_assignments_f mxa

23623: ,asg.effective_end_date
23624: ,MAX(mxa.effective_end_date) AS max_effective_end_date
23625: ,pop.actual_termination_date
23626: FROM per_all_assignments_f asg
23627: ,per_all_assignments_f mxa
23628: ,per_periods_of_placement pop
23629: WHERE pop.person_id (+) = asg.person_id
23630: AND pop.date_start (+) = asg.period_of_placement_date_start
23631: AND mxa.assignment_id = asg.assignment_id

Line 23654: FROM per_all_assignments_f asg

23650: ,asg.primary_flag
23651: ,asg.person_id
23652: ,asg.effective_start_date
23653: ,asg.effective_end_date
23654: FROM per_all_assignments_f asg
23655: WHERE asg.person_id = csr_old_assignment.p_person_id
23656: AND csr_old_assignment.p_effective_date BETWEEN asg.effective_start_date
23657: AND asg.effective_end_date
23658: AND asg.primary_flag = 'Y'

Line 23950: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

23946: PROCEDURE interview1_apl_asg
23947: (p_validate IN BOOLEAN
23948: ,p_effective_date IN DATE
23949: ,p_datetrack_update_mode IN VARCHAR2
23950: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23951: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23952: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
23953: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
23954: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

Line 23951: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

23947: (p_validate IN BOOLEAN
23948: ,p_effective_date IN DATE
23949: ,p_datetrack_update_mode IN VARCHAR2
23950: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23951: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23952: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
23953: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
23954: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23955: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

Line 23953: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE

23949: ,p_datetrack_update_mode IN VARCHAR2
23950: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23951: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23952: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
23953: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
23954: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23955: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
23956: )
23957: IS

Line 23954: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

23950: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23951: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23952: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
23953: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
23954: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23955: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
23956: )
23957: IS
23958: --

Line 23955: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

23951: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23952: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
23953: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
23954: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23955: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
23956: )
23957: IS
23958: --
23959: -- Local variables

Line 23965: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;

23961: l_proc VARCHAR2(72);
23962: --
23963: l_effective_date DATE;
23964: --
23965: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
23966: --
23967: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'INTERVIEW1';
23968: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
23969: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

Line 23968: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

23964: --
23965: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
23966: --
23967: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'INTERVIEW1';
23968: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
23969: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
23970: --
23971: lv_object_version_number number := p_object_version_number ;
23972: --

Line 23969: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

23965: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
23966: --
23967: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'INTERVIEW1';
23968: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
23969: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
23970: --
23971: lv_object_version_number number := p_object_version_number ;
23972: --
23973: BEGIN

Line 24114: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

24110: PROCEDURE interview2_apl_asg
24111: (p_validate IN BOOLEAN
24112: ,p_effective_date IN DATE
24113: ,p_datetrack_update_mode IN VARCHAR2
24114: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
24115: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
24116: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
24117: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
24118: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

Line 24115: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

24111: (p_validate IN BOOLEAN
24112: ,p_effective_date IN DATE
24113: ,p_datetrack_update_mode IN VARCHAR2
24114: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
24115: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
24116: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
24117: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
24118: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
24119: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

Line 24117: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE

24113: ,p_datetrack_update_mode IN VARCHAR2
24114: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
24115: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
24116: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
24117: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
24118: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
24119: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
24120: )
24121: IS

Line 24118: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

24114: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
24115: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
24116: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
24117: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
24118: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
24119: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
24120: )
24121: IS
24122: --

Line 24119: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

24115: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
24116: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
24117: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
24118: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
24119: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
24120: )
24121: IS
24122: --
24123: -- Local variables

Line 24129: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;

24125: l_proc VARCHAR2(72);
24126: --
24127: l_effective_date DATE;
24128: --
24129: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
24130: --
24131: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'INTERVIEW2';
24132: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
24133: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

Line 24132: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

24128: --
24129: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
24130: --
24131: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'INTERVIEW2';
24132: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
24133: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
24134: --
24135: lv_object_version_number number := p_object_version_number ;
24136: --

Line 24133: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

24129: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
24130: --
24131: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'INTERVIEW2';
24132: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
24133: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
24134: --
24135: lv_object_version_number number := p_object_version_number ;
24136: --
24137: BEGIN

Line 24279: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

24275: PROCEDURE delete_assignment
24276: (p_validate IN boolean default false
24277: ,p_effective_date IN DATE
24278: ,p_datetrack_mode IN VARCHAR2
24279: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
24280: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
24281: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
24282: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
24283: ,p_loc_change_tax_issues OUT NOCOPY boolean

Line 24280: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

24276: (p_validate IN boolean default false
24277: ,p_effective_date IN DATE
24278: ,p_datetrack_mode IN VARCHAR2
24279: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
24280: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
24281: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
24282: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
24283: ,p_loc_change_tax_issues OUT NOCOPY boolean
24284: ,p_delete_asg_budgets OUT NOCOPY boolean

Line 24281: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

24277: ,p_effective_date IN DATE
24278: ,p_datetrack_mode IN VARCHAR2
24279: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
24280: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
24281: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
24282: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
24283: ,p_loc_change_tax_issues OUT NOCOPY boolean
24284: ,p_delete_asg_budgets OUT NOCOPY boolean
24285: ,p_org_now_no_manager_warning OUT NOCOPY boolean

Line 24282: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

24278: ,p_datetrack_mode IN VARCHAR2
24279: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
24280: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
24281: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
24282: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
24283: ,p_loc_change_tax_issues OUT NOCOPY boolean
24284: ,p_delete_asg_budgets OUT NOCOPY boolean
24285: ,p_org_now_no_manager_warning OUT NOCOPY boolean
24286: ,p_element_salary_warning OUT NOCOPY boolean

Line 24302: from per_all_assignments_f

24298: asg_type varchar2(10);
24299: --
24300: cursor get_asgt_type is
24301: select assignment_type
24302: from per_all_assignments_f
24303: where assignment_id = p_assignment_id
24304: and p_effective_date between effective_start_date and effective_end_date;
24305: --
24306: BEGIN