1087: hr_utility.set_location(' Inside balance Loop ', 850);
1088: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1089: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1090:
1091: l_regwg_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1092: l_valid_asg_act_rec.assignment_action_id,
1093: g_employer_id,
1094: null,
1095: null,
1102: hr_utility.set_location(' Inside balance Loop ', 850);
1103: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1104: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1105:
1106: l_irrb_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1107: l_valid_asg_act_rec.assignment_action_id,
1108: g_employer_id,
1109: null,
1110: null,
1117: hr_utility.set_location(' Inside balance Loop ', 850);
1118: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1119: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1120:
1121: l_ovrt_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1122: l_valid_asg_act_rec.assignment_action_id,
1123: g_employer_id,
1124: null,
1125: null,
1132: hr_utility.set_location(' Inside balance Loop ', 850);
1133: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1134: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1135:
1136: l_othr_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1137: l_valid_asg_act_rec.assignment_action_id,
1138: g_employer_id,
1139: null,
1140: null,
1179: Raise l_ehecs_exception;
1180: END IF;
1181: */
1182: ELSE
1183: l_chrs_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1184: l_valid_asg_act_rec.assignment_action_id,
1185: g_employer_id,
1186: null,
1187: null,
1198: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1199:
1200: l_mat_bal_val := nvl(l_mat_bal_val,0)
1201: +
1202: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1203: l_valid_asg_act_rec.assignment_action_id,
1204: g_employer_id,
1205: null,
1206: null,
1219:
1220: l_sic_bal_val :=
1221: nvl(l_sic_bal_val,0)
1222: +
1223: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1224: l_valid_asg_act_rec.assignment_action_id,
1225: g_employer_id,
1226: null,
1227: null,
1239:
1240: l_otl_bal_val :=
1241: l_otl_bal_val
1242: +
1243: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1244: l_valid_asg_act_rec.assignment_action_id,
1245: g_employer_id,
1246: null,
1247: null,
1262:
1263: l_mat_bal_val :=
1264: nvl(l_mat_bal_val,0)
1265: +
1266: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1267: l_valid_asg_act_rec.assignment_action_id,
1268: g_employer_id,
1269: null,
1270: null,
1283:
1284: l_sic_bal_val :=
1285: nvl(l_sic_bal_val,0)
1286: +
1287: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1288: l_valid_asg_act_rec.assignment_action_id,
1289: g_employer_id,
1290: null,
1291: null,
1302:
1303: l_otl_bal_val :=
1304: nvl(l_otl_bal_val,0)
1305: +
1306: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1307: l_valid_asg_act_rec.assignment_action_id,
1308: g_employer_id,
1309: null,
1310: null,
1321: hr_utility.set_location(' Inside balance Loop ', 850);
1322: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1323: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1324:
1325: l_incct_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1326: l_valid_asg_act_rec.assignment_action_id,
1327: g_employer_id,
1328: null,
1329: null,
1336: hr_utility.set_location(' Inside balance Loop ', 850);
1337: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1338: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1339:
1340: l_red_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1341: l_valid_asg_act_rec.assignment_action_id,
1342: g_employer_id,
1343: null,
1344: null,
1351: hr_utility.set_location(' Inside balance Loop ', 850);
1352: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1353: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1354:
1355: l_otsoc_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1356: l_valid_asg_act_rec.assignment_action_id,
1357: g_employer_id,
1358: null,
1359: null,
1366: hr_utility.set_location(' Inside balance Loop ', 850);
1367: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1368: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1369:
1370: l_tr_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1371: l_valid_asg_act_rec.assignment_action_id,
1372: g_employer_id,
1373: null,
1374: null,
1381: hr_utility.set_location(' Inside balance Loop ', 850);
1382: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1383: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1384:
1385: l_refund_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1386: l_valid_asg_act_rec.assignment_action_id,
1387: g_employer_id,
1388: null,
1389: null,
1396: hr_utility.set_location(' Inside balance Loop ', 850);
1397: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1398: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1399:
1400: l_vhi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1401: l_valid_asg_act_rec.assignment_action_id,
1402: g_employer_id,
1403: null,
1404: null,
1411: hr_utility.set_location(' Inside balance Loop ', 850);
1412: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1413: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1414:
1415: l_hse_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1416: l_valid_asg_act_rec.assignment_action_id,
1417: g_employer_id,
1418: null,
1419: null,
1426: hr_utility.set_location(' Inside balance Loop ', 850);
1427: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1428: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1429:
1430: l_otben_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1431: l_valid_asg_act_rec.assignment_action_id,
1432: g_employer_id,
1433: null,
1434: null,
1441: hr_utility.set_location(' Inside balance Loop ', 850);
1442: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1443: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1444:
1445: l_ot_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1446: l_valid_asg_act_rec.assignment_action_id,
1447: g_employer_id,
1448: null,
1449: null,
1456: hr_utility.set_location(' Inside balance Loop ', 850);
1457: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1458: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1459:
1460: /* l_nmw_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1461: l_valid_asg_act_rec.assignment_action_id,
1462: g_employer_id,
1463: null,
1464: null,
1473: hr_utility.set_location(' Inside balance Loop ', 850);
1474: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1475: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1476:
1477: l_stks_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1478: l_valid_asg_act_rec.assignment_action_id,
1479: g_employer_id,
1480: null,
1481: null,
1488: hr_utility.set_location(' Inside balance Loop ', 850);
1489: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1490: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1491:
1492: l_rbs_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1493: l_valid_asg_act_rec.assignment_action_id,
1494: g_employer_id,
1495: null,
1496: null,
1503: hr_utility.set_location(' Inside balance Loop ', 850);
1504: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1505: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1506:
1507: l_prsa_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1508: l_valid_asg_act_rec.assignment_action_id,
1509: g_employer_id,
1510: null,
1511: null,
1518: hr_utility.set_location(' Inside balance Loop ', 850);
1519: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1520: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1521:
1522: l_rac_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1523: l_valid_asg_act_rec.assignment_action_id,
1524: g_employer_id,
1525: null,
1526: null,
1533: hr_utility.set_location(' Inside balance Loop ', 850);
1534: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1535: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1536:
1537: l_prsi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1538: l_valid_asg_act_rec.assignment_action_id,
1539: g_employer_id,
1540: null,
1541: null,
1548: hr_utility.set_location(' Inside balance Loop ', 850);
1549: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1550: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1551:
1552: l_bik_veh_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1553: l_valid_asg_act_rec.assignment_action_id,
1554: g_employer_id,
1555: null,
1556: null,
1564: ELSIF g_def_bal_id(bal_index).balance_name = 'Annual Leave and Bank Holiday Hours' THEN
1565: hr_utility.set_location(' Inside balance Loop ', 850);
1566: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1567: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1568: l_al_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1569: l_valid_asg_act_rec.assignment_action_id,
1570: g_employer_id,
1571: null,
1572: null,
1580: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1581: l_al_bal_val :=
1582: nvl(l_al_bal_val,0)
1583: +
1584: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1585: l_valid_asg_act_rec.assignment_action_id,
1586: g_employer_id,
1587: null,
1588: null,