DBA Data[Home] [Help]

APPS.DDR_POP_CALENDAR_PKG dependencies on DDR_R_ADVR_WK_SEQ

Line 2278: SELECT DDR_R_ADVR_WK_SEQ.NEXTVAL

2274: l_week_no := l_week_no + 1;
2275: l_curr_week_start_date := l_curr_date;
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: