DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS dependencies on PO_VALIDATION_RESULTS_TYPE

Line 108: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

104: ---------------------------------------------------------------------------
105: PROCEDURE price_update_tol_ge_zero(
106: p_header_id_tbl IN PO_TBL_NUMBER
107: , p_price_update_tol_tbl IN PO_TBL_NUMBER
108: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
109: , x_result_type OUT NOCOPY VARCHAR2
110: )
111: IS
112: BEGIN

Line 136: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

132: ---------------------------------------------------------------------------
133: PROCEDURE amount_limit_ge_zero(
134: p_header_id_tbl IN PO_TBL_NUMBER
135: , p_amount_limit_tbl IN PO_TBL_NUMBER
136: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
137: , x_result_type OUT NOCOPY VARCHAR2
138: )
139: IS
140: BEGIN

Line 165: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

161: PROCEDURE amt_limit_ge_amt_agreed(
162: p_header_id_tbl IN PO_TBL_NUMBER
163: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
164: , p_amount_limit_tbl IN PO_TBL_NUMBER
165: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
166: , x_result_type OUT NOCOPY VARCHAR2
167: )
168: IS
169: BEGIN

Line 193: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

189: ---------------------------------------------------------------------------
190: PROCEDURE amount_agreed_ge_zero(
191: p_header_id_tbl IN PO_TBL_NUMBER
192: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
193: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
194: , x_result_type OUT NOCOPY VARCHAR2
195: )
196: IS
197: BEGIN

Line 222: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

218: PROCEDURE amount_agreed_not_null(
219: p_header_id_tbl IN PO_TBL_NUMBER
220: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
221: , p_amount_limit_tbl IN PO_TBL_NUMBER
222: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
223: , x_result_type OUT NOCOPY VARCHAR2
224: )
225: IS
226: d_mod CONSTANT VARCHAR2(100) := D_amount_agreed_not_null;

Line 238: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

234: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
235: END IF;
236:
237: IF (x_results IS NULL) THEN
238: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
239: END IF;
240:
241: l_results_count := x_results.result_type.COUNT;
242:

Line 356: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

352: ---------------------------------------------------------------------------
353: PROCEDURE rate_gt_zero(
354: p_header_id_tbl IN PO_TBL_NUMBER
355: , p_rate_tbl IN PO_TBL_NUMBER
356: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
357: , x_result_type OUT NOCOPY VARCHAR2
358: )
359: IS
360: BEGIN

Line 391: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

387: , p_currency_code_tbl IN PO_TBL_VARCHAR30
388: , p_rate_type_tbl IN PO_TBL_VARCHAR30
389: , p_rate_date_tbl IN PO_TBL_DATE
390: , p_rate_tbl IN PO_TBL_NUMBER
391: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
392: , x_result_type OUT NOCOPY VARCHAR2
393: )
394: IS
395: d_mod CONSTANT VARCHAR2(100) := D_rate_combination_valid;

Line 411: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

407: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
408: END IF;
409:
410: IF (x_results IS NULL) THEN
411: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
412: END IF;
413:
414: l_results_count := x_results.result_type.COUNT;
415:

Line 501: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

497: p_header_id_tbl IN PO_TBL_NUMBER
498: , p_supplier_notif_method_tbl IN PO_TBL_VARCHAR30
499: , p_fax_tbl IN PO_TBL_VARCHAR30
500: , p_email_address_tbl IN PO_TBL_VARCHAR2000
501: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
502: , x_result_type OUT NOCOPY VARCHAR2
503: )
504: IS
505: d_mod CONSTANT VARCHAR2(100) := D_fax_email_address_valid;

Line 518: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

514: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
515: END IF;
516:
517: IF (x_results IS NULL) THEN
518: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
519: END IF;
520:
521: l_results_count := x_results.result_type.COUNT;
522:

Line 575: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

571: PROCEDURE effective_le_expiration(
572: p_header_id_tbl IN PO_TBL_NUMBER
573: , p_start_date_tbl IN PO_TBL_DATE
574: , p_end_date_tbl IN PO_TBL_DATE
575: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
576: , x_result_type OUT NOCOPY VARCHAR2
577: )
578: IS
579: BEGIN

Line 926: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

922: PROCEDURE doc_num_chars_valid(
923: p_header_id_tbl IN PO_TBL_NUMBER
924: , p_org_id_tbl IN PO_TBL_NUMBER
925: , p_segment1_tbl IN PO_TBL_VARCHAR30
926: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
927: , x_result_type OUT NOCOPY VARCHAR2
928: )
929: IS
930: d_mod CONSTANT VARCHAR2(100) := D_doc_num_chars_valid;

Line 947: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

943: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
944: END IF;
945:
946: IF (x_results IS NULL) THEN
947: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
948: END IF;
949:
950: l_results_count := x_results.result_type.COUNT;
951:

Line 1030: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1026: p_header_id_tbl IN PO_TBL_NUMBER
1027: , p_org_id_tbl IN PO_TBL_NUMBER
1028: , p_segment1_tbl IN PO_TBL_VARCHAR30
1029: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1030: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1031: , x_result_type OUT NOCOPY VARCHAR2
1032: )
1033: IS
1034: d_mod CONSTANT VARCHAR2(100) := D_doc_num_unique;

Line 1061: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

1057:
1058: d_position := 1;
1059:
1060: IF (x_results IS NULL) THEN
1061: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1062: END IF;
1063:
1064: l_results_count := x_results.result_type.COUNT;
1065:

Line 1547: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1543: -------------------------------------------------------------------------------
1544: PROCEDURE agent_id_not_null(
1545: p_header_id_tbl IN PO_TBL_NUMBER
1546: , p_agent_id_tbl IN PO_TBL_NUMBER
1547: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1548: , x_result_type OUT NOCOPY VARCHAR2
1549: )
1550: IS
1551: BEGIN

Line 1573: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1569: -------------------------------------------------------------------------------
1570: PROCEDURE ship_to_loc_not_null(
1571: p_header_id_tbl IN PO_TBL_NUMBER
1572: , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER
1573: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1574: , x_result_type OUT NOCOPY VARCHAR2
1575: )
1576: IS
1577: BEGIN

Line 1599: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1595: -------------------------------------------------------------------------------
1596: PROCEDURE vendor_id_not_null(
1597: p_header_id_tbl IN PO_TBL_NUMBER
1598: , p_vendor_id_tbl IN PO_TBL_NUMBER
1599: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1600: , x_result_type OUT NOCOPY VARCHAR2
1601: )
1602: IS
1603: BEGIN

Line 1625: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1621: -------------------------------------------------------------------------------
1622: PROCEDURE vendor_site_id_not_null(
1623: p_header_id_tbl IN PO_TBL_NUMBER
1624: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
1625: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1626: , x_result_type OUT NOCOPY VARCHAR2
1627: )
1628: IS
1629: BEGIN