PACKAGE: APPS.MSC_SCN_UTILS

Source

1 PACKAGE MSC_SCN_UTILS AS
2 	/* $Header: MSCSCNUS.pls 120.13 2008/02/22 12:48:29 vkkandul noship $ */
3 
4 
5     FUNCTION get_plan_name(p_plan_type in number,
6                            p_plan_id in number,
7                            p_plan_run_id in number) return varchar2;
8 
9     Function get_proc_act_name(p_activity_type in number) return varchar2;
10 
11     FUNCTION get_owner_name(p_owner_id in number) return varchar2;
12 
13     FUNCTION get_scn_version(p_version date) return varchar2;
14 
15     FUNCTION get_plan_version (p_plan_run_id in number) return varchar2;
16 
17     FUNCTION get_scn_users(p_scn_id in number) return varchar2;
18 
19     FUNCTION Scenario_Status(p_Scenario_id in number) return varchar2;
20 
21     FUNCTION Plan_Status(p_Plan_id in number) return varchar2;
22 
23     FUNCTION get_scenario_name(p_scenario_id in number) return varchar2;
24 
25     function plan_scns_count(p_plan_id in number, p_scn_id in number, p_plan_run_id in number) return number;
26 
27     FUNCTION get_scenario_set_name(p_scenario_set_id in number) return varchar2;
28 
29     procedure archive_scn_conc( errbuf out nocopy varchar2, retcode out nocopy varchar2 , p_scn_id in number);
30 
31     procedure purge_scn_conc( errbuf out nocopy varchar2, retcode out nocopy varchar2 , p_scn_id in number);
32 
33     procedure purge_plan_conc( errbuf out nocopy varchar2, retcode out nocopy varchar2 , p_plan_id in number, p_plan_type in number);
34 
35     procedure populate_act_params_for_lov(p_activity_type in number);
36 
37     procedure get_Activity_Summary(where_clause IN OUT NOCOPY varchar2, activity_summary IN out NOCOPY varchar2);
38 
39     function get_plan_run_date (p_plan_type in number,p_plan_id in number) return date;
40 
41     function get_process_status(p_process_id in number,p_curr_run_seq in number) return number;
42 
43     procedure copy_scn_plans(p_src_scnId in number, p_dest_scnId in number);
44 
45     procedure populate_default_params(p_activity_type IN OUT NOCOPY  number,param_default IN OUT NOCOPY varchar2);
46 
47 end MSC_SCN_UTILS;