APPS.DDR_POP_CALENDAR_PKG dependencies on DDR_R_PLNG_YR

Line 45: ELSIF p_clndr_type = 'PLNG' THEN l_table_name := 'DDR_R_PLNG_YR';

41: IF p_clndr_type = 'CLNDR' THEN l_table_name := 'DDR_R_CLNDR_YR';
42: ELSIF p_clndr_type = 'BSNS' THEN l_table_name := 'DDR_R_BSNS_YR';
43: ELSIF p_clndr_type = 'FSCL' THEN l_table_name := 'DDR_R_FSCL_YR';
44: ELSIF p_clndr_type = 'ADVR' THEN l_table_name := 'DDR_R_ADVR_YR';
45: ELSIF p_clndr_type = 'PLNG' THEN l_table_name := 'DDR_R_PLNG_YR';
46: END IF;
47:
48: /*
49: SELECT yr_strt_dt, yr_end_dt

Line 2544: SELECT DDR_R_PLNG_YR_SEQ.NEXTVAL

2540: l_curr_year_start_date := l_curr_year_end_date+1;
2541: l_curr_year_end_date := l_curr_year_start_date + (7*l_no_of_weeks) - 1;
2542: l_no_year_days := l_curr_year_end_date - l_curr_year_start_date + 1;
2543: -- l_curr_year_id := TO_NUMBER(TO_CHAR(l_curr_year_start_date,g_YR_ID_format));
2544: SELECT DDR_R_PLNG_YR_SEQ.NEXTVAL
2545: INTO l_curr_year_id
2546: FROM DUAL;
2547: l_curr_year_desc := 'PY ' || TO_CHAR(l_curr_year);
2548:

Line 2549: insert into DDR_R_PLNG_YR (

2545: INTO l_curr_year_id
2546: FROM DUAL;
2547: l_curr_year_desc := 'PY ' || TO_CHAR(l_curr_year);
2548:
2549: insert into DDR_R_PLNG_YR (
2550: PLNG_YR_ID,
2551: MFG_ORG_CD,
2552: CLNDR_CD,
2553: YR_CD,