DBA Data[Home] [Help]

APPS.MSC_CL_GMP_UTILITY dependencies on MSC_ST_CALENDAR_DATES

Line 14837: Populating MSC_ST_CALENDAR_DATES here

14833: week_end := new_rec(old_weekly).cal_date + week_num;
14834:
14835: /*
14836: The PL/sql table thus Populated after exploding the Calendar is useful in
14837: Populating MSC_ST_CALENDAR_DATES here
14838: */
14839: stmt_no := 50;
14840: FOR j IN 1 ..cal_count
14841: LOOP

Line 14871: INSERT INTO msc_st_calendar_dates

14867:
14868: stmt_no := 51;
14869: WHILE ( v_old_cal_date + 1 < new_rec(j).cal_date)
14870: LOOP
14871: INSERT INTO msc_st_calendar_dates
14872: (calendar_date,
14873: calendar_code,
14874: exception_set_id,
14875: seq_num,

Line 14918: INSERT INTO msc_st_calendar_dates

14914: calendar_dates - 02/01/2000
14915: */
14916:
14917: stmt_no := 52;
14918: INSERT INTO msc_st_calendar_dates
14919: (calendar_date,
14920: calendar_code,
14921: exception_set_id,
14922: seq_num,

Line 15020: INSERT INTO msc_st_calendar_dates

15016:
15017: /* Insert for the last record */
15018:
15019: stmt_no := 60;
15020: INSERT INTO msc_st_calendar_dates
15021: ( calendar_date,
15022: calendar_code,
15023: exception_set_id,
15024: seq_num,