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.

APPS.PO_VALIDATION_HELPER dependencies on PO_TBL_VARCHAR4000

Line 287: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,

283: p_message_name IN VARCHAR2 DEFAULT NULL,
284: p_token1_name IN VARCHAR2 DEFAULT NULL,
285: p_token1_value IN VARCHAR2 DEFAULT NULL,
286: p_token2_name IN VARCHAR2 DEFAULT NULL,
287: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
288: p_validation_id IN NUMBER DEFAULT NULL,
289: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
290: x_result_type OUT NOCOPY VARCHAR2)
291: IS

Line 297: l_token2_value_tbl PO_TBL_VARCHAR4000;

293: d_mod CONSTANT VARCHAR2(100) := D_greater_or_equal_zero;
294: l_results_count NUMBER;
295: l_null_not_allowed BOOLEAN;
296: l_message_name VARCHAR2(30);
297: l_token2_value_tbl PO_TBL_VARCHAR4000;
298:
299: BEGIN
300:
301: IF PO_LOG.d_proc THEN

Line 321: l_token2_value_tbl := PO_TBL_VARCHAR4000();

317: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
318: END IF;
319:
320: IF (p_token2_value_tbl IS NULL) THEN
321: l_token2_value_tbl := PO_TBL_VARCHAR4000();
322: l_token2_value_tbl.extend(p_value_tbl.COUNT);
323: ELSE
324: l_token2_value_tbl := p_token2_value_tbl;
325: END IF;

Line 430: , p_token1_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL

426: , p_entity_type IN VARCHAR2
427: , p_column_name IN VARCHAR2
428: , p_message_name IN VARCHAR2 DEFAULT NULL
429: , p_token1_name IN VARCHAR2 DEFAULT NULL
430: , p_token1_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL
431: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
432: , x_result_type OUT NOCOPY VARCHAR2
433: )
434: IS

Line 439: l_token1_value_tbl PO_TBL_VARCHAR4000;

435: d_mod CONSTANT VARCHAR2(100) := D_within_percentage_range;
436: l_results_count NUMBER;
437: l_null_not_allowed BOOLEAN;
438: l_message_name VARCHAR2(30);
439: l_token1_value_tbl PO_TBL_VARCHAR4000;
440: BEGIN
441:
442: IF PO_LOG.d_proc THEN
443: PO_LOG.proc_begin(p_calling_module);

Line 470: l_token1_value_tbl := PO_TBL_VARCHAR4000();

466:
467: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_PERCENT);
468:
469: IF (p_token1_value_tbl IS NULL) THEN
470: l_token1_value_tbl := PO_TBL_VARCHAR4000();
471: l_token1_value_tbl.extend(p_value_tbl.COUNT);
472: ELSE
473: l_token1_value_tbl := p_token1_value_tbl;
474: END IF;

Line 710: p_value_tbl IN PO_TBL_VARCHAR4000,

706: --End of Comments
707: -------------------------------------------------------------------------------
708: PROCEDURE not_null(
709: p_calling_module IN VARCHAR2,
710: p_value_tbl IN PO_TBL_VARCHAR4000,
711: p_entity_id_tbl IN PO_TBL_NUMBER,
712: p_entity_type IN VARCHAR2,
713: p_column_name IN VARCHAR2,
714: p_message_name IN VARCHAR2,

Line 718: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,

714: p_message_name IN VARCHAR2,
715: p_token1_name IN VARCHAR2 DEFAULT NULL,
716: p_token1_value IN VARCHAR2 DEFAULT NULL,
717: p_token2_name IN VARCHAR2 DEFAULT NULL,
718: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
719: p_validation_id IN NUMBER DEFAULT NULL,
720: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
721: x_result_type OUT NOCOPY VARCHAR2
722: )

Line 727: l_token2_value_tbl PO_TBL_VARCHAR4000;

723: IS
724:
725: d_mod CONSTANT VARCHAR2(100) := D_not_null;
726: l_results_count NUMBER;
727: l_token2_value_tbl PO_TBL_VARCHAR4000;
728:
729: BEGIN
730:
731: IF PO_LOG.d_proc THEN

Line 750: l_token2_value_tbl := PO_TBL_VARCHAR4000();

746: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
747: END IF;
748:
749: IF (p_token2_value_tbl IS NULL) THEN
750: l_token2_value_tbl := PO_TBL_VARCHAR4000();
751: l_token2_value_tbl.extend(p_value_tbl.COUNT);
752: ELSE
753: l_token2_value_tbl := p_token2_value_tbl;
754: END IF;

Line 833: p_value_tbl IN PO_TBL_VARCHAR4000,

829: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
830: --End of Comments
831: -------------------------------------------------------------------------------
832: PROCEDURE ensure_null(p_calling_module IN VARCHAR2,
833: p_value_tbl IN PO_TBL_VARCHAR4000,
834: p_entity_id_tbl IN PO_TBL_NUMBER,
835: p_entity_type IN VARCHAR2,
836: p_column_name IN VARCHAR2,
837: p_message_name IN VARCHAR2,

Line 841: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,

837: p_message_name IN VARCHAR2,
838: p_token1_name IN VARCHAR2 DEFAULT NULL,
839: p_token1_value IN VARCHAR2 DEFAULT NULL,
840: p_token2_name IN VARCHAR2 DEFAULT NULL,
841: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
842: p_validation_id IN NUMBER DEFAULT NULL,
843: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
844: x_result_type OUT NOCOPY VARCHAR2) IS
845: d_mod CONSTANT VARCHAR2(100) := D_ensure_null;

Line 847: l_token2_value_tbl PO_TBL_VARCHAR4000;

843: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
844: x_result_type OUT NOCOPY VARCHAR2) IS
845: d_mod CONSTANT VARCHAR2(100) := D_ensure_null;
846: l_results_count NUMBER;
847: l_token2_value_tbl PO_TBL_VARCHAR4000;
848:
849: BEGIN
850:
851: IF PO_LOG.d_proc THEN

Line 870: l_token2_value_tbl := PO_TBL_VARCHAR4000();

866: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
867: END IF;
868:
869: IF (p_token2_value_tbl IS NULL) THEN
870: l_token2_value_tbl := PO_TBL_VARCHAR4000();
871: l_token2_value_tbl.extend(p_value_tbl.COUNT);
872: ELSE
873: l_token2_value_tbl := p_token2_value_tbl;
874: END IF;

Line 960: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,

956: p_message_name IN VARCHAR2,
957: p_token1_name IN VARCHAR2 DEFAULT NULL,
958: p_token1_value IN VARCHAR2 DEFAULT NULL,
959: p_token2_name IN VARCHAR2 DEFAULT NULL,
960: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
961: p_validation_id IN NUMBER DEFAULT NULL,
962: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
963: x_result_type OUT NOCOPY VARCHAR2) IS
964: d_mod CONSTANT VARCHAR2(100) := D_flag_value_Y_N;

Line 966: l_token2_value_tbl PO_TBL_VARCHAR4000;

962: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
963: x_result_type OUT NOCOPY VARCHAR2) IS
964: d_mod CONSTANT VARCHAR2(100) := D_flag_value_Y_N;
965: l_results_count NUMBER;
966: l_token2_value_tbl PO_TBL_VARCHAR4000;
967:
968: BEGIN
969:
970: IF PO_LOG.d_proc THEN

Line 989: l_token2_value_tbl := PO_TBL_VARCHAR4000();

985: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
986: END IF;
987:
988: IF (p_token2_value_tbl IS NULL) THEN
989: l_token2_value_tbl := PO_TBL_VARCHAR4000();
990: l_token2_value_tbl.extend(p_flag_value_tbl.COUNT);
991: ELSE
992: l_token2_value_tbl := p_token2_value_tbl;
993: END IF;

Line 1797: , p_unique_value_tbl IN PO_TBL_VARCHAR4000

1793: p_calling_module IN VARCHAR2
1794: , p_price_diff_id_tbl IN PO_TBL_NUMBER
1795: , p_entity_id_tbl IN PO_TBL_NUMBER
1796: , p_entity_type_tbl IN PO_TBL_VARCHAR30
1797: , p_unique_value_tbl IN PO_TBL_VARCHAR4000
1798: , p_column_name IN VARCHAR2
1799: , p_message_name IN VARCHAR2
1800: , x_result_set_id IN OUT NOCOPY NUMBER
1801: , x_result_type OUT NOCOPY VARCHAR2

Line 2169: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,

2165: p_message_name IN VARCHAR2,
2166: p_token1_name IN VARCHAR2 DEFAULT NULL,
2167: p_token1_value IN VARCHAR2 DEFAULT NULL,
2168: p_token2_name IN VARCHAR2 DEFAULT NULL,
2169: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
2170: p_validation_id IN NUMBER DEFAULT NULL,
2171: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2172: x_result_type OUT NOCOPY VARCHAR2) IS
2173:

Line 2176: l_token2_value_tbl PO_TBL_VARCHAR4000;

2172: x_result_type OUT NOCOPY VARCHAR2) IS
2173:
2174: d_mod CONSTANT VARCHAR2(100) := D_zero;
2175: l_results_count NUMBER;
2176: l_token2_value_tbl PO_TBL_VARCHAR4000;
2177:
2178: BEGIN
2179:
2180: IF PO_LOG.d_proc THEN

Line 2199: l_token2_value_tbl := PO_TBL_VARCHAR4000();

2195: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2196: END IF;
2197:
2198: IF (p_token2_value_tbl IS NULL) THEN
2199: l_token2_value_tbl := PO_TBL_VARCHAR4000();
2200: l_token2_value_tbl.extend(p_value_tbl.COUNT);
2201: ELSE
2202: l_token2_value_tbl := p_token2_value_tbl;
2203: END IF;