APPS.MSC_CL_GMP_UTILITY dependencies on MSC_ST_SHIFT_DATES

Line 14438: REM| 03/20/03 - Added Inserts to msc_st_shift_dates table - 2213101 |

14434: REM| - dates |
14435: REM| 03/01/00 - Added Code to not to include rows which have |
14436: REM| shift_duration as zero seconds - Bug#1221285 |
14437: REM| 03/20/03 - Added Inserts to msc_st_shift_times table - 2213101 |
14438: REM| 03/20/03 - Added Inserts to msc_st_shift_dates table - 2213101 |
14439: REM| |
14440: REM| |
14441: REM+==========================================================================+
14442: */

Line 15097: /* B2213101 - Code added for Insert into msc_st_shift_dates */

15093: new_rec(prior_period).cal_date,
15094: 2,
15095: p_INSTANCE_ID);
15096:
15097: /* B2213101 - Code added for Insert into msc_st_shift_dates */
15098: stmt_no := 70;
15099: shift_prior_date := new_rec(1).cal_date;
15100:
15101: FOR h IN 1 ..new_rec.COUNT

Line 15127: INSERT INTO msc_st_shift_dates

15123: END IF;
15124: END IF;
15125:
15126:
15127: INSERT INTO msc_st_shift_dates
15128: ( calendar_code,
15129: exception_set_id,
15130: shift_num,
15131: shift_date,

Line 15156: /* B2213101 - End of changes for Insert into msc_st_shift_dates */

15152: );
15153:
15154: END LOOP;
15155:
15156: /* B2213101 - End of changes for Insert into msc_st_shift_dates */
15157:
15158: END IF ; /* End if for usage */
15159:
15160: return_status := TRUE;