DBA Data[Home] [Help]

APPS.MSC_CL_GMP_UTILITY dependencies on MSC_ST_CALENDAR_DATES

Line 15672: Populating MSC_ST_CALENDAR_DATES here

15668: week_end := new_rec(old_weekly).cal_date + week_num;
15669:
15670: /*
15671: The PL/sql table thus Populated after exploding the Calendar is useful in
15672: Populating MSC_ST_CALENDAR_DATES here
15673: */
15674: stmt_no := 50;
15675: FOR j IN 1 ..cal_count
15676: LOOP

Line 15706: INSERT INTO msc_st_calendar_dates

15702:
15703: stmt_no := 51;
15704: WHILE ( v_old_cal_date + 1 < new_rec(j).cal_date)
15705: LOOP
15706: INSERT INTO msc_st_calendar_dates
15707: (calendar_date,
15708: calendar_code,
15709: exception_set_id,
15710: seq_num,

Line 15753: INSERT INTO msc_st_calendar_dates

15749: calendar_dates - 02/01/2000
15750: */
15751:
15752: stmt_no := 52;
15753: INSERT INTO msc_st_calendar_dates
15754: (calendar_date,
15755: calendar_code,
15756: exception_set_id,
15757: seq_num,

Line 15855: INSERT INTO msc_st_calendar_dates

15851:
15852: /* Insert for the last record */
15853:
15854: stmt_no := 60;
15855: INSERT INTO msc_st_calendar_dates
15856: ( calendar_date,
15857: calendar_code,
15858: exception_set_id,
15859: seq_num,