APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_PLANS

Line 639: from msc_plans

635: -- bug#6893383
636:
637: select compile_designator,curr_plan_type,saved_flag
638: into p_designator,l_plan_type,l_plan_status
639: from msc_plans
640: where plan_id = p_plan_id;
641:
642: log_message('Designator/Plan Type/Plan Status : ' || p_designator || '/' || l_plan_type || '/' || l_plan_status );
643:

Line 1416: --update version number in msc_plans

1412: IF l_records_exist = 1 then
1413: l_log_message := get_message('MSC','MSC_X_PUB_NEW_VERSION',l_language_code) || ' ' || l_version || '.' || fnd_global.local_chr(10);
1414: log_message(l_log_message);
1415:
1416: --update version number in msc_plans
1417:
1418: UPDATE msc_plans
1419: SET publish_fcst_version = l_version
1420: WHERE plan_id = p_plan_id;

Line 1418: UPDATE msc_plans

1414: log_message(l_log_message);
1415:
1416: --update version number in msc_plans
1417:
1418: UPDATE msc_plans
1419: SET publish_fcst_version = l_version
1420: WHERE plan_id = p_plan_id;
1421:
1422: END IF;