APPS.DDR_POP_CALENDAR_PKG dependencies on DDR_R_ADVR_YR

Line 44: ELSIF p_clndr_type = 'ADVR' THEN l_table_name := 'DDR_R_ADVR_YR';

40: BEGIN
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: /*

Line 2011: /* Check existence of record in DDR_R_ADVR_YR and get last year details */

2007:
2008: /* Set the Manufacturer code with the given organization code */
2009: l_mfg_org_cd := p_org_cd;
2010:
2011: /* Check existence of record in DDR_R_ADVR_YR and get last year details */
2012: Get_Last_Year_Details('ADVR',p_org_cd,l_last_year,l_last_year_start_date,l_last_year_end_date);
2013: IF l_last_year IS NULL /* Last year record does not exist */
2014: THEN
2015: IF p_start_date IS NULL

Line 2080: SELECT DDR_R_ADVR_YR_SEQ.NEXTVAL

2076: l_curr_year_start_date := l_curr_year_end_date+1;
2077: l_curr_year_end_date := l_curr_year_start_date + (7*l_no_of_weeks) - 1;
2078: l_no_year_days := l_curr_year_end_date - l_curr_year_start_date + 1;
2079: -- l_curr_year_id := TO_NUMBER(TO_CHAR(l_curr_year_start_date,g_YR_ID_format));
2080: SELECT DDR_R_ADVR_YR_SEQ.NEXTVAL
2081: INTO l_curr_year_id
2082: FROM DUAL;
2083: l_curr_year_desc := 'AY ' || TO_CHAR(l_curr_year);
2084:

Line 2085: insert into DDR_R_ADVR_YR (

2081: INTO l_curr_year_id
2082: FROM DUAL;
2083: l_curr_year_desc := 'AY ' || TO_CHAR(l_curr_year);
2084:
2085: insert into DDR_R_ADVR_YR (
2086: ADVR_YR_ID,
2087: MFG_ORG_CD,
2088: CLNDR_CD,
2089: YR_CD,

Line 2475: /* Check existence of record in DDR_R_ADVR_YR and get last year details */

2471:
2472: /* Set the Manufacturer code with the given organization code */
2473: l_mfg_org_cd := p_org_cd;
2474:
2475: /* Check existence of record in DDR_R_ADVR_YR and get last year details */
2476: Get_Last_Year_Details('PLNG',p_org_cd,l_last_year,l_last_year_start_date,l_last_year_end_date);
2477: IF l_last_year IS NULL /* Last year record does not exist */
2478: THEN
2479: IF p_start_date IS NULL