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_CA_ROE_EI_PKG dependencies on HR_UTILITY

Line 84: hr_utility.set_location('Starting: ' || l_proc_name, 10);

80: l_prev_roe_end_date DATE;
81: l_first_start_date DATE;
82:
83: BEGIN
84: hr_utility.set_location('Starting: ' || l_proc_name, 10);
85: hr_utility.set_location('p_start_date: ' || p_start_date, 10.5);
86: hr_utility.set_location('p_effective_date: ' || p_effective_date, 11);
87: hr_utility.set_location('p_last_period_start_date: ' || p_last_period_start_date, 12);
88:

Line 85: hr_utility.set_location('p_start_date: ' || p_start_date, 10.5);

81: l_first_start_date DATE;
82:
83: BEGIN
84: hr_utility.set_location('Starting: ' || l_proc_name, 10);
85: hr_utility.set_location('p_start_date: ' || p_start_date, 10.5);
86: hr_utility.set_location('p_effective_date: ' || p_effective_date, 11);
87: hr_utility.set_location('p_last_period_start_date: ' || p_last_period_start_date, 12);
88:
89: l_period_num := 1;

Line 86: hr_utility.set_location('p_effective_date: ' || p_effective_date, 11);

82:
83: BEGIN
84: hr_utility.set_location('Starting: ' || l_proc_name, 10);
85: hr_utility.set_location('p_start_date: ' || p_start_date, 10.5);
86: hr_utility.set_location('p_effective_date: ' || p_effective_date, 11);
87: hr_utility.set_location('p_last_period_start_date: ' || p_last_period_start_date, 12);
88:
89: l_period_num := 1;
90: l_days := 0;

Line 87: hr_utility.set_location('p_last_period_start_date: ' || p_last_period_start_date, 12);

83: BEGIN
84: hr_utility.set_location('Starting: ' || l_proc_name, 10);
85: hr_utility.set_location('p_start_date: ' || p_start_date, 10.5);
86: hr_utility.set_location('p_effective_date: ' || p_effective_date, 11);
87: hr_utility.set_location('p_last_period_start_date: ' || p_last_period_start_date, 12);
88:
89: l_period_num := 1;
90: l_days := 0;
91:

Line 97: hr_utility.trace('Day : '||to_char(l_days_from_start(l_days))|| ' Period : '|| to_char(l_period_number(l_days)));

93:
94: l_days_from_start(l_days) := l_days;
95: l_period_number(l_days) := l_period_num;
96:
97: hr_utility.trace('Day : '||to_char(l_days_from_start(l_days))|| ' Period : '|| to_char(l_period_number(l_days)));
98:
99: l_days := l_days + 1;
100:
101: END LOOP;

Line 113: hr_utility.trace('Day : '||to_char(l_days_from_start(l_days))|| ' Period : '|| to_char(l_period_number(l_days)));

109:
110: l_days_from_start(l_days) := l_days;
111: l_period_number(l_days) := l_period_num;
112:
113: hr_utility.trace('Day : '||to_char(l_days_from_start(l_days))|| ' Period : '|| to_char(l_period_number(l_days)));
114:
115: l_days := l_days + 1;
116:
117: END LOOP;

Line 128: hr_utility.trace('p_start_date : ' || to_char(p_start_date));

124: l_first_start_date := r_periods.start_date;
125:
126: END LOOP;
127:
128: hr_utility.trace('p_start_date : ' || to_char(p_start_date));
129:
130: -- This section checks to see if the employee was rehired in the
131: -- same period as the previous ROE (same period as p_start_date)
132: -- if so it we will return Y otherwise N

Line 148: hr_utility.trace('l_prev_roe_end_date : '|| to_char(l_prev_roe_end_date));

144: FETCH csr_prev_roe_end_date INTO l_prev_roe_end_date;
145:
146: IF csr_prev_roe_end_date%FOUND THEN
147:
148: hr_utility.trace('l_prev_roe_end_date : '|| to_char(l_prev_roe_end_date));
149:
150: -- Find any rehire dates that fall between the previous (ROE date + 1)
151: -- and the end date of it's pay period
152:

Line 159: hr_utility.trace('l_rehire_date : ' || to_char(l_rehire_date));

155:
156: IF csr_rehire_date%FOUND AND
157: l_rehire_date IS NOT NULL THEN
158:
159: hr_utility.trace('l_rehire_date : ' || to_char(l_rehire_date));
160: hr_utility.trace('l_first_start_date : ' || to_char(l_first_start_date));
161: hr_utility.trace('p_last_period_start_date : ' || to_char(p_last_period_start_date));
162:
163: -- If the rehire date falls under the correct range then store

Line 160: hr_utility.trace('l_first_start_date : ' || to_char(l_first_start_date));

156: IF csr_rehire_date%FOUND AND
157: l_rehire_date IS NOT NULL THEN
158:
159: hr_utility.trace('l_rehire_date : ' || to_char(l_rehire_date));
160: hr_utility.trace('l_first_start_date : ' || to_char(l_first_start_date));
161: hr_utility.trace('p_last_period_start_date : ' || to_char(p_last_period_start_date));
162:
163: -- If the rehire date falls under the correct range then store
164: -- the period between the rehire date and the end of the first

Line 161: hr_utility.trace('p_last_period_start_date : ' || to_char(p_last_period_start_date));

157: l_rehire_date IS NOT NULL THEN
158:
159: hr_utility.trace('l_rehire_date : ' || to_char(l_rehire_date));
160: hr_utility.trace('l_first_start_date : ' || to_char(l_first_start_date));
161: hr_utility.trace('p_last_period_start_date : ' || to_char(p_last_period_start_date));
162:
163: -- If the rehire date falls under the correct range then store
164: -- the period between the rehire date and the end of the first
165: -- period. The last condition ensures that we do not store any

Line 177: hr_utility.trace('Day : '||to_char(l_days_from_start(l_days))|| ' Period : '|| to_char(l_period_number(l_days)));

173:
174: l_days_from_start(l_days) := l_days;
175: l_period_number(l_days) := l_period_num;
176:
177: hr_utility.trace('Day : '||to_char(l_days_from_start(l_days))|| ' Period : '|| to_char(l_period_number(l_days)));
178:
179: l_days := l_days + 1;
180:
181: END LOOP;

Line 195: hr_utility.trace('Rehire flag returned : ' || l_rehire_flag);

191: END IF;
192:
193: CLOSE csr_prev_roe_end_date;
194:
195: hr_utility.trace('Rehire flag returned : ' || l_rehire_flag);
196: hr_utility.set_location('Ending: ' || l_proc_name, 1000);
197:
198: RETURN l_rehire_flag;
199:

Line 196: hr_utility.set_location('Ending: ' || l_proc_name, 1000);

192:
193: CLOSE csr_prev_roe_end_date;
194:
195: hr_utility.trace('Rehire flag returned : ' || l_rehire_flag);
196: hr_utility.set_location('Ending: ' || l_proc_name, 1000);
197:
198: RETURN l_rehire_flag;
199:
200: END populate_date_lookup_table;

Line 1284: hr_utility.set_location('Starting: ' || l_proc_name, 10);

1280: l_hour_start_date DATE;
1281:
1282: BEGIN
1283:
1284: hr_utility.set_location('Starting: ' || l_proc_name, 10);
1285: hr_utility.set_location('p_start_date: ' || to_char(p_start_date), 11);
1286: hr_utility.set_location('p_end_date: ' || p_end_date, 12);
1287:
1288: /*

Line 1285: hr_utility.set_location('p_start_date: ' || to_char(p_start_date), 11);

1281:
1282: BEGIN
1283:
1284: hr_utility.set_location('Starting: ' || l_proc_name, 10);
1285: hr_utility.set_location('p_start_date: ' || to_char(p_start_date), 11);
1286: hr_utility.set_location('p_end_date: ' || p_end_date, 12);
1287:
1288: /*
1289: * Initialise the output parameters

Line 1286: hr_utility.set_location('p_end_date: ' || p_end_date, 12);

1282: BEGIN
1283:
1284: hr_utility.set_location('Starting: ' || l_proc_name, 10);
1285: hr_utility.set_location('p_start_date: ' || to_char(p_start_date), 11);
1286: hr_utility.set_location('p_end_date: ' || p_end_date, 12);
1287:
1288: /*
1289: * Initialise the output parameters
1290: */

Line 1304: hr_utility.set_location('l_last_period_start_date: ' ||

1300: l_last_period_end_date;
1301: CLOSE csr_get_period_type;
1302:
1303:
1304: hr_utility.set_location('l_last_period_start_date: ' ||
1305: l_last_period_start_date, 13);
1306: hr_utility.set_location(l_proc_name, 20);
1307: IF p_total_type = 'EI Hours' THEN
1308:

Line 1306: hr_utility.set_location(l_proc_name, 20);

1302:
1303:
1304: hr_utility.set_location('l_last_period_start_date: ' ||
1305: l_last_period_start_date, 13);
1306: hr_utility.set_location(l_proc_name, 20);
1307: IF p_total_type = 'EI Hours' THEN
1308:
1309: IF p_period_type = 'Week' OR
1310: p_period_type = 'Bi-Week' OR

Line 1312: hr_utility.set_location(l_proc_name, 30);

1308:
1309: IF p_period_type = 'Week' OR
1310: p_period_type = 'Bi-Week' OR
1311: p_period_type = 'Lunar Month' THEN
1312: hr_utility.set_location(l_proc_name, 30);
1313: l_start_date := l_last_period_start_date - 364;
1314: ELSIF p_period_type = 'Semi-Month' OR
1315: p_period_type = 'Calendar Month' THEN
1316: hr_utility.set_location(l_proc_name, 40);

Line 1316: hr_utility.set_location(l_proc_name, 40);

1312: hr_utility.set_location(l_proc_name, 30);
1313: l_start_date := l_last_period_start_date - 364;
1314: ELSIF p_period_type = 'Semi-Month' OR
1315: p_period_type = 'Calendar Month' THEN
1316: hr_utility.set_location(l_proc_name, 40);
1317: l_start_date := ADD_MONTHS(l_last_period_start_date, -12);
1318: END IF;
1319:
1320: hr_utility.set_location('EI Hours l_start_date: ' ||

Line 1320: hr_utility.set_location('EI Hours l_start_date: ' ||

1316: hr_utility.set_location(l_proc_name, 40);
1317: l_start_date := ADD_MONTHS(l_last_period_start_date, -12);
1318: END IF;
1319:
1320: hr_utility.set_location('EI Hours l_start_date: ' ||
1321: l_start_date, 20);
1322:
1323: hr_utility.set_location('EI Hours p_start_date: ' ||
1324: p_start_date, 20);

Line 1323: hr_utility.set_location('EI Hours p_start_date: ' ||

1319:
1320: hr_utility.set_location('EI Hours l_start_date: ' ||
1321: l_start_date, 20);
1322:
1323: hr_utility.set_location('EI Hours p_start_date: ' ||
1324: p_start_date, 20);
1325:
1326: l_period_start_date_exists := 'N';
1327:

Line 1338: hr_utility.trace('l_next_prd_start_date : '||to_char(l_next_prd_start_date));

1334: close cur_next_prd_start_date;
1335:
1336: l_start_date := p_start_date;
1337:
1338: hr_utility.trace('l_next_prd_start_date : '||to_char(l_next_prd_start_date));
1339: hr_utility.trace('l_start_date : '||to_char(l_start_date));
1340:
1341: -- Check to see if l_start_date is the start date of a period
1342: -- If it is, then we set l_period_start_date_exists to Y

Line 1339: hr_utility.trace('l_start_date : '||to_char(l_start_date));

1335:
1336: l_start_date := p_start_date;
1337:
1338: hr_utility.trace('l_next_prd_start_date : '||to_char(l_next_prd_start_date));
1339: hr_utility.trace('l_start_date : '||to_char(l_start_date));
1340:
1341: -- Check to see if l_start_date is the start date of a period
1342: -- If it is, then we set l_period_start_date_exists to Y
1343: -- this means that the previous ROE date was on the last day

Line 1388: hr_utility.trace('EI Hours: l_hour_start_date = '

1384: l_hour_start_date := l_start_date;
1385:
1386: END IF;
1387:
1388: hr_utility.trace('EI Hours: l_hour_start_date = '
1389: || to_char(l_hour_start_date));
1390: OPEN cur_ftr(l_hour_start_date,
1391: l_pay_period_end_date);
1392: FETCH cur_ftr

Line 1396: hr_utility.trace('EI Hours cur_ftr not Found !!!');

1392: FETCH cur_ftr
1393: INTO dummy;
1394:
1395: IF cur_ftr%NOTFOUND THEN
1396: hr_utility.trace('EI Hours cur_ftr not Found !!!');
1397: l_ftr_exists := FALSE;
1398: ELSE
1399: hr_utility.trace('EI Hours cur_ftr Found !!!');
1400: l_ftr_exists := TRUE;

Line 1399: hr_utility.trace('EI Hours cur_ftr Found !!!');

1395: IF cur_ftr%NOTFOUND THEN
1396: hr_utility.trace('EI Hours cur_ftr not Found !!!');
1397: l_ftr_exists := FALSE;
1398: ELSE
1399: hr_utility.trace('EI Hours cur_ftr Found !!!');
1400: l_ftr_exists := TRUE;
1401: END IF;
1402:
1403: CLOSE cur_ftr;

Line 1407: hr_utility.trace('EI Hours l_ftr_exists !!!');

1403: CLOSE cur_ftr;
1404:
1405: IF l_ftr_exists THEN
1406:
1407: hr_utility.trace('EI Hours l_ftr_exists !!!');
1408: OPEN csr_dp_hours_total_ftr_exists(p_assignment_id,
1409: p_gre,
1410: l_hour_start_date,
1411: l_last_period_end_date);

Line 1424: hr_utility.trace('EI Hours NOT l_ftr_exists !!!');

1420: CLOSE csr_de_hours_total_ftr_exists;
1421:
1422: ELSE
1423:
1424: hr_utility.trace('EI Hours NOT l_ftr_exists !!!');
1425: OPEN csr_dp_hours_total_ftr_nexists(p_assignment_id,
1426: p_gre,
1427: l_hour_start_date,
1428: l_last_period_end_date);

Line 1441: hr_utility.trace (' l_dp_hours_total = ' || to_char(l_dp_hours_total));

1437: CLOSE csr_de_hours_total_ftr_nexists;
1438:
1439: END IF;
1440:
1441: hr_utility.trace (' l_dp_hours_total = ' || to_char(l_dp_hours_total));
1442: hr_utility.trace (' l_de_hours_total = ' || to_char(l_de_hours_total));
1443:
1444: p_total_insurable := NVL(l_dp_hours_total,0) +
1445: NVL(l_de_hours_total,0);

Line 1442: hr_utility.trace (' l_de_hours_total = ' || to_char(l_de_hours_total));

1438:
1439: END IF;
1440:
1441: hr_utility.trace (' l_dp_hours_total = ' || to_char(l_dp_hours_total));
1442: hr_utility.trace (' l_de_hours_total = ' || to_char(l_de_hours_total));
1443:
1444: p_total_insurable := NVL(l_dp_hours_total,0) +
1445: NVL(l_de_hours_total,0);
1446:

Line 1447: hr_utility.trace('Total Hours : '|| to_char(p_total_insurable));

1443:
1444: p_total_insurable := NVL(l_dp_hours_total,0) +
1445: NVL(l_de_hours_total,0);
1446:
1447: hr_utility.trace('Total Hours : '|| to_char(p_total_insurable));
1448:
1449: RETURN 'BOX15A';
1450:
1451: ELSIF p_total_type = 'EI Earnings' THEN

Line 1454: hr_utility.set_location(l_proc_name, 50);

1450:
1451: ELSIF p_total_type = 'EI Earnings' THEN
1452: /* Modified the period count for bug 4510534 */
1453: IF p_period_type = 'Week' THEN
1454: hr_utility.set_location(l_proc_name, 50);
1455: l_start_date := l_last_period_start_date - 365;
1456: l_period_count := 53;
1457: l_period_count1 := 27;
1458: ELSIF p_period_type = 'Bi-Week' THEN

Line 1459: hr_utility.set_location(l_proc_name, 60);

1455: l_start_date := l_last_period_start_date - 365;
1456: l_period_count := 53;
1457: l_period_count1 := 27;
1458: ELSIF p_period_type = 'Bi-Week' THEN
1459: hr_utility.set_location(l_proc_name, 60);
1460: l_start_date := l_last_period_start_date - 365;
1461: l_period_count := 27;
1462: l_period_count1 := 14;
1463: ELSIF p_period_type = 'Semi-Month' THEN

Line 1464: hr_utility.set_location(l_proc_name, 70);

1460: l_start_date := l_last_period_start_date - 365;
1461: l_period_count := 27;
1462: l_period_count1 := 14;
1463: ELSIF p_period_type = 'Semi-Month' THEN
1464: hr_utility.set_location(l_proc_name, 70);
1465: l_start_date := ADD_MONTHS(l_last_period_start_date, -12);
1466: l_period_count := 25;
1467: l_period_count1 := 13;
1468: ELSIF p_period_type = 'Calendar Month' THEN

Line 1469: hr_utility.set_location(l_proc_name, 80);

1465: l_start_date := ADD_MONTHS(l_last_period_start_date, -12);
1466: l_period_count := 25;
1467: l_period_count1 := 13;
1468: ELSIF p_period_type = 'Calendar Month' THEN
1469: hr_utility.set_location(l_proc_name, 80);
1470: l_start_date := ADD_MONTHS(l_last_period_start_date, -12);
1471: l_period_count := 13;
1472: l_period_count1 := 7;
1473: ELSIF p_period_type = 'Lunar Month' THEN

Line 1474: hr_utility.set_location(l_proc_name, 90);

1470: l_start_date := ADD_MONTHS(l_last_period_start_date, -12);
1471: l_period_count := 13;
1472: l_period_count1 := 7;
1473: ELSIF p_period_type = 'Lunar Month' THEN
1474: hr_utility.set_location(l_proc_name, 90);
1475: l_start_date := l_last_period_start_date - 336;
1476: l_period_count := 14;
1477: l_period_count1 := 7;
1478: END IF;

Line 1494: hr_utility.set_location('l_start_date: ' || l_start_date, 21);

1490: l_start_date := p_start_date;
1491:
1492: END IF;
1493:
1494: hr_utility.set_location('l_start_date: ' || l_start_date, 21);
1495:
1496: hr_utility.trace('b4 populate_date_lookup_table');
1497: hr_utility.trace('l_start_date = ' || to_char(l_start_date));
1498: hr_utility.trace('p_end_date = ' || to_char(p_end_date));

Line 1496: hr_utility.trace('b4 populate_date_lookup_table');

1492: END IF;
1493:
1494: hr_utility.set_location('l_start_date: ' || l_start_date, 21);
1495:
1496: hr_utility.trace('b4 populate_date_lookup_table');
1497: hr_utility.trace('l_start_date = ' || to_char(l_start_date));
1498: hr_utility.trace('p_end_date = ' || to_char(p_end_date));
1499: hr_utility.trace('l_last_period_start_date = ' || to_char(l_last_period_start_date));
1500:

Line 1497: hr_utility.trace('l_start_date = ' || to_char(l_start_date));

1493:
1494: hr_utility.set_location('l_start_date: ' || l_start_date, 21);
1495:
1496: hr_utility.trace('b4 populate_date_lookup_table');
1497: hr_utility.trace('l_start_date = ' || to_char(l_start_date));
1498: hr_utility.trace('p_end_date = ' || to_char(p_end_date));
1499: hr_utility.trace('l_last_period_start_date = ' || to_char(l_last_period_start_date));
1500:
1501: l_rehire := populate_date_lookup_table(p_payroll_id,

Line 1498: hr_utility.trace('p_end_date = ' || to_char(p_end_date));

1494: hr_utility.set_location('l_start_date: ' || l_start_date, 21);
1495:
1496: hr_utility.trace('b4 populate_date_lookup_table');
1497: hr_utility.trace('l_start_date = ' || to_char(l_start_date));
1498: hr_utility.trace('p_end_date = ' || to_char(p_end_date));
1499: hr_utility.trace('l_last_period_start_date = ' || to_char(l_last_period_start_date));
1500:
1501: l_rehire := populate_date_lookup_table(p_payroll_id,
1502: p_assignment_id,

Line 1499: hr_utility.trace('l_last_period_start_date = ' || to_char(l_last_period_start_date));

1495:
1496: hr_utility.trace('b4 populate_date_lookup_table');
1497: hr_utility.trace('l_start_date = ' || to_char(l_start_date));
1498: hr_utility.trace('p_end_date = ' || to_char(p_end_date));
1499: hr_utility.trace('l_last_period_start_date = ' || to_char(l_last_period_start_date));
1500:
1501: l_rehire := populate_date_lookup_table(p_payroll_id,
1502: p_assignment_id,
1503: l_start_date,

Line 1566: hr_utility.trace('l_de_total(1) = ' || to_char(l_de_total(1)));

1562: l_de_total(52),
1563: l_de_total(53) ;
1564: CLOSE csr_get_de_total;
1565:
1566: hr_utility.trace('l_de_total(1) = ' || to_char(l_de_total(1)));
1567: hr_utility.trace('l_de_total(2) = ' || to_char(l_de_total(2)));
1568: hr_utility.trace('l_de_total(3) = ' || to_char(l_de_total(3)));
1569: hr_utility.trace('l_de_total(4) = ' || to_char(l_de_total(4)));
1570: hr_utility.trace('l_de_total(5) = ' || to_char(l_de_total(5)));

Line 1567: hr_utility.trace('l_de_total(2) = ' || to_char(l_de_total(2)));

1563: l_de_total(53) ;
1564: CLOSE csr_get_de_total;
1565:
1566: hr_utility.trace('l_de_total(1) = ' || to_char(l_de_total(1)));
1567: hr_utility.trace('l_de_total(2) = ' || to_char(l_de_total(2)));
1568: hr_utility.trace('l_de_total(3) = ' || to_char(l_de_total(3)));
1569: hr_utility.trace('l_de_total(4) = ' || to_char(l_de_total(4)));
1570: hr_utility.trace('l_de_total(5) = ' || to_char(l_de_total(5)));
1571: hr_utility.trace('l_de_total(6) = ' || to_char(l_de_total(6)));

Line 1568: hr_utility.trace('l_de_total(3) = ' || to_char(l_de_total(3)));

1564: CLOSE csr_get_de_total;
1565:
1566: hr_utility.trace('l_de_total(1) = ' || to_char(l_de_total(1)));
1567: hr_utility.trace('l_de_total(2) = ' || to_char(l_de_total(2)));
1568: hr_utility.trace('l_de_total(3) = ' || to_char(l_de_total(3)));
1569: hr_utility.trace('l_de_total(4) = ' || to_char(l_de_total(4)));
1570: hr_utility.trace('l_de_total(5) = ' || to_char(l_de_total(5)));
1571: hr_utility.trace('l_de_total(6) = ' || to_char(l_de_total(6)));
1572: hr_utility.trace('l_de_total(7) = ' || to_char(l_de_total(7)));

Line 1569: hr_utility.trace('l_de_total(4) = ' || to_char(l_de_total(4)));

1565:
1566: hr_utility.trace('l_de_total(1) = ' || to_char(l_de_total(1)));
1567: hr_utility.trace('l_de_total(2) = ' || to_char(l_de_total(2)));
1568: hr_utility.trace('l_de_total(3) = ' || to_char(l_de_total(3)));
1569: hr_utility.trace('l_de_total(4) = ' || to_char(l_de_total(4)));
1570: hr_utility.trace('l_de_total(5) = ' || to_char(l_de_total(5)));
1571: hr_utility.trace('l_de_total(6) = ' || to_char(l_de_total(6)));
1572: hr_utility.trace('l_de_total(7) = ' || to_char(l_de_total(7)));
1573: hr_utility.trace('l_de_total(8) = ' || to_char(l_de_total(8)));

Line 1570: hr_utility.trace('l_de_total(5) = ' || to_char(l_de_total(5)));

1566: hr_utility.trace('l_de_total(1) = ' || to_char(l_de_total(1)));
1567: hr_utility.trace('l_de_total(2) = ' || to_char(l_de_total(2)));
1568: hr_utility.trace('l_de_total(3) = ' || to_char(l_de_total(3)));
1569: hr_utility.trace('l_de_total(4) = ' || to_char(l_de_total(4)));
1570: hr_utility.trace('l_de_total(5) = ' || to_char(l_de_total(5)));
1571: hr_utility.trace('l_de_total(6) = ' || to_char(l_de_total(6)));
1572: hr_utility.trace('l_de_total(7) = ' || to_char(l_de_total(7)));
1573: hr_utility.trace('l_de_total(8) = ' || to_char(l_de_total(8)));
1574: hr_utility.trace('l_de_total(9) = ' || to_char(l_de_total(9)));

Line 1571: hr_utility.trace('l_de_total(6) = ' || to_char(l_de_total(6)));

1567: hr_utility.trace('l_de_total(2) = ' || to_char(l_de_total(2)));
1568: hr_utility.trace('l_de_total(3) = ' || to_char(l_de_total(3)));
1569: hr_utility.trace('l_de_total(4) = ' || to_char(l_de_total(4)));
1570: hr_utility.trace('l_de_total(5) = ' || to_char(l_de_total(5)));
1571: hr_utility.trace('l_de_total(6) = ' || to_char(l_de_total(6)));
1572: hr_utility.trace('l_de_total(7) = ' || to_char(l_de_total(7)));
1573: hr_utility.trace('l_de_total(8) = ' || to_char(l_de_total(8)));
1574: hr_utility.trace('l_de_total(9) = ' || to_char(l_de_total(9)));
1575: hr_utility.trace('l_de_total(10) = ' || to_char(l_de_total(10)));

Line 1572: hr_utility.trace('l_de_total(7) = ' || to_char(l_de_total(7)));

1568: hr_utility.trace('l_de_total(3) = ' || to_char(l_de_total(3)));
1569: hr_utility.trace('l_de_total(4) = ' || to_char(l_de_total(4)));
1570: hr_utility.trace('l_de_total(5) = ' || to_char(l_de_total(5)));
1571: hr_utility.trace('l_de_total(6) = ' || to_char(l_de_total(6)));
1572: hr_utility.trace('l_de_total(7) = ' || to_char(l_de_total(7)));
1573: hr_utility.trace('l_de_total(8) = ' || to_char(l_de_total(8)));
1574: hr_utility.trace('l_de_total(9) = ' || to_char(l_de_total(9)));
1575: hr_utility.trace('l_de_total(10) = ' || to_char(l_de_total(10)));
1576: hr_utility.trace('l_de_total(11) = ' || to_char(l_de_total(11)));

Line 1573: hr_utility.trace('l_de_total(8) = ' || to_char(l_de_total(8)));

1569: hr_utility.trace('l_de_total(4) = ' || to_char(l_de_total(4)));
1570: hr_utility.trace('l_de_total(5) = ' || to_char(l_de_total(5)));
1571: hr_utility.trace('l_de_total(6) = ' || to_char(l_de_total(6)));
1572: hr_utility.trace('l_de_total(7) = ' || to_char(l_de_total(7)));
1573: hr_utility.trace('l_de_total(8) = ' || to_char(l_de_total(8)));
1574: hr_utility.trace('l_de_total(9) = ' || to_char(l_de_total(9)));
1575: hr_utility.trace('l_de_total(10) = ' || to_char(l_de_total(10)));
1576: hr_utility.trace('l_de_total(11) = ' || to_char(l_de_total(11)));
1577: hr_utility.trace('l_de_total(12) = ' || to_char(l_de_total(12)));

Line 1574: hr_utility.trace('l_de_total(9) = ' || to_char(l_de_total(9)));

1570: hr_utility.trace('l_de_total(5) = ' || to_char(l_de_total(5)));
1571: hr_utility.trace('l_de_total(6) = ' || to_char(l_de_total(6)));
1572: hr_utility.trace('l_de_total(7) = ' || to_char(l_de_total(7)));
1573: hr_utility.trace('l_de_total(8) = ' || to_char(l_de_total(8)));
1574: hr_utility.trace('l_de_total(9) = ' || to_char(l_de_total(9)));
1575: hr_utility.trace('l_de_total(10) = ' || to_char(l_de_total(10)));
1576: hr_utility.trace('l_de_total(11) = ' || to_char(l_de_total(11)));
1577: hr_utility.trace('l_de_total(12) = ' || to_char(l_de_total(12)));
1578: hr_utility.trace('l_de_total(13) = ' || to_char(l_de_total(13)));

Line 1575: hr_utility.trace('l_de_total(10) = ' || to_char(l_de_total(10)));

1571: hr_utility.trace('l_de_total(6) = ' || to_char(l_de_total(6)));
1572: hr_utility.trace('l_de_total(7) = ' || to_char(l_de_total(7)));
1573: hr_utility.trace('l_de_total(8) = ' || to_char(l_de_total(8)));
1574: hr_utility.trace('l_de_total(9) = ' || to_char(l_de_total(9)));
1575: hr_utility.trace('l_de_total(10) = ' || to_char(l_de_total(10)));
1576: hr_utility.trace('l_de_total(11) = ' || to_char(l_de_total(11)));
1577: hr_utility.trace('l_de_total(12) = ' || to_char(l_de_total(12)));
1578: hr_utility.trace('l_de_total(13) = ' || to_char(l_de_total(13)));
1579: hr_utility.trace('l_de_total(14) = ' || to_char(l_de_total(14)));

Line 1576: hr_utility.trace('l_de_total(11) = ' || to_char(l_de_total(11)));

1572: hr_utility.trace('l_de_total(7) = ' || to_char(l_de_total(7)));
1573: hr_utility.trace('l_de_total(8) = ' || to_char(l_de_total(8)));
1574: hr_utility.trace('l_de_total(9) = ' || to_char(l_de_total(9)));
1575: hr_utility.trace('l_de_total(10) = ' || to_char(l_de_total(10)));
1576: hr_utility.trace('l_de_total(11) = ' || to_char(l_de_total(11)));
1577: hr_utility.trace('l_de_total(12) = ' || to_char(l_de_total(12)));
1578: hr_utility.trace('l_de_total(13) = ' || to_char(l_de_total(13)));
1579: hr_utility.trace('l_de_total(14) = ' || to_char(l_de_total(14)));
1580: hr_utility.trace('l_de_total(15) = ' || to_char(l_de_total(15)));

Line 1577: hr_utility.trace('l_de_total(12) = ' || to_char(l_de_total(12)));

1573: hr_utility.trace('l_de_total(8) = ' || to_char(l_de_total(8)));
1574: hr_utility.trace('l_de_total(9) = ' || to_char(l_de_total(9)));
1575: hr_utility.trace('l_de_total(10) = ' || to_char(l_de_total(10)));
1576: hr_utility.trace('l_de_total(11) = ' || to_char(l_de_total(11)));
1577: hr_utility.trace('l_de_total(12) = ' || to_char(l_de_total(12)));
1578: hr_utility.trace('l_de_total(13) = ' || to_char(l_de_total(13)));
1579: hr_utility.trace('l_de_total(14) = ' || to_char(l_de_total(14)));
1580: hr_utility.trace('l_de_total(15) = ' || to_char(l_de_total(15)));
1581: hr_utility.trace('l_de_total(16) = ' || to_char(l_de_total(16)));

Line 1578: hr_utility.trace('l_de_total(13) = ' || to_char(l_de_total(13)));

1574: hr_utility.trace('l_de_total(9) = ' || to_char(l_de_total(9)));
1575: hr_utility.trace('l_de_total(10) = ' || to_char(l_de_total(10)));
1576: hr_utility.trace('l_de_total(11) = ' || to_char(l_de_total(11)));
1577: hr_utility.trace('l_de_total(12) = ' || to_char(l_de_total(12)));
1578: hr_utility.trace('l_de_total(13) = ' || to_char(l_de_total(13)));
1579: hr_utility.trace('l_de_total(14) = ' || to_char(l_de_total(14)));
1580: hr_utility.trace('l_de_total(15) = ' || to_char(l_de_total(15)));
1581: hr_utility.trace('l_de_total(16) = ' || to_char(l_de_total(16)));
1582: hr_utility.trace('l_de_total(17) = ' || to_char(l_de_total(17)));

Line 1579: hr_utility.trace('l_de_total(14) = ' || to_char(l_de_total(14)));

1575: hr_utility.trace('l_de_total(10) = ' || to_char(l_de_total(10)));
1576: hr_utility.trace('l_de_total(11) = ' || to_char(l_de_total(11)));
1577: hr_utility.trace('l_de_total(12) = ' || to_char(l_de_total(12)));
1578: hr_utility.trace('l_de_total(13) = ' || to_char(l_de_total(13)));
1579: hr_utility.trace('l_de_total(14) = ' || to_char(l_de_total(14)));
1580: hr_utility.trace('l_de_total(15) = ' || to_char(l_de_total(15)));
1581: hr_utility.trace('l_de_total(16) = ' || to_char(l_de_total(16)));
1582: hr_utility.trace('l_de_total(17) = ' || to_char(l_de_total(17)));
1583: hr_utility.trace('l_de_total(18) = ' || to_char(l_de_total(18)));

Line 1580: hr_utility.trace('l_de_total(15) = ' || to_char(l_de_total(15)));

1576: hr_utility.trace('l_de_total(11) = ' || to_char(l_de_total(11)));
1577: hr_utility.trace('l_de_total(12) = ' || to_char(l_de_total(12)));
1578: hr_utility.trace('l_de_total(13) = ' || to_char(l_de_total(13)));
1579: hr_utility.trace('l_de_total(14) = ' || to_char(l_de_total(14)));
1580: hr_utility.trace('l_de_total(15) = ' || to_char(l_de_total(15)));
1581: hr_utility.trace('l_de_total(16) = ' || to_char(l_de_total(16)));
1582: hr_utility.trace('l_de_total(17) = ' || to_char(l_de_total(17)));
1583: hr_utility.trace('l_de_total(18) = ' || to_char(l_de_total(18)));
1584: hr_utility.trace('l_de_total(19) = ' || to_char(l_de_total(19)));

Line 1581: hr_utility.trace('l_de_total(16) = ' || to_char(l_de_total(16)));

1577: hr_utility.trace('l_de_total(12) = ' || to_char(l_de_total(12)));
1578: hr_utility.trace('l_de_total(13) = ' || to_char(l_de_total(13)));
1579: hr_utility.trace('l_de_total(14) = ' || to_char(l_de_total(14)));
1580: hr_utility.trace('l_de_total(15) = ' || to_char(l_de_total(15)));
1581: hr_utility.trace('l_de_total(16) = ' || to_char(l_de_total(16)));
1582: hr_utility.trace('l_de_total(17) = ' || to_char(l_de_total(17)));
1583: hr_utility.trace('l_de_total(18) = ' || to_char(l_de_total(18)));
1584: hr_utility.trace('l_de_total(19) = ' || to_char(l_de_total(19)));
1585: hr_utility.trace('l_de_total(20) = ' || to_char(l_de_total(20)));

Line 1582: hr_utility.trace('l_de_total(17) = ' || to_char(l_de_total(17)));

1578: hr_utility.trace('l_de_total(13) = ' || to_char(l_de_total(13)));
1579: hr_utility.trace('l_de_total(14) = ' || to_char(l_de_total(14)));
1580: hr_utility.trace('l_de_total(15) = ' || to_char(l_de_total(15)));
1581: hr_utility.trace('l_de_total(16) = ' || to_char(l_de_total(16)));
1582: hr_utility.trace('l_de_total(17) = ' || to_char(l_de_total(17)));
1583: hr_utility.trace('l_de_total(18) = ' || to_char(l_de_total(18)));
1584: hr_utility.trace('l_de_total(19) = ' || to_char(l_de_total(19)));
1585: hr_utility.trace('l_de_total(20) = ' || to_char(l_de_total(20)));
1586: hr_utility.trace('l_de_total(21) = ' || to_char(l_de_total(21)));

Line 1583: hr_utility.trace('l_de_total(18) = ' || to_char(l_de_total(18)));

1579: hr_utility.trace('l_de_total(14) = ' || to_char(l_de_total(14)));
1580: hr_utility.trace('l_de_total(15) = ' || to_char(l_de_total(15)));
1581: hr_utility.trace('l_de_total(16) = ' || to_char(l_de_total(16)));
1582: hr_utility.trace('l_de_total(17) = ' || to_char(l_de_total(17)));
1583: hr_utility.trace('l_de_total(18) = ' || to_char(l_de_total(18)));
1584: hr_utility.trace('l_de_total(19) = ' || to_char(l_de_total(19)));
1585: hr_utility.trace('l_de_total(20) = ' || to_char(l_de_total(20)));
1586: hr_utility.trace('l_de_total(21) = ' || to_char(l_de_total(21)));
1587: hr_utility.trace('l_de_total(22) = ' || to_char(l_de_total(22)));

Line 1584: hr_utility.trace('l_de_total(19) = ' || to_char(l_de_total(19)));

1580: hr_utility.trace('l_de_total(15) = ' || to_char(l_de_total(15)));
1581: hr_utility.trace('l_de_total(16) = ' || to_char(l_de_total(16)));
1582: hr_utility.trace('l_de_total(17) = ' || to_char(l_de_total(17)));
1583: hr_utility.trace('l_de_total(18) = ' || to_char(l_de_total(18)));
1584: hr_utility.trace('l_de_total(19) = ' || to_char(l_de_total(19)));
1585: hr_utility.trace('l_de_total(20) = ' || to_char(l_de_total(20)));
1586: hr_utility.trace('l_de_total(21) = ' || to_char(l_de_total(21)));
1587: hr_utility.trace('l_de_total(22) = ' || to_char(l_de_total(22)));
1588: hr_utility.trace('l_de_total(23) = ' || to_char(l_de_total(23)));

Line 1585: hr_utility.trace('l_de_total(20) = ' || to_char(l_de_total(20)));

1581: hr_utility.trace('l_de_total(16) = ' || to_char(l_de_total(16)));
1582: hr_utility.trace('l_de_total(17) = ' || to_char(l_de_total(17)));
1583: hr_utility.trace('l_de_total(18) = ' || to_char(l_de_total(18)));
1584: hr_utility.trace('l_de_total(19) = ' || to_char(l_de_total(19)));
1585: hr_utility.trace('l_de_total(20) = ' || to_char(l_de_total(20)));
1586: hr_utility.trace('l_de_total(21) = ' || to_char(l_de_total(21)));
1587: hr_utility.trace('l_de_total(22) = ' || to_char(l_de_total(22)));
1588: hr_utility.trace('l_de_total(23) = ' || to_char(l_de_total(23)));
1589: hr_utility.trace('l_de_total(24) = ' || to_char(l_de_total(24)));

Line 1586: hr_utility.trace('l_de_total(21) = ' || to_char(l_de_total(21)));

1582: hr_utility.trace('l_de_total(17) = ' || to_char(l_de_total(17)));
1583: hr_utility.trace('l_de_total(18) = ' || to_char(l_de_total(18)));
1584: hr_utility.trace('l_de_total(19) = ' || to_char(l_de_total(19)));
1585: hr_utility.trace('l_de_total(20) = ' || to_char(l_de_total(20)));
1586: hr_utility.trace('l_de_total(21) = ' || to_char(l_de_total(21)));
1587: hr_utility.trace('l_de_total(22) = ' || to_char(l_de_total(22)));
1588: hr_utility.trace('l_de_total(23) = ' || to_char(l_de_total(23)));
1589: hr_utility.trace('l_de_total(24) = ' || to_char(l_de_total(24)));
1590: hr_utility.trace('l_de_total(25) = ' || to_char(l_de_total(25)));

Line 1587: hr_utility.trace('l_de_total(22) = ' || to_char(l_de_total(22)));

1583: hr_utility.trace('l_de_total(18) = ' || to_char(l_de_total(18)));
1584: hr_utility.trace('l_de_total(19) = ' || to_char(l_de_total(19)));
1585: hr_utility.trace('l_de_total(20) = ' || to_char(l_de_total(20)));
1586: hr_utility.trace('l_de_total(21) = ' || to_char(l_de_total(21)));
1587: hr_utility.trace('l_de_total(22) = ' || to_char(l_de_total(22)));
1588: hr_utility.trace('l_de_total(23) = ' || to_char(l_de_total(23)));
1589: hr_utility.trace('l_de_total(24) = ' || to_char(l_de_total(24)));
1590: hr_utility.trace('l_de_total(25) = ' || to_char(l_de_total(25)));
1591: hr_utility.trace('l_de_total(26) = ' || to_char(l_de_total(26)));

Line 1588: hr_utility.trace('l_de_total(23) = ' || to_char(l_de_total(23)));

1584: hr_utility.trace('l_de_total(19) = ' || to_char(l_de_total(19)));
1585: hr_utility.trace('l_de_total(20) = ' || to_char(l_de_total(20)));
1586: hr_utility.trace('l_de_total(21) = ' || to_char(l_de_total(21)));
1587: hr_utility.trace('l_de_total(22) = ' || to_char(l_de_total(22)));
1588: hr_utility.trace('l_de_total(23) = ' || to_char(l_de_total(23)));
1589: hr_utility.trace('l_de_total(24) = ' || to_char(l_de_total(24)));
1590: hr_utility.trace('l_de_total(25) = ' || to_char(l_de_total(25)));
1591: hr_utility.trace('l_de_total(26) = ' || to_char(l_de_total(26)));
1592: hr_utility.trace('l_de_total(27) = ' || to_char(l_de_total(27)));

Line 1589: hr_utility.trace('l_de_total(24) = ' || to_char(l_de_total(24)));

1585: hr_utility.trace('l_de_total(20) = ' || to_char(l_de_total(20)));
1586: hr_utility.trace('l_de_total(21) = ' || to_char(l_de_total(21)));
1587: hr_utility.trace('l_de_total(22) = ' || to_char(l_de_total(22)));
1588: hr_utility.trace('l_de_total(23) = ' || to_char(l_de_total(23)));
1589: hr_utility.trace('l_de_total(24) = ' || to_char(l_de_total(24)));
1590: hr_utility.trace('l_de_total(25) = ' || to_char(l_de_total(25)));
1591: hr_utility.trace('l_de_total(26) = ' || to_char(l_de_total(26)));
1592: hr_utility.trace('l_de_total(27) = ' || to_char(l_de_total(27)));
1593:

Line 1590: hr_utility.trace('l_de_total(25) = ' || to_char(l_de_total(25)));

1586: hr_utility.trace('l_de_total(21) = ' || to_char(l_de_total(21)));
1587: hr_utility.trace('l_de_total(22) = ' || to_char(l_de_total(22)));
1588: hr_utility.trace('l_de_total(23) = ' || to_char(l_de_total(23)));
1589: hr_utility.trace('l_de_total(24) = ' || to_char(l_de_total(24)));
1590: hr_utility.trace('l_de_total(25) = ' || to_char(l_de_total(25)));
1591: hr_utility.trace('l_de_total(26) = ' || to_char(l_de_total(26)));
1592: hr_utility.trace('l_de_total(27) = ' || to_char(l_de_total(27)));
1593:
1594: IF p_term_or_abs_flag = 'Y' THEN

Line 1591: hr_utility.trace('l_de_total(26) = ' || to_char(l_de_total(26)));

1587: hr_utility.trace('l_de_total(22) = ' || to_char(l_de_total(22)));
1588: hr_utility.trace('l_de_total(23) = ' || to_char(l_de_total(23)));
1589: hr_utility.trace('l_de_total(24) = ' || to_char(l_de_total(24)));
1590: hr_utility.trace('l_de_total(25) = ' || to_char(l_de_total(25)));
1591: hr_utility.trace('l_de_total(26) = ' || to_char(l_de_total(26)));
1592: hr_utility.trace('l_de_total(27) = ' || to_char(l_de_total(27)));
1593:
1594: IF p_term_or_abs_flag = 'Y' THEN
1595:

Line 1592: hr_utility.trace('l_de_total(27) = ' || to_char(l_de_total(27)));

1588: hr_utility.trace('l_de_total(23) = ' || to_char(l_de_total(23)));
1589: hr_utility.trace('l_de_total(24) = ' || to_char(l_de_total(24)));
1590: hr_utility.trace('l_de_total(25) = ' || to_char(l_de_total(25)));
1591: hr_utility.trace('l_de_total(26) = ' || to_char(l_de_total(26)));
1592: hr_utility.trace('l_de_total(27) = ' || to_char(l_de_total(27)));
1593:
1594: IF p_term_or_abs_flag = 'Y' THEN
1595:
1596: open cur_pay_period_dates(p_end_date);

Line 1679: hr_utility.trace('p_assignment_id = ' || to_char(p_assignment_id));

1675: l_last_period_end_date,
1676: l_last_period_start_date);
1677: ELSE
1678:
1679: hr_utility.trace('p_assignment_id = ' || to_char(p_assignment_id));
1680: hr_utility.trace('p_gre = ' || to_char(p_gre));
1681: hr_utility.trace('l_start_date = ' || to_char(l_start_date));
1682: hr_utility.trace('l_last_period_end_date = '
1683: || to_char(l_last_period_end_date));

Line 1680: hr_utility.trace('p_gre = ' || to_char(p_gre));

1676: l_last_period_start_date);
1677: ELSE
1678:
1679: hr_utility.trace('p_assignment_id = ' || to_char(p_assignment_id));
1680: hr_utility.trace('p_gre = ' || to_char(p_gre));
1681: hr_utility.trace('l_start_date = ' || to_char(l_start_date));
1682: hr_utility.trace('l_last_period_end_date = '
1683: || to_char(l_last_period_end_date));
1684:

Line 1681: hr_utility.trace('l_start_date = ' || to_char(l_start_date));

1677: ELSE
1678:
1679: hr_utility.trace('p_assignment_id = ' || to_char(p_assignment_id));
1680: hr_utility.trace('p_gre = ' || to_char(p_gre));
1681: hr_utility.trace('l_start_date = ' || to_char(l_start_date));
1682: hr_utility.trace('l_last_period_end_date = '
1683: || to_char(l_last_period_end_date));
1684:
1685: OPEN csr_get_dp_total1(p_assignment_id,

Line 1682: hr_utility.trace('l_last_period_end_date = '

1678:
1679: hr_utility.trace('p_assignment_id = ' || to_char(p_assignment_id));
1680: hr_utility.trace('p_gre = ' || to_char(p_gre));
1681: hr_utility.trace('l_start_date = ' || to_char(l_start_date));
1682: hr_utility.trace('l_last_period_end_date = '
1683: || to_char(l_last_period_end_date));
1684:
1685: OPEN csr_get_dp_total1(p_assignment_id,
1686: p_gre,

Line 1747: hr_utility.trace('l_dp_total(1) = ' || to_char(l_dp_total(1)));

1743:
1744: END IF;
1745:
1746:
1747: hr_utility.trace('l_dp_total(1) = ' || to_char(l_dp_total(1)));
1748: hr_utility.trace('l_dp_total(2) = ' || to_char(l_dp_total(2)));
1749: hr_utility.trace('l_dp_total(3) = ' || to_char(l_dp_total(3)));
1750: hr_utility.trace('l_dp_total(4) = ' || to_char(l_dp_total(4)));
1751: hr_utility.trace('l_dp_total(5) = ' || to_char(l_dp_total(5)));

Line 1748: hr_utility.trace('l_dp_total(2) = ' || to_char(l_dp_total(2)));

1744: END IF;
1745:
1746:
1747: hr_utility.trace('l_dp_total(1) = ' || to_char(l_dp_total(1)));
1748: hr_utility.trace('l_dp_total(2) = ' || to_char(l_dp_total(2)));
1749: hr_utility.trace('l_dp_total(3) = ' || to_char(l_dp_total(3)));
1750: hr_utility.trace('l_dp_total(4) = ' || to_char(l_dp_total(4)));
1751: hr_utility.trace('l_dp_total(5) = ' || to_char(l_dp_total(5)));
1752: hr_utility.trace('l_dp_total(6) = ' || to_char(l_dp_total(6)));

Line 1749: hr_utility.trace('l_dp_total(3) = ' || to_char(l_dp_total(3)));

1745:
1746:
1747: hr_utility.trace('l_dp_total(1) = ' || to_char(l_dp_total(1)));
1748: hr_utility.trace('l_dp_total(2) = ' || to_char(l_dp_total(2)));
1749: hr_utility.trace('l_dp_total(3) = ' || to_char(l_dp_total(3)));
1750: hr_utility.trace('l_dp_total(4) = ' || to_char(l_dp_total(4)));
1751: hr_utility.trace('l_dp_total(5) = ' || to_char(l_dp_total(5)));
1752: hr_utility.trace('l_dp_total(6) = ' || to_char(l_dp_total(6)));
1753: hr_utility.trace('l_dp_total(7) = ' || to_char(l_dp_total(7)));

Line 1750: hr_utility.trace('l_dp_total(4) = ' || to_char(l_dp_total(4)));

1746:
1747: hr_utility.trace('l_dp_total(1) = ' || to_char(l_dp_total(1)));
1748: hr_utility.trace('l_dp_total(2) = ' || to_char(l_dp_total(2)));
1749: hr_utility.trace('l_dp_total(3) = ' || to_char(l_dp_total(3)));
1750: hr_utility.trace('l_dp_total(4) = ' || to_char(l_dp_total(4)));
1751: hr_utility.trace('l_dp_total(5) = ' || to_char(l_dp_total(5)));
1752: hr_utility.trace('l_dp_total(6) = ' || to_char(l_dp_total(6)));
1753: hr_utility.trace('l_dp_total(7) = ' || to_char(l_dp_total(7)));
1754: hr_utility.trace('l_dp_total(8) = ' || to_char(l_dp_total(8)));

Line 1751: hr_utility.trace('l_dp_total(5) = ' || to_char(l_dp_total(5)));

1747: hr_utility.trace('l_dp_total(1) = ' || to_char(l_dp_total(1)));
1748: hr_utility.trace('l_dp_total(2) = ' || to_char(l_dp_total(2)));
1749: hr_utility.trace('l_dp_total(3) = ' || to_char(l_dp_total(3)));
1750: hr_utility.trace('l_dp_total(4) = ' || to_char(l_dp_total(4)));
1751: hr_utility.trace('l_dp_total(5) = ' || to_char(l_dp_total(5)));
1752: hr_utility.trace('l_dp_total(6) = ' || to_char(l_dp_total(6)));
1753: hr_utility.trace('l_dp_total(7) = ' || to_char(l_dp_total(7)));
1754: hr_utility.trace('l_dp_total(8) = ' || to_char(l_dp_total(8)));
1755: hr_utility.trace('l_dp_total(9) = ' || to_char(l_dp_total(9)));

Line 1752: hr_utility.trace('l_dp_total(6) = ' || to_char(l_dp_total(6)));

1748: hr_utility.trace('l_dp_total(2) = ' || to_char(l_dp_total(2)));
1749: hr_utility.trace('l_dp_total(3) = ' || to_char(l_dp_total(3)));
1750: hr_utility.trace('l_dp_total(4) = ' || to_char(l_dp_total(4)));
1751: hr_utility.trace('l_dp_total(5) = ' || to_char(l_dp_total(5)));
1752: hr_utility.trace('l_dp_total(6) = ' || to_char(l_dp_total(6)));
1753: hr_utility.trace('l_dp_total(7) = ' || to_char(l_dp_total(7)));
1754: hr_utility.trace('l_dp_total(8) = ' || to_char(l_dp_total(8)));
1755: hr_utility.trace('l_dp_total(9) = ' || to_char(l_dp_total(9)));
1756: hr_utility.trace('l_dp_total(10) = ' || to_char(l_dp_total(10)));

Line 1753: hr_utility.trace('l_dp_total(7) = ' || to_char(l_dp_total(7)));

1749: hr_utility.trace('l_dp_total(3) = ' || to_char(l_dp_total(3)));
1750: hr_utility.trace('l_dp_total(4) = ' || to_char(l_dp_total(4)));
1751: hr_utility.trace('l_dp_total(5) = ' || to_char(l_dp_total(5)));
1752: hr_utility.trace('l_dp_total(6) = ' || to_char(l_dp_total(6)));
1753: hr_utility.trace('l_dp_total(7) = ' || to_char(l_dp_total(7)));
1754: hr_utility.trace('l_dp_total(8) = ' || to_char(l_dp_total(8)));
1755: hr_utility.trace('l_dp_total(9) = ' || to_char(l_dp_total(9)));
1756: hr_utility.trace('l_dp_total(10) = ' || to_char(l_dp_total(10)));
1757: hr_utility.trace('l_dp_total(11) = ' || to_char(l_dp_total(11)));

Line 1754: hr_utility.trace('l_dp_total(8) = ' || to_char(l_dp_total(8)));

1750: hr_utility.trace('l_dp_total(4) = ' || to_char(l_dp_total(4)));
1751: hr_utility.trace('l_dp_total(5) = ' || to_char(l_dp_total(5)));
1752: hr_utility.trace('l_dp_total(6) = ' || to_char(l_dp_total(6)));
1753: hr_utility.trace('l_dp_total(7) = ' || to_char(l_dp_total(7)));
1754: hr_utility.trace('l_dp_total(8) = ' || to_char(l_dp_total(8)));
1755: hr_utility.trace('l_dp_total(9) = ' || to_char(l_dp_total(9)));
1756: hr_utility.trace('l_dp_total(10) = ' || to_char(l_dp_total(10)));
1757: hr_utility.trace('l_dp_total(11) = ' || to_char(l_dp_total(11)));
1758: hr_utility.trace('l_dp_total(12) = ' || to_char(l_dp_total(12)));

Line 1755: hr_utility.trace('l_dp_total(9) = ' || to_char(l_dp_total(9)));

1751: hr_utility.trace('l_dp_total(5) = ' || to_char(l_dp_total(5)));
1752: hr_utility.trace('l_dp_total(6) = ' || to_char(l_dp_total(6)));
1753: hr_utility.trace('l_dp_total(7) = ' || to_char(l_dp_total(7)));
1754: hr_utility.trace('l_dp_total(8) = ' || to_char(l_dp_total(8)));
1755: hr_utility.trace('l_dp_total(9) = ' || to_char(l_dp_total(9)));
1756: hr_utility.trace('l_dp_total(10) = ' || to_char(l_dp_total(10)));
1757: hr_utility.trace('l_dp_total(11) = ' || to_char(l_dp_total(11)));
1758: hr_utility.trace('l_dp_total(12) = ' || to_char(l_dp_total(12)));
1759: hr_utility.trace('l_dp_total(13) = ' || to_char(l_dp_total(13)));

Line 1756: hr_utility.trace('l_dp_total(10) = ' || to_char(l_dp_total(10)));

1752: hr_utility.trace('l_dp_total(6) = ' || to_char(l_dp_total(6)));
1753: hr_utility.trace('l_dp_total(7) = ' || to_char(l_dp_total(7)));
1754: hr_utility.trace('l_dp_total(8) = ' || to_char(l_dp_total(8)));
1755: hr_utility.trace('l_dp_total(9) = ' || to_char(l_dp_total(9)));
1756: hr_utility.trace('l_dp_total(10) = ' || to_char(l_dp_total(10)));
1757: hr_utility.trace('l_dp_total(11) = ' || to_char(l_dp_total(11)));
1758: hr_utility.trace('l_dp_total(12) = ' || to_char(l_dp_total(12)));
1759: hr_utility.trace('l_dp_total(13) = ' || to_char(l_dp_total(13)));
1760: hr_utility.trace('l_dp_total(14) = ' || to_char(l_dp_total(14)));

Line 1757: hr_utility.trace('l_dp_total(11) = ' || to_char(l_dp_total(11)));

1753: hr_utility.trace('l_dp_total(7) = ' || to_char(l_dp_total(7)));
1754: hr_utility.trace('l_dp_total(8) = ' || to_char(l_dp_total(8)));
1755: hr_utility.trace('l_dp_total(9) = ' || to_char(l_dp_total(9)));
1756: hr_utility.trace('l_dp_total(10) = ' || to_char(l_dp_total(10)));
1757: hr_utility.trace('l_dp_total(11) = ' || to_char(l_dp_total(11)));
1758: hr_utility.trace('l_dp_total(12) = ' || to_char(l_dp_total(12)));
1759: hr_utility.trace('l_dp_total(13) = ' || to_char(l_dp_total(13)));
1760: hr_utility.trace('l_dp_total(14) = ' || to_char(l_dp_total(14)));
1761: hr_utility.trace('l_dp_total(15) = ' || to_char(l_dp_total(15)));

Line 1758: hr_utility.trace('l_dp_total(12) = ' || to_char(l_dp_total(12)));

1754: hr_utility.trace('l_dp_total(8) = ' || to_char(l_dp_total(8)));
1755: hr_utility.trace('l_dp_total(9) = ' || to_char(l_dp_total(9)));
1756: hr_utility.trace('l_dp_total(10) = ' || to_char(l_dp_total(10)));
1757: hr_utility.trace('l_dp_total(11) = ' || to_char(l_dp_total(11)));
1758: hr_utility.trace('l_dp_total(12) = ' || to_char(l_dp_total(12)));
1759: hr_utility.trace('l_dp_total(13) = ' || to_char(l_dp_total(13)));
1760: hr_utility.trace('l_dp_total(14) = ' || to_char(l_dp_total(14)));
1761: hr_utility.trace('l_dp_total(15) = ' || to_char(l_dp_total(15)));
1762: hr_utility.trace('l_dp_total(16) = ' || to_char(l_dp_total(16)));

Line 1759: hr_utility.trace('l_dp_total(13) = ' || to_char(l_dp_total(13)));

1755: hr_utility.trace('l_dp_total(9) = ' || to_char(l_dp_total(9)));
1756: hr_utility.trace('l_dp_total(10) = ' || to_char(l_dp_total(10)));
1757: hr_utility.trace('l_dp_total(11) = ' || to_char(l_dp_total(11)));
1758: hr_utility.trace('l_dp_total(12) = ' || to_char(l_dp_total(12)));
1759: hr_utility.trace('l_dp_total(13) = ' || to_char(l_dp_total(13)));
1760: hr_utility.trace('l_dp_total(14) = ' || to_char(l_dp_total(14)));
1761: hr_utility.trace('l_dp_total(15) = ' || to_char(l_dp_total(15)));
1762: hr_utility.trace('l_dp_total(16) = ' || to_char(l_dp_total(16)));
1763: hr_utility.trace('l_dp_total(17) = ' || to_char(l_dp_total(17)));

Line 1760: hr_utility.trace('l_dp_total(14) = ' || to_char(l_dp_total(14)));

1756: hr_utility.trace('l_dp_total(10) = ' || to_char(l_dp_total(10)));
1757: hr_utility.trace('l_dp_total(11) = ' || to_char(l_dp_total(11)));
1758: hr_utility.trace('l_dp_total(12) = ' || to_char(l_dp_total(12)));
1759: hr_utility.trace('l_dp_total(13) = ' || to_char(l_dp_total(13)));
1760: hr_utility.trace('l_dp_total(14) = ' || to_char(l_dp_total(14)));
1761: hr_utility.trace('l_dp_total(15) = ' || to_char(l_dp_total(15)));
1762: hr_utility.trace('l_dp_total(16) = ' || to_char(l_dp_total(16)));
1763: hr_utility.trace('l_dp_total(17) = ' || to_char(l_dp_total(17)));
1764: hr_utility.trace('l_dp_total(18) = ' || to_char(l_dp_total(18)));

Line 1761: hr_utility.trace('l_dp_total(15) = ' || to_char(l_dp_total(15)));

1757: hr_utility.trace('l_dp_total(11) = ' || to_char(l_dp_total(11)));
1758: hr_utility.trace('l_dp_total(12) = ' || to_char(l_dp_total(12)));
1759: hr_utility.trace('l_dp_total(13) = ' || to_char(l_dp_total(13)));
1760: hr_utility.trace('l_dp_total(14) = ' || to_char(l_dp_total(14)));
1761: hr_utility.trace('l_dp_total(15) = ' || to_char(l_dp_total(15)));
1762: hr_utility.trace('l_dp_total(16) = ' || to_char(l_dp_total(16)));
1763: hr_utility.trace('l_dp_total(17) = ' || to_char(l_dp_total(17)));
1764: hr_utility.trace('l_dp_total(18) = ' || to_char(l_dp_total(18)));
1765: hr_utility.trace('l_dp_total(19) = ' || to_char(l_dp_total(19)));

Line 1762: hr_utility.trace('l_dp_total(16) = ' || to_char(l_dp_total(16)));

1758: hr_utility.trace('l_dp_total(12) = ' || to_char(l_dp_total(12)));
1759: hr_utility.trace('l_dp_total(13) = ' || to_char(l_dp_total(13)));
1760: hr_utility.trace('l_dp_total(14) = ' || to_char(l_dp_total(14)));
1761: hr_utility.trace('l_dp_total(15) = ' || to_char(l_dp_total(15)));
1762: hr_utility.trace('l_dp_total(16) = ' || to_char(l_dp_total(16)));
1763: hr_utility.trace('l_dp_total(17) = ' || to_char(l_dp_total(17)));
1764: hr_utility.trace('l_dp_total(18) = ' || to_char(l_dp_total(18)));
1765: hr_utility.trace('l_dp_total(19) = ' || to_char(l_dp_total(19)));
1766: hr_utility.trace('l_dp_total(20) = ' || to_char(l_dp_total(20)));

Line 1763: hr_utility.trace('l_dp_total(17) = ' || to_char(l_dp_total(17)));

1759: hr_utility.trace('l_dp_total(13) = ' || to_char(l_dp_total(13)));
1760: hr_utility.trace('l_dp_total(14) = ' || to_char(l_dp_total(14)));
1761: hr_utility.trace('l_dp_total(15) = ' || to_char(l_dp_total(15)));
1762: hr_utility.trace('l_dp_total(16) = ' || to_char(l_dp_total(16)));
1763: hr_utility.trace('l_dp_total(17) = ' || to_char(l_dp_total(17)));
1764: hr_utility.trace('l_dp_total(18) = ' || to_char(l_dp_total(18)));
1765: hr_utility.trace('l_dp_total(19) = ' || to_char(l_dp_total(19)));
1766: hr_utility.trace('l_dp_total(20) = ' || to_char(l_dp_total(20)));
1767: hr_utility.trace('l_dp_total(21) = ' || to_char(l_dp_total(21)));

Line 1764: hr_utility.trace('l_dp_total(18) = ' || to_char(l_dp_total(18)));

1760: hr_utility.trace('l_dp_total(14) = ' || to_char(l_dp_total(14)));
1761: hr_utility.trace('l_dp_total(15) = ' || to_char(l_dp_total(15)));
1762: hr_utility.trace('l_dp_total(16) = ' || to_char(l_dp_total(16)));
1763: hr_utility.trace('l_dp_total(17) = ' || to_char(l_dp_total(17)));
1764: hr_utility.trace('l_dp_total(18) = ' || to_char(l_dp_total(18)));
1765: hr_utility.trace('l_dp_total(19) = ' || to_char(l_dp_total(19)));
1766: hr_utility.trace('l_dp_total(20) = ' || to_char(l_dp_total(20)));
1767: hr_utility.trace('l_dp_total(21) = ' || to_char(l_dp_total(21)));
1768: hr_utility.trace('l_dp_total(22) = ' || to_char(l_dp_total(22)));

Line 1765: hr_utility.trace('l_dp_total(19) = ' || to_char(l_dp_total(19)));

1761: hr_utility.trace('l_dp_total(15) = ' || to_char(l_dp_total(15)));
1762: hr_utility.trace('l_dp_total(16) = ' || to_char(l_dp_total(16)));
1763: hr_utility.trace('l_dp_total(17) = ' || to_char(l_dp_total(17)));
1764: hr_utility.trace('l_dp_total(18) = ' || to_char(l_dp_total(18)));
1765: hr_utility.trace('l_dp_total(19) = ' || to_char(l_dp_total(19)));
1766: hr_utility.trace('l_dp_total(20) = ' || to_char(l_dp_total(20)));
1767: hr_utility.trace('l_dp_total(21) = ' || to_char(l_dp_total(21)));
1768: hr_utility.trace('l_dp_total(22) = ' || to_char(l_dp_total(22)));
1769: hr_utility.trace('l_dp_total(23) = ' || to_char(l_dp_total(23)));

Line 1766: hr_utility.trace('l_dp_total(20) = ' || to_char(l_dp_total(20)));

1762: hr_utility.trace('l_dp_total(16) = ' || to_char(l_dp_total(16)));
1763: hr_utility.trace('l_dp_total(17) = ' || to_char(l_dp_total(17)));
1764: hr_utility.trace('l_dp_total(18) = ' || to_char(l_dp_total(18)));
1765: hr_utility.trace('l_dp_total(19) = ' || to_char(l_dp_total(19)));
1766: hr_utility.trace('l_dp_total(20) = ' || to_char(l_dp_total(20)));
1767: hr_utility.trace('l_dp_total(21) = ' || to_char(l_dp_total(21)));
1768: hr_utility.trace('l_dp_total(22) = ' || to_char(l_dp_total(22)));
1769: hr_utility.trace('l_dp_total(23) = ' || to_char(l_dp_total(23)));
1770: hr_utility.trace('l_dp_total(24) = ' || to_char(l_dp_total(24)));

Line 1767: hr_utility.trace('l_dp_total(21) = ' || to_char(l_dp_total(21)));

1763: hr_utility.trace('l_dp_total(17) = ' || to_char(l_dp_total(17)));
1764: hr_utility.trace('l_dp_total(18) = ' || to_char(l_dp_total(18)));
1765: hr_utility.trace('l_dp_total(19) = ' || to_char(l_dp_total(19)));
1766: hr_utility.trace('l_dp_total(20) = ' || to_char(l_dp_total(20)));
1767: hr_utility.trace('l_dp_total(21) = ' || to_char(l_dp_total(21)));
1768: hr_utility.trace('l_dp_total(22) = ' || to_char(l_dp_total(22)));
1769: hr_utility.trace('l_dp_total(23) = ' || to_char(l_dp_total(23)));
1770: hr_utility.trace('l_dp_total(24) = ' || to_char(l_dp_total(24)));
1771: hr_utility.trace('l_dp_total(25) = ' || to_char(l_dp_total(25)));

Line 1768: hr_utility.trace('l_dp_total(22) = ' || to_char(l_dp_total(22)));

1764: hr_utility.trace('l_dp_total(18) = ' || to_char(l_dp_total(18)));
1765: hr_utility.trace('l_dp_total(19) = ' || to_char(l_dp_total(19)));
1766: hr_utility.trace('l_dp_total(20) = ' || to_char(l_dp_total(20)));
1767: hr_utility.trace('l_dp_total(21) = ' || to_char(l_dp_total(21)));
1768: hr_utility.trace('l_dp_total(22) = ' || to_char(l_dp_total(22)));
1769: hr_utility.trace('l_dp_total(23) = ' || to_char(l_dp_total(23)));
1770: hr_utility.trace('l_dp_total(24) = ' || to_char(l_dp_total(24)));
1771: hr_utility.trace('l_dp_total(25) = ' || to_char(l_dp_total(25)));
1772: hr_utility.trace('l_dp_total(26) = ' || to_char(l_dp_total(26)));

Line 1769: hr_utility.trace('l_dp_total(23) = ' || to_char(l_dp_total(23)));

1765: hr_utility.trace('l_dp_total(19) = ' || to_char(l_dp_total(19)));
1766: hr_utility.trace('l_dp_total(20) = ' || to_char(l_dp_total(20)));
1767: hr_utility.trace('l_dp_total(21) = ' || to_char(l_dp_total(21)));
1768: hr_utility.trace('l_dp_total(22) = ' || to_char(l_dp_total(22)));
1769: hr_utility.trace('l_dp_total(23) = ' || to_char(l_dp_total(23)));
1770: hr_utility.trace('l_dp_total(24) = ' || to_char(l_dp_total(24)));
1771: hr_utility.trace('l_dp_total(25) = ' || to_char(l_dp_total(25)));
1772: hr_utility.trace('l_dp_total(26) = ' || to_char(l_dp_total(26)));
1773: hr_utility.trace('l_dp_total(27) = ' || to_char(l_dp_total(27)));

Line 1770: hr_utility.trace('l_dp_total(24) = ' || to_char(l_dp_total(24)));

1766: hr_utility.trace('l_dp_total(20) = ' || to_char(l_dp_total(20)));
1767: hr_utility.trace('l_dp_total(21) = ' || to_char(l_dp_total(21)));
1768: hr_utility.trace('l_dp_total(22) = ' || to_char(l_dp_total(22)));
1769: hr_utility.trace('l_dp_total(23) = ' || to_char(l_dp_total(23)));
1770: hr_utility.trace('l_dp_total(24) = ' || to_char(l_dp_total(24)));
1771: hr_utility.trace('l_dp_total(25) = ' || to_char(l_dp_total(25)));
1772: hr_utility.trace('l_dp_total(26) = ' || to_char(l_dp_total(26)));
1773: hr_utility.trace('l_dp_total(27) = ' || to_char(l_dp_total(27)));
1774:

Line 1771: hr_utility.trace('l_dp_total(25) = ' || to_char(l_dp_total(25)));

1767: hr_utility.trace('l_dp_total(21) = ' || to_char(l_dp_total(21)));
1768: hr_utility.trace('l_dp_total(22) = ' || to_char(l_dp_total(22)));
1769: hr_utility.trace('l_dp_total(23) = ' || to_char(l_dp_total(23)));
1770: hr_utility.trace('l_dp_total(24) = ' || to_char(l_dp_total(24)));
1771: hr_utility.trace('l_dp_total(25) = ' || to_char(l_dp_total(25)));
1772: hr_utility.trace('l_dp_total(26) = ' || to_char(l_dp_total(26)));
1773: hr_utility.trace('l_dp_total(27) = ' || to_char(l_dp_total(27)));
1774:
1775:

Line 1772: hr_utility.trace('l_dp_total(26) = ' || to_char(l_dp_total(26)));

1768: hr_utility.trace('l_dp_total(22) = ' || to_char(l_dp_total(22)));
1769: hr_utility.trace('l_dp_total(23) = ' || to_char(l_dp_total(23)));
1770: hr_utility.trace('l_dp_total(24) = ' || to_char(l_dp_total(24)));
1771: hr_utility.trace('l_dp_total(25) = ' || to_char(l_dp_total(25)));
1772: hr_utility.trace('l_dp_total(26) = ' || to_char(l_dp_total(26)));
1773: hr_utility.trace('l_dp_total(27) = ' || to_char(l_dp_total(27)));
1774:
1775:
1776: hr_utility.set_location(l_proc_name, 100);

Line 1773: hr_utility.trace('l_dp_total(27) = ' || to_char(l_dp_total(27)));

1769: hr_utility.trace('l_dp_total(23) = ' || to_char(l_dp_total(23)));
1770: hr_utility.trace('l_dp_total(24) = ' || to_char(l_dp_total(24)));
1771: hr_utility.trace('l_dp_total(25) = ' || to_char(l_dp_total(25)));
1772: hr_utility.trace('l_dp_total(26) = ' || to_char(l_dp_total(26)));
1773: hr_utility.trace('l_dp_total(27) = ' || to_char(l_dp_total(27)));
1774:
1775:
1776: hr_utility.set_location(l_proc_name, 100);
1777:

Line 1776: hr_utility.set_location(l_proc_name, 100);

1772: hr_utility.trace('l_dp_total(26) = ' || to_char(l_dp_total(26)));
1773: hr_utility.trace('l_dp_total(27) = ' || to_char(l_dp_total(27)));
1774:
1775:
1776: hr_utility.set_location(l_proc_name, 100);
1777:
1778: -- If the hire date is later than either the
1779: -- previous roe date (p_start_date) or the
1780: -- starting date for the current roe then hire

Line 1789: hr_utility.trace('l_hire_date = ' || to_char(l_hire_date));

1785: fetch cur_date_of_hire
1786: into l_hire_date;
1787: close cur_date_of_hire;
1788:
1789: hr_utility.trace('l_hire_date = ' || to_char(l_hire_date));
1790:
1791: if p_start_date is not null and
1792: p_start_date > l_start_date then
1793:

Line 1794: hr_utility.trace('p_start_date = ' || to_char(p_start_date));

1790:
1791: if p_start_date is not null and
1792: p_start_date > l_start_date then
1793:
1794: hr_utility.trace('p_start_date = ' || to_char(p_start_date));
1795:
1796: if l_hire_date > p_start_date then
1797: l_start_date1 := l_hire_date;
1798: else

Line 1804: hr_utility.trace('l_start_date = ' || to_char(l_start_date));

1800: end if;
1801:
1802: else
1803:
1804: hr_utility.trace('l_start_date = ' || to_char(l_start_date));
1805:
1806: if l_hire_date > l_start_date then
1807: l_start_date1 := l_hire_date;
1808: else

Line 1814: hr_utility.trace('l_start_date1 = ' || to_char(l_start_date1));

1810: end if;
1811:
1812: end if;
1813:
1814: hr_utility.trace('l_start_date1 = ' || to_char(l_start_date1));
1815:
1816: OPEN cur_count_pay_periods(l_start_date1);
1817: FETCH cur_count_pay_periods
1818: INTO l_no_of_pay_periods;

Line 1821: hr_utility.trace('l_no_of_pay_periods = ' || to_char(l_no_of_pay_periods));

1817: FETCH cur_count_pay_periods
1818: INTO l_no_of_pay_periods;
1819: CLOSE cur_count_pay_periods;
1820:
1821: hr_utility.trace('l_no_of_pay_periods = ' || to_char(l_no_of_pay_periods));
1822: hr_utility.trace('l_period_count = ' || to_char(l_period_count));
1823:
1824: FOR l_index IN 1..l_period_count LOOP
1825:

Line 1822: hr_utility.trace('l_period_count = ' || to_char(l_period_count));

1818: INTO l_no_of_pay_periods;
1819: CLOSE cur_count_pay_periods;
1820:
1821: hr_utility.trace('l_no_of_pay_periods = ' || to_char(l_no_of_pay_periods));
1822: hr_utility.trace('l_period_count = ' || to_char(l_period_count));
1823:
1824: FOR l_index IN 1..l_period_count LOOP
1825:
1826: p_period_total(l_index) := l_dp_total(l_index) + l_de_total(l_index);

Line 1828: hr_utility.trace('l_dp_total = ' || to_char(l_dp_total(l_index)));

1824: FOR l_index IN 1..l_period_count LOOP
1825:
1826: p_period_total(l_index) := l_dp_total(l_index) + l_de_total(l_index);
1827:
1828: hr_utility.trace('l_dp_total = ' || to_char(l_dp_total(l_index)));
1829: hr_utility.trace('l_de_total = ' || to_char(l_de_total(l_index)));
1830: hr_utility.trace('l_index = ' || to_char(l_index));
1831:
1832: IF p_period_total(l_index) = 0 and

Line 1829: hr_utility.trace('l_de_total = ' || to_char(l_de_total(l_index)));

1825:
1826: p_period_total(l_index) := l_dp_total(l_index) + l_de_total(l_index);
1827:
1828: hr_utility.trace('l_dp_total = ' || to_char(l_dp_total(l_index)));
1829: hr_utility.trace('l_de_total = ' || to_char(l_de_total(l_index)));
1830: hr_utility.trace('l_index = ' || to_char(l_index));
1831:
1832: IF p_period_total(l_index) = 0 and
1833: l_index <= l_no_of_pay_periods THEN

Line 1830: hr_utility.trace('l_index = ' || to_char(l_index));

1826: p_period_total(l_index) := l_dp_total(l_index) + l_de_total(l_index);
1827:
1828: hr_utility.trace('l_dp_total = ' || to_char(l_dp_total(l_index)));
1829: hr_utility.trace('l_de_total = ' || to_char(l_de_total(l_index)));
1830: hr_utility.trace('l_index = ' || to_char(l_index));
1831:
1832: IF p_period_total(l_index) = 0 and
1833: l_index <= l_no_of_pay_periods THEN
1834: l_box15c_flag := TRUE;

Line 1846: hr_utility.trace('Retro Functionality starts here');

1842: p_no_of_periods := l_period_count;
1843:
1844: -- Retro Functionality starts here
1845:
1846: hr_utility.trace('Retro Functionality starts here');
1847:
1848: for i in cur_retro_run(l_start_date,
1849: l_last_period_end_date) loop
1850:

Line 1851: hr_utility.trace('cur_retro_run found');

1847:
1848: for i in cur_retro_run(l_start_date,
1849: l_last_period_end_date) loop
1850:
1851: hr_utility.trace('cur_retro_run found');
1852: hr_utility.trace('i.effective_date = ' || to_char(i.effective_date));
1853: hr_utility.trace('i.start_date = ' || to_char(i.start_date));
1854:
1855: open cur_curr_pay_period_dates(i.effective_date);

Line 1852: hr_utility.trace('i.effective_date = ' || to_char(i.effective_date));

1848: for i in cur_retro_run(l_start_date,
1849: l_last_period_end_date) loop
1850:
1851: hr_utility.trace('cur_retro_run found');
1852: hr_utility.trace('i.effective_date = ' || to_char(i.effective_date));
1853: hr_utility.trace('i.start_date = ' || to_char(i.start_date));
1854:
1855: open cur_curr_pay_period_dates(i.effective_date);
1856: fetch cur_curr_pay_period_dates

Line 1853: hr_utility.trace('i.start_date = ' || to_char(i.start_date));

1849: l_last_period_end_date) loop
1850:
1851: hr_utility.trace('cur_retro_run found');
1852: hr_utility.trace('i.effective_date = ' || to_char(i.effective_date));
1853: hr_utility.trace('i.start_date = ' || to_char(i.start_date));
1854:
1855: open cur_curr_pay_period_dates(i.effective_date);
1856: fetch cur_curr_pay_period_dates
1857: into l_pay_period_start_date,

Line 1861: hr_utility.trace('l_pay_period_start_date = ' || to_char(l_pay_period_start_date));

1857: into l_pay_period_start_date,
1858: l_pay_period_end_date;
1859: close cur_curr_pay_period_dates;
1860:
1861: hr_utility.trace('l_pay_period_start_date = ' || to_char(l_pay_period_start_date));
1862: hr_utility.trace('l_pay_period_end_date = ' || to_char(l_pay_period_end_date));
1863:
1864: open cur_payroll_exists(l_pay_period_start_date,
1865: l_pay_period_end_date);

Line 1862: hr_utility.trace('l_pay_period_end_date = ' || to_char(l_pay_period_end_date));

1858: l_pay_period_end_date;
1859: close cur_curr_pay_period_dates;
1860:
1861: hr_utility.trace('l_pay_period_start_date = ' || to_char(l_pay_period_start_date));
1862: hr_utility.trace('l_pay_period_end_date = ' || to_char(l_pay_period_end_date));
1863:
1864: open cur_payroll_exists(l_pay_period_start_date,
1865: l_pay_period_end_date);
1866: fetch cur_payroll_exists

Line 1876: hr_utility.trace('k.element_type_id = ' || to_char(k.element_type_id));

1872:
1873: for k in cur_ele_entries(l_pay_period_start_date,
1874: l_pay_period_end_date) loop
1875:
1876: hr_utility.trace('k.element_type_id = ' || to_char(k.element_type_id));
1877: hr_utility.trace('k.creator_type = ' || k.creator_type);
1878: hr_utility.trace('k.source_id = ' || to_char(nvl(k.source_id,0)));
1879: hr_utility.trace('k.source_asg_action_id = ' || to_char(nvl(k.source_asg_action_id,0)));
1880: hr_utility.trace('k.screen_entry_value = ' || nvl(k.screen_entry_value,'0'));

Line 1877: hr_utility.trace('k.creator_type = ' || k.creator_type);

1873: for k in cur_ele_entries(l_pay_period_start_date,
1874: l_pay_period_end_date) loop
1875:
1876: hr_utility.trace('k.element_type_id = ' || to_char(k.element_type_id));
1877: hr_utility.trace('k.creator_type = ' || k.creator_type);
1878: hr_utility.trace('k.source_id = ' || to_char(nvl(k.source_id,0)));
1879: hr_utility.trace('k.source_asg_action_id = ' || to_char(nvl(k.source_asg_action_id,0)));
1880: hr_utility.trace('k.screen_entry_value = ' || nvl(k.screen_entry_value,'0'));
1881: hr_utility.trace('k.element_entry_id = ' || to_char(k.element_entry_id));

Line 1878: hr_utility.trace('k.source_id = ' || to_char(nvl(k.source_id,0)));

1874: l_pay_period_end_date) loop
1875:
1876: hr_utility.trace('k.element_type_id = ' || to_char(k.element_type_id));
1877: hr_utility.trace('k.creator_type = ' || k.creator_type);
1878: hr_utility.trace('k.source_id = ' || to_char(nvl(k.source_id,0)));
1879: hr_utility.trace('k.source_asg_action_id = ' || to_char(nvl(k.source_asg_action_id,0)));
1880: hr_utility.trace('k.screen_entry_value = ' || nvl(k.screen_entry_value,'0'));
1881: hr_utility.trace('k.element_entry_id = ' || to_char(k.element_entry_id));
1882: hr_utility.trace('k.classification_name = ' || nvl(k.classification_name,' '));

Line 1879: hr_utility.trace('k.source_asg_action_id = ' || to_char(nvl(k.source_asg_action_id,0)));

1875:
1876: hr_utility.trace('k.element_type_id = ' || to_char(k.element_type_id));
1877: hr_utility.trace('k.creator_type = ' || k.creator_type);
1878: hr_utility.trace('k.source_id = ' || to_char(nvl(k.source_id,0)));
1879: hr_utility.trace('k.source_asg_action_id = ' || to_char(nvl(k.source_asg_action_id,0)));
1880: hr_utility.trace('k.screen_entry_value = ' || nvl(k.screen_entry_value,'0'));
1881: hr_utility.trace('k.element_entry_id = ' || to_char(k.element_entry_id));
1882: hr_utility.trace('k.classification_name = ' || nvl(k.classification_name,' '));
1883: hr_utility.trace('k.classification_id = ' || to_char(nvl(k.classification_id,0)));

Line 1880: hr_utility.trace('k.screen_entry_value = ' || nvl(k.screen_entry_value,'0'));

1876: hr_utility.trace('k.element_type_id = ' || to_char(k.element_type_id));
1877: hr_utility.trace('k.creator_type = ' || k.creator_type);
1878: hr_utility.trace('k.source_id = ' || to_char(nvl(k.source_id,0)));
1879: hr_utility.trace('k.source_asg_action_id = ' || to_char(nvl(k.source_asg_action_id,0)));
1880: hr_utility.trace('k.screen_entry_value = ' || nvl(k.screen_entry_value,'0'));
1881: hr_utility.trace('k.element_entry_id = ' || to_char(k.element_entry_id));
1882: hr_utility.trace('k.classification_name = ' || nvl(k.classification_name,' '));
1883: hr_utility.trace('k.classification_id = ' || to_char(nvl(k.classification_id,0)));
1884: hr_utility.trace('k.element_information1 = ' || k.element_information1);

Line 1881: hr_utility.trace('k.element_entry_id = ' || to_char(k.element_entry_id));

1877: hr_utility.trace('k.creator_type = ' || k.creator_type);
1878: hr_utility.trace('k.source_id = ' || to_char(nvl(k.source_id,0)));
1879: hr_utility.trace('k.source_asg_action_id = ' || to_char(nvl(k.source_asg_action_id,0)));
1880: hr_utility.trace('k.screen_entry_value = ' || nvl(k.screen_entry_value,'0'));
1881: hr_utility.trace('k.element_entry_id = ' || to_char(k.element_entry_id));
1882: hr_utility.trace('k.classification_name = ' || nvl(k.classification_name,' '));
1883: hr_utility.trace('k.classification_id = ' || to_char(nvl(k.classification_id,0)));
1884: hr_utility.trace('k.element_information1 = ' || k.element_information1);
1885:

Line 1882: hr_utility.trace('k.classification_name = ' || nvl(k.classification_name,' '));

1878: hr_utility.trace('k.source_id = ' || to_char(nvl(k.source_id,0)));
1879: hr_utility.trace('k.source_asg_action_id = ' || to_char(nvl(k.source_asg_action_id,0)));
1880: hr_utility.trace('k.screen_entry_value = ' || nvl(k.screen_entry_value,'0'));
1881: hr_utility.trace('k.element_entry_id = ' || to_char(k.element_entry_id));
1882: hr_utility.trace('k.classification_name = ' || nvl(k.classification_name,' '));
1883: hr_utility.trace('k.classification_id = ' || to_char(nvl(k.classification_id,0)));
1884: hr_utility.trace('k.element_information1 = ' || k.element_information1);
1885:
1886: if (((k.element_entry_id <> l_prev_element_entry_id) or

Line 1883: hr_utility.trace('k.classification_id = ' || to_char(nvl(k.classification_id,0)));

1879: hr_utility.trace('k.source_asg_action_id = ' || to_char(nvl(k.source_asg_action_id,0)));
1880: hr_utility.trace('k.screen_entry_value = ' || nvl(k.screen_entry_value,'0'));
1881: hr_utility.trace('k.element_entry_id = ' || to_char(k.element_entry_id));
1882: hr_utility.trace('k.classification_name = ' || nvl(k.classification_name,' '));
1883: hr_utility.trace('k.classification_id = ' || to_char(nvl(k.classification_id,0)));
1884: hr_utility.trace('k.element_information1 = ' || k.element_information1);
1885:
1886: if (((k.element_entry_id <> l_prev_element_entry_id) or
1887: (l_prev_element_entry_id is null)) and

Line 1884: hr_utility.trace('k.element_information1 = ' || k.element_information1);

1880: hr_utility.trace('k.screen_entry_value = ' || nvl(k.screen_entry_value,'0'));
1881: hr_utility.trace('k.element_entry_id = ' || to_char(k.element_entry_id));
1882: hr_utility.trace('k.classification_name = ' || nvl(k.classification_name,' '));
1883: hr_utility.trace('k.classification_id = ' || to_char(nvl(k.classification_id,0)));
1884: hr_utility.trace('k.element_information1 = ' || k.element_information1);
1885:
1886: if (((k.element_entry_id <> l_prev_element_entry_id) or
1887: (l_prev_element_entry_id is null)) and
1888: (taxability_rule_exists(k.classification_name,

Line 1931: hr_utility.trace('period_from = ' || to_char(period_from));

1927:
1928: period_to := pay_ca_roe_ei_pkg.get_pd_num(l_start_period,
1929: l_last_period_end_date);
1930:
1931: hr_utility.trace('period_from = ' || to_char(period_from));
1932: hr_utility.trace('period_to = ' || to_char(period_to));
1933:
1934: p_period_total(period_from) := p_period_total(period_from) - l_value;
1935: p_period_total(period_to) := p_period_total(period_to) + l_value;

Line 1932: hr_utility.trace('period_to = ' || to_char(period_to));

1928: period_to := pay_ca_roe_ei_pkg.get_pd_num(l_start_period,
1929: l_last_period_end_date);
1930:
1931: hr_utility.trace('period_from = ' || to_char(period_from));
1932: hr_utility.trace('period_to = ' || to_char(period_to));
1933:
1934: p_period_total(period_from) := p_period_total(period_from) - l_value;
1935: p_period_total(period_to) := p_period_total(period_to) + l_value;
1936:

Line 1951: hr_utility.set_location(l_proc_name, 120);

1947: end loop;
1948:
1949: -- Retro Functionality ends here;
1950:
1951: hr_utility.set_location(l_proc_name, 120);
1952: IF l_box15c_flag THEN
1953: hr_utility.set_location('Ending: ' || l_proc_name, 130);
1954: RETURN 'BOX15C';
1955: ELSE

Line 1953: hr_utility.set_location('Ending: ' || l_proc_name, 130);

1949: -- Retro Functionality ends here;
1950:
1951: hr_utility.set_location(l_proc_name, 120);
1952: IF l_box15c_flag THEN
1953: hr_utility.set_location('Ending: ' || l_proc_name, 130);
1954: RETURN 'BOX15C';
1955: ELSE
1956: hr_utility.set_location('Ending: ' || l_proc_name, 140);
1957: RETURN 'BOX15B';

Line 1956: hr_utility.set_location('Ending: ' || l_proc_name, 140);

1952: IF l_box15c_flag THEN
1953: hr_utility.set_location('Ending: ' || l_proc_name, 130);
1954: RETURN 'BOX15C';
1955: ELSE
1956: hr_utility.set_location('Ending: ' || l_proc_name, 140);
1957: RETURN 'BOX15B';
1958: END IF;
1959:
1960: END IF;