DBA Data[Home] [Help]

APPS.PO_MULTI_MOD_VALIDATIONS dependencies on PO_MULTI_MOD_VAL_RESULTS_TYPE

Line 68: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

64:
65: PROCEDURE validate_multi_mod( p_multi_mod_request_id IN NUMBER
66: ,p_validation_type IN VARCHAR2 DEFAULT NULL
67: ,x_result_type OUT NOCOPY VARCHAR2
68: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
69: );
70:
71: PROCEDURE validate_set( p_validation_set IN PO_TBL_VARCHAR2000
72: ,p_multi_mod_request_id IN NUMBER

Line 85: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

81: ,p_multi_mod_docs IN PO_MULTI_MOD_DOCS_VAL_TYPE
82: ,p_multi_mod_changes IN PO_MULTI_MOD_CHANGES_VAL_TYPE
83: ,p_validation_type IN VARCHAR2
84: ,x_result_type OUT NOCOPY VARCHAR2
85: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
86: );
87:
88:
89: PROCEDURE atleast_one_doc_selected

Line 94: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

90: ( p_request_id IN NUMBER
91: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
92: ,p_validation_type IN VARCHAR2
93: ,x_result_type OUT NOCOPY VARCHAR2
94: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
95: );
96:
97:
98: PROCEDURE exemption_reason_given

Line 104: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

100: ,p_exemption_reason IN VARCHAR2
101: ,p_initiate_app_flag IN VARCHAR2
102: ,p_validation_type IN VARCHAR2
103: ,x_result_type OUT NOCOPY VARCHAR2
104: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
105: );
106:
107:
108:

Line 121: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

117: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER
118: ,p_new_vendor_contact_id_tbl IN PO_TBL_NUMBER
119: ,p_validation_type IN VARCHAR2
120: ,x_result_type OUT NOCOPY VARCHAR2
121: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
122: );
123:
124:
125: PROCEDURE vendor_name_chg_valid

Line 133: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

129: ,p_old_vendor_name_tbl PO_TBL_VARCHAR240
130: ,p_new_vendor_name_tbl PO_TBL_VARCHAR240
131: ,p_validation_type IN VARCHAR2
132: ,x_result_type OUT NOCOPY VARCHAR2
133: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
134: );
135:
136: PROCEDURE new_vendor_on_hold
137: ( p_request_id IN NUMBER

Line 143: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

139: ,p_change_type_tbl PO_TBL_VARCHAR30
140: ,p_new_vendor_id_tbl PO_TBL_NUMBER
141: ,p_validation_type IN VARCHAR2
142: ,x_result_type OUT NOCOPY VARCHAR2
143: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
144: );
145:
146: PROCEDURE vendor_chg_valid
147: ( p_request_id IN NUMBER

Line 154: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

150: ,p_old_vendor_id_tbl PO_TBL_NUMBER
151: ,p_new_vendor_id_tbl PO_TBL_NUMBER
152: ,p_validation_type IN VARCHAR2
153: ,x_result_type OUT NOCOPY VARCHAR2
154: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
155: );
156:
157: PROCEDURE no_of_copies_ge_zero
158: ( p_request_id IN NUMBER

Line 163: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

159: ,p_acceptance_reqd_flag IN VARCHAR2
160: ,p_clm_noofcopies IN NUMBER
161: ,p_validation_type IN VARCHAR2
162: ,x_result_type OUT NOCOPY VARCHAR2
163: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
164: );
165:
166: PROCEDURE acceptance_due_date_valid
167: ( p_request_id IN NUMBER

Line 172: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

168: ,p_acceptance_reqd_flag IN VARCHAR2
169: ,p_acceptance_due_date IN DATE
170: ,p_validation_type IN VARCHAR2
171: ,x_result_type OUT NOCOPY VARCHAR2
172: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
173: );
174:
175: PROCEDURE clause_change_valid
176: ( p_request_id IN NUMBER

Line 179: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

175: PROCEDURE clause_change_valid
176: ( p_request_id IN NUMBER
177: ,p_validation_type IN VARCHAR2
178: ,x_result_type OUT NOCOPY VARCHAR2
179: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
180: );
181:
182: PROCEDURE atleast_one_change_done
183: ( p_request_id IN NUMBER

Line 187: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

183: ( p_request_id IN NUMBER
184: ,p_change_id_tbl IN PO_TBL_NUMBER
185: ,p_validation_type IN VARCHAR2
186: ,x_result_type OUT NOCOPY VARCHAR2
187: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
188: );
189:
190: PROCEDURE new_vendor_site_provided
191: ( p_request_id IN NUMBER

Line 199: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

195: ,p_old_vendor_site_id_tbl IN PO_TBL_NUMBER
196: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER
197: ,p_validation_type IN VARCHAR2
198: ,x_result_type OUT NOCOPY VARCHAR2
199: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
200: );
201:
202: PROCEDURE new_vendor_site_CCR_valid
203: ( p_request_id IN NUMBER

Line 210: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

206: ,p_old_vendor_site_id_tbl IN PO_TBL_NUMBER
207: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER
208: ,p_validation_type IN VARCHAR2
209: ,x_result_type OUT NOCOPY VARCHAR2
210: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
211: );
212:
213: PROCEDURE generate_idv_exceptions
214: ( p_request_id IN NUMBER

Line 218: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

214: ( p_request_id IN NUMBER
215: --,p_document_id_tbl IN PO_TBL_NUMBER
216: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
217: ,x_result_type OUT NOCOPY VARCHAR2
218: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
219: );
220:
221: PROCEDURE generate_award_exceptions
222: ( p_request_id IN NUMBER

Line 226: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

222: ( p_request_id IN NUMBER
223: -- ,p_document_id_tbl IN PO_TBL_NUMBER
224: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
225: ,x_result_type OUT NOCOPY VARCHAR2
226: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
227: );
228:
229: PROCEDURE generate_receipts_exceptions
230: ( p_request_id IN NUMBER

Line 235: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

231: ,p_document_id_tbl IN PO_TBL_NUMBER
232: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
233: ,p_novation_effective_date IN DATE
234: ,x_result_type OUT NOCOPY VARCHAR2
235: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
236: );
237:
238: PROCEDURE generate_project_exceptions
239: ( p_request_id IN NUMBER

Line 244: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

240: ,p_document_id_tbl IN PO_TBL_NUMBER
241: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
242: ,p_novation_effective_date IN DATE
243: ,x_result_type OUT NOCOPY VARCHAR2
244: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
245: );
246:
247: PROCEDURE generate_invoice_exceptions
248: ( p_request_id IN NUMBER

Line 253: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

249: ,p_document_id_tbl IN PO_TBL_NUMBER
250: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
251: ,p_novation_effective_date IN DATE
252: ,x_result_type OUT NOCOPY VARCHAR2
253: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
254: );
255:
256: PROCEDURE set_validation_status( p_multi_mod_request_id IN NUMBER
257: ,p_validation_status IN VARCHAR2

Line 272: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

268: );
269:
270: PROCEDURE uda_addresses_valid( p_request_id IN NUMBER
271: ,x_result_type OUT NOCOPY VARCHAR2
272: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
273: );
274:
275: PROCEDURE contract_officer_provided
276: ( p_request_id IN NUMBER

Line 281: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

277: ,p_clm_contract_officer IN NUMBER
278: ,p_validation_type IN VARCHAR2
279: ,p_org_id_tbl IN PO_TBL_NUMBER -- Added this parameter as part of CLM Controls Project
280: ,x_result_type OUT NOCOPY VARCHAR2
281: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
282: );
283:
284: /* Checks if compatible locks at header level are available to make the requested
285: changes.

Line 289: , x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE);

285: changes.
286: */
287: PROCEDURE header_lock_compatible(p_request_id IN NUMBER
288: , x_result_type OUT NOCOPY VARCHAR2
289: , x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE);
290:
291: /* Checks if compatible lock at any address is available to make the requested
292: changes at that particular address.
293: */

Line 296: , x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE);

292: changes at that particular address.
293: */
294: PROCEDURE address_lock_compatible(p_request_id IN NUMBER
295: , x_result_type OUT NOCOPY VARCHAR2
296: , x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE);
297:
298: /* Checks if there already exists an open modification if conc modifications
299: */
300: PROCEDURE validate_open_mod(p_request_id IN NUMBER

Line 302: , x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE);

298: /* Checks if there already exists an open modification if conc modifications
299: */
300: PROCEDURE validate_open_mod(p_request_id IN NUMBER
301: , x_result_type OUT NOCOPY VARCHAR2
302: , x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE);
303:
304:
305: END PO_MULTI_MOD_VALIDATIONS;
306: