APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on MSC_PLANS

Line 608: from msc_plans

604:
605: -- RP-CP Integration
606: select compile_designator,curr_plan_type,saved_flag
607: into p_designator,l_plan_type,l_plan_status
608: from msc_plans
609: where plan_id = p_plan_id;
610:
611: log_message('Designator/Plan Type/Plan Status : ' || p_designator || '/' || l_plan_type || '/' || l_plan_status );
612:

Line 937: FROM msc_plans

933:
934: -- check for the latest version, in case if another user has updated it
935: IF p_auto_version = 1 THEN
936: SELECT nvl(publish_supply_commit_version,0)+1 INTO l_new_version
937: FROM msc_plans
938: WHERE plan_id = p_plan_id;
939: IF l_version <> l_new_version THEN
940: print_debug_info('Warning: Someone has already published supply commit with the version '||l_version||'. The new version is ' ||l_new_version);
941: l_version := l_new_version;

Line 1023: --update version number in msc_plans

1019: IF l_records_exist = 1 then
1020: l_log_message := get_message('MSC','MSC_X_PUB_NEW_VERSION_SC',l_language_code) || ' ' || l_version || '.' || fnd_global.local_chr(10);
1021: log_message(l_log_message);
1022:
1023: --update version number in msc_plans
1024:
1025: UPDATE msc_plans
1026: SET publish_supply_commit_version = l_version
1027: WHERE plan_id = p_plan_id;

Line 1025: UPDATE msc_plans

1021: log_message(l_log_message);
1022:
1023: --update version number in msc_plans
1024:
1025: UPDATE msc_plans
1026: SET publish_supply_commit_version = l_version
1027: WHERE plan_id = p_plan_id;
1028:
1029: END IF;