APPS.MSD_LIABILITY dependencies on MSD_TIME

Line 600: from msd_time

596:
597: x_no_of_days := trunc( x_plan_end_date,'DD') - trunc( x_plan_start_date, 'DD') ;
598:
599: Select count(*) into x_cal_no_of_days
600: from msd_time
601: where calendar_type = 1 and day between
602: x_plan_start_date and x_plan_end_date
603: ;
604:

Line 609: delete from msd_time where calendar_type = 1 and trunc( day, 'DD') between trunc( x_plan_start_date, 'DD') and trunc( x_plan_end_date , 'DD') ;

605: If x_no_of_days + 1 <> x_cal_no_of_days
606: Then
607: display_message( 'Generating Gergorian Calendar ' , INFORMATION);
608: display_message( 'Deleteing Gergorian Calendar between '||x_plan_start_date||'---'||x_plan_end_date , DEBUG);
609: delete from msd_time where calendar_type = 1 and trunc( day, 'DD') between trunc( x_plan_start_date, 'DD') and trunc( x_plan_end_date , 'DD') ;
610:
611: display_message( 'Generating Gergorian Calendar between '||x_plan_start_date||'---'||x_plan_end_date , DEBUG);
612: MSD_TRANSLATE_TIME_DATA.Generate_Gregorian( errbuf,
613: retcode,

Line 747: FROM msd_time_lb_v dp

743: /* This cursor returns the start date and end date of a given calendar */
744: CURSOR get_tim(p_calendar_type VARCHAR2, p_calendar_code VARCHAR2,
745: p_start_date DATE, p_end_date DATE) IS
746: SELECT MIN(day) min_date, MAX(day) max_date
747: FROM msd_time_lb_v dp
748: WHERE dp.calendar_type = p_calendar_type
749: AND dp.calendar_code = p_calendar_code ;
750: --AND day between p_start_date and p_end_date;
751:

Line 2328: delete from msd_time_lb where CALENDAR_CODE in

2324: IS
2325:
2326: BEGIN
2327:
2328: delete from msd_time_lb where CALENDAR_CODE in
2329: ( select CALENDAR_CODE from msd_dp_calendars where demand_plan_id = p_demand_plan_id)
2330: ;
2331:
2332: commit ;

Line 2334: insert into msd_time_lb (

2330: ;
2331:
2332: commit ;
2333:
2334: insert into msd_time_lb (
2335: CALENDAR_TYPE,
2336: CALENDAR_CODE,
2337: SEQ_NUM,
2338: YEAR,