[Home] [Help]
57: l_proc varchar2(30):= 'update_last_change_date';
58:
59: begin
60:
61: hr_utility.set_location('Entering:'||l_proc,5);
62: hr_utility.set_location('p_assignment_id:'||p_assignment_id,15);
63: hr_utility.set_location('p_change_date:'||p_change_date,25);
64:
65: l_last_change_date:=p_change_date;
58:
59: begin
60:
61: hr_utility.set_location('Entering:'||l_proc,5);
62: hr_utility.set_location('p_assignment_id:'||p_assignment_id,15);
63: hr_utility.set_location('p_change_date:'||p_change_date,25);
64:
65: l_last_change_date:=p_change_date;
66:
59: begin
60:
61: hr_utility.set_location('Entering:'||l_proc,5);
62: hr_utility.set_location('p_assignment_id:'||p_assignment_id,15);
63: hr_utility.set_location('p_change_date:'||p_change_date,25);
64:
65: l_last_change_date:=p_change_date;
66:
67: OPEN csr_next_proposal;
66:
67: OPEN csr_next_proposal;
68: FETCH csr_next_proposal into l_pay_proposal_id,l_row_id;
69:
70: hr_utility.set_location('l_pay_proposal_id:'||l_pay_proposal_id,15);
71:
72: if csr_next_proposal%FOUND then
73: hr_utility.set_location('Cursor found:',25);
74:
69:
70: hr_utility.set_location('l_pay_proposal_id:'||l_pay_proposal_id,15);
71:
72: if csr_next_proposal%FOUND then
73: hr_utility.set_location('Cursor found:',25);
74:
75: --added by schowdhu to fix 7205132
76:
77: update per_pay_proposals
85: update per_pay_proposals
86: set last_change_date = l_last_change_date
87: where rowid=l_row_id;
88: */
89: hr_utility.set_location('Updated successfuly:',35);
90: end if;
91:
92: CLOSE csr_next_proposal;
93:
90: end if;
91:
92: CLOSE csr_next_proposal;
93:
94: hr_utility.set_location('Leaving:'||l_proc,5);
95:
96: EXCEPTION
97: When others then
98: --
97: When others then
98: --
99: -- An unexpected error has occured
100: --
101: hr_utility.set_location('When Others:'||l_proc,5);
102: raise;
103: --
104: end update_last_change_date;
105: --
124: l_proc varchar2(30):= 'end_date_proposed_proposal';
125:
126: begin
127:
128: hr_utility.set_location('Entering:'||l_proc,5);
129: hr_utility.set_location('p_assignment_id:'||p_assignment_id,15);
130: hr_utility.set_location('p_date_to:'||p_date_to,25);
131:
132: OPEN csr_prev_prop_details;
125:
126: begin
127:
128: hr_utility.set_location('Entering:'||l_proc,5);
129: hr_utility.set_location('p_assignment_id:'||p_assignment_id,15);
130: hr_utility.set_location('p_date_to:'||p_date_to,25);
131:
132: OPEN csr_prev_prop_details;
133: FETCH csr_prev_prop_details into l_pay_proposal_id,l_date_to;
126: begin
127:
128: hr_utility.set_location('Entering:'||l_proc,5);
129: hr_utility.set_location('p_assignment_id:'||p_assignment_id,15);
130: hr_utility.set_location('p_date_to:'||p_date_to,25);
131:
132: OPEN csr_prev_prop_details;
133: FETCH csr_prev_prop_details into l_pay_proposal_id,l_date_to;
134:
131:
132: OPEN csr_prev_prop_details;
133: FETCH csr_prev_prop_details into l_pay_proposal_id,l_date_to;
134:
135: hr_utility.set_location('l_pay_proposal_id:'||l_pay_proposal_id,15);
136: hr_utility.set_location('l_date_to:'||l_date_to,25);
137:
138: if csr_prev_prop_details%FOUND then
139: hr_utility.set_location('Cursor found:',35);
132: OPEN csr_prev_prop_details;
133: FETCH csr_prev_prop_details into l_pay_proposal_id,l_date_to;
134:
135: hr_utility.set_location('l_pay_proposal_id:'||l_pay_proposal_id,15);
136: hr_utility.set_location('l_date_to:'||l_date_to,25);
137:
138: if csr_prev_prop_details%FOUND then
139: hr_utility.set_location('Cursor found:',35);
140: if l_date_to is null OR l_date_to > p_date_to then
135: hr_utility.set_location('l_pay_proposal_id:'||l_pay_proposal_id,15);
136: hr_utility.set_location('l_date_to:'||l_date_to,25);
137:
138: if csr_prev_prop_details%FOUND then
139: hr_utility.set_location('Cursor found:',35);
140: if l_date_to is null OR l_date_to > p_date_to then
141: hr_utility.set_location('About to update',45);
142: update per_pay_proposals
143: set date_to = p_date_to,
137:
138: if csr_prev_prop_details%FOUND then
139: hr_utility.set_location('Cursor found:',35);
140: if l_date_to is null OR l_date_to > p_date_to then
141: hr_utility.set_location('About to update',45);
142: update per_pay_proposals
143: set date_to = p_date_to,
144: -- added by vkodedal fix for 6831216
145: last_update_date = sysdate,
147: last_update_login = fnd_global.login_id
148: -- end of fix
149: where assignment_id = p_assignment_id
150: and pay_proposal_id = l_pay_proposal_id;
151: hr_utility.set_location('Updated successfuly:',85);
152: end if;
153: end if;
154: CLOSE csr_prev_prop_details;
155:
152: end if;
153: end if;
154: CLOSE csr_prev_prop_details;
155:
156: hr_utility.set_location('Leaving:'||l_proc,5);
157:
158: end end_date_proposed_proposal;
159: --
160: --
197: l_del_warn boolean;
198:
199: begin
200:
201: hr_utility.set_location('Entering:'||l_proc,5);
202: hr_utility.set_location('p_assignment_id:'||p_assignment_id,15);
203: hr_utility.set_location('p_date_to:'||p_date_to,25);
204:
205: OPEN csr_prev_prop_details;
198:
199: begin
200:
201: hr_utility.set_location('Entering:'||l_proc,5);
202: hr_utility.set_location('p_assignment_id:'||p_assignment_id,15);
203: hr_utility.set_location('p_date_to:'||p_date_to,25);
204:
205: OPEN csr_prev_prop_details;
206: FETCH csr_prev_prop_details into l_pay_proposal_id,l_date_to;
199: begin
200:
201: hr_utility.set_location('Entering:'||l_proc,5);
202: hr_utility.set_location('p_assignment_id:'||p_assignment_id,15);
203: hr_utility.set_location('p_date_to:'||p_date_to,25);
204:
205: OPEN csr_prev_prop_details;
206: FETCH csr_prev_prop_details into l_pay_proposal_id,l_date_to;
207:
205: OPEN csr_prev_prop_details;
206: FETCH csr_prev_prop_details into l_pay_proposal_id,l_date_to;
207:
208: if csr_prev_prop_details%FOUND then
209: hr_utility.set_location('Cursor found:',35);
210: if l_date_to is null OR l_date_to > p_date_to then
211: hr_utility.set_location('About to update',45);
212: update per_pay_proposals
213: set date_to = p_date_to,
207:
208: if csr_prev_prop_details%FOUND then
209: hr_utility.set_location('Cursor found:',35);
210: if l_date_to is null OR l_date_to > p_date_to then
211: hr_utility.set_location('About to update',45);
212: update per_pay_proposals
213: set date_to = p_date_to,
214: -- added by vkodedal fix for 6831216
215: last_update_date = sysdate,
217: last_update_login = fnd_global.login_id
218: -- end of fix
219: where assignment_id = p_assignment_id
220: and pay_proposal_id = l_pay_proposal_id;
221: hr_utility.set_location('Updated successfuly:',85);
222: end if;
223: end if;
224: CLOSE csr_prev_prop_details;
225:
226: -- This condition is added to delete the proposed proposals in case it is not yet done from
227: -- the OA layer. schowdhu - 01-Dec-2008
228: if( HR_MAINTAIN_PROPOSAL_API.g_deleted_from_oa = 'N')
229: then
230: hr_utility.set_location('Within delete from OA',90);
231: -- now delete all the inactivated proposed proposals. Bug#7386307 by schowdhu
232: for a in get_all_proposed_proposals loop
233: hr_maintain_proposal_api.delete_salary_proposal
234: (p_pay_proposal_id => a.pay_proposal_id
237: ,p_salary_warning => l_del_warn);
238: end loop;
239: end if;
240:
241: hr_utility.set_location('Leaving:'||l_proc,100);
242:
243: end end_date_approved_proposal;
244: --
245: --
281: and assignment_id = p_assignment_id
282: and change_date = p_date_to +1 ;
283: begin
284:
285: hr_utility.set_location('Entering:'||l_proc,5);
286: hr_utility.set_location('p_assignment_id:'||p_assignment_id,15);
287: hr_utility.set_location('p_date_to:'||p_date_to,25);
288: /*
289: OPEN csr_prev_prop_details;
282: and change_date = p_date_to +1 ;
283: begin
284:
285: hr_utility.set_location('Entering:'||l_proc,5);
286: hr_utility.set_location('p_assignment_id:'||p_assignment_id,15);
287: hr_utility.set_location('p_date_to:'||p_date_to,25);
288: /*
289: OPEN csr_prev_prop_details;
290: FETCH csr_prev_prop_details into l_pay_proposal_id,l_date_to;
283: begin
284:
285: hr_utility.set_location('Entering:'||l_proc,5);
286: hr_utility.set_location('p_assignment_id:'||p_assignment_id,15);
287: hr_utility.set_location('p_date_to:'||p_date_to,25);
288: /*
289: OPEN csr_prev_prop_details;
290: FETCH csr_prev_prop_details into l_pay_proposal_id,l_date_to;
291:
288: /*
289: OPEN csr_prev_prop_details;
290: FETCH csr_prev_prop_details into l_pay_proposal_id,l_date_to;
291:
292: hr_utility.set_location('l_pay_proposal_id:'||l_pay_proposal_id,15);
293: hr_utility.set_location('l_date_to:'||l_date_to,25);
294:
295:
296: if csr_prev_prop_details%FOUND then
289: OPEN csr_prev_prop_details;
290: FETCH csr_prev_prop_details into l_pay_proposal_id,l_date_to;
291:
292: hr_utility.set_location('l_pay_proposal_id:'||l_pay_proposal_id,15);
293: hr_utility.set_location('l_date_to:'||l_date_to,25);
294:
295:
296: if csr_prev_prop_details%FOUND then
297: hr_utility.set_location('Cursor found:',35);
293: hr_utility.set_location('l_date_to:'||l_date_to,25);
294:
295:
296: if csr_prev_prop_details%FOUND then
297: hr_utility.set_location('Cursor found:',35);
298: if l_date_to is null OR l_date_to > p_date_to then
299: hr_utility.set_location('About to update',45);
300: update per_pay_proposals
301: set date_to = p_date_to,
295:
296: if csr_prev_prop_details%FOUND then
297: hr_utility.set_location('Cursor found:',35);
298: if l_date_to is null OR l_date_to > p_date_to then
299: hr_utility.set_location('About to update',45);
300: update per_pay_proposals
301: set date_to = p_date_to,
302: -- added by vkodedal fix for 6831216
303: last_update_date = sysdate,
305: last_update_login = fnd_global.login_id
306: -- end of fix
307: where assignment_id = p_assignment_id
308: and pay_proposal_id = l_pay_proposal_id;
309: hr_utility.set_location('Updated successfuly:',85);
310: end if;
311: end if;
312: CLOSE csr_prev_prop_details;
313: */
320: end_date_approved_proposal (p_assignment_id, p_date_to, p_proposal_id);
321: end if;
322: CLOSE chk_approved_flg;
323:
324: hr_utility.set_location('Leaving:'||l_proc,5);
325:
326: end end_date_salary_proposal;
327:
328:
351: --
352: begin
353: --
354:
355: hr_utility.set_location('Entering:'||l_proc,5);
356: --
357: if (p_pay_proposal_id is not null)
358: then
359: open c_pay_proposal;
363: open c_asg_pay_basis_id(l_assignment_id , l_deleted_proposal_date);
364: fetch c_asg_pay_basis_id into l_curr_pay_basis_id;
365: close c_asg_pay_basis_id;
366: --
367: hr_utility.set_location('Current pay_basis_id:'||l_curr_pay_basis_id,10);
368: --
369: --
370: open c_asg_pay_basis_id(l_assignment_id , l_deleted_proposal_date-1);
371: fetch c_asg_pay_basis_id into l_prev_pay_basis_id;
370: open c_asg_pay_basis_id(l_assignment_id , l_deleted_proposal_date-1);
371: fetch c_asg_pay_basis_id into l_prev_pay_basis_id;
372: close c_asg_pay_basis_id;
373: --
374: hr_utility.set_location('Previous pay_basis_id:'||l_prev_pay_basis_id,20);
375: --
376:
377: --
378: -- if pay_basis_id for the assignment is different don't extend
379: --
380: if (l_curr_pay_basis_id is null or l_prev_pay_basis_id is null
381: or l_curr_pay_basis_id<>l_prev_pay_basis_id) then
382: --
383: hr_utility.set_location('Exiting1:'||l_proc,50);
384: --
385: return;
386: end if;
387: /* changed to adjust the date_to after deletion of a proposal. Bug#7386307 by schowdhu */
428: */
429:
430: end if;
431: --
432: hr_utility.set_location('Exiting2:'||l_proc,50);
433:
434: --
435: end;
436:
583: --
584: --
585: begin
586: --
587: hr_utility.set_location('Entering:'||l_proc,5);
588: l_date_to := p_date_to;
589:
590: open csr_get_element_detail;
591: fetch csr_get_element_detail into l_element_type_id,
592: l_input_value_id,
593: l_pay_annualization_factor,
594: l_pay_basis;
595: if csr_get_element_detail%notfound then
596: hr_utility.set_location(l_proc,10);
597: close csr_get_element_detail;
598: hr_utility.set_message(801,'HR_289855_SAL_ASS_NOT_SAL_ELIG');
599: hr_utility.raise_error;
600: else
594: l_pay_basis;
595: if csr_get_element_detail%notfound then
596: hr_utility.set_location(l_proc,10);
597: close csr_get_element_detail;
598: hr_utility.set_message(801,'HR_289855_SAL_ASS_NOT_SAL_ELIG');
599: hr_utility.raise_error;
600: else
601: close csr_get_element_detail;
602: per_pay_proposals_populate.get_payroll(p_assignment_id
595: if csr_get_element_detail%notfound then
596: hr_utility.set_location(l_proc,10);
597: close csr_get_element_detail;
598: hr_utility.set_message(801,'HR_289855_SAL_ASS_NOT_SAL_ELIG');
599: hr_utility.raise_error;
600: else
601: close csr_get_element_detail;
602: per_pay_proposals_populate.get_payroll(p_assignment_id
603: ,p_change_date
603: ,p_change_date
604: ,l_dummy_v
605: ,l_payroll_annualization_factor);
606: --
607: hr_utility.set_location(l_proc,15);
608: --
609: if(l_pay_annualization_factor is null and l_pay_basis='PERIOD') then
610: l_pay_annualization_factor:=l_payroll_annualization_factor;
611: end if;
615: /l_payroll_annualization_factor;
616: --
617: if (l_element_type_id IS NULL OR l_input_value_id IS NULL)
618: then
619: hr_utility.set_location(l_proc,20);
620: hr_utility.set_message(801,'HR_289855_SAL_ASS_NOT_SAL_ELIG');
621: hr_utility.raise_error;
622: else
623: --
616: --
617: if (l_element_type_id IS NULL OR l_input_value_id IS NULL)
618: then
619: hr_utility.set_location(l_proc,20);
620: hr_utility.set_message(801,'HR_289855_SAL_ASS_NOT_SAL_ELIG');
621: hr_utility.raise_error;
622: else
623: --
624: -- get the payroll element if it exists
617: if (l_element_type_id IS NULL OR l_input_value_id IS NULL)
618: then
619: hr_utility.set_location(l_proc,20);
620: hr_utility.set_message(801,'HR_289855_SAL_ASS_NOT_SAL_ELIG');
621: hr_utility.raise_error;
622: else
623: --
624: -- get the payroll element if it exists
625: --
625: --
626: open get_payroll_element(l_element_type_id);
627: fetch get_payroll_element into l_input_value_id2;
628: if(get_payroll_element%notfound) then
629: hr_utility.set_location(l_proc,25);
630: close get_payroll_element;
631: l_input_value_id2:=null;
632: l_entry_value2:=null;
633: else
636: --
637: if (p_element_entry_id is null) THEN
638: -- this must be a new entry so do the inserting of the element
639: --
640: hr_utility.set_location(l_proc,30);
641: l_element_link_id := hr_entry_api.get_link
642: (p_assignment_id
643: ,l_element_type_id
644: ,p_change_date);
642: (p_assignment_id
643: ,l_element_type_id
644: ,p_change_date);
645: if l_element_link_id IS NULL then
646: hr_utility.set_location(l_proc,35);
647: hr_utility.set_message(801,'HR_13016_SAL_ELE_NOT_ELIG');
648: hr_utility.raise_error;
649: end if;
650: hr_utility.set_location(l_proc,40);
643: ,l_element_type_id
644: ,p_change_date);
645: if l_element_link_id IS NULL then
646: hr_utility.set_location(l_proc,35);
647: hr_utility.set_message(801,'HR_13016_SAL_ELE_NOT_ELIG');
648: hr_utility.raise_error;
649: end if;
650: hr_utility.set_location(l_proc,40);
651: open get_existing_date;
644: ,p_change_date);
645: if l_element_link_id IS NULL then
646: hr_utility.set_location(l_proc,35);
647: hr_utility.set_message(801,'HR_13016_SAL_ELE_NOT_ELIG');
648: hr_utility.raise_error;
649: end if;
650: hr_utility.set_location(l_proc,40);
651: open get_existing_date;
652: fetch get_existing_date into l_dummy;
646: hr_utility.set_location(l_proc,35);
647: hr_utility.set_message(801,'HR_13016_SAL_ELE_NOT_ELIG');
648: hr_utility.raise_error;
649: end if;
650: hr_utility.set_location(l_proc,40);
651: open get_existing_date;
652: fetch get_existing_date into l_dummy;
653: if(get_existing_date%found) then
654: close get_existing_date;
651: open get_existing_date;
652: fetch get_existing_date into l_dummy;
653: if(get_existing_date%found) then
654: close get_existing_date;
655: hr_utility.set_location(l_proc,45);
656: hr_utility.set_message(801,'HR_13003_SAL_SAL_CHANGE_EXISTS');
657: hr_utility.raise_error;
658: else
659: close get_existing_date;
652: fetch get_existing_date into l_dummy;
653: if(get_existing_date%found) then
654: close get_existing_date;
655: hr_utility.set_location(l_proc,45);
656: hr_utility.set_message(801,'HR_13003_SAL_SAL_CHANGE_EXISTS');
657: hr_utility.raise_error;
658: else
659: close get_existing_date;
660: --
653: if(get_existing_date%found) then
654: close get_existing_date;
655: hr_utility.set_location(l_proc,45);
656: hr_utility.set_message(801,'HR_13003_SAL_SAL_CHANGE_EXISTS');
657: hr_utility.raise_error;
658: else
659: close get_existing_date;
660: --
661: -- Now we insert an element entry for this proposal
660: --
661: -- Now we insert an element entry for this proposal
662: -- by calling the insert_element_entry_api.
663: --
664: hr_utility.set_location(l_proc,50);
665: hr_entry_api.insert_element_entry
666: (p_effective_start_date =>l_effective_start_date
667: ,p_effective_end_date => l_effective_end_date
668: ,p_element_entry_id => p_element_entry_id
678: );
679: end if;
680:
681: else
682: hr_utility.set_location(l_proc,65);
683: hr_entry_api.update_element_entry
684: (p_dt_update_mode => get_dt_mode(p_change_date,p_element_entry_id)
685: ,p_session_date => p_change_date
686: ,p_check_for_update => 'Y'
693: ,p_entry_value2 => l_entry_value2
694: );
695: end if;
696:
697: hr_utility.set_location('Effective End Date of the element entry:'||l_effective_end_date,69);
698:
699: OPEN get_last_date;
700: FETCH get_last_date INTO l_last_date;
701: CLOSE get_last_date;
715: CLOSE Csr_Entry_End_Date;
716:
717: IF l_date_to > l_Entry_End_Date THEN
718: FOR i in csr_element_entries LOOP
719: hr_utility.set_location('Inside the loop'||i.effective_start_date,69);
720: hr_entry_api.delete_element_entry
721: ('DELETE_NEXT_CHANGE',
722: i.effective_end_date,
723: p_element_entry_id);
736: ,p_input_value_id2 => l_input_value_id2
737: ,p_entry_value2 => 0
738: );
739: ELSE
740: hr_utility.set_location('The element entry end date and the date_to are matching',89);
741: END IF; --l_date_to and element entry date comparisons
742: end if;
743: end if;
744:
749: ,p_effective_date => p_change_date
750: ,p_called_from => 'SAL');
751: --End changes for position control rule on sal proposal
752: --
753: hr_utility.set_location('Leaving:'||l_proc,70);
754: end maintain_elements_bsp;
755: --
756: -- ----------------------------------------------------------------------------
757: -- |----------------------< insert_salary_proposal >--------------------------|
829:
830: --
831: --
832: begin
833: hr_utility.set_location('Entering:'||l_proc,10);
834: --
835: -- Issue a savepoint
836: --
837: savepoint insert_salary_proposal;
1006: p_payroll_value => l_payroll_value,
1007: p_element_entry_id => l_element_entry_id);
1008: end if;
1009: --
1010: hr_utility.set_location(l_proc,20);
1011: if(p_approved='Y') then
1012: hr_utility.set_location(l_proc,30);
1013: -- parameter p_element_entry_id is change to l_element_entry_id to fix the bug#3488239.
1014: maintain_elements_bsp(l_pay_proposal_id
1008: end if;
1009: --
1010: hr_utility.set_location(l_proc,20);
1011: if(p_approved='Y') then
1012: hr_utility.set_location(l_proc,30);
1013: -- parameter p_element_entry_id is change to l_element_entry_id to fix the bug#3488239.
1014: maintain_elements_bsp(l_pay_proposal_id
1015: ,p_assignment_id
1016: ,p_change_date
1018: ,l_element_entry_id
1019: ,p_proposed_salary_n);
1020: end if;
1021: --
1022: hr_utility.set_location(l_proc, 40);
1023: --
1024: -- Call After Process User Hook for insert_salary_proposal
1025: --
1026: begin
1093: p_proposed_salary_warning := l_proposed_salary_warning;
1094: p_approved_warning := l_approved_warning;
1095: p_payroll_warning := l_payroll_warning;
1096: --
1097: hr_utility.set_location('Leaving: '||l_proc,50);
1098: --
1099: Exception
1100: When HR_Api.Validate_Enabled Then
1101: --
1116: p_payroll_warning := l_payroll_warning;
1117:
1118: p_element_entry_id := l_temp_element_entry_id;
1119: --
1120: hr_utility.set_location(' Leaving:'||l_proc, 60);
1121: --
1122: When others then
1123: --
1124: -- A validation or unexpected error has occured
1130: p_proposed_salary_warning := null;
1131: p_approved_warning := null;
1132: p_payroll_warning := null;
1133: p_element_entry_id := l_temp_element_entry_id;
1134: hr_utility.set_location(' Leaving:'||l_proc, 70);
1135: raise;
1136: --
1137: end insert_salary_proposal;
1138: --
1327:
1328: --
1329: begin
1330:
1331: hr_utility.set_location('Entering:'||l_proc,5);
1332: --
1333: -- Issue a savepoint
1334: --
1335: savepoint update_salary_proposal;
1489:
1490: -- Now we maintain an element entry for this proposal
1491: -- by calling the maintain_elements_bsp.
1492: --
1493: hr_utility.set_location(l_proc,10);
1494:
1495: if(p_approved='Y') then
1496: hr_utility.set_location(l_proc,15);
1497: open get_element;
1492: --
1493: hr_utility.set_location(l_proc,10);
1494:
1495: if(p_approved='Y') then
1496: hr_utility.set_location(l_proc,15);
1497: open get_element;
1498: fetch get_element into l_element_entry_id,l_assignment_id;
1499: if get_element%found then
1500: close get_element;
1497: open get_element;
1498: fetch get_element into l_element_entry_id,l_assignment_id;
1499: if get_element%found then
1500: close get_element;
1501: hr_utility.set_location(l_proc,20);
1502: --
1503: if p_proposed_salary_n = hr_api.g_number then
1504: l_proposed_salary_n:=per_pyp_shd.g_old_rec.proposed_salary_n;
1505: else
1511: ,l_date_to
1512: ,l_element_entry_id
1513: ,l_proposed_salary_n);
1514: else
1515: hr_utility.set_location(l_proc,25);
1516: l_element_entry_id := null;
1517: select pyp.assignment_id
1518: into l_assignment_id
1519: from per_pay_proposals pyp
1601: p_proposed_salary_warning := l_proposed_salary_warning;
1602: p_approved_warning := l_approved_warning;
1603: p_payroll_warning := l_payroll_warning;
1604: --
1605: hr_utility.set_location('Leaving: '||l_proc,20);
1606: --
1607: Exception
1608: When HR_Api.Validate_Enabled Then
1609: --
1621: p_approved_warning := l_approved_warning;
1622: p_payroll_warning := l_payroll_warning;
1623: p_object_version_number := l_temp_ovn;
1624: --
1625: hr_utility.set_location(' Leaving:'||l_proc, 25);
1626: --
1627: When others then
1628: --
1629: -- A validation or unexpected error has occured
1633: p_proposed_salary_warning := null;
1634: p_approved_warning := null;
1635: p_payroll_warning := null;
1636: p_object_version_number := l_temp_ovn;
1637: hr_utility.set_location(' Leaving:'||l_proc, 30);
1638: raise;
1639: --
1640: end update_salary_proposal;
1641: --
1801: from per_pay_proposals
1802: where pay_proposal_id = p_pay_proposal_id;
1803:
1804: begin
1805: hr_utility.set_location('Entering:'||l_proc,5);
1806: --
1807: -- Issue a savepoint
1808: --
1809: savepoint approve_salary_proposal;
1877:
1878: -- Now we maintain an element entry for this proposal
1879: -- by calling the maintain_elements_bsp.
1880: --
1881: hr_utility.set_location(l_proc,10);
1882: --
1883: -- Bug 1732348 Fix
1884: l_assignment_id:=per_pyp_shd.g_old_rec.assignment_id;
1885: open get_element;
1945: p_approved_warning := l_approved_warning;
1946: p_payroll_warning := l_payroll_warning;
1947: p_error_text := l_error_text;
1948: --
1949: hr_utility.set_location('Leaving: '||l_proc,15);
1950: --
1951: Exception
1952: When HR_Api.Validate_Enabled Then
1953: --
1966: p_payroll_warning := l_payroll_warning;
1967: p_error_text := null;
1968: p_object_version_number := l_temp_ovn;
1969: --
1970: hr_utility.set_location(' Leaving:'||l_proc, 20);
1971: --
1972: When others then
1973: --
1974: -- A validation or unexpected error has occured
1982: p_payroll_warning := null;
1983: p_object_version_number := l_temp_ovn;
1984: p_error_text := sqlerrm;
1985: --
1986: hr_utility.set_location(' Leaving:'||l_proc, 25);
1987: -- raise;
1988: --
1989: end approve_salary_proposal;
1990: --
2045: where pay_proposal_id = p_pay_proposal_id;
2046:
2047:
2048: begin
2049: hr_utility.set_location('Entering:'||l_proc,5);
2050: --
2051: --
2052: -- Issue a savepoint
2053: --
2082: ,p_object_version_number=>l_components.object_version_number
2083: ,p_validation_strength=>'WEAK'
2084: ,p_validate=>FALSE);
2085: END LOOP;
2086: hr_utility.set_location(l_proc,10);
2087:
2088: OPEN Csr_proposal_details;
2089: fetch Csr_proposal_details into l_approved,l_last_change_date, l_assignment_id;
2090: close Csr_proposal_details;
2098: -- delete the element entries
2099: --
2100: if (l_element_entry_id is not null) then
2101: --
2102: hr_utility.set_location(l_proc,15);
2103: begin
2104: --
2105: select 'Y'
2106: into v_zap
2116: exception
2117: when no_data_found
2118: then
2119: v_delete_next_change := TRUE;
2120: hr_utility.set_location(l_proc,20);
2121: --
2122: end;
2123: --
2124: v_zap_entry := (v_zap = 'Y');
2141: --
2142:
2143: -- then delete the proposal
2144: --
2145: hr_utility.set_location(l_proc,25);
2146: per_pyp_del.del(p_pay_proposal_id=>p_pay_proposal_id
2147: ,p_object_version_number=>p_object_version_number
2148: ,p_validate=>FALSE
2149: ,p_salary_warning=>l_salary_warning);
2158: CLOSE csr_future_element_entries;
2159:
2160: if l_future_element_entries > 0 then
2161:
2162: hr_utility.set_message(800,'PER_SAL_FIRST_PROPOSAL_DELETE');
2163: hr_utility.raise_error;
2164:
2165: end if;
2166:
2159:
2160: if l_future_element_entries > 0 then
2161:
2162: hr_utility.set_message(800,'PER_SAL_FIRST_PROPOSAL_DELETE');
2163: hr_utility.raise_error;
2164:
2165: end if;
2166:
2167:
2164:
2165: end if;
2166:
2167:
2168: hr_utility.set_location(l_proc,30);
2169: -- call API to zap entry
2170: hr_entry_api.delete_element_entry
2171: ('ZAP',
2172: l_change_date,
2172: l_change_date,
2173: l_element_entry_id);
2174: elsif (v_delete_next_change = TRUE)
2175: then
2176: hr_utility.set_location(l_proc,35);
2177: -- Call API to do a 'DELETE_NEXT_CHANGE'
2178: hr_entry_api.delete_element_entry
2179: ('DELETE_NEXT_CHANGE',
2180: l_change_date - 1,
2218: -- Set OUT parameters
2219: --
2220: p_salary_warning := l_salary_warning;
2221: --
2222: hr_utility.set_location('Leaving: '||l_proc,40);
2223: --
2224: Exception
2225: When HR_Api.Validate_Enabled Then
2226: --
2290: l_component_id per_pay_proposal_components.component_id%TYPE;
2291: l_object_version_number per_pay_proposal_components.object_version_number%TYPE;
2292: --
2293: begin
2294: hr_utility.set_location('Entering:'||l_proc,5);
2295: --
2296: --
2297: -- Issue a savepoint
2298: --
2439: --
2440: p_component_id := l_component_id;
2441: p_object_version_number := l_object_version_number;
2442: --
2443: hr_utility.set_location('Leaving: '||l_proc,10);
2444: --
2445: Exception
2446: When HR_Api.Validate_Enabled Then
2447: --
2510: l_object_version_number per_pay_proposal_components.object_version_number%TYPE;
2511: l_temp_ovn number := p_object_version_number;
2512: --
2513: begin
2514: hr_utility.set_location('Entering:'||l_proc,10);
2515: --
2516: --
2517: -- Issue a savepoint
2518: --
2657: -- Set OUT parameters
2658: --
2659: p_object_version_number := l_object_version_number;
2660: --
2661: hr_utility.set_location('Leaving: '||l_proc,20);
2662: --
2663: Exception
2664: When HR_Api.Validate_Enabled Then
2665: --
2674: -- A validation or unexpected error has occured
2675: --
2676: ROLLBACK TO update_proposal_components;
2677: p_object_version_number := l_temp_ovn;
2678: hr_utility.set_location(' Leaving:'||l_proc, 25);
2679: raise;
2680: --
2681: end update_proposal_component;
2682: --
2692: --
2693: l_proc varchar2(72) := g_package||'delete_proposal_component';
2694: --
2695: begin
2696: hr_utility.set_location('Entering:'||l_proc,5);
2697: --
2698: --
2699: -- Issue a savepoint
2700: --
2754: If p_validate then
2755: Raise HR_Api.Validate_Enabled;
2756: End If;
2757: --
2758: hr_utility.set_location('Leaving: '||l_proc,10);
2759: --
2760: Exception
2761: When HR_Api.Validate_Enabled Then
2762: --
2850: l_asg_type per_all_assignments_f.assignment_type%type;
2851: --
2852: begin
2853: --
2854: hr_utility.set_location('Entering:'|| l_proc, 10);
2855: --
2856: savepoint cre_or_upd_salary_proposal;
2857: --
2858:
2863:
2864: l_api_updating := per_pyp_shd.api_updating
2865: (p_pay_proposal_id => p_pay_proposal_id
2866: ,p_object_version_number => p_object_version_number);
2867: hr_utility.set_location(l_proc, 20);
2868:
2869: if (l_api_updating and l_date_to = hr_api.g_date) then
2870: l_date_to := hr_general.end_of_time;
2871: end if;
2916: --
2917: -- set g_old_rec to null
2918: --
2919: per_pyp_shd.g_old_rec:=l_null_pyp_rec;
2920: hr_utility.set_location(l_proc, 30);
2921: --
2922: -- convert the null values
2923: --
2924: hr_utility.set_location(l_proc, 40);
2920: hr_utility.set_location(l_proc, 30);
2921: --
2922: -- convert the null values
2923: --
2924: hr_utility.set_location(l_proc, 40);
2925: per_pyp_upd.convert_defs(l_pyp_rec);
2926: --
2927: hr_utility.set_location(l_proc, 45);
2928: --
2923: --
2924: hr_utility.set_location(l_proc, 40);
2925: per_pyp_upd.convert_defs(l_pyp_rec);
2926: --
2927: hr_utility.set_location(l_proc, 45);
2928: --
2929: open first_proposal;
2930: fetch first_proposal into l_dummy;
2931: if first_proposal%notfound then
2939: --Retain auto approve first proposal functionality if profile is null or set to Yes
2940:
2941: l_autoApprove:=fnd_profile.value('HR_AUTO_APPROVE_FIRST_PROPOSAL');
2942: if(l_autoApprove is null or l_autoApprove ='Y') then
2943: hr_utility.set_location(l_proc, 47);
2944: l_pyp_rec.approved:='Y';
2945: end if;
2946:
2947: else
2951: close first_proposal;
2952: end if;
2953: -- insert the data
2954: --
2955: hr_utility.set_location(l_proc, 50);
2956: hr_maintain_proposal_api.insert_salary_proposal
2957: (p_pay_proposal_id => l_pyp_rec.pay_proposal_id
2958: ,p_assignment_id => l_pyp_rec.assignment_id
2959: ,p_business_group_id => l_pyp_rec.business_group_id
2995: ,p_proposed_salary_warning => l_proposed_salary_warning
2996: ,p_approved_warning => l_approved_warning
2997: ,p_payroll_warning => l_payroll_warning
2998: );
2999: hr_utility.set_location(l_proc, 60);
3000: else
3001: --
3002: -- updating not inserting
3003: --
3000: else
3001: --
3002: -- updating not inserting
3003: --
3004: hr_utility.set_location(l_proc, 70);
3005: per_pyp_shd.lck
3006: (p_pay_proposal_id => p_pay_proposal_id
3007: ,p_object_version_number => p_object_version_number);
3008: --
3007: ,p_object_version_number => p_object_version_number);
3008: --
3009: -- convert the null values
3010: --
3011: hr_utility.set_location(l_proc, 80);
3012: per_pyp_upd.convert_defs(l_pyp_rec);
3013: --
3014: -- update the data
3015: --
3012: per_pyp_upd.convert_defs(l_pyp_rec);
3013: --
3014: -- update the data
3015: --
3016: hr_utility.set_location(l_proc, 90);
3017: --
3018: hr_maintain_proposal_api.update_salary_proposal
3019: (p_pay_proposal_id => l_pyp_rec.pay_proposal_id
3020: ,p_change_date => l_pyp_rec.change_date
3055: ,p_approved_warning => l_approved_warning
3056: ,p_payroll_warning => l_payroll_warning
3057: );
3058: --
3059: hr_utility.set_location(l_proc, 100);
3060: --
3061: end if;
3062: --
3063: if p_validate then
3063: if p_validate then
3064: raise hr_api.validate_enabled;
3065: end if;
3066: --
3067: hr_utility.set_location(l_proc, 110);
3068: --
3069: p_pay_proposal_id := l_pyp_rec.pay_proposal_id;
3070: p_object_version_number := l_pyp_rec.object_version_number;
3071: p_inv_next_sal_date_warning := l_inv_next_sal_date_warning;
3072: p_proposed_salary_warning := l_proposed_salary_warning;
3073: p_approved_warning := l_approved_warning;
3074: p_payroll_warning := l_payroll_warning;
3075: --
3076: hr_utility.set_location('Leaving:'||l_proc, 120);
3077: --
3078: exception
3079: when hr_api.validate_enabled then
3080: rollback to cre_or_upd_salary_proposal;
3083: p_inv_next_sal_date_warning := l_inv_next_sal_date_warning;
3084: p_proposed_salary_warning := l_proposed_salary_warning;
3085: p_approved_warning := l_approved_warning;
3086: p_payroll_warning := l_payroll_warning;
3087: hr_utility.set_location('Leaving:'||l_proc, 130);
3088: when others then
3089: rollback to cre_or_upd_salary_proposal;
3090: -- Reset IN OUT and OUT parameters.
3091: p_pay_proposal_id := l_temp_pay_proposal_id;
3093: p_inv_next_sal_date_warning := null;
3094: p_proposed_salary_warning := null;
3095: p_approved_warning := null;
3096: p_payroll_warning := null;
3097: hr_utility.set_location('Leaving:'||l_proc, 140);
3098: raise;
3099: --
3100: end cre_or_upd_salary_proposal;
3101: --
3250: where ppc.pay_proposal_id=p_pay_proposal_id
3251: and ppc.business_group_id=p_business_group_id;
3252: --
3253: begin
3254: hr_utility.set_location('Entering:'||l_proc,5);
3255: --
3256: --
3257: -- Issue a savepoint
3258: --
3260: --
3261: --
3262: FOR r_del_sp in c_del_salary_proposals( p_assignment_id ,p_date)
3263: LOOP
3264: hr_utility.set_location('Inside loop salary_proposal - '||
3265: r_del_sp.pay_proposal_id||l_proc,10);
3266: --
3267: -- first of all delete all of the components
3268: --
3268: --
3269: FOR l_components IN components(r_del_sp.pay_proposal_id,
3270: r_del_sp.business_group_id)
3271: LOOP
3272: hr_utility.set_location('Inside loop component - '||
3273: l_components.component_id||l_proc,15);
3274: per_ppc_del.del(p_component_id=>l_components.component_id
3275: ,p_object_version_number=>l_components.object_version_number
3276: ,p_validation_strength=>'WEAK'
3275: ,p_object_version_number=>l_components.object_version_number
3276: ,p_validation_strength=>'WEAK'
3277: ,p_validate=>FALSE);
3278: END LOOP;
3279: hr_utility.set_location(l_proc,20);
3280: --
3281: -- Update CWB table that created/updated the salary proposal
3282: --
3283: update BEN_CWB_PERSON_RATES
3288: --
3289: delete per_pay_proposals
3290: where pay_proposal_id = r_del_sp.pay_proposal_id;
3291: --
3292: hr_utility.set_location(l_proc,25);
3293: --
3294: END LOOP;
3295: hr_utility.set_location('Exiting:'||l_proc,50);
3296: EXCEPTION
3291: --
3292: hr_utility.set_location(l_proc,25);
3293: --
3294: END LOOP;
3295: hr_utility.set_location('Exiting:'||l_proc,50);
3296: EXCEPTION
3297: When others then
3298: --
3299: -- A validation or unexpected error has occured
3297: When others then
3298: --
3299: -- A validation or unexpected error has occured
3300: --
3301: hr_utility.set_location('When Others:'||l_proc,55);
3302: ROLLBACK TO delete_salary_proposal;
3303: raise;
3304: --
3305: --