APPS.MSC_CL_CONT_COLL_FW dependencies on MSC_CL_COLLECTION

Line 3213: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SUPPLIER_CAPACITY) THEN

3209:
3210: p_is_incremental_refresh := FALSE;
3211: p_is_partial_refresh := FALSE;
3212:
3213: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SUPPLIER_CAPACITY) THEN
3214: if (MSC_CL_COLLECTION.v_coll_prec.supcap_sn_flag = MSC_UTIL.SYS_INCR) then
3215: -- do net-change for this entity
3216: p_is_incremental_refresh := TRUE;
3217: p_is_partial_refresh := FALSE;

Line 3214: if (MSC_CL_COLLECTION.v_coll_prec.supcap_sn_flag = MSC_UTIL.SYS_INCR) then

3210: p_is_incremental_refresh := FALSE;
3211: p_is_partial_refresh := FALSE;
3212:
3213: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SUPPLIER_CAPACITY) THEN
3214: if (MSC_CL_COLLECTION.v_coll_prec.supcap_sn_flag = MSC_UTIL.SYS_INCR) then
3215: -- do net-change for this entity
3216: p_is_incremental_refresh := TRUE;
3217: p_is_partial_refresh := FALSE;
3218: p_exchange_mode := MSC_UTIL.SYS_NO;

Line 3220: elsif (MSC_CL_COLLECTION.v_coll_prec.supcap_sn_flag = MSC_UTIL.SYS_TGT) then

3216: p_is_incremental_refresh := TRUE;
3217: p_is_partial_refresh := FALSE;
3218: p_exchange_mode := MSC_UTIL.SYS_NO;
3219: RETURN TRUE;
3220: elsif (MSC_CL_COLLECTION.v_coll_prec.supcap_sn_flag = MSC_UTIL.SYS_TGT) then
3221: -- do targeted for this entity
3222: p_is_incremental_refresh := FALSE;
3223: p_is_partial_refresh := TRUE;
3224: p_exchange_mode := MSC_UTIL.SYS_YES;

Line 3233: if p_task_num in (MSC_CL_COLLECTION.PTASK_BOM_COMPONENTS,MSC_CL_COLLECTION.PTASK_BOM,MSC_CL_COLLECTION.PTASK_COMPONENT_SUBSTITUTE,MSC_CL_COLLECTION.PTASK_ROUTING,

3229: end if;
3230:
3231: END IF;
3232:
3233: if p_task_num in (MSC_CL_COLLECTION.PTASK_BOM_COMPONENTS,MSC_CL_COLLECTION.PTASK_BOM,MSC_CL_COLLECTION.PTASK_COMPONENT_SUBSTITUTE,MSC_CL_COLLECTION.PTASK_ROUTING,
3234: MSC_CL_COLLECTION.PTASK_ROUTING_OPERATIONS,MSC_CL_COLLECTION.PTASK_OPERATION_RESOURCES,MSC_CL_COLLECTION.PTASK_RESOURCE,MSC_CL_COLLECTION.PTASK_OP_RESOURCE_SEQ,
3235: MSC_CL_COLLECTION.PTASK_PROCESS_EFFECTIVITY,MSC_CL_COLLECTION.PTASK_OPERATION_COMPONENTS,MSC_CL_COLLECTION.PTASK_OPERATION_NETWORKS,
3236: MSC_CL_COLLECTION.PTASK_RESOURCE_SETUP,MSC_CL_COLLECTION.PTASK_SETUP_TRANSITION,MSC_CL_COLLECTION.PTASK_STD_OP_RESOURCES) then /* ds change */
3237:

Line 3234: MSC_CL_COLLECTION.PTASK_ROUTING_OPERATIONS,MSC_CL_COLLECTION.PTASK_OPERATION_RESOURCES,MSC_CL_COLLECTION.PTASK_RESOURCE,MSC_CL_COLLECTION.PTASK_OP_RESOURCE_SEQ,

3230:
3231: END IF;
3232:
3233: if p_task_num in (MSC_CL_COLLECTION.PTASK_BOM_COMPONENTS,MSC_CL_COLLECTION.PTASK_BOM,MSC_CL_COLLECTION.PTASK_COMPONENT_SUBSTITUTE,MSC_CL_COLLECTION.PTASK_ROUTING,
3234: MSC_CL_COLLECTION.PTASK_ROUTING_OPERATIONS,MSC_CL_COLLECTION.PTASK_OPERATION_RESOURCES,MSC_CL_COLLECTION.PTASK_RESOURCE,MSC_CL_COLLECTION.PTASK_OP_RESOURCE_SEQ,
3235: MSC_CL_COLLECTION.PTASK_PROCESS_EFFECTIVITY,MSC_CL_COLLECTION.PTASK_OPERATION_COMPONENTS,MSC_CL_COLLECTION.PTASK_OPERATION_NETWORKS,
3236: MSC_CL_COLLECTION.PTASK_RESOURCE_SETUP,MSC_CL_COLLECTION.PTASK_SETUP_TRANSITION,MSC_CL_COLLECTION.PTASK_STD_OP_RESOURCES) then /* ds change */
3237:
3238: if (MSC_CL_COLLECTION.v_coll_prec.bom_sn_flag = MSC_UTIL.SYS_INCR) then

Line 3235: MSC_CL_COLLECTION.PTASK_PROCESS_EFFECTIVITY,MSC_CL_COLLECTION.PTASK_OPERATION_COMPONENTS,MSC_CL_COLLECTION.PTASK_OPERATION_NETWORKS,

3231: END IF;
3232:
3233: if p_task_num in (MSC_CL_COLLECTION.PTASK_BOM_COMPONENTS,MSC_CL_COLLECTION.PTASK_BOM,MSC_CL_COLLECTION.PTASK_COMPONENT_SUBSTITUTE,MSC_CL_COLLECTION.PTASK_ROUTING,
3234: MSC_CL_COLLECTION.PTASK_ROUTING_OPERATIONS,MSC_CL_COLLECTION.PTASK_OPERATION_RESOURCES,MSC_CL_COLLECTION.PTASK_RESOURCE,MSC_CL_COLLECTION.PTASK_OP_RESOURCE_SEQ,
3235: MSC_CL_COLLECTION.PTASK_PROCESS_EFFECTIVITY,MSC_CL_COLLECTION.PTASK_OPERATION_COMPONENTS,MSC_CL_COLLECTION.PTASK_OPERATION_NETWORKS,
3236: MSC_CL_COLLECTION.PTASK_RESOURCE_SETUP,MSC_CL_COLLECTION.PTASK_SETUP_TRANSITION,MSC_CL_COLLECTION.PTASK_STD_OP_RESOURCES) then /* ds change */
3237:
3238: if (MSC_CL_COLLECTION.v_coll_prec.bom_sn_flag = MSC_UTIL.SYS_INCR) then
3239: -- do net-change for this entity

Line 3236: MSC_CL_COLLECTION.PTASK_RESOURCE_SETUP,MSC_CL_COLLECTION.PTASK_SETUP_TRANSITION,MSC_CL_COLLECTION.PTASK_STD_OP_RESOURCES) then /* ds change */

3232:
3233: if p_task_num in (MSC_CL_COLLECTION.PTASK_BOM_COMPONENTS,MSC_CL_COLLECTION.PTASK_BOM,MSC_CL_COLLECTION.PTASK_COMPONENT_SUBSTITUTE,MSC_CL_COLLECTION.PTASK_ROUTING,
3234: MSC_CL_COLLECTION.PTASK_ROUTING_OPERATIONS,MSC_CL_COLLECTION.PTASK_OPERATION_RESOURCES,MSC_CL_COLLECTION.PTASK_RESOURCE,MSC_CL_COLLECTION.PTASK_OP_RESOURCE_SEQ,
3235: MSC_CL_COLLECTION.PTASK_PROCESS_EFFECTIVITY,MSC_CL_COLLECTION.PTASK_OPERATION_COMPONENTS,MSC_CL_COLLECTION.PTASK_OPERATION_NETWORKS,
3236: MSC_CL_COLLECTION.PTASK_RESOURCE_SETUP,MSC_CL_COLLECTION.PTASK_SETUP_TRANSITION,MSC_CL_COLLECTION.PTASK_STD_OP_RESOURCES) then /* ds change */
3237:
3238: if (MSC_CL_COLLECTION.v_coll_prec.bom_sn_flag = MSC_UTIL.SYS_INCR) then
3239: -- do net-change for this entity
3240: p_is_incremental_refresh := TRUE;

Line 3238: if (MSC_CL_COLLECTION.v_coll_prec.bom_sn_flag = MSC_UTIL.SYS_INCR) then

3234: MSC_CL_COLLECTION.PTASK_ROUTING_OPERATIONS,MSC_CL_COLLECTION.PTASK_OPERATION_RESOURCES,MSC_CL_COLLECTION.PTASK_RESOURCE,MSC_CL_COLLECTION.PTASK_OP_RESOURCE_SEQ,
3235: MSC_CL_COLLECTION.PTASK_PROCESS_EFFECTIVITY,MSC_CL_COLLECTION.PTASK_OPERATION_COMPONENTS,MSC_CL_COLLECTION.PTASK_OPERATION_NETWORKS,
3236: MSC_CL_COLLECTION.PTASK_RESOURCE_SETUP,MSC_CL_COLLECTION.PTASK_SETUP_TRANSITION,MSC_CL_COLLECTION.PTASK_STD_OP_RESOURCES) then /* ds change */
3237:
3238: if (MSC_CL_COLLECTION.v_coll_prec.bom_sn_flag = MSC_UTIL.SYS_INCR) then
3239: -- do net-change for this entity
3240: p_is_incremental_refresh := TRUE;
3241: p_is_partial_refresh := FALSE;
3242: p_exchange_mode := MSC_UTIL.SYS_NO;

Line 3243: MSC_CL_COLLECTION.v_bom_refresh_type := 1;

3239: -- do net-change for this entity
3240: p_is_incremental_refresh := TRUE;
3241: p_is_partial_refresh := FALSE;
3242: p_exchange_mode := MSC_UTIL.SYS_NO;
3243: MSC_CL_COLLECTION.v_bom_refresh_type := 1;
3244: RETURN TRUE;
3245: elsif (MSC_CL_COLLECTION.v_coll_prec.bom_sn_flag = MSC_UTIL.SYS_TGT) then
3246: -- do targeted for this entity
3247: p_is_incremental_refresh := FALSE;

Line 3245: elsif (MSC_CL_COLLECTION.v_coll_prec.bom_sn_flag = MSC_UTIL.SYS_TGT) then

3241: p_is_partial_refresh := FALSE;
3242: p_exchange_mode := MSC_UTIL.SYS_NO;
3243: MSC_CL_COLLECTION.v_bom_refresh_type := 1;
3244: RETURN TRUE;
3245: elsif (MSC_CL_COLLECTION.v_coll_prec.bom_sn_flag = MSC_UTIL.SYS_TGT) then
3246: -- do targeted for this entity
3247: p_is_incremental_refresh := FALSE;
3248: p_is_partial_refresh := TRUE;
3249: p_exchange_mode := MSC_UTIL.SYS_YES;

Line 3250: MSC_CL_COLLECTION.v_bom_refresh_type := 2;

3246: -- do targeted for this entity
3247: p_is_incremental_refresh := FALSE;
3248: p_is_partial_refresh := TRUE;
3249: p_exchange_mode := MSC_UTIL.SYS_YES;
3250: MSC_CL_COLLECTION.v_bom_refresh_type := 2;
3251: RETURN TRUE;
3252: else
3253: -- do nothing
3254: MSC_CL_COLLECTION.v_bom_refresh_type := 3;

Line 3254: MSC_CL_COLLECTION.v_bom_refresh_type := 3;

3250: MSC_CL_COLLECTION.v_bom_refresh_type := 2;
3251: RETURN TRUE;
3252: else
3253: -- do nothing
3254: MSC_CL_COLLECTION.v_bom_refresh_type := 3;
3255: RETURN FALSE;
3256: end if;
3257: end if;
3258: -- grouping bor w/ the bom tasks

Line 3259: IF (p_task_num = MSC_CL_COLLECTION.PTASK_BOR) THEN

3255: RETURN FALSE;
3256: end if;
3257: end if;
3258: -- grouping bor w/ the bom tasks
3259: IF (p_task_num = MSC_CL_COLLECTION.PTASK_BOR) THEN
3260: if (MSC_CL_COLLECTION.v_coll_prec.bor_sn_flag = MSC_UTIL.SYS_INCR) then
3261: -- do net-change for this entity
3262: p_is_incremental_refresh := TRUE;
3263: p_is_partial_refresh := FALSE;

Line 3260: if (MSC_CL_COLLECTION.v_coll_prec.bor_sn_flag = MSC_UTIL.SYS_INCR) then

3256: end if;
3257: end if;
3258: -- grouping bor w/ the bom tasks
3259: IF (p_task_num = MSC_CL_COLLECTION.PTASK_BOR) THEN
3260: if (MSC_CL_COLLECTION.v_coll_prec.bor_sn_flag = MSC_UTIL.SYS_INCR) then
3261: -- do net-change for this entity
3262: p_is_incremental_refresh := TRUE;
3263: p_is_partial_refresh := FALSE;
3264: p_exchange_mode := MSC_UTIL.SYS_NO;

Line 3266: elsif (MSC_CL_COLLECTION.v_coll_prec.bor_sn_flag = MSC_UTIL.SYS_TGT) then

3262: p_is_incremental_refresh := TRUE;
3263: p_is_partial_refresh := FALSE;
3264: p_exchange_mode := MSC_UTIL.SYS_NO;
3265: RETURN TRUE;
3266: elsif (MSC_CL_COLLECTION.v_coll_prec.bor_sn_flag = MSC_UTIL.SYS_TGT) then
3267: -- do targeted for this entity
3268: p_is_incremental_refresh := FALSE;
3269: p_is_partial_refresh := TRUE;
3270: p_exchange_mode := MSC_UTIL.SYS_YES;

Line 3278: IF (p_task_num = MSC_CL_COLLECTION.PTASK_FORECAST_DEMAND) THEN

3274: RETURN FALSE;
3275: end if;
3276: END IF;
3277:
3278: IF (p_task_num = MSC_CL_COLLECTION.PTASK_FORECAST_DEMAND) THEN
3279: -- (p_task_num = MSC_CL_COLLECTION.PTASK_FORECASTS) /*This will be done in launch_mon_partial*/
3280: -- (p_task_num = MSC_CL_COLLECTION.PTASK_ODS_DEMAND)) /* this will be done in supply */
3281: if (MSC_CL_COLLECTION.v_coll_prec.fcst_sn_flag = MSC_UTIL.SYS_INCR) then
3282: -- do net-change for this entity

Line 3279: -- (p_task_num = MSC_CL_COLLECTION.PTASK_FORECASTS) /*This will be done in launch_mon_partial*/

3275: end if;
3276: END IF;
3277:
3278: IF (p_task_num = MSC_CL_COLLECTION.PTASK_FORECAST_DEMAND) THEN
3279: -- (p_task_num = MSC_CL_COLLECTION.PTASK_FORECASTS) /*This will be done in launch_mon_partial*/
3280: -- (p_task_num = MSC_CL_COLLECTION.PTASK_ODS_DEMAND)) /* this will be done in supply */
3281: if (MSC_CL_COLLECTION.v_coll_prec.fcst_sn_flag = MSC_UTIL.SYS_INCR) then
3282: -- do net-change for this entity
3283: p_is_incremental_refresh := TRUE;

Line 3280: -- (p_task_num = MSC_CL_COLLECTION.PTASK_ODS_DEMAND)) /* this will be done in supply */

3276: END IF;
3277:
3278: IF (p_task_num = MSC_CL_COLLECTION.PTASK_FORECAST_DEMAND) THEN
3279: -- (p_task_num = MSC_CL_COLLECTION.PTASK_FORECASTS) /*This will be done in launch_mon_partial*/
3280: -- (p_task_num = MSC_CL_COLLECTION.PTASK_ODS_DEMAND)) /* this will be done in supply */
3281: if (MSC_CL_COLLECTION.v_coll_prec.fcst_sn_flag = MSC_UTIL.SYS_INCR) then
3282: -- do net-change for this entity
3283: p_is_incremental_refresh := TRUE;
3284: p_is_partial_refresh := FALSE;

Line 3281: if (MSC_CL_COLLECTION.v_coll_prec.fcst_sn_flag = MSC_UTIL.SYS_INCR) then

3277:
3278: IF (p_task_num = MSC_CL_COLLECTION.PTASK_FORECAST_DEMAND) THEN
3279: -- (p_task_num = MSC_CL_COLLECTION.PTASK_FORECASTS) /*This will be done in launch_mon_partial*/
3280: -- (p_task_num = MSC_CL_COLLECTION.PTASK_ODS_DEMAND)) /* this will be done in supply */
3281: if (MSC_CL_COLLECTION.v_coll_prec.fcst_sn_flag = MSC_UTIL.SYS_INCR) then
3282: -- do net-change for this entity
3283: p_is_incremental_refresh := TRUE;
3284: p_is_partial_refresh := FALSE;
3285: p_exchange_mode := MSC_UTIL.SYS_NO;

Line 3287: elsif (MSC_CL_COLLECTION.v_coll_prec.fcst_sn_flag = MSC_UTIL.SYS_TGT) then

3283: p_is_incremental_refresh := TRUE;
3284: p_is_partial_refresh := FALSE;
3285: p_exchange_mode := MSC_UTIL.SYS_NO;
3286: RETURN TRUE;
3287: elsif (MSC_CL_COLLECTION.v_coll_prec.fcst_sn_flag = MSC_UTIL.SYS_TGT) then
3288: -- do targeted for this entity
3289: p_is_incremental_refresh := FALSE;
3290: p_is_partial_refresh := TRUE;
3291: p_exchange_mode := MSC_UTIL.SYS_YES;

Line 3298: IF ((p_task_num = MSC_CL_COLLECTION.PTASK_ITEM) or (p_task_num = MSC_CL_COLLECTION.PTASK_CATEGORY_ITEM)) THEN

3294: -- do nothing
3295: RETURN FALSE;
3296: end if;
3297: end if;
3298: IF ((p_task_num = MSC_CL_COLLECTION.PTASK_ITEM) or (p_task_num = MSC_CL_COLLECTION.PTASK_CATEGORY_ITEM)) THEN
3299: if (MSC_CL_COLLECTION.v_coll_prec.item_sn_flag = MSC_UTIL.SYS_INCR) then
3300: -- do net-change for this entity
3301: p_is_incremental_refresh := TRUE;
3302: p_is_partial_refresh := FALSE;

Line 3299: if (MSC_CL_COLLECTION.v_coll_prec.item_sn_flag = MSC_UTIL.SYS_INCR) then

3295: RETURN FALSE;
3296: end if;
3297: end if;
3298: IF ((p_task_num = MSC_CL_COLLECTION.PTASK_ITEM) or (p_task_num = MSC_CL_COLLECTION.PTASK_CATEGORY_ITEM)) THEN
3299: if (MSC_CL_COLLECTION.v_coll_prec.item_sn_flag = MSC_UTIL.SYS_INCR) then
3300: -- do net-change for this entity
3301: p_is_incremental_refresh := TRUE;
3302: p_is_partial_refresh := FALSE;
3303: p_exchange_mode := MSC_UTIL.SYS_NO;

Line 3305: elsif (MSC_CL_COLLECTION.v_coll_prec.item_sn_flag = MSC_UTIL.SYS_TGT) then

3301: p_is_incremental_refresh := TRUE;
3302: p_is_partial_refresh := FALSE;
3303: p_exchange_mode := MSC_UTIL.SYS_NO;
3304: RETURN TRUE;
3305: elsif (MSC_CL_COLLECTION.v_coll_prec.item_sn_flag = MSC_UTIL.SYS_TGT) then
3306: -- do targeted for this entity
3307: p_is_incremental_refresh := FALSE;
3308: p_is_partial_refresh := TRUE;
3309: p_exchange_mode := MSC_UTIL.SYS_YES;

Line 3317: IF (p_task_num = MSC_CL_COLLECTION.PTASK_MDS_DEMAND) THEN

3313: RETURN FALSE;
3314: end if;
3315: END IF;
3316:
3317: IF (p_task_num = MSC_CL_COLLECTION.PTASK_MDS_DEMAND) THEN
3318: ---- (p_task_num = PTASK_DESIGNATOR) or
3319: ---- Currently LOAD_DESIGNATOR called in the LAUNCH_MONITOR itself.
3320: if (MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_INCR) then
3321: -- do net-change for this entity

Line 3320: if (MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_INCR) then

3316:
3317: IF (p_task_num = MSC_CL_COLLECTION.PTASK_MDS_DEMAND) THEN
3318: ---- (p_task_num = PTASK_DESIGNATOR) or
3319: ---- Currently LOAD_DESIGNATOR called in the LAUNCH_MONITOR itself.
3320: if (MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_INCR) then
3321: -- do net-change for this entity
3322: p_is_incremental_refresh := TRUE;
3323: p_is_partial_refresh := FALSE;
3324: p_exchange_mode := MSC_UTIL.SYS_NO;

Line 3326: elsif (MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_TGT) then

3322: p_is_incremental_refresh := TRUE;
3323: p_is_partial_refresh := FALSE;
3324: p_exchange_mode := MSC_UTIL.SYS_NO;
3325: RETURN TRUE;
3326: elsif (MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_TGT) then
3327: -- do targeted for this entity
3328: p_is_incremental_refresh := FALSE;
3329: p_is_partial_refresh := TRUE;
3330: p_exchange_mode := MSC_UTIL.SYS_YES;

Line 3339: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SUPPLY) then

3335: end if;
3336: END IF;
3337: /* supply is handled differently in execute_task_partial simply return true here */
3338:
3339: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SUPPLY) then
3340: RETURN TRUE;
3341: end if;
3342:
3343: /* If the Task is ODS_DEMAND, just retrun true since all the logic is in execute_part_task */

Line 3344: IF ( p_task_num = MSC_CL_COLLECTION.PTASK_ODS_DEMAND ) THEN

3340: RETURN TRUE;
3341: end if;
3342:
3343: /* If the Task is ODS_DEMAND, just retrun true since all the logic is in execute_part_task */
3344: IF ( p_task_num = MSC_CL_COLLECTION.PTASK_ODS_DEMAND ) THEN
3345: RETURN TRUE;
3346: END IF;
3347:
3348: IF (p_task_num = MSC_CL_COLLECTION.PTASK_NET_RESOURCE_AVAIL) THEN

Line 3348: IF (p_task_num = MSC_CL_COLLECTION.PTASK_NET_RESOURCE_AVAIL) THEN

3344: IF ( p_task_num = MSC_CL_COLLECTION.PTASK_ODS_DEMAND ) THEN
3345: RETURN TRUE;
3346: END IF;
3347:
3348: IF (p_task_num = MSC_CL_COLLECTION.PTASK_NET_RESOURCE_AVAIL) THEN
3349: RETURN TRUE;
3350: END IF;
3351:
3352: IF (p_task_num = MSC_CL_COLLECTION.PTASK_TRADING_PARTNER) THEN

Line 3352: IF (p_task_num = MSC_CL_COLLECTION.PTASK_TRADING_PARTNER) THEN

3348: IF (p_task_num = MSC_CL_COLLECTION.PTASK_NET_RESOURCE_AVAIL) THEN
3349: RETURN TRUE;
3350: END IF;
3351:
3352: IF (p_task_num = MSC_CL_COLLECTION.PTASK_TRADING_PARTNER) THEN
3353: RETURN FALSE; -- This will be done in Launch_mon_partial
3354: END IF;
3355:
3356: IF (p_task_num = MSC_CL_COLLECTION.PTASK_UOM) THEN

Line 3356: IF (p_task_num = MSC_CL_COLLECTION.PTASK_UOM) THEN

3352: IF (p_task_num = MSC_CL_COLLECTION.PTASK_TRADING_PARTNER) THEN
3353: RETURN FALSE; -- This will be done in Launch_mon_partial
3354: END IF;
3355:
3356: IF (p_task_num = MSC_CL_COLLECTION.PTASK_UOM) THEN
3357: RETURN FALSE; -- This will be done in Launch_mon_partial
3358: END IF;
3359:
3360: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SALES_ORDER) THEN

Line 3360: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SALES_ORDER) THEN

3356: IF (p_task_num = MSC_CL_COLLECTION.PTASK_UOM) THEN
3357: RETURN FALSE; -- This will be done in Launch_mon_partial
3358: END IF;
3359:
3360: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SALES_ORDER) THEN
3361: if (MSC_CL_COLLECTION.v_coll_prec.so_sn_flag = MSC_UTIL.SYS_TGT) then
3362: -- do targeted for this entity
3363: p_is_incremental_refresh := FALSE;
3364: p_is_partial_refresh := TRUE;

Line 3361: if (MSC_CL_COLLECTION.v_coll_prec.so_sn_flag = MSC_UTIL.SYS_TGT) then

3357: RETURN FALSE; -- This will be done in Launch_mon_partial
3358: END IF;
3359:
3360: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SALES_ORDER) THEN
3361: if (MSC_CL_COLLECTION.v_coll_prec.so_sn_flag = MSC_UTIL.SYS_TGT) then
3362: -- do targeted for this entity
3363: p_is_incremental_refresh := FALSE;
3364: p_is_partial_refresh := TRUE;
3365: p_exchange_mode := MSC_UTIL.SYS_YES;

Line 3376: IF (p_task_num in ( MSC_CL_COLLECTION.PTASK_WIP_RES_REQ, MSC_CL_COLLECTION.PTASK_WIP_DEMAND,MSC_CL_COLLECTION.PTASK_RES_INST_REQ ) ) THEN

3372: RETURN TRUE;
3373: end if;
3374: END IF;
3375:
3376: IF (p_task_num in ( MSC_CL_COLLECTION.PTASK_WIP_RES_REQ, MSC_CL_COLLECTION.PTASK_WIP_DEMAND,MSC_CL_COLLECTION.PTASK_RES_INST_REQ ) ) THEN
3377: if (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR) then
3378: -- do net-change for this entity
3379: p_is_incremental_refresh := TRUE;
3380: p_is_partial_refresh := FALSE;

Line 3377: if (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR) then

3373: end if;
3374: END IF;
3375:
3376: IF (p_task_num in ( MSC_CL_COLLECTION.PTASK_WIP_RES_REQ, MSC_CL_COLLECTION.PTASK_WIP_DEMAND,MSC_CL_COLLECTION.PTASK_RES_INST_REQ ) ) THEN
3377: if (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR) then
3378: -- do net-change for this entity
3379: p_is_incremental_refresh := TRUE;
3380: p_is_partial_refresh := FALSE;
3381: p_exchange_mode := MSC_UTIL.SYS_NO;

Line 3383: elsif (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) then

3379: p_is_incremental_refresh := TRUE;
3380: p_is_partial_refresh := FALSE;
3381: p_exchange_mode := MSC_UTIL.SYS_NO;
3382: RETURN TRUE;
3383: elsif (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) then
3384: -- do targeted for this entity
3385: p_is_incremental_refresh := FALSE;
3386: p_is_partial_refresh := TRUE;
3387: p_exchange_mode := MSC_UTIL.SYS_YES;

Line 3393: IF (p_task_num = MSC_CL_COLLECTION.PTASK_ATP_RULES) THEN

3389: else
3390: RETURN FALSE;
3391: end if;
3392: END IF;
3393: IF (p_task_num = MSC_CL_COLLECTION.PTASK_ATP_RULES) THEN
3394: if (MSC_CL_COLLECTION.v_coll_prec.atp_rules_flag = MSC_UTIL.SYS_YES) then
3395: p_is_incremental_refresh := FALSE;
3396: p_is_partial_refresh := TRUE;
3397: RETURN TRUE;

Line 3394: if (MSC_CL_COLLECTION.v_coll_prec.atp_rules_flag = MSC_UTIL.SYS_YES) then

3390: RETURN FALSE;
3391: end if;
3392: END IF;
3393: IF (p_task_num = MSC_CL_COLLECTION.PTASK_ATP_RULES) THEN
3394: if (MSC_CL_COLLECTION.v_coll_prec.atp_rules_flag = MSC_UTIL.SYS_YES) then
3395: p_is_incremental_refresh := FALSE;
3396: p_is_partial_refresh := TRUE;
3397: RETURN TRUE;
3398: else

Line 3403: IF (p_task_num = MSC_CL_COLLECTION.PTASK_CALENDAR_DATE) THEN

3399: RETURN FALSE;
3400: end if;
3401: END IF;
3402:
3403: IF (p_task_num = MSC_CL_COLLECTION.PTASK_CALENDAR_DATE) THEN
3404: if (MSC_CL_COLLECTION.v_coll_prec.calendar_flag = MSC_UTIL.SYS_YES) then
3405: p_is_incremental_refresh := FALSE;
3406: p_is_partial_refresh := TRUE;
3407: RETURN TRUE;

Line 3404: if (MSC_CL_COLLECTION.v_coll_prec.calendar_flag = MSC_UTIL.SYS_YES) then

3400: end if;
3401: END IF;
3402:
3403: IF (p_task_num = MSC_CL_COLLECTION.PTASK_CALENDAR_DATE) THEN
3404: if (MSC_CL_COLLECTION.v_coll_prec.calendar_flag = MSC_UTIL.SYS_YES) then
3405: p_is_incremental_refresh := FALSE;
3406: p_is_partial_refresh := TRUE;
3407: RETURN TRUE;
3408: else

Line 3413: IF (p_task_num = MSC_CL_COLLECTION.PTASK_DEMAND_CLASS) THEN

3409: RETURN FALSE;
3410: end if;
3411: END IF;
3412:
3413: IF (p_task_num = MSC_CL_COLLECTION.PTASK_DEMAND_CLASS) THEN
3414: if (MSC_CL_COLLECTION.v_coll_prec.demand_class_flag = MSC_UTIL.SYS_YES) then
3415: p_is_incremental_refresh := FALSE;
3416: p_is_partial_refresh := TRUE;
3417: RETURN TRUE;

Line 3414: if (MSC_CL_COLLECTION.v_coll_prec.demand_class_flag = MSC_UTIL.SYS_YES) then

3410: end if;
3411: END IF;
3412:
3413: IF (p_task_num = MSC_CL_COLLECTION.PTASK_DEMAND_CLASS) THEN
3414: if (MSC_CL_COLLECTION.v_coll_prec.demand_class_flag = MSC_UTIL.SYS_YES) then
3415: p_is_incremental_refresh := FALSE;
3416: p_is_partial_refresh := TRUE;
3417: RETURN TRUE;
3418: else

Line 3423: IF ((p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PFMC_MEASURES) OR

3419: RETURN FALSE;
3420: end if;
3421: END IF;
3422:
3423: IF ((p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PFMC_MEASURES) OR
3424: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGET_LEVELS) OR
3425: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGETS ) OR
3426: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_BUSINESS_PLANS) OR
3427: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PERIODS ) ) THEN

Line 3424: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGET_LEVELS) OR

3420: end if;
3421: END IF;
3422:
3423: IF ((p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PFMC_MEASURES) OR
3424: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGET_LEVELS) OR
3425: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGETS ) OR
3426: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_BUSINESS_PLANS) OR
3427: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PERIODS ) ) THEN
3428: IF MSC_CL_COLLECTION.v_coll_prec.kpi_bis_flag = MSC_UTIL.SYS_YES THEN

Line 3425: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGETS ) OR

3421: END IF;
3422:
3423: IF ((p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PFMC_MEASURES) OR
3424: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGET_LEVELS) OR
3425: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGETS ) OR
3426: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_BUSINESS_PLANS) OR
3427: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PERIODS ) ) THEN
3428: IF MSC_CL_COLLECTION.v_coll_prec.kpi_bis_flag = MSC_UTIL.SYS_YES THEN
3429: p_is_incremental_refresh := FALSE;

Line 3426: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_BUSINESS_PLANS) OR

3422:
3423: IF ((p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PFMC_MEASURES) OR
3424: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGET_LEVELS) OR
3425: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGETS ) OR
3426: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_BUSINESS_PLANS) OR
3427: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PERIODS ) ) THEN
3428: IF MSC_CL_COLLECTION.v_coll_prec.kpi_bis_flag = MSC_UTIL.SYS_YES THEN
3429: p_is_incremental_refresh := FALSE;
3430: p_is_partial_refresh := TRUE;

Line 3427: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PERIODS ) ) THEN

3423: IF ((p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PFMC_MEASURES) OR
3424: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGET_LEVELS) OR
3425: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGETS ) OR
3426: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_BUSINESS_PLANS) OR
3427: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PERIODS ) ) THEN
3428: IF MSC_CL_COLLECTION.v_coll_prec.kpi_bis_flag = MSC_UTIL.SYS_YES THEN
3429: p_is_incremental_refresh := FALSE;
3430: p_is_partial_refresh := TRUE;
3431: RETURN TRUE;

Line 3428: IF MSC_CL_COLLECTION.v_coll_prec.kpi_bis_flag = MSC_UTIL.SYS_YES THEN

3424: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGET_LEVELS) OR
3425: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGETS ) OR
3426: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_BUSINESS_PLANS) OR
3427: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PERIODS ) ) THEN
3428: IF MSC_CL_COLLECTION.v_coll_prec.kpi_bis_flag = MSC_UTIL.SYS_YES THEN
3429: p_is_incremental_refresh := FALSE;
3430: p_is_partial_refresh := TRUE;
3431: RETURN TRUE;
3432: else

Line 3437: IF (p_task_num = MSC_CL_COLLECTION.PTASK_PARAMETER) THEN

3433: RETURN FALSE;
3434: end if;
3435: END IF;
3436:
3437: IF (p_task_num = MSC_CL_COLLECTION.PTASK_PARAMETER) THEN
3438: if (MSC_CL_COLLECTION.v_coll_prec.parameter_flag = MSC_UTIL.SYS_YES) then
3439: p_is_incremental_refresh := FALSE;
3440: p_is_partial_refresh := TRUE;
3441: RETURN TRUE;

Line 3438: if (MSC_CL_COLLECTION.v_coll_prec.parameter_flag = MSC_UTIL.SYS_YES) then

3434: end if;
3435: END IF;
3436:
3437: IF (p_task_num = MSC_CL_COLLECTION.PTASK_PARAMETER) THEN
3438: if (MSC_CL_COLLECTION.v_coll_prec.parameter_flag = MSC_UTIL.SYS_YES) then
3439: p_is_incremental_refresh := FALSE;
3440: p_is_partial_refresh := TRUE;
3441: RETURN TRUE;
3442: else

Line 3447: IF (p_task_num = MSC_CL_COLLECTION.PTASK_PLANNERS) THEN

3443: RETURN FALSE;
3444: end if;
3445: END IF;
3446:
3447: IF (p_task_num = MSC_CL_COLLECTION.PTASK_PLANNERS) THEN
3448: if (MSC_CL_COLLECTION.v_coll_prec.planner_flag = MSC_UTIL.SYS_YES) then
3449: p_is_incremental_refresh := FALSE;
3450: p_is_partial_refresh := TRUE;
3451: RETURN TRUE;

Line 3448: if (MSC_CL_COLLECTION.v_coll_prec.planner_flag = MSC_UTIL.SYS_YES) then

3444: end if;
3445: END IF;
3446:
3447: IF (p_task_num = MSC_CL_COLLECTION.PTASK_PLANNERS) THEN
3448: if (MSC_CL_COLLECTION.v_coll_prec.planner_flag = MSC_UTIL.SYS_YES) then
3449: p_is_incremental_refresh := FALSE;
3450: p_is_partial_refresh := TRUE;
3451: RETURN TRUE;
3452: else

Line 3457: IF (p_task_num = MSC_CL_COLLECTION.PTASK_PROJECT) THEN

3453: RETURN FALSE;
3454: end if;
3455: END IF;
3456:
3457: IF (p_task_num = MSC_CL_COLLECTION.PTASK_PROJECT) THEN
3458: if (MSC_CL_COLLECTION.v_coll_prec.project_flag = MSC_UTIL.SYS_YES) then
3459: p_is_incremental_refresh := FALSE;
3460: p_is_partial_refresh := TRUE;
3461: RETURN TRUE;

Line 3458: if (MSC_CL_COLLECTION.v_coll_prec.project_flag = MSC_UTIL.SYS_YES) then

3454: end if;
3455: END IF;
3456:
3457: IF (p_task_num = MSC_CL_COLLECTION.PTASK_PROJECT) THEN
3458: if (MSC_CL_COLLECTION.v_coll_prec.project_flag = MSC_UTIL.SYS_YES) then
3459: p_is_incremental_refresh := FALSE;
3460: p_is_partial_refresh := TRUE;
3461: RETURN TRUE;
3462: else

Line 3467: IF (p_task_num = MSC_CL_COLLECTION.PTASK_HARD_RESERVATION) THEN

3463: RETURN FALSE;
3464: end if;
3465: END IF;
3466:
3467: IF (p_task_num = MSC_CL_COLLECTION.PTASK_HARD_RESERVATION) THEN
3468: if (MSC_CL_COLLECTION.v_coll_prec.reserves_flag = MSC_UTIL.SYS_YES) then
3469: p_is_incremental_refresh := FALSE;
3470: p_is_partial_refresh := TRUE;
3471: RETURN TRUE;

Line 3468: if (MSC_CL_COLLECTION.v_coll_prec.reserves_flag = MSC_UTIL.SYS_YES) then

3464: end if;
3465: END IF;
3466:
3467: IF (p_task_num = MSC_CL_COLLECTION.PTASK_HARD_RESERVATION) THEN
3468: if (MSC_CL_COLLECTION.v_coll_prec.reserves_flag = MSC_UTIL.SYS_YES) then
3469: p_is_incremental_refresh := FALSE;
3470: p_is_partial_refresh := TRUE;
3471: RETURN TRUE;
3472: else

Line 3477: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SAFETY_STOCK) THEN

3473: RETURN FALSE;
3474: end if;
3475: END IF;
3476:
3477: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SAFETY_STOCK) THEN
3478: if (MSC_CL_COLLECTION.v_coll_prec.saf_stock_flag = MSC_UTIL.SYS_YES) then
3479: p_is_incremental_refresh := FALSE;
3480: p_is_partial_refresh := TRUE;
3481: RETURN TRUE;

Line 3478: if (MSC_CL_COLLECTION.v_coll_prec.saf_stock_flag = MSC_UTIL.SYS_YES) then

3474: end if;
3475: END IF;
3476:
3477: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SAFETY_STOCK) THEN
3478: if (MSC_CL_COLLECTION.v_coll_prec.saf_stock_flag = MSC_UTIL.SYS_YES) then
3479: p_is_incremental_refresh := FALSE;
3480: p_is_partial_refresh := TRUE;
3481: RETURN TRUE;
3482: else

Line 3487: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SOURCING) THEN

3483: RETURN FALSE;
3484: end if;
3485: END IF;
3486:
3487: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SOURCING) THEN
3488: if (MSC_CL_COLLECTION.v_coll_prec.sourcing_rule_flag = MSC_UTIL.SYS_YES) then
3489: p_is_incremental_refresh := FALSE;
3490: p_is_partial_refresh := TRUE;
3491: RETURN TRUE;

Line 3488: if (MSC_CL_COLLECTION.v_coll_prec.sourcing_rule_flag = MSC_UTIL.SYS_YES) then

3484: end if;
3485: END IF;
3486:
3487: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SOURCING) THEN
3488: if (MSC_CL_COLLECTION.v_coll_prec.sourcing_rule_flag = MSC_UTIL.SYS_YES) then
3489: p_is_incremental_refresh := FALSE;
3490: p_is_partial_refresh := TRUE;
3491: RETURN TRUE;
3492: else

Line 3497: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SUB_INVENTORY) THEN

3493: RETURN FALSE;
3494: end if;
3495: END IF;
3496:
3497: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SUB_INVENTORY) THEN
3498: if (MSC_CL_COLLECTION.v_coll_prec.sub_inventory_flag = MSC_UTIL.SYS_YES) then
3499: p_is_incremental_refresh := FALSE;
3500: p_is_partial_refresh := TRUE;
3501: RETURN TRUE;

Line 3498: if (MSC_CL_COLLECTION.v_coll_prec.sub_inventory_flag = MSC_UTIL.SYS_YES) then

3494: end if;
3495: END IF;
3496:
3497: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SUB_INVENTORY) THEN
3498: if (MSC_CL_COLLECTION.v_coll_prec.sub_inventory_flag = MSC_UTIL.SYS_YES) then
3499: p_is_incremental_refresh := FALSE;
3500: p_is_partial_refresh := TRUE;
3501: RETURN TRUE;
3502: else

Line 3507: IF (p_task_num = MSC_CL_COLLECTION.PTASK_UNIT_NUMBER) THEN

3503: RETURN FALSE;
3504: end if;
3505: END IF;
3506:
3507: IF (p_task_num = MSC_CL_COLLECTION.PTASK_UNIT_NUMBER) THEN
3508: if (MSC_CL_COLLECTION.v_coll_prec.unit_number_flag = MSC_UTIL.SYS_YES) then
3509: p_is_incremental_refresh := FALSE;
3510: p_is_partial_refresh := TRUE;
3511: RETURN TRUE;

Line 3508: if (MSC_CL_COLLECTION.v_coll_prec.unit_number_flag = MSC_UTIL.SYS_YES) then

3504: end if;
3505: END IF;
3506:
3507: IF (p_task_num = MSC_CL_COLLECTION.PTASK_UNIT_NUMBER) THEN
3508: if (MSC_CL_COLLECTION.v_coll_prec.unit_number_flag = MSC_UTIL.SYS_YES) then
3509: p_is_incremental_refresh := FALSE;
3510: p_is_partial_refresh := TRUE;
3511: RETURN TRUE;
3512: else

Line 3517: IF (p_task_num = MSC_CL_COLLECTION.PTASK_ITEM_SUBSTITUTES) THEN

3513: RETURN FALSE;
3514: end if;
3515: END IF;
3516:
3517: IF (p_task_num = MSC_CL_COLLECTION.PTASK_ITEM_SUBSTITUTES) THEN
3518: if (MSC_CL_COLLECTION.v_coll_prec.item_subst_flag = MSC_UTIL.SYS_YES) then
3519: p_is_incremental_refresh := FALSE;
3520: p_is_partial_refresh := TRUE;
3521: RETURN TRUE;

Line 3518: if (MSC_CL_COLLECTION.v_coll_prec.item_subst_flag = MSC_UTIL.SYS_YES) then

3514: end if;
3515: END IF;
3516:
3517: IF (p_task_num = MSC_CL_COLLECTION.PTASK_ITEM_SUBSTITUTES) THEN
3518: if (MSC_CL_COLLECTION.v_coll_prec.item_subst_flag = MSC_UTIL.SYS_YES) then
3519: p_is_incremental_refresh := FALSE;
3520: p_is_partial_refresh := TRUE;
3521: RETURN TRUE;
3522: else

Line 3527: IF (p_task_num = MSC_CL_COLLECTION.PTASK_COMPANY_USERS) THEN

3523: RETURN FALSE;
3524: end if;
3525: END IF;
3526:
3527: IF (p_task_num = MSC_CL_COLLECTION.PTASK_COMPANY_USERS) THEN
3528: if (MSC_CL_COLLECTION.v_coll_prec.user_company_flag = MSC_UTIL.COMPANY_ONLY) OR
3529: (MSC_CL_COLLECTION.v_coll_prec.user_company_flag = MSC_UTIL.USER_AND_COMPANY) then
3530: p_is_incremental_refresh := FALSE;
3531: p_is_partial_refresh := TRUE;

Line 3528: if (MSC_CL_COLLECTION.v_coll_prec.user_company_flag = MSC_UTIL.COMPANY_ONLY) OR

3524: end if;
3525: END IF;
3526:
3527: IF (p_task_num = MSC_CL_COLLECTION.PTASK_COMPANY_USERS) THEN
3528: if (MSC_CL_COLLECTION.v_coll_prec.user_company_flag = MSC_UTIL.COMPANY_ONLY) OR
3529: (MSC_CL_COLLECTION.v_coll_prec.user_company_flag = MSC_UTIL.USER_AND_COMPANY) then
3530: p_is_incremental_refresh := FALSE;
3531: p_is_partial_refresh := TRUE;
3532: RETURN TRUE;

Line 3529: (MSC_CL_COLLECTION.v_coll_prec.user_company_flag = MSC_UTIL.USER_AND_COMPANY) then

3525: END IF;
3526:
3527: IF (p_task_num = MSC_CL_COLLECTION.PTASK_COMPANY_USERS) THEN
3528: if (MSC_CL_COLLECTION.v_coll_prec.user_company_flag = MSC_UTIL.COMPANY_ONLY) OR
3529: (MSC_CL_COLLECTION.v_coll_prec.user_company_flag = MSC_UTIL.USER_AND_COMPANY) then
3530: p_is_incremental_refresh := FALSE;
3531: p_is_partial_refresh := TRUE;
3532: RETURN TRUE;
3533: else