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_CONT_COLL_FW dependencies on MSC_CL_COLLECTION

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

3250:
3251: p_is_incremental_refresh := FALSE;
3252: p_is_partial_refresh := FALSE;
3253:
3254: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SUPPLIER_CAPACITY) THEN
3255: if (MSC_CL_COLLECTION.v_coll_prec.supcap_sn_flag = MSC_UTIL.SYS_INCR) then
3256: -- do net-change for this entity
3257: p_is_incremental_refresh := TRUE;
3258: p_is_partial_refresh := FALSE;

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

3251: p_is_incremental_refresh := FALSE;
3252: p_is_partial_refresh := FALSE;
3253:
3254: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SUPPLIER_CAPACITY) THEN
3255: if (MSC_CL_COLLECTION.v_coll_prec.supcap_sn_flag = MSC_UTIL.SYS_INCR) then
3256: -- do net-change for this entity
3257: p_is_incremental_refresh := TRUE;
3258: p_is_partial_refresh := FALSE;
3259: p_exchange_mode := MSC_UTIL.SYS_NO;

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

3257: p_is_incremental_refresh := TRUE;
3258: p_is_partial_refresh := FALSE;
3259: p_exchange_mode := MSC_UTIL.SYS_NO;
3260: RETURN TRUE;
3261: elsif (MSC_CL_COLLECTION.v_coll_prec.supcap_sn_flag = MSC_UTIL.SYS_TGT) then
3262: -- do targeted for this entity
3263: p_is_incremental_refresh := FALSE;
3264: p_is_partial_refresh := TRUE;
3265: p_exchange_mode := MSC_UTIL.SYS_YES;

Line 3274: 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,

3270: end if;
3271:
3272: END IF;
3273:
3274: 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,
3275: MSC_CL_COLLECTION.PTASK_ROUTING_OPERATIONS,MSC_CL_COLLECTION.PTASK_OPERATION_RESOURCES,MSC_CL_COLLECTION.PTASK_RESOURCE,MSC_CL_COLLECTION.PTASK_OP_RESOURCE_SEQ,
3276: MSC_CL_COLLECTION.PTASK_PROCESS_EFFECTIVITY,MSC_CL_COLLECTION.PTASK_OPERATION_COMPONENTS,MSC_CL_COLLECTION.PTASK_OPERATION_NETWORKS,
3277: MSC_CL_COLLECTION.PTASK_RESOURCE_SETUP,MSC_CL_COLLECTION.PTASK_SETUP_TRANSITION,MSC_CL_COLLECTION.PTASK_STD_OP_RESOURCES) then /* ds change */
3278:

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

3271:
3272: END IF;
3273:
3274: 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,
3275: MSC_CL_COLLECTION.PTASK_ROUTING_OPERATIONS,MSC_CL_COLLECTION.PTASK_OPERATION_RESOURCES,MSC_CL_COLLECTION.PTASK_RESOURCE,MSC_CL_COLLECTION.PTASK_OP_RESOURCE_SEQ,
3276: MSC_CL_COLLECTION.PTASK_PROCESS_EFFECTIVITY,MSC_CL_COLLECTION.PTASK_OPERATION_COMPONENTS,MSC_CL_COLLECTION.PTASK_OPERATION_NETWORKS,
3277: MSC_CL_COLLECTION.PTASK_RESOURCE_SETUP,MSC_CL_COLLECTION.PTASK_SETUP_TRANSITION,MSC_CL_COLLECTION.PTASK_STD_OP_RESOURCES) then /* ds change */
3278:
3279: if (MSC_CL_COLLECTION.v_coll_prec.bom_sn_flag = MSC_UTIL.SYS_INCR) then

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

3272: END IF;
3273:
3274: 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,
3275: MSC_CL_COLLECTION.PTASK_ROUTING_OPERATIONS,MSC_CL_COLLECTION.PTASK_OPERATION_RESOURCES,MSC_CL_COLLECTION.PTASK_RESOURCE,MSC_CL_COLLECTION.PTASK_OP_RESOURCE_SEQ,
3276: MSC_CL_COLLECTION.PTASK_PROCESS_EFFECTIVITY,MSC_CL_COLLECTION.PTASK_OPERATION_COMPONENTS,MSC_CL_COLLECTION.PTASK_OPERATION_NETWORKS,
3277: MSC_CL_COLLECTION.PTASK_RESOURCE_SETUP,MSC_CL_COLLECTION.PTASK_SETUP_TRANSITION,MSC_CL_COLLECTION.PTASK_STD_OP_RESOURCES) then /* ds change */
3278:
3279: if (MSC_CL_COLLECTION.v_coll_prec.bom_sn_flag = MSC_UTIL.SYS_INCR) then
3280: -- do net-change for this entity

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

3273:
3274: 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,
3275: MSC_CL_COLLECTION.PTASK_ROUTING_OPERATIONS,MSC_CL_COLLECTION.PTASK_OPERATION_RESOURCES,MSC_CL_COLLECTION.PTASK_RESOURCE,MSC_CL_COLLECTION.PTASK_OP_RESOURCE_SEQ,
3276: MSC_CL_COLLECTION.PTASK_PROCESS_EFFECTIVITY,MSC_CL_COLLECTION.PTASK_OPERATION_COMPONENTS,MSC_CL_COLLECTION.PTASK_OPERATION_NETWORKS,
3277: MSC_CL_COLLECTION.PTASK_RESOURCE_SETUP,MSC_CL_COLLECTION.PTASK_SETUP_TRANSITION,MSC_CL_COLLECTION.PTASK_STD_OP_RESOURCES) then /* ds change */
3278:
3279: if (MSC_CL_COLLECTION.v_coll_prec.bom_sn_flag = MSC_UTIL.SYS_INCR) then
3280: -- do net-change for this entity
3281: p_is_incremental_refresh := TRUE;

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

3275: MSC_CL_COLLECTION.PTASK_ROUTING_OPERATIONS,MSC_CL_COLLECTION.PTASK_OPERATION_RESOURCES,MSC_CL_COLLECTION.PTASK_RESOURCE,MSC_CL_COLLECTION.PTASK_OP_RESOURCE_SEQ,
3276: MSC_CL_COLLECTION.PTASK_PROCESS_EFFECTIVITY,MSC_CL_COLLECTION.PTASK_OPERATION_COMPONENTS,MSC_CL_COLLECTION.PTASK_OPERATION_NETWORKS,
3277: MSC_CL_COLLECTION.PTASK_RESOURCE_SETUP,MSC_CL_COLLECTION.PTASK_SETUP_TRANSITION,MSC_CL_COLLECTION.PTASK_STD_OP_RESOURCES) then /* ds change */
3278:
3279: if (MSC_CL_COLLECTION.v_coll_prec.bom_sn_flag = MSC_UTIL.SYS_INCR) then
3280: -- do net-change for this entity
3281: p_is_incremental_refresh := TRUE;
3282: p_is_partial_refresh := FALSE;
3283: p_exchange_mode := MSC_UTIL.SYS_NO;

Line 3284: MSC_CL_COLLECTION.v_bom_refresh_type := 1;

3280: -- do net-change for this entity
3281: p_is_incremental_refresh := TRUE;
3282: p_is_partial_refresh := FALSE;
3283: p_exchange_mode := MSC_UTIL.SYS_NO;
3284: MSC_CL_COLLECTION.v_bom_refresh_type := 1;
3285: RETURN TRUE;
3286: elsif (MSC_CL_COLLECTION.v_coll_prec.bom_sn_flag = MSC_UTIL.SYS_TGT) then
3287: -- do targeted for this entity
3288: p_is_incremental_refresh := FALSE;

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

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

Line 3291: MSC_CL_COLLECTION.v_bom_refresh_type := 2;

3287: -- do targeted for this entity
3288: p_is_incremental_refresh := FALSE;
3289: p_is_partial_refresh := TRUE;
3290: p_exchange_mode := MSC_UTIL.SYS_YES;
3291: MSC_CL_COLLECTION.v_bom_refresh_type := 2;
3292: RETURN TRUE;
3293: else
3294: -- do nothing
3295: MSC_CL_COLLECTION.v_bom_refresh_type := 3;

Line 3295: MSC_CL_COLLECTION.v_bom_refresh_type := 3;

3291: MSC_CL_COLLECTION.v_bom_refresh_type := 2;
3292: RETURN TRUE;
3293: else
3294: -- do nothing
3295: MSC_CL_COLLECTION.v_bom_refresh_type := 3;
3296: RETURN FALSE;
3297: end if;
3298: end if;
3299: -- grouping bor w/ the bom tasks

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

3296: RETURN FALSE;
3297: end if;
3298: end if;
3299: -- grouping bor w/ the bom tasks
3300: IF (p_task_num = MSC_CL_COLLECTION.PTASK_BOR) THEN
3301: if (MSC_CL_COLLECTION.v_coll_prec.bor_sn_flag = MSC_UTIL.SYS_INCR) then
3302: -- do net-change for this entity
3303: p_is_incremental_refresh := TRUE;
3304: p_is_partial_refresh := FALSE;

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

3297: end if;
3298: end if;
3299: -- grouping bor w/ the bom tasks
3300: IF (p_task_num = MSC_CL_COLLECTION.PTASK_BOR) THEN
3301: if (MSC_CL_COLLECTION.v_coll_prec.bor_sn_flag = MSC_UTIL.SYS_INCR) then
3302: -- do net-change for this entity
3303: p_is_incremental_refresh := TRUE;
3304: p_is_partial_refresh := FALSE;
3305: p_exchange_mode := MSC_UTIL.SYS_NO;

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

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

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

3315: RETURN FALSE;
3316: end if;
3317: END IF;
3318:
3319: IF (p_task_num = MSC_CL_COLLECTION.PTASK_FORECAST_DEMAND) THEN
3320: -- (p_task_num = MSC_CL_COLLECTION.PTASK_FORECASTS) /*This will be done in launch_mon_partial*/
3321: -- (p_task_num = MSC_CL_COLLECTION.PTASK_ODS_DEMAND)) /* this will be done in supply */
3322: if (MSC_CL_COLLECTION.v_coll_prec.fcst_sn_flag = MSC_UTIL.SYS_INCR) then
3323: -- do net-change for this entity

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

3316: end if;
3317: END IF;
3318:
3319: IF (p_task_num = MSC_CL_COLLECTION.PTASK_FORECAST_DEMAND) THEN
3320: -- (p_task_num = MSC_CL_COLLECTION.PTASK_FORECASTS) /*This will be done in launch_mon_partial*/
3321: -- (p_task_num = MSC_CL_COLLECTION.PTASK_ODS_DEMAND)) /* this will be done in supply */
3322: if (MSC_CL_COLLECTION.v_coll_prec.fcst_sn_flag = MSC_UTIL.SYS_INCR) then
3323: -- do net-change for this entity
3324: p_is_incremental_refresh := TRUE;

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

3317: END IF;
3318:
3319: IF (p_task_num = MSC_CL_COLLECTION.PTASK_FORECAST_DEMAND) THEN
3320: -- (p_task_num = MSC_CL_COLLECTION.PTASK_FORECASTS) /*This will be done in launch_mon_partial*/
3321: -- (p_task_num = MSC_CL_COLLECTION.PTASK_ODS_DEMAND)) /* this will be done in supply */
3322: if (MSC_CL_COLLECTION.v_coll_prec.fcst_sn_flag = MSC_UTIL.SYS_INCR) then
3323: -- do net-change for this entity
3324: p_is_incremental_refresh := TRUE;
3325: p_is_partial_refresh := FALSE;

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

3318:
3319: IF (p_task_num = MSC_CL_COLLECTION.PTASK_FORECAST_DEMAND) THEN
3320: -- (p_task_num = MSC_CL_COLLECTION.PTASK_FORECASTS) /*This will be done in launch_mon_partial*/
3321: -- (p_task_num = MSC_CL_COLLECTION.PTASK_ODS_DEMAND)) /* this will be done in supply */
3322: if (MSC_CL_COLLECTION.v_coll_prec.fcst_sn_flag = MSC_UTIL.SYS_INCR) then
3323: -- do net-change for this entity
3324: p_is_incremental_refresh := TRUE;
3325: p_is_partial_refresh := FALSE;
3326: p_exchange_mode := MSC_UTIL.SYS_NO;

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

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

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

3335: -- do nothing
3336: RETURN FALSE;
3337: end if;
3338: end if;
3339: IF ((p_task_num = MSC_CL_COLLECTION.PTASK_ITEM) or (p_task_num = MSC_CL_COLLECTION.PTASK_CATEGORY_ITEM)) THEN
3340: if (MSC_CL_COLLECTION.v_coll_prec.item_sn_flag = MSC_UTIL.SYS_INCR) then
3341: -- do net-change for this entity
3342: p_is_incremental_refresh := TRUE;
3343: p_is_partial_refresh := FALSE;

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

3336: RETURN FALSE;
3337: end if;
3338: end if;
3339: IF ((p_task_num = MSC_CL_COLLECTION.PTASK_ITEM) or (p_task_num = MSC_CL_COLLECTION.PTASK_CATEGORY_ITEM)) THEN
3340: if (MSC_CL_COLLECTION.v_coll_prec.item_sn_flag = MSC_UTIL.SYS_INCR) then
3341: -- do net-change for this entity
3342: p_is_incremental_refresh := TRUE;
3343: p_is_partial_refresh := FALSE;
3344: p_exchange_mode := MSC_UTIL.SYS_NO;

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

3342: p_is_incremental_refresh := TRUE;
3343: p_is_partial_refresh := FALSE;
3344: p_exchange_mode := MSC_UTIL.SYS_NO;
3345: RETURN TRUE;
3346: elsif (MSC_CL_COLLECTION.v_coll_prec.item_sn_flag = MSC_UTIL.SYS_TGT) then
3347: -- do targeted for this entity
3348: p_is_incremental_refresh := FALSE;
3349: p_is_partial_refresh := TRUE;
3350: p_exchange_mode := MSC_UTIL.SYS_YES;

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

3354: RETURN FALSE;
3355: end if;
3356: END IF;
3357:
3358: IF (p_task_num = MSC_CL_COLLECTION.PTASK_MDS_DEMAND) THEN
3359: ---- (p_task_num = PTASK_DESIGNATOR) or
3360: ---- Currently LOAD_DESIGNATOR called in the LAUNCH_MONITOR itself.
3361: if (MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_INCR) then
3362: -- do net-change for this entity

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

3357:
3358: IF (p_task_num = MSC_CL_COLLECTION.PTASK_MDS_DEMAND) THEN
3359: ---- (p_task_num = PTASK_DESIGNATOR) or
3360: ---- Currently LOAD_DESIGNATOR called in the LAUNCH_MONITOR itself.
3361: if (MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_INCR) then
3362: -- do net-change for this entity
3363: p_is_incremental_refresh := TRUE;
3364: p_is_partial_refresh := FALSE;
3365: p_exchange_mode := MSC_UTIL.SYS_NO;

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

3363: p_is_incremental_refresh := TRUE;
3364: p_is_partial_refresh := FALSE;
3365: p_exchange_mode := MSC_UTIL.SYS_NO;
3366: RETURN TRUE;
3367: elsif (MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_TGT) then
3368: -- do targeted for this entity
3369: p_is_incremental_refresh := FALSE;
3370: p_is_partial_refresh := TRUE;
3371: p_exchange_mode := MSC_UTIL.SYS_YES;

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

3376: end if;
3377: END IF;
3378: /* supply is handled differently in execute_task_partial simply return true here */
3379:
3380: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SUPPLY) then
3381: RETURN TRUE;
3382: end if;
3383:
3384: /* If the Task is ODS_DEMAND, just retrun true since all the logic is in execute_part_task */

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

3381: RETURN TRUE;
3382: end if;
3383:
3384: /* If the Task is ODS_DEMAND, just retrun true since all the logic is in execute_part_task */
3385: IF ( p_task_num = MSC_CL_COLLECTION.PTASK_ODS_DEMAND ) THEN
3386: RETURN TRUE;
3387: END IF;
3388:
3389: IF (p_task_num = MSC_CL_COLLECTION.PTASK_NET_RESOURCE_AVAIL) THEN

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

3385: IF ( p_task_num = MSC_CL_COLLECTION.PTASK_ODS_DEMAND ) THEN
3386: RETURN TRUE;
3387: END IF;
3388:
3389: IF (p_task_num = MSC_CL_COLLECTION.PTASK_NET_RESOURCE_AVAIL) THEN
3390: RETURN TRUE;
3391: END IF;
3392:
3393: IF (p_task_num = MSC_CL_COLLECTION.PTASK_TRADING_PARTNER) THEN

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

3389: IF (p_task_num = MSC_CL_COLLECTION.PTASK_NET_RESOURCE_AVAIL) THEN
3390: RETURN TRUE;
3391: END IF;
3392:
3393: IF (p_task_num = MSC_CL_COLLECTION.PTASK_TRADING_PARTNER) THEN
3394: RETURN FALSE; -- This will be done in Launch_mon_partial
3395: END IF;
3396:
3397: IF (p_task_num = MSC_CL_COLLECTION.PTASK_UOM) THEN

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

3393: IF (p_task_num = MSC_CL_COLLECTION.PTASK_TRADING_PARTNER) THEN
3394: RETURN FALSE; -- This will be done in Launch_mon_partial
3395: END IF;
3396:
3397: IF (p_task_num = MSC_CL_COLLECTION.PTASK_UOM) THEN
3398: RETURN FALSE; -- This will be done in Launch_mon_partial
3399: END IF;
3400:
3401: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SALES_ORDER) THEN

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

3397: IF (p_task_num = MSC_CL_COLLECTION.PTASK_UOM) THEN
3398: RETURN FALSE; -- This will be done in Launch_mon_partial
3399: END IF;
3400:
3401: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SALES_ORDER) THEN
3402: if (MSC_CL_COLLECTION.v_coll_prec.so_sn_flag = MSC_UTIL.SYS_TGT) then
3403: -- do targeted for this entity
3404: p_is_incremental_refresh := FALSE;
3405: p_is_partial_refresh := TRUE;

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

3398: RETURN FALSE; -- This will be done in Launch_mon_partial
3399: END IF;
3400:
3401: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SALES_ORDER) THEN
3402: if (MSC_CL_COLLECTION.v_coll_prec.so_sn_flag = MSC_UTIL.SYS_TGT) then
3403: -- do targeted for this entity
3404: p_is_incremental_refresh := FALSE;
3405: p_is_partial_refresh := TRUE;
3406: p_exchange_mode := MSC_UTIL.SYS_YES;

Line 3417: 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

3413: RETURN TRUE;
3414: end if;
3415: END IF;
3416:
3417: 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
3418: if (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR) then
3419: -- do net-change for this entity
3420: p_is_incremental_refresh := TRUE;
3421: p_is_partial_refresh := FALSE;

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

3414: end if;
3415: END IF;
3416:
3417: 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
3418: if (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR) then
3419: -- do net-change for this entity
3420: p_is_incremental_refresh := TRUE;
3421: p_is_partial_refresh := FALSE;
3422: p_exchange_mode := MSC_UTIL.SYS_NO;

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

3420: p_is_incremental_refresh := TRUE;
3421: p_is_partial_refresh := FALSE;
3422: p_exchange_mode := MSC_UTIL.SYS_NO;
3423: RETURN TRUE;
3424: elsif (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) then
3425: -- do targeted for this entity
3426: p_is_incremental_refresh := FALSE;
3427: p_is_partial_refresh := TRUE;
3428: p_exchange_mode := MSC_UTIL.SYS_YES;

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

3430: else
3431: RETURN FALSE;
3432: end if;
3433: END IF;
3434: IF (p_task_num = MSC_CL_COLLECTION.PTASK_ATP_RULES) THEN
3435: if (MSC_CL_COLLECTION.v_coll_prec.atp_rules_flag = MSC_UTIL.SYS_YES) then
3436: p_is_incremental_refresh := FALSE;
3437: p_is_partial_refresh := TRUE;
3438: RETURN TRUE;

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

3431: RETURN FALSE;
3432: end if;
3433: END IF;
3434: IF (p_task_num = MSC_CL_COLLECTION.PTASK_ATP_RULES) THEN
3435: if (MSC_CL_COLLECTION.v_coll_prec.atp_rules_flag = MSC_UTIL.SYS_YES) then
3436: p_is_incremental_refresh := FALSE;
3437: p_is_partial_refresh := TRUE;
3438: RETURN TRUE;
3439: else

Line 3444: IF (p_task_num = MSC_CL_COLLECTION.PTASK_CALENDAR_DATE OR

3440: RETURN FALSE;
3441: end if;
3442: END IF;
3443:
3444: IF (p_task_num = MSC_CL_COLLECTION.PTASK_CALENDAR_DATE OR
3445: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PERIODS ) ) THEN
3446: if (MSC_CL_COLLECTION.v_coll_prec.calendar_flag = MSC_UTIL.SYS_YES) then
3447: p_is_incremental_refresh := FALSE;
3448: p_is_partial_refresh := TRUE;

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

3441: end if;
3442: END IF;
3443:
3444: IF (p_task_num = MSC_CL_COLLECTION.PTASK_CALENDAR_DATE OR
3445: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PERIODS ) ) THEN
3446: if (MSC_CL_COLLECTION.v_coll_prec.calendar_flag = MSC_UTIL.SYS_YES) then
3447: p_is_incremental_refresh := FALSE;
3448: p_is_partial_refresh := TRUE;
3449: RETURN TRUE;

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

3442: END IF;
3443:
3444: IF (p_task_num = MSC_CL_COLLECTION.PTASK_CALENDAR_DATE OR
3445: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PERIODS ) ) THEN
3446: if (MSC_CL_COLLECTION.v_coll_prec.calendar_flag = MSC_UTIL.SYS_YES) then
3447: p_is_incremental_refresh := FALSE;
3448: p_is_partial_refresh := TRUE;
3449: RETURN TRUE;
3450: else

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

3451: RETURN FALSE;
3452: end if;
3453: END IF;
3454:
3455: IF (p_task_num = MSC_CL_COLLECTION.PTASK_DEMAND_CLASS) THEN
3456: if (MSC_CL_COLLECTION.v_coll_prec.demand_class_flag = MSC_UTIL.SYS_YES) then
3457: p_is_incremental_refresh := FALSE;
3458: p_is_partial_refresh := TRUE;
3459: RETURN TRUE;

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

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

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

3461: RETURN FALSE;
3462: end if;
3463: END IF;
3464:
3465: IF ((p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PFMC_MEASURES) OR
3466: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGET_LEVELS) OR
3467: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGETS ) OR
3468: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_BUSINESS_PLANS)) THEN
3469: IF MSC_CL_COLLECTION.v_coll_prec.kpi_bis_flag = MSC_UTIL.SYS_YES THEN

Line 3466: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGET_LEVELS) OR

3462: end if;
3463: END IF;
3464:
3465: IF ((p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PFMC_MEASURES) OR
3466: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGET_LEVELS) OR
3467: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGETS ) OR
3468: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_BUSINESS_PLANS)) THEN
3469: IF MSC_CL_COLLECTION.v_coll_prec.kpi_bis_flag = MSC_UTIL.SYS_YES THEN
3470: p_is_incremental_refresh := FALSE;

Line 3467: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGETS ) OR

3463: END IF;
3464:
3465: IF ((p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PFMC_MEASURES) OR
3466: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGET_LEVELS) OR
3467: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGETS ) OR
3468: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_BUSINESS_PLANS)) THEN
3469: IF MSC_CL_COLLECTION.v_coll_prec.kpi_bis_flag = MSC_UTIL.SYS_YES THEN
3470: p_is_incremental_refresh := FALSE;
3471: p_is_partial_refresh := TRUE;

Line 3468: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_BUSINESS_PLANS)) THEN

3464:
3465: IF ((p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PFMC_MEASURES) OR
3466: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGET_LEVELS) OR
3467: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGETS ) OR
3468: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_BUSINESS_PLANS)) THEN
3469: IF MSC_CL_COLLECTION.v_coll_prec.kpi_bis_flag = MSC_UTIL.SYS_YES THEN
3470: p_is_incremental_refresh := FALSE;
3471: p_is_partial_refresh := TRUE;
3472: RETURN TRUE;

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

3465: IF ((p_task_num = MSC_CL_COLLECTION.PTASK_BIS_PFMC_MEASURES) OR
3466: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGET_LEVELS) OR
3467: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_TARGETS ) OR
3468: (p_task_num = MSC_CL_COLLECTION.PTASK_BIS_BUSINESS_PLANS)) THEN
3469: IF MSC_CL_COLLECTION.v_coll_prec.kpi_bis_flag = MSC_UTIL.SYS_YES THEN
3470: p_is_incremental_refresh := FALSE;
3471: p_is_partial_refresh := TRUE;
3472: RETURN TRUE;
3473: else

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3524: RETURN FALSE;
3525: end if;
3526: END IF;
3527:
3528: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SOURCING) THEN
3529: if (MSC_CL_COLLECTION.v_coll_prec.sourcing_rule_flag = MSC_UTIL.SYS_YES) then
3530: p_is_incremental_refresh := FALSE;
3531: p_is_partial_refresh := TRUE;
3532: RETURN TRUE;

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

3525: end if;
3526: END IF;
3527:
3528: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SOURCING) THEN
3529: if (MSC_CL_COLLECTION.v_coll_prec.sourcing_rule_flag = MSC_UTIL.SYS_YES) then
3530: p_is_incremental_refresh := FALSE;
3531: p_is_partial_refresh := TRUE;
3532: RETURN TRUE;
3533: else

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

3534: RETURN FALSE;
3535: end if;
3536: END IF;
3537:
3538: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SUB_INVENTORY) THEN
3539: if (MSC_CL_COLLECTION.v_coll_prec.sub_inventory_flag = MSC_UTIL.SYS_YES) then
3540: p_is_incremental_refresh := FALSE;
3541: p_is_partial_refresh := TRUE;
3542: RETURN TRUE;

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

3535: end if;
3536: END IF;
3537:
3538: IF (p_task_num = MSC_CL_COLLECTION.PTASK_SUB_INVENTORY) THEN
3539: if (MSC_CL_COLLECTION.v_coll_prec.sub_inventory_flag = MSC_UTIL.SYS_YES) then
3540: p_is_incremental_refresh := FALSE;
3541: p_is_partial_refresh := TRUE;
3542: RETURN TRUE;
3543: else

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

3544: RETURN FALSE;
3545: end if;
3546: END IF;
3547:
3548: IF (p_task_num = MSC_CL_COLLECTION.PTASK_UNIT_NUMBER) THEN
3549: if (MSC_CL_COLLECTION.v_coll_prec.unit_number_flag = MSC_UTIL.SYS_YES) then
3550: p_is_incremental_refresh := FALSE;
3551: p_is_partial_refresh := TRUE;
3552: RETURN TRUE;

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

3545: end if;
3546: END IF;
3547:
3548: IF (p_task_num = MSC_CL_COLLECTION.PTASK_UNIT_NUMBER) THEN
3549: if (MSC_CL_COLLECTION.v_coll_prec.unit_number_flag = MSC_UTIL.SYS_YES) then
3550: p_is_incremental_refresh := FALSE;
3551: p_is_partial_refresh := TRUE;
3552: RETURN TRUE;
3553: else

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

3554: RETURN FALSE;
3555: end if;
3556: END IF;
3557:
3558: IF (p_task_num = MSC_CL_COLLECTION.PTASK_ITEM_SUBSTITUTES) THEN
3559: if (MSC_CL_COLLECTION.v_coll_prec.item_subst_flag = MSC_UTIL.SYS_YES) then
3560: p_is_incremental_refresh := FALSE;
3561: p_is_partial_refresh := TRUE;
3562: RETURN TRUE;

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

3555: end if;
3556: END IF;
3557:
3558: IF (p_task_num = MSC_CL_COLLECTION.PTASK_ITEM_SUBSTITUTES) THEN
3559: if (MSC_CL_COLLECTION.v_coll_prec.item_subst_flag = MSC_UTIL.SYS_YES) then
3560: p_is_incremental_refresh := FALSE;
3561: p_is_partial_refresh := TRUE;
3562: RETURN TRUE;
3563: else

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

3564: RETURN FALSE;
3565: end if;
3566: END IF;
3567:
3568: IF (p_task_num = MSC_CL_COLLECTION.PTASK_COMPANY_USERS) THEN
3569: if (MSC_CL_COLLECTION.v_coll_prec.user_company_flag = MSC_UTIL.COMPANY_ONLY) OR
3570: (MSC_CL_COLLECTION.v_coll_prec.user_company_flag = MSC_UTIL.USER_AND_COMPANY) then
3571: p_is_incremental_refresh := FALSE;
3572: p_is_partial_refresh := TRUE;

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

3565: end if;
3566: END IF;
3567:
3568: IF (p_task_num = MSC_CL_COLLECTION.PTASK_COMPANY_USERS) THEN
3569: if (MSC_CL_COLLECTION.v_coll_prec.user_company_flag = MSC_UTIL.COMPANY_ONLY) OR
3570: (MSC_CL_COLLECTION.v_coll_prec.user_company_flag = MSC_UTIL.USER_AND_COMPANY) then
3571: p_is_incremental_refresh := FALSE;
3572: p_is_partial_refresh := TRUE;
3573: RETURN TRUE;

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

3566: END IF;
3567:
3568: IF (p_task_num = MSC_CL_COLLECTION.PTASK_COMPANY_USERS) THEN
3569: if (MSC_CL_COLLECTION.v_coll_prec.user_company_flag = MSC_UTIL.COMPANY_ONLY) OR
3570: (MSC_CL_COLLECTION.v_coll_prec.user_company_flag = MSC_UTIL.USER_AND_COMPANY) then
3571: p_is_incremental_refresh := FALSE;
3572: p_is_partial_refresh := TRUE;
3573: RETURN TRUE;
3574: else