APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_PLANS

Line 636: from msc_plans

632: -- bug#6893383
633:
634: select compile_designator,curr_plan_type
635: into p_designator,l_plan_type
636: from msc_plans
637: where plan_id = p_plan_id;
638:
639: log_message('Designator/Plan Type : ' || p_designator || '/' || l_plan_type );
640:

Line 1399: --update version number in msc_plans

1395: IF l_records_exist = 1 then
1396: l_log_message := get_message('MSC','MSC_X_PUB_NEW_VERSION',l_language_code) || ' ' || l_version || '.' || fnd_global.local_chr(10);
1397: log_message(l_log_message);
1398:
1399: --update version number in msc_plans
1400:
1401: UPDATE msc_plans
1402: SET publish_fcst_version = l_version
1403: WHERE plan_id = p_plan_id;

Line 1401: UPDATE msc_plans

1397: log_message(l_log_message);
1398:
1399: --update version number in msc_plans
1400:
1401: UPDATE msc_plans
1402: SET publish_fcst_version = l_version
1403: WHERE plan_id = p_plan_id;
1404:
1405: END IF;