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 569: 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);

565: CLOSE csr_get_pay_action_id;
566: --
567: IF g_ptp_formula_exists = TRUE THEN
568: IF g_ptp_formula_cached = FALSE THEN
569: 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);
570: g_ptp_formula_exists:=l_formula_exists;
571: g_ptp_formula_cached:=l_formula_cached;
572: g_ptp_formula_id:=l_formula_id;
573: END IF;

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

589: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
590: --
591: l_outputs(1).name := 'PART_TIME_PERCENTAGE';
592: --
593: pay_nl_general.run_formula(p_formula_id => g_ptp_formula_id,
594: p_effective_date => p_date_earned,
595: p_formula_name => g_ptp_formula_name,
596: p_inputs => l_inputs,
597: p_outputs => l_outputs);

Line 643: 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);

639: --
640:
641: IF g_std_ptp_formula_exists = TRUE THEN
642: IF g_std_ptp_formula_cached = FALSE THEN
643: 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);
644: g_std_ptp_formula_exists:=l_formula_exists;
645: g_std_ptp_formula_cached:=l_formula_cached;
646: g_std_ptp_formula_id:=l_formula_id;
647: END IF;

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

663: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
664: --
665: l_outputs(1).name := 'STANDARD_SI_PART_TIME_PERCENTAGE';
666: --
667: pay_nl_general.run_formula(p_formula_id => g_std_ptp_formula_id,
668: p_effective_date => p_date_earned,
669: p_formula_name => g_std_ptp_formula_name,
670: p_inputs => l_inputs,
671: p_outputs => l_outputs);

Line 717: 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);

713: --
714:
715: IF g_pse_ptp_formula_exists = TRUE THEN
716: IF g_pse_ptp_formula_cached = FALSE THEN
717: 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);
718: g_pse_ptp_formula_exists:=l_formula_exists;
719: g_pse_ptp_formula_cached:=l_formula_cached;
720: g_pse_ptp_formula_id:=l_formula_id;
721: END IF;

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

737: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
738: --
739: l_outputs(1).name := 'PSEUDO_SI_PART_TIME_PERCENTAGE';
740: --
741: pay_nl_general.run_formula(p_formula_id => g_pse_ptp_formula_id,
742: p_effective_date => p_date_earned,
743: p_formula_name => g_pse_ptp_formula_name,
744: p_inputs => l_inputs,
745: p_outputs => l_outputs);

Line 790: 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);

786: CLOSE csr_get_pay_action_id;
787: --
788: IF g_std_rep_ptp_formula_exists = TRUE THEN
789: IF g_std_rep_ptp_formula_cached = FALSE THEN
790: 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);
791: g_std_rep_ptp_formula_exists:=l_formula_exists;
792: g_std_rep_ptp_formula_cached:=l_formula_cached;
793: g_std_rep_ptp_formula_id:=l_formula_id;
794: END IF;

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

810: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
811: --
812: l_outputs(1).name := 'STANDARD_SI_REPORTING_PART_TIME_PERCENTAGE';
813: --
814: pay_nl_general.run_formula(p_formula_id => g_std_rep_ptp_formula_id,
815: p_effective_date => p_date_earned,
816: p_formula_name => g_std_rep_ptp_formula_name,
817: p_inputs => l_inputs,
818: p_outputs => l_outputs);

Line 863: 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);

859: CLOSE csr_get_pay_action_id;
860: --
861: IF g_pse_rep_ptp_formula_exists = TRUE THEN
862: IF g_pse_rep_ptp_formula_cached = FALSE THEN
863: 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);
864: g_pse_rep_ptp_formula_exists:=l_formula_exists;
865: g_pse_rep_ptp_formula_cached:=l_formula_cached;
866: g_pse_rep_ptp_formula_id:=l_formula_id;
867: END IF;

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

883: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
884: --
885: l_outputs(1).name := 'PSEUDO_SI_REPORTING_PART_TIME_PERCENTAGE';
886: --
887: pay_nl_general.run_formula(p_formula_id => g_pse_rep_ptp_formula_id,
888: p_effective_date => p_date_earned,
889: p_formula_name => g_pse_rep_ptp_formula_name,
890: p_inputs => l_inputs,
891: p_outputs => l_outputs);

Line 959: a := PAY_NL_GENERAL.get_period_asg_dates

955: l_period_days NUMBER := 0;
956: l_part_time_percentage NUMBER := 0;
957: a NUMBER;
958: BEGIN
959: a := PAY_NL_GENERAL.get_period_asg_dates
960: ( p_assignment_id => p_assignment_id
961: , p_period_start_date => p_period_start_date
962: , p_period_end_date => p_period_end_date
963: , p_asg_start_date => l_asg_start_date

Line 1009: 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);

1005: BEGIN
1006: g_real_si_days_formula_name := 'NL_REAL_SOCIAL_INSURANCE_DAYS';
1007: IF g_real_si_days_formula_exists = TRUE THEN
1008: IF g_real_si_days_formula_cached = FALSE THEN
1009: 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);
1010: g_real_si_days_formula_exists:=l_formula_exists;
1011: g_real_si_days_formula_cached:=l_formula_cached;
1012: g_real_si_days_formula_id:=l_formula_id;
1013: END IF;

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

1028: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
1029: --
1030: l_outputs(1).name := 'REAL_SOCIAL_INSURANCE_DAYS';
1031: --
1032: pay_nl_general.run_formula(p_formula_id => g_real_si_days_formula_id,
1033: p_effective_date => p_date_earned,
1034: p_formula_name => g_real_si_days_formula_name,
1035: p_inputs => l_inputs,
1036: p_outputs => l_outputs);

Line 1110: l_temp := PAY_NL_GENERAL.get_period_asg_dates

1106: BEGIN
1107:
1108: l_mon_days := ( p_period_end_date - p_period_start_date )+ 1;
1109:
1110: l_temp := PAY_NL_GENERAL.get_period_asg_dates
1111: ( p_assignment_id => p_assignment_id
1112: , p_period_start_date => p_period_start_date
1113: , p_period_end_date => p_period_end_date
1114: , p_asg_start_date => l_asg_start_date

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

1197:
1198: OPEN get_payroll_period(p_payroll_id,p_effective_date);
1199: FETCH get_payroll_period INTO l_period_start_date, l_period_end_date;
1200: CLOSE get_payroll_period;
1201: l_number := pay_nl_general.get_period_asg_dates (p_assignment_id ,l_period_start_date ,l_period_end_date
1202: ,l_asg_start_date , l_asg_end_date );
1203:
1204:
1205: l_period_type := pay_nl_si_pkg.get_payroll_type(p_payroll_id);

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

1361: BEGIN
1362: OPEN get_payroll_period(p_payroll_id,p_effective_date);
1363: FETCH get_payroll_period INTO l_period_start_date, l_period_end_date;
1364: CLOSE get_payroll_period;
1365: l_number := pay_nl_general.get_period_asg_dates (p_assignment_id ,l_period_start_date ,l_period_end_date
1366: ,l_asg_start_date , l_asg_end_date );
1367:
1368:
1369: Period_Start_Date := GREATEST( l_period_start_date , l_asg_start_date);

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

1439:
1440: OPEN get_payroll_period(p_payroll_id,p_effective_date);
1441: FETCH get_payroll_period INTO l_period_start_date, l_period_end_date;
1442: CLOSE get_payroll_period;
1443: l_number := pay_nl_general.get_period_asg_dates (p_assignment_id ,l_period_start_date ,l_period_end_date
1444: ,l_asg_start_date , l_asg_end_date );
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 );

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 1750: 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);

1746: BEGIN
1747: g_si_days_formula_name := 'NL_OVERRIDE_SOCIAL_INSURANCE_DAYS';
1748: IF g_si_days_formula_exists = TRUE THEN
1749: IF g_si_days_formula_cached = FALSE THEN
1750: 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);
1751: g_si_days_formula_exists:=l_formula_exists;
1752: g_si_days_formula_cached:=l_formula_cached;
1753: g_si_days_formula_id:=l_formula_id;
1754: END IF;

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

1771: l_outputs(1).name := 'OVERRIDE_SOCIAL_INSURANCE_DAYS';
1772: l_outputs(2).name := 'PRORATION_FLAG';
1773: l_outputs(3).name := 'OVERRIDE_SOCIAL_INSURANCE_DAYS_ZVW';
1774: --
1775: pay_nl_general.run_formula(p_formula_id => g_si_days_formula_id,
1776: p_effective_date => p_date_earned,
1777: p_formula_name => g_si_days_formula_name,
1778: p_inputs => l_inputs,
1779: p_outputs => l_outputs);