[Home] [Help]
1476: p_qty,
1477: p_original_item_id,
1478: p_substitute_item_id,
1479: p_org_id
1480: FROM msc_demands md,
1481: msc_trading_partners mtp
1482: WHERE md.plan_id = arg_plan_id
1483: AND md.release_errors is NULL
1484: and md.load_type = 30
1543: p_qty,
1544: p_original_item_id,
1545: p_substitute_item_id,
1546: p_org_id
1547: FROM msc_demands md,
1548: msc_trading_partners mtp
1549: WHERE md.plan_id = arg_plan_id
1550: AND md.release_errors is NULL
1551: and md.load_type = 30
1725: v_temp2 :=0;
1726:
1727: select count(*)
1728: into v_temp2
1729: from msc_demands
1730: where plan_id = arg_plan_id
1731: anD release_errors is NULL
1732: and load_type = 30
1733: and sr_instance_id = p_inst_id
1739: end if; -- if v_temp >0 then
1740: END LOOP;
1741: CLOSE instance_cur;
1742:
1743: UPDATE MSC_DEMANDS
1744: SET /* implement_date = NULL,
1745: implement_ship_date = NULL,
1746: implement_earliest_date = NULL,
1747: implement_arrival_date = NULL,
2818: inventory_item_id,
2819: ship_method,
2820: customer_id,
2821: customer_site_id
2822: from msc_demands
2823: where plan_id = p_plan_id
2824: and demand_id = p_demand_id
2825: and sr_instance_id = p_inst_id;
2826:
2843: md.schedule_ship_date,
2844: nvl(md.planned_ship_date,md.dmd_satisfied_date),
2845: md.planned_arrival_date,
2846: md.intransit_lead_time
2847: from msc_demands md,
2848: msc_system_items msi
2849: where md.plan_id = p_plan_id
2850: and md.ship_set_id = p_ship_set_id
2851: and msi.plan_id = md.plan_id
2871: md.organization_id,
2872: md.sr_instance_id,
2873: nvl(md.planned_ship_date,md.dmd_satisfied_date),
2874: md.planned_arrival_date
2875: from msc_demands md,
2876: msc_system_items msi
2877: where md.plan_id = p_plan_id
2878: and md.arrival_set_id = p_arrival_set_id
2879: and msi.plan_id = md.plan_id
2963: , p_ship_date);
2964: end if;
2965:
2966: if v_set_demand_id(a) <> p_demand_id then
2967: update msc_demands
2968: set implement_ship_date = p_ship_date, -- sche ship date
2969: implement_date = nvl(implement_date, nvl(firm_date,
2970: nvl(planned_ship_date,dmd_satisfied_date))),
2971: implement_earliest_date = p_earliest_date, -- earliest ship date
3064: , v_inst_id(a)
3065: , v_lead_time(a)*-1
3066: , p_earliest_date);
3067: if v_set_demand_id(a) <> p_demand_id then
3068: update msc_demands
3069: set implement_arrival_date = p_arrival_date,
3070: implement_earliest_date = v_earliest_date(a),
3071: implement_ship_date = v_ship_date(a), -- sche ship date
3072: implement_date = nvl(implement_date, nvl(firm_date,
3132: end if;
3133:
3134: end if;
3135: end if; --if so_rec.ship_set_id is null and so_rec.arrival_set_id is null
3136: update msc_demands
3137: set implement_earliest_date = p_earliest_date
3138: where plan_id = p_plan_id
3139: and demand_id = p_demand_id;
3140:
3143: PROCEDURE unrelease_so_set(p_plan_id number, p_demand_id number,
3144: p_instance_id number) IS
3145: cursor set_id is
3146: select ship_set_id, arrival_set_id
3147: from msc_demands
3148: where plan_id = p_plan_id
3149: and demand_id = p_demand_id
3150: and sr_instance_id = p_instance_id;
3151: p_ship_set_id number;
3155: FETCH set_id into p_ship_set_id, p_arrival_set_id;
3156: CLOSE set_id;
3157:
3158: if p_ship_set_id is not null then
3159: UPDATE MSC_DEMANDS
3160: SET implement_date = NULL,
3161: implement_ship_date = NULL,
3162: implement_earliest_date = NULL,
3163: implement_arrival_date = NULL,
3175: AND demand_id <> p_demand_id;
3176: end if;
3177:
3178: if p_arrival_set_id is not null then
3179: UPDATE MSC_DEMANDS
3180: SET implement_date = NULL,
3181: implement_ship_date = NULL,
3182: implement_earliest_date = NULL,
3183: implement_arrival_date = NULL,
3211: origination_type demand_type,
3212: ship_set_id, arrival_set_id,
3213: decode(nvl(prev_subst_item,0),
3214: inventory_item_id, 0,0,0,1) subst_item
3215: from msc_demands
3216: where plan_id = p_plan_id
3217: and demand_id = p_demand_id
3218: and sr_instance_id = p_inst_id;
3219:
3223: cursor check_source(p_order_number varchar2,
3224: p_order_type number,
3225: p_org_id number) is
3226: select 1
3227: from msc_demands
3228: where plan_id = p_plan_id
3229: and order_number = p_order_number
3230: and origination_type = p_order_type
3231: and organization_id <> p_org_id
3235:
3236: cursor check_ship_source(p_ship_set_id number,
3237: p_org_id number) is
3238: select 1
3239: from msc_demands
3240: where plan_id = p_plan_id
3241: and ship_set_id = p_ship_set_id
3242: and organization_id <> p_org_id ;
3243:
3245:
3246: cursor ship_set(p_ship_set_id number) is
3247: select
3248: decode(nvl(original_item_id,0), inventory_item_id, 0,0,0,1)
3249: from msc_demands
3250: where plan_id = p_plan_id
3251: and ship_set_id = p_ship_set_id;
3252:
3253: cursor arrival_set(p_arrival_set_id number) is
3252:
3253: cursor arrival_set(p_arrival_set_id number) is
3254: select
3255: decode(nvl(original_item_id,0), inventory_item_id, 0,0,0,1)
3256: from msc_demands
3257: where plan_id = p_plan_id
3258: and arrival_set_id = p_arrival_set_id;
3259:
3260: v_error_msg varchar2(80);
3442: md.plan_id,md.original_inst_id)
3443: orig_item_desc
3444: from msc_system_items msi,
3445: msc_plans mp,
3446: msc_demands md,
3447: msc_sales_order_interface msoi
3448: where msoi.batch_id = p_batch_id
3449: and msoi.sr_instance_id = p_instance_id
3450: and msoi.plan_id = md.plan_id