[Home] [Help]
1: PACKAGE BODY MRP_KANBAN_PLAN_PK AS
2: /* $Header: MRPKPLNB.pls 120.13.12020000.2 2012/07/04 16:43:06 sisankar ship $ */
3:
4: -- ========================================================================
5: -- This function will update the plan_start_date column in mrp_kanban_plans
6: -- table to indicate that the plan has started to run. The user will not
7: -- be able to query up this plan until the plan has finished running.
8: -- ========================================================================
9: FUNCTION START_KANBAN_PLAN
45: l_bom_effectivity,
46: l_start_date,
47: l_cutoff_date,
48: g_kanban_info_rec.kanban_designator
49: FROM mrp_kanban_plans
50: WHERE kanban_plan_id = g_kanban_info_rec.kanban_plan_id;
51:
52: -- clean out data in some tables depending on whether we are
53: -- replanning or not
117:
118: commit;
119:
120: -- ------------------------------------------------------------------------
121: -- Update some plan information in mrp_kanban_plans table
122: -- ------------------------------------------------------------------------
123: UPDATE mrp_kanban_plans
124: SET plan_start_date = g_kanban_info_rec.start_date,
125: plan_completion_date = NULL,
119:
120: -- ------------------------------------------------------------------------
121: -- Update some plan information in mrp_kanban_plans table
122: -- ------------------------------------------------------------------------
123: UPDATE mrp_kanban_plans
124: SET plan_start_date = g_kanban_info_rec.start_date,
125: plan_completion_date = NULL,
126: bom_effectivity_date = g_kanban_info_rec.bom_effectivity,
127: plan_cutoff_date = g_kanban_info_rec.cutoff_date,
158: END START_KANBAN_PLAN;
159:
160: -- ========================================================================
161: -- This function will update the plan_completion_date column in
162: -- mrp_kanban_plans table to indicate that the plan has successfully
163: -- finished.
164: -- ========================================================================
165: FUNCTION END_KANBAN_PLAN
166: RETURN BOOLEAN IS
173:
174: -- ------------------------------------------------------------------------
175: -- Update the plan_completion_date to sysdate
176: -- ------------------------------------------------------------------------
177: UPDATE mrp_kanban_plans
178: SET plan_completion_date = sysdate
179: WHERE kanban_plan_id = g_kanban_info_rec.kanban_plan_id;
180:
181: -- commit the changes to the database