DBA Data[Home] [Help]

APPS.FLM_CREATE_PRODUCT_SYNCH dependencies on MRP_CALENDAR

Line 140: -- l_date := mrp_calendar.prev_work_day(p_org_id,1,trunc(l_date)-1)+l_stop_time/(24*3600);

136: -- If completion time is the same as line start time in the day, then
137: -- the completion time is set to the previous work day at line stop time
138: --fix bug#3170105
139: --if ( l_date = (trunc(l_date)+l_start_time/(24*3600)) ) then
140: -- l_date := mrp_calendar.prev_work_day(p_org_id,1,trunc(l_date)-1)+l_stop_time/(24*3600);
141: --end if;
142: if ( l_date = (flm_timezone.server_to_calendar(l_date)+l_start_time/(24*3600)) ) then
143: l_date := mrp_calendar.prev_work_day(p_org_id,1,
144: flm_timezone.server_to_calendar(l_date)-1)+l_stop_time/(24*3600);

Line 143: l_date := mrp_calendar.prev_work_day(p_org_id,1,

139: --if ( l_date = (trunc(l_date)+l_start_time/(24*3600)) ) then
140: -- l_date := mrp_calendar.prev_work_day(p_org_id,1,trunc(l_date)-1)+l_stop_time/(24*3600);
141: --end if;
142: if ( l_date = (flm_timezone.server_to_calendar(l_date)+l_start_time/(24*3600)) ) then
143: l_date := mrp_calendar.prev_work_day(p_org_id,1,
144: flm_timezone.server_to_calendar(l_date)-1)+l_stop_time/(24*3600);
145: end if;
146: --end of fix bug#3170105
147: