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_DK_STATSR_PKG dependencies on PAY_DK_STATSR_PKG

Line 1: PACKAGE BODY PAY_DK_STATSR_PKG AS

1: PACKAGE BODY PAY_DK_STATSR_PKG AS
2: /* $Header: pydkstatsr.pkb 120.11.12000000.6 2007/06/08 11:49:28 nprasath noship $ */
3:
4: --Global parameters
5: g_package CONSTANT varchar2(33) := 'PAY_DK_STATSR_PKG.';

Line 5: g_package CONSTANT varchar2(33) := 'PAY_DK_STATSR_PKG.';

1: PACKAGE BODY PAY_DK_STATSR_PKG AS
2: /* $Header: pydkstatsr.pkb 120.11.12000000.6 2007/06/08 11:49:28 nprasath noship $ */
3:
4: --Global parameters
5: g_package CONSTANT varchar2(33) := 'PAY_DK_STATSR_PKG.';
6: g_debug BOOLEAN := hr_utility.debug_enabled;
7: g_err_num NUMBER;
8:
9:

Line 95: PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')

91: IS
92:
93: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
94: SELECT
95: PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
96: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
97: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')
98: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
99: ,effective_date

Line 96: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')

92:
93: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
94: SELECT
95: PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
96: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
97: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')
98: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
99: ,effective_date
100: ,fnd_date.canonical_to_date(PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))

Line 97: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')

93: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
94: SELECT
95: PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
96: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
97: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')
98: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
99: ,effective_date
100: ,fnd_date.canonical_to_date(PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))
101: ,business_group_id

Line 98: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')

94: SELECT
95: PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
96: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
97: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')
98: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
99: ,effective_date
100: ,fnd_date.canonical_to_date(PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))
101: ,business_group_id
102: FROM pay_payroll_actions

Line 100: ,fnd_date.canonical_to_date(PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))

96: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
97: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')
98: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
99: ,effective_date
100: ,fnd_date.canonical_to_date(PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))
101: ,business_group_id
102: FROM pay_payroll_actions
103: WHERE payroll_action_id = p_payroll_action_id;
104:

Line 412: PAY_DK_STATSR_PKG.GET_ALL_PARAMETERS(

408: AND ppa.business_group_id = ppf.business_group_id
409: ORDER BY ppf.person_id';
410:
411: -- Fetch the input parameter values
412: PAY_DK_STATSR_PKG.GET_ALL_PARAMETERS(
413: pactid
414: ,l_business_group_id
415: ,l_payroll_id
416: ,l_sender_id

Line 866: SELECT PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')

862: IF g_debug THEN
863: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',10);
864: END IF;
865:
866: SELECT PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')
867: INTO l_span
868: FROM pay_payroll_actions
869: WHERE payroll_action_id = p_payroll_action_id;
870:

Line 1129: l_mkode0600 := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Worked Hours',l_dimension ,l_bal_todate) - l_old_mkode0600; -- l_date_to);

1125: /*Changes for Lunar Payroll */
1126:
1127: /*ELSIF csr_rec.payroll_period IN ('2','3','4') THEN*/
1128: ELSIF l_hourly_salaried = 'H' THEN
1129: l_mkode0600 := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Worked Hours',l_dimension ,l_bal_todate) - l_old_mkode0600; -- l_date_to);
1130: l_old_mkode0600 := l_mkode0600 + l_old_mkode0600;
1131:
1132: IF l_span = 'Q' THEN
1133: l_mkode0600 := l_mkode0600 / 13;

Line 1145: l_mkode0610 := to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_5DAY_WEEK_HOLIDAY_ENTITLEMENT', l_date_to));

1141: END IF; /* Bug 5030983 Fixes - End */
1142:
1143: /* Logic for selecting mkode0610 */
1144: IF( nvl(csr_rec.default_work_patt,rec_get_hol_entit.default_work_patt) = '5DAY') THEN
1145: l_mkode0610 := to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_5DAY_WEEK_HOLIDAY_ENTITLEMENT', l_date_to));
1146: ELSIF ( nvl(csr_rec.default_work_patt,rec_get_hol_entit.default_work_patt) = '6DAY') THEN
1147: l_mkode0610 := to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_6DAY_WEEK_HOLIDAY_ENTITLEMENT', l_date_to));
1148: /* Added new condition for bug fix 5003621 */
1149: ELSE

Line 1147: l_mkode0610 := to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_6DAY_WEEK_HOLIDAY_ENTITLEMENT', l_date_to));

1143: /* Logic for selecting mkode0610 */
1144: IF( nvl(csr_rec.default_work_patt,rec_get_hol_entit.default_work_patt) = '5DAY') THEN
1145: l_mkode0610 := to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_5DAY_WEEK_HOLIDAY_ENTITLEMENT', l_date_to));
1146: ELSIF ( nvl(csr_rec.default_work_patt,rec_get_hol_entit.default_work_patt) = '6DAY') THEN
1147: l_mkode0610 := to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_6DAY_WEEK_HOLIDAY_ENTITLEMENT', l_date_to));
1148: /* Added new condition for bug fix 5003621 */
1149: ELSE
1150: l_mkode0610 := to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_5DAY_WEEK_HOLIDAY_ENTITLEMENT', l_date_to));
1151: END IF;

Line 1150: l_mkode0610 := to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_5DAY_WEEK_HOLIDAY_ENTITLEMENT', l_date_to));

1146: ELSIF ( nvl(csr_rec.default_work_patt,rec_get_hol_entit.default_work_patt) = '6DAY') THEN
1147: l_mkode0610 := to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_6DAY_WEEK_HOLIDAY_ENTITLEMENT', l_date_to));
1148: /* Added new condition for bug fix 5003621 */
1149: ELSE
1150: l_mkode0610 := to_char(PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_5DAY_WEEK_HOLIDAY_ENTITLEMENT', l_date_to));
1151: END IF;
1152:
1153: /* Logic for selecting l_mkode0620 */
1154: /*Changes for Lunar Payroll */

Line 1158: ,PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_HOLIDAY_PAY_LEGSL_PERCENTAGE', l_date_to));

1154: /*Changes for Lunar Payroll */
1155: /*IF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/
1156: IF l_hourly_salaried = 'H' THEN
1157: l_mkode0620 := nvl(nvl(csr_rec.hourly_accr_rate,rec_get_hol_entit.hourly_accr_rate)
1158: ,PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_HOLIDAY_PAY_LEGSL_PERCENTAGE', l_date_to));
1159: /*ELSIF(csr_rec.payroll_period = '1') THEN*/
1160: ELSIF l_hourly_salaried = 'S' THEN
1161: l_mkode0620 := nvl(nvl(csr_rec.sal_allow_rate,rec_get_hol_entit.sal_allow_rate)
1162: ,PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_HOLIDAY_ALLOWANCE_LEGSL_PERCENTAGE', l_date_to));

Line 1162: ,PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_HOLIDAY_ALLOWANCE_LEGSL_PERCENTAGE', l_date_to));

1158: ,PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_HOLIDAY_PAY_LEGSL_PERCENTAGE', l_date_to));
1159: /*ELSIF(csr_rec.payroll_period = '1') THEN*/
1160: ELSIF l_hourly_salaried = 'S' THEN
1161: l_mkode0620 := nvl(nvl(csr_rec.sal_allow_rate,rec_get_hol_entit.sal_allow_rate)
1162: ,PAY_DK_STATSR_PKG.GET_GLOBAL_VALUE('DK_HOLIDAY_ALLOWANCE_LEGSL_PERCENTAGE', l_date_to));
1163: END IF;
1164:
1165: /************** Access the balance values for the ILTYPE balances **************/
1166:

Line 1168: l_iltype_0010_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total Income',l_dimension ,l_bal_todate) - l_old_iltype_0010_bal; -- l_date_to);

1164:
1165: /************** Access the balance values for the ILTYPE balances **************/
1166:
1167: /* Logic for fetching l_iltype_0010_bal */
1168: l_iltype_0010_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total Income',l_dimension ,l_bal_todate) - l_old_iltype_0010_bal; -- l_date_to);
1169: l_old_iltype_0010_bal := l_old_iltype_0010_bal + l_iltype_0010_bal;
1170: /* Bug 5030983 Fixes - Start */
1171: IF csr_rec.SAL_BASIS_MKODE IN ('81','82','83','84') THEN
1172: l_iltype_0010_unit := 0;

Line 1179: l_iltype_0010_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total ATP Hours',l_dimension ,l_bal_todate)

1175: /*IF(csr_rec.payroll_period = '1') THEN*/
1176: IF l_hourly_salaried = 'S' THEN
1177: /* Changed this for bug fix 5034129 */
1178: /*l_iltype_0010_unit := ROUND(l_hours_rate * l_mul_factor * 22/5,2);*/
1179: l_iltype_0010_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total ATP Hours',l_dimension ,l_bal_todate)
1180: - PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Worked Hours',l_dimension ,l_bal_todate) - l_s_old_iltype_0010_unit;
1181: l_s_old_iltype_0010_unit := l_iltype_0010_unit + l_s_old_iltype_0010_unit;
1182: /*Changes for Lunar Payroll */
1183: /*ELSIF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/

Line 1180: - PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Worked Hours',l_dimension ,l_bal_todate) - l_s_old_iltype_0010_unit;

1176: IF l_hourly_salaried = 'S' THEN
1177: /* Changed this for bug fix 5034129 */
1178: /*l_iltype_0010_unit := ROUND(l_hours_rate * l_mul_factor * 22/5,2);*/
1179: l_iltype_0010_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total ATP Hours',l_dimension ,l_bal_todate)
1180: - PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Worked Hours',l_dimension ,l_bal_todate) - l_s_old_iltype_0010_unit;
1181: l_s_old_iltype_0010_unit := l_iltype_0010_unit + l_s_old_iltype_0010_unit;
1182: /*Changes for Lunar Payroll */
1183: /*ELSIF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/
1184: ELSIF l_hourly_salaried = 'H' THEN

Line 1185: l_iltype_0010_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Worked Hours',l_dimension ,l_bal_todate) - l_h_old_iltype_0010_unit; -- l_date_to);

1181: l_s_old_iltype_0010_unit := l_iltype_0010_unit + l_s_old_iltype_0010_unit;
1182: /*Changes for Lunar Payroll */
1183: /*ELSIF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/
1184: ELSIF l_hourly_salaried = 'H' THEN
1185: l_iltype_0010_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Worked Hours',l_dimension ,l_bal_todate) - l_h_old_iltype_0010_unit; -- l_date_to);
1186: l_h_old_iltype_0010_unit := l_h_old_iltype_0010_unit + l_iltype_0010_unit;
1187: END IF;
1188: END IF; /* Bug 5030983 Fixes - End */
1189: /* Logic for fetching l_iltype_0011_bal */

Line 1190: l_iltype_0011_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Special Pay',l_dimension ,l_bal_todate) - l_old_iltype_0011_bal; -- l_date_to);

1186: l_h_old_iltype_0010_unit := l_h_old_iltype_0010_unit + l_iltype_0010_unit;
1187: END IF;
1188: END IF; /* Bug 5030983 Fixes - End */
1189: /* Logic for fetching l_iltype_0011_bal */
1190: l_iltype_0011_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Special Pay',l_dimension ,l_bal_todate) - l_old_iltype_0011_bal; -- l_date_to);
1191: l_old_iltype_0011_bal := l_iltype_0011_bal + l_old_iltype_0011_bal;
1192: l_iltype_0011_unit := 1;
1193:
1194: /* Logic for fetching l_iltype_0013_bal */

Line 1195: l_iltype_0013_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holidayable Pay',l_dimension ,l_bal_todate) - l_old_iltype_0013_bal; -- l_date_to);

1191: l_old_iltype_0011_bal := l_iltype_0011_bal + l_old_iltype_0011_bal;
1192: l_iltype_0011_unit := 1;
1193:
1194: /* Logic for fetching l_iltype_0013_bal */
1195: l_iltype_0013_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holidayable Pay',l_dimension ,l_bal_todate) - l_old_iltype_0013_bal; -- l_date_to);
1196: l_old_iltype_0013_bal := l_old_iltype_0013_bal + l_iltype_0013_bal;
1197: /* Added for bug 5050964*/
1198: l_iltype_0013_unit := l_iltype_0010_unit;
1199:

Line 1201: l_iltype_0015_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total Benefits in Kind',l_dimension ,l_bal_todate) - l_old_iltype_0015_bal; -- l_date_to);

1197: /* Added for bug 5050964*/
1198: l_iltype_0013_unit := l_iltype_0010_unit;
1199:
1200: /* Logic for fetching l_iltype_0015_bal */
1201: l_iltype_0015_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total Benefits in Kind',l_dimension ,l_bal_todate) - l_old_iltype_0015_bal; -- l_date_to);
1202: l_old_iltype_0015_bal := l_old_iltype_0015_bal + l_iltype_0015_bal;
1203: l_iltype_0015_unit := 1;
1204:
1205: /* Logic for fetching l_iltype_0021_bal */

Line 1206: l_iltype_0021_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)

1202: l_old_iltype_0015_bal := l_old_iltype_0015_bal + l_iltype_0015_bal;
1203: l_iltype_0015_unit := 1;
1204:
1205: /* Logic for fetching l_iltype_0021_bal */
1206: l_iltype_0021_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1207: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1208: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee Pension Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1209: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer Pension Deductions',l_dimension ,l_bal_todate)
1210: - l_old_iltype_0021_bal; -- l_date_to);

Line 1207: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)

1203: l_iltype_0015_unit := 1;
1204:
1205: /* Logic for fetching l_iltype_0021_bal */
1206: l_iltype_0021_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1207: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1208: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee Pension Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1209: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer Pension Deductions',l_dimension ,l_bal_todate)
1210: - l_old_iltype_0021_bal; -- l_date_to);
1211: l_old_iltype_0021_bal := l_iltype_0021_bal + l_old_iltype_0021_bal;

Line 1208: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee Pension Deductions',l_dimension ,l_bal_todate) -- l_date_to)

1204:
1205: /* Logic for fetching l_iltype_0021_bal */
1206: l_iltype_0021_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1207: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1208: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee Pension Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1209: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer Pension Deductions',l_dimension ,l_bal_todate)
1210: - l_old_iltype_0021_bal; -- l_date_to);
1211: l_old_iltype_0021_bal := l_iltype_0021_bal + l_old_iltype_0021_bal;
1212: l_iltype_0021_unit := 1;

Line 1209: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer Pension Deductions',l_dimension ,l_bal_todate)

1205: /* Logic for fetching l_iltype_0021_bal */
1206: l_iltype_0021_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1207: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer ATP Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1208: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employee Pension Deductions',l_dimension ,l_bal_todate) -- l_date_to)
1209: +PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Employer Pension Deductions',l_dimension ,l_bal_todate)
1210: - l_old_iltype_0021_bal; -- l_date_to);
1211: l_old_iltype_0021_bal := l_iltype_0021_bal + l_old_iltype_0021_bal;
1212: l_iltype_0021_unit := 1;
1213: /* Added condition for bug fix 4998238 */

Line 1217: l_iltype_0021_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Worked Hours',l_dimension ,l_bal_todate) - l_old_iltype_0021_unit; -- l_date_to);

1213: /* Added condition for bug fix 4998238 */
1214: /*Changes for Lunar Payroll */
1215: /*IF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/
1216: IF l_hourly_salaried = 'H' THEN
1217: l_iltype_0021_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Worked Hours',l_dimension ,l_bal_todate) - l_old_iltype_0021_unit; -- l_date_to);
1218: l_old_iltype_0021_unit := l_iltype_0021_unit + l_old_iltype_0021_unit;
1219: END IF;
1220:
1221: /* Logic for fetching l_iltype_0022_bal */

Line 1222: l_iltype_0022_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Pay',l_dimension ,l_bal_todate) - l_old_iltype_0022_bal; -- l_date_to);

1218: l_old_iltype_0021_unit := l_iltype_0021_unit + l_old_iltype_0021_unit;
1219: END IF;
1220:
1221: /* Logic for fetching l_iltype_0022_bal */
1222: l_iltype_0022_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Pay',l_dimension ,l_bal_todate) - l_old_iltype_0022_bal; -- l_date_to);
1223: l_old_iltype_0022_bal := l_iltype_0022_bal + l_old_iltype_0022_bal;
1224: /* After FS changes, now for both salaried and non-salaried, to report Total G_Dage_Days_ASG_XXX as units
1225: , earlier was Total G_Dage Hours for non-salaried */
1226: /* Commenting code below and re-writing to achieve this */

Line 1228: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Days',l_dimension ,l_date_to);

1224: /* After FS changes, now for both salaried and non-salaried, to report Total G_Dage_Days_ASG_XXX as units
1225: , earlier was Total G_Dage Hours for non-salaried */
1226: /* Commenting code below and re-writing to achieve this */
1227: /*IF(csr_rec.payroll_period = '1') THEN
1228: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Days',l_dimension ,l_date_to);
1229: ELSIF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3') THEN
1230: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Hours',l_dimension ,l_date_to);
1231: END IF;*/
1232: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Days',l_dimension ,l_bal_todate) - l_old_iltype_0022_unit; -- l_date_to);

Line 1230: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Hours',l_dimension ,l_date_to);

1226: /* Commenting code below and re-writing to achieve this */
1227: /*IF(csr_rec.payroll_period = '1') THEN
1228: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Days',l_dimension ,l_date_to);
1229: ELSIF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3') THEN
1230: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Hours',l_dimension ,l_date_to);
1231: END IF;*/
1232: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Days',l_dimension ,l_bal_todate) - l_old_iltype_0022_unit; -- l_date_to);
1233: l_old_iltype_0022_unit := l_iltype_0022_unit + l_old_iltype_0022_unit;
1234: /*Bug 5026906 fix- Changing the '<' operator to '=' in order to display

Line 1232: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Days',l_dimension ,l_bal_todate) - l_old_iltype_0022_unit; -- l_date_to);

1228: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Days',l_dimension ,l_date_to);
1229: ELSIF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3') THEN
1230: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Hours',l_dimension ,l_date_to);
1231: END IF;*/
1232: l_iltype_0022_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Total G_Dage Days',l_dimension ,l_bal_todate) - l_old_iltype_0022_unit; -- l_date_to);
1233: l_old_iltype_0022_unit := l_iltype_0022_unit + l_old_iltype_0022_unit;
1234: /*Bug 5026906 fix- Changing the '<' operator to '=' in order to display
1235: the negative values*/
1236: -- IF(l_iltype_0022_unit <0) THEN

Line 1244: l_iltype_0023_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Paid Absence Hours',l_dimension ,l_bal_todate) - l_s_old_iltype_0023_unit; -- l_date_to);

1240:
1241: /* Logic for fetching l_iltype_0023_bal */
1242: /*IF(csr_rec.payroll_period = '1' ) THEN*/
1243: IF l_hourly_salaried = 'S' THEN
1244: l_iltype_0023_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Paid Absence Hours',l_dimension ,l_bal_todate) - l_s_old_iltype_0023_unit; -- l_date_to);
1245: l_s_old_iltype_0023_unit := l_s_old_iltype_0023_unit + l_iltype_0023_unit;
1246:
1247: /* Calculate Hourly Rate Modified with if clause to avoid zero divide error */
1248: if l_iltype_0010_unit <> 0 then

Line 1249: l_iltype_0023_hr_rate := ROUND((PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salary Reporting',l_dimension ,l_bal_todate) - l_old_iltype_0023_hr_rate)/l_iltype_0010_unit,2);

1245: l_s_old_iltype_0023_unit := l_s_old_iltype_0023_unit + l_iltype_0023_unit;
1246:
1247: /* Calculate Hourly Rate Modified with if clause to avoid zero divide error */
1248: if l_iltype_0010_unit <> 0 then
1249: l_iltype_0023_hr_rate := ROUND((PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salary Reporting',l_dimension ,l_bal_todate) - l_old_iltype_0023_hr_rate)/l_iltype_0010_unit,2);
1250: l_old_iltype_0023_hr_rate := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salary Reporting',l_dimension ,l_bal_todate);
1251: end if;
1252:
1253: l_iltype_0023_bal := l_iltype_0023_hr_rate*l_iltype_0023_unit;

Line 1250: l_old_iltype_0023_hr_rate := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salary Reporting',l_dimension ,l_bal_todate);

1246:
1247: /* Calculate Hourly Rate Modified with if clause to avoid zero divide error */
1248: if l_iltype_0010_unit <> 0 then
1249: l_iltype_0023_hr_rate := ROUND((PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salary Reporting',l_dimension ,l_bal_todate) - l_old_iltype_0023_hr_rate)/l_iltype_0010_unit,2);
1250: l_old_iltype_0023_hr_rate := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salary Reporting',l_dimension ,l_bal_todate);
1251: end if;
1252:
1253: l_iltype_0023_bal := l_iltype_0023_hr_rate*l_iltype_0023_unit;
1254: /*Changes for Lunar Payroll */

Line 1257: l_iltype_0023_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Paid Absence Pay',l_dimension ,l_bal_todate) - l_old_iltype_0023_bal; -- l_date_to);

1253: l_iltype_0023_bal := l_iltype_0023_hr_rate*l_iltype_0023_unit;
1254: /*Changes for Lunar Payroll */
1255: /*ELSIF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/
1256: ELSIF l_hourly_salaried = 'H' THEN
1257: l_iltype_0023_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Paid Absence Pay',l_dimension ,l_bal_todate) - l_old_iltype_0023_bal; -- l_date_to);
1258: l_old_iltype_0023_bal := l_iltype_0023_bal + l_old_iltype_0023_bal;
1259: l_iltype_0023_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Paid Absence Hours',l_dimension ,l_bal_todate) - l_h_old_iltype_0023_unit; -- l_date_to);
1260: l_h_old_iltype_0023_unit := l_iltype_0023_unit + l_h_old_iltype_0023_unit;
1261: END IF;

Line 1259: l_iltype_0023_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Paid Absence Hours',l_dimension ,l_bal_todate) - l_h_old_iltype_0023_unit; -- l_date_to);

1255: /*ELSIF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/
1256: ELSIF l_hourly_salaried = 'H' THEN
1257: l_iltype_0023_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Paid Absence Pay',l_dimension ,l_bal_todate) - l_old_iltype_0023_bal; -- l_date_to);
1258: l_old_iltype_0023_bal := l_iltype_0023_bal + l_old_iltype_0023_bal;
1259: l_iltype_0023_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Paid Absence Hours',l_dimension ,l_bal_todate) - l_h_old_iltype_0023_unit; -- l_date_to);
1260: l_h_old_iltype_0023_unit := l_iltype_0023_unit + l_h_old_iltype_0023_unit;
1261: END IF;
1262: /* Logic for fetching l_iltype_0024_bal */
1263: /* After FS changes, it is now valid only for non-salaried ppl with balance Holiday_Accrual_Amount_ASG_XXX

Line 1269: l_iltype_0024_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Allowance Paid',l_dimension ,l_date_to);

1265: and Holiday Absence Days as units.*/
1266: /* Commenting code below and re-writing to achieve this */
1267: /*
1268: IF(csr_rec.payroll_period = '1' ) THEN
1269: l_iltype_0024_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Allowance Paid',l_dimension ,l_date_to);
1270: l_iltype_0024_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Absence Days',l_dimension ,l_date_to);
1271: */
1272: /*Changes for Lunar Payroll */
1273: /*IF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/

Line 1270: l_iltype_0024_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Absence Days',l_dimension ,l_date_to);

1266: /* Commenting code below and re-writing to achieve this */
1267: /*
1268: IF(csr_rec.payroll_period = '1' ) THEN
1269: l_iltype_0024_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Allowance Paid',l_dimension ,l_date_to);
1270: l_iltype_0024_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Absence Days',l_dimension ,l_date_to);
1271: */
1272: /*Changes for Lunar Payroll */
1273: /*IF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/
1274: IF l_hourly_salaried = 'H' THEN

Line 1276: l_iltype_0024_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Bank Pay',l_dimension ,l_bal_todate) - l_old_iltype_0024_bal; -- l_date_to);

1272: /*Changes for Lunar Payroll */
1273: /*IF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/
1274: IF l_hourly_salaried = 'H' THEN
1275: /* Changed for bug 5012411*/
1276: l_iltype_0024_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Bank Pay',l_dimension ,l_bal_todate) - l_old_iltype_0024_bal; -- l_date_to);
1277: l_old_iltype_0024_bal := l_iltype_0024_bal + l_old_iltype_0024_bal;
1278: l_iltype_0024_unit := 1;
1279: END IF;
1280:

Line 1288: l_iltype_0025_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Bank Pay',l_dimension ,l_date_to);

1284: and units Holiday Absence Hours */
1285: /* Commenting code below and re-writing to achieve this */
1286: /*
1287: IF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3') THEN
1288: l_iltype_0025_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Bank Pay',l_dimension ,l_date_to);
1289: l_iltype_0025_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Absence Hours',l_dimension ,l_date_to);
1290: */
1291: /*IF(csr_rec.payroll_period = '1' ) THEN*/
1292: IF l_hourly_salaried = 'S' THEN

Line 1289: l_iltype_0025_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Absence Hours',l_dimension ,l_date_to);

1285: /* Commenting code below and re-writing to achieve this */
1286: /*
1287: IF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3') THEN
1288: l_iltype_0025_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Bank Pay',l_dimension ,l_date_to);
1289: l_iltype_0025_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Absence Hours',l_dimension ,l_date_to);
1290: */
1291: /*IF(csr_rec.payroll_period = '1' ) THEN*/
1292: IF l_hourly_salaried = 'S' THEN
1293: l_iltype_0025_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Accrual Amount',l_dimension ,l_bal_todate) - l_old_iltype_0025_bal; -- l_date_to);

Line 1293: l_iltype_0025_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Accrual Amount',l_dimension ,l_bal_todate) - l_old_iltype_0025_bal; -- l_date_to);

1289: l_iltype_0025_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Absence Hours',l_dimension ,l_date_to);
1290: */
1291: /*IF(csr_rec.payroll_period = '1' ) THEN*/
1292: IF l_hourly_salaried = 'S' THEN
1293: l_iltype_0025_bal := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Accrual Amount',l_dimension ,l_bal_todate) - l_old_iltype_0025_bal; -- l_date_to);
1294: l_old_iltype_0025_bal := l_old_iltype_0025_bal + l_iltype_0025_bal;
1295: l_iltype_0025_unit := 1;
1296: END IF;
1297:

Line 1300: l_iltype_0026_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Unpaid Days',l_dimension ,l_bal_todate) - l_old_iltype_0026_unit; -- l_date_to);

1296: END IF;
1297:
1298: /* Logic for fetching l_iltype_0026_bal */
1299: l_iltype_0026_bal := 0;
1300: l_iltype_0026_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Unpaid Days',l_dimension ,l_bal_todate) - l_old_iltype_0026_unit; -- l_date_to);
1301: l_old_iltype_0026_unit := l_iltype_0026_unit + l_old_iltype_0026_unit;
1302:
1303: /* Logic for fetching l_iltype_0032_bal */
1304: l_iltype_0032_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Other Pay',l_dimension ,l_bal_todate) - l_old_iltype_0032_bal; -- l_date_to);

Line 1304: l_iltype_0032_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Other Pay',l_dimension ,l_bal_todate) - l_old_iltype_0032_bal; -- l_date_to);

1300: l_iltype_0026_unit := PAY_DK_STATSR_PKG.GET_DEFINED_BALANCE_VALUE(l_asg_id, 'Holiday Unpaid Days',l_dimension ,l_bal_todate) - l_old_iltype_0026_unit; -- l_date_to);
1301: l_old_iltype_0026_unit := l_iltype_0026_unit + l_old_iltype_0026_unit;
1302:
1303: /* Logic for fetching l_iltype_0032_bal */
1304: l_iltype_0032_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Other Pay',l_dimension ,l_bal_todate) - l_old_iltype_0032_bal; -- l_date_to);
1305: l_old_iltype_0032_bal := l_old_iltype_0032_bal + l_iltype_0032_bal;
1306: l_iltype_0032_unit := 1;
1307:
1308: /* Logic for fetching l_iltype_0034_bal */

Line 1314: l_iltype_0034_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Paid Absence Hours',l_dimension ,l_bal_todate) - l_old_iltype_0034_unit; -- l_date_to);

1310: /* Adding new condition, to achieve this */
1311: /*IF(csr_rec.payroll_period = '1') THEN*/
1312: IF l_hourly_salaried = 'S' THEN
1313: l_iltype_0034_bal := 0;
1314: l_iltype_0034_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Paid Absence Hours',l_dimension ,l_bal_todate) - l_old_iltype_0034_unit; -- l_date_to);
1315: l_old_iltype_0034_unit := l_iltype_0034_unit + l_old_iltype_0034_unit;
1316: END IF;
1317: /* Logic for fetching l_iltype_0036_bal */
1318: /* After FS changes, now applicable to non-salaried Payrolls only now, earlier was for all*/

Line 1320: /l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_date_to);/

1316: END IF;
1317: /* Logic for fetching l_iltype_0036_bal */
1318: /* After FS changes, now applicable to non-salaried Payrolls only now, earlier was for all*/
1319: /* Commenting code and putting everything into the first IF condition, to achieve this */
1320: /*l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_date_to);*/
1321: /*Changes for Lunar Payroll */
1322: /*IF(csr_rec.payroll_period = '2' OR csr_rec.payroll_period = '3' OR csr_rec.payroll_period = '4') THEN*/
1323: IF l_hourly_salaried = 'H' THEN
1324: /*l_iltype_0036_bal := 0;

Line 1328: /*l_iltype_0036_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Hours',l_dimension ,l_date_to);

1324: /*l_iltype_0036_bal := 0;
1325: ELSIF(csr_rec.payroll_period = '1' ) THEN */
1326: /*Bug 5020527 fix - Assigning the 'Hourly Overtime Hours' balance value to l_iltype_0036_unit
1327: and 'Hourly Overtime Pay' balance value to l_iltype_0036_bal*/
1328: /*l_iltype_0036_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Hours',l_dimension ,l_date_to);
1329: l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_date_to);*/
1330:
1331: l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Hours',l_dimension ,l_bal_todate) - l_old_iltype_0036_unit; -- l_date_to);
1332: l_old_iltype_0036_unit := l_iltype_0036_unit + l_old_iltype_0036_unit;

Line 1329: l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_date_to);*/

1325: ELSIF(csr_rec.payroll_period = '1' ) THEN */
1326: /*Bug 5020527 fix - Assigning the 'Hourly Overtime Hours' balance value to l_iltype_0036_unit
1327: and 'Hourly Overtime Pay' balance value to l_iltype_0036_bal*/
1328: /*l_iltype_0036_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Hours',l_dimension ,l_date_to);
1329: l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_date_to);*/
1330:
1331: l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Hours',l_dimension ,l_bal_todate) - l_old_iltype_0036_unit; -- l_date_to);
1332: l_old_iltype_0036_unit := l_iltype_0036_unit + l_old_iltype_0036_unit;
1333: l_iltype_0036_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_bal_todate) - l_old_iltype_0036_bal; -- l_date_to);

Line 1331: l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Hours',l_dimension ,l_bal_todate) - l_old_iltype_0036_unit; -- l_date_to);

1327: and 'Hourly Overtime Pay' balance value to l_iltype_0036_bal*/
1328: /*l_iltype_0036_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Hours',l_dimension ,l_date_to);
1329: l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_date_to);*/
1330:
1331: l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Hours',l_dimension ,l_bal_todate) - l_old_iltype_0036_unit; -- l_date_to);
1332: l_old_iltype_0036_unit := l_iltype_0036_unit + l_old_iltype_0036_unit;
1333: l_iltype_0036_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_bal_todate) - l_old_iltype_0036_bal; -- l_date_to);
1334: l_old_iltype_0036_bal := l_old_iltype_0036_bal + l_iltype_0036_bal;
1335: /*Bug 5026906 fix- Changing the '<' operator to '=' in order to display

Line 1333: l_iltype_0036_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_bal_todate) - l_old_iltype_0036_bal; -- l_date_to);

1329: l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_date_to);*/
1330:
1331: l_iltype_0036_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Hours',l_dimension ,l_bal_todate) - l_old_iltype_0036_unit; -- l_date_to);
1332: l_old_iltype_0036_unit := l_iltype_0036_unit + l_old_iltype_0036_unit;
1333: l_iltype_0036_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Hourly Overtime Pay',l_dimension ,l_bal_todate) - l_old_iltype_0036_bal; -- l_date_to);
1334: l_old_iltype_0036_bal := l_old_iltype_0036_bal + l_iltype_0036_bal;
1335: /*Bug 5026906 fix- Changing the '<' operator to '=' in order to display
1336: the negative values*/
1337: -- IF(l_iltype_0036_unit <0) THEN

Line 1348: l_iltype_0037_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Overtime Pay',l_dimension ,l_bal_todate) - l_old_iltype_0037_bal; -- l_date_to);

1344: /* After FS changes, now applicable to Salaried Payrolls only now, earlier was for all*/
1345: /* Adding new condition, to achieve this */
1346: /*IF(csr_rec.payroll_period = '1') THEN*/
1347: IF l_hourly_salaried = 'S' THEN
1348: l_iltype_0037_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Overtime Pay',l_dimension ,l_bal_todate) - l_old_iltype_0037_bal; -- l_date_to);
1349: l_old_iltype_0037_bal := l_old_iltype_0037_bal + l_iltype_0037_bal;
1350: l_iltype_0037_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Overtime Hours',l_dimension ,l_bal_todate) - l_old_iltype_0037_unit; -- l_date_to);
1351: l_old_iltype_0037_unit := l_old_iltype_0037_unit + l_iltype_0037_unit;
1352: /*Bug 5026906 fix- Changing the '<' operator to '=' in order to display

Line 1350: l_iltype_0037_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Overtime Hours',l_dimension ,l_bal_todate) - l_old_iltype_0037_unit; -- l_date_to);

1346: /*IF(csr_rec.payroll_period = '1') THEN*/
1347: IF l_hourly_salaried = 'S' THEN
1348: l_iltype_0037_bal := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Overtime Pay',l_dimension ,l_bal_todate) - l_old_iltype_0037_bal; -- l_date_to);
1349: l_old_iltype_0037_bal := l_old_iltype_0037_bal + l_iltype_0037_bal;
1350: l_iltype_0037_unit := PAY_DK_STATSR_PKG.GET_BALANCE_CATEGORY_VALUE(l_asg_id, 'Salaried Overtime Hours',l_dimension ,l_bal_todate) - l_old_iltype_0037_unit; -- l_date_to);
1351: l_old_iltype_0037_unit := l_old_iltype_0037_unit + l_iltype_0037_unit;
1352: /*Bug 5026906 fix- Changing the '<' operator to '=' in order to display
1353: the negative values*/
1354: --IF(l_iltype_0037_unit <0) THEN

Line 2181: END PAY_DK_STATSR_PKG;

2177: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
2178: HR_UTILITY.RAISE_ERROR;
2179: END WritetoCLOB;
2180:
2181: END PAY_DK_STATSR_PKG;