PACKAGE: APPS.MSC_NETCHANGE_PKG

Source

1 PACKAGE Msc_Netchange_Pkg AS
2 /* $Header: MSCNETCS.pls 120.0 2005/05/25 17:32:30 appldev noship $ */
3 
4 Procedure compare_plans(from_plan number,
5                        to_plan number,
6                        options_flag number,
7                        p_folder_id number,
8                        exception_list varchar2,
9                        p_criteria_id number,
10                        option_query_id out nocopy number,
11                        exception_query_id out nocopy number
12                        );
13 Function convert_condition(operator number) RETURN varchar2;
14 Procedure compare_options;
15 Procedure compare_aggregate;
16 Procedure compare_optimize;
17 Procedure compare_orgs;
18 Procedure compare_schedules;
19 Procedure compare_constraints;
20 Procedure compare_goalprog;
21 
22 Procedure compare_exceptions(
23                        exception_list varchar2,
24                        item_where_clause varchar2,
25                        resource_where_clause varchar2);
26 
27 Procedure populate_all_exceptions(p_plan_id number,p_report_id number);
28 
29 function calculate_start_date (p_org_id               IN NUMBER,
30                                p_sr_instance_id       IN    NUMBER,
31                                p_plan_start_date      IN    DATE,
32                                p_daily_cutoff_bucket  IN    NUMBER,
33                                p_weekly_cutoff_bucket IN    NUMBER,
34                                p_period_cutoff_bucket IN    NUMBER)
35                           return varchar2 ;
36 
37 Procedure checkPlanStatus(p_from_plan in number,
38                             p_to_plan in number,
39                             p_status out nocopy number,
40                             p_report_id out nocopy number);
41 
42 
43 Procedure compare_all_exceptions(errbuf             OUT NOCOPY VARCHAR2,
44                                  retcode            OUT NOCOPY NUMBER,
45                                  p_from_plan         IN  NUMBER,
46                                  p_to_plan          IN  NUMBER);
47 
48 Procedure compare_each_exception(p_report_id number);
49 
50 Procedure filter_data(p_report_id number,
51                               p_excp_type number,
52                               where_clause varchar2);
53 
54 Function category_name(p_org_id number, p_instance_id number,
55                        p_item_id number,
56                        p_plan_id number) return varchar2;
57 
58 Procedure compare_plan_need_refresh(p_plan_id number);
59 
60 Procedure purge_plan(errbuf  OUT NOCOPY VARCHAR2,
61                      retcode OUT NOCOPY NUMBER,
62                      p_plan_id IN NUMBER);
63 
64 END Msc_Netchange_Pkg;