eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PL_UTILITY dependencies on HR_UTILITY

Line 111: hr_utility.set_location(l_proc,10);

107:
108:
109: begin
110: l_proc:='PAY_PL_UTILITY.PL_GET_SII_DETAILS';
111: hr_utility.set_location(l_proc,10);
112: open csr_payroll_end_date;
113: fetch csr_payroll_end_date into l_period_end_date;
114: close csr_payroll_end_date;
115:

Line 134: hr_utility.set_location(l_proc,20);

130:
131: p_active_term_flag:= 'YN';
132:
133:
134: hr_utility.set_location(l_proc,20);
135: open csr_sii_details(l_join_variable,l_contract_category,l_period_end_date);
136: fetch csr_sii_details into p_sii_code,
137: p_old_age_contrib,p_pension_contrib,
138: p_sickness_contrib,

Line 143: hr_utility.set_location(l_proc,30);

139: p_work_injury_contrib,p_labor_contrib,
140: p_unemployment_contrib,p_health_contrib;
141:
142: close csr_sii_details;
143: hr_utility.set_location(l_proc,30);
144:
145:
146:
147: else --per_system_status =term_assign?

Line 152: hr_utility.set_location(l_proc,40);

148:
149: --the employee has been terminated
150: --check if he was terminated in the current
151: --payroll period or some other previous period
152: hr_utility.set_location(l_proc,40);
153:
154: open csr_date_terminated;
155: fetch csr_date_terminated into l_date_terminated,l_payroll_id;
156:

Line 160: hr_utility.set_location(l_proc,50);

156:
157: if csr_date_terminated%found then
158: --employee has been terminated in current period only...
159: --so he has both active and term sii details in the tables
160: hr_utility.set_location(l_proc,50);
161: p_active_term_flag:= 'YY';
162: close csr_date_terminated;
163:
164: if l_contract_category='NORMAL' then

Line 187: hr_utility.set_location(l_proc,60);

183: end if;
184: --processing finished for active assign in this period
185: --before being terminated
186:
187: hr_utility.set_location(l_proc,60);
188:
189: if l_contract_category='NORMAL' then
190: l_contract_category:='TERM_NORMAL';
191: end if;

Line 202: hr_utility.set_location(l_proc,70);

198: p_term_work_injury_contrib,p_term_labor_contrib,
199: p_term_unemployment_contrib,p_term_health_contrib;
200: close csr_sii_details;
201:
202: hr_utility.set_location(l_proc,70);
203: else --csr_date_terminated%found ?
204: hr_utility.set_location(l_proc,80);
205: close csr_date_terminated;
206: p_active_term_flag:= 'NY';

Line 204: hr_utility.set_location(l_proc,80);

200: close csr_sii_details;
201:
202: hr_utility.set_location(l_proc,70);
203: else --csr_date_terminated%found ?
204: hr_utility.set_location(l_proc,80);
205: close csr_date_terminated;
206: p_active_term_flag:= 'NY';
207: --employee has been terminated in some other period and in this period he has been
208: --terminated throughout

Line 223: hr_utility.set_location(l_proc,90);

219: p_term_work_injury_contrib,p_term_labor_contrib,
220: p_term_unemployment_contrib,p_term_health_contrib;
221: close csr_sii_details;
222:
223: hr_utility.set_location(l_proc,90);
224: end if;--csr_date_terminated%found?
225: end if; --per_system_status =term_assign?
226: hr_utility.set_location(l_proc,95);
227: return 1;

Line 226: hr_utility.set_location(l_proc,95);

222:
223: hr_utility.set_location(l_proc,90);
224: end if;--csr_date_terminated%found?
225: end if; --per_system_status =term_assign?
226: hr_utility.set_location(l_proc,95);
227: return 1;
228: Exception
229: when others then
230: hr_utility.set_location(l_proc,99);

Line 230: hr_utility.set_location(l_proc,99);

226: hr_utility.set_location(l_proc,95);
227: return 1;
228: Exception
229: when others then
230: hr_utility.set_location(l_proc,99);
231: hr_utility.raise_error;
232:
233: end pl_get_sii_details; --end of function pl_get_sii_details
234: -- Start of function Get Rate of Tax

Line 231: hr_utility.raise_error;

227: return 1;
228: Exception
229: when others then
230: hr_utility.set_location(l_proc,99);
231: hr_utility.raise_error;
232:
233: end pl_get_sii_details; --end of function pl_get_sii_details
234: -- Start of function Get Rate of Tax
235: FUNCTION GET_RATE_OF_TAX(p_date_earned IN DATE,

Line 467: hr_utility.set_location(l_proc_name,10);

463: begin
464:
465: l_proc_name:='PAY_PL_UTILITY.PL_GET_TAX_DETAILS';
466:
467: hr_utility.set_location(l_proc_name,10);
468: open csr_contract_assgt_type(p_date_earned);
469: fetch csr_contract_assgt_type into
470: p_contract_category,
471: p_contract_type,

Line 493: hr_utility.set_location(l_proc_name,20);

489:
490: if l_payroll_run='Y' then
491: --payroll run for this or some other normal contract of this person
492: --with same payroll_id
493: hr_utility.set_location(l_proc_name,20);
494: open csr_run_result_values(l_assignment_action_id,'Tax Details');
495: fetch csr_run_result_values bulk collect into l_run_result_table;
496: close csr_run_result_values;
497: FOR indx IN l_run_result_table.FIRST .. l_run_result_table.LAST loop

Line 510: hr_utility.set_location(l_proc_name,30);

506: when 'IR Flag' then p_ir_flag :=l_run_result_table(indx).result_value;
507: when 'Income Reduction Amount' then p_income_reduction_amount:=l_run_result_table(indx).result_value;
508: end case;
509: end loop;
510: hr_utility.set_location(l_proc_name,30);
511: else--l_payroll_run='Y'?
512: hr_utility.set_location(l_proc_name,40);
513: open csr_payroll_end_date;
514: fetch csr_payroll_end_date into l_payroll_end_date;

Line 512: hr_utility.set_location(l_proc_name,40);

508: end case;
509: end loop;
510: hr_utility.set_location(l_proc_name,30);
511: else--l_payroll_run='Y'?
512: hr_utility.set_location(l_proc_name,40);
513: open csr_payroll_end_date;
514: fetch csr_payroll_end_date into l_payroll_end_date;
515: close csr_payroll_end_date;
516:

Line 529: hr_utility.set_location(l_proc_name,50);

525:
526: else--l_per_system_status<>'TERM_ASSIGN'
527: --Assignment is terminated.
528: --Find out if it has been terminated in current Payroll period
529: hr_utility.set_location(l_proc_name,50);
530: open csr_date_terminated ;
531: fetch csr_date_terminated into l_csr_date_terminated;
532: --this is the last date as active/susp assign.
533: --Pass next date for getting terminated sii/tax record

Line 561: hr_utility.set_location(l_proc_name,60);

557: fetch csr_get_tax_details into p_tax_reduction,p_spouse_or_child_flag,p_income_reduction,
558: p_income_reduction_amount,p_rate_of_tax,p_sii_code;
559: close csr_get_tax_details;
560:
561: hr_utility.set_location(l_proc_name,60);
562: end if;--l_payroll_run='Y'?
563: else--l_contract_category='NORMAL'?
564: /* ***************Tax Params for Civil Contract,Lump and F_Lump*************** */
565: hr_utility.set_location(l_proc_name,70);

Line 565: hr_utility.set_location(l_proc_name,70);

561: hr_utility.set_location(l_proc_name,60);
562: end if;--l_payroll_run='Y'?
563: else--l_contract_category='NORMAL'?
564: /* ***************Tax Params for Civil Contract,Lump and F_Lump*************** */
565: hr_utility.set_location(l_proc_name,70);
566: open csr_payroll_run(p_assignment_id,p_date_earned,p_payroll_id,p_date_earned-1);
567: fetch csr_payroll_run into l_csr_payroll_run.payroll_run,l_csr_payroll_run.assignment_action_id,l_csr_payroll_run.date_earned;
568: if l_csr_payroll_run.payroll_run='Y' then
569: hr_utility.set_location(l_proc_name,20);

Line 569: hr_utility.set_location(l_proc_name,20);

565: hr_utility.set_location(l_proc_name,70);
566: open csr_payroll_run(p_assignment_id,p_date_earned,p_payroll_id,p_date_earned-1);
567: fetch csr_payroll_run into l_csr_payroll_run.payroll_run,l_csr_payroll_run.assignment_action_id,l_csr_payroll_run.date_earned;
568: if l_csr_payroll_run.payroll_run='Y' then
569: hr_utility.set_location(l_proc_name,20);
570: open csr_run_result_values(l_csr_payroll_run.assignment_action_id,'Tax Details');
571: fetch csr_run_result_values bulk collect into l_run_result_table;
572: close csr_run_result_values;
573:

Line 587: hr_utility.set_location(l_proc_name,80);

583: when 'IR Flag' then p_ir_flag :=l_run_result_table(indx).result_value;
584: when 'Income Reduction Amount' then p_income_reduction_amount:=l_run_result_table(indx).result_value;
585: end case;
586: end loop;
587: hr_utility.set_location(l_proc_name,80);
588: close csr_payroll_run;
589: else --l_payroll_run='Y'?
590: close csr_payroll_run;
591: --No payroll has been run for this Civil Contract,Lump or F_Lump contract

Line 593: hr_utility.set_location(l_proc_name,40);

589: else --l_payroll_run='Y'?
590: close csr_payroll_run;
591: --No payroll has been run for this Civil Contract,Lump or F_Lump contract
592: --in the current payroll period
593: hr_utility.set_location(l_proc_name,40);
594:
595: open csr_payroll_end_date;
596: fetch csr_payroll_end_date into l_paye_table_date;
597: close csr_payroll_end_date;

Line 611: hr_utility.set_location(l_proc_name,90);

607: else
608: p_ir_flag:='Y';
609: end if;
610: end if;--l_payroll_run='Y'?
611: hr_utility.set_location(l_proc_name,90);
612: end if;--l_contract_category='NORMAL'?
613: hr_utility.set_location(l_proc_name,100);
614: return 0;
615: Exception

Line 613: hr_utility.set_location(l_proc_name,100);

609: end if;
610: end if;--l_payroll_run='Y'?
611: hr_utility.set_location(l_proc_name,90);
612: end if;--l_contract_category='NORMAL'?
613: hr_utility.set_location(l_proc_name,100);
614: return 0;
615: Exception
616: when others then
617: hr_utility.set_location(l_proc_name,99);

Line 617: hr_utility.set_location(l_proc_name,99);

613: hr_utility.set_location(l_proc_name,100);
614: return 0;
615: Exception
616: when others then
617: hr_utility.set_location(l_proc_name,99);
618: hr_utility.raise_error;
619: end pl_get_tax_details; --end of function pl_get_tax_details
620: END pay_pl_utility;

Line 618: hr_utility.raise_error;

614: return 0;
615: Exception
616: when others then
617: hr_utility.set_location(l_proc_name,99);
618: hr_utility.raise_error;
619: end pl_get_tax_details; --end of function pl_get_tax_details
620: END pay_pl_utility;