[Home] [Help]
PACKAGE: APPS.IMC_REPORTS_SUMMARY_PKG
Source
1 package imc_reports_summary_pkg as
2 /* $Header: imcrsums.pls 120.1 2005/09/07 18:50:13 acng noship $ */
3 --- Procedure name : Extract_main
4
5 -- global pl/sql variables
6
7 rp_org_cnt Number;
8 rp_rel_cnt Number;
9 rp_per_cnt Number;
10 rp_total_cnt Number;
11 rp_grth_per_cnt Number;
12 rp_grth_rel_cnt Number;
13 rp_grth_org_cnt Number;
14 rp_grth_total_cnt Number;
15 rp_dupl_org_cnt Number;
16 rp_dupl_per_cnt Number;
17 rp_ind_org_cnt Number;
18
19 -- Fix for NLS Bug 2552772: Numeric or Value error
20 -- Changes: varchar2(30) to varchar2(80), substrb introduced while retrieving
21 -- messages using fnd_message.get_string
22
23 rp_msg_dupl varchar2(80) :=
24 substrb(fnd_message.get_string('IMC','IMC_REPORTS_DUPL'),1,80);
25 rp_msg_dupls varchar2(80) :=
26 substrb(fnd_message.get_string('IMC','IMC_REPORTS_DUPLS'),1,80);
27 rp_msg_no_dupl varchar2(80) :=
28 substrb(fnd_message.get_string('IMC','IMC_REPORTS_NO_DUPL'),1,80);
29 rp_msg_all_others varchar2(80) :=
30 substrb(fnd_message.get_string('IMC','IMC_REPORTS_ALL_OTHERS'),1,80);
31 rp_msg_total varchar2(80) :=
32 substrb(fnd_message.get_string('IMC','IMC_REPORTS_TOTAL'),1,80);
33 rp_msg_undefined varchar2(80):=
34 substrb(fnd_message.get_string('IMC','IMC_REPORTS_UNDEFINED'),1,80);
35
36 -- This variable g_log_flag is used as a flag whether to use fnd_file.put_line
37 -- or not. If it is set to null, error messages are logged to fnd_file.If it
38 -- set to some value,the message can be printed dbms_output instead of
39 -- fnd_file.put_line. This is used only for during developement and testing
40 -- as fnd_file can not be used from the SQL prompt. The write_log procedure
41 -- will use DBMS_OUTPUT to print message instead of fnd_file.put_line when
42 -- the flag is set to some value.
43
44 g_log_output varchar2( 1) := null;
45
46 g_log_flag varchar2(1) := null;
47
48 Procedure extract_main;
49 Procedure load_industry;
50 Procedure load_country;
51 Procedure load_state;
52 Procedure load_duplicates;
53 Procedure load_growth;
54 PROCEDURE extract_quality;
55 PROCEDURE get_compl_count(
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2
59 );
60
61 PROCEDURE delete_daily_score (
62 p_report_name IN VARCHAR2,
63 p_system_date IN DATE,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2
67 );
68
69 PROCEDURE insert_daily_score (
70 p_report_name IN VARCHAR2,
71 p_total_party IN NUMBER,
72 p_party_type IN VARCHAR2,
73 p_attribute IN VARCHAR2,
74 p_attr_code IN VARCHAR2,
75 p_table_name IN VARCHAR2,
76 p_system_date IN DATE,
77 p_parent_cat IN VARCHAR2,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2
81 );
82
83 PROCEDURE insert_monthly_score (
84 p_report_name IN VARCHAR2,
85 p_total_party IN NUMBER,
86 p_total_attribute IN NUMBER,
87 p_system_date IN DATE,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2
91 );
92
93 PROCEDURE update_monthly_score (
94 p_report_name IN VARCHAR2,
95 p_total_party IN NUMBER,
96 p_total_attribute IN NUMBER,
97 p_system_date IN DATE,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2
101 );
102
103 PROCEDURE insert_quarterly_score (
104 p_report_name IN VARCHAR2,
105 p_total_party IN NUMBER,
106 p_total_attribute IN NUMBER,
107 p_system_date IN DATE,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2
111 );
112
113 PROCEDURE update_quarterly_score (
114 p_report_name IN VARCHAR2,
115 p_total_party IN NUMBER,
116 p_total_attribute IN NUMBER,
117 p_system_date IN DATE,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2
121 );
122
123 PROCEDURE get_enrich_count(
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2
127 );
128
129 PROCEDURE insert_menrich_score (
130 p_system_date IN DATE,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2
134 );
135
136 PROCEDURE update_menrich_score (
137 p_system_date IN DATE,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2
141 );
142
143 PROCEDURE insert_qenrich_score (
144 p_system_date IN DATE,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2
148 );
149
150 PROCEDURE update_qenrich_score (
151 p_system_date IN DATE,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2
155 );
156
157 PROCEDURE archive_compl_report (
158 p_report_code IN VARCHAR2,
159 x_return_status OUT NOCOPY VARCHAR2
160 );
161
162 end imc_reports_summary_pkg;