DBA Data[Home] [Help]

APPS.DDR_POP_CALENDAR_PKG dependencies on DDR_R_CLNDR_WK_SEQ

Line 1013: SELECT DDR_R_CLNDR_WK_SEQ.NEXTVAL

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