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 PAY_NL_GENERAL

Line 552: pay_nl_general.cache_formula('NL_PART_TIME_PERCENTAGE',p_business_group_id,p_date_earned,l_formula_id,l_formula_exists,l_formula_cached);

548: CLOSE csr_get_pay_action_id;
549: --
550: IF g_ptp_formula_exists = TRUE THEN
551: IF g_ptp_formula_cached = FALSE THEN
552: pay_nl_general.cache_formula('NL_PART_TIME_PERCENTAGE',p_business_group_id,p_date_earned,l_formula_id,l_formula_exists,l_formula_cached);
553: g_ptp_formula_exists:=l_formula_exists;
554: g_ptp_formula_cached:=l_formula_cached;
555: g_ptp_formula_id:=l_formula_id;
556: END IF;

Line 576: pay_nl_general.run_formula(p_formula_id => g_ptp_formula_id,

572: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
573: --
574: l_outputs(1).name := 'PART_TIME_PERCENTAGE';
575: --
576: pay_nl_general.run_formula(p_formula_id => g_ptp_formula_id,
577: p_effective_date => p_date_earned,
578: p_formula_name => g_ptp_formula_name,
579: p_inputs => l_inputs,
580: p_outputs => l_outputs);

Line 626: pay_nl_general.cache_formula('NL_STANDARD_SI_PART_TIME_PERCENTAGE',p_business_group_id,p_date_earned,l_formula_id,l_formula_exists,l_formula_cached);

622: --
623:
624: IF g_std_ptp_formula_exists = TRUE THEN
625: IF g_std_ptp_formula_cached = FALSE THEN
626: pay_nl_general.cache_formula('NL_STANDARD_SI_PART_TIME_PERCENTAGE',p_business_group_id,p_date_earned,l_formula_id,l_formula_exists,l_formula_cached);
627: g_std_ptp_formula_exists:=l_formula_exists;
628: g_std_ptp_formula_cached:=l_formula_cached;
629: g_std_ptp_formula_id:=l_formula_id;
630: END IF;

Line 650: pay_nl_general.run_formula(p_formula_id => g_std_ptp_formula_id,

646: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
647: --
648: l_outputs(1).name := 'STANDARD_SI_PART_TIME_PERCENTAGE';
649: --
650: pay_nl_general.run_formula(p_formula_id => g_std_ptp_formula_id,
651: p_effective_date => p_date_earned,
652: p_formula_name => g_std_ptp_formula_name,
653: p_inputs => l_inputs,
654: p_outputs => l_outputs);

Line 700: pay_nl_general.cache_formula('NL_PSEUDO_SI_PART_TIME_PERCENTAGE',p_business_group_id,p_date_earned,l_formula_id,l_formula_exists,l_formula_cached);

696: --
697:
698: IF g_pse_ptp_formula_exists = TRUE THEN
699: IF g_pse_ptp_formula_cached = FALSE THEN
700: pay_nl_general.cache_formula('NL_PSEUDO_SI_PART_TIME_PERCENTAGE',p_business_group_id,p_date_earned,l_formula_id,l_formula_exists,l_formula_cached);
701: g_pse_ptp_formula_exists:=l_formula_exists;
702: g_pse_ptp_formula_cached:=l_formula_cached;
703: g_pse_ptp_formula_id:=l_formula_id;
704: END IF;

Line 724: pay_nl_general.run_formula(p_formula_id => g_pse_ptp_formula_id,

720: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
721: --
722: l_outputs(1).name := 'PSEUDO_SI_PART_TIME_PERCENTAGE';
723: --
724: pay_nl_general.run_formula(p_formula_id => g_pse_ptp_formula_id,
725: p_effective_date => p_date_earned,
726: p_formula_name => g_pse_ptp_formula_name,
727: p_inputs => l_inputs,
728: p_outputs => l_outputs);

Line 773: pay_nl_general.cache_formula('NL_STANDARD_SI_REPORTING_PART_TIME_PERCENTAGE',p_business_group_id,p_date_earned,l_formula_id,l_formula_exists,l_formula_cached);

769: CLOSE csr_get_pay_action_id;
770: --
771: IF g_std_rep_ptp_formula_exists = TRUE THEN
772: IF g_std_rep_ptp_formula_cached = FALSE THEN
773: pay_nl_general.cache_formula('NL_STANDARD_SI_REPORTING_PART_TIME_PERCENTAGE',p_business_group_id,p_date_earned,l_formula_id,l_formula_exists,l_formula_cached);
774: g_std_rep_ptp_formula_exists:=l_formula_exists;
775: g_std_rep_ptp_formula_cached:=l_formula_cached;
776: g_std_rep_ptp_formula_id:=l_formula_id;
777: END IF;

Line 797: pay_nl_general.run_formula(p_formula_id => g_std_rep_ptp_formula_id,

793: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
794: --
795: l_outputs(1).name := 'STANDARD_SI_REPORTING_PART_TIME_PERCENTAGE';
796: --
797: pay_nl_general.run_formula(p_formula_id => g_std_rep_ptp_formula_id,
798: p_effective_date => p_date_earned,
799: p_formula_name => g_std_rep_ptp_formula_name,
800: p_inputs => l_inputs,
801: p_outputs => l_outputs);

Line 846: pay_nl_general.cache_formula('NL_PSEUDO_SI_REPORTING_PART_TIME_PERCENTAGE',p_business_group_id,p_date_earned,l_formula_id,l_formula_exists,l_formula_cached);

842: CLOSE csr_get_pay_action_id;
843: --
844: IF g_pse_rep_ptp_formula_exists = TRUE THEN
845: IF g_pse_rep_ptp_formula_cached = FALSE THEN
846: pay_nl_general.cache_formula('NL_PSEUDO_SI_REPORTING_PART_TIME_PERCENTAGE',p_business_group_id,p_date_earned,l_formula_id,l_formula_exists,l_formula_cached);
847: g_pse_rep_ptp_formula_exists:=l_formula_exists;
848: g_pse_rep_ptp_formula_cached:=l_formula_cached;
849: g_pse_rep_ptp_formula_id:=l_formula_id;
850: END IF;

Line 870: pay_nl_general.run_formula(p_formula_id => g_pse_rep_ptp_formula_id,

866: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
867: --
868: l_outputs(1).name := 'PSEUDO_SI_REPORTING_PART_TIME_PERCENTAGE';
869: --
870: pay_nl_general.run_formula(p_formula_id => g_pse_rep_ptp_formula_id,
871: p_effective_date => p_date_earned,
872: p_formula_name => g_pse_rep_ptp_formula_name,
873: p_inputs => l_inputs,
874: p_outputs => l_outputs);

Line 942: a := PAY_NL_GENERAL.get_period_asg_dates

938: l_period_days NUMBER := 0;
939: l_part_time_percentage NUMBER := 0;
940: a NUMBER;
941: BEGIN
942: a := PAY_NL_GENERAL.get_period_asg_dates
943: ( p_assignment_id => p_assignment_id
944: , p_period_start_date => p_period_start_date
945: , p_period_end_date => p_period_end_date
946: , p_asg_start_date => l_asg_start_date

Line 992: pay_nl_general.cache_formula('NL_REAL_SOCIAL_INSURANCE_DAYS',p_business_group_id,p_date_earned,l_formula_id,l_formula_exists,l_formula_cached);

988: BEGIN
989: g_real_si_days_formula_name := 'NL_REAL_SOCIAL_INSURANCE_DAYS';
990: IF g_real_si_days_formula_exists = TRUE THEN
991: IF g_real_si_days_formula_cached = FALSE THEN
992: pay_nl_general.cache_formula('NL_REAL_SOCIAL_INSURANCE_DAYS',p_business_group_id,p_date_earned,l_formula_id,l_formula_exists,l_formula_cached);
993: g_real_si_days_formula_exists:=l_formula_exists;
994: g_real_si_days_formula_cached:=l_formula_cached;
995: g_real_si_days_formula_id:=l_formula_id;
996: END IF;

Line 1015: pay_nl_general.run_formula(p_formula_id => g_real_si_days_formula_id,

1011: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
1012: --
1013: l_outputs(1).name := 'REAL_SOCIAL_INSURANCE_DAYS';
1014: --
1015: pay_nl_general.run_formula(p_formula_id => g_real_si_days_formula_id,
1016: p_effective_date => p_date_earned,
1017: p_formula_name => g_real_si_days_formula_name,
1018: p_inputs => l_inputs,
1019: p_outputs => l_outputs);

Line 1093: l_temp := PAY_NL_GENERAL.get_period_asg_dates

1089: BEGIN
1090:
1091: l_mon_days := ( p_period_end_date - p_period_start_date )+ 1;
1092:
1093: l_temp := PAY_NL_GENERAL.get_period_asg_dates
1094: ( p_assignment_id => p_assignment_id
1095: , p_period_start_date => p_period_start_date
1096: , p_period_end_date => p_period_end_date
1097: , p_asg_start_date => l_asg_start_date

Line 1184: l_number := pay_nl_general.get_period_asg_dates (p_assignment_id ,l_period_start_date ,l_period_end_date

1180:
1181: OPEN get_payroll_period(p_payroll_id,p_effective_date);
1182: FETCH get_payroll_period INTO l_period_start_date, l_period_end_date;
1183: CLOSE get_payroll_period;
1184: l_number := pay_nl_general.get_period_asg_dates (p_assignment_id ,l_period_start_date ,l_period_end_date
1185: ,l_asg_start_date , l_asg_end_date );
1186:
1187:
1188: l_period_type := pay_nl_si_pkg.get_payroll_type(p_payroll_id);

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 1348: l_number := pay_nl_general.get_period_asg_dates (p_assignment_id ,l_period_start_date ,l_period_end_date

1344: BEGIN
1345: OPEN get_payroll_period(p_payroll_id,p_effective_date);
1346: FETCH get_payroll_period INTO l_period_start_date, l_period_end_date;
1347: CLOSE get_payroll_period;
1348: l_number := pay_nl_general.get_period_asg_dates (p_assignment_id ,l_period_start_date ,l_period_end_date
1349: ,l_asg_start_date , l_asg_end_date );
1350:
1351:
1352: Period_Start_Date := GREATEST( l_period_start_date , l_asg_start_date);

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 1426: l_number := pay_nl_general.get_period_asg_dates (p_assignment_id ,l_period_start_date ,l_period_end_date

1422:
1423: OPEN get_payroll_period(p_payroll_id,p_effective_date);
1424: FETCH get_payroll_period INTO l_period_start_date, l_period_end_date;
1425: CLOSE get_payroll_period;
1426: l_number := pay_nl_general.get_period_asg_dates (p_assignment_id ,l_period_start_date ,l_period_end_date
1427: ,l_asg_start_date , l_asg_end_date );
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 );

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 1733: pay_nl_general.cache_formula('NL_OVERRIDE_SOCIAL_INSURANCE_DAYS',p_business_group_id,p_date_earned,l_formula_id,l_formula_exists,l_formula_cached);

1729: BEGIN
1730: g_si_days_formula_name := 'NL_OVERRIDE_SOCIAL_INSURANCE_DAYS';
1731: IF g_si_days_formula_exists = TRUE THEN
1732: IF g_si_days_formula_cached = FALSE THEN
1733: pay_nl_general.cache_formula('NL_OVERRIDE_SOCIAL_INSURANCE_DAYS',p_business_group_id,p_date_earned,l_formula_id,l_formula_exists,l_formula_cached);
1734: g_si_days_formula_exists:=l_formula_exists;
1735: g_si_days_formula_cached:=l_formula_cached;
1736: g_si_days_formula_id:=l_formula_id;
1737: END IF;

Line 1757: pay_nl_general.run_formula(p_formula_id => g_si_days_formula_id,

1753: --
1754: l_outputs(1).name := 'OVERRIDE_SOCIAL_INSURANCE_DAYS';
1755: l_outputs(2).name := 'PRORATION_FLAG';
1756: --
1757: pay_nl_general.run_formula(p_formula_id => g_si_days_formula_id,
1758: p_effective_date => p_date_earned,
1759: p_formula_name => g_si_days_formula_name,
1760: p_inputs => l_inputs,
1761: p_outputs => l_outputs);