39: WEEK, WEEK_DESCRIPTION,
40: WEEK_START_DATE, WEEK_END_DATE,
41: DAY, DAY_DESCRIPTION)
42: select week.instance, 2, week.calendar_code,
43: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, fnd_global.user_id,
44: week.month, week.month_description,
45: week.month_start_date, week.month_end_date,
46: week.week, week.week_description,
47: week.sd, week.ed,
211: l_fiscal_cal_data.MONTH_END_DATE,
212: l_fiscal_cal_data.MONTH_START_DATE + v_num_of_days,
213: l_fiscal_cal_data.MONTH_START_DATE + v_num_of_days,
214: sysdate,
215: FND_GLOBAL.USER_ID ,
216: sysdate,
217: FND_GLOBAL.USER_ID ,
218: FND_GLOBAL.USER_ID
219: ) ;
213: l_fiscal_cal_data.MONTH_START_DATE + v_num_of_days,
214: sysdate,
215: FND_GLOBAL.USER_ID ,
216: sysdate,
217: FND_GLOBAL.USER_ID ,
218: FND_GLOBAL.USER_ID
219: ) ;
220: commit;
221:
214: sysdate,
215: FND_GLOBAL.USER_ID ,
216: sysdate,
217: FND_GLOBAL.USER_ID ,
218: FND_GLOBAL.USER_ID
219: ) ;
220: commit;
221:
222: end loop ;
264: l_fiscal_cal_data.MONTH,
265: l_fiscal_cal_data.MONTH_START_DATE,
266: l_fiscal_cal_data.MONTH_END_DATE,
267: sysdate,
268: FND_GLOBAL.USER_ID ,
269: sysdate,
270: FND_GLOBAL.USER_ID ,
271: FND_GLOBAL.USER_ID
272: ) ;
266: l_fiscal_cal_data.MONTH_END_DATE,
267: sysdate,
268: FND_GLOBAL.USER_ID ,
269: sysdate,
270: FND_GLOBAL.USER_ID ,
271: FND_GLOBAL.USER_ID
272: ) ;
273: commit;
274:
267: sysdate,
268: FND_GLOBAL.USER_ID ,
269: sysdate,
270: FND_GLOBAL.USER_ID ,
271: FND_GLOBAL.USER_ID
272: ) ;
273: commit;
274:
275: end if;