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 1471: hr_utility.set_location('Starting: ' || l_proc_name, 10);

1467: l_hour_start_date DATE;
1468:
1469: BEGIN
1470:
1471: hr_utility.set_location('Starting: ' || l_proc_name, 10);
1472: hr_utility.set_location('p_start_date: ' || to_char(p_start_date), 11);
1473: hr_utility.set_location('p_end_date: ' || p_end_date, 12);
1474:
1475: /*

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

1468:
1469: BEGIN
1470:
1471: hr_utility.set_location('Starting: ' || l_proc_name, 10);
1472: hr_utility.set_location('p_start_date: ' || to_char(p_start_date), 11);
1473: hr_utility.set_location('p_end_date: ' || p_end_date, 12);
1474:
1475: /*
1476: * Initialise the output parameters

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

1469: BEGIN
1470:
1471: hr_utility.set_location('Starting: ' || l_proc_name, 10);
1472: hr_utility.set_location('p_start_date: ' || to_char(p_start_date), 11);
1473: hr_utility.set_location('p_end_date: ' || p_end_date, 12);
1474:
1475: /*
1476: * Initialise the output parameters
1477: */

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

1487: l_last_period_end_date;
1488: CLOSE csr_get_period_type;
1489:
1490:
1491: hr_utility.set_location('l_last_period_start_date: ' ||
1492: l_last_period_start_date, 13);
1493: hr_utility.set_location(l_proc_name, 20);
1494: IF p_total_type = 'EI Hours' THEN
1495:

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

1489:
1490:
1491: hr_utility.set_location('l_last_period_start_date: ' ||
1492: l_last_period_start_date, 13);
1493: hr_utility.set_location(l_proc_name, 20);
1494: IF p_total_type = 'EI Hours' THEN
1495:
1496: IF p_period_type = 'Week' OR
1497: p_period_type = 'Bi-Week' OR

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

1495:
1496: IF p_period_type = 'Week' OR
1497: p_period_type = 'Bi-Week' OR
1498: p_period_type = 'Lunar Month' THEN
1499: hr_utility.set_location(l_proc_name, 30);
1500: l_start_date := l_last_period_start_date - 364;
1501: ELSIF p_period_type = 'Semi-Month' OR
1502: p_period_type = 'Calendar Month' THEN
1503: hr_utility.set_location(l_proc_name, 40);

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

1499: hr_utility.set_location(l_proc_name, 30);
1500: l_start_date := l_last_period_start_date - 364;
1501: ELSIF p_period_type = 'Semi-Month' OR
1502: p_period_type = 'Calendar Month' THEN
1503: hr_utility.set_location(l_proc_name, 40);
1504: l_start_date := ADD_MONTHS(l_last_period_start_date, -12);
1505: END IF;
1506:
1507: hr_utility.set_location('EI Hours l_start_date: ' ||

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

1503: hr_utility.set_location(l_proc_name, 40);
1504: l_start_date := ADD_MONTHS(l_last_period_start_date, -12);
1505: END IF;
1506:
1507: hr_utility.set_location('EI Hours l_start_date: ' ||
1508: l_start_date, 20);
1509:
1510: hr_utility.set_location('EI Hours p_start_date: ' ||
1511: p_start_date, 20);

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

1506:
1507: hr_utility.set_location('EI Hours l_start_date: ' ||
1508: l_start_date, 20);
1509:
1510: hr_utility.set_location('EI Hours p_start_date: ' ||
1511: p_start_date, 20);
1512:
1513: l_period_start_date_exists := 'N';
1514:

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

1521: close cur_next_prd_start_date;
1522:
1523: l_start_date := p_start_date;
1524:
1525: hr_utility.trace('l_next_prd_start_date : '||to_char(l_next_prd_start_date));
1526: hr_utility.trace('l_start_date : '||to_char(l_start_date));
1527:
1528: -- Check to see if l_start_date is the start date of a period
1529: -- If it is, then we set l_period_start_date_exists to Y

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

1522:
1523: l_start_date := p_start_date;
1524:
1525: hr_utility.trace('l_next_prd_start_date : '||to_char(l_next_prd_start_date));
1526: hr_utility.trace('l_start_date : '||to_char(l_start_date));
1527:
1528: -- Check to see if l_start_date is the start date of a period
1529: -- If it is, then we set l_period_start_date_exists to Y
1530: -- this means that the previous ROE date was on the last day

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

1571: l_hour_start_date := l_start_date;
1572:
1573: END IF;
1574:
1575: hr_utility.trace('EI Hours: l_hour_start_date = '
1576: || to_char(l_hour_start_date));
1577: OPEN cur_ftr(l_hour_start_date,
1578: l_pay_period_end_date);
1579: FETCH cur_ftr

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

1579: FETCH cur_ftr
1580: INTO dummy;
1581:
1582: IF cur_ftr%NOTFOUND THEN
1583: hr_utility.trace('EI Hours cur_ftr not Found !!!');
1584: l_ftr_exists := FALSE;
1585: ELSE
1586: hr_utility.trace('EI Hours cur_ftr Found !!!');
1587: l_ftr_exists := TRUE;

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

1582: IF cur_ftr%NOTFOUND THEN
1583: hr_utility.trace('EI Hours cur_ftr not Found !!!');
1584: l_ftr_exists := FALSE;
1585: ELSE
1586: hr_utility.trace('EI Hours cur_ftr Found !!!');
1587: l_ftr_exists := TRUE;
1588: END IF;
1589:
1590: CLOSE cur_ftr;

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

1590: CLOSE cur_ftr;
1591:
1592: IF l_ftr_exists THEN
1593:
1594: hr_utility.trace('EI Hours l_ftr_exists !!!');
1595: OPEN csr_dp_hours_total_ftr_exists(p_assignment_id,
1596: p_gre,
1597: l_hour_start_date,
1598: l_last_period_end_date);

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

1607: CLOSE csr_de_hours_total_ftr_exists;
1608:
1609: ELSE
1610:
1611: hr_utility.trace('EI Hours NOT l_ftr_exists !!!');
1612: OPEN csr_dp_hours_total_ftr_nexists(p_assignment_id,
1613: p_gre,
1614: l_hour_start_date,
1615: l_last_period_end_date);

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

1624: CLOSE csr_de_hours_total_ftr_nexists;
1625:
1626: END IF;
1627:
1628: hr_utility.trace (' l_dp_hours_total = ' || to_char(l_dp_hours_total));
1629: hr_utility.trace (' l_de_hours_total = ' || to_char(l_de_hours_total));
1630:
1631: p_total_insurable := NVL(l_dp_hours_total,0) +
1632: NVL(l_de_hours_total,0);

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

1625:
1626: END IF;
1627:
1628: hr_utility.trace (' l_dp_hours_total = ' || to_char(l_dp_hours_total));
1629: hr_utility.trace (' l_de_hours_total = ' || to_char(l_de_hours_total));
1630:
1631: p_total_insurable := NVL(l_dp_hours_total,0) +
1632: NVL(l_de_hours_total,0);
1633:

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

1630:
1631: p_total_insurable := NVL(l_dp_hours_total,0) +
1632: NVL(l_de_hours_total,0);
1633:
1634: hr_utility.trace('Total Hours : '|| to_char(p_total_insurable));
1635:
1636: RETURN 'BOX15A';
1637:
1638: ELSIF p_total_type = 'EI Earnings' THEN

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

1637:
1638: ELSIF p_total_type = 'EI Earnings' THEN
1639: /* Modified the period count for bug 4510534 */
1640: IF p_period_type = 'Week' THEN
1641: hr_utility.set_location(l_proc_name, 50);
1642: l_start_date := l_last_period_start_date - 365;
1643: l_period_count := 53;
1644: l_period_count1 := 27;
1645: ELSIF p_period_type = 'Bi-Week' THEN

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

1642: l_start_date := l_last_period_start_date - 365;
1643: l_period_count := 53;
1644: l_period_count1 := 27;
1645: ELSIF p_period_type = 'Bi-Week' THEN
1646: hr_utility.set_location(l_proc_name, 60);
1647: l_start_date := l_last_period_start_date - 365;
1648: l_period_count := 27;
1649: l_period_count1 := 14;
1650: ELSIF p_period_type = 'Semi-Month' THEN

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

1647: l_start_date := l_last_period_start_date - 365;
1648: l_period_count := 27;
1649: l_period_count1 := 14;
1650: ELSIF p_period_type = 'Semi-Month' THEN
1651: hr_utility.set_location(l_proc_name, 70);
1652: l_start_date := ADD_MONTHS(l_last_period_start_date, -12);
1653: l_period_count := 25;
1654: l_period_count1 := 13;
1655: ELSIF p_period_type = 'Calendar Month' THEN

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

1652: l_start_date := ADD_MONTHS(l_last_period_start_date, -12);
1653: l_period_count := 25;
1654: l_period_count1 := 13;
1655: ELSIF p_period_type = 'Calendar Month' THEN
1656: hr_utility.set_location(l_proc_name, 80);
1657: l_start_date := ADD_MONTHS(l_last_period_start_date, -12);
1658: l_period_count := 13;
1659: l_period_count1 := 7;
1660: ELSIF p_period_type = 'Lunar Month' THEN

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

1657: l_start_date := ADD_MONTHS(l_last_period_start_date, -12);
1658: l_period_count := 13;
1659: l_period_count1 := 7;
1660: ELSIF p_period_type = 'Lunar Month' THEN
1661: hr_utility.set_location(l_proc_name, 90);
1662: l_start_date := l_last_period_start_date - 336;
1663: l_period_count := 14;
1664: l_period_count1 := 7;
1665: END IF;

Line 1695: hr_utility.trace('p_assignment_id de' || to_char(p_assignment_id));

1691: p_assignment_id,
1692: l_start_date,
1693: l_prd_end_date_after_final,
1694: l_prd_st_date_after_final);
1695: hr_utility.trace('p_assignment_id de' || to_char(p_assignment_id));
1696: hr_utility.trace('p_gre de' || to_char(p_gre));
1697: hr_utility.trace('l_start_date de' || to_char(l_start_date));
1698: hr_utility.trace('l_prd_end_date_after_final de' || to_char(l_prd_end_date_after_final));
1699:

Line 1696: hr_utility.trace('p_gre de' || to_char(p_gre));

1692: l_start_date,
1693: l_prd_end_date_after_final,
1694: l_prd_st_date_after_final);
1695: hr_utility.trace('p_assignment_id de' || to_char(p_assignment_id));
1696: hr_utility.trace('p_gre de' || to_char(p_gre));
1697: hr_utility.trace('l_start_date de' || to_char(l_start_date));
1698: hr_utility.trace('l_prd_end_date_after_final de' || to_char(l_prd_end_date_after_final));
1699:
1700:

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

1693: l_prd_end_date_after_final,
1694: l_prd_st_date_after_final);
1695: hr_utility.trace('p_assignment_id de' || to_char(p_assignment_id));
1696: hr_utility.trace('p_gre de' || to_char(p_gre));
1697: hr_utility.trace('l_start_date de' || to_char(l_start_date));
1698: hr_utility.trace('l_prd_end_date_after_final de' || to_char(l_prd_end_date_after_final));
1699:
1700:
1701:

Line 1698: hr_utility.trace('l_prd_end_date_after_final de' || to_char(l_prd_end_date_after_final));

1694: l_prd_st_date_after_final);
1695: hr_utility.trace('p_assignment_id de' || to_char(p_assignment_id));
1696: hr_utility.trace('p_gre de' || to_char(p_gre));
1697: hr_utility.trace('l_start_date de' || to_char(l_start_date));
1698: hr_utility.trace('l_prd_end_date_after_final de' || to_char(l_prd_end_date_after_final));
1699:
1700:
1701:
1702: /* Modified the code to add aadditional amounts 28 to 53 for bug4510534 */

Line 1762: hr_utility.trace('p_assignment_id dp' || to_char(p_assignment_id));

1758: l_de_total(52),
1759: l_de_total(53) ;
1760: CLOSE csr_get_de_total;
1761:
1762: hr_utility.trace('p_assignment_id dp' || to_char(p_assignment_id));
1763: hr_utility.trace('p_gre dp' || to_char(p_gre));
1764: hr_utility.trace('l_start_date dp' || to_char(l_start_date));
1765: hr_utility.trace('l_prd_end_date_after_final dp' || to_char(l_prd_end_date_after_final));
1766:

Line 1763: hr_utility.trace('p_gre dp' || to_char(p_gre));

1759: l_de_total(53) ;
1760: CLOSE csr_get_de_total;
1761:
1762: hr_utility.trace('p_assignment_id dp' || to_char(p_assignment_id));
1763: hr_utility.trace('p_gre dp' || to_char(p_gre));
1764: hr_utility.trace('l_start_date dp' || to_char(l_start_date));
1765: hr_utility.trace('l_prd_end_date_after_final dp' || to_char(l_prd_end_date_after_final));
1766:
1767:

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

1760: CLOSE csr_get_de_total;
1761:
1762: hr_utility.trace('p_assignment_id dp' || to_char(p_assignment_id));
1763: hr_utility.trace('p_gre dp' || to_char(p_gre));
1764: hr_utility.trace('l_start_date dp' || to_char(l_start_date));
1765: hr_utility.trace('l_prd_end_date_after_final dp' || to_char(l_prd_end_date_after_final));
1766:
1767:
1768:

Line 1765: hr_utility.trace('l_prd_end_date_after_final dp' || to_char(l_prd_end_date_after_final));

1761:
1762: hr_utility.trace('p_assignment_id dp' || to_char(p_assignment_id));
1763: hr_utility.trace('p_gre dp' || to_char(p_gre));
1764: hr_utility.trace('l_start_date dp' || to_char(l_start_date));
1765: hr_utility.trace('l_prd_end_date_after_final dp' || to_char(l_prd_end_date_after_final));
1766:
1767:
1768:
1769: OPEN csr_get_dp_total(p_assignment_id,

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

1836: l_last_period_end_date,
1837: l_last_period_start_date);
1838: ELSE
1839:
1840: hr_utility.trace('p_assignment_id de1= ' || to_char(p_assignment_id));
1841: hr_utility.trace('p_gre de1= ' || to_char(p_gre));
1842: hr_utility.trace('l_start_date de1= ' || to_char(l_start_date));
1843: hr_utility.trace('l_last_period_end_date de1= '
1844: || to_char(l_last_period_end_date));

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

1837: l_last_period_start_date);
1838: ELSE
1839:
1840: hr_utility.trace('p_assignment_id de1= ' || to_char(p_assignment_id));
1841: hr_utility.trace('p_gre de1= ' || to_char(p_gre));
1842: hr_utility.trace('l_start_date de1= ' || to_char(l_start_date));
1843: hr_utility.trace('l_last_period_end_date de1= '
1844: || to_char(l_last_period_end_date));
1845:

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

1838: ELSE
1839:
1840: hr_utility.trace('p_assignment_id de1= ' || to_char(p_assignment_id));
1841: hr_utility.trace('p_gre de1= ' || to_char(p_gre));
1842: hr_utility.trace('l_start_date de1= ' || to_char(l_start_date));
1843: hr_utility.trace('l_last_period_end_date de1= '
1844: || to_char(l_last_period_end_date));
1845:
1846: OPEN csr_get_de_total1(p_assignment_id,

Line 1843: hr_utility.trace('l_last_period_end_date de1= '

1839:
1840: hr_utility.trace('p_assignment_id de1= ' || to_char(p_assignment_id));
1841: hr_utility.trace('p_gre de1= ' || to_char(p_gre));
1842: hr_utility.trace('l_start_date de1= ' || to_char(l_start_date));
1843: hr_utility.trace('l_last_period_end_date de1= '
1844: || to_char(l_last_period_end_date));
1845:
1846: OPEN csr_get_de_total1(p_assignment_id,
1847: p_gre,

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

1900: l_de_total(51),
1901: l_de_total(52),
1902: l_de_total(53) ;
1903: CLOSE csr_get_de_total1;
1904: hr_utility.trace('p_assignment_id dp1= ' || to_char(p_assignment_id));
1905: hr_utility.trace('p_gre dp1= ' || to_char(p_gre));
1906: hr_utility.trace('l_start_date dp1= ' || to_char(l_start_date));
1907: hr_utility.trace('l_last_period_end_date dp1= '
1908: || to_char(l_last_period_end_date));

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

1901: l_de_total(52),
1902: l_de_total(53) ;
1903: CLOSE csr_get_de_total1;
1904: hr_utility.trace('p_assignment_id dp1= ' || to_char(p_assignment_id));
1905: hr_utility.trace('p_gre dp1= ' || to_char(p_gre));
1906: hr_utility.trace('l_start_date dp1= ' || to_char(l_start_date));
1907: hr_utility.trace('l_last_period_end_date dp1= '
1908: || to_char(l_last_period_end_date));
1909:

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

1902: l_de_total(53) ;
1903: CLOSE csr_get_de_total1;
1904: hr_utility.trace('p_assignment_id dp1= ' || to_char(p_assignment_id));
1905: hr_utility.trace('p_gre dp1= ' || to_char(p_gre));
1906: hr_utility.trace('l_start_date dp1= ' || to_char(l_start_date));
1907: hr_utility.trace('l_last_period_end_date dp1= '
1908: || to_char(l_last_period_end_date));
1909:
1910: OPEN csr_get_dp_total1(p_assignment_id,

Line 1907: hr_utility.trace('l_last_period_end_date dp1= '

1903: CLOSE csr_get_de_total1;
1904: hr_utility.trace('p_assignment_id dp1= ' || to_char(p_assignment_id));
1905: hr_utility.trace('p_gre dp1= ' || to_char(p_gre));
1906: hr_utility.trace('l_start_date dp1= ' || to_char(l_start_date));
1907: hr_utility.trace('l_last_period_end_date dp1= '
1908: || to_char(l_last_period_end_date));
1909:
1910: OPEN csr_get_dp_total1(p_assignment_id,
1911: p_gre,

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

1967: CLOSE csr_get_dp_total1;
1968:
1969: END IF;
1970:
1971: hr_utility.trace('l_de_total(1) = ' || to_char(l_de_total(1)));
1972: hr_utility.trace('l_de_total(2) = ' || to_char(l_de_total(2)));
1973: hr_utility.trace('l_de_total(3) = ' || to_char(l_de_total(3)));
1974: hr_utility.trace('l_de_total(4) = ' || to_char(l_de_total(4)));
1975: hr_utility.trace('l_de_total(5) = ' || to_char(l_de_total(5)));

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

1968:
1969: END IF;
1970:
1971: hr_utility.trace('l_de_total(1) = ' || to_char(l_de_total(1)));
1972: hr_utility.trace('l_de_total(2) = ' || to_char(l_de_total(2)));
1973: hr_utility.trace('l_de_total(3) = ' || to_char(l_de_total(3)));
1974: hr_utility.trace('l_de_total(4) = ' || to_char(l_de_total(4)));
1975: hr_utility.trace('l_de_total(5) = ' || to_char(l_de_total(5)));
1976: hr_utility.trace('l_de_total(6) = ' || to_char(l_de_total(6)));

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

1969: END IF;
1970:
1971: hr_utility.trace('l_de_total(1) = ' || to_char(l_de_total(1)));
1972: hr_utility.trace('l_de_total(2) = ' || to_char(l_de_total(2)));
1973: hr_utility.trace('l_de_total(3) = ' || to_char(l_de_total(3)));
1974: hr_utility.trace('l_de_total(4) = ' || to_char(l_de_total(4)));
1975: hr_utility.trace('l_de_total(5) = ' || to_char(l_de_total(5)));
1976: hr_utility.trace('l_de_total(6) = ' || to_char(l_de_total(6)));
1977: hr_utility.trace('l_de_total(7) = ' || to_char(l_de_total(7)));

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

1970:
1971: hr_utility.trace('l_de_total(1) = ' || to_char(l_de_total(1)));
1972: hr_utility.trace('l_de_total(2) = ' || to_char(l_de_total(2)));
1973: hr_utility.trace('l_de_total(3) = ' || to_char(l_de_total(3)));
1974: hr_utility.trace('l_de_total(4) = ' || to_char(l_de_total(4)));
1975: hr_utility.trace('l_de_total(5) = ' || to_char(l_de_total(5)));
1976: hr_utility.trace('l_de_total(6) = ' || to_char(l_de_total(6)));
1977: hr_utility.trace('l_de_total(7) = ' || to_char(l_de_total(7)));
1978: hr_utility.trace('l_de_total(8) = ' || to_char(l_de_total(8)));

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

1971: hr_utility.trace('l_de_total(1) = ' || to_char(l_de_total(1)));
1972: hr_utility.trace('l_de_total(2) = ' || to_char(l_de_total(2)));
1973: hr_utility.trace('l_de_total(3) = ' || to_char(l_de_total(3)));
1974: hr_utility.trace('l_de_total(4) = ' || to_char(l_de_total(4)));
1975: hr_utility.trace('l_de_total(5) = ' || to_char(l_de_total(5)));
1976: hr_utility.trace('l_de_total(6) = ' || to_char(l_de_total(6)));
1977: hr_utility.trace('l_de_total(7) = ' || to_char(l_de_total(7)));
1978: hr_utility.trace('l_de_total(8) = ' || to_char(l_de_total(8)));
1979: hr_utility.trace('l_de_total(9) = ' || to_char(l_de_total(9)));

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

1972: hr_utility.trace('l_de_total(2) = ' || to_char(l_de_total(2)));
1973: hr_utility.trace('l_de_total(3) = ' || to_char(l_de_total(3)));
1974: hr_utility.trace('l_de_total(4) = ' || to_char(l_de_total(4)));
1975: hr_utility.trace('l_de_total(5) = ' || to_char(l_de_total(5)));
1976: hr_utility.trace('l_de_total(6) = ' || to_char(l_de_total(6)));
1977: hr_utility.trace('l_de_total(7) = ' || to_char(l_de_total(7)));
1978: hr_utility.trace('l_de_total(8) = ' || to_char(l_de_total(8)));
1979: hr_utility.trace('l_de_total(9) = ' || to_char(l_de_total(9)));
1980: hr_utility.trace('l_de_total(10) = ' || to_char(l_de_total(10)));

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

1973: hr_utility.trace('l_de_total(3) = ' || to_char(l_de_total(3)));
1974: hr_utility.trace('l_de_total(4) = ' || to_char(l_de_total(4)));
1975: hr_utility.trace('l_de_total(5) = ' || to_char(l_de_total(5)));
1976: hr_utility.trace('l_de_total(6) = ' || to_char(l_de_total(6)));
1977: hr_utility.trace('l_de_total(7) = ' || to_char(l_de_total(7)));
1978: hr_utility.trace('l_de_total(8) = ' || to_char(l_de_total(8)));
1979: hr_utility.trace('l_de_total(9) = ' || to_char(l_de_total(9)));
1980: hr_utility.trace('l_de_total(10) = ' || to_char(l_de_total(10)));
1981: hr_utility.trace('l_de_total(11) = ' || to_char(l_de_total(11)));

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

1974: hr_utility.trace('l_de_total(4) = ' || to_char(l_de_total(4)));
1975: hr_utility.trace('l_de_total(5) = ' || to_char(l_de_total(5)));
1976: hr_utility.trace('l_de_total(6) = ' || to_char(l_de_total(6)));
1977: hr_utility.trace('l_de_total(7) = ' || to_char(l_de_total(7)));
1978: hr_utility.trace('l_de_total(8) = ' || to_char(l_de_total(8)));
1979: hr_utility.trace('l_de_total(9) = ' || to_char(l_de_total(9)));
1980: hr_utility.trace('l_de_total(10) = ' || to_char(l_de_total(10)));
1981: hr_utility.trace('l_de_total(11) = ' || to_char(l_de_total(11)));
1982: hr_utility.trace('l_de_total(12) = ' || to_char(l_de_total(12)));

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

1975: hr_utility.trace('l_de_total(5) = ' || to_char(l_de_total(5)));
1976: hr_utility.trace('l_de_total(6) = ' || to_char(l_de_total(6)));
1977: hr_utility.trace('l_de_total(7) = ' || to_char(l_de_total(7)));
1978: hr_utility.trace('l_de_total(8) = ' || to_char(l_de_total(8)));
1979: hr_utility.trace('l_de_total(9) = ' || to_char(l_de_total(9)));
1980: hr_utility.trace('l_de_total(10) = ' || to_char(l_de_total(10)));
1981: hr_utility.trace('l_de_total(11) = ' || to_char(l_de_total(11)));
1982: hr_utility.trace('l_de_total(12) = ' || to_char(l_de_total(12)));
1983: hr_utility.trace('l_de_total(13) = ' || to_char(l_de_total(13)));

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

1976: hr_utility.trace('l_de_total(6) = ' || to_char(l_de_total(6)));
1977: hr_utility.trace('l_de_total(7) = ' || to_char(l_de_total(7)));
1978: hr_utility.trace('l_de_total(8) = ' || to_char(l_de_total(8)));
1979: hr_utility.trace('l_de_total(9) = ' || to_char(l_de_total(9)));
1980: hr_utility.trace('l_de_total(10) = ' || to_char(l_de_total(10)));
1981: hr_utility.trace('l_de_total(11) = ' || to_char(l_de_total(11)));
1982: hr_utility.trace('l_de_total(12) = ' || to_char(l_de_total(12)));
1983: hr_utility.trace('l_de_total(13) = ' || to_char(l_de_total(13)));
1984: hr_utility.trace('l_de_total(14) = ' || to_char(l_de_total(14)));

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

1977: hr_utility.trace('l_de_total(7) = ' || to_char(l_de_total(7)));
1978: hr_utility.trace('l_de_total(8) = ' || to_char(l_de_total(8)));
1979: hr_utility.trace('l_de_total(9) = ' || to_char(l_de_total(9)));
1980: hr_utility.trace('l_de_total(10) = ' || to_char(l_de_total(10)));
1981: hr_utility.trace('l_de_total(11) = ' || to_char(l_de_total(11)));
1982: hr_utility.trace('l_de_total(12) = ' || to_char(l_de_total(12)));
1983: hr_utility.trace('l_de_total(13) = ' || to_char(l_de_total(13)));
1984: hr_utility.trace('l_de_total(14) = ' || to_char(l_de_total(14)));
1985: hr_utility.trace('l_de_total(15) = ' || to_char(l_de_total(15)));

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

1978: hr_utility.trace('l_de_total(8) = ' || to_char(l_de_total(8)));
1979: hr_utility.trace('l_de_total(9) = ' || to_char(l_de_total(9)));
1980: hr_utility.trace('l_de_total(10) = ' || to_char(l_de_total(10)));
1981: hr_utility.trace('l_de_total(11) = ' || to_char(l_de_total(11)));
1982: hr_utility.trace('l_de_total(12) = ' || to_char(l_de_total(12)));
1983: hr_utility.trace('l_de_total(13) = ' || to_char(l_de_total(13)));
1984: hr_utility.trace('l_de_total(14) = ' || to_char(l_de_total(14)));
1985: hr_utility.trace('l_de_total(15) = ' || to_char(l_de_total(15)));
1986: hr_utility.trace('l_de_total(16) = ' || to_char(l_de_total(16)));

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

1979: hr_utility.trace('l_de_total(9) = ' || to_char(l_de_total(9)));
1980: hr_utility.trace('l_de_total(10) = ' || to_char(l_de_total(10)));
1981: hr_utility.trace('l_de_total(11) = ' || to_char(l_de_total(11)));
1982: hr_utility.trace('l_de_total(12) = ' || to_char(l_de_total(12)));
1983: hr_utility.trace('l_de_total(13) = ' || to_char(l_de_total(13)));
1984: hr_utility.trace('l_de_total(14) = ' || to_char(l_de_total(14)));
1985: hr_utility.trace('l_de_total(15) = ' || to_char(l_de_total(15)));
1986: hr_utility.trace('l_de_total(16) = ' || to_char(l_de_total(16)));
1987: hr_utility.trace('l_de_total(17) = ' || to_char(l_de_total(17)));

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

1980: hr_utility.trace('l_de_total(10) = ' || to_char(l_de_total(10)));
1981: hr_utility.trace('l_de_total(11) = ' || to_char(l_de_total(11)));
1982: hr_utility.trace('l_de_total(12) = ' || to_char(l_de_total(12)));
1983: hr_utility.trace('l_de_total(13) = ' || to_char(l_de_total(13)));
1984: hr_utility.trace('l_de_total(14) = ' || to_char(l_de_total(14)));
1985: hr_utility.trace('l_de_total(15) = ' || to_char(l_de_total(15)));
1986: hr_utility.trace('l_de_total(16) = ' || to_char(l_de_total(16)));
1987: hr_utility.trace('l_de_total(17) = ' || to_char(l_de_total(17)));
1988: hr_utility.trace('l_de_total(18) = ' || to_char(l_de_total(18)));

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

1981: hr_utility.trace('l_de_total(11) = ' || to_char(l_de_total(11)));
1982: hr_utility.trace('l_de_total(12) = ' || to_char(l_de_total(12)));
1983: hr_utility.trace('l_de_total(13) = ' || to_char(l_de_total(13)));
1984: hr_utility.trace('l_de_total(14) = ' || to_char(l_de_total(14)));
1985: hr_utility.trace('l_de_total(15) = ' || to_char(l_de_total(15)));
1986: hr_utility.trace('l_de_total(16) = ' || to_char(l_de_total(16)));
1987: hr_utility.trace('l_de_total(17) = ' || to_char(l_de_total(17)));
1988: hr_utility.trace('l_de_total(18) = ' || to_char(l_de_total(18)));
1989: hr_utility.trace('l_de_total(19) = ' || to_char(l_de_total(19)));

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

1982: hr_utility.trace('l_de_total(12) = ' || to_char(l_de_total(12)));
1983: hr_utility.trace('l_de_total(13) = ' || to_char(l_de_total(13)));
1984: hr_utility.trace('l_de_total(14) = ' || to_char(l_de_total(14)));
1985: hr_utility.trace('l_de_total(15) = ' || to_char(l_de_total(15)));
1986: hr_utility.trace('l_de_total(16) = ' || to_char(l_de_total(16)));
1987: hr_utility.trace('l_de_total(17) = ' || to_char(l_de_total(17)));
1988: hr_utility.trace('l_de_total(18) = ' || to_char(l_de_total(18)));
1989: hr_utility.trace('l_de_total(19) = ' || to_char(l_de_total(19)));
1990: hr_utility.trace('l_de_total(20) = ' || to_char(l_de_total(20)));

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

1983: hr_utility.trace('l_de_total(13) = ' || to_char(l_de_total(13)));
1984: hr_utility.trace('l_de_total(14) = ' || to_char(l_de_total(14)));
1985: hr_utility.trace('l_de_total(15) = ' || to_char(l_de_total(15)));
1986: hr_utility.trace('l_de_total(16) = ' || to_char(l_de_total(16)));
1987: hr_utility.trace('l_de_total(17) = ' || to_char(l_de_total(17)));
1988: hr_utility.trace('l_de_total(18) = ' || to_char(l_de_total(18)));
1989: hr_utility.trace('l_de_total(19) = ' || to_char(l_de_total(19)));
1990: hr_utility.trace('l_de_total(20) = ' || to_char(l_de_total(20)));
1991: hr_utility.trace('l_de_total(21) = ' || to_char(l_de_total(21)));

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

1984: hr_utility.trace('l_de_total(14) = ' || to_char(l_de_total(14)));
1985: hr_utility.trace('l_de_total(15) = ' || to_char(l_de_total(15)));
1986: hr_utility.trace('l_de_total(16) = ' || to_char(l_de_total(16)));
1987: hr_utility.trace('l_de_total(17) = ' || to_char(l_de_total(17)));
1988: hr_utility.trace('l_de_total(18) = ' || to_char(l_de_total(18)));
1989: hr_utility.trace('l_de_total(19) = ' || to_char(l_de_total(19)));
1990: hr_utility.trace('l_de_total(20) = ' || to_char(l_de_total(20)));
1991: hr_utility.trace('l_de_total(21) = ' || to_char(l_de_total(21)));
1992: hr_utility.trace('l_de_total(22) = ' || to_char(l_de_total(22)));

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

1985: hr_utility.trace('l_de_total(15) = ' || to_char(l_de_total(15)));
1986: hr_utility.trace('l_de_total(16) = ' || to_char(l_de_total(16)));
1987: hr_utility.trace('l_de_total(17) = ' || to_char(l_de_total(17)));
1988: hr_utility.trace('l_de_total(18) = ' || to_char(l_de_total(18)));
1989: hr_utility.trace('l_de_total(19) = ' || to_char(l_de_total(19)));
1990: hr_utility.trace('l_de_total(20) = ' || to_char(l_de_total(20)));
1991: hr_utility.trace('l_de_total(21) = ' || to_char(l_de_total(21)));
1992: hr_utility.trace('l_de_total(22) = ' || to_char(l_de_total(22)));
1993: hr_utility.trace('l_de_total(23) = ' || to_char(l_de_total(23)));

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

1986: hr_utility.trace('l_de_total(16) = ' || to_char(l_de_total(16)));
1987: hr_utility.trace('l_de_total(17) = ' || to_char(l_de_total(17)));
1988: hr_utility.trace('l_de_total(18) = ' || to_char(l_de_total(18)));
1989: hr_utility.trace('l_de_total(19) = ' || to_char(l_de_total(19)));
1990: hr_utility.trace('l_de_total(20) = ' || to_char(l_de_total(20)));
1991: hr_utility.trace('l_de_total(21) = ' || to_char(l_de_total(21)));
1992: hr_utility.trace('l_de_total(22) = ' || to_char(l_de_total(22)));
1993: hr_utility.trace('l_de_total(23) = ' || to_char(l_de_total(23)));
1994: hr_utility.trace('l_de_total(24) = ' || to_char(l_de_total(24)));

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

1987: hr_utility.trace('l_de_total(17) = ' || to_char(l_de_total(17)));
1988: hr_utility.trace('l_de_total(18) = ' || to_char(l_de_total(18)));
1989: hr_utility.trace('l_de_total(19) = ' || to_char(l_de_total(19)));
1990: hr_utility.trace('l_de_total(20) = ' || to_char(l_de_total(20)));
1991: hr_utility.trace('l_de_total(21) = ' || to_char(l_de_total(21)));
1992: hr_utility.trace('l_de_total(22) = ' || to_char(l_de_total(22)));
1993: hr_utility.trace('l_de_total(23) = ' || to_char(l_de_total(23)));
1994: hr_utility.trace('l_de_total(24) = ' || to_char(l_de_total(24)));
1995: hr_utility.trace('l_de_total(25) = ' || to_char(l_de_total(25)));

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

1988: hr_utility.trace('l_de_total(18) = ' || to_char(l_de_total(18)));
1989: hr_utility.trace('l_de_total(19) = ' || to_char(l_de_total(19)));
1990: hr_utility.trace('l_de_total(20) = ' || to_char(l_de_total(20)));
1991: hr_utility.trace('l_de_total(21) = ' || to_char(l_de_total(21)));
1992: hr_utility.trace('l_de_total(22) = ' || to_char(l_de_total(22)));
1993: hr_utility.trace('l_de_total(23) = ' || to_char(l_de_total(23)));
1994: hr_utility.trace('l_de_total(24) = ' || to_char(l_de_total(24)));
1995: hr_utility.trace('l_de_total(25) = ' || to_char(l_de_total(25)));
1996: hr_utility.trace('l_de_total(26) = ' || to_char(l_de_total(26)));

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

1989: hr_utility.trace('l_de_total(19) = ' || to_char(l_de_total(19)));
1990: hr_utility.trace('l_de_total(20) = ' || to_char(l_de_total(20)));
1991: hr_utility.trace('l_de_total(21) = ' || to_char(l_de_total(21)));
1992: hr_utility.trace('l_de_total(22) = ' || to_char(l_de_total(22)));
1993: hr_utility.trace('l_de_total(23) = ' || to_char(l_de_total(23)));
1994: hr_utility.trace('l_de_total(24) = ' || to_char(l_de_total(24)));
1995: hr_utility.trace('l_de_total(25) = ' || to_char(l_de_total(25)));
1996: hr_utility.trace('l_de_total(26) = ' || to_char(l_de_total(26)));
1997: hr_utility.trace('l_de_total(27) = ' || to_char(l_de_total(27)));

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

1990: hr_utility.trace('l_de_total(20) = ' || to_char(l_de_total(20)));
1991: hr_utility.trace('l_de_total(21) = ' || to_char(l_de_total(21)));
1992: hr_utility.trace('l_de_total(22) = ' || to_char(l_de_total(22)));
1993: hr_utility.trace('l_de_total(23) = ' || to_char(l_de_total(23)));
1994: hr_utility.trace('l_de_total(24) = ' || to_char(l_de_total(24)));
1995: hr_utility.trace('l_de_total(25) = ' || to_char(l_de_total(25)));
1996: hr_utility.trace('l_de_total(26) = ' || to_char(l_de_total(26)));
1997: hr_utility.trace('l_de_total(27) = ' || to_char(l_de_total(27)));
1998:

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

1991: hr_utility.trace('l_de_total(21) = ' || to_char(l_de_total(21)));
1992: hr_utility.trace('l_de_total(22) = ' || to_char(l_de_total(22)));
1993: hr_utility.trace('l_de_total(23) = ' || to_char(l_de_total(23)));
1994: hr_utility.trace('l_de_total(24) = ' || to_char(l_de_total(24)));
1995: hr_utility.trace('l_de_total(25) = ' || to_char(l_de_total(25)));
1996: hr_utility.trace('l_de_total(26) = ' || to_char(l_de_total(26)));
1997: hr_utility.trace('l_de_total(27) = ' || to_char(l_de_total(27)));
1998:
1999:

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

1992: hr_utility.trace('l_de_total(22) = ' || to_char(l_de_total(22)));
1993: hr_utility.trace('l_de_total(23) = ' || to_char(l_de_total(23)));
1994: hr_utility.trace('l_de_total(24) = ' || to_char(l_de_total(24)));
1995: hr_utility.trace('l_de_total(25) = ' || to_char(l_de_total(25)));
1996: hr_utility.trace('l_de_total(26) = ' || to_char(l_de_total(26)));
1997: hr_utility.trace('l_de_total(27) = ' || to_char(l_de_total(27)));
1998:
1999:
2000:

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

1993: hr_utility.trace('l_de_total(23) = ' || to_char(l_de_total(23)));
1994: hr_utility.trace('l_de_total(24) = ' || to_char(l_de_total(24)));
1995: hr_utility.trace('l_de_total(25) = ' || to_char(l_de_total(25)));
1996: hr_utility.trace('l_de_total(26) = ' || to_char(l_de_total(26)));
1997: hr_utility.trace('l_de_total(27) = ' || to_char(l_de_total(27)));
1998:
1999:
2000:
2001: hr_utility.trace('l_dp_total(1) = ' || to_char(l_dp_total(1)));

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

1997: hr_utility.trace('l_de_total(27) = ' || to_char(l_de_total(27)));
1998:
1999:
2000:
2001: hr_utility.trace('l_dp_total(1) = ' || to_char(l_dp_total(1)));
2002: hr_utility.trace('l_dp_total(2) = ' || to_char(l_dp_total(2)));
2003: hr_utility.trace('l_dp_total(3) = ' || to_char(l_dp_total(3)));
2004: hr_utility.trace('l_dp_total(4) = ' || to_char(l_dp_total(4)));
2005: hr_utility.trace('l_dp_total(5) = ' || to_char(l_dp_total(5)));

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

1998:
1999:
2000:
2001: hr_utility.trace('l_dp_total(1) = ' || to_char(l_dp_total(1)));
2002: hr_utility.trace('l_dp_total(2) = ' || to_char(l_dp_total(2)));
2003: hr_utility.trace('l_dp_total(3) = ' || to_char(l_dp_total(3)));
2004: hr_utility.trace('l_dp_total(4) = ' || to_char(l_dp_total(4)));
2005: hr_utility.trace('l_dp_total(5) = ' || to_char(l_dp_total(5)));
2006: hr_utility.trace('l_dp_total(6) = ' || to_char(l_dp_total(6)));

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

1999:
2000:
2001: hr_utility.trace('l_dp_total(1) = ' || to_char(l_dp_total(1)));
2002: hr_utility.trace('l_dp_total(2) = ' || to_char(l_dp_total(2)));
2003: hr_utility.trace('l_dp_total(3) = ' || to_char(l_dp_total(3)));
2004: hr_utility.trace('l_dp_total(4) = ' || to_char(l_dp_total(4)));
2005: hr_utility.trace('l_dp_total(5) = ' || to_char(l_dp_total(5)));
2006: hr_utility.trace('l_dp_total(6) = ' || to_char(l_dp_total(6)));
2007: hr_utility.trace('l_dp_total(7) = ' || to_char(l_dp_total(7)));

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

2000:
2001: hr_utility.trace('l_dp_total(1) = ' || to_char(l_dp_total(1)));
2002: hr_utility.trace('l_dp_total(2) = ' || to_char(l_dp_total(2)));
2003: hr_utility.trace('l_dp_total(3) = ' || to_char(l_dp_total(3)));
2004: hr_utility.trace('l_dp_total(4) = ' || to_char(l_dp_total(4)));
2005: hr_utility.trace('l_dp_total(5) = ' || to_char(l_dp_total(5)));
2006: hr_utility.trace('l_dp_total(6) = ' || to_char(l_dp_total(6)));
2007: hr_utility.trace('l_dp_total(7) = ' || to_char(l_dp_total(7)));
2008: hr_utility.trace('l_dp_total(8) = ' || to_char(l_dp_total(8)));

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

2001: hr_utility.trace('l_dp_total(1) = ' || to_char(l_dp_total(1)));
2002: hr_utility.trace('l_dp_total(2) = ' || to_char(l_dp_total(2)));
2003: hr_utility.trace('l_dp_total(3) = ' || to_char(l_dp_total(3)));
2004: hr_utility.trace('l_dp_total(4) = ' || to_char(l_dp_total(4)));
2005: hr_utility.trace('l_dp_total(5) = ' || to_char(l_dp_total(5)));
2006: hr_utility.trace('l_dp_total(6) = ' || to_char(l_dp_total(6)));
2007: hr_utility.trace('l_dp_total(7) = ' || to_char(l_dp_total(7)));
2008: hr_utility.trace('l_dp_total(8) = ' || to_char(l_dp_total(8)));
2009: hr_utility.trace('l_dp_total(9) = ' || to_char(l_dp_total(9)));

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

2002: hr_utility.trace('l_dp_total(2) = ' || to_char(l_dp_total(2)));
2003: hr_utility.trace('l_dp_total(3) = ' || to_char(l_dp_total(3)));
2004: hr_utility.trace('l_dp_total(4) = ' || to_char(l_dp_total(4)));
2005: hr_utility.trace('l_dp_total(5) = ' || to_char(l_dp_total(5)));
2006: hr_utility.trace('l_dp_total(6) = ' || to_char(l_dp_total(6)));
2007: hr_utility.trace('l_dp_total(7) = ' || to_char(l_dp_total(7)));
2008: hr_utility.trace('l_dp_total(8) = ' || to_char(l_dp_total(8)));
2009: hr_utility.trace('l_dp_total(9) = ' || to_char(l_dp_total(9)));
2010: hr_utility.trace('l_dp_total(10) = ' || to_char(l_dp_total(10)));

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

2003: hr_utility.trace('l_dp_total(3) = ' || to_char(l_dp_total(3)));
2004: hr_utility.trace('l_dp_total(4) = ' || to_char(l_dp_total(4)));
2005: hr_utility.trace('l_dp_total(5) = ' || to_char(l_dp_total(5)));
2006: hr_utility.trace('l_dp_total(6) = ' || to_char(l_dp_total(6)));
2007: hr_utility.trace('l_dp_total(7) = ' || to_char(l_dp_total(7)));
2008: hr_utility.trace('l_dp_total(8) = ' || to_char(l_dp_total(8)));
2009: hr_utility.trace('l_dp_total(9) = ' || to_char(l_dp_total(9)));
2010: hr_utility.trace('l_dp_total(10) = ' || to_char(l_dp_total(10)));
2011: hr_utility.trace('l_dp_total(11) = ' || to_char(l_dp_total(11)));

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

2004: hr_utility.trace('l_dp_total(4) = ' || to_char(l_dp_total(4)));
2005: hr_utility.trace('l_dp_total(5) = ' || to_char(l_dp_total(5)));
2006: hr_utility.trace('l_dp_total(6) = ' || to_char(l_dp_total(6)));
2007: hr_utility.trace('l_dp_total(7) = ' || to_char(l_dp_total(7)));
2008: hr_utility.trace('l_dp_total(8) = ' || to_char(l_dp_total(8)));
2009: hr_utility.trace('l_dp_total(9) = ' || to_char(l_dp_total(9)));
2010: hr_utility.trace('l_dp_total(10) = ' || to_char(l_dp_total(10)));
2011: hr_utility.trace('l_dp_total(11) = ' || to_char(l_dp_total(11)));
2012: hr_utility.trace('l_dp_total(12) = ' || to_char(l_dp_total(12)));

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

2005: hr_utility.trace('l_dp_total(5) = ' || to_char(l_dp_total(5)));
2006: hr_utility.trace('l_dp_total(6) = ' || to_char(l_dp_total(6)));
2007: hr_utility.trace('l_dp_total(7) = ' || to_char(l_dp_total(7)));
2008: hr_utility.trace('l_dp_total(8) = ' || to_char(l_dp_total(8)));
2009: hr_utility.trace('l_dp_total(9) = ' || to_char(l_dp_total(9)));
2010: hr_utility.trace('l_dp_total(10) = ' || to_char(l_dp_total(10)));
2011: hr_utility.trace('l_dp_total(11) = ' || to_char(l_dp_total(11)));
2012: hr_utility.trace('l_dp_total(12) = ' || to_char(l_dp_total(12)));
2013: hr_utility.trace('l_dp_total(13) = ' || to_char(l_dp_total(13)));

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

2006: hr_utility.trace('l_dp_total(6) = ' || to_char(l_dp_total(6)));
2007: hr_utility.trace('l_dp_total(7) = ' || to_char(l_dp_total(7)));
2008: hr_utility.trace('l_dp_total(8) = ' || to_char(l_dp_total(8)));
2009: hr_utility.trace('l_dp_total(9) = ' || to_char(l_dp_total(9)));
2010: hr_utility.trace('l_dp_total(10) = ' || to_char(l_dp_total(10)));
2011: hr_utility.trace('l_dp_total(11) = ' || to_char(l_dp_total(11)));
2012: hr_utility.trace('l_dp_total(12) = ' || to_char(l_dp_total(12)));
2013: hr_utility.trace('l_dp_total(13) = ' || to_char(l_dp_total(13)));
2014: hr_utility.trace('l_dp_total(14) = ' || to_char(l_dp_total(14)));

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

2007: hr_utility.trace('l_dp_total(7) = ' || to_char(l_dp_total(7)));
2008: hr_utility.trace('l_dp_total(8) = ' || to_char(l_dp_total(8)));
2009: hr_utility.trace('l_dp_total(9) = ' || to_char(l_dp_total(9)));
2010: hr_utility.trace('l_dp_total(10) = ' || to_char(l_dp_total(10)));
2011: hr_utility.trace('l_dp_total(11) = ' || to_char(l_dp_total(11)));
2012: hr_utility.trace('l_dp_total(12) = ' || to_char(l_dp_total(12)));
2013: hr_utility.trace('l_dp_total(13) = ' || to_char(l_dp_total(13)));
2014: hr_utility.trace('l_dp_total(14) = ' || to_char(l_dp_total(14)));
2015: hr_utility.trace('l_dp_total(15) = ' || to_char(l_dp_total(15)));

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

2008: hr_utility.trace('l_dp_total(8) = ' || to_char(l_dp_total(8)));
2009: hr_utility.trace('l_dp_total(9) = ' || to_char(l_dp_total(9)));
2010: hr_utility.trace('l_dp_total(10) = ' || to_char(l_dp_total(10)));
2011: hr_utility.trace('l_dp_total(11) = ' || to_char(l_dp_total(11)));
2012: hr_utility.trace('l_dp_total(12) = ' || to_char(l_dp_total(12)));
2013: hr_utility.trace('l_dp_total(13) = ' || to_char(l_dp_total(13)));
2014: hr_utility.trace('l_dp_total(14) = ' || to_char(l_dp_total(14)));
2015: hr_utility.trace('l_dp_total(15) = ' || to_char(l_dp_total(15)));
2016: hr_utility.trace('l_dp_total(16) = ' || to_char(l_dp_total(16)));

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

2009: hr_utility.trace('l_dp_total(9) = ' || to_char(l_dp_total(9)));
2010: hr_utility.trace('l_dp_total(10) = ' || to_char(l_dp_total(10)));
2011: hr_utility.trace('l_dp_total(11) = ' || to_char(l_dp_total(11)));
2012: hr_utility.trace('l_dp_total(12) = ' || to_char(l_dp_total(12)));
2013: hr_utility.trace('l_dp_total(13) = ' || to_char(l_dp_total(13)));
2014: hr_utility.trace('l_dp_total(14) = ' || to_char(l_dp_total(14)));
2015: hr_utility.trace('l_dp_total(15) = ' || to_char(l_dp_total(15)));
2016: hr_utility.trace('l_dp_total(16) = ' || to_char(l_dp_total(16)));
2017: hr_utility.trace('l_dp_total(17) = ' || to_char(l_dp_total(17)));

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

2010: hr_utility.trace('l_dp_total(10) = ' || to_char(l_dp_total(10)));
2011: hr_utility.trace('l_dp_total(11) = ' || to_char(l_dp_total(11)));
2012: hr_utility.trace('l_dp_total(12) = ' || to_char(l_dp_total(12)));
2013: hr_utility.trace('l_dp_total(13) = ' || to_char(l_dp_total(13)));
2014: hr_utility.trace('l_dp_total(14) = ' || to_char(l_dp_total(14)));
2015: hr_utility.trace('l_dp_total(15) = ' || to_char(l_dp_total(15)));
2016: hr_utility.trace('l_dp_total(16) = ' || to_char(l_dp_total(16)));
2017: hr_utility.trace('l_dp_total(17) = ' || to_char(l_dp_total(17)));
2018: hr_utility.trace('l_dp_total(18) = ' || to_char(l_dp_total(18)));

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

2011: hr_utility.trace('l_dp_total(11) = ' || to_char(l_dp_total(11)));
2012: hr_utility.trace('l_dp_total(12) = ' || to_char(l_dp_total(12)));
2013: hr_utility.trace('l_dp_total(13) = ' || to_char(l_dp_total(13)));
2014: hr_utility.trace('l_dp_total(14) = ' || to_char(l_dp_total(14)));
2015: hr_utility.trace('l_dp_total(15) = ' || to_char(l_dp_total(15)));
2016: hr_utility.trace('l_dp_total(16) = ' || to_char(l_dp_total(16)));
2017: hr_utility.trace('l_dp_total(17) = ' || to_char(l_dp_total(17)));
2018: hr_utility.trace('l_dp_total(18) = ' || to_char(l_dp_total(18)));
2019: hr_utility.trace('l_dp_total(19) = ' || to_char(l_dp_total(19)));

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

2012: hr_utility.trace('l_dp_total(12) = ' || to_char(l_dp_total(12)));
2013: hr_utility.trace('l_dp_total(13) = ' || to_char(l_dp_total(13)));
2014: hr_utility.trace('l_dp_total(14) = ' || to_char(l_dp_total(14)));
2015: hr_utility.trace('l_dp_total(15) = ' || to_char(l_dp_total(15)));
2016: hr_utility.trace('l_dp_total(16) = ' || to_char(l_dp_total(16)));
2017: hr_utility.trace('l_dp_total(17) = ' || to_char(l_dp_total(17)));
2018: hr_utility.trace('l_dp_total(18) = ' || to_char(l_dp_total(18)));
2019: hr_utility.trace('l_dp_total(19) = ' || to_char(l_dp_total(19)));
2020: hr_utility.trace('l_dp_total(20) = ' || to_char(l_dp_total(20)));

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

2013: hr_utility.trace('l_dp_total(13) = ' || to_char(l_dp_total(13)));
2014: hr_utility.trace('l_dp_total(14) = ' || to_char(l_dp_total(14)));
2015: hr_utility.trace('l_dp_total(15) = ' || to_char(l_dp_total(15)));
2016: hr_utility.trace('l_dp_total(16) = ' || to_char(l_dp_total(16)));
2017: hr_utility.trace('l_dp_total(17) = ' || to_char(l_dp_total(17)));
2018: hr_utility.trace('l_dp_total(18) = ' || to_char(l_dp_total(18)));
2019: hr_utility.trace('l_dp_total(19) = ' || to_char(l_dp_total(19)));
2020: hr_utility.trace('l_dp_total(20) = ' || to_char(l_dp_total(20)));
2021: hr_utility.trace('l_dp_total(21) = ' || to_char(l_dp_total(21)));

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

2014: hr_utility.trace('l_dp_total(14) = ' || to_char(l_dp_total(14)));
2015: hr_utility.trace('l_dp_total(15) = ' || to_char(l_dp_total(15)));
2016: hr_utility.trace('l_dp_total(16) = ' || to_char(l_dp_total(16)));
2017: hr_utility.trace('l_dp_total(17) = ' || to_char(l_dp_total(17)));
2018: hr_utility.trace('l_dp_total(18) = ' || to_char(l_dp_total(18)));
2019: hr_utility.trace('l_dp_total(19) = ' || to_char(l_dp_total(19)));
2020: hr_utility.trace('l_dp_total(20) = ' || to_char(l_dp_total(20)));
2021: hr_utility.trace('l_dp_total(21) = ' || to_char(l_dp_total(21)));
2022: hr_utility.trace('l_dp_total(22) = ' || to_char(l_dp_total(22)));

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

2015: hr_utility.trace('l_dp_total(15) = ' || to_char(l_dp_total(15)));
2016: hr_utility.trace('l_dp_total(16) = ' || to_char(l_dp_total(16)));
2017: hr_utility.trace('l_dp_total(17) = ' || to_char(l_dp_total(17)));
2018: hr_utility.trace('l_dp_total(18) = ' || to_char(l_dp_total(18)));
2019: hr_utility.trace('l_dp_total(19) = ' || to_char(l_dp_total(19)));
2020: hr_utility.trace('l_dp_total(20) = ' || to_char(l_dp_total(20)));
2021: hr_utility.trace('l_dp_total(21) = ' || to_char(l_dp_total(21)));
2022: hr_utility.trace('l_dp_total(22) = ' || to_char(l_dp_total(22)));
2023: hr_utility.trace('l_dp_total(23) = ' || to_char(l_dp_total(23)));

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

2016: hr_utility.trace('l_dp_total(16) = ' || to_char(l_dp_total(16)));
2017: hr_utility.trace('l_dp_total(17) = ' || to_char(l_dp_total(17)));
2018: hr_utility.trace('l_dp_total(18) = ' || to_char(l_dp_total(18)));
2019: hr_utility.trace('l_dp_total(19) = ' || to_char(l_dp_total(19)));
2020: hr_utility.trace('l_dp_total(20) = ' || to_char(l_dp_total(20)));
2021: hr_utility.trace('l_dp_total(21) = ' || to_char(l_dp_total(21)));
2022: hr_utility.trace('l_dp_total(22) = ' || to_char(l_dp_total(22)));
2023: hr_utility.trace('l_dp_total(23) = ' || to_char(l_dp_total(23)));
2024: hr_utility.trace('l_dp_total(24) = ' || to_char(l_dp_total(24)));

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

2017: hr_utility.trace('l_dp_total(17) = ' || to_char(l_dp_total(17)));
2018: hr_utility.trace('l_dp_total(18) = ' || to_char(l_dp_total(18)));
2019: hr_utility.trace('l_dp_total(19) = ' || to_char(l_dp_total(19)));
2020: hr_utility.trace('l_dp_total(20) = ' || to_char(l_dp_total(20)));
2021: hr_utility.trace('l_dp_total(21) = ' || to_char(l_dp_total(21)));
2022: hr_utility.trace('l_dp_total(22) = ' || to_char(l_dp_total(22)));
2023: hr_utility.trace('l_dp_total(23) = ' || to_char(l_dp_total(23)));
2024: hr_utility.trace('l_dp_total(24) = ' || to_char(l_dp_total(24)));
2025: hr_utility.trace('l_dp_total(25) = ' || to_char(l_dp_total(25)));

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

2018: hr_utility.trace('l_dp_total(18) = ' || to_char(l_dp_total(18)));
2019: hr_utility.trace('l_dp_total(19) = ' || to_char(l_dp_total(19)));
2020: hr_utility.trace('l_dp_total(20) = ' || to_char(l_dp_total(20)));
2021: hr_utility.trace('l_dp_total(21) = ' || to_char(l_dp_total(21)));
2022: hr_utility.trace('l_dp_total(22) = ' || to_char(l_dp_total(22)));
2023: hr_utility.trace('l_dp_total(23) = ' || to_char(l_dp_total(23)));
2024: hr_utility.trace('l_dp_total(24) = ' || to_char(l_dp_total(24)));
2025: hr_utility.trace('l_dp_total(25) = ' || to_char(l_dp_total(25)));
2026: hr_utility.trace('l_dp_total(26) = ' || to_char(l_dp_total(26)));

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

2019: hr_utility.trace('l_dp_total(19) = ' || to_char(l_dp_total(19)));
2020: hr_utility.trace('l_dp_total(20) = ' || to_char(l_dp_total(20)));
2021: hr_utility.trace('l_dp_total(21) = ' || to_char(l_dp_total(21)));
2022: hr_utility.trace('l_dp_total(22) = ' || to_char(l_dp_total(22)));
2023: hr_utility.trace('l_dp_total(23) = ' || to_char(l_dp_total(23)));
2024: hr_utility.trace('l_dp_total(24) = ' || to_char(l_dp_total(24)));
2025: hr_utility.trace('l_dp_total(25) = ' || to_char(l_dp_total(25)));
2026: hr_utility.trace('l_dp_total(26) = ' || to_char(l_dp_total(26)));
2027: hr_utility.trace('l_dp_total(27) = ' || to_char(l_dp_total(27)));

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

2020: hr_utility.trace('l_dp_total(20) = ' || to_char(l_dp_total(20)));
2021: hr_utility.trace('l_dp_total(21) = ' || to_char(l_dp_total(21)));
2022: hr_utility.trace('l_dp_total(22) = ' || to_char(l_dp_total(22)));
2023: hr_utility.trace('l_dp_total(23) = ' || to_char(l_dp_total(23)));
2024: hr_utility.trace('l_dp_total(24) = ' || to_char(l_dp_total(24)));
2025: hr_utility.trace('l_dp_total(25) = ' || to_char(l_dp_total(25)));
2026: hr_utility.trace('l_dp_total(26) = ' || to_char(l_dp_total(26)));
2027: hr_utility.trace('l_dp_total(27) = ' || to_char(l_dp_total(27)));
2028:

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

2021: hr_utility.trace('l_dp_total(21) = ' || to_char(l_dp_total(21)));
2022: hr_utility.trace('l_dp_total(22) = ' || to_char(l_dp_total(22)));
2023: hr_utility.trace('l_dp_total(23) = ' || to_char(l_dp_total(23)));
2024: hr_utility.trace('l_dp_total(24) = ' || to_char(l_dp_total(24)));
2025: hr_utility.trace('l_dp_total(25) = ' || to_char(l_dp_total(25)));
2026: hr_utility.trace('l_dp_total(26) = ' || to_char(l_dp_total(26)));
2027: hr_utility.trace('l_dp_total(27) = ' || to_char(l_dp_total(27)));
2028:
2029:

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

2022: hr_utility.trace('l_dp_total(22) = ' || to_char(l_dp_total(22)));
2023: hr_utility.trace('l_dp_total(23) = ' || to_char(l_dp_total(23)));
2024: hr_utility.trace('l_dp_total(24) = ' || to_char(l_dp_total(24)));
2025: hr_utility.trace('l_dp_total(25) = ' || to_char(l_dp_total(25)));
2026: hr_utility.trace('l_dp_total(26) = ' || to_char(l_dp_total(26)));
2027: hr_utility.trace('l_dp_total(27) = ' || to_char(l_dp_total(27)));
2028:
2029:
2030: hr_utility.set_location(l_proc_name, 100);

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

2023: hr_utility.trace('l_dp_total(23) = ' || to_char(l_dp_total(23)));
2024: hr_utility.trace('l_dp_total(24) = ' || to_char(l_dp_total(24)));
2025: hr_utility.trace('l_dp_total(25) = ' || to_char(l_dp_total(25)));
2026: hr_utility.trace('l_dp_total(26) = ' || to_char(l_dp_total(26)));
2027: hr_utility.trace('l_dp_total(27) = ' || to_char(l_dp_total(27)));
2028:
2029:
2030: hr_utility.set_location(l_proc_name, 100);
2031:

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

2026: hr_utility.trace('l_dp_total(26) = ' || to_char(l_dp_total(26)));
2027: hr_utility.trace('l_dp_total(27) = ' || to_char(l_dp_total(27)));
2028:
2029:
2030: hr_utility.set_location(l_proc_name, 100);
2031:
2032: -- If the hire date is later than either the
2033: -- previous roe date (p_start_date) or the
2034: -- starting date for the current roe then hire

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

2039: fetch cur_date_of_hire
2040: into l_hire_date;
2041: close cur_date_of_hire;
2042:
2043: hr_utility.trace('l_hire_date = ' || to_char(l_hire_date));
2044:
2045: if p_start_date is not null and
2046: p_start_date > l_start_date then
2047:

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

2044:
2045: if p_start_date is not null and
2046: p_start_date > l_start_date then
2047:
2048: hr_utility.trace('p_start_date = ' || to_char(p_start_date));
2049:
2050: if l_hire_date > p_start_date then
2051: l_start_date1 := l_hire_date;
2052: else

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

2054: end if;
2055:
2056: else
2057:
2058: hr_utility.trace('l_start_date = ' || to_char(l_start_date));
2059:
2060: if l_hire_date > l_start_date then
2061: l_start_date1 := l_hire_date;
2062: else

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

2064: end if;
2065:
2066: end if;
2067:
2068: hr_utility.trace('l_start_date1 = ' || to_char(l_start_date1));
2069:
2070: OPEN cur_count_pay_periods(l_start_date1);
2071: FETCH cur_count_pay_periods
2072: INTO l_no_of_pay_periods;

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

2071: FETCH cur_count_pay_periods
2072: INTO l_no_of_pay_periods;
2073: CLOSE cur_count_pay_periods;
2074:
2075: hr_utility.trace('l_no_of_pay_periods = ' || to_char(l_no_of_pay_periods));
2076: hr_utility.trace('l_period_count = ' || to_char(l_period_count));
2077:
2078: FOR l_index IN 1..l_period_count LOOP
2079:

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

2072: INTO l_no_of_pay_periods;
2073: CLOSE cur_count_pay_periods;
2074:
2075: hr_utility.trace('l_no_of_pay_periods = ' || to_char(l_no_of_pay_periods));
2076: hr_utility.trace('l_period_count = ' || to_char(l_period_count));
2077:
2078: FOR l_index IN 1..l_period_count LOOP
2079:
2080: p_period_total(l_index) := l_dp_total(l_index) + l_de_total(l_index);

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

2078: FOR l_index IN 1..l_period_count LOOP
2079:
2080: p_period_total(l_index) := l_dp_total(l_index) + l_de_total(l_index);
2081:
2082: hr_utility.trace('l_dp_total = ' || to_char(l_dp_total(l_index)));
2083: hr_utility.trace('l_de_total = ' || to_char(l_de_total(l_index)));
2084: hr_utility.trace('l_index = ' || to_char(l_index));
2085:
2086: IF p_period_total(l_index) = 0 and

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

2079:
2080: p_period_total(l_index) := l_dp_total(l_index) + l_de_total(l_index);
2081:
2082: hr_utility.trace('l_dp_total = ' || to_char(l_dp_total(l_index)));
2083: hr_utility.trace('l_de_total = ' || to_char(l_de_total(l_index)));
2084: hr_utility.trace('l_index = ' || to_char(l_index));
2085:
2086: IF p_period_total(l_index) = 0 and
2087: l_index <= l_no_of_pay_periods THEN

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

2080: p_period_total(l_index) := l_dp_total(l_index) + l_de_total(l_index);
2081:
2082: hr_utility.trace('l_dp_total = ' || to_char(l_dp_total(l_index)));
2083: hr_utility.trace('l_de_total = ' || to_char(l_de_total(l_index)));
2084: hr_utility.trace('l_index = ' || to_char(l_index));
2085:
2086: IF p_period_total(l_index) = 0 and
2087: l_index <= l_no_of_pay_periods THEN
2088: l_box15c_flag := TRUE;

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

2097: p_no_of_periods := l_period_count;
2098:
2099: -- Retro Functionality starts here
2100:
2101: hr_utility.trace('Retro Functionality starts here');
2102:
2103: for i in cur_retro_run(l_start_date,
2104: l_last_period_end_date) loop
2105:

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

2102:
2103: for i in cur_retro_run(l_start_date,
2104: l_last_period_end_date) loop
2105:
2106: hr_utility.trace('cur_retro_run found');
2107: hr_utility.trace('i.effective_date = ' || to_char(i.effective_date));
2108: hr_utility.trace('i.start_date = ' || to_char(i.start_date));
2109:
2110: open cur_curr_pay_period_dates(i.effective_date);

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

2103: for i in cur_retro_run(l_start_date,
2104: l_last_period_end_date) loop
2105:
2106: hr_utility.trace('cur_retro_run found');
2107: hr_utility.trace('i.effective_date = ' || to_char(i.effective_date));
2108: hr_utility.trace('i.start_date = ' || to_char(i.start_date));
2109:
2110: open cur_curr_pay_period_dates(i.effective_date);
2111: fetch cur_curr_pay_period_dates

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

2104: l_last_period_end_date) loop
2105:
2106: hr_utility.trace('cur_retro_run found');
2107: hr_utility.trace('i.effective_date = ' || to_char(i.effective_date));
2108: hr_utility.trace('i.start_date = ' || to_char(i.start_date));
2109:
2110: open cur_curr_pay_period_dates(i.effective_date);
2111: fetch cur_curr_pay_period_dates
2112: into l_pay_period_start_date,

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

2112: into l_pay_period_start_date,
2113: l_pay_period_end_date;
2114: close cur_curr_pay_period_dates;
2115:
2116: hr_utility.trace('l_pay_period_start_date = ' || to_char(l_pay_period_start_date));
2117: hr_utility.trace('l_pay_period_end_date = ' || to_char(l_pay_period_end_date));
2118:
2119: open cur_payroll_exists(l_pay_period_start_date,
2120: l_pay_period_end_date);

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

2113: l_pay_period_end_date;
2114: close cur_curr_pay_period_dates;
2115:
2116: hr_utility.trace('l_pay_period_start_date = ' || to_char(l_pay_period_start_date));
2117: hr_utility.trace('l_pay_period_end_date = ' || to_char(l_pay_period_end_date));
2118:
2119: open cur_payroll_exists(l_pay_period_start_date,
2120: l_pay_period_end_date);
2121: fetch cur_payroll_exists

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

2127:
2128: for k in cur_ele_entries(l_pay_period_start_date,
2129: l_pay_period_end_date) loop
2130:
2131: hr_utility.trace('k.element_type_id = ' || to_char(k.element_type_id));
2132: hr_utility.trace('k.creator_type = ' || k.creator_type);
2133: hr_utility.trace('k.source_id = ' || to_char(nvl(k.source_id,0)));
2134: hr_utility.trace('k.source_asg_action_id = ' || to_char(nvl(k.source_asg_action_id,0)));
2135: hr_utility.trace('k.screen_entry_value = ' || nvl(k.screen_entry_value,'0'));

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

2128: for k in cur_ele_entries(l_pay_period_start_date,
2129: l_pay_period_end_date) loop
2130:
2131: hr_utility.trace('k.element_type_id = ' || to_char(k.element_type_id));
2132: hr_utility.trace('k.creator_type = ' || k.creator_type);
2133: hr_utility.trace('k.source_id = ' || to_char(nvl(k.source_id,0)));
2134: hr_utility.trace('k.source_asg_action_id = ' || to_char(nvl(k.source_asg_action_id,0)));
2135: hr_utility.trace('k.screen_entry_value = ' || nvl(k.screen_entry_value,'0'));
2136: hr_utility.trace('k.element_entry_id = ' || to_char(k.element_entry_id));

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

2129: l_pay_period_end_date) loop
2130:
2131: hr_utility.trace('k.element_type_id = ' || to_char(k.element_type_id));
2132: hr_utility.trace('k.creator_type = ' || k.creator_type);
2133: hr_utility.trace('k.source_id = ' || to_char(nvl(k.source_id,0)));
2134: hr_utility.trace('k.source_asg_action_id = ' || to_char(nvl(k.source_asg_action_id,0)));
2135: hr_utility.trace('k.screen_entry_value = ' || nvl(k.screen_entry_value,'0'));
2136: hr_utility.trace('k.element_entry_id = ' || to_char(k.element_entry_id));
2137: hr_utility.trace('k.classification_name = ' || nvl(k.classification_name,' '));

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

2130:
2131: hr_utility.trace('k.element_type_id = ' || to_char(k.element_type_id));
2132: hr_utility.trace('k.creator_type = ' || k.creator_type);
2133: hr_utility.trace('k.source_id = ' || to_char(nvl(k.source_id,0)));
2134: hr_utility.trace('k.source_asg_action_id = ' || to_char(nvl(k.source_asg_action_id,0)));
2135: hr_utility.trace('k.screen_entry_value = ' || nvl(k.screen_entry_value,'0'));
2136: hr_utility.trace('k.element_entry_id = ' || to_char(k.element_entry_id));
2137: hr_utility.trace('k.classification_name = ' || nvl(k.classification_name,' '));
2138: hr_utility.trace('k.classification_id = ' || to_char(nvl(k.classification_id,0)));

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

2131: hr_utility.trace('k.element_type_id = ' || to_char(k.element_type_id));
2132: hr_utility.trace('k.creator_type = ' || k.creator_type);
2133: hr_utility.trace('k.source_id = ' || to_char(nvl(k.source_id,0)));
2134: hr_utility.trace('k.source_asg_action_id = ' || to_char(nvl(k.source_asg_action_id,0)));
2135: hr_utility.trace('k.screen_entry_value = ' || nvl(k.screen_entry_value,'0'));
2136: hr_utility.trace('k.element_entry_id = ' || to_char(k.element_entry_id));
2137: hr_utility.trace('k.classification_name = ' || nvl(k.classification_name,' '));
2138: hr_utility.trace('k.classification_id = ' || to_char(nvl(k.classification_id,0)));
2139: hr_utility.trace('k.element_information1 = ' || k.element_information1);

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

2132: hr_utility.trace('k.creator_type = ' || k.creator_type);
2133: hr_utility.trace('k.source_id = ' || to_char(nvl(k.source_id,0)));
2134: hr_utility.trace('k.source_asg_action_id = ' || to_char(nvl(k.source_asg_action_id,0)));
2135: hr_utility.trace('k.screen_entry_value = ' || nvl(k.screen_entry_value,'0'));
2136: hr_utility.trace('k.element_entry_id = ' || to_char(k.element_entry_id));
2137: hr_utility.trace('k.classification_name = ' || nvl(k.classification_name,' '));
2138: hr_utility.trace('k.classification_id = ' || to_char(nvl(k.classification_id,0)));
2139: hr_utility.trace('k.element_information1 = ' || k.element_information1);
2140:

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

2133: hr_utility.trace('k.source_id = ' || to_char(nvl(k.source_id,0)));
2134: hr_utility.trace('k.source_asg_action_id = ' || to_char(nvl(k.source_asg_action_id,0)));
2135: hr_utility.trace('k.screen_entry_value = ' || nvl(k.screen_entry_value,'0'));
2136: hr_utility.trace('k.element_entry_id = ' || to_char(k.element_entry_id));
2137: hr_utility.trace('k.classification_name = ' || nvl(k.classification_name,' '));
2138: hr_utility.trace('k.classification_id = ' || to_char(nvl(k.classification_id,0)));
2139: hr_utility.trace('k.element_information1 = ' || k.element_information1);
2140:
2141: if (((k.element_entry_id <> l_prev_element_entry_id) or

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

2134: hr_utility.trace('k.source_asg_action_id = ' || to_char(nvl(k.source_asg_action_id,0)));
2135: hr_utility.trace('k.screen_entry_value = ' || nvl(k.screen_entry_value,'0'));
2136: hr_utility.trace('k.element_entry_id = ' || to_char(k.element_entry_id));
2137: hr_utility.trace('k.classification_name = ' || nvl(k.classification_name,' '));
2138: hr_utility.trace('k.classification_id = ' || to_char(nvl(k.classification_id,0)));
2139: hr_utility.trace('k.element_information1 = ' || k.element_information1);
2140:
2141: if (((k.element_entry_id <> l_prev_element_entry_id) or
2142: (l_prev_element_entry_id is null)) and

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

2135: hr_utility.trace('k.screen_entry_value = ' || nvl(k.screen_entry_value,'0'));
2136: hr_utility.trace('k.element_entry_id = ' || to_char(k.element_entry_id));
2137: hr_utility.trace('k.classification_name = ' || nvl(k.classification_name,' '));
2138: hr_utility.trace('k.classification_id = ' || to_char(nvl(k.classification_id,0)));
2139: hr_utility.trace('k.element_information1 = ' || k.element_information1);
2140:
2141: if (((k.element_entry_id <> l_prev_element_entry_id) or
2142: (l_prev_element_entry_id is null)) and
2143: (taxability_rule_exists(k.classification_name,

Line 2150: hr_utility.trace('l_value '||l_value);

2146: l_pay_period_end_date,
2147: 'EIM') = 'TRUE')) then
2148:
2149: l_value := to_number(k.screen_entry_value);
2150: hr_utility.trace('l_value '||l_value);
2151:
2152: if (k.element_information3 = 'DE') then
2153:
2154: if k.creator_type = 'RR' then

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

2183:
2184: period_to := pay_ca_roe_ei_pkg.get_pd_num(l_start_period,
2185: l_last_period_end_date);
2186:
2187: hr_utility.trace('period_from = ' || to_char(period_from));
2188: hr_utility.trace('period_to = ' || to_char(period_to));
2189:
2190: p_period_total(period_from) := p_period_total(period_from) - l_value;
2191: p_period_total(period_to) := p_period_total(period_to) + l_value;

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

2184: period_to := pay_ca_roe_ei_pkg.get_pd_num(l_start_period,
2185: l_last_period_end_date);
2186:
2187: hr_utility.trace('period_from = ' || to_char(period_from));
2188: hr_utility.trace('period_to = ' || to_char(period_to));
2189:
2190: p_period_total(period_from) := p_period_total(period_from) - l_value;
2191: p_period_total(period_to) := p_period_total(period_to) + l_value;
2192: hr_utility.trace('p_period_total(period_from) '||p_period_total(period_from));

Line 2192: hr_utility.trace('p_period_total(period_from) '||p_period_total(period_from));

2188: hr_utility.trace('period_to = ' || to_char(period_to));
2189:
2190: p_period_total(period_from) := p_period_total(period_from) - l_value;
2191: p_period_total(period_to) := p_period_total(period_to) + l_value;
2192: hr_utility.trace('p_period_total(period_from) '||p_period_total(period_from));
2193: hr_utility.trace('p_period_total(period_to) '||p_period_total(period_to));
2194:
2195: end if;
2196:

Line 2193: hr_utility.trace('p_period_total(period_to) '||p_period_total(period_to));

2189:
2190: p_period_total(period_from) := p_period_total(period_from) - l_value;
2191: p_period_total(period_to) := p_period_total(period_to) + l_value;
2192: hr_utility.trace('p_period_total(period_from) '||p_period_total(period_from));
2193: hr_utility.trace('p_period_total(period_to) '||p_period_total(period_to));
2194:
2195: end if;
2196:
2197: end if; -- prev element entry id

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

2204:
2205: end loop;
2206:
2207: -- Retro Functionality ends here;
2208: hr_utility.set_location(l_proc_name, 120);
2209:
2210: -- Summing 15B, Total insurable earnings, bug 8835569
2211: for l_index in 1..l_period_count1 loop
2212: p_total_insurable := p_total_insurable + p_period_total(l_index);

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

2212: p_total_insurable := p_total_insurable + p_period_total(l_index);
2213: end loop;
2214:
2215: IF l_box15c_flag THEN
2216: hr_utility.set_location('Ending: ' || l_proc_name, 130);
2217: RETURN 'BOX15C';
2218: ELSE
2219: hr_utility.set_location('Ending: ' || l_proc_name, 140);
2220: RETURN 'BOX15B';

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

2215: IF l_box15c_flag THEN
2216: hr_utility.set_location('Ending: ' || l_proc_name, 130);
2217: RETURN 'BOX15C';
2218: ELSE
2219: hr_utility.set_location('Ending: ' || l_proc_name, 140);
2220: RETURN 'BOX15B';
2221: END IF;
2222:
2223: END IF;