10: --
11: g_num_errors number := 0;
12: g_element_type_ids t_numbers;
13: --
14: g_debug boolean := hr_utility.debug_enabled;
15: --
16: -- |-------------------------------------------------------------------|
17: -- |----------------------< get_upgrade_status >-----------------------|
18: -- |-------------------------------------------------------------------|
126: and pai.action_information1 = paa.assignment_action_id
127: and rownum =1 ;
128:
129: begin
130: hr_utility.set_location('Entering: ' || c_proc, 10);
131: --
132: open csr_exists;
133: fetch csr_exists into p_valid_upgrade;
134: if csr_exists%notfound then
135: p_valid_upgrade := 'FALSE';
136: end if;
137: close csr_exists;
138: --
139: hr_utility.trace(p_valid_upgrade);
140: hr_utility.set_location('Leaving: ' || c_proc, 100);
141: end validate_pay_jp_pre_tax;
142: -- |-------------------------------------------------------------------|
143: -- |--------------------< qualify_pay_jp_pre_tax >---------------------|
136: end if;
137: close csr_exists;
138: --
139: hr_utility.trace(p_valid_upgrade);
140: hr_utility.set_location('Leaving: ' || c_proc, 100);
141: end validate_pay_jp_pre_tax;
142: -- |-------------------------------------------------------------------|
143: -- |--------------------< qualify_pay_jp_pre_tax >---------------------|
144: -- |-------------------------------------------------------------------|
171: and pai.action_information1 = paa.assignment_action_id
172: and rownum = 1;
173:
174: begin
175: hr_utility.set_location('Entering: ' || c_proc, 10);
176: --
177: open csr_ppt;
178: fetch csr_ppt into p_qualifier;
179: if csr_ppt%notfound then
180: p_qualifier := 'N';
181: end if;
182: close csr_ppt;
183: --
184: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
185: hr_utility.set_location('Leaving: ' || c_proc, 100);
186: end qualify_pay_jp_pre_tax;
187: -- |-------------------------------------------------------------------|
188: -- |----------------< upgrade_disaster_tax_reduction >-----------------|
181: end if;
182: close csr_ppt;
183: --
184: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
185: hr_utility.set_location('Leaving: ' || c_proc, 100);
186: end qualify_pay_jp_pre_tax;
187: -- |-------------------------------------------------------------------|
188: -- |----------------< upgrade_disaster_tax_reduction >-----------------|
189: -- |-------------------------------------------------------------------|
218: and ppt.action_status = 'C'
219: for update of ppt.pre_tax_id nowait;
220: */
221: begin
222: hr_utility.set_location('Entering: ' || c_proc, 10);
223: hr_utility.trace('assignment_id: ' || p_assignment_id);
224: --
225: -- When the following sql fails, it means JP post install has not
226: -- completed successfully because qualify procedure guarantees that
219: for update of ppt.pre_tax_id nowait;
220: */
221: begin
222: hr_utility.set_location('Entering: ' || c_proc, 10);
223: hr_utility.trace('assignment_id: ' || p_assignment_id);
224: --
225: -- When the following sql fails, it means JP post install has not
226: -- completed successfully because qualify procedure guarantees that
227: -- JP post install had been completed before.
247: set disaster_tax_reduction = l_balance
248: where rowid = l_assact.rowid;
249: */
250: --
251: hr_utility.trace(l_assact.disaster_tax_reduction || ' --> ' || l_balance);
252: end if;
253: end loop;
254: --
255: hr_utility.set_location('Leaving: ' || c_proc, 100);
251: hr_utility.trace(l_assact.disaster_tax_reduction || ' --> ' || l_balance);
252: end if;
253: end loop;
254: --
255: hr_utility.set_location('Leaving: ' || c_proc, 100);
256: end upgrade_disaster_tax_reduction;
257: -- |-------------------------------------------------------------------|
258: -- |-----------------------< validate_prev_job >-----------------------|
259: -- |-------------------------------------------------------------------|
273: and pet.legislation_code = 'JP'
274: and pel.element_type_id = pet.element_type_id
275: and pee.element_link_id = pel.element_link_id);
276: begin
277: hr_utility.set_location('Entering: ' || c_proc, 10);
278: --
279: open csr_exists;
280: fetch csr_exists into p_valid_upgrade;
281: if csr_exists%notfound then
282: p_valid_upgrade := 'FALSE';
283: end if;
284: close csr_exists;
285: --
286: hr_utility.trace(p_valid_upgrade);
287: hr_utility.set_location('Leaving: ' || c_proc, 100);
288: end validate_prev_job;
289: -- |-------------------------------------------------------------------|
290: -- |-----------------------< qualify_prev_job >------------------------|
283: end if;
284: close csr_exists;
285: --
286: hr_utility.trace(p_valid_upgrade);
287: hr_utility.set_location('Leaving: ' || c_proc, 100);
288: end validate_prev_job;
289: -- |-------------------------------------------------------------------|
290: -- |-----------------------< qualify_prev_job >------------------------|
291: -- |-------------------------------------------------------------------|
308: and pel.element_type_id = pet.element_type_id
309: and pee.assignment_id = p_assignment_id
310: and pee.element_link_id = pel.element_link_id);
311: begin
312: hr_utility.set_location('Entering: ' || c_proc, 10);
313: --
314: -- No need to check whether the assignment is "Payroll" assignment or not
315: -- not to raise error when creating previous employers by API because
316: -- non-recurring entries cannot be created for non-Payroll assignments.
321: p_qualifier := 'N';
322: end if;
323: close csr_ee;
324: --
325: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
326: hr_utility.set_location('Leaving: ' || c_proc, 100);
327: end qualify_prev_job;
328: -- |-------------------------------------------------------------------|
329: -- |-----------------------< upgrade_prev_job >------------------------|
322: end if;
323: close csr_ee;
324: --
325: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
326: hr_utility.set_location('Leaving: ' || c_proc, 100);
327: end qualify_prev_job;
328: -- |-------------------------------------------------------------------|
329: -- |-----------------------< upgrade_prev_job >------------------------|
330: -- |-------------------------------------------------------------------|
430: for update of previous_employer_id;
431: l_prev_employer csr_prev_employer%rowtype;
432: begin
433: begin
434: hr_utility.set_location('Entering: ' || c_proc, 10);
435: hr_utility.trace('assignment_id: ' || p_assignment_id);
436: --
437: select business_group_id,
438: person_id,
431: l_prev_employer csr_prev_employer%rowtype;
432: begin
433: begin
434: hr_utility.set_location('Entering: ' || c_proc, 10);
435: hr_utility.trace('assignment_id: ' || p_assignment_id);
436: --
437: select business_group_id,
438: person_id,
439: effective_start_date
456: and l_effective_date
457: between per.effective_start_date and per.effective_end_date
458: and bg.business_group_id = per.business_group_id;
459: --
460: hr_utility.set_location(c_proc, 20);
461: --
462: -- When the following sql fails, it means JP post install has not
463: -- completed successfully because qualify procedure guarantees that
464: -- JP post install had been completed before.
465: -- To fix no_data_found error here, need to complete JP post install
466: -- before applying this.
467: --
468: for l_prev_job in csr_ee loop
469: hr_utility.set_location(c_proc, 30);
470: --
471: hr_utility.trace('employment_income : ' || l_prev_job.employment_income);
472: hr_utility.trace('si_prems : ' || l_prev_job.si_prems);
473: hr_utility.trace('mutual_aid_prem : ' || l_prev_job.mutual_aid_prem);
467: --
468: for l_prev_job in csr_ee loop
469: hr_utility.set_location(c_proc, 30);
470: --
471: hr_utility.trace('employment_income : ' || l_prev_job.employment_income);
472: hr_utility.trace('si_prems : ' || l_prev_job.si_prems);
473: hr_utility.trace('mutual_aid_prem : ' || l_prev_job.mutual_aid_prem);
474: hr_utility.trace('withholding_tax : ' || l_prev_job.withholding_tax);
475: hr_utility.trace('termination_date : ' || l_prev_job.termination_date);
468: for l_prev_job in csr_ee loop
469: hr_utility.set_location(c_proc, 30);
470: --
471: hr_utility.trace('employment_income : ' || l_prev_job.employment_income);
472: hr_utility.trace('si_prems : ' || l_prev_job.si_prems);
473: hr_utility.trace('mutual_aid_prem : ' || l_prev_job.mutual_aid_prem);
474: hr_utility.trace('withholding_tax : ' || l_prev_job.withholding_tax);
475: hr_utility.trace('termination_date : ' || l_prev_job.termination_date);
476: hr_utility.trace('foreign_flag : ' || l_prev_job.foreign_flag);
469: hr_utility.set_location(c_proc, 30);
470: --
471: hr_utility.trace('employment_income : ' || l_prev_job.employment_income);
472: hr_utility.trace('si_prems : ' || l_prev_job.si_prems);
473: hr_utility.trace('mutual_aid_prem : ' || l_prev_job.mutual_aid_prem);
474: hr_utility.trace('withholding_tax : ' || l_prev_job.withholding_tax);
475: hr_utility.trace('termination_date : ' || l_prev_job.termination_date);
476: hr_utility.trace('foreign_flag : ' || l_prev_job.foreign_flag);
477: hr_utility.trace('employer_address_kana: ' || l_prev_job.employer_address_kana);
470: --
471: hr_utility.trace('employment_income : ' || l_prev_job.employment_income);
472: hr_utility.trace('si_prems : ' || l_prev_job.si_prems);
473: hr_utility.trace('mutual_aid_prem : ' || l_prev_job.mutual_aid_prem);
474: hr_utility.trace('withholding_tax : ' || l_prev_job.withholding_tax);
475: hr_utility.trace('termination_date : ' || l_prev_job.termination_date);
476: hr_utility.trace('foreign_flag : ' || l_prev_job.foreign_flag);
477: hr_utility.trace('employer_address_kana: ' || l_prev_job.employer_address_kana);
478: hr_utility.trace('employer_address : ' || l_prev_job.employer_address);
471: hr_utility.trace('employment_income : ' || l_prev_job.employment_income);
472: hr_utility.trace('si_prems : ' || l_prev_job.si_prems);
473: hr_utility.trace('mutual_aid_prem : ' || l_prev_job.mutual_aid_prem);
474: hr_utility.trace('withholding_tax : ' || l_prev_job.withholding_tax);
475: hr_utility.trace('termination_date : ' || l_prev_job.termination_date);
476: hr_utility.trace('foreign_flag : ' || l_prev_job.foreign_flag);
477: hr_utility.trace('employer_address_kana: ' || l_prev_job.employer_address_kana);
478: hr_utility.trace('employer_address : ' || l_prev_job.employer_address);
479: hr_utility.trace('employer_name_kana : ' || l_prev_job.employer_name_kana);
472: hr_utility.trace('si_prems : ' || l_prev_job.si_prems);
473: hr_utility.trace('mutual_aid_prem : ' || l_prev_job.mutual_aid_prem);
474: hr_utility.trace('withholding_tax : ' || l_prev_job.withholding_tax);
475: hr_utility.trace('termination_date : ' || l_prev_job.termination_date);
476: hr_utility.trace('foreign_flag : ' || l_prev_job.foreign_flag);
477: hr_utility.trace('employer_address_kana: ' || l_prev_job.employer_address_kana);
478: hr_utility.trace('employer_address : ' || l_prev_job.employer_address);
479: hr_utility.trace('employer_name_kana : ' || l_prev_job.employer_name_kana);
480: hr_utility.trace('employer_name : ' || l_prev_job.employer_name);
473: hr_utility.trace('mutual_aid_prem : ' || l_prev_job.mutual_aid_prem);
474: hr_utility.trace('withholding_tax : ' || l_prev_job.withholding_tax);
475: hr_utility.trace('termination_date : ' || l_prev_job.termination_date);
476: hr_utility.trace('foreign_flag : ' || l_prev_job.foreign_flag);
477: hr_utility.trace('employer_address_kana: ' || l_prev_job.employer_address_kana);
478: hr_utility.trace('employer_address : ' || l_prev_job.employer_address);
479: hr_utility.trace('employer_name_kana : ' || l_prev_job.employer_name_kana);
480: hr_utility.trace('employer_name : ' || l_prev_job.employer_name);
481: --
474: hr_utility.trace('withholding_tax : ' || l_prev_job.withholding_tax);
475: hr_utility.trace('termination_date : ' || l_prev_job.termination_date);
476: hr_utility.trace('foreign_flag : ' || l_prev_job.foreign_flag);
477: hr_utility.trace('employer_address_kana: ' || l_prev_job.employer_address_kana);
478: hr_utility.trace('employer_address : ' || l_prev_job.employer_address);
479: hr_utility.trace('employer_name_kana : ' || l_prev_job.employer_name_kana);
480: hr_utility.trace('employer_name : ' || l_prev_job.employer_name);
481: --
482: open csr_prev_employer( l_person_id,
475: hr_utility.trace('termination_date : ' || l_prev_job.termination_date);
476: hr_utility.trace('foreign_flag : ' || l_prev_job.foreign_flag);
477: hr_utility.trace('employer_address_kana: ' || l_prev_job.employer_address_kana);
478: hr_utility.trace('employer_address : ' || l_prev_job.employer_address);
479: hr_utility.trace('employer_name_kana : ' || l_prev_job.employer_name_kana);
480: hr_utility.trace('employer_name : ' || l_prev_job.employer_name);
481: --
482: open csr_prev_employer( l_person_id,
483: l_prev_job.employer_name,
476: hr_utility.trace('foreign_flag : ' || l_prev_job.foreign_flag);
477: hr_utility.trace('employer_address_kana: ' || l_prev_job.employer_address_kana);
478: hr_utility.trace('employer_address : ' || l_prev_job.employer_address);
479: hr_utility.trace('employer_name_kana : ' || l_prev_job.employer_name_kana);
480: hr_utility.trace('employer_name : ' || l_prev_job.employer_name);
481: --
482: open csr_prev_employer( l_person_id,
483: l_prev_job.employer_name,
484: l_prev_job.foreign_flag,
490: -- 2) Termination Date is not different.
491: -- 3) Country is not different.
492: --
493: if csr_prev_employer%found then
494: hr_utility.trace('Updating PER_PREVIOUS_EMPLOYERS...');
495: --
496: if l_prev_employer.end_date is null then
497: l_prev_employer.end_date := l_prev_job.termination_date;
498: end if;
523: P_PEM_INFORMATION5 => fnd_number.number_to_canonical(l_prev_job.mutual_aid_prem),
524: P_PEM_INFORMATION6 => fnd_number.number_to_canonical(l_prev_job.withholding_tax),
525: P_OBJECT_VERSION_NUMBER => l_prev_employer.object_version_number);
526: else
527: hr_utility.trace('Inserting PER_PREVIOUS_EMPLOYERS...');
528: --
529: l_prev_employer := null;
530: --
531: if l_prev_job.foreign_flag = 'Y' then
555: end if;
556: close csr_prev_employer;
557: end loop;
558: --
559: hr_utility.set_location('Leaving: ' || c_proc, 100);
560: exception
561: when app_exception.application_exception then
562: app_exception.raise_exception;
563: end;
617: and ppa.business_group_id = bg.business_group_id
618: and paa.payroll_action_id = ppa.payroll_action_id
619: and prr.assignment_action_id = paa.assignment_action_id);
620: begin
621: hr_utility.set_location('Entering: ' || c_proc, 10);
622: --
623: open csr_exists;
624: fetch csr_exists into l_exists;
625: if csr_exists%notfound then
626: l_exists := 'N';
627: end if;
628: close csr_exists;
629: --
630: hr_utility.trace('Exists? : ' || l_exists);
631: hr_utility.set_location('Leaving: ' || c_proc, 100);
632: --
633: return (l_exists = 'Y');
634: end entries_or_results_exist;
627: end if;
628: close csr_exists;
629: --
630: hr_utility.trace('Exists? : ' || l_exists);
631: hr_utility.set_location('Leaving: ' || c_proc, 100);
632: --
633: return (l_exists = 'Y');
634: end entries_or_results_exist;
635: -- |-------------------------------------------------------------------|
659: select null
660: from pay_run_results prr
661: where prr.element_type_id = p_element_type_id);
662: begin
663: hr_utility.set_location('Entering: ' || c_proc, 10);
664: --
665: open csr_exists;
666: fetch csr_exists into l_exists;
667: if csr_exists%notfound then
668: l_exists := 'N';
669: end if;
670: close csr_exists;
671: --
672: hr_utility.trace('Exists? : ' || l_exists);
673: hr_utility.set_location('Leaving: ' || c_proc, 100);
674: --
675: return (l_exists = 'Y');
676: end entries_or_results_exist;
669: end if;
670: close csr_exists;
671: --
672: hr_utility.trace('Exists? : ' || l_exists);
673: hr_utility.set_location('Leaving: ' || c_proc, 100);
674: --
675: return (l_exists = 'Y');
676: end entries_or_results_exist;
677: -- |-------------------------------------------------------------------|
697: pay_run_results prr
698: where paa.assignment_id = p_assignment_id
699: and prr.assignment_action_id = paa.assignment_action_id);
700: begin
701: hr_utility.set_location('Entering: ' || c_proc, 10);
702: --
703: open csr_exists;
704: fetch csr_exists into l_exists;
705: if csr_exists%notfound then
706: l_exists := 'N';
707: end if;
708: close csr_exists;
709: --
710: hr_utility.trace(p_assignment_id || ' : ' || l_exists);
711: hr_utility.set_location('Leaving: ' || c_proc, 100);
712: --
713: return (l_exists = 'Y');
714: end entries_or_results_exist;
707: end if;
708: close csr_exists;
709: --
710: hr_utility.trace(p_assignment_id || ' : ' || l_exists);
711: hr_utility.set_location('Leaving: ' || c_proc, 100);
712: --
713: return (l_exists = 'Y');
714: end entries_or_results_exist;
715: -- |-------------------------------------------------------------------|
749: where paa.assignment_id = p_assignment_id
750: and prr.assignment_action_id = paa.assignment_action_id
751: and prr.element_type_id = p_element_type_id);
752: begin
753: hr_utility.set_location('Entering: ' || c_proc, 10);
754: --
755: open csr_exists;
756: fetch csr_exists into l_exists;
757: if csr_exists%notfound then
758: l_exists := 'N';
759: end if;
760: close csr_exists;
761: --
762: hr_utility.trace(p_assignment_id || ' : ' || l_exists);
763: hr_utility.set_location('Leaving: ' || c_proc, 100);
764: --
765: return (l_exists = 'Y');
766: end entries_or_results_exist;
759: end if;
760: close csr_exists;
761: --
762: hr_utility.trace(p_assignment_id || ' : ' || l_exists);
763: hr_utility.set_location('Leaving: ' || c_proc, 100);
764: --
765: return (l_exists = 'Y');
766: end entries_or_results_exist;
767: -- |-------------------------------------------------------------------|
794: where pliv.element_link_id = pel.element_link_id
795: and pliv.input_value_id = piv.input_value_id)
796: group by pel.element_link_id, piv.input_value_id;
797: begin
798: hr_utility.set_location('Entering: ' || c_proc, 10);
799: --
800: if p_element_type_id is not null then
801: for l_rec in csr_link loop
802: hr_utility.trace('******************************');
798: hr_utility.set_location('Entering: ' || c_proc, 10);
799: --
800: if p_element_type_id is not null then
801: for l_rec in csr_link loop
802: hr_utility.trace('******************************');
803: hr_utility.trace('element_link_id : ' || l_rec.element_link_id);
804: hr_utility.trace('input_value_id : ' || l_rec.input_value_id);
805: hr_utility.trace('effective_start_date : ' || l_rec.effective_start_date);
806: hr_utility.trace('effective_end_date : ' || l_rec.effective_end_date);
799: --
800: if p_element_type_id is not null then
801: for l_rec in csr_link loop
802: hr_utility.trace('******************************');
803: hr_utility.trace('element_link_id : ' || l_rec.element_link_id);
804: hr_utility.trace('input_value_id : ' || l_rec.input_value_id);
805: hr_utility.trace('effective_start_date : ' || l_rec.effective_start_date);
806: hr_utility.trace('effective_end_date : ' || l_rec.effective_end_date);
807: --
800: if p_element_type_id is not null then
801: for l_rec in csr_link loop
802: hr_utility.trace('******************************');
803: hr_utility.trace('element_link_id : ' || l_rec.element_link_id);
804: hr_utility.trace('input_value_id : ' || l_rec.input_value_id);
805: hr_utility.trace('effective_start_date : ' || l_rec.effective_start_date);
806: hr_utility.trace('effective_end_date : ' || l_rec.effective_end_date);
807: --
808: pay_link_input_values_api.create_liv_internal(
801: for l_rec in csr_link loop
802: hr_utility.trace('******************************');
803: hr_utility.trace('element_link_id : ' || l_rec.element_link_id);
804: hr_utility.trace('input_value_id : ' || l_rec.input_value_id);
805: hr_utility.trace('effective_start_date : ' || l_rec.effective_start_date);
806: hr_utility.trace('effective_end_date : ' || l_rec.effective_end_date);
807: --
808: pay_link_input_values_api.create_liv_internal(
809: P_EFFECTIVE_DATE => l_rec.effective_start_date,
802: hr_utility.trace('******************************');
803: hr_utility.trace('element_link_id : ' || l_rec.element_link_id);
804: hr_utility.trace('input_value_id : ' || l_rec.input_value_id);
805: hr_utility.trace('effective_start_date : ' || l_rec.effective_start_date);
806: hr_utility.trace('effective_end_date : ' || l_rec.effective_end_date);
807: --
808: pay_link_input_values_api.create_liv_internal(
809: P_EFFECTIVE_DATE => l_rec.effective_start_date,
810: P_ELEMENT_LINK_ID => l_rec.element_link_id,
819: P_EFFECTIVE_END_DATE => l_effective_end_date,
820: P_OBJECT_VERSION_NUMBER => l_object_version_number,
821: P_PAY_BASIS_WARNING => l_pay_basis_warning);
822: --
823: hr_utility.trace('------------------------------');
824: hr_utility.trace('link_input_value_id : ' || l_link_input_value_id);
825: hr_utility.trace('effective_start_date : ' || l_effective_start_date);
826: hr_utility.trace('effective_end_date : ' || l_effective_end_date);
827: end loop;
820: P_OBJECT_VERSION_NUMBER => l_object_version_number,
821: P_PAY_BASIS_WARNING => l_pay_basis_warning);
822: --
823: hr_utility.trace('------------------------------');
824: hr_utility.trace('link_input_value_id : ' || l_link_input_value_id);
825: hr_utility.trace('effective_start_date : ' || l_effective_start_date);
826: hr_utility.trace('effective_end_date : ' || l_effective_end_date);
827: end loop;
828: end if;
821: P_PAY_BASIS_WARNING => l_pay_basis_warning);
822: --
823: hr_utility.trace('------------------------------');
824: hr_utility.trace('link_input_value_id : ' || l_link_input_value_id);
825: hr_utility.trace('effective_start_date : ' || l_effective_start_date);
826: hr_utility.trace('effective_end_date : ' || l_effective_end_date);
827: end loop;
828: end if;
829: --
822: --
823: hr_utility.trace('------------------------------');
824: hr_utility.trace('link_input_value_id : ' || l_link_input_value_id);
825: hr_utility.trace('effective_start_date : ' || l_effective_start_date);
826: hr_utility.trace('effective_end_date : ' || l_effective_end_date);
827: end loop;
828: end if;
829: --
830: hr_utility.set_location('Leaving: ' || c_proc, 100);
826: hr_utility.trace('effective_end_date : ' || l_effective_end_date);
827: end loop;
828: end if;
829: --
830: hr_utility.set_location('Leaving: ' || c_proc, 100);
831: end sync_link_input_values;
832: -- |-------------------------------------------------------------------|
833: -- |-------------------< sync_entries_and_results >--------------------|
834: -- |-------------------------------------------------------------------|
841: l_rule_mode pay_legislation_rules.rule_mode%type;
842: l_found boolean;
843: l_business_group_id number;
844: begin
845: hr_utility.set_location('Entering: ' || c_proc, 10);
846: --
847: if p_element_type_id is not null then
848: --
849: -- Before running this SQL, PAY_LINK_INPUT_VALUES needs to be populated.
884: and peev.effective_start_date = pee.effective_start_date
885: and peev.effective_end_date = pee.effective_end_date
886: and peev.input_value_id = piv.input_value_id);
887: --
888: hr_utility.trace('assignment_id : ' || p_assignment_id);
889: hr_utility.trace('element_type_id : ' || p_element_type_id);
890: hr_utility.trace(sql%rowcount || ' rows inserted into pay_element_entry_values_f');
891: --
892: -- Check RR_SPARSE legislation rule
885: and peev.effective_end_date = pee.effective_end_date
886: and peev.input_value_id = piv.input_value_id);
887: --
888: hr_utility.trace('assignment_id : ' || p_assignment_id);
889: hr_utility.trace('element_type_id : ' || p_element_type_id);
890: hr_utility.trace(sql%rowcount || ' rows inserted into pay_element_entry_values_f');
891: --
892: -- Check RR_SPARSE legislation rule
893: --
886: and peev.input_value_id = piv.input_value_id);
887: --
888: hr_utility.trace('assignment_id : ' || p_assignment_id);
889: hr_utility.trace('element_type_id : ' || p_element_type_id);
890: hr_utility.trace(sql%rowcount || ' rows inserted into pay_element_entry_values_f');
891: --
892: -- Check RR_SPARSE legislation rule
893: --
894: pay_core_utils.get_legislation_rule(
949: -- from pay_run_result_values prrv
950: -- where prrv.run_result_id = prr.run_result_id
951: -- and prrv.input_value_id = piv.input_value_id);
952: -- --
953: -- hr_utility.trace(sql%rowcount || ' rows inserted into pay_run_result_values (RR_SPARSE)');
954: --
955: -- When not RR_SPARSE, create "null" result values for all appropriate run results.
956: --
957: else
985: from pay_run_result_values prrv
986: where prrv.run_result_id = prr.run_result_id
987: and prrv.input_value_id = piv.input_value_id);
988: --
989: hr_utility.trace(sql%rowcount || ' rows inserted into pay_run_result_values');
990: end if;
991: end if;
992: --
993: hr_utility.set_location('Leaving: ' || c_proc, 100);
989: hr_utility.trace(sql%rowcount || ' rows inserted into pay_run_result_values');
990: end if;
991: end if;
992: --
993: hr_utility.set_location('Leaving: ' || c_proc, 100);
994: end sync_entries_and_results;
995: -- |-------------------------------------------------------------------|
996: -- |----------------------< get_element_type_id >----------------------|
997: -- |-------------------------------------------------------------------|
1011: begin
1012: open csr_id;
1013: fetch csr_id into l_element_type_id;
1014: if csr_id%found then
1015: hr_utility.trace(p_element_name || ': ' || l_element_type_id);
1016: p_element_type_ids(p_element_type_ids.count + 1) := l_element_type_id;
1017: else
1018: hr_utility.trace(p_element_name || ' NOT found!');
1019: end if;
1014: if csr_id%found then
1015: hr_utility.trace(p_element_name || ': ' || l_element_type_id);
1016: p_element_type_ids(p_element_type_ids.count + 1) := l_element_type_id;
1017: else
1018: hr_utility.trace(p_element_name || ' NOT found!');
1019: end if;
1020: close csr_id;
1021: end get_element_type_id;
1022: -- |-------------------------------------------------------------------|
1025: procedure init_pay_a
1026: is
1027: c_proc constant varchar2(61) := c_package || 'init_pay_a';
1028: begin
1029: hr_utility.set_location('Entering: ' || c_proc, 10);
1030: --
1031: if g_element_type_ids.count = 0 then
1032: hr_utility.trace('Not cached.');
1033: --
1028: begin
1029: hr_utility.set_location('Entering: ' || c_proc, 10);
1030: --
1031: if g_element_type_ids.count = 0 then
1032: hr_utility.trace('Not cached.');
1033: --
1034: get_element_type_id('INI_SAL2', g_element_type_ids);
1035: get_element_type_id('INI_BON2', g_element_type_ids);
1036: get_element_type_id('INI_SPB1', g_element_type_ids);
1055: get_element_type_id('SAN_REPORT_RMKS_RSLT', g_element_type_ids);
1056: end if;
1057: --
1058: -- for i in 1..g_element_type_ids.count loop
1059: -- hr_utility.trace(i || ': ' || g_element_type_ids(i));
1060: -- end loop;
1061: --
1062: hr_utility.set_location('Leaving: ' || c_proc, 100);
1063: end init_pay_a;
1058: -- for i in 1..g_element_type_ids.count loop
1059: -- hr_utility.trace(i || ': ' || g_element_type_ids(i));
1060: -- end loop;
1061: --
1062: hr_utility.set_location('Leaving: ' || c_proc, 100);
1063: end init_pay_a;
1064: -- |-------------------------------------------------------------------|
1065: -- |------------------------< validate_pay_a >-------------------------|
1066: -- |-------------------------------------------------------------------|
1071: l_element_type_id1 number;
1072: l_element_type_id2 number;
1073: l_element_type_id3 number;
1074: begin
1075: hr_utility.set_location('Entering: ' || c_proc, 10);
1076: --
1077: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
1078: --
1079: init_pay_a;
1087: else
1088: p_valid_upgrade := 'FALSE';
1089: end if;
1090: --
1091: hr_utility.trace(p_valid_upgrade);
1092: hr_utility.set_location('Leaving: ' || c_proc, 100);
1093: end validate_pay_a;
1094: -- |-------------------------------------------------------------------|
1095: -- |-------------------------< qualify_pay_a >-------------------------|
1088: p_valid_upgrade := 'FALSE';
1089: end if;
1090: --
1091: hr_utility.trace(p_valid_upgrade);
1092: hr_utility.set_location('Leaving: ' || c_proc, 100);
1093: end validate_pay_a;
1094: -- |-------------------------------------------------------------------|
1095: -- |-------------------------< qualify_pay_a >-------------------------|
1096: -- |-------------------------------------------------------------------|
1099: p_qualifier out nocopy varchar2)
1100: is
1101: c_proc constant varchar2(61) := c_package || 'qualify_pay_a';
1102: begin
1103: hr_utility.set_location('Entering: ' || c_proc, 10);
1104: --
1105: if entries_or_results_exist(p_assignment_id => p_assignment_id) then
1106: p_qualifier := 'Y';
1107: else
1107: else
1108: p_qualifier := 'N';
1109: end if;
1110: --
1111: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
1112: hr_utility.set_location('Leaving: ' || c_proc, 100);
1113: end qualify_pay_a;
1114: -- |-------------------------------------------------------------------|
1115: -- |----------------------< upgrade_pay_a >----------------------------|
1108: p_qualifier := 'N';
1109: end if;
1110: --
1111: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
1112: hr_utility.set_location('Leaving: ' || c_proc, 100);
1113: end qualify_pay_a;
1114: -- |-------------------------------------------------------------------|
1115: -- |----------------------< upgrade_pay_a >----------------------------|
1116: -- |-------------------------------------------------------------------|
1117: procedure upgrade_pay_a(p_assignment_id in number)
1118: is
1119: c_proc constant varchar2(61) := c_package || 'upgrade_pay_a';
1120: begin
1121: hr_utility.set_location('Entering: ' || c_proc, 10);
1122: --
1123: init_pay_a;
1124: --
1125: for i in 1..g_element_type_ids.count loop
1125: for i in 1..g_element_type_ids.count loop
1126: sync_entries_and_results(p_assignment_id, g_element_type_ids(i));
1127: end loop;
1128: --
1129: hr_utility.set_location('Leaving: ' || c_proc, 100);
1130: end upgrade_pay_a;
1131: -- |-------------------------------------------------------------------|
1132: -- |-------------------< validate_itax_description >-------------------|
1133: -- |-------------------------------------------------------------------|
1139: c_proc constant varchar2(61) := c_package || 'validate_itax_description';
1140: --
1141: begin
1142: --
1143: hr_utility.set_location('Entering: ' || c_proc, 10);
1144: --
1145: --
1146: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
1147: --
1162: else
1163: p_valid_upgrade := 'FALSE';
1164: end if;
1165: --
1166: hr_utility.trace(p_valid_upgrade);
1167: hr_utility.set_location('Leaving: ' || c_proc, 100);
1168: --
1169: end validate_itax_description;
1170: -- |-------------------------------------------------------------------|
1163: p_valid_upgrade := 'FALSE';
1164: end if;
1165: --
1166: hr_utility.trace(p_valid_upgrade);
1167: hr_utility.set_location('Leaving: ' || c_proc, 100);
1168: --
1169: end validate_itax_description;
1170: -- |-------------------------------------------------------------------|
1171: -- |-------------------< qualify_itax_description >--------------------|
1176: )
1177: is
1178: c_proc constant varchar2(61) := c_package || 'qualify_itax_description';
1179: begin
1180: hr_utility.set_location('Entering: ' || c_proc, 10);
1181: --
1182: if entries_or_results_exist(p_assignment_id => p_assignment_id) then
1183: p_qualifier := 'Y';
1184: else
1184: else
1185: p_qualifier := 'N';
1186: end if;
1187: --
1188: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
1189: hr_utility.set_location('Leaving: ' || c_proc, 100);
1190: end qualify_itax_description;
1191: -- |-------------------------------------------------------------------|
1192: -- |-------------------< upgrade_itax_description >--------------------|
1185: p_qualifier := 'N';
1186: end if;
1187: --
1188: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
1189: hr_utility.set_location('Leaving: ' || c_proc, 100);
1190: end qualify_itax_description;
1191: -- |-------------------------------------------------------------------|
1192: -- |-------------------< upgrade_itax_description >--------------------|
1193: -- |-------------------------------------------------------------------|
1197: is
1198: c_proc constant varchar2(61) := c_package || 'upgrade_itax_description';
1199: begin
1200: --
1201: hr_utility.set_location('Entering: ' || c_proc, 10);
1202: --
1203: if g_element_type_ids.count = 0 then
1204: --
1205: get_element_type_id('YEA_WITHHOLD_TAX_REPORT_INFO', g_element_type_ids);
1211: sync_entries_and_results(p_assignment_id, g_element_type_ids(i));
1212: --
1213: end loop;
1214: --
1215: hr_utility.set_location('Leaving: ' || c_proc, 100);
1216: --
1217: end upgrade_itax_description;
1218: -- |-------------------------------------------------------------------|
1219: -- |--------------------< validate_code_jp_pre_tax >-------------------|
1235: and action_context_type = 'AAP')
1236: and rownum =1;
1237:
1238: begin
1239: hr_utility.set_location('Entering: ' || c_proc, 10);
1240: --
1241: open csr_exists;
1242: fetch csr_exists into p_valid_upgrade;
1243: if csr_exists%notfound then
1244: p_valid_upgrade := 'FALSE';
1245: end if;
1246: close csr_exists;
1247: --
1248: hr_utility.trace(p_valid_upgrade);
1249: hr_utility.set_location('Leaving: ' || c_proc, 100);
1250: end validate_code_jp_pre_tax;
1251: -- |-------------------------------------------------------------------|
1252: -- |--------------------< qualifying_jp_pre_tax >----------------------|
1245: end if;
1246: close csr_exists;
1247: --
1248: hr_utility.trace(p_valid_upgrade);
1249: hr_utility.set_location('Leaving: ' || c_proc, 100);
1250: end validate_code_jp_pre_tax;
1251: -- |-------------------------------------------------------------------|
1252: -- |--------------------< qualifying_jp_pre_tax >----------------------|
1253: -- |-------------------------------------------------------------------|
1271: and action_context_type = 'AAP')
1272: and rownum = 1;
1273:
1274: begin
1275: hr_utility.set_location('Entering: ' || c_proc, 10);
1276: --
1277: open csr_ppt;
1278: fetch csr_ppt into p_qualifier;
1279: if csr_ppt%notfound then
1280: p_qualifier := 'N';
1281: end if;
1282: close csr_ppt;
1283: --
1284: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
1285: hr_utility.set_location('Leaving: ' || c_proc, 100);
1286: end qualifying_jp_pre_tax;
1287: -- |-------------------------------------------------------------------|
1288: -- |----------------------< upgrade_jp_pre_tax >-----------------------|
1281: end if;
1282: close csr_ppt;
1283: --
1284: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
1285: hr_utility.set_location('Leaving: ' || c_proc, 100);
1286: end qualifying_jp_pre_tax;
1287: -- |-------------------------------------------------------------------|
1288: -- |----------------------< upgrade_jp_pre_tax >-----------------------|
1289: -- |-------------------------------------------------------------------|
1321: for update of ppt.pre_tax_id;
1322:
1323: begin
1324: begin
1325: hr_utility.set_location('Entering: ' || c_proc, 10);
1326: hr_utility.trace('assignment_id: ' || p_assignment_id);
1327: --
1328: for l_pre_tax in csr_pre_tax
1329: loop
1322:
1323: begin
1324: begin
1325: hr_utility.set_location('Entering: ' || c_proc, 10);
1326: hr_utility.trace('assignment_id: ' || p_assignment_id);
1327: --
1328: for l_pre_tax in csr_pre_tax
1329: loop
1330: hr_utility.set_location(c_proc, 20);
1326: hr_utility.trace('assignment_id: ' || p_assignment_id);
1327: --
1328: for l_pre_tax in csr_pre_tax
1329: loop
1330: hr_utility.set_location(c_proc, 20);
1331: --
1332: l_effective_date := l_pre_tax.effective_date;
1333: --
1334: select asg.person_id,
1348: where asg.assignment_id = p_assignment_id
1349: and l_effective_date between asg.effective_start_date and asg.effective_end_date
1350: and pds.period_of_service_id = asg.period_of_service_id;
1351: --
1352: hr_utility.trace('salary_category : ' || l_pre_tax.salary_category);
1353: hr_utility.trace('taxable_sal_amt : ' || l_pre_tax.taxable_sal_amt);
1354: hr_utility.trace('taxable_mat_amt : ' || l_pre_tax.taxable_mat_amt);
1355: hr_utility.trace('previous_taxable_amt : ' || l_pre_tax.previous_taxable_amt);
1356: hr_utility.trace('hi_organization_id : ' || l_pre_tax.hi_organization_id);
1349: and l_effective_date between asg.effective_start_date and asg.effective_end_date
1350: and pds.period_of_service_id = asg.period_of_service_id;
1351: --
1352: hr_utility.trace('salary_category : ' || l_pre_tax.salary_category);
1353: hr_utility.trace('taxable_sal_amt : ' || l_pre_tax.taxable_sal_amt);
1354: hr_utility.trace('taxable_mat_amt : ' || l_pre_tax.taxable_mat_amt);
1355: hr_utility.trace('previous_taxable_amt : ' || l_pre_tax.previous_taxable_amt);
1356: hr_utility.trace('hi_organization_id : ' || l_pre_tax.hi_organization_id);
1357: hr_utility.trace('hi_prem_ee : ' || l_pre_tax.hi_prem_ee);
1350: and pds.period_of_service_id = asg.period_of_service_id;
1351: --
1352: hr_utility.trace('salary_category : ' || l_pre_tax.salary_category);
1353: hr_utility.trace('taxable_sal_amt : ' || l_pre_tax.taxable_sal_amt);
1354: hr_utility.trace('taxable_mat_amt : ' || l_pre_tax.taxable_mat_amt);
1355: hr_utility.trace('previous_taxable_amt : ' || l_pre_tax.previous_taxable_amt);
1356: hr_utility.trace('hi_organization_id : ' || l_pre_tax.hi_organization_id);
1357: hr_utility.trace('hi_prem_ee : ' || l_pre_tax.hi_prem_ee);
1358: hr_utility.trace('hi_prem_er : ' || l_pre_tax.hi_prem_er);
1351: --
1352: hr_utility.trace('salary_category : ' || l_pre_tax.salary_category);
1353: hr_utility.trace('taxable_sal_amt : ' || l_pre_tax.taxable_sal_amt);
1354: hr_utility.trace('taxable_mat_amt : ' || l_pre_tax.taxable_mat_amt);
1355: hr_utility.trace('previous_taxable_amt : ' || l_pre_tax.previous_taxable_amt);
1356: hr_utility.trace('hi_organization_id : ' || l_pre_tax.hi_organization_id);
1357: hr_utility.trace('hi_prem_ee : ' || l_pre_tax.hi_prem_ee);
1358: hr_utility.trace('hi_prem_er : ' || l_pre_tax.hi_prem_er);
1359: hr_utility.trace('wp_organization_id : ' || l_pre_tax.wp_organization_id);
1352: hr_utility.trace('salary_category : ' || l_pre_tax.salary_category);
1353: hr_utility.trace('taxable_sal_amt : ' || l_pre_tax.taxable_sal_amt);
1354: hr_utility.trace('taxable_mat_amt : ' || l_pre_tax.taxable_mat_amt);
1355: hr_utility.trace('previous_taxable_amt : ' || l_pre_tax.previous_taxable_amt);
1356: hr_utility.trace('hi_organization_id : ' || l_pre_tax.hi_organization_id);
1357: hr_utility.trace('hi_prem_ee : ' || l_pre_tax.hi_prem_ee);
1358: hr_utility.trace('hi_prem_er : ' || l_pre_tax.hi_prem_er);
1359: hr_utility.trace('wp_organization_id : ' || l_pre_tax.wp_organization_id);
1360: hr_utility.trace('wp_prem_ee : ' || l_pre_tax.wp_prem_ee);
1353: hr_utility.trace('taxable_sal_amt : ' || l_pre_tax.taxable_sal_amt);
1354: hr_utility.trace('taxable_mat_amt : ' || l_pre_tax.taxable_mat_amt);
1355: hr_utility.trace('previous_taxable_amt : ' || l_pre_tax.previous_taxable_amt);
1356: hr_utility.trace('hi_organization_id : ' || l_pre_tax.hi_organization_id);
1357: hr_utility.trace('hi_prem_ee : ' || l_pre_tax.hi_prem_ee);
1358: hr_utility.trace('hi_prem_er : ' || l_pre_tax.hi_prem_er);
1359: hr_utility.trace('wp_organization_id : ' || l_pre_tax.wp_organization_id);
1360: hr_utility.trace('wp_prem_ee : ' || l_pre_tax.wp_prem_ee);
1361: hr_utility.trace('wp_prem_er : ' || l_pre_tax.wp_prem_er);
1354: hr_utility.trace('taxable_mat_amt : ' || l_pre_tax.taxable_mat_amt);
1355: hr_utility.trace('previous_taxable_amt : ' || l_pre_tax.previous_taxable_amt);
1356: hr_utility.trace('hi_organization_id : ' || l_pre_tax.hi_organization_id);
1357: hr_utility.trace('hi_prem_ee : ' || l_pre_tax.hi_prem_ee);
1358: hr_utility.trace('hi_prem_er : ' || l_pre_tax.hi_prem_er);
1359: hr_utility.trace('wp_organization_id : ' || l_pre_tax.wp_organization_id);
1360: hr_utility.trace('wp_prem_ee : ' || l_pre_tax.wp_prem_ee);
1361: hr_utility.trace('wp_prem_er : ' || l_pre_tax.wp_prem_er);
1362: hr_utility.trace('wpf_organization_id : ' || l_pre_tax.wpf_organization_id);
1355: hr_utility.trace('previous_taxable_amt : ' || l_pre_tax.previous_taxable_amt);
1356: hr_utility.trace('hi_organization_id : ' || l_pre_tax.hi_organization_id);
1357: hr_utility.trace('hi_prem_ee : ' || l_pre_tax.hi_prem_ee);
1358: hr_utility.trace('hi_prem_er : ' || l_pre_tax.hi_prem_er);
1359: hr_utility.trace('wp_organization_id : ' || l_pre_tax.wp_organization_id);
1360: hr_utility.trace('wp_prem_ee : ' || l_pre_tax.wp_prem_ee);
1361: hr_utility.trace('wp_prem_er : ' || l_pre_tax.wp_prem_er);
1362: hr_utility.trace('wpf_organization_id : ' || l_pre_tax.wpf_organization_id);
1363: hr_utility.trace('wpf_prem_ee : ' || l_pre_tax.wpf_prem_ee);
1356: hr_utility.trace('hi_organization_id : ' || l_pre_tax.hi_organization_id);
1357: hr_utility.trace('hi_prem_ee : ' || l_pre_tax.hi_prem_ee);
1358: hr_utility.trace('hi_prem_er : ' || l_pre_tax.hi_prem_er);
1359: hr_utility.trace('wp_organization_id : ' || l_pre_tax.wp_organization_id);
1360: hr_utility.trace('wp_prem_ee : ' || l_pre_tax.wp_prem_ee);
1361: hr_utility.trace('wp_prem_er : ' || l_pre_tax.wp_prem_er);
1362: hr_utility.trace('wpf_organization_id : ' || l_pre_tax.wpf_organization_id);
1363: hr_utility.trace('wpf_prem_ee : ' || l_pre_tax.wpf_prem_ee);
1364: hr_utility.trace('wpf_prem_er : ' || l_pre_tax.wpf_prem_er);
1357: hr_utility.trace('hi_prem_ee : ' || l_pre_tax.hi_prem_ee);
1358: hr_utility.trace('hi_prem_er : ' || l_pre_tax.hi_prem_er);
1359: hr_utility.trace('wp_organization_id : ' || l_pre_tax.wp_organization_id);
1360: hr_utility.trace('wp_prem_ee : ' || l_pre_tax.wp_prem_ee);
1361: hr_utility.trace('wp_prem_er : ' || l_pre_tax.wp_prem_er);
1362: hr_utility.trace('wpf_organization_id : ' || l_pre_tax.wpf_organization_id);
1363: hr_utility.trace('wpf_prem_ee : ' || l_pre_tax.wpf_prem_ee);
1364: hr_utility.trace('wpf_prem_er : ' || l_pre_tax.wpf_prem_er);
1365: hr_utility.trace('ui_organization_id : ' || l_pre_tax.ui_organization_id);
1358: hr_utility.trace('hi_prem_er : ' || l_pre_tax.hi_prem_er);
1359: hr_utility.trace('wp_organization_id : ' || l_pre_tax.wp_organization_id);
1360: hr_utility.trace('wp_prem_ee : ' || l_pre_tax.wp_prem_ee);
1361: hr_utility.trace('wp_prem_er : ' || l_pre_tax.wp_prem_er);
1362: hr_utility.trace('wpf_organization_id : ' || l_pre_tax.wpf_organization_id);
1363: hr_utility.trace('wpf_prem_ee : ' || l_pre_tax.wpf_prem_ee);
1364: hr_utility.trace('wpf_prem_er : ' || l_pre_tax.wpf_prem_er);
1365: hr_utility.trace('ui_organization_id : ' || l_pre_tax.ui_organization_id);
1366: hr_utility.trace('ui_category : ' || l_pre_tax.ui_category);
1359: hr_utility.trace('wp_organization_id : ' || l_pre_tax.wp_organization_id);
1360: hr_utility.trace('wp_prem_ee : ' || l_pre_tax.wp_prem_ee);
1361: hr_utility.trace('wp_prem_er : ' || l_pre_tax.wp_prem_er);
1362: hr_utility.trace('wpf_organization_id : ' || l_pre_tax.wpf_organization_id);
1363: hr_utility.trace('wpf_prem_ee : ' || l_pre_tax.wpf_prem_ee);
1364: hr_utility.trace('wpf_prem_er : ' || l_pre_tax.wpf_prem_er);
1365: hr_utility.trace('ui_organization_id : ' || l_pre_tax.ui_organization_id);
1366: hr_utility.trace('ui_category : ' || l_pre_tax.ui_category);
1367: hr_utility.trace('ui_prem_ee : ' || l_pre_tax.ui_prem_ee);
1360: hr_utility.trace('wp_prem_ee : ' || l_pre_tax.wp_prem_ee);
1361: hr_utility.trace('wp_prem_er : ' || l_pre_tax.wp_prem_er);
1362: hr_utility.trace('wpf_organization_id : ' || l_pre_tax.wpf_organization_id);
1363: hr_utility.trace('wpf_prem_ee : ' || l_pre_tax.wpf_prem_ee);
1364: hr_utility.trace('wpf_prem_er : ' || l_pre_tax.wpf_prem_er);
1365: hr_utility.trace('ui_organization_id : ' || l_pre_tax.ui_organization_id);
1366: hr_utility.trace('ui_category : ' || l_pre_tax.ui_category);
1367: hr_utility.trace('ui_prem_ee : ' || l_pre_tax.ui_prem_ee);
1368: hr_utility.trace('ui_sal_amt : ' || l_pre_tax.ui_sal_amt);
1361: hr_utility.trace('wp_prem_er : ' || l_pre_tax.wp_prem_er);
1362: hr_utility.trace('wpf_organization_id : ' || l_pre_tax.wpf_organization_id);
1363: hr_utility.trace('wpf_prem_ee : ' || l_pre_tax.wpf_prem_ee);
1364: hr_utility.trace('wpf_prem_er : ' || l_pre_tax.wpf_prem_er);
1365: hr_utility.trace('ui_organization_id : ' || l_pre_tax.ui_organization_id);
1366: hr_utility.trace('ui_category : ' || l_pre_tax.ui_category);
1367: hr_utility.trace('ui_prem_ee : ' || l_pre_tax.ui_prem_ee);
1368: hr_utility.trace('ui_sal_amt : ' || l_pre_tax.ui_sal_amt);
1369: hr_utility.trace('wai_organization_id : ' || l_pre_tax.wai_organization_id);
1362: hr_utility.trace('wpf_organization_id : ' || l_pre_tax.wpf_organization_id);
1363: hr_utility.trace('wpf_prem_ee : ' || l_pre_tax.wpf_prem_ee);
1364: hr_utility.trace('wpf_prem_er : ' || l_pre_tax.wpf_prem_er);
1365: hr_utility.trace('ui_organization_id : ' || l_pre_tax.ui_organization_id);
1366: hr_utility.trace('ui_category : ' || l_pre_tax.ui_category);
1367: hr_utility.trace('ui_prem_ee : ' || l_pre_tax.ui_prem_ee);
1368: hr_utility.trace('ui_sal_amt : ' || l_pre_tax.ui_sal_amt);
1369: hr_utility.trace('wai_organization_id : ' || l_pre_tax.wai_organization_id);
1370: hr_utility.trace('wai_category : ' || l_pre_tax.wai_category);
1363: hr_utility.trace('wpf_prem_ee : ' || l_pre_tax.wpf_prem_ee);
1364: hr_utility.trace('wpf_prem_er : ' || l_pre_tax.wpf_prem_er);
1365: hr_utility.trace('ui_organization_id : ' || l_pre_tax.ui_organization_id);
1366: hr_utility.trace('ui_category : ' || l_pre_tax.ui_category);
1367: hr_utility.trace('ui_prem_ee : ' || l_pre_tax.ui_prem_ee);
1368: hr_utility.trace('ui_sal_amt : ' || l_pre_tax.ui_sal_amt);
1369: hr_utility.trace('wai_organization_id : ' || l_pre_tax.wai_organization_id);
1370: hr_utility.trace('wai_category : ' || l_pre_tax.wai_category);
1371: hr_utility.trace('wai_sal_amt : ' || l_pre_tax.wai_sal_amt);
1364: hr_utility.trace('wpf_prem_er : ' || l_pre_tax.wpf_prem_er);
1365: hr_utility.trace('ui_organization_id : ' || l_pre_tax.ui_organization_id);
1366: hr_utility.trace('ui_category : ' || l_pre_tax.ui_category);
1367: hr_utility.trace('ui_prem_ee : ' || l_pre_tax.ui_prem_ee);
1368: hr_utility.trace('ui_sal_amt : ' || l_pre_tax.ui_sal_amt);
1369: hr_utility.trace('wai_organization_id : ' || l_pre_tax.wai_organization_id);
1370: hr_utility.trace('wai_category : ' || l_pre_tax.wai_category);
1371: hr_utility.trace('wai_sal_amt : ' || l_pre_tax.wai_sal_amt);
1372: hr_utility.trace('itax_organization_id : ' || l_pre_tax.itax_organization_id);
1365: hr_utility.trace('ui_organization_id : ' || l_pre_tax.ui_organization_id);
1366: hr_utility.trace('ui_category : ' || l_pre_tax.ui_category);
1367: hr_utility.trace('ui_prem_ee : ' || l_pre_tax.ui_prem_ee);
1368: hr_utility.trace('ui_sal_amt : ' || l_pre_tax.ui_sal_amt);
1369: hr_utility.trace('wai_organization_id : ' || l_pre_tax.wai_organization_id);
1370: hr_utility.trace('wai_category : ' || l_pre_tax.wai_category);
1371: hr_utility.trace('wai_sal_amt : ' || l_pre_tax.wai_sal_amt);
1372: hr_utility.trace('itax_organization_id : ' || l_pre_tax.itax_organization_id);
1373: hr_utility.trace('itax_category : ' || l_pre_tax.itax_category);
1366: hr_utility.trace('ui_category : ' || l_pre_tax.ui_category);
1367: hr_utility.trace('ui_prem_ee : ' || l_pre_tax.ui_prem_ee);
1368: hr_utility.trace('ui_sal_amt : ' || l_pre_tax.ui_sal_amt);
1369: hr_utility.trace('wai_organization_id : ' || l_pre_tax.wai_organization_id);
1370: hr_utility.trace('wai_category : ' || l_pre_tax.wai_category);
1371: hr_utility.trace('wai_sal_amt : ' || l_pre_tax.wai_sal_amt);
1372: hr_utility.trace('itax_organization_id : ' || l_pre_tax.itax_organization_id);
1373: hr_utility.trace('itax_category : ' || l_pre_tax.itax_category);
1374: hr_utility.trace('itax_yea_category : ' || l_pre_tax.itax_yea_category);
1367: hr_utility.trace('ui_prem_ee : ' || l_pre_tax.ui_prem_ee);
1368: hr_utility.trace('ui_sal_amt : ' || l_pre_tax.ui_sal_amt);
1369: hr_utility.trace('wai_organization_id : ' || l_pre_tax.wai_organization_id);
1370: hr_utility.trace('wai_category : ' || l_pre_tax.wai_category);
1371: hr_utility.trace('wai_sal_amt : ' || l_pre_tax.wai_sal_amt);
1372: hr_utility.trace('itax_organization_id : ' || l_pre_tax.itax_organization_id);
1373: hr_utility.trace('itax_category : ' || l_pre_tax.itax_category);
1374: hr_utility.trace('itax_yea_category : ' || l_pre_tax.itax_yea_category);
1375: hr_utility.trace('itax : ' || l_pre_tax.itax);
1368: hr_utility.trace('ui_sal_amt : ' || l_pre_tax.ui_sal_amt);
1369: hr_utility.trace('wai_organization_id : ' || l_pre_tax.wai_organization_id);
1370: hr_utility.trace('wai_category : ' || l_pre_tax.wai_category);
1371: hr_utility.trace('wai_sal_amt : ' || l_pre_tax.wai_sal_amt);
1372: hr_utility.trace('itax_organization_id : ' || l_pre_tax.itax_organization_id);
1373: hr_utility.trace('itax_category : ' || l_pre_tax.itax_category);
1374: hr_utility.trace('itax_yea_category : ' || l_pre_tax.itax_yea_category);
1375: hr_utility.trace('itax : ' || l_pre_tax.itax);
1376: hr_utility.trace('itax_adjustment : ' || l_pre_tax.itax_adjustment);
1369: hr_utility.trace('wai_organization_id : ' || l_pre_tax.wai_organization_id);
1370: hr_utility.trace('wai_category : ' || l_pre_tax.wai_category);
1371: hr_utility.trace('wai_sal_amt : ' || l_pre_tax.wai_sal_amt);
1372: hr_utility.trace('itax_organization_id : ' || l_pre_tax.itax_organization_id);
1373: hr_utility.trace('itax_category : ' || l_pre_tax.itax_category);
1374: hr_utility.trace('itax_yea_category : ' || l_pre_tax.itax_yea_category);
1375: hr_utility.trace('itax : ' || l_pre_tax.itax);
1376: hr_utility.trace('itax_adjustment : ' || l_pre_tax.itax_adjustment);
1377: hr_utility.trace('previous_itax : ' || l_pre_tax.previous_itax);
1370: hr_utility.trace('wai_category : ' || l_pre_tax.wai_category);
1371: hr_utility.trace('wai_sal_amt : ' || l_pre_tax.wai_sal_amt);
1372: hr_utility.trace('itax_organization_id : ' || l_pre_tax.itax_organization_id);
1373: hr_utility.trace('itax_category : ' || l_pre_tax.itax_category);
1374: hr_utility.trace('itax_yea_category : ' || l_pre_tax.itax_yea_category);
1375: hr_utility.trace('itax : ' || l_pre_tax.itax);
1376: hr_utility.trace('itax_adjustment : ' || l_pre_tax.itax_adjustment);
1377: hr_utility.trace('previous_itax : ' || l_pre_tax.previous_itax);
1378: hr_utility.trace('ltax_organization_id : ' || l_pre_tax.ltax_organization_id);
1371: hr_utility.trace('wai_sal_amt : ' || l_pre_tax.wai_sal_amt);
1372: hr_utility.trace('itax_organization_id : ' || l_pre_tax.itax_organization_id);
1373: hr_utility.trace('itax_category : ' || l_pre_tax.itax_category);
1374: hr_utility.trace('itax_yea_category : ' || l_pre_tax.itax_yea_category);
1375: hr_utility.trace('itax : ' || l_pre_tax.itax);
1376: hr_utility.trace('itax_adjustment : ' || l_pre_tax.itax_adjustment);
1377: hr_utility.trace('previous_itax : ' || l_pre_tax.previous_itax);
1378: hr_utility.trace('ltax_organization_id : ' || l_pre_tax.ltax_organization_id);
1379: hr_utility.trace('ltax_district_code : ' || l_pre_tax.ltax_district_code);
1372: hr_utility.trace('itax_organization_id : ' || l_pre_tax.itax_organization_id);
1373: hr_utility.trace('itax_category : ' || l_pre_tax.itax_category);
1374: hr_utility.trace('itax_yea_category : ' || l_pre_tax.itax_yea_category);
1375: hr_utility.trace('itax : ' || l_pre_tax.itax);
1376: hr_utility.trace('itax_adjustment : ' || l_pre_tax.itax_adjustment);
1377: hr_utility.trace('previous_itax : ' || l_pre_tax.previous_itax);
1378: hr_utility.trace('ltax_organization_id : ' || l_pre_tax.ltax_organization_id);
1379: hr_utility.trace('ltax_district_code : ' || l_pre_tax.ltax_district_code);
1380: hr_utility.trace('ltax_swot_no : ' || l_pre_tax.ltax_swot_no);
1373: hr_utility.trace('itax_category : ' || l_pre_tax.itax_category);
1374: hr_utility.trace('itax_yea_category : ' || l_pre_tax.itax_yea_category);
1375: hr_utility.trace('itax : ' || l_pre_tax.itax);
1376: hr_utility.trace('itax_adjustment : ' || l_pre_tax.itax_adjustment);
1377: hr_utility.trace('previous_itax : ' || l_pre_tax.previous_itax);
1378: hr_utility.trace('ltax_organization_id : ' || l_pre_tax.ltax_organization_id);
1379: hr_utility.trace('ltax_district_code : ' || l_pre_tax.ltax_district_code);
1380: hr_utility.trace('ltax_swot_no : ' || l_pre_tax.ltax_swot_no);
1381: hr_utility.trace('ltax : ' || l_pre_tax.ltax);
1374: hr_utility.trace('itax_yea_category : ' || l_pre_tax.itax_yea_category);
1375: hr_utility.trace('itax : ' || l_pre_tax.itax);
1376: hr_utility.trace('itax_adjustment : ' || l_pre_tax.itax_adjustment);
1377: hr_utility.trace('previous_itax : ' || l_pre_tax.previous_itax);
1378: hr_utility.trace('ltax_organization_id : ' || l_pre_tax.ltax_organization_id);
1379: hr_utility.trace('ltax_district_code : ' || l_pre_tax.ltax_district_code);
1380: hr_utility.trace('ltax_swot_no : ' || l_pre_tax.ltax_swot_no);
1381: hr_utility.trace('ltax : ' || l_pre_tax.ltax);
1382: hr_utility.trace('ltax_lumpsum : ' || l_pre_tax.ltax_lumpsum);
1375: hr_utility.trace('itax : ' || l_pre_tax.itax);
1376: hr_utility.trace('itax_adjustment : ' || l_pre_tax.itax_adjustment);
1377: hr_utility.trace('previous_itax : ' || l_pre_tax.previous_itax);
1378: hr_utility.trace('ltax_organization_id : ' || l_pre_tax.ltax_organization_id);
1379: hr_utility.trace('ltax_district_code : ' || l_pre_tax.ltax_district_code);
1380: hr_utility.trace('ltax_swot_no : ' || l_pre_tax.ltax_swot_no);
1381: hr_utility.trace('ltax : ' || l_pre_tax.ltax);
1382: hr_utility.trace('ltax_lumpsum : ' || l_pre_tax.ltax_lumpsum);
1383: hr_utility.trace('sp_ltax : ' || l_pre_tax.sp_ltax);
1376: hr_utility.trace('itax_adjustment : ' || l_pre_tax.itax_adjustment);
1377: hr_utility.trace('previous_itax : ' || l_pre_tax.previous_itax);
1378: hr_utility.trace('ltax_organization_id : ' || l_pre_tax.ltax_organization_id);
1379: hr_utility.trace('ltax_district_code : ' || l_pre_tax.ltax_district_code);
1380: hr_utility.trace('ltax_swot_no : ' || l_pre_tax.ltax_swot_no);
1381: hr_utility.trace('ltax : ' || l_pre_tax.ltax);
1382: hr_utility.trace('ltax_lumpsum : ' || l_pre_tax.ltax_lumpsum);
1383: hr_utility.trace('sp_ltax : ' || l_pre_tax.sp_ltax);
1384: hr_utility.trace('sp_ltax_income : ' || l_pre_tax.sp_ltax_income);
1377: hr_utility.trace('previous_itax : ' || l_pre_tax.previous_itax);
1378: hr_utility.trace('ltax_organization_id : ' || l_pre_tax.ltax_organization_id);
1379: hr_utility.trace('ltax_district_code : ' || l_pre_tax.ltax_district_code);
1380: hr_utility.trace('ltax_swot_no : ' || l_pre_tax.ltax_swot_no);
1381: hr_utility.trace('ltax : ' || l_pre_tax.ltax);
1382: hr_utility.trace('ltax_lumpsum : ' || l_pre_tax.ltax_lumpsum);
1383: hr_utility.trace('sp_ltax : ' || l_pre_tax.sp_ltax);
1384: hr_utility.trace('sp_ltax_income : ' || l_pre_tax.sp_ltax_income);
1385: hr_utility.trace('sp_ltax_shi : ' || l_pre_tax.sp_ltax_shi);
1378: hr_utility.trace('ltax_organization_id : ' || l_pre_tax.ltax_organization_id);
1379: hr_utility.trace('ltax_district_code : ' || l_pre_tax.ltax_district_code);
1380: hr_utility.trace('ltax_swot_no : ' || l_pre_tax.ltax_swot_no);
1381: hr_utility.trace('ltax : ' || l_pre_tax.ltax);
1382: hr_utility.trace('ltax_lumpsum : ' || l_pre_tax.ltax_lumpsum);
1383: hr_utility.trace('sp_ltax : ' || l_pre_tax.sp_ltax);
1384: hr_utility.trace('sp_ltax_income : ' || l_pre_tax.sp_ltax_income);
1385: hr_utility.trace('sp_ltax_shi : ' || l_pre_tax.sp_ltax_shi);
1386: hr_utility.trace('sp_ltax_to : ' || l_pre_tax.sp_ltax_to);
1379: hr_utility.trace('ltax_district_code : ' || l_pre_tax.ltax_district_code);
1380: hr_utility.trace('ltax_swot_no : ' || l_pre_tax.ltax_swot_no);
1381: hr_utility.trace('ltax : ' || l_pre_tax.ltax);
1382: hr_utility.trace('ltax_lumpsum : ' || l_pre_tax.ltax_lumpsum);
1383: hr_utility.trace('sp_ltax : ' || l_pre_tax.sp_ltax);
1384: hr_utility.trace('sp_ltax_income : ' || l_pre_tax.sp_ltax_income);
1385: hr_utility.trace('sp_ltax_shi : ' || l_pre_tax.sp_ltax_shi);
1386: hr_utility.trace('sp_ltax_to : ' || l_pre_tax.sp_ltax_to);
1387: hr_utility.trace('ci_prem_ee : ' || l_pre_tax.ci_prem_ee);
1380: hr_utility.trace('ltax_swot_no : ' || l_pre_tax.ltax_swot_no);
1381: hr_utility.trace('ltax : ' || l_pre_tax.ltax);
1382: hr_utility.trace('ltax_lumpsum : ' || l_pre_tax.ltax_lumpsum);
1383: hr_utility.trace('sp_ltax : ' || l_pre_tax.sp_ltax);
1384: hr_utility.trace('sp_ltax_income : ' || l_pre_tax.sp_ltax_income);
1385: hr_utility.trace('sp_ltax_shi : ' || l_pre_tax.sp_ltax_shi);
1386: hr_utility.trace('sp_ltax_to : ' || l_pre_tax.sp_ltax_to);
1387: hr_utility.trace('ci_prem_ee : ' || l_pre_tax.ci_prem_ee);
1388: hr_utility.trace('ci_prem_er : ' || l_pre_tax.ci_prem_er);
1381: hr_utility.trace('ltax : ' || l_pre_tax.ltax);
1382: hr_utility.trace('ltax_lumpsum : ' || l_pre_tax.ltax_lumpsum);
1383: hr_utility.trace('sp_ltax : ' || l_pre_tax.sp_ltax);
1384: hr_utility.trace('sp_ltax_income : ' || l_pre_tax.sp_ltax_income);
1385: hr_utility.trace('sp_ltax_shi : ' || l_pre_tax.sp_ltax_shi);
1386: hr_utility.trace('sp_ltax_to : ' || l_pre_tax.sp_ltax_to);
1387: hr_utility.trace('ci_prem_ee : ' || l_pre_tax.ci_prem_ee);
1388: hr_utility.trace('ci_prem_er : ' || l_pre_tax.ci_prem_er);
1389: hr_utility.trace('mutual_aid : ' || l_pre_tax.mutual_aid);
1382: hr_utility.trace('ltax_lumpsum : ' || l_pre_tax.ltax_lumpsum);
1383: hr_utility.trace('sp_ltax : ' || l_pre_tax.sp_ltax);
1384: hr_utility.trace('sp_ltax_income : ' || l_pre_tax.sp_ltax_income);
1385: hr_utility.trace('sp_ltax_shi : ' || l_pre_tax.sp_ltax_shi);
1386: hr_utility.trace('sp_ltax_to : ' || l_pre_tax.sp_ltax_to);
1387: hr_utility.trace('ci_prem_ee : ' || l_pre_tax.ci_prem_ee);
1388: hr_utility.trace('ci_prem_er : ' || l_pre_tax.ci_prem_er);
1389: hr_utility.trace('mutual_aid : ' || l_pre_tax.mutual_aid);
1390: hr_utility.trace('disaster_tax_reduction : ' || l_pre_tax.disaster_tax_reduction);
1383: hr_utility.trace('sp_ltax : ' || l_pre_tax.sp_ltax);
1384: hr_utility.trace('sp_ltax_income : ' || l_pre_tax.sp_ltax_income);
1385: hr_utility.trace('sp_ltax_shi : ' || l_pre_tax.sp_ltax_shi);
1386: hr_utility.trace('sp_ltax_to : ' || l_pre_tax.sp_ltax_to);
1387: hr_utility.trace('ci_prem_ee : ' || l_pre_tax.ci_prem_ee);
1388: hr_utility.trace('ci_prem_er : ' || l_pre_tax.ci_prem_er);
1389: hr_utility.trace('mutual_aid : ' || l_pre_tax.mutual_aid);
1390: hr_utility.trace('disaster_tax_reduction : ' || l_pre_tax.disaster_tax_reduction);
1391: hr_utility.trace('sp_ltax_district_code : ' || l_pre_tax.sp_ltax_district_code);
1384: hr_utility.trace('sp_ltax_income : ' || l_pre_tax.sp_ltax_income);
1385: hr_utility.trace('sp_ltax_shi : ' || l_pre_tax.sp_ltax_shi);
1386: hr_utility.trace('sp_ltax_to : ' || l_pre_tax.sp_ltax_to);
1387: hr_utility.trace('ci_prem_ee : ' || l_pre_tax.ci_prem_ee);
1388: hr_utility.trace('ci_prem_er : ' || l_pre_tax.ci_prem_er);
1389: hr_utility.trace('mutual_aid : ' || l_pre_tax.mutual_aid);
1390: hr_utility.trace('disaster_tax_reduction : ' || l_pre_tax.disaster_tax_reduction);
1391: hr_utility.trace('sp_ltax_district_code : ' || l_pre_tax.sp_ltax_district_code);
1392: --
1385: hr_utility.trace('sp_ltax_shi : ' || l_pre_tax.sp_ltax_shi);
1386: hr_utility.trace('sp_ltax_to : ' || l_pre_tax.sp_ltax_to);
1387: hr_utility.trace('ci_prem_ee : ' || l_pre_tax.ci_prem_ee);
1388: hr_utility.trace('ci_prem_er : ' || l_pre_tax.ci_prem_er);
1389: hr_utility.trace('mutual_aid : ' || l_pre_tax.mutual_aid);
1390: hr_utility.trace('disaster_tax_reduction : ' || l_pre_tax.disaster_tax_reduction);
1391: hr_utility.trace('sp_ltax_district_code : ' || l_pre_tax.sp_ltax_district_code);
1392: --
1393: pay_action_information_api.create_action_information
1386: hr_utility.trace('sp_ltax_to : ' || l_pre_tax.sp_ltax_to);
1387: hr_utility.trace('ci_prem_ee : ' || l_pre_tax.ci_prem_ee);
1388: hr_utility.trace('ci_prem_er : ' || l_pre_tax.ci_prem_er);
1389: hr_utility.trace('mutual_aid : ' || l_pre_tax.mutual_aid);
1390: hr_utility.trace('disaster_tax_reduction : ' || l_pre_tax.disaster_tax_reduction);
1391: hr_utility.trace('sp_ltax_district_code : ' || l_pre_tax.sp_ltax_district_code);
1392: --
1393: pay_action_information_api.create_action_information
1394: (
1387: hr_utility.trace('ci_prem_ee : ' || l_pre_tax.ci_prem_ee);
1388: hr_utility.trace('ci_prem_er : ' || l_pre_tax.ci_prem_er);
1389: hr_utility.trace('mutual_aid : ' || l_pre_tax.mutual_aid);
1390: hr_utility.trace('disaster_tax_reduction : ' || l_pre_tax.disaster_tax_reduction);
1391: hr_utility.trace('sp_ltax_district_code : ' || l_pre_tax.sp_ltax_district_code);
1392: --
1393: pay_action_information_api.create_action_information
1394: (
1395: p_action_information_id => l_action_info_id1
1460: );
1461:
1462: end loop;
1463: --
1464: hr_utility.set_location('Leaving: ' || c_proc, 100);
1465: --
1466: exception
1467: when app_exception.application_exception then
1468: app_exception.raise_exception;
1492: c_proc constant varchar2(61) := c_package || 'validate_yea_national_pens';
1493: --
1494: begin
1495: --
1496: hr_utility.set_location('Entering: ' || c_proc, 10);
1497: --
1498: if g_element_type_ids.count = 0 then
1499: --
1500: get_element_type_id('YEA_INS_PREM_SPOUSE_SP_EXM_INFO', g_element_type_ids);
1512: else
1513: p_valid_upgrade := 'FALSE';
1514: end if;
1515: --
1516: hr_utility.trace(p_valid_upgrade);
1517: --
1518: hr_utility.set_location('Leaving: ' || c_proc, 100);
1519: --
1520: end validate_yea_national_pens;
1514: end if;
1515: --
1516: hr_utility.trace(p_valid_upgrade);
1517: --
1518: hr_utility.set_location('Leaving: ' || c_proc, 100);
1519: --
1520: end validate_yea_national_pens;
1521: -- |-------------------------------------------------------------------|
1522: -- |------------------< qualify_yea_national_pens >--------------------|
1528: is
1529: c_proc constant varchar2(61) := c_package || 'qualify_yea_national_pens';
1530: begin
1531: --
1532: hr_utility.set_location('Entering: ' || c_proc, 10);
1533: --
1534: if entries_or_results_exist(p_assignment_id => p_assignment_id) then
1535: p_qualifier := 'Y';
1536: else
1536: else
1537: p_qualifier := 'N';
1538: end if;
1539: --
1540: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
1541: hr_utility.set_location('Leaving: ' || c_proc, 100);
1542: --
1543: end qualify_yea_national_pens;
1544: -- |-------------------------------------------------------------------|
1537: p_qualifier := 'N';
1538: end if;
1539: --
1540: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
1541: hr_utility.set_location('Leaving: ' || c_proc, 100);
1542: --
1543: end qualify_yea_national_pens;
1544: -- |-------------------------------------------------------------------|
1545: -- |-------------------< upgrade_yea_national_pens >-------------------|
1549: is
1550: c_proc constant varchar2(61) := c_package || 'upgrade_yea_national_pens';
1551: begin
1552: --
1553: hr_utility.set_location('Entering: ' || c_proc, 10);
1554: --
1555: if g_element_type_ids.count = 0 then
1556: --
1557: get_element_type_id('YEA_INS_PREM_SPOUSE_SP_EXM_INFO', g_element_type_ids);
1563: sync_entries_and_results(p_assignment_id, g_element_type_ids(i));
1564: --
1565: end loop;
1566: --
1567: hr_utility.set_location('Leaving: ' || c_proc, 100);
1568: --
1569: end upgrade_yea_national_pens;
1570: -- |-------------------------------------------------------------------|
1571: -- |--------------------< init_yea_earthquake_ins >--------------------|
1573: procedure init_yea_earthquake_ins
1574: is
1575: c_proc constant varchar2(61) := c_package || 'init_yea_earthquake_ins';
1576: begin
1577: hr_utility.set_location('Entering: ' || c_proc, 10);
1578: --
1579: if g_element_type_ids.count = 0 then
1580: hr_utility.trace('Not cached.');
1581: --
1576: begin
1577: hr_utility.set_location('Entering: ' || c_proc, 10);
1578: --
1579: if g_element_type_ids.count = 0 then
1580: hr_utility.trace('Not cached.');
1581: --
1582: get_element_type_id('YEA_INS_PREM_SPOUSE_SP_EXM_INFO', g_element_type_ids);
1583: get_element_type_id('YEA_INS_PREM_SPOUSE_SP_EXM_RSLT', g_element_type_ids);
1584: get_element_type_id('INI_YEA2', g_element_type_ids);
1585: get_element_type_id('YEA_INS_PREM_EXM_DECLARE_INFO', g_element_type_ids);
1586: end if;
1587: --
1588: for i in 1..g_element_type_ids.count loop
1589: hr_utility.trace(i || ': ' || g_element_type_ids(i));
1590: end loop;
1591: --
1592: hr_utility.set_location('Leaving: ' || c_proc, 100);
1593: end init_yea_earthquake_ins;
1588: for i in 1..g_element_type_ids.count loop
1589: hr_utility.trace(i || ': ' || g_element_type_ids(i));
1590: end loop;
1591: --
1592: hr_utility.set_location('Leaving: ' || c_proc, 100);
1593: end init_yea_earthquake_ins;
1594: -- |-------------------------------------------------------------------|
1595: -- |------------------< validate_yea_earthquake_ins >------------------|
1596: -- |-------------------------------------------------------------------|
1598: procedure validate_yea_earthquake_ins(p_valid_upgrade out nocopy varchar2)
1599: is
1600: c_proc constant varchar2(61) := c_package || 'validate_yea_earthquake_ins';
1601: begin
1602: hr_utility.set_location('Entering: ' || c_proc, 10);
1603: --
1604: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
1605: --
1606: init_yea_earthquake_ins;
1614: else
1615: p_valid_upgrade := 'FALSE';
1616: end if;
1617: --
1618: hr_utility.trace(p_valid_upgrade);
1619: hr_utility.set_location('Leaving: ' || c_proc, 100);
1620: end validate_yea_earthquake_ins;
1621: -- |-------------------------------------------------------------------|
1622: -- |------------------< qualify_yea_earthquake_ins >-------------------|
1615: p_valid_upgrade := 'FALSE';
1616: end if;
1617: --
1618: hr_utility.trace(p_valid_upgrade);
1619: hr_utility.set_location('Leaving: ' || c_proc, 100);
1620: end validate_yea_earthquake_ins;
1621: -- |-------------------------------------------------------------------|
1622: -- |------------------< qualify_yea_earthquake_ins >-------------------|
1623: -- |-------------------------------------------------------------------|
1627: p_qualifier out nocopy varchar2)
1628: is
1629: c_proc constant varchar2(61) := c_package || 'qualify_yea_earthquake_ins';
1630: begin
1631: hr_utility.set_location('Entering: ' || c_proc, 10);
1632: --
1633: if entries_or_results_exist(p_assignment_id => p_assignment_id) then
1634: p_qualifier := 'Y';
1635: else
1635: else
1636: p_qualifier := 'N';
1637: end if;
1638: --
1639: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
1640: hr_utility.set_location('Leaving: ' || c_proc, 100);
1641: end qualify_yea_earthquake_ins;
1642: -- |-------------------------------------------------------------------|
1643: -- |------------------< upgrade_yea_earthquake_ins >-------------------|
1636: p_qualifier := 'N';
1637: end if;
1638: --
1639: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
1640: hr_utility.set_location('Leaving: ' || c_proc, 100);
1641: end qualify_yea_earthquake_ins;
1642: -- |-------------------------------------------------------------------|
1643: -- |------------------< upgrade_yea_earthquake_ins >-------------------|
1644: -- |-------------------------------------------------------------------|
1645: procedure upgrade_yea_earthquake_ins(p_assignment_id in number)
1646: is
1647: c_proc constant varchar2(61) := c_package || 'upgrade_yea_earthquake_ins';
1648: begin
1649: hr_utility.set_location('Entering: ' || c_proc, 10);
1650: --
1651: init_yea_earthquake_ins;
1652: --
1653: for i in 1..g_element_type_ids.count loop
1653: for i in 1..g_element_type_ids.count loop
1654: sync_entries_and_results(p_assignment_id, g_element_type_ids(i));
1655: end loop;
1656: --
1657: hr_utility.set_location('Leaving: ' || c_proc, 100);
1658: end upgrade_yea_earthquake_ins;
1659: -- |-------------------------------------------------------------------|
1660: -- |---------------------< validate_itw_archive >----------------------|
1661: -- |-------------------------------------------------------------------|
1718: || l_separator || p_token_value || l_separator;
1719: end if;
1720: end concat_parameter;
1721: begin
1722: hr_utility.set_location('Entering: ' || c_proc, 10);
1723: --
1724: p_valid_upgrade := 'FALSE';
1725: --
1726: for l_pact in csr_pacts loop
1749: concat_parameter('PUBLICATION_START_DATE', fnd_date.date_to_canonical(l_publication_start_date));
1750: concat_parameter('PUBLICATION_END_DATE', fnd_date.date_to_canonical(l_publication_end_date));
1751: concat_parameter('UPGRADE_FLAG', 'Y');
1752: --
1753: hr_utility.trace('payroll_action_id: ' || l_pact.payroll_action_id);
1754: hr_utility.trace('legislative_parameters: ' || l_legislative_parameters);
1755: --
1756: update pay_payroll_actions
1757: set legislative_parameters = l_legislative_parameters
1750: concat_parameter('PUBLICATION_END_DATE', fnd_date.date_to_canonical(l_publication_end_date));
1751: concat_parameter('UPGRADE_FLAG', 'Y');
1752: --
1753: hr_utility.trace('payroll_action_id: ' || l_pact.payroll_action_id);
1754: hr_utility.trace('legislative_parameters: ' || l_legislative_parameters);
1755: --
1756: update pay_payroll_actions
1757: set legislative_parameters = l_legislative_parameters
1758: where payroll_action_id = l_pact.payroll_action_id;
1774: p_action_information_id => l_id,
1775: p_object_version_number => l_ovn);
1776: end loop;
1777: --
1778: hr_utility.trace(p_valid_upgrade);
1779: hr_utility.set_location('Leaving: ' || c_proc, 100);
1780: end validate_itw_archive;
1781: -- |-------------------------------------------------------------------|
1782: -- |----------------------< qualify_itw_archive >----------------------|
1775: p_object_version_number => l_ovn);
1776: end loop;
1777: --
1778: hr_utility.trace(p_valid_upgrade);
1779: hr_utility.set_location('Leaving: ' || c_proc, 100);
1780: end validate_itw_archive;
1781: -- |-------------------------------------------------------------------|
1782: -- |----------------------< qualify_itw_archive >----------------------|
1783: -- |-------------------------------------------------------------------|
1806: and ppa.report_qualifier = 'JP'
1807: and ppa.report_category = 'ARCHIVE'
1808: and pay_core_utils.get_parameter('UPGRADE_FLAG', ppa.legislative_parameters) = 'Y');
1809: begin
1810: hr_utility.set_location('Entering: ' || c_proc, 10);
1811: --
1812: open csr_upgrade_required;
1813: fetch csr_upgrade_required into p_qualifier;
1814: if csr_upgrade_required%notfound then
1815: p_qualifier := 'N';
1816: end if;
1817: close csr_upgrade_required;
1818: --
1819: hr_utility.trace(p_assignment_id || ': ' || p_qualifier);
1820: hr_utility.set_location('Leaving: ' || c_proc, 100);
1821: end qualify_itw_archive;
1822: -- |-------------------------------------------------------------------|
1823: -- |-----------------------< to_canonical_date >-----------------------|
1816: end if;
1817: close csr_upgrade_required;
1818: --
1819: hr_utility.trace(p_assignment_id || ': ' || p_qualifier);
1820: hr_utility.set_location('Leaving: ' || c_proc, 100);
1821: end qualify_itw_archive;
1822: -- |-------------------------------------------------------------------|
1823: -- |-----------------------< to_canonical_date >-----------------------|
1824: -- |-------------------------------------------------------------------|
1902: for update of
1903: person.action_information_id,
1904: other2.action_information_id nowait;
1905: begin
1906: hr_utility.set_location('Entering: ' || c_proc, 10);
1907: --
1908: for l_rec in csr loop
1909: --
1910: -- JP_ITAX_PERSON
1998: action_information30 = l_wtm_user_desc_kana2
1999: where rowid = l_rec.other2_rowid;
2000: end loop;
2001: --
2002: hr_utility.set_location('Leaving: ' || c_proc, 100);
2003: end upgrade_itw_archive;
2004: --
2005: -- -------------------------------------------------------------------------
2006: -- qualify_hi_smr_data
2020: --
2021: begin
2022: --
2023: if g_debug then
2024: hr_utility.set_location(l_proc,0);
2025: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2026: end if;
2027: --
2028: hr_jp_data_migration_pkg.init_def_hi_smr_data;
2021: begin
2022: --
2023: if g_debug then
2024: hr_utility.set_location(l_proc,0);
2025: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2026: end if;
2027: --
2028: hr_jp_data_migration_pkg.init_def_hi_smr_data;
2029: --
2027: --
2028: hr_jp_data_migration_pkg.init_def_hi_smr_data;
2029: --
2030: if g_debug then
2031: hr_utility.set_location(l_proc,10);
2032: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2033: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2034: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2035: end if;
2028: hr_jp_data_migration_pkg.init_def_hi_smr_data;
2029: --
2030: if g_debug then
2031: hr_utility.set_location(l_proc,10);
2032: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2033: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2034: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2035: end if;
2036: --
2029: --
2030: if g_debug then
2031: hr_utility.set_location(l_proc,10);
2032: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2033: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2034: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2035: end if;
2036: --
2037: if hr_jp_data_migration_pkg.g_skip_qualify = 'N' then
2030: if g_debug then
2031: hr_utility.set_location(l_proc,10);
2032: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2033: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2034: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2035: end if;
2036: --
2037: if hr_jp_data_migration_pkg.g_skip_qualify = 'N' then
2038: --
2036: --
2037: if hr_jp_data_migration_pkg.g_skip_qualify = 'N' then
2038: --
2039: if g_debug then
2040: hr_utility.set_location(l_proc,20);
2041: end if;
2042: --
2043: -- print header for each threads but it is ok because just log.
2044: hr_jp_data_migration_pkg.qualify_hi_smr_hd(
2044: hr_jp_data_migration_pkg.qualify_hi_smr_hd(
2045: p_assignment_id => p_assignment_id);
2046: --
2047: if g_debug then
2048: hr_utility.set_location(l_proc,30);
2049: end if;
2050: --
2051: l_ass_info := hr_jp_data_migration_pkg.get_ass_info(
2052: p_assignment_id => p_assignment_id,
2052: p_assignment_id => p_assignment_id,
2053: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2054: --
2055: if g_debug then
2056: hr_utility.set_location(l_proc,40);
2057: hr_utility.trace('l_ass_info.ass_id : '||to_char(l_ass_info.ass_id));
2058: end if;
2059: --
2060: hr_jp_data_migration_pkg.val_mig_smr_assact(
2053: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2054: --
2055: if g_debug then
2056: hr_utility.set_location(l_proc,40);
2057: hr_utility.trace('l_ass_info.ass_id : '||to_char(l_ass_info.ass_id));
2058: end if;
2059: --
2060: hr_jp_data_migration_pkg.val_mig_smr_assact(
2061: p_business_group_id => l_ass_info.bg_id,
2065: p_session_date => hr_jp_data_migration_pkg.g_mig_date,
2066: p_valid_delete => l_valid_delete);
2067: --
2068: if g_debug then
2069: hr_utility.set_location(l_proc,50);
2070: hr_utility.trace('l_valid_delete : '||l_valid_delete);
2071: end if;
2072: --
2073: p_qualifier := l_valid_delete;
2066: p_valid_delete => l_valid_delete);
2067: --
2068: if g_debug then
2069: hr_utility.set_location(l_proc,50);
2070: hr_utility.trace('l_valid_delete : '||l_valid_delete);
2071: end if;
2072: --
2073: p_qualifier := l_valid_delete;
2074: --
2083: --
2084: p_qualifier := 'Y';
2085: --
2086: if g_debug then
2087: hr_utility.set_location(l_proc,60);
2088: end if;
2089: --
2090: end if;
2091: --
2089: --
2090: end if;
2091: --
2092: if g_debug then
2093: hr_utility.trace('p_qualifier : '||p_qualifier);
2094: hr_utility.set_location(l_proc,1000);
2095: end if;
2096: --
2097: end qualify_hi_smr_data;
2090: end if;
2091: --
2092: if g_debug then
2093: hr_utility.trace('p_qualifier : '||p_qualifier);
2094: hr_utility.set_location(l_proc,1000);
2095: end if;
2096: --
2097: end qualify_hi_smr_data;
2098: --
2110: --
2111: begin
2112: --
2113: if g_debug then
2114: hr_utility.set_location(l_proc,0);
2115: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2116: end if;
2117: --
2118: -- need to reset for retry, qualify_obs_data is not called in retry process.
2111: begin
2112: --
2113: if g_debug then
2114: hr_utility.set_location(l_proc,0);
2115: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2116: end if;
2117: --
2118: -- need to reset for retry, qualify_obs_data is not called in retry process.
2119: hr_jp_data_migration_pkg.init_def_hi_smr_data;
2118: -- need to reset for retry, qualify_obs_data is not called in retry process.
2119: hr_jp_data_migration_pkg.init_def_hi_smr_data;
2120: --
2121: if g_debug then
2122: hr_utility.set_location(l_proc,10);
2123: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2124: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2125: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2126: end if;
2119: hr_jp_data_migration_pkg.init_def_hi_smr_data;
2120: --
2121: if g_debug then
2122: hr_utility.set_location(l_proc,10);
2123: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2124: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2125: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2126: end if;
2127: --
2120: --
2121: if g_debug then
2122: hr_utility.set_location(l_proc,10);
2123: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2124: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2125: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2126: end if;
2127: --
2128: -- print header for each threads but it is ok because just log.
2121: if g_debug then
2122: hr_utility.set_location(l_proc,10);
2123: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2124: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2125: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2126: end if;
2127: --
2128: -- print header for each threads but it is ok because just log.
2129: hr_jp_data_migration_pkg.migrate_hi_smr_hd(
2129: hr_jp_data_migration_pkg.migrate_hi_smr_hd(
2130: p_assignment_id => p_assignment_id);
2131: --
2132: if g_debug then
2133: hr_utility.set_location(l_proc,20);
2134: end if;
2135: --
2136: l_ass_info := hr_jp_data_migration_pkg.get_ass_info(
2137: p_assignment_id => p_assignment_id,
2137: p_assignment_id => p_assignment_id,
2138: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2139: --
2140: if g_debug then
2141: hr_utility.set_location(l_proc,30);
2142: hr_utility.trace('l_ass_info.ass_id : '||to_char(l_ass_info.ass_id));
2143: end if;
2144: --
2145: -- for api use
2138: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2139: --
2140: if g_debug then
2141: hr_utility.set_location(l_proc,30);
2142: hr_utility.trace('l_ass_info.ass_id : '||to_char(l_ass_info.ass_id));
2143: end if;
2144: --
2145: -- for api use
2146: hr_jp_data_migration_pkg.insert_session(
2161: -- automatically commit will be executed for each assignment in archive process.
2162: -- commit;
2163: --
2164: if g_debug then
2165: hr_utility.set_location(l_proc,1000);
2166: end if;
2167: --
2168: end migrate_hi_smr_data;
2169: --
2177: --
2178: begin
2179: --
2180: if g_debug then
2181: hr_utility.set_location('Entering: ' || c_proc, 10);
2182: end if;
2183: --
2184: if g_element_type_ids.count = 0 then
2185: --
2183: --
2184: if g_element_type_ids.count = 0 then
2185: --
2186: if g_debug then
2187: hr_utility.trace('Not cached.');
2188: end if;
2189: --
2190: get_element_type_id('BON_HI_ADJ_INFO', g_element_type_ids);
2191: get_element_type_id('BON_HI_STD_BON', g_element_type_ids);
2194: --
2195: for i in 1..g_element_type_ids.count loop
2196: --
2197: if g_debug then
2198: hr_utility.trace(i || ': ' || g_element_type_ids(i));
2199: end if;
2200: --
2201: end loop;
2202: --
2200: --
2201: end loop;
2202: --
2203: if g_debug then
2204: hr_utility.set_location('Leaving: ' || c_proc, 100);
2205: end if;
2206: --
2207: end init_adj_ann_std_bon;
2208: --
2218: --
2219: begin
2220: --
2221: if g_debug then
2222: hr_utility.set_location('Entering: ' || c_proc, 10);
2223: end if;
2224: --
2225: init_adj_ann_std_bon;
2226: --
2236: p_valid_upgrade := 'FALSE';
2237: end if;
2238: --
2239: if g_debug then
2240: hr_utility.trace(p_valid_upgrade);
2241: hr_utility.set_location('Leaving: ' || c_proc, 100);
2242: end if;
2243: --
2244: end validate_adj_ann_std_bon;
2237: end if;
2238: --
2239: if g_debug then
2240: hr_utility.trace(p_valid_upgrade);
2241: hr_utility.set_location('Leaving: ' || c_proc, 100);
2242: end if;
2243: --
2244: end validate_adj_ann_std_bon;
2245: --
2254: c_proc constant varchar2(61) := c_package || 'qualify_adj_ann_std_bon';
2255: begin
2256: --
2257: if g_debug then
2258: hr_utility.set_location('Entering: ' || c_proc, 10);
2259: end if;
2260: --
2261: if entries_or_results_exist(p_assignment_id => p_assignment_id) then
2262: p_qualifier := 'Y';
2263: else
2264: p_qualifier := 'N';
2265: end if;
2266: --
2267: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
2268: hr_utility.set_location('Leaving: ' || c_proc, 100);
2269: --
2270: end qualify_adj_ann_std_bon;
2271: --
2264: p_qualifier := 'N';
2265: end if;
2266: --
2267: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
2268: hr_utility.set_location('Leaving: ' || c_proc, 100);
2269: --
2270: end qualify_adj_ann_std_bon;
2271: --
2272: -- -------------------------------------------------------------------------
2278: c_proc constant varchar2(61) := c_package || 'upgrade_adj_ann_std_bon';
2279: begin
2280: --
2281: if g_debug then
2282: hr_utility.set_location('Entering: ' || c_proc, 10);
2283: end if;
2284: --
2285: init_adj_ann_std_bon;
2286: --
2288: sync_entries_and_results(p_assignment_id, g_element_type_ids(i));
2289: end loop;
2290: --
2291: if g_debug then
2292: hr_utility.set_location('Leaving: ' || c_proc, 100);
2293: end if;
2294: --
2295: end upgrade_adj_ann_std_bon;
2296: --
2312: --
2313: begin
2314: --
2315: if g_debug then
2316: hr_utility.set_location(l_proc,0);
2317: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2318: end if;
2319: --
2320: hr_jp_data_migration_pkg.init_def_dep_data;
2313: begin
2314: --
2315: if g_debug then
2316: hr_utility.set_location(l_proc,0);
2317: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2318: end if;
2319: --
2320: hr_jp_data_migration_pkg.init_def_dep_data;
2321: --
2319: --
2320: hr_jp_data_migration_pkg.init_def_dep_data;
2321: --
2322: if g_debug then
2323: hr_utility.set_location(l_proc,10);
2324: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2325: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2326: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2327: end if;
2320: hr_jp_data_migration_pkg.init_def_dep_data;
2321: --
2322: if g_debug then
2323: hr_utility.set_location(l_proc,10);
2324: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2325: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2326: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2327: end if;
2328: --
2321: --
2322: if g_debug then
2323: hr_utility.set_location(l_proc,10);
2324: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2325: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2326: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2327: end if;
2328: --
2329: if hr_jp_data_migration_pkg.g_skip_qualify = 'N' then
2322: if g_debug then
2323: hr_utility.set_location(l_proc,10);
2324: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2325: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2326: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2327: end if;
2328: --
2329: if hr_jp_data_migration_pkg.g_skip_qualify = 'N' then
2330: --
2328: --
2329: if hr_jp_data_migration_pkg.g_skip_qualify = 'N' then
2330: --
2331: if g_debug then
2332: hr_utility.set_location(l_proc,20);
2333: end if;
2334: --
2335: -- print header for each threads but it is ok because just log.
2336: hr_jp_data_migration_pkg.qualify_dep_hd(
2336: hr_jp_data_migration_pkg.qualify_dep_hd(
2337: p_assignment_id => p_assignment_id);
2338: --
2339: if g_debug then
2340: hr_utility.set_location(l_proc,30);
2341: end if;
2342: --
2343: l_ass_info := hr_jp_data_migration_pkg.get_ass_info(
2344: p_assignment_id => p_assignment_id,
2344: p_assignment_id => p_assignment_id,
2345: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2346: --
2347: if g_debug then
2348: hr_utility.set_location(l_proc,40);
2349: hr_utility.trace('l_ass_info.ass_id : '||to_char(l_ass_info.ass_id));
2350: end if;
2351: --
2352: hr_jp_data_migration_pkg.val_mig_dep_assact(
2345: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2346: --
2347: if g_debug then
2348: hr_utility.set_location(l_proc,40);
2349: hr_utility.trace('l_ass_info.ass_id : '||to_char(l_ass_info.ass_id));
2350: end if;
2351: --
2352: hr_jp_data_migration_pkg.val_mig_dep_assact(
2353: p_business_group_id => l_ass_info.bg_id,
2357: p_session_date => hr_jp_data_migration_pkg.g_mig_date,
2358: p_valid_update => l_valid_update);
2359: --
2360: if g_debug then
2361: hr_utility.set_location(l_proc,50);
2362: hr_utility.trace('l_valid_update : '||l_valid_update);
2363: end if;
2364: --
2365: p_qualifier := l_valid_update;
2358: p_valid_update => l_valid_update);
2359: --
2360: if g_debug then
2361: hr_utility.set_location(l_proc,50);
2362: hr_utility.trace('l_valid_update : '||l_valid_update);
2363: end if;
2364: --
2365: p_qualifier := l_valid_update;
2366: --
2374: --
2375: p_qualifier := 'Y';
2376: --
2377: if g_debug then
2378: hr_utility.set_location(l_proc,60);
2379: end if;
2380: --
2381: end if;
2382: --
2380: --
2381: end if;
2382: --
2383: if g_debug then
2384: hr_utility.trace('p_qualifier : '||p_qualifier);
2385: hr_utility.set_location(l_proc,1000);
2386: end if;
2387: --
2388: end qualify_dep_data;
2381: end if;
2382: --
2383: if g_debug then
2384: hr_utility.trace('p_qualifier : '||p_qualifier);
2385: hr_utility.set_location(l_proc,1000);
2386: end if;
2387: --
2388: end qualify_dep_data;
2389: --
2401: --
2402: begin
2403: --
2404: if g_debug then
2405: hr_utility.set_location(l_proc,0);
2406: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2407: end if;
2408: --
2409: -- need to reset for retry, qualify_dep_data is not called in retry process.
2402: begin
2403: --
2404: if g_debug then
2405: hr_utility.set_location(l_proc,0);
2406: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2407: end if;
2408: --
2409: -- need to reset for retry, qualify_dep_data is not called in retry process.
2410: hr_jp_data_migration_pkg.init_def_dep_data;
2409: -- need to reset for retry, qualify_dep_data is not called in retry process.
2410: hr_jp_data_migration_pkg.init_def_dep_data;
2411: --
2412: if g_debug then
2413: hr_utility.set_location(l_proc,10);
2414: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2415: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2416: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2417: end if;
2410: hr_jp_data_migration_pkg.init_def_dep_data;
2411: --
2412: if g_debug then
2413: hr_utility.set_location(l_proc,10);
2414: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2415: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2416: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2417: end if;
2418: --
2411: --
2412: if g_debug then
2413: hr_utility.set_location(l_proc,10);
2414: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2415: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2416: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2417: end if;
2418: --
2419: -- print header for each threads but it is ok because just log.
2412: if g_debug then
2413: hr_utility.set_location(l_proc,10);
2414: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2415: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2416: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2417: end if;
2418: --
2419: -- print header for each threads but it is ok because just log.
2420: hr_jp_data_migration_pkg.migrate_dep_hd(
2420: hr_jp_data_migration_pkg.migrate_dep_hd(
2421: p_assignment_id => p_assignment_id);
2422: --
2423: if g_debug then
2424: hr_utility.set_location(l_proc,20);
2425: end if;
2426: --
2427: l_ass_info := hr_jp_data_migration_pkg.get_ass_info(
2428: p_assignment_id => p_assignment_id,
2428: p_assignment_id => p_assignment_id,
2429: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2430: --
2431: if g_debug then
2432: hr_utility.set_location(l_proc,30);
2433: hr_utility.trace('l_ass_info.ass_id : '||to_char(l_ass_info.ass_id));
2434: end if;
2435: --
2436: -- for api use
2429: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2430: --
2431: if g_debug then
2432: hr_utility.set_location(l_proc,30);
2433: hr_utility.trace('l_ass_info.ass_id : '||to_char(l_ass_info.ass_id));
2434: end if;
2435: --
2436: -- for api use
2437: hr_jp_data_migration_pkg.insert_session(
2451: -- automatically commit will be executed for each assignment in archive process.
2452: -- commit;
2453: --
2454: if g_debug then
2455: hr_utility.set_location(l_proc,1000);
2456: end if;
2457: --
2458: end migrate_dep_data;
2459: --
2464: is
2465: c_proc constant varchar2(61) := c_package || 'init_yea_ins_dct';
2466: begin
2467: --
2468: hr_utility.set_location('Entering: ' || c_proc, 10);
2469: --
2470: if g_element_type_ids.count = 0 then
2471: --
2472: hr_utility.trace('Not cached.');
2468: hr_utility.set_location('Entering: ' || c_proc, 10);
2469: --
2470: if g_element_type_ids.count = 0 then
2471: --
2472: hr_utility.trace('Not cached.');
2473: --
2474: get_element_type_id('YEA_INS_PREM_SPOUSE_SP_EXM_INFO', g_element_type_ids);
2475: get_element_type_id('INI_YEA2', g_element_type_ids);
2476: --
2476: --
2477: end if;
2478: --
2479: for i in 1..g_element_type_ids.count loop
2480: hr_utility.trace(i || ': ' || g_element_type_ids(i));
2481: end loop;
2482: --
2483: hr_utility.set_location('Leaving: ' || c_proc, 100);
2484: --
2479: for i in 1..g_element_type_ids.count loop
2480: hr_utility.trace(i || ': ' || g_element_type_ids(i));
2481: end loop;
2482: --
2483: hr_utility.set_location('Leaving: ' || c_proc, 100);
2484: --
2485: end init_yea_ins_dct;
2486: --
2487: -- -------------------------------------------------------------------------
2494: c_proc constant varchar2(61) := c_package || 'validate_yea_ins_dct';
2495: --
2496: begin
2497: --
2498: hr_utility.set_location('Entering: ' || c_proc, 10);
2499: --
2500: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
2501: --
2502: init_yea_ins_dct;
2510: else
2511: p_valid_upgrade := 'FALSE';
2512: end if;
2513: --
2514: hr_utility.trace(p_valid_upgrade);
2515: hr_utility.set_location('Leaving: ' || c_proc, 100);
2516: --
2517: end validate_yea_ins_dct;
2518: --
2511: p_valid_upgrade := 'FALSE';
2512: end if;
2513: --
2514: hr_utility.trace(p_valid_upgrade);
2515: hr_utility.set_location('Leaving: ' || c_proc, 100);
2516: --
2517: end validate_yea_ins_dct;
2518: --
2519: -- -------------------------------------------------------------------------
2528: c_proc constant varchar2(61) := c_package || 'qualify_yea_ins_dct';
2529: --
2530: begin
2531: --
2532: hr_utility.set_location('Entering: ' || c_proc, 10);
2533: --
2534: if entries_or_results_exist(p_assignment_id => p_assignment_id) then
2535: p_qualifier := 'Y';
2536: else
2536: else
2537: p_qualifier := 'N';
2538: end if;
2539: --
2540: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
2541: hr_utility.set_location('Leaving: ' || c_proc, 100);
2542: --
2543: end qualify_yea_ins_dct;
2544: --
2537: p_qualifier := 'N';
2538: end if;
2539: --
2540: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
2541: hr_utility.set_location('Leaving: ' || c_proc, 100);
2542: --
2543: end qualify_yea_ins_dct;
2544: --
2545: -- -------------------------------------------------------------------------
2551: c_proc constant varchar2(61) := c_package || 'upgrade_yea_ins_dct';
2552: --
2553: begin
2554: --
2555: hr_utility.set_location('Entering: ' || c_proc, 10);
2556: --
2557: init_yea_ins_dct;
2558: --
2559: for i in 1..g_element_type_ids.count loop
2559: for i in 1..g_element_type_ids.count loop
2560: sync_entries_and_results(p_assignment_id, g_element_type_ids(i));
2561: end loop;
2562: --
2563: hr_utility.set_location('Leaving: ' || c_proc, 100);
2564: --
2565: end upgrade_yea_ins_dct;
2566: --
2567: -- |-------------------------------------------------------------------|
2570: procedure init_yea_ins_prem_2012
2571: is
2572: c_proc constant varchar2(61) := c_package || 'init_yea_ins_prem_2012';
2573: begin
2574: hr_utility.set_location('Entering: ' || c_proc, 10);
2575: --
2576: if g_element_type_ids.count = 0 then
2577: hr_utility.trace('Not cached.');
2578: --
2573: begin
2574: hr_utility.set_location('Entering: ' || c_proc, 10);
2575: --
2576: if g_element_type_ids.count = 0 then
2577: hr_utility.trace('Not cached.');
2578: --
2579: get_element_type_id('YEA_INS_PREM_EXM_DECLARE_INFO', g_element_type_ids);
2580: end if;
2581: --
2579: get_element_type_id('YEA_INS_PREM_EXM_DECLARE_INFO', g_element_type_ids);
2580: end if;
2581: --
2582: for i in 1..g_element_type_ids.count loop
2583: hr_utility.trace(i || ': ' || g_element_type_ids(i));
2584: end loop;
2585: --
2586: hr_utility.set_location('Leaving: ' || c_proc, 100);
2587: end init_yea_ins_prem_2012;
2582: for i in 1..g_element_type_ids.count loop
2583: hr_utility.trace(i || ': ' || g_element_type_ids(i));
2584: end loop;
2585: --
2586: hr_utility.set_location('Leaving: ' || c_proc, 100);
2587: end init_yea_ins_prem_2012;
2588: -- |-------------------------------------------------------------------|
2589: -- |------------------< validate_yea_ins_prem_2012 >------------------|
2590: -- |-------------------------------------------------------------------|
2592: procedure validate_yea_ins_prem_2012(p_valid_upgrade out nocopy varchar2)
2593: is
2594: c_proc constant varchar2(61) := c_package || 'validate_yea_ins_prem_2012';
2595: begin
2596: hr_utility.set_location('Entering: ' || c_proc, 10);
2597: --
2598: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
2599: --
2600: init_yea_ins_prem_2012;
2608: else
2609: p_valid_upgrade := 'FALSE';
2610: end if;
2611: --
2612: hr_utility.trace(p_valid_upgrade);
2613: hr_utility.set_location('Leaving: ' || c_proc, 100);
2614: end validate_yea_ins_prem_2012;
2615: -- |-------------------------------------------------------------------|
2616: -- |------------------< qualify_yea_ins_prem_2012 >-------------------|
2609: p_valid_upgrade := 'FALSE';
2610: end if;
2611: --
2612: hr_utility.trace(p_valid_upgrade);
2613: hr_utility.set_location('Leaving: ' || c_proc, 100);
2614: end validate_yea_ins_prem_2012;
2615: -- |-------------------------------------------------------------------|
2616: -- |------------------< qualify_yea_ins_prem_2012 >-------------------|
2617: -- |-------------------------------------------------------------------|
2621: p_qualifier out nocopy varchar2)
2622: is
2623: c_proc constant varchar2(61) := c_package || 'qualify_yea_ins_prem_2012';
2624: begin
2625: hr_utility.set_location('Entering: ' || c_proc, 10);
2626: --
2627: if entries_or_results_exist(p_assignment_id => p_assignment_id) then
2628: p_qualifier := 'Y';
2629: else
2629: else
2630: p_qualifier := 'N';
2631: end if;
2632: --
2633: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
2634: hr_utility.set_location('Leaving: ' || c_proc, 100);
2635: end qualify_yea_ins_prem_2012;
2636: -- |-------------------------------------------------------------------|
2637: -- |------------------< upgrade_yea_ins_prem_2012 >-------------------|
2630: p_qualifier := 'N';
2631: end if;
2632: --
2633: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
2634: hr_utility.set_location('Leaving: ' || c_proc, 100);
2635: end qualify_yea_ins_prem_2012;
2636: -- |-------------------------------------------------------------------|
2637: -- |------------------< upgrade_yea_ins_prem_2012 >-------------------|
2638: -- |-------------------------------------------------------------------|
2639: procedure upgrade_yea_ins_prem_2012(p_assignment_id in number)
2640: is
2641: c_proc constant varchar2(61) := c_package || 'upgrade_yea_ins_prem_2012';
2642: begin
2643: hr_utility.set_location('Entering: ' || c_proc, 10);
2644: --
2645: init_yea_ins_prem_2012;
2646: --
2647: for i in 1..g_element_type_ids.count loop
2647: for i in 1..g_element_type_ids.count loop
2648: sync_entries_and_results(p_assignment_id, g_element_type_ids(i));
2649: end loop;
2650: --
2651: hr_utility.set_location('Leaving: ' || c_proc, 100);
2652: end upgrade_yea_ins_prem_2012;
2653:
2654: -- |-------------------------------------------------------------------|
2655: -- |--------------------< init_net_annual_tax_2013 >--------------------|
2657: procedure init_net_annual_tax_2013
2658: is
2659: c_proc constant varchar2(61) := c_package || 'init_net_annual_tax_2013';
2660: begin
2661: hr_utility.set_location('Entering: ' || c_proc, 10);
2662: --
2663: if g_element_type_ids.count = 0 then
2664: hr_utility.trace('Not cached.');
2665: --
2660: begin
2661: hr_utility.set_location('Entering: ' || c_proc, 10);
2662: --
2663: if g_element_type_ids.count = 0 then
2664: hr_utility.trace('Not cached.');
2665: --
2666: get_element_type_id('YEA_NET_ANNUAL_TAX', g_element_type_ids);
2667: end if;
2668: --
2666: get_element_type_id('YEA_NET_ANNUAL_TAX', g_element_type_ids);
2667: end if;
2668: --
2669: for i in 1..g_element_type_ids.count loop
2670: hr_utility.trace(i || ': ' || g_element_type_ids(i));
2671: end loop;
2672: --
2673: hr_utility.set_location('Leaving: ' || c_proc, 100);
2674: end init_net_annual_tax_2013;
2669: for i in 1..g_element_type_ids.count loop
2670: hr_utility.trace(i || ': ' || g_element_type_ids(i));
2671: end loop;
2672: --
2673: hr_utility.set_location('Leaving: ' || c_proc, 100);
2674: end init_net_annual_tax_2013;
2675: -- |-------------------------------------------------------------------|
2676: -- |------------------< validate_net_annual_tax_2013 >------------------|
2677: -- |-------------------------------------------------------------------|
2679: procedure validate_net_annual_tax_2013(p_valid_upgrade out nocopy varchar2)
2680: is
2681: c_proc constant varchar2(61) := c_package || 'validate_net_annual_tax_2013';
2682: begin
2683: hr_utility.set_location('Entering: ' || c_proc, 10);
2684: --
2685: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
2686: --
2687: init_net_annual_tax_2013;
2695: else
2696: p_valid_upgrade := 'FALSE';
2697: end if;
2698: --
2699: hr_utility.trace(p_valid_upgrade);
2700: hr_utility.set_location('Leaving: ' || c_proc, 100);
2701: end validate_net_annual_tax_2013;
2702: -- |-------------------------------------------------------------------|
2703: -- |------------------< qualify_net_annual_tax_2013 >-------------------|
2696: p_valid_upgrade := 'FALSE';
2697: end if;
2698: --
2699: hr_utility.trace(p_valid_upgrade);
2700: hr_utility.set_location('Leaving: ' || c_proc, 100);
2701: end validate_net_annual_tax_2013;
2702: -- |-------------------------------------------------------------------|
2703: -- |------------------< qualify_net_annual_tax_2013 >-------------------|
2704: -- |-------------------------------------------------------------------|
2708: p_qualifier out nocopy varchar2)
2709: is
2710: c_proc constant varchar2(61) := c_package || 'qualify_net_annual_tax_2013';
2711: begin
2712: hr_utility.set_location('Entering: ' || c_proc, 10);
2713: --
2714: if entries_or_results_exist(p_assignment_id => p_assignment_id) then
2715: p_qualifier := 'Y';
2716: else
2716: else
2717: p_qualifier := 'N';
2718: end if;
2719: --
2720: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
2721: hr_utility.set_location('Leaving: ' || c_proc, 100);
2722: end qualify_net_annual_tax_2013;
2723: -- |-------------------------------------------------------------------|
2724: -- |------------------< upgrade_net_annual_tax_2013 >-------------------|
2717: p_qualifier := 'N';
2718: end if;
2719: --
2720: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
2721: hr_utility.set_location('Leaving: ' || c_proc, 100);
2722: end qualify_net_annual_tax_2013;
2723: -- |-------------------------------------------------------------------|
2724: -- |------------------< upgrade_net_annual_tax_2013 >-------------------|
2725: -- |-------------------------------------------------------------------|
2726: procedure upgrade_net_annual_tax_2013(p_assignment_id in number)
2727: is
2728: c_proc constant varchar2(61) := c_package || 'upgrade_net_annual_tax_2013';
2729: begin
2730: hr_utility.set_location('Entering: ' || c_proc, 10);
2731: --
2732: init_net_annual_tax_2013;
2733: --
2734: for i in 1..g_element_type_ids.count loop
2734: for i in 1..g_element_type_ids.count loop
2735: sync_entries_and_results(p_assignment_id, g_element_type_ids(i));
2736: end loop;
2737: --
2738: hr_utility.set_location('Leaving: ' || c_proc, 100);
2739: end upgrade_net_annual_tax_2013;
2740:
2741: ----
2742: -- |-------------------------------------------------------------------|
2745: procedure init_spc_exec_2013
2746: is
2747: c_proc constant varchar2(61) := c_package || 'init_spc_exec_2013';
2748: begin
2749: hr_utility.set_location('Entering: ' || c_proc, 10);
2750: --
2751: if g_element_type_ids.count = 0 then
2752: hr_utility.trace('Not cached.');
2753: --
2748: begin
2749: hr_utility.set_location('Entering: ' || c_proc, 10);
2750: --
2751: if g_element_type_ids.count = 0 then
2752: hr_utility.trace('Not cached.');
2753: --
2754: get_element_type_id('TRM_INCOME_DCT', g_element_type_ids);
2755: end if;
2756: --
2754: get_element_type_id('TRM_INCOME_DCT', g_element_type_ids);
2755: end if;
2756: --
2757: for i in 1..g_element_type_ids.count loop
2758: hr_utility.trace(i || ': ' || g_element_type_ids(i));
2759: end loop;
2760: --
2761: hr_utility.set_location('Leaving: ' || c_proc, 100);
2762: end init_spc_exec_2013;
2757: for i in 1..g_element_type_ids.count loop
2758: hr_utility.trace(i || ': ' || g_element_type_ids(i));
2759: end loop;
2760: --
2761: hr_utility.set_location('Leaving: ' || c_proc, 100);
2762: end init_spc_exec_2013;
2763: -- |-------------------------------------------------------------------|
2764: -- |------------------< validate_spc_exec_2013 >------------------|
2765: -- |-------------------------------------------------------------------|
2767: procedure validate_spc_exec_2013(p_valid_upgrade out nocopy varchar2)
2768: is
2769: c_proc constant varchar2(61) := c_package || 'validate_spc_exec_2013';
2770: begin
2771: hr_utility.set_location('Entering: ' || c_proc, 10);
2772: --
2773: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
2774: --
2775: init_spc_exec_2013;
2783: else
2784: p_valid_upgrade := 'FALSE';
2785: end if;
2786: --
2787: hr_utility.trace(p_valid_upgrade);
2788: hr_utility.set_location('Leaving: ' || c_proc, 100);
2789: end validate_spc_exec_2013;
2790: -- |-------------------------------------------------------------------|
2791: -- |------------------< qualify_spc_exec_2013 >-------------------|
2784: p_valid_upgrade := 'FALSE';
2785: end if;
2786: --
2787: hr_utility.trace(p_valid_upgrade);
2788: hr_utility.set_location('Leaving: ' || c_proc, 100);
2789: end validate_spc_exec_2013;
2790: -- |-------------------------------------------------------------------|
2791: -- |------------------< qualify_spc_exec_2013 >-------------------|
2792: -- |-------------------------------------------------------------------|
2796: p_qualifier out nocopy varchar2)
2797: is
2798: c_proc constant varchar2(61) := c_package || 'qualify_spc_exec_2013';
2799: begin
2800: hr_utility.set_location('Entering: ' || c_proc, 10);
2801: --
2802: if entries_or_results_exist(p_assignment_id => p_assignment_id) then
2803: p_qualifier := 'Y';
2804: else
2804: else
2805: p_qualifier := 'N';
2806: end if;
2807: --
2808: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
2809: hr_utility.set_location('Leaving: ' || c_proc, 100);
2810: end qualify_spc_exec_2013;
2811: -- |-------------------------------------------------------------------|
2812: -- |------------------< upgrade_spc_exec_2013 >-------------------|
2805: p_qualifier := 'N';
2806: end if;
2807: --
2808: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
2809: hr_utility.set_location('Leaving: ' || c_proc, 100);
2810: end qualify_spc_exec_2013;
2811: -- |-------------------------------------------------------------------|
2812: -- |------------------< upgrade_spc_exec_2013 >-------------------|
2813: -- |-------------------------------------------------------------------|
2814: procedure upgrade_spc_exec_2013(p_assignment_id in number)
2815: is
2816: c_proc constant varchar2(61) := c_package || 'upgrade_spc_exec_2013';
2817: begin
2818: hr_utility.set_location('Entering: ' || c_proc, 10);
2819: --
2820: init_spc_exec_2013;
2821: --
2822: for i in 1..g_element_type_ids.count loop
2822: for i in 1..g_element_type_ids.count loop
2823: sync_entries_and_results(p_assignment_id, g_element_type_ids(i));
2824: end loop;
2825: --
2826: hr_utility.set_location('Leaving: ' || c_proc, 100);
2827: end upgrade_spc_exec_2013;
2828:
2829: /*
2830: -- |-------------------------------------------------------------------|
3029: argument10 => fnd_number.number_to_canonical(l_upgrade_def.upgrade_definition_id), -- ID
3030: argument11 => p_upgrade_short_name, -- Short Name
3031: argument12 => 'UPG_DEF_NAME=' || p_upgrade_short_name); -- Upgrade Name
3032: if l_request_id = 0 then
3033: hr_utility.raise_error;
3034: end if;
3035: else
3036: set_upgrade_completed;
3037: end if;