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_VALIDATION_RESULTS_TYPE

Line 165: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

161: , p_entity_id_tbl IN PO_TBL_NUMBER
162: , p_entity_type IN VARCHAR2
163: , p_column_name IN VARCHAR2
164: , p_message_name IN VARCHAR2 DEFAULT NULL
165: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
166: , x_result_type OUT NOCOPY VARCHAR2
167: )
168: IS
169: d_mod CONSTANT VARCHAR2(100) := D_greater_than_zero;

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

183: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
184: END IF;
185:
186: IF (x_results IS NULL) THEN
187: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
188: END IF;
189:
190: l_results_count := x_results.result_type.COUNT;
191:

Line 289: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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
292:
293: d_mod CONSTANT VARCHAR2(100) := D_greater_or_equal_zero;

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

313: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
314: END IF;
315:
316: IF (x_results IS NULL) THEN
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();

Line 431: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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
435: d_mod CONSTANT VARCHAR2(100) := D_within_percentage_range;

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

452: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
453: END IF;
454:
455: IF (x_results IS NULL) THEN
456: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
457: END IF;
458:
459: l_results_count := x_results.result_type.COUNT;
460:

Line 720: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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: )
723: IS
724:

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

742: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
743: END IF;
744:
745: IF (x_results IS NULL) THEN
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();

Line 843: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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;
846: l_results_count NUMBER;
847: l_token2_value_tbl PO_TBL_VARCHAR4000;

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

862: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
863: END IF;
864:
865: IF (x_results IS NULL) THEN
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();

Line 962: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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;
965: l_results_count NUMBER;
966: l_token2_value_tbl PO_TBL_VARCHAR4000;

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

981: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
982: END IF;
983:
984: IF (x_results IS NULL) THEN
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();

Line 1085: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1081: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1082: , p_check_quantity_types_flag IN VARCHAR2
1083: , p_entity_type IN VARCHAR2
1084: , p_column_name IN VARCHAR2
1085: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1086: , x_result_type OUT NOCOPY VARCHAR2
1087: )
1088: IS
1089: d_mod CONSTANT VARCHAR2(100) := D_gt_zero_order_type_filter;

Line 1212: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1208: , p_start_date_tbl IN PO_TBL_DATE DEFAULT NULL
1209: , p_expiration_date_tbl IN PO_TBL_DATE DEFAULT NULL
1210: , p_column_name IN VARCHAR2
1211: , p_message_name IN VARCHAR2
1212: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1213: , x_result_type OUT NOCOPY VARCHAR2
1214: )
1215: IS
1216: d_mod CONSTANT VARCHAR2(100) := D_no_timecards_exist;

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

1243: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1244: END IF;
1245:
1246: IF (x_results IS NULL) THEN
1247: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1248: END IF;
1249:
1250: l_results_count := x_results.result_type.COUNT;
1251:

Line 1985: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1981: , p_column_name IN VARCHAR2
1982: , p_column_val_selector IN VARCHAR2
1983: , p_message_name IN VARCHAR2
1984: , p_validation_id IN NUMBER DEFAULT NULL
1985: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1986: , x_result_type OUT NOCOPY VARCHAR2
1987: )
1988: IS
1989: d_mod CONSTANT VARCHAR2(100) := D_start_date_le_end_date;

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

2004: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2005: END IF;
2006:
2007: IF (x_results IS NULL) THEN
2008: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2009: END IF;
2010:
2011: l_results_count := x_results.result_type.COUNT;
2012:

Line 2070: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2066: , p_entity_id_tbl IN PO_TBL_NUMBER
2067: , p_entity_type IN VARCHAR2
2068: , p_column_name IN VARCHAR2
2069: , p_message_name IN VARCHAR2
2070: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2071: , x_result_type OUT NOCOPY VARCHAR2
2072: )
2073: IS
2074: d_mod CONSTANT VARCHAR2(100) := D_num1_less_or_equal_num2;

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

2086: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2087: END IF;
2088:
2089: IF (x_results IS NULL) THEN
2090: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2091: END IF;
2092:
2093: l_results_count := x_results.result_type.COUNT;
2094:

Line 2171: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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:
2174: d_mod CONSTANT VARCHAR2(100) := D_zero;
2175: l_results_count NUMBER;

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

2191: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
2192: END IF;
2193:
2194: IF (x_results IS NULL) THEN
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();

Line 2396: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2392: , p_item_id_tbl IN PO_TBL_NUMBER
2393: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2394: , p_entity_type IN VARCHAR2
2395: , p_column_name IN VARCHAR2
2396: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2397: , x_result_type OUT NOCOPY VARCHAR2
2398: )
2399: IS
2400: d_mod CONSTANT VARCHAR2(100) := D_gt_zero_opm_filter;

Line 2541: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2537: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
2538: , p_sec_quantity_tbl IN PO_TBL_NUMBER
2539: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
2540: , p_column_name IN VARCHAR2
2541: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2542: , x_result_type OUT NOCOPY VARCHAR2
2543: )
2544: IS
2545: d_mod CONSTANT VARCHAR2(100) := D_qtys_within_deviation;

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

2563: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2564: END IF;
2565:
2566: IF (x_results IS NULL) THEN
2567: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2568: END IF;
2569:
2570: l_results_count := x_results.result_type.COUNT;
2571:

Line 2664: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

2660: p_item_tbl IN po_tbl_varchar2000,
2661: p_organization_id_tbl IN po_tbl_number,
2662: p_doc_type IN VARCHAR2,
2663: p_create_or_update_item_flag IN VARCHAR2,
2664: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2665: x_result_type OUT NOCOPY VARCHAR2)
2666: IS
2667:
2668: d_mod CONSTANT VARCHAR2(100) := d_secondary_unit_of_measure;

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

2683: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2684: END IF;
2685:
2686: IF (x_results IS NULL) THEN
2687: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2688: END IF;
2689:
2690: x_result_type := po_validations.c_result_type_success;
2691:

Line 2800: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

2796: p_item_tbl IN po_tbl_varchar2000,
2797: p_organization_id_tbl IN po_tbl_number,
2798: p_doc_type IN VARCHAR2,
2799: p_create_or_update_item_flag IN VARCHAR2,
2800: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2801: x_result_type OUT NOCOPY VARCHAR2)
2802: IS
2803:
2804: d_mod CONSTANT VARCHAR2(100) := d_secondary_quantity;

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

2821: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2822: END IF;
2823:
2824: IF (x_results IS NULL) THEN
2825: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2826: END IF;
2827:
2828: x_result_type := po_validations.c_result_type_success;
2829:

Line 3083: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

3079: p_item_tbl IN po_tbl_varchar2000,
3080: p_organization_id_tbl IN po_tbl_number,
3081: p_create_or_update_item_flag IN VARCHAR2,
3082: p_validation_id IN NUMBER DEFAULT NULL,
3083: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3084: x_result_set_id IN OUT NOCOPY NUMBER,
3085: x_result_type OUT NOCOPY VARCHAR2)
3086: IS
3087: d_mod CONSTANT VARCHAR2(100) := d_preferred_grade;

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

3104: x_result_set_id := po_validations.next_result_set_id();
3105: END IF;
3106:
3107: IF (x_results IS NULL) THEN
3108: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3109: END IF;
3110:
3111: x_result_type := po_validations.c_result_type_success;
3112: FOR i IN 1 .. p_id_tbl.COUNT LOOP

Line 3410: x_results IN OUT NOCOPY po_validation_results_type,

3406: p_attribute13_tbl IN PO_TBL_VARCHAR2000,
3407: p_attribute14_tbl IN PO_TBL_VARCHAR2000,
3408: p_attribute15_tbl IN PO_TBL_VARCHAR2000,
3409: p_entity_type IN VARCHAR2,
3410: x_results IN OUT NOCOPY po_validation_results_type,
3411: x_result_type OUT NOCOPY VARCHAR2)
3412: IS
3413: d_mod CONSTANT VARCHAR2(100) := D_validate_desc_flex;
3414: c_message_name CONSTANT VARCHAR2(30) := 'PO_DFF_SEGMENT_NOT_VALID';

Line 3444: x_results := po_validation_results_type.new_instance();

3440: PO_LOG.proc_begin(d_mod, 'p_attribute15_tbl', p_attribute15_tbl);
3441: END IF;
3442:
3443: IF (x_results IS NULL) THEN
3444: x_results := po_validation_results_type.new_instance();
3445: END IF;
3446:
3447: x_result_type := po_validations.c_result_type_success;
3448: