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_NL_SI_PKG dependencies on FND_NUMBER

Line 592: RETURN fnd_number.canonical_to_number(l_part_time_perc);

588: END IF;
589: ELSIF g_ptp_formula_exists = FALSE THEN
590: l_part_time_perc := NULL;
591: END IF;
592: RETURN fnd_number.canonical_to_number(l_part_time_perc);
593: END get_part_time_perc;
594: -------------------------------------------------------------------------------
595: -- Function : get_standard_si_part_time_perc
596: -- To get the Standard SI Part time Percentage using

Line 666: RETURN fnd_number.canonical_to_number(l_part_time_perc);

662: END IF;
663: ELSIF g_std_ptp_formula_exists = FALSE THEN
664: l_part_time_perc := NULL;
665: END IF;
666: RETURN fnd_number.canonical_to_number(l_part_time_perc);
667: END get_standard_si_part_time_perc;
668: -------------------------------------------------------------------------------
669: -- Function : get_pseudo_si_part_time_perc
670: -- To get the Pseudo SI Part time Percentage using

Line 740: RETURN fnd_number.canonical_to_number(l_part_time_perc);

736: END IF;
737: ELSIF g_pse_ptp_formula_exists = FALSE THEN
738: l_part_time_perc := NULL;
739: END IF;
740: RETURN fnd_number.canonical_to_number(l_part_time_perc);
741: END get_pseudo_si_part_time_perc;
742: -------------------------------------------------------------------------------
743: -- Function : get_std_si_rep_part_time_perc
744: -- To get the Standard SI Part time Percentage for Reporting using

Line 813: RETURN fnd_number.canonical_to_number(l_part_time_perc);

809: END IF;
810: ELSIF g_std_rep_ptp_formula_exists = FALSE THEN
811: l_part_time_perc := NULL;
812: END IF;
813: RETURN fnd_number.canonical_to_number(l_part_time_perc);
814: END get_std_si_rep_part_time_perc;
815: -------------------------------------------------------------------------------
816: -- Function : get_pse_si_rep_part_time_perc
817: -- To get the Pseudo SI Part time Percentage for reporting using

Line 886: RETURN fnd_number.canonical_to_number(l_part_time_perc);

882: END IF;
883: ELSIF g_pse_rep_ptp_formula_exists = FALSE THEN
884: l_part_time_perc := NULL;
885: END IF;
886: RETURN fnd_number.canonical_to_number(l_part_time_perc);
887: END get_pse_si_rep_part_time_perc;
888: /* This Function returns the day of the week.
889: Sunday is considered to be the first day of the week*/
890: FUNCTION get_day_of_week(p_date date)

Line 917: SELECT FND_NUMBER.CANONICAL_TO_NUMBER(hs.segment29) segment29 ,

913: csr_get_part_time_per( p_assignment_id per_all_assignments_f.assignment_id%type,
914: p_period_start_date DATE ,
915: p_period_end_date DATE
916: ) IS
917: SELECT FND_NUMBER.CANONICAL_TO_NUMBER(hs.segment29) segment29 ,
918: pas.effective_start_date effective_start_date,
919: pas.effective_end_date effective_end_date
920: FROM
921: hr_soft_coding_keyflex hs ,

Line 1028: RETURN fnd_number.canonical_to_number(l_real_si_days);

1024: END IF;
1025: ELSIF g_real_si_days_formula_exists = FALSE THEN
1026: l_real_si_days := NULL;
1027: END IF;
1028: RETURN fnd_number.canonical_to_number(l_real_si_days);
1029: END get_real_si_days;
1030:
1031:
1032: Function IsLeapYear(p_year NUMBER) RETURN NUMBER IS

Line 1057: SELECT FND_NUMBER.CANONICAL_TO_NUMBER(scl.segment28) segment28 ,

1053: csr_get_ind_work_hrs( p_assignment_id per_all_assignments_f.assignment_id%type,
1054: p_period_start_date DATE ,
1055: p_period_end_date DATE
1056: ) IS
1057: SELECT FND_NUMBER.CANONICAL_TO_NUMBER(scl.segment28) segment28 ,
1058: paa.frequency ,
1059: paa.effective_start_date effective_start_date,
1060: paa.effective_end_date effective_end_date
1061: FROM

Line 1190: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_MONTHLY'));

1186:
1187:
1188: l_period_type := pay_nl_si_pkg.get_payroll_type(p_payroll_id);
1189: IF l_period_type = 'Calendar Month' THEN
1190: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_MONTHLY'));
1191: END IF;
1192: IF l_period_type = 'Week' THEN
1193: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_WEEKLY'));
1194: END IF;

Line 1193: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_WEEKLY'));

1189: IF l_period_type = 'Calendar Month' THEN
1190: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_MONTHLY'));
1191: END IF;
1192: IF l_period_type = 'Week' THEN
1193: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_WEEKLY'));
1194: END IF;
1195: IF l_period_type = 'Quarter' THEN
1196: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_QUARTERLY'));
1197: END IF;

Line 1196: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_QUARTERLY'));

1192: IF l_period_type = 'Week' THEN
1193: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_WEEKLY'));
1194: END IF;
1195: IF l_period_type = 'Quarter' THEN
1196: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_QUARTERLY'));
1197: END IF;
1198: IF l_period_type = 'Lunar Month' THEN
1199: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_4WEEKLY'));
1200: END IF;

Line 1199: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_4WEEKLY'));

1195: IF l_period_type = 'Quarter' THEN
1196: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_QUARTERLY'));
1197: END IF;
1198: IF l_period_type = 'Lunar Month' THEN
1199: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_4WEEKLY'));
1200: END IF;
1201: IF l_asg_start_date > l_period_start_date THEN
1202: Total_Days := fffunc.days_between(l_period_end_date, l_period_start_date) + 1;
1203: IF l_Asg_End_Date < l_period_end_date THEN

Line 1377: l_si_avg_days_yr := fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_YEARLY'));

1373: IF p_real_si_days > l_avail_real_si_days THEN
1374: p_ret_real_si_days := l_avail_real_si_days;
1375: END IF;
1376: END IF;
1377: l_si_avg_days_yr := fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_YEARLY'));
1378: IF p_override_real_si_days = -1 THEN
1379: l_cum_real_si_days := (p_real_si_sit_ytd - p_real_si_sit_ptd) + p_ret_real_si_days + p_ret_real_si_sit_ytd;
1380: IF l_cum_real_si_days > l_si_avg_days_yr THEN
1381: p_ret_real_si_days := p_ret_real_si_days - (l_cum_real_si_days - l_si_avg_days_yr);

Line 1432: l_avg_si_days_monthly := fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_MONTHLY'));

1428:
1429: Period_Start_Date := GREATEST( l_period_start_date , l_asg_start_date);
1430: Period_End_Date := LEAST( l_period_end_date , l_asg_end_date );
1431:
1432: l_avg_si_days_monthly := fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_MONTHLY'));
1433:
1434: IF (p_calc_code = 0 OR p_calc_code =1 OR p_calc_code = 3 ) then
1435:
1436: Threshold_or_Max_SI := p_si_days * to_number(p_thre_max_si);

Line 1763: g_si_days := fnd_number.canonical_to_number(l_outputs(1).value);

1759: p_formula_name => g_si_days_formula_name,
1760: p_inputs => l_inputs,
1761: p_outputs => l_outputs);
1762: --
1763: g_si_days := fnd_number.canonical_to_number(l_outputs(1).value);
1764: g_tax_proration_days := fnd_number.canonical_to_number(l_outputs(1).value);
1765: g_tax_proration_flag := l_outputs(2).value;
1766: ELSE
1767: g_si_days := '-1';

Line 1764: g_tax_proration_days := fnd_number.canonical_to_number(l_outputs(1).value);

1760: p_inputs => l_inputs,
1761: p_outputs => l_outputs);
1762: --
1763: g_si_days := fnd_number.canonical_to_number(l_outputs(1).value);
1764: g_tax_proration_days := fnd_number.canonical_to_number(l_outputs(1).value);
1765: g_tax_proration_flag := l_outputs(2).value;
1766: ELSE
1767: g_si_days := '-1';
1768: g_tax_proration_days := '-1';

Line 1776: RETURN fnd_number.canonical_to_number(g_si_days);

1772: g_si_days := '-1';
1773: g_tax_proration_days := '-1';
1774: g_tax_proration_flag := 'X';
1775: END IF;
1776: RETURN fnd_number.canonical_to_number(g_si_days);
1777:
1778: END get_override_si_days;
1779:
1780: -----------------------------------------------------------------------------------------------

Line 1796: RETURN fnd_number.canonical_to_number(g_tax_proration_days);

1792: RETURN number IS
1793: l_override_si_days varchar2(35);
1794: BEGIN
1795: IF g_assignment_id = p_assignment_id THEN
1796: RETURN fnd_number.canonical_to_number(g_tax_proration_days);
1797: ELSE
1798: l_override_si_days := get_override_si_days
1799: ( p_assignment_id
1800: ,p_date_earned

Line 1806: RETURN fnd_number.canonical_to_number(g_tax_proration_days);

1802: ,p_assignment_action_id
1803: ,p_payroll_action_id
1804: );
1805: g_assignment_id := p_assignment_id;
1806: RETURN fnd_number.canonical_to_number(g_tax_proration_days);
1807: END IF;
1808: END get_tax_proration_days;
1809:
1810: -----------------------------------------------------------------------------------------------