[Home] [Help]
57: p_sql out nocopy varchar2 )
58: is
59: begin
60: if g_debug then
61: hr_utility.set_location(' Start of range_code',1);
62: end if;
63: --
64: p_sql := 'select distinct person_id ' ||
65: 'from per_people_f ppf, ' ||
68: 'and ppa.business_group_id = ppf.business_group_id ' ||
69: 'order by ppf.person_id';
70: --
71: if g_debug then
72: hr_utility.set_location('End of range_code',2);
73: end if;
74: end range_code;
75: ----------------------------------------------------------------------------
76: -- Bug 3435334 - Pre-processor process now introduced for this archive.
103: and pai.action_information_category = 'SG_IRAS_SETUP'
104: and action_information2 between p_start_person_id and p_end_person_id ;
105: begin
106: if g_debug then
107: hr_utility.set_location('Start of assignment_action_code',3);
108: end if;
109: --
110: open get_params( p_payroll_action_id );
111: fetch get_params into v_setup_action_id;
116: fetch process_assignments into v_assignment_id;
117: exit when process_assignments%notfound;
118: --
119: if g_debug then
120: hr_utility.set_location('Before calling hr_nonrun_asact.insact',4);
121: end if;
122: --
123: open next_action_id ;
124: fetch next_action_id into v_next_action_id;
130: p_chunk,
131: null );
132: --
133: if g_debug then
134: hr_utility.set_location('After calling hr_nonrun_asact.insact',4);
135: end if;
136: end loop;
137: --
138: close process_assignments;
137: --
138: close process_assignments;
139: --
140: if g_debug then
141: hr_utility.set_location('End of assignment_action_code',5);
142: end if;
143: end assignment_action_code;
144: ------------------------------------------------------------------------
145: -- Bug 3435334 - Pre-processor process now introduced for this archive.
170: and organization_id = pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters)
171: and payroll_action_id = p_payroll_action_id;
172: begin
173: if g_debug then
174: hr_utility.set_location('pysgirar: Start of initialization_code',6);
175: end if;
176: --
177: if g_business_group_id is null then
178: open get_params( p_payroll_action_id );
196: g_org_a8a_run := 'Y';
197: end if;
198:
199: if g_debug then
200: hr_utility.set_location('pysgirar: End of initialization_code',8);
201: end if;
202: end initialization_code;
203: --------------------------------------------------------------------------------
204: -- Bug: 3118540 - This function is called from SRS 'IR8S Ad Hoc Printed Archive'
276: group by paf.person_id;
277:
278: begin
279: if g_debug then
280: hr_utility.set_location('pysgirar: Start of Assignemnt Action Code Adhoc', 20);
281: end if;
282: --
283: open get_params(p_payroll_action_id);
284: fetch get_params into v_person_id,
315: end loop;
316: close process_assignments;
317: --
318: if g_debug then
319: hr_utility.set_location('pysgirar: End of Assignemnt Action Code Adhoc', 20);
320: end if;
321: exception
322: when others then
323: hr_utility.set_location('pysgirar: Error in assignment action code adhoc',10);
319: hr_utility.set_location('pysgirar: End of Assignemnt Action Code Adhoc', 20);
320: end if;
321: exception
322: when others then
323: hr_utility.set_location('pysgirar: Error in assignment action code adhoc',10);
324: raise;
325: end assignment_action_code_adhoc;
326: --------------------------------------------------------------------------------
327: -- Bug: 3118540 - This function is called from SRS 'IR8S Ad Hoc Printed Archive'
344: where payroll_action_id = c_payroll_action_id;
345: --
346: begin
347: if g_debug then
348: hr_utility.set_location('pysgirar: Start of initialization_code',6);
349: end if;
350: ------------------------------------------------------------------------
351: -- Cursor Get Params
352: ------------------------------------------------------------------------
364: close get_params;
365: end if;
366: --
367: if g_debug then
368: hr_utility.set_location('pysgirar: End of initialization_code',8);
369: end if;
370: end initialization_code_adhoc;
371: -----------------------------------------------------------------------------------------------------
372: -- Bug: 3118540 - This function is called from the report PYSG8SAD.rdf - 'IR8S Ad Hoc Printed Report'
402: return(l_value);
403: exception
404: when e_no_value_found then
405: If g_debug then
406: hr_utility.set_location('error in get archive value - assignment_action_id:' ||p_assignment_action_id,3);
407: hr_utility.set_location('error in get archive value - user entity name :' ||p_user_entity_name,3);
408: end if;
409: return (null);
410: when others then
403: exception
404: when e_no_value_found then
405: If g_debug then
406: hr_utility.set_location('error in get archive value - assignment_action_id:' ||p_assignment_action_id,3);
407: hr_utility.set_location('error in get archive value - user entity name :' ||p_user_entity_name,3);
408: end if;
409: return (null);
410: when others then
411: If g_debug then
408: end if;
409: return (null);
410: when others then
411: If g_debug then
412: hr_utility.set_location('error in get archive value - assignment_action_id:' ||p_assignment_action_id,3);
413: hr_utility.set_location('error in get archive value - user entity name :' ||p_user_entity_name,3);
414: end if;
415: return (null);
416: end get_archive_value;
409: return (null);
410: when others then
411: If g_debug then
412: hr_utility.set_location('error in get archive value - assignment_action_id:' ||p_assignment_action_id,3);
413: hr_utility.set_location('error in get archive value - user entity name :' ||p_user_entity_name,3);
414: end if;
415: return (null);
416: end get_archive_value;
417: ------------------------------------------------------------------------
447: and paa.person_id = pap.person_id ;
448:
449: begin
450: if g_debug then
451: hr_utility.set_location('pysgirar: Start of archive_code',10);
452: end if;
453: --
454:
455: open get_details ( p_assignment_action_id );
460: if get_details%found then
461: close get_details;
462: --
463: if g_debug then
464: hr_utility.set_location('pysgirar: Person Id: ' || to_char(v_person_id) ,100);
465: end if;
466: ------------------------------------------------------------------------------------------------
467: -- Because there are different routes for each group of data, a separate procedure
468: -- has been written for each.
566: l_archived_person_id := v_person_id;
567: t_archived_person(l_archived_person_id).person_id:= v_person_id;
568: else
569: if g_debug then
570: hr_utility.trace('The Employee has a duplicate employee so will not be processed');
571: end if;
572: end if;
573: else
574: close get_details;
574: close get_details;
575: end if;
576: --
577: if g_debug then
578: hr_utility.set_location('pysgirar: End of archive_code',20);
579: end if;
580: end archive_code;
581: --------------------------------------------------------------------------------------
582: -- Bug#3501927 Added new function to fetch and calculate A8A Balances
1042: end loop;
1043: --
1044: exception
1045: when others then
1046: hr_utility.set_location('pysgirar: Error in a8a_balances_value',10);
1047: raise;
1048: end;
1049: ---------------------------------------------------------------------------
1050: -- Selects data required to archive the YTD and Month balances. The
1287: duplicate_exists := 'N';
1288: l_arch_counter := 1;
1289: --
1290: if g_debug then
1291: hr_utility.set_location('pysgirar: Start of archive_balances',10);
1292: end if;
1293: ------------------------------------------------------------------------------------------------
1294: -- Bug 3435334 Table g_person_id_tab is populated with duplicate records for current person
1295: -- in employee_if_latest( ) function
1740: p_assignment_action_id,
1741: v_run_ass_action_id,
1742: p_tax_unit_id );
1743: if g_debug then
1744: hr_utility.set_location('pysgirar: End of archive_balances',100);
1745: end if;
1746: end archive_balances;
1747: ---------------------------------------------------------------------------
1748: -- Copies the standard balance route code, but instead of selecting the run
1998: --
1999: --
2000: begin
2001: if g_debug then
2002: hr_utility.set_location('pysgirar: Start of archive_balance_dates',10);
2003: end if;
2004: ---------------------------------------------------------------------------------------
2005: -- Bug 2843586. Added v_no_of_times>0 check along with
2006: -- balance_dates%found check for all the below balances
2474: archive_item ('X_IR8S_MOA_413_DATE', p_assignment_action_id, v_moa_413_date);
2475: end if;
2476: --
2477: if g_debug then
2478: hr_utility.set_location('pysgirar: End of archive_balance_dates',100);
2479: end if;
2480:
2481: end archive_balance_dates;
2482: ---------------------------------------------------------------------------
2553: and to_char(org.organization_id) = scl.segment1;
2554:
2555: begin
2556: if g_debug then
2557: hr_utility.set_location('pysgirar: Start of archive_org_info',10);
2558: end if;
2559: --
2560: hr_utility.trace('g_org_run before:'||g_org_run);
2561: if g_org_run <> 'Y' then
2556: if g_debug then
2557: hr_utility.set_location('pysgirar: Start of archive_org_info',10);
2558: end if;
2559: --
2560: hr_utility.trace('g_org_run before:'||g_org_run);
2561: if g_org_run <> 'Y' then
2562: hr_utility.trace('g_org_run: 1'||g_org_run);
2563: open org_info (p_business_group_id, p_legal_entity_id);
2564: fetch org_info into v_legal_entity_name,
2558: end if;
2559: --
2560: hr_utility.trace('g_org_run before:'||g_org_run);
2561: if g_org_run <> 'Y' then
2562: hr_utility.trace('g_org_run: 1'||g_org_run);
2563: open org_info (p_business_group_id, p_legal_entity_id);
2564: fetch org_info into v_legal_entity_name,
2565: v_er_income_tax_number,
2566: v_er_auth_person,
2711: end if;
2712: end if;
2713: --
2714: if g_debug then
2715: hr_utility.set_location('pysgirar: End of archive_org_info',20);
2716: end if;
2717: end archive_org_info;
2718:
2719: --------------------------------------------------------------------------
2747: and ppamax.action_type in ('R','B','I','Q','V');
2748:
2749: begin
2750: if g_debug then
2751: hr_utility.set_location('pysgirar: Start of archive_payroll_date',10);
2752: end if;
2753: --
2754: open payroll_date (p_business_group_id, p_legal_entity_id, p_person_id, p_basis_year);
2755: fetch payroll_date into v_payroll_date;
2760: --
2761: close payroll_date;
2762: --
2763: if g_debug then
2764: hr_utility.set_location('pysgirar: End of archive_payroll_date',20);
2765: end if;
2766: end archive_payroll_date;
2767:
2768: ---------------------------------------------------------------------------
2805: and h.application_id (+)= 800;
2806: --
2807: begin
2808: if g_debug then
2809: hr_utility.set_location('pysgirar: Start of archive_person_details',10);
2810: end if;
2811: --
2812: open person_details (p_person_id, p_basis_start, p_basis_end);
2813: fetch person_details into v_national_identifier, v_sex, v_date_of_birth;
2821: --
2822: close person_details;
2823: --
2824: if g_debug then
2825: hr_utility.set_location('pysgirar: End of archive_person_details',20);
2826: end if;
2827: end archive_person_details;
2828: ---------------------------------------------------------------------------
2829: -- Copies the standard Person Address information route code.
2868: and a.language (+)= userenv('LANG');
2869:
2870: begin
2871: if g_debug then
2872: hr_utility.set_location('pysgirar: Start of archive_person_addresses',10);
2873: end if;
2874: -- Primary Address
2875: open person_address (p_person_id, p_basis_start, p_basis_end);
2876: fetch person_address into v_style,
2905: end if;
2906: close person_address;
2907: --
2908: if g_debug then
2909: hr_utility.set_location('pysgirar: End of archive_person_addresses',20);
2910: end if;
2911: end archive_person_addresses;
2912: ---------------------------------------------------------------------------
2913: -- Copies the standard Person Company Quarters address
2950: and nvl(date_to, c_basis_end) >= c_basis_start));/*Bug 2654499*/
2951:
2952: begin
2953: if g_debug then
2954: hr_utility.set_location('pysgirar: Start of archive_person_cq_addresses',10);
2955: end if;
2956:
2957: -- Company Quarters Address, bug 2373475
2958: open person_cq_address (p_person_id, p_basis_start, p_basis_end);
2970: end if;
2971: close person_cq_address;
2972: --
2973: if g_debug then
2974: hr_utility.set_location('pysgirar: End of archive_person_cq_addresses',20);
2975: end if;
2976: end archive_person_cq_addresses;
2977:
2978: ---------------------------------------------------------------------------
3014: and assign1.effective_end_date >= c_basis_start)
3015: );/*Bug 2654499*/
3016: begin
3017: if g_debug then
3018: hr_utility.set_location('pysgirar: Start of archive_emp_details',10);
3019: end if;
3020: --
3021: open emp_hire_details (p_person_id, p_basis_end);
3022: fetch emp_hire_details into v_date_start;
3034: end if;
3035: close emp_termination_details;
3036: --
3037: if g_debug then
3038: hr_utility.set_location('pysgirar: End of archive_emp_details',20);
3039: end if;
3040: end archive_emp_details;
3041: ---------------------------------------------------------------------------
3042: -- Copies the standard Person Developer DF route code.
3083: and people1.effective_end_date >= c_basis_start);
3084: --
3085: begin
3086: if g_debug then
3087: hr_utility.set_location('pysgirar: Start of archive_people_flex',10);
3088: end if;
3089: --
3090: open emp_details (p_person_id, p_basis_start, p_basis_end);
3091: 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;
3135: end if;
3136: --
3137: close emp_details;
3138: if g_debug then
3139: hr_utility.set_location('pysgirar: End of archive_people_flex',20);
3140: end if;
3141: end archive_people_flex;
3142:
3143: ---------------------------------------------------------------------------
3201: and info.information_type(+) = 'HR_IRAS_ADDITIONAL_INFO_SG';
3202: --
3203: begin
3204: if g_debug then
3205: hr_utility.set_location('pysgirar: Start of archive_person_eits',10);
3206: end if;
3207: --
3208: open person_eits (p_person_id, p_basis_start, p_basis_end);
3209: fetch person_eits into v_section_45_applicable,
3243: end if;
3244: close person_eits;
3245: --
3246: if g_debug then
3247: hr_utility.set_location('pysgirar: End of archive_person_eits',20);
3248: end if;
3249: end archive_person_eits;
3250:
3251: ---------------------------------------------------------------------------
3293: and aei.information_type = 'HR_IR8S_INDICATORS_SG';
3294: --
3295: begin
3296: if g_debug then
3297: hr_utility.set_location('pysgirar: Start of archive_assignment_eits', 10);
3298: end if;
3299: --
3300: open assignment_eits (p_person_id, p_assignment_id, p_legal_entity_id, p_basis_start, p_basis_end);
3301: fetch assignment_eits into v_voluntary_cpf_obligatory,
3310: end if;
3311: close assignment_eits;
3312: --
3313: if g_debug then
3314: hr_utility.set_location('pysgirar: End of archive_assignment_eits', 20);
3315: end if;
3316: end archive_assignment_eits;
3317:
3318: ---------------------------------------------------------------------------
3358: --
3359: begin
3360:
3361: if g_debug then
3362: hr_utility.set_location('pysgirar: Start of archive_ass_bonus_date_eits', 10);
3363: end if;
3364: --
3365: open ass_bonus_date_eits (p_person_id, p_assignment_id, p_legal_entity_id, p_basis_start, p_basis_end);
3366: fetch ass_bonus_date_eits into v_ass_bonus_date;
3373: --
3374: close ass_bonus_date_eits;
3375: --
3376: if g_debug then
3377: hr_utility.set_location('pysgirar: End of archive_ass_bonus_date_eits', 20);
3378: end if;
3379: end archive_ass_bonus_date_eits;
3380:
3381: ---------------------------------------------------------------------------
3433: --
3434: begin
3435:
3436: if g_debug then
3437: hr_utility.set_location('pysgirar: Start of archive_ass_payment_method', 10);
3438: end if;
3439: --
3440: --
3441: open ass_payment_method (p_person_id, p_assignment_id, p_legal_entity_id, p_basis_start, p_basis_end);
3451: --
3452: close ass_payment_method;
3453: --
3454: if g_debug then
3455: hr_utility.set_location('pysgirar: End of archive_ass_payment_method', 20);
3456: end if;
3457: end archive_ass_payment_method;
3458:
3459:
3701: and assign.assignment_type = 'E';
3702: --
3703: begin
3704: if g_debug then
3705: hr_utility.set_location('pysgirar: Start of archive_job_designation',10);
3706: end if;
3707: ------------------------------------------------------------------------
3708: -- Check selected Job Designation Type
3709: -- Bug 4688761, added p_legal_eneity_id
3758:
3759: archive_item ('X_ASG_DESIGNATION', p_assignment_action_id, v_designation);
3760: --
3761: if g_debug then
3762: hr_utility.set_location('pysgirar: End of archive_job_designation',10);
3763: end if;
3764: end archive_job_designation;
3765: ---------------------------------------------------------------------------
3766: -- Selects information for Overseas Assignments, which is indicated by
3810: group by aei.aei_information1;
3811: --
3812: begin
3813: if g_debug then
3814: hr_utility.set_location('pysgirar: Start of archive_os_assignment',10);
3815: end if;
3816: --
3817: open os_assignment (p_person_id, p_legal_entity_id, p_basis_start, p_basis_end);
3818: fetch os_assignment into v_cpf_overseas_post_obligatory,
3826: end if;
3827: --
3828: close os_assignment;
3829: if g_debug then
3830: hr_utility.set_location('pysgirar: End of archive_os_assignment',20);
3831: end if;
3832: end archive_os_assignment;
3833:
3834: ---------------------------------------------------------------------------
3912: v_moa_358 := 0;
3913: v_moa_602 := 0;
3914: v_grant_type_error := 'N';
3915: if g_debug then
3916: hr_utility.set_location('pysgirar: Start of archive_shares_details', 10);
3917: end if;
3918: --
3919: -- modifed for bug 5435088
3920: for share_rec in shares_details (p_person_id, p_basis_start, p_basis_end)
3963: archive_item ('X_PER_GRANT_TYPE_ERROR', p_assignment_action_id, v_grant_type_error);
3964: --
3965:
3966: if g_debug then
3967: hr_utility.set_location('pysgirar: End of archive_share_details', 100);
3968: end if;
3969: end archive_shares_details;
3970:
3971: ---------------------------------------------------------------------------
4025: duplicate_exists := 'N';
4026: l_total_counts := 0;
4027: --
4028: if g_debug then
4029: hr_utility.set_location('pysgirar: Start of archive_ir8s_c_details', 10);
4030: end if;
4031: ----------------------------------------------------------------------------------
4032: -- Added for bug 3162319
4033: -- Bug 3435334 Table g_person_id_tab is populated with duplicate records for current person
4092:
4093: end if;
4094: --
4095: if g_debug then
4096: hr_utility.set_location('pysgirar: End of archive_ir8s_c_details', 100);
4097: end if;
4098: end archive_ir8s_c_details;
4099:
4100:
4148:
4149: begin
4150: v_ir8s_total_moa410 := 0;
4151: if g_debug then
4152: hr_utility.set_location('pysgirar: Start of archive_ir8s_c_detail_moas', 10);
4153: end if;
4154: --
4155: for ir8s_c_rec in ir8s_c_details (p_person_id
4156: , p_tax_unit_id
4193:
4194: archive_item('X_IR8S_TOTAL_MOA410', p_assignment_action_id, v_ir8s_total_moa410);
4195: --
4196: if g_debug then
4197: hr_utility.set_location('pysgirar: End of archive_ir8s_c_detail_moas', 100);
4198: end if;
4199: end archive_ir8s_c_detail_moas;
4200: ---------------------------------------------------------------------------
4201: -- Calls the archive utility to actually perform the archive of the item.
4221: where user_entity_name = c_user_entity_name;
4222: --
4223: begin
4224: if g_debug then
4225: hr_utility.set_location('Start of archive_item',10);
4226: end if;
4227: --
4228: open user_entity_id (p_user_entity_name);
4229: fetch user_entity_id into v_user_entity_id;
4242: ,p_context1 => p_assignment_action_id
4243: ,p_some_warning => v_some_warning);
4244: --
4245: if g_debug then
4246: hr_utility.set_location('End of archive_item',20);
4247: end if;
4248: end archive_item;
4249:
4250: -----------------------------------------------------------------------------
4273: where user_entity_name = c_user_entity_name;
4274: --
4275: begin
4276: if g_debug then
4277: hr_utility.set_location('Start of archive_item_2',10);
4278: end if;
4279: --
4280: open user_entity_id (p_user_entity_name);
4281: fetch user_entity_id into v_user_entity_id;
4296: ,p_context2 => p_context_value2
4297: ,p_some_warning => v_some_warning);
4298: --
4299: if g_debug then
4300: hr_utility.set_location('End of archive_item_2',20);
4301: end if;
4302: end archive_item_2;
4303:
4304: -----------------------------------------------------------------------------
4328: where user_entity_name = c_user_entity_name;
4329: --
4330: begin
4331: if g_debug then
4332: hr_utility.set_location('Start of archive_item_3',10);
4333: end if;
4334: --
4335: open user_entity_id (p_user_entity_name);
4336: fetch user_entity_id into v_user_entity_id;
4353: ,p_context3 => p_context_value3
4354: ,p_some_warning => v_some_warning );
4355: --
4356: if g_debug then
4357: hr_utility.set_location('End of archive_item_3',20);
4358: end if;
4359: end archive_item_3;
4360: --------------------------------------------------------------------------------
4361: -- Bug 3118540 -
4370: begin
4371: l_rep_req_id := 0;
4372: v_setup_action := 0;
4373: if g_debug then
4374: hr_utility.set_location('pysgirar: Start of deinit_code',10);
4375: end if;
4376: --
4377: select report_type
4378: into l_report_type
4410: end if;
4411: exception
4412: when others then
4413: if g_debug then
4414: hr_utility.set_location('pysgirar: End of deinit_code',10);
4415: end if;
4416: raise;
4417: end deinit_code;
4418: ----------------------------------------------------------------------
4465: is
4466: l_archived_person_id binary_integer;
4467: begin
4468: if g_debug then
4469: hr_utility.set_location('pysgirar: Start of person_if_archived',10);
4470: end if;
4471:
4472: l_archived_person_id := p_person_id;
4473: if t_archived_person.exists(l_archived_person_id) then
4472: l_archived_person_id := p_person_id;
4473: if t_archived_person.exists(l_archived_person_id) then
4474: if (t_archived_person(l_archived_person_id).person_id = p_person_id) then
4475: if g_debug then
4476: hr_utility.set_location('End of person_if_archived',20);
4477: end if;
4478: return true;
4479: end if;
4480: end if;
4478: return true;
4479: end if;
4480: end if;
4481: if g_debug then
4482: hr_utility.set_location('End of person_if_archived',20);
4483: end if;
4484: return false;
4485: end person_if_archived;
4486:
4521: and (paf.effective_start_date <= c_basis_end and paf.effective_end_date >= c_basis_start);
4522:
4523: begin
4524: if g_debug then
4525: hr_utility.set_location('pysgirar: Start of pri_if_latest',10);
4526: end if;
4527:
4528: open pri_latest (p_person_id,
4529: p_tax_unit_id,
4533: --
4534: if pri_latest%found then
4535: close pri_latest;
4536: if g_debug then
4537: hr_utility.set_location('End of pri_if_latest',20);
4538: end if;
4539: return TRUE;
4540: end if;
4541: close pri_latest;
4539: return TRUE;
4540: end if;
4541: close pri_latest;
4542: if g_debug then
4543: hr_utility.set_location('End of pri_if_latest',20);
4544: end if;
4545: return FALSE;
4546:
4547: end pri_if_latest;
4585: and (paf.effective_start_date <= c_basis_end and paf.effective_end_date >= c_basis_start);
4586:
4587: begin
4588: if g_debug then
4589: hr_utility.set_location('pysgirar: Start of pri_LE_if_latest',10);
4590: end if;
4591:
4592: open pri_latest_LE (p_person_id,
4593: p_tax_unit_id,
4597: --
4598: if pri_latest_LE%found then
4599: close pri_latest_LE;
4600: if g_debug then
4601: hr_utility.set_location('End of pri_LE_if_latest',20);
4602: end if;
4603: return v_assignment_id;
4604: end if;
4605: close pri_latest_LE;
4603: return v_assignment_id;
4604: end if;
4605: close pri_latest_LE;
4606: if g_debug then
4607: hr_utility.set_location('End of pri_LE_if_latest',20);
4608: end if;
4609: return null;
4610:
4611: end pri_LE_if_latest;
4652: and (paf.effective_start_date <= c_basis_end and paf.effective_end_date >= c_basis_start);
4653:
4654: begin
4655: if g_debug then
4656: hr_utility.set_location('pysgirar: Start of id_LE_if_latest',10);
4657: end if;
4658:
4659: open id_latest_LE ( p_person_id
4660: , p_tax_unit_id
4664: --
4665: if id_latest_LE%found then
4666: close id_latest_LE;
4667: if g_debug then
4668: hr_utility.set_location('End of id_LE_if_latest',20);
4669: end if;
4670: return v_assignment_id;
4671: end if;
4672: close id_latest_LE;
4670: return v_assignment_id;
4671: end if;
4672: close id_latest_LE;
4673: if g_debug then
4674: hr_utility.set_location('End of id_LE_if_latest',20);
4675: end if;
4676: return null;
4677:
4678: end id_LE_if_latest;
4682: function check_is_number (p_value in varchar2) return boolean is
4683: l_number_value number;
4684: begin
4685: if g_debug then
4686: hr_utility.set_location('pysgirar: Start of check_is_number',10);
4687: end if;
4688:
4689: if p_value is NULL then
4690: if g_debug then
4687: end if;
4688:
4689: if p_value is NULL then
4690: if g_debug then
4691: hr_utility.set_location('End of check_is_number',20);
4692: end if;
4693:
4694: return TRUE;
4695: else
4697: l_number_value := to_number(p_value);
4698: exception
4699: when value_error then
4700: if g_debug then
4701: hr_utility.set_location('End of check_is_number',20);
4702: end if;
4703:
4704: return FALSE;
4705: end;
4704: return FALSE;
4705: end;
4706:
4707: if g_debug then
4708: hr_utility.set_location('End of check_is_number',20);
4709: end if;
4710:
4711: return TRUE;
4712: end if;
4725: l_year number;
4726: begin
4727:
4728: if g_debug then
4729: hr_utility.set_location('pysgirar: Start of check_payer_id',10);
4730: end if;
4731:
4732: l_payer_id := p_er_income_tax_number;
4733: l_payer_id_type := p_er_payer_id;
4804: end if;
4805: end if;
4806:
4807: if g_debug then
4808: hr_utility.set_location('pysgirar: End of check_payer_id',20);
4809: end if;
4810:
4811: return l_return;
4812: end check_payer_id;
4823: l_year number;
4824: begin
4825:
4826: if g_debug then
4827: hr_utility.set_location('pysgirar: Start of check_payee_id',10);
4828: end if;
4829:
4830: l_payee_id := p_ee_income_tax_number;
4831: l_payee_id_type := p_payee_id_type;
4861: end if;
4862: end if;
4863:
4864: if g_debug then
4865: hr_utility.set_location('pysgirar: End of check_payee_id',20);
4866: end if;
4867:
4868: return l_return;
4869: end check_payee_id;
4887:
4888: begin
4889:
4890: if g_debug then
4891: hr_utility.set_location('Start of get_country_code',10);
4892: end if;
4893:
4894: if p_country = 'ID' then
4895: l_country_code := '303';
4922: close country_code;
4923: end if;
4924:
4925: if g_debug then
4926: hr_utility.set_location('End of get_country_code',20);
4927: end if;
4928:
4929: return l_country_code;
4930:
4930:
4931: end get_country_code;
4932:
4933: begin
4934: g_debug := hr_utility.debug_enabled;
4935: g_org_run := 'N';
4936: g_org_a8a_run := 'N';
4937: end pay_sg_iras_archive;