APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on MSC_PLANS

Line 597: from msc_plans

593: end if;
594:
595: select compile_designator
596: into p_designator
597: from msc_plans
598: where plan_id = p_plan_id;
599:
600: BEGIN
601: select MEANING

Line 910: FROM msc_plans

906:
907: -- check for the latest version, in case if another user has updated it
908: IF p_auto_version = 1 THEN
909: SELECT nvl(publish_supply_commit_version,0)+1 INTO l_new_version
910: FROM msc_plans
911: WHERE plan_id = p_plan_id;
912: IF l_version <> l_new_version THEN
913: print_debug_info('Warning: Someone has already published supply commit with the version '||l_version||'. The new version is ' ||l_new_version);
914: l_version := l_new_version;

Line 996: --update version number in msc_plans

992: IF l_records_exist = 1 then
993: l_log_message := get_message('MSC','MSC_X_PUB_NEW_VERSION_SC',l_language_code) || ' ' || l_version || '.' || fnd_global.local_chr(10);
994: log_message(l_log_message);
995:
996: --update version number in msc_plans
997:
998: UPDATE msc_plans
999: SET publish_supply_commit_version = l_version
1000: WHERE plan_id = p_plan_id;

Line 998: UPDATE msc_plans

994: log_message(l_log_message);
995:
996: --update version number in msc_plans
997:
998: UPDATE msc_plans
999: SET publish_supply_commit_version = l_version
1000: WHERE plan_id = p_plan_id;
1001:
1002: END IF;