DBA Data[Home] [Help]

APPS.PO_MULTI_MOD_VALIDATIONS dependencies on PO_TBL_VARCHAR2000

Line 172: c_address_change_vs CONSTANT PO_TBL_VARCHAR2000 :=

168:
169:
170:
171: --validation set for Address change
172: c_address_change_vs CONSTANT PO_TBL_VARCHAR2000 :=
173: PO_TBL_VARCHAR2000(
174: c_atleast_one_doc_selected
175: , c_exemption_reason_given
176: , c_new_vendor_contact_provided

Line 173: PO_TBL_VARCHAR2000(

169:
170:
171: --validation set for Address change
172: c_address_change_vs CONSTANT PO_TBL_VARCHAR2000 :=
173: PO_TBL_VARCHAR2000(
174: c_atleast_one_doc_selected
175: , c_exemption_reason_given
176: , c_new_vendor_contact_provided
177: , c_clause_change_valid

Line 189: c_vendor_name_change_vs CONSTANT PO_TBL_VARCHAR2000 :=

185: , c_validate_open_mod
186: );
187:
188: --validation set for vendor name change
189: c_vendor_name_change_vs CONSTANT PO_TBL_VARCHAR2000 :=
190: PO_TBL_VARCHAR2000(
191: c_atleast_one_doc_selected
192: , c_exemption_reason_given
193: , c_new_vendor_contact_provided

Line 190: PO_TBL_VARCHAR2000(

186: );
187:
188: --validation set for vendor name change
189: c_vendor_name_change_vs CONSTANT PO_TBL_VARCHAR2000 :=
190: PO_TBL_VARCHAR2000(
191: c_atleast_one_doc_selected
192: , c_exemption_reason_given
193: , c_new_vendor_contact_provided
194: , c_clause_change_valid

Line 204: c_vendor_change_vs CONSTANT PO_TBL_VARCHAR2000 :=

200: , c_validate_open_mod
201: );
202:
203: --validation set for vendor change
204: c_vendor_change_vs CONSTANT PO_TBL_VARCHAR2000 :=
205: PO_TBL_VARCHAR2000(
206: c_atleast_one_doc_selected
207: , c_exemption_reason_given
208: , c_new_vendor_contact_provided

Line 205: PO_TBL_VARCHAR2000(

201: );
202:
203: --validation set for vendor change
204: c_vendor_change_vs CONSTANT PO_TBL_VARCHAR2000 :=
205: PO_TBL_VARCHAR2000(
206: c_atleast_one_doc_selected
207: , c_exemption_reason_given
208: , c_new_vendor_contact_provided
209: , c_clause_change_valid

Line 222: c_vendor_change_exception_vs CONSTANT PO_TBL_VARCHAR2000 :=

218: , c_validate_open_mod
219: );
220:
221: --validation set for Supplier change - exceptions concurrent program
222: c_vendor_change_exception_vs CONSTANT PO_TBL_VARCHAR2000 :=
223: PO_TBL_VARCHAR2000(
224: c_generate_idv_exceptions
225: , c_generate_award_exceptions
226: , c_generate_receipts_exceptions

Line 223: PO_TBL_VARCHAR2000(

219: );
220:
221: --validation set for Supplier change - exceptions concurrent program
222: c_vendor_change_exception_vs CONSTANT PO_TBL_VARCHAR2000 :=
223: PO_TBL_VARCHAR2000(
224: c_generate_idv_exceptions
225: , c_generate_award_exceptions
226: , c_generate_receipts_exceptions
227: , c_generate_invoice_exceptions

Line 262: l_validation_set PO_TBL_VARCHAR2000;

258: ,x_result_type OUT NOCOPY VARCHAR2
259: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
260: )
261: is
262: l_validation_set PO_TBL_VARCHAR2000;
263: l_multi_mod_request_type PO_MULTI_MOD_REQUESTS.multi_mod_request_type%type;
264: l_novation_effective_date PO_MULTI_MOD_REQUESTS.novation_effective_date%TYPE;
265: l_acceptance_reqd_flag PO_MULTI_MOD_REQUESTS.acceptance_required_flag%TYPE;
266: l_acceptance_due_date PO_MULTI_MOD_REQUESTS.acceptance_due_date%TYPE;

Line 284: l_validation_set := PO_TBL_VARCHAR2000();

280: END IF;
281:
282:
283: d_position := 10;
284: l_validation_set := PO_TBL_VARCHAR2000();
285: IF PO_LOG.d_stmt THEN
286: PO_LOG.stmt(d_mod,d_position,'l_validation_set',l_validation_set);
287: PO_LOG.stmt(d_mod,d_position,'p_validation_type',p_validation_type);
288: PO_LOG.stmt(d_mod,d_position,'p_multi_mod_request_id',p_multi_mod_request_id);

Line 532: PROCEDURE validate_set( p_validation_set IN PO_TBL_VARCHAR2000

528: --x_results
529: -- Out variable that holds the validation results
530: --End of Comments
531: -------------------------------------------------------------------------------
532: PROCEDURE validate_set( p_validation_set IN PO_TBL_VARCHAR2000
533: ,p_multi_mod_request_id IN NUMBER
534: ,p_multi_mod_request_type IN VARCHAR2
535: ,p_novation_effective_date DATE
536: ,p_acceptance_reqd_flag IN VARCHAR2

Line 2851: l_address_code_tbl PO_TBL_VARCHAR2000;

2847: d_position NUMBER := 0;
2848: d_stmt CONSTANT BOOLEAN := PO_LOG.d_stmt;
2849: d_mod CONSTANT VARCHAR2(2000) := D_address_lock_compatible;
2850: l_addr_attr_group_id NUMBER;
2851: l_address_code_tbl PO_TBL_VARCHAR2000;
2852: l_sum_check_tbl PO_TBL_NUMBER;
2853: l_document_id_tbl PO_TBL_NUMBER;
2854: l_modification_number_tbl PO_TBL_VARCHAR100;
2855: l_document_number_tbl PO_TBL_VARCHAR100;