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

Line 173: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

169: -------------------------------------------------------------------------------
170: PROCEDURE amt_agreed_ge_zero(
171: p_line_id_tbl IN PO_TBL_NUMBER
172: , p_committed_amount_tbl IN PO_TBL_NUMBER
173: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
174: , x_result_type OUT NOCOPY VARCHAR2
175: )
176: IS
177: BEGIN

Line 200: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

196: -------------------------------------------------------------------------------
197: PROCEDURE min_rel_amt_ge_zero(
198: p_line_id_tbl IN PO_TBL_NUMBER
199: , p_min_release_amount_tbl IN PO_TBL_NUMBER
200: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
201: , x_result_type OUT NOCOPY VARCHAR2
202: )
203: IS
204: BEGIN

Line 228: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

224: PROCEDURE quantity_gt_zero(
225: p_line_id_tbl IN PO_TBL_NUMBER
226: , p_quantity_tbl IN PO_TBL_NUMBER
227: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
228: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
229: , x_result_type OUT NOCOPY VARCHAR2
230: )
231: IS
232: BEGIN

Line 376: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

372: , p_advance_tbl IN PO_TBL_NUMBER
373: , p_amount_tbl IN PO_TBL_NUMBER
374: , p_quantity_tbl IN PO_TBL_NUMBER
375: , p_price_tbl IN PO_TBL_NUMBER
376: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
377: , x_result_type OUT NOCOPY VARCHAR2
378: )
379: IS
380: d_mod CONSTANT VARCHAR2(100) := D_advance_amt_le_amt;

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

391: END IF;
392:
393:
394: IF (x_results IS NULL) THEN
395: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
396: END IF;
397:
398: l_results_count := x_results.result_type.COUNT;
399:

Line 543: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

539: PROCEDURE amount_gt_zero(
540: p_line_id_tbl IN PO_TBL_NUMBER
541: , p_amount_tbl IN PO_TBL_NUMBER
542: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
543: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
544: , x_result_type OUT NOCOPY VARCHAR2
545: )
546: IS
547: BEGIN

Line 773: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

769: -----------------------------------------------------------------------------
770: PROCEDURE amount_ge_timecard(
771: p_line_id_tbl IN PO_TBL_NUMBER
772: , p_amount_tbl IN PO_TBL_NUMBER
773: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
774: , x_result_type OUT NOCOPY VARCHAR2
775: )
776: IS
777: d_mod CONSTANT VARCHAR2(100) := D_amount_ge_timecard;

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

792: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
793: END IF;
794:
795: IF (x_results IS NULL) THEN
796: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
797: END IF;
798:
799: l_results_count := x_results.result_type.COUNT;
800:

Line 928: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

924:
925: PROCEDURE line_num_gt_zero(
926: p_line_id_tbl IN PO_TBL_NUMBER
927: , p_line_num_tbl IN PO_TBL_NUMBER
928: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
929: , x_result_type OUT NOCOPY VARCHAR2
930: )
931: IS
932: BEGIN

Line 1069: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1065: PROCEDURE start_date_le_end_date(
1066: p_line_id_tbl IN PO_TBL_NUMBER
1067: , p_start_date_tbl IN PO_TBL_DATE
1068: , p_expiration_date_tbl IN PO_TBL_DATE
1069: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1070: , x_result_type OUT NOCOPY VARCHAR2
1071: )
1072: IS
1073: BEGIN

Line 1103: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1099: ------------------------------------------------------------------------
1100: PROCEDURE otl_invalid_start_date_change(
1101: p_line_id_tbl IN PO_TBL_NUMBER
1102: , p_start_date_tbl IN PO_TBL_DATE
1103: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1104: , x_result_type OUT NOCOPY VARCHAR2
1105: )
1106: IS
1107: BEGIN

Line 1136: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1132: ------------------------------------------------------------------------
1133: PROCEDURE otl_invalid_end_date_change(
1134: p_line_id_tbl IN PO_TBL_NUMBER
1135: , p_expiration_date_tbl IN PO_TBL_DATE
1136: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1137: , x_result_type OUT NOCOPY VARCHAR2
1138: )
1139: IS
1140: BEGIN

Line 1164: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1160: PROCEDURE unit_price_ge_zero(
1161: p_line_id_tbl IN PO_TBL_NUMBER
1162: , p_unit_price_tbl IN PO_TBL_NUMBER
1163: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1164: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1165: , x_result_type OUT NOCOPY VARCHAR2
1166: )
1167: IS
1168: d_mod CONSTANT VARCHAR2(100) := D_unit_price_ge_zero;

Line 1231: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1227: -----------------------------------------------------------------------------
1228: PROCEDURE list_price_ge_zero(
1229: p_line_id_tbl IN PO_TBL_NUMBER
1230: , p_list_price_per_unit_tbl IN PO_TBL_NUMBER
1231: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1232: , x_result_type OUT NOCOPY VARCHAR2
1233: )
1234: IS
1235: BEGIN

Line 1258: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1254: -----------------------------------------------------------------------------
1255: PROCEDURE market_price_ge_zero(
1256: p_line_id_tbl IN PO_TBL_NUMBER
1257: , p_market_price_tbl IN PO_TBL_NUMBER
1258: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1259: , x_result_type OUT NOCOPY VARCHAR2
1260: )
1261: IS
1262: BEGIN

Line 1290: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1286: p_line_id_tbl IN PO_TBL_NUMBER
1287: , p_unit_price_tbl IN PO_TBL_NUMBER
1288: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
1289: , x_result_set_id IN OUT NOCOPY NUMBER
1290: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1291: , x_result_type OUT NOCOPY VARCHAR2
1292: )
1293: IS
1294: d_mod CONSTANT VARCHAR2(100) := D_validate_unit_price_change;

Line 1390: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1386: PROCEDURE expiration_ge_blanket_start(
1387: p_line_id_tbl IN PO_TBL_NUMBER
1388: , p_blanket_start_date_tbl IN PO_TBL_DATE
1389: , p_expiration_date_tbl IN PO_TBL_DATE
1390: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1391: , x_result_type OUT NOCOPY VARCHAR2
1392: )
1393: IS
1394: BEGIN

Line 1422: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1418: PROCEDURE expiration_le_blanket_end(
1419: p_line_id_tbl IN PO_TBL_NUMBER
1420: , p_blanket_end_date_tbl IN PO_TBL_DATE
1421: , p_expiration_date_tbl IN PO_TBL_DATE
1422: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1423: , x_result_type OUT NOCOPY VARCHAR2
1424: )
1425: IS
1426: BEGIN

Line 1453: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1449: -------------------------------------------------------------------------
1450: PROCEDURE recoupment_rate_range_check (
1451: p_line_id_tbl IN PO_TBL_NUMBER
1452: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
1453: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1454: , x_result_type OUT NOCOPY VARCHAR2
1455: )
1456: IS
1457: BEGIN

Line 1476: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1472:
1473: PROCEDURE retainage_rate_range_check (
1474: p_line_id_tbl IN PO_TBL_NUMBER
1475: , p_retainage_rate_tbl IN PO_TBL_NUMBER
1476: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1477: , x_result_type OUT NOCOPY VARCHAR2
1478: )
1479: IS
1480: BEGIN

Line 1499: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1495:
1496: PROCEDURE prog_pay_rate_range_check (
1497: p_line_id_tbl IN PO_TBL_NUMBER
1498: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
1499: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1500: , x_result_type OUT NOCOPY VARCHAR2
1501: )
1502: IS
1503: BEGIN

Line 1714: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1710: PROCEDURE unit_meas_not_null(
1711: p_line_id_tbl IN PO_TBL_NUMBER
1712: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
1713: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1714: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1715: , x_result_type OUT NOCOPY VARCHAR2
1716: )
1717: IS
1718: d_mod CONSTANT VARCHAR2(100) := D_unit_meas_not_null;

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

1726: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1727: END IF;
1728:
1729: IF (x_results IS NULL) THEN
1730: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1731: END IF;
1732:
1733: l_results_count := x_results.result_type.COUNT;
1734:

Line 1776: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1772: -------------------------------------------------------------------------------
1773: PROCEDURE item_description_not_null(
1774: p_line_id_tbl IN PO_TBL_NUMBER
1775: , p_item_description_tbl IN PO_TBL_VARCHAR2000
1776: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1777: , x_result_type OUT NOCOPY VARCHAR2
1778: )
1779: IS
1780: BEGIN

Line 1802: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1798: -------------------------------------------------------------------------------
1799: PROCEDURE category_id_not_null(
1800: p_line_id_tbl IN PO_TBL_NUMBER
1801: , p_category_id_tbl IN PO_TBL_NUMBER
1802: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1803: , x_result_type OUT NOCOPY VARCHAR2
1804: )
1805: IS
1806: BEGIN

Line 1936: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1932: PROCEDURE temp_labor_job_id_not_null(
1933: p_line_id_tbl IN PO_TBL_NUMBER
1934: , p_job_id_tbl IN PO_TBL_NUMBER
1935: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
1936: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1937: , x_result_type OUT NOCOPY VARCHAR2
1938: )
1939: IS
1940: d_mod CONSTANT VARCHAR2(100) := D_temp_labor_job_id_not_null;

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

1948: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1949: END IF;
1950:
1951: IF (x_results IS NULL) THEN
1952: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1953: END IF;
1954:
1955: l_results_count := x_results.result_type.COUNT;
1956:

Line 1999: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1995: PROCEDURE src_doc_line_not_null(
1996: p_line_id_tbl IN PO_TBL_NUMBER
1997: , p_from_header_id_tbl IN PO_TBL_NUMBER
1998: , p_from_line_id_tbl IN PO_TBL_NUMBER
1999: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2000: , x_result_type OUT NOCOPY VARCHAR2
2001: )
2002: IS
2003: d_mod CONSTANT VARCHAR2(100) := D_src_doc_line_not_null;

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

2004: l_results_count NUMBER;
2005: BEGIN
2006:
2007: IF (x_results IS NULL) THEN
2008: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2009: END IF;
2010:
2011: IF PO_LOG.d_proc THEN
2012: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

Line 2059: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2055: -------------------------------------------------------------------------------
2056: PROCEDURE line_type_id_not_null(
2057: p_line_id_tbl IN PO_TBL_NUMBER
2058: , p_line_type_id_tbl IN PO_TBL_NUMBER
2059: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2060: , x_result_type OUT NOCOPY VARCHAR2
2061: )
2062: IS
2063: BEGIN

Line 2085: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2081: PROCEDURE temp_lbr_start_date_not_null(
2082: p_line_id_tbl IN PO_TBL_NUMBER
2083: , p_start_date_tbl IN PO_TBL_DATE
2084: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
2085: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2086: , x_result_type OUT NOCOPY VARCHAR2
2087: )
2088: IS
2089: d_mod CONSTANT VARCHAR2(100) := D_temp_lbr_start_date_not_null;

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

2097: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2098: END IF;
2099:
2100: IF (x_results IS NULL) THEN
2101: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2102: END IF;
2103:
2104: l_results_count := x_results.result_type.COUNT;
2105:

Line 2149: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2145: PROCEDURE line_sec_quantity_gt_zero(
2146: p_line_id_tbl IN PO_TBL_NUMBER
2147: , p_item_id_tbl IN PO_TBL_NUMBER
2148: , p_sec_quantity_tbl IN PO_TBL_NUMBER
2149: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2150: , x_result_type OUT NOCOPY VARCHAR2
2151: )
2152: IS
2153: d_mod CONSTANT VARCHAR2(100) := D_line_sec_quantity_gt_zero;

Line 2214: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2210: , p_quantity_tbl IN PO_TBL_NUMBER
2211: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
2212: , p_sec_quantity_tbl IN PO_TBL_NUMBER
2213: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
2214: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2215: , x_result_type OUT NOCOPY VARCHAR2
2216: )
2217: IS
2218:

Line 2278: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2274: PROCEDURE from_line_id_not_null (
2275: p_line_id_tbl IN PO_TBL_NUMBER
2276: , p_from_header_id_tbl IN PO_TBL_NUMBER
2277: , p_from_line_id_tbl IN PO_TBL_NUMBER
2278: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2279: , x_result_type OUT NOCOPY VARCHAR2
2280: )
2281: IS
2282:

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

2293: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2294: END IF;
2295:
2296: IF (x_results IS NULL) THEN
2297: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2298: END IF;
2299:
2300: l_results_count := x_results.result_type.COUNT;
2301:

Line 2365: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2361: -------------------------------------------------------------------------------
2362: PROCEDURE max_retain_amt_ge_zero(
2363: p_line_id_tbl IN PO_TBL_NUMBER
2364: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
2365: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2366: , x_result_type OUT NOCOPY VARCHAR2
2367: )
2368: IS
2369: BEGIN