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_ES_SS_CALCULATION dependencies on HR_UTILITY

Line 67: hr_utility.trace('get_assignment_info ');

63: l_date DATE;
64: --
65: BEGIN
66: --
67: hr_utility.trace('get_assignment_info ');
68: OPEN csr_get_per_info(p_assignment_id,p_date);
69: FETCH csr_get_per_info into p_35_yrs_ss, l_date;
70: CLOSE csr_get_per_info;
71: --

Line 72: hr_utility.trace('p_35_yrs_ss '||p_35_yrs_ss);

68: OPEN csr_get_per_info(p_assignment_id,p_date);
69: FETCH csr_get_per_info into p_35_yrs_ss, l_date;
70: CLOSE csr_get_per_info;
71: --
72: hr_utility.trace('p_35_yrs_ss '||p_35_yrs_ss);
73: --
74: p_seniority_yrs := FLOOR(MONTHS_BETWEEN(p_date,l_date)/12);
75: hr_utility.trace('p_seniority_yrs '||p_seniority_yrs);
76: --

Line 75: hr_utility.trace('p_seniority_yrs '||p_seniority_yrs);

71: --
72: hr_utility.trace('p_35_yrs_ss '||p_35_yrs_ss);
73: --
74: p_seniority_yrs := FLOOR(MONTHS_BETWEEN(p_date,l_date)/12);
75: hr_utility.trace('p_seniority_yrs '||p_seniority_yrs);
76: --
77: OPEN csr_get_assign_info(p_assignment_id,p_date);
78: FETCH csr_get_assign_info into p_Contribution_grp,p_work_center;
79: CLOSE csr_get_assign_info;

Line 81: hr_utility.trace('leaving get_assignment_info ');

77: OPEN csr_get_assign_info(p_assignment_id,p_date);
78: FETCH csr_get_assign_info into p_Contribution_grp,p_work_center;
79: CLOSE csr_get_assign_info;
80: --
81: hr_utility.trace('leaving get_assignment_info ');
82: --
83: return 0;
84: END get_assignment_info;
85: --

Line 135: hr_utility.trace('~~ Type '||p_leave_type);

131: --
132: l_no_days := 0;
133: l_ptm_perc := 0;
134: --
135: hr_utility.trace('~~ Type '||p_leave_type);
136: FOR i IN csr_get_no_absence(p_assignment_id
137: ,p_business_group_id
138: ,p_effective_date
139: ,p_period_start_date

Line 176: hr_utility.trace('~~ l_no_days '||l_no_days);

172: l_no_days := l_no_days + (i.end_date - i.start_date) + 1;
173: END IF;
174: END IF;
175: END LOOP;
176: hr_utility.trace('~~ l_no_days '||l_no_days);
177: --
178: RETURN nvl(l_no_days,0);
179: --
180: END get_absence_days;

Line 324: hr_utility.trace('**************** p_working_days '||p_working_days);

320: ,p_error_message => l_error_msg
321: ,p_default_wp => NULL
322: );
323: p_working_days := l_no_days;
324: hr_utility.trace('**************** p_working_days '||p_working_days);
325: hr_utility.trace('**************** p_working_hours '||p_working_hours);
326: RETURN l_no_days;
327: END;
328: --

Line 325: hr_utility.trace('**************** p_working_hours '||p_working_hours);

321: ,p_default_wp => NULL
322: );
323: p_working_days := l_no_days;
324: hr_utility.trace('**************** p_working_days '||p_working_days);
325: hr_utility.trace('**************** p_working_hours '||p_working_hours);
326: RETURN l_no_days;
327: END;
328: --
329: --------------------------------------------------------------------------------

Line 475: hr_utility.trace('~~~~~~~~ Exempt days '||l_days||p_ss_type|| i.situation);

471: -- to handle 28 days
472: IF l_days = l_act_days THEN
473: l_days := p_tot_days;
474: END IF;
475: hr_utility.trace('~~~~~~~~ Exempt days '||l_days||p_ss_type|| i.situation);
476: --
477: IF p_ss_type = 'NON_IA_ID' AND i.situation IN ('EXP_LE_NON_IA_ID','EXP_SS') THEN
478: p_td_flag := 'Y';
479: p_td_rebate_days := p_td_rebate_days + l_days;

Line 529: hr_utility.trace('l_days :'||l_days ||' l_tot_days : '||l_tot_days);

525: -- to handle 28 days
526: IF l_days = l_act_days THEN
527: l_days := p_tot_days;
528: END IF;
529: hr_utility.trace('l_days :'||l_days ||' l_tot_days : '||l_tot_days);
530: p_exempt_days := p_exempt_days + l_days;
531: l_ret:= get_table_value(p_business_gr_id
532: ,'ES_CONTRIBUTION_RATES_FOR_EXEMPT_SITUATIONS'
533: ,'EMPLOYERS_PERC'

Line 538: hr_utility.trace('p_le_exempt_perc :'||p_le_exempt_perc ||' l_ret : '||l_ret);

534: ,i.situation
535: ,p_effective_date);
536:
537: p_le_exempt_perc := p_le_exempt_perc + (to_number(l_ret) * (l_days/l_tot_days));
538: hr_utility.trace('p_le_exempt_perc :'||p_le_exempt_perc ||' l_ret : '||l_ret);
539: --
540: l_ret:= get_table_value(p_business_gr_id
541: ,'ES_CONTRIBUTION_RATES_FOR_EXEMPT_SITUATIONS'
542: ,'EMPLOYEES_PERC'

Line 546: hr_utility.trace('p_emp_exempt_perc :'||p_emp_exempt_perc ||' l_ret : '||l_ret);

542: ,'EMPLOYEES_PERC'
543: ,i.situation
544: ,p_effective_date);
545: p_emp_exempt_perc := p_emp_exempt_perc + (to_number(l_ret) * (l_days/l_tot_days));
546: hr_utility.trace('p_emp_exempt_perc :'||p_emp_exempt_perc ||' l_ret : '||l_ret);
547: END LOOP;
548: END IF;
549: p_td_rebate_days := LEAST(p_td_rebate_days,30);
550: p_exempt_days := LEAST(p_exempt_days,30);

Line 552: hr_utility.trace('~~Rebate- LE - CE - TD ');

548: END IF;
549: p_td_rebate_days := LEAST(p_td_rebate_days,30);
550: p_exempt_days := LEAST(p_exempt_days,30);
551: --
552: hr_utility.trace('~~Rebate- LE - CE - TD ');
553: hr_utility.trace('~~--p_td_flag ' || p_td_flag );
554: hr_utility.trace('~~--p_td_rebate_days ' || p_td_rebate_days );
555: hr_utility.trace('~~--p_le_td_perc ' || p_le_td_perc );
556: hr_utility.trace('~~--p_ss_td_perc ' || p_ss_td_perc );

Line 553: hr_utility.trace('~~--p_td_flag ' || p_td_flag );

549: p_td_rebate_days := LEAST(p_td_rebate_days,30);
550: p_exempt_days := LEAST(p_exempt_days,30);
551: --
552: hr_utility.trace('~~Rebate- LE - CE - TD ');
553: hr_utility.trace('~~--p_td_flag ' || p_td_flag );
554: hr_utility.trace('~~--p_td_rebate_days ' || p_td_rebate_days );
555: hr_utility.trace('~~--p_le_td_perc ' || p_le_td_perc );
556: hr_utility.trace('~~--p_ss_td_perc ' || p_ss_td_perc );
557: hr_utility.trace('~~--p_exempt_flag ' || p_exempt_flag );

Line 554: hr_utility.trace('~~--p_td_rebate_days ' || p_td_rebate_days );

550: p_exempt_days := LEAST(p_exempt_days,30);
551: --
552: hr_utility.trace('~~Rebate- LE - CE - TD ');
553: hr_utility.trace('~~--p_td_flag ' || p_td_flag );
554: hr_utility.trace('~~--p_td_rebate_days ' || p_td_rebate_days );
555: hr_utility.trace('~~--p_le_td_perc ' || p_le_td_perc );
556: hr_utility.trace('~~--p_ss_td_perc ' || p_ss_td_perc );
557: hr_utility.trace('~~--p_exempt_flag ' || p_exempt_flag );
558: hr_utility.trace('~~--p_exempt_days ' || p_exempt_days );

Line 555: hr_utility.trace('~~--p_le_td_perc ' || p_le_td_perc );

551: --
552: hr_utility.trace('~~Rebate- LE - CE - TD ');
553: hr_utility.trace('~~--p_td_flag ' || p_td_flag );
554: hr_utility.trace('~~--p_td_rebate_days ' || p_td_rebate_days );
555: hr_utility.trace('~~--p_le_td_perc ' || p_le_td_perc );
556: hr_utility.trace('~~--p_ss_td_perc ' || p_ss_td_perc );
557: hr_utility.trace('~~--p_exempt_flag ' || p_exempt_flag );
558: hr_utility.trace('~~--p_exempt_days ' || p_exempt_days );
559: hr_utility.trace('~~--p_le_exempt_perc ' || p_le_exempt_perc );

Line 556: hr_utility.trace('~~--p_ss_td_perc ' || p_ss_td_perc );

552: hr_utility.trace('~~Rebate- LE - CE - TD ');
553: hr_utility.trace('~~--p_td_flag ' || p_td_flag );
554: hr_utility.trace('~~--p_td_rebate_days ' || p_td_rebate_days );
555: hr_utility.trace('~~--p_le_td_perc ' || p_le_td_perc );
556: hr_utility.trace('~~--p_ss_td_perc ' || p_ss_td_perc );
557: hr_utility.trace('~~--p_exempt_flag ' || p_exempt_flag );
558: hr_utility.trace('~~--p_exempt_days ' || p_exempt_days );
559: hr_utility.trace('~~--p_le_exempt_perc ' || p_le_exempt_perc );
560: hr_utility.trace('~~--p_emp_exempt_perc ' || p_emp_exempt_perc );

Line 557: hr_utility.trace('~~--p_exempt_flag ' || p_exempt_flag );

553: hr_utility.trace('~~--p_td_flag ' || p_td_flag );
554: hr_utility.trace('~~--p_td_rebate_days ' || p_td_rebate_days );
555: hr_utility.trace('~~--p_le_td_perc ' || p_le_td_perc );
556: hr_utility.trace('~~--p_ss_td_perc ' || p_ss_td_perc );
557: hr_utility.trace('~~--p_exempt_flag ' || p_exempt_flag );
558: hr_utility.trace('~~--p_exempt_days ' || p_exempt_days );
559: hr_utility.trace('~~--p_le_exempt_perc ' || p_le_exempt_perc );
560: hr_utility.trace('~~--p_emp_exempt_perc ' || p_emp_exempt_perc );
561: --

Line 558: hr_utility.trace('~~--p_exempt_days ' || p_exempt_days );

554: hr_utility.trace('~~--p_td_rebate_days ' || p_td_rebate_days );
555: hr_utility.trace('~~--p_le_td_perc ' || p_le_td_perc );
556: hr_utility.trace('~~--p_ss_td_perc ' || p_ss_td_perc );
557: hr_utility.trace('~~--p_exempt_flag ' || p_exempt_flag );
558: hr_utility.trace('~~--p_exempt_days ' || p_exempt_days );
559: hr_utility.trace('~~--p_le_exempt_perc ' || p_le_exempt_perc );
560: hr_utility.trace('~~--p_emp_exempt_perc ' || p_emp_exempt_perc );
561: --
562: RETURN 0;

Line 559: hr_utility.trace('~~--p_le_exempt_perc ' || p_le_exempt_perc );

555: hr_utility.trace('~~--p_le_td_perc ' || p_le_td_perc );
556: hr_utility.trace('~~--p_ss_td_perc ' || p_ss_td_perc );
557: hr_utility.trace('~~--p_exempt_flag ' || p_exempt_flag );
558: hr_utility.trace('~~--p_exempt_days ' || p_exempt_days );
559: hr_utility.trace('~~--p_le_exempt_perc ' || p_le_exempt_perc );
560: hr_utility.trace('~~--p_emp_exempt_perc ' || p_emp_exempt_perc );
561: --
562: RETURN 0;
563: END get_legal_employer_info;

Line 560: hr_utility.trace('~~--p_emp_exempt_perc ' || p_emp_exempt_perc );

556: hr_utility.trace('~~--p_ss_td_perc ' || p_ss_td_perc );
557: hr_utility.trace('~~--p_exempt_flag ' || p_exempt_flag );
558: hr_utility.trace('~~--p_exempt_days ' || p_exempt_days );
559: hr_utility.trace('~~--p_le_exempt_perc ' || p_le_exempt_perc );
560: hr_utility.trace('~~--p_emp_exempt_perc ' || p_emp_exempt_perc );
561: --
562: RETURN 0;
563: END get_legal_employer_info;
564: --

Line 730: hr_utility.trace('~~Entering pay_es_ss_calculation.get_prev_salary');

726: l_legal_employer_id hr_All_organization_units.organization_id%TYPE;
727: --
728: BEGIN
729: --
730: hr_utility.trace('~~Entering pay_es_ss_calculation.get_prev_salary');
731: l_def_bal_id := get_defined_bal_id(p_balance_name, p_database_item_suffix);
732: hr_utility.trace('~~~~ p_balance_name'||p_balance_name);
733: hr_utility.trace('~~~~ p_database_item_suffix'||p_database_item_suffix);
734: hr_utility.trace('~~~~ l_def_bal_id'||l_def_bal_id);

Line 732: hr_utility.trace('~~~~ p_balance_name'||p_balance_name);

728: BEGIN
729: --
730: hr_utility.trace('~~Entering pay_es_ss_calculation.get_prev_salary');
731: l_def_bal_id := get_defined_bal_id(p_balance_name, p_database_item_suffix);
732: hr_utility.trace('~~~~ p_balance_name'||p_balance_name);
733: hr_utility.trace('~~~~ p_database_item_suffix'||p_database_item_suffix);
734: hr_utility.trace('~~~~ l_def_bal_id'||l_def_bal_id);
735: l_amount := 0;
736: l_amt := 0;

Line 733: hr_utility.trace('~~~~ p_database_item_suffix'||p_database_item_suffix);

729: --
730: hr_utility.trace('~~Entering pay_es_ss_calculation.get_prev_salary');
731: l_def_bal_id := get_defined_bal_id(p_balance_name, p_database_item_suffix);
732: hr_utility.trace('~~~~ p_balance_name'||p_balance_name);
733: hr_utility.trace('~~~~ p_database_item_suffix'||p_database_item_suffix);
734: hr_utility.trace('~~~~ l_def_bal_id'||l_def_bal_id);
735: l_amount := 0;
736: l_amt := 0;
737: l_ctr := 0;

Line 734: hr_utility.trace('~~~~ l_def_bal_id'||l_def_bal_id);

730: hr_utility.trace('~~Entering pay_es_ss_calculation.get_prev_salary');
731: l_def_bal_id := get_defined_bal_id(p_balance_name, p_database_item_suffix);
732: hr_utility.trace('~~~~ p_balance_name'||p_balance_name);
733: hr_utility.trace('~~~~ p_database_item_suffix'||p_database_item_suffix);
734: hr_utility.trace('~~~~ l_def_bal_id'||l_def_bal_id);
735: l_amount := 0;
736: l_amt := 0;
737: l_ctr := 0;
738: l_cnt := 0;

Line 747: hr_utility.trace('~~~~ Setting TAX_UNIT_ID Context '||l_legal_employer_id);

743: OPEN get_legal_employer_id(to_number(p_context_val));
744: FETCH get_legal_employer_id INTO l_legal_employer_id;
745: CLOSE get_legal_employer_id;
746: pay_balance_pkg.set_context('TAX_UNIT_ID', l_legal_employer_id);
747: hr_utility.trace('~~~~ Setting TAX_UNIT_ID Context '||l_legal_employer_id);
748: END IF;
749: --
750: hr_utility.trace('~~~~ Start loop p_period_start_date '||p_period_start_date);
751: hr_utility.trace('~~~~ p_assignment_action_id '||p_assignment_action_id);

Line 750: hr_utility.trace('~~~~ Start loop p_period_start_date '||p_period_start_date);

746: pay_balance_pkg.set_context('TAX_UNIT_ID', l_legal_employer_id);
747: hr_utility.trace('~~~~ Setting TAX_UNIT_ID Context '||l_legal_employer_id);
748: END IF;
749: --
750: hr_utility.trace('~~~~ Start loop p_period_start_date '||p_period_start_date);
751: hr_utility.trace('~~~~ p_assignment_action_id '||p_assignment_action_id);
752: FOR i IN get_prev_periods_dates( p_assignment_action_id, p_period_start_date) LOOP
753: --
754: IF l_date = i.start_date AND l_amt <> 0 THEN

Line 751: hr_utility.trace('~~~~ p_assignment_action_id '||p_assignment_action_id);

747: hr_utility.trace('~~~~ Setting TAX_UNIT_ID Context '||l_legal_employer_id);
748: END IF;
749: --
750: hr_utility.trace('~~~~ Start loop p_period_start_date '||p_period_start_date);
751: hr_utility.trace('~~~~ p_assignment_action_id '||p_assignment_action_id);
752: FOR i IN get_prev_periods_dates( p_assignment_action_id, p_period_start_date) LOOP
753: --
754: IF l_date = i.start_date AND l_amt <> 0 THEN
755: NULL;

Line 766: hr_utility.trace('~~~~ Inside loop start_date '||i.start_date);

762: IF l_amt <> 0 THEN
763: l_cnt := l_cnt + 1;
764: END IF;
765: l_amount := l_amount + l_amt;
766: hr_utility.trace('~~~~ Inside loop start_date '||i.start_date);
767: hr_utility.trace('~~~~ assignment_action_id '||i.assignment_action_id);
768: hr_utility.trace('~~~~ l_ctr '||l_ctr);
769: hr_utility.trace('~~~~ l_cnt '||l_cnt);
770: hr_utility.trace('~~~~ l_amt '||l_amt);

Line 767: hr_utility.trace('~~~~ assignment_action_id '||i.assignment_action_id);

763: l_cnt := l_cnt + 1;
764: END IF;
765: l_amount := l_amount + l_amt;
766: hr_utility.trace('~~~~ Inside loop start_date '||i.start_date);
767: hr_utility.trace('~~~~ assignment_action_id '||i.assignment_action_id);
768: hr_utility.trace('~~~~ l_ctr '||l_ctr);
769: hr_utility.trace('~~~~ l_cnt '||l_cnt);
770: hr_utility.trace('~~~~ l_amt '||l_amt);
771: hr_utility.trace('~~~~ l_amount '||l_amount);

Line 768: hr_utility.trace('~~~~ l_ctr '||l_ctr);

764: END IF;
765: l_amount := l_amount + l_amt;
766: hr_utility.trace('~~~~ Inside loop start_date '||i.start_date);
767: hr_utility.trace('~~~~ assignment_action_id '||i.assignment_action_id);
768: hr_utility.trace('~~~~ l_ctr '||l_ctr);
769: hr_utility.trace('~~~~ l_cnt '||l_cnt);
770: hr_utility.trace('~~~~ l_amt '||l_amt);
771: hr_utility.trace('~~~~ l_amount '||l_amount);
772: hr_utility.trace('~~~~ p_no_month '||p_no_month);

Line 769: hr_utility.trace('~~~~ l_cnt '||l_cnt);

765: l_amount := l_amount + l_amt;
766: hr_utility.trace('~~~~ Inside loop start_date '||i.start_date);
767: hr_utility.trace('~~~~ assignment_action_id '||i.assignment_action_id);
768: hr_utility.trace('~~~~ l_ctr '||l_ctr);
769: hr_utility.trace('~~~~ l_cnt '||l_cnt);
770: hr_utility.trace('~~~~ l_amt '||l_amt);
771: hr_utility.trace('~~~~ l_amount '||l_amount);
772: hr_utility.trace('~~~~ p_no_month '||p_no_month);
773: IF l_amt <> 0 OR p_flag = 'N' THEN

Line 770: hr_utility.trace('~~~~ l_amt '||l_amt);

766: hr_utility.trace('~~~~ Inside loop start_date '||i.start_date);
767: hr_utility.trace('~~~~ assignment_action_id '||i.assignment_action_id);
768: hr_utility.trace('~~~~ l_ctr '||l_ctr);
769: hr_utility.trace('~~~~ l_cnt '||l_cnt);
770: hr_utility.trace('~~~~ l_amt '||l_amt);
771: hr_utility.trace('~~~~ l_amount '||l_amount);
772: hr_utility.trace('~~~~ p_no_month '||p_no_month);
773: IF l_amt <> 0 OR p_flag = 'N' THEN
774: p_days := p_days + last_day(i.start_date) - last_day(add_months(i.start_date,-1));

Line 771: hr_utility.trace('~~~~ l_amount '||l_amount);

767: hr_utility.trace('~~~~ assignment_action_id '||i.assignment_action_id);
768: hr_utility.trace('~~~~ l_ctr '||l_ctr);
769: hr_utility.trace('~~~~ l_cnt '||l_cnt);
770: hr_utility.trace('~~~~ l_amt '||l_amt);
771: hr_utility.trace('~~~~ l_amount '||l_amount);
772: hr_utility.trace('~~~~ p_no_month '||p_no_month);
773: IF l_amt <> 0 OR p_flag = 'N' THEN
774: p_days := p_days + last_day(i.start_date) - last_day(add_months(i.start_date,-1));
775: END IF;

Line 772: hr_utility.trace('~~~~ p_no_month '||p_no_month);

768: hr_utility.trace('~~~~ l_ctr '||l_ctr);
769: hr_utility.trace('~~~~ l_cnt '||l_cnt);
770: hr_utility.trace('~~~~ l_amt '||l_amt);
771: hr_utility.trace('~~~~ l_amount '||l_amount);
772: hr_utility.trace('~~~~ p_no_month '||p_no_month);
773: IF l_amt <> 0 OR p_flag = 'N' THEN
774: p_days := p_days + last_day(i.start_date) - last_day(add_months(i.start_date,-1));
775: END IF;
776: IF l_ctr >= p_no_month THEN

Line 786: hr_utility.trace('~~Exiting pay_es_ss_calculation.get_prev_salary');

782: END IF;
783: l_date := i.start_date;
784: END IF;
785: END LOOP;
786: hr_utility.trace('~~Exiting pay_es_ss_calculation.get_prev_salary');
787: RETURN l_amount;
788: --
789: END get_prev_salary;
790: --

Line 928: hr_utility.trace(' l_epigraph '||l_epigraph||' '||p_epigraph_code||' l_cac '||l_cac||' '||p_cac);

924: ,p_rec_start_date
925: ,p_rec_end_date
926: ,p_period_end_date);
927: FETCH csr_get_value INTO l_period,l_epigraph,l_cac;
928: hr_utility.trace(' l_epigraph '||l_epigraph||' '||p_epigraph_code||' l_cac '||l_cac||' '||p_cac);
929: IF csr_get_value%NOTFOUND THEN
930: p_no_ptm_days := 0;
931: ELSE
932: IF l_epigraph = p_epigraph_code AND l_cac = p_cac THEN

Line 1031: hr_utility.trace(' p_no_ptm_days '||p_no_ptm_days);

1027: --
1028: p_no_ptm_days := nvl(p_no_ptm_days,0);
1029: p_no_partial_strike_days := nvl(p_no_partial_strike_days,0);
1030: p_active_without_pay_days := nvl(p_active_without_pay_days,0);
1031: hr_utility.trace(' p_no_ptm_days '||p_no_ptm_days);
1032: hr_utility.trace(' p_no_partial_strike_days '||p_no_partial_strike_days);
1033: hr_utility.trace(' p_active_without_pay_days '||p_active_without_pay_days);
1034: hr_utility.trace(' p_no_ptm_hours '||p_no_ptm_hours);
1035: hr_utility.trace(' p_no_partial_strike_hours '||p_no_partial_strike_hours);

Line 1032: hr_utility.trace(' p_no_partial_strike_days '||p_no_partial_strike_days);

1028: p_no_ptm_days := nvl(p_no_ptm_days,0);
1029: p_no_partial_strike_days := nvl(p_no_partial_strike_days,0);
1030: p_active_without_pay_days := nvl(p_active_without_pay_days,0);
1031: hr_utility.trace(' p_no_ptm_days '||p_no_ptm_days);
1032: hr_utility.trace(' p_no_partial_strike_days '||p_no_partial_strike_days);
1033: hr_utility.trace(' p_active_without_pay_days '||p_active_without_pay_days);
1034: hr_utility.trace(' p_no_ptm_hours '||p_no_ptm_hours);
1035: hr_utility.trace(' p_no_partial_strike_hours '||p_no_partial_strike_hours);
1036: hr_utility.trace(' p_active_without_pay_hours '||p_active_without_pay_hours);

Line 1033: hr_utility.trace(' p_active_without_pay_days '||p_active_without_pay_days);

1029: p_no_partial_strike_days := nvl(p_no_partial_strike_days,0);
1030: p_active_without_pay_days := nvl(p_active_without_pay_days,0);
1031: hr_utility.trace(' p_no_ptm_days '||p_no_ptm_days);
1032: hr_utility.trace(' p_no_partial_strike_days '||p_no_partial_strike_days);
1033: hr_utility.trace(' p_active_without_pay_days '||p_active_without_pay_days);
1034: hr_utility.trace(' p_no_ptm_hours '||p_no_ptm_hours);
1035: hr_utility.trace(' p_no_partial_strike_hours '||p_no_partial_strike_hours);
1036: hr_utility.trace(' p_active_without_pay_hours '||p_active_without_pay_hours);
1037: --

Line 1034: hr_utility.trace(' p_no_ptm_hours '||p_no_ptm_hours);

1030: p_active_without_pay_days := nvl(p_active_without_pay_days,0);
1031: hr_utility.trace(' p_no_ptm_days '||p_no_ptm_days);
1032: hr_utility.trace(' p_no_partial_strike_days '||p_no_partial_strike_days);
1033: hr_utility.trace(' p_active_without_pay_days '||p_active_without_pay_days);
1034: hr_utility.trace(' p_no_ptm_hours '||p_no_ptm_hours);
1035: hr_utility.trace(' p_no_partial_strike_hours '||p_no_partial_strike_hours);
1036: hr_utility.trace(' p_active_without_pay_hours '||p_active_without_pay_hours);
1037: --
1038: RETURN 0;

Line 1035: hr_utility.trace(' p_no_partial_strike_hours '||p_no_partial_strike_hours);

1031: hr_utility.trace(' p_no_ptm_days '||p_no_ptm_days);
1032: hr_utility.trace(' p_no_partial_strike_days '||p_no_partial_strike_days);
1033: hr_utility.trace(' p_active_without_pay_days '||p_active_without_pay_days);
1034: hr_utility.trace(' p_no_ptm_hours '||p_no_ptm_hours);
1035: hr_utility.trace(' p_no_partial_strike_hours '||p_no_partial_strike_hours);
1036: hr_utility.trace(' p_active_without_pay_hours '||p_active_without_pay_hours);
1037: --
1038: RETURN 0;
1039: --

Line 1036: hr_utility.trace(' p_active_without_pay_hours '||p_active_without_pay_hours);

1032: hr_utility.trace(' p_no_partial_strike_days '||p_no_partial_strike_days);
1033: hr_utility.trace(' p_active_without_pay_days '||p_active_without_pay_days);
1034: hr_utility.trace(' p_no_ptm_hours '||p_no_ptm_hours);
1035: hr_utility.trace(' p_no_partial_strike_hours '||p_no_partial_strike_hours);
1036: hr_utility.trace(' p_active_without_pay_hours '||p_active_without_pay_hours);
1037: --
1038: RETURN 0;
1039: --
1040: END get_input_value;

Line 1068: hr_utility.trace('l_ret '||l_ret);

1064: WHEN NO_DATA_FOUND THEN
1065: l_ret:='0';
1066: END;
1067: --
1068: hr_utility.trace('l_ret '||l_ret);
1069: RETURN to_number(l_ret);
1070: --
1071: END get_table_value;
1072: --

Line 1106: hr_utility.trace('~~WC - '|| p_context);

1102: l_act_days NUMBER;
1103: --
1104: BEGIN
1105: --
1106: hr_utility.trace('~~WC - '|| p_context);
1107: l_total_days := 0;
1108: l_act_days := 0;
1109: l_tmp_days := 0;
1110: l_tmp_hours := 0;

Line 1113: hr_utility.trace('~~--Start Loop '|| i.Information_1);

1109: l_tmp_days := 0;
1110: l_tmp_hours := 0;
1111: FOR i IN csr_get_context_info(p_work_center,p_context,p_period_start_date,p_period_end_date) LOOP
1112: l_days := 0;
1113: hr_utility.trace('~~--Start Loop '|| i.Information_1);
1114: hr_utility.trace('~~----Start Date '|| i.Information_1);
1115: hr_utility.trace('~~----End Date'|| i.Information_2);
1116: IF i.Information_1 > p_period_end_date THEN
1117: hr_utility.trace('~~Total Days '|| l_total_days);

Line 1114: hr_utility.trace('~~----Start Date '|| i.Information_1);

1110: l_tmp_hours := 0;
1111: FOR i IN csr_get_context_info(p_work_center,p_context,p_period_start_date,p_period_end_date) LOOP
1112: l_days := 0;
1113: hr_utility.trace('~~--Start Loop '|| i.Information_1);
1114: hr_utility.trace('~~----Start Date '|| i.Information_1);
1115: hr_utility.trace('~~----End Date'|| i.Information_2);
1116: IF i.Information_1 > p_period_end_date THEN
1117: hr_utility.trace('~~Total Days '|| l_total_days);
1118: RETURN ROUND(l_total_days);

Line 1115: hr_utility.trace('~~----End Date'|| i.Information_2);

1111: FOR i IN csr_get_context_info(p_work_center,p_context,p_period_start_date,p_period_end_date) LOOP
1112: l_days := 0;
1113: hr_utility.trace('~~--Start Loop '|| i.Information_1);
1114: hr_utility.trace('~~----Start Date '|| i.Information_1);
1115: hr_utility.trace('~~----End Date'|| i.Information_2);
1116: IF i.Information_1 > p_period_end_date THEN
1117: hr_utility.trace('~~Total Days '|| l_total_days);
1118: RETURN ROUND(l_total_days);
1119: END IF;

Line 1117: hr_utility.trace('~~Total Days '|| l_total_days);

1113: hr_utility.trace('~~--Start Loop '|| i.Information_1);
1114: hr_utility.trace('~~----Start Date '|| i.Information_1);
1115: hr_utility.trace('~~----End Date'|| i.Information_2);
1116: IF i.Information_1 > p_period_end_date THEN
1117: hr_utility.trace('~~Total Days '|| l_total_days);
1118: RETURN ROUND(l_total_days);
1119: END IF;
1120: IF i.Information_2 >= p_period_start_date THEN
1121: --l_act_days := LEAST(p_period_end_date,i.Information_2)-GREATEST(p_period_start_date,i.Information_1) + 1;

Line 1142: hr_utility.trace('~~----l_days '|| l_days);

1138: -- to handle 28 days
1139: IF l_days = l_act_days THEN
1140: l_days := p_tot_days;
1141: END IF;
1142: hr_utility.trace('~~----l_days '|| l_days);
1143: IF p_context = 'ES_WC_PARTIAL_UNEMPLOYMENT' THEN
1144: hr_utility.trace('~~----PU Percentage '|| i.Information_3);
1145: l_days := l_days * fnd_number.canonical_to_number(i.Information_3)/100;
1146: END IF;

Line 1144: hr_utility.trace('~~----PU Percentage '|| i.Information_3);

1140: l_days := p_tot_days;
1141: END IF;
1142: hr_utility.trace('~~----l_days '|| l_days);
1143: IF p_context = 'ES_WC_PARTIAL_UNEMPLOYMENT' THEN
1144: hr_utility.trace('~~----PU Percentage '|| i.Information_3);
1145: l_days := l_days * fnd_number.canonical_to_number(i.Information_3)/100;
1146: END IF;
1147: END IF;
1148: l_total_days := l_total_days + l_days;

Line 1150: hr_utility.trace('~~Total Days '|| l_total_days);

1146: END IF;
1147: END IF;
1148: l_total_days := l_total_days + l_days;
1149: END LOOP;
1150: hr_utility.trace('~~Total Days '|| l_total_days);
1151: RETURN l_total_days;
1152: --
1153: END get_org_context_info;
1154: --

Line 1462: hr_utility.trace('~~RETRUN GIndex'||GIndex);

1458: IF GIndex = 0 and cac_epigraph_change.LAST <> 0 THEN
1459: GIndex := 1;
1460: END IF;
1461: IF NOT cac_epigraph_change.exists(GIndex) THEN
1462: hr_utility.trace('~~RETRUN GIndex'||GIndex);
1463: RETURN -1;
1464: END IF;
1465:
1466: p_epigraph := cac_epigraph_change(GIndex).epigraph;

Line 1484: hr_utility.trace('~~Read PL/SQl Tablep_epigraph '||p_epigraph);

1480: p_tot_days := cac_epigraph_change(GIndex).Tot_Days;
1481: p_pu_days := cac_epigraph_change(GIndex).PU_Days;
1482: p_curr_index := GIndex;
1483:
1484: hr_utility.trace('~~Read PL/SQl Tablep_epigraph '||p_epigraph);
1485: hr_utility.trace('~~--p_epigraph '||p_epigraph);
1486: hr_utility.trace('~~--p_epigraph_114 '||p_epigraph_114);
1487: hr_utility.trace('~~--p_epigraph_126 '||p_epigraph_126);
1488: hr_utility.trace('~~--p_start_date '||p_start_date);

Line 1485: hr_utility.trace('~~--p_epigraph '||p_epigraph);

1481: p_pu_days := cac_epigraph_change(GIndex).PU_Days;
1482: p_curr_index := GIndex;
1483:
1484: hr_utility.trace('~~Read PL/SQl Tablep_epigraph '||p_epigraph);
1485: hr_utility.trace('~~--p_epigraph '||p_epigraph);
1486: hr_utility.trace('~~--p_epigraph_114 '||p_epigraph_114);
1487: hr_utility.trace('~~--p_epigraph_126 '||p_epigraph_126);
1488: hr_utility.trace('~~--p_start_date '||p_start_date);
1489: hr_utility.trace('~~--p_end_date '||p_end_date);

Line 1486: hr_utility.trace('~~--p_epigraph_114 '||p_epigraph_114);

1482: p_curr_index := GIndex;
1483:
1484: hr_utility.trace('~~Read PL/SQl Tablep_epigraph '||p_epigraph);
1485: hr_utility.trace('~~--p_epigraph '||p_epigraph);
1486: hr_utility.trace('~~--p_epigraph_114 '||p_epigraph_114);
1487: hr_utility.trace('~~--p_epigraph_126 '||p_epigraph_126);
1488: hr_utility.trace('~~--p_start_date '||p_start_date);
1489: hr_utility.trace('~~--p_end_date '||p_end_date);
1490: hr_utility.trace('~~--p_no_ptm_days '||p_no_ptm_days);

Line 1487: hr_utility.trace('~~--p_epigraph_126 '||p_epigraph_126);

1483:
1484: hr_utility.trace('~~Read PL/SQl Tablep_epigraph '||p_epigraph);
1485: hr_utility.trace('~~--p_epigraph '||p_epigraph);
1486: hr_utility.trace('~~--p_epigraph_114 '||p_epigraph_114);
1487: hr_utility.trace('~~--p_epigraph_126 '||p_epigraph_126);
1488: hr_utility.trace('~~--p_start_date '||p_start_date);
1489: hr_utility.trace('~~--p_end_date '||p_end_date);
1490: hr_utility.trace('~~--p_no_ptm_days '||p_no_ptm_days);
1491: IF cac_epigraph_change(GIndex).cac = 0 THEN

Line 1488: hr_utility.trace('~~--p_start_date '||p_start_date);

1484: hr_utility.trace('~~Read PL/SQl Tablep_epigraph '||p_epigraph);
1485: hr_utility.trace('~~--p_epigraph '||p_epigraph);
1486: hr_utility.trace('~~--p_epigraph_114 '||p_epigraph_114);
1487: hr_utility.trace('~~--p_epigraph_126 '||p_epigraph_126);
1488: hr_utility.trace('~~--p_start_date '||p_start_date);
1489: hr_utility.trace('~~--p_end_date '||p_end_date);
1490: hr_utility.trace('~~--p_no_ptm_days '||p_no_ptm_days);
1491: IF cac_epigraph_change(GIndex).cac = 0 THEN
1492: p_cac := '';

Line 1489: hr_utility.trace('~~--p_end_date '||p_end_date);

1485: hr_utility.trace('~~--p_epigraph '||p_epigraph);
1486: hr_utility.trace('~~--p_epigraph_114 '||p_epigraph_114);
1487: hr_utility.trace('~~--p_epigraph_126 '||p_epigraph_126);
1488: hr_utility.trace('~~--p_start_date '||p_start_date);
1489: hr_utility.trace('~~--p_end_date '||p_end_date);
1490: hr_utility.trace('~~--p_no_ptm_days '||p_no_ptm_days);
1491: IF cac_epigraph_change(GIndex).cac = 0 THEN
1492: p_cac := '';
1493: ELSE

Line 1490: hr_utility.trace('~~--p_no_ptm_days '||p_no_ptm_days);

1486: hr_utility.trace('~~--p_epigraph_114 '||p_epigraph_114);
1487: hr_utility.trace('~~--p_epigraph_126 '||p_epigraph_126);
1488: hr_utility.trace('~~--p_start_date '||p_start_date);
1489: hr_utility.trace('~~--p_end_date '||p_end_date);
1490: hr_utility.trace('~~--p_no_ptm_days '||p_no_ptm_days);
1491: IF cac_epigraph_change(GIndex).cac = 0 THEN
1492: p_cac := '';
1493: ELSE
1494: p_cac := cac_epigraph_change(GIndex).cac;

Line 1499: hr_utility.trace('~~RETURN GIndex'||GIndex);

1495: END IF;
1496: --
1497: IF GIndex = cac_epigraph_change.LAST THEN
1498: GIndex := 0;
1499: hr_utility.trace('~~RETURN GIndex'||GIndex);
1500: p_next_epigraph := 'x';
1501: p_next_cac := 'x';
1502: RETURN GIndex;
1503: END IF;

Line 1505: hr_utility.trace('~~RETURN GIndex'||GIndex);

1501: p_next_cac := 'x';
1502: RETURN GIndex;
1503: END IF;
1504: --
1505: hr_utility.trace('~~RETURN GIndex'||GIndex);
1506: GIndex := GIndex + 1;
1507: p_next_epigraph := cac_epigraph_change(GIndex).epigraph;
1508: p_next_cac := cac_epigraph_change(GIndex).cac;
1509: Return GIndex;

Line 1556: hr_utility.trace('~~RETRUN GIndex'||GIndex);

1552: --
1553: BEGIN
1554: --
1555: IF NOT cac_epigraph_change.exists(p_index) THEN
1556: hr_utility.trace('~~RETRUN GIndex'||GIndex);
1557: RETURN -1;
1558: END IF;
1559: --
1560: p_epigraph := cac_epigraph_change(p_index).epigraph;

Line 1685: hr_utility.trace('~~Entering pay_es_ss_calculation.get_prev_salary');

1681: l_days NUMBER;
1682: --
1683: BEGIN
1684: --
1685: hr_utility.trace('~~Entering pay_es_ss_calculation.get_prev_salary');
1686: l_def_bal_id := get_defined_bal_id(p_balance_name, p_database_item_suffix);
1687: l_days_def_bal_id := get_defined_bal_id('Social Security Days', p_database_item_suffix);
1688: hr_utility.trace('~~~~ p_balance_name'||p_balance_name);
1689: hr_utility.trace('~~~~ p_database_item_suffix'||p_database_item_suffix);

Line 1688: hr_utility.trace('~~~~ p_balance_name'||p_balance_name);

1684: --
1685: hr_utility.trace('~~Entering pay_es_ss_calculation.get_prev_salary');
1686: l_def_bal_id := get_defined_bal_id(p_balance_name, p_database_item_suffix);
1687: l_days_def_bal_id := get_defined_bal_id('Social Security Days', p_database_item_suffix);
1688: hr_utility.trace('~~~~ p_balance_name'||p_balance_name);
1689: hr_utility.trace('~~~~ p_database_item_suffix'||p_database_item_suffix);
1690: hr_utility.trace('~~~~ l_def_bal_id'||l_def_bal_id);
1691: l_amount := 0;
1692: l_amt := 0;

Line 1689: hr_utility.trace('~~~~ p_database_item_suffix'||p_database_item_suffix);

1685: hr_utility.trace('~~Entering pay_es_ss_calculation.get_prev_salary');
1686: l_def_bal_id := get_defined_bal_id(p_balance_name, p_database_item_suffix);
1687: l_days_def_bal_id := get_defined_bal_id('Social Security Days', p_database_item_suffix);
1688: hr_utility.trace('~~~~ p_balance_name'||p_balance_name);
1689: hr_utility.trace('~~~~ p_database_item_suffix'||p_database_item_suffix);
1690: hr_utility.trace('~~~~ l_def_bal_id'||l_def_bal_id);
1691: l_amount := 0;
1692: l_amt := 0;
1693: l_days := 0;

Line 1690: hr_utility.trace('~~~~ l_def_bal_id'||l_def_bal_id);

1686: l_def_bal_id := get_defined_bal_id(p_balance_name, p_database_item_suffix);
1687: l_days_def_bal_id := get_defined_bal_id('Social Security Days', p_database_item_suffix);
1688: hr_utility.trace('~~~~ p_balance_name'||p_balance_name);
1689: hr_utility.trace('~~~~ p_database_item_suffix'||p_database_item_suffix);
1690: hr_utility.trace('~~~~ l_def_bal_id'||l_def_bal_id);
1691: l_amount := 0;
1692: l_amt := 0;
1693: l_days := 0;
1694: l_ctr := 0;

Line 1705: hr_utility.trace('~~~~ Setting TAX_UNIT_ID Context '||l_legal_employer_id);

1701: OPEN get_legal_employer_id(to_number(p_context_val));
1702: FETCH get_legal_employer_id INTO l_legal_employer_id;
1703: CLOSE get_legal_employer_id;
1704: pay_balance_pkg.set_context('TAX_UNIT_ID', l_legal_employer_id);
1705: hr_utility.trace('~~~~ Setting TAX_UNIT_ID Context '||l_legal_employer_id);
1706: END IF;
1707: --
1708: hr_utility.trace('~~~~ Start loop p_period_start_date '||p_period_start_date);
1709: hr_utility.trace('~~~~ p_assignment_action_id '||p_assignment_action_id);

Line 1708: hr_utility.trace('~~~~ Start loop p_period_start_date '||p_period_start_date);

1704: pay_balance_pkg.set_context('TAX_UNIT_ID', l_legal_employer_id);
1705: hr_utility.trace('~~~~ Setting TAX_UNIT_ID Context '||l_legal_employer_id);
1706: END IF;
1707: --
1708: hr_utility.trace('~~~~ Start loop p_period_start_date '||p_period_start_date);
1709: hr_utility.trace('~~~~ p_assignment_action_id '||p_assignment_action_id);
1710: FOR i IN get_prev_periods_dates( p_assignment_action_id, p_period_start_date) LOOP
1711: --
1712: IF l_date = i.start_date AND l_days <> 0 AND l_amt <> 0 THEN

Line 1709: hr_utility.trace('~~~~ p_assignment_action_id '||p_assignment_action_id);

1705: hr_utility.trace('~~~~ Setting TAX_UNIT_ID Context '||l_legal_employer_id);
1706: END IF;
1707: --
1708: hr_utility.trace('~~~~ Start loop p_period_start_date '||p_period_start_date);
1709: hr_utility.trace('~~~~ p_assignment_action_id '||p_assignment_action_id);
1710: FOR i IN get_prev_periods_dates( p_assignment_action_id, p_period_start_date) LOOP
1711: --
1712: IF l_date = i.start_date AND l_days <> 0 AND l_amt <> 0 THEN
1713: NULL;

Line 1720: hr_utility.trace('~~~~ Inside loop p_period_start_date '||p_period_start_date);

1716: l_ctr := l_ctr + 1;
1717: l_days := 0;
1718: l_amt := 0;
1719: END IF;
1720: hr_utility.trace('~~~~ Inside loop p_period_start_date '||p_period_start_date);
1721: hr_utility.trace('~~~~ p_assignment_action_id '||p_assignment_action_id);
1722: IF l_days = 0 THEN
1723: l_days := pay_balance_pkg.get_value(l_days_def_bal_id, i.assignment_action_id);
1724: END IF;

Line 1721: hr_utility.trace('~~~~ p_assignment_action_id '||p_assignment_action_id);

1717: l_days := 0;
1718: l_amt := 0;
1719: END IF;
1720: hr_utility.trace('~~~~ Inside loop p_period_start_date '||p_period_start_date);
1721: hr_utility.trace('~~~~ p_assignment_action_id '||p_assignment_action_id);
1722: IF l_days = 0 THEN
1723: l_days := pay_balance_pkg.get_value(l_days_def_bal_id, i.assignment_action_id);
1724: END IF;
1725: IF l_days <> 0 THEN

Line 1733: hr_utility.trace('~~~~ Inside loop start_date '||i.start_date);

1729: IF l_amt <> 0 THEN
1730: l_cnt := l_cnt + 1;
1731: END IF;
1732: END IF;
1733: hr_utility.trace('~~~~ Inside loop start_date '||i.start_date);
1734: hr_utility.trace('~~~~ assignment_action_id '||i.assignment_action_id);
1735: hr_utility.trace('~~~~ l_ctr '||l_ctr);
1736: hr_utility.trace('~~~~ l_cnt '||l_cnt);
1737: hr_utility.trace('~~~~ l_amt '||l_amt);

Line 1734: hr_utility.trace('~~~~ assignment_action_id '||i.assignment_action_id);

1730: l_cnt := l_cnt + 1;
1731: END IF;
1732: END IF;
1733: hr_utility.trace('~~~~ Inside loop start_date '||i.start_date);
1734: hr_utility.trace('~~~~ assignment_action_id '||i.assignment_action_id);
1735: hr_utility.trace('~~~~ l_ctr '||l_ctr);
1736: hr_utility.trace('~~~~ l_cnt '||l_cnt);
1737: hr_utility.trace('~~~~ l_amt '||l_amt);
1738: hr_utility.trace('~~~~ l_days '||l_days);

Line 1735: hr_utility.trace('~~~~ l_ctr '||l_ctr);

1731: END IF;
1732: END IF;
1733: hr_utility.trace('~~~~ Inside loop start_date '||i.start_date);
1734: hr_utility.trace('~~~~ assignment_action_id '||i.assignment_action_id);
1735: hr_utility.trace('~~~~ l_ctr '||l_ctr);
1736: hr_utility.trace('~~~~ l_cnt '||l_cnt);
1737: hr_utility.trace('~~~~ l_amt '||l_amt);
1738: hr_utility.trace('~~~~ l_days '||l_days);
1739: hr_utility.trace('~~~~ l_amount '||l_amount);

Line 1736: hr_utility.trace('~~~~ l_cnt '||l_cnt);

1732: END IF;
1733: hr_utility.trace('~~~~ Inside loop start_date '||i.start_date);
1734: hr_utility.trace('~~~~ assignment_action_id '||i.assignment_action_id);
1735: hr_utility.trace('~~~~ l_ctr '||l_ctr);
1736: hr_utility.trace('~~~~ l_cnt '||l_cnt);
1737: hr_utility.trace('~~~~ l_amt '||l_amt);
1738: hr_utility.trace('~~~~ l_days '||l_days);
1739: hr_utility.trace('~~~~ l_amount '||l_amount);
1740: hr_utility.trace('~~~~ p_ss_days '||p_ss_days);

Line 1737: hr_utility.trace('~~~~ l_amt '||l_amt);

1733: hr_utility.trace('~~~~ Inside loop start_date '||i.start_date);
1734: hr_utility.trace('~~~~ assignment_action_id '||i.assignment_action_id);
1735: hr_utility.trace('~~~~ l_ctr '||l_ctr);
1736: hr_utility.trace('~~~~ l_cnt '||l_cnt);
1737: hr_utility.trace('~~~~ l_amt '||l_amt);
1738: hr_utility.trace('~~~~ l_days '||l_days);
1739: hr_utility.trace('~~~~ l_amount '||l_amount);
1740: hr_utility.trace('~~~~ p_ss_days '||p_ss_days);
1741: hr_utility.trace('~~~~ p_no_month '||p_no_month);

Line 1738: hr_utility.trace('~~~~ l_days '||l_days);

1734: hr_utility.trace('~~~~ assignment_action_id '||i.assignment_action_id);
1735: hr_utility.trace('~~~~ l_ctr '||l_ctr);
1736: hr_utility.trace('~~~~ l_cnt '||l_cnt);
1737: hr_utility.trace('~~~~ l_amt '||l_amt);
1738: hr_utility.trace('~~~~ l_days '||l_days);
1739: hr_utility.trace('~~~~ l_amount '||l_amount);
1740: hr_utility.trace('~~~~ p_ss_days '||p_ss_days);
1741: hr_utility.trace('~~~~ p_no_month '||p_no_month);
1742: IF (l_days <> 0)OR p_flag = 'N' THEN

Line 1739: hr_utility.trace('~~~~ l_amount '||l_amount);

1735: hr_utility.trace('~~~~ l_ctr '||l_ctr);
1736: hr_utility.trace('~~~~ l_cnt '||l_cnt);
1737: hr_utility.trace('~~~~ l_amt '||l_amt);
1738: hr_utility.trace('~~~~ l_days '||l_days);
1739: hr_utility.trace('~~~~ l_amount '||l_amount);
1740: hr_utility.trace('~~~~ p_ss_days '||p_ss_days);
1741: hr_utility.trace('~~~~ p_no_month '||p_no_month);
1742: IF (l_days <> 0)OR p_flag = 'N' THEN
1743: p_days := p_days + last_day(i.start_date) - last_day(add_months(i.start_date,-1));

Line 1740: hr_utility.trace('~~~~ p_ss_days '||p_ss_days);

1736: hr_utility.trace('~~~~ l_cnt '||l_cnt);
1737: hr_utility.trace('~~~~ l_amt '||l_amt);
1738: hr_utility.trace('~~~~ l_days '||l_days);
1739: hr_utility.trace('~~~~ l_amount '||l_amount);
1740: hr_utility.trace('~~~~ p_ss_days '||p_ss_days);
1741: hr_utility.trace('~~~~ p_no_month '||p_no_month);
1742: IF (l_days <> 0)OR p_flag = 'N' THEN
1743: p_days := p_days + last_day(i.start_date) - last_day(add_months(i.start_date,-1));
1744: END IF;

Line 1741: hr_utility.trace('~~~~ p_no_month '||p_no_month);

1737: hr_utility.trace('~~~~ l_amt '||l_amt);
1738: hr_utility.trace('~~~~ l_days '||l_days);
1739: hr_utility.trace('~~~~ l_amount '||l_amount);
1740: hr_utility.trace('~~~~ p_ss_days '||p_ss_days);
1741: hr_utility.trace('~~~~ p_no_month '||p_no_month);
1742: IF (l_days <> 0)OR p_flag = 'N' THEN
1743: p_days := p_days + last_day(i.start_date) - last_day(add_months(i.start_date,-1));
1744: END IF;
1745: IF l_ctr >= p_no_month THEN

Line 1754: hr_utility.trace('~~Exiting pay_es_ss_calculation.get_prev_salary');

1750: END IF;
1751: END IF;
1752: END IF;
1753: END LOOP;
1754: hr_utility.trace('~~Exiting pay_es_ss_calculation.get_prev_salary');
1755: RETURN l_amount;
1756: --
1757: END get_prev_base;
1758: --