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_VAL_LINES2 dependencies on PO_VALIDATION_RESULTS_TYPE

Line 150: x_results IN OUT NOCOPY po_validation_results_type,

146: p_id_tbl IN po_tbl_number,
147: p_expiration_date_tbl IN po_tbl_date,
148: p_header_start_date_tbl IN po_tbl_date,
149: p_header_end_date_tbl IN po_tbl_date,
150: x_results IN OUT NOCOPY po_validation_results_type,
151: x_result_type OUT NOCOPY VARCHAR2)
152: IS
153: d_mod CONSTANT VARCHAR2(100) := d_expiration_date_blanket;
154: BEGIN

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

152: IS
153: d_mod CONSTANT VARCHAR2(100) := d_expiration_date_blanket;
154: BEGIN
155: IF (x_results IS NULL) THEN
156: x_results := po_validation_results_type.new_instance();
157: END IF;
158:
159: x_result_type := po_validations.c_result_type_success;
160:

Line 217: x_results IN OUT NOCOPY po_validation_results_type,

213: p_global_agreement_flag_tbl IN po_tbl_varchar1,
214: p_purchase_basis_tbl IN po_tbl_varchar30,
215: p_line_type_id_tbl IN po_tbl_number,
216: x_result_set_id IN OUT NOCOPY NUMBER,
217: x_results IN OUT NOCOPY po_validation_results_type,
218: x_result_type OUT NOCOPY VARCHAR2)
219: IS
220: d_mod CONSTANT VARCHAR2(100) := d_global_agreement_flag;
221: BEGIN

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

223: x_result_set_id := po_validations.next_result_set_id();
224: END IF;
225:
226: IF (x_results IS NULL) THEN
227: x_results := po_validation_results_type.new_instance();
228: END IF;
229:
230: IF po_log.d_proc THEN
231: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 309: x_results IN OUT NOCOPY po_validation_results_type,

305: PROCEDURE amount_blanket(
306: p_id_tbl IN po_tbl_number,
307: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
308: p_amount_tbl IN po_tbl_number,
309: x_results IN OUT NOCOPY po_validation_results_type,
310: x_result_type OUT NOCOPY VARCHAR2)
311: IS
312: d_mod CONSTANT VARCHAR2(100) := d_amount_blanket;
313: BEGIN

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

311: IS
312: d_mod CONSTANT VARCHAR2(100) := d_amount_blanket;
313: BEGIN
314: IF (x_results IS NULL) THEN
315: x_results := po_validation_results_type.new_instance();
316: END IF;
317:
318: IF po_log.d_proc THEN
319: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 374: x_results IN OUT NOCOPY po_validation_results_type,

370: -------------------------------------------------------------------------
371: PROCEDURE order_type_lookup_code(
372: p_id_tbl IN po_tbl_number,
373: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
374: x_results IN OUT NOCOPY po_validation_results_type,
375: x_result_type OUT NOCOPY VARCHAR2)
376: IS
377: d_mod CONSTANT VARCHAR2(100) := d_order_type_lookup_code;
378: BEGIN

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

376: IS
377: d_mod CONSTANT VARCHAR2(100) := d_order_type_lookup_code;
378: BEGIN
379: IF (x_results IS NULL) THEN
380: x_results := po_validation_results_type.new_instance();
381: END IF;
382:
383: IF po_log.d_proc THEN
384: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 432: x_results IN OUT NOCOPY po_validation_results_type,

428: p_doc_type IN VARCHAR2,
429: p_purchase_basis_tbl IN po_tbl_varchar30,
430: p_contractor_last_name_tbl IN po_tbl_varchar2000,
431: p_contractor_first_name_tbl IN po_tbl_varchar2000,
432: x_results IN OUT NOCOPY po_validation_results_type,
433: x_result_type OUT NOCOPY VARCHAR2)
434: IS
435: d_mod CONSTANT VARCHAR2(100) := d_contractor_name;
436: BEGIN

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

434: IS
435: d_mod CONSTANT VARCHAR2(100) := d_contractor_name;
436: BEGIN
437: IF (x_results IS NULL) THEN
438: x_results := po_validation_results_type.new_instance();
439: END IF;
440:
441: IF po_log.d_proc THEN
442: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 489: x_results IN OUT NOCOPY po_validation_results_type,

485: p_job_business_group_id_tbl IN po_tbl_number,
486: p_purchase_basis_tbl IN po_tbl_varchar30,
487: p_category_id_tbl IN po_tbl_number,
488: x_result_set_id IN OUT NOCOPY NUMBER,
489: x_results IN OUT NOCOPY po_validation_results_type,
490: x_result_type OUT NOCOPY VARCHAR2)
491: IS
492: d_mod CONSTANT VARCHAR2(100) := d_job_id;
493: BEGIN

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

495: x_result_set_id := po_validations.next_result_set_id();
496: END IF;
497:
498: IF (x_results IS NULL) THEN
499: x_results := po_validation_results_type.new_instance();
500: END IF;
501:
502: IF po_log.d_proc THEN
503: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 794: x_results IN OUT NOCOPY po_validation_results_type,

790: PROCEDURE capital_expense_flag(
791: p_id_tbl IN po_tbl_number,
792: p_purchase_basis_tbl IN po_tbl_varchar30,
793: p_capital_expense_flag_tbl IN po_tbl_varchar1,
794: x_results IN OUT NOCOPY po_validation_results_type,
795: x_result_type OUT NOCOPY VARCHAR2)
796: IS
797: d_mod CONSTANT VARCHAR2(100) := d_capital_expense_flag;
798: BEGIN

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

796: IS
797: d_mod CONSTANT VARCHAR2(100) := d_capital_expense_flag;
798: BEGIN
799: IF (x_results IS NULL) THEN
800: x_results := po_validation_results_type.new_instance();
801: END IF;
802:
803: IF po_log.d_proc THEN
804: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 845: x_results IN OUT NOCOPY po_validation_results_type,

841: p_id_tbl IN po_tbl_number,
842: p_purchase_basis_tbl IN po_tbl_varchar30,
843: p_un_number_id_tbl IN po_tbl_number,
844: x_result_set_id IN OUT NOCOPY NUMBER,
845: x_results IN OUT NOCOPY po_validation_results_type,
846: x_result_type OUT NOCOPY VARCHAR2)
847: IS
848: d_mod CONSTANT VARCHAR2(100) := d_un_number_id;
849: BEGIN

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

851: x_result_set_id := po_validations.next_result_set_id();
852: END IF;
853:
854: IF (x_results IS NULL) THEN
855: x_results := po_validation_results_type.new_instance();
856: END IF;
857:
858: IF po_log.d_proc THEN
859: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 936: x_results IN OUT NOCOPY po_validation_results_type,

932: p_id_tbl IN po_tbl_number,
933: p_purchase_basis_tbl IN po_tbl_varchar30,
934: p_hazard_class_id_tbl IN po_tbl_number,
935: x_result_set_id IN OUT NOCOPY NUMBER,
936: x_results IN OUT NOCOPY po_validation_results_type,
937: x_result_type OUT NOCOPY VARCHAR2)
938: IS
939: d_mod CONSTANT VARCHAR2(100) := d_hazard_class_id;
940: BEGIN

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

942: x_result_set_id := po_validations.next_result_set_id();
943: END IF;
944:
945: IF (x_results IS NULL) THEN
946: x_results := po_validation_results_type.new_instance();
947: END IF;
948:
949: IF po_log.d_proc THEN
950: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1029: x_results IN OUT NOCOPY po_validation_results_type,

1025: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1026: p_line_type_id_tbl IN po_tbl_number,
1027: p_inventory_org_id IN NUMBER,
1028: x_result_set_id IN OUT NOCOPY NUMBER,
1029: x_results IN OUT NOCOPY po_validation_results_type,
1030: x_result_type OUT NOCOPY VARCHAR2)
1031: IS
1032: d_mod CONSTANT VARCHAR2(100) := d_item_id;
1033: BEGIN

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

1035: x_result_set_id := po_validations.next_result_set_id();
1036: END IF;
1037:
1038: IF (x_results IS NULL) THEN
1039: x_results := po_validation_results_type.new_instance();
1040: END IF;
1041:
1042: IF po_log.d_proc THEN
1043: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1278: x_results IN OUT NOCOPY po_validation_results_type,

1274: p_item_id_tbl IN po_tbl_number,
1275: p_line_type_id_tbl IN po_tbl_number,
1276: p_inventory_org_id IN NUMBER,
1277: x_result_set_id IN OUT NOCOPY NUMBER,
1278: x_results IN OUT NOCOPY po_validation_results_type,
1279: x_result_type OUT NOCOPY VARCHAR2)
1280: IS
1281: d_mod CONSTANT VARCHAR2(100) := d_unit_meas_lookup_code;
1282: l_service_uom_class VARCHAR2(2000);

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

1285: x_result_set_id := po_validations.next_result_set_id();
1286: END IF;
1287:
1288: IF (x_results IS NULL) THEN
1289: x_results := po_validation_results_type.new_instance();
1290: END IF;
1291:
1292: IF po_log.d_proc THEN
1293: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1514: x_results IN OUT NOCOPY po_validation_results_type,

1510: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1511: p_item_revision_tbl IN po_tbl_varchar5,
1512: p_item_id_tbl IN po_tbl_number,
1513: x_result_set_id IN OUT NOCOPY NUMBER,
1514: x_results IN OUT NOCOPY po_validation_results_type,
1515: x_result_type OUT NOCOPY VARCHAR2)
1516: IS
1517: d_mod CONSTANT VARCHAR2(100) := d_item_revision;
1518: BEGIN

Line 1623: x_results IN OUT NOCOPY po_validation_results_type,

1619: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1620: p_item_id_tbl IN po_tbl_number,
1621: p_inventory_org_id IN NUMBER,
1622: x_result_set_id IN OUT NOCOPY NUMBER,
1623: x_results IN OUT NOCOPY po_validation_results_type,
1624: x_result_type OUT NOCOPY VARCHAR2)
1625: IS
1626: d_mod CONSTANT VARCHAR2(100) := d_category_id;
1627: x_flag mtl_category_sets_v.validate_flag%TYPE;

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

1631: x_result_set_id := po_validations.next_result_set_id();
1632: END IF;
1633:
1634: IF (x_results IS NULL) THEN
1635: x_results := po_validation_results_type.new_instance();
1636: END IF;
1637:
1638: IF po_log.d_proc THEN
1639: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1816: x_results IN OUT NOCOPY po_validation_results_type,

1812: PROCEDURE ip_category_id(
1813: p_id_tbl IN po_tbl_number,
1814: p_ip_category_id_tbl IN po_tbl_number,
1815: x_result_set_id IN OUT NOCOPY NUMBER,
1816: x_results IN OUT NOCOPY po_validation_results_type,
1817: x_result_type OUT NOCOPY VARCHAR2)
1818: IS
1819: d_mod CONSTANT VARCHAR2(100) := d_ip_category_id;
1820: BEGIN

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

1822: x_result_set_id := po_validations.next_result_set_id();
1823: END IF;
1824:
1825: IF (x_results IS NULL) THEN
1826: x_results := po_validation_results_type.new_instance();
1827: END IF;
1828:
1829: IF po_log.d_proc THEN
1830: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1915: x_results IN OUT NOCOPY po_validation_results_type,

1911: p_unit_price_tbl IN po_tbl_number,
1912: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1913: p_line_type_id_tbl IN po_tbl_number,
1914: x_result_set_id IN OUT NOCOPY NUMBER,
1915: x_results IN OUT NOCOPY po_validation_results_type,
1916: x_result_type OUT NOCOPY VARCHAR2)
1917: IS
1918: d_mod CONSTANT VARCHAR2(100) := d_unit_price;
1919: X_li_unit_price NUMBER := NULL; --bug 12631717

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

1922: x_result_set_id := po_validations.next_result_set_id();
1923: END IF;
1924:
1925: IF (x_results IS NULL) THEN
1926: x_results := po_validation_results_type.new_instance();
1927: END IF;
1928:
1929: IF po_log.d_proc THEN
1930: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 2098: x_results IN OUT NOCOPY po_validation_results_type,

2094: PROCEDURE quantity(
2095: p_id_tbl IN po_tbl_number,
2096: p_quantity_tbl IN po_tbl_number,
2097: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2098: x_results IN OUT NOCOPY po_validation_results_type,
2099: x_result_type OUT NOCOPY VARCHAR2)
2100: IS
2101: d_mod CONSTANT VARCHAR2(100) := d_quantity;
2102: BEGIN

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

2100: IS
2101: d_mod CONSTANT VARCHAR2(100) := d_quantity;
2102: BEGIN
2103: IF (x_results IS NULL) THEN
2104: x_results := po_validation_results_type.new_instance();
2105: END IF;
2106:
2107: IF po_log.d_proc THEN
2108: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 2167: x_results IN OUT NOCOPY po_validation_results_type,

2163: PROCEDURE amount(
2164: p_id_tbl IN po_tbl_number,
2165: p_amount_tbl IN po_tbl_number,
2166: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2167: x_results IN OUT NOCOPY po_validation_results_type,
2168: x_result_type OUT NOCOPY VARCHAR2)
2169: IS
2170: d_mod CONSTANT VARCHAR2(100) := d_amount;
2171: BEGIN

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

2169: IS
2170: d_mod CONSTANT VARCHAR2(100) := d_amount;
2171: BEGIN
2172: IF (x_results IS NULL) THEN
2173: x_results := po_validation_results_type.new_instance();
2174: END IF;
2175:
2176: IF po_log.d_proc THEN
2177: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 2220: x_results IN OUT NOCOPY po_validation_results_type,

2216: PROCEDURE rate_type(
2217: p_id_tbl IN po_tbl_number,
2218: p_rate_type_tbl IN po_tbl_varchar30,
2219: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2220: x_results IN OUT NOCOPY po_validation_results_type,
2221: x_result_type OUT NOCOPY VARCHAR2)
2222: IS
2223: d_mod CONSTANT VARCHAR2(100) := d_rate_type;
2224: BEGIN

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

2222: IS
2223: d_mod CONSTANT VARCHAR2(100) := d_rate_type;
2224: BEGIN
2225: IF (x_results IS NULL) THEN
2226: x_results := po_validation_results_type.new_instance();
2227: END IF;
2228:
2229: IF po_log.d_proc THEN
2230: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 2275: x_results IN OUT NOCOPY po_validation_results_type,

2271: p_line_num_tbl IN po_tbl_number,
2272: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2273: p_draft_id_tbl IN PO_TBL_NUMBER, -- bug5129752
2274: x_result_set_id IN OUT NOCOPY NUMBER,
2275: x_results IN OUT NOCOPY po_validation_results_type,
2276: x_result_type OUT NOCOPY VARCHAR2)
2277: IS
2278: d_mod CONSTANT VARCHAR2(100) := d_line_num;
2279: BEGIN

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

2277: IS
2278: d_mod CONSTANT VARCHAR2(100) := d_line_num;
2279: BEGIN
2280: IF (x_results IS NULL) THEN
2281: x_results := po_validation_results_type.new_instance();
2282: END IF;
2283:
2284: IF x_result_set_id IS NULL THEN
2285: x_result_set_id := po_validations.next_result_set_id();

Line 2743: x_results IN OUT NOCOPY po_validation_results_type,

2739: p_id_tbl IN po_tbl_number,
2740: p_start_date_tbl IN po_tbl_date,
2741: p_expiration_date_tbl IN po_tbl_date,
2742: p_purchase_basis_tbl IN po_tbl_varchar30,
2743: x_results IN OUT NOCOPY po_validation_results_type,
2744: x_result_type OUT NOCOPY VARCHAR2)
2745: IS
2746: d_mod CONSTANT VARCHAR2(100) := d_start_date_standard;
2747: BEGIN

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

2745: IS
2746: d_mod CONSTANT VARCHAR2(100) := d_start_date_standard;
2747: BEGIN
2748: IF (x_results IS NULL) THEN
2749: x_results := po_validation_results_type.new_instance();
2750: END IF;
2751:
2752: IF po_log.d_proc THEN
2753: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 2900: x_results IN OUT NOCOPY po_validation_results_type,

2896: PROCEDURE quantity_standard(
2897: p_id_tbl IN po_tbl_number,
2898: p_quantity_tbl IN po_tbl_number,
2899: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2900: x_results IN OUT NOCOPY po_validation_results_type,
2901: x_result_type OUT NOCOPY VARCHAR2)
2902: IS
2903: d_mod CONSTANT VARCHAR2(100) := d_quantity_standard;
2904: BEGIN

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

2902: IS
2903: d_mod CONSTANT VARCHAR2(100) := d_quantity_standard;
2904: BEGIN
2905: IF (x_results IS NULL) THEN
2906: x_results := po_validation_results_type.new_instance();
2907: END IF;
2908:
2909: IF po_log.d_proc THEN
2910: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 2958: x_results IN OUT NOCOPY po_validation_results_type,

2954: PROCEDURE amount_standard(
2955: p_id_tbl IN po_tbl_number,
2956: p_amount_tbl IN po_tbl_number,
2957: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2958: x_results IN OUT NOCOPY po_validation_results_type,
2959: x_result_type OUT NOCOPY VARCHAR2)
2960: IS
2961: d_mod CONSTANT VARCHAR2(100) := d_amount_standard;
2962: BEGIN

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

2960: IS
2961: d_mod CONSTANT VARCHAR2(100) := d_amount_standard;
2962: BEGIN
2963: IF (x_results IS NULL) THEN
2964: x_results := po_validation_results_type.new_instance();
2965: END IF;
2966:
2967: IF po_log.d_proc THEN
2968: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 3026: x_results IN OUT NOCOPY po_validation_results_type,

3022: p_global_agreement_flag_tbl IN po_tbl_varchar1,
3023: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
3024: p_purchase_basis_tbl IN po_tbl_varchar30,
3025: x_result_set_id IN OUT NOCOPY NUMBER,
3026: x_results IN OUT NOCOPY po_validation_results_type,
3027: x_result_type OUT NOCOPY VARCHAR2)
3028: IS
3029: d_mod CONSTANT VARCHAR2(100) := d_price_break_lookup_code;
3030: BEGIN

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

3032: x_result_set_id := po_validations.next_result_set_id();
3033: END IF;
3034:
3035: IF (x_results IS NULL) THEN
3036: x_results := po_validation_results_type.new_instance();
3037: END IF;
3038:
3039: IF po_log.d_proc THEN
3040: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 3133: x_results IN OUT NOCOPY po_validation_results_type,

3129: p_id_tbl IN po_tbl_number,
3130: p_not_to_exceed_price_tbl IN po_tbl_number,
3131: p_allow_price_override_tbl IN po_tbl_varchar1,
3132: p_unit_price_tbl IN po_tbl_number,
3133: x_results IN OUT NOCOPY po_validation_results_type,
3134: x_result_type OUT NOCOPY VARCHAR2)
3135: IS
3136: d_mod CONSTANT VARCHAR2(100) := d_not_to_exceed_price;
3137: BEGIN

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

3135: IS
3136: d_mod CONSTANT VARCHAR2(100) := d_not_to_exceed_price;
3137: BEGIN
3138: IF (x_results IS NULL) THEN
3139: x_results := po_validation_results_type.new_instance();
3140: END IF;
3141:
3142: IF po_log.d_proc THEN
3143: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 3199: x_results IN OUT NOCOPY po_validation_results_type,

3195: PROCEDURE ip_category_id_update(
3196: p_id_tbl IN po_tbl_number,
3197: p_ip_category_id_tbl IN po_tbl_number,
3198: x_result_set_id IN OUT NOCOPY NUMBER,
3199: x_results IN OUT NOCOPY po_validation_results_type,
3200: x_result_type OUT NOCOPY VARCHAR2)
3201: IS
3202: d_mod CONSTANT VARCHAR2(100) := d_ip_category_id_update;
3203: BEGIN

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

3205: x_result_set_id := po_validations.next_result_set_id();
3206: END IF;
3207:
3208: IF (x_results IS NULL) THEN
3209: x_results := po_validation_results_type.new_instance();
3210: END IF;
3211:
3212: IF po_log.d_proc THEN
3213: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 3294: x_results IN OUT NOCOPY po_validation_results_type, x_result_set_id IN OUT NOCOPY NUMBER,

3290: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,
3291: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
3292: p_po_header_id_tbl IN po_tbl_number,
3293: p_po_line_id_tbl IN po_tbl_number,
3294: x_results IN OUT NOCOPY po_validation_results_type, x_result_set_id IN OUT NOCOPY NUMBER,
3295: x_result_type OUT NOCOPY VARCHAR2)
3296: IS
3297: d_mod CONSTANT VARCHAR2(100) := d_uom_update;
3298: BEGIN

Line 3403: x_results IN OUT NOCOPY po_validation_results_type, x_result_set_id IN OUT NOCOPY NUMBER,

3399: p_item_id_tbl IN po_tbl_number,
3400: p_inventory_org_id IN NUMBER,
3401: p_po_header_id_tbl IN po_tbl_number,
3402: p_po_line_id_tbl IN po_tbl_number,
3403: x_results IN OUT NOCOPY po_validation_results_type, x_result_set_id IN OUT NOCOPY NUMBER,
3404: x_result_type OUT NOCOPY VARCHAR2)
3405: IS
3406: d_mod CONSTANT VARCHAR2(100) := d_item_desc_update;
3407: BEGIN

Line 3518: x_results IN OUT NOCOPY po_validation_results_type,

3514: ----------------------------------------------------------------------------------------
3515: PROCEDURE negotiated_by_preparer(
3516: p_id_tbl IN po_tbl_number,
3517: p_negotiated_by_preparer_tbl IN po_tbl_varchar1,
3518: x_results IN OUT NOCOPY po_validation_results_type,
3519: x_result_type OUT NOCOPY VARCHAR2)
3520: IS
3521: d_mod CONSTANT VARCHAR2(100) := d_negotiated_by_preparer;
3522: BEGIN

Line 3567: x_results IN OUT NOCOPY po_validation_results_type,

3563: --------------------------------------------------------------------------------------
3564: PROCEDURE negotiated_by_prep_update(
3565: p_id_tbl IN po_tbl_number,
3566: p_negotiated_by_preparer_tbl IN po_tbl_varchar1,
3567: x_results IN OUT NOCOPY po_validation_results_type,
3568: x_result_type OUT NOCOPY VARCHAR2)
3569: IS
3570: d_mod CONSTANT VARCHAR2(100) := d_negotiated_by_prep_update;
3571: BEGIN

Line 3633: x_results IN OUT NOCOPY po_validation_results_type,

3629: p_item_id_tbl IN po_tbl_number,
3630: p_job_id_tbl IN po_tbl_number,
3631: p_inventory_org_id IN NUMBER,
3632: x_result_set_id IN OUT NOCOPY NUMBER,
3633: x_results IN OUT NOCOPY po_validation_results_type,
3634: x_result_type OUT NOCOPY VARCHAR2)
3635: IS
3636: d_mod CONSTANT VARCHAR2(100) := d_category_id_update;
3637: BEGIN

Line 3736: x_results IN OUT NOCOPY po_validation_results_type,

3732: ( p_id_tbl IN po_tbl_number,
3733: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
3734: p_draft_id_tbl IN po_tbl_number,
3735: p_unit_price_tbl IN po_tbl_number,
3736: x_results IN OUT NOCOPY po_validation_results_type,
3737: x_result_set_id IN OUT NOCOPY NUMBER, -- bug5008206
3738: x_result_type OUT NOCOPY VARCHAR2
3739: )
3740: IS

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

3740: IS
3741: d_mod CONSTANT VARCHAR2(100) := d_unit_price_update;
3742: BEGIN
3743: IF (x_results IS NULL) THEN
3744: x_results := po_validation_results_type.new_instance();
3745: END IF;
3746:
3747: IF x_result_set_id IS NULL THEN
3748: x_result_set_id := po_validations.next_result_set_id();

Line 3922: x_results IN OUT NOCOPY po_validation_results_type,

3918: ( p_id_tbl IN po_tbl_number,
3919: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
3920: p_draft_id_tbl IN po_tbl_number,
3921: p_amount_tbl IN po_tbl_number,
3922: x_results IN OUT NOCOPY po_validation_results_type,
3923: x_result_set_id IN OUT NOCOPY NUMBER, -- bug5008206
3924: x_result_type OUT NOCOPY VARCHAR2
3925: )
3926: IS

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

3926: IS
3927: d_mod CONSTANT VARCHAR2(100) := d_amount_update;
3928: BEGIN
3929: IF (x_results IS NULL) THEN
3930: x_results := po_validation_results_type.new_instance();
3931: END IF;
3932:
3933: IF x_result_set_id IS NULL THEN
3934: x_result_set_id := po_validations.next_result_set_id();

Line 4082: x_results IN OUT NOCOPY po_validation_results_type,

4078: PROCEDURE category_combination_valid
4079: ( p_po_line_id_tbl IN po_tbl_number,
4080: p_category_id_tbl IN po_tbl_number,
4081: p_clm_info_flag_tbl IN PO_TBL_VARCHAR1, --Bug 12768893
4082: x_results IN OUT NOCOPY po_validation_results_type,
4083: x_result_type OUT NOCOPY VARCHAR2
4084: )
4085: IS
4086: d_mod CONSTANT VARCHAR2(100) := d_category_comb_valid;

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

4100: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
4101: END IF;
4102:
4103: IF (x_results IS NULL) THEN
4104: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4105: END IF;
4106: l_results_count := x_results.result_type.COUNT;
4107: x_result_type := po_validations.c_result_type_success;
4108: BEGIN

Line 4274: x_results IN OUT NOCOPY po_validation_results_type,

4270: ------------------------------------------------------------------------------------------
4271: PROCEDURE item_combination_valid
4272: ( p_po_line_id_tbl IN po_tbl_number,
4273: p_item_id_tbl IN po_tbl_number,
4274: x_results IN OUT NOCOPY po_validation_results_type,
4275: x_result_type OUT NOCOPY VARCHAR2
4276: )
4277: IS
4278: d_mod CONSTANT VARCHAR2(100) := d_item_comb_valid;

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

4293: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
4294: END IF;
4295:
4296: IF (x_results IS NULL) THEN
4297: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4298: END IF;
4299: l_results_count := x_results.result_type.COUNT;
4300: x_result_type := po_validations.c_result_type_success;
4301: BEGIN