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 297: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,

293: p_message_name IN VARCHAR2 DEFAULT NULL,
294: p_token1_name IN VARCHAR2 DEFAULT NULL,
295: p_token1_value IN VARCHAR2 DEFAULT NULL,
296: p_token2_name IN VARCHAR2 DEFAULT NULL,
297: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
298: p_validation_id IN NUMBER DEFAULT NULL,
299: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
300: x_result_type OUT NOCOPY VARCHAR2)
301: IS

Line 307: l_token2_value_tbl PO_TBL_VARCHAR4000;

303: d_mod CONSTANT VARCHAR2(100) := D_greater_or_equal_zero;
304: l_results_count NUMBER;
305: l_null_not_allowed BOOLEAN;
306: l_message_name VARCHAR2(30);
307: l_token2_value_tbl PO_TBL_VARCHAR4000;
308:
309: BEGIN
310:
311: IF PO_LOG.d_proc THEN

Line 331: l_token2_value_tbl := PO_TBL_VARCHAR4000();

327: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
328: END IF;
329:
330: IF (p_token2_value_tbl IS NULL) THEN
331: l_token2_value_tbl := PO_TBL_VARCHAR4000();
332: l_token2_value_tbl.extend(p_value_tbl.COUNT);
333: ELSE
334: l_token2_value_tbl := p_token2_value_tbl;
335: END IF;

Line 440: , p_token1_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL

436: , p_entity_type IN VARCHAR2
437: , p_column_name IN VARCHAR2
438: , p_message_name IN VARCHAR2 DEFAULT NULL
439: , p_token1_name IN VARCHAR2 DEFAULT NULL
440: , p_token1_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL
441: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
442: , x_result_type OUT NOCOPY VARCHAR2
443: )
444: IS

Line 449: l_token1_value_tbl PO_TBL_VARCHAR4000;

445: d_mod CONSTANT VARCHAR2(100) := D_within_percentage_range;
446: l_results_count NUMBER;
447: l_null_not_allowed BOOLEAN;
448: l_message_name VARCHAR2(30);
449: l_token1_value_tbl PO_TBL_VARCHAR4000;
450: BEGIN
451:
452: IF PO_LOG.d_proc THEN
453: PO_LOG.proc_begin(p_calling_module);

Line 480: l_token1_value_tbl := PO_TBL_VARCHAR4000();

476:
477: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_PERCENT);
478:
479: IF (p_token1_value_tbl IS NULL) THEN
480: l_token1_value_tbl := PO_TBL_VARCHAR4000();
481: l_token1_value_tbl.extend(p_value_tbl.COUNT);
482: ELSE
483: l_token1_value_tbl := p_token1_value_tbl;
484: END IF;

Line 720: p_value_tbl IN PO_TBL_VARCHAR4000,

716: --End of Comments
717: -------------------------------------------------------------------------------
718: PROCEDURE not_null(
719: p_calling_module IN VARCHAR2,
720: p_value_tbl IN PO_TBL_VARCHAR4000,
721: p_entity_id_tbl IN PO_TBL_NUMBER,
722: p_entity_type IN VARCHAR2,
723: p_column_name IN VARCHAR2,
724: p_message_name IN VARCHAR2,

Line 728: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,

724: p_message_name IN VARCHAR2,
725: p_token1_name IN VARCHAR2 DEFAULT NULL,
726: p_token1_value IN VARCHAR2 DEFAULT NULL,
727: p_token2_name IN VARCHAR2 DEFAULT NULL,
728: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
729: p_validation_id IN NUMBER DEFAULT NULL,
730: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
731: x_result_type OUT NOCOPY VARCHAR2
732: )

Line 737: l_token2_value_tbl PO_TBL_VARCHAR4000;

733: IS
734:
735: d_mod CONSTANT VARCHAR2(100) := D_not_null;
736: l_results_count NUMBER;
737: l_token2_value_tbl PO_TBL_VARCHAR4000;
738:
739: BEGIN
740:
741: IF PO_LOG.d_proc THEN

Line 760: l_token2_value_tbl := PO_TBL_VARCHAR4000();

756: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
757: END IF;
758:
759: IF (p_token2_value_tbl IS NULL) THEN
760: l_token2_value_tbl := PO_TBL_VARCHAR4000();
761: l_token2_value_tbl.extend(p_value_tbl.COUNT);
762: ELSE
763: l_token2_value_tbl := p_token2_value_tbl;
764: END IF;

Line 843: p_value_tbl IN PO_TBL_VARCHAR4000,

839: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
840: --End of Comments
841: -------------------------------------------------------------------------------
842: PROCEDURE ensure_null(p_calling_module IN VARCHAR2,
843: p_value_tbl IN PO_TBL_VARCHAR4000,
844: p_entity_id_tbl IN PO_TBL_NUMBER,
845: p_entity_type IN VARCHAR2,
846: p_column_name IN VARCHAR2,
847: p_message_name IN VARCHAR2,

Line 851: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,

847: p_message_name IN VARCHAR2,
848: p_token1_name IN VARCHAR2 DEFAULT NULL,
849: p_token1_value IN VARCHAR2 DEFAULT NULL,
850: p_token2_name IN VARCHAR2 DEFAULT NULL,
851: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
852: p_validation_id IN NUMBER DEFAULT NULL,
853: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
854: x_result_type OUT NOCOPY VARCHAR2) IS
855: d_mod CONSTANT VARCHAR2(100) := D_ensure_null;

Line 857: l_token2_value_tbl PO_TBL_VARCHAR4000;

853: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
854: x_result_type OUT NOCOPY VARCHAR2) IS
855: d_mod CONSTANT VARCHAR2(100) := D_ensure_null;
856: l_results_count NUMBER;
857: l_token2_value_tbl PO_TBL_VARCHAR4000;
858:
859: BEGIN
860:
861: IF PO_LOG.d_proc THEN

Line 880: l_token2_value_tbl := PO_TBL_VARCHAR4000();

876: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
877: END IF;
878:
879: IF (p_token2_value_tbl IS NULL) THEN
880: l_token2_value_tbl := PO_TBL_VARCHAR4000();
881: l_token2_value_tbl.extend(p_value_tbl.COUNT);
882: ELSE
883: l_token2_value_tbl := p_token2_value_tbl;
884: END IF;

Line 970: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,

966: p_message_name IN VARCHAR2,
967: p_token1_name IN VARCHAR2 DEFAULT NULL,
968: p_token1_value IN VARCHAR2 DEFAULT NULL,
969: p_token2_name IN VARCHAR2 DEFAULT NULL,
970: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
971: p_validation_id IN NUMBER DEFAULT NULL,
972: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
973: x_result_type OUT NOCOPY VARCHAR2) IS
974: d_mod CONSTANT VARCHAR2(100) := D_flag_value_Y_N;

Line 976: l_token2_value_tbl PO_TBL_VARCHAR4000;

972: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
973: x_result_type OUT NOCOPY VARCHAR2) IS
974: d_mod CONSTANT VARCHAR2(100) := D_flag_value_Y_N;
975: l_results_count NUMBER;
976: l_token2_value_tbl PO_TBL_VARCHAR4000;
977:
978: BEGIN
979:
980: IF PO_LOG.d_proc THEN

Line 999: l_token2_value_tbl := PO_TBL_VARCHAR4000();

995: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
996: END IF;
997:
998: IF (p_token2_value_tbl IS NULL) THEN
999: l_token2_value_tbl := PO_TBL_VARCHAR4000();
1000: l_token2_value_tbl.extend(p_flag_value_tbl.COUNT);
1001: ELSE
1002: l_token2_value_tbl := p_token2_value_tbl;
1003: END IF;

Line 1682: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --

1678: , p_entity_type IN VARCHAR2
1679: , p_entity_id_tbl IN PO_TBL_NUMBER
1680: , p_parent_id_tbl IN PO_TBL_NUMBER
1681: , p_entity_num_tbl IN PO_TBL_NUMBER
1682: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
1683: , p_draft_id_tbl IN PO_TBL_NUMBER
1684: , x_result_set_id IN OUT NOCOPY NUMBER
1685: , x_result_type OUT NOCOPY VARCHAR2
1686: , p_entity_type_tbl IN PO_TBL_VARCHAR30 DEFAULT NULL --

Line 1982: , p_unique_value_tbl IN PO_TBL_VARCHAR4000

1978: p_calling_module IN VARCHAR2
1979: , p_price_diff_id_tbl IN PO_TBL_NUMBER
1980: , p_entity_id_tbl IN PO_TBL_NUMBER
1981: , p_entity_type_tbl IN PO_TBL_VARCHAR30
1982: , p_unique_value_tbl IN PO_TBL_VARCHAR4000
1983: , p_column_name IN VARCHAR2
1984: , p_message_name IN VARCHAR2
1985: , x_result_set_id IN OUT NOCOPY NUMBER
1986: , x_result_type OUT NOCOPY VARCHAR2

Line 2354: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,

2350: p_message_name IN VARCHAR2,
2351: p_token1_name IN VARCHAR2 DEFAULT NULL,
2352: p_token1_value IN VARCHAR2 DEFAULT NULL,
2353: p_token2_name IN VARCHAR2 DEFAULT NULL,
2354: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
2355: p_validation_id IN NUMBER DEFAULT NULL,
2356: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2357: x_result_type OUT NOCOPY VARCHAR2) IS
2358:

Line 2361: l_token2_value_tbl PO_TBL_VARCHAR4000;

2357: x_result_type OUT NOCOPY VARCHAR2) IS
2358:
2359: d_mod CONSTANT VARCHAR2(100) := D_zero;
2360: l_results_count NUMBER;
2361: l_token2_value_tbl PO_TBL_VARCHAR4000;
2362:
2363: BEGIN
2364:
2365: IF PO_LOG.d_proc THEN

Line 2384: l_token2_value_tbl := PO_TBL_VARCHAR4000();

2380: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2381: END IF;
2382:
2383: IF (p_token2_value_tbl IS NULL) THEN
2384: l_token2_value_tbl := PO_TBL_VARCHAR4000();
2385: l_token2_value_tbl.extend(p_value_tbl.COUNT);
2386: ELSE
2387: l_token2_value_tbl := p_token2_value_tbl;
2388: END IF;