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_PULL

Line 121: 'BEGIN MRP_CL_REFRESH_SNAPSHOT.CHECK_ENTITY_CONT_REF_TYPE'||MSC_CL_PULL.v_dblink||'('

117: lv_last_coll_time := p_last_tgt_cont_coll_time;
118: END IF;
119:
120: v_sql_stmt:=
121: 'BEGIN MRP_CL_REFRESH_SNAPSHOT.CHECK_ENTITY_CONT_REF_TYPE'||MSC_CL_PULL.v_dblink||'('
122: ||' p_entity_name => :p_entity_name,'
123: ||' p_entity_lrn => :p_entity_lrn,'
124: ||' entity_flag => :entity_flag,'
125: ||' p_org_str => :p_org_str,'

Line 331: IF (msc_cl_pull.v_is_cont_refresh = MSC_UTIL.SYS_YES) THEN

327:
328:
329: begin
330:
331: IF (msc_cl_pull.v_is_cont_refresh = MSC_UTIL.SYS_YES) THEN
332:
333: IF (MSC_CL_PULL.v_instance_type = MSC_UTIL.G_INS_MIXED) THEN
334:
335: SELECT FND_GLOBAL.APPLICATION_NAME

Line 333: IF (MSC_CL_PULL.v_instance_type = MSC_UTIL.G_INS_MIXED) THEN

329: begin
330:
331: IF (msc_cl_pull.v_is_cont_refresh = MSC_UTIL.SYS_YES) THEN
332:
333: IF (MSC_CL_PULL.v_instance_type = MSC_UTIL.G_INS_MIXED) THEN
334:
335: SELECT FND_GLOBAL.APPLICATION_NAME
336: INTO lv_application_name
337: FROM dual;

Line 445: ELSIF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN

441:
442: IF prec.trip_flag = MSC_UTIL.SYS_YES THEN
443: lv_trip1 := MSC_UTIL.SYS_TGT;
444: END IF;
445: ELSIF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN
446:
447: lv_in_org_str:= MSC_CL_PULL.GET_ORG_STR(p_instance_id,2);
448:
449: select apps_lrn

Line 447: lv_in_org_str:= MSC_CL_PULL.GET_ORG_STR(p_instance_id,2);

443: lv_trip1 := MSC_UTIL.SYS_TGT;
444: END IF;
445: ELSIF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN
446:
447: lv_in_org_str:= MSC_CL_PULL.GET_ORG_STR(p_instance_id,2);
448:
449: select apps_lrn
450: into lv_apps_lrn
451: from msc_apps_instances

Line 786: lv_in_org_str:= MSC_CL_PULL.GET_ORG_STR(p_instance_id,2);

782: end if;
783: END IF ;
784: ELSE --For backward compatbility IF version <121
785: ------ set lv_in_org_str ----------
786: lv_in_org_str:= MSC_CL_PULL.GET_ORG_STR(p_instance_id,2);
787:
788: select apps_lrn
789: into lv_apps_lrn
790: from msc_apps_instances

Line 2710: /* IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN

2706: -- For Future Use only. Time Frequency for Non Snapshot Entities
2707:
2708: p_nosnap_flag := -1;
2709:
2710: /* IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
2711: p_supcap_sn_flag := lv_po_supcap_snrt;
2712:
2713: ELSE -- For 110/107 source , supplier capacity is associated with other setup entities -nosnap_flag
2714: p_supcap_sn_flag := p_nosnap_flag;

Line 2730: IF p_task_num = MSC_CL_PULL.TASK_SUPPLIER_CAPACITY THEN

2726: RETURN BOOLEAN AS
2727:
2728: BEGIN
2729:
2730: IF p_task_num = MSC_CL_PULL.TASK_SUPPLIER_CAPACITY THEN
2731: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
2732: if (prec.supcap_sn_flag = MSC_UTIL.SYS_INCR) then
2733: -- do net-change for this entity
2734: p_cont_lrnn := p_lrnn;

Line 2731: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN

2727:
2728: BEGIN
2729:
2730: IF p_task_num = MSC_CL_PULL.TASK_SUPPLIER_CAPACITY THEN
2731: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
2732: if (prec.supcap_sn_flag = MSC_UTIL.SYS_INCR) then
2733: -- do net-change for this entity
2734: p_cont_lrnn := p_lrnn;
2735: RETURN TRUE;

Line 2756: IF ((p_task_num = MSC_CL_PULL.TASK_BOM) or

2752: end if;
2753: END IF;
2754: END IF;
2755:
2756: IF ((p_task_num = MSC_CL_PULL.TASK_BOM) or
2757: (p_task_num = MSC_CL_PULL.TASK_ROUTING) or
2758: (p_task_num = MSC_CL_PULL.TASK_OPER_NETWORKS) or
2759: (p_task_num = MSC_CL_PULL.TASK_ROUTING_OPERATIONS) or
2760: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RES_SEQS) or

Line 2757: (p_task_num = MSC_CL_PULL.TASK_ROUTING) or

2753: END IF;
2754: END IF;
2755:
2756: IF ((p_task_num = MSC_CL_PULL.TASK_BOM) or
2757: (p_task_num = MSC_CL_PULL.TASK_ROUTING) or
2758: (p_task_num = MSC_CL_PULL.TASK_OPER_NETWORKS) or
2759: (p_task_num = MSC_CL_PULL.TASK_ROUTING_OPERATIONS) or
2760: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RES_SEQS) or
2761: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RESOURCES) or

Line 2758: (p_task_num = MSC_CL_PULL.TASK_OPER_NETWORKS) or

2754: END IF;
2755:
2756: IF ((p_task_num = MSC_CL_PULL.TASK_BOM) or
2757: (p_task_num = MSC_CL_PULL.TASK_ROUTING) or
2758: (p_task_num = MSC_CL_PULL.TASK_OPER_NETWORKS) or
2759: (p_task_num = MSC_CL_PULL.TASK_ROUTING_OPERATIONS) or
2760: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RES_SEQS) or
2761: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RESOURCES) or
2762: (p_task_num = MSC_CL_PULL.TASK_OPERATION_COMPONENTS) or

Line 2759: (p_task_num = MSC_CL_PULL.TASK_ROUTING_OPERATIONS) or

2755:
2756: IF ((p_task_num = MSC_CL_PULL.TASK_BOM) or
2757: (p_task_num = MSC_CL_PULL.TASK_ROUTING) or
2758: (p_task_num = MSC_CL_PULL.TASK_OPER_NETWORKS) or
2759: (p_task_num = MSC_CL_PULL.TASK_ROUTING_OPERATIONS) or
2760: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RES_SEQS) or
2761: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RESOURCES) or
2762: (p_task_num = MSC_CL_PULL.TASK_OPERATION_COMPONENTS) or
2763: (p_task_num = MSC_CL_PULL.TASK_PROCESS_EFFECTIVITY) ) THEN

Line 2760: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RES_SEQS) or

2756: IF ((p_task_num = MSC_CL_PULL.TASK_BOM) or
2757: (p_task_num = MSC_CL_PULL.TASK_ROUTING) or
2758: (p_task_num = MSC_CL_PULL.TASK_OPER_NETWORKS) or
2759: (p_task_num = MSC_CL_PULL.TASK_ROUTING_OPERATIONS) or
2760: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RES_SEQS) or
2761: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RESOURCES) or
2762: (p_task_num = MSC_CL_PULL.TASK_OPERATION_COMPONENTS) or
2763: (p_task_num = MSC_CL_PULL.TASK_PROCESS_EFFECTIVITY) ) THEN
2764: -- LOAD_BOM,

Line 2761: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RESOURCES) or

2757: (p_task_num = MSC_CL_PULL.TASK_ROUTING) or
2758: (p_task_num = MSC_CL_PULL.TASK_OPER_NETWORKS) or
2759: (p_task_num = MSC_CL_PULL.TASK_ROUTING_OPERATIONS) or
2760: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RES_SEQS) or
2761: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RESOURCES) or
2762: (p_task_num = MSC_CL_PULL.TASK_OPERATION_COMPONENTS) or
2763: (p_task_num = MSC_CL_PULL.TASK_PROCESS_EFFECTIVITY) ) THEN
2764: -- LOAD_BOM,
2765: -- LOAD_ROUTING,

Line 2762: (p_task_num = MSC_CL_PULL.TASK_OPERATION_COMPONENTS) or

2758: (p_task_num = MSC_CL_PULL.TASK_OPER_NETWORKS) or
2759: (p_task_num = MSC_CL_PULL.TASK_ROUTING_OPERATIONS) or
2760: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RES_SEQS) or
2761: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RESOURCES) or
2762: (p_task_num = MSC_CL_PULL.TASK_OPERATION_COMPONENTS) or
2763: (p_task_num = MSC_CL_PULL.TASK_PROCESS_EFFECTIVITY) ) THEN
2764: -- LOAD_BOM,
2765: -- LOAD_ROUTING,
2766: -- LOAD_OPER_NETWORKS

Line 2763: (p_task_num = MSC_CL_PULL.TASK_PROCESS_EFFECTIVITY) ) THEN

2759: (p_task_num = MSC_CL_PULL.TASK_ROUTING_OPERATIONS) or
2760: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RES_SEQS) or
2761: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RESOURCES) or
2762: (p_task_num = MSC_CL_PULL.TASK_OPERATION_COMPONENTS) or
2763: (p_task_num = MSC_CL_PULL.TASK_PROCESS_EFFECTIVITY) ) THEN
2764: -- LOAD_BOM,
2765: -- LOAD_ROUTING,
2766: -- LOAD_OPER_NETWORKS
2767: -- LOAD_ROUTING_OPERATIONS

Line 2788: IF ( p_task_num = MSC_CL_PULL.TASK_BOR ) THEN

2784: end if;
2785: END IF;
2786:
2787:
2788: IF ( p_task_num = MSC_CL_PULL.TASK_BOR ) THEN
2789: if (prec.bor_sn_flag = MSC_UTIL.SYS_INCR) then
2790: -- do net-change for this entity
2791: p_cont_lrnn := p_lrnn;
2792: RETURN TRUE;

Line 2803: IF (p_task_num = MSC_CL_PULL.TASK_LOAD_FORECAST) THEN

2799: RETURN FALSE;
2800: end if;
2801: END IF;
2802:
2803: IF (p_task_num = MSC_CL_PULL.TASK_LOAD_FORECAST) THEN
2804: -- both of the ones below will get executed
2805: -- LOAD_FORECASTS
2806: -- LOAD_ITEM_FORECASTS
2807: if (prec.fcst_sn_flag = MSC_UTIL.SYS_INCR) then

Line 2822: IF ((p_task_num = MSC_CL_PULL.TASK_CATEGORY) or

2818: end if;
2819: END IF;
2820:
2821:
2822: IF ((p_task_num = MSC_CL_PULL.TASK_CATEGORY) or
2823: (p_task_num = MSC_CL_PULL.TASK_ITEM1) or
2824: (p_task_num = MSC_CL_PULL.TASK_ITEM2) or
2825: (p_task_num = MSC_CL_PULL.TASK_ITEM3) ) THEN
2826:

Line 2823: (p_task_num = MSC_CL_PULL.TASK_ITEM1) or

2819: END IF;
2820:
2821:
2822: IF ((p_task_num = MSC_CL_PULL.TASK_CATEGORY) or
2823: (p_task_num = MSC_CL_PULL.TASK_ITEM1) or
2824: (p_task_num = MSC_CL_PULL.TASK_ITEM2) or
2825: (p_task_num = MSC_CL_PULL.TASK_ITEM3) ) THEN
2826:
2827: if (prec.item_sn_flag = MSC_UTIL.SYS_INCR) then

Line 2824: (p_task_num = MSC_CL_PULL.TASK_ITEM2) or

2820:
2821:
2822: IF ((p_task_num = MSC_CL_PULL.TASK_CATEGORY) or
2823: (p_task_num = MSC_CL_PULL.TASK_ITEM1) or
2824: (p_task_num = MSC_CL_PULL.TASK_ITEM2) or
2825: (p_task_num = MSC_CL_PULL.TASK_ITEM3) ) THEN
2826:
2827: if (prec.item_sn_flag = MSC_UTIL.SYS_INCR) then
2828: -- do net-change for this entity

Line 2825: (p_task_num = MSC_CL_PULL.TASK_ITEM3) ) THEN

2821:
2822: IF ((p_task_num = MSC_CL_PULL.TASK_CATEGORY) or
2823: (p_task_num = MSC_CL_PULL.TASK_ITEM1) or
2824: (p_task_num = MSC_CL_PULL.TASK_ITEM2) or
2825: (p_task_num = MSC_CL_PULL.TASK_ITEM3) ) THEN
2826:
2827: if (prec.item_sn_flag = MSC_UTIL.SYS_INCR) then
2828: -- do net-change for this entity
2829: p_cont_lrnn := p_lrnn;

Line 2842: IF (p_task_num = MSC_CL_PULL.TASK_MDS_DEMAND) THEN

2838: end if;
2839: END IF;
2840:
2841:
2842: IF (p_task_num = MSC_CL_PULL.TASK_MDS_DEMAND) THEN
2843: if (prec.mds_sn_flag = MSC_UTIL.SYS_INCR) then
2844: -- do net-change for this entity
2845: p_cont_lrnn := p_lrnn;
2846: RETURN TRUE;

Line 2858: IF (p_task_num = MSC_CL_PULL.TASK_MPS_SUPPLY) THEN

2854: end if;
2855: END IF;
2856:
2857:
2858: IF (p_task_num = MSC_CL_PULL.TASK_MPS_SUPPLY) THEN
2859: if (prec.mps_sn_flag = MSC_UTIL.SYS_INCR) then
2860: -- do net-change for this entity
2861: p_cont_lrnn := p_lrnn;
2862: RETURN TRUE;

Line 2873: IF (p_task_num = MSC_CL_PULL.TASK_SCHEDULE) THEN

2869: RETURN FALSE;
2870: end if;
2871: END IF;
2872:
2873: IF (p_task_num = MSC_CL_PULL.TASK_SCHEDULE) THEN
2874: if (prec.mds_sn_flag = MSC_UTIL.SYS_TGT) or (prec.mps_sn_flag = MSC_UTIL.SYS_TGT) THEN
2875: -- do targeted for this entity
2876: p_cont_lrnn := -1;
2877: RETURN TRUE;

Line 2888: IF p_task_num = MSC_CL_PULL.TASK_OH_SUPPLY THEN

2884: RETURN FALSE;
2885: end if;
2886: END IF;
2887:
2888: IF p_task_num = MSC_CL_PULL.TASK_OH_SUPPLY THEN
2889: if (prec.oh_sn_flag = MSC_UTIL.SYS_INCR) then
2890: -- do net-change for this entity
2891: p_cont_lrnn := p_lrnn;
2892: RETURN TRUE;

Line 2905: IF ((p_task_num = MSC_CL_PULL.TASK_PO_SUPPLY) or

2901: END IF;
2902:
2903:
2904: -- IF p_task_num = TASK_PO_SUPPLY THEN
2905: IF ((p_task_num = MSC_CL_PULL.TASK_PO_SUPPLY) or
2906: (p_task_num = MSC_CL_PULL.TASK_PO_PO_SUPPLY) or
2907: (p_task_num = MSC_CL_PULL.TASK_PO_REQ_SUPPLY)) THEN
2908:
2909: if (prec.po_sn_flag = MSC_UTIL.SYS_INCR) then

Line 2906: (p_task_num = MSC_CL_PULL.TASK_PO_PO_SUPPLY) or

2902:
2903:
2904: -- IF p_task_num = TASK_PO_SUPPLY THEN
2905: IF ((p_task_num = MSC_CL_PULL.TASK_PO_SUPPLY) or
2906: (p_task_num = MSC_CL_PULL.TASK_PO_PO_SUPPLY) or
2907: (p_task_num = MSC_CL_PULL.TASK_PO_REQ_SUPPLY)) THEN
2908:
2909: if (prec.po_sn_flag = MSC_UTIL.SYS_INCR) then
2910: -- do net-change for this entity

Line 2907: (p_task_num = MSC_CL_PULL.TASK_PO_REQ_SUPPLY)) THEN

2903:
2904: -- IF p_task_num = TASK_PO_SUPPLY THEN
2905: IF ((p_task_num = MSC_CL_PULL.TASK_PO_SUPPLY) or
2906: (p_task_num = MSC_CL_PULL.TASK_PO_PO_SUPPLY) or
2907: (p_task_num = MSC_CL_PULL.TASK_PO_REQ_SUPPLY)) THEN
2908:
2909: if (prec.po_sn_flag = MSC_UTIL.SYS_INCR) then
2910: -- do net-change for this entity
2911: p_cont_lrnn := p_lrnn;

Line 2924: IF p_task_num in (MSC_CL_PULL.TASK_SALES_ORDER1,MSC_CL_PULL.TASK_SALES_ORDER2,MSC_CL_PULL.TASK_SALES_ORDER3,MSC_CL_PULL.TASK_AHL) THEN

2920: end if;
2921: END IF;
2922:
2923:
2924: IF p_task_num in (MSC_CL_PULL.TASK_SALES_ORDER1,MSC_CL_PULL.TASK_SALES_ORDER2,MSC_CL_PULL.TASK_SALES_ORDER3,MSC_CL_PULL.TASK_AHL) THEN
2925: if (prec.so_sn_flag = MSC_UTIL.SYS_INCR) then
2926: -- do net-change for this entity
2927: p_cont_lrnn := p_lrnn;
2928: RETURN TRUE;

Line 2940: IF ((p_task_num = MSC_CL_PULL.TASK_USER_SUPPLY) OR (p_task_num = MSC_CL_PULL.TASK_USER_DEMAND)) THEN

2936: end if;
2937: END IF;
2938:
2939:
2940: IF ((p_task_num = MSC_CL_PULL.TASK_USER_SUPPLY) OR (p_task_num = MSC_CL_PULL.TASK_USER_DEMAND)) THEN
2941: if (prec.usup_sn_flag = MSC_UTIL.SYS_INCR) then
2942: -- do net-change for this entity
2943: p_cont_lrnn := p_lrnn;
2944: RETURN TRUE;

Line 2958: IF ( (p_task_num = MSC_CL_PULL.TASK_WIP_SUPPLY) OR

2954:
2955:
2956: -- FOR LOAD_WIP_SUPPLY
2957: -- FOR LOAD_WIP_DEMAND
2958: IF ( (p_task_num = MSC_CL_PULL.TASK_WIP_SUPPLY) OR
2959: (p_task_num = MSC_CL_PULL.TASK_WIP_DEMAND) ) THEN
2960: if (prec.wip_sn_flag = MSC_UTIL.SYS_INCR) then
2961: -- do net-change for this entity
2962: p_cont_lrnn := p_lrnn;

Line 2959: (p_task_num = MSC_CL_PULL.TASK_WIP_DEMAND) ) THEN

2955:
2956: -- FOR LOAD_WIP_SUPPLY
2957: -- FOR LOAD_WIP_DEMAND
2958: IF ( (p_task_num = MSC_CL_PULL.TASK_WIP_SUPPLY) OR
2959: (p_task_num = MSC_CL_PULL.TASK_WIP_DEMAND) ) THEN
2960: if (prec.wip_sn_flag = MSC_UTIL.SYS_INCR) then
2961: -- do net-change for this entity
2962: p_cont_lrnn := p_lrnn;
2963: RETURN TRUE;

Line 2974: IF (p_task_num = MSC_CL_PULL.TASK_RESOURCE) THEN

2970: RETURN FALSE;
2971: end if;
2972: END IF;
2973:
2974: IF (p_task_num = MSC_CL_PULL.TASK_RESOURCE) THEN
2975: if ( (prec.bom_sn_flag = MSC_UTIL.SYS_TGT) or (prec.wip_sn_flag = MSC_UTIL.SYS_TGT) ) then
2976: -- do targeted for this entity
2977: p_cont_lrnn := -1;
2978: RETURN TRUE;

Line 2990: IF (p_task_num = MSC_CL_PULL.TASK_RESOURCE_INSTANCE) THEN

2986: end if;
2987: END IF;
2988:
2989: /* ds change start */
2990: IF (p_task_num = MSC_CL_PULL.TASK_RESOURCE_INSTANCE) THEN
2991: if ( (prec.bom_sn_flag = MSC_UTIL.SYS_TGT) or (prec.wip_sn_flag = MSC_UTIL.SYS_TGT) ) then
2992: -- do targeted for this entity
2993: p_cont_lrnn := -1;
2994: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'TASK_RESOURCE_INSTANCE is targetted ');

Line 3007: IF (p_task_num = MSC_CL_PULL.TASK_RESOURCE_SETUP) THEN

3003: RETURN FALSE;
3004: end if;
3005: END IF;
3006:
3007: IF (p_task_num = MSC_CL_PULL.TASK_RESOURCE_SETUP) THEN
3008: IF (prec.bom_sn_flag = MSC_UTIL.SYS_TGT) THEN
3009: p_cont_lrnn := -1;
3010: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'TASK_RESOURCE_SETUP is targetted ');
3011: RETURN TRUE;

Line 3019: IF (p_task_num = MSC_CL_PULL.TASK_ATP_RULES) THEN

3015: END IF;
3016:
3017: /* ds change end */
3018:
3019: IF (p_task_num = MSC_CL_PULL.TASK_ATP_RULES) THEN
3020: IF (prec.atp_rules_flag = MSC_UTIL.SYS_YES) THEN
3021: p_cont_lrnn := -1;
3022: RETURN TRUE;
3023: ELSE

Line 3028: IF ( p_task_num = MSC_CL_PULL.TASK_CALENDAR_DATE ) THEN

3024: RETURN FALSE;
3025: END IF;
3026: END IF;
3027:
3028: IF ( p_task_num = MSC_CL_PULL.TASK_CALENDAR_DATE ) THEN
3029: IF prec.calendar_flag = MSC_UTIL.SYS_YES THEN
3030: p_cont_lrnn := -1;
3031: RETURN TRUE;
3032: else

Line 3037: IF ( p_task_num = MSC_CL_PULL.TASK_DEMAND_CLASS ) THEN

3033: RETURN FALSE;
3034: end if;
3035: END IF;
3036:
3037: IF ( p_task_num = MSC_CL_PULL.TASK_DEMAND_CLASS ) THEN
3038: IF prec.demand_class_flag = MSC_UTIL.SYS_YES THEN
3039: p_cont_lrnn := -1;
3040: RETURN TRUE;
3041: else

Line 3046: IF ( p_task_num = MSC_CL_PULL.TASK_BIS ) THEN

3042: RETURN FALSE;
3043: end if;
3044: END IF;
3045:
3046: IF ( p_task_num = MSC_CL_PULL.TASK_BIS ) THEN
3047: IF prec.kpi_bis_flag = MSC_UTIL.SYS_YES THEN
3048: p_cont_lrnn := -1;
3049: RETURN TRUE;
3050: else

Line 3055: IF ( p_task_num = MSC_CL_PULL.TASK_PARAMETER ) THEN

3051: RETURN FALSE;
3052: end if;
3053: END IF;
3054:
3055: IF ( p_task_num = MSC_CL_PULL.TASK_PARAMETER ) THEN
3056: IF prec.parameter_flag = MSC_UTIL.SYS_YES THEN
3057: p_cont_lrnn := -1;
3058: RETURN TRUE;
3059: else

Line 3064: IF ( p_task_num = MSC_CL_PULL.TASK_PLANNERS ) THEN

3060: RETURN FALSE;
3061: end if;
3062: END IF;
3063:
3064: IF ( p_task_num = MSC_CL_PULL.TASK_PLANNERS ) THEN
3065: IF prec.planner_flag = MSC_UTIL.SYS_YES THEN
3066: p_cont_lrnn := -1;
3067: RETURN TRUE;
3068: else

Line 3073: IF ( p_task_num = MSC_CL_PULL.TASK_PROJECT ) THEN

3069: RETURN FALSE;
3070: end if;
3071: END IF;
3072:
3073: IF ( p_task_num = MSC_CL_PULL.TASK_PROJECT ) THEN
3074: IF prec.project_flag = MSC_UTIL.SYS_YES THEN
3075: p_cont_lrnn := -1;
3076: RETURN TRUE;
3077: else

Line 3082: IF ( p_task_num = MSC_CL_PULL.TASK_HARD_RESERVATION ) THEN

3078: RETURN FALSE;
3079: end if;
3080: END IF;
3081:
3082: IF ( p_task_num = MSC_CL_PULL.TASK_HARD_RESERVATION ) THEN
3083: IF prec.reserves_flag = MSC_UTIL.SYS_YES THEN
3084: p_cont_lrnn := -1;
3085: RETURN TRUE;
3086: else

Line 3091: IF ( p_task_num = MSC_CL_PULL.TASK_SAFETY_STOCK ) THEN

3087: RETURN FALSE;
3088: end if;
3089: END IF;
3090:
3091: IF ( p_task_num = MSC_CL_PULL.TASK_SAFETY_STOCK ) THEN
3092: IF prec.saf_stock_flag = MSC_UTIL.SYS_YES THEN
3093: p_cont_lrnn := -1;
3094: RETURN TRUE;
3095: else

Line 3100: IF ( p_task_num = MSC_CL_PULL.TASK_SOURCING ) THEN

3096: RETURN FALSE;
3097: end if;
3098: END IF;
3099:
3100: IF ( p_task_num = MSC_CL_PULL.TASK_SOURCING ) THEN
3101: IF prec.sourcing_rule_flag = MSC_UTIL.SYS_YES THEN
3102: p_cont_lrnn := -1;
3103: RETURN TRUE;
3104: else

Line 3109: IF ( p_task_num = MSC_CL_PULL.TASK_SUB_INVENTORY ) THEN

3105: RETURN FALSE;
3106: end if;
3107: END IF;
3108:
3109: IF ( p_task_num = MSC_CL_PULL.TASK_SUB_INVENTORY ) THEN
3110: IF prec.sub_inventory_flag = MSC_UTIL.SYS_YES THEN
3111: p_cont_lrnn := -1;
3112: RETURN TRUE;
3113: else

Line 3118: IF (p_task_num = MSC_CL_PULL.TASK_TRADING_PARTNER) OR (p_task_num = MSC_CL_PULL.TASK_BUYER_CONTACT) THEN

3114: RETURN FALSE;
3115: end if;
3116: END IF;
3117:
3118: IF (p_task_num = MSC_CL_PULL.TASK_TRADING_PARTNER) OR (p_task_num = MSC_CL_PULL.TASK_BUYER_CONTACT) THEN
3119: IF (prec.tp_customer_flag = MSC_UTIL.SYS_YES ) OR (prec.tp_vendor_flag = MSC_UTIL.SYS_YES) THEN
3120: p_cont_lrnn := -1;
3121: RETURN TRUE;
3122: else

Line 3127: IF ( p_task_num = MSC_CL_PULL.TASK_UNIT_NUMBER ) THEN

3123: RETURN FALSE;
3124: end if;
3125: END IF;
3126:
3127: IF ( p_task_num = MSC_CL_PULL.TASK_UNIT_NUMBER ) THEN
3128: IF prec.unit_number_flag = MSC_UTIL.SYS_YES THEN
3129: p_cont_lrnn := -1;
3130: RETURN TRUE;
3131: else

Line 3136: IF ( p_task_num = MSC_CL_PULL.TASK_UOM ) THEN

3132: RETURN FALSE;
3133: end if;
3134: END IF;
3135:
3136: IF ( p_task_num = MSC_CL_PULL.TASK_UOM ) THEN
3137: IF prec.uom_flag = MSC_UTIL.SYS_YES THEN
3138: p_cont_lrnn := -1;
3139: RETURN TRUE;
3140: else

Line 3145: IF ( p_task_num = MSC_CL_PULL.TASK_ITEM_SUBSTITUTES ) THEN

3141: RETURN FALSE;
3142: end if;
3143: END IF;
3144:
3145: IF ( p_task_num = MSC_CL_PULL.TASK_ITEM_SUBSTITUTES ) THEN
3146: IF prec.item_subst_flag = MSC_UTIL.SYS_YES THEN
3147: p_cont_lrnn := -1;
3148: RETURN TRUE;
3149: else

Line 3154: IF ( p_task_num = MSC_CL_PULL.TASK_USER_COMPANY ) THEN

3150: RETURN FALSE;
3151: end if;
3152: END IF;
3153:
3154: IF ( p_task_num = MSC_CL_PULL.TASK_USER_COMPANY ) THEN
3155: IF (prec.user_company_flag = 2) OR (prec.user_company_flag = 3) THEN
3156: p_cont_lrnn := -1;
3157: RETURN TRUE;
3158: else

Line 3164: IF ( p_task_num = MSC_CL_PULL.TASK_SUPPLIER_RESPONSE ) THEN

3160: end if;
3161: END IF;
3162:
3163: /* CP-AUTO */
3164: IF ( p_task_num = MSC_CL_PULL.TASK_SUPPLIER_RESPONSE ) THEN
3165:
3166: if (prec.suprep_sn_flag = MSC_UTIL.SYS_INCR) then
3167: -- do net-change for this entity
3168: p_cont_lrnn := p_lrnn;

Line 3182: IF ( p_task_num = MSC_CL_PULL.TASK_TRIP ) THEN

3178: RETURN FALSE;
3179: end if;
3180: END IF;
3181:
3182: IF ( p_task_num = MSC_CL_PULL.TASK_TRIP ) THEN
3183: if (prec.trip_sn_flag = MSC_UTIL.SYS_INCR) then
3184: -- do net-change for this entity
3185: p_cont_lrnn := p_lrnn;
3186: RETURN TRUE;