1353:
1354: IF i.epigraph_114 = 'Y' THEN
1355: cac_epigraph_change(lctr).epigraph := '114';
1356: END IF;
1357: FND_FILE.NEW_LINE(fnd_file.log, 1);
1358: FND_FILE.PUT(fnd_file.log,rpad(i.work_center_cac,10));
1359: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_code,10));
1360: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_114,10));
1361: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_126,10));
1354: IF i.epigraph_114 = 'Y' THEN
1355: cac_epigraph_change(lctr).epigraph := '114';
1356: END IF;
1357: FND_FILE.NEW_LINE(fnd_file.log, 1);
1358: FND_FILE.PUT(fnd_file.log,rpad(i.work_center_cac,10));
1359: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_code,10));
1360: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_114,10));
1361: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_126,10));
1362: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_rec_days),10));
1355: cac_epigraph_change(lctr).epigraph := '114';
1356: END IF;
1357: FND_FILE.NEW_LINE(fnd_file.log, 1);
1358: FND_FILE.PUT(fnd_file.log,rpad(i.work_center_cac,10));
1359: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_code,10));
1360: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_114,10));
1361: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_126,10));
1362: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_rec_days),10));
1363: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.start_date,'dd-mm-yyyy'),10));
1356: END IF;
1357: FND_FILE.NEW_LINE(fnd_file.log, 1);
1358: FND_FILE.PUT(fnd_file.log,rpad(i.work_center_cac,10));
1359: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_code,10));
1360: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_114,10));
1361: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_126,10));
1362: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_rec_days),10));
1363: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.start_date,'dd-mm-yyyy'),10));
1364: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.end_date,'dd-mm-yyyy'),10));
1357: FND_FILE.NEW_LINE(fnd_file.log, 1);
1358: FND_FILE.PUT(fnd_file.log,rpad(i.work_center_cac,10));
1359: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_code,10));
1360: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_114,10));
1361: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_126,10));
1362: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_rec_days),10));
1363: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.start_date,'dd-mm-yyyy'),10));
1364: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.end_date,'dd-mm-yyyy'),10));
1365: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_days_worked),5));
1358: FND_FILE.PUT(fnd_file.log,rpad(i.work_center_cac,10));
1359: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_code,10));
1360: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_114,10));
1361: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_126,10));
1362: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_rec_days),10));
1363: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.start_date,'dd-mm-yyyy'),10));
1364: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.end_date,'dd-mm-yyyy'),10));
1365: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_days_worked),5));
1366: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_td_days),5));
1359: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_code,10));
1360: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_114,10));
1361: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_126,10));
1362: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_rec_days),10));
1363: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.start_date,'dd-mm-yyyy'),10));
1364: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.end_date,'dd-mm-yyyy'),10));
1365: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_days_worked),5));
1366: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_td_days),5));
1367: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_tot_days),5));
1360: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_114,10));
1361: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_126,10));
1362: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_rec_days),10));
1363: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.start_date,'dd-mm-yyyy'),10));
1364: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.end_date,'dd-mm-yyyy'),10));
1365: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_days_worked),5));
1366: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_td_days),5));
1367: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_tot_days),5));
1368: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_pu_days),5));
1361: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_126,10));
1362: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_rec_days),10));
1363: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.start_date,'dd-mm-yyyy'),10));
1364: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.end_date,'dd-mm-yyyy'),10));
1365: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_days_worked),5));
1366: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_td_days),5));
1367: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_tot_days),5));
1368: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_pu_days),5));
1369: ELSE
1362: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_rec_days),10));
1363: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.start_date,'dd-mm-yyyy'),10));
1364: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.end_date,'dd-mm-yyyy'),10));
1365: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_days_worked),5));
1366: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_td_days),5));
1367: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_tot_days),5));
1368: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_pu_days),5));
1369: ELSE
1370: IF NOT cac_epigraph_change.exists(lctr) THEN
1363: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.start_date,'dd-mm-yyyy'),10));
1364: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.end_date,'dd-mm-yyyy'),10));
1365: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_days_worked),5));
1366: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_td_days),5));
1367: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_tot_days),5));
1368: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_pu_days),5));
1369: ELSE
1370: IF NOT cac_epigraph_change.exists(lctr) THEN
1371: RETURN (-1);
1364: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.end_date,'dd-mm-yyyy'),10));
1365: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_days_worked),5));
1366: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_td_days),5));
1367: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_tot_days),5));
1368: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_pu_days),5));
1369: ELSE
1370: IF NOT cac_epigraph_change.exists(lctr) THEN
1371: RETURN (-1);
1372: END IF;
1408: cac_epigraph_change(lctr).no_td_days := l_td_days;
1409: cac_epigraph_change(lctr).Tot_Days := l_tot_days;
1410: cac_epigraph_change(lctr).PU_Days := l_pu_days;
1411: END IF;
1412: FND_FILE.NEW_LINE(fnd_file.log, 1);
1413: FND_FILE.PUT(fnd_file.log,rpad(i.work_center_cac,10));
1414: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_code,10));
1415: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_114,10));
1416: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_126,10));
1409: cac_epigraph_change(lctr).Tot_Days := l_tot_days;
1410: cac_epigraph_change(lctr).PU_Days := l_pu_days;
1411: END IF;
1412: FND_FILE.NEW_LINE(fnd_file.log, 1);
1413: FND_FILE.PUT(fnd_file.log,rpad(i.work_center_cac,10));
1414: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_code,10));
1415: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_114,10));
1416: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_126,10));
1417: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_rec_days),10));
1410: cac_epigraph_change(lctr).PU_Days := l_pu_days;
1411: END IF;
1412: FND_FILE.NEW_LINE(fnd_file.log, 1);
1413: FND_FILE.PUT(fnd_file.log,rpad(i.work_center_cac,10));
1414: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_code,10));
1415: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_114,10));
1416: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_126,10));
1417: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_rec_days),10));
1418: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.start_date,'dd-mm-yyyy'),10));
1411: END IF;
1412: FND_FILE.NEW_LINE(fnd_file.log, 1);
1413: FND_FILE.PUT(fnd_file.log,rpad(i.work_center_cac,10));
1414: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_code,10));
1415: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_114,10));
1416: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_126,10));
1417: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_rec_days),10));
1418: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.start_date,'dd-mm-yyyy'),10));
1419: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.end_date,'dd-mm-yyyy'),10));
1412: FND_FILE.NEW_LINE(fnd_file.log, 1);
1413: FND_FILE.PUT(fnd_file.log,rpad(i.work_center_cac,10));
1414: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_code,10));
1415: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_114,10));
1416: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_126,10));
1417: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_rec_days),10));
1418: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.start_date,'dd-mm-yyyy'),10));
1419: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.end_date,'dd-mm-yyyy'),10));
1420: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_days_worked),5));
1413: FND_FILE.PUT(fnd_file.log,rpad(i.work_center_cac,10));
1414: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_code,10));
1415: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_114,10));
1416: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_126,10));
1417: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_rec_days),10));
1418: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.start_date,'dd-mm-yyyy'),10));
1419: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.end_date,'dd-mm-yyyy'),10));
1420: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_days_worked),5));
1421: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_td_days),5));
1414: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_code,10));
1415: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_114,10));
1416: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_126,10));
1417: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_rec_days),10));
1418: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.start_date,'dd-mm-yyyy'),10));
1419: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.end_date,'dd-mm-yyyy'),10));
1420: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_days_worked),5));
1421: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_td_days),5));
1422: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_tot_days),5));
1415: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_114,10));
1416: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_126,10));
1417: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_rec_days),10));
1418: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.start_date,'dd-mm-yyyy'),10));
1419: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.end_date,'dd-mm-yyyy'),10));
1420: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_days_worked),5));
1421: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_td_days),5));
1422: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_tot_days),5));
1423: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_pu_days),5));
1416: FND_FILE.PUT(fnd_file.log,rpad(i.epigraph_126,10));
1417: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_rec_days),10));
1418: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.start_date,'dd-mm-yyyy'),10));
1419: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.end_date,'dd-mm-yyyy'),10));
1420: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_days_worked),5));
1421: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_td_days),5));
1422: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_tot_days),5));
1423: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_pu_days),5));
1424: END IF;
1417: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_rec_days),10));
1418: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.start_date,'dd-mm-yyyy'),10));
1419: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.end_date,'dd-mm-yyyy'),10));
1420: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_days_worked),5));
1421: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_td_days),5));
1422: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_tot_days),5));
1423: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_pu_days),5));
1424: END IF;
1425: END LOOP;
1418: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.start_date,'dd-mm-yyyy'),10));
1419: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.end_date,'dd-mm-yyyy'),10));
1420: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_days_worked),5));
1421: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_td_days),5));
1422: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_tot_days),5));
1423: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_pu_days),5));
1424: END IF;
1425: END LOOP;
1426: RETURN lctr;
1419: FND_FILE.PUT(fnd_file.log,rpad(to_char(i.end_date,'dd-mm-yyyy'),10));
1420: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_days_worked),5));
1421: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_td_days),5));
1422: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_tot_days),5));
1423: FND_FILE.PUT(fnd_file.log,rpad(to_char(l_pu_days),5));
1424: END IF;
1425: END LOOP;
1426: RETURN lctr;
1427: --