APPS.MSC_DRP_UTIL dependencies on MSC_CALENDAR

Line 190: msc_calendar.get_calendar_code(

186:
187: if p_deliver_calendar is null then
188:
189: p_deliver_calendar :=
190: msc_calendar.get_calendar_code(
191: p_inst_id,
192: null,
193: null,
194: null,

Line 199: 7, --MSC_CALENDAR.VIC,

195: null,
196: 4,
197: null,
198: p_ship_method,
199: 7, --MSC_CALENDAR.VIC,
200: p_associate_type);
201: end if;
202:
203: if p_receive_calendar is null then

Line 205: msc_calendar.get_calendar_code(

201: end if;
202:
203: if p_receive_calendar is null then
204: p_receive_calendar :=
205: msc_calendar.get_calendar_code(
206: p_inst_id,
207: null,
208: null,
209: null,

Line 214: 3, --MSC_CALENDAR.ORC,

210: null,
211: 3,
212: p_to_org,
213: p_ship_method,
214: 3, --MSC_CALENDAR.ORC,
215: p_associate_type);
216: end if;
217:
218: if p_ship_calendar is null then

Line 220: msc_calendar.get_calendar_code(

216: end if;
217:
218: if p_ship_calendar is null then
219: p_ship_calendar :=
220: msc_calendar.get_calendar_code(
221: p_inst_id,
222: null,
223: null,
224: null,

Line 229: 5, --MSC_CALENDAR.OSC,

225: null,
226: 3,
227: p_from_org,
228: p_ship_method,
229: 5, --MSC_CALENDAR.OSC,
230: p_associate_type);
231: end if;
232: -- dbms_output.put_line(p_lead_time||','||p_deliver_calendar||','||p_receive_calendar||','||p_ship_calendar);
233: if p_anchor_date = 'SHIP_DATE' then

Line 300: msc_calendar.get_calendar_code(

296: CLOSE pp_lt_c;
297:
298: if v_receive_calendar is null then
299: v_receive_calendar :=
300: msc_calendar.get_calendar_code(
301: p_inst_id,
302: null,
303: null,
304: null,

Line 309: 3, --MSC_CALENDAR.ORC,

305: null,
306: 3,
307: p_to_org,
308: p_ship_method,
309: 3, --MSC_CALENDAR.ORC,
310: p_association_type);
311: end if;
312:
313: IF p_anchor_date = 'DUE_DATE' then

Line 484: msc_get_name.lookup_meaning('MSC_CALENDAR',a);

480: FOR a in 1..no_of_calendars loop
481: IF substr(p_padded_vl_cal,a,1) <> '0' then
482: if l_out is null then
483: l_out :=
484: msc_get_name.lookup_meaning('MSC_CALENDAR',a);
485: else
486: l_out := l_out ||','||
487: msc_get_name.lookup_meaning('MSC_CALENDAR',a);
488: end if;

Line 487: msc_get_name.lookup_meaning('MSC_CALENDAR',a);

483: l_out :=
484: msc_get_name.lookup_meaning('MSC_CALENDAR',a);
485: else
486: l_out := l_out ||','||
487: msc_get_name.lookup_meaning('MSC_CALENDAR',a);
488: end if;
489: END IF;
490: END LOOP;
491: return l_out;

Line 812: msc_calendar_shifts mcs

808:
809: CURSOR time_c IS
810: select mst.from_time,mst.to_time
811: from msc_shift_times mst,
812: msc_calendar_shifts mcs
813: where mcs.calendar_code = p_calendar_code
814: and mcs.sr_instance_id = p_instance_id
815: and mst.calendar_code = mcs.calendar_code
816: and mst.sr_instance_id = mcs.sr_instance_id

Line 829: p_out_date := msc_calendar.next_work_day(p_calendar_code,

825: return p_calendar_date;
826: end if;
827:
828: if p_next_or_prev = 'NEXT' then
829: p_out_date := msc_calendar.next_work_day(p_calendar_code,
830: p_instance_id,
831: p_calendar_date);
832: else
833: p_out_date := msc_calendar.prev_work_day(p_calendar_code,

Line 833: p_out_date := msc_calendar.prev_work_day(p_calendar_code,

829: p_out_date := msc_calendar.next_work_day(p_calendar_code,
830: p_instance_id,
831: p_calendar_date);
832: else
833: p_out_date := msc_calendar.prev_work_day(p_calendar_code,
834: p_instance_id,
835: p_calendar_date);
836: end if;
837: --dbms_output.put_line('p_out_date after move day='||to_char(p_out_date,'MM-DD-RR HH24:MI')||',move type is '||p_next_or_prev);

Line 918: p_out_date := msc_calendar.date_offset(p_calendar_code,

914: p_out_date := p_valid_hour;
915: else -- have not find the valid hour yet
916: if p_next_or_prev = 'NEXT' then
917: -- move to the earliest shift time of the next working day
918: p_out_date := msc_calendar.date_offset(p_calendar_code,
919: p_instance_id,
920: p_out_date,1,null);
921: p_out_date := trunc(p_out_date) + v_time/(60*60*24);
922: else -- if p_next_or_prev = 'PREV'

Line 924: p_out_date := msc_calendar.date_offset(p_calendar_code,

920: p_out_date,1,null);
921: p_out_date := trunc(p_out_date) + v_time/(60*60*24);
922: else -- if p_next_or_prev = 'PREV'
923: -- move to the latest shift time of the prev working day
924: p_out_date := msc_calendar.date_offset(p_calendar_code,
925: p_instance_id,
926: p_out_date,-1,null);
927: p_out_date := trunc(p_out_date) + v_time/(60*60*24);
928: