APPS.DDR_POP_CALENDAR_PKG dependencies on DDR_R_CLNDR_YR

Line 41: IF p_clndr_type = 'CLNDR' THEN l_table_name := 'DDR_R_CLNDR_YR';

37: IS
38: l_SQL_str VARCHAR2(500) := null;
39: l_table_name VARCHAR2(30);
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';

Line 337: from DDR_R_CLNDR_YR

333: RETURN VARCHAR2
334: IS
335: cursor cur_clndr_yr (p_year IN NUMBER) is
336: select 1
337: from DDR_R_CLNDR_YR
338: where YR_NBR = p_year;
339:
340: l_start_year NUMBER;
341: l_end_year NUMBER;

Line 799: /* Check existence of record in DDR_R_CLNDR_YR and get last year details */

795: l_month_no NUMBER;
796: l_week_no NUMBER;
797:
798: BEGIN
799: /* Check existence of record in DDR_R_CLNDR_YR and get last year details */
800: Get_Last_Year_Details('CLNDR',null,l_last_year,l_last_year_start_date,l_last_year_end_date);
801: IF l_last_year IS NULL /* Last year record does not exist */
802: THEN
803: IF p_start_year IS NULL

Line 847: SELECT DDR_R_CLNDR_YR_SEQ.NEXTVAL

843: l_curr_year_start_date := l_curr_year_end_date+1;
844: l_curr_year_end_date := ADD_MONTHS(l_curr_year_start_date,12)-1;
845: l_no_year_days := l_curr_year_end_date - l_curr_year_start_date + 1;
846: -- l_curr_year_id := TO_NUMBER(TO_CHAR(l_curr_year_start_date,g_YR_ID_format));
847: SELECT DDR_R_CLNDR_YR_SEQ.NEXTVAL
848: INTO l_curr_year_id
849: FROM DUAL;
850: l_curr_year_desc := 'CY ' || TO_CHAR(l_curr_year);
851:

Line 852: insert into DDR_R_CLNDR_YR (

848: INTO l_curr_year_id
849: FROM DUAL;
850: l_curr_year_desc := 'CY ' || TO_CHAR(l_curr_year);
851:
852: insert into DDR_R_CLNDR_YR (
853: CLNDR_YR_ID,
854: YR_CD,
855: YR_NBR,
856: YR_DESC,

Line 1228: /* Check existance of record in DDR_R_CLNDR_YR for all relevant years */

1224: /* Populate Quarter and Month array */
1225: Populate_Month_Arrays(l_month_array,l_qtr_array,l_spl_year_array,p_five_week_month_list,p_special_year_list,p_extra_week_month,l_no_of_years,l_last_year_end_date+1);
1226: l_extra_week_month := REPLACE(UPPER(p_extra_week_month),' ','');
1227:
1228: /* Check existance of record in DDR_R_CLNDR_YR for all relevant years */
1229: l_missing_year := Check_Calendar_Year_Exists('BSNS',l_last_year_end_date+1,l_no_of_years,l_spl_year_array.COUNT);
1230: IF l_missing_year IS NOT NULL
1231: THEN
1232: Raise_Error('Standard Calendar to be populated for years (' || l_missing_year || ')');

Line 1669: /* Check existance of record in DDR_R_CLNDR_YR for all relevant years */

1665: END IF;
1666:
1667: l_no_of_years := nvl(p_no_of_years,1);
1668:
1669: /* Check existance of record in DDR_R_CLNDR_YR for all relevant years */
1670: l_missing_year := Check_Calendar_Year_Exists('FSCL',l_last_year_end_date+1,l_no_of_years,null);
1671: IF l_missing_year IS NOT NULL
1672: THEN
1673: Raise_Error('Standard Calendar to be populated for years (' || l_missing_year || ')');

Line 2036: /* Check existance of record in DDR_R_CLNDR_YR for all relevant years */

2032: /* Populate ADVR different arrays like Quarter, Period, Special Year etc. */
2033: Populate_Period_Arrays(l_period_array,l_qtr_array,l_spl_year_array,p_period_dist_list,p_week_dist_list,p_special_year_list,p_extra_week_period,l_no_of_years,l_last_year_end_date+1);
2034: l_extra_week_period := REPLACE(UPPER(p_extra_week_period),' ','');
2035:
2036: /* Check existance of record in DDR_R_CLNDR_YR for all relevant years */
2037: l_missing_year := Check_Calendar_Year_Exists('ADVR',l_last_year_end_date+1,l_no_of_years,l_spl_year_array.COUNT);
2038: IF l_missing_year IS NOT NULL
2039: THEN
2040: Raise_Error('Standard Calendar to be populated for years (' || l_missing_year || ')');

Line 2500: /* Check existance of record in DDR_R_CLNDR_YR for all relevant years */

2496: /* Populate PLNG different arrays like Quarter, Period, Special Year etc. */
2497: Populate_Period_Arrays(l_period_array,l_qtr_array,l_spl_year_array,p_period_dist_list,p_week_dist_list,p_special_year_list,p_extra_week_period,l_no_of_years,l_last_year_end_date+1);
2498: l_extra_week_period := REPLACE(UPPER(p_extra_week_period),' ','');
2499:
2500: /* Check existance of record in DDR_R_CLNDR_YR for all relevant years */
2501: l_missing_year := Check_Calendar_Year_Exists('PLNG',l_last_year_end_date+1,l_no_of_years,l_spl_year_array.COUNT);
2502: IF l_missing_year IS NOT NULL
2503: THEN
2504: Raise_Error('Standard Calendar to be populated for years (' || l_missing_year || ')');