DBA Data[Home] [Help]

APPS.DDR_POP_CALENDAR_PKG dependencies on DDR_R_CLNDR_MNTH

Line 960: SELECT DDR_R_CLNDR_MNTH_SEQ.NEXTVAL

956: l_month_no := l_month_no + 1;
957: l_curr_month_start_date := l_curr_date;
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:

Line 965: insert into DDR_R_CLNDR_MNTH (

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,
967: MNTH_CD,
968: MNTH_NBR,
969: MNTH_DESC,