PACKAGE: APPS.MSC_SCN_UTILS

Source

1 PACKAGE MSC_SCN_UTILS AUTHID CURRENT_USER AS
2     /* $Header: MSCSCNUS.pls 120.16 2011/05/04 16:59:45 wexia ship $ */
3 
4 
5     TYPE number_arr IS TABLE OF number;
6 
7     FUNCTION get_plan_name(p_plan_type in number,
8                            p_plan_id in number,
9                            p_plan_run_id in number) return varchar2;
10 
11     Function get_proc_act_name(p_activity_type in number) return varchar2;
12 
13     FUNCTION get_owner_name(p_owner_id in number) return varchar2;
14 
15     FUNCTION get_scn_version(p_version date) return varchar2;
16 
17     FUNCTION get_plan_version (p_plan_run_id in number) return varchar2;
18 
19     FUNCTION get_scn_users(p_scn_id in number) return varchar2;
20 
21     FUNCTION Scenario_Status(p_Scenario_id in number) return varchar2;
22 
23     FUNCTION Plan_Status(p_Plan_id in number) return varchar2;
24 
25     FUNCTION get_scenario_name(p_scenario_id in number) return varchar2;
26 
27     function plan_scns_count(p_plan_id in number, p_scn_id in number, p_plan_run_id in number) return number;
28 
29     FUNCTION get_scenario_set_name(p_scenario_set_id in number) return varchar2;
30 
31     procedure archive_scn_conc( errbuf out nocopy varchar2, retcode out nocopy varchar2 , p_scn_id in number);
32 
33     procedure purge_scn_conc( errbuf out nocopy varchar2, retcode out nocopy varchar2 , p_scn_id in number);
34 
35     procedure purge_plan_conc( errbuf out nocopy varchar2, retcode out nocopy varchar2 , p_plan_name varchar2);
36 
37     procedure populate_act_params_for_lov(p_activity_type in number);
38 
39     procedure get_Activity_Summary(where_clause IN OUT NOCOPY varchar2, activity_summary IN out NOCOPY varchar2);
40 
41     function get_plan_run_date (p_plan_type in number,p_plan_id in number) return date;
42 
43     function get_process_status(p_process_id in number,p_curr_run_seq in number) return number;
44 
45     procedure copy_scn_plans(p_src_scnId in number, p_dest_scnId in number);
46 
47     procedure populate_default_params(p_activity_type IN OUT NOCOPY  number,param_default IN OUT NOCOPY varchar2);
48 
49     procedure create_scenario( errbuf out nocopy varchar2, retcode out nocopy varchar2,
50       p_scn_name varchar2, p_description varchar2,
51       p_owner number, p_scn_version date,
52       p_scn_access number, p_scn_comment varchar2,
53       p_valid_from date, p_valid_to date,
54       p_plan_id_arr msc_scn_utils.number_arr,
55       p_users_arr  msc_scn_utils.number_arr
56       );
57 
58 end MSC_SCN_UTILS;