DBA Data[Home] [Help]

APPS.DDR_POP_CALENDAR_PKG dependencies on DDR_R_WKDAY

Line 216: from DDR_R_WKDAY;

212: PROCEDURE Create_WKDAY_Records
213: IS
214: cursor cur_wkday is
215: select 1
216: from DDR_R_WKDAY;
217:
218: l_dummy NUMBER(1);
219: l_sunday_date DATE;
220: BEGIN

Line 228: insert into DDR_R_WKDAY (

224: THEN
225: l_sunday_date := TRUNC(sysdate,'DAY');
226: FOR day_idx IN 1 .. 7
227: LOOP
228: insert into DDR_R_WKDAY (
229: WKDAY_ID,
230: WKDAY_CD,
231: WKDAY_DESC,
232: SRC_SYS_IDNT,

Line 829: /* Check existance of record in DDR_R_WKDAY. Create records if not alreday exists */

825: END IF;
826:
827: l_no_of_years := nvl(p_no_of_years,1);
828:
829: /* Check existance of record in DDR_R_WKDAY. Create records if not alreday exists */
830: Create_WKDAY_Records;
831:
832: /* Initialize Year and Week Variables for loop operation */
833: l_curr_year := l_last_year;