eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_SCN_UTILS dependencies on MSC_SCN_UTILS

Line 1: PACKAGE BODY MSC_SCN_UTILS AS

1: PACKAGE BODY MSC_SCN_UTILS AS
2: /* $Header: MSCSCNUB.pls 120.51.12010000.5 2008/07/22 06:15:25 vkkandul ship $*/
3:
4: p_version constant number := 7;
5:

Line 2027: select msc_scn_utils.get_owner_name(user_id)

2023: end copy_scn_plans;
2024:
2025: FUNCTION get_scn_users (p_scn_id in number) return varchar2 is
2026: cursor c_scn_users is
2027: select msc_scn_utils.get_owner_name(user_id)
2028: from msc_scenario_users
2029: where scenario_id = p_scn_id;
2030:
2031: l_scn_users varchar2(2000) := '';

Line 2101: l_scn_name := msc_scn_utils.get_scenario_name(p_scn_id);

2097: if p_scn_id is null then
2098: return;
2099: end if;
2100:
2101: l_scn_name := msc_scn_utils.get_scenario_name(p_scn_id);
2102: select count(*) into l_scn_count from msc_scenarios where scenario_name like l_scn_name||' ('||sysdate||')%';
2103: l_scn_count := l_scn_count+1;
2104: msc_util.msc_debug('New Scenario Name:'||l_scn_name||' ('||sysdate||')('||l_scn_count||')');
2105: update msc_scenarios set scn_version = sysdate,scenario_name = scenario_name||' ('||sysdate||')('||l_scn_count||')' where scenario_id = p_scn_id;

Line 2191: l_plan_name := msc_scn_utils.get_plan_name(l_plan_type,l_plan_id,null);

2187: open c_scn_plans;
2188: loop
2189: fetch c_scn_plans into l_plan_type,l_plan_id,l_run_date;
2190: exit when c_scn_plans%NOTFOUND;
2191: l_plan_name := msc_scn_utils.get_plan_name(l_plan_type,l_plan_id,null);
2192: if(l_plan_type <> 10) then
2193:
2194: l_plan_run_id := msc_phub_pkg.populate_plan_run_info(l_plan_id,l_plan_name,l_plan_type,l_run_date);
2195: if(l_plan_type = 6) then -- for sno plans

Line 2545: 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, ';

2541: from_query := from_query || ' Scenario_Status, Scenario_Owner_Name, Scenario_Comment, Plan_Name, Plan_Status, Priority_Text, Completed_On, Alternate_Owner_Name, Created_By_User, Creation_Date, Row_Id, Activity_Id, Scenario_Id, ';
2542: from_query := from_query || ' Scenario_set_Id, source_table, Owner, Status, created_by, last_update_date, Last_updated_by, last_update_login, Priority, Alternate_Owner, Scenario_owner from ( (select ';
2543: from_query := from_query || ' msa.Activity_Name Activity_Name, msa.Description Activity_Description, msc_get_name.lookup_meaning(''MSC_SCN_ACTIVITY_STATES'',msa.Status) Activity_Status, msc_pers_queries.get_user(msa.owner) owner_name, ';
2544: from_query := from_query || ' trunc(msa.Finish_By) Finish_By, ''Manual'' activity_type, msa.Act_Comment Activity_Comment, mss.scenario_set_name Scenario_Set_Name, mss.Description Scenario_Set_Description, ms.scenario_name Scenario_Name, ';
2545: 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, ';
2546: 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, ';
2547: 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, ';
2548: 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, ';
2549: from_query := from_query || ' MSC_SCENARIOS MS, MSC_SCENARIO_SETS MSS WHERE ';

Line 2555: from_query := from_query || ' to_CHAR(NULL) Scenario_Description, to_char(NULL) Scenario_Status, to_CHAR(NULL) Scenario_Owner_Name, to_CHAR(NULL) Scenario_Comment, msc_scn_utils.get_plan_Name(MPPA.Activity_Type,MPPA.plan_id,null) Plan_Name, ';

2551: 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, ';
2552: 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)) ';
2553: 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, ';
2554: from_query := from_query || ' to_char(NULL) Activity_Comment, to_char(NULL) Scenario_Set_Name, to_CHAR(NULL) Scenario_Set_Description, to_char(NULL) Scenario_Name, ';
2555: from_query := from_query || ' to_CHAR(NULL) Scenario_Description, to_char(NULL) Scenario_Status, to_CHAR(NULL) Scenario_Owner_Name, to_CHAR(NULL) Scenario_Comment, msc_scn_utils.get_plan_Name(MPPA.Activity_Type,MPPA.plan_id,null) Plan_Name, ';
2556: from_query := from_query || ' msc_scn_utils.plan_status(MPPA.plan_id) Plan_Status, to_CHAR(NULL) Priority_Text, ';
2557: from_query := from_query || ' to_date(NULL) Completed_On,msc_pers_queries.get_user(MPPA.alternate_owner) Alternate_Owner_Name,msc_pers_queries.get_user(MPPA.created_by) ';
2558: from_query := from_query || ' Created_By_User, MPPA.Creation_date Creation_Date, mppa.rowid ROW_ID, MPPA.Activity_Id Activity_Id, to_number(NULL) Scenario_Id, to_number(NULL) Scenario_Set_Id, ';
2559: from_query := from_query || ' decode (to_char(decode(MPPA.activity_type,14,''Manual'',15,''Manual'',16,''Manual'',17,''Manual'',18,''Manual'',20,''Manual'',22,''Manual'',23,''Manual'',''System'' ) ),''Manual'',''MSA'',''MPPA'') ';

Line 2556: from_query := from_query || ' msc_scn_utils.plan_status(MPPA.plan_id) Plan_Status, to_CHAR(NULL) Priority_Text, ';

2552: 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)) ';
2553: 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, ';
2554: from_query := from_query || ' to_char(NULL) Activity_Comment, to_char(NULL) Scenario_Set_Name, to_CHAR(NULL) Scenario_Set_Description, to_char(NULL) Scenario_Name, ';
2555: from_query := from_query || ' to_CHAR(NULL) Scenario_Description, to_char(NULL) Scenario_Status, to_CHAR(NULL) Scenario_Owner_Name, to_CHAR(NULL) Scenario_Comment, msc_scn_utils.get_plan_Name(MPPA.Activity_Type,MPPA.plan_id,null) Plan_Name, ';
2556: from_query := from_query || ' msc_scn_utils.plan_status(MPPA.plan_id) Plan_Status, to_CHAR(NULL) Priority_Text, ';
2557: from_query := from_query || ' to_date(NULL) Completed_On,msc_pers_queries.get_user(MPPA.alternate_owner) Alternate_Owner_Name,msc_pers_queries.get_user(MPPA.created_by) ';
2558: from_query := from_query || ' Created_By_User, MPPA.Creation_date Creation_Date, mppa.rowid ROW_ID, MPPA.Activity_Id Activity_Id, to_number(NULL) Scenario_Id, to_number(NULL) Scenario_Set_Id, ';
2559: from_query := from_query || ' decode (to_char(decode(MPPA.activity_type,14,''Manual'',15,''Manual'',16,''Manual'',17,''Manual'',18,''Manual'',20,''Manual'',22,''Manual'',23,''Manual'',''System'' ) ),''Manual'',''MSA'',''MPPA'') ';
2560: from_query := from_query || ' SOURCE_TABLE, MPPA.Owner Owner,';

Line 2798: END MSC_SCN_UTILS;

2794: close c_activity_params;
2795: param_default := l_return;
2796: end populate_default_params;
2797:
2798: END MSC_SCN_UTILS;