1 PACKAGE qa_txn_grp AS
2 /* $Header: qagtxns.pls 120.3.12010000.1 2008/07/25 09:19:34 appldev ship $ */
3
4 --
5 -- Bug 2123065
6 -- Custom parameters used for customization.
7 -- bso Mon Nov 26 11:52:09 PST 2001
8 --
9 g_custom1 VARCHAR2(150) DEFAULT '';
10 g_custom2 VARCHAR2(150) DEFAULT '';
11 g_custom3 VARCHAR2(150) DEFAULT '';
12 g_custom4 VARCHAR2(150) DEFAULT '';
13 g_custom5 VARCHAR2(150) DEFAULT '';
14 g_custom6 VARCHAR2(150) DEFAULT '';
15 g_custom7 VARCHAR2(150) DEFAULT '';
16 g_custom8 VARCHAR2(150) DEFAULT '';
17 g_custom9 VARCHAR2(150) DEFAULT '';
18 g_custom10 VARCHAR2(150) DEFAULT '';
19 g_custom11 VARCHAR2(150) DEFAULT '';
20 g_custom12 VARCHAR2(150) DEFAULT '';
21 g_custom13 VARCHAR2(150) DEFAULT '';
22 g_custom14 VARCHAR2(150) DEFAULT '';
23 g_custom15 VARCHAR2(150) DEFAULT '';
24
25 qa_enabled_cache VARCHAR2(1) DEFAULT NULL;
26 txn_number_cache NUMBER DEFAULT -1;
27 org_id_cache NUMBER DEFAULT -1;
28
29 TYPE ElementRecord IS RECORD (
30 value VARCHAR2(2000),
31 validation_flag VARCHAR2(100) DEFAULT 'invalid');
32
33 TYPE ElementsArray IS TABLE OF ElementRecord INDEX BY BINARY_INTEGER;
34
35 --
36 -- Return 'T' if QA is installed and there is some plans set up
37 -- Return 'F' if otherwise
38 --
39 FUNCTION qa_enabled(
40 p_txn_number IN NUMBER,
41 p_org_id IN NUMBER) RETURN VARCHAR2;
42
43 --
44 -- Return 'T' if there are plans set up for the given transaction
45 -- Return 'F' if otherwise
46 --
47 FUNCTION commit_allowed(
48 p_txn_number IN varchar2,
49 p_org_id IN NUMBER,
50 p_plan_txn_ids IN VARCHAR2,
51 p_collection_id IN NUMBER,
52 x_plan_ids OUT NOCOPY VARCHAR2)
53 RETURN VARCHAR2;
54
55 FUNCTION get_collection_id RETURN NUMBER;
56
57 FUNCTION result_to_array(x_result IN VARCHAR2)
58 RETURN ElementsArray;
59
60 FUNCTION evaluate_triggers(
61 p_txn_number IN NUMBER,
62 p_org_id IN NUMBER,
63 p_context_values IN VARCHAR2,
64 x_plan_txn_ids OUT NOCOPY VARCHAR2)
65 RETURN VARCHAR2;
66
67 PROCEDURE insert_results(
68 p_plan_id IN NUMBER,
69 p_org_id IN NUMBER,
70 p_collection_id IN NUMBER,
71 elements IN ElementsArray);
72
73 PROCEDURE post_background_results(
74 p_txn_number IN NUMBER,
75 p_org_id IN NUMBER,
76 p_plan_txn_ids IN VARCHAR2,
77 p_context_values IN VARCHAR2,
78 p_collection_id IN NUMBER);
79
80 -- Bug 4995406
81 -- Added a procedure to do the processing
82 -- of the Results for Background Collection plans
83 -- for EAM Transaction
84 -- ntungare Wed Feb 22 06:26:17 PST 2006
85 PROCEDURE eam_post_background_results(
86 p_txn_number IN NUMBER,
87 p_org_id IN NUMBER,
88 p_context_values IN VARCHAR2,
89 p_collection_id IN NUMBER);
90
91 FUNCTION get_plan_names(
92 p_plan_ids IN VARCHAR2) RETURN VARCHAR2;
93
94 PROCEDURE relate_results(p_collection_id NUMBER);
95
96
97 --
98 -- Bug 2123065
99 -- Custom parameters used for customization.
100 -- bso Mon Nov 26 11:52:09 PST 2001
101 --
102 PROCEDURE clear_customs;
103 PROCEDURE put_custom1(p_value IN VARCHAR2);
104 PROCEDURE put_custom2(p_value IN VARCHAR2);
105 PROCEDURE put_custom3(p_value IN VARCHAR2);
106 PROCEDURE put_custom4(p_value IN VARCHAR2);
107 PROCEDURE put_custom5(p_value IN VARCHAR2);
108 PROCEDURE put_custom6(p_value IN VARCHAR2);
109 PROCEDURE put_custom7(p_value IN VARCHAR2);
110 PROCEDURE put_custom8(p_value IN VARCHAR2);
111 PROCEDURE put_custom9(p_value IN VARCHAR2);
112 PROCEDURE put_custom10(p_value IN VARCHAR2);
113 PROCEDURE put_custom11(p_value IN VARCHAR2);
114 PROCEDURE put_custom12(p_value IN VARCHAR2);
115 PROCEDURE put_custom13(p_value IN VARCHAR2);
116 PROCEDURE put_custom14(p_value IN VARCHAR2);
117 PROCEDURE put_custom15(p_value IN VARCHAR2);
118 FUNCTION get_custom1 RETURN VARCHAR2;
119 FUNCTION get_custom2 RETURN VARCHAR2;
120 FUNCTION get_custom3 RETURN VARCHAR2;
121 FUNCTION get_custom4 RETURN VARCHAR2;
122 FUNCTION get_custom5 RETURN VARCHAR2;
123 FUNCTION get_custom6 RETURN VARCHAR2;
124 FUNCTION get_custom7 RETURN VARCHAR2;
125 FUNCTION get_custom8 RETURN VARCHAR2;
126 FUNCTION get_custom9 RETURN VARCHAR2;
127 FUNCTION get_custom10 RETURN VARCHAR2;
128 FUNCTION get_custom11 RETURN VARCHAR2;
129 FUNCTION get_custom12 RETURN VARCHAR2;
130 FUNCTION get_custom13 RETURN VARCHAR2;
131 FUNCTION get_custom14 RETURN VARCHAR2;
132 FUNCTION get_custom15 RETURN VARCHAR2;
133
134 -- Bug 4343758
135 -- R12 OAF Txn Integration Project
136 -- shkalyan 05/10/2005.
137 -- This function is used by parent Txns to check whether the Quality
138 -- Results entered during the Transaction can be committed.
139 FUNCTION is_commit_allowed(
140 p_api_version IN NUMBER := NULL,
141 p_init_msg_list IN VARCHAR2 := NULL,
142 p_commit IN VARCHAR2 := NULL,
143 p_validation_level IN NUMBER := NULL,
144 p_txn_number IN NUMBER,
145 p_org_id IN NUMBER,
146 p_txn_header_id IN NUMBER := NULL,
147 p_collection_id IN NUMBER,
148 p_plan_txn_ids IN VARCHAR2 := NULL,
149 x_plan_names OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
150
151 -- Bug 4343758
152 -- R12 OAF Txn Integration Project
153 -- shkalyan 05/07/2005.
154 -- This is an API for performing the post commit processing in
155 -- transaction integration scenario. This API performs the following actions
156 -- Insert Automatic and History Results.
157 -- Post Background results for the transaction.
158 -- Generate Sequence element values.
159 -- Enable the Quality Results
160 -- Fire Background actions.
161 PROCEDURE process_txn_post_commit(
162 p_api_version IN NUMBER := NULL,
163 p_init_msg_list IN VARCHAR2 := NULL,
164 p_commit IN VARCHAR2 := NULL,
165 p_validation_level IN NUMBER := NULL,
166 p_txn_number IN NUMBER,
167 p_org_id IN NUMBER,
168 p_txn_header_id IN NUMBER,
169 p_collection_id IN NUMBER,
170 p_plan_txn_ids IN VARCHAR2 := NULL,
171 p_context_values IN VARCHAR2,
172 p_context_ids IN VARCHAR2 := NULL,
173 p_generated_values IN VARCHAR2 := NULL,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2);
177
178 -- Bug 4343758
179 -- R12 OAF Txn Integration Project
180 -- shkalyan 05/10/2005.
181 -- This function is used for Purging QA Results and their associated
182 -- Records. This API is called when the parent Transaction is Unsuccessful.
183 FUNCTION purge_records(
184 p_txn_number IN NUMBER,
185 p_org_id IN NUMBER,
186 p_txn_header_id IN NUMBER := NULL,
187 p_collection_id IN NUMBER) RETURN NUMBER;
188
189 -- Bug 4343758. OA Integration Project.
190 -- Wrapper around evaluate_triggers.
191 -- Returns comma seperated list of transaction id
192 -- srhariha. Wed May 4 03:12:40 PDT 2005.
193 FUNCTION ssqr_evaluate_triggers(
194 p_txn_number IN NUMBER,
195 p_org_id IN NUMBER,
196 p_context_values IN VARCHAR2)
197 RETURN VARCHAR2;
198
199 -- Added two new methods below for ERES in MES integration.
200 -- saugupta Mon, 07 Jan 2008 05:45:06 -0800 PDT
201
202 -- Method inserts background results, history and automatic results
203 -- and generate sequence Numbers for the applicable plans
204 -- saugupta Mon, 07 Jan 2008 05:46:11 -0800 PDT
205 PROCEDURE process_txn_for_eres(
206 p_api_version IN NUMBER := NULL,
207 p_init_msg_list IN VARCHAR2 := NULL,
208 p_commit IN VARCHAR2 := NULL,
209 p_validation_level IN NUMBER := NULL,
210 p_txn_number IN NUMBER,
211 p_org_id IN NUMBER,
212 p_txn_header_id IN NUMBER,
213 p_collection_id IN NUMBER,
214 p_plan_txn_ids IN VARCHAR2 := NULL,
215 p_context_values IN VARCHAR2,
216 p_context_ids IN VARCHAR2 := NULL,
217 p_generated_values IN VARCHAR2 := NULL,
218 x_return_status OUT NOCOPY VARCHAR2,
219 x_msg_count OUT NOCOPY NUMBER,
220 x_msg_data OUT NOCOPY VARCHAR2);
221
222 -- Enable and fire background actions in case of ERES
223 -- saugupta Mon, 07 Jan 2008 05:46:40 -0800 PDT
224 PROCEDURE enable_and_fire_action (
225 p_api_version IN NUMBER := NULL,
226 p_init_msg_list IN VARCHAR2 := NULL,
227 p_commit IN VARCHAR2 := NULL,
228 p_validation_level IN NUMBER := NULL,
229 p_collection_id IN NUMBER,
230 x_return_status OUT NOCOPY VARCHAR2,
231 x_msg_count OUT NOCOPY NUMBER,
232 x_msg_data OUT NOCOPY VARCHAR2 );
233
234
235 END qa_txn_grp;
236