APPS.DDR_POP_CALENDAR_PKG dependencies on DDR_R_FSCL_YR

Line 43: ELSIF p_clndr_type = 'FSCL' THEN l_table_name := 'DDR_R_FSCL_YR';

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';
46: END IF;
47:

Line 1648: /* Check existence of record in DDR_R_FSCL_YR and get last year details */

1644:
1645: /* Set the Manufacturer code with the given organization code */
1646: l_mfg_org_cd := p_org_cd;
1647:
1648: /* Check existence of record in DDR_R_FSCL_YR and get last year details */
1649: Get_Last_Year_Details('FSCL',p_org_cd,l_last_year,l_last_year_start_date,l_last_year_end_date);
1650: IF l_last_year IS NULL /* Last year record does not exist */
1651: THEN
1652: IF p_start_year_month IS NULL

Line 1698: SELECT DDR_R_FSCL_YR_SEQ.NEXTVAL

1694: l_curr_year_start_date := l_curr_year_end_date+1;
1695: l_curr_year_end_date := ADD_MONTHS(l_curr_year_start_date,12)-1;
1696: l_no_year_days := l_curr_year_end_date - l_curr_year_start_date + 1;
1697: -- l_curr_year_id := TO_NUMBER(TO_CHAR(l_curr_year_start_date,g_YR_ID_format));
1698: SELECT DDR_R_FSCL_YR_SEQ.NEXTVAL
1699: INTO l_curr_year_id
1700: FROM DUAL;
1701: l_curr_year_desc := 'FY ' || TO_CHAR(l_curr_year);
1702:

Line 1703: insert into DDR_R_FSCL_YR (

1699: INTO l_curr_year_id
1700: FROM DUAL;
1701: l_curr_year_desc := 'FY ' || TO_CHAR(l_curr_year);
1702:
1703: insert into DDR_R_FSCL_YR (
1704: FSCL_YR_ID,
1705: MFG_ORG_CD,
1706: CLNDR_CD,
1707: YR_CD,