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_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 542: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

538: --
539: -- Out variables
540: --
541: l_asg_future_changes_warning boolean := FALSE;
542: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
543: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
544: l_entries_changed_warning varchar2(1) := 'N';
545: l_object_version_number per_assignments_f.object_version_number%TYPE;
546: l_org_now_no_manager_warning boolean := FALSE;

Line 543: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

539: -- Out variables
540: --
541: l_asg_future_changes_warning boolean := FALSE;
542: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
543: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
544: l_entries_changed_warning varchar2(1) := 'N';
545: l_object_version_number per_assignments_f.object_version_number%TYPE;
546: l_org_now_no_manager_warning boolean := FALSE;
547: --

Line 545: l_object_version_number per_assignments_f.object_version_number%TYPE;

541: l_asg_future_changes_warning boolean := FALSE;
542: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
543: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
544: l_entries_changed_warning varchar2(1) := 'N';
545: l_object_version_number per_assignments_f.object_version_number%TYPE;
546: l_org_now_no_manager_warning boolean := FALSE;
547: --
548: l_business_group_id per_assignments_f.business_group_id%TYPE;
549: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 548: l_business_group_id per_assignments_f.business_group_id%TYPE;

544: l_entries_changed_warning varchar2(1) := 'N';
545: l_object_version_number per_assignments_f.object_version_number%TYPE;
546: l_org_now_no_manager_warning boolean := FALSE;
547: --
548: l_business_group_id per_assignments_f.business_group_id%TYPE;
549: l_legislation_code per_business_groups.legislation_code%TYPE;
550: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
551: l_proc varchar2(72) :=
552: g_package || 'final_process_cwk_asg';

Line 550: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;

546: l_org_now_no_manager_warning boolean := FALSE;
547: --
548: l_business_group_id per_assignments_f.business_group_id%TYPE;
549: l_legislation_code per_business_groups.legislation_code%TYPE;
550: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
551: l_proc varchar2(72) :=
552: g_package || 'final_process_cwk_asg';
553: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
554: l_validation_end_date per_assignments_f.effective_end_date%TYPE;

Line 553: l_validation_start_date per_assignments_f.effective_start_date%TYPE;

549: l_legislation_code per_business_groups.legislation_code%TYPE;
550: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
551: l_proc varchar2(72) :=
552: g_package || 'final_process_cwk_asg';
553: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
554: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
555: l_status varchar2(2);
556: --
557: --

Line 554: l_validation_end_date per_assignments_f.effective_end_date%TYPE;

550: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
551: l_proc varchar2(72) :=
552: g_package || 'final_process_cwk_asg';
553: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
554: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
555: l_status varchar2(2);
556: --
557: --
558: cursor csr_get_busgrp_legislation is

Line 562: per_assignments_f asg

558: cursor csr_get_busgrp_legislation is
559: select pbg.business_group_id, pbg.legislation_code
560: from per_business_groups_perf pbg
561: where pbg.business_group_id = (select distinct asg.business_group_id from
562: per_assignments_f asg
563: where asg.assignment_id = p_assignment_id);
564:
565: --
566: --

Line 1036: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

1032: --
1033: -- Out variables
1034: --
1035: l_asg_future_changes_warning boolean := FALSE;
1036: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1037: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1038: l_entries_changed_warning varchar2(1) := 'N';
1039: l_object_version_number per_assignments_f.object_version_number%TYPE;
1040: --

Line 1037: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

1033: -- Out variables
1034: --
1035: l_asg_future_changes_warning boolean := FALSE;
1036: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1037: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1038: l_entries_changed_warning varchar2(1) := 'N';
1039: l_object_version_number per_assignments_f.object_version_number%TYPE;
1040: --
1041: -- 115.66 (START)

Line 1039: l_object_version_number per_assignments_f.object_version_number%TYPE;

1035: l_asg_future_changes_warning boolean := FALSE;
1036: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1037: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1038: l_entries_changed_warning varchar2(1) := 'N';
1039: l_object_version_number per_assignments_f.object_version_number%TYPE;
1040: --
1041: -- 115.66 (START)
1042: --
1043: l_alu_change_warning varchar2(1) := 'N';

Line 1048: l_business_group_id per_assignments_f.business_group_id%TYPE;

1044: --
1045: -- 115.66 (END)
1046: --
1047: --
1048: l_business_group_id per_assignments_f.business_group_id%TYPE;
1049: l_comment_id per_assignments_f.comment_id%TYPE;
1050: l_correction boolean;
1051: l_datetrack_mode varchar2(30);
1052: l_entries_changed varchar2(1);

Line 1049: l_comment_id per_assignments_f.comment_id%TYPE;

1045: -- 115.66 (END)
1046: --
1047: --
1048: l_business_group_id per_assignments_f.business_group_id%TYPE;
1049: l_comment_id per_assignments_f.comment_id%TYPE;
1050: l_correction boolean;
1051: l_datetrack_mode varchar2(30);
1052: l_entries_changed varchar2(1);
1053: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 1054: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;

1050: l_correction boolean;
1051: l_datetrack_mode varchar2(30);
1052: l_entries_changed varchar2(1);
1053: l_legislation_code per_business_groups.legislation_code%TYPE;
1054: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
1055: l_no_managers_warning boolean;
1056: l_org_now_no_manager_warning boolean;
1057: l_pay_proposal_warning boolean := FALSE; -- Bug 3202260
1058: l_other_manager_warning boolean;

Line 1083: from per_assignments_f asg

1079: cursor csr_asg_values (l_effective_date date) is
1080: select asg.object_version_number
1081: , asg.effective_start_date
1082: , asg.effective_end_date
1083: from per_assignments_f asg
1084: where asg.assignment_id = p_assignment_id
1085: and l_effective_date between asg.effective_start_date
1086: and asg.effective_end_date;
1087: --

Line 1092: from per_assignments_f asg

1088: cursor csr_get_future_asg (l_effective_date date) is
1089: select asg.object_version_number
1090: , asg.effective_start_date
1091: , asg.effective_end_date
1092: from per_assignments_f asg
1093: where asg.assignment_id = p_assignment_id
1094: and asg.effective_start_date >= l_effective_date;
1095: --
1096: cursor csr_lock_alu is

Line 1166: l_effective_end_date1 per_assignments_f.effective_end_date%TYPE;

1162: -- End of 3202260
1163:
1164: --start of bug 5026287
1165: /*commented the changes for bug 5026287
1166: l_effective_end_date1 per_assignments_f.effective_end_date%TYPE;
1167: l_effective_start_date1 per_assignments_f.effective_start_date%TYPE;
1168: l_object_version_number1 per_assignments_f.object_version_number%TYPE;*/
1169: --end of bug 5026287
1170:

Line 1167: l_effective_start_date1 per_assignments_f.effective_start_date%TYPE;

1163:
1164: --start of bug 5026287
1165: /*commented the changes for bug 5026287
1166: l_effective_end_date1 per_assignments_f.effective_end_date%TYPE;
1167: l_effective_start_date1 per_assignments_f.effective_start_date%TYPE;
1168: l_object_version_number1 per_assignments_f.object_version_number%TYPE;*/
1169: --end of bug 5026287
1170:
1171: begin

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

1164: --start of bug 5026287
1165: /*commented the changes for bug 5026287
1166: l_effective_end_date1 per_assignments_f.effective_end_date%TYPE;
1167: l_effective_start_date1 per_assignments_f.effective_start_date%TYPE;
1168: l_object_version_number1 per_assignments_f.object_version_number%TYPE;*/
1169: --end of bug 5026287
1170:
1171: begin
1172: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 1654: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

1650: l_time_normal_start per_business_groups.default_start_time%TYPE;
1651: l_normal_hours number;
1652: l_frequency per_business_groups.frequency%TYPE;
1653: l_legislation_code per_business_groups.legislation_code%TYPE;
1654: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1655: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
1656: l_assignment_number per_assignments_f.assignment_number%TYPE;
1657: l_comment_id per_assignments_f.comment_id%TYPE;
1658: l_other_manager_warning boolean;

Line 1655: l_effective_end_date per_assignments_f.effective_start_date%TYPE;

1651: l_normal_hours number;
1652: l_frequency per_business_groups.frequency%TYPE;
1653: l_legislation_code per_business_groups.legislation_code%TYPE;
1654: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1655: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
1656: l_assignment_number per_assignments_f.assignment_number%TYPE;
1657: l_comment_id per_assignments_f.comment_id%TYPE;
1658: l_other_manager_warning boolean;
1659: l_proc varchar2(72):=g_package||'create_default_emp_asg';

Line 1656: l_assignment_number per_assignments_f.assignment_number%TYPE;

1652: l_frequency per_business_groups.frequency%TYPE;
1653: l_legislation_code per_business_groups.legislation_code%TYPE;
1654: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1655: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
1656: l_assignment_number per_assignments_f.assignment_number%TYPE;
1657: l_comment_id per_assignments_f.comment_id%TYPE;
1658: l_other_manager_warning boolean;
1659: l_proc varchar2(72):=g_package||'create_default_emp_asg';
1660: --

Line 1657: l_comment_id per_assignments_f.comment_id%TYPE;

1653: l_legislation_code per_business_groups.legislation_code%TYPE;
1654: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1655: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
1656: l_assignment_number per_assignments_f.assignment_number%TYPE;
1657: l_comment_id per_assignments_f.comment_id%TYPE;
1658: l_other_manager_warning boolean;
1659: l_proc varchar2(72):=g_package||'create_default_emp_asg';
1660: --
1661: cursor csr_get_default_details is

Line 1845: l_assignment_id per_assignments_f.assignment_id%TYPE;

1841: ) is
1842: --
1843: -- Declare cursors and local variables
1844: --
1845: l_assignment_id per_assignments_f.assignment_id%TYPE;
1846: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
1847: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1848: l_entries_changed varchar2(1);
1849: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

Line 1846: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;

1842: --
1843: -- Declare cursors and local variables
1844: --
1845: l_assignment_id per_assignments_f.assignment_id%TYPE;
1846: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
1847: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1848: l_entries_changed varchar2(1);
1849: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1850: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

Line 1847: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

1843: -- Declare cursors and local variables
1844: --
1845: l_assignment_id per_assignments_f.assignment_id%TYPE;
1846: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
1847: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1848: l_entries_changed varchar2(1);
1849: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1850: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1851: l_proc varchar2(72) := g_package||'create_emp_asg';

Line 1849: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

1845: l_assignment_id per_assignments_f.assignment_id%TYPE;
1846: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
1847: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1848: l_entries_changed varchar2(1);
1849: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1850: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1851: l_proc varchar2(72) := g_package||'create_emp_asg';
1852: l_hourly_salaried_warning boolean;
1853: l_object_version_number per_assignments_f.object_version_number%TYPE;

Line 1850: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

1846: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
1847: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1848: l_entries_changed varchar2(1);
1849: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1850: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1851: l_proc varchar2(72) := g_package||'create_emp_asg';
1852: l_hourly_salaried_warning boolean;
1853: l_object_version_number per_assignments_f.object_version_number%TYPE;
1854:

Line 1853: l_object_version_number per_assignments_f.object_version_number%TYPE;

1849: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1850: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1851: l_proc varchar2(72) := g_package||'create_emp_asg';
1852: l_hourly_salaried_warning boolean;
1853: l_object_version_number per_assignments_f.object_version_number%TYPE;
1854:
1855: --
1856: begin
1857: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 2071: l_assignment_id per_assignments_f.assignment_id%TYPE;

2067: ) is
2068: --
2069: -- Declare cursors and local variables
2070: --
2071: l_assignment_id per_assignments_f.assignment_id%TYPE;
2072: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
2073: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
2074: l_entries_changed varchar2(1);
2075: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

Line 2072: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;

2068: --
2069: -- Declare cursors and local variables
2070: --
2071: l_assignment_id per_assignments_f.assignment_id%TYPE;
2072: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
2073: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
2074: l_entries_changed varchar2(1);
2075: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
2076: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

Line 2073: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

2069: -- Declare cursors and local variables
2070: --
2071: l_assignment_id per_assignments_f.assignment_id%TYPE;
2072: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
2073: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
2074: l_entries_changed varchar2(1);
2075: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
2076: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
2077: l_proc varchar2(72) := g_package||'create_emp_asg';

Line 2075: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

2071: l_assignment_id per_assignments_f.assignment_id%TYPE;
2072: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
2073: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
2074: l_entries_changed varchar2(1);
2075: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
2076: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
2077: l_proc varchar2(72) := g_package||'create_emp_asg';
2078: l_labour_union_member_flag per_assignments_f.labour_union_member_flag%TYPE;
2079: l_work_at_home per_all_assignments_f.work_at_home%TYPE; --FIX FOR BUG 9162187

Line 2076: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

2072: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
2073: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
2074: l_entries_changed varchar2(1);
2075: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
2076: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
2077: l_proc varchar2(72) := g_package||'create_emp_asg';
2078: l_labour_union_member_flag per_assignments_f.labour_union_member_flag%TYPE;
2079: l_work_at_home per_all_assignments_f.work_at_home%TYPE; --FIX FOR BUG 9162187
2080: --

Line 2078: l_labour_union_member_flag per_assignments_f.labour_union_member_flag%TYPE;

2074: l_entries_changed varchar2(1);
2075: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
2076: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
2077: l_proc varchar2(72) := g_package||'create_emp_asg';
2078: l_labour_union_member_flag per_assignments_f.labour_union_member_flag%TYPE;
2079: l_work_at_home per_all_assignments_f.work_at_home%TYPE; --FIX FOR BUG 9162187
2080: --
2081: begin
2082: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 2114: -- Insert per_assignments_f row.

2110: );
2111: --
2112: hr_utility.set_location(l_proc, 10);
2113: --
2114: -- Insert per_assignments_f row.
2115: --
2116: per_asg_ins.ins
2117: (p_assignment_id => l_assignment_id
2118: ,p_effective_start_date => l_effective_start_date

Line 2284: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

2280: --
2281: -- Out variables
2282: --
2283: l_asg_future_changes_warning boolean := FALSE;
2284: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
2285: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
2286: l_entries_changed_warning varchar2(1) := 'N';
2287: --
2288: -- 115.66 (START)

Line 2285: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

2281: -- Out variables
2282: --
2283: l_asg_future_changes_warning boolean := FALSE;
2284: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
2285: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
2286: l_entries_changed_warning varchar2(1) := 'N';
2287: --
2288: -- 115.66 (START)
2289: --

Line 2294: l_object_version_number per_assignments_f.object_version_number%TYPE;

2290: l_alu_change_warning varchar2(1) := 'N';
2291: --
2292: -- 115.66 (END)
2293: --
2294: l_object_version_number per_assignments_f.object_version_number%TYPE;
2295: l_org_now_no_manager_warning boolean := FALSE;
2296: --surendra
2297: --
2298: l_loc_change_tax_issues boolean;

Line 2306: l_business_group_id per_assignments_f.business_group_id%TYPE;

2302: l_spp_warning boolean;
2303: l_cost_warning boolean;
2304: l_life_events_exists boolean;
2305: --
2306: l_business_group_id per_assignments_f.business_group_id%TYPE;
2307: l_legislation_code per_business_groups.legislation_code%TYPE;
2308: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
2309: l_proc varchar2(72) :=
2310: g_package || 'final_process_emp_asg_sup';

Line 2308: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;

2304: l_life_events_exists boolean;
2305: --
2306: l_business_group_id per_assignments_f.business_group_id%TYPE;
2307: l_legislation_code per_business_groups.legislation_code%TYPE;
2308: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
2309: l_proc varchar2(72) :=
2310: g_package || 'final_process_emp_asg_sup';
2311: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
2312: l_validation_end_date per_assignments_f.effective_end_date%TYPE;

Line 2311: l_validation_start_date per_assignments_f.effective_start_date%TYPE;

2307: l_legislation_code per_business_groups.legislation_code%TYPE;
2308: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
2309: l_proc varchar2(72) :=
2310: g_package || 'final_process_emp_asg_sup';
2311: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
2312: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
2313: l_status varchar2(2);
2314: --
2315: --

Line 2312: l_validation_end_date per_assignments_f.effective_end_date%TYPE;

2308: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
2309: l_proc varchar2(72) :=
2310: g_package || 'final_process_emp_asg_sup';
2311: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
2312: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
2313: l_status varchar2(2);
2314: --
2315: --
2316: cursor csr_get_busgrp_legislation is

Line 2320: per_assignments_f asg

2316: cursor csr_get_busgrp_legislation is
2317: select pbg.business_group_id, pbg.legislation_code
2318: from per_business_groups_perf pbg
2319: where pbg.business_group_id = (select distinct asg.business_group_id from
2320: per_assignments_f asg
2321: where asg.assignment_id = p_assignment_id);
2322: --
2323: --
2324: cursor csr_lock_csa is

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

2707: -- |--------------------------------< SPP_ZAP >--------------------------------|
2708: -- ----------------------------------------------------------------------------
2709: --
2710: PROCEDURE spp_zap
2711: (p_assignment_id IN per_assignments_f.assignment_id%TYPE) IS
2712: --
2713: -- Declare Local Variables
2714: --
2715: l_proc VARCHAR2(72) := g_package||'spp_zap';

Line 2767: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

2763: -- |-----------------------< SPP_UPDATE_CHANGE_INSERT >-----------------------|
2764: -- ----------------------------------------------------------------------------
2765: --
2766: PROCEDURE spp_update_change_insert
2767: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2768: ,p_placement_id IN per_spinal_point_placements_f.placement_id%TYPE
2769: ,p_validation_start_date IN DATE
2770: ,p_validation_end_date IN DATE
2771: ,p_spp_eff_start_date IN DATE

Line 4733: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

4729: -- Declare cursors and local variables
4730: --
4731: -- Out variables
4732: --
4733: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
4734: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
4735: l_object_version_number per_assignments_f.object_version_number%TYPE;
4736: --
4737: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

Line 4734: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

4730: --
4731: -- Out variables
4732: --
4733: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
4734: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
4735: l_object_version_number per_assignments_f.object_version_number%TYPE;
4736: --
4737: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4738: l_assignment_type per_assignments_f.assignment_type%TYPE;

Line 4735: l_object_version_number per_assignments_f.object_version_number%TYPE;

4731: -- Out variables
4732: --
4733: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
4734: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
4735: l_object_version_number per_assignments_f.object_version_number%TYPE;
4736: --
4737: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4738: l_assignment_type per_assignments_f.assignment_type%TYPE;
4739: l_business_group_id per_assignments_f.business_group_id%TYPE;

Line 4737: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

4733: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
4734: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
4735: l_object_version_number per_assignments_f.object_version_number%TYPE;
4736: --
4737: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4738: l_assignment_type per_assignments_f.assignment_type%TYPE;
4739: l_business_group_id per_assignments_f.business_group_id%TYPE;
4740: l_comment_id per_assignments_f.comment_id%TYPE;
4741: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 4738: l_assignment_type per_assignments_f.assignment_type%TYPE;

4734: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
4735: l_object_version_number per_assignments_f.object_version_number%TYPE;
4736: --
4737: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4738: l_assignment_type per_assignments_f.assignment_type%TYPE;
4739: l_business_group_id per_assignments_f.business_group_id%TYPE;
4740: l_comment_id per_assignments_f.comment_id%TYPE;
4741: l_legislation_code per_business_groups.legislation_code%TYPE;
4742: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

Line 4739: l_business_group_id per_assignments_f.business_group_id%TYPE;

4735: l_object_version_number per_assignments_f.object_version_number%TYPE;
4736: --
4737: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4738: l_assignment_type per_assignments_f.assignment_type%TYPE;
4739: l_business_group_id per_assignments_f.business_group_id%TYPE;
4740: l_comment_id per_assignments_f.comment_id%TYPE;
4741: l_legislation_code per_business_groups.legislation_code%TYPE;
4742: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4743: l_no_managers_warning boolean;

Line 4740: l_comment_id per_assignments_f.comment_id%TYPE;

4736: --
4737: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4738: l_assignment_type per_assignments_f.assignment_type%TYPE;
4739: l_business_group_id per_assignments_f.business_group_id%TYPE;
4740: l_comment_id per_assignments_f.comment_id%TYPE;
4741: l_legislation_code per_business_groups.legislation_code%TYPE;
4742: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4743: l_no_managers_warning boolean;
4744: l_other_manager_warning boolean;

Line 4748: l_validation_start_date per_assignments_f.effective_start_date%TYPE;

4744: l_other_manager_warning boolean;
4745: l_hourly_salaried_warning boolean;
4746: l_payroll_id_updated boolean;
4747: l_org_now_no_manager_warning boolean;
4748: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
4749: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
4750: l_proc varchar2(72):=
4751: g_package||'update_status_type_cwk_asg';
4752: --

Line 4749: l_validation_end_date per_assignments_f.effective_end_date%TYPE;

4745: l_hourly_salaried_warning boolean;
4746: l_payroll_id_updated boolean;
4747: l_org_now_no_manager_warning boolean;
4748: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
4749: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
4750: l_proc varchar2(72):=
4751: g_package||'update_status_type_cwk_asg';
4752: --
4753: cursor csr_get_asg_dets is

Line 4757: from per_assignments_f asg

4753: cursor csr_get_asg_dets is
4754: select asg.assignment_type
4755: , asg.business_group_id
4756: , bus.legislation_code
4757: from per_assignments_f asg
4758: , per_business_groups_perf bus
4759: where asg.assignment_id = p_assignment_id
4760: and p_effective_date between asg.effective_start_date
4761: and asg.effective_end_date

Line 4898: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

4894: -- Declare cursors and local variables
4895: --
4896: -- Out variables
4897: --
4898: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
4899: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
4900: l_object_version_number per_assignments_f.object_version_number%TYPE;
4901: --
4902: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

Line 4899: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

4895: --
4896: -- Out variables
4897: --
4898: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
4899: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
4900: l_object_version_number per_assignments_f.object_version_number%TYPE;
4901: --
4902: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4903: l_assignment_type per_assignments_f.assignment_type%TYPE;

Line 4900: l_object_version_number per_assignments_f.object_version_number%TYPE;

4896: -- Out variables
4897: --
4898: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
4899: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
4900: l_object_version_number per_assignments_f.object_version_number%TYPE;
4901: --
4902: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4903: l_assignment_type per_assignments_f.assignment_type%TYPE;
4904: l_business_group_id per_assignments_f.business_group_id%TYPE;

Line 4902: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

4898: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
4899: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
4900: l_object_version_number per_assignments_f.object_version_number%TYPE;
4901: --
4902: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4903: l_assignment_type per_assignments_f.assignment_type%TYPE;
4904: l_business_group_id per_assignments_f.business_group_id%TYPE;
4905: l_comment_id per_assignments_f.comment_id%TYPE;
4906: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 4903: l_assignment_type per_assignments_f.assignment_type%TYPE;

4899: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
4900: l_object_version_number per_assignments_f.object_version_number%TYPE;
4901: --
4902: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4903: l_assignment_type per_assignments_f.assignment_type%TYPE;
4904: l_business_group_id per_assignments_f.business_group_id%TYPE;
4905: l_comment_id per_assignments_f.comment_id%TYPE;
4906: l_legislation_code per_business_groups.legislation_code%TYPE;
4907: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

Line 4904: l_business_group_id per_assignments_f.business_group_id%TYPE;

4900: l_object_version_number per_assignments_f.object_version_number%TYPE;
4901: --
4902: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4903: l_assignment_type per_assignments_f.assignment_type%TYPE;
4904: l_business_group_id per_assignments_f.business_group_id%TYPE;
4905: l_comment_id per_assignments_f.comment_id%TYPE;
4906: l_legislation_code per_business_groups.legislation_code%TYPE;
4907: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4908: l_no_managers_warning boolean;

Line 4905: l_comment_id per_assignments_f.comment_id%TYPE;

4901: --
4902: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4903: l_assignment_type per_assignments_f.assignment_type%TYPE;
4904: l_business_group_id per_assignments_f.business_group_id%TYPE;
4905: l_comment_id per_assignments_f.comment_id%TYPE;
4906: l_legislation_code per_business_groups.legislation_code%TYPE;
4907: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4908: l_no_managers_warning boolean;
4909: l_other_manager_warning boolean;

Line 4913: l_validation_start_date per_assignments_f.effective_start_date%TYPE;

4909: l_other_manager_warning boolean;
4910: l_hourly_salaried_warning boolean;
4911: l_payroll_id_updated boolean;
4912: l_org_now_no_manager_warning boolean;
4913: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
4914: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
4915: l_proc varchar2(72):=
4916: g_package||'update_status_type_emp_asg';
4917: --

Line 4914: l_validation_end_date per_assignments_f.effective_end_date%TYPE;

4910: l_hourly_salaried_warning boolean;
4911: l_payroll_id_updated boolean;
4912: l_org_now_no_manager_warning boolean;
4913: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
4914: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
4915: l_proc varchar2(72):=
4916: g_package||'update_status_type_emp_asg';
4917: --
4918: cursor csr_get_asg_dets is

Line 4922: from per_assignments_f asg

4918: cursor csr_get_asg_dets is
4919: select asg.assignment_type
4920: , asg.business_group_id
4921: , bus.legislation_code
4922: from per_assignments_f asg
4923: , per_business_groups_perf bus
4924: where asg.assignment_id = p_assignment_id
4925: and p_effective_date between asg.effective_start_date
4926: and asg.effective_end_date

Line 5150: l_assignment_id per_assignments_f.assignment_id%TYPE;

5146: -- Declare cursors and local variables
5147: --
5148: l_assignment_status_id number;
5149: l_asg_status_ovn number;
5150: l_assignment_id per_assignments_f.assignment_id%TYPE;
5151: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5152: l_object_version_number per_assignments_f.object_version_number%TYPE;
5153: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5154: l_assignment_number per_assignments_f.assignment_number%TYPE;

Line 5151: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;

5147: --
5148: l_assignment_status_id number;
5149: l_asg_status_ovn number;
5150: l_assignment_id per_assignments_f.assignment_id%TYPE;
5151: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5152: l_object_version_number per_assignments_f.object_version_number%TYPE;
5153: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5154: l_assignment_number per_assignments_f.assignment_number%TYPE;
5155: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

Line 5152: l_object_version_number per_assignments_f.object_version_number%TYPE;

5148: l_assignment_status_id number;
5149: l_asg_status_ovn number;
5150: l_assignment_id per_assignments_f.assignment_id%TYPE;
5151: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5152: l_object_version_number per_assignments_f.object_version_number%TYPE;
5153: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5154: l_assignment_number per_assignments_f.assignment_number%TYPE;
5155: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5156: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

Line 5153: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

5149: l_asg_status_ovn number;
5150: l_assignment_id per_assignments_f.assignment_id%TYPE;
5151: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5152: l_object_version_number per_assignments_f.object_version_number%TYPE;
5153: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5154: l_assignment_number per_assignments_f.assignment_number%TYPE;
5155: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5156: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5157: l_comment_id per_assignments_f.comment_id%TYPE;

Line 5154: l_assignment_number per_assignments_f.assignment_number%TYPE;

5150: l_assignment_id per_assignments_f.assignment_id%TYPE;
5151: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5152: l_object_version_number per_assignments_f.object_version_number%TYPE;
5153: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5154: l_assignment_number per_assignments_f.assignment_number%TYPE;
5155: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5156: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5157: l_comment_id per_assignments_f.comment_id%TYPE;
5158: l_other_manager_warning boolean;

Line 5155: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

5151: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5152: l_object_version_number per_assignments_f.object_version_number%TYPE;
5153: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5154: l_assignment_number per_assignments_f.assignment_number%TYPE;
5155: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5156: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5157: l_comment_id per_assignments_f.comment_id%TYPE;
5158: l_other_manager_warning boolean;
5159: l_hourly_salaried_warning boolean;

Line 5156: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

5152: l_object_version_number per_assignments_f.object_version_number%TYPE;
5153: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5154: l_assignment_number per_assignments_f.assignment_number%TYPE;
5155: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5156: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5157: l_comment_id per_assignments_f.comment_id%TYPE;
5158: l_other_manager_warning boolean;
5159: l_hourly_salaried_warning boolean;
5160: l_proc varchar2(72) := g_package||'create_apl_asg';

Line 5157: l_comment_id per_assignments_f.comment_id%TYPE;

5153: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5154: l_assignment_number per_assignments_f.assignment_number%TYPE;
5155: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5156: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5157: l_comment_id per_assignments_f.comment_id%TYPE;
5158: l_other_manager_warning boolean;
5159: l_hourly_salaried_warning boolean;
5160: l_proc varchar2(72) := g_package||'create_apl_asg';
5161: l_labour_union_member_flag per_assignments_f.labour_union_member_flag%TYPE;

Line 5161: l_labour_union_member_flag per_assignments_f.labour_union_member_flag%TYPE;

5157: l_comment_id per_assignments_f.comment_id%TYPE;
5158: l_other_manager_warning boolean;
5159: l_hourly_salaried_warning boolean;
5160: l_proc varchar2(72) := g_package||'create_apl_asg';
5161: l_labour_union_member_flag per_assignments_f.labour_union_member_flag%TYPE;
5162: l_work_at_home per_all_assignments_f.work_at_home%TYPE; --FIX FOR BUG 9246917
5163: begin
5164: --
5165: hr_utility.set_location(l_proc, 10);

Line 5205: -- Insert per_assignments_f row.

5201: --
5202: l_assignment_number := null;
5203: l_work_at_home := nvl(p_work_at_home,'N'); --FIX FOR BUG 9246917
5204: --
5205: -- Insert per_assignments_f row.
5206: --
5207: per_asg_ins.ins
5208: (p_assignment_id => l_assignment_id
5209: ,p_effective_start_date => l_effective_start_date

Line 5389: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

5385: l_time_normal_start per_business_groups.default_start_time%TYPE;
5386: l_normal_hours number;
5387: l_frequency per_business_groups.frequency%TYPE;
5388: l_legislation_code per_business_groups.legislation_code%TYPE;
5389: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5390: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
5391: l_assignment_number per_assignments_f.assignment_number%TYPE;
5392: l_comment_id per_assignments_f.comment_id%TYPE;
5393: l_other_manager_warning boolean;

Line 5390: l_effective_end_date per_assignments_f.effective_start_date%TYPE;

5386: l_normal_hours number;
5387: l_frequency per_business_groups.frequency%TYPE;
5388: l_legislation_code per_business_groups.legislation_code%TYPE;
5389: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5390: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
5391: l_assignment_number per_assignments_f.assignment_number%TYPE;
5392: l_comment_id per_assignments_f.comment_id%TYPE;
5393: l_other_manager_warning boolean;
5394: l_proc varchar2(72):=g_package||'create_default_cwk_asg';

Line 5391: l_assignment_number per_assignments_f.assignment_number%TYPE;

5387: l_frequency per_business_groups.frequency%TYPE;
5388: l_legislation_code per_business_groups.legislation_code%TYPE;
5389: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5390: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
5391: l_assignment_number per_assignments_f.assignment_number%TYPE;
5392: l_comment_id per_assignments_f.comment_id%TYPE;
5393: l_other_manager_warning boolean;
5394: l_proc varchar2(72):=g_package||'create_default_cwk_asg';
5395: --

Line 5392: l_comment_id per_assignments_f.comment_id%TYPE;

5388: l_legislation_code per_business_groups.legislation_code%TYPE;
5389: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5390: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
5391: l_assignment_number per_assignments_f.assignment_number%TYPE;
5392: l_comment_id per_assignments_f.comment_id%TYPE;
5393: l_other_manager_warning boolean;
5394: l_proc varchar2(72):=g_package||'create_default_cwk_asg';
5395: --
5396: cursor csr_get_default_details is

Line 5571: l_assignment_id per_assignments_f.assignment_id%TYPE;

5567: ) is
5568: --
5569: -- Declare cursors and local variables
5570: --
5571: l_assignment_id per_assignments_f.assignment_id%TYPE;
5572: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5573: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5574: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5575: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

Line 5572: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;

5568: --
5569: -- Declare cursors and local variables
5570: --
5571: l_assignment_id per_assignments_f.assignment_id%TYPE;
5572: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5573: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5574: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5575: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5576: l_hourly_salaried_warning boolean;

Line 5573: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

5569: -- Declare cursors and local variables
5570: --
5571: l_assignment_id per_assignments_f.assignment_id%TYPE;
5572: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5573: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5574: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5575: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5576: l_hourly_salaried_warning boolean;
5577: l_proc varchar2(72) := g_package||'create_cwk_asg';

Line 5574: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

5570: --
5571: l_assignment_id per_assignments_f.assignment_id%TYPE;
5572: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5573: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5574: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5575: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5576: l_hourly_salaried_warning boolean;
5577: l_proc varchar2(72) := g_package||'create_cwk_asg';
5578: --

Line 5575: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

5571: l_assignment_id per_assignments_f.assignment_id%TYPE;
5572: l_assignment_sequence per_assignments_f.assignment_sequence%TYPE;
5573: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5574: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5575: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5576: l_hourly_salaried_warning boolean;
5577: l_proc varchar2(72) := g_package||'create_cwk_asg';
5578: --
5579: begin

Line 5602: -- Insert per_assignments_f row.

5598: );
5599: --
5600: hr_utility.set_location(l_proc, 10);
5601: --
5602: -- Insert per_assignments_f row.
5603: --
5604: per_asg_ins.ins
5605: (p_validate => p_validate
5606: ,p_effective_date => p_effective_date

Line 5735: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

5731: l_time_normal_start per_business_groups.default_start_time%TYPE;
5732: l_normal_hours number;
5733: l_frequency per_business_groups.frequency%TYPE;
5734: l_legislation_code per_business_groups.legislation_code%TYPE;
5735: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5736: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5737: l_comment_id per_assignments_f.comment_id%TYPE;
5738: l_proc varchar2(72):=g_package||'create_default_apl_asg';
5739: --

Line 5736: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

5732: l_normal_hours number;
5733: l_frequency per_business_groups.frequency%TYPE;
5734: l_legislation_code per_business_groups.legislation_code%TYPE;
5735: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5736: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5737: l_comment_id per_assignments_f.comment_id%TYPE;
5738: l_proc varchar2(72):=g_package||'create_default_apl_asg';
5739: --
5740: cursor csr_get_default_details is

Line 5737: l_comment_id per_assignments_f.comment_id%TYPE;

5733: l_frequency per_business_groups.frequency%TYPE;
5734: l_legislation_code per_business_groups.legislation_code%TYPE;
5735: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5736: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5737: l_comment_id per_assignments_f.comment_id%TYPE;
5738: l_proc varchar2(72):=g_package||'create_default_apl_asg';
5739: --
5740: cursor csr_get_default_details is
5741: select bus.location_id

Line 5869: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

5865: -- Out variables
5866: --
5867: l_assignment_status_id number;
5868: L_ASG_STATUS_OVN number;
5869: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5870: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5871: l_object_version_number per_assignments_f.object_version_number%TYPE;
5872: --
5873: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

Line 5870: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

5866: --
5867: l_assignment_status_id number;
5868: L_ASG_STATUS_OVN number;
5869: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5870: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5871: l_object_version_number per_assignments_f.object_version_number%TYPE;
5872: --
5873: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5874: l_assignment_type per_assignments_f.assignment_type%TYPE;

Line 5871: l_object_version_number per_assignments_f.object_version_number%TYPE;

5867: l_assignment_status_id number;
5868: L_ASG_STATUS_OVN number;
5869: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5870: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5871: l_object_version_number per_assignments_f.object_version_number%TYPE;
5872: --
5873: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5874: l_assignment_type per_assignments_f.assignment_type%TYPE;
5875: l_person_id per_assignments_f.person_id%TYPE;

Line 5873: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

5869: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5870: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5871: l_object_version_number per_assignments_f.object_version_number%TYPE;
5872: --
5873: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5874: l_assignment_type per_assignments_f.assignment_type%TYPE;
5875: l_person_id per_assignments_f.person_id%TYPE;
5876: l_business_group_id per_assignments_f.business_group_id%TYPE;
5877: l_comment_id per_assignments_f.comment_id%TYPE;

Line 5874: l_assignment_type per_assignments_f.assignment_type%TYPE;

5870: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5871: l_object_version_number per_assignments_f.object_version_number%TYPE;
5872: --
5873: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5874: l_assignment_type per_assignments_f.assignment_type%TYPE;
5875: l_person_id per_assignments_f.person_id%TYPE;
5876: l_business_group_id per_assignments_f.business_group_id%TYPE;
5877: l_comment_id per_assignments_f.comment_id%TYPE;
5878: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 5875: l_person_id per_assignments_f.person_id%TYPE;

5871: l_object_version_number per_assignments_f.object_version_number%TYPE;
5872: --
5873: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5874: l_assignment_type per_assignments_f.assignment_type%TYPE;
5875: l_person_id per_assignments_f.person_id%TYPE;
5876: l_business_group_id per_assignments_f.business_group_id%TYPE;
5877: l_comment_id per_assignments_f.comment_id%TYPE;
5878: l_legislation_code per_business_groups.legislation_code%TYPE;
5879: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

Line 5876: l_business_group_id per_assignments_f.business_group_id%TYPE;

5872: --
5873: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5874: l_assignment_type per_assignments_f.assignment_type%TYPE;
5875: l_person_id per_assignments_f.person_id%TYPE;
5876: l_business_group_id per_assignments_f.business_group_id%TYPE;
5877: l_comment_id per_assignments_f.comment_id%TYPE;
5878: l_legislation_code per_business_groups.legislation_code%TYPE;
5879: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
5880: l_no_managers_warning boolean;

Line 5877: l_comment_id per_assignments_f.comment_id%TYPE;

5873: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
5874: l_assignment_type per_assignments_f.assignment_type%TYPE;
5875: l_person_id per_assignments_f.person_id%TYPE;
5876: l_business_group_id per_assignments_f.business_group_id%TYPE;
5877: l_comment_id per_assignments_f.comment_id%TYPE;
5878: l_legislation_code per_business_groups.legislation_code%TYPE;
5879: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
5880: l_no_managers_warning boolean;
5881: l_other_manager_warning boolean;

Line 5885: l_validation_start_date per_assignments_f.effective_start_date%TYPE;

5881: l_other_manager_warning boolean;
5882: l_payroll_id_updated boolean;
5883: l_org_now_no_manager_warning boolean;
5884: l_hourly_salaried_warning boolean;
5885: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
5886: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
5887: l_proc varchar2(72):=
5888: g_package||'update_status_type_apl_asg';
5889: l_vacancy_id number;

Line 5886: l_validation_end_date per_assignments_f.effective_end_date%TYPE;

5882: l_payroll_id_updated boolean;
5883: l_org_now_no_manager_warning boolean;
5884: l_hourly_salaried_warning boolean;
5885: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
5886: l_validation_end_date per_assignments_f.effective_end_date%TYPE;
5887: l_proc varchar2(72):=
5888: g_package||'update_status_type_apl_asg';
5889: l_vacancy_id number;
5890: --

Line 5896: from per_assignments_f asg

5892: select asg.assignment_type
5893: , asg.person_id
5894: , asg.business_group_id
5895: , bus.legislation_code
5896: from per_assignments_f asg
5897: , per_business_groups_perf bus
5898: where asg.assignment_id = p_assignment_id
5899: and p_effective_date between asg.effective_start_date
5900: and asg.effective_end_date

Line 6432: per_assignments_f2_pkg.pre_delete(

6428: if g_debug then
6429: hr_utility.set_location('l_re_entry_point :'||l_re_entry_point, 40);
6430: end if;
6431: --
6432: per_assignments_f2_pkg.pre_delete(
6433: p_datetrack_mode, -- p_del_mode,
6434: p_validation_start_date, -- p_val_st_date,
6435: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6436: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,

Line 6537: per_assignments_f2_pkg.key_delrec(

6533: if g_debug then
6534: hr_utility.set_location('Before key_delrec ', 60);
6535: end if;
6536: --
6537: per_assignments_f2_pkg.key_delrec(
6538: p_datetrack_mode, -- l_del_mode,
6539: p_validation_start_date, -- p_val_st_date,
6540: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6541: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,

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

6552: per_asg_shd.g_old_rec.payroll_id, -- p_pay_id,
6553: l_pay_basis_id -- added for bug 4764140
6554: );
6555: --
6556: -- CHECK_TERM_BY_POS changes (called in per_assignments_f2_pkg.key_delrec)
6557: --
6558: declare
6559: l_rec2 per_asg_shd.g_rec_type;
6560: begin

Line 6688: update per_assignments_f a

6684: if g_debug then
6685: hr_utility.set_location('Before updating assignment end date', 30);
6686: end if;
6687: --
6688: update per_assignments_f a
6689: set a.effective_end_date = p_appl_asg_new_end_date
6690: where a.assignment_id = p_rec.assignment_id -- p_assignment_id
6691: and a.effective_end_date = (
6692: select max(a2.effective_end_date)

Line 6693: from per_assignments_f a2

6689: set a.effective_end_date = p_appl_asg_new_end_date
6690: where a.assignment_id = p_rec.assignment_id -- p_assignment_id
6691: and a.effective_end_date = (
6692: select max(a2.effective_end_date)
6693: from per_assignments_f a2
6694: where a2.assignment_id = a.assignment_id);
6695: end if;
6696: --
6697: per_app_asg_pkg.cleanup_letters ( p_rec.assignment_id); -- p_assignment_id );

Line 6712: per_assignments_f1_pkg.post_delete(

6708: if g_debug then
6709: hr_utility.set_location('EMP/CWK type assignment checks ', 40);
6710: end if;
6711: --
6712: per_assignments_f1_pkg.post_delete(
6713: p_rec.assignment_id, -- p_ass_id,
6714: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6715: p_effective_date, -- p_sess_date,
6716: p_new_end_date, -- from pre_del()