APPS.HR_ASSIGNMENT_INTERNAL dependencies on PER_ASSIGNMENTS_F

Line 46: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;

42: ) return date is
43: --
44: -- Declare cursors and local variables
45: --
46: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
47: l_proc varchar2(72)
48: := g_package || 'get_max_asg_fut_change_end_dt';
49: --
50: cursor csr_get_max_asg_end_date is

Line 52: from per_assignments_f asg

48: := g_package || 'get_max_asg_fut_change_end_dt';
49: --
50: cursor csr_get_max_asg_end_date is
51: select max(asg.effective_end_date)
52: from per_assignments_f asg
53: where asg.assignment_id = p_assignment_id
54: and asg.effective_start_date > p_effective_date;
55: --
56: begin

Line 97: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

93: --
94: -- Out variables
95: --
96: l_asg_future_changes_warning boolean := FALSE;
97: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
98: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
99: l_entries_changed_warning varchar2(1) := 'N';
100: l_object_version_number per_assignments_f.object_version_number%TYPE;
101: --

Line 98: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

94: -- Out variables
95: --
96: l_asg_future_changes_warning boolean := FALSE;
97: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
98: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
99: l_entries_changed_warning varchar2(1) := 'N';
100: l_object_version_number per_assignments_f.object_version_number%TYPE;
101: --
102: l_business_group_id per_assignments_f.business_group_id%TYPE;

Line 100: l_object_version_number per_assignments_f.object_version_number%TYPE;

96: l_asg_future_changes_warning boolean := FALSE;
97: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
98: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
99: l_entries_changed_warning varchar2(1) := 'N';
100: l_object_version_number per_assignments_f.object_version_number%TYPE;
101: --
102: l_business_group_id per_assignments_f.business_group_id%TYPE;
103: l_comment_id per_assignments_f.comment_id%TYPE;
104: l_correction boolean;

Line 102: l_business_group_id per_assignments_f.business_group_id%TYPE;

98: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
99: l_entries_changed_warning varchar2(1) := 'N';
100: l_object_version_number per_assignments_f.object_version_number%TYPE;
101: --
102: l_business_group_id per_assignments_f.business_group_id%TYPE;
103: l_comment_id per_assignments_f.comment_id%TYPE;
104: l_correction boolean;
105: l_datetrack_mode varchar2(30);
106: l_entries_changed varchar2(1);

Line 103: l_comment_id per_assignments_f.comment_id%TYPE;

99: l_entries_changed_warning varchar2(1) := 'N';
100: l_object_version_number per_assignments_f.object_version_number%TYPE;
101: --
102: l_business_group_id per_assignments_f.business_group_id%TYPE;
103: l_comment_id per_assignments_f.comment_id%TYPE;
104: l_correction boolean;
105: l_datetrack_mode varchar2(30);
106: l_entries_changed varchar2(1);
107: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 108: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;

104: l_correction boolean;
105: l_datetrack_mode varchar2(30);
106: l_entries_changed varchar2(1);
107: l_legislation_code per_business_groups.legislation_code%TYPE;
108: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
109: l_no_managers_warning boolean;
110: l_org_now_no_manager_warning boolean;
111: l_pay_proposal_warning boolean := FALSE; -- Bug 3202260
112: l_other_manager_warning boolean;

Line 137: from per_assignments_f asg

133: cursor csr_asg_values (l_effective_date date) is
134: select asg.object_version_number
135: , asg.effective_start_date
136: , asg.effective_end_date
137: from per_assignments_f asg
138: where asg.assignment_id = p_assignment_id
139: and l_effective_date between asg.effective_start_date
140: and asg.effective_end_date;
141: --

Line 146: from per_assignments_f asg

142: cursor csr_get_future_asg (l_effective_date date) is
143: select asg.object_version_number
144: , asg.effective_start_date
145: , asg.effective_end_date
146: from per_assignments_f asg
147: where asg.assignment_id = p_assignment_id
148: and asg.effective_start_date >= l_effective_date;
149: --
150: cursor csr_lock_alu is

Line 507: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

503: --
504: -- Out variables
505: --
506: l_asg_future_changes_warning boolean := FALSE;
507: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
508: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
509: l_entries_changed_warning varchar2(1) := 'N';
510: l_object_version_number per_assignments_f.object_version_number%TYPE;
511: l_org_now_no_manager_warning boolean := FALSE;

Line 508: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

504: -- Out variables
505: --
506: l_asg_future_changes_warning boolean := FALSE;
507: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
508: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
509: l_entries_changed_warning varchar2(1) := 'N';
510: l_object_version_number per_assignments_f.object_version_number%TYPE;
511: l_org_now_no_manager_warning boolean := FALSE;
512: --

Line 510: l_object_version_number per_assignments_f.object_version_number%TYPE;

506: l_asg_future_changes_warning boolean := FALSE;
507: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
508: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
509: l_entries_changed_warning varchar2(1) := 'N';
510: l_object_version_number per_assignments_f.object_version_number%TYPE;
511: l_org_now_no_manager_warning boolean := FALSE;
512: --
513: l_business_group_id per_assignments_f.business_group_id%TYPE;
514: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 513: l_business_group_id per_assignments_f.business_group_id%TYPE;

509: l_entries_changed_warning varchar2(1) := 'N';
510: l_object_version_number per_assignments_f.object_version_number%TYPE;
511: l_org_now_no_manager_warning boolean := FALSE;
512: --
513: l_business_group_id per_assignments_f.business_group_id%TYPE;
514: l_legislation_code per_business_groups.legislation_code%TYPE;
515: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
516: l_proc varchar2(72) :=
517: g_package || 'final_process_cwk_asg';

Line 515: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;

511: l_org_now_no_manager_warning boolean := FALSE;
512: --
513: l_business_group_id per_assignments_f.business_group_id%TYPE;
514: l_legislation_code per_business_groups.legislation_code%TYPE;
515: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
516: l_proc varchar2(72) :=
517: g_package || 'final_process_cwk_asg';
518: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
519: l_validation_end_date per_assignments_f.effective_end_date%TYPE;

Line 518: l_validation_start_date per_assignments_f.effective_start_date%TYPE;

514: l_legislation_code per_business_groups.legislation_code%TYPE;
515: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
516: l_proc varchar2(72) :=
517: g_package || 'final_process_cwk_asg';
518: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
519: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
520: l_status varchar2(2);
521: --
522: --

Line 519: l_validation_end_date per_assignments_f.effective_end_date%TYPE;

515: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
516: l_proc varchar2(72) :=
517: g_package || 'final_process_cwk_asg';
518: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
519: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
520: l_status varchar2(2);
521: --
522: --
523: cursor csr_get_busgrp_legislation is

Line 527: per_assignments_f asg

523: cursor csr_get_busgrp_legislation is
524: select pbg.business_group_id, pbg.legislation_code
525: from per_business_groups_perf pbg
526: where pbg.business_group_id = (select distinct asg.business_group_id from
527: per_assignments_f asg
528: where asg.assignment_id = p_assignment_id);
529:
530: --
531: --

Line 970: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

966: --
967: -- Out variables
968: --
969: l_asg_future_changes_warning boolean := FALSE;
970: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
971: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
972: l_entries_changed_warning varchar2(1) := 'N';
973: l_object_version_number per_assignments_f.object_version_number%TYPE;
974: --

Line 971: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

967: -- Out variables
968: --
969: l_asg_future_changes_warning boolean := FALSE;
970: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
971: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
972: l_entries_changed_warning varchar2(1) := 'N';
973: l_object_version_number per_assignments_f.object_version_number%TYPE;
974: --
975: -- 115.66 (START)

Line 973: l_object_version_number per_assignments_f.object_version_number%TYPE;

969: l_asg_future_changes_warning boolean := FALSE;
970: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
971: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
972: l_entries_changed_warning varchar2(1) := 'N';
973: l_object_version_number per_assignments_f.object_version_number%TYPE;
974: --
975: -- 115.66 (START)
976: --
977: l_alu_change_warning varchar2(1) := 'N';

Line 982: l_business_group_id per_assignments_f.business_group_id%TYPE;

978: --
979: -- 115.66 (END)
980: --
981: --
982: l_business_group_id per_assignments_f.business_group_id%TYPE;
983: l_comment_id per_assignments_f.comment_id%TYPE;
984: l_correction boolean;
985: l_datetrack_mode varchar2(30);
986: l_entries_changed varchar2(1);

Line 983: l_comment_id per_assignments_f.comment_id%TYPE;

979: -- 115.66 (END)
980: --
981: --
982: l_business_group_id per_assignments_f.business_group_id%TYPE;
983: l_comment_id per_assignments_f.comment_id%TYPE;
984: l_correction boolean;
985: l_datetrack_mode varchar2(30);
986: l_entries_changed varchar2(1);
987: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 988: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;

984: l_correction boolean;
985: l_datetrack_mode varchar2(30);
986: l_entries_changed varchar2(1);
987: l_legislation_code per_business_groups.legislation_code%TYPE;
988: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
989: l_no_managers_warning boolean;
990: l_org_now_no_manager_warning boolean;
991: l_pay_proposal_warning boolean := FALSE; -- Bug 3202260
992: l_other_manager_warning boolean;

Line 1017: from per_assignments_f asg

1013: cursor csr_asg_values (l_effective_date date) is
1014: select asg.object_version_number
1015: , asg.effective_start_date
1016: , asg.effective_end_date
1017: from per_assignments_f asg
1018: where asg.assignment_id = p_assignment_id
1019: and l_effective_date between asg.effective_start_date
1020: and asg.effective_end_date;
1021: --

Line 1026: from per_assignments_f asg

1022: cursor csr_get_future_asg (l_effective_date date) is
1023: select asg.object_version_number
1024: , asg.effective_start_date
1025: , asg.effective_end_date
1026: from per_assignments_f asg
1027: where asg.assignment_id = p_assignment_id
1028: and asg.effective_start_date >= l_effective_date;
1029: --
1030: cursor csr_lock_alu is

Line 1080: l_effective_end_date1 per_assignments_f.effective_end_date%TYPE;

1076: -- End of 3202260
1077:
1078: --start of bug 5026287
1079: /*commented the changes for bug 5026287
1080: l_effective_end_date1 per_assignments_f.effective_end_date%TYPE;
1081: l_effective_start_date1 per_assignments_f.effective_start_date%TYPE;
1082: l_object_version_number1 per_assignments_f.object_version_number%TYPE;*/
1083: --end of bug 5026287
1084:

Line 1081: l_effective_start_date1 per_assignments_f.effective_start_date%TYPE;

1077:
1078: --start of bug 5026287
1079: /*commented the changes for bug 5026287
1080: l_effective_end_date1 per_assignments_f.effective_end_date%TYPE;
1081: l_effective_start_date1 per_assignments_f.effective_start_date%TYPE;
1082: l_object_version_number1 per_assignments_f.object_version_number%TYPE;*/
1083: --end of bug 5026287
1084:
1085: begin

Line 1082: l_object_version_number1 per_assignments_f.object_version_number%TYPE;*/

1078: --start of bug 5026287
1079: /*commented the changes for bug 5026287
1080: l_effective_end_date1 per_assignments_f.effective_end_date%TYPE;
1081: l_effective_start_date1 per_assignments_f.effective_start_date%TYPE;
1082: l_object_version_number1 per_assignments_f.object_version_number%TYPE;*/
1083: --end of bug 5026287
1084:
1085: begin
1086: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 1555: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

1551: l_time_normal_start per_business_groups.default_start_time%TYPE;
1552: l_normal_hours number;
1553: l_frequency per_business_groups.frequency%TYPE;
1554: l_legislation_code per_business_groups.legislation_code%TYPE;
1555: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1556: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
1557: l_assignment_number per_assignments_f.assignment_number%TYPE;
1558: l_comment_id per_assignments_f.comment_id%TYPE;
1559: l_other_manager_warning boolean;

Line 1556: l_effective_end_date per_assignments_f.effective_start_date%TYPE;

1552: l_normal_hours number;
1553: l_frequency per_business_groups.frequency%TYPE;
1554: l_legislation_code per_business_groups.legislation_code%TYPE;
1555: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1556: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
1557: l_assignment_number per_assignments_f.assignment_number%TYPE;
1558: l_comment_id per_assignments_f.comment_id%TYPE;
1559: l_other_manager_warning boolean;
1560: l_proc varchar2(72):=g_package||'create_default_emp_asg';

Line 1557: l_assignment_number per_assignments_f.assignment_number%TYPE;

1553: l_frequency per_business_groups.frequency%TYPE;
1554: l_legislation_code per_business_groups.legislation_code%TYPE;
1555: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1556: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
1557: l_assignment_number per_assignments_f.assignment_number%TYPE;
1558: l_comment_id per_assignments_f.comment_id%TYPE;
1559: l_other_manager_warning boolean;
1560: l_proc varchar2(72):=g_package||'create_default_emp_asg';
1561: --

Line 1558: l_comment_id per_assignments_f.comment_id%TYPE;

1554: l_legislation_code per_business_groups.legislation_code%TYPE;
1555: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1556: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
1557: l_assignment_number per_assignments_f.assignment_number%TYPE;
1558: l_comment_id per_assignments_f.comment_id%TYPE;
1559: l_other_manager_warning boolean;
1560: l_proc varchar2(72):=g_package||'create_default_emp_asg';
1561: --
1562: cursor csr_get_default_details is

Line 1746: l_assignment_id per_assignments_f.assignment_id%TYPE;

1742: ) is
1743: --
1744: -- Declare cursors and local variables
1745: --
1746: l_assignment_id per_assignments_f.assignment_id%TYPE;
1747: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
1748: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1749: l_entries_changed varchar2(1);
1750: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

Line 1747: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;

1743: --
1744: -- Declare cursors and local variables
1745: --
1746: l_assignment_id per_assignments_f.assignment_id%TYPE;
1747: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
1748: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1749: l_entries_changed varchar2(1);
1750: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1751: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

Line 1748: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

1744: -- Declare cursors and local variables
1745: --
1746: l_assignment_id per_assignments_f.assignment_id%TYPE;
1747: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
1748: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1749: l_entries_changed varchar2(1);
1750: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1751: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1752: l_proc varchar2(72) := g_package||'create_emp_asg';

Line 1750: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

1746: l_assignment_id per_assignments_f.assignment_id%TYPE;
1747: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
1748: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1749: l_entries_changed varchar2(1);
1750: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1751: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1752: l_proc varchar2(72) := g_package||'create_emp_asg';
1753: l_hourly_salaried_warning boolean;
1754: l_object_version_number per_assignments_f.object_version_number%TYPE;

Line 1751: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

1747: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
1748: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1749: l_entries_changed varchar2(1);
1750: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1751: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1752: l_proc varchar2(72) := g_package||'create_emp_asg';
1753: l_hourly_salaried_warning boolean;
1754: l_object_version_number per_assignments_f.object_version_number%TYPE;
1755:

Line 1754: l_object_version_number per_assignments_f.object_version_number%TYPE;

1750: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1751: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1752: l_proc varchar2(72) := g_package||'create_emp_asg';
1753: l_hourly_salaried_warning boolean;
1754: l_object_version_number per_assignments_f.object_version_number%TYPE;
1755:
1756: --
1757: begin
1758: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 1972: l_assignment_id per_assignments_f.assignment_id%TYPE;

1968: ) is
1969: --
1970: -- Declare cursors and local variables
1971: --
1972: l_assignment_id per_assignments_f.assignment_id%TYPE;
1973: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
1974: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1975: l_entries_changed varchar2(1);
1976: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

Line 1973: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;

1969: --
1970: -- Declare cursors and local variables
1971: --
1972: l_assignment_id per_assignments_f.assignment_id%TYPE;
1973: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
1974: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1975: l_entries_changed varchar2(1);
1976: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1977: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

Line 1974: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

1970: -- Declare cursors and local variables
1971: --
1972: l_assignment_id per_assignments_f.assignment_id%TYPE;
1973: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
1974: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1975: l_entries_changed varchar2(1);
1976: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1977: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1978: l_proc varchar2(72) := g_package||'create_emp_asg';

Line 1976: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

1972: l_assignment_id per_assignments_f.assignment_id%TYPE;
1973: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
1974: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1975: l_entries_changed varchar2(1);
1976: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1977: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1978: l_proc varchar2(72) := g_package||'create_emp_asg';
1979: l_labour_union_member_flag per_assignments_f.labour_union_member_flag%TYPE;
1980: --

Line 1977: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

1973: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
1974: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1975: l_entries_changed varchar2(1);
1976: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1977: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1978: l_proc varchar2(72) := g_package||'create_emp_asg';
1979: l_labour_union_member_flag per_assignments_f.labour_union_member_flag%TYPE;
1980: --
1981: begin

Line 1979: l_labour_union_member_flag per_assignments_f.labour_union_member_flag%TYPE;

1975: l_entries_changed varchar2(1);
1976: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1977: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1978: l_proc varchar2(72) := g_package||'create_emp_asg';
1979: l_labour_union_member_flag per_assignments_f.labour_union_member_flag%TYPE;
1980: --
1981: begin
1982: hr_utility.set_location('Entering:'|| l_proc, 1);
1983: --

Line 2012: -- Insert per_assignments_f row.

2008: );
2009: --
2010: hr_utility.set_location(l_proc, 10);
2011: --
2012: -- Insert per_assignments_f row.
2013: --
2014: per_asg_ins.ins
2015: (p_assignment_id => l_assignment_id
2016: ,p_effective_start_date => l_effective_start_date

Line 2182: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

2178: --
2179: -- Out variables
2180: --
2181: l_asg_future_changes_warning boolean := FALSE;
2182: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
2183: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
2184: l_entries_changed_warning varchar2(1) := 'N';
2185: --
2186: -- 115.66 (START)

Line 2183: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

2179: -- Out variables
2180: --
2181: l_asg_future_changes_warning boolean := FALSE;
2182: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
2183: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
2184: l_entries_changed_warning varchar2(1) := 'N';
2185: --
2186: -- 115.66 (START)
2187: --

Line 2192: l_object_version_number per_assignments_f.object_version_number%TYPE;

2188: l_alu_change_warning varchar2(1) := 'N';
2189: --
2190: -- 115.66 (END)
2191: --
2192: l_object_version_number per_assignments_f.object_version_number%TYPE;
2193: l_org_now_no_manager_warning boolean := FALSE;
2194: --surendra
2195: --
2196: l_loc_change_tax_issues boolean;

Line 2204: l_business_group_id per_assignments_f.business_group_id%TYPE;

2200: l_spp_warning boolean;
2201: l_cost_warning boolean;
2202: l_life_events_exists boolean;
2203: --
2204: l_business_group_id per_assignments_f.business_group_id%TYPE;
2205: l_legislation_code per_business_groups.legislation_code%TYPE;
2206: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
2207: l_proc varchar2(72) :=
2208: g_package || 'final_process_emp_asg_sup';

Line 2206: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;

2202: l_life_events_exists boolean;
2203: --
2204: l_business_group_id per_assignments_f.business_group_id%TYPE;
2205: l_legislation_code per_business_groups.legislation_code%TYPE;
2206: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
2207: l_proc varchar2(72) :=
2208: g_package || 'final_process_emp_asg_sup';
2209: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
2210: l_validation_end_date per_assignments_f.effective_end_date%TYPE;

Line 2209: l_validation_start_date per_assignments_f.effective_start_date%TYPE;

2205: l_legislation_code per_business_groups.legislation_code%TYPE;
2206: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
2207: l_proc varchar2(72) :=
2208: g_package || 'final_process_emp_asg_sup';
2209: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
2210: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
2211: l_status varchar2(2);
2212: --
2213: --

Line 2210: l_validation_end_date per_assignments_f.effective_end_date%TYPE;

2206: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
2207: l_proc varchar2(72) :=
2208: g_package || 'final_process_emp_asg_sup';
2209: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
2210: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
2211: l_status varchar2(2);
2212: --
2213: --
2214: cursor csr_get_busgrp_legislation is

Line 2218: per_assignments_f asg

2214: cursor csr_get_busgrp_legislation is
2215: select pbg.business_group_id, pbg.legislation_code
2216: from per_business_groups_perf pbg
2217: where pbg.business_group_id = (select distinct asg.business_group_id from
2218: per_assignments_f asg
2219: where asg.assignment_id = p_assignment_id);
2220: --
2221: --
2222: cursor csr_lock_csa is

Line 2578: (p_assignment_id IN per_assignments_f.assignment_id%TYPE) IS

2574: -- |--------------------------------< SPP_ZAP >--------------------------------|
2575: -- ----------------------------------------------------------------------------
2576: --
2577: PROCEDURE spp_zap
2578: (p_assignment_id IN per_assignments_f.assignment_id%TYPE) IS
2579: --
2580: -- Declare Local Variables
2581: --
2582: l_proc VARCHAR2(72) := g_package||'spp_zap';

Line 2634: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

2630: -- |-----------------------< SPP_UPDATE_CHANGE_INSERT >-----------------------|
2631: -- ----------------------------------------------------------------------------
2632: --
2633: PROCEDURE spp_update_change_insert
2634: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2635: ,p_placement_id IN per_spinal_point_placements_f.placement_id%TYPE
2636: ,p_validation_start_date IN DATE
2637: ,p_validation_end_date IN DATE
2638: ,p_spp_eff_start_date IN DATE

Line 4600: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

4596: -- Declare cursors and local variables
4597: --
4598: -- Out variables
4599: --
4600: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
4601: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
4602: l_object_version_number per_assignments_f.object_version_number%TYPE;
4603: --
4604: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

Line 4601: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

4597: --
4598: -- Out variables
4599: --
4600: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
4601: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
4602: l_object_version_number per_assignments_f.object_version_number%TYPE;
4603: --
4604: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4605: l_assignment_type per_assignments_f.assignment_type%TYPE;

Line 4602: l_object_version_number per_assignments_f.object_version_number%TYPE;

4598: -- Out variables
4599: --
4600: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
4601: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
4602: l_object_version_number per_assignments_f.object_version_number%TYPE;
4603: --
4604: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4605: l_assignment_type per_assignments_f.assignment_type%TYPE;
4606: l_business_group_id per_assignments_f.business_group_id%TYPE;

Line 4604: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

4600: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
4601: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
4602: l_object_version_number per_assignments_f.object_version_number%TYPE;
4603: --
4604: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4605: l_assignment_type per_assignments_f.assignment_type%TYPE;
4606: l_business_group_id per_assignments_f.business_group_id%TYPE;
4607: l_comment_id per_assignments_f.comment_id%TYPE;
4608: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 4605: l_assignment_type per_assignments_f.assignment_type%TYPE;

4601: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
4602: l_object_version_number per_assignments_f.object_version_number%TYPE;
4603: --
4604: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4605: l_assignment_type per_assignments_f.assignment_type%TYPE;
4606: l_business_group_id per_assignments_f.business_group_id%TYPE;
4607: l_comment_id per_assignments_f.comment_id%TYPE;
4608: l_legislation_code per_business_groups.legislation_code%TYPE;
4609: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

Line 4606: l_business_group_id per_assignments_f.business_group_id%TYPE;

4602: l_object_version_number per_assignments_f.object_version_number%TYPE;
4603: --
4604: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4605: l_assignment_type per_assignments_f.assignment_type%TYPE;
4606: l_business_group_id per_assignments_f.business_group_id%TYPE;
4607: l_comment_id per_assignments_f.comment_id%TYPE;
4608: l_legislation_code per_business_groups.legislation_code%TYPE;
4609: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4610: l_no_managers_warning boolean;

Line 4607: l_comment_id per_assignments_f.comment_id%TYPE;

4603: --
4604: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4605: l_assignment_type per_assignments_f.assignment_type%TYPE;
4606: l_business_group_id per_assignments_f.business_group_id%TYPE;
4607: l_comment_id per_assignments_f.comment_id%TYPE;
4608: l_legislation_code per_business_groups.legislation_code%TYPE;
4609: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4610: l_no_managers_warning boolean;
4611: l_other_manager_warning boolean;

Line 4615: l_validation_start_date per_assignments_f.effective_start_date%TYPE;

4611: l_other_manager_warning boolean;
4612: l_hourly_salaried_warning boolean;
4613: l_payroll_id_updated boolean;
4614: l_org_now_no_manager_warning boolean;
4615: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
4616: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
4617: l_proc varchar2(72):=
4618: g_package||'update_status_type_cwk_asg';
4619: --

Line 4616: l_validation_end_date per_assignments_f.effective_end_date%TYPE;

4612: l_hourly_salaried_warning boolean;
4613: l_payroll_id_updated boolean;
4614: l_org_now_no_manager_warning boolean;
4615: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
4616: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
4617: l_proc varchar2(72):=
4618: g_package||'update_status_type_cwk_asg';
4619: --
4620: cursor csr_get_asg_dets is

Line 4624: from per_assignments_f asg

4620: cursor csr_get_asg_dets is
4621: select asg.assignment_type
4622: , asg.business_group_id
4623: , bus.legislation_code
4624: from per_assignments_f asg
4625: , per_business_groups_perf bus
4626: where asg.assignment_id = p_assignment_id
4627: and p_effective_date between asg.effective_start_date
4628: and asg.effective_end_date

Line 4765: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

4761: -- Declare cursors and local variables
4762: --
4763: -- Out variables
4764: --
4765: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
4766: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
4767: l_object_version_number per_assignments_f.object_version_number%TYPE;
4768: --
4769: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

Line 4766: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

4762: --
4763: -- Out variables
4764: --
4765: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
4766: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
4767: l_object_version_number per_assignments_f.object_version_number%TYPE;
4768: --
4769: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4770: l_assignment_type per_assignments_f.assignment_type%TYPE;

Line 4767: l_object_version_number per_assignments_f.object_version_number%TYPE;

4763: -- Out variables
4764: --
4765: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
4766: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
4767: l_object_version_number per_assignments_f.object_version_number%TYPE;
4768: --
4769: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4770: l_assignment_type per_assignments_f.assignment_type%TYPE;
4771: l_business_group_id per_assignments_f.business_group_id%TYPE;

Line 4769: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

4765: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
4766: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
4767: l_object_version_number per_assignments_f.object_version_number%TYPE;
4768: --
4769: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4770: l_assignment_type per_assignments_f.assignment_type%TYPE;
4771: l_business_group_id per_assignments_f.business_group_id%TYPE;
4772: l_comment_id per_assignments_f.comment_id%TYPE;
4773: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 4770: l_assignment_type per_assignments_f.assignment_type%TYPE;

4766: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
4767: l_object_version_number per_assignments_f.object_version_number%TYPE;
4768: --
4769: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4770: l_assignment_type per_assignments_f.assignment_type%TYPE;
4771: l_business_group_id per_assignments_f.business_group_id%TYPE;
4772: l_comment_id per_assignments_f.comment_id%TYPE;
4773: l_legislation_code per_business_groups.legislation_code%TYPE;
4774: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

Line 4771: l_business_group_id per_assignments_f.business_group_id%TYPE;

4767: l_object_version_number per_assignments_f.object_version_number%TYPE;
4768: --
4769: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4770: l_assignment_type per_assignments_f.assignment_type%TYPE;
4771: l_business_group_id per_assignments_f.business_group_id%TYPE;
4772: l_comment_id per_assignments_f.comment_id%TYPE;
4773: l_legislation_code per_business_groups.legislation_code%TYPE;
4774: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4775: l_no_managers_warning boolean;

Line 4772: l_comment_id per_assignments_f.comment_id%TYPE;

4768: --
4769: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4770: l_assignment_type per_assignments_f.assignment_type%TYPE;
4771: l_business_group_id per_assignments_f.business_group_id%TYPE;
4772: l_comment_id per_assignments_f.comment_id%TYPE;
4773: l_legislation_code per_business_groups.legislation_code%TYPE;
4774: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4775: l_no_managers_warning boolean;
4776: l_other_manager_warning boolean;

Line 4780: l_validation_start_date per_assignments_f.effective_start_date%TYPE;

4776: l_other_manager_warning boolean;
4777: l_hourly_salaried_warning boolean;
4778: l_payroll_id_updated boolean;
4779: l_org_now_no_manager_warning boolean;
4780: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
4781: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
4782: l_proc varchar2(72):=
4783: g_package||'update_status_type_emp_asg';
4784: --

Line 4781: l_validation_end_date per_assignments_f.effective_end_date%TYPE;

4777: l_hourly_salaried_warning boolean;
4778: l_payroll_id_updated boolean;
4779: l_org_now_no_manager_warning boolean;
4780: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
4781: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
4782: l_proc varchar2(72):=
4783: g_package||'update_status_type_emp_asg';
4784: --
4785: cursor csr_get_asg_dets is

Line 4789: from per_assignments_f asg

4785: cursor csr_get_asg_dets is
4786: select asg.assignment_type
4787: , asg.business_group_id
4788: , bus.legislation_code
4789: from per_assignments_f asg
4790: , per_business_groups_perf bus
4791: where asg.assignment_id = p_assignment_id
4792: and p_effective_date between asg.effective_start_date
4793: and asg.effective_end_date

Line 5017: l_assignment_id per_assignments_f.assignment_id%TYPE;

5013: -- Declare cursors and local variables
5014: --
5015: l_assignment_status_id number;
5016: l_asg_status_ovn number;
5017: l_assignment_id per_assignments_f.assignment_id%TYPE;
5018: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5019: l_object_version_number per_assignments_f.object_version_number%TYPE;
5020: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5021: l_assignment_number per_assignments_f.assignment_number%TYPE;

Line 5018: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;

5014: --
5015: l_assignment_status_id number;
5016: l_asg_status_ovn number;
5017: l_assignment_id per_assignments_f.assignment_id%TYPE;
5018: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5019: l_object_version_number per_assignments_f.object_version_number%TYPE;
5020: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5021: l_assignment_number per_assignments_f.assignment_number%TYPE;
5022: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

Line 5019: l_object_version_number per_assignments_f.object_version_number%TYPE;

5015: l_assignment_status_id number;
5016: l_asg_status_ovn number;
5017: l_assignment_id per_assignments_f.assignment_id%TYPE;
5018: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5019: l_object_version_number per_assignments_f.object_version_number%TYPE;
5020: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5021: l_assignment_number per_assignments_f.assignment_number%TYPE;
5022: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5023: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

Line 5020: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

5016: l_asg_status_ovn number;
5017: l_assignment_id per_assignments_f.assignment_id%TYPE;
5018: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5019: l_object_version_number per_assignments_f.object_version_number%TYPE;
5020: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5021: l_assignment_number per_assignments_f.assignment_number%TYPE;
5022: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5023: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5024: l_comment_id per_assignments_f.comment_id%TYPE;

Line 5021: l_assignment_number per_assignments_f.assignment_number%TYPE;

5017: l_assignment_id per_assignments_f.assignment_id%TYPE;
5018: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5019: l_object_version_number per_assignments_f.object_version_number%TYPE;
5020: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5021: l_assignment_number per_assignments_f.assignment_number%TYPE;
5022: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5023: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5024: l_comment_id per_assignments_f.comment_id%TYPE;
5025: l_other_manager_warning boolean;

Line 5022: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

5018: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5019: l_object_version_number per_assignments_f.object_version_number%TYPE;
5020: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5021: l_assignment_number per_assignments_f.assignment_number%TYPE;
5022: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5023: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5024: l_comment_id per_assignments_f.comment_id%TYPE;
5025: l_other_manager_warning boolean;
5026: l_hourly_salaried_warning boolean;

Line 5023: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

5019: l_object_version_number per_assignments_f.object_version_number%TYPE;
5020: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5021: l_assignment_number per_assignments_f.assignment_number%TYPE;
5022: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5023: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5024: l_comment_id per_assignments_f.comment_id%TYPE;
5025: l_other_manager_warning boolean;
5026: l_hourly_salaried_warning boolean;
5027: l_proc varchar2(72) := g_package||'create_apl_asg';

Line 5024: l_comment_id per_assignments_f.comment_id%TYPE;

5020: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5021: l_assignment_number per_assignments_f.assignment_number%TYPE;
5022: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5023: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5024: l_comment_id per_assignments_f.comment_id%TYPE;
5025: l_other_manager_warning boolean;
5026: l_hourly_salaried_warning boolean;
5027: l_proc varchar2(72) := g_package||'create_apl_asg';
5028: l_labour_union_member_flag per_assignments_f.labour_union_member_flag%TYPE;

Line 5028: l_labour_union_member_flag per_assignments_f.labour_union_member_flag%TYPE;

5024: l_comment_id per_assignments_f.comment_id%TYPE;
5025: l_other_manager_warning boolean;
5026: l_hourly_salaried_warning boolean;
5027: l_proc varchar2(72) := g_package||'create_apl_asg';
5028: l_labour_union_member_flag per_assignments_f.labour_union_member_flag%TYPE;
5029: begin
5030: --
5031: hr_utility.set_location(l_proc, 10);
5032: -- fix for bug 4550165 starts here.

Line 5070: -- Insert per_assignments_f row.

5066: hr_utility.set_location(l_proc, 20);
5067: --
5068: l_assignment_number := null;
5069: --
5070: -- Insert per_assignments_f row.
5071: --
5072: per_asg_ins.ins
5073: (p_assignment_id => l_assignment_id
5074: ,p_effective_start_date => l_effective_start_date

Line 5254: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

5250: l_time_normal_start per_business_groups.default_start_time%TYPE;
5251: l_normal_hours number;
5252: l_frequency per_business_groups.frequency%TYPE;
5253: l_legislation_code per_business_groups.legislation_code%TYPE;
5254: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5255: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
5256: l_assignment_number per_assignments_f.assignment_number%TYPE;
5257: l_comment_id per_assignments_f.comment_id%TYPE;
5258: l_other_manager_warning boolean;

Line 5255: l_effective_end_date per_assignments_f.effective_start_date%TYPE;

5251: l_normal_hours number;
5252: l_frequency per_business_groups.frequency%TYPE;
5253: l_legislation_code per_business_groups.legislation_code%TYPE;
5254: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5255: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
5256: l_assignment_number per_assignments_f.assignment_number%TYPE;
5257: l_comment_id per_assignments_f.comment_id%TYPE;
5258: l_other_manager_warning boolean;
5259: l_proc varchar2(72):=g_package||'create_default_cwk_asg';

Line 5256: l_assignment_number per_assignments_f.assignment_number%TYPE;

5252: l_frequency per_business_groups.frequency%TYPE;
5253: l_legislation_code per_business_groups.legislation_code%TYPE;
5254: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5255: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
5256: l_assignment_number per_assignments_f.assignment_number%TYPE;
5257: l_comment_id per_assignments_f.comment_id%TYPE;
5258: l_other_manager_warning boolean;
5259: l_proc varchar2(72):=g_package||'create_default_cwk_asg';
5260: --

Line 5257: l_comment_id per_assignments_f.comment_id%TYPE;

5253: l_legislation_code per_business_groups.legislation_code%TYPE;
5254: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5255: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
5256: l_assignment_number per_assignments_f.assignment_number%TYPE;
5257: l_comment_id per_assignments_f.comment_id%TYPE;
5258: l_other_manager_warning boolean;
5259: l_proc varchar2(72):=g_package||'create_default_cwk_asg';
5260: --
5261: cursor csr_get_default_details is

Line 5436: l_assignment_id per_assignments_f.assignment_id%TYPE;

5432: ) is
5433: --
5434: -- Declare cursors and local variables
5435: --
5436: l_assignment_id per_assignments_f.assignment_id%TYPE;
5437: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5438: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5439: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5440: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

Line 5437: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;

5433: --
5434: -- Declare cursors and local variables
5435: --
5436: l_assignment_id per_assignments_f.assignment_id%TYPE;
5437: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5438: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5439: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5440: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5441: l_hourly_salaried_warning boolean;

Line 5438: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

5434: -- Declare cursors and local variables
5435: --
5436: l_assignment_id per_assignments_f.assignment_id%TYPE;
5437: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5438: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5439: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5440: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5441: l_hourly_salaried_warning boolean;
5442: l_proc varchar2(72) := g_package||'create_cwk_asg';

Line 5439: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

5435: --
5436: l_assignment_id per_assignments_f.assignment_id%TYPE;
5437: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5438: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5439: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5440: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5441: l_hourly_salaried_warning boolean;
5442: l_proc varchar2(72) := g_package||'create_cwk_asg';
5443: --

Line 5440: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

5436: l_assignment_id per_assignments_f.assignment_id%TYPE;
5437: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5438: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5439: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5440: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5441: l_hourly_salaried_warning boolean;
5442: l_proc varchar2(72) := g_package||'create_cwk_asg';
5443: --
5444: begin

Line 5467: -- Insert per_assignments_f row.

5463: );
5464: --
5465: hr_utility.set_location(l_proc, 10);
5466: --
5467: -- Insert per_assignments_f row.
5468: --
5469: per_asg_ins.ins
5470: (p_validate => p_validate
5471: ,p_effective_date => p_effective_date

Line 5600: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

5596: l_time_normal_start per_business_groups.default_start_time%TYPE;
5597: l_normal_hours number;
5598: l_frequency per_business_groups.frequency%TYPE;
5599: l_legislation_code per_business_groups.legislation_code%TYPE;
5600: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5601: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5602: l_comment_id per_assignments_f.comment_id%TYPE;
5603: l_proc varchar2(72):=g_package||'create_default_apl_asg';
5604: --

Line 5601: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

5597: l_normal_hours number;
5598: l_frequency per_business_groups.frequency%TYPE;
5599: l_legislation_code per_business_groups.legislation_code%TYPE;
5600: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5601: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5602: l_comment_id per_assignments_f.comment_id%TYPE;
5603: l_proc varchar2(72):=g_package||'create_default_apl_asg';
5604: --
5605: cursor csr_get_default_details is

Line 5602: l_comment_id per_assignments_f.comment_id%TYPE;

5598: l_frequency per_business_groups.frequency%TYPE;
5599: l_legislation_code per_business_groups.legislation_code%TYPE;
5600: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5601: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5602: l_comment_id per_assignments_f.comment_id%TYPE;
5603: l_proc varchar2(72):=g_package||'create_default_apl_asg';
5604: --
5605: cursor csr_get_default_details is
5606: select bus.location_id

Line 5734: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

5730: -- Out variables
5731: --
5732: l_assignment_status_id number;
5733: L_ASG_STATUS_OVN number;
5734: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5735: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5736: l_object_version_number per_assignments_f.object_version_number%TYPE;
5737: --
5738: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

Line 5735: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

5731: --
5732: l_assignment_status_id number;
5733: L_ASG_STATUS_OVN number;
5734: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5735: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5736: l_object_version_number per_assignments_f.object_version_number%TYPE;
5737: --
5738: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5739: l_assignment_type per_assignments_f.assignment_type%TYPE;

Line 5736: l_object_version_number per_assignments_f.object_version_number%TYPE;

5732: l_assignment_status_id number;
5733: L_ASG_STATUS_OVN number;
5734: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5735: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5736: l_object_version_number per_assignments_f.object_version_number%TYPE;
5737: --
5738: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5739: l_assignment_type per_assignments_f.assignment_type%TYPE;
5740: l_person_id per_assignments_f.person_id%TYPE;

Line 5738: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

5734: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5735: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5736: l_object_version_number per_assignments_f.object_version_number%TYPE;
5737: --
5738: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5739: l_assignment_type per_assignments_f.assignment_type%TYPE;
5740: l_person_id per_assignments_f.person_id%TYPE;
5741: l_business_group_id per_assignments_f.business_group_id%TYPE;
5742: l_comment_id per_assignments_f.comment_id%TYPE;

Line 5739: l_assignment_type per_assignments_f.assignment_type%TYPE;

5735: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5736: l_object_version_number per_assignments_f.object_version_number%TYPE;
5737: --
5738: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5739: l_assignment_type per_assignments_f.assignment_type%TYPE;
5740: l_person_id per_assignments_f.person_id%TYPE;
5741: l_business_group_id per_assignments_f.business_group_id%TYPE;
5742: l_comment_id per_assignments_f.comment_id%TYPE;
5743: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 5740: l_person_id per_assignments_f.person_id%TYPE;

5736: l_object_version_number per_assignments_f.object_version_number%TYPE;
5737: --
5738: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5739: l_assignment_type per_assignments_f.assignment_type%TYPE;
5740: l_person_id per_assignments_f.person_id%TYPE;
5741: l_business_group_id per_assignments_f.business_group_id%TYPE;
5742: l_comment_id per_assignments_f.comment_id%TYPE;
5743: l_legislation_code per_business_groups.legislation_code%TYPE;
5744: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

Line 5741: l_business_group_id per_assignments_f.business_group_id%TYPE;

5737: --
5738: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5739: l_assignment_type per_assignments_f.assignment_type%TYPE;
5740: l_person_id per_assignments_f.person_id%TYPE;
5741: l_business_group_id per_assignments_f.business_group_id%TYPE;
5742: l_comment_id per_assignments_f.comment_id%TYPE;
5743: l_legislation_code per_business_groups.legislation_code%TYPE;
5744: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
5745: l_no_managers_warning boolean;

Line 5742: l_comment_id per_assignments_f.comment_id%TYPE;

5738: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5739: l_assignment_type per_assignments_f.assignment_type%TYPE;
5740: l_person_id per_assignments_f.person_id%TYPE;
5741: l_business_group_id per_assignments_f.business_group_id%TYPE;
5742: l_comment_id per_assignments_f.comment_id%TYPE;
5743: l_legislation_code per_business_groups.legislation_code%TYPE;
5744: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
5745: l_no_managers_warning boolean;
5746: l_other_manager_warning boolean;

Line 5750: l_validation_start_date per_assignments_f.effective_start_date%TYPE;

5746: l_other_manager_warning boolean;
5747: l_payroll_id_updated boolean;
5748: l_org_now_no_manager_warning boolean;
5749: l_hourly_salaried_warning boolean;
5750: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
5751: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
5752: l_proc varchar2(72):=
5753: g_package||'update_status_type_apl_asg';
5754: l_vacancy_id number;

Line 5751: l_validation_end_date per_assignments_f.effective_end_date%TYPE;

5747: l_payroll_id_updated boolean;
5748: l_org_now_no_manager_warning boolean;
5749: l_hourly_salaried_warning boolean;
5750: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
5751: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
5752: l_proc varchar2(72):=
5753: g_package||'update_status_type_apl_asg';
5754: l_vacancy_id number;
5755: --

Line 5761: from per_assignments_f asg

5757: select asg.assignment_type
5758: , asg.person_id
5759: , asg.business_group_id
5760: , bus.legislation_code
5761: from per_assignments_f asg
5762: , per_business_groups_perf bus
5763: where asg.assignment_id = p_assignment_id
5764: and p_effective_date between asg.effective_start_date
5765: and asg.effective_end_date

Line 6218: per_assignments_f2_pkg.pre_delete(

6214: if g_debug then
6215: hr_utility.set_location('l_re_entry_point :'||l_re_entry_point, 40);
6216: end if;
6217: --
6218: per_assignments_f2_pkg.pre_delete(
6219: p_datetrack_mode, -- p_del_mode,
6220: p_validation_start_date, -- p_val_st_date,
6221: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6222: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,

Line 6319: per_assignments_f2_pkg.key_delrec(

6315: if g_debug then
6316: hr_utility.set_location('Before key_delrec ', 60);
6317: end if;
6318: --
6319: per_assignments_f2_pkg.key_delrec(
6320: p_datetrack_mode, -- l_del_mode,
6321: p_validation_start_date, -- p_val_st_date,
6322: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6323: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,

Line 6338: -- CHECK_TERM_BY_POS changes (called in per_assignments_f2_pkg.key_delrec)

6334: per_asg_shd.g_old_rec.payroll_id, -- p_pay_id,
6335: l_pay_basis_id -- added for bug 4764140
6336: );
6337: --
6338: -- CHECK_TERM_BY_POS changes (called in per_assignments_f2_pkg.key_delrec)
6339: --
6340: declare
6341: l_rec2 per_asg_shd.g_rec_type;
6342: begin

Line 6470: update per_assignments_f a

6466: if g_debug then
6467: hr_utility.set_location('Before updating assignment end date', 30);
6468: end if;
6469: --
6470: update per_assignments_f a
6471: set a.effective_end_date = p_appl_asg_new_end_date
6472: where a.assignment_id = p_rec.assignment_id -- p_assignment_id
6473: and a.effective_end_date = (
6474: select max(a2.effective_end_date)

Line 6475: from per_assignments_f a2

6471: set a.effective_end_date = p_appl_asg_new_end_date
6472: where a.assignment_id = p_rec.assignment_id -- p_assignment_id
6473: and a.effective_end_date = (
6474: select max(a2.effective_end_date)
6475: from per_assignments_f a2
6476: where a2.assignment_id = a.assignment_id);
6477: end if;
6478: --
6479: per_app_asg_pkg.cleanup_letters ( p_rec.assignment_id); -- p_assignment_id );

Line 6494: per_assignments_f1_pkg.post_delete(

6490: if g_debug then
6491: hr_utility.set_location('EMP/CWK type assignment checks ', 40);
6492: end if;
6493: --
6494: per_assignments_f1_pkg.post_delete(
6495: p_rec.assignment_id, -- p_ass_id,
6496: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6497: p_effective_date, -- p_sess_date,
6498: p_new_end_date, -- from pre_del()