DBA Data[Home] [Help]

APPS.DDR_POP_CALENDAR_PKG dependencies on DDR_R_PLNG_WK

Line 2743: SELECT DDR_R_PLNG_WK_SEQ.NEXTVAL

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

Line 2748: insert into DDR_R_PLNG_WK (

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,
2750: MFG_ORG_CD,
2751: CLNDR_CD,
2752: WK_CD,