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_GET_NAME

Line 2392: msc_get_name.execute_dsql(l_sql_stmnt);

2388:
2389: l_sql_stmnt := l_insert||l_select;
2390:
2391: commit;
2392: msc_get_name.execute_dsql(l_sql_stmnt);
2393:
2394: commit;
2395: end loop;
2396: close c_activity_params;

Line 2430: msc_Get_name.lookup_meaning(

2426:
2427: FUNCTION plan_Status(p_Plan_id in number) return varchar2 is
2428: cursor c_plan_status(c_plan_id number) is
2429: Select
2430: msc_Get_name.lookup_meaning(
2431: 'MSC_SCN_PLAN_STATUS',
2432: decode(upper(fcr.status_code),'C',4,'E',3)
2433: ) plan_status_display
2434: from msc_plans mp,

Line 2537: select_query := ' SELECT source_table, msc_get_name.lookup_meaning(''MSC_SCN_ACTIVITY_STATES'', status) activity_status, ' ;

2533: ||','||act19||','||act20||','||act21||','||act22||','||act23||','||act24||','||act25||','||act26
2534: ||','||act27||','||act28||','||act29||','||act30||','||act31||','||act32||','||act33||','||act34
2535: ||','||act35||','||act36;
2536: -- select all columns in vo as required
2537: select_query := ' SELECT source_table, msc_get_name.lookup_meaning(''MSC_SCN_ACTIVITY_STATES'', status) activity_status, ' ;
2538: select_query:= select_query || ' decode(SIGN(finish_by -TRUNC(sysdate) + 0), -1, ''PAST_DUE'', 0, ''CURRENT'', 1, ''FUTURE'') ppf, ';
2539: select_query:= select_query || ' status, COUNT(activity_id) summ ';
2540: from_query := ' from(select Activity_Name, Activity_Description, Activity_Status, Owner_Name, Finish_By, Activity_Type, Activity_Comment, Scenario_Set_Name, Scenario_Set_Description, Scenario_Name, Scenario_Description, ';
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, ';

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

2539: select_query:= select_query || ' status, COUNT(activity_id) summ ';
2540: from_query := ' from(select Activity_Name, Activity_Description, Activity_Status, Owner_Name, Finish_By, Activity_Type, Activity_Comment, Scenario_Set_Name, Scenario_Set_Description, Scenario_Name, Scenario_Description, ';
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, ';

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

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 ';
2550: 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 ';

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

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

Line 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)) ';

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