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 609: RETURN fnd_number.canonical_to_number(l_part_time_perc);

605: END IF;
606: ELSIF g_ptp_formula_exists = FALSE THEN
607: l_part_time_perc := NULL;
608: END IF;
609: RETURN fnd_number.canonical_to_number(l_part_time_perc);
610: END get_part_time_perc;
611: -------------------------------------------------------------------------------
612: -- Function : get_standard_si_part_time_perc
613: -- To get the Standard SI Part time Percentage using

Line 683: RETURN fnd_number.canonical_to_number(l_part_time_perc);

679: END IF;
680: ELSIF g_std_ptp_formula_exists = FALSE THEN
681: l_part_time_perc := NULL;
682: END IF;
683: RETURN fnd_number.canonical_to_number(l_part_time_perc);
684: END get_standard_si_part_time_perc;
685: -------------------------------------------------------------------------------
686: -- Function : get_pseudo_si_part_time_perc
687: -- To get the Pseudo SI Part time Percentage using

Line 757: RETURN fnd_number.canonical_to_number(l_part_time_perc);

753: END IF;
754: ELSIF g_pse_ptp_formula_exists = FALSE THEN
755: l_part_time_perc := NULL;
756: END IF;
757: RETURN fnd_number.canonical_to_number(l_part_time_perc);
758: END get_pseudo_si_part_time_perc;
759: -------------------------------------------------------------------------------
760: -- Function : get_std_si_rep_part_time_perc
761: -- To get the Standard SI Part time Percentage for Reporting using

Line 830: RETURN fnd_number.canonical_to_number(l_part_time_perc);

826: END IF;
827: ELSIF g_std_rep_ptp_formula_exists = FALSE THEN
828: l_part_time_perc := NULL;
829: END IF;
830: RETURN fnd_number.canonical_to_number(l_part_time_perc);
831: END get_std_si_rep_part_time_perc;
832: -------------------------------------------------------------------------------
833: -- Function : get_pse_si_rep_part_time_perc
834: -- To get the Pseudo SI Part time Percentage for reporting using

Line 903: RETURN fnd_number.canonical_to_number(l_part_time_perc);

899: END IF;
900: ELSIF g_pse_rep_ptp_formula_exists = FALSE THEN
901: l_part_time_perc := NULL;
902: END IF;
903: RETURN fnd_number.canonical_to_number(l_part_time_perc);
904: END get_pse_si_rep_part_time_perc;
905: /* This Function returns the day of the week.
906: Sunday is considered to be the first day of the week*/
907: FUNCTION get_day_of_week(p_date date)

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

930: csr_get_part_time_per( p_assignment_id per_all_assignments_f.assignment_id%type,
931: p_period_start_date DATE ,
932: p_period_end_date DATE
933: ) IS
934: SELECT FND_NUMBER.CANONICAL_TO_NUMBER(hs.segment29) segment29 ,
935: pas.effective_start_date effective_start_date,
936: pas.effective_end_date effective_end_date
937: FROM
938: hr_soft_coding_keyflex hs ,

Line 1045: RETURN fnd_number.canonical_to_number(l_real_si_days);

1041: END IF;
1042: ELSIF g_real_si_days_formula_exists = FALSE THEN
1043: l_real_si_days := NULL;
1044: END IF;
1045: RETURN fnd_number.canonical_to_number(l_real_si_days);
1046: END get_real_si_days;
1047:
1048:
1049: Function IsLeapYear(p_year NUMBER) RETURN NUMBER IS

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

1070: csr_get_ind_work_hrs( p_assignment_id per_all_assignments_f.assignment_id%type,
1071: p_period_start_date DATE ,
1072: p_period_end_date DATE
1073: ) IS
1074: SELECT FND_NUMBER.CANONICAL_TO_NUMBER(scl.segment28) segment28 ,
1075: paa.frequency ,
1076: paa.effective_start_date effective_start_date,
1077: paa.effective_end_date effective_end_date
1078: FROM

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

1203:
1204:
1205: l_period_type := pay_nl_si_pkg.get_payroll_type(p_payroll_id);
1206: IF l_period_type = 'Calendar Month' THEN
1207: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_MONTHLY'));
1208: END IF;
1209: IF l_period_type = 'Week' THEN
1210: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_WEEKLY'));
1211: END IF;

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

1206: IF l_period_type = 'Calendar Month' THEN
1207: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_MONTHLY'));
1208: END IF;
1209: IF l_period_type = 'Week' THEN
1210: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_WEEKLY'));
1211: END IF;
1212: IF l_period_type = 'Quarter' THEN
1213: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_QUARTERLY'));
1214: END IF;

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

1209: IF l_period_type = 'Week' THEN
1210: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_WEEKLY'));
1211: END IF;
1212: IF l_period_type = 'Quarter' THEN
1213: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_QUARTERLY'));
1214: END IF;
1215: IF l_period_type = 'Lunar Month' THEN
1216: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_4WEEKLY'));
1217: END IF;

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

1212: IF l_period_type = 'Quarter' THEN
1213: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_QUARTERLY'));
1214: END IF;
1215: IF l_period_type = 'Lunar Month' THEN
1216: Average_SI_days:= fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_4WEEKLY'));
1217: END IF;
1218: IF l_asg_start_date > l_period_start_date THEN
1219: Total_Days := fffunc.days_between(l_period_end_date, l_period_start_date) + 1;
1220: IF l_Asg_End_Date < l_period_end_date THEN

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

1390: IF p_real_si_days > l_avail_real_si_days THEN
1391: p_ret_real_si_days := l_avail_real_si_days;
1392: END IF;
1393: END IF;
1394: l_si_avg_days_yr := fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_YEARLY'));
1395: IF p_override_real_si_days = -1 THEN
1396: 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;
1397: IF l_cum_real_si_days > l_si_avg_days_yr THEN
1398: p_ret_real_si_days := p_ret_real_si_days - (l_cum_real_si_days - l_si_avg_days_yr);

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

1445:
1446: Period_Start_Date := GREATEST( l_period_start_date , l_asg_start_date);
1447: Period_End_Date := LEAST( l_period_end_date , l_asg_end_date );
1448:
1449: l_avg_si_days_monthly := fnd_number.canonical_to_number(pay_nl_general.get_global_value(p_effective_date,'NL_SI_AVERAGE_DAYS_MONTHLY'));
1450:
1451: IF (p_calc_code = 0 OR p_calc_code =1 OR p_calc_code = 3 ) then
1452:
1453: Threshold_or_Max_SI := p_si_days * to_number(p_thre_max_si);

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

1777: p_formula_name => g_si_days_formula_name,
1778: p_inputs => l_inputs,
1779: p_outputs => l_outputs);
1780: --
1781: g_si_days := fnd_number.canonical_to_number(l_outputs(1).value);
1782: g_tax_proration_days := fnd_number.canonical_to_number(l_outputs(1).value);
1783: g_tax_proration_flag := l_outputs(2).value;
1784: g_si_days_zvw := fnd_number.canonical_to_number(l_outputs(3).value);
1785: ELSE

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

1778: p_inputs => l_inputs,
1779: p_outputs => l_outputs);
1780: --
1781: g_si_days := fnd_number.canonical_to_number(l_outputs(1).value);
1782: g_tax_proration_days := fnd_number.canonical_to_number(l_outputs(1).value);
1783: g_tax_proration_flag := l_outputs(2).value;
1784: g_si_days_zvw := fnd_number.canonical_to_number(l_outputs(3).value);
1785: ELSE
1786: g_si_days := '-1';

Line 1784: g_si_days_zvw := fnd_number.canonical_to_number(l_outputs(3).value);

1780: --
1781: g_si_days := fnd_number.canonical_to_number(l_outputs(1).value);
1782: g_tax_proration_days := fnd_number.canonical_to_number(l_outputs(1).value);
1783: g_tax_proration_flag := l_outputs(2).value;
1784: g_si_days_zvw := fnd_number.canonical_to_number(l_outputs(3).value);
1785: ELSE
1786: g_si_days := '-1';
1787: g_tax_proration_days := '-1';
1788: g_tax_proration_flag := 'X';

Line 1797: RETURN fnd_number.canonical_to_number(g_si_days);

1793: g_tax_proration_days := '-1';
1794: g_tax_proration_flag := 'X';
1795: g_si_days_zvw := '-1';
1796: END IF;
1797: RETURN fnd_number.canonical_to_number(g_si_days);
1798:
1799: END get_override_si_days;
1800:
1801:

Line 1818: RETURN fnd_number.canonical_to_number(g_si_days_zvw);

1814: RETURN NUMBER IS
1815: l_override_si_days varchar2(35);
1816: BEGIN
1817: IF g_assignment_id = p_assignment_id THEN
1818: RETURN fnd_number.canonical_to_number(g_si_days_zvw);
1819: ELSE
1820: l_override_si_days := get_override_si_days
1821: ( p_assignment_id
1822: ,p_date_earned

Line 1828: RETURN fnd_number.canonical_to_number(g_si_days_zvw);

1824: ,p_assignment_action_id
1825: ,p_payroll_action_id
1826: );
1827: g_assignment_id := p_assignment_id;
1828: RETURN fnd_number.canonical_to_number(g_si_days_zvw);
1829: END IF;
1830: END get_override_si_days_zvw;
1831:
1832:

Line 1849: RETURN fnd_number.canonical_to_number(g_tax_proration_days);

1845: RETURN number IS
1846: l_override_si_days varchar2(35);
1847: BEGIN
1848: IF g_assignment_id = p_assignment_id THEN
1849: RETURN fnd_number.canonical_to_number(g_tax_proration_days);
1850: ELSE
1851: l_override_si_days := get_override_si_days
1852: ( p_assignment_id
1853: ,p_date_earned

Line 1859: RETURN fnd_number.canonical_to_number(g_tax_proration_days);

1855: ,p_assignment_action_id
1856: ,p_payroll_action_id
1857: );
1858: g_assignment_id := p_assignment_id;
1859: RETURN fnd_number.canonical_to_number(g_tax_proration_days);
1860: END IF;
1861: END get_tax_proration_days;
1862:
1863: -----------------------------------------------------------------------------------------------