eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
TYPE BODY: APPS.PO_MULTI_MOD_VAL_RESULTS_TYPE

Source


1 TYPE BODY po_multi_mod_val_results_type AS
2 
3 
4 /**
5  * Start of Comments
6  * Function:
7  *   Creates an empty instance of this type, with all attributes set to NULL.
8  *   Generally, this constructor should not be used by outside callers.
9  * Returns:
10  *   An empty instance of this type.
11  * End of Comments
12  */
13 CONSTRUCTOR FUNCTION PO_MULTI_MOD_VAL_RESULTS_TYPE RETURN SELF AS RESULT
14 IS
15 BEGIN
16 RETURN;
17 END;
18 
19 /**
20  * Creates a new instance of this type, with all attributes initialized
21  * to empty tables.
22  */
23 STATIC FUNCTION new_instance
24 RETURN PO_MULTI_MOD_VAL_RESULTS_TYPE
25 IS
26 l_instance PO_MULTI_MOD_VAL_RESULTS_TYPE;
27 BEGIN
28 l_instance := PO_MULTI_MOD_VAL_RESULTS_TYPE();
29 l_instance.initialize();
30 RETURN l_instance;
31 END new_instance;
32 
33 
34 /**
35  * Start of Comments
36  * Pre-reqs: None.
37  * Modifies: SELF.
38  * Locks: None.
39  * Function:
40  *   Sets all of the attributes of this object to be empty tables
41  *   of the appropriate type.
42  * End of Comments
43  */
44 MEMBER PROCEDURE initialize
45 IS
46 BEGIN
47  MULTI_MOD_VAL_RESULT_ID			:= PO_TBL_NUMBER();
48  MULTI_MOD_REQUEST_ID 				:= PO_TBL_NUMBER();
49  MULTI_MOD_DOC_ID					:= PO_TBL_NUMBER();
50  VALIDATION_TYPE					:= PO_TBL_VARCHAR30();
51  EXCEPTION_TYPE						:= PO_TBL_VARCHAR30();
52  RESULT_TYPE						:= PO_TBL_VARCHAR30();
53  DOCUMENT_ID						:= PO_TBL_NUMBER();
54  DOCUMENT_NUMBER					:= PO_TBL_VARCHAR50();
55  RELATED_DOCUMENT_ID				:= PO_TBL_NUMBER();
56  RELATED_DOCUMENT_NUMBER			:= PO_TBL_VARCHAR50();
57  RELATED_DOCUMENT_DATE				:= PO_TBL_DATE();
58  RELATED_DOCUMENT_AMOUNT			:= PO_TBL_NUMBER();
59  MESSAGE_APPLICATION				:= PO_TBL_VARCHAR30();
60  MESSAGE_NAME						:= PO_TBL_VARCHAR30();
61  TOKEN1_NAME						:= PO_TBL_VARCHAR30();
62  TOKEN1_VALUE						:= PO_TBL_VARCHAR4000();
63  TOKEN2_NAME						:= PO_TBL_VARCHAR30();
64  TOKEN2_VALUE						:= PO_TBL_VARCHAR4000();
65  TOKEN3_NAME						:= PO_TBL_VARCHAR30();
66  TOKEN3_VALUE						:= PO_TBL_VARCHAR4000();
67  TOKEN4_NAME						:= PO_TBL_VARCHAR30();
68  TOKEN4_VALUE						:= PO_TBL_VARCHAR4000();
69  TOKEN5_NAME						:= PO_TBL_VARCHAR30();
70  TOKEN5_VALUE						:= PO_TBL_VARCHAR4000();
71  TOKEN6_NAME						:= PO_TBL_VARCHAR30();
72  TOKEN6_VALUE						:= PO_TBL_VARCHAR4000();
73  MESSAGE_TEXT           := PO_TBL_VARCHAR4000();
74 END initialize;
75 
76 
77 MEMBER PROCEDURE extend
78 IS
79 BEGIN
80  MULTI_MOD_VAL_RESULT_ID.EXTEND();
81  MULTI_MOD_REQUEST_ID.EXTEND();
82  MULTI_MOD_DOC_ID.EXTEND();
83  VALIDATION_TYPE.EXTEND();
84  EXCEPTION_TYPE.EXTEND();
85  RESULT_TYPE.EXTEND();
86  DOCUMENT_ID.EXTEND();
87  DOCUMENT_NUMBER.EXTEND();
88  RELATED_DOCUMENT_ID.EXTEND();
89  RELATED_DOCUMENT_NUMBER.EXTEND();
90  RELATED_DOCUMENT_DATE.EXTEND();
91  RELATED_DOCUMENT_AMOUNT.EXTEND();
92  MESSAGE_APPLICATION.EXTEND();
93  MESSAGE_NAME.EXTEND();
94  TOKEN1_NAME.EXTEND();
95  TOKEN1_VALUE.EXTEND();
96  TOKEN2_NAME.EXTEND();
97  TOKEN2_VALUE.EXTEND();
98  TOKEN3_NAME.EXTEND();
99  TOKEN3_VALUE.EXTEND();
100  TOKEN4_NAME.EXTEND();
101  TOKEN4_VALUE.EXTEND();
102  TOKEN5_NAME.EXTEND();
103  TOKEN5_VALUE.EXTEND();
104  TOKEN6_NAME.EXTEND();
105  TOKEN6_VALUE.EXTEND();
106  MESSAGE_TEXT.EXTEND();
107 END extend;
108 
109 /**
110  * Start of Comments
111  * Pre-reqs: The attribute tables have been initialized.
112  * Modifies: SELF.
113  * Function:
114  *   Adds a record to this result set.
115  * End of Comments
116  */
117 MEMBER PROCEDURE add_result(
118   p_multi_mod_val_result_id			IN NUMBER
119 , p_multi_mod_request_id 			IN NUMBER
120 , p_multi_mod_doc_id				IN NUMBER DEFAULT NULL
121 , p_validation_type					IN VARCHAR2
122 , p_exception_type					IN VARCHAR2 DEFAULT NULL
123 , p_result_type						IN VARCHAR2 DEFAULT NULL
124 , p_document_id						IN NUMBER DEFAULT NULL
125 , p_document_number					IN VARCHAR2 DEFAULT NULL
126 , p_related_document_id				IN NUMBER DEFAULT NULL
127 , p_related_document_number			IN VARCHAR2 DEFAULT NULL
128 , p_related_document_date			IN VARCHAR2 DEFAULT NULL
129 , p_related_document_amount			IN NUMBER DEFAULT NULL
130 , p_message_application				IN VARCHAR2 DEFAULT NULL
131 , p_message_name					IN VARCHAR2
132 , p_token1_name						IN VARCHAR2 DEFAULT NULL
133 , p_token1_value					IN VARCHAR2 DEFAULT NULL
134 , p_token2_name						IN VARCHAR2 DEFAULT NULL
135 , p_token2_value					IN VARCHAR2 DEFAULT NULL
136 , p_token3_name						IN VARCHAR2 DEFAULT NULL
137 , p_token3_value					IN VARCHAR2 DEFAULT NULL
138 , p_token4_name						IN VARCHAR2 DEFAULT NULL
139 , p_token4_value					IN VARCHAR2 DEFAULT NULL
140 , p_token5_name						IN VARCHAR2 DEFAULT NULL
141 , p_token5_value					IN VARCHAR2 DEFAULT NULL
142 , p_token6_name						IN VARCHAR2 DEFAULT NULL
143 , p_token6_value					IN VARCHAR2 DEFAULT NULL
144 , p_message_text          IN VARCHAR2 DEFAULT NULL
145 )
146 IS
147 l_count NUMBER;
148 BEGIN
149 SELF.extend();
150 
151  l_count := result_type.COUNT();
152  MULTI_MOD_VAL_RESULT_ID(L_COUNT)			:= NVL(p_multi_mod_val_result_id,po_multi_mod_val_results_s.nextval);
153  MULTI_MOD_REQUEST_ID (L_COUNT)				:= p_multi_mod_request_id ;
154  MULTI_MOD_DOC_ID(L_COUNT)					:= p_multi_mod_doc_id;
155  VALIDATION_TYPE(L_COUNT)					:= p_validation_type;
156  EXCEPTION_TYPE(L_COUNT)					:= p_exception_type;
157  RESULT_TYPE(L_COUNT)						:= p_result_type;
158  DOCUMENT_ID(L_COUNT)						:= p_document_id;
159  DOCUMENT_NUMBER(L_COUNT)					:= p_document_number;
160  RELATED_DOCUMENT_ID(L_COUNT)				:= p_related_document_id;
161  RELATED_DOCUMENT_NUMBER(L_COUNT)			:= p_related_document_number;
162  RELATED_DOCUMENT_DATE(L_COUNT)				:= p_related_document_date;
163  RELATED_DOCUMENT_AMOUNT(L_COUNT)			:= p_related_document_amount;
164  MESSAGE_APPLICATION(L_COUNT)				:= p_message_application;
165  MESSAGE_NAME(L_COUNT)						:= p_message_name;
166  TOKEN1_NAME(L_COUNT)						:= p_token1_name;
167  TOKEN1_VALUE(L_COUNT)						:= p_token1_value;
168  TOKEN2_NAME(L_COUNT)						:= p_token2_name;
169  TOKEN2_VALUE(L_COUNT)						:= p_token2_value;
170  TOKEN3_NAME(L_COUNT)						:= p_token3_name;
171  TOKEN3_VALUE(L_COUNT)						:= p_token3_value;
172  TOKEN4_NAME(L_COUNT)						:= p_token4_name;
173  TOKEN4_VALUE(L_COUNT)						:= p_token4_value;
174  TOKEN5_NAME(L_COUNT)						:= p_token5_name;
175  TOKEN5_VALUE(L_COUNT)						:= p_token5_value;
176  TOKEN6_NAME(L_COUNT)						:= p_token6_name;
177  TOKEN6_VALUE(L_COUNT)						:= p_token6_value;
178  MESSAGE_TEXT(L_COUNT)          := p_message_text;
179 
180 END add_result;
181 
182 /**
183  * Appends the input results to this results object.
184  */
185 MEMBER PROCEDURE append(
186   p_results IN  PO_MULTI_MOD_VAL_RESULTS_TYPE
187 )
188 IS
189 l_count NUMBER;
190 BEGIN
191 
192 IF (p_results IS NOT NULL AND p_results.result_type IS NOT NULL) THEN
193 
194   l_count := SELF.result_type.COUNT();
195 
196   FOR i IN 1 .. p_results.result_type.COUNT() LOOP
197 
198     SELF.extend();
199     l_count := l_count + 1;
200  SELF.MULTI_MOD_VAL_RESULT_ID(L_COUNT)			:= p_results.multi_mod_val_result_id(i);
201  SELF.MULTI_MOD_REQUEST_ID (L_COUNT)			:= p_results.multi_mod_request_id(i) ;
202  SELF.MULTI_MOD_DOC_ID(L_COUNT)					:= p_results.multi_mod_doc_id(i);
203  SELF.VALIDATION_TYPE(L_COUNT)					:= p_results.validation_type(i);
204  SELF.EXCEPTION_TYPE(L_COUNT)					:= p_results.exception_type(i);
205  SELF.RESULT_TYPE(L_COUNT)						:= p_results.result_type(i);
206  SELF.DOCUMENT_ID(L_COUNT)						:= p_results.document_id(i);
207  SELF.DOCUMENT_NUMBER(L_COUNT)					:= p_results.document_number(i);
208  SELF.RELATED_DOCUMENT_ID(L_COUNT)				:= p_results.related_document_id(i);
209  SELF.RELATED_DOCUMENT_NUMBER(L_COUNT)			:= p_results.related_document_number(i);
210  SELF.RELATED_DOCUMENT_DATE(L_COUNT)			:= p_results.related_document_date(i);
211  SELF.RELATED_DOCUMENT_AMOUNT(L_COUNT)			:= p_results.related_document_amount(i);
212  SELF.MESSAGE_APPLICATION(L_COUNT)				:= p_results.message_application(i);
213  SELF.MESSAGE_NAME(L_COUNT)						:= p_results.message_name(i);
214  SELF.TOKEN1_NAME(L_COUNT)						:= p_results.token1_name(i);
215  SELF.TOKEN1_VALUE(L_COUNT)						:= p_results.token1_value(i);
216  SELF.TOKEN2_NAME(L_COUNT)						:= p_results.token2_name(i);
217  SELF.TOKEN2_VALUE(L_COUNT)						:= p_results.token2_value(i);
218  SELF.TOKEN3_NAME(L_COUNT)						:= p_results.token3_name(i);
219  SELF.TOKEN3_VALUE(L_COUNT)						:= p_results.token3_value(i);
220  SELF.TOKEN4_NAME(L_COUNT)						:= p_results.token4_name(i);
221  SELF.TOKEN4_VALUE(L_COUNT)						:= p_results.token4_value(i);
222  SELF.TOKEN5_NAME(L_COUNT)						:= p_results.token5_name(i);
223  SELF.TOKEN5_VALUE(L_COUNT)						:= p_results.token5_value(i);
224  SELF.TOKEN6_NAME(L_COUNT)						:= p_results.token6_name(i);
225  SELF.TOKEN6_VALUE(L_COUNT)						:= p_results.token6_value(i);
226  SELF.MESSAGE_TEXT(L_COUNT)           := p_results.message_text(I);
227  END LOOP;
228 
229 END IF;
230 
231 END append;
232 
233 END;