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 145: x_results IN OUT NOCOPY po_validation_results_type,

141: p_id_tbl IN po_tbl_number,
142: p_expiration_date_tbl IN po_tbl_date,
143: p_header_start_date_tbl IN po_tbl_date,
144: p_header_end_date_tbl IN po_tbl_date,
145: x_results IN OUT NOCOPY po_validation_results_type,
146: x_result_type OUT NOCOPY VARCHAR2)
147: IS
148: d_mod CONSTANT VARCHAR2(100) := d_expiration_date_blanket;
149: BEGIN

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

147: IS
148: d_mod CONSTANT VARCHAR2(100) := d_expiration_date_blanket;
149: BEGIN
150: IF (x_results IS NULL) THEN
151: x_results := po_validation_results_type.new_instance();
152: END IF;
153:
154: x_result_type := po_validations.c_result_type_success;
155:

Line 212: x_results IN OUT NOCOPY po_validation_results_type,

208: p_global_agreement_flag_tbl IN po_tbl_varchar1,
209: p_purchase_basis_tbl IN po_tbl_varchar30,
210: p_line_type_id_tbl IN po_tbl_number,
211: x_result_set_id IN OUT NOCOPY NUMBER,
212: x_results IN OUT NOCOPY po_validation_results_type,
213: x_result_type OUT NOCOPY VARCHAR2)
214: IS
215: d_mod CONSTANT VARCHAR2(100) := d_global_agreement_flag;
216: BEGIN

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

218: x_result_set_id := po_validations.next_result_set_id();
219: END IF;
220:
221: IF (x_results IS NULL) THEN
222: x_results := po_validation_results_type.new_instance();
223: END IF;
224:
225: IF po_log.d_proc THEN
226: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 300: x_results IN OUT NOCOPY po_validation_results_type,

296: PROCEDURE amount_blanket(
297: p_id_tbl IN po_tbl_number,
298: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
299: p_amount_tbl IN po_tbl_number,
300: x_results IN OUT NOCOPY po_validation_results_type,
301: x_result_type OUT NOCOPY VARCHAR2)
302: IS
303: d_mod CONSTANT VARCHAR2(100) := d_amount_blanket;
304: BEGIN

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

302: IS
303: d_mod CONSTANT VARCHAR2(100) := d_amount_blanket;
304: BEGIN
305: IF (x_results IS NULL) THEN
306: x_results := po_validation_results_type.new_instance();
307: END IF;
308:
309: IF po_log.d_proc THEN
310: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 365: x_results IN OUT NOCOPY po_validation_results_type,

361: -------------------------------------------------------------------------
362: PROCEDURE order_type_lookup_code(
363: p_id_tbl IN po_tbl_number,
364: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
365: x_results IN OUT NOCOPY po_validation_results_type,
366: x_result_type OUT NOCOPY VARCHAR2)
367: IS
368: d_mod CONSTANT VARCHAR2(100) := d_order_type_lookup_code;
369: BEGIN

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

367: IS
368: d_mod CONSTANT VARCHAR2(100) := d_order_type_lookup_code;
369: BEGIN
370: IF (x_results IS NULL) THEN
371: x_results := po_validation_results_type.new_instance();
372: END IF;
373:
374: IF po_log.d_proc THEN
375: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 423: x_results IN OUT NOCOPY po_validation_results_type,

419: p_doc_type IN VARCHAR2,
420: p_purchase_basis_tbl IN po_tbl_varchar30,
421: p_contractor_last_name_tbl IN po_tbl_varchar2000,
422: p_contractor_first_name_tbl IN po_tbl_varchar2000,
423: x_results IN OUT NOCOPY po_validation_results_type,
424: x_result_type OUT NOCOPY VARCHAR2)
425: IS
426: d_mod CONSTANT VARCHAR2(100) := d_contractor_name;
427: BEGIN

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

425: IS
426: d_mod CONSTANT VARCHAR2(100) := d_contractor_name;
427: BEGIN
428: IF (x_results IS NULL) THEN
429: x_results := po_validation_results_type.new_instance();
430: END IF;
431:
432: IF po_log.d_proc THEN
433: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 480: x_results IN OUT NOCOPY po_validation_results_type,

476: p_job_business_group_id_tbl IN po_tbl_number,
477: p_purchase_basis_tbl IN po_tbl_varchar30,
478: p_category_id_tbl IN po_tbl_number,
479: x_result_set_id IN OUT NOCOPY NUMBER,
480: x_results IN OUT NOCOPY po_validation_results_type,
481: x_result_type OUT NOCOPY VARCHAR2)
482: IS
483: d_mod CONSTANT VARCHAR2(100) := d_job_id;
484: BEGIN

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

486: x_result_set_id := po_validations.next_result_set_id();
487: END IF;
488:
489: IF (x_results IS NULL) THEN
490: x_results := po_validation_results_type.new_instance();
491: END IF;
492:
493: IF po_log.d_proc THEN
494: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 785: x_results IN OUT NOCOPY po_validation_results_type,

781: PROCEDURE capital_expense_flag(
782: p_id_tbl IN po_tbl_number,
783: p_purchase_basis_tbl IN po_tbl_varchar30,
784: p_capital_expense_flag_tbl IN po_tbl_varchar1,
785: x_results IN OUT NOCOPY po_validation_results_type,
786: x_result_type OUT NOCOPY VARCHAR2)
787: IS
788: d_mod CONSTANT VARCHAR2(100) := d_capital_expense_flag;
789: BEGIN

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

787: IS
788: d_mod CONSTANT VARCHAR2(100) := d_capital_expense_flag;
789: BEGIN
790: IF (x_results IS NULL) THEN
791: x_results := po_validation_results_type.new_instance();
792: END IF;
793:
794: IF po_log.d_proc THEN
795: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 836: x_results IN OUT NOCOPY po_validation_results_type,

832: p_id_tbl IN po_tbl_number,
833: p_purchase_basis_tbl IN po_tbl_varchar30,
834: p_un_number_id_tbl IN po_tbl_number,
835: x_result_set_id IN OUT NOCOPY NUMBER,
836: x_results IN OUT NOCOPY po_validation_results_type,
837: x_result_type OUT NOCOPY VARCHAR2)
838: IS
839: d_mod CONSTANT VARCHAR2(100) := d_un_number_id;
840: BEGIN

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

842: x_result_set_id := po_validations.next_result_set_id();
843: END IF;
844:
845: IF (x_results IS NULL) THEN
846: x_results := po_validation_results_type.new_instance();
847: END IF;
848:
849: IF po_log.d_proc THEN
850: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 927: x_results IN OUT NOCOPY po_validation_results_type,

923: p_id_tbl IN po_tbl_number,
924: p_purchase_basis_tbl IN po_tbl_varchar30,
925: p_hazard_class_id_tbl IN po_tbl_number,
926: x_result_set_id IN OUT NOCOPY NUMBER,
927: x_results IN OUT NOCOPY po_validation_results_type,
928: x_result_type OUT NOCOPY VARCHAR2)
929: IS
930: d_mod CONSTANT VARCHAR2(100) := d_hazard_class_id;
931: BEGIN

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

933: x_result_set_id := po_validations.next_result_set_id();
934: END IF;
935:
936: IF (x_results IS NULL) THEN
937: x_results := po_validation_results_type.new_instance();
938: END IF;
939:
940: IF po_log.d_proc THEN
941: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1020: x_results IN OUT NOCOPY po_validation_results_type,

1016: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1017: p_line_type_id_tbl IN po_tbl_number,
1018: p_inventory_org_id IN NUMBER,
1019: x_result_set_id IN OUT NOCOPY NUMBER,
1020: x_results IN OUT NOCOPY po_validation_results_type,
1021: x_result_type OUT NOCOPY VARCHAR2)
1022: IS
1023: d_mod CONSTANT VARCHAR2(100) := d_item_id;
1024: BEGIN

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

1026: x_result_set_id := po_validations.next_result_set_id();
1027: END IF;
1028:
1029: IF (x_results IS NULL) THEN
1030: x_results := po_validation_results_type.new_instance();
1031: END IF;
1032:
1033: IF po_log.d_proc THEN
1034: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1269: x_results IN OUT NOCOPY po_validation_results_type,

1265: p_item_id_tbl IN po_tbl_number,
1266: p_line_type_id_tbl IN po_tbl_number,
1267: p_inventory_org_id IN NUMBER,
1268: x_result_set_id IN OUT NOCOPY NUMBER,
1269: x_results IN OUT NOCOPY po_validation_results_type,
1270: x_result_type OUT NOCOPY VARCHAR2)
1271: IS
1272: d_mod CONSTANT VARCHAR2(100) := d_unit_meas_lookup_code;
1273: l_service_uom_class VARCHAR2(2000);

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

1276: x_result_set_id := po_validations.next_result_set_id();
1277: END IF;
1278:
1279: IF (x_results IS NULL) THEN
1280: x_results := po_validation_results_type.new_instance();
1281: END IF;
1282:
1283: IF po_log.d_proc THEN
1284: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1505: x_results IN OUT NOCOPY po_validation_results_type,

1501: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1502: p_item_revision_tbl IN po_tbl_varchar5,
1503: p_item_id_tbl IN po_tbl_number,
1504: x_result_set_id IN OUT NOCOPY NUMBER,
1505: x_results IN OUT NOCOPY po_validation_results_type,
1506: x_result_type OUT NOCOPY VARCHAR2)
1507: IS
1508: d_mod CONSTANT VARCHAR2(100) := d_item_revision;
1509: BEGIN

Line 1614: x_results IN OUT NOCOPY po_validation_results_type,

1610: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1611: p_item_id_tbl IN po_tbl_number,
1612: p_inventory_org_id IN NUMBER,
1613: x_result_set_id IN OUT NOCOPY NUMBER,
1614: x_results IN OUT NOCOPY po_validation_results_type,
1615: x_result_type OUT NOCOPY VARCHAR2)
1616: IS
1617: d_mod CONSTANT VARCHAR2(100) := d_category_id;
1618: x_flag mtl_category_sets_v.validate_flag%TYPE;

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

1622: x_result_set_id := po_validations.next_result_set_id();
1623: END IF;
1624:
1625: IF (x_results IS NULL) THEN
1626: x_results := po_validation_results_type.new_instance();
1627: END IF;
1628:
1629: IF po_log.d_proc THEN
1630: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1807: x_results IN OUT NOCOPY po_validation_results_type,

1803: PROCEDURE ip_category_id(
1804: p_id_tbl IN po_tbl_number,
1805: p_ip_category_id_tbl IN po_tbl_number,
1806: x_result_set_id IN OUT NOCOPY NUMBER,
1807: x_results IN OUT NOCOPY po_validation_results_type,
1808: x_result_type OUT NOCOPY VARCHAR2)
1809: IS
1810: d_mod CONSTANT VARCHAR2(100) := d_ip_category_id;
1811: BEGIN

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

1813: x_result_set_id := po_validations.next_result_set_id();
1814: END IF;
1815:
1816: IF (x_results IS NULL) THEN
1817: x_results := po_validation_results_type.new_instance();
1818: END IF;
1819:
1820: IF po_log.d_proc THEN
1821: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1906: x_results IN OUT NOCOPY po_validation_results_type,

1902: p_unit_price_tbl IN po_tbl_number,
1903: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1904: p_line_type_id_tbl IN po_tbl_number,
1905: x_result_set_id IN OUT NOCOPY NUMBER,
1906: x_results IN OUT NOCOPY po_validation_results_type,
1907: x_result_type OUT NOCOPY VARCHAR2)
1908: IS
1909: d_mod CONSTANT VARCHAR2(100) := d_unit_price;
1910: BEGIN

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

1912: x_result_set_id := po_validations.next_result_set_id();
1913: END IF;
1914:
1915: IF (x_results IS NULL) THEN
1916: x_results := po_validation_results_type.new_instance();
1917: END IF;
1918:
1919: IF po_log.d_proc THEN
1920: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 2037: x_results IN OUT NOCOPY po_validation_results_type,

2033: PROCEDURE quantity(
2034: p_id_tbl IN po_tbl_number,
2035: p_quantity_tbl IN po_tbl_number,
2036: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2037: x_results IN OUT NOCOPY po_validation_results_type,
2038: x_result_type OUT NOCOPY VARCHAR2)
2039: IS
2040: d_mod CONSTANT VARCHAR2(100) := d_quantity;
2041: BEGIN

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

2039: IS
2040: d_mod CONSTANT VARCHAR2(100) := d_quantity;
2041: BEGIN
2042: IF (x_results IS NULL) THEN
2043: x_results := po_validation_results_type.new_instance();
2044: END IF;
2045:
2046: IF po_log.d_proc THEN
2047: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 2106: x_results IN OUT NOCOPY po_validation_results_type,

2102: PROCEDURE amount(
2103: p_id_tbl IN po_tbl_number,
2104: p_amount_tbl IN po_tbl_number,
2105: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2106: x_results IN OUT NOCOPY po_validation_results_type,
2107: x_result_type OUT NOCOPY VARCHAR2)
2108: IS
2109: d_mod CONSTANT VARCHAR2(100) := d_amount;
2110: BEGIN

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

2108: IS
2109: d_mod CONSTANT VARCHAR2(100) := d_amount;
2110: BEGIN
2111: IF (x_results IS NULL) THEN
2112: x_results := po_validation_results_type.new_instance();
2113: END IF;
2114:
2115: IF po_log.d_proc THEN
2116: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 2159: x_results IN OUT NOCOPY po_validation_results_type,

2155: PROCEDURE rate_type(
2156: p_id_tbl IN po_tbl_number,
2157: p_rate_type_tbl IN po_tbl_varchar30,
2158: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2159: x_results IN OUT NOCOPY po_validation_results_type,
2160: x_result_type OUT NOCOPY VARCHAR2)
2161: IS
2162: d_mod CONSTANT VARCHAR2(100) := d_rate_type;
2163: BEGIN

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

2161: IS
2162: d_mod CONSTANT VARCHAR2(100) := d_rate_type;
2163: BEGIN
2164: IF (x_results IS NULL) THEN
2165: x_results := po_validation_results_type.new_instance();
2166: END IF;
2167:
2168: IF po_log.d_proc THEN
2169: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 2214: x_results IN OUT NOCOPY po_validation_results_type,

2210: p_line_num_tbl IN po_tbl_number,
2211: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2212: p_draft_id_tbl IN PO_TBL_NUMBER, -- bug5129752
2213: x_result_set_id IN OUT NOCOPY NUMBER,
2214: x_results IN OUT NOCOPY po_validation_results_type,
2215: x_result_type OUT NOCOPY VARCHAR2)
2216: IS
2217: d_mod CONSTANT VARCHAR2(100) := d_line_num;
2218: BEGIN

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

2216: IS
2217: d_mod CONSTANT VARCHAR2(100) := d_line_num;
2218: BEGIN
2219: IF (x_results IS NULL) THEN
2220: x_results := po_validation_results_type.new_instance();
2221: END IF;
2222:
2223: IF x_result_set_id IS NULL THEN
2224: x_result_set_id := po_validations.next_result_set_id();

Line 2682: x_results IN OUT NOCOPY po_validation_results_type,

2678: p_id_tbl IN po_tbl_number,
2679: p_start_date_tbl IN po_tbl_date,
2680: p_expiration_date_tbl IN po_tbl_date,
2681: p_purchase_basis_tbl IN po_tbl_varchar30,
2682: x_results IN OUT NOCOPY po_validation_results_type,
2683: x_result_type OUT NOCOPY VARCHAR2)
2684: IS
2685: d_mod CONSTANT VARCHAR2(100) := d_start_date_standard;
2686: BEGIN

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

2684: IS
2685: d_mod CONSTANT VARCHAR2(100) := d_start_date_standard;
2686: BEGIN
2687: IF (x_results IS NULL) THEN
2688: x_results := po_validation_results_type.new_instance();
2689: END IF;
2690:
2691: IF po_log.d_proc THEN
2692: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 2839: x_results IN OUT NOCOPY po_validation_results_type,

2835: PROCEDURE quantity_standard(
2836: p_id_tbl IN po_tbl_number,
2837: p_quantity_tbl IN po_tbl_number,
2838: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2839: x_results IN OUT NOCOPY po_validation_results_type,
2840: x_result_type OUT NOCOPY VARCHAR2)
2841: IS
2842: d_mod CONSTANT VARCHAR2(100) := d_quantity_standard;
2843: BEGIN

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

2841: IS
2842: d_mod CONSTANT VARCHAR2(100) := d_quantity_standard;
2843: BEGIN
2844: IF (x_results IS NULL) THEN
2845: x_results := po_validation_results_type.new_instance();
2846: END IF;
2847:
2848: IF po_log.d_proc THEN
2849: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 2897: x_results IN OUT NOCOPY po_validation_results_type,

2893: PROCEDURE amount_standard(
2894: p_id_tbl IN po_tbl_number,
2895: p_amount_tbl IN po_tbl_number,
2896: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2897: x_results IN OUT NOCOPY po_validation_results_type,
2898: x_result_type OUT NOCOPY VARCHAR2)
2899: IS
2900: d_mod CONSTANT VARCHAR2(100) := d_amount_standard;
2901: BEGIN

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

2899: IS
2900: d_mod CONSTANT VARCHAR2(100) := d_amount_standard;
2901: BEGIN
2902: IF (x_results IS NULL) THEN
2903: x_results := po_validation_results_type.new_instance();
2904: END IF;
2905:
2906: IF po_log.d_proc THEN
2907: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 2965: x_results IN OUT NOCOPY po_validation_results_type,

2961: p_global_agreement_flag_tbl IN po_tbl_varchar1,
2962: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2963: p_purchase_basis_tbl IN po_tbl_varchar30,
2964: x_result_set_id IN OUT NOCOPY NUMBER,
2965: x_results IN OUT NOCOPY po_validation_results_type,
2966: x_result_type OUT NOCOPY VARCHAR2)
2967: IS
2968: d_mod CONSTANT VARCHAR2(100) := d_price_break_lookup_code;
2969: BEGIN

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

2971: x_result_set_id := po_validations.next_result_set_id();
2972: END IF;
2973:
2974: IF (x_results IS NULL) THEN
2975: x_results := po_validation_results_type.new_instance();
2976: END IF;
2977:
2978: IF po_log.d_proc THEN
2979: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 3072: x_results IN OUT NOCOPY po_validation_results_type,

3068: p_id_tbl IN po_tbl_number,
3069: p_not_to_exceed_price_tbl IN po_tbl_number,
3070: p_allow_price_override_tbl IN po_tbl_varchar1,
3071: p_unit_price_tbl IN po_tbl_number,
3072: x_results IN OUT NOCOPY po_validation_results_type,
3073: x_result_type OUT NOCOPY VARCHAR2)
3074: IS
3075: d_mod CONSTANT VARCHAR2(100) := d_not_to_exceed_price;
3076: BEGIN

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

3074: IS
3075: d_mod CONSTANT VARCHAR2(100) := d_not_to_exceed_price;
3076: BEGIN
3077: IF (x_results IS NULL) THEN
3078: x_results := po_validation_results_type.new_instance();
3079: END IF;
3080:
3081: IF po_log.d_proc THEN
3082: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 3138: x_results IN OUT NOCOPY po_validation_results_type,

3134: PROCEDURE ip_category_id_update(
3135: p_id_tbl IN po_tbl_number,
3136: p_ip_category_id_tbl IN po_tbl_number,
3137: x_result_set_id IN OUT NOCOPY NUMBER,
3138: x_results IN OUT NOCOPY po_validation_results_type,
3139: x_result_type OUT NOCOPY VARCHAR2)
3140: IS
3141: d_mod CONSTANT VARCHAR2(100) := d_ip_category_id_update;
3142: BEGIN

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

3144: x_result_set_id := po_validations.next_result_set_id();
3145: END IF;
3146:
3147: IF (x_results IS NULL) THEN
3148: x_results := po_validation_results_type.new_instance();
3149: END IF;
3150:
3151: IF po_log.d_proc THEN
3152: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

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

3229: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,
3230: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
3231: p_po_header_id_tbl IN po_tbl_number,
3232: p_po_line_id_tbl IN po_tbl_number,
3233: x_results IN OUT NOCOPY po_validation_results_type, x_result_set_id IN OUT NOCOPY NUMBER,
3234: x_result_type OUT NOCOPY VARCHAR2)
3235: IS
3236: d_mod CONSTANT VARCHAR2(100) := d_uom_update;
3237: BEGIN

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

3335: p_item_id_tbl IN po_tbl_number,
3336: p_inventory_org_id IN NUMBER,
3337: p_po_header_id_tbl IN po_tbl_number,
3338: p_po_line_id_tbl IN po_tbl_number,
3339: x_results IN OUT NOCOPY po_validation_results_type, x_result_set_id IN OUT NOCOPY NUMBER,
3340: x_result_type OUT NOCOPY VARCHAR2)
3341: IS
3342: d_mod CONSTANT VARCHAR2(100) := d_item_desc_update;
3343: BEGIN

Line 3454: x_results IN OUT NOCOPY po_validation_results_type,

3450: ----------------------------------------------------------------------------------------
3451: PROCEDURE negotiated_by_preparer(
3452: p_id_tbl IN po_tbl_number,
3453: p_negotiated_by_preparer_tbl IN po_tbl_varchar1,
3454: x_results IN OUT NOCOPY po_validation_results_type,
3455: x_result_type OUT NOCOPY VARCHAR2)
3456: IS
3457: d_mod CONSTANT VARCHAR2(100) := d_negotiated_by_preparer;
3458: BEGIN

Line 3503: x_results IN OUT NOCOPY po_validation_results_type,

3499: --------------------------------------------------------------------------------------
3500: PROCEDURE negotiated_by_prep_update(
3501: p_id_tbl IN po_tbl_number,
3502: p_negotiated_by_preparer_tbl IN po_tbl_varchar1,
3503: x_results IN OUT NOCOPY po_validation_results_type,
3504: x_result_type OUT NOCOPY VARCHAR2)
3505: IS
3506: d_mod CONSTANT VARCHAR2(100) := d_negotiated_by_prep_update;
3507: BEGIN

Line 3569: x_results IN OUT NOCOPY po_validation_results_type,

3565: p_item_id_tbl IN po_tbl_number,
3566: p_job_id_tbl IN po_tbl_number,
3567: p_inventory_org_id IN NUMBER,
3568: x_result_set_id IN OUT NOCOPY NUMBER,
3569: x_results IN OUT NOCOPY po_validation_results_type,
3570: x_result_type OUT NOCOPY VARCHAR2)
3571: IS
3572: d_mod CONSTANT VARCHAR2(100) := d_category_id_update;
3573: BEGIN

Line 3672: x_results IN OUT NOCOPY po_validation_results_type,

3668: ( p_id_tbl IN po_tbl_number,
3669: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
3670: p_draft_id_tbl IN po_tbl_number,
3671: p_unit_price_tbl IN po_tbl_number,
3672: x_results IN OUT NOCOPY po_validation_results_type,
3673: x_result_set_id IN OUT NOCOPY NUMBER, -- bug5008206
3674: x_result_type OUT NOCOPY VARCHAR2
3675: )
3676: IS

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

3676: IS
3677: d_mod CONSTANT VARCHAR2(100) := d_unit_price_update;
3678: BEGIN
3679: IF (x_results IS NULL) THEN
3680: x_results := po_validation_results_type.new_instance();
3681: END IF;
3682:
3683: IF x_result_set_id IS NULL THEN
3684: x_result_set_id := po_validations.next_result_set_id();

Line 3826: x_results IN OUT NOCOPY po_validation_results_type,

3822: ( p_id_tbl IN po_tbl_number,
3823: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
3824: p_draft_id_tbl IN po_tbl_number,
3825: p_amount_tbl IN po_tbl_number,
3826: x_results IN OUT NOCOPY po_validation_results_type,
3827: x_result_set_id IN OUT NOCOPY NUMBER, -- bug5008206
3828: x_result_type OUT NOCOPY VARCHAR2
3829: )
3830: IS

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

3830: IS
3831: d_mod CONSTANT VARCHAR2(100) := d_amount_update;
3832: BEGIN
3833: IF (x_results IS NULL) THEN
3834: x_results := po_validation_results_type.new_instance();
3835: END IF;
3836:
3837: IF x_result_set_id IS NULL THEN
3838: x_result_set_id := po_validations.next_result_set_id();