[Home] [Help]
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.
890: and peev.effective_start_date = pee.effective_start_date
891: and peev.effective_end_date = pee.effective_end_date
892: and peev.input_value_id = piv.input_value_id);
893: --
894: hr_utility.trace('assignment_id : ' || p_assignment_id);
895: hr_utility.trace('element_type_id : ' || p_element_type_id);
896: hr_utility.trace(sql%rowcount || ' rows inserted into pay_element_entry_values_f');
897: --
898: -- Check RR_SPARSE legislation rule
891: and peev.effective_end_date = pee.effective_end_date
892: and peev.input_value_id = piv.input_value_id);
893: --
894: hr_utility.trace('assignment_id : ' || p_assignment_id);
895: hr_utility.trace('element_type_id : ' || p_element_type_id);
896: hr_utility.trace(sql%rowcount || ' rows inserted into pay_element_entry_values_f');
897: --
898: -- Check RR_SPARSE legislation rule
899: --
892: and peev.input_value_id = piv.input_value_id);
893: --
894: hr_utility.trace('assignment_id : ' || p_assignment_id);
895: hr_utility.trace('element_type_id : ' || p_element_type_id);
896: hr_utility.trace(sql%rowcount || ' rows inserted into pay_element_entry_values_f');
897: --
898: -- Check RR_SPARSE legislation rule
899: --
900: pay_core_utils.get_legislation_rule(
955: -- from pay_run_result_values prrv
956: -- where prrv.run_result_id = prr.run_result_id
957: -- and prrv.input_value_id = piv.input_value_id);
958: -- --
959: -- hr_utility.trace(sql%rowcount || ' rows inserted into pay_run_result_values (RR_SPARSE)');
960: --
961: -- When not RR_SPARSE, create "null" result values for all appropriate run results.
962: --
963: else
991: from pay_run_result_values prrv
992: where prrv.run_result_id = prr.run_result_id
993: and prrv.input_value_id = piv.input_value_id);
994: --
995: hr_utility.trace(sql%rowcount || ' rows inserted into pay_run_result_values');
996: end if;
997: end if;
998: --
999: hr_utility.set_location('Leaving: ' || c_proc, 100);
995: hr_utility.trace(sql%rowcount || ' rows inserted into pay_run_result_values');
996: end if;
997: end if;
998: --
999: hr_utility.set_location('Leaving: ' || c_proc, 100);
1000: end sync_entries_and_results;
1001: -- |-------------------------------------------------------------------|
1002: -- |----------------------< get_element_type_id >----------------------|
1003: -- |-------------------------------------------------------------------|
1017: begin
1018: open csr_id;
1019: fetch csr_id into l_element_type_id;
1020: if csr_id%found then
1021: hr_utility.trace(p_element_name || ': ' || l_element_type_id);
1022: p_element_type_ids(p_element_type_ids.count + 1) := l_element_type_id;
1023: else
1024: hr_utility.trace(p_element_name || ' NOT found!');
1025: end if;
1020: if csr_id%found then
1021: hr_utility.trace(p_element_name || ': ' || l_element_type_id);
1022: p_element_type_ids(p_element_type_ids.count + 1) := l_element_type_id;
1023: else
1024: hr_utility.trace(p_element_name || ' NOT found!');
1025: end if;
1026: close csr_id;
1027: end get_element_type_id;
1028: -- |-------------------------------------------------------------------|
1031: procedure init_pay_a
1032: is
1033: c_proc constant varchar2(61) := c_package || 'init_pay_a';
1034: begin
1035: hr_utility.set_location('Entering: ' || c_proc, 10);
1036: --
1037: if g_element_type_ids.count = 0 then
1038: hr_utility.trace('Not cached.');
1039: --
1034: begin
1035: hr_utility.set_location('Entering: ' || c_proc, 10);
1036: --
1037: if g_element_type_ids.count = 0 then
1038: hr_utility.trace('Not cached.');
1039: --
1040: get_element_type_id('INI_SAL2', g_element_type_ids);
1041: get_element_type_id('INI_BON2', g_element_type_ids);
1042: get_element_type_id('INI_SPB1', g_element_type_ids);
1061: get_element_type_id('SAN_REPORT_RMKS_RSLT', g_element_type_ids);
1062: end if;
1063: --
1064: -- for i in 1..g_element_type_ids.count loop
1065: -- hr_utility.trace(i || ': ' || g_element_type_ids(i));
1066: -- end loop;
1067: --
1068: hr_utility.set_location('Leaving: ' || c_proc, 100);
1069: end init_pay_a;
1064: -- for i in 1..g_element_type_ids.count loop
1065: -- hr_utility.trace(i || ': ' || g_element_type_ids(i));
1066: -- end loop;
1067: --
1068: hr_utility.set_location('Leaving: ' || c_proc, 100);
1069: end init_pay_a;
1070: -- |-------------------------------------------------------------------|
1071: -- |------------------------< validate_pay_a >-------------------------|
1072: -- |-------------------------------------------------------------------|
1077: l_element_type_id1 number;
1078: l_element_type_id2 number;
1079: l_element_type_id3 number;
1080: begin
1081: hr_utility.set_location('Entering: ' || c_proc, 10);
1082: --
1083: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
1084: --
1085: init_pay_a;
1093: else
1094: p_valid_upgrade := 'FALSE';
1095: end if;
1096: --
1097: hr_utility.trace(p_valid_upgrade);
1098: hr_utility.set_location('Leaving: ' || c_proc, 100);
1099: end validate_pay_a;
1100: -- |-------------------------------------------------------------------|
1101: -- |-------------------------< qualify_pay_a >-------------------------|
1094: p_valid_upgrade := 'FALSE';
1095: end if;
1096: --
1097: hr_utility.trace(p_valid_upgrade);
1098: hr_utility.set_location('Leaving: ' || c_proc, 100);
1099: end validate_pay_a;
1100: -- |-------------------------------------------------------------------|
1101: -- |-------------------------< qualify_pay_a >-------------------------|
1102: -- |-------------------------------------------------------------------|
1105: p_qualifier out nocopy varchar2)
1106: is
1107: c_proc constant varchar2(61) := c_package || 'qualify_pay_a';
1108: begin
1109: hr_utility.set_location('Entering: ' || c_proc, 10);
1110: --
1111: if entries_or_results_exist(p_assignment_id => p_assignment_id) then
1112: p_qualifier := 'Y';
1113: else
1113: else
1114: p_qualifier := 'N';
1115: end if;
1116: --
1117: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
1118: hr_utility.set_location('Leaving: ' || c_proc, 100);
1119: end qualify_pay_a;
1120: -- |-------------------------------------------------------------------|
1121: -- |----------------------< upgrade_pay_a >----------------------------|
1114: p_qualifier := 'N';
1115: end if;
1116: --
1117: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
1118: hr_utility.set_location('Leaving: ' || c_proc, 100);
1119: end qualify_pay_a;
1120: -- |-------------------------------------------------------------------|
1121: -- |----------------------< upgrade_pay_a >----------------------------|
1122: -- |-------------------------------------------------------------------|
1123: procedure upgrade_pay_a(p_assignment_id in number)
1124: is
1125: c_proc constant varchar2(61) := c_package || 'upgrade_pay_a';
1126: begin
1127: hr_utility.set_location('Entering: ' || c_proc, 10);
1128: --
1129: init_pay_a;
1130: --
1131: for i in 1..g_element_type_ids.count loop
1131: for i in 1..g_element_type_ids.count loop
1132: sync_entries_and_results(p_assignment_id, g_element_type_ids(i));
1133: end loop;
1134: --
1135: hr_utility.set_location('Leaving: ' || c_proc, 100);
1136: end upgrade_pay_a;
1137: -- |-------------------------------------------------------------------|
1138: -- |-------------------< validate_itax_description >-------------------|
1139: -- |-------------------------------------------------------------------|
1145: c_proc constant varchar2(61) := c_package || 'validate_itax_description';
1146: --
1147: begin
1148: --
1149: hr_utility.set_location('Entering: ' || c_proc, 10);
1150: --
1151: --
1152: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
1153: --
1168: else
1169: p_valid_upgrade := 'FALSE';
1170: end if;
1171: --
1172: hr_utility.trace(p_valid_upgrade);
1173: hr_utility.set_location('Leaving: ' || c_proc, 100);
1174: --
1175: end validate_itax_description;
1176: -- |-------------------------------------------------------------------|
1169: p_valid_upgrade := 'FALSE';
1170: end if;
1171: --
1172: hr_utility.trace(p_valid_upgrade);
1173: hr_utility.set_location('Leaving: ' || c_proc, 100);
1174: --
1175: end validate_itax_description;
1176: -- |-------------------------------------------------------------------|
1177: -- |-------------------< qualify_itax_description >--------------------|
1182: )
1183: is
1184: c_proc constant varchar2(61) := c_package || 'qualify_itax_description';
1185: begin
1186: hr_utility.set_location('Entering: ' || c_proc, 10);
1187: --
1188: if entries_or_results_exist(p_assignment_id => p_assignment_id) then
1189: p_qualifier := 'Y';
1190: else
1190: else
1191: p_qualifier := 'N';
1192: end if;
1193: --
1194: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
1195: hr_utility.set_location('Leaving: ' || c_proc, 100);
1196: end qualify_itax_description;
1197: -- |-------------------------------------------------------------------|
1198: -- |-------------------< upgrade_itax_description >--------------------|
1191: p_qualifier := 'N';
1192: end if;
1193: --
1194: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
1195: hr_utility.set_location('Leaving: ' || c_proc, 100);
1196: end qualify_itax_description;
1197: -- |-------------------------------------------------------------------|
1198: -- |-------------------< upgrade_itax_description >--------------------|
1199: -- |-------------------------------------------------------------------|
1203: is
1204: c_proc constant varchar2(61) := c_package || 'upgrade_itax_description';
1205: begin
1206: --
1207: hr_utility.set_location('Entering: ' || c_proc, 10);
1208: --
1209: if g_element_type_ids.count = 0 then
1210: --
1211: get_element_type_id('YEA_WITHHOLD_TAX_REPORT_INFO', g_element_type_ids);
1217: sync_entries_and_results(p_assignment_id, g_element_type_ids(i));
1218: --
1219: end loop;
1220: --
1221: hr_utility.set_location('Leaving: ' || c_proc, 100);
1222: --
1223: end upgrade_itax_description;
1224: -- |-------------------------------------------------------------------|
1225: -- |--------------------< validate_code_jp_pre_tax >-------------------|
1241: and action_context_type = 'AAP')
1242: and rownum =1;
1243:
1244: begin
1245: hr_utility.set_location('Entering: ' || c_proc, 10);
1246: --
1247: open csr_exists;
1248: fetch csr_exists into p_valid_upgrade;
1249: if csr_exists%notfound then
1250: p_valid_upgrade := 'FALSE';
1251: end if;
1252: close csr_exists;
1253: --
1254: hr_utility.trace(p_valid_upgrade);
1255: hr_utility.set_location('Leaving: ' || c_proc, 100);
1256: end validate_code_jp_pre_tax;
1257: -- |-------------------------------------------------------------------|
1258: -- |--------------------< qualifying_jp_pre_tax >----------------------|
1251: end if;
1252: close csr_exists;
1253: --
1254: hr_utility.trace(p_valid_upgrade);
1255: hr_utility.set_location('Leaving: ' || c_proc, 100);
1256: end validate_code_jp_pre_tax;
1257: -- |-------------------------------------------------------------------|
1258: -- |--------------------< qualifying_jp_pre_tax >----------------------|
1259: -- |-------------------------------------------------------------------|
1277: and action_context_type = 'AAP')
1278: and rownum = 1;
1279:
1280: begin
1281: hr_utility.set_location('Entering: ' || c_proc, 10);
1282: --
1283: open csr_ppt;
1284: fetch csr_ppt into p_qualifier;
1285: if csr_ppt%notfound then
1286: p_qualifier := 'N';
1287: end if;
1288: close csr_ppt;
1289: --
1290: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
1291: hr_utility.set_location('Leaving: ' || c_proc, 100);
1292: end qualifying_jp_pre_tax;
1293: -- |-------------------------------------------------------------------|
1294: -- |----------------------< upgrade_jp_pre_tax >-----------------------|
1287: end if;
1288: close csr_ppt;
1289: --
1290: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
1291: hr_utility.set_location('Leaving: ' || c_proc, 100);
1292: end qualifying_jp_pre_tax;
1293: -- |-------------------------------------------------------------------|
1294: -- |----------------------< upgrade_jp_pre_tax >-----------------------|
1295: -- |-------------------------------------------------------------------|
1327: for update of ppt.pre_tax_id;
1328:
1329: begin
1330: begin
1331: hr_utility.set_location('Entering: ' || c_proc, 10);
1332: hr_utility.trace('assignment_id: ' || p_assignment_id);
1333: --
1334: for l_pre_tax in csr_pre_tax
1335: loop
1328:
1329: begin
1330: begin
1331: hr_utility.set_location('Entering: ' || c_proc, 10);
1332: hr_utility.trace('assignment_id: ' || p_assignment_id);
1333: --
1334: for l_pre_tax in csr_pre_tax
1335: loop
1336: hr_utility.set_location(c_proc, 20);
1332: hr_utility.trace('assignment_id: ' || p_assignment_id);
1333: --
1334: for l_pre_tax in csr_pre_tax
1335: loop
1336: hr_utility.set_location(c_proc, 20);
1337: --
1338: l_effective_date := l_pre_tax.effective_date;
1339: --
1340: select asg.person_id,
1354: where asg.assignment_id = p_assignment_id
1355: and l_effective_date between asg.effective_start_date and asg.effective_end_date
1356: and pds.period_of_service_id = asg.period_of_service_id;
1357: --
1358: hr_utility.trace('salary_category : ' || l_pre_tax.salary_category);
1359: hr_utility.trace('taxable_sal_amt : ' || l_pre_tax.taxable_sal_amt);
1360: hr_utility.trace('taxable_mat_amt : ' || l_pre_tax.taxable_mat_amt);
1361: hr_utility.trace('previous_taxable_amt : ' || l_pre_tax.previous_taxable_amt);
1362: hr_utility.trace('hi_organization_id : ' || l_pre_tax.hi_organization_id);
1355: and l_effective_date between asg.effective_start_date and asg.effective_end_date
1356: and pds.period_of_service_id = asg.period_of_service_id;
1357: --
1358: hr_utility.trace('salary_category : ' || l_pre_tax.salary_category);
1359: hr_utility.trace('taxable_sal_amt : ' || l_pre_tax.taxable_sal_amt);
1360: hr_utility.trace('taxable_mat_amt : ' || l_pre_tax.taxable_mat_amt);
1361: hr_utility.trace('previous_taxable_amt : ' || l_pre_tax.previous_taxable_amt);
1362: hr_utility.trace('hi_organization_id : ' || l_pre_tax.hi_organization_id);
1363: hr_utility.trace('hi_prem_ee : ' || l_pre_tax.hi_prem_ee);
1356: and pds.period_of_service_id = asg.period_of_service_id;
1357: --
1358: hr_utility.trace('salary_category : ' || l_pre_tax.salary_category);
1359: hr_utility.trace('taxable_sal_amt : ' || l_pre_tax.taxable_sal_amt);
1360: hr_utility.trace('taxable_mat_amt : ' || l_pre_tax.taxable_mat_amt);
1361: hr_utility.trace('previous_taxable_amt : ' || l_pre_tax.previous_taxable_amt);
1362: hr_utility.trace('hi_organization_id : ' || l_pre_tax.hi_organization_id);
1363: hr_utility.trace('hi_prem_ee : ' || l_pre_tax.hi_prem_ee);
1364: hr_utility.trace('hi_prem_er : ' || l_pre_tax.hi_prem_er);
1357: --
1358: hr_utility.trace('salary_category : ' || l_pre_tax.salary_category);
1359: hr_utility.trace('taxable_sal_amt : ' || l_pre_tax.taxable_sal_amt);
1360: hr_utility.trace('taxable_mat_amt : ' || l_pre_tax.taxable_mat_amt);
1361: hr_utility.trace('previous_taxable_amt : ' || l_pre_tax.previous_taxable_amt);
1362: hr_utility.trace('hi_organization_id : ' || l_pre_tax.hi_organization_id);
1363: hr_utility.trace('hi_prem_ee : ' || l_pre_tax.hi_prem_ee);
1364: hr_utility.trace('hi_prem_er : ' || l_pre_tax.hi_prem_er);
1365: hr_utility.trace('wp_organization_id : ' || l_pre_tax.wp_organization_id);
1358: hr_utility.trace('salary_category : ' || l_pre_tax.salary_category);
1359: hr_utility.trace('taxable_sal_amt : ' || l_pre_tax.taxable_sal_amt);
1360: hr_utility.trace('taxable_mat_amt : ' || l_pre_tax.taxable_mat_amt);
1361: hr_utility.trace('previous_taxable_amt : ' || l_pre_tax.previous_taxable_amt);
1362: hr_utility.trace('hi_organization_id : ' || l_pre_tax.hi_organization_id);
1363: hr_utility.trace('hi_prem_ee : ' || l_pre_tax.hi_prem_ee);
1364: hr_utility.trace('hi_prem_er : ' || l_pre_tax.hi_prem_er);
1365: hr_utility.trace('wp_organization_id : ' || l_pre_tax.wp_organization_id);
1366: hr_utility.trace('wp_prem_ee : ' || l_pre_tax.wp_prem_ee);
1359: hr_utility.trace('taxable_sal_amt : ' || l_pre_tax.taxable_sal_amt);
1360: hr_utility.trace('taxable_mat_amt : ' || l_pre_tax.taxable_mat_amt);
1361: hr_utility.trace('previous_taxable_amt : ' || l_pre_tax.previous_taxable_amt);
1362: hr_utility.trace('hi_organization_id : ' || l_pre_tax.hi_organization_id);
1363: hr_utility.trace('hi_prem_ee : ' || l_pre_tax.hi_prem_ee);
1364: hr_utility.trace('hi_prem_er : ' || l_pre_tax.hi_prem_er);
1365: hr_utility.trace('wp_organization_id : ' || l_pre_tax.wp_organization_id);
1366: hr_utility.trace('wp_prem_ee : ' || l_pre_tax.wp_prem_ee);
1367: hr_utility.trace('wp_prem_er : ' || l_pre_tax.wp_prem_er);
1360: hr_utility.trace('taxable_mat_amt : ' || l_pre_tax.taxable_mat_amt);
1361: hr_utility.trace('previous_taxable_amt : ' || l_pre_tax.previous_taxable_amt);
1362: hr_utility.trace('hi_organization_id : ' || l_pre_tax.hi_organization_id);
1363: hr_utility.trace('hi_prem_ee : ' || l_pre_tax.hi_prem_ee);
1364: hr_utility.trace('hi_prem_er : ' || l_pre_tax.hi_prem_er);
1365: hr_utility.trace('wp_organization_id : ' || l_pre_tax.wp_organization_id);
1366: hr_utility.trace('wp_prem_ee : ' || l_pre_tax.wp_prem_ee);
1367: hr_utility.trace('wp_prem_er : ' || l_pre_tax.wp_prem_er);
1368: hr_utility.trace('wpf_organization_id : ' || l_pre_tax.wpf_organization_id);
1361: hr_utility.trace('previous_taxable_amt : ' || l_pre_tax.previous_taxable_amt);
1362: hr_utility.trace('hi_organization_id : ' || l_pre_tax.hi_organization_id);
1363: hr_utility.trace('hi_prem_ee : ' || l_pre_tax.hi_prem_ee);
1364: hr_utility.trace('hi_prem_er : ' || l_pre_tax.hi_prem_er);
1365: hr_utility.trace('wp_organization_id : ' || l_pre_tax.wp_organization_id);
1366: hr_utility.trace('wp_prem_ee : ' || l_pre_tax.wp_prem_ee);
1367: hr_utility.trace('wp_prem_er : ' || l_pre_tax.wp_prem_er);
1368: hr_utility.trace('wpf_organization_id : ' || l_pre_tax.wpf_organization_id);
1369: hr_utility.trace('wpf_prem_ee : ' || l_pre_tax.wpf_prem_ee);
1362: hr_utility.trace('hi_organization_id : ' || l_pre_tax.hi_organization_id);
1363: hr_utility.trace('hi_prem_ee : ' || l_pre_tax.hi_prem_ee);
1364: hr_utility.trace('hi_prem_er : ' || l_pre_tax.hi_prem_er);
1365: hr_utility.trace('wp_organization_id : ' || l_pre_tax.wp_organization_id);
1366: hr_utility.trace('wp_prem_ee : ' || l_pre_tax.wp_prem_ee);
1367: hr_utility.trace('wp_prem_er : ' || l_pre_tax.wp_prem_er);
1368: hr_utility.trace('wpf_organization_id : ' || l_pre_tax.wpf_organization_id);
1369: hr_utility.trace('wpf_prem_ee : ' || l_pre_tax.wpf_prem_ee);
1370: hr_utility.trace('wpf_prem_er : ' || l_pre_tax.wpf_prem_er);
1363: hr_utility.trace('hi_prem_ee : ' || l_pre_tax.hi_prem_ee);
1364: hr_utility.trace('hi_prem_er : ' || l_pre_tax.hi_prem_er);
1365: hr_utility.trace('wp_organization_id : ' || l_pre_tax.wp_organization_id);
1366: hr_utility.trace('wp_prem_ee : ' || l_pre_tax.wp_prem_ee);
1367: hr_utility.trace('wp_prem_er : ' || l_pre_tax.wp_prem_er);
1368: hr_utility.trace('wpf_organization_id : ' || l_pre_tax.wpf_organization_id);
1369: hr_utility.trace('wpf_prem_ee : ' || l_pre_tax.wpf_prem_ee);
1370: hr_utility.trace('wpf_prem_er : ' || l_pre_tax.wpf_prem_er);
1371: hr_utility.trace('ui_organization_id : ' || l_pre_tax.ui_organization_id);
1364: hr_utility.trace('hi_prem_er : ' || l_pre_tax.hi_prem_er);
1365: hr_utility.trace('wp_organization_id : ' || l_pre_tax.wp_organization_id);
1366: hr_utility.trace('wp_prem_ee : ' || l_pre_tax.wp_prem_ee);
1367: hr_utility.trace('wp_prem_er : ' || l_pre_tax.wp_prem_er);
1368: hr_utility.trace('wpf_organization_id : ' || l_pre_tax.wpf_organization_id);
1369: hr_utility.trace('wpf_prem_ee : ' || l_pre_tax.wpf_prem_ee);
1370: hr_utility.trace('wpf_prem_er : ' || l_pre_tax.wpf_prem_er);
1371: hr_utility.trace('ui_organization_id : ' || l_pre_tax.ui_organization_id);
1372: hr_utility.trace('ui_category : ' || l_pre_tax.ui_category);
1365: hr_utility.trace('wp_organization_id : ' || l_pre_tax.wp_organization_id);
1366: hr_utility.trace('wp_prem_ee : ' || l_pre_tax.wp_prem_ee);
1367: hr_utility.trace('wp_prem_er : ' || l_pre_tax.wp_prem_er);
1368: hr_utility.trace('wpf_organization_id : ' || l_pre_tax.wpf_organization_id);
1369: hr_utility.trace('wpf_prem_ee : ' || l_pre_tax.wpf_prem_ee);
1370: hr_utility.trace('wpf_prem_er : ' || l_pre_tax.wpf_prem_er);
1371: hr_utility.trace('ui_organization_id : ' || l_pre_tax.ui_organization_id);
1372: hr_utility.trace('ui_category : ' || l_pre_tax.ui_category);
1373: hr_utility.trace('ui_prem_ee : ' || l_pre_tax.ui_prem_ee);
1366: hr_utility.trace('wp_prem_ee : ' || l_pre_tax.wp_prem_ee);
1367: hr_utility.trace('wp_prem_er : ' || l_pre_tax.wp_prem_er);
1368: hr_utility.trace('wpf_organization_id : ' || l_pre_tax.wpf_organization_id);
1369: hr_utility.trace('wpf_prem_ee : ' || l_pre_tax.wpf_prem_ee);
1370: hr_utility.trace('wpf_prem_er : ' || l_pre_tax.wpf_prem_er);
1371: hr_utility.trace('ui_organization_id : ' || l_pre_tax.ui_organization_id);
1372: hr_utility.trace('ui_category : ' || l_pre_tax.ui_category);
1373: hr_utility.trace('ui_prem_ee : ' || l_pre_tax.ui_prem_ee);
1374: hr_utility.trace('ui_sal_amt : ' || l_pre_tax.ui_sal_amt);
1367: hr_utility.trace('wp_prem_er : ' || l_pre_tax.wp_prem_er);
1368: hr_utility.trace('wpf_organization_id : ' || l_pre_tax.wpf_organization_id);
1369: hr_utility.trace('wpf_prem_ee : ' || l_pre_tax.wpf_prem_ee);
1370: hr_utility.trace('wpf_prem_er : ' || l_pre_tax.wpf_prem_er);
1371: hr_utility.trace('ui_organization_id : ' || l_pre_tax.ui_organization_id);
1372: hr_utility.trace('ui_category : ' || l_pre_tax.ui_category);
1373: hr_utility.trace('ui_prem_ee : ' || l_pre_tax.ui_prem_ee);
1374: hr_utility.trace('ui_sal_amt : ' || l_pre_tax.ui_sal_amt);
1375: hr_utility.trace('wai_organization_id : ' || l_pre_tax.wai_organization_id);
1368: hr_utility.trace('wpf_organization_id : ' || l_pre_tax.wpf_organization_id);
1369: hr_utility.trace('wpf_prem_ee : ' || l_pre_tax.wpf_prem_ee);
1370: hr_utility.trace('wpf_prem_er : ' || l_pre_tax.wpf_prem_er);
1371: hr_utility.trace('ui_organization_id : ' || l_pre_tax.ui_organization_id);
1372: hr_utility.trace('ui_category : ' || l_pre_tax.ui_category);
1373: hr_utility.trace('ui_prem_ee : ' || l_pre_tax.ui_prem_ee);
1374: hr_utility.trace('ui_sal_amt : ' || l_pre_tax.ui_sal_amt);
1375: hr_utility.trace('wai_organization_id : ' || l_pre_tax.wai_organization_id);
1376: hr_utility.trace('wai_category : ' || l_pre_tax.wai_category);
1369: hr_utility.trace('wpf_prem_ee : ' || l_pre_tax.wpf_prem_ee);
1370: hr_utility.trace('wpf_prem_er : ' || l_pre_tax.wpf_prem_er);
1371: hr_utility.trace('ui_organization_id : ' || l_pre_tax.ui_organization_id);
1372: hr_utility.trace('ui_category : ' || l_pre_tax.ui_category);
1373: hr_utility.trace('ui_prem_ee : ' || l_pre_tax.ui_prem_ee);
1374: hr_utility.trace('ui_sal_amt : ' || l_pre_tax.ui_sal_amt);
1375: hr_utility.trace('wai_organization_id : ' || l_pre_tax.wai_organization_id);
1376: hr_utility.trace('wai_category : ' || l_pre_tax.wai_category);
1377: hr_utility.trace('wai_sal_amt : ' || l_pre_tax.wai_sal_amt);
1370: hr_utility.trace('wpf_prem_er : ' || l_pre_tax.wpf_prem_er);
1371: hr_utility.trace('ui_organization_id : ' || l_pre_tax.ui_organization_id);
1372: hr_utility.trace('ui_category : ' || l_pre_tax.ui_category);
1373: hr_utility.trace('ui_prem_ee : ' || l_pre_tax.ui_prem_ee);
1374: hr_utility.trace('ui_sal_amt : ' || l_pre_tax.ui_sal_amt);
1375: hr_utility.trace('wai_organization_id : ' || l_pre_tax.wai_organization_id);
1376: hr_utility.trace('wai_category : ' || l_pre_tax.wai_category);
1377: hr_utility.trace('wai_sal_amt : ' || l_pre_tax.wai_sal_amt);
1378: hr_utility.trace('itax_organization_id : ' || l_pre_tax.itax_organization_id);
1371: hr_utility.trace('ui_organization_id : ' || l_pre_tax.ui_organization_id);
1372: hr_utility.trace('ui_category : ' || l_pre_tax.ui_category);
1373: hr_utility.trace('ui_prem_ee : ' || l_pre_tax.ui_prem_ee);
1374: hr_utility.trace('ui_sal_amt : ' || l_pre_tax.ui_sal_amt);
1375: hr_utility.trace('wai_organization_id : ' || l_pre_tax.wai_organization_id);
1376: hr_utility.trace('wai_category : ' || l_pre_tax.wai_category);
1377: hr_utility.trace('wai_sal_amt : ' || l_pre_tax.wai_sal_amt);
1378: hr_utility.trace('itax_organization_id : ' || l_pre_tax.itax_organization_id);
1379: hr_utility.trace('itax_category : ' || l_pre_tax.itax_category);
1372: hr_utility.trace('ui_category : ' || l_pre_tax.ui_category);
1373: hr_utility.trace('ui_prem_ee : ' || l_pre_tax.ui_prem_ee);
1374: hr_utility.trace('ui_sal_amt : ' || l_pre_tax.ui_sal_amt);
1375: hr_utility.trace('wai_organization_id : ' || l_pre_tax.wai_organization_id);
1376: hr_utility.trace('wai_category : ' || l_pre_tax.wai_category);
1377: hr_utility.trace('wai_sal_amt : ' || l_pre_tax.wai_sal_amt);
1378: hr_utility.trace('itax_organization_id : ' || l_pre_tax.itax_organization_id);
1379: hr_utility.trace('itax_category : ' || l_pre_tax.itax_category);
1380: hr_utility.trace('itax_yea_category : ' || l_pre_tax.itax_yea_category);
1373: hr_utility.trace('ui_prem_ee : ' || l_pre_tax.ui_prem_ee);
1374: hr_utility.trace('ui_sal_amt : ' || l_pre_tax.ui_sal_amt);
1375: hr_utility.trace('wai_organization_id : ' || l_pre_tax.wai_organization_id);
1376: hr_utility.trace('wai_category : ' || l_pre_tax.wai_category);
1377: hr_utility.trace('wai_sal_amt : ' || l_pre_tax.wai_sal_amt);
1378: hr_utility.trace('itax_organization_id : ' || l_pre_tax.itax_organization_id);
1379: hr_utility.trace('itax_category : ' || l_pre_tax.itax_category);
1380: hr_utility.trace('itax_yea_category : ' || l_pre_tax.itax_yea_category);
1381: hr_utility.trace('itax : ' || l_pre_tax.itax);
1374: hr_utility.trace('ui_sal_amt : ' || l_pre_tax.ui_sal_amt);
1375: hr_utility.trace('wai_organization_id : ' || l_pre_tax.wai_organization_id);
1376: hr_utility.trace('wai_category : ' || l_pre_tax.wai_category);
1377: hr_utility.trace('wai_sal_amt : ' || l_pre_tax.wai_sal_amt);
1378: hr_utility.trace('itax_organization_id : ' || l_pre_tax.itax_organization_id);
1379: hr_utility.trace('itax_category : ' || l_pre_tax.itax_category);
1380: hr_utility.trace('itax_yea_category : ' || l_pre_tax.itax_yea_category);
1381: hr_utility.trace('itax : ' || l_pre_tax.itax);
1382: hr_utility.trace('itax_adjustment : ' || l_pre_tax.itax_adjustment);
1375: hr_utility.trace('wai_organization_id : ' || l_pre_tax.wai_organization_id);
1376: hr_utility.trace('wai_category : ' || l_pre_tax.wai_category);
1377: hr_utility.trace('wai_sal_amt : ' || l_pre_tax.wai_sal_amt);
1378: hr_utility.trace('itax_organization_id : ' || l_pre_tax.itax_organization_id);
1379: hr_utility.trace('itax_category : ' || l_pre_tax.itax_category);
1380: hr_utility.trace('itax_yea_category : ' || l_pre_tax.itax_yea_category);
1381: hr_utility.trace('itax : ' || l_pre_tax.itax);
1382: hr_utility.trace('itax_adjustment : ' || l_pre_tax.itax_adjustment);
1383: hr_utility.trace('previous_itax : ' || l_pre_tax.previous_itax);
1376: hr_utility.trace('wai_category : ' || l_pre_tax.wai_category);
1377: hr_utility.trace('wai_sal_amt : ' || l_pre_tax.wai_sal_amt);
1378: hr_utility.trace('itax_organization_id : ' || l_pre_tax.itax_organization_id);
1379: hr_utility.trace('itax_category : ' || l_pre_tax.itax_category);
1380: hr_utility.trace('itax_yea_category : ' || l_pre_tax.itax_yea_category);
1381: hr_utility.trace('itax : ' || l_pre_tax.itax);
1382: hr_utility.trace('itax_adjustment : ' || l_pre_tax.itax_adjustment);
1383: hr_utility.trace('previous_itax : ' || l_pre_tax.previous_itax);
1384: hr_utility.trace('ltax_organization_id : ' || l_pre_tax.ltax_organization_id);
1377: hr_utility.trace('wai_sal_amt : ' || l_pre_tax.wai_sal_amt);
1378: hr_utility.trace('itax_organization_id : ' || l_pre_tax.itax_organization_id);
1379: hr_utility.trace('itax_category : ' || l_pre_tax.itax_category);
1380: hr_utility.trace('itax_yea_category : ' || l_pre_tax.itax_yea_category);
1381: hr_utility.trace('itax : ' || l_pre_tax.itax);
1382: hr_utility.trace('itax_adjustment : ' || l_pre_tax.itax_adjustment);
1383: hr_utility.trace('previous_itax : ' || l_pre_tax.previous_itax);
1384: hr_utility.trace('ltax_organization_id : ' || l_pre_tax.ltax_organization_id);
1385: hr_utility.trace('ltax_district_code : ' || l_pre_tax.ltax_district_code);
1378: hr_utility.trace('itax_organization_id : ' || l_pre_tax.itax_organization_id);
1379: hr_utility.trace('itax_category : ' || l_pre_tax.itax_category);
1380: hr_utility.trace('itax_yea_category : ' || l_pre_tax.itax_yea_category);
1381: hr_utility.trace('itax : ' || l_pre_tax.itax);
1382: hr_utility.trace('itax_adjustment : ' || l_pre_tax.itax_adjustment);
1383: hr_utility.trace('previous_itax : ' || l_pre_tax.previous_itax);
1384: hr_utility.trace('ltax_organization_id : ' || l_pre_tax.ltax_organization_id);
1385: hr_utility.trace('ltax_district_code : ' || l_pre_tax.ltax_district_code);
1386: hr_utility.trace('ltax_swot_no : ' || l_pre_tax.ltax_swot_no);
1379: hr_utility.trace('itax_category : ' || l_pre_tax.itax_category);
1380: hr_utility.trace('itax_yea_category : ' || l_pre_tax.itax_yea_category);
1381: hr_utility.trace('itax : ' || l_pre_tax.itax);
1382: hr_utility.trace('itax_adjustment : ' || l_pre_tax.itax_adjustment);
1383: hr_utility.trace('previous_itax : ' || l_pre_tax.previous_itax);
1384: hr_utility.trace('ltax_organization_id : ' || l_pre_tax.ltax_organization_id);
1385: hr_utility.trace('ltax_district_code : ' || l_pre_tax.ltax_district_code);
1386: hr_utility.trace('ltax_swot_no : ' || l_pre_tax.ltax_swot_no);
1387: hr_utility.trace('ltax : ' || l_pre_tax.ltax);
1380: hr_utility.trace('itax_yea_category : ' || l_pre_tax.itax_yea_category);
1381: hr_utility.trace('itax : ' || l_pre_tax.itax);
1382: hr_utility.trace('itax_adjustment : ' || l_pre_tax.itax_adjustment);
1383: hr_utility.trace('previous_itax : ' || l_pre_tax.previous_itax);
1384: hr_utility.trace('ltax_organization_id : ' || l_pre_tax.ltax_organization_id);
1385: hr_utility.trace('ltax_district_code : ' || l_pre_tax.ltax_district_code);
1386: hr_utility.trace('ltax_swot_no : ' || l_pre_tax.ltax_swot_no);
1387: hr_utility.trace('ltax : ' || l_pre_tax.ltax);
1388: hr_utility.trace('ltax_lumpsum : ' || l_pre_tax.ltax_lumpsum);
1381: hr_utility.trace('itax : ' || l_pre_tax.itax);
1382: hr_utility.trace('itax_adjustment : ' || l_pre_tax.itax_adjustment);
1383: hr_utility.trace('previous_itax : ' || l_pre_tax.previous_itax);
1384: hr_utility.trace('ltax_organization_id : ' || l_pre_tax.ltax_organization_id);
1385: hr_utility.trace('ltax_district_code : ' || l_pre_tax.ltax_district_code);
1386: hr_utility.trace('ltax_swot_no : ' || l_pre_tax.ltax_swot_no);
1387: hr_utility.trace('ltax : ' || l_pre_tax.ltax);
1388: hr_utility.trace('ltax_lumpsum : ' || l_pre_tax.ltax_lumpsum);
1389: hr_utility.trace('sp_ltax : ' || l_pre_tax.sp_ltax);
1382: hr_utility.trace('itax_adjustment : ' || l_pre_tax.itax_adjustment);
1383: hr_utility.trace('previous_itax : ' || l_pre_tax.previous_itax);
1384: hr_utility.trace('ltax_organization_id : ' || l_pre_tax.ltax_organization_id);
1385: hr_utility.trace('ltax_district_code : ' || l_pre_tax.ltax_district_code);
1386: hr_utility.trace('ltax_swot_no : ' || l_pre_tax.ltax_swot_no);
1387: hr_utility.trace('ltax : ' || l_pre_tax.ltax);
1388: hr_utility.trace('ltax_lumpsum : ' || l_pre_tax.ltax_lumpsum);
1389: hr_utility.trace('sp_ltax : ' || l_pre_tax.sp_ltax);
1390: hr_utility.trace('sp_ltax_income : ' || l_pre_tax.sp_ltax_income);
1383: hr_utility.trace('previous_itax : ' || l_pre_tax.previous_itax);
1384: hr_utility.trace('ltax_organization_id : ' || l_pre_tax.ltax_organization_id);
1385: hr_utility.trace('ltax_district_code : ' || l_pre_tax.ltax_district_code);
1386: hr_utility.trace('ltax_swot_no : ' || l_pre_tax.ltax_swot_no);
1387: hr_utility.trace('ltax : ' || l_pre_tax.ltax);
1388: hr_utility.trace('ltax_lumpsum : ' || l_pre_tax.ltax_lumpsum);
1389: hr_utility.trace('sp_ltax : ' || l_pre_tax.sp_ltax);
1390: hr_utility.trace('sp_ltax_income : ' || l_pre_tax.sp_ltax_income);
1391: hr_utility.trace('sp_ltax_shi : ' || l_pre_tax.sp_ltax_shi);
1384: hr_utility.trace('ltax_organization_id : ' || l_pre_tax.ltax_organization_id);
1385: hr_utility.trace('ltax_district_code : ' || l_pre_tax.ltax_district_code);
1386: hr_utility.trace('ltax_swot_no : ' || l_pre_tax.ltax_swot_no);
1387: hr_utility.trace('ltax : ' || l_pre_tax.ltax);
1388: hr_utility.trace('ltax_lumpsum : ' || l_pre_tax.ltax_lumpsum);
1389: hr_utility.trace('sp_ltax : ' || l_pre_tax.sp_ltax);
1390: hr_utility.trace('sp_ltax_income : ' || l_pre_tax.sp_ltax_income);
1391: hr_utility.trace('sp_ltax_shi : ' || l_pre_tax.sp_ltax_shi);
1392: hr_utility.trace('sp_ltax_to : ' || l_pre_tax.sp_ltax_to);
1385: hr_utility.trace('ltax_district_code : ' || l_pre_tax.ltax_district_code);
1386: hr_utility.trace('ltax_swot_no : ' || l_pre_tax.ltax_swot_no);
1387: hr_utility.trace('ltax : ' || l_pre_tax.ltax);
1388: hr_utility.trace('ltax_lumpsum : ' || l_pre_tax.ltax_lumpsum);
1389: hr_utility.trace('sp_ltax : ' || l_pre_tax.sp_ltax);
1390: hr_utility.trace('sp_ltax_income : ' || l_pre_tax.sp_ltax_income);
1391: hr_utility.trace('sp_ltax_shi : ' || l_pre_tax.sp_ltax_shi);
1392: hr_utility.trace('sp_ltax_to : ' || l_pre_tax.sp_ltax_to);
1393: hr_utility.trace('ci_prem_ee : ' || l_pre_tax.ci_prem_ee);
1386: hr_utility.trace('ltax_swot_no : ' || l_pre_tax.ltax_swot_no);
1387: hr_utility.trace('ltax : ' || l_pre_tax.ltax);
1388: hr_utility.trace('ltax_lumpsum : ' || l_pre_tax.ltax_lumpsum);
1389: hr_utility.trace('sp_ltax : ' || l_pre_tax.sp_ltax);
1390: hr_utility.trace('sp_ltax_income : ' || l_pre_tax.sp_ltax_income);
1391: hr_utility.trace('sp_ltax_shi : ' || l_pre_tax.sp_ltax_shi);
1392: hr_utility.trace('sp_ltax_to : ' || l_pre_tax.sp_ltax_to);
1393: hr_utility.trace('ci_prem_ee : ' || l_pre_tax.ci_prem_ee);
1394: hr_utility.trace('ci_prem_er : ' || l_pre_tax.ci_prem_er);
1387: hr_utility.trace('ltax : ' || l_pre_tax.ltax);
1388: hr_utility.trace('ltax_lumpsum : ' || l_pre_tax.ltax_lumpsum);
1389: hr_utility.trace('sp_ltax : ' || l_pre_tax.sp_ltax);
1390: hr_utility.trace('sp_ltax_income : ' || l_pre_tax.sp_ltax_income);
1391: hr_utility.trace('sp_ltax_shi : ' || l_pre_tax.sp_ltax_shi);
1392: hr_utility.trace('sp_ltax_to : ' || l_pre_tax.sp_ltax_to);
1393: hr_utility.trace('ci_prem_ee : ' || l_pre_tax.ci_prem_ee);
1394: hr_utility.trace('ci_prem_er : ' || l_pre_tax.ci_prem_er);
1395: hr_utility.trace('mutual_aid : ' || l_pre_tax.mutual_aid);
1388: hr_utility.trace('ltax_lumpsum : ' || l_pre_tax.ltax_lumpsum);
1389: hr_utility.trace('sp_ltax : ' || l_pre_tax.sp_ltax);
1390: hr_utility.trace('sp_ltax_income : ' || l_pre_tax.sp_ltax_income);
1391: hr_utility.trace('sp_ltax_shi : ' || l_pre_tax.sp_ltax_shi);
1392: hr_utility.trace('sp_ltax_to : ' || l_pre_tax.sp_ltax_to);
1393: hr_utility.trace('ci_prem_ee : ' || l_pre_tax.ci_prem_ee);
1394: hr_utility.trace('ci_prem_er : ' || l_pre_tax.ci_prem_er);
1395: hr_utility.trace('mutual_aid : ' || l_pre_tax.mutual_aid);
1396: hr_utility.trace('disaster_tax_reduction : ' || l_pre_tax.disaster_tax_reduction);
1389: hr_utility.trace('sp_ltax : ' || l_pre_tax.sp_ltax);
1390: hr_utility.trace('sp_ltax_income : ' || l_pre_tax.sp_ltax_income);
1391: hr_utility.trace('sp_ltax_shi : ' || l_pre_tax.sp_ltax_shi);
1392: hr_utility.trace('sp_ltax_to : ' || l_pre_tax.sp_ltax_to);
1393: hr_utility.trace('ci_prem_ee : ' || l_pre_tax.ci_prem_ee);
1394: hr_utility.trace('ci_prem_er : ' || l_pre_tax.ci_prem_er);
1395: hr_utility.trace('mutual_aid : ' || l_pre_tax.mutual_aid);
1396: hr_utility.trace('disaster_tax_reduction : ' || l_pre_tax.disaster_tax_reduction);
1397: hr_utility.trace('sp_ltax_district_code : ' || l_pre_tax.sp_ltax_district_code);
1390: hr_utility.trace('sp_ltax_income : ' || l_pre_tax.sp_ltax_income);
1391: hr_utility.trace('sp_ltax_shi : ' || l_pre_tax.sp_ltax_shi);
1392: hr_utility.trace('sp_ltax_to : ' || l_pre_tax.sp_ltax_to);
1393: hr_utility.trace('ci_prem_ee : ' || l_pre_tax.ci_prem_ee);
1394: hr_utility.trace('ci_prem_er : ' || l_pre_tax.ci_prem_er);
1395: hr_utility.trace('mutual_aid : ' || l_pre_tax.mutual_aid);
1396: hr_utility.trace('disaster_tax_reduction : ' || l_pre_tax.disaster_tax_reduction);
1397: hr_utility.trace('sp_ltax_district_code : ' || l_pre_tax.sp_ltax_district_code);
1398: --
1391: hr_utility.trace('sp_ltax_shi : ' || l_pre_tax.sp_ltax_shi);
1392: hr_utility.trace('sp_ltax_to : ' || l_pre_tax.sp_ltax_to);
1393: hr_utility.trace('ci_prem_ee : ' || l_pre_tax.ci_prem_ee);
1394: hr_utility.trace('ci_prem_er : ' || l_pre_tax.ci_prem_er);
1395: hr_utility.trace('mutual_aid : ' || l_pre_tax.mutual_aid);
1396: hr_utility.trace('disaster_tax_reduction : ' || l_pre_tax.disaster_tax_reduction);
1397: hr_utility.trace('sp_ltax_district_code : ' || l_pre_tax.sp_ltax_district_code);
1398: --
1399: pay_action_information_api.create_action_information
1392: hr_utility.trace('sp_ltax_to : ' || l_pre_tax.sp_ltax_to);
1393: hr_utility.trace('ci_prem_ee : ' || l_pre_tax.ci_prem_ee);
1394: hr_utility.trace('ci_prem_er : ' || l_pre_tax.ci_prem_er);
1395: hr_utility.trace('mutual_aid : ' || l_pre_tax.mutual_aid);
1396: hr_utility.trace('disaster_tax_reduction : ' || l_pre_tax.disaster_tax_reduction);
1397: hr_utility.trace('sp_ltax_district_code : ' || l_pre_tax.sp_ltax_district_code);
1398: --
1399: pay_action_information_api.create_action_information
1400: (
1393: hr_utility.trace('ci_prem_ee : ' || l_pre_tax.ci_prem_ee);
1394: hr_utility.trace('ci_prem_er : ' || l_pre_tax.ci_prem_er);
1395: hr_utility.trace('mutual_aid : ' || l_pre_tax.mutual_aid);
1396: hr_utility.trace('disaster_tax_reduction : ' || l_pre_tax.disaster_tax_reduction);
1397: hr_utility.trace('sp_ltax_district_code : ' || l_pre_tax.sp_ltax_district_code);
1398: --
1399: pay_action_information_api.create_action_information
1400: (
1401: p_action_information_id => l_action_info_id1
1466: );
1467:
1468: end loop;
1469: --
1470: hr_utility.set_location('Leaving: ' || c_proc, 100);
1471: --
1472: exception
1473: when app_exception.application_exception then
1474: app_exception.raise_exception;
1498: c_proc constant varchar2(61) := c_package || 'validate_yea_national_pens';
1499: --
1500: begin
1501: --
1502: hr_utility.set_location('Entering: ' || c_proc, 10);
1503: --
1504: if g_element_type_ids.count = 0 then
1505: --
1506: get_element_type_id('YEA_INS_PREM_SPOUSE_SP_EXM_INFO', g_element_type_ids);
1518: else
1519: p_valid_upgrade := 'FALSE';
1520: end if;
1521: --
1522: hr_utility.trace(p_valid_upgrade);
1523: --
1524: hr_utility.set_location('Leaving: ' || c_proc, 100);
1525: --
1526: end validate_yea_national_pens;
1520: end if;
1521: --
1522: hr_utility.trace(p_valid_upgrade);
1523: --
1524: hr_utility.set_location('Leaving: ' || c_proc, 100);
1525: --
1526: end validate_yea_national_pens;
1527: -- |-------------------------------------------------------------------|
1528: -- |------------------< qualify_yea_national_pens >--------------------|
1534: is
1535: c_proc constant varchar2(61) := c_package || 'qualify_yea_national_pens';
1536: begin
1537: --
1538: hr_utility.set_location('Entering: ' || c_proc, 10);
1539: --
1540: if entries_or_results_exist(p_assignment_id => p_assignment_id) then
1541: p_qualifier := 'Y';
1542: else
1542: else
1543: p_qualifier := 'N';
1544: end if;
1545: --
1546: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
1547: hr_utility.set_location('Leaving: ' || c_proc, 100);
1548: --
1549: end qualify_yea_national_pens;
1550: -- |-------------------------------------------------------------------|
1543: p_qualifier := 'N';
1544: end if;
1545: --
1546: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
1547: hr_utility.set_location('Leaving: ' || c_proc, 100);
1548: --
1549: end qualify_yea_national_pens;
1550: -- |-------------------------------------------------------------------|
1551: -- |-------------------< upgrade_yea_national_pens >-------------------|
1555: is
1556: c_proc constant varchar2(61) := c_package || 'upgrade_yea_national_pens';
1557: begin
1558: --
1559: hr_utility.set_location('Entering: ' || c_proc, 10);
1560: --
1561: if g_element_type_ids.count = 0 then
1562: --
1563: get_element_type_id('YEA_INS_PREM_SPOUSE_SP_EXM_INFO', g_element_type_ids);
1569: sync_entries_and_results(p_assignment_id, g_element_type_ids(i));
1570: --
1571: end loop;
1572: --
1573: hr_utility.set_location('Leaving: ' || c_proc, 100);
1574: --
1575: end upgrade_yea_national_pens;
1576: -- |-------------------------------------------------------------------|
1577: -- |--------------------< init_yea_earthquake_ins >--------------------|
1579: procedure init_yea_earthquake_ins
1580: is
1581: c_proc constant varchar2(61) := c_package || 'init_yea_earthquake_ins';
1582: begin
1583: hr_utility.set_location('Entering: ' || c_proc, 10);
1584: --
1585: if g_element_type_ids.count = 0 then
1586: hr_utility.trace('Not cached.');
1587: --
1582: begin
1583: hr_utility.set_location('Entering: ' || c_proc, 10);
1584: --
1585: if g_element_type_ids.count = 0 then
1586: hr_utility.trace('Not cached.');
1587: --
1588: get_element_type_id('YEA_INS_PREM_SPOUSE_SP_EXM_INFO', g_element_type_ids);
1589: get_element_type_id('YEA_INS_PREM_SPOUSE_SP_EXM_RSLT', g_element_type_ids);
1590: get_element_type_id('INI_YEA2', g_element_type_ids);
1591: get_element_type_id('YEA_INS_PREM_EXM_DECLARE_INFO', g_element_type_ids);
1592: end if;
1593: --
1594: for i in 1..g_element_type_ids.count loop
1595: hr_utility.trace(i || ': ' || g_element_type_ids(i));
1596: end loop;
1597: --
1598: hr_utility.set_location('Leaving: ' || c_proc, 100);
1599: end init_yea_earthquake_ins;
1594: for i in 1..g_element_type_ids.count loop
1595: hr_utility.trace(i || ': ' || g_element_type_ids(i));
1596: end loop;
1597: --
1598: hr_utility.set_location('Leaving: ' || c_proc, 100);
1599: end init_yea_earthquake_ins;
1600: -- |-------------------------------------------------------------------|
1601: -- |------------------< validate_yea_earthquake_ins >------------------|
1602: -- |-------------------------------------------------------------------|
1604: procedure validate_yea_earthquake_ins(p_valid_upgrade out nocopy varchar2)
1605: is
1606: c_proc constant varchar2(61) := c_package || 'validate_yea_earthquake_ins';
1607: begin
1608: hr_utility.set_location('Entering: ' || c_proc, 10);
1609: --
1610: -- At first, upgrade PAY_LINK_INPUT_VALUES_F.
1611: --
1612: init_yea_earthquake_ins;
1620: else
1621: p_valid_upgrade := 'FALSE';
1622: end if;
1623: --
1624: hr_utility.trace(p_valid_upgrade);
1625: hr_utility.set_location('Leaving: ' || c_proc, 100);
1626: end validate_yea_earthquake_ins;
1627: -- |-------------------------------------------------------------------|
1628: -- |------------------< qualify_yea_earthquake_ins >-------------------|
1621: p_valid_upgrade := 'FALSE';
1622: end if;
1623: --
1624: hr_utility.trace(p_valid_upgrade);
1625: hr_utility.set_location('Leaving: ' || c_proc, 100);
1626: end validate_yea_earthquake_ins;
1627: -- |-------------------------------------------------------------------|
1628: -- |------------------< qualify_yea_earthquake_ins >-------------------|
1629: -- |-------------------------------------------------------------------|
1633: p_qualifier out nocopy varchar2)
1634: is
1635: c_proc constant varchar2(61) := c_package || 'qualify_yea_earthquake_ins';
1636: begin
1637: hr_utility.set_location('Entering: ' || c_proc, 10);
1638: --
1639: if entries_or_results_exist(p_assignment_id => p_assignment_id) then
1640: p_qualifier := 'Y';
1641: else
1641: else
1642: p_qualifier := 'N';
1643: end if;
1644: --
1645: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
1646: hr_utility.set_location('Leaving: ' || c_proc, 100);
1647: end qualify_yea_earthquake_ins;
1648: -- |-------------------------------------------------------------------|
1649: -- |------------------< upgrade_yea_earthquake_ins >-------------------|
1642: p_qualifier := 'N';
1643: end if;
1644: --
1645: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
1646: hr_utility.set_location('Leaving: ' || c_proc, 100);
1647: end qualify_yea_earthquake_ins;
1648: -- |-------------------------------------------------------------------|
1649: -- |------------------< upgrade_yea_earthquake_ins >-------------------|
1650: -- |-------------------------------------------------------------------|
1651: procedure upgrade_yea_earthquake_ins(p_assignment_id in number)
1652: is
1653: c_proc constant varchar2(61) := c_package || 'upgrade_yea_earthquake_ins';
1654: begin
1655: hr_utility.set_location('Entering: ' || c_proc, 10);
1656: --
1657: init_yea_earthquake_ins;
1658: --
1659: for i in 1..g_element_type_ids.count loop
1659: for i in 1..g_element_type_ids.count loop
1660: sync_entries_and_results(p_assignment_id, g_element_type_ids(i));
1661: end loop;
1662: --
1663: hr_utility.set_location('Leaving: ' || c_proc, 100);
1664: end upgrade_yea_earthquake_ins;
1665: -- |-------------------------------------------------------------------|
1666: -- |---------------------< validate_itw_archive >----------------------|
1667: -- |-------------------------------------------------------------------|
1724: || l_separator || p_token_value || l_separator;
1725: end if;
1726: end concat_parameter;
1727: begin
1728: hr_utility.set_location('Entering: ' || c_proc, 10);
1729: --
1730: p_valid_upgrade := 'FALSE';
1731: --
1732: for l_pact in csr_pacts loop
1755: concat_parameter('PUBLICATION_START_DATE', fnd_date.date_to_canonical(l_publication_start_date));
1756: concat_parameter('PUBLICATION_END_DATE', fnd_date.date_to_canonical(l_publication_end_date));
1757: concat_parameter('UPGRADE_FLAG', 'Y');
1758: --
1759: hr_utility.trace('payroll_action_id: ' || l_pact.payroll_action_id);
1760: hr_utility.trace('legislative_parameters: ' || l_legislative_parameters);
1761: --
1762: update pay_payroll_actions
1763: set legislative_parameters = l_legislative_parameters
1756: concat_parameter('PUBLICATION_END_DATE', fnd_date.date_to_canonical(l_publication_end_date));
1757: concat_parameter('UPGRADE_FLAG', 'Y');
1758: --
1759: hr_utility.trace('payroll_action_id: ' || l_pact.payroll_action_id);
1760: hr_utility.trace('legislative_parameters: ' || l_legislative_parameters);
1761: --
1762: update pay_payroll_actions
1763: set legislative_parameters = l_legislative_parameters
1764: where payroll_action_id = l_pact.payroll_action_id;
1780: p_action_information_id => l_id,
1781: p_object_version_number => l_ovn);
1782: end loop;
1783: --
1784: hr_utility.trace(p_valid_upgrade);
1785: hr_utility.set_location('Leaving: ' || c_proc, 100);
1786: end validate_itw_archive;
1787: -- |-------------------------------------------------------------------|
1788: -- |----------------------< qualify_itw_archive >----------------------|
1781: p_object_version_number => l_ovn);
1782: end loop;
1783: --
1784: hr_utility.trace(p_valid_upgrade);
1785: hr_utility.set_location('Leaving: ' || c_proc, 100);
1786: end validate_itw_archive;
1787: -- |-------------------------------------------------------------------|
1788: -- |----------------------< qualify_itw_archive >----------------------|
1789: -- |-------------------------------------------------------------------|
1812: and ppa.report_qualifier = 'JP'
1813: and ppa.report_category = 'ARCHIVE'
1814: and pay_core_utils.get_parameter('UPGRADE_FLAG', ppa.legislative_parameters) = 'Y');
1815: begin
1816: hr_utility.set_location('Entering: ' || c_proc, 10);
1817: --
1818: open csr_upgrade_required;
1819: fetch csr_upgrade_required into p_qualifier;
1820: if csr_upgrade_required%notfound then
1821: p_qualifier := 'N';
1822: end if;
1823: close csr_upgrade_required;
1824: --
1825: hr_utility.trace(p_assignment_id || ': ' || p_qualifier);
1826: hr_utility.set_location('Leaving: ' || c_proc, 100);
1827: end qualify_itw_archive;
1828: -- |-------------------------------------------------------------------|
1829: -- |-----------------------< to_canonical_date >-----------------------|
1822: end if;
1823: close csr_upgrade_required;
1824: --
1825: hr_utility.trace(p_assignment_id || ': ' || p_qualifier);
1826: hr_utility.set_location('Leaving: ' || c_proc, 100);
1827: end qualify_itw_archive;
1828: -- |-------------------------------------------------------------------|
1829: -- |-----------------------< to_canonical_date >-----------------------|
1830: -- |-------------------------------------------------------------------|
1908: for update of
1909: person.action_information_id,
1910: other2.action_information_id nowait;
1911: begin
1912: hr_utility.set_location('Entering: ' || c_proc, 10);
1913: --
1914: for l_rec in csr loop
1915: --
1916: -- JP_ITAX_PERSON
2004: action_information30 = l_wtm_user_desc_kana2
2005: where rowid = l_rec.other2_rowid;
2006: end loop;
2007: --
2008: hr_utility.set_location('Leaving: ' || c_proc, 100);
2009: end upgrade_itw_archive;
2010: --
2011: -- -------------------------------------------------------------------------
2012: -- qualify_hi_smr_data
2026: --
2027: begin
2028: --
2029: if g_debug then
2030: hr_utility.set_location(l_proc,0);
2031: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2032: end if;
2033: --
2034: hr_jp_data_migration_pkg.init_def_hi_smr_data;
2027: begin
2028: --
2029: if g_debug then
2030: hr_utility.set_location(l_proc,0);
2031: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2032: end if;
2033: --
2034: hr_jp_data_migration_pkg.init_def_hi_smr_data;
2035: --
2033: --
2034: hr_jp_data_migration_pkg.init_def_hi_smr_data;
2035: --
2036: if g_debug then
2037: hr_utility.set_location(l_proc,10);
2038: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2039: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2040: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2041: end if;
2034: hr_jp_data_migration_pkg.init_def_hi_smr_data;
2035: --
2036: if g_debug then
2037: hr_utility.set_location(l_proc,10);
2038: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2039: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2040: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2041: end if;
2042: --
2035: --
2036: if g_debug then
2037: hr_utility.set_location(l_proc,10);
2038: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2039: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2040: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2041: end if;
2042: --
2043: if hr_jp_data_migration_pkg.g_skip_qualify = 'N' then
2036: if g_debug then
2037: hr_utility.set_location(l_proc,10);
2038: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2039: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2040: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2041: end if;
2042: --
2043: if hr_jp_data_migration_pkg.g_skip_qualify = 'N' then
2044: --
2042: --
2043: if hr_jp_data_migration_pkg.g_skip_qualify = 'N' then
2044: --
2045: if g_debug then
2046: hr_utility.set_location(l_proc,20);
2047: end if;
2048: --
2049: -- print header for each threads but it is ok because just log.
2050: hr_jp_data_migration_pkg.qualify_hi_smr_hd(
2050: hr_jp_data_migration_pkg.qualify_hi_smr_hd(
2051: p_assignment_id => p_assignment_id);
2052: --
2053: if g_debug then
2054: hr_utility.set_location(l_proc,30);
2055: end if;
2056: --
2057: l_ass_info := hr_jp_data_migration_pkg.get_ass_info(
2058: p_assignment_id => p_assignment_id,
2058: p_assignment_id => p_assignment_id,
2059: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2060: --
2061: if g_debug then
2062: hr_utility.set_location(l_proc,40);
2063: hr_utility.trace('l_ass_info.ass_id : '||to_char(l_ass_info.ass_id));
2064: end if;
2065: --
2066: hr_jp_data_migration_pkg.val_mig_smr_assact(
2059: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2060: --
2061: if g_debug then
2062: hr_utility.set_location(l_proc,40);
2063: hr_utility.trace('l_ass_info.ass_id : '||to_char(l_ass_info.ass_id));
2064: end if;
2065: --
2066: hr_jp_data_migration_pkg.val_mig_smr_assact(
2067: p_business_group_id => l_ass_info.bg_id,
2071: p_session_date => hr_jp_data_migration_pkg.g_mig_date,
2072: p_valid_delete => l_valid_delete);
2073: --
2074: if g_debug then
2075: hr_utility.set_location(l_proc,50);
2076: hr_utility.trace('l_valid_delete : '||l_valid_delete);
2077: end if;
2078: --
2079: p_qualifier := l_valid_delete;
2072: p_valid_delete => l_valid_delete);
2073: --
2074: if g_debug then
2075: hr_utility.set_location(l_proc,50);
2076: hr_utility.trace('l_valid_delete : '||l_valid_delete);
2077: end if;
2078: --
2079: p_qualifier := l_valid_delete;
2080: --
2089: --
2090: p_qualifier := 'Y';
2091: --
2092: if g_debug then
2093: hr_utility.set_location(l_proc,60);
2094: end if;
2095: --
2096: end if;
2097: --
2095: --
2096: end if;
2097: --
2098: if g_debug then
2099: hr_utility.trace('p_qualifier : '||p_qualifier);
2100: hr_utility.set_location(l_proc,1000);
2101: end if;
2102: --
2103: end qualify_hi_smr_data;
2096: end if;
2097: --
2098: if g_debug then
2099: hr_utility.trace('p_qualifier : '||p_qualifier);
2100: hr_utility.set_location(l_proc,1000);
2101: end if;
2102: --
2103: end qualify_hi_smr_data;
2104: --
2116: --
2117: begin
2118: --
2119: if g_debug then
2120: hr_utility.set_location(l_proc,0);
2121: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2122: end if;
2123: --
2124: -- need to reset for retry, qualify_obs_data is not called in retry process.
2117: begin
2118: --
2119: if g_debug then
2120: hr_utility.set_location(l_proc,0);
2121: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2122: end if;
2123: --
2124: -- need to reset for retry, qualify_obs_data is not called in retry process.
2125: hr_jp_data_migration_pkg.init_def_hi_smr_data;
2124: -- need to reset for retry, qualify_obs_data is not called in retry process.
2125: hr_jp_data_migration_pkg.init_def_hi_smr_data;
2126: --
2127: if g_debug then
2128: hr_utility.set_location(l_proc,10);
2129: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2130: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2131: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2132: end if;
2125: hr_jp_data_migration_pkg.init_def_hi_smr_data;
2126: --
2127: if g_debug then
2128: hr_utility.set_location(l_proc,10);
2129: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2130: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2131: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2132: end if;
2133: --
2126: --
2127: if g_debug then
2128: hr_utility.set_location(l_proc,10);
2129: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2130: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2131: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2132: end if;
2133: --
2134: -- print header for each threads but it is ok because just log.
2127: if g_debug then
2128: hr_utility.set_location(l_proc,10);
2129: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2130: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2131: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2132: end if;
2133: --
2134: -- print header for each threads but it is ok because just log.
2135: hr_jp_data_migration_pkg.migrate_hi_smr_hd(
2135: hr_jp_data_migration_pkg.migrate_hi_smr_hd(
2136: p_assignment_id => p_assignment_id);
2137: --
2138: if g_debug then
2139: hr_utility.set_location(l_proc,20);
2140: end if;
2141: --
2142: l_ass_info := hr_jp_data_migration_pkg.get_ass_info(
2143: p_assignment_id => p_assignment_id,
2143: p_assignment_id => p_assignment_id,
2144: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2145: --
2146: if g_debug then
2147: hr_utility.set_location(l_proc,30);
2148: hr_utility.trace('l_ass_info.ass_id : '||to_char(l_ass_info.ass_id));
2149: end if;
2150: --
2151: -- for api use
2144: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2145: --
2146: if g_debug then
2147: hr_utility.set_location(l_proc,30);
2148: hr_utility.trace('l_ass_info.ass_id : '||to_char(l_ass_info.ass_id));
2149: end if;
2150: --
2151: -- for api use
2152: hr_jp_data_migration_pkg.insert_session(
2167: -- automatically commit will be executed for each assignment in archive process.
2168: -- commit;
2169: --
2170: if g_debug then
2171: hr_utility.set_location(l_proc,1000);
2172: end if;
2173: --
2174: end migrate_hi_smr_data;
2175: --
2183: --
2184: begin
2185: --
2186: if g_debug then
2187: hr_utility.set_location('Entering: ' || c_proc, 10);
2188: end if;
2189: --
2190: if g_element_type_ids.count = 0 then
2191: --
2189: --
2190: if g_element_type_ids.count = 0 then
2191: --
2192: if g_debug then
2193: hr_utility.trace('Not cached.');
2194: end if;
2195: --
2196: get_element_type_id('BON_HI_ADJ_INFO', g_element_type_ids);
2197: get_element_type_id('BON_HI_STD_BON', g_element_type_ids);
2200: --
2201: for i in 1..g_element_type_ids.count loop
2202: --
2203: if g_debug then
2204: hr_utility.trace(i || ': ' || g_element_type_ids(i));
2205: end if;
2206: --
2207: end loop;
2208: --
2206: --
2207: end loop;
2208: --
2209: if g_debug then
2210: hr_utility.set_location('Leaving: ' || c_proc, 100);
2211: end if;
2212: --
2213: end init_adj_ann_std_bon;
2214: --
2224: --
2225: begin
2226: --
2227: if g_debug then
2228: hr_utility.set_location('Entering: ' || c_proc, 10);
2229: end if;
2230: --
2231: init_adj_ann_std_bon;
2232: --
2242: p_valid_upgrade := 'FALSE';
2243: end if;
2244: --
2245: if g_debug then
2246: hr_utility.trace(p_valid_upgrade);
2247: hr_utility.set_location('Leaving: ' || c_proc, 100);
2248: end if;
2249: --
2250: end validate_adj_ann_std_bon;
2243: end if;
2244: --
2245: if g_debug then
2246: hr_utility.trace(p_valid_upgrade);
2247: hr_utility.set_location('Leaving: ' || c_proc, 100);
2248: end if;
2249: --
2250: end validate_adj_ann_std_bon;
2251: --
2260: c_proc constant varchar2(61) := c_package || 'qualify_adj_ann_std_bon';
2261: begin
2262: --
2263: if g_debug then
2264: hr_utility.set_location('Entering: ' || c_proc, 10);
2265: end if;
2266: --
2267: if entries_or_results_exist(p_assignment_id => p_assignment_id) then
2268: p_qualifier := 'Y';
2269: else
2270: p_qualifier := 'N';
2271: end if;
2272: --
2273: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
2274: hr_utility.set_location('Leaving: ' || c_proc, 100);
2275: --
2276: end qualify_adj_ann_std_bon;
2277: --
2270: p_qualifier := 'N';
2271: end if;
2272: --
2273: hr_utility.trace(p_assignment_id || ' : ' || p_qualifier);
2274: hr_utility.set_location('Leaving: ' || c_proc, 100);
2275: --
2276: end qualify_adj_ann_std_bon;
2277: --
2278: -- -------------------------------------------------------------------------
2284: c_proc constant varchar2(61) := c_package || 'upgrade_adj_ann_std_bon';
2285: begin
2286: --
2287: if g_debug then
2288: hr_utility.set_location('Entering: ' || c_proc, 10);
2289: end if;
2290: --
2291: init_adj_ann_std_bon;
2292: --
2294: sync_entries_and_results(p_assignment_id, g_element_type_ids(i));
2295: end loop;
2296: --
2297: if g_debug then
2298: hr_utility.set_location('Leaving: ' || c_proc, 100);
2299: end if;
2300: --
2301: end upgrade_adj_ann_std_bon;
2302: --
2503: argument10 => fnd_number.number_to_canonical(l_upgrade_def.upgrade_definition_id), -- ID
2504: argument11 => p_upgrade_short_name, -- Short Name
2505: argument12 => 'UPG_DEF_NAME=' || p_upgrade_short_name); -- Upgrade Name
2506: if l_request_id = 0 then
2507: hr_utility.raise_error;
2508: end if;
2509: else
2510: set_upgrade_completed;
2511: end if;
2519: end submit_request;
2520: */
2521: --
2522: --begin
2523: -- hr_utility.trace_on('F', 'TTAGAWA');
2524: end pay_jp_generic_upgrade_pkg;