eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_SUPPLY_ODS_LOAD dependencies on MSC_CALENDAR

Line 254: nvl(MSC_CALENDAR.DATE_OFFSET(x.ORGANIZATION_ID,

250: x.REVISION,
251: x.UNIT_NUMBER,
252: -- bug 2773881 - Use either PROMISED_DATE or NEED_BY_DATE; always call date_offset
253: /*decode(x.ORDER_TYPE, 1,
254: nvl(MSC_CALENDAR.DATE_OFFSET(x.ORGANIZATION_ID,
255: x.SR_INSTANCE_ID,
256: TYPE_DAILY_BUCKET,
257: (MSC_CALENDAR.NEXT_WORK_DAY
258: (x.ORGANIZATION_ID,

Line 257: (MSC_CALENDAR.NEXT_WORK_DAY

253: /*decode(x.ORDER_TYPE, 1,
254: nvl(MSC_CALENDAR.DATE_OFFSET(x.ORGANIZATION_ID,
255: x.SR_INSTANCE_ID,
256: TYPE_DAILY_BUCKET,
257: (MSC_CALENDAR.NEXT_WORK_DAY
258: (x.ORGANIZATION_ID,
259: x.SR_INSTANCE_ID,
260: 1,
261: decode(lv_po_dock_date_ref,

Line 271: NEED_BY_DATE_PREF, MSC_CALENDAR.DATE_OFFSET(x.ORGANIZATION_ID,

267: /*
268: decode(x.ORDER_TYPE, 1,
269: decode(lv_po_dock_date_ref,
270: PROMISED_DATE_PREF , x.NEW_SCHEDULE_DATE,
271: NEED_BY_DATE_PREF, MSC_CALENDAR.DATE_OFFSET(x.ORGANIZATION_ID,
272: x.SR_INSTANCE_ID,
273: TYPE_DAILY_BUCKET,
274: (MSC_CALENDAR.NEXT_WORK_DAY
275: (x.ORGANIZATION_ID,

Line 274: (MSC_CALENDAR.NEXT_WORK_DAY

270: PROMISED_DATE_PREF , x.NEW_SCHEDULE_DATE,
271: NEED_BY_DATE_PREF, MSC_CALENDAR.DATE_OFFSET(x.ORGANIZATION_ID,
272: x.SR_INSTANCE_ID,
273: TYPE_DAILY_BUCKET,
274: (MSC_CALENDAR.NEXT_WORK_DAY
275: (x.ORGANIZATION_ID,
276: x.SR_INSTANCE_ID,
277: 1,
278: nvl(x.NEED_BY_DATE,x.promised_date))),

Line 1117: lv_cal_code:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.ORC);

1113: IF(lv_org_id <> c_rec.ORGANIZATION_ID or lv_org_id=0) THEN
1114:
1115: --GET_CALENDAR_CODE to be called only once for the same org
1116:
1117: lv_cal_code:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.ORC);
1118:
1119: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.OMC);
1120:
1121: lv_org_id:=c_rec.ORGANIZATION_ID;

Line 1119: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.OMC);

1115: --GET_CALENDAR_CODE to be called only once for the same org
1116:
1117: lv_cal_code:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.ORC);
1118:
1119: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.OMC);
1120:
1121: lv_org_id:=c_rec.ORGANIZATION_ID;
1122:
1123: END IF;

Line 1127: lv_dock_date :=MSC_CALENDAR.NEXT_WORK_DAY(lv_cal_code,c_rec.SR_INSTANCE_ID,c_rec.NEW_DOCK_DATE);

1123: END IF;
1124:
1125: --finding the dock date by validating it from Org Rec. Calendar
1126: lv_time_component:= c_rec.NEW_DOCK_DATE - trunc(c_rec.NEW_DOCK_DATE);
1127: lv_dock_date :=MSC_CALENDAR.NEXT_WORK_DAY(lv_cal_code,c_rec.SR_INSTANCE_ID,c_rec.NEW_DOCK_DATE);
1128: lv_dock_date:= lv_dock_date + lv_time_component;
1129: ELSE
1130: IF c_rec.ORDER_TYPE=11 THEN
1131:

Line 1135: lv_cal_code:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.ORC);

1131:
1132: IF(lv_org_id <> c_rec.ORGANIZATION_ID or lv_org_id=0) THEN
1133: --GET_CALENDAR_CODE to be called only once for the same org
1134:
1135: lv_cal_code:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.ORC);
1136:
1137: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.OMC);
1138:
1139: lv_org_id:=c_rec.ORGANIZATION_ID;

Line 1137: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.OMC);

1133: --GET_CALENDAR_CODE to be called only once for the same org
1134:
1135: lv_cal_code:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.ORC);
1136:
1137: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.OMC);
1138:
1139: lv_org_id:=c_rec.ORGANIZATION_ID;
1140:
1141: END IF;

Line 1145: lv_schedule_date :=MSC_CALENDAR.DATE_OFFSET(lv_cal_code_omc,c_rec.SR_INSTANCE_ID,c_rec.NEW_SCHEDULE_DATE,nvl(c_rec.POSTPROCESSING_LEAD_TIME,0),1);

1141: END IF;
1142: if (c_rec.NEW_SCHEDULE_DATE is not null ) then
1143: lv_time_component:= c_rec.NEW_SCHEDULE_DATE - trunc(c_rec.NEW_SCHEDULE_DATE);
1144: END IF ;
1145: lv_schedule_date :=MSC_CALENDAR.DATE_OFFSET(lv_cal_code_omc,c_rec.SR_INSTANCE_ID,c_rec.NEW_SCHEDULE_DATE,nvl(c_rec.POSTPROCESSING_LEAD_TIME,0),1);
1146: if (c_rec.NEW_SCHEDULE_DATE is not null ) then
1147: lv_schedule_date := lv_schedule_date + lv_time_component;
1148: END IF ;
1149:

Line 1161: lv_schedule_date :=MSC_CALENDAR.DATE_OFFSET(lv_cal_code_omc,c_rec.SR_INSTANCE_ID,lv_dock_date,nvl(c_rec.POSTPROCESSING_LEAD_TIME,0),1);

1157:
1158: --offsetting the dock date to find the schedule date using OMC
1159: IF (lv_dock_date is not null ) then
1160: lv_time_component:= lv_dock_date - trunc(lv_dock_date);
1161: lv_schedule_date :=MSC_CALENDAR.DATE_OFFSET(lv_cal_code_omc,c_rec.SR_INSTANCE_ID,lv_dock_date,nvl(c_rec.POSTPROCESSING_LEAD_TIME,0),1);
1162: lv_schedule_date:= lv_schedule_date + lv_time_component;
1163: ELSE
1164: lv_schedule_date :=c_rec.NEW_SCHEDULE_DATE;
1165: END IF ;

Line 1177: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.OMC);

1173: /* bug 5937871 */
1174: IF MSC_UTIL.g_collect_srp_data = 'Y' THEN
1175: IF c_rec.ORDER_TYPE=75 THEN
1176: if (c_rec.NEW_SCHEDULE_DATE is null ) then
1177: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.OMC);
1178: lv_schedule_date :=MSC_CALENDAR.DATE_OFFSET(lv_cal_code_omc,c_rec.SR_INSTANCE_ID,c_rec.RO_CREATION_DATE,nvl(c_rec.REPAIR_LEAD_TIME,0),1);
1179: END IF ;
1180: END IF ;
1181: END IF ;

Line 1178: lv_schedule_date :=MSC_CALENDAR.DATE_OFFSET(lv_cal_code_omc,c_rec.SR_INSTANCE_ID,c_rec.RO_CREATION_DATE,nvl(c_rec.REPAIR_LEAD_TIME,0),1);

1174: IF MSC_UTIL.g_collect_srp_data = 'Y' THEN
1175: IF c_rec.ORDER_TYPE=75 THEN
1176: if (c_rec.NEW_SCHEDULE_DATE is null ) then
1177: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.OMC);
1178: lv_schedule_date :=MSC_CALENDAR.DATE_OFFSET(lv_cal_code_omc,c_rec.SR_INSTANCE_ID,c_rec.RO_CREATION_DATE,nvl(c_rec.REPAIR_LEAD_TIME,0),1);
1179: END IF ;
1180: END IF ;
1181: END IF ;
1182: /* end bug 5937871*/

Line 2437: MSC_CL_COLLECTION.NEED_BY_DATE_PREF, MSC_CALENDAR.DATE_OFFSET(x.ORGANIZATION_ID,

2433: x.UNIT_NUMBER,
2434: /* decode(x.ORDER_TYPE, 1,
2435: decode(lv_po_dock_date_ref,
2436: PROMISED_DATE_PREF , x.NEW_SCHEDULE_DATE,
2437: MSC_CL_COLLECTION.NEED_BY_DATE_PREF, MSC_CALENDAR.DATE_OFFSET(x.ORGANIZATION_ID,
2438: x.SR_INSTANCE_ID,
2439: TYPE_DAILY_BUCKET,
2440: (MSC_CALENDAR.NEXT_WORK_DAY
2441: (x.ORGANIZATION_ID,

Line 2440: (MSC_CALENDAR.NEXT_WORK_DAY

2436: PROMISED_DATE_PREF , x.NEW_SCHEDULE_DATE,
2437: MSC_CL_COLLECTION.NEED_BY_DATE_PREF, MSC_CALENDAR.DATE_OFFSET(x.ORGANIZATION_ID,
2438: x.SR_INSTANCE_ID,
2439: TYPE_DAILY_BUCKET,
2440: (MSC_CALENDAR.NEXT_WORK_DAY
2441: (x.ORGANIZATION_ID,
2442: x.SR_INSTANCE_ID,
2443: 1,
2444: nvl(x.NEED_BY_DATE,x.promised_date))),

Line 2948: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'debug2 orc='||to_char(MSC_CALENDAR.ORC));

2944: --GET_CALENDAR_CODE to be called only once for the same org
2945:
2946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'debug2 c_rec.SR_INSTANCE_ID='||to_char(c_rec.SR_INSTANCE_ID));
2947: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'debug2 org_id='||to_char(c_rec.ORGANIZATION_ID));
2948: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'debug2 orc='||to_char(MSC_CALENDAR.ORC));
2949: lv_cal_code:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.ORC);
2950:
2951: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.OMC);
2952:

Line 2949: lv_cal_code:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.ORC);

2945:
2946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'debug2 c_rec.SR_INSTANCE_ID='||to_char(c_rec.SR_INSTANCE_ID));
2947: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'debug2 org_id='||to_char(c_rec.ORGANIZATION_ID));
2948: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'debug2 orc='||to_char(MSC_CALENDAR.ORC));
2949: lv_cal_code:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.ORC);
2950:
2951: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.OMC);
2952:
2953: lv_org_id:=c_rec.ORGANIZATION_ID;

Line 2951: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.OMC);

2947: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'debug2 org_id='||to_char(c_rec.ORGANIZATION_ID));
2948: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'debug2 orc='||to_char(MSC_CALENDAR.ORC));
2949: lv_cal_code:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.ORC);
2950:
2951: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.OMC);
2952:
2953: lv_org_id:=c_rec.ORGANIZATION_ID;
2954:
2955: END IF;

Line 2959: lv_dock_date :=MSC_CALENDAR.NEXT_WORK_DAY(lv_cal_code,c_rec.SR_INSTANCE_ID,c_rec.NEW_DOCK_DATE);

2955: END IF;
2956:
2957: --finding the dock date by validating it from Org Rec. Calendar
2958: lv_time_component := c_rec.NEW_DOCK_DATE - trunc(c_rec.NEW_DOCK_DATE);
2959: lv_dock_date :=MSC_CALENDAR.NEXT_WORK_DAY(lv_cal_code,c_rec.SR_INSTANCE_ID,c_rec.NEW_DOCK_DATE);
2960: lv_dock_date := lv_dock_date + lv_time_component;
2961: ELSE
2962: IF c_rec.ORDER_TYPE=11 THEN
2963:

Line 2967: lv_cal_code:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.ORC);

2963:
2964: IF(lv_org_id <> c_rec.ORGANIZATION_ID or lv_org_id=0) THEN
2965: --GET_CALENDAR_CODE to be called only once for the same org
2966:
2967: lv_cal_code:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.ORC);
2968:
2969: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.OMC);
2970:
2971: lv_org_id:=c_rec.ORGANIZATION_ID;

Line 2969: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.OMC);

2965: --GET_CALENDAR_CODE to be called only once for the same org
2966:
2967: lv_cal_code:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.ORC);
2968:
2969: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.OMC);
2970:
2971: lv_org_id:=c_rec.ORGANIZATION_ID;
2972:
2973: END IF;

Line 2978: lv_schedule_date :=MSC_CALENDAR.DATE_OFFSET(lv_cal_code_omc,c_rec.SR_INSTANCE_ID,c_rec.NEW_SCHEDULE_DATE,nvl(c_rec.POSTPROCESSING_LEAD_TIME,0),1);

2974: if (c_rec.NEW_SCHEDULE_DATE is not null ) then
2975: lv_time_component := c_rec.NEW_SCHEDULE_DATE - trunc(c_rec.NEW_SCHEDULE_DATE);
2976: END IF ;
2977:
2978: lv_schedule_date :=MSC_CALENDAR.DATE_OFFSET(lv_cal_code_omc,c_rec.SR_INSTANCE_ID,c_rec.NEW_SCHEDULE_DATE,nvl(c_rec.POSTPROCESSING_LEAD_TIME,0),1);
2979:
2980: if (c_rec.NEW_SCHEDULE_DATE is not null ) then
2981: lv_schedule_date := lv_schedule_date + lv_time_component ;
2982: END IF ;

Line 2996: lv_schedule_date :=MSC_CALENDAR.DATE_OFFSET(lv_cal_code_omc,c_rec.SR_INSTANCE_ID,lv_dock_date,nvl(c_rec.POSTPROCESSING_LEAD_TIME,0),1);

2992:
2993: --offsetting the dock date to find the schedule date
2994: If ( lv_dock_date is not null) then
2995: lv_time_component := lv_dock_date - trunc(lv_dock_date);
2996: lv_schedule_date :=MSC_CALENDAR.DATE_OFFSET(lv_cal_code_omc,c_rec.SR_INSTANCE_ID,lv_dock_date,nvl(c_rec.POSTPROCESSING_LEAD_TIME,0),1);
2997: lv_schedule_date := lv_schedule_date + lv_time_component;
2998: ELSE
2999: lv_schedule_date :=c_rec.NEW_SCHEDULE_DATE;
3000: END IF ;

Line 3014: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.OMC);

3010: /* bug 5937871 */
3011: IF MSC_UTIL.g_collect_srp_data = 'Y' THEN
3012: IF c_rec.ORDER_TYPE=75 THEN
3013: if (c_rec.NEW_SCHEDULE_DATE is null ) then
3014: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.OMC);
3015: lv_schedule_date :=MSC_CALENDAR.DATE_OFFSET(lv_cal_code_omc,c_rec.SR_INSTANCE_ID,c_rec.RO_CREATION_DATE,nvl(c_rec.REPAIR_LEAD_TIME,0),1);
3016: END IF ;
3017: END IF ;
3018: END IF ;

Line 3015: lv_schedule_date :=MSC_CALENDAR.DATE_OFFSET(lv_cal_code_omc,c_rec.SR_INSTANCE_ID,c_rec.RO_CREATION_DATE,nvl(c_rec.REPAIR_LEAD_TIME,0),1);

3011: IF MSC_UTIL.g_collect_srp_data = 'Y' THEN
3012: IF c_rec.ORDER_TYPE=75 THEN
3013: if (c_rec.NEW_SCHEDULE_DATE is null ) then
3014: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(c_rec.SR_INSTANCE_ID, null, null, null, null, null, c_rec.ORGANIZATION_ID, null, MSC_CALENDAR.OMC);
3015: lv_schedule_date :=MSC_CALENDAR.DATE_OFFSET(lv_cal_code_omc,c_rec.SR_INSTANCE_ID,c_rec.RO_CREATION_DATE,nvl(c_rec.REPAIR_LEAD_TIME,0),1);
3016: END IF ;
3017: END IF ;
3018: END IF ;
3019: /* end bug 5937871*/

Line 3355: || MSC_CL_COLLECTION.NEED_BY_DATE_PREF ||', MSC_CALENDAR.DATE_OFFSET(x.ORGANIZATION_ID,'

3351: || ' x.UNIT_NUMBER,'
3352: /*|| ' decode(x.ORDER_TYPE, 1,'
3353: || ' decode( '||lv_po_dock_date_ref|| ' ,'
3354: || PROMISED_DATE_PREF ||', x.NEW_SCHEDULE_DATE,'
3355: || MSC_CL_COLLECTION.NEED_BY_DATE_PREF ||', MSC_CALENDAR.DATE_OFFSET(x.ORGANIZATION_ID,'
3356: || ' x.SR_INSTANCE_ID,'
3357: || TYPE_DAILY_BUCKET ||' ,'
3358: || ' (MSC_CALENDAR.NEXT_WORK_DAY'
3359: || ' (x.ORGANIZATION_ID,'

Line 3358: || ' (MSC_CALENDAR.NEXT_WORK_DAY'

3354: || PROMISED_DATE_PREF ||', x.NEW_SCHEDULE_DATE,'
3355: || MSC_CL_COLLECTION.NEED_BY_DATE_PREF ||', MSC_CALENDAR.DATE_OFFSET(x.ORGANIZATION_ID,'
3356: || ' x.SR_INSTANCE_ID,'
3357: || TYPE_DAILY_BUCKET ||' ,'
3358: || ' (MSC_CALENDAR.NEXT_WORK_DAY'
3359: || ' (x.ORGANIZATION_ID,'
3360: || ' x.SR_INSTANCE_ID,'
3361: || ' 1,'
3362: || ' nvl(x.NEED_BY_DATE,x.promised_date))),'

Line 3739: lv_cal_code:=msc_calendar.GET_CALENDAR_CODE(lv_SR_INSTANCE_ID, null, null, null, null, null, lv_ORGANIZATION_ID, null, MSC_CALENDAR.ORC);

3735: IF(lv_org_id <> lv_ORGANIZATION_ID or lv_org_id=0) THEN
3736:
3737: --GET_CALENDAR_CODE to be called only once for the same org
3738:
3739: lv_cal_code:=msc_calendar.GET_CALENDAR_CODE(lv_SR_INSTANCE_ID, null, null, null, null, null, lv_ORGANIZATION_ID, null, MSC_CALENDAR.ORC);
3740:
3741: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(lv_SR_INSTANCE_ID, null, null, null, null, null, lv_ORGANIZATION_ID, null, MSC_CALENDAR.OMC);
3742:
3743: lv_org_id:=lv_ORGANIZATION_ID;

Line 3741: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(lv_SR_INSTANCE_ID, null, null, null, null, null, lv_ORGANIZATION_ID, null, MSC_CALENDAR.OMC);

3737: --GET_CALENDAR_CODE to be called only once for the same org
3738:
3739: lv_cal_code:=msc_calendar.GET_CALENDAR_CODE(lv_SR_INSTANCE_ID, null, null, null, null, null, lv_ORGANIZATION_ID, null, MSC_CALENDAR.ORC);
3740:
3741: lv_cal_code_omc:=msc_calendar.GET_CALENDAR_CODE(lv_SR_INSTANCE_ID, null, null, null, null, null, lv_ORGANIZATION_ID, null, MSC_CALENDAR.OMC);
3742:
3743: lv_org_id:=lv_ORGANIZATION_ID;
3744:
3745: END IF;

Line 3749: lv_NEW_DOCK_DATE :=MSC_CALENDAR.NEXT_WORK_DAY(lv_cal_code,lv_SR_INSTANCE_ID,lv_NEW_DOCK_DATE);

3745: END IF;
3746:
3747: --finding the dock date by validating it from Org Rec. Calendar
3748: lv_time_component:= lv_NEW_DOCK_DATE- trunc(lv_NEW_DOCK_DATE);
3749: lv_NEW_DOCK_DATE :=MSC_CALENDAR.NEXT_WORK_DAY(lv_cal_code,lv_SR_INSTANCE_ID,lv_NEW_DOCK_DATE);
3750: lv_NEW_DOCK_DATE := lv_NEW_DOCK_DATE + lv_time_component;
3751: ELSE
3752: lv_NEW_DOCK_DATE :=null;
3753:

Line 3763: lv_NEW_SCHEDULE_DATE :=MSC_CALENDAR.DATE_OFFSET(lv_cal_code_omc,lv_SR_INSTANCE_ID,lv_NEW_DOCK_DATE,nvl(lv_POSTPROCESSING_LEAD_TIME,0),1);

3759: --offsetting the dock date to find the schedule date
3760: If ( lv_NEW_DOCK_DATE is not null) then
3761: lv_time_component := lv_NEW_DOCK_DATE - trunc(lv_NEW_DOCK_DATE);
3762: END IF ;
3763: lv_NEW_SCHEDULE_DATE :=MSC_CALENDAR.DATE_OFFSET(lv_cal_code_omc,lv_SR_INSTANCE_ID,lv_NEW_DOCK_DATE,nvl(lv_POSTPROCESSING_LEAD_TIME,0),1);
3764:
3765: If ( lv_NEW_DOCK_DATE is not null) then
3766: lv_NEW_SCHEDULE_DATE := lv_NEW_SCHEDULE_DATE +lv_time_component ;
3767: END IF ;