84: and fetr.effective_start_date <=(select sysdate from dual)
85: and fetr.effective_end_date >=(select sysdate from dual);
86:
87: begin
88: hr_utility.trace('Entering PAY_US_EXTRA_PER_INFO_LEG_HOOK.person_check_nra_status_create');
89:
90: l_person_id := P_PERSON_ID;
91: l_information_type := P_INFORMATION_TYPE;
92: l_pei_information_category := P_PEI_INFORMATION_CATEGORY;
140: fnd_message.raise_error;
141: end if; */
142: end if;
143:
144: hr_utility.trace('Leaving PAY_US_EXTRA_PER_INFO_LEG_HOOK.person_check_nra_status_create');
145:
146: end person_check_nra_status_create;
147:
148:
231:
232:
233:
234: begin
235: hr_utility.trace('Entering PAY_US_EXTRA_PER_INFO_LEG_HOOK.person_check_nra_status_update');
236:
237: l_person_extra_info_id := P_PERSON_EXTRA_INFO_ID;
238: l_pei_information_category := P_PEI_INFORMATION_CATEGORY;
239: l_pei_information1 := P_PEI_INFORMATION1; /*student status*/
267: fetch get_fitexempt_fed into l_fit_exempt;
268: close get_fitexempt_fed;
269:
270: /*
271: hr_utility.trace('l_person_id '||l_person_id);
272: hr_utility.trace('l_information_type '||l_information_type);
273: hr_utility.trace('l_assignment_id '||l_assignment_id);
274: hr_utility.trace('l_wa_fed '||l_wa_fed);
275: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
268: close get_fitexempt_fed;
269:
270: /*
271: hr_utility.trace('l_person_id '||l_person_id);
272: hr_utility.trace('l_information_type '||l_information_type);
273: hr_utility.trace('l_assignment_id '||l_assignment_id);
274: hr_utility.trace('l_wa_fed '||l_wa_fed);
275: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
276: hr_utility.trace('l_fit_exempt '||l_fit_exempt);
269:
270: /*
271: hr_utility.trace('l_person_id '||l_person_id);
272: hr_utility.trace('l_information_type '||l_information_type);
273: hr_utility.trace('l_assignment_id '||l_assignment_id);
274: hr_utility.trace('l_wa_fed '||l_wa_fed);
275: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
276: hr_utility.trace('l_fit_exempt '||l_fit_exempt);
277: */
270: /*
271: hr_utility.trace('l_person_id '||l_person_id);
272: hr_utility.trace('l_information_type '||l_information_type);
273: hr_utility.trace('l_assignment_id '||l_assignment_id);
274: hr_utility.trace('l_wa_fed '||l_wa_fed);
275: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
276: hr_utility.trace('l_fit_exempt '||l_fit_exempt);
277: */
278:
271: hr_utility.trace('l_person_id '||l_person_id);
272: hr_utility.trace('l_information_type '||l_information_type);
273: hr_utility.trace('l_assignment_id '||l_assignment_id);
274: hr_utility.trace('l_wa_fed '||l_wa_fed);
275: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
276: hr_utility.trace('l_fit_exempt '||l_fit_exempt);
277: */
278:
279: /* if person is a student or a business appprentice his records are selected */
272: hr_utility.trace('l_information_type '||l_information_type);
273: hr_utility.trace('l_assignment_id '||l_assignment_id);
274: hr_utility.trace('l_wa_fed '||l_wa_fed);
275: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
276: hr_utility.trace('l_fit_exempt '||l_fit_exempt);
277: */
278:
279: /* if person is a student or a business appprentice his records are selected */
280: open csr_chk_student_status;
309: end if;
310: end if;
311:
312: /*
313: hr_utility.trace('l_student_flag '||l_student_flag);
314: hr_utility.trace('l_information_type '||l_information_type);
315: hr_utility.trace('l_pei_information_category '||l_pei_information_category);
316: hr_utility.trace('l_pei_information5 '||l_pei_information5);
317: hr_utility.trace('l_pei_information9 '||l_pei_information9);
310: end if;
311:
312: /*
313: hr_utility.trace('l_student_flag '||l_student_flag);
314: hr_utility.trace('l_information_type '||l_information_type);
315: hr_utility.trace('l_pei_information_category '||l_pei_information_category);
316: hr_utility.trace('l_pei_information5 '||l_pei_information5);
317: hr_utility.trace('l_pei_information9 '||l_pei_information9);
318: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
311:
312: /*
313: hr_utility.trace('l_student_flag '||l_student_flag);
314: hr_utility.trace('l_information_type '||l_information_type);
315: hr_utility.trace('l_pei_information_category '||l_pei_information_category);
316: hr_utility.trace('l_pei_information5 '||l_pei_information5);
317: hr_utility.trace('l_pei_information9 '||l_pei_information9);
318: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
319: hr_utility.trace('l_fit_exempt '||l_fit_exempt);
312: /*
313: hr_utility.trace('l_student_flag '||l_student_flag);
314: hr_utility.trace('l_information_type '||l_information_type);
315: hr_utility.trace('l_pei_information_category '||l_pei_information_category);
316: hr_utility.trace('l_pei_information5 '||l_pei_information5);
317: hr_utility.trace('l_pei_information9 '||l_pei_information9);
318: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
319: hr_utility.trace('l_fit_exempt '||l_fit_exempt);
320: */
313: hr_utility.trace('l_student_flag '||l_student_flag);
314: hr_utility.trace('l_information_type '||l_information_type);
315: hr_utility.trace('l_pei_information_category '||l_pei_information_category);
316: hr_utility.trace('l_pei_information5 '||l_pei_information5);
317: hr_utility.trace('l_pei_information9 '||l_pei_information9);
318: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
319: hr_utility.trace('l_fit_exempt '||l_fit_exempt);
320: */
321:
314: hr_utility.trace('l_information_type '||l_information_type);
315: hr_utility.trace('l_pei_information_category '||l_pei_information_category);
316: hr_utility.trace('l_pei_information5 '||l_pei_information5);
317: hr_utility.trace('l_pei_information9 '||l_pei_information9);
318: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
319: hr_utility.trace('l_fit_exempt '||l_fit_exempt);
320: */
321:
322: if l_information_type like 'PER_US_ADDITIONAL_DETAILS'
315: hr_utility.trace('l_pei_information_category '||l_pei_information_category);
316: hr_utility.trace('l_pei_information5 '||l_pei_information5);
317: hr_utility.trace('l_pei_information9 '||l_pei_information9);
318: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
319: hr_utility.trace('l_fit_exempt '||l_fit_exempt);
320: */
321:
322: if l_information_type like 'PER_US_ADDITIONAL_DETAILS'
323: and l_pei_information_category like 'PER_US_ADDITIONAL_DETAILS'
341: fnd_message.raise_error;
342: end if; */
343: end if;
344:
345: hr_utility.trace('Leaving PAY_US_EXTRA_PER_INFO_LEG_HOOK.person_check_nra_status_update');
346:
347: end person_check_nra_status_update;
348:
349: end PAY_US_EXTRA_PER_INFO_LEG_HOOK ;