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 1063: 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);

1059: IF(lv_org_id <> c_rec.ORGANIZATION_ID or lv_org_id=0) THEN
1060:
1061: --GET_CALENDAR_CODE to be called only once for the same org
1062:
1063: 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);
1064:
1065: 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);
1066:
1067: lv_org_id:=c_rec.ORGANIZATION_ID;

Line 1065: 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);

1061: --GET_CALENDAR_CODE to be called only once for the same org
1062:
1063: 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);
1064:
1065: 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);
1066:
1067: lv_org_id:=c_rec.ORGANIZATION_ID;
1068:
1069: END IF;

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

1069: END IF;
1070:
1071: --finding the dock date by validating it from Org Rec. Calendar
1072: lv_time_component:= c_rec.NEW_DOCK_DATE - trunc(c_rec.NEW_DOCK_DATE);
1073: lv_dock_date :=MSC_CALENDAR.NEXT_WORK_DAY(lv_cal_code,c_rec.SR_INSTANCE_ID,c_rec.NEW_DOCK_DATE);
1074: lv_dock_date:= lv_dock_date + lv_time_component;
1075: ELSE
1076: IF c_rec.ORDER_TYPE=11 THEN
1077:

Line 1081: 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);

1077:
1078: IF(lv_org_id <> c_rec.ORGANIZATION_ID or lv_org_id=0) THEN
1079: --GET_CALENDAR_CODE to be called only once for the same org
1080:
1081: 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);
1082:
1083: 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);
1084:
1085: lv_org_id:=c_rec.ORGANIZATION_ID;

Line 1083: 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);

1079: --GET_CALENDAR_CODE to be called only once for the same org
1080:
1081: 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);
1082:
1083: 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);
1084:
1085: lv_org_id:=c_rec.ORGANIZATION_ID;
1086:
1087: END IF;

Line 1091: 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);

1087: END IF;
1088: if (c_rec.NEW_SCHEDULE_DATE is not null ) then
1089: lv_time_component:= c_rec.NEW_SCHEDULE_DATE - trunc(c_rec.NEW_SCHEDULE_DATE);
1090: END IF ;
1091: 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);
1092: if (c_rec.NEW_SCHEDULE_DATE is not null ) then
1093: lv_schedule_date := lv_schedule_date + lv_time_component;
1094: END IF ;
1095:

Line 1107: 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);

1103:
1104: --offsetting the dock date to find the schedule date using OMC
1105: IF (lv_dock_date is not null ) then
1106: lv_time_component:= lv_dock_date - trunc(lv_dock_date);
1107: 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);
1108: lv_schedule_date:= lv_schedule_date + lv_time_component;
1109: ELSE
1110: lv_schedule_date :=c_rec.NEW_SCHEDULE_DATE;
1111: END IF ;

Line 1123: 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);

1119: /* bug 5937871 */
1120: IF MSC_UTIL.g_collect_srp_data = 'Y' THEN
1121: IF c_rec.ORDER_TYPE=75 THEN
1122: if (c_rec.NEW_SCHEDULE_DATE is null ) then
1123: 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);
1124: 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);
1125: END IF ;
1126: END IF ;
1127: END IF ;

Line 1124: 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);

1120: IF MSC_UTIL.g_collect_srp_data = 'Y' THEN
1121: IF c_rec.ORDER_TYPE=75 THEN
1122: if (c_rec.NEW_SCHEDULE_DATE is null ) then
1123: 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);
1124: 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);
1125: END IF ;
1126: END IF ;
1127: END IF ;
1128: /* end bug 5937871*/

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

2317: x.UNIT_NUMBER,
2318: /* decode(x.ORDER_TYPE, 1,
2319: decode(lv_po_dock_date_ref,
2320: PROMISED_DATE_PREF , x.NEW_SCHEDULE_DATE,
2321: MSC_CL_COLLECTION.NEED_BY_DATE_PREF, MSC_CALENDAR.DATE_OFFSET(x.ORGANIZATION_ID,
2322: x.SR_INSTANCE_ID,
2323: TYPE_DAILY_BUCKET,
2324: (MSC_CALENDAR.NEXT_WORK_DAY
2325: (x.ORGANIZATION_ID,

Line 2324: (MSC_CALENDAR.NEXT_WORK_DAY

2320: PROMISED_DATE_PREF , x.NEW_SCHEDULE_DATE,
2321: MSC_CL_COLLECTION.NEED_BY_DATE_PREF, MSC_CALENDAR.DATE_OFFSET(x.ORGANIZATION_ID,
2322: x.SR_INSTANCE_ID,
2323: TYPE_DAILY_BUCKET,
2324: (MSC_CALENDAR.NEXT_WORK_DAY
2325: (x.ORGANIZATION_ID,
2326: x.SR_INSTANCE_ID,
2327: 1,
2328: nvl(x.NEED_BY_DATE,x.promised_date))),

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

2793: --GET_CALENDAR_CODE to be called only once for the same org
2794:
2795: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'debug2 c_rec.SR_INSTANCE_ID='||to_char(c_rec.SR_INSTANCE_ID));
2796: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'debug2 org_id='||to_char(c_rec.ORGANIZATION_ID));
2797: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'debug2 orc='||to_char(MSC_CALENDAR.ORC));
2798: 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);
2799:
2800: 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);
2801:

Line 2798: 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);

2794:
2795: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'debug2 c_rec.SR_INSTANCE_ID='||to_char(c_rec.SR_INSTANCE_ID));
2796: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'debug2 org_id='||to_char(c_rec.ORGANIZATION_ID));
2797: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'debug2 orc='||to_char(MSC_CALENDAR.ORC));
2798: 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);
2799:
2800: 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);
2801:
2802: lv_org_id:=c_rec.ORGANIZATION_ID;

Line 2800: 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);

2796: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'debug2 org_id='||to_char(c_rec.ORGANIZATION_ID));
2797: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'debug2 orc='||to_char(MSC_CALENDAR.ORC));
2798: 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);
2799:
2800: 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);
2801:
2802: lv_org_id:=c_rec.ORGANIZATION_ID;
2803:
2804: END IF;

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

2804: END IF;
2805:
2806: --finding the dock date by validating it from Org Rec. Calendar
2807: lv_time_component := c_rec.NEW_DOCK_DATE - trunc(c_rec.NEW_DOCK_DATE);
2808: lv_dock_date :=MSC_CALENDAR.NEXT_WORK_DAY(lv_cal_code,c_rec.SR_INSTANCE_ID,c_rec.NEW_DOCK_DATE);
2809: lv_dock_date := lv_dock_date + lv_time_component;
2810: ELSE
2811: IF c_rec.ORDER_TYPE=11 THEN
2812:

Line 2816: 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);

2812:
2813: IF(lv_org_id <> c_rec.ORGANIZATION_ID or lv_org_id=0) THEN
2814: --GET_CALENDAR_CODE to be called only once for the same org
2815:
2816: 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);
2817:
2818: 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);
2819:
2820: lv_org_id:=c_rec.ORGANIZATION_ID;

Line 2818: 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);

2814: --GET_CALENDAR_CODE to be called only once for the same org
2815:
2816: 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);
2817:
2818: 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);
2819:
2820: lv_org_id:=c_rec.ORGANIZATION_ID;
2821:
2822: END IF;

Line 2827: 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);

2823: if (c_rec.NEW_SCHEDULE_DATE is not null ) then
2824: lv_time_component := c_rec.NEW_SCHEDULE_DATE - trunc(c_rec.NEW_SCHEDULE_DATE);
2825: END IF ;
2826:
2827: 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);
2828:
2829: if (c_rec.NEW_SCHEDULE_DATE is not null ) then
2830: lv_schedule_date := lv_schedule_date + lv_time_component ;
2831: END IF ;

Line 2845: 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);

2841:
2842: --offsetting the dock date to find the schedule date
2843: If ( lv_dock_date is not null) then
2844: lv_time_component := lv_dock_date - trunc(lv_dock_date);
2845: 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);
2846: lv_schedule_date := lv_schedule_date + lv_time_component;
2847: ELSE
2848: lv_schedule_date :=c_rec.NEW_SCHEDULE_DATE;
2849: END IF ;

Line 2863: 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);

2859: /* bug 5937871 */
2860: IF MSC_UTIL.g_collect_srp_data = 'Y' THEN
2861: IF c_rec.ORDER_TYPE=75 THEN
2862: if (c_rec.NEW_SCHEDULE_DATE is null ) then
2863: 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);
2864: 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);
2865: END IF ;
2866: END IF ;
2867: END IF ;

Line 2864: 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);

2860: IF MSC_UTIL.g_collect_srp_data = 'Y' THEN
2861: IF c_rec.ORDER_TYPE=75 THEN
2862: if (c_rec.NEW_SCHEDULE_DATE is null ) then
2863: 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);
2864: 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);
2865: END IF ;
2866: END IF ;
2867: END IF ;
2868: /* end bug 5937871*/

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

3163: || ' x.UNIT_NUMBER,'
3164: /*|| ' decode(x.ORDER_TYPE, 1,'
3165: || ' decode( '||lv_po_dock_date_ref|| ' ,'
3166: || PROMISED_DATE_PREF ||', x.NEW_SCHEDULE_DATE,'
3167: || MSC_CL_COLLECTION.NEED_BY_DATE_PREF ||', MSC_CALENDAR.DATE_OFFSET(x.ORGANIZATION_ID,'
3168: || ' x.SR_INSTANCE_ID,'
3169: || TYPE_DAILY_BUCKET ||' ,'
3170: || ' (MSC_CALENDAR.NEXT_WORK_DAY'
3171: || ' (x.ORGANIZATION_ID,'

Line 3170: || ' (MSC_CALENDAR.NEXT_WORK_DAY'

3166: || PROMISED_DATE_PREF ||', x.NEW_SCHEDULE_DATE,'
3167: || MSC_CL_COLLECTION.NEED_BY_DATE_PREF ||', MSC_CALENDAR.DATE_OFFSET(x.ORGANIZATION_ID,'
3168: || ' x.SR_INSTANCE_ID,'
3169: || TYPE_DAILY_BUCKET ||' ,'
3170: || ' (MSC_CALENDAR.NEXT_WORK_DAY'
3171: || ' (x.ORGANIZATION_ID,'
3172: || ' x.SR_INSTANCE_ID,'
3173: || ' 1,'
3174: || ' nvl(x.NEED_BY_DATE,x.promised_date))),'

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

3521: IF(lv_org_id <> lv_ORGANIZATION_ID or lv_org_id=0) THEN
3522:
3523: --GET_CALENDAR_CODE to be called only once for the same org
3524:
3525: lv_cal_code:=msc_calendar.GET_CALENDAR_CODE(lv_SR_INSTANCE_ID, null, null, null, null, null, lv_ORGANIZATION_ID, null, MSC_CALENDAR.ORC);
3526:
3527: 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);
3528:
3529: lv_org_id:=lv_ORGANIZATION_ID;

Line 3527: 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);

3523: --GET_CALENDAR_CODE to be called only once for the same org
3524:
3525: lv_cal_code:=msc_calendar.GET_CALENDAR_CODE(lv_SR_INSTANCE_ID, null, null, null, null, null, lv_ORGANIZATION_ID, null, MSC_CALENDAR.ORC);
3526:
3527: 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);
3528:
3529: lv_org_id:=lv_ORGANIZATION_ID;
3530:
3531: END IF;

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

3531: END IF;
3532:
3533: --finding the dock date by validating it from Org Rec. Calendar
3534: lv_time_component:= lv_NEW_DOCK_DATE- trunc(lv_NEW_DOCK_DATE);
3535: lv_NEW_DOCK_DATE :=MSC_CALENDAR.NEXT_WORK_DAY(lv_cal_code,lv_SR_INSTANCE_ID,lv_NEW_DOCK_DATE);
3536: lv_NEW_DOCK_DATE := lv_NEW_DOCK_DATE + lv_time_component;
3537: ELSE
3538: lv_NEW_DOCK_DATE :=null;
3539:

Line 3549: 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);

3545: --offsetting the dock date to find the schedule date
3546: If ( lv_NEW_DOCK_DATE is not null) then
3547: lv_time_component := lv_NEW_DOCK_DATE - trunc(lv_NEW_DOCK_DATE);
3548: END IF ;
3549: 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);
3550:
3551: If ( lv_NEW_DOCK_DATE is not null) then
3552: lv_NEW_SCHEDULE_DATE := lv_NEW_SCHEDULE_DATE +lv_time_component ;
3553: END IF ;