[Home] [Help]
84: DELETE FROM mrp_low_level_codes
85: WHERE plan_id = g_kanban_info_rec.kanban_plan_id
86: AND organization_id = g_kanban_info_rec.organization_id;
87:
88: DELETE FROM mtl_kanban_pull_sequences
89: WHERE kanban_plan_id = g_kanban_info_rec.kanban_plan_id;
90:
91: END IF;
92:
678: fnd_global.user_id,
679: sysdate,
680: fnd_global.user_id
681: FROM
682: mtl_kanban_pull_sequences ps
683: WHERE ps.wip_line_id = l_line_id
684: AND ps.source_type = G_PRODUCTION_SOURCE_TYPE
685: AND ps.kanban_plan_id = decode (g_kanban_info_rec.replan_flag,
686: 2, G_PRODUCTION_KANBAN,
2389: END IF;
2390:
2391: -- the first insert here is for the item for which we have
2392: -- foreacast based on the allocation percentages mentioned
2393: -- in the mtl_kanban_pull_sequences table
2394:
2395: IF NOT item_schedule_entries%ISOPEN THEN
2396: OPEN item_schedule_entries;
2397: END IF;
2490: fnd_global.user_id,
2491: sysdate,
2492: fnd_global.user_id
2493: FROM
2494: mtl_kanban_pull_sequences ps
2495: WHERE ps.wip_line_id = l_line_id
2496: AND ps.source_type = G_PRODUCTION_SOURCE_TYPE
2497: AND ps.kanban_plan_id = decode (g_kanban_info_rec.replan_flag,
2498: 2, G_PRODUCTION_KANBAN,
2676: END IF;
2677:
2678: -- the first insert here is for the item for which we have
2679: -- mds/mps based on the allocation percentages mentioned
2680: -- in the mtl_kanban_pull_sequences table
2681:
2682: l_item_id := p_inventory_item_id;
2683: IF NOT item_schedule_entries%ISOPEN THEN
2684: OPEN item_schedule_entries;
2763: fnd_global.user_id,
2764: sysdate,
2765: fnd_global.user_id
2766: FROM
2767: mtl_kanban_pull_sequences ps
2768: WHERE ps.wip_line_id = l_line_id
2769: AND ps.source_type = G_PRODUCTION_SOURCE_TYPE
2770: AND ps.kanban_plan_id = decode (g_kanban_info_rec.replan_flag,
2771: 2, G_PRODUCTION_KANBAN,
2916: END IF;
2917:
2918: -- the first insert here is for the item for which we have
2919: -- mds/mps based on the allocation percentages mentioned
2920: -- in the mtl_kanban_pull_sequences table
2921:
2922: l_item_id := p_inventory_item_id;
2923: IF NOT item_schedule_entries%ISOPEN THEN
2924: OPEN item_schedule_entries;
3001: fnd_global.user_id,
3002: sysdate,
3003: fnd_global.user_id
3004: FROM
3005: mtl_kanban_pull_sequences ps
3006: WHERE ps.wip_line_id = l_line_id
3007: AND ps.source_type = G_PRODUCTION_SOURCE_TYPE
3008: AND ps.kanban_plan_id = decode (g_kanban_info_rec.replan_flag,
3009: 2, G_PRODUCTION_KANBAN,
3466: END Kanban_Calculation_Pvt;
3467: -- ========================================================================
3468: -- this function calculates the kanban size/number for each
3469: -- kanban item/location that we need to plan in this plan run
3470: -- and inserts the information into mtl_kanban_pull_sequences table
3471: -- ========================================================================
3472:
3473: FUNCTION Calculate_Kanban_Quantity (p_total_workdays IN NUMBER)
3474: RETURN BOOLEAN IS
3524: minimum_order_quantity,
3525: aggregation_type,
3526: allocation_percent,
3527: release_kanban_flag
3528: FROM mtl_kanban_pull_sequences
3529: WHERE kanban_plan_id = decode (g_kanban_info_rec.replan_flag,
3530: 2, G_PRODUCTION_KANBAN,
3531: 1, g_kanban_info_rec.kanban_plan_id,
3532: G_PRODUCTION_KANBAN)
3563:
3564: EXIT WHEN cur_kanban_demand%NOTFOUND;
3565:
3566: -- now get some information about this item/location from
3567: -- mtl_kanban_pull_sequences
3568:
3569: OPEN cur_pull_sequence;
3570:
3571: FETCH cur_pull_sequence
3681:
3682: END IF;
3683: END IF;
3684:
3685: -- Now go ahead and insert/update into mtl_kanban_pull_sequences table
3686: -- information about this kanban item/location for this kanban plan
3687:
3688: SELECT
3689: fnd_global.conc_request_id,