APPS.MSC_CL_GMP_UTILITY dependencies on MSC_ST_SHIFT_DATES

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

15262: REM| - dates |
15263: REM| 03/01/00 - Added Code to not to include rows which have |
15264: REM| shift_duration as zero seconds - Bug#1221285 |
15265: REM| 03/20/03 - Added Inserts to msc_st_shift_times table - 2213101 |
15266: REM| 03/20/03 - Added Inserts to msc_st_shift_dates table - 2213101 |
15267: REM| |
15268: REM| |
15269: REM+==========================================================================+
15270: */

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

15928: new_rec(prior_period).cal_date,
15929: 2,
15930: p_INSTANCE_ID);
15931:
15932: /* B2213101 - Code added for Insert into msc_st_shift_dates */
15933: stmt_no := 70;
15934: shift_prior_date := new_rec(1).cal_date;
15935:
15936: FOR h IN 1 ..new_rec.COUNT

Line 15962: INSERT INTO msc_st_shift_dates

15958: END IF;
15959: END IF;
15960:
15961:
15962: INSERT INTO msc_st_shift_dates
15963: ( calendar_code,
15964: exception_set_id,
15965: shift_num,
15966: shift_date,

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

15987: );
15988:
15989: END LOOP;
15990:
15991: /* B2213101 - End of changes for Insert into msc_st_shift_dates */
15992:
15993: END IF ; /* End if for usage */
15994:
15995: return_status := TRUE;