APPS.DDR_POP_CALENDAR_PKG dependencies on DDR_R_CLNDR_WK

Line 102: from DDR_R_CLNDR_WK

98: )
99: IS
100: cursor cur_week is
101: select WK_NBR, WK_STRT_DT, WK_END_DT
102: from DDR_R_CLNDR_WK
103: where WK_NBR = (
104: select max(WK_NBR)
105: from DDR_R_CLNDR_WK
106: );

Line 105: from DDR_R_CLNDR_WK

101: select WK_NBR, WK_STRT_DT, WK_END_DT
102: from DDR_R_CLNDR_WK
103: where WK_NBR = (
104: select max(WK_NBR)
105: from DDR_R_CLNDR_WK
106: );
107: BEGIN
108: OPEN cur_week;
109: FETCH cur_week INTO p_last_week,p_last_week_start_dt,p_last_week_end_dt;

Line 127: from DDR_R_CLNDR_WK

123: )
124: IS
125: cursor cur_week is
126: select CLNDR_WK_ID, WK_CD
127: from DDR_R_CLNDR_WK
128: where p_date between TRUNC(WK_STRT_DT)
129: and TRUNC(WK_END_DT) + .99999;
130: BEGIN
131: OPEN cur_week;

Line 819: /* Check existence of record in DDR_R_CLNDR_WK and get last week details */

815: END IF;
816: -- Bug# 6863276 change end
817: END IF;
818:
819: /* Check existence of record in DDR_R_CLNDR_WK and get last week details */
820: Get_Last_Calendar_Week_Details(l_last_week,l_last_week_start_date,l_last_week_end_date);
821: IF l_last_week IS NULL /* Last week record does not exist */
822: THEN
823: l_last_week_start_date := TRUNC(l_last_year_end_date,'DAY');

Line 1013: SELECT DDR_R_CLNDR_WK_SEQ.NEXTVAL

1009: l_week_no := l_week_no + 1;
1010: l_curr_week_start_date := l_curr_date;
1011: l_curr_week_end_date := l_curr_week_start_date + 7 - 1;
1012: -- l_curr_week_id := TO_NUMBER(TO_CHAR(l_curr_week_start_date,g_WK_ID_format));
1013: SELECT DDR_R_CLNDR_WK_SEQ.NEXTVAL
1014: INTO l_curr_week_id
1015: FROM DUAL;
1016: l_curr_week := TO_NUMBER(TO_CHAR(l_curr_year) || LPAD(TO_CHAR(l_week_no),2,'0'));
1017:

Line 1018: insert into DDR_R_CLNDR_WK (

1014: INTO l_curr_week_id
1015: FROM DUAL;
1016: l_curr_week := TO_NUMBER(TO_CHAR(l_curr_year) || LPAD(TO_CHAR(l_week_no),2,'0'));
1017:
1018: insert into DDR_R_CLNDR_WK (
1019: CLNDR_WK_ID,
1020: WK_CD,
1021: WK_NBR,
1022: WK_DESC,