[Home] [Help]
1963:
1964: FUNCTION get_scenario_name(p_scenario_id in number) return varchar2 is
1965: cursor c_scn_name is
1966: select scenario_name
1967: from msc_scenarios
1968: where scenario_id = p_scenario_id;
1969:
1970: l_scn_name varchar2(100);
1971: begin
2070: for every plan_id,
2071: generate plan_run_id and update plan_run_id field for it.
2072: call populate_Details api
2073: end for;
2074: insert new record into msc_scenarios for current version of the scenario
2075: update scenario_name,version for this scenario_id by appending sysdate to it
2076: */
2077:
2078:
2104: return;
2105: end if;
2106:
2107: l_scn_name := msc_scn_utils.get_scenario_name(p_scn_id);
2108: select count(*) into l_scn_count from msc_scenarios where scenario_name like l_scn_name||' ('||sysdate||')%';
2109: l_scn_count := l_scn_count+1;
2110: msc_util.msc_debug('New Scenario Name:'||l_scn_name||' ('||sysdate||')('||l_scn_count||')');
2111: update msc_scenarios set scn_version = sysdate,scenario_name = scenario_name||' ('||sysdate||')('||l_scn_count||')' where scenario_id = p_scn_id;
2112:
2107: l_scn_name := msc_scn_utils.get_scenario_name(p_scn_id);
2108: select count(*) into l_scn_count from msc_scenarios where scenario_name like l_scn_name||' ('||sysdate||')%';
2109: l_scn_count := l_scn_count+1;
2110: msc_util.msc_debug('New Scenario Name:'||l_scn_name||' ('||sysdate||')('||l_scn_count||')');
2111: update msc_scenarios set scn_version = sysdate,scenario_name = scenario_name||' ('||sysdate||')('||l_scn_count||')' where scenario_id = p_scn_id;
2112:
2113: l_user_id := fnd_profile.value ('USER_ID');
2114: l_login_id := FND_PROFILE.VALUE('LOGIN_ID');
2115:
2114: l_login_id := FND_PROFILE.VALUE('LOGIN_ID');
2115:
2116: select msc_scn_scenarios_s.nextval into l_new_scn_id from dual;
2117:
2118: -- Insert rows into msc_scenarios,msc_scenario_plans,msc_scenario_users;
2119:
2120: insert into msc_scenarios(scenario_id,
2121: scenario_name,
2122: created_by,
2116: select msc_scn_scenarios_s.nextval into l_new_scn_id from dual;
2117:
2118: -- Insert rows into msc_scenarios,msc_scenario_plans,msc_scenario_users;
2119:
2120: insert into msc_scenarios(scenario_id,
2121: scenario_name,
2122: created_by,
2123: creation_date,
2124: last_update_date,
2152: null,
2153: wc_flag,
2154: gs_name,
2155: gs_name_orig
2156: from msc_scenarios where scenario_id = p_scn_id);
2157:
2158: insert into msc_scenario_plans (scenario_id,
2159: plan_type,
2160: plan_id,
2250: and sp.plan_run_id = r.plan_run_id;
2251:
2252: cursor c_scn_version is
2253: select scn_version
2254: from msc_scenarios
2255: where scenario_id = p_scn_id;
2256:
2257: l_scn_version date;
2258: l_plan_run_name varchar2(50);
2279: end loop;
2280: close c_scn_plans;
2281:
2282: end if;
2283: delete msc_scenarios where scenario_id = p_scn_id;
2284:
2285: delete msc_scenario_plans where scenario_id = p_scn_id;
2286:
2287: delete msc_Scenario_users where scenario_id = p_scn_id;
2548: from_query := from_query || ' ms.Description Scenario_Description, msc_scn_utils.Scenario_Status(msa.scenario_id) Scenario_Status, msc_pers_queries.get_user(ms.owner) Scenario_Owner_Name, ms.Scn_Comment Scenario_Comment, to_char(Null) Plan_Name, ';
2549: from_query := from_query || ' to_char(NULL) Plan_Status, msc_get_name.lookup_meaning(''MSC_SCN_PRIORITIES'',msa.Priority) Priority_Text, msa.Completed_On Completed_On, msc_pers_queries.get_user(msa.alternate_owner) alternate_owner_name, ';
2550: from_query := from_query || ' msc_pers_queries.get_user(msa.created_by) Created_By_User, msa.Creation_date, msa.rowid ROW_ID, msa.Activity_Id, msa.Scenario_Id, msa.Scenario_set_Id, ''MSA'' source_table, ';
2551: from_query := from_query || ' msa.Owner, msa.Status Status, msa.created_by, msa.last_update_date, msa.Last_updated_by, msa.last_update_login, msa.Priority, msa.Alternate_Owner, ms.owner Scenario_Owner FROM MSC_SCENARIO_ACTIVITIES MSA, ';
2552: from_query := from_query || ' MSC_SCENARIOS MS, MSC_SCENARIO_SETS MSS WHERE ';
2553: from_query := from_query || ' MSA.SCENARIO_ID=MS.SCENARIO_ID(+) AND MSA.SCENARIO_SET_ID=MSS.SCENARIO_SET_ID(+) and status in (1,2,4)) union ';
2554: from_query := from_query || ' (select concat(concat(mpp.process_name,'' - ''),msc_get_name.lookup_meaning(''MSC_PROCESS_ACTIVITY_TYPES'',MPPA.Activity_Type)) Activity_Name, to_char(NULL) Activity_Description, ';
2555: from_query := from_query || ' msc_get_name.lookup_meaning(''MSC_SCN_ACTIVITY_STATES'',MPPA.Status) Activity_Status, msc_pers_queries.get_user(MPPA.owner) Owner_Name, trunc(mppa.creation_date + nvl(time_out,0)) ';
2556: from_query := from_query || ' Finish_By, to_char(decode(MPPA.activity_type,14,''Manual'',15,''Manual'',16,''Manual'',17,''Manual'',18,''Manual'',20,''Manual'',22,''Manual'',23,''Manual'',''System'' ) ) Activity_Type, ';
2826: l_plan_horizon date;
2827:
2828: cursor c_scn is
2829: select scenario_id
2830: from msc_scenarios
2831: where scenario_name = p_scn_name;
2832: l_temp number;
2833:
2834: cursor c_plan_type (ll_plan_id number) is
2870: l_user_id := 0;
2871:
2872: select msc_scn_scenarios_s.nextval into l_scn_id from dual;
2873:
2874: --Insert rows into msc_scenarios,msc_scenario_plans,msc_scenario_users;
2875:
2876: insert into msc_scenarios (scenario_id, scenario_name,
2877: created_by, creation_date, last_update_date, last_updated_by, last_update_login,
2878: parent_scn_id, description, owner,
2872: select msc_scn_scenarios_s.nextval into l_scn_id from dual;
2873:
2874: --Insert rows into msc_scenarios,msc_scenario_plans,msc_scenario_users;
2875:
2876: insert into msc_scenarios (scenario_id, scenario_name,
2877: created_by, creation_date, last_update_date, last_updated_by, last_update_login,
2878: parent_scn_id, description, owner,
2879: scn_access, scn_comment, valid_from, valid_to, scn_version)
2880: values