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 1307: -- Update MSC Plans to null out the date.

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

Line 1308: /* update msc_plans

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

Line 1514: update msc_plans

1510: conc_debug (' Plan ID : '|| p_plan_id || ' Status : ' || p_status);
1511:
1512: x_return_status := FND_API.G_RET_STS_SUCCESS;
1513:
1514: update msc_plans
1515: set summary_flag = p_status
1516: where plan_id = p_plan_id;
1517:
1518: EXCEPTION