APPS.MRP_KANBAN_PLAN_PK dependencies on MRP_KANBAN_PLANS

Line 5: -- This function will update the plan_start_date column in mrp_kanban_plans

1: PACKAGE BODY MRP_KANBAN_PLAN_PK AS
2: /* $Header: MRPKPLNB.pls 120.8 2006/05/26 01:47:08 ksuleman noship $ */
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

Line 47: FROM mrp_kanban_plans

43: g_kanban_info_rec.input_designator,
44: l_bom_effectivity,
45: l_start_date,
46: l_cutoff_date
47: FROM mrp_kanban_plans
48: WHERE kanban_plan_id = g_kanban_info_rec.kanban_plan_id;
49:
50: -- clean out data in some tables depending on whether we are
51: -- replanning or not

Line 119: -- Update some plan information in mrp_kanban_plans table

115:
116: commit;
117:
118: -- ------------------------------------------------------------------------
119: -- Update some plan information in mrp_kanban_plans table
120: -- ------------------------------------------------------------------------
121: UPDATE mrp_kanban_plans
122: SET plan_start_date = g_kanban_info_rec.start_date,
123: plan_completion_date = NULL,

Line 121: UPDATE mrp_kanban_plans

117:
118: -- ------------------------------------------------------------------------
119: -- Update some plan information in mrp_kanban_plans table
120: -- ------------------------------------------------------------------------
121: UPDATE mrp_kanban_plans
122: SET plan_start_date = g_kanban_info_rec.start_date,
123: plan_completion_date = NULL,
124: bom_effectivity_date = g_kanban_info_rec.bom_effectivity,
125: plan_cutoff_date = g_kanban_info_rec.cutoff_date

Line 159: -- mrp_kanban_plans table to indicate that the plan has successfully

155: END START_KANBAN_PLAN;
156:
157: -- ========================================================================
158: -- This function will update the plan_completion_date column in
159: -- mrp_kanban_plans table to indicate that the plan has successfully
160: -- finished.
161: -- ========================================================================
162: FUNCTION END_KANBAN_PLAN
163: RETURN BOOLEAN IS

Line 174: UPDATE mrp_kanban_plans

170:
171: -- ------------------------------------------------------------------------
172: -- Update the plan_completion_date to sysdate
173: -- ------------------------------------------------------------------------
174: UPDATE mrp_kanban_plans
175: SET plan_completion_date = sysdate
176: WHERE kanban_plan_id = g_kanban_info_rec.kanban_plan_id;
177:
178: -- commit the changes to the database