APPS.DDR_POP_CALENDAR_PKG dependencies on DDR_R_BSNS_YR

Line 42: ELSIF p_clndr_type = 'BSNS' THEN l_table_name := 'DDR_R_BSNS_YR';

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

Line 50: FROM DDR_R_BSNS_YR

46: END IF;
47:
48: /*
49: SELECT yr_strt_dt, yr_end_dt
50: FROM DDR_R_BSNS_YR
51: WHERE yr_nbr = (
52: SELECT MAX(yr_nbr)
53: FROM DDR_R_BSNS_YR
54: WHERE clndr_cd = (

Line 53: FROM DDR_R_BSNS_YR

49: SELECT yr_strt_dt, yr_end_dt
50: FROM DDR_R_BSNS_YR
51: WHERE yr_nbr = (
52: SELECT MAX(yr_nbr)
53: FROM DDR_R_BSNS_YR
54: WHERE clndr_cd = (
55: SELECT clndr_cd
56: FROM DDR_R_CLNDR
57: WHERE org_cd = p_org_code

Line 1203: /* Check existence of record in DDR_R_BSNS_YR and get last year details */

1199: THEN
1200: Raise_Error('Manufacturer Organization not yet defined');
1201: END IF;
1202:
1203: /* Check existence of record in DDR_R_BSNS_YR and get last year details */
1204: Get_Last_Year_Details('BSNS',p_org_cd,l_last_year,l_last_year_start_date,l_last_year_end_date);
1205: IF l_last_year IS NULL /* Last year record does not exist */
1206: THEN
1207: IF p_start_date IS NULL

Line 1267: SELECT DDR_R_BSNS_YR_SEQ.NEXTVAL

1263: l_curr_year_start_date := l_curr_year_end_date+1;
1264: l_curr_year_end_date := l_curr_year_start_date + (7*l_no_of_weeks) - 1;
1265: l_no_year_days := l_curr_year_end_date - l_curr_year_start_date + 1;
1266: -- l_curr_year_id := TO_NUMBER(TO_CHAR(l_curr_year_start_date,g_YR_ID_format));
1267: SELECT DDR_R_BSNS_YR_SEQ.NEXTVAL
1268: INTO l_curr_year_id
1269: FROM DUAL;
1270: l_curr_year_desc := 'BY ' || TO_CHAR(l_curr_year);
1271:

Line 1272: insert into DDR_R_BSNS_YR (

1268: INTO l_curr_year_id
1269: FROM DUAL;
1270: l_curr_year_desc := 'BY ' || TO_CHAR(l_curr_year);
1271:
1272: insert into DDR_R_BSNS_YR (
1273: BSNS_YR_ID,
1274: MFG_ORG_CD,
1275: CLNDR_CD,
1276: YR_CD,