APPS.MSC_DRP_UTIL dependencies on MSC_CALENDAR

Line 191: msc_calendar.get_calendar_code(

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

Line 200: 7, --MSC_CALENDAR.VIC,

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

Line 206: msc_calendar.get_calendar_code(

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

Line 215: 3, --MSC_CALENDAR.ORC,

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

Line 221: msc_calendar.get_calendar_code(

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

Line 230: 5, --MSC_CALENDAR.OSC,

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

Line 303: msc_calendar.get_calendar_code(

299: CLOSE pp_lt_c;
300:
301: if v_receive_calendar is null then
302: v_receive_calendar :=
303: msc_calendar.get_calendar_code(
304: p_inst_id,
305: null,
306: null,
307: null,

Line 312: 3, --MSC_CALENDAR.ORC,

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

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

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

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

487: l_out :=
488: msc_get_name.lookup_meaning('MSC_CALENDAR',a);
489: else
490: l_out := l_out ||','||
491: msc_get_name.lookup_meaning('MSC_CALENDAR',a);
492: end if;
493: END IF;
494: END LOOP;
495: return l_out;

Line 816: msc_calendar_shifts mcs

812:
813: CURSOR time_c IS
814: select mst.from_time,mst.to_time
815: from msc_shift_times mst,
816: msc_calendar_shifts mcs
817: where mcs.calendar_code = p_calendar_code
818: and mcs.sr_instance_id = p_instance_id
819: and mst.calendar_code = mcs.calendar_code
820: and mst.sr_instance_id = mcs.sr_instance_id

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

829: return p_calendar_date;
830: end if;
831:
832: if p_next_or_prev = 'NEXT' then
833: p_out_date := msc_calendar.next_work_day(p_calendar_code,
834: p_instance_id,
835: p_calendar_date);
836: else
837: p_out_date := msc_calendar.prev_work_day(p_calendar_code,

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

833: p_out_date := msc_calendar.next_work_day(p_calendar_code,
834: p_instance_id,
835: p_calendar_date);
836: else
837: p_out_date := msc_calendar.prev_work_day(p_calendar_code,
838: p_instance_id,
839: p_calendar_date);
840: end if;
841: --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 927: p_out_date := msc_calendar.date_offset(p_calendar_code,

923: p_out_date := p_valid_hour;
924: else -- have not find the valid hour yet
925: if p_next_or_prev = 'NEXT' then
926: -- move to the earliest shift time of the next working day
927: p_out_date := msc_calendar.date_offset(p_calendar_code,
928: p_instance_id,
929: p_out_date,1,null);
930: p_out_date := trunc(p_out_date) + v_time/(60*60*24);
931: else -- if p_next_or_prev = 'PREV'

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

929: p_out_date,1,null);
930: p_out_date := trunc(p_out_date) + v_time/(60*60*24);
931: else -- if p_next_or_prev = 'PREV'
932: -- move to the latest shift time of the prev working day
933: p_out_date := msc_calendar.date_offset(p_calendar_code,
934: p_instance_id,
935: p_out_date,-1,null);
936: p_out_date := trunc(p_out_date) + v_time/(60*60*24);
937: