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 175: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

171: , p_entity_id_tbl IN PO_TBL_NUMBER
172: , p_entity_type IN VARCHAR2
173: , p_column_name IN VARCHAR2
174: , p_message_name IN VARCHAR2 DEFAULT NULL
175: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
176: , x_result_type OUT NOCOPY VARCHAR2
177: )
178: IS
179: d_mod CONSTANT VARCHAR2(100) := D_greater_than_zero;

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

193: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
194: END IF;
195:
196: IF (x_results IS NULL) THEN
197: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
198: END IF;
199:
200: l_results_count := x_results.result_type.COUNT;
201:

Line 299: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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

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

323: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
324: END IF;
325:
326: IF (x_results IS NULL) THEN
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();

Line 441: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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

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

462: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
463: END IF;
464:
465: IF (x_results IS NULL) THEN
466: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
467: END IF;
468:
469: l_results_count := x_results.result_type.COUNT;
470:

Line 730: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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: )
733: IS
734:

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

752: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
753: END IF;
754:
755: IF (x_results IS NULL) THEN
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();

Line 853: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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;
856: l_results_count NUMBER;
857: l_token2_value_tbl PO_TBL_VARCHAR4000;

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

872: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
873: END IF;
874:
875: IF (x_results IS NULL) THEN
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();

Line 972: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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;
975: l_results_count NUMBER;
976: l_token2_value_tbl PO_TBL_VARCHAR4000;

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

991: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
992: END IF;
993:
994: IF (x_results IS NULL) THEN
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();

Line 1097: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1093: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
1094: , p_check_quantity_types_flag IN VARCHAR2
1095: , p_entity_type IN VARCHAR2
1096: , p_column_name IN VARCHAR2
1097: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1098: , x_result_type OUT NOCOPY VARCHAR2
1099: , p_header_id_tbl IN PO_TBL_NUMBER --
1100: )
1101: IS

Line 1239: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1235: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1236: , p_check_quantity_types_flag IN VARCHAR2
1237: , p_entity_type IN VARCHAR2
1238: , p_column_name IN VARCHAR2
1239: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1240: , x_result_type OUT NOCOPY VARCHAR2
1241: )
1242: IS
1243: d_mod CONSTANT VARCHAR2(100) := D_gt_zero_order_type_filter;

Line 1366: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1362: , p_start_date_tbl IN PO_TBL_DATE DEFAULT NULL
1363: , p_expiration_date_tbl IN PO_TBL_DATE DEFAULT NULL
1364: , p_column_name IN VARCHAR2
1365: , p_message_name IN VARCHAR2
1366: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1367: , x_result_type OUT NOCOPY VARCHAR2
1368: )
1369: IS
1370: d_mod CONSTANT VARCHAR2(100) := D_no_timecards_exist;

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

1397: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1398: END IF;
1399:
1400: IF (x_results IS NULL) THEN
1401: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1402: END IF;
1403:
1404: l_results_count := x_results.result_type.COUNT;
1405:

Line 2170: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2166: , p_column_name IN VARCHAR2
2167: , p_column_val_selector IN VARCHAR2
2168: , p_message_name IN VARCHAR2
2169: , p_validation_id IN NUMBER DEFAULT NULL
2170: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2171: , x_result_type OUT NOCOPY VARCHAR2
2172: )
2173: IS
2174: d_mod CONSTANT VARCHAR2(100) := D_start_date_le_end_date;

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

2189: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2190: END IF;
2191:
2192: IF (x_results IS NULL) THEN
2193: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2194: END IF;
2195:
2196: l_results_count := x_results.result_type.COUNT;
2197:

Line 2255: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2251: , p_entity_id_tbl IN PO_TBL_NUMBER
2252: , p_entity_type IN VARCHAR2
2253: , p_column_name IN VARCHAR2
2254: , p_message_name IN VARCHAR2
2255: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2256: , x_result_type OUT NOCOPY VARCHAR2
2257: )
2258: IS
2259: d_mod CONSTANT VARCHAR2(100) := D_num1_less_or_equal_num2;

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

2271: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2272: END IF;
2273:
2274: IF (x_results IS NULL) THEN
2275: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2276: END IF;
2277:
2278: l_results_count := x_results.result_type.COUNT;
2279:

Line 2356: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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

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

2376: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
2377: END IF;
2378:
2379: IF (x_results IS NULL) THEN
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();

Line 2581: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2577: , p_item_id_tbl IN PO_TBL_NUMBER
2578: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2579: , p_entity_type IN VARCHAR2
2580: , p_column_name IN VARCHAR2
2581: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2582: , x_result_type OUT NOCOPY VARCHAR2
2583: )
2584: IS
2585: d_mod CONSTANT VARCHAR2(100) := D_gt_zero_opm_filter;

Line 2726: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2722: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
2723: , p_sec_quantity_tbl IN PO_TBL_NUMBER
2724: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
2725: , p_column_name IN VARCHAR2
2726: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2727: , x_result_type OUT NOCOPY VARCHAR2
2728: )
2729: IS
2730: d_mod CONSTANT VARCHAR2(100) := D_qtys_within_deviation;

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

2748: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2749: END IF;
2750:
2751: IF (x_results IS NULL) THEN
2752: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2753: END IF;
2754:
2755: l_results_count := x_results.result_type.COUNT;
2756:

Line 2851: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

2847: p_item_tbl IN po_tbl_varchar2000,
2848: p_organization_id_tbl IN po_tbl_number,
2849: p_doc_type IN VARCHAR2,
2850: p_create_or_update_item_flag IN VARCHAR2,
2851: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2852: x_result_type OUT NOCOPY VARCHAR2)
2853: IS
2854:
2855: d_mod CONSTANT VARCHAR2(100) := d_secondary_unit_of_measure;

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

2870: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2871: END IF;
2872:
2873: IF (x_results IS NULL) THEN
2874: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2875: END IF;
2876:
2877: x_result_type := po_validations.c_result_type_success;
2878:

Line 2987: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

2983: p_item_tbl IN po_tbl_varchar2000,
2984: p_organization_id_tbl IN po_tbl_number,
2985: p_doc_type IN VARCHAR2,
2986: p_create_or_update_item_flag IN VARCHAR2,
2987: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2988: x_result_type OUT NOCOPY VARCHAR2)
2989: IS
2990:
2991: d_mod CONSTANT VARCHAR2(100) := d_secondary_quantity;

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

3008: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3009: END IF;
3010:
3011: IF (x_results IS NULL) THEN
3012: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3013: END IF;
3014:
3015: x_result_type := po_validations.c_result_type_success;
3016:

Line 3270: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

3266: p_item_tbl IN po_tbl_varchar2000,
3267: p_organization_id_tbl IN po_tbl_number,
3268: p_create_or_update_item_flag IN VARCHAR2,
3269: p_validation_id IN NUMBER DEFAULT NULL,
3270: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3271: x_result_set_id IN OUT NOCOPY NUMBER,
3272: x_result_type OUT NOCOPY VARCHAR2)
3273: IS
3274: d_mod CONSTANT VARCHAR2(100) := d_preferred_grade;

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

3291: x_result_set_id := po_validations.next_result_set_id();
3292: END IF;
3293:
3294: IF (x_results IS NULL) THEN
3295: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3296: END IF;
3297:
3298: x_result_type := po_validations.c_result_type_success;
3299: FOR i IN 1 .. p_id_tbl.COUNT LOOP

Line 3577: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

3573: , p_entity_type IN VARCHAR2
3574: , p_column_name IN VARCHAR2
3575: , p_message_name IN VARCHAR2
3576: , p_validation_id IN NUMBER DEFAULT NULL
3577: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3578: , x_result_type OUT NOCOPY VARCHAR2
3579: )
3580: IS
3581: d_mod CONSTANT VARCHAR2(100) := D_start_date_le_sys_date;

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

3595: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3596: END IF;
3597:
3598: IF (x_results IS NULL) THEN
3599: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3600: END IF;
3601:
3602: l_results_count := x_results.result_type.COUNT;
3603: