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 177: -- data must exists in the table per_all_assignments_f for an Person

173: -- This procedure is used to reverse the termination of an applicant at
174: -- application level.
175: --
176: -- Prerequisites:
177: -- data must exists in the table per_all_assignments_f for an Person
178: --
179: -- In Parameters:
180: -- Name Reqd Type Description
181: -- p_effective_date yes Effective date

Line 228: from per_all_assignments_f

224: select date_end ,date_received, application_id
225: from per_applications papp
226: where application_id =
227: ( select distinct (application_id)
228: from per_all_assignments_f
229: where assignment_id = p_assignment_id and
230: business_group_id = p_business_group_id )
231: for update nowait;
232:

Line 235: from per_all_assignments_f a

231: for update nowait;
232:
233: cursor c2 is
234: select 1
235: from per_all_assignments_f a
236: where assignment_id = p_assignment_id
237: and exists
238: (select null
239: from per_assignment_status_types b

Line 294: from per_all_assignments_f

290: hr_utility.set_location('REVERSE_TERM_APLN - l_date_end:'|| l_date_end, 10);
291:
292:
293: select effective_start_date, effective_end_date,object_version_number into l_asg_start_date,l_asg_end_date,l_ovn
294: from per_all_assignments_f
295: where assignment_id = p_assignment_id
296: and effective_end_date = (select max(effective_end_date)
297: from per_all_assignments_f
298: where assignment_id = p_assignment_id );

Line 297: from per_all_assignments_f

293: select effective_start_date, effective_end_date,object_version_number into l_asg_start_date,l_asg_end_date,l_ovn
294: from per_all_assignments_f
295: where assignment_id = p_assignment_id
296: and effective_end_date = (select max(effective_end_date)
297: from per_all_assignments_f
298: where assignment_id = p_assignment_id );
299:
300: hr_utility.set_location('REVERSE_TERM_APLN - l_asg_end_date:'|| l_asg_end_date, 20);
301:

Line 303: from per_all_assignments_f

299:
300: hr_utility.set_location('REVERSE_TERM_APLN - l_asg_end_date:'|| l_asg_end_date, 20);
301:
302: select assignment_status_type_id into l_assignment_status_id
303: from per_all_assignments_f
304: where assignment_id = p_assignment_id
305: and effective_end_date = l_asg_end_date ;
306:
307: hr_utility.set_location('REVERSE_TERM_APLN - l_assignment_status_id:'|| l_assignment_status_id, 30);

Line 362: update per_all_assignments_f

358:
359:
360: hr_utility.set_location('Entering:'|| l_proc, 70);
361:
362: update per_all_assignments_f
363: set effective_end_date = l_eot
364: where assignment_id = p_assignment_id
365: and person_id=p_person_id
366: and business_group_id= p_business_group_id

Line 483: update per_all_assignments_f

479: p_validation_start_date =>l_validation_start_date,
480: p_validation_end_date => l_validation_end_date);
481:
482:
483: update per_all_assignments_f
484: set effective_end_date = l_eot
485: where assignment_id = p_assignment_id
486: and person_id=p_person_id
487: and business_group_id= p_business_group_id

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

712: -- Local Variables
713: --
714: --
715: l_proc VARCHAR2(72) := g_package||'validate_scl';
716: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
717: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
718: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
719: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
720: l_scl_null_ind number(1) := 0;

Line 758: from per_all_assignments_f asg

754: -- Cursor Defination.
755: --
756: cursor csr_get_soft_coding_keyflex is
757: select asg.soft_coding_keyflex_id
758: from per_all_assignments_f asg
759: where asg.assignment_id = p_assignment_id
760: and p_effective_date between asg.effective_start_date
761: and asg.effective_end_date;
762:

Line 1160: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

1156: --
1157: -- {End of Comments}
1158: --
1159: FUNCTION last_apl_asg
1160: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1161: ,p_effective_date IN DATE
1162: )
1163: RETURN BOOLEAN
1164: IS

Line 1175: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

1171: --
1172: -- Local cursors
1173: --
1174: CURSOR csr_last_apl_asg
1175: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1176: ,p_effective_date IN DATE
1177: )
1178: IS
1179: SELECT as2.assignment_id

Line 1180: FROM per_all_assignments_f as2

1176: ,p_effective_date IN DATE
1177: )
1178: IS
1179: SELECT as2.assignment_id
1180: FROM per_all_assignments_f as2
1181: ,per_all_assignments_f as1
1182: WHERE as2.person_id = as1.person_id
1183: AND as2.assignment_type = as1.assignment_type
1184: AND csr_last_apl_asg.p_effective_date BETWEEN as2.effective_start_date

Line 1181: ,per_all_assignments_f as1

1177: )
1178: IS
1179: SELECT as2.assignment_id
1180: FROM per_all_assignments_f as2
1181: ,per_all_assignments_f as1
1182: WHERE as2.person_id = as1.person_id
1183: AND as2.assignment_type = as1.assignment_type
1184: AND csr_last_apl_asg.p_effective_date BETWEEN as2.effective_start_date
1185: AND as2.effective_end_date

Line 1247: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

1243: l_effective_date date;
1244: --
1245: -- Out variables
1246: --
1247: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
1248: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1249: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
1250: --
1251: lv_object_version_number number := p_object_version_number ;

Line 1248: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

1244: --
1245: -- Out variables
1246: --
1247: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
1248: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1249: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
1250: --
1251: lv_object_version_number number := p_object_version_number ;
1252: --

Line 1249: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

1245: -- Out variables
1246: --
1247: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
1248: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1249: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
1250: --
1251: lv_object_version_number number := p_object_version_number ;
1252: --
1253: l_proc varchar2(72);

Line 1415: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

1411: l_effective_date date;
1412: --
1413: -- Out variables
1414: --
1415: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
1416: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1417: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
1418: --
1419: lv_object_version_number number := p_object_version_number ;

Line 1416: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

1412: --
1413: -- Out variables
1414: --
1415: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
1416: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1417: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
1418: --
1419: lv_object_version_number number := p_object_version_number ;
1420: --

Line 1417: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

1413: -- Out variables
1414: --
1415: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
1416: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1417: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
1418: --
1419: lv_object_version_number number := p_object_version_number ;
1420: --
1421: l_proc varchar2(72);

Line 1584: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

1580: -- Out variables
1581: --
1582: l_asg_future_changes_warning boolean := FALSE;
1583: l_pay_proposal_warning boolean := FALSE;
1584: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
1585: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
1586: l_entries_changed_warning varchar2(1) := 'N';
1587: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1588: --

Line 1585: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

1581: --
1582: l_asg_future_changes_warning boolean := FALSE;
1583: l_pay_proposal_warning boolean := FALSE;
1584: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
1585: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
1586: l_entries_changed_warning varchar2(1) := 'N';
1587: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1588: --
1589: l_assignment_status_type_id

Line 1587: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

1583: l_pay_proposal_warning boolean := FALSE;
1584: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
1585: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
1586: l_entries_changed_warning varchar2(1) := 'N';
1587: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1588: --
1589: l_assignment_status_type_id
1590: per_all_assignments_f.assignment_status_type_id%TYPE;
1591: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

Line 1590: per_all_assignments_f.assignment_status_type_id%TYPE;

1586: l_entries_changed_warning varchar2(1) := 'N';
1587: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1588: --
1589: l_assignment_status_type_id
1590: per_all_assignments_f.assignment_status_type_id%TYPE;
1591: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
1592: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
1593: l_exists varchar2(1);
1594: l_last_standard_process_date

Line 1591: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

1587: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1588: --
1589: l_assignment_status_type_id
1590: per_all_assignments_f.assignment_status_type_id%TYPE;
1591: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
1592: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
1593: l_exists varchar2(1);
1594: l_last_standard_process_date
1595: per_periods_of_service.last_standard_process_date%TYPE;

Line 1592: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;

1588: --
1589: l_assignment_status_type_id
1590: per_all_assignments_f.assignment_status_type_id%TYPE;
1591: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
1592: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
1593: l_exists varchar2(1);
1594: l_last_standard_process_date
1595: per_periods_of_service.last_standard_process_date%TYPE;
1596: l_actual_termination_date

Line 1599: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

1595: per_periods_of_service.last_standard_process_date%TYPE;
1596: l_actual_termination_date
1597: per_periods_of_service.actual_termination_date%TYPE;
1598: l_legislation_code per_business_groups.legislation_code%TYPE;
1599: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
1600: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
1601: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
1602: l_proc varchar2(72)
1603: := g_package || 'actual_termination_cwk_asg';

Line 1601: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

1597: per_periods_of_service.actual_termination_date%TYPE;
1598: l_legislation_code per_business_groups.legislation_code%TYPE;
1599: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
1600: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
1601: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
1602: l_proc varchar2(72)
1603: := g_package || 'actual_termination_cwk_asg';
1604: --
1605: lv_object_version_number number := p_object_version_number ;

Line 1613: from per_all_assignments_f asg

1609: , asg.payroll_id
1610: , asg.primary_flag
1611: , bus.business_group_id
1612: , bus.legislation_code
1613: from per_all_assignments_f asg
1614: , per_business_groups_perf bus
1615: where asg.assignment_id = p_assignment_id
1616: and l_actual_termination_date between asg.effective_start_date
1617: and asg.effective_end_date

Line 1622: from per_all_assignments_f asg

1618: and bus.business_group_id+0 = asg.business_group_id;
1619: --
1620: cursor csr_invalid_term_assign is
1621: select null
1622: from per_all_assignments_f asg
1623: , per_assignment_status_types ast
1624: where asg.assignment_id = p_assignment_id
1625: and asg.effective_end_date >= l_actual_termination_date
1626: and ast.assignment_status_type_id = asg.assignment_status_type_id

Line 1992: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

1988: --
1989: -- Out variables
1990: --
1991: l_asg_future_changes_warning boolean := FALSE;
1992: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
1993: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
1994: l_entries_changed_warning varchar2(1) := 'N';
1995: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1996: l_org_now_no_manager_warning boolean := FALSE;

Line 1993: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

1989: -- Out variables
1990: --
1991: l_asg_future_changes_warning boolean := FALSE;
1992: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
1993: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
1994: l_entries_changed_warning varchar2(1) := 'N';
1995: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1996: l_org_now_no_manager_warning boolean := FALSE;
1997: --

Line 1995: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

1991: l_asg_future_changes_warning boolean := FALSE;
1992: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
1993: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
1994: l_entries_changed_warning varchar2(1) := 'N';
1995: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1996: l_org_now_no_manager_warning boolean := FALSE;
1997: --
1998: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
1999: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

Line 1998: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

1994: l_entries_changed_warning varchar2(1) := 'N';
1995: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1996: l_org_now_no_manager_warning boolean := FALSE;
1997: --
1998: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
1999: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
2000: l_proc varchar2(72)
2001: := g_package || 'final_process_cwk_asg';
2002: l_actual_termination_date date;

Line 1999: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

1995: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
1996: l_org_now_no_manager_warning boolean := FALSE;
1997: --
1998: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
1999: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
2000: l_proc varchar2(72)
2001: := g_package || 'final_process_cwk_asg';
2002: l_actual_termination_date date;
2003: l_final_process_date date;

Line 2011: from per_all_assignments_f asg

2007: --
2008: cursor csr_get_derived_details is
2009: select asg.assignment_type
2010: , asg.primary_flag
2011: from per_all_assignments_f asg
2012: where asg.assignment_id = p_assignment_id
2013: and l_final_process_date between asg.effective_start_date
2014: and asg.effective_end_date;
2015: --

Line 2018: from per_all_assignments_f asg

2014: and asg.effective_end_date;
2015: --
2016: cursor csr_valid_term_assign is
2017: select min(asg.effective_start_date) - 1
2018: from per_all_assignments_f asg
2019: where asg.assignment_id = p_assignment_id
2020: and exists ( select null
2021: from per_assignment_status_types ast
2022: where ast.assignment_status_type_id

Line 2029: from per_all_assignments_f asg

2025:
2026: --
2027: cursor csr_invalid_term_assign is
2028: select max(asg.effective_end_date)
2029: from per_all_assignments_f asg
2030: where asg.assignment_id = p_assignment_id
2031: and exists ( select null
2032: from per_assignment_status_types ast
2033: where ast.assignment_status_type_id

Line 2332: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

2328: l_effective_date date;
2329: --
2330: -- Out variables
2331: --
2332: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2333: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2334: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2335: --
2336: l_proc varchar2(72);

Line 2333: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

2329: --
2330: -- Out variables
2331: --
2332: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2333: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2334: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2335: --
2336: l_proc varchar2(72);
2337: --

Line 2334: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

2330: -- Out variables
2331: --
2332: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2333: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2334: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2335: --
2336: l_proc varchar2(72);
2337: --
2338: begin

Line 2494: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

2490: -- Out variables
2491: --
2492: l_asg_future_changes_warning boolean := FALSE;
2493: l_pay_proposal_warning boolean := FALSE;
2494: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2495: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2496: l_entries_changed_warning varchar2(1) := 'N';
2497: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2498: --

Line 2495: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

2491: --
2492: l_asg_future_changes_warning boolean := FALSE;
2493: l_pay_proposal_warning boolean := FALSE;
2494: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2495: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2496: l_entries_changed_warning varchar2(1) := 'N';
2497: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2498: --
2499: l_assignment_status_type_id

Line 2497: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

2493: l_pay_proposal_warning boolean := FALSE;
2494: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2495: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2496: l_entries_changed_warning varchar2(1) := 'N';
2497: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2498: --
2499: l_assignment_status_type_id
2500: per_all_assignments_f.assignment_status_type_id%TYPE;
2501: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

Line 2500: per_all_assignments_f.assignment_status_type_id%TYPE;

2496: l_entries_changed_warning varchar2(1) := 'N';
2497: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2498: --
2499: l_assignment_status_type_id
2500: per_all_assignments_f.assignment_status_type_id%TYPE;
2501: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
2502: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
2503: l_exists varchar2(1);
2504: l_last_standard_process_date

Line 2501: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

2497: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
2498: --
2499: l_assignment_status_type_id
2500: per_all_assignments_f.assignment_status_type_id%TYPE;
2501: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
2502: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
2503: l_exists varchar2(1);
2504: l_last_standard_process_date
2505: per_periods_of_service.last_standard_process_date%TYPE;

Line 2502: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;

2498: --
2499: l_assignment_status_type_id
2500: per_all_assignments_f.assignment_status_type_id%TYPE;
2501: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
2502: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
2503: l_exists varchar2(1);
2504: l_last_standard_process_date
2505: per_periods_of_service.last_standard_process_date%TYPE;
2506: l_actual_termination_date

Line 2509: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

2505: per_periods_of_service.last_standard_process_date%TYPE;
2506: l_actual_termination_date
2507: per_periods_of_service.actual_termination_date%TYPE;
2508: l_legislation_code per_business_groups.legislation_code%TYPE;
2509: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
2510: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
2511: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
2512: l_proc varchar2(72)
2513: := g_package || 'actual_termination_emp_asg';

Line 2511: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

2507: per_periods_of_service.actual_termination_date%TYPE;
2508: l_legislation_code per_business_groups.legislation_code%TYPE;
2509: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
2510: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
2511: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
2512: l_proc varchar2(72)
2513: := g_package || 'actual_termination_emp_asg';
2514: --
2515: lv_object_version_number number := p_object_version_number ;

Line 2523: from per_all_assignments_f asg

2519: , asg.payroll_id
2520: , asg.primary_flag
2521: , bus.business_group_id
2522: , bus.legislation_code
2523: from per_all_assignments_f asg
2524: , per_business_groups_perf bus
2525: where asg.assignment_id = p_assignment_id
2526: and l_actual_termination_date between asg.effective_start_date
2527: and asg.effective_end_date

Line 2532: from per_all_assignments_f asg

2528: and bus.business_group_id+0 = asg.business_group_id;
2529: --
2530: cursor csr_invalid_term_assign is
2531: select null
2532: from per_all_assignments_f asg
2533: , per_assignment_status_types ast
2534: where asg.assignment_id = p_assignment_id
2535: and asg.effective_end_date >= l_actual_termination_date
2536: and ast.assignment_status_type_id = asg.assignment_status_type_id

Line 3053: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

3049: -- Declare cursors and local variables
3050: --
3051: -- Out variables
3052: --
3053: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3054: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
3055: := p_soft_coding_keyflex_id; -- bug 2359997
3056: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3057: := p_people_group_id; -- bug 2359997

Line 3054: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

3050: --
3051: -- Out variables
3052: --
3053: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3054: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
3055: := p_soft_coding_keyflex_id; -- bug 2359997
3056: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3057: := p_people_group_id; -- bug 2359997
3058: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

Line 3056: l_people_group_id per_all_assignments_f.people_group_id%TYPE

3052: --
3053: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3054: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
3055: := p_soft_coding_keyflex_id; -- bug 2359997
3056: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3057: := p_people_group_id; -- bug 2359997
3058: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3059: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3060: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

Line 3058: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

3054: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
3055: := p_soft_coding_keyflex_id; -- bug 2359997
3056: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3057: := p_people_group_id; -- bug 2359997
3058: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3059: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3060: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3061: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3062: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

Line 3059: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

3055: := p_soft_coding_keyflex_id; -- bug 2359997
3056: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3057: := p_people_group_id; -- bug 2359997
3058: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3059: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3060: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3061: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3062: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3063: l_comment_id per_all_assignments_f.comment_id%TYPE;

Line 3060: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

3056: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3057: := p_people_group_id; -- bug 2359997
3058: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3059: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3060: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3061: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3062: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3063: l_comment_id per_all_assignments_f.comment_id%TYPE;
3064: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 3061: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

3057: := p_people_group_id; -- bug 2359997
3058: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3059: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3060: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3061: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3062: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3063: l_comment_id per_all_assignments_f.comment_id%TYPE;
3064: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3065: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 3062: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

3058: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3059: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3060: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3061: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3062: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3063: l_comment_id per_all_assignments_f.comment_id%TYPE;
3064: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3065: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3066: l_group_name pay_people_groups.group_name%TYPE;

Line 3063: l_comment_id per_all_assignments_f.comment_id%TYPE;

3059: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3060: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3061: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3062: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3063: l_comment_id per_all_assignments_f.comment_id%TYPE;
3064: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3065: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3066: l_group_name pay_people_groups.group_name%TYPE;
3067: l_old_group_name pay_people_groups.group_name%TYPE;

Line 3070: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

3066: l_group_name pay_people_groups.group_name%TYPE;
3067: l_old_group_name pay_people_groups.group_name%TYPE;
3068: l_other_manager_warning boolean;
3069: l_effective_date date;
3070: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
3071: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3072: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3073: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3074: --

Line 3077: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

3073: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3074: --
3075: l_business_group_id per_business_groups.business_group_id%TYPE;
3076: l_legislation_code per_business_groups.legislation_code%TYPE;
3077: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
3078: l_proc varchar2(72);
3079: l_session_id number;
3080: l_cagr_grade_def_id number;
3081: l_cagr_concatenated_segments number;

Line 3488: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

3484: -- Declare cursors and local variables
3485: --
3486: -- Out variables
3487: --
3488: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3489: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
3490: := p_soft_coding_keyflex_id; -- bug 2359997 added initialization
3491: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3492: := p_people_group_id; -- bug 2359997 added initialization

Line 3489: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

3485: --
3486: -- Out variables
3487: --
3488: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3489: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
3490: := p_soft_coding_keyflex_id; -- bug 2359997 added initialization
3491: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3492: := p_people_group_id; -- bug 2359997 added initialization
3493: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

Line 3491: l_people_group_id per_all_assignments_f.people_group_id%TYPE

3487: --
3488: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3489: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
3490: := p_soft_coding_keyflex_id; -- bug 2359997 added initialization
3491: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3492: := p_people_group_id; -- bug 2359997 added initialization
3493: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
3494: := p_cagr_grade_def_id; -- bug 2359997, added this local variable
3495: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

Line 3495: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

3491: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3492: := p_people_group_id; -- bug 2359997 added initialization
3493: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
3494: := p_cagr_grade_def_id; -- bug 2359997, added this local variable
3495: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3496: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3497: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3498: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3499: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

Line 3496: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

3492: := p_people_group_id; -- bug 2359997 added initialization
3493: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
3494: := p_cagr_grade_def_id; -- bug 2359997, added this local variable
3495: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3496: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3497: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3498: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3499: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3500: l_comment_id per_all_assignments_f.comment_id%TYPE;

Line 3497: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

3493: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
3494: := p_cagr_grade_def_id; -- bug 2359997, added this local variable
3495: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3496: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3497: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3498: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3499: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3500: l_comment_id per_all_assignments_f.comment_id%TYPE;
3501: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 3498: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

3494: := p_cagr_grade_def_id; -- bug 2359997, added this local variable
3495: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3496: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3497: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3498: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3499: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3500: l_comment_id per_all_assignments_f.comment_id%TYPE;
3501: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3502: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 3499: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

3495: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3496: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3497: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3498: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3499: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3500: l_comment_id per_all_assignments_f.comment_id%TYPE;
3501: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3502: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3503: l_group_name pay_people_groups.group_name%TYPE;

Line 3500: l_comment_id per_all_assignments_f.comment_id%TYPE;

3496: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3497: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3498: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3499: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3500: l_comment_id per_all_assignments_f.comment_id%TYPE;
3501: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3502: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3503: l_group_name pay_people_groups.group_name%TYPE;
3504: l_old_group_name pay_people_groups.group_name%TYPE;

Line 3507: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

3503: l_group_name pay_people_groups.group_name%TYPE;
3504: l_old_group_name pay_people_groups.group_name%TYPE;
3505: l_other_manager_warning boolean;
3506: l_effective_date date;
3507: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
3508: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3509: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3510: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3511: l_hourly_salaried_warning boolean;

Line 3924: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

3920: -- Declare cursors and local variables
3921: --
3922: -- Out variables
3923: --
3924: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3925: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
3926: := p_soft_coding_keyflex_id;
3927: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3928: := p_people_group_id;

Line 3925: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

3921: --
3922: -- Out variables
3923: --
3924: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3925: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
3926: := p_soft_coding_keyflex_id;
3927: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3928: := p_people_group_id;
3929: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

Line 3927: l_people_group_id per_all_assignments_f.people_group_id%TYPE

3923: --
3924: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3925: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
3926: := p_soft_coding_keyflex_id;
3927: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3928: := p_people_group_id;
3929: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3930: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3931: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

Line 3929: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

3925: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
3926: := p_soft_coding_keyflex_id;
3927: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3928: := p_people_group_id;
3929: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3930: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3931: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3932: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3933: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

Line 3930: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

3926: := p_soft_coding_keyflex_id;
3927: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3928: := p_people_group_id;
3929: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3930: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3931: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3932: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3933: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3934: l_comment_id per_all_assignments_f.comment_id%TYPE;

Line 3931: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

3927: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3928: := p_people_group_id;
3929: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3930: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3931: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3932: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3933: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3934: l_comment_id per_all_assignments_f.comment_id%TYPE;
3935: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 3932: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

3928: := p_people_group_id;
3929: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3930: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3931: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3932: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3933: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3934: l_comment_id per_all_assignments_f.comment_id%TYPE;
3935: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3936: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 3933: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

3929: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3930: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3931: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3932: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3933: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3934: l_comment_id per_all_assignments_f.comment_id%TYPE;
3935: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3936: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3937: l_group_name pay_people_groups.group_name%TYPE;

Line 3934: l_comment_id per_all_assignments_f.comment_id%TYPE;

3930: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3931: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3932: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3933: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3934: l_comment_id per_all_assignments_f.comment_id%TYPE;
3935: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3936: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3937: l_group_name pay_people_groups.group_name%TYPE;
3938: l_old_group_name pay_people_groups.group_name%TYPE;

Line 3942: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

3938: l_old_group_name pay_people_groups.group_name%TYPE;
3939: l_other_manager_warning boolean;
3940: l_hourly_salaried_warning boolean;
3941: l_effective_date date;
3942: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
3943: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3944: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3945: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3946: --

Line 3949: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

3945: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3946: --
3947: l_business_group_id per_business_groups.business_group_id%TYPE;
3948: l_legislation_code per_business_groups.legislation_code%TYPE;
3949: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
3950: l_proc varchar2(72) := g_package||
3951: 'create_secondary_emp_asg';
3952: l_session_id number;
3953: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

Line 4373: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

4369: -- Declare cursors and local variables
4370: --
4371: -- Out variables
4372: --
4373: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4374: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
4375: := p_soft_coding_keyflex_id;
4376: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4377: := p_people_group_id;

Line 4374: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

4370: --
4371: -- Out variables
4372: --
4373: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4374: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
4375: := p_soft_coding_keyflex_id;
4376: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4377: := p_people_group_id;
4378: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

Line 4376: l_people_group_id per_all_assignments_f.people_group_id%TYPE

4372: --
4373: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4374: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
4375: := p_soft_coding_keyflex_id;
4376: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4377: := p_people_group_id;
4378: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4379: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4380: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

Line 4378: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

4374: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
4375: := p_soft_coding_keyflex_id;
4376: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4377: := p_people_group_id;
4378: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4379: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4380: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4381: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4382: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

Line 4379: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

4375: := p_soft_coding_keyflex_id;
4376: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4377: := p_people_group_id;
4378: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4379: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4380: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4381: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4382: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4383: l_comment_id per_all_assignments_f.comment_id%TYPE;

Line 4380: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

4376: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4377: := p_people_group_id;
4378: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4379: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4380: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4381: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4382: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4383: l_comment_id per_all_assignments_f.comment_id%TYPE;
4384: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 4381: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

4377: := p_people_group_id;
4378: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4379: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4380: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4381: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4382: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4383: l_comment_id per_all_assignments_f.comment_id%TYPE;
4384: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4385: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 4382: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

4378: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4379: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4380: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4381: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4382: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4383: l_comment_id per_all_assignments_f.comment_id%TYPE;
4384: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4385: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4386: l_group_name pay_people_groups.group_name%TYPE;

Line 4383: l_comment_id per_all_assignments_f.comment_id%TYPE;

4379: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4380: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4381: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4382: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4383: l_comment_id per_all_assignments_f.comment_id%TYPE;
4384: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4385: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4386: l_group_name pay_people_groups.group_name%TYPE;
4387: l_old_group_name pay_people_groups.group_name%TYPE;

Line 4391: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

4387: l_old_group_name pay_people_groups.group_name%TYPE;
4388: l_other_manager_warning boolean;
4389: l_hourly_salaried_warning boolean;
4390: l_effective_date date;
4391: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4392: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4393: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4394: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4395: --

Line 4398: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

4394: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4395: --
4396: l_business_group_id per_business_groups.business_group_id%TYPE;
4397: l_legislation_code per_business_groups.legislation_code%TYPE;
4398: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
4399: l_proc varchar2(72) := g_package||
4400: 'create_secondary_emp_asg';
4401: l_session_id number;
4402: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

Line 4518: from per_all_assignments_f asg

4514: and bus.business_group_id = per.business_group_id;
4515: --
4516: cursor csr_get_period_of_service is
4517: select asg.period_of_service_id
4518: from per_all_assignments_f asg
4519: where asg.person_id = p_person_id
4520: and l_effective_date between asg.effective_start_date
4521: and asg.effective_end_date
4522: and asg.primary_flag = 'Y'

Line 5901: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

5897: l_proc VARCHAR2(72) := g_package||'create_secondary_cwk_asg';
5898: l_effective_date DATE;
5899: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
5900: l_old_group_name pay_people_groups.group_name%TYPE;
5901: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
5902: l_other_manager_warning BOOLEAN;
5903: l_hourly_salaried_warning BOOLEAN;
5904: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
5905: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

Line 5904: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

5900: l_old_group_name pay_people_groups.group_name%TYPE;
5901: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
5902: l_other_manager_warning BOOLEAN;
5903: l_hourly_salaried_warning BOOLEAN;
5904: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
5905: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
5906: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
5907: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
5908: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

Line 5905: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

5901: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
5902: l_other_manager_warning BOOLEAN;
5903: l_hourly_salaried_warning BOOLEAN;
5904: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
5905: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
5906: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
5907: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
5908: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
5909: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

Line 5906: l_people_group_id per_all_assignments_f.people_group_id%TYPE;

5902: l_other_manager_warning BOOLEAN;
5903: l_hourly_salaried_warning BOOLEAN;
5904: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
5905: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
5906: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
5907: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
5908: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
5909: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
5910: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

Line 5907: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

5903: l_hourly_salaried_warning BOOLEAN;
5904: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
5905: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
5906: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
5907: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
5908: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
5909: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
5910: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
5911: l_comment_id per_all_assignments_f.comment_id%TYPE;

Line 5908: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

5904: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
5905: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
5906: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
5907: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
5908: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
5909: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
5910: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
5911: l_comment_id per_all_assignments_f.comment_id%TYPE;
5912: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 5909: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

5905: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
5906: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
5907: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
5908: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
5909: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
5910: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
5911: l_comment_id per_all_assignments_f.comment_id%TYPE;
5912: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
5913: l_group_name pay_people_groups.group_name%TYPE;

Line 5910: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

5906: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
5907: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
5908: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
5909: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
5910: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
5911: l_comment_id per_all_assignments_f.comment_id%TYPE;
5912: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
5913: l_group_name pay_people_groups.group_name%TYPE;
5914: l_session_id NUMBER;

Line 5911: l_comment_id per_all_assignments_f.comment_id%TYPE;

5907: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
5908: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
5909: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
5910: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
5911: l_comment_id per_all_assignments_f.comment_id%TYPE;
5912: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
5913: l_group_name pay_people_groups.group_name%TYPE;
5914: l_session_id NUMBER;
5915: l_business_group_id per_business_groups.business_group_id%TYPE;

Line 5918: --l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

5914: l_session_id NUMBER;
5915: l_business_group_id per_business_groups.business_group_id%TYPE;
5916: l_legislation_code per_business_groups.legislation_code%TYPE;
5917: l_pop_date_start DATE;
5918: --l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
5919: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
5920: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
5921: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
5922: l_vendor_id NUMBER := p_vendor_id;

Line 5945: from per_all_assignments_f asg

5941: and bus.business_group_id = per.business_group_id;
5942: --
5943: cursor csr_get_period_of_placement is
5944: select asg.period_of_placement_date_start
5945: from per_all_assignments_f asg
5946: where asg.person_id = p_person_id
5947: and l_effective_date between asg.effective_start_date
5948: and asg.effective_end_date
5949: and asg.primary_flag = 'Y'

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

7167: --
7168: -- Declare cursors and local variables
7169: --
7170: -- Assigned the value p_assignment_number for fix of #2823013
7171: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
7172: l_effective_date date;
7173: l_legislation_code per_business_groups.legislation_code%TYPE;
7174: l_proc varchar2(72);
7175: --

Line 7178: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

7174: l_proc varchar2(72);
7175: --
7176: -- Declare dummy variables
7177: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
7178: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
7179: --
7180: -- Declare cursors
7181: --
7182: cursor csr_legislation is

Line 7184: from per_all_assignments_f paf,

7180: -- Declare cursors
7181: --
7182: cursor csr_legislation is
7183: select null
7184: from per_all_assignments_f paf,
7185: per_business_groups_perf pbg
7186: where paf.person_id = p_person_id
7187: and l_effective_date between paf.effective_start_date
7188: and paf.effective_end_date

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

7476: --
7477: -- Declare cursors and local variables
7478: --
7479: -- Assigned the value p_assignment_number for fix of #2823013
7480: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
7481: l_effective_date date;
7482: l_legislation_code per_business_groups.legislation_code%TYPE;
7483: l_proc varchar2(72);
7484: --

Line 7487: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

7483: l_proc varchar2(72);
7484: --
7485: -- Declare dummy variables
7486: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
7487: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
7488: --
7489: -- Declare cursors
7490: --
7491: cursor csr_legislation is

Line 7493: from per_all_assignments_f paf,

7489: -- Declare cursors
7490: --
7491: cursor csr_legislation is
7492: select null
7493: from per_all_assignments_f paf,
7494: per_business_groups_perf pbg
7495: where paf.person_id = p_person_id
7496: and l_effective_date between paf.effective_start_date
7497: and paf.effective_end_date

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

7800: --
7801: -- Declare variables
7802: --
7803: -- WWBUG 2539685
7804: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
7805: l_effective_date date;
7806: --
7807: l_business_group_id per_business_groups.business_group_id%TYPE;
7808: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 7815: from per_all_assignments_f paf,

7811: -- Declare cursors
7812: --
7813: cursor csr_legislation is
7814: select null
7815: from per_all_assignments_f paf,
7816: per_business_groups_perf pbg
7817: where paf.person_id = p_person_id
7818: and l_effective_date between paf.effective_start_date
7819: and paf.effective_end_date

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

8133: --
8134: -- Declare variables
8135: --
8136: -- Assigned the value p_assignment_number for fix of #2823013
8137: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
8138: l_effective_date date;
8139: --
8140: l_business_group_id per_business_groups.business_group_id%TYPE;
8141: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 8148: from per_all_assignments_f paf,

8144: -- Declare cursors
8145: --
8146: cursor csr_legislation is
8147: select null
8148: from per_all_assignments_f paf,
8149: per_business_groups_perf pbg
8150: where paf.person_id = p_person_id
8151: and l_effective_date between paf.effective_start_date
8152: and paf.effective_end_date

Line 8350: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

8346: --
8347: -- Out variables
8348: --
8349: l_asg_future_changes_warning boolean := FALSE;
8350: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
8351: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
8352: l_entries_changed_warning varchar2(1) := 'N';
8353: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
8354: l_org_now_no_manager_warning boolean := FALSE;

Line 8351: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

8347: -- Out variables
8348: --
8349: l_asg_future_changes_warning boolean := FALSE;
8350: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
8351: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
8352: l_entries_changed_warning varchar2(1) := 'N';
8353: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
8354: l_org_now_no_manager_warning boolean := FALSE;
8355: --

Line 8353: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

8349: l_asg_future_changes_warning boolean := FALSE;
8350: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
8351: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
8352: l_entries_changed_warning varchar2(1) := 'N';
8353: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
8354: l_org_now_no_manager_warning boolean := FALSE;
8355: --
8356: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
8357: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

Line 8356: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

8352: l_entries_changed_warning varchar2(1) := 'N';
8353: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
8354: l_org_now_no_manager_warning boolean := FALSE;
8355: --
8356: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
8357: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
8358: l_proc varchar2(72)
8359: := g_package || 'final_process_emp_asg';
8360: l_actual_termination_date date;

Line 8357: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

8353: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
8354: l_org_now_no_manager_warning boolean := FALSE;
8355: --
8356: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
8357: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
8358: l_proc varchar2(72)
8359: := g_package || 'final_process_emp_asg';
8360: l_actual_termination_date date;
8361: l_final_process_date date;

Line 8369: from per_all_assignments_f asg

8365: --
8366: cursor csr_get_derived_details is
8367: select asg.assignment_type
8368: , asg.primary_flag
8369: from per_all_assignments_f asg
8370: where asg.assignment_id = p_assignment_id
8371: and l_final_process_date between asg.effective_start_date
8372: and asg.effective_end_date;
8373: --

Line 8376: from per_all_assignments_f asg

8372: and asg.effective_end_date;
8373: --
8374: cursor csr_valid_term_assign is
8375: select min(asg.effective_start_date) - 1
8376: from per_all_assignments_f asg
8377: where asg.assignment_id = p_assignment_id
8378: and exists ( select null
8379: from per_assignment_status_types ast
8380: where ast.assignment_status_type_id

Line 8387: from per_all_assignments_f asg

8383:
8384: --
8385: cursor csr_invalid_term_assign is
8386: select max(asg.effective_end_date)
8387: from per_all_assignments_f asg
8388: where asg.assignment_id = p_assignment_id
8389: and exists ( select null
8390: from per_assignment_status_types ast
8391: where ast.assignment_status_type_id

Line 8692: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

8688: l_effective_date date;
8689: --
8690: -- Out variables
8691: --
8692: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
8693: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
8694: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
8695: --
8696: lv_object_version_number number := p_object_version_number ;

Line 8693: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

8689: --
8690: -- Out variables
8691: --
8692: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
8693: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
8694: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
8695: --
8696: lv_object_version_number number := p_object_version_number ;
8697: --

Line 8694: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

8690: -- Out variables
8691: --
8692: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
8693: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
8694: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
8695: --
8696: lv_object_version_number number := p_object_version_number ;
8697: --
8698: l_proc varchar2(72);

Line 8953: l_comment_id per_all_assignments_f.comment_id%TYPE;

8949: -- Declare cursors and local variables
8950: --
8951: -- Out variables
8952: --
8953: l_comment_id per_all_assignments_f.comment_id%TYPE;
8954: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
8955: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
8956: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
8957: l_no_managers_warning boolean;

Line 8954: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

8950: --
8951: -- Out variables
8952: --
8953: l_comment_id per_all_assignments_f.comment_id%TYPE;
8954: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
8955: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
8956: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
8957: l_no_managers_warning boolean;
8958: l_other_manager_warning boolean;

Line 8955: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

8951: -- Out variables
8952: --
8953: l_comment_id per_all_assignments_f.comment_id%TYPE;
8954: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
8955: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
8956: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
8957: l_no_managers_warning boolean;
8958: l_other_manager_warning boolean;
8959: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

Line 8956: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

8952: --
8953: l_comment_id per_all_assignments_f.comment_id%TYPE;
8954: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
8955: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
8956: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
8957: l_no_managers_warning boolean;
8958: l_other_manager_warning boolean;
8959: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
8960: := p_soft_coding_keyflex_id; -- bug 2359997

Line 8959: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

8955: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
8956: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
8957: l_no_managers_warning boolean;
8958: l_other_manager_warning boolean;
8959: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
8960: := p_soft_coding_keyflex_id; -- bug 2359997
8961: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
8962: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
8963: l_effective_date date;

Line 8964: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

8960: := p_soft_coding_keyflex_id; -- bug 2359997
8961: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
8962: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
8963: l_effective_date date;
8964: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
8965: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
8966: l_organization_id per_all_assignments_f.organization_id%type;
8967: l_location_id per_all_assignments_f.location_id%type;
8968: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE;

Line 8966: l_organization_id per_all_assignments_f.organization_id%type;

8962: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
8963: l_effective_date date;
8964: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
8965: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
8966: l_organization_id per_all_assignments_f.organization_id%type;
8967: l_location_id per_all_assignments_f.location_id%type;
8968: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE;
8969: l_cagr_concatenated_segments varchar2(2000);
8970: l_proc varchar2(72);

Line 8967: l_location_id per_all_assignments_f.location_id%type;

8963: l_effective_date date;
8964: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
8965: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
8966: l_organization_id per_all_assignments_f.organization_id%type;
8967: l_location_id per_all_assignments_f.location_id%type;
8968: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE;
8969: l_cagr_concatenated_segments varchar2(2000);
8970: l_proc varchar2(72);
8971: --

Line 9275: l_comment_id per_all_assignments_f.comment_id%TYPE;

9271: -- Declare cursors and local variables
9272: --
9273: -- Out variables
9274: --
9275: l_comment_id per_all_assignments_f.comment_id%TYPE;
9276: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9277: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9278: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9279: l_no_managers_warning boolean;

Line 9276: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

9272: --
9273: -- Out variables
9274: --
9275: l_comment_id per_all_assignments_f.comment_id%TYPE;
9276: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9277: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9278: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9279: l_no_managers_warning boolean;
9280: l_other_manager_warning boolean;

Line 9277: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

9273: -- Out variables
9274: --
9275: l_comment_id per_all_assignments_f.comment_id%TYPE;
9276: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9277: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9278: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9279: l_no_managers_warning boolean;
9280: l_other_manager_warning boolean;
9281: l_hourly_salaried_warning boolean;

Line 9278: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

9274: --
9275: l_comment_id per_all_assignments_f.comment_id%TYPE;
9276: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9277: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9278: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9279: l_no_managers_warning boolean;
9280: l_other_manager_warning boolean;
9281: l_hourly_salaried_warning boolean;
9282: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

Line 9282: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

9278: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9279: l_no_managers_warning boolean;
9280: l_other_manager_warning boolean;
9281: l_hourly_salaried_warning boolean;
9282: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
9283: := p_soft_coding_keyflex_id; -- bug 2359997
9284: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9285: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9286: l_effective_date date;

Line 9287: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

9283: := p_soft_coding_keyflex_id; -- bug 2359997
9284: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9285: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9286: l_effective_date date;
9287: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9288: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9289: l_organization_id per_all_assignments_f.organization_id%type;
9290: l_location_id per_all_assignments_f.location_id%type;
9291: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

Line 9289: l_organization_id per_all_assignments_f.organization_id%type;

9285: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9286: l_effective_date date;
9287: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9288: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9289: l_organization_id per_all_assignments_f.organization_id%type;
9290: l_location_id per_all_assignments_f.location_id%type;
9291: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
9292: := p_cagr_grade_def_id; -- bug 2359997
9293: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;

Line 9290: l_location_id per_all_assignments_f.location_id%type;

9286: l_effective_date date;
9287: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9288: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9289: l_organization_id per_all_assignments_f.organization_id%type;
9290: l_location_id per_all_assignments_f.location_id%type;
9291: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
9292: := p_cagr_grade_def_id; -- bug 2359997
9293: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
9294: l_cagr_concatenated_segments varchar2(2000);

Line 9611: l_comment_id per_all_assignments_f.comment_id%TYPE;

9607: -- Declare cursors and local variables
9608: --
9609: -- Out variables
9610: --
9611: l_comment_id per_all_assignments_f.comment_id%TYPE;
9612: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9613: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9614: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9615: l_no_managers_warning boolean;

Line 9612: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

9608: --
9609: -- Out variables
9610: --
9611: l_comment_id per_all_assignments_f.comment_id%TYPE;
9612: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9613: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9614: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9615: l_no_managers_warning boolean;
9616: l_other_manager_warning boolean;

Line 9613: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

9609: -- Out variables
9610: --
9611: l_comment_id per_all_assignments_f.comment_id%TYPE;
9612: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9613: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9614: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9615: l_no_managers_warning boolean;
9616: l_other_manager_warning boolean;
9617: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

Line 9614: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

9610: --
9611: l_comment_id per_all_assignments_f.comment_id%TYPE;
9612: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9613: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9614: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9615: l_no_managers_warning boolean;
9616: l_other_manager_warning boolean;
9617: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
9618: := p_soft_coding_keyflex_id; -- bug 2359997

Line 9617: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

9613: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9614: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9615: l_no_managers_warning boolean;
9616: l_other_manager_warning boolean;
9617: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
9618: := p_soft_coding_keyflex_id; -- bug 2359997
9619: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9620: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9621: l_effective_date date;

Line 9622: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

9618: := p_soft_coding_keyflex_id; -- bug 2359997
9619: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9620: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9621: l_effective_date date;
9622: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9623: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9624: l_organization_id per_all_assignments_f.organization_id%type;
9625: l_location_id per_all_assignments_f.location_id%type;
9626: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

Line 9624: l_organization_id per_all_assignments_f.organization_id%type;

9620: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9621: l_effective_date date;
9622: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9623: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9624: l_organization_id per_all_assignments_f.organization_id%type;
9625: l_location_id per_all_assignments_f.location_id%type;
9626: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
9627: := p_cagr_grade_def_id; -- bug 2359997
9628: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;

Line 9625: l_location_id per_all_assignments_f.location_id%type;

9621: l_effective_date date;
9622: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9623: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9624: l_organization_id per_all_assignments_f.organization_id%type;
9625: l_location_id per_all_assignments_f.location_id%type;
9626: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
9627: := p_cagr_grade_def_id; -- bug 2359997
9628: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
9629: l_cagr_concatenated_segments varchar2(2000);

Line 9635: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

9631: l_gsp_post_process_warning varchar2(2000); -- bug 2999562
9632: --
9633: -- Internal working variables
9634: --
9635: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
9636: l_business_group_id per_business_groups.business_group_id%TYPE;
9637: l_payroll_id_updated boolean;
9638: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
9639: l_org_now_no_manager_warning boolean;

Line 9638: l_people_group_id per_all_assignments_f.people_group_id%TYPE;

9634: --
9635: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
9636: l_business_group_id per_business_groups.business_group_id%TYPE;
9637: l_payroll_id_updated boolean;
9638: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
9639: l_org_now_no_manager_warning boolean;
9640: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
9641: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
9642: l_proc varchar2(72) := g_package||'update_emp_asg';

Line 9640: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;

9636: l_business_group_id per_business_groups.business_group_id%TYPE;
9637: l_payroll_id_updated boolean;
9638: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
9639: l_org_now_no_manager_warning boolean;
9640: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
9641: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
9642: l_proc varchar2(72) := g_package||'update_emp_asg';
9643: l_session_id number;
9644: l_unused_start_date date;

Line 9641: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;

9637: l_payroll_id_updated boolean;
9638: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
9639: l_org_now_no_manager_warning boolean;
9640: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
9641: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
9642: l_proc varchar2(72) := g_package||'update_emp_asg';
9643: l_session_id number;
9644: l_unused_start_date date;
9645: l_unused_end_date date;

Line 9967: l_comment_id per_all_assignments_f.comment_id%TYPE;

9963: -- Declare cursors and local variables
9964: --
9965: -- Out variables
9966: --
9967: l_comment_id per_all_assignments_f.comment_id%TYPE;
9968: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9969: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9970: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9971: l_no_managers_warning boolean;

Line 9968: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

9964: --
9965: -- Out variables
9966: --
9967: l_comment_id per_all_assignments_f.comment_id%TYPE;
9968: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9969: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9970: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9971: l_no_managers_warning boolean;
9972: l_other_manager_warning boolean;

Line 9969: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

9965: -- Out variables
9966: --
9967: l_comment_id per_all_assignments_f.comment_id%TYPE;
9968: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9969: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9970: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9971: l_no_managers_warning boolean;
9972: l_other_manager_warning boolean;
9973: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

Line 9970: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

9966: --
9967: l_comment_id per_all_assignments_f.comment_id%TYPE;
9968: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
9969: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9970: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9971: l_no_managers_warning boolean;
9972: l_other_manager_warning boolean;
9973: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
9974: := p_soft_coding_keyflex_id; -- bug 2359997

Line 9973: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

9969: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
9970: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
9971: l_no_managers_warning boolean;
9972: l_other_manager_warning boolean;
9973: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
9974: := p_soft_coding_keyflex_id; -- bug 2359997
9975: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9976: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9977: l_effective_date date;

Line 9978: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

9974: := p_soft_coding_keyflex_id; -- bug 2359997
9975: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9976: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9977: l_effective_date date;
9978: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9979: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9980: l_organization_id per_all_assignments_f.organization_id%type;
9981: l_location_id per_all_assignments_f.location_id%type;
9982: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

Line 9980: l_organization_id per_all_assignments_f.organization_id%type;

9976: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9977: l_effective_date date;
9978: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9979: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9980: l_organization_id per_all_assignments_f.organization_id%type;
9981: l_location_id per_all_assignments_f.location_id%type;
9982: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
9983: := p_cagr_grade_def_id; -- bug 2359997
9984: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;

Line 9981: l_location_id per_all_assignments_f.location_id%type;

9977: l_effective_date date;
9978: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9979: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9980: l_organization_id per_all_assignments_f.organization_id%type;
9981: l_location_id per_all_assignments_f.location_id%type;
9982: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
9983: := p_cagr_grade_def_id; -- bug 2359997
9984: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
9985: l_cagr_concatenated_segments varchar2(2000);

Line 9991: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

9987: l_gsp_post_process_warning varchar2(2000); -- bug 2999562
9988: --
9989: -- Internal working variables
9990: --
9991: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
9992: l_business_group_id per_business_groups.business_group_id%TYPE;
9993: l_payroll_id_updated boolean;
9994: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
9995: l_org_now_no_manager_warning boolean;

Line 9994: l_people_group_id per_all_assignments_f.people_group_id%TYPE;

9990: --
9991: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
9992: l_business_group_id per_business_groups.business_group_id%TYPE;
9993: l_payroll_id_updated boolean;
9994: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
9995: l_org_now_no_manager_warning boolean;
9996: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
9997: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
9998: l_proc varchar2(72) := g_package||'update_emp_asg';

Line 9996: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;

9992: l_business_group_id per_business_groups.business_group_id%TYPE;
9993: l_payroll_id_updated boolean;
9994: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
9995: l_org_now_no_manager_warning boolean;
9996: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
9997: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
9998: l_proc varchar2(72) := g_package||'update_emp_asg';
9999: l_session_id number;
10000: l_unused_start_date date;

Line 9997: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;

9993: l_payroll_id_updated boolean;
9994: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
9995: l_org_now_no_manager_warning boolean;
9996: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
9997: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
9998: l_proc varchar2(72) := g_package||'update_emp_asg';
9999: l_session_id number;
10000: l_unused_start_date date;
10001: l_unused_end_date date;

Line 10073: per_all_assignments_f asg

10069: l_projected_assignment_end date;--fix for bug 6595592.
10070: cursor csr_old_asg_status is
10071: select ast.per_system_status
10072: from per_assignment_status_types ast,
10073: per_all_assignments_f asg
10074: where ast.assignment_status_type_id = asg.assignment_status_type_id
10075: and asg.assignment_id = p_assignment_id
10076: and l_effective_date between asg.effective_start_date
10077: and asg.effective_end_date;

Line 10090: from per_all_assignments_f asg

10086: , asg.business_group_id
10087: -- , asg.soft_coding_keyflex_id -- bug 2359997
10088: , asg.organization_id
10089: , asg.location_id
10090: from per_all_assignments_f asg
10091: where asg.assignment_id = p_assignment_id
10092: and l_effective_date between asg.effective_start_date
10093: and asg.effective_end_date;
10094: --

Line 10098: from per_all_assignments_f asg

10094: --
10095: /* Added By Fs
10096: cursor csr_get_soft_coding_keyflex is -- bug 2359997
10097: select asg.soft_coding_keyflex_id
10098: from per_all_assignments_f asg
10099: where asg.assignment_id = p_assignment_id
10100: and l_effective_date between asg.effective_start_date
10101: and asg.effective_end_date;
10102: --

Line 11276: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

11272: --
11273: -- Out variables
11274: --
11275: l_org_now_no_manager_warning BOOLEAN;
11276: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
11277: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
11278: l_comment_id per_all_assignments_f.comment_id%TYPE;
11279: l_no_managers_warning BOOLEAN;
11280: l_other_manager_warning BOOLEAN;

Line 11277: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

11273: -- Out variables
11274: --
11275: l_org_now_no_manager_warning BOOLEAN;
11276: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
11277: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
11278: l_comment_id per_all_assignments_f.comment_id%TYPE;
11279: l_no_managers_warning BOOLEAN;
11280: l_other_manager_warning BOOLEAN;
11281: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

Line 11278: l_comment_id per_all_assignments_f.comment_id%TYPE;

11274: --
11275: l_org_now_no_manager_warning BOOLEAN;
11276: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
11277: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
11278: l_comment_id per_all_assignments_f.comment_id%TYPE;
11279: l_no_managers_warning BOOLEAN;
11280: l_other_manager_warning BOOLEAN;
11281: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
11282: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

Line 11281: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

11277: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
11278: l_comment_id per_all_assignments_f.comment_id%TYPE;
11279: l_no_managers_warning BOOLEAN;
11280: l_other_manager_warning BOOLEAN;
11281: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
11282: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
11283: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11284: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11285: l_hourly_salaried_warning BOOLEAN;

Line 11282: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

11278: l_comment_id per_all_assignments_f.comment_id%TYPE;
11279: l_no_managers_warning BOOLEAN;
11280: l_other_manager_warning BOOLEAN;
11281: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
11282: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
11283: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11284: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11285: l_hourly_salaried_warning BOOLEAN;
11286: l_session_id NUMBER;

Line 11295: l_organization_id per_all_assignments_f.organization_id%TYPE;

11291: --
11292: l_proc VARCHAR2(72) := g_package||'update_cwk_asg';
11293: l_effective_date DATE;
11294: l_projected_assignment_end DATE;
11295: l_organization_id per_all_assignments_f.organization_id%TYPE;
11296: l_business_group_id per_business_groups.business_group_id%TYPE;
11297: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
11298: l_location_id per_all_assignments_f.location_id%TYPE;
11299: l_old_asg_status per_assignment_status_types.per_system_status%TYPE;

Line 11297: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

11293: l_effective_date DATE;
11294: l_projected_assignment_end DATE;
11295: l_organization_id per_all_assignments_f.organization_id%TYPE;
11296: l_business_group_id per_business_groups.business_group_id%TYPE;
11297: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
11298: l_location_id per_all_assignments_f.location_id%TYPE;
11299: l_old_asg_status per_assignment_status_types.per_system_status%TYPE;
11300: l_new_asg_status per_assignment_status_types.per_system_status%TYPE;
11301: l_cagr_grade_def_id NUMBER;

Line 11298: l_location_id per_all_assignments_f.location_id%TYPE;

11294: l_projected_assignment_end DATE;
11295: l_organization_id per_all_assignments_f.organization_id%TYPE;
11296: l_business_group_id per_business_groups.business_group_id%TYPE;
11297: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
11298: l_location_id per_all_assignments_f.location_id%TYPE;
11299: l_old_asg_status per_assignment_status_types.per_system_status%TYPE;
11300: l_new_asg_status per_assignment_status_types.per_system_status%TYPE;
11301: l_cagr_grade_def_id NUMBER;
11302: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;

Line 11302: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;

11298: l_location_id per_all_assignments_f.location_id%TYPE;
11299: l_old_asg_status per_assignment_status_types.per_system_status%TYPE;
11300: l_new_asg_status per_assignment_status_types.per_system_status%TYPE;
11301: l_cagr_grade_def_id NUMBER;
11302: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
11303: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
11304: l_po_header_id NUMBER := p_po_header_id;
11305: l_vendor_id NUMBER := p_vendor_id;
11306: --

Line 11303: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;

11299: l_old_asg_status per_assignment_status_types.per_system_status%TYPE;
11300: l_new_asg_status per_assignment_status_types.per_system_status%TYPE;
11301: l_cagr_grade_def_id NUMBER;
11302: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
11303: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
11304: l_po_header_id NUMBER := p_po_header_id;
11305: l_vendor_id NUMBER := p_vendor_id;
11306: --
11307: /*

Line 11309: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

11305: l_vendor_id NUMBER := p_vendor_id;
11306: --
11307: /*
11308: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11309: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
11310: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
11311: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
11312: l_unused_start_date date;
11313: l_unused_end_date date;

Line 11310: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

11306: --
11307: /*
11308: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11309: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
11310: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
11311: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
11312: l_unused_start_date date;
11313: l_unused_end_date date;
11314: */

Line 11311: l_people_group_id per_all_assignments_f.people_group_id%TYPE;

11307: /*
11308: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11309: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
11310: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
11311: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
11312: l_unused_start_date date;
11313: l_unused_end_date date;
11314: */
11315: --

Line 11321: per_all_assignments_f asg

11317: --
11318: cursor csr_old_asg_status is
11319: select ast.per_system_status
11320: from per_assignment_status_types ast,
11321: per_all_assignments_f asg
11322: where ast.assignment_status_type_id = asg.assignment_status_type_id
11323: and asg.assignment_id = p_assignment_id
11324: and l_effective_date between asg.effective_start_date and asg.effective_end_date;
11325: --

Line 11337: from per_all_assignments_f asg

11333: , asg.business_group_id
11334: , asg.soft_coding_keyflex_id
11335: , asg.organization_id
11336: , asg.location_id
11337: from per_all_assignments_f asg
11338: where asg.assignment_id = p_assignment_id
11339: and l_effective_date between asg.effective_start_date
11340: and asg.effective_end_date;
11341: --

Line 11373: per_all_assignments_f paf

11369: l_vendor_site_id_1 number default null;
11370:
11371: cursor po_cwk is
11372: select vendor_id,vendor_site_id from
11373: per_all_assignments_f paf
11374: where paf.assignment_id = p_assignment_id
11375: and nvl(l_effective_date,sysdate) between paf.effective_start_date
11376: and paf.effective_end_date;
11377: --end code for bug 6961562

Line 12233: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

12229: -- Declare cursors and local variables
12230: --
12231: -- Out variables
12232: --
12233: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
12234: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
12235: l_entries_changed_warning varchar2(1) := 'N';
12236: l_people_group_name pay_people_groups.group_name%TYPE;
12237: l_old_group_name pay_people_groups.group_name%TYPE;

Line 12234: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

12230: --
12231: -- Out variables
12232: --
12233: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
12234: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
12235: l_entries_changed_warning varchar2(1) := 'N';
12236: l_people_group_name pay_people_groups.group_name%TYPE;
12237: l_old_group_name pay_people_groups.group_name%TYPE;
12238: l_no_managers_warning boolean;

Line 12239: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

12235: l_entries_changed_warning varchar2(1) := 'N';
12236: l_people_group_name pay_people_groups.group_name%TYPE;
12237: l_old_group_name pay_people_groups.group_name%TYPE;
12238: l_no_managers_warning boolean;
12239: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
12240: l_org_now_no_manager_warning boolean;
12241: l_other_manager_warning boolean;
12242: l_hourly_salaried_warning boolean;
12243: l_payroll_id_updated boolean;

Line 12244: l_people_group_id per_all_assignments_f.people_group_id%TYPE;

12240: l_org_now_no_manager_warning boolean;
12241: l_other_manager_warning boolean;
12242: l_hourly_salaried_warning boolean;
12243: l_payroll_id_updated boolean;
12244: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
12245: l_spp_delete_warning boolean := false; -- Bug 3545065
12246: l_tax_district_changed_warning boolean;
12247: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
12248: --

Line 12250: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

12246: l_tax_district_changed_warning boolean;
12247: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
12248: --
12249: l_api_updating boolean;
12250: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
12251: l_comment_id per_all_assignments_f.comment_id%TYPE;
12252: l_entries_changed varchar2(1);
12253: l_legislation_code per_business_groups.legislation_code%TYPE;
12254: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;

Line 12251: l_comment_id per_all_assignments_f.comment_id%TYPE;

12247: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
12248: --
12249: l_api_updating boolean;
12250: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
12251: l_comment_id per_all_assignments_f.comment_id%TYPE;
12252: l_entries_changed varchar2(1);
12253: l_legislation_code per_business_groups.legislation_code%TYPE;
12254: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
12255: l_proc varchar2(72) :=

Line 12254: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;

12250: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
12251: l_comment_id per_all_assignments_f.comment_id%TYPE;
12252: l_entries_changed varchar2(1);
12253: l_legislation_code per_business_groups.legislation_code%TYPE;
12254: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
12255: l_proc varchar2(72) :=
12256: g_package || 'update_cwk_asg_criteria';
12257: l_validation_end_date date;
12258: l_validation_start_date date;

Line 12261: l_organization_id per_all_assignments_f.organization_id%type;

12257: l_validation_end_date date;
12258: l_validation_start_date date;
12259: l_effective_date date;
12260: l_element_entry_id number;
12261: l_organization_id per_all_assignments_f.organization_id%type;
12262: l_location_id per_all_assignments_f.location_id%type;
12263: l_session_id number;
12264: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
12265: --

Line 12262: l_location_id per_all_assignments_f.location_id%type;

12258: l_validation_start_date date;
12259: l_effective_date date;
12260: l_element_entry_id number;
12261: l_organization_id per_all_assignments_f.organization_id%type;
12262: l_location_id per_all_assignments_f.location_id%type;
12263: l_session_id number;
12264: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
12265: --
12266: lv_object_version_number number := p_object_version_number ;

Line 12264: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

12260: l_element_entry_id number;
12261: l_organization_id per_all_assignments_f.organization_id%type;
12262: l_location_id per_all_assignments_f.location_id%type;
12263: l_session_id number;
12264: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
12265: --
12266: lv_object_version_number number := p_object_version_number ;
12267: l_grade_id number := Null; -- Bug 3545065
12268: --

Line 12291: from per_all_assignments_f asg

12287: --
12288: cursor get_sec_date_range is
12289: select asg.effective_start_date
12290: , asg.effective_end_date
12291: from per_all_assignments_f asg
12292: where asg.assignment_id=p_assignment_id
12293: and ((sysdate between asg.effective_start_date
12294: and asg.effective_end_date)
12295: or

Line 12299: from per_all_assignments_f asg2

12295: or
12296: (sysdate 12297: and not exists
12298: (select 1
12299: from per_all_assignments_f asg2
12300: where asg2.person_id=asg.person_id
12301: and asg2.period_of_service_id=asg.period_of_service_id
12302: and asg2.effective_start_date 12303: )

Line 12308: from per_all_assignments_f asg

12304: );
12305: --
12306: cursor csr_get_assignment_type is
12307: select asg.assignment_type
12308: from per_all_assignments_f asg
12309: where asg.assignment_id = p_assignment_id
12310: and l_effective_date between asg.effective_start_date
12311: and asg.effective_end_date;
12312: --

Line 13140: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

13136: -- Declare cursors and local variables
13137: --
13138: l_proc varchar2(72);
13139: l_effective_date date;
13140: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
13141: l_concatenated_segments varchar2(2000);
13142: l_legislation_code per_business_groups.legislation_code%TYPE;
13143: l_cagr_concatenated_segments varchar2(300);
13144: l_cagr_grade_def_id number;

Line 13325: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

13321: -- Declare cursors and local variables
13322: --
13323: l_proc varchar2(72);
13324: l_effective_date date;
13325: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
13326: l_concatenated_segments varchar2(2000);
13327: l_legislation_code per_business_groups.legislation_code%TYPE;
13328: --
13329: cursor check_legislation

Line 13330: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,

13326: l_concatenated_segments varchar2(2000);
13327: l_legislation_code per_business_groups.legislation_code%TYPE;
13328: --
13329: cursor check_legislation
13330: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,
13331: c_effective_date date
13332: )
13333: is
13334: select bgp.legislation_code

Line 13335: from per_all_assignments_f asg,

13331: c_effective_date date
13332: )
13333: is
13334: select bgp.legislation_code
13335: from per_all_assignments_f asg,
13336: per_business_groups_perf bgp
13337: where asg.business_group_id = bgp.business_group_id
13338: and asg.assignment_id = c_assignment_id
13339: and c_effective_date

Line 13562: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

13558: -- Declare cursors and local variables
13559: --
13560: l_proc varchar2(72);
13561: l_effective_date date;
13562: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
13563: l_concatenated_segments varchar2(2000);
13564: l_legislation_code per_business_groups.legislation_code%TYPE;
13565: --
13566: cursor check_legislation

Line 13567: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,

13563: l_concatenated_segments varchar2(2000);
13564: l_legislation_code per_business_groups.legislation_code%TYPE;
13565: --
13566: cursor check_legislation
13567: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,
13568: c_effective_date date
13569: )
13570: is
13571: select bgp.legislation_code

Line 13572: from per_all_assignments_f asg,

13568: c_effective_date date
13569: )
13570: is
13571: select bgp.legislation_code
13572: from per_all_assignments_f asg,
13573: per_business_groups_perf bgp
13574: where asg.business_group_id = bgp.business_group_id
13575: and asg.assignment_id = c_assignment_id
13576: and c_effective_date

Line 14015: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,

14011: l_legislation_code per_business_groups.legislation_code%TYPE;
14012:
14013: --
14014: cursor check_legislation
14015: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,
14016: c_effective_date date
14017: )
14018: is
14019: select bgp.legislation_code

Line 14020: from per_all_assignments_f asg,

14016: c_effective_date date
14017: )
14018: is
14019: select bgp.legislation_code
14020: from per_all_assignments_f asg,
14021: per_business_groups_perf bgp
14022: where asg.business_group_id = bgp.business_group_id
14023: and asg.assignment_id = c_assignment_id
14024: and c_effective_date

Line 14281: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,

14277: l_gsp_post_process_warning varchar2(2000); -- bug 2999562
14278:
14279: --
14280: cursor check_legislation
14281: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,
14282: c_effective_date date
14283: )
14284: is
14285: select bgp.legislation_code

Line 14286: from per_all_assignments_f asg,

14282: c_effective_date date
14283: )
14284: is
14285: select bgp.legislation_code
14286: from per_all_assignments_f asg,
14287: per_business_groups_perf bgp
14288: where asg.business_group_id = bgp.business_group_id
14289: and asg.assignment_id = c_assignment_id
14290: and c_effective_date

Line 14549: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,

14545: l_legislation_code per_business_groups.legislation_code%TYPE;
14546:
14547: --
14548: cursor check_legislation
14549: (c_assignment_id per_all_assignments_f.assignment_id%TYPE,
14550: c_effective_date date
14551: )
14552: is
14553: select bgp.legislation_code

Line 14554: from per_all_assignments_f asg,

14550: c_effective_date date
14551: )
14552: is
14553: select bgp.legislation_code
14554: from per_all_assignments_f asg,
14555: per_business_groups_perf bgp
14556: where asg.business_group_id = bgp.business_group_id
14557: and asg.assignment_id = c_assignment_id
14558: and c_effective_date

Line 14776: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

14772: -- Declare cursors and local variables
14773: --
14774: -- Out variables
14775: --
14776: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
14777: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
14778: l_entries_changed_warning varchar2(1) := 'N';
14779: l_group_name pay_people_groups.group_name%TYPE;
14780: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

Line 14777: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

14773: --
14774: -- Out variables
14775: --
14776: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
14777: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
14778: l_entries_changed_warning varchar2(1) := 'N';
14779: l_group_name pay_people_groups.group_name%TYPE;
14780: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
14781: l_org_now_no_manager_warning boolean;

Line 14780: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

14776: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
14777: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
14778: l_entries_changed_warning varchar2(1) := 'N';
14779: l_group_name pay_people_groups.group_name%TYPE;
14780: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
14781: l_org_now_no_manager_warning boolean;
14782: l_other_manager_warning boolean;
14783: l_people_group_id per_all_assignments_f.people_group_id%TYPE
14784: := p_people_group_id; -- bug 2359997

Line 14783: l_people_group_id per_all_assignments_f.people_group_id%TYPE

14779: l_group_name pay_people_groups.group_name%TYPE;
14780: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
14781: l_org_now_no_manager_warning boolean;
14782: l_other_manager_warning boolean;
14783: l_people_group_id per_all_assignments_f.people_group_id%TYPE
14784: := p_people_group_id; -- bug 2359997
14785: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE
14786: := p_special_ceiling_step_id; --3485599
14787: l_spp_delete_warning boolean;

Line 14785: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE

14781: l_org_now_no_manager_warning boolean;
14782: l_other_manager_warning boolean;
14783: l_people_group_id per_all_assignments_f.people_group_id%TYPE
14784: := p_people_group_id; -- bug 2359997
14785: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE
14786: := p_special_ceiling_step_id; --3485599
14787: l_spp_delete_warning boolean;
14788: l_tax_district_changed_warning boolean;
14789:

Line 15004: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

15000: -- Declare cursors and local variables
15001: --
15002: -- Out variables
15003: --
15004: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
15005: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
15006: l_entries_changed_warning varchar2(1) := 'N';
15007: l_group_name pay_people_groups.group_name%TYPE;
15008: l_old_group_name pay_people_groups.group_name%TYPE;

Line 15005: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

15001: --
15002: -- Out variables
15003: --
15004: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
15005: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
15006: l_entries_changed_warning varchar2(1) := 'N';
15007: l_group_name pay_people_groups.group_name%TYPE;
15008: l_old_group_name pay_people_groups.group_name%TYPE;
15009: l_no_managers_warning boolean;

Line 15010: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

15006: l_entries_changed_warning varchar2(1) := 'N';
15007: l_group_name pay_people_groups.group_name%TYPE;
15008: l_old_group_name pay_people_groups.group_name%TYPE;
15009: l_no_managers_warning boolean;
15010: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
15011: l_org_now_no_manager_warning boolean;
15012: l_other_manager_warning boolean;
15013: l_hourly_salaried_warning boolean;
15014: l_payroll_id_updated boolean;

Line 15015: l_people_group_id per_all_assignments_f.people_group_id%TYPE

15011: l_org_now_no_manager_warning boolean;
15012: l_other_manager_warning boolean;
15013: l_hourly_salaried_warning boolean;
15014: l_payroll_id_updated boolean;
15015: l_people_group_id per_all_assignments_f.people_group_id%TYPE
15016: := p_people_group_id; -- bug 2359997
15017: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE
15018: := p_special_ceiling_step_id; -- bug 3485599
15019: l_spp_delete_warning boolean;

Line 15017: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE

15013: l_hourly_salaried_warning boolean;
15014: l_payroll_id_updated boolean;
15015: l_people_group_id per_all_assignments_f.people_group_id%TYPE
15016: := p_people_group_id; -- bug 2359997
15017: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE
15018: := p_special_ceiling_step_id; -- bug 3485599
15019: l_spp_delete_warning boolean;
15020: l_tax_district_changed_warning boolean;
15021: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 15024: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

15020: l_tax_district_changed_warning boolean;
15021: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
15022: --
15023: l_api_updating boolean;
15024: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
15025: l_comment_id per_all_assignments_f.comment_id%TYPE;
15026: l_entries_changed varchar2(1);
15027: l_legislation_code per_business_groups.legislation_code%TYPE;
15028: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;

Line 15025: l_comment_id per_all_assignments_f.comment_id%TYPE;

15021: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
15022: --
15023: l_api_updating boolean;
15024: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
15025: l_comment_id per_all_assignments_f.comment_id%TYPE;
15026: l_entries_changed varchar2(1);
15027: l_legislation_code per_business_groups.legislation_code%TYPE;
15028: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
15029: l_proc varchar2(72) :=

Line 15028: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;

15024: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
15025: l_comment_id per_all_assignments_f.comment_id%TYPE;
15026: l_entries_changed varchar2(1);
15027: l_legislation_code per_business_groups.legislation_code%TYPE;
15028: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
15029: l_proc varchar2(72) :=
15030: g_package || 'update_emp_asg_criteria';
15031:
15032: -- Start of Fix for Bug 2622747

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

15029: l_proc varchar2(72) :=
15030: g_package || 'update_emp_asg_criteria';
15031:
15032: -- Start of Fix for Bug 2622747
15033: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
15034: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15035: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15036: -- End of Fix for Bug 2622747
15037:

Line 15218: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

15214: -- Declare cursors and local variables
15215: --
15216: -- Out variables
15217: --
15218: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
15219: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
15220: l_entries_changed_warning varchar2(1) := 'N';
15221: l_group_name pay_people_groups.group_name%TYPE;
15222: l_old_group_name pay_people_groups.group_name%TYPE;

Line 15219: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

15215: --
15216: -- Out variables
15217: --
15218: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
15219: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
15220: l_entries_changed_warning varchar2(1) := 'N';
15221: l_group_name pay_people_groups.group_name%TYPE;
15222: l_old_group_name pay_people_groups.group_name%TYPE;
15223: l_no_managers_warning boolean;

Line 15224: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

15220: l_entries_changed_warning varchar2(1) := 'N';
15221: l_group_name pay_people_groups.group_name%TYPE;
15222: l_old_group_name pay_people_groups.group_name%TYPE;
15223: l_no_managers_warning boolean;
15224: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
15225: l_org_now_no_manager_warning boolean;
15226: l_other_manager_warning boolean;
15227: l_hourly_salaried_warning boolean;
15228: l_payroll_id_updated boolean;

Line 15229: l_people_group_id per_all_assignments_f.people_group_id%TYPE

15225: l_org_now_no_manager_warning boolean;
15226: l_other_manager_warning boolean;
15227: l_hourly_salaried_warning boolean;
15228: l_payroll_id_updated boolean;
15229: l_people_group_id per_all_assignments_f.people_group_id%TYPE
15230: := p_people_group_id; -- bug 2359997
15231: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
15232: l_spp_delete_warning boolean;
15233: l_tax_district_changed_warning boolean;

Line 15231: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;

15227: l_hourly_salaried_warning boolean;
15228: l_payroll_id_updated boolean;
15229: l_people_group_id per_all_assignments_f.people_group_id%TYPE
15230: := p_people_group_id; -- bug 2359997
15231: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
15232: l_spp_delete_warning boolean;
15233: l_tax_district_changed_warning boolean;
15234: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
15235: l_gsp_post_process_warning varchar2(2000); -- bug2999562

Line 15238: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

15234: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
15235: l_gsp_post_process_warning varchar2(2000); -- bug2999562
15236: --
15237: l_api_updating boolean;
15238: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
15239: l_comment_id per_all_assignments_f.comment_id%TYPE;
15240: l_entries_changed varchar2(1);
15241: l_legislation_code per_business_groups.legislation_code%TYPE;
15242: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;

Line 15239: l_comment_id per_all_assignments_f.comment_id%TYPE;

15235: l_gsp_post_process_warning varchar2(2000); -- bug2999562
15236: --
15237: l_api_updating boolean;
15238: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
15239: l_comment_id per_all_assignments_f.comment_id%TYPE;
15240: l_entries_changed varchar2(1);
15241: l_legislation_code per_business_groups.legislation_code%TYPE;
15242: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
15243: l_proc varchar2(72) :=

Line 15242: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;

15238: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
15239: l_comment_id per_all_assignments_f.comment_id%TYPE;
15240: l_entries_changed varchar2(1);
15241: l_legislation_code per_business_groups.legislation_code%TYPE;
15242: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
15243: l_proc varchar2(72) :=
15244: g_package || 'update_emp_asg_criteria';
15245: l_validation_end_date date;
15246: l_validation_start_date date;

Line 15249: l_organization_id per_all_assignments_f.organization_id%type;

15245: l_validation_end_date date;
15246: l_validation_start_date date;
15247: l_effective_date date;
15248: l_element_entry_id number;
15249: l_organization_id per_all_assignments_f.organization_id%type;
15250: l_location_id per_all_assignments_f.location_id%type;
15251: l_session_id number;
15252: l_step_id per_spinal_point_steps_f.step_id%TYPE;
15253:

Line 15250: l_location_id per_all_assignments_f.location_id%type;

15246: l_validation_start_date date;
15247: l_effective_date date;
15248: l_element_entry_id number;
15249: l_organization_id per_all_assignments_f.organization_id%type;
15250: l_location_id per_all_assignments_f.location_id%type;
15251: l_session_id number;
15252: l_step_id per_spinal_point_steps_f.step_id%TYPE;
15253:
15254: -- Start of Fix for Bug 2622747

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

15251: l_session_id number;
15252: l_step_id per_spinal_point_steps_f.step_id%TYPE;
15253:
15254: -- Start of Fix for Bug 2622747
15255: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
15256: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15257: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
15258: -- End of Fix for Bug 2622747
15259:

Line 15411: from per_all_assignments_f asg

15407: --
15408: cursor get_sec_date_range is
15409: select asg.effective_start_date
15410: , asg.effective_end_date
15411: from per_all_assignments_f asg
15412: where asg.assignment_id=p_assignment_id
15413: and ((sysdate between asg.effective_start_date
15414: and asg.effective_end_date)
15415: or

Line 15419: from per_all_assignments_f asg2

15415: or
15416: (sysdate 15417: and not exists
15418: (select 1
15419: from per_all_assignments_f asg2
15420: where asg2.person_id=asg.person_id
15421: and asg2.period_of_service_id=asg.period_of_service_id
15422: and asg2.effective_start_date 15423: )

Line 16694: l_comment_id per_all_assignments_f.comment_id%TYPE;

16690: -- Declare cursors and local variables
16691: --
16692: -- Out variables
16693: --
16694: l_comment_id per_all_assignments_f.comment_id%TYPE;
16695: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
16696: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
16697: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
16698: l_dummy_payroll boolean;

Line 16695: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

16691: --
16692: -- Out variables
16693: --
16694: l_comment_id per_all_assignments_f.comment_id%TYPE;
16695: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
16696: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
16697: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
16698: l_dummy_payroll boolean;
16699: l_dummy_manager1 boolean;

Line 16696: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

16692: -- Out variables
16693: --
16694: l_comment_id per_all_assignments_f.comment_id%TYPE;
16695: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
16696: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
16697: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
16698: l_dummy_payroll boolean;
16699: l_dummy_manager1 boolean;
16700: l_dummy_manager2 boolean;

Line 16697: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

16693: --
16694: l_comment_id per_all_assignments_f.comment_id%TYPE;
16695: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
16696: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
16697: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
16698: l_dummy_payroll boolean;
16699: l_dummy_manager1 boolean;
16700: l_dummy_manager2 boolean;
16701: l_dummy_manager3 boolean;

Line 16703: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;

16699: l_dummy_manager1 boolean;
16700: l_dummy_manager2 boolean;
16701: l_dummy_manager3 boolean;
16702: l_hourly_salaried_warning boolean;
16703: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
16704: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
16705: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
16706: l_effective_date date;
16707: l_date_probation_end date;

Line 16704: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;

16700: l_dummy_manager2 boolean;
16701: l_dummy_manager3 boolean;
16702: l_hourly_salaried_warning boolean;
16703: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
16704: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
16705: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
16706: l_effective_date date;
16707: l_date_probation_end date;
16708: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 16705: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

16701: l_dummy_manager3 boolean;
16702: l_hourly_salaried_warning boolean;
16703: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
16704: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
16705: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
16706: l_effective_date date;
16707: l_date_probation_end date;
16708: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
16709: l_organization_id per_all_assignments_f.organization_id%type;

Line 16709: l_organization_id per_all_assignments_f.organization_id%type;

16705: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
16706: l_effective_date date;
16707: l_date_probation_end date;
16708: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
16709: l_organization_id per_all_assignments_f.organization_id%type;
16710: l_location_id per_all_assignments_f.location_id%type;
16711: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
16712: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
16713: l_unused_start_date date;

Line 16710: l_location_id per_all_assignments_f.location_id%type;

16706: l_effective_date date;
16707: l_date_probation_end date;
16708: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
16709: l_organization_id per_all_assignments_f.organization_id%type;
16710: l_location_id per_all_assignments_f.location_id%type;
16711: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
16712: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
16713: l_unused_start_date date;
16714: l_unused_end_date date;

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

16718: --
16719: l_assignment_status_id number;
16720: l_asg_status_ovn number;
16721: --
16722: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;
16723: l_group_name pay_people_groups.group_name%TYPE;
16724: l_old_group_name pay_people_groups.group_name%TYPE;
16725: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
16726: l_scl_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE ;

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

16721: --
16722: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;
16723: l_group_name pay_people_groups.group_name%TYPE;
16724: l_old_group_name pay_people_groups.group_name%TYPE;
16725: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
16726: l_scl_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE ;
16727: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
16728: l_proc varchar2(72) := g_package||'update_apl_asg';
16729: l_api_updating boolean;

Line 16835: per_all_assignments_f asg

16831: --
16832: cursor csr_old_asg_status is
16833: select ast.per_system_status
16834: from per_assignment_status_types ast,
16835: per_all_assignments_f asg
16836: where ast.assignment_status_type_id = asg.assignment_status_type_id
16837: and asg.assignment_id = p_assignment_id
16838: and l_effective_date between asg.effective_start_date and asg.effective_end_date;
16839: --

Line 16876: from per_all_assignments_f asg

16872: --
16873: cursor get_sec_date_range is
16874: select asg.effective_start_date
16875: , asg.effective_end_date
16876: from per_all_assignments_f asg
16877: where asg.assignment_id=p_assignment_id
16878: and ((sysdate between asg.effective_start_date
16879: and asg.effective_end_date)
16880: or

Line 16884: from per_all_assignments_f asg2

16880: or
16881: (sysdate 16882: and not exists
16883: (select 1
16884: from per_all_assignments_f asg2
16885: where asg2.person_id=asg.person_id
16886: and asg2.application_id=asg.application_id
16887: and asg2.effective_start_date 16888: )

Line 16996: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

16992: from per_cagr_grades_def
16993: where cagr_grade_def_id = l_cagr_grade_def_id;
16994: --
16995: -- fix for bug 5938120 starts here.
16996: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
16997:
16998: cursor csr_get_assign(csr_person_id number) is
16999: select assignment_id
17000: from per_all_assignments_f

Line 17000: from per_all_assignments_f

16996: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
16997:
16998: cursor csr_get_assign(csr_person_id number) is
16999: select assignment_id
17000: from per_all_assignments_f
17001: where person_id=csr_person_id
17002: and business_group_id=l_business_group_id
17003: and l_effective_date between effective_start_date and effective_end_date
17004: and assignment_type not in ('B','O'); -- added for the bug 6925339

Line 18360: l_comment_id per_all_assignments_f.comment_id%TYPE;

18356: -- Declare cursors and local variables
18357: --
18358: -- Out variables
18359: --
18360: l_comment_id per_all_assignments_f.comment_id%TYPE;
18361: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
18362: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
18363: l_dummy_payroll boolean;
18364: l_dummy_manager1 boolean;

Line 18361: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

18357: --
18358: -- Out variables
18359: --
18360: l_comment_id per_all_assignments_f.comment_id%TYPE;
18361: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
18362: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
18363: l_dummy_payroll boolean;
18364: l_dummy_manager1 boolean;
18365: l_dummy_manager2 boolean;

Line 18362: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

18358: -- Out variables
18359: --
18360: l_comment_id per_all_assignments_f.comment_id%TYPE;
18361: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
18362: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
18363: l_dummy_payroll boolean;
18364: l_dummy_manager1 boolean;
18365: l_dummy_manager2 boolean;
18366: l_dummy_manager3 boolean;

Line 18367: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;

18363: l_dummy_payroll boolean;
18364: l_dummy_manager1 boolean;
18365: l_dummy_manager2 boolean;
18366: l_dummy_manager3 boolean;
18367: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
18368: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
18369: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
18370: l_effective_date date;
18371: l_date_probation_end date;

Line 18368: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;

18364: l_dummy_manager1 boolean;
18365: l_dummy_manager2 boolean;
18366: l_dummy_manager3 boolean;
18367: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
18368: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
18369: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
18370: l_effective_date date;
18371: l_date_probation_end date;
18372: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 18369: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

18365: l_dummy_manager2 boolean;
18366: l_dummy_manager3 boolean;
18367: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
18368: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
18369: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
18370: l_effective_date date;
18371: l_date_probation_end date;
18372: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
18373: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 18386: l_people_group_id per_all_assignments_f.people_group_id%TYPE;

18382: --
18383: -- Internal working variables
18384: --
18385: l_business_group_id per_business_groups.business_group_id%TYPE;
18386: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
18387: l_group_name pay_people_groups.group_name%TYPE;
18388: l_proc varchar2(72);
18389: l_api_updating boolean;
18390: --

Line 19088: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

19084: -- Declare cursors and local variables
19085: --
19086: -- Out variables
19087: --
19088: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
19089: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;
19090: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
19091: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
19092: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

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

19085: --
19086: -- Out variables
19087: --
19088: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
19089: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;
19090: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
19091: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
19092: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
19093: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

Line 19090: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

19086: -- Out variables
19087: --
19088: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
19089: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;
19090: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
19091: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
19092: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
19093: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
19094: l_comment_id per_all_assignments_f.comment_id%TYPE;

Line 19091: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

19087: --
19088: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
19089: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;
19090: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
19091: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
19092: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
19093: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
19094: l_comment_id per_all_assignments_f.comment_id%TYPE;
19095: l_group_name pay_people_groups.group_name%TYPE;

Line 19092: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

19088: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
19089: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;
19090: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
19091: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
19092: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
19093: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
19094: l_comment_id per_all_assignments_f.comment_id%TYPE;
19095: l_group_name pay_people_groups.group_name%TYPE;
19096: l_old_group_name pay_people_groups.group_name%TYPE;

Line 19093: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

19089: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;
19090: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
19091: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
19092: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
19093: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
19094: l_comment_id per_all_assignments_f.comment_id%TYPE;
19095: l_group_name pay_people_groups.group_name%TYPE;
19096: l_old_group_name pay_people_groups.group_name%TYPE;
19097: --

Line 19094: l_comment_id per_all_assignments_f.comment_id%TYPE;

19090: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
19091: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
19092: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
19093: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
19094: l_comment_id per_all_assignments_f.comment_id%TYPE;
19095: l_group_name pay_people_groups.group_name%TYPE;
19096: l_old_group_name pay_people_groups.group_name%TYPE;
19097: --
19098: l_application_id per_applications.application_id%TYPE;

Line 19101: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

19097: --
19098: l_application_id per_applications.application_id%TYPE;
19099: l_business_group_id per_business_groups.business_group_id%TYPE;
19100: l_legislation_code per_business_groups.legislation_code%TYPE;
19101: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
19102: l_proc varchar2(72) := g_package||'create_secondary_apl_asg';
19103: l_effective_date date;
19104: l_date_probation_end date;
19105: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;

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

19101: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
19102: l_proc varchar2(72) := g_package||'create_secondary_apl_asg';
19103: l_effective_date date;
19104: l_date_probation_end date;
19105: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
19106: l_scl_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE ;
19107: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
19108: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
19109: l_session_id number;

Line 19239: from per_all_assignments_f asg

19235: and nvl(apl.date_end,hr_api.g_eot);
19236: -- <<
19237: cursor csr_get_apl_asg is
19238: select asg.application_id
19239: from per_all_assignments_f asg
19240: where asg.person_id = p_person_id
19241: and l_effective_date between asg.effective_start_date
19242: and asg.effective_end_date
19243: and asg.assignment_type = 'A';

Line 19375: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;

19371: segment20
19372: from per_cagr_grades_def
19373: where cagr_grade_def_id = l_cagr_grade_def_id;
19374: --
19375: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;
19376: --
19377: begin
19378: --
19379: if g_debug then

Line 20804: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

20800: -- Declare cursors and local variables
20801: --
20802: -- Out variables
20803: --
20804: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
20805: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
20806: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
20807: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
20808: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

Line 20805: l_people_group_id per_all_assignments_f.people_group_id%TYPE;

20801: --
20802: -- Out variables
20803: --
20804: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
20805: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
20806: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
20807: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
20808: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
20809: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

Line 20806: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

20802: -- Out variables
20803: --
20804: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
20805: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
20806: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
20807: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
20808: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
20809: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
20810: l_comment_id per_all_assignments_f.comment_id%TYPE;

Line 20807: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

20803: --
20804: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
20805: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
20806: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
20807: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
20808: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
20809: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
20810: l_comment_id per_all_assignments_f.comment_id%TYPE;
20811: l_group_name pay_people_groups.group_name%TYPE;

Line 20808: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

20804: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
20805: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
20806: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
20807: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
20808: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
20809: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
20810: l_comment_id per_all_assignments_f.comment_id%TYPE;
20811: l_group_name pay_people_groups.group_name%TYPE;
20812: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 20809: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

20805: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
20806: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
20807: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
20808: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
20809: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
20810: l_comment_id per_all_assignments_f.comment_id%TYPE;
20811: l_group_name pay_people_groups.group_name%TYPE;
20812: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
20813: l_application_id per_applications.application_id%TYPE;

Line 20810: l_comment_id per_all_assignments_f.comment_id%TYPE;

20806: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
20807: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
20808: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
20809: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
20810: l_comment_id per_all_assignments_f.comment_id%TYPE;
20811: l_group_name pay_people_groups.group_name%TYPE;
20812: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
20813: l_application_id per_applications.application_id%TYPE;
20814: l_business_group_id per_business_groups.business_group_id%TYPE;

Line 20816: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

20812: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
20813: l_application_id per_applications.application_id%TYPE;
20814: l_business_group_id per_business_groups.business_group_id%TYPE;
20815: l_legislation_code per_business_groups.legislation_code%TYPE;
20816: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
20817: l_proc varchar2(72);
20818: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
20819: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
20820: l_effective_date date;

Line 20818: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

20814: l_business_group_id per_business_groups.business_group_id%TYPE;
20815: l_legislation_code per_business_groups.legislation_code%TYPE;
20816: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
20817: l_proc varchar2(72);
20818: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
20819: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
20820: l_effective_date date;
20821: l_date_probation_end date;
20822: l_cagr_concatenated_segments varchar2(3000);

Line 20979: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

20975: l_effective_date date;
20976: --
20977: -- Out variables
20978: --
20979: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
20980: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
20981: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
20982: --
20983: lv_object_version_number number := p_object_version_number ;

Line 20980: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

20976: --
20977: -- Out variables
20978: --
20979: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
20980: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
20981: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
20982: --
20983: lv_object_version_number number := p_object_version_number ;
20984: --

Line 20981: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

20977: -- Out variables
20978: --
20979: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
20980: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
20981: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
20982: --
20983: lv_object_version_number number := p_object_version_number ;
20984: --
20985: l_proc varchar2(72);

Line 21144: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

21140: l_effective_date date;
21141: --
21142: -- Out variables
21143: --
21144: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
21145: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21146: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
21147: --
21148: lv_object_version_number number := p_object_version_number ;

Line 21145: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

21141: --
21142: -- Out variables
21143: --
21144: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
21145: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21146: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
21147: --
21148: lv_object_version_number number := p_object_version_number ;
21149: --

Line 21146: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

21142: -- Out variables
21143: --
21144: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
21145: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21146: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
21147: --
21148: lv_object_version_number number := p_object_version_number ;
21149: --
21150: l_proc varchar2(72);

Line 21284: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

21280: PROCEDURE activate_apl_asg
21281: (p_validate IN BOOLEAN
21282: ,p_effective_date IN DATE
21283: ,p_datetrack_update_mode IN VARCHAR2
21284: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
21285: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
21286: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
21287: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
21288: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

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

21281: (p_validate IN BOOLEAN
21282: ,p_effective_date IN DATE
21283: ,p_datetrack_update_mode IN VARCHAR2
21284: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
21285: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
21286: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
21287: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
21288: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
21289: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

Line 21287: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE

21283: ,p_datetrack_update_mode IN VARCHAR2
21284: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
21285: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
21286: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
21287: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
21288: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
21289: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
21290: )
21291: IS

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

21284: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
21285: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
21286: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
21287: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
21288: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
21289: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
21290: )
21291: IS
21292: --

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

21285: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
21286: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
21287: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
21288: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
21289: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
21290: )
21291: IS
21292: --
21293: -- Local variables

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

21295: l_proc VARCHAR2(72);
21296: --
21297: l_effective_date DATE;
21298: --
21299: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
21300: --
21301: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'ACTIVE_APL';
21302: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21303: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

Line 21302: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

21298: --
21299: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
21300: --
21301: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'ACTIVE_APL';
21302: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21303: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
21304: --
21305: lv_object_version_number number := p_object_version_number ;
21306: --

Line 21303: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

21299: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
21300: --
21301: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'ACTIVE_APL';
21302: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21303: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
21304: --
21305: lv_object_version_number number := p_object_version_number ;
21306: --
21307: --

Line 21448: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

21444: --
21445: PROCEDURE terminate_apl_asg
21446: (p_validate IN BOOLEAN
21447: ,p_effective_date IN DATE
21448: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
21449: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
21450: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
21451: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
21452: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

Line 21449: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

21445: PROCEDURE terminate_apl_asg
21446: (p_validate IN BOOLEAN
21447: ,p_effective_date IN DATE
21448: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
21449: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
21450: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
21451: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
21452: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
21453: )

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

21446: (p_validate IN BOOLEAN
21447: ,p_effective_date IN DATE
21448: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
21449: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
21450: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
21451: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
21452: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
21453: )
21454: IS

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

21447: ,p_effective_date IN DATE
21448: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
21449: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
21450: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
21451: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
21452: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
21453: )
21454: IS
21455: BEGIN

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

21448: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
21449: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
21450: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
21451: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
21452: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
21453: )
21454: IS
21455: BEGIN
21456: hr_assignment_api.terminate_apl_asg

Line 21475: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

21471: --
21472: PROCEDURE terminate_apl_asg
21473: (p_validate IN BOOLEAN
21474: ,p_effective_date IN DATE
21475: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
21476: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
21477: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
21478: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
21479: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

Line 21476: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

21472: PROCEDURE terminate_apl_asg
21473: (p_validate IN BOOLEAN
21474: ,p_effective_date IN DATE
21475: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
21476: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
21477: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
21478: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
21479: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
21480: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

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

21473: (p_validate IN BOOLEAN
21474: ,p_effective_date IN DATE
21475: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
21476: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
21477: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
21478: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
21479: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
21480: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
21481: )

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

21474: ,p_effective_date IN DATE
21475: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
21476: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
21477: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
21478: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
21479: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
21480: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
21481: )
21482: IS

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

21475: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
21476: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
21477: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
21478: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
21479: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
21480: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
21481: )
21482: IS
21483: --

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

21476: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
21477: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
21478: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
21479: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
21480: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
21481: )
21482: IS
21483: --
21484: -- Local variables

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

21486: l_proc VARCHAR2(72) := g_package||'terminate_apl_asg';
21487: --
21488: l_effective_date DATE;
21489: --
21490: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
21491: --
21492: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21493: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
21494: --

Line 21492: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

21488: l_effective_date DATE;
21489: --
21490: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
21491: --
21492: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21493: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
21494: --
21495: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;
21496: l_business_group_id hr_all_organization_units.organization_id%TYPE;

Line 21493: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

21489: --
21490: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
21491: --
21492: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21493: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
21494: --
21495: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;
21496: l_business_group_id hr_all_organization_units.organization_id%TYPE;
21497: l_validation_start_date DATE;

Line 21495: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;

21491: --
21492: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21493: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
21494: --
21495: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;
21496: l_business_group_id hr_all_organization_units.organization_id%TYPE;
21497: l_validation_start_date DATE;
21498: l_validation_end_date DATE;
21499: l_org_now_no_manager_warning BOOLEAN;

Line 21520: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

21516: -- <<
21517: -- Local cursors
21518: --
21519: CURSOR csr_assignments
21520: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
21521: ,p_effective_date IN DATE
21522: )
21523: IS
21524: SELECT asg.assignment_type

Line 21529: FROM per_all_assignments_f asg

21525: ,asg.business_group_id
21526: ,bus.legislation_code
21527: ,person_id ,effective_end_date, application_id
21528: ,asg.assignment_status_type_id --7229710
21529: FROM per_all_assignments_f asg
21530: ,per_business_groups_perf bus
21531: WHERE asg.assignment_id = p_assignment_id
21532: AND bus.business_group_id = asg.business_group_id
21533: AND p_effective_date BETWEEN asg.effective_start_date

Line 21539: FROM per_all_assignments_f as2

21535: -- 3652025 >>
21536: CURSOR csr_get_current_apl_asg(cp_asg_id number, cp_effective_date date) IS
21537: SELECT as2.assignment_id, as2.effective_start_date
21538: ,as2.effective_end_date
21539: FROM per_all_assignments_f as2
21540: ,per_all_assignments_f as1
21541: WHERE as2.person_id = as1.person_id
21542: AND as2.assignment_type = as1.assignment_type
21543: AND cp_effective_date BETWEEN as2.effective_start_date

Line 21540: ,per_all_assignments_f as1

21536: CURSOR csr_get_current_apl_asg(cp_asg_id number, cp_effective_date date) IS
21537: SELECT as2.assignment_id, as2.effective_start_date
21538: ,as2.effective_end_date
21539: FROM per_all_assignments_f as2
21540: ,per_all_assignments_f as1
21541: WHERE as2.person_id = as1.person_id
21542: AND as2.assignment_type = as1.assignment_type
21543: AND cp_effective_date BETWEEN as2.effective_start_date
21544: AND as2.effective_end_date

Line 21552: FROM per_all_assignments_f as2

21548: CURSOR csr_get_future_apl_asg(cp_asg_id number, cp_effective_date date) IS
21549: SELECT as2.assignment_id, as2.business_group_id
21550: , as2.effective_start_date, as2.effective_end_date
21551: , as2.application_id, as2.person_id, as2.object_version_number
21552: FROM per_all_assignments_f as2
21553: ,per_all_assignments_f as1
21554: WHERE as2.person_id = as1.person_id
21555: AND as2.assignment_type = as1.assignment_type
21556: AND as2.effective_start_date > cp_effective_date

Line 21553: ,per_all_assignments_f as1

21549: SELECT as2.assignment_id, as2.business_group_id
21550: , as2.effective_start_date, as2.effective_end_date
21551: , as2.application_id, as2.person_id, as2.object_version_number
21552: FROM per_all_assignments_f as2
21553: ,per_all_assignments_f as1
21554: WHERE as2.person_id = as1.person_id
21555: AND as2.assignment_type = as1.assignment_type
21556: AND as2.effective_start_date > cp_effective_date
21557: AND as2.assignment_id <> as1.assignment_id

Line 21586: From per_all_assignments_f

21582: l_person_id number;
21583:
21584: Cursor csr_vacancy_id(l_assg_id number) is
21585: Select vacancy_id
21586: From per_all_assignments_f
21587: Where assignment_id = l_assg_id
21588: And p_effective_date between effective_start_date and effective_end_date;
21589:
21590: cursor csr_person_id(l_assg_id number) is

Line 21592: from per_all_assignments_f

21588: And p_effective_date between effective_start_date and effective_end_date;
21589:
21590: cursor csr_person_id(l_assg_id number) is
21591: select person_id
21592: from per_all_assignments_f
21593: where assignment_id=l_assg_id;
21594: --fix for bug 7229710 Ends here.
21595:
21596: begin

Line 22203: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

22199: PROCEDURE set_new_primary_asg
22200: (p_validate IN BOOLEAN
22201: ,p_effective_date IN DATE
22202: ,p_person_id IN per_all_people_f.person_id%TYPE
22203: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22204: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22205: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22206: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22207: )

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

22200: (p_validate IN BOOLEAN
22201: ,p_effective_date IN DATE
22202: ,p_person_id IN per_all_people_f.person_id%TYPE
22203: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22204: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22205: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22206: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22207: )
22208: IS

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

22201: ,p_effective_date IN DATE
22202: ,p_person_id IN per_all_people_f.person_id%TYPE
22203: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22204: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22205: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22206: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22207: )
22208: IS
22209: --

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

22202: ,p_person_id IN per_all_people_f.person_id%TYPE
22203: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22204: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22205: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22206: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22207: )
22208: IS
22209: --
22210: -- Local Variables

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

22211: --
22212: l_proc VARCHAR2(72) := g_package||'set_new_primary_asg';
22213: --
22214: l_effective_date DATE;
22215: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
22216: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
22217: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
22218: --
22219: lv_object_version_number number := p_object_version_number ;

Line 22216: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

22212: l_proc VARCHAR2(72) := g_package||'set_new_primary_asg';
22213: --
22214: l_effective_date DATE;
22215: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
22216: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
22217: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
22218: --
22219: lv_object_version_number number := p_object_version_number ;
22220: --

Line 22217: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

22213: --
22214: l_effective_date DATE;
22215: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
22216: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
22217: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
22218: --
22219: lv_object_version_number number := p_object_version_number ;
22220: --
22221: -- Local cursors

Line 22224: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

22220: --
22221: -- Local cursors
22222: --
22223: CURSOR csr_new_assignment
22224: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22225: ,p_effective_date IN DATE
22226: )
22227: IS
22228: SELECT asg.object_version_number

Line 22237: FROM per_all_assignments_f asg

22233: ,asg.effective_start_date
22234: ,asg.effective_end_date
22235: ,MAX(mxa.effective_end_date) AS max_effective_end_date
22236: ,pds.actual_termination_date
22237: FROM per_all_assignments_f asg
22238: ,per_all_assignments_f mxa
22239: ,per_periods_of_service pds
22240: WHERE pds.period_of_service_id(+) = asg.period_of_service_id
22241: AND mxa.assignment_id = asg.assignment_id

Line 22238: ,per_all_assignments_f mxa

22234: ,asg.effective_end_date
22235: ,MAX(mxa.effective_end_date) AS max_effective_end_date
22236: ,pds.actual_termination_date
22237: FROM per_all_assignments_f asg
22238: ,per_all_assignments_f mxa
22239: ,per_periods_of_service pds
22240: WHERE pds.period_of_service_id(+) = asg.period_of_service_id
22241: AND mxa.assignment_id = asg.assignment_id
22242: AND asg.assignment_id = csr_new_assignment.p_assignment_id

Line 22267: FROM per_all_assignments_f asg

22263: ,asg.primary_flag
22264: ,asg.person_id
22265: ,asg.effective_start_date
22266: ,asg.effective_end_date
22267: FROM per_all_assignments_f asg
22268: WHERE asg.person_id = csr_old_assignment.p_person_id
22269: AND csr_old_assignment.p_effective_date BETWEEN asg.effective_start_date
22270: AND asg.effective_end_date
22271: AND asg.primary_flag = 'Y'

Line 22546: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

22542: PROCEDURE set_new_primary_cwk_asg
22543: (p_validate IN BOOLEAN
22544: ,p_effective_date IN DATE
22545: ,p_person_id IN per_all_people_f.person_id%TYPE
22546: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22547: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22548: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22549: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22550: )

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

22543: (p_validate IN BOOLEAN
22544: ,p_effective_date IN DATE
22545: ,p_person_id IN per_all_people_f.person_id%TYPE
22546: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22547: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22548: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22549: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22550: )
22551: IS

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

22544: ,p_effective_date IN DATE
22545: ,p_person_id IN per_all_people_f.person_id%TYPE
22546: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22547: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22548: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22549: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22550: )
22551: IS
22552: --

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

22545: ,p_person_id IN per_all_people_f.person_id%TYPE
22546: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22547: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22548: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22549: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22550: )
22551: IS
22552: --
22553: -- Local Variables

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

22554: --
22555: l_proc VARCHAR2(72) := g_package||'set_new_primary_cwk_asg';
22556: --
22557: l_effective_date DATE;
22558: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
22559: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
22560: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
22561: --
22562: lv_object_version_number number := p_object_version_number ;

Line 22559: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

22555: l_proc VARCHAR2(72) := g_package||'set_new_primary_cwk_asg';
22556: --
22557: l_effective_date DATE;
22558: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
22559: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
22560: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
22561: --
22562: lv_object_version_number number := p_object_version_number ;
22563: --

Line 22560: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

22556: --
22557: l_effective_date DATE;
22558: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
22559: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
22560: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
22561: --
22562: lv_object_version_number number := p_object_version_number ;
22563: --
22564: -- Local cursors

Line 22567: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

22563: --
22564: -- Local cursors
22565: --
22566: CURSOR csr_new_assignment
22567: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22568: ,p_effective_date IN DATE) IS
22569: SELECT asg.object_version_number
22570: ,asg.assignment_type
22571: ,asg.period_of_placement_date_start

Line 22578: FROM per_all_assignments_f asg

22574: ,asg.effective_start_date
22575: ,asg.effective_end_date
22576: ,MAX(mxa.effective_end_date) AS max_effective_end_date
22577: ,pop.actual_termination_date
22578: FROM per_all_assignments_f asg
22579: ,per_all_assignments_f mxa
22580: ,per_periods_of_placement pop
22581: WHERE pop.person_id (+) = asg.person_id
22582: AND pop.date_start (+) = asg.period_of_placement_date_start

Line 22579: ,per_all_assignments_f mxa

22575: ,asg.effective_end_date
22576: ,MAX(mxa.effective_end_date) AS max_effective_end_date
22577: ,pop.actual_termination_date
22578: FROM per_all_assignments_f asg
22579: ,per_all_assignments_f mxa
22580: ,per_periods_of_placement pop
22581: WHERE pop.person_id (+) = asg.person_id
22582: AND pop.date_start (+) = asg.period_of_placement_date_start
22583: AND mxa.assignment_id = asg.assignment_id

Line 22606: FROM per_all_assignments_f asg

22602: ,asg.primary_flag
22603: ,asg.person_id
22604: ,asg.effective_start_date
22605: ,asg.effective_end_date
22606: FROM per_all_assignments_f asg
22607: WHERE asg.person_id = csr_old_assignment.p_person_id
22608: AND csr_old_assignment.p_effective_date BETWEEN asg.effective_start_date
22609: AND asg.effective_end_date
22610: AND asg.primary_flag = 'Y'

Line 22902: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

22898: PROCEDURE interview1_apl_asg
22899: (p_validate IN BOOLEAN
22900: ,p_effective_date IN DATE
22901: ,p_datetrack_update_mode IN VARCHAR2
22902: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22903: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22904: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
22905: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
22906: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

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

22899: (p_validate IN BOOLEAN
22900: ,p_effective_date IN DATE
22901: ,p_datetrack_update_mode IN VARCHAR2
22902: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22903: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22904: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
22905: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
22906: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22907: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

Line 22905: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE

22901: ,p_datetrack_update_mode IN VARCHAR2
22902: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22903: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22904: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
22905: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
22906: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22907: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22908: )
22909: IS

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

22902: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22903: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22904: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
22905: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
22906: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22907: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22908: )
22909: IS
22910: --

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

22903: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22904: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
22905: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
22906: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22907: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22908: )
22909: IS
22910: --
22911: -- Local variables

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

22913: l_proc VARCHAR2(72);
22914: --
22915: l_effective_date DATE;
22916: --
22917: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
22918: --
22919: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'INTERVIEW1';
22920: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
22921: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

Line 22920: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

22916: --
22917: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
22918: --
22919: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'INTERVIEW1';
22920: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
22921: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
22922: --
22923: lv_object_version_number number := p_object_version_number ;
22924: --

Line 22921: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

22917: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
22918: --
22919: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'INTERVIEW1';
22920: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
22921: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
22922: --
22923: lv_object_version_number number := p_object_version_number ;
22924: --
22925: BEGIN

Line 23066: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

23062: PROCEDURE interview2_apl_asg
23063: (p_validate IN BOOLEAN
23064: ,p_effective_date IN DATE
23065: ,p_datetrack_update_mode IN VARCHAR2
23066: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23067: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23068: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
23069: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
23070: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

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

23063: (p_validate IN BOOLEAN
23064: ,p_effective_date IN DATE
23065: ,p_datetrack_update_mode IN VARCHAR2
23066: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23067: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23068: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
23069: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
23070: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23071: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

Line 23069: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE

23065: ,p_datetrack_update_mode IN VARCHAR2
23066: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23067: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23068: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
23069: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
23070: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23071: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
23072: )
23073: IS

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

23066: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23067: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23068: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
23069: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
23070: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23071: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
23072: )
23073: IS
23074: --

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

23067: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23068: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
23069: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
23070: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23071: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
23072: )
23073: IS
23074: --
23075: -- Local variables

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

23077: l_proc VARCHAR2(72);
23078: --
23079: l_effective_date DATE;
23080: --
23081: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
23082: --
23083: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'INTERVIEW2';
23084: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
23085: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

Line 23084: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

23080: --
23081: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
23082: --
23083: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'INTERVIEW2';
23084: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
23085: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
23086: --
23087: lv_object_version_number number := p_object_version_number ;
23088: --

Line 23085: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

23081: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
23082: --
23083: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'INTERVIEW2';
23084: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
23085: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
23086: --
23087: lv_object_version_number number := p_object_version_number ;
23088: --
23089: BEGIN

Line 23231: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

23227: PROCEDURE delete_assignment
23228: (p_validate IN boolean default false
23229: ,p_effective_date IN DATE
23230: ,p_datetrack_mode IN VARCHAR2
23231: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23232: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23233: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23234: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
23235: ,p_loc_change_tax_issues OUT NOCOPY boolean

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

23228: (p_validate IN boolean default false
23229: ,p_effective_date IN DATE
23230: ,p_datetrack_mode IN VARCHAR2
23231: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23232: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23233: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23234: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
23235: ,p_loc_change_tax_issues OUT NOCOPY boolean
23236: ,p_delete_asg_budgets OUT NOCOPY boolean

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

23229: ,p_effective_date IN DATE
23230: ,p_datetrack_mode IN VARCHAR2
23231: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23232: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23233: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23234: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
23235: ,p_loc_change_tax_issues OUT NOCOPY boolean
23236: ,p_delete_asg_budgets OUT NOCOPY boolean
23237: ,p_org_now_no_manager_warning OUT NOCOPY boolean

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

23230: ,p_datetrack_mode IN VARCHAR2
23231: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23232: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23233: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23234: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
23235: ,p_loc_change_tax_issues OUT NOCOPY boolean
23236: ,p_delete_asg_budgets OUT NOCOPY boolean
23237: ,p_org_now_no_manager_warning OUT NOCOPY boolean
23238: ,p_element_salary_warning OUT NOCOPY boolean

Line 23254: from per_all_assignments_f

23250: asg_type varchar2(10);
23251: --
23252: cursor get_asgt_type is
23253: select assignment_type
23254: from per_all_assignments_f
23255: where assignment_id = p_assignment_id
23256: and p_effective_date between effective_start_date and effective_end_date;
23257: --
23258: BEGIN