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.PJI_TIME_C dependencies on PJI_TIME_C

Line 1: PACKAGE BODY PJI_TIME_C AS

1: PACKAGE BODY PJI_TIME_C AS
2: /*$Header: PJICMT1B.pls 120.3 2005/10/17 18:09:43 appldev noship $*/
3:
4:
5: -- ------------------------

Line 171: FROM pji_time_cal_extr_info

167: , NVL(latest_end_date,TRUNC(SYSDATE))
168: INTO
169: g_earliest_start_date
170: , g_latest_end_date
171: FROM pji_time_cal_extr_info
172: WHERE calendar_id = -1;
173: EXCEPTION
174: WHEN NO_DATA_FOUND THEN
175: g_cal_info_exists:='N';

Line 339: INSERT INTO pji_time_cal_extr_info

335: BEGIN
336: IF g_debug_flag = 'Y' THEN
337: pji_utils.write2log('Trying to insert record into PJI_TIME_EXTR_INFO table.');
338: END IF;
339: INSERT INTO pji_time_cal_extr_info
340: (calendar_id, earliest_start_date,
341: latest_end_date, creation_date,
342: last_update_date, last_updated_by,
343: created_by, last_update_login)

Line 351: UPDATE pji_time_cal_extr_info

347: WHEN DUP_VAL_ON_INDEX THEN
348: IF g_debug_flag = 'Y' THEN
349: pji_utils.write2log('Duplicate records. Now trying to update the record...');
350: END IF;
351: UPDATE pji_time_cal_extr_info
352: SET earliest_start_date = LEAST(l_min_date, earliest_start_date)
353: , latest_end_date = GREATEST(l_max_date, latest_end_date)
354: WHERE calendar_id = -1;
355: g_cal_info_exists:='Y';

Line 358: UPDATE pji_time_cal_extr_info

354: WHERE calendar_id = -1;
355: g_cal_info_exists:='Y';
356: END;
357: ELSE
358: UPDATE pji_time_cal_extr_info
359: SET earliest_start_date = LEAST(l_min_date, earliest_start_date)
360: , latest_end_date = GREATEST(l_max_date, latest_end_date)
361: WHERE calendar_id = -1;
362: END IF;

Line 604: INSERT INTO pji_time_cal_period(cal_period_id

600: AND adjustment_period_flag='N'
601: AND (start_date < p_earliest_start_date
602: OR end_date > p_latest_end_date);
603:
604: INSERT INTO pji_time_cal_period(cal_period_id
605: , cal_qtr_id
606: , calendar_id
607: , SEQUENCE
608: , NAME

Line 634: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_PERIOD table.');

630:
631: l_no_rows_inserted := SQL%rowcount;
632:
633: IF g_debug_flag = 'Y' THEN
634: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_PERIOD table.');
635: END IF;
636:
637: IF l_no_rows_inserted > 0 THEN
638: SELECT MIN(start_date), MAX(end_date)

Line 640: FROM pji_time_cal_period

636:
637: IF l_no_rows_inserted > 0 THEN
638: SELECT MIN(start_date), MAX(end_date)
639: INTO l_min_date, l_max_date
640: FROM pji_time_cal_period
641: WHERE (start_date < p_earliest_start_date
642: OR end_date > p_latest_end_date)
643: AND calendar_id = p_calendar_id;
644:

Line 652: INSERT INTO pji_time_cal_extr_info

648: BEGIN
649: IF g_debug_flag = 'Y' THEN
650: pji_utils.write2log('Trying to insert record into PJI_TIME_EXTR_INFO table.');
651: END IF;
652: INSERT INTO pji_time_cal_extr_info
653: (calendar_id, earliest_start_date,
654: latest_end_date, creation_date,
655: last_update_date, last_updated_by,
656: created_by, last_update_login)

Line 664: UPDATE pji_time_cal_extr_info

660: WHEN DUP_VAL_ON_INDEX THEN
661: IF g_debug_flag = 'Y' THEN
662: pji_utils.write2log('Duplicate records. Now trying to update the record...');
663: END IF;
664: UPDATE pji_time_cal_extr_info
665: SET earliest_start_date = LEAST(l_min_date, earliest_start_date)
666: , latest_end_date = GREATEST(l_max_date, latest_end_date)
667: WHERE calendar_id = p_calendar_id;
668: END;

Line 670: UPDATE pji_time_cal_extr_info

666: , latest_end_date = GREATEST(l_max_date, latest_end_date)
667: WHERE calendar_id = p_calendar_id;
668: END;
669: ELSE
670: UPDATE pji_time_cal_extr_info
671: SET earliest_start_date = LEAST(l_min_date, earliest_start_date)
672: , latest_end_date = GREATEST(l_max_date, latest_end_date)
673: WHERE calendar_id = p_calendar_id;
674: END IF;

Line 691: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_CAL_PERIOD table.');

687: END IF;
688: EXCEPTION
689: WHEN DUP_VAL_ON_INDEX THEN
690: IF g_debug_flag = 'Y' THEN
691: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_CAL_PERIOD table.');
692: END IF;
693: RETURN FALSE;
694: END LOAD_CAL_PERIOD;
695:

Line 699: -- entries in PJI_TIME_CAL_YEAR.

695:
696: ---------------------------------------------------
697: -- PRIVATE PROCEDURE load_cal_qtr
698: -- This procedure incrementally maintains quarter
699: -- entries in PJI_TIME_CAL_YEAR.
700: ---------------------------------------------------
701: PROCEDURE LOAD_CAL_QUARTER(p_calendar_id NUMBER
702: , p_earliest_start_date DATE
703: , p_latest_end_date DATE

Line 724: FROM pji_time_cal_qtr

720: l_start_qtr_id
721: , l_end_qtr_id
722: , l_earliest_qtr_end_date
723: , l_latest_qtr_start_date
724: FROM pji_time_cal_qtr
725: WHERE 1=1
726: AND calendar_id = p_calendar_id
727: AND (p_earliest_start_date BETWEEN start_date AND end_date)
728: OR (p_latest_end_date BETWEEN start_date AND end_date);

Line 737: DELETE FROM pji_time_cal_qtr

733: pji_utils.write2log('l_latest_qtr_start_date: '||l_latest_qtr_start_date);
734: END IF;
735: END IF;
736:
737: DELETE FROM pji_time_cal_qtr
738: WHERE cal_qtr_id in (SELECT DISTINCT LPAD(p_calendar_id,3,'0')||period_year||quarter_num FROM pji_time_extr_tmp);
739:
740: l_no_rows_deleted := SQL%rowcount;
741:

Line 743: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_QTR table.');

739:
740: l_no_rows_deleted := SQL%rowcount;
741:
742: IF g_debug_flag = 'Y' THEN
743: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_QTR table.');
744: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_QTR table.');
745: END IF;
746:
747: INSERT INTO pji_time_cal_qtr

Line 744: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_QTR table.');

740: l_no_rows_deleted := SQL%rowcount;
741:
742: IF g_debug_flag = 'Y' THEN
743: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_QTR table.');
744: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_QTR table.');
745: END IF;
746:
747: INSERT INTO pji_time_cal_qtr
748: (cal_qtr_id

Line 747: INSERT INTO pji_time_cal_qtr

743: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_QTR table.');
744: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_QTR table.');
745: END IF;
746:
747: INSERT INTO pji_time_cal_qtr
748: (cal_qtr_id
749: , cal_year_id
750: , calendar_id
751: , SEQUENCE

Line 784: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_QTR table.');

780:
781: l_no_rows_inserted := SQL%rowcount;
782:
783: IF g_debug_flag = 'Y' THEN
784: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_QTR table.');
785: END IF;
786:
787: EXCEPTION
788: WHEN DUP_VAL_ON_INDEX THEN

Line 790: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_CAL_QTR table.');

786:
787: EXCEPTION
788: WHEN DUP_VAL_ON_INDEX THEN
789: IF g_debug_flag = 'Y' THEN
790: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_CAL_QTR table.');
791: END IF;
792: END LOAD_CAL_QUARTER;
793:
794: ---------------------------------------------------

Line 797: -- entries in PJI_TIME_CAL_YEAR.

793:
794: ---------------------------------------------------
795: -- PRIVATE PROCEDURE load_cal_year
796: -- This procedure incrementally maintains year
797: -- entries in PJI_TIME_CAL_YEAR.
798: ---------------------------------------------------
799: PROCEDURE LOAD_CAL_YEAR(p_calendar_id NUMBER
800: , p_earliest_start_date DATE
801: , p_latest_end_date DATE

Line 821: FROM pji_time_cal_year

817: l_start_yr_id
818: , l_end_yr_id
819: , l_earliest_yr_end_date
820: , l_latest_yr_start_date
821: FROM pji_time_cal_year
822: WHERE 1=1
823: AND calendar_id = p_calendar_id
824: AND (g_earliest_start_date BETWEEN start_date AND end_date)
825: OR (g_latest_end_date BETWEEN start_date AND end_date);

Line 835: DELETE FROM pji_time_cal_year

831: pji_utils.write2log('l_latest_yr_start_date: '||l_latest_yr_start_date);
832: END IF;
833: END IF;
834:
835: DELETE FROM pji_time_cal_year
836: WHERE cal_year_id in (SELECT DISTINCT LPAD(p_calendar_id,3,'0')||period_year from pji_time_extr_tmp);
837:
838: l_no_rows_deleted := SQL%rowcount;
839:

Line 841: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_YEAR table.');

837:
838: l_no_rows_deleted := SQL%rowcount;
839:
840: IF g_debug_flag = 'Y' THEN
841: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_YEAR table.');
842: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_YEAR table.');
843: END IF;
844:
845: INSERT INTO PJI_TIME_CAL_YEAR

Line 842: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_YEAR table.');

838: l_no_rows_deleted := SQL%rowcount;
839:
840: IF g_debug_flag = 'Y' THEN
841: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_YEAR table.');
842: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_YEAR table.');
843: END IF;
844:
845: INSERT INTO PJI_TIME_CAL_YEAR
846: (cal_year_id

Line 845: INSERT INTO PJI_TIME_CAL_YEAR

841: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_YEAR table.');
842: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_YEAR table.');
843: END IF;
844:
845: INSERT INTO PJI_TIME_CAL_YEAR
846: (cal_year_id
847: , calendar_id
848: , SEQUENCE
849: , NAME

Line 877: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_YEAR table.');

873:
874: l_no_rows_inserted := SQL%rowcount;
875:
876: IF g_debug_flag = 'Y' THEN
877: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_YEAR table.');
878: END IF;
879:
880: EXCEPTION
881: WHEN DUP_VAL_ON_INDEX THEN

Line 883: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_CAL_YEAR table.');

879:
880: EXCEPTION
881: WHEN DUP_VAL_ON_INDEX THEN
882: IF g_debug_flag = 'Y' THEN
883: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_CAL_YEAR table.');
884: END IF;
885: END LOAD_CAL_YEAR;
886:
887: ---------------------------------------------------

Line 1215: -- entries in PJI_TIME_CAL_RPT_STRUCT table.

1211:
1212: ---------------------------------------------------
1213: -- PRIVATE PROCEDURE load_time_cal_rpt_struct
1214: -- This procedure incrementally maintains
1215: -- entries in PJI_TIME_CAL_RPT_STRUCT table.
1216: ---------------------------------------------------
1217: PROCEDURE LOAD_TIME_CAL_RPT_STRUCT ( p_calendar_id NUMBER
1218: , p_earliest_start_date DATE
1219: , p_min_date DATE

Line 1248: FROM pji_time_cal_period period

1244: , l_year_start_date
1245: , l_qtr_end_date
1246: , l_period_end_date
1247: , l_year_end_date
1248: FROM pji_time_cal_period period
1249: , pji_time_cal_qtr qtr
1250: , pji_time_cal_year yr
1251: WHERE 1=1
1252: AND period.calendar_id = p_calendar_id

Line 1249: , pji_time_cal_qtr qtr

1245: , l_qtr_end_date
1246: , l_period_end_date
1247: , l_year_end_date
1248: FROM pji_time_cal_period period
1249: , pji_time_cal_qtr qtr
1250: , pji_time_cal_year yr
1251: WHERE 1=1
1252: AND period.calendar_id = p_calendar_id
1253: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 1250: , pji_time_cal_year yr

1246: , l_period_end_date
1247: , l_year_end_date
1248: FROM pji_time_cal_period period
1249: , pji_time_cal_qtr qtr
1250: , pji_time_cal_year yr
1251: WHERE 1=1
1252: AND period.calendar_id = p_calendar_id
1253: AND period.cal_qtr_id = qtr.cal_qtr_id
1254: AND qtr.cal_year_id = yr.cal_year_id

Line 1261: INSERT INTO PJI_TIME_CAL_RPT_STRUCT

1257: IF g_debug_flag = 'Y' THEN
1258: pji_utils.write2log('Creating prior year records for time periods after the current year.');
1259: END IF;
1260:
1261: INSERT INTO PJI_TIME_CAL_RPT_STRUCT
1262: (calendar_id
1263: , calendar_type
1264: , report_date
1265: , time_id

Line 1285: FROM PJI_TIME_CAL_YEAR year

1281: , SYSDATE
1282: , g_user_id
1283: , g_user_id
1284: , g_login_id
1285: FROM PJI_TIME_CAL_YEAR year
1286: , PJI_TIME_CAL_PERIOD period
1287: WHERE year.end_date < l_year_start_date
1288: AND year.calendar_id = p_calendar_id
1289: AND period.calendar_id = p_calendar_id

Line 1286: , PJI_TIME_CAL_PERIOD period

1282: , g_user_id
1283: , g_user_id
1284: , g_login_id
1285: FROM PJI_TIME_CAL_YEAR year
1286: , PJI_TIME_CAL_PERIOD period
1287: WHERE year.end_date < l_year_start_date
1288: AND year.calendar_id = p_calendar_id
1289: AND period.calendar_id = p_calendar_id
1290: AND period.start_date > p_earliest_start_date;

Line 1298: INSERT INTO PJI_TIME_CAL_RPT_STRUCT

1294: IF g_debug_flag = 'Y' THEN
1295: pji_utils.write2log('Creating prior quarter records for time periods records after current quarter.');
1296: END IF;
1297:
1298: INSERT INTO PJI_TIME_CAL_RPT_STRUCT
1299: (calendar_id
1300: , calendar_type
1301: , report_date
1302: , time_id

Line 1322: FROM PJI_TIME_CAL_QTR qtr

1318: , SYSDATE
1319: , g_user_id
1320: , g_user_id
1321: , g_login_id
1322: FROM PJI_TIME_CAL_QTR qtr
1323: , PJI_TIME_CAL_PERIOD period
1324: WHERE 1=1
1325: AND qtr.end_date < l_qtr_start_date
1326: AND qtr.start_date >= l_year_start_date

Line 1323: , PJI_TIME_CAL_PERIOD period

1319: , g_user_id
1320: , g_user_id
1321: , g_login_id
1322: FROM PJI_TIME_CAL_QTR qtr
1323: , PJI_TIME_CAL_PERIOD period
1324: WHERE 1=1
1325: AND qtr.end_date < l_qtr_start_date
1326: AND qtr.start_date >= l_year_start_date
1327: AND qtr.calendar_id = p_calendar_id

Line 1338: INSERT INTO PJI_TIME_CAL_RPT_STRUCT

1334: IF g_debug_flag = 'Y' THEN
1335: pji_utils.write2log('Creating prior period records for time periods records after current periods.');
1336: END IF;
1337:
1338: INSERT INTO PJI_TIME_CAL_RPT_STRUCT
1339: (calendar_id
1340: , calendar_type
1341: , report_date
1342: , time_id

Line 1362: FROM PJI_TIME_CAL_PERIOD newprd

1358: , SYSDATE
1359: , g_user_id
1360: , g_user_id
1361: , g_login_id
1362: FROM PJI_TIME_CAL_PERIOD newprd
1363: , PJI_TIME_CAL_PERIOD oldprd
1364: WHERE 1=1
1365: AND newprd.end_date < l_period_start_date
1366: AND newprd.start_date >= l_qtr_start_date

Line 1363: , PJI_TIME_CAL_PERIOD oldprd

1359: , g_user_id
1360: , g_user_id
1361: , g_login_id
1362: FROM PJI_TIME_CAL_PERIOD newprd
1363: , PJI_TIME_CAL_PERIOD oldprd
1364: WHERE 1=1
1365: AND newprd.end_date < l_period_start_date
1366: AND newprd.start_date >= l_qtr_start_date
1367: AND newprd.calendar_id = p_calendar_id

Line 1393: , pji_time_cal_period period

1389: , period.end_date period_end_date
1390: , qtr.end_date qtr_end_date
1391: , YEAR.end_date year_end_date
1392: FROM pji_time_extr_tmp extr
1393: , pji_time_cal_period period
1394: , pji_time_cal_qtr qtr
1395: , pji_time_cal_year YEAR
1396: WHERE 1=1
1397: AND period.calendar_id = p_calendar_id

Line 1394: , pji_time_cal_qtr qtr

1390: , qtr.end_date qtr_end_date
1391: , YEAR.end_date year_end_date
1392: FROM pji_time_extr_tmp extr
1393: , pji_time_cal_period period
1394: , pji_time_cal_qtr qtr
1395: , pji_time_cal_year YEAR
1396: WHERE 1=1
1397: AND period.calendar_id = p_calendar_id
1398: AND TO_NUMBER(LPAD(p_calendar_id,3,'0')||period_year||quarter_num||DECODE(LENGTH(period_num),1,'0'||period_num, period_num)) = period.cal_period_id

Line 1395: , pji_time_cal_year YEAR

1391: , YEAR.end_date year_end_date
1392: FROM pji_time_extr_tmp extr
1393: , pji_time_cal_period period
1394: , pji_time_cal_qtr qtr
1395: , pji_time_cal_year YEAR
1396: WHERE 1=1
1397: AND period.calendar_id = p_calendar_id
1398: AND TO_NUMBER(LPAD(p_calendar_id,3,'0')||period_year||quarter_num||DECODE(LENGTH(period_num),1,'0'||period_num, period_num)) = period.cal_period_id
1399: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 1402: INSERT INTO PJI_TIME_CAL_RPT_STRUCT

1398: AND TO_NUMBER(LPAD(p_calendar_id,3,'0')||period_year||quarter_num||DECODE(LENGTH(period_num),1,'0'||period_num, period_num)) = period.cal_period_id
1399: AND period.cal_qtr_id = qtr.cal_qtr_id
1400: AND qtr.cal_year_id = YEAR.cal_year_id)
1401: LOOP
1402: INSERT INTO PJI_TIME_CAL_RPT_STRUCT
1403: (calendar_id
1404: , calendar_type
1405: , report_date
1406: , time_id

Line 1426: FROM PJI_TIME_CAL_PERIOD

1422: , SYSDATE
1423: , g_user_id
1424: , g_user_id
1425: , g_login_id
1426: FROM PJI_TIME_CAL_PERIOD
1427: WHERE start_date >= extr_rec.qtr_start_date
1428: AND start_date <= extr_rec.period_start_date
1429: AND end_date < extr_rec.report_date
1430: AND calendar_id = p_calendar_id

Line 1444: FROM PJI_TIME_CAL_PERIOD

1440: , SYSDATE
1441: , g_user_id
1442: , g_user_id
1443: , g_login_id
1444: FROM PJI_TIME_CAL_PERIOD
1445: WHERE start_date >= extr_rec.qtr_start_date
1446: AND start_date <= extr_rec.period_start_date
1447: AND end_date >= extr_rec.report_date
1448: AND calendar_id = p_calendar_id;

Line 1452: INSERT INTO PJI_TIME_CAL_RPT_STRUCT

1448: AND calendar_id = p_calendar_id;
1449:
1450: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;
1451:
1452: INSERT INTO PJI_TIME_CAL_RPT_STRUCT
1453: (calendar_id
1454: , calendar_type
1455: , report_date
1456: , time_id

Line 1476: FROM PJI_TIME_CAL_QTR

1472: , SYSDATE
1473: , g_user_id
1474: , g_user_id
1475: , g_login_id
1476: FROM PJI_TIME_CAL_QTR
1477: WHERE start_date >= extr_rec.year_start_date
1478: AND start_date <= extr_rec.qtr_start_date
1479: AND end_date < extr_rec.report_date
1480: AND calendar_id = p_calendar_id

Line 1494: FROM PJI_TIME_CAL_QTR

1490: , SYSDATE
1491: , g_user_id
1492: , g_user_id
1493: , g_login_id
1494: FROM PJI_TIME_CAL_QTR
1495: WHERE start_date >= extr_rec.year_start_date
1496: AND start_date <= extr_rec.qtr_start_date
1497: AND end_date >= extr_rec.report_date
1498: AND calendar_id = p_calendar_id;

Line 1502: INSERT INTO PJI_TIME_CAL_RPT_STRUCT

1498: AND calendar_id = p_calendar_id;
1499:
1500: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;
1501:
1502: INSERT INTO PJI_TIME_CAL_RPT_STRUCT
1503: (calendar_id
1504: , calendar_type
1505: , report_date
1506: , time_id

Line 1526: FROM PJI_TIME_CAL_YEAR

1522: , SYSDATE
1523: , g_user_id
1524: , g_user_id
1525: , g_login_id
1526: FROM PJI_TIME_CAL_YEAR
1527: WHERE extr_rec.report_date BETWEEN start_date AND end_date
1528: AND calendar_id = p_calendar_id
1529: UNION ALL
1530: SELECT

Line 1542: FROM PJI_TIME_CAL_YEAR

1538: , SYSDATE
1539: , g_user_id
1540: , g_user_id
1541: , g_login_id
1542: FROM PJI_TIME_CAL_YEAR
1543: WHERE end_date < extr_rec.report_date
1544: AND calendar_id = p_calendar_id;
1545:
1546: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;

Line 1549: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_RPT_STRUCT table for date : '||Fnd_Date.date_to_displaydate(extr_rec.report_date));

1545:
1546: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;
1547:
1548: IF g_debug_flag = 'Y' THEN
1549: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_RPT_STRUCT table for date : '||Fnd_Date.date_to_displaydate(extr_rec.report_date));
1550: END IF;
1551:
1552: END LOOP;
1553: END LOAD_TIME_CAL_RPT_STRUCT;

Line 1619: , PJI_TIME_CAL_EXTR_INFO info

1615: , l_earliest_start_dates_tbl
1616: , l_latest_end_dates_tbl
1617: , l_cal_info_exists_tbl
1618: FROM fii_time_cal_name cal
1619: , PJI_TIME_CAL_EXTR_INFO info
1620: WHERE 1=1
1621: AND cal.calendar_id = info.calendar_id (+)
1622: AND cal.calendar_id = NVL(l_calendar_id,cal.calendar_id)
1623: AND cal.period_set_name = NVL(p_period_set_name,cal.period_set_name)

Line 1766: END PJI_TIME_C;

1762:
1763: BEGIN
1764: NULL;
1765: --INIT;
1766: END PJI_TIME_C;