DBA Data[Home] [Help]

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 332: IF (msc_cl_pull.v_is_cont_refresh = MSC_UTIL.SYS_YES) THEN

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

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

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

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

441: IF prec.trip_flag = MSC_UTIL.SYS_YES THEN
442: p_trip_sn_flag := MSC_UTIL.SYS_TGT;
443: END IF;
444:
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: END IF;
444:
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 793: lv_in_org_str:= MSC_CL_PULL.GET_ORG_STR(p_instance_id,2);

789: end if;
790: END IF ;
791: ELSE --For backward compatbility IF version <121
792: ------ set lv_in_org_str ----------
793: lv_in_org_str:= MSC_CL_PULL.GET_ORG_STR(p_instance_id,2);
794:
795: select apps_lrn
796: into lv_apps_lrn
797: from msc_apps_instances

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

2746: -- For Future Use only. Time Frequency for Non Snapshot Entities
2747:
2748: p_nosnap_flag := -1;
2749:
2750: /* IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
2751: p_supcap_sn_flag := lv_po_supcap_snrt;
2752:
2753: ELSE -- For 110/107 source , supplier capacity is associated with other setup entities -nosnap_flag
2754: p_supcap_sn_flag := p_nosnap_flag;

Line 2771: IF p_task_num = MSC_CL_PULL.TASK_SUPPLIER_CAPACITY THEN

2767: RETURN BOOLEAN AS
2768:
2769: BEGIN
2770:
2771: IF p_task_num = MSC_CL_PULL.TASK_SUPPLIER_CAPACITY THEN
2772: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
2773: if (prec.supcap_sn_flag = MSC_UTIL.SYS_INCR) then
2774: -- do net-change for this entity
2775: p_cont_lrnn := p_lrnn;

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

2768:
2769: BEGIN
2770:
2771: IF p_task_num = MSC_CL_PULL.TASK_SUPPLIER_CAPACITY THEN
2772: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
2773: if (prec.supcap_sn_flag = MSC_UTIL.SYS_INCR) then
2774: -- do net-change for this entity
2775: p_cont_lrnn := p_lrnn;
2776: RETURN TRUE;

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

2793: end if;
2794: END IF;
2795: END IF;
2796:
2797: IF ((p_task_num = MSC_CL_PULL.TASK_BOM) or
2798: (p_task_num = MSC_CL_PULL.TASK_ROUTING) or
2799: (p_task_num = MSC_CL_PULL.TASK_OPER_NETWORKS) or
2800: (p_task_num = MSC_CL_PULL.TASK_ROUTING_OPERATIONS) or
2801: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RES_SEQS) or

Line 2798: (p_task_num = MSC_CL_PULL.TASK_ROUTING) or

2794: END IF;
2795: END IF;
2796:
2797: IF ((p_task_num = MSC_CL_PULL.TASK_BOM) or
2798: (p_task_num = MSC_CL_PULL.TASK_ROUTING) or
2799: (p_task_num = MSC_CL_PULL.TASK_OPER_NETWORKS) or
2800: (p_task_num = MSC_CL_PULL.TASK_ROUTING_OPERATIONS) or
2801: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RES_SEQS) or
2802: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RESOURCES) or

Line 2799: (p_task_num = MSC_CL_PULL.TASK_OPER_NETWORKS) or

2795: END IF;
2796:
2797: IF ((p_task_num = MSC_CL_PULL.TASK_BOM) or
2798: (p_task_num = MSC_CL_PULL.TASK_ROUTING) or
2799: (p_task_num = MSC_CL_PULL.TASK_OPER_NETWORKS) or
2800: (p_task_num = MSC_CL_PULL.TASK_ROUTING_OPERATIONS) or
2801: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RES_SEQS) or
2802: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RESOURCES) or
2803: (p_task_num = MSC_CL_PULL.TASK_OPERATION_COMPONENTS) or

Line 2800: (p_task_num = MSC_CL_PULL.TASK_ROUTING_OPERATIONS) or

2796:
2797: IF ((p_task_num = MSC_CL_PULL.TASK_BOM) or
2798: (p_task_num = MSC_CL_PULL.TASK_ROUTING) or
2799: (p_task_num = MSC_CL_PULL.TASK_OPER_NETWORKS) or
2800: (p_task_num = MSC_CL_PULL.TASK_ROUTING_OPERATIONS) or
2801: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RES_SEQS) or
2802: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RESOURCES) or
2803: (p_task_num = MSC_CL_PULL.TASK_OPERATION_COMPONENTS) or
2804: (p_task_num = MSC_CL_PULL.TASK_PROCESS_EFFECTIVITY) ) THEN

Line 2801: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RES_SEQS) or

2797: IF ((p_task_num = MSC_CL_PULL.TASK_BOM) or
2798: (p_task_num = MSC_CL_PULL.TASK_ROUTING) or
2799: (p_task_num = MSC_CL_PULL.TASK_OPER_NETWORKS) or
2800: (p_task_num = MSC_CL_PULL.TASK_ROUTING_OPERATIONS) or
2801: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RES_SEQS) or
2802: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RESOURCES) or
2803: (p_task_num = MSC_CL_PULL.TASK_OPERATION_COMPONENTS) or
2804: (p_task_num = MSC_CL_PULL.TASK_PROCESS_EFFECTIVITY) ) THEN
2805: -- LOAD_BOM,

Line 2802: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RESOURCES) or

2798: (p_task_num = MSC_CL_PULL.TASK_ROUTING) or
2799: (p_task_num = MSC_CL_PULL.TASK_OPER_NETWORKS) or
2800: (p_task_num = MSC_CL_PULL.TASK_ROUTING_OPERATIONS) or
2801: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RES_SEQS) or
2802: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RESOURCES) or
2803: (p_task_num = MSC_CL_PULL.TASK_OPERATION_COMPONENTS) or
2804: (p_task_num = MSC_CL_PULL.TASK_PROCESS_EFFECTIVITY) ) THEN
2805: -- LOAD_BOM,
2806: -- LOAD_ROUTING,

Line 2803: (p_task_num = MSC_CL_PULL.TASK_OPERATION_COMPONENTS) or

2799: (p_task_num = MSC_CL_PULL.TASK_OPER_NETWORKS) or
2800: (p_task_num = MSC_CL_PULL.TASK_ROUTING_OPERATIONS) or
2801: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RES_SEQS) or
2802: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RESOURCES) or
2803: (p_task_num = MSC_CL_PULL.TASK_OPERATION_COMPONENTS) or
2804: (p_task_num = MSC_CL_PULL.TASK_PROCESS_EFFECTIVITY) ) THEN
2805: -- LOAD_BOM,
2806: -- LOAD_ROUTING,
2807: -- LOAD_OPER_NETWORKS

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

2800: (p_task_num = MSC_CL_PULL.TASK_ROUTING_OPERATIONS) or
2801: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RES_SEQS) or
2802: (p_task_num = MSC_CL_PULL.TASK_OPERATION_RESOURCES) or
2803: (p_task_num = MSC_CL_PULL.TASK_OPERATION_COMPONENTS) or
2804: (p_task_num = MSC_CL_PULL.TASK_PROCESS_EFFECTIVITY) ) THEN
2805: -- LOAD_BOM,
2806: -- LOAD_ROUTING,
2807: -- LOAD_OPER_NETWORKS
2808: -- LOAD_ROUTING_OPERATIONS

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

2825: end if;
2826: END IF;
2827:
2828:
2829: IF ( p_task_num = MSC_CL_PULL.TASK_BOR ) THEN
2830: if (prec.bor_sn_flag = MSC_UTIL.SYS_INCR) then
2831: -- do net-change for this entity
2832: p_cont_lrnn := p_lrnn;
2833: RETURN TRUE;

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

2840: RETURN FALSE;
2841: end if;
2842: END IF;
2843:
2844: IF (p_task_num = MSC_CL_PULL.TASK_LOAD_FORECAST) THEN
2845: -- both of the ones below will get executed
2846: -- LOAD_FORECASTS
2847: -- LOAD_ITEM_FORECASTS
2848: if (prec.fcst_sn_flag = MSC_UTIL.SYS_INCR) then

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

2859: end if;
2860: END IF;
2861:
2862:
2863: IF ((p_task_num = MSC_CL_PULL.TASK_CATEGORY) or
2864: (p_task_num = MSC_CL_PULL.TASK_ITEM1) or
2865: (p_task_num = MSC_CL_PULL.TASK_ITEM2) or
2866: (p_task_num = MSC_CL_PULL.TASK_ITEM3) ) THEN
2867:

Line 2864: (p_task_num = MSC_CL_PULL.TASK_ITEM1) or

2860: END IF;
2861:
2862:
2863: IF ((p_task_num = MSC_CL_PULL.TASK_CATEGORY) or
2864: (p_task_num = MSC_CL_PULL.TASK_ITEM1) or
2865: (p_task_num = MSC_CL_PULL.TASK_ITEM2) or
2866: (p_task_num = MSC_CL_PULL.TASK_ITEM3) ) THEN
2867:
2868: if (prec.item_sn_flag = MSC_UTIL.SYS_INCR) then

Line 2865: (p_task_num = MSC_CL_PULL.TASK_ITEM2) or

2861:
2862:
2863: IF ((p_task_num = MSC_CL_PULL.TASK_CATEGORY) or
2864: (p_task_num = MSC_CL_PULL.TASK_ITEM1) or
2865: (p_task_num = MSC_CL_PULL.TASK_ITEM2) or
2866: (p_task_num = MSC_CL_PULL.TASK_ITEM3) ) THEN
2867:
2868: if (prec.item_sn_flag = MSC_UTIL.SYS_INCR) then
2869: -- do net-change for this entity

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

2862:
2863: IF ((p_task_num = MSC_CL_PULL.TASK_CATEGORY) or
2864: (p_task_num = MSC_CL_PULL.TASK_ITEM1) or
2865: (p_task_num = MSC_CL_PULL.TASK_ITEM2) or
2866: (p_task_num = MSC_CL_PULL.TASK_ITEM3) ) THEN
2867:
2868: if (prec.item_sn_flag = MSC_UTIL.SYS_INCR) then
2869: -- do net-change for this entity
2870: p_cont_lrnn := p_lrnn;

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

2879: end if;
2880: END IF;
2881:
2882:
2883: IF (p_task_num = MSC_CL_PULL.TASK_MDS_DEMAND) THEN
2884: if (prec.mds_sn_flag = MSC_UTIL.SYS_INCR) then
2885: -- do net-change for this entity
2886: p_cont_lrnn := p_lrnn;
2887: RETURN TRUE;

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

2895: end if;
2896: END IF;
2897:
2898:
2899: IF (p_task_num = MSC_CL_PULL.TASK_MPS_SUPPLY) THEN
2900: if (prec.mps_sn_flag = MSC_UTIL.SYS_INCR) then
2901: -- do net-change for this entity
2902: p_cont_lrnn := p_lrnn;
2903: RETURN TRUE;

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

2910: RETURN FALSE;
2911: end if;
2912: END IF;
2913:
2914: IF (p_task_num = MSC_CL_PULL.TASK_SCHEDULE) THEN
2915: if (prec.mds_sn_flag = MSC_UTIL.SYS_TGT) or (prec.mps_sn_flag = MSC_UTIL.SYS_TGT) THEN
2916: -- do targeted for this entity
2917: p_cont_lrnn := -1;
2918: RETURN TRUE;

Line 2929: IF p_task_num = MSC_CL_PULL.TASK_OH_SUPPLY THEN

2925: RETURN FALSE;
2926: end if;
2927: END IF;
2928:
2929: IF p_task_num = MSC_CL_PULL.TASK_OH_SUPPLY THEN
2930: if (prec.oh_sn_flag = MSC_UTIL.SYS_INCR) then
2931: -- do net-change for this entity
2932: p_cont_lrnn := p_lrnn;
2933: RETURN TRUE;

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

2942: END IF;
2943:
2944:
2945: -- IF p_task_num = TASK_PO_SUPPLY THEN
2946: IF ((p_task_num = MSC_CL_PULL.TASK_PO_SUPPLY) or
2947: (p_task_num = MSC_CL_PULL.TASK_PO_PO_SUPPLY) or
2948: (p_task_num = MSC_CL_PULL.TASK_PO_REQ_SUPPLY)) THEN
2949:
2950: if (prec.po_sn_flag = MSC_UTIL.SYS_INCR) then

Line 2947: (p_task_num = MSC_CL_PULL.TASK_PO_PO_SUPPLY) or

2943:
2944:
2945: -- IF p_task_num = TASK_PO_SUPPLY THEN
2946: IF ((p_task_num = MSC_CL_PULL.TASK_PO_SUPPLY) or
2947: (p_task_num = MSC_CL_PULL.TASK_PO_PO_SUPPLY) or
2948: (p_task_num = MSC_CL_PULL.TASK_PO_REQ_SUPPLY)) THEN
2949:
2950: if (prec.po_sn_flag = MSC_UTIL.SYS_INCR) then
2951: -- do net-change for this entity

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

2944:
2945: -- IF p_task_num = TASK_PO_SUPPLY THEN
2946: IF ((p_task_num = MSC_CL_PULL.TASK_PO_SUPPLY) or
2947: (p_task_num = MSC_CL_PULL.TASK_PO_PO_SUPPLY) or
2948: (p_task_num = MSC_CL_PULL.TASK_PO_REQ_SUPPLY)) THEN
2949:
2950: if (prec.po_sn_flag = MSC_UTIL.SYS_INCR) then
2951: -- do net-change for this entity
2952: p_cont_lrnn := p_lrnn;

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

2961: end if;
2962: END IF;
2963:
2964:
2965: 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
2966: if (prec.so_sn_flag = MSC_UTIL.SYS_INCR) then
2967: -- do net-change for this entity
2968: p_cont_lrnn := p_lrnn;
2969: RETURN TRUE;

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

2977: end if;
2978: END IF;
2979:
2980:
2981: IF ((p_task_num = MSC_CL_PULL.TASK_USER_SUPPLY) OR (p_task_num = MSC_CL_PULL.TASK_USER_DEMAND)) THEN
2982: if (prec.usup_sn_flag = MSC_UTIL.SYS_INCR) then
2983: -- do net-change for this entity
2984: p_cont_lrnn := p_lrnn;
2985: RETURN TRUE;

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

2995:
2996:
2997: -- FOR LOAD_WIP_SUPPLY
2998: -- FOR LOAD_WIP_DEMAND
2999: IF ( (p_task_num = MSC_CL_PULL.TASK_WIP_SUPPLY) OR
3000: (p_task_num = MSC_CL_PULL.TASK_WIP_DEMAND) ) THEN
3001: if (prec.wip_sn_flag = MSC_UTIL.SYS_INCR) then
3002: -- do net-change for this entity
3003: p_cont_lrnn := p_lrnn;

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

2996:
2997: -- FOR LOAD_WIP_SUPPLY
2998: -- FOR LOAD_WIP_DEMAND
2999: IF ( (p_task_num = MSC_CL_PULL.TASK_WIP_SUPPLY) OR
3000: (p_task_num = MSC_CL_PULL.TASK_WIP_DEMAND) ) THEN
3001: if (prec.wip_sn_flag = MSC_UTIL.SYS_INCR) then
3002: -- do net-change for this entity
3003: p_cont_lrnn := p_lrnn;
3004: RETURN TRUE;

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

3011: RETURN FALSE;
3012: end if;
3013: END IF;
3014:
3015: IF (p_task_num = MSC_CL_PULL.TASK_RESOURCE) THEN
3016: if ( (prec.bom_sn_flag = MSC_UTIL.SYS_TGT) or (prec.wip_sn_flag = MSC_UTIL.SYS_TGT) ) then
3017: -- do targeted for this entity
3018: p_cont_lrnn := -1;
3019: RETURN TRUE;

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

3027: end if;
3028: END IF;
3029:
3030: /* ds change start */
3031: IF (p_task_num = MSC_CL_PULL.TASK_RESOURCE_INSTANCE) THEN
3032: if ( (prec.bom_sn_flag = MSC_UTIL.SYS_TGT) or (prec.wip_sn_flag = MSC_UTIL.SYS_TGT) ) then
3033: -- do targeted for this entity
3034: p_cont_lrnn := -1;
3035: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'TASK_RESOURCE_INSTANCE is targetted ');

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

3044: RETURN FALSE;
3045: end if;
3046: END IF;
3047:
3048: IF (p_task_num = MSC_CL_PULL.TASK_RESOURCE_SETUP) THEN
3049: IF (prec.bom_sn_flag = MSC_UTIL.SYS_TGT) THEN
3050: p_cont_lrnn := -1;
3051: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'TASK_RESOURCE_SETUP is targetted ');
3052: RETURN TRUE;

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

3056: END IF;
3057:
3058: /* ds change end */
3059:
3060: IF (p_task_num = MSC_CL_PULL.TASK_ATP_RULES) THEN
3061: IF (prec.atp_rules_flag = MSC_UTIL.SYS_YES) THEN
3062: p_cont_lrnn := -1;
3063: RETURN TRUE;
3064: ELSE

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

3065: RETURN FALSE;
3066: END IF;
3067: END IF;
3068:
3069: IF ( p_task_num = MSC_CL_PULL.TASK_CALENDAR_DATE ) THEN
3070: IF prec.calendar_flag = MSC_UTIL.SYS_YES THEN
3071: p_cont_lrnn := -1;
3072: RETURN TRUE;
3073: else

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

3074: RETURN FALSE;
3075: end if;
3076: END IF;
3077:
3078: IF ( p_task_num = MSC_CL_PULL.TASK_DEMAND_CLASS ) THEN
3079: IF prec.demand_class_flag = MSC_UTIL.SYS_YES THEN
3080: p_cont_lrnn := -1;
3081: RETURN TRUE;
3082: else

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

3083: RETURN FALSE;
3084: end if;
3085: END IF;
3086:
3087: IF ( p_task_num = MSC_CL_PULL.TASK_BIS ) THEN
3088: IF prec.kpi_bis_flag = MSC_UTIL.SYS_YES THEN
3089: p_cont_lrnn := -1;
3090: RETURN TRUE;
3091: else

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

3092: RETURN FALSE;
3093: end if;
3094: END IF;
3095:
3096: IF ( p_task_num = MSC_CL_PULL.TASK_PARAMETER ) THEN
3097: IF prec.parameter_flag = MSC_UTIL.SYS_YES THEN
3098: p_cont_lrnn := -1;
3099: RETURN TRUE;
3100: else

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

3101: RETURN FALSE;
3102: end if;
3103: END IF;
3104:
3105: IF ( p_task_num = MSC_CL_PULL.TASK_PLANNERS ) THEN
3106: IF prec.planner_flag = MSC_UTIL.SYS_YES THEN
3107: p_cont_lrnn := -1;
3108: RETURN TRUE;
3109: else

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

3110: RETURN FALSE;
3111: end if;
3112: END IF;
3113:
3114: IF ( p_task_num = MSC_CL_PULL.TASK_PROJECT ) THEN
3115: IF prec.project_flag = MSC_UTIL.SYS_YES THEN
3116: p_cont_lrnn := -1;
3117: RETURN TRUE;
3118: else

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

3119: RETURN FALSE;
3120: end if;
3121: END IF;
3122:
3123: IF ( p_task_num = MSC_CL_PULL.TASK_HARD_RESERVATION ) THEN
3124: IF prec.reserves_flag = MSC_UTIL.SYS_YES THEN
3125: p_cont_lrnn := -1;
3126: RETURN TRUE;
3127: else

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

3128: RETURN FALSE;
3129: end if;
3130: END IF;
3131:
3132: IF ( p_task_num = MSC_CL_PULL.TASK_SAFETY_STOCK ) THEN
3133: IF prec.saf_stock_flag = MSC_UTIL.SYS_YES THEN
3134: p_cont_lrnn := -1;
3135: RETURN TRUE;
3136: else

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

3137: RETURN FALSE;
3138: end if;
3139: END IF;
3140:
3141: IF ( p_task_num = MSC_CL_PULL.TASK_SOURCING ) THEN
3142: IF prec.sourcing_rule_flag = MSC_UTIL.SYS_YES THEN
3143: p_cont_lrnn := -1;
3144: RETURN TRUE;
3145: else

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

3146: RETURN FALSE;
3147: end if;
3148: END IF;
3149:
3150: IF ( p_task_num = MSC_CL_PULL.TASK_SUB_INVENTORY ) THEN
3151: IF prec.sub_inventory_flag = MSC_UTIL.SYS_YES THEN
3152: p_cont_lrnn := -1;
3153: RETURN TRUE;
3154: else

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

3155: RETURN FALSE;
3156: end if;
3157: END IF;
3158:
3159: IF (p_task_num = MSC_CL_PULL.TASK_TRADING_PARTNER) OR (p_task_num = MSC_CL_PULL.TASK_BUYER_CONTACT) THEN
3160: IF (prec.tp_customer_flag = MSC_UTIL.SYS_YES ) OR (prec.tp_vendor_flag = MSC_UTIL.SYS_YES) THEN
3161: p_cont_lrnn := -1;
3162: RETURN TRUE;
3163: else

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

3164: RETURN FALSE;
3165: end if;
3166: END IF;
3167:
3168: IF ( p_task_num = MSC_CL_PULL.TASK_UNIT_NUMBER ) THEN
3169: IF prec.unit_number_flag = MSC_UTIL.SYS_YES THEN
3170: p_cont_lrnn := -1;
3171: RETURN TRUE;
3172: else

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

3173: RETURN FALSE;
3174: end if;
3175: END IF;
3176:
3177: IF ( p_task_num = MSC_CL_PULL.TASK_UOM ) THEN
3178: IF prec.uom_flag = MSC_UTIL.SYS_YES THEN
3179: p_cont_lrnn := -1;
3180: RETURN TRUE;
3181: else

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

3182: RETURN FALSE;
3183: end if;
3184: END IF;
3185:
3186: IF ( p_task_num = MSC_CL_PULL.TASK_ITEM_SUBSTITUTES ) THEN
3187: IF prec.item_subst_flag = MSC_UTIL.SYS_YES THEN
3188: p_cont_lrnn := -1;
3189: RETURN TRUE;
3190: else

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

3191: RETURN FALSE;
3192: end if;
3193: END IF;
3194:
3195: IF ( p_task_num = MSC_CL_PULL.TASK_USER_COMPANY ) THEN
3196: IF (prec.user_company_flag = 2) OR (prec.user_company_flag = 3) THEN
3197: p_cont_lrnn := -1;
3198: RETURN TRUE;
3199: else

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

3201: end if;
3202: END IF;
3203:
3204: /* CP-AUTO */
3205: IF ( p_task_num = MSC_CL_PULL.TASK_SUPPLIER_RESPONSE ) THEN
3206:
3207: if (prec.suprep_sn_flag = MSC_UTIL.SYS_INCR) then
3208: -- do net-change for this entity
3209: p_cont_lrnn := p_lrnn;

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

3219: RETURN FALSE;
3220: end if;
3221: END IF;
3222:
3223: IF ( p_task_num = MSC_CL_PULL.TASK_TRIP ) THEN
3224: if (prec.trip_sn_flag = MSC_UTIL.SYS_INCR) then
3225: -- do net-change for this entity
3226: p_cont_lrnn := p_lrnn;
3227: RETURN TRUE;