APPS.DDR_POP_CALENDAR_PKG dependencies on DDR_R_ADVR_WK

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:

Line 2283: insert into DDR_R_ADVR_WK (

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,
2285: MFG_ORG_CD,
2286: CLNDR_CD,
2287: WK_CD,