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.DDR_POP_CALENDAR_PKG dependencies on DUAL

Line 849: FROM DUAL;

845: l_no_year_days := l_curr_year_end_date - l_curr_year_start_date + 1;
846: -- l_curr_year_id := TO_NUMBER(TO_CHAR(l_curr_year_start_date,g_YR_ID_format));
847: SELECT DDR_R_CLNDR_YR_SEQ.NEXTVAL
848: INTO l_curr_year_id
849: FROM DUAL;
850: l_curr_year_desc := 'CY ' || TO_CHAR(l_curr_year);
851:
852: insert into DDR_R_CLNDR_YR (
853: CLNDR_YR_ID,

Line 909: FROM DUAL;

905: l_curr_qtr_end_date := ADD_MONTHS(l_curr_qtr_start_date,3)-1;
906: -- l_curr_qtr_id := TO_NUMBER(TO_CHAR(l_curr_qtr_start_date,g_QTR_ID_format));
907: SELECT DDR_R_CLNDR_QTR_SEQ.NEXTVAL
908: INTO l_curr_qtr_id
909: FROM DUAL;
910: l_curr_qtr := TO_NUMBER(TO_CHAR(l_curr_year) || TO_CHAR(l_qtr_no));
911:
912: insert into DDR_R_CLNDR_QTR (
913: CLNDR_QTR_ID,

Line 962: FROM DUAL;

958: l_curr_month_end_date := ADD_MONTHS(l_curr_month_start_date,1)-1;
959: -- l_curr_month_id := TO_NUMBER(TO_CHAR(l_curr_month_start_date,g_MNTH_ID_format));
960: SELECT DDR_R_CLNDR_MNTH_SEQ.NEXTVAL
961: INTO l_curr_month_id
962: FROM DUAL;
963: l_curr_month := TO_NUMBER(TO_CHAR(l_curr_year) || LPAD(TO_CHAR(l_month_no),2,'0'));
964:
965: insert into DDR_R_CLNDR_MNTH (
966: CLNDR_MNTH_ID,

Line 1015: FROM DUAL;

1011: l_curr_week_end_date := l_curr_week_start_date + 7 - 1;
1012: -- l_curr_week_id := TO_NUMBER(TO_CHAR(l_curr_week_start_date,g_WK_ID_format));
1013: SELECT DDR_R_CLNDR_WK_SEQ.NEXTVAL
1014: INTO l_curr_week_id
1015: FROM DUAL;
1016: l_curr_week := TO_NUMBER(TO_CHAR(l_curr_year) || LPAD(TO_CHAR(l_week_no),2,'0'));
1017:
1018: insert into DDR_R_CLNDR_WK (
1019: CLNDR_WK_ID,

Line 1269: FROM DUAL;

1265: l_no_year_days := l_curr_year_end_date - l_curr_year_start_date + 1;
1266: -- l_curr_year_id := TO_NUMBER(TO_CHAR(l_curr_year_start_date,g_YR_ID_format));
1267: SELECT DDR_R_BSNS_YR_SEQ.NEXTVAL
1268: INTO l_curr_year_id
1269: FROM DUAL;
1270: l_curr_year_desc := 'BY ' || TO_CHAR(l_curr_year);
1271:
1272: insert into DDR_R_BSNS_YR (
1273: BSNS_YR_ID,

Line 1354: FROM DUAL;

1350: l_curr_qtr_end_date := l_curr_qtr_start_date + 7*l_no_of_weeks_qtr - 1;
1351: -- l_curr_qtr_id := TO_NUMBER(TO_CHAR(l_curr_qtr_start_date,g_QTR_ID_format));
1352: SELECT DDR_R_BSNS_QTR_SEQ.NEXTVAL
1353: INTO l_curr_qtr_id
1354: FROM DUAL;
1355: l_curr_qtr := TO_NUMBER(TO_CHAR(l_curr_year) || TO_CHAR(l_qtr_no));
1356:
1357: insert into DDR_R_BSNS_QTR (
1358: BSNS_QTR_ID,

Line 1420: FROM DUAL;

1416: l_curr_month_end_date := l_curr_month_start_date + 7*l_no_of_weeks_month - 1;
1417: -- l_curr_month_id := TO_NUMBER(TO_CHAR(l_curr_month_start_date,g_MNTH_ID_format));
1418: SELECT DDR_R_BSNS_MNTH_SEQ.NEXTVAL
1419: INTO l_curr_month_id
1420: FROM DUAL;
1421: l_curr_month := TO_NUMBER(TO_CHAR(l_curr_year) || LPAD(TO_CHAR(l_month_no),2,'0'));
1422:
1423: insert into DDR_R_BSNS_MNTH (
1424: BSNS_MNTH_ID,

Line 1476: FROM DUAL;

1472: l_curr_week_end_date := l_curr_week_start_date + 7 - 1;
1473: -- l_curr_week_id := TO_NUMBER(TO_CHAR(l_curr_week_start_date,g_WK_ID_format));
1474: SELECT DDR_R_BSNS_WK_SEQ.NEXTVAL
1475: INTO l_curr_week_id
1476: FROM DUAL;
1477: l_curr_week := TO_NUMBER(TO_CHAR(l_curr_year) || LPAD(TO_CHAR(l_week_no),2,'0'));
1478:
1479: insert into DDR_R_BSNS_WK (
1480: BSNS_WK_ID,

Line 1700: FROM DUAL;

1696: l_no_year_days := l_curr_year_end_date - l_curr_year_start_date + 1;
1697: -- l_curr_year_id := TO_NUMBER(TO_CHAR(l_curr_year_start_date,g_YR_ID_format));
1698: SELECT DDR_R_FSCL_YR_SEQ.NEXTVAL
1699: INTO l_curr_year_id
1700: FROM DUAL;
1701: l_curr_year_desc := 'FY ' || TO_CHAR(l_curr_year);
1702:
1703: insert into DDR_R_FSCL_YR (
1704: FSCL_YR_ID,

Line 1764: FROM DUAL;

1760: l_curr_qtr_end_date := ADD_MONTHS(l_curr_qtr_start_date,3)-1;
1761: -- l_curr_qtr_id := TO_NUMBER(TO_CHAR(l_curr_qtr_start_date,g_QTR_ID_format));
1762: SELECT DDR_R_FSCL_QTR_SEQ.NEXTVAL
1763: INTO l_curr_qtr_id
1764: FROM DUAL;
1765: l_curr_qtr := TO_NUMBER(TO_CHAR(l_curr_year) || TO_CHAR(l_qtr_no));
1766:
1767: insert into DDR_R_FSCL_QTR (
1768: FSCL_QTR_ID,

Line 1821: FROM DUAL;

1817: l_curr_month_end_date := ADD_MONTHS(l_curr_month_start_date,1)-1;
1818: -- l_curr_month_id := TO_NUMBER(TO_CHAR(l_curr_month_start_date,g_MNTH_ID_format));
1819: SELECT DDR_R_FSCL_MNTH_SEQ.NEXTVAL
1820: INTO l_curr_month_id
1821: FROM DUAL;
1822: l_curr_month := TO_NUMBER(TO_CHAR(l_curr_year) || LPAD(TO_CHAR(l_month_no),2,'0'));
1823:
1824: insert into DDR_R_FSCL_MNTH (
1825: FSCL_MNTH_ID,

Line 2082: FROM DUAL;

2078: l_no_year_days := l_curr_year_end_date - l_curr_year_start_date + 1;
2079: -- l_curr_year_id := TO_NUMBER(TO_CHAR(l_curr_year_start_date,g_YR_ID_format));
2080: SELECT DDR_R_ADVR_YR_SEQ.NEXTVAL
2081: INTO l_curr_year_id
2082: FROM DUAL;
2083: l_curr_year_desc := 'AY ' || TO_CHAR(l_curr_year);
2084:
2085: insert into DDR_R_ADVR_YR (
2086: ADVR_YR_ID,

Line 2158: FROM DUAL;

2154: l_curr_qtr_end_date := l_curr_qtr_start_date + 7*l_no_of_weeks_qtr - 1;
2155: -- l_curr_qtr_id := TO_NUMBER(TO_CHAR(l_curr_qtr_start_date,g_QTR_ID_format));
2156: SELECT DDR_R_ADVR_QTR_SEQ.NEXTVAL
2157: INTO l_curr_qtr_id
2158: FROM DUAL;
2159: l_curr_qtr := TO_NUMBER(TO_CHAR(l_curr_year) || TO_CHAR(l_qtr_no));
2160:
2161: insert into DDR_R_ADVR_QTR (
2162: ADVR_QTR_ID,

Line 2224: FROM DUAL;

2220: l_curr_period_end_date := l_curr_period_start_date + 7*l_no_of_weeks_period - 1;
2221: -- l_curr_period_id := TO_NUMBER(TO_CHAR(l_curr_period_start_date,g_PRD_ID_format));
2222: SELECT DDR_R_ADVR_PRD_SEQ.NEXTVAL
2223: INTO l_curr_period_id
2224: FROM DUAL;
2225: l_curr_period := TO_NUMBER(TO_CHAR(l_curr_year) || LPAD(TO_CHAR(l_period_no),2,'0'));
2226:
2227: insert into DDR_R_ADVR_PRD (
2228: ADVR_PRD_ID,

Line 2280: FROM DUAL;

2276: l_curr_week_end_date := l_curr_week_start_date + 7 - 1;
2277: -- l_curr_week_id := TO_NUMBER(TO_CHAR(l_curr_week_start_date,g_WK_ID_format));
2278: SELECT DDR_R_ADVR_WK_SEQ.NEXTVAL
2279: INTO l_curr_week_id
2280: FROM DUAL;
2281: l_curr_week := TO_NUMBER(TO_CHAR(l_curr_year) || LPAD(TO_CHAR(l_week_no),2,'0'));
2282:
2283: insert into DDR_R_ADVR_WK (
2284: ADVR_WK_ID,

Line 2546: FROM DUAL;

2542: l_no_year_days := l_curr_year_end_date - l_curr_year_start_date + 1;
2543: -- l_curr_year_id := TO_NUMBER(TO_CHAR(l_curr_year_start_date,g_YR_ID_format));
2544: SELECT DDR_R_PLNG_YR_SEQ.NEXTVAL
2545: INTO l_curr_year_id
2546: FROM DUAL;
2547: l_curr_year_desc := 'PY ' || TO_CHAR(l_curr_year);
2548:
2549: insert into DDR_R_PLNG_YR (
2550: PLNG_YR_ID,

Line 2623: FROM DUAL;

2619: l_curr_qtr_end_date := l_curr_qtr_start_date + 7*l_no_of_weeks_qtr - 1;
2620: -- l_curr_qtr_id := TO_NUMBER(TO_CHAR(l_curr_qtr_start_date,g_QTR_ID_format));
2621: SELECT DDR_R_PLNG_QTR_SEQ.NEXTVAL
2622: INTO l_curr_qtr_id
2623: FROM DUAL;
2624: l_curr_qtr := TO_NUMBER(TO_CHAR(l_curr_year) || TO_CHAR(l_qtr_no));
2625:
2626: insert into DDR_R_PLNG_QTR (
2627: PLNG_QTR_ID,

Line 2689: FROM DUAL;

2685: l_curr_period_end_date := l_curr_period_start_date + 7*l_no_of_weeks_period - 1;
2686: -- l_curr_period_id := TO_NUMBER(TO_CHAR(l_curr_period_start_date,g_PRD_ID_format));
2687: SELECT DDR_R_PLNG_PRD_SEQ.NEXTVAL
2688: INTO l_curr_period_id
2689: FROM DUAL;
2690: l_curr_period := TO_NUMBER(TO_CHAR(l_curr_year) || LPAD(TO_CHAR(l_period_no),2,'0'));
2691:
2692: insert into DDR_R_PLNG_PRD (
2693: PLNG_PRD_ID,

Line 2745: FROM DUAL;

2741: l_curr_week_end_date := l_curr_week_start_date + 7 - 1;
2742: -- l_curr_week_id := TO_NUMBER(TO_CHAR(l_curr_week_start_date,g_WK_ID_format));
2743: SELECT DDR_R_PLNG_WK_SEQ.NEXTVAL
2744: INTO l_curr_week_id
2745: FROM DUAL;
2746: l_curr_week := TO_NUMBER(TO_CHAR(l_curr_year) || LPAD(TO_CHAR(l_week_no),2,'0'));
2747:
2748: insert into DDR_R_PLNG_WK (
2749: PLNG_WK_ID,