[Home] [Help]
60: p_sql out nocopy varchar2 )
61: is
62: begin
63: if g_debug then
64: hr_utility.set_location(' Start of range_code',1);
65: end if;
66: --
67: p_sql := 'select distinct person_id ' ||
68: 'from per_people_f ppf, ' ||
71: 'and ppa.business_group_id = ppf.business_group_id ' ||
72: 'order by ppf.person_id';
73: --
74: if g_debug then
75: hr_utility.set_location('End of range_code',2);
76: end if;
77: end range_code;
78: ----------------------------------------------------------------------------
79: -- Bug 3435334 - Pre-processor process now introduced for this archive.
106: and pai.action_information_category = 'SG_IRAS_SETUP'
107: and action_information2 between p_start_person_id and p_end_person_id ;
108: begin
109: if g_debug then
110: hr_utility.set_location('Start of assignment_action_code',3);
111: end if;
112: --
113: open get_params( p_payroll_action_id );
114: fetch get_params into v_setup_action_id;
119: fetch process_assignments into v_assignment_id;
120: exit when process_assignments%notfound;
121: --
122: if g_debug then
123: hr_utility.set_location('Before calling hr_nonrun_asact.insact',4);
124: end if;
125: --
126: open next_action_id ;
127: fetch next_action_id into v_next_action_id;
133: p_chunk,
134: null );
135: --
136: if g_debug then
137: hr_utility.set_location('After calling hr_nonrun_asact.insact',4);
138: end if;
139: end loop;
140: --
141: close process_assignments;
140: --
141: close process_assignments;
142: --
143: if g_debug then
144: hr_utility.set_location('End of assignment_action_code',5);
145: end if;
146: end assignment_action_code;
147: ------------------------------------------------------------------------
148: -- Bug 3435334 - Pre-processor process now introduced for this archive.
173: and organization_id = pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters)
174: and payroll_action_id = p_payroll_action_id;
175: begin
176: if g_debug then
177: hr_utility.set_location('pysgirar: Start of initialization_code',6);
178: end if;
179: --
180: if g_business_group_id is null then
181: open get_params( p_payroll_action_id );
199: g_org_a8a_run := 'Y';
200: end if;
201:
202: if g_debug then
203: hr_utility.set_location('pysgirar: End of initialization_code',8);
204: end if;
205: end initialization_code;
206: --------------------------------------------------------------------------------
207: -- Bug: 3118540 - This function is called from SRS 'IR8S Ad Hoc Printed Archive'
279: group by paf.person_id;
280:
281: begin
282: if g_debug then
283: hr_utility.set_location('pysgirar: Start of Assignemnt Action Code Adhoc', 20);
284: end if;
285: --
286: open get_params(p_payroll_action_id);
287: fetch get_params into v_person_id,
318: end loop;
319: close process_assignments;
320: --
321: if g_debug then
322: hr_utility.set_location('pysgirar: End of Assignemnt Action Code Adhoc', 20);
323: end if;
324: exception
325: when others then
326: hr_utility.set_location('pysgirar: Error in assignment action code adhoc',10);
322: hr_utility.set_location('pysgirar: End of Assignemnt Action Code Adhoc', 20);
323: end if;
324: exception
325: when others then
326: hr_utility.set_location('pysgirar: Error in assignment action code adhoc',10);
327: raise;
328: end assignment_action_code_adhoc;
329: --------------------------------------------------------------------------------
330: -- Bug: 3118540 - This function is called from SRS 'IR8S Ad Hoc Printed Archive'
347: where payroll_action_id = c_payroll_action_id;
348: --
349: begin
350: if g_debug then
351: hr_utility.set_location('pysgirar: Start of initialization_code',6);
352: end if;
353: ------------------------------------------------------------------------
354: -- Cursor Get Params
355: ------------------------------------------------------------------------
367: close get_params;
368: end if;
369: --
370: if g_debug then
371: hr_utility.set_location('pysgirar: End of initialization_code',8);
372: end if;
373: end initialization_code_adhoc;
374: -----------------------------------------------------------------------------------------------------
375: -- Bug: 3118540 - This function is called from the report PYSG8SAD.rdf - 'IR8S Ad Hoc Printed Report'
405: return(l_value);
406: exception
407: when e_no_value_found then
408: If g_debug then
409: hr_utility.set_location('error in get archive value - assignment_action_id:' ||p_assignment_action_id,3);
410: hr_utility.set_location('error in get archive value - user entity name :' ||p_user_entity_name,3);
411: end if;
412: return (null);
413: when others then
406: exception
407: when e_no_value_found then
408: If g_debug then
409: hr_utility.set_location('error in get archive value - assignment_action_id:' ||p_assignment_action_id,3);
410: hr_utility.set_location('error in get archive value - user entity name :' ||p_user_entity_name,3);
411: end if;
412: return (null);
413: when others then
414: If g_debug then
411: end if;
412: return (null);
413: when others then
414: If g_debug then
415: hr_utility.set_location('error in get archive value - assignment_action_id:' ||p_assignment_action_id,3);
416: hr_utility.set_location('error in get archive value - user entity name :' ||p_user_entity_name,3);
417: end if;
418: return (null);
419: end get_archive_value;
412: return (null);
413: when others then
414: If g_debug then
415: hr_utility.set_location('error in get archive value - assignment_action_id:' ||p_assignment_action_id,3);
416: hr_utility.set_location('error in get archive value - user entity name :' ||p_user_entity_name,3);
417: end if;
418: return (null);
419: end get_archive_value;
420: ------------------------------------------------------------------------
450: and paa.person_id = pap.person_id;
451:
452: begin
453: if g_debug then
454: hr_utility.set_location('pysgirar: Start of archive_code',10);
455: end if;
456: --
457:
458: open get_details ( p_assignment_action_id );
463: if get_details%found then
464: close get_details;
465: --
466: if g_debug then
467: hr_utility.set_location('pysgirar: Person Id: ' || to_char(v_person_id) ,100);
468: end if;
469: ------------------------------------------------------------------------------------------------
470: -- Because there are different routes for each group of data, a separate procedure
471: -- has been written for each.
573: l_archived_person_id := v_person_id;
574: t_archived_person(l_archived_person_id).person_id:= v_person_id;
575: else
576: if g_debug then
577: hr_utility.trace('The Employee has a duplicate employee so will not be processed');
578: end if;
579: end if;
580: else
581: close get_details;
581: close get_details;
582: end if;
583: --
584: if g_debug then
585: hr_utility.set_location('pysgirar: End of archive_code',20);
586: end if;
587: end archive_code;
588: --------------------------------------------------------------------------------------
589: -- Bug#3501927 Added new function to fetch and calculate A8A Balances
1053: end loop;
1054: --
1055: exception
1056: when others then
1057: hr_utility.set_location('pysgirar: Error in a8a_balances_value',10);
1058: raise;
1059: end;
1060: ---------------------------------------------------------------------------
1061: -- Selects data required to archive the YTD and Month balances. The
1298: duplicate_exists := 'N';
1299: l_arch_counter := 1;
1300: --
1301: if g_debug then
1302: hr_utility.set_location('pysgirar: Start of archive_balances',10);
1303: end if;
1304: ------------------------------------------------------------------------------------------------
1305: -- Bug 3435334 Table g_person_id_tab is populated with duplicate records for current person
1306: -- in employee_if_latest( ) function
1751: p_assignment_action_id,
1752: v_run_ass_action_id,
1753: p_tax_unit_id );
1754: if g_debug then
1755: hr_utility.set_location('pysgirar: End of archive_balances',100);
1756: end if;
1757: end archive_balances;
1758: ---------------------------------------------------------------------------
1759: -- Copies the standard balance route code, but instead of selecting the run
2009: --
2010: --
2011: begin
2012: if g_debug then
2013: hr_utility.set_location('pysgirar: Start of archive_balance_dates',10);
2014: end if;
2015: ---------------------------------------------------------------------------------------
2016: -- Bug 2843586. Added v_no_of_times>0 check along with
2017: -- balance_dates%found check for all the below balances
2485: archive_item ('X_IR8S_MOA_413_DATE', p_assignment_action_id, v_moa_413_date);
2486: end if;
2487: --
2488: if g_debug then
2489: hr_utility.set_location('pysgirar: End of archive_balance_dates',100);
2490: end if;
2491:
2492: end archive_balance_dates;
2493: ---------------------------------------------------------------------------
2589:
2590:
2591: begin
2592: if g_debug then
2593: hr_utility.set_location('pysgirar: Start of archive_org_info',10);
2594: end if;
2595: --
2596:
2597: if g_org_run <> 'Y' then
2763: end if;
2764: end if;
2765: --
2766: if g_debug then
2767: hr_utility.set_location('pysgirar: End of archive_org_info',20);
2768: end if;
2769: end archive_org_info;
2770:
2771: --------------------------------------------------------------------------
2799: and ppamax.action_type in ('R','B','I','Q','V');
2800:
2801: begin
2802: if g_debug then
2803: hr_utility.set_location('pysgirar: Start of archive_payroll_date',10);
2804: end if;
2805: --
2806: open payroll_date (p_business_group_id, p_legal_entity_id, p_person_id, p_basis_year);
2807: fetch payroll_date into v_payroll_date;
2812: --
2813: close payroll_date;
2814: --
2815: if g_debug then
2816: hr_utility.set_location('pysgirar: End of archive_payroll_date',20);
2817: end if;
2818: end archive_payroll_date;
2819:
2820: ---------------------------------------------------------------------------
2857: and h.application_id (+)= 800;
2858: --
2859: begin
2860: if g_debug then
2861: hr_utility.set_location('pysgirar: Start of archive_person_details',10);
2862: end if;
2863: --
2864: open person_details (p_person_id, p_basis_start, p_basis_end);
2865: fetch person_details into v_national_identifier, v_sex, v_date_of_birth;
2873: --
2874: close person_details;
2875: --
2876: if g_debug then
2877: hr_utility.set_location('pysgirar: End of archive_person_details',20);
2878: end if;
2879: end archive_person_details;
2880: ---------------------------------------------------------------------------
2881: -- Copies the standard Person Address information route code.
2921: and a.language (+)= userenv('LANG');
2922:
2923: begin
2924: if g_debug then
2925: hr_utility.set_location('pysgirar: Start of archive_person_addresses',10);
2926: end if;
2927: -- Primary Address
2928: open person_address (p_person_id, p_basis_start, p_basis_end);
2929: fetch person_address into v_style,
2960: end if;
2961: close person_address;
2962: --
2963: if g_debug then
2964: hr_utility.set_location('pysgirar: End of archive_person_addresses',20);
2965: end if;
2966: end archive_person_addresses;
2967: ---------------------------------------------------------------------------
2968: -- Copies the standard Person Company Quarters address
3008: and nvl(date_to, c_basis_end) >= c_basis_start));/*Bug 2654499*/
3009:
3010: begin
3011: if g_debug then
3012: hr_utility.set_location('pysgirar: Start of archive_person_cq_addresses',10);
3013: end if;
3014:
3015: -- Company Quarters Address, bug 2373475
3016: open person_cq_address (p_person_id, p_basis_start, p_basis_end);
3028: end if;
3029: close person_cq_address;
3030: --
3031: if g_debug then
3032: hr_utility.set_location('pysgirar: End of archive_person_cq_addresses',20);
3033: end if;
3034: end archive_person_cq_addresses;
3035:
3036: ---------------------------------------------------------------------------
3111: and assign.effective_end_date <= c_basis_end;
3112:
3113: begin
3114: if g_debug then
3115: hr_utility.set_location('pysgirar: Start of archive_emp_details',10);
3116: end if;
3117: --
3118: /* Bug 13786754 */
3119: open ass_latest_join_dates (p_person_id, p_legal_entity_id, p_basis_start, p_basis_end);
3158:
3159: if v_ass_end_date is not null then
3160: archive_item ('X_EMP_TERM_DATE', p_assignment_action_id, fnd_date.date_to_canonical(v_ass_end_date));
3161: end if;
3162: hr_utility.trace('X_EMP_HIRE_DATE:'||fnd_date.date_to_canonical(v_ass_start_date));
3163: hr_utility.trace('X_EMP_TERM_DATE:'||fnd_date.date_to_canonical(v_ass_end_date));
3164:
3165: --
3166: if g_debug then
3159: if v_ass_end_date is not null then
3160: archive_item ('X_EMP_TERM_DATE', p_assignment_action_id, fnd_date.date_to_canonical(v_ass_end_date));
3161: end if;
3162: hr_utility.trace('X_EMP_HIRE_DATE:'||fnd_date.date_to_canonical(v_ass_start_date));
3163: hr_utility.trace('X_EMP_TERM_DATE:'||fnd_date.date_to_canonical(v_ass_end_date));
3164:
3165: --
3166: if g_debug then
3167: hr_utility.set_location('pysgirar: End of archive_emp_details',20);
3163: hr_utility.trace('X_EMP_TERM_DATE:'||fnd_date.date_to_canonical(v_ass_end_date));
3164:
3165: --
3166: if g_debug then
3167: hr_utility.set_location('pysgirar: End of archive_emp_details',20);
3168: end if;
3169: end archive_emp_details;
3170: ---------------------------------------------------------------------------
3171: -- Copies the standard Person Developer DF route code.
3212: and people1.effective_end_date >= c_basis_start);
3213: --
3214: begin
3215: if g_debug then
3216: hr_utility.set_location('pysgirar: Start of archive_people_flex',10);
3217: end if;
3218: --
3219: open emp_details (p_person_id, p_basis_start, p_basis_end);
3220: fetch emp_details into v_sg_legal_name, v_pp_country, v_permit_type, v_permit_date, v_income_tax_no, v_payee_id_type;
3267: end if;
3268: --
3269: close emp_details;
3270: if g_debug then
3271: hr_utility.set_location('pysgirar: End of archive_people_flex',20);
3272: end if;
3273: end archive_people_flex;
3274:
3275: ---------------------------------------------------------------------------
3333: and info.information_type(+) = 'HR_IRAS_ADDITIONAL_INFO_SG';
3334: --
3335: begin
3336: if g_debug then
3337: hr_utility.set_location('pysgirar: Start of archive_person_eits',10);
3338: end if;
3339: --
3340: open person_eits (p_person_id, p_basis_start, p_basis_end);
3341: fetch person_eits into v_section_45_applicable,
3372: end if;
3373: close person_eits;
3374: --
3375: if g_debug then
3376: hr_utility.set_location('pysgirar: End of archive_person_eits',20);
3377: end if;
3378: end archive_person_eits;
3379:
3380: ---------------------------------------------------------------------------
3422: and aei.information_type = 'HR_IR8S_INDICATORS_SG';
3423: --
3424: begin
3425: if g_debug then
3426: hr_utility.set_location('pysgirar: Start of archive_assignment_eits', 10);
3427: end if;
3428: --
3429: open assignment_eits (p_person_id, p_assignment_id, p_legal_entity_id, p_basis_start, p_basis_end);
3430: fetch assignment_eits into v_voluntary_cpf_obligatory,
3439: end if;
3440: close assignment_eits;
3441: --
3442: if g_debug then
3443: hr_utility.set_location('pysgirar: End of archive_assignment_eits', 20);
3444: end if;
3445: end archive_assignment_eits;
3446:
3447: ---------------------------------------------------------------------------
3487: --
3488: begin
3489:
3490: if g_debug then
3491: hr_utility.set_location('pysgirar: Start of archive_ass_bonus_date_eits', 10);
3492: end if;
3493: --
3494: open ass_bonus_date_eits (p_person_id, p_assignment_id, p_legal_entity_id, p_basis_start, p_basis_end);
3495: fetch ass_bonus_date_eits into v_ass_bonus_date;
3502: --
3503: close ass_bonus_date_eits;
3504: --
3505: if g_debug then
3506: hr_utility.set_location('pysgirar: End of archive_ass_bonus_date_eits', 20);
3507: end if;
3508: end archive_ass_bonus_date_eits;
3509:
3510: ---------------------------------------------------------------------------
3562: --
3563: begin
3564:
3565: if g_debug then
3566: hr_utility.set_location('pysgirar: Start of archive_ass_payment_method', 10);
3567: end if;
3568: --
3569: --
3570: open ass_payment_method (p_person_id, p_assignment_id, p_legal_entity_id, p_basis_start, p_basis_end);
3581: --
3582: close ass_payment_method;
3583: --
3584: if g_debug then
3585: hr_utility.set_location('pysgirar: End of archive_ass_payment_method', 20);
3586: end if;
3587: end archive_ass_payment_method;
3588:
3589:
3831: and assign.assignment_type = 'E';
3832: --
3833: begin
3834: if g_debug then
3835: hr_utility.set_location('pysgirar: Start of archive_job_designation',10);
3836: end if;
3837: ------------------------------------------------------------------------
3838: -- Check selected Job Designation Type
3839: -- Bug 4688761, added p_legal_eneity_id
3888:
3889: archive_item ('X_ASG_DESIGNATION', p_assignment_action_id, v_designation);
3890: --
3891: if g_debug then
3892: hr_utility.set_location('pysgirar: End of archive_job_designation',10);
3893: end if;
3894: end archive_job_designation;
3895: ---------------------------------------------------------------------------
3896: -- Selects information for Overseas Assignments, which is indicated by
3940: group by aei.aei_information1;
3941: --
3942: begin
3943: if g_debug then
3944: hr_utility.set_location('pysgirar: Start of archive_os_assignment',10);
3945: end if;
3946: --
3947: open os_assignment (p_person_id, p_legal_entity_id, p_basis_start, p_basis_end);
3948: fetch os_assignment into v_cpf_overseas_post_obligatory,
3956: end if;
3957: --
3958: close os_assignment;
3959: if g_debug then
3960: hr_utility.set_location('pysgirar: End of archive_os_assignment',20);
3961: end if;
3962: end archive_os_assignment;
3963:
3964: ---------------------------------------------------------------------------
4071: v_nsop_count := 0;
4072: v_csop_count := 0;
4073:
4074: if g_debug then
4075: hr_utility.set_location('pysgirar: Start of archive_shares_details', 10);
4076: end if;
4077: --
4078: v_archive := 'N';
4079: -- modified for bug 5435088
4223: end if;
4224: end if;
4225:
4226: if g_debug then
4227: hr_utility.set_location('pysgirar: End of archive_share_details', 100);
4228: end if;
4229: end archive_shares_details;
4230:
4231: ---------------------------------------------------------------------------
4285: duplicate_exists := 'N';
4286: l_total_counts := 0;
4287: --
4288: if g_debug then
4289: hr_utility.set_location('pysgirar: Start of archive_ir8s_c_details', 10);
4290: end if;
4291: ----------------------------------------------------------------------------------
4292: -- Added for bug 3162319
4293: -- Bug 3435334 Table g_person_id_tab is populated with duplicate records for current person
4352:
4353: end if;
4354: --
4355: if g_debug then
4356: hr_utility.set_location('pysgirar: End of archive_ir8s_c_details', 100);
4357: end if;
4358: end archive_ir8s_c_details;
4359:
4360:
4408:
4409: begin
4410: v_ir8s_total_moa410 := 0;
4411: if g_debug then
4412: hr_utility.set_location('pysgirar: Start of archive_ir8s_c_detail_moas', 10);
4413: end if;
4414: --
4415: for ir8s_c_rec in ir8s_c_details (p_person_id
4416: , p_tax_unit_id
4453:
4454: archive_item('X_IR8S_TOTAL_MOA410', p_assignment_action_id, v_ir8s_total_moa410);
4455: --
4456: if g_debug then
4457: hr_utility.set_location('pysgirar: End of archive_ir8s_c_detail_moas', 100);
4458: end if;
4459: end archive_ir8s_c_detail_moas;
4460: ---------------------------------------------------------------------------
4461: -- Calls the archive utility to actually perform the archive of the item.
4481: where user_entity_name = c_user_entity_name;
4482: --
4483: begin
4484: if g_debug then
4485: hr_utility.set_location('Start of archive_item',10);
4486: end if;
4487: --
4488: open user_entity_id (p_user_entity_name);
4489: fetch user_entity_id into v_user_entity_id;
4502: ,p_context1 => p_assignment_action_id
4503: ,p_some_warning => v_some_warning);
4504: --
4505: if g_debug then
4506: hr_utility.set_location('End of archive_item',20);
4507: end if;
4508: end archive_item;
4509:
4510: -----------------------------------------------------------------------------
4533: where user_entity_name = c_user_entity_name;
4534: --
4535: begin
4536: if g_debug then
4537: hr_utility.set_location('Start of archive_item_2',10);
4538: end if;
4539: --
4540: open user_entity_id (p_user_entity_name);
4541: fetch user_entity_id into v_user_entity_id;
4556: ,p_context2 => p_context_value2
4557: ,p_some_warning => v_some_warning);
4558: --
4559: if g_debug then
4560: hr_utility.set_location('End of archive_item_2',20);
4561: end if;
4562: end archive_item_2;
4563:
4564: -----------------------------------------------------------------------------
4588: where user_entity_name = c_user_entity_name;
4589: --
4590: begin
4591: if g_debug then
4592: hr_utility.set_location('Start of archive_item_3',10);
4593: end if;
4594: --
4595: open user_entity_id (p_user_entity_name);
4596: fetch user_entity_id into v_user_entity_id;
4613: ,p_context3 => p_context_value3
4614: ,p_some_warning => v_some_warning );
4615: --
4616: if g_debug then
4617: hr_utility.set_location('End of archive_item_3',20);
4618: end if;
4619: end archive_item_3;
4620: --------------------------------------------------------------------------------
4621: -- Bug 3118540 -
4630: begin
4631: l_rep_req_id := 0;
4632: v_setup_action := 0;
4633: if g_debug then
4634: hr_utility.set_location('pysgirar: Start of deinit_code',10);
4635: end if;
4636: --
4637: select report_type
4638: into l_report_type
4670: end if;
4671: exception
4672: when others then
4673: if g_debug then
4674: hr_utility.set_location('pysgirar: End of deinit_code',10);
4675: end if;
4676: raise;
4677: end deinit_code;
4678: ----------------------------------------------------------------------
4725: is
4726: l_archived_person_id binary_integer;
4727: begin
4728: if g_debug then
4729: hr_utility.set_location('pysgirar: Start of person_if_archived',10);
4730: end if;
4731:
4732: l_archived_person_id := p_person_id;
4733: if t_archived_person.exists(l_archived_person_id) then
4732: l_archived_person_id := p_person_id;
4733: if t_archived_person.exists(l_archived_person_id) then
4734: if (t_archived_person(l_archived_person_id).person_id = p_person_id) then
4735: if g_debug then
4736: hr_utility.set_location('End of person_if_archived',20);
4737: end if;
4738: return true;
4739: end if;
4740: end if;
4738: return true;
4739: end if;
4740: end if;
4741: if g_debug then
4742: hr_utility.set_location('End of person_if_archived',20);
4743: end if;
4744: return false;
4745: end person_if_archived;
4746:
4781: and (paf.effective_start_date <= c_basis_end and paf.effective_end_date >= c_basis_start);
4782:
4783: begin
4784: if g_debug then
4785: hr_utility.set_location('pysgirar: Start of pri_if_latest',10);
4786: end if;
4787:
4788: open pri_latest (p_person_id,
4789: p_tax_unit_id,
4793: --
4794: if pri_latest%found then
4795: close pri_latest;
4796: if g_debug then
4797: hr_utility.set_location('End of pri_if_latest',20);
4798: end if;
4799: return TRUE;
4800: end if;
4801: close pri_latest;
4799: return TRUE;
4800: end if;
4801: close pri_latest;
4802: if g_debug then
4803: hr_utility.set_location('End of pri_if_latest',20);
4804: end if;
4805: return FALSE;
4806:
4807: end pri_if_latest;
4845: and (paf.effective_start_date <= c_basis_end and paf.effective_end_date >= c_basis_start);
4846:
4847: begin
4848: if g_debug then
4849: hr_utility.set_location('pysgirar: Start of pri_LE_if_latest',10);
4850: end if;
4851:
4852: open pri_latest_LE (p_person_id,
4853: p_tax_unit_id,
4857: --
4858: if pri_latest_LE%found then
4859: close pri_latest_LE;
4860: if g_debug then
4861: hr_utility.set_location('End of pri_LE_if_latest',20);
4862: end if;
4863: return v_assignment_id;
4864: end if;
4865: close pri_latest_LE;
4863: return v_assignment_id;
4864: end if;
4865: close pri_latest_LE;
4866: if g_debug then
4867: hr_utility.set_location('End of pri_LE_if_latest',20);
4868: end if;
4869: return null;
4870:
4871: end pri_LE_if_latest;
4912: and (paf.effective_start_date <= c_basis_end and paf.effective_end_date >= c_basis_start);
4913:
4914: begin
4915: if g_debug then
4916: hr_utility.set_location('pysgirar: Start of id_LE_if_latest',10);
4917: end if;
4918:
4919: open id_latest_LE ( p_person_id
4920: , p_tax_unit_id
4924: --
4925: if id_latest_LE%found then
4926: close id_latest_LE;
4927: if g_debug then
4928: hr_utility.set_location('End of id_LE_if_latest',20);
4929: end if;
4930: return v_assignment_id;
4931: end if;
4932: close id_latest_LE;
4930: return v_assignment_id;
4931: end if;
4932: close id_latest_LE;
4933: if g_debug then
4934: hr_utility.set_location('End of id_LE_if_latest',20);
4935: end if;
4936: return null;
4937:
4938: end id_LE_if_latest;
4943: l_number_value number;
4944: l_result number;
4945: begin
4946: if g_debug then
4947: hr_utility.set_location('pysgirar: Start of check_is_number',10);
4948: end if;
4949:
4950: if p_value is NULL then
4951: if g_debug then
4948: end if;
4949:
4950: if p_value is NULL then
4951: if g_debug then
4952: hr_utility.set_location('End of check_is_number',20);
4953: end if;
4954:
4955: return TRUE;
4956: else
4958: l_result := nvl(length(TRANSLATE(p_value,'~0123456789','~')),0);
4959:
4960: if l_result=0 then
4961: if g_debug then
4962: hr_utility.set_location('End of check_is_number',20);
4963: end if;
4964: return TRUE;
4965: else
4966: if g_debug then
4963: end if;
4964: return TRUE;
4965: else
4966: if g_debug then
4967: hr_utility.set_location('End of check_is_number',30);
4968: end if;
4969: return FALSE;
4970: end if;
4971:
4986: l_result number;
4987: begin
4988:
4989: if g_debug then
4990: hr_utility.set_location('pysgirar: Start of check_payer_id',10);
4991: end if;
4992:
4993: l_payer_id := p_er_income_tax_number;
4994: l_payer_id_type := p_er_payer_id;
5059: end if;
5060: end if;
5061:
5062: if g_debug then
5063: hr_utility.set_location('pysgirar: End of check_payer_id',20);
5064: end if;
5065:
5066: return l_return;
5067: end check_payer_id;
5078: l_year number;
5079: begin
5080:
5081: if g_debug then
5082: hr_utility.set_location('pysgirar: Start of check_payee_id',10);
5083: end if;
5084:
5085: l_payee_id := p_ee_income_tax_number;
5086: l_payee_id_type := p_payee_id_type;
5116: end if;
5117: end if;
5118:
5119: if g_debug then
5120: hr_utility.set_location('pysgirar: End of check_payee_id',20);
5121: end if;
5122:
5123: return l_return;
5124: end check_payee_id;
5142:
5143: begin
5144:
5145: if g_debug then
5146: hr_utility.set_location('Start of get_country_code',10);
5147: end if;
5148:
5149: if p_country = 'ID' then
5150: l_country_code := '303';
5177: close country_code;
5178: end if;
5179:
5180: if g_debug then
5181: hr_utility.set_location('End of get_country_code',20);
5182: end if;
5183:
5184: return l_country_code;
5185:
5185:
5186: end get_country_code;
5187:
5188: begin
5189: g_debug := hr_utility.debug_enabled;
5190: g_org_run := 'N';
5191: g_org_a8a_run := 'N';
5192: g_iras_method := 'O';
5193: g_a8b_moa_348 := 0;