APPS.MSC_ATP_24X7 dependencies on MSC_PLANS

Line 138: from msc_plans

134: conc_debug ('Fetching New PLAN ID from the database ...');
135: BEGIN
136: select plan_id
137: into l_new_plan_id
138: from msc_plans
139: where copy_plan_id = p_old_plan_id;
140: EXCEPTION
141: when OTHERS then
142: conc_log ('Unable to retrieve the copy plan ID for the old plan');

Line 206: -- Set status in MSC_PLANS - summary_flag

202: -- Set the global to indicate ATP Synchronization
203: conc_debug ('Setting ATP Synchronization flag');
204: MSC_ATP_PVT.G_SYNC_ATP_CHECK := 'Y';
205:
206: -- Set status in MSC_PLANS - summary_flag
207: conc_debug ('Updating summary flag ');
208: Update_Summary_Flag ( p_new_plan_id,
209: G_SF_SYNC_RUNNING,
210: l_return_status);

Line 1310: -- Update MSC Plans to null out the date.

1306: conc_debug ('------ATP_Downtime_Init--------');
1307: conc_debug (' Old Plan: ' || p_old_plan_id);
1308:
1309: x_return_status := FND_API.G_RET_STS_SUCCESS;
1310: -- Update MSC Plans to null out the date.
1311: /* update msc_plans
1312: set plan_completion_date = NULL
1313: where plan_id = p_old_plan_id;
1314: */

Line 1311: /* update msc_plans

1307: conc_debug (' Old Plan: ' || p_old_plan_id);
1308:
1309: x_return_status := FND_API.G_RET_STS_SUCCESS;
1310: -- Update MSC Plans to null out the date.
1311: /* update msc_plans
1312: set plan_completion_date = NULL
1313: where plan_id = p_old_plan_id;
1314: */
1315: Update_Summary_Flag ( P_new_plan_id,

Line 1568: update msc_plans

1564: conc_debug (' Plan ID : '|| p_plan_id || ' Status : ' || p_status);
1565:
1566: x_return_status := FND_API.G_RET_STS_SUCCESS;
1567:
1568: update msc_plans
1569: set summary_flag = p_status
1570: where plan_id = p_plan_id;
1571:
1572: EXCEPTION