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

277: -------------------------------------------------------------------------------
278: PROCEDURE amt_agreed_ge_zero(
279: p_line_id_tbl IN PO_TBL_NUMBER
280: , p_committed_amount_tbl IN PO_TBL_NUMBER
281: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
282: , x_result_type OUT NOCOPY VARCHAR2
283: )
284: IS
285: BEGIN

Line 308: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

304: -------------------------------------------------------------------------------
305: PROCEDURE min_rel_amt_ge_zero(
306: p_line_id_tbl IN PO_TBL_NUMBER
307: , p_min_release_amount_tbl IN PO_TBL_NUMBER
308: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
309: , x_result_type OUT NOCOPY VARCHAR2
310: )
311: IS
312: BEGIN

Line 338: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

334: , p_quantity_tbl IN PO_TBL_NUMBER
335: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
336: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
337: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
338: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
339: , x_result_type OUT NOCOPY VARCHAR2
340: , p_header_id_tbl IN PO_TBL_NUMBER --
341: )
342: IS

Line 490: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

486: , p_advance_tbl IN PO_TBL_NUMBER
487: , p_amount_tbl IN PO_TBL_NUMBER
488: , p_quantity_tbl IN PO_TBL_NUMBER
489: , p_price_tbl IN PO_TBL_NUMBER
490: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
491: , x_result_type OUT NOCOPY VARCHAR2
492: )
493: IS
494: d_mod CONSTANT VARCHAR2(100) := D_advance_amt_le_amt;

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

507: END IF;
508:
509:
510: IF (x_results IS NULL) THEN
511: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
512: END IF;
513:
514: l_results_count := x_results.result_type.COUNT;
515:

Line 550: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

546: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
547: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
548: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
549: , p_advance_tbl IN PO_TBL_NUMBER
550: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
551: , x_result_type OUT NOCOPY VARCHAR2
552: )
553: IS
554: d_mod CONSTANT VARCHAR2(100) := D_complex_po_attributes_check;

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

576: END IF;
577:
578:
579: IF (x_results IS NULL) THEN
580: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
581: END IF;
582:
583: l_results_count := x_results.result_type.COUNT;
584:

Line 799: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

795: , p_amount_tbl IN PO_TBL_NUMBER
796: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
797: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
798: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
799: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
800: , x_result_type OUT NOCOPY VARCHAR2
801: , p_header_id_tbl IN PO_TBL_NUMBER --
802: )
803: IS

Line 1033: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1029: -----------------------------------------------------------------------------
1030: PROCEDURE amount_ge_timecard(
1031: p_line_id_tbl IN PO_TBL_NUMBER
1032: , p_amount_tbl IN PO_TBL_NUMBER
1033: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1034: , x_result_type OUT NOCOPY VARCHAR2
1035: )
1036: IS
1037: d_mod CONSTANT VARCHAR2(100) := D_amount_ge_timecard;

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

1052: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1053: END IF;
1054:
1055: IF (x_results IS NULL) THEN
1056: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1057: END IF;
1058:
1059: l_results_count := x_results.result_type.COUNT;
1060:

Line 1192: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1188:
1189: PROCEDURE line_num_gt_zero(
1190: p_line_id_tbl IN PO_TBL_NUMBER
1191: , p_line_num_tbl IN PO_TBL_NUMBER
1192: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1193: , x_result_type OUT NOCOPY VARCHAR2
1194: )
1195: IS
1196: BEGIN

Line 1333: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1329: PROCEDURE start_date_le_end_date(
1330: p_line_id_tbl IN PO_TBL_NUMBER
1331: , p_start_date_tbl IN PO_TBL_DATE
1332: , p_expiration_date_tbl IN PO_TBL_DATE
1333: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1334: , x_result_type OUT NOCOPY VARCHAR2
1335: )
1336: IS
1337: BEGIN

Line 1370: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1366: (
1367: p_line_id_tbl IN PO_TBL_NUMBER
1368: , p_start_date_tbl IN PO_TBL_DATE
1369: , p_expiration_date_tbl IN PO_TBL_DATE
1370: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1371: , x_result_type OUT NOCOPY VARCHAR2
1372: )
1373: IS
1374: l_results_count NUMBER;

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

1379: RETURN;
1380: END IF;
1381:
1382: IF (x_results IS NULL) THEN
1383: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1384: END IF;
1385:
1386: l_results_count := x_results.result_type.COUNT;
1387:

Line 1435: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1431: (
1432: p_line_id_tbl IN PO_TBL_NUMBER
1433: , p_order_from_date_tbl IN PO_TBL_DATE
1434: , p_draft_id_tbl IN PO_TBL_NUMBER
1435: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1436: , x_result_type OUT NOCOPY VARCHAR2
1437: )
1438: IS
1439: l_results_count NUMBER;

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

1455: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
1456: END IF;
1457:
1458: IF (x_results IS NULL) THEN
1459: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1460: END IF;
1461:
1462: l_results_count := x_results.result_type.COUNT;
1463:

Line 1521: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1517: (
1518: p_line_id_tbl IN PO_TBL_NUMBER
1519: , p_max_total_amt_tbl IN PO_TBL_NUMBER
1520: , p_line_amount_tbl IN PO_TBL_NUMBER
1521: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1522: , x_result_type OUT NOCOPY VARCHAR2
1523: )
1524: IS
1525: d_mod CONSTANT VARCHAR2(100) := D_max_tot_amt_le_line_tot_amt;

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

1540: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1541: END IF;
1542:
1543: IF (x_results IS NULL) THEN
1544: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1545: END IF;
1546:
1547: l_results_count := x_results.result_type.COUNT;
1548:

Line 1576: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1572: (
1573: p_line_id_tbl IN PO_TBL_NUMBER
1574: , p_max_total_amt_tbl IN PO_TBL_NUMBER
1575: , p_min_total_amt_tbl IN PO_TBL_NUMBER
1576: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1577: , x_result_type OUT NOCOPY VARCHAR2
1578: )
1579: IS
1580: d_mod CONSTANT VARCHAR2(100) := D_max_tot_amt_ge_min_tot_amt;

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

1595: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1596: END IF;
1597:
1598: IF (x_results IS NULL) THEN
1599: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1600: END IF;
1601:
1602: l_results_count := x_results.result_type.COUNT;
1603:

Line 1630: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1626: (
1627: p_line_id_tbl IN PO_TBL_NUMBER
1628: , p_max_total_qty_tbl IN PO_TBL_NUMBER
1629: , p_line_qty_tbl IN PO_TBL_NUMBER
1630: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1631: , x_result_type OUT NOCOPY VARCHAR2
1632: )
1633: IS
1634: d_mod CONSTANT VARCHAR2(100) := D_max_tot_qty_le_line_tot_qty;

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

1649: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1650: END IF;
1651:
1652: IF (x_results IS NULL) THEN
1653: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1654: END IF;
1655:
1656: l_results_count := x_results.result_type.COUNT;
1657:

Line 1685: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1681: (
1682: p_line_id_tbl IN PO_TBL_NUMBER
1683: , p_max_total_qty_tbl IN PO_TBL_NUMBER
1684: , p_min_total_qty_tbl IN PO_TBL_NUMBER
1685: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1686: , x_result_type OUT NOCOPY VARCHAR2
1687: )
1688: IS
1689: d_mod CONSTANT VARCHAR2(100) := D_max_tot_qty_ge_min_tot_qty;

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

1704: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1705: END IF;
1706:
1707: IF (x_results IS NULL) THEN
1708: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1709: END IF;
1710:
1711: l_results_count := x_results.result_type.COUNT;
1712:

Line 1740: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1736: (
1737: p_line_id_tbl IN PO_TBL_NUMBER
1738: , p_max_order_amt_tbl IN PO_TBL_NUMBER
1739: , p_max_tot_amount_tbl IN PO_TBL_NUMBER
1740: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1741: , x_result_type OUT NOCOPY VARCHAR2
1742: )
1743: IS
1744: d_mod CONSTANT VARCHAR2(100) := D_max_ord_amt_le_max_tot_amt;

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

1759: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1760: END IF;
1761:
1762: IF (x_results IS NULL) THEN
1763: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1764: END IF;
1765:
1766: l_results_count := x_results.result_type.COUNT;
1767:

Line 1795: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1791: (
1792: p_line_id_tbl IN PO_TBL_NUMBER
1793: , p_max_ord_amt_tbl IN PO_TBL_NUMBER
1794: , p_min_ord_amt_tbl IN PO_TBL_NUMBER
1795: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1796: , x_result_type OUT NOCOPY VARCHAR2
1797: )
1798: IS
1799: d_mod CONSTANT VARCHAR2(100) := D_max_ord_amt_ge_min_ord_amt;

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

1814: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1815: END IF;
1816:
1817: IF (x_results IS NULL) THEN
1818: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1819: END IF;
1820:
1821: l_results_count := x_results.result_type.COUNT;
1822:

Line 1849: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1845: (
1846: p_line_id_tbl IN PO_TBL_NUMBER
1847: , p_max_order_qty_tbl IN PO_TBL_NUMBER
1848: , p_max_tot_qty_tbl IN PO_TBL_NUMBER
1849: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1850: , x_result_type OUT NOCOPY VARCHAR2
1851: )
1852: IS
1853: d_mod CONSTANT VARCHAR2(100) := D_max_ord_qty_le_max_tot_qty;

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

1868: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1869: END IF;
1870:
1871: IF (x_results IS NULL) THEN
1872: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1873: END IF;
1874:
1875: l_results_count := x_results.result_type.COUNT;
1876:

Line 1904: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1900: (
1901: p_line_id_tbl IN PO_TBL_NUMBER
1902: , p_max_ord_qty_tbl IN PO_TBL_NUMBER
1903: , p_min_ord_qty_tbl IN PO_TBL_NUMBER
1904: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1905: , x_result_type OUT NOCOPY VARCHAR2
1906: )
1907: IS
1908: d_mod CONSTANT VARCHAR2(100) := D_max_ord_qty_ge_min_ord_qty;

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

1923: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1924: END IF;
1925:
1926: IF (x_results IS NULL) THEN
1927: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1928: END IF;
1929:
1930: l_results_count := x_results.result_type.COUNT;
1931:

Line 1966: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1962: ------------------------------------------------------------------------
1963: PROCEDURE otl_invalid_start_date_change(
1964: p_line_id_tbl IN PO_TBL_NUMBER
1965: , p_start_date_tbl IN PO_TBL_DATE
1966: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1967: , x_result_type OUT NOCOPY VARCHAR2
1968: )
1969: IS
1970: BEGIN

Line 1999: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1995: ------------------------------------------------------------------------
1996: PROCEDURE otl_invalid_end_date_change(
1997: p_line_id_tbl IN PO_TBL_NUMBER
1998: , p_expiration_date_tbl IN PO_TBL_DATE
1999: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2000: , x_result_type OUT NOCOPY VARCHAR2
2001: )
2002: IS
2003: BEGIN

Line 2028: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2024: p_line_id_tbl IN PO_TBL_NUMBER
2025: , p_unit_price_tbl IN PO_TBL_NUMBER
2026: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
2027: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2028: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2029: , x_result_type OUT NOCOPY VARCHAR2
2030: )
2031: IS
2032: d_mod CONSTANT VARCHAR2(100) := D_unit_price_ge_zero;

Line 2098: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2094: -----------------------------------------------------------------------------
2095: PROCEDURE list_price_ge_zero(
2096: p_line_id_tbl IN PO_TBL_NUMBER
2097: , p_list_price_per_unit_tbl IN PO_TBL_NUMBER
2098: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2099: , x_result_type OUT NOCOPY VARCHAR2
2100: )
2101: IS
2102: BEGIN

Line 2125: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2121: -----------------------------------------------------------------------------
2122: PROCEDURE market_price_ge_zero(
2123: p_line_id_tbl IN PO_TBL_NUMBER
2124: , p_market_price_tbl IN PO_TBL_NUMBER
2125: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2126: , x_result_type OUT NOCOPY VARCHAR2
2127: )
2128: IS
2129: BEGIN

Line 2158: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2154: , p_unit_price_tbl IN PO_TBL_NUMBER
2155: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
2156: , p_amt_changed_flag_tbl IN PO_TBL_VARCHAR1
2157: , x_result_set_id IN OUT NOCOPY NUMBER
2158: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2159: , x_result_type OUT NOCOPY VARCHAR2
2160: )
2161: IS
2162: d_mod CONSTANT VARCHAR2(100) := D_validate_unit_price_change;

Line 2265: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2261: PROCEDURE expiration_ge_blanket_start(
2262: p_line_id_tbl IN PO_TBL_NUMBER
2263: , p_blanket_start_date_tbl IN PO_TBL_DATE
2264: , p_expiration_date_tbl IN PO_TBL_DATE
2265: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2266: , x_result_type OUT NOCOPY VARCHAR2
2267: )
2268: IS
2269: BEGIN

Line 2297: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2293: PROCEDURE expiration_le_blanket_end(
2294: p_line_id_tbl IN PO_TBL_NUMBER
2295: , p_blanket_end_date_tbl IN PO_TBL_DATE
2296: , p_expiration_date_tbl IN PO_TBL_DATE
2297: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2298: , x_result_type OUT NOCOPY VARCHAR2
2299: )
2300: IS
2301: BEGIN

Line 2328: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2324: -------------------------------------------------------------------------
2325: PROCEDURE recoupment_rate_range_check (
2326: p_line_id_tbl IN PO_TBL_NUMBER
2327: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
2328: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2329: , x_result_type OUT NOCOPY VARCHAR2
2330: )
2331: IS
2332: BEGIN

Line 2351: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2347:
2348: PROCEDURE retainage_rate_range_check (
2349: p_line_id_tbl IN PO_TBL_NUMBER
2350: , p_retainage_rate_tbl IN PO_TBL_NUMBER
2351: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2352: , x_result_type OUT NOCOPY VARCHAR2
2353: )
2354: IS
2355: BEGIN

Line 2374: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2370:
2371: PROCEDURE prog_pay_rate_range_check (
2372: p_line_id_tbl IN PO_TBL_NUMBER
2373: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
2374: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2375: , x_result_type OUT NOCOPY VARCHAR2
2376: )
2377: IS
2378: BEGIN

Line 2590: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2586: p_line_id_tbl IN PO_TBL_NUMBER
2587: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
2588: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
2589: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2590: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2591: , x_result_type OUT NOCOPY VARCHAR2
2592: )
2593: IS
2594: d_mod CONSTANT VARCHAR2(100) := D_unit_meas_not_null;

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

2603: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2604: END IF;
2605:
2606: IF (x_results IS NULL) THEN
2607: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2608: END IF;
2609:
2610: l_results_count := x_results.result_type.COUNT;
2611:

Line 2655: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2651: -------------------------------------------------------------------------------
2652: PROCEDURE item_description_not_null(
2653: p_line_id_tbl IN PO_TBL_NUMBER
2654: , p_item_description_tbl IN PO_TBL_VARCHAR2000
2655: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2656: , x_result_type OUT NOCOPY VARCHAR2
2657: )
2658: IS
2659: BEGIN

Line 2682: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2678: PROCEDURE category_id_not_null(
2679: p_line_id_tbl IN PO_TBL_NUMBER
2680: , p_category_id_tbl IN PO_TBL_NUMBER
2681: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2682: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2683: , x_result_type OUT NOCOPY VARCHAR2
2684: )
2685: IS
2686:

Line 2848: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2844: PROCEDURE temp_labor_job_id_not_null(
2845: p_line_id_tbl IN PO_TBL_NUMBER
2846: , p_job_id_tbl IN PO_TBL_NUMBER
2847: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
2848: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2849: , x_result_type OUT NOCOPY VARCHAR2
2850: )
2851: IS
2852: d_mod CONSTANT VARCHAR2(100) := D_temp_labor_job_id_not_null;

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

2860: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2861: END IF;
2862:
2863: IF (x_results IS NULL) THEN
2864: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2865: END IF;
2866:
2867: l_results_count := x_results.result_type.COUNT;
2868:

Line 2911: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2907: PROCEDURE src_doc_line_not_null(
2908: p_line_id_tbl IN PO_TBL_NUMBER
2909: , p_from_header_id_tbl IN PO_TBL_NUMBER
2910: , p_from_line_id_tbl IN PO_TBL_NUMBER
2911: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2912: , x_result_type OUT NOCOPY VARCHAR2
2913: )
2914: IS
2915: d_mod CONSTANT VARCHAR2(100) := D_src_doc_line_not_null;

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

2916: l_results_count NUMBER;
2917: BEGIN
2918:
2919: IF (x_results IS NULL) THEN
2920: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2921: END IF;
2922:
2923: IF PO_LOG.d_proc THEN
2924: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

Line 2980: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2976: PROCEDURE line_type_id_not_null(
2977: p_line_id_tbl IN PO_TBL_NUMBER
2978: , p_line_type_id_tbl IN PO_TBL_NUMBER
2979: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2980: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2981: , x_result_type OUT NOCOPY VARCHAR2
2982: )
2983: IS
2984:

Line 3032: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

3028: PROCEDURE temp_lbr_start_date_not_null(
3029: p_line_id_tbl IN PO_TBL_NUMBER
3030: , p_start_date_tbl IN PO_TBL_DATE
3031: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
3032: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3033: , x_result_type OUT NOCOPY VARCHAR2
3034: )
3035: IS
3036: d_mod CONSTANT VARCHAR2(100) := D_temp_lbr_start_date_not_null;

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

3044: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3045: END IF;
3046:
3047: IF (x_results IS NULL) THEN
3048: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3049: END IF;
3050:
3051: l_results_count := x_results.result_type.COUNT;
3052:

Line 3096: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

3092: PROCEDURE line_sec_quantity_gt_zero(
3093: p_line_id_tbl IN PO_TBL_NUMBER
3094: , p_item_id_tbl IN PO_TBL_NUMBER
3095: , p_sec_quantity_tbl IN PO_TBL_NUMBER
3096: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3097: , x_result_type OUT NOCOPY VARCHAR2
3098: )
3099: IS
3100: d_mod CONSTANT VARCHAR2(100) := D_line_sec_quantity_gt_zero;

Line 3161: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

3157: , p_quantity_tbl IN PO_TBL_NUMBER
3158: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
3159: , p_sec_quantity_tbl IN PO_TBL_NUMBER
3160: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
3161: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3162: , x_result_type OUT NOCOPY VARCHAR2
3163: )
3164: IS
3165:

Line 3225: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

3221: PROCEDURE from_line_id_not_null (
3222: p_line_id_tbl IN PO_TBL_NUMBER
3223: , p_from_header_id_tbl IN PO_TBL_NUMBER
3224: , p_from_line_id_tbl IN PO_TBL_NUMBER
3225: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3226: , x_result_type OUT NOCOPY VARCHAR2
3227: )
3228: IS
3229:

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

3240: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3241: END IF;
3242:
3243: IF (x_results IS NULL) THEN
3244: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3245: END IF;
3246:
3247: l_results_count := x_results.result_type.COUNT;
3248:

Line 3312: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

3308: -------------------------------------------------------------------------------
3309: PROCEDURE max_retain_amt_ge_zero(
3310: p_line_id_tbl IN PO_TBL_NUMBER
3311: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
3312: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3313: , x_result_type OUT NOCOPY VARCHAR2
3314: )
3315: IS
3316: BEGIN

Line 3421: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

3417: PROCEDURE option_from_date_not_null (
3418: p_line_id_tbl IN PO_TBL_NUMBER
3419: , p_option_ind_tbl IN PO_TBL_VARCHAR1
3420: , p_option_from_date_tbl IN PO_TBL_DATE
3421: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3422: , x_result_type OUT NOCOPY VARCHAR2
3423: )
3424: IS
3425: d_mod CONSTANT VARCHAR2(100) := D_option_from_date_not_null;

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

3433: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3434: END IF;
3435:
3436: IF (x_results IS NULL) THEN
3437: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3438: END IF;
3439:
3440: l_results_count := x_results.result_type.COUNT;
3441:

Line 3476: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

3472: PROCEDURE option_to_date_not_null (
3473: p_line_id_tbl IN PO_TBL_NUMBER
3474: , p_option_ind_tbl IN PO_TBL_VARCHAR1
3475: ,p_option_to_Date_tbl IN PO_TBL_DATE
3476: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3477: , x_result_type OUT NOCOPY VARCHAR2
3478: )
3479: IS
3480: l_results_count NUMBER;

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

3488: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3489: END IF;
3490:
3491: IF (x_results IS NULL) THEN
3492: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3493: END IF;
3494:
3495: l_results_count := x_results.result_type.COUNT;
3496:

Line 3532: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

3528: p_line_id_tbl IN PO_TBL_NUMBER
3529: , p_option_ind_tbl IN PO_TBL_VARCHAR1
3530: ,p_option_from_date_tbl IN PO_TBL_DATE
3531: ,p_option_to_Date_tbl IN PO_TBL_DATE
3532: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3533: , x_result_type OUT NOCOPY VARCHAR2
3534: )
3535: IS
3536: l_results_count NUMBER;

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

3547: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3548: END IF;
3549:
3550: IF (x_results IS NULL) THEN
3551: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3552: END IF;
3553:
3554: l_results_count := x_results.result_type.COUNT;
3555:

Line 3593: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

3589: p_line_id_tbl IN PO_TBL_NUMBER
3590: , p_option_ind_tbl IN PO_TBL_VARCHAR1
3591: ,p_option_from_date_tbl IN PO_TBL_DATE
3592: , p_draft_id_tbl IN PO_TBL_NUMBER
3593: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3594: , x_result_type OUT NOCOPY VARCHAR2
3595: )
3596: IS
3597: l_results_count NUMBER;

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

3608: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3609: END IF;
3610:
3611: IF (x_results IS NULL) THEN
3612: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3613: END IF;
3614:
3615: l_results_count := x_results.result_type.COUNT;
3616:

Line 3677: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

3673: p_line_id_tbl IN PO_TBL_NUMBER
3674: , p_exer_flag_tbl IN PO_TBL_VARCHAR1
3675: , p_option_from_date_tbl IN PO_TBL_DATE
3676: , p_option_exer_date_tbl IN PO_TBL_DATE
3677: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3678: , x_result_type OUT NOCOPY VARCHAR2
3679: )
3680: IS
3681: l_results_count NUMBER;

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

3692: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3693: END IF;
3694:
3695: IF (x_results IS NULL) THEN
3696: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3697: END IF;
3698:
3699: l_results_count := x_results.result_type.COUNT;
3700:

Line 3738: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

3734: p_line_id_tbl IN PO_TBL_NUMBER
3735: , p_line_num_disp_tbl IN PO_TBL_VARCHAR100
3736: , p_group_line_id_tbl IN PO_TBL_NUMBER
3737: , p_clm_exhibit_name_tbl IN PO_TBL_VARCHAR20
3738: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3739: , x_result_type OUT NOCOPY VARCHAR2
3740: )is
3741: d_mod CONSTANT VARCHAR2(100) := D_line_num_disp_check;
3742: l_results_count NUMBER;

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

3753: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3754: END IF;
3755:
3756: IF (x_results IS NULL) THEN
3757: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3758: END IF;
3759:
3760: l_results_count := x_results.result_type.COUNT;
3761:

Line 4116: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

4112: p_line_id_tbl IN PO_TBL_NUMBER,
4113: --p_draft_id_tbl IN PO_TBL_NUMBER,
4114: p_intf_line_id_tbl IN PO_TBL_NUMBER,
4115: p_group_line_id_tbl IN PO_TBL_NUMBER,
4116: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
4117: x_result_type OUT NOCOPY VARCHAR2
4118: )
4119: IS
4120: d_mod CONSTANT VARCHAR2(100) := D_clin_slin_structure;

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

4133: PO_LOG.proc_begin(d_mod,'p_group_line_id_tbl',p_group_line_id_tbl);
4134: END IF;
4135:
4136: IF (x_results IS NULL) THEN
4137: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4138: END IF;
4139:
4140: --l_results_count := x_results.result_type.COUNT;
4141:

Line 4196: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

4192: PROCEDURE validate_contract_type(
4193: p_intf_line_id_tbl IN PO_TBL_NUMBER
4194: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
4195: , p_contract_type_tbl IN PO_TBL_VARCHAR240
4196: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4197: , x_result_type OUT NOCOPY VARCHAR2
4198: ) IS
4199:
4200: d_mod CONSTANT VARCHAR2(100) := D_validate_contract_type;

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

4214: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
4215: END IF;
4216:
4217: IF (x_results IS NULL) THEN
4218: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4219: END IF;
4220:
4221: FOR i IN 1..p_intf_line_id_tbl.Count
4222: LOOP

Line 4284: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

4280:
4281: PROCEDURE validate_cost_constraint(
4282: p_intf_line_id_tbl IN PO_TBL_NUMBER
4283: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
4284: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4285: , x_result_type OUT NOCOPY VARCHAR2
4286: ) IS
4287:
4288: d_mod CONSTANT VARCHAR2(100) := D_validate_cost_constraint;

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

4302: --PO_LOG.proc_begin(d_mod,'p_cost_constraint_tbl',p_order_type_lookup_code_tbl);
4303: END IF;
4304:
4305: IF (x_results IS NULL) THEN
4306: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4307: END IF;
4308:
4309: FOR i IN 1..p_intf_line_id_tbl.Count
4310: LOOP

Line 4358: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

4354: p_intf_line_id_tbl IN PO_TBL_NUMBER
4355: , p_oke_contract_header_id_tbl IN PO_TBL_NUMBER
4356: , p_oke_contract_header_num_tbl IN PO_TBL_VARCHAR240
4357: , p_oke_contract_version_id_tbl IN PO_TBL_NUMBER
4358: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4359: , x_result_type OUT NOCOPY VARCHAR2
4360: ) IS
4361:
4362: d_mod CONSTANT VARCHAR2(100) := D_check_contract_num_and_ver;

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

4376: --PO_LOG.proc_begin(d_mod,'p_oke_contract_header_num_tbl',p_oke_contract_header_num_tbl);
4377: END IF;
4378:
4379: IF (x_results IS NULL) THEN
4380: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4381: END IF;
4382:
4383: FOR i IN 1..p_intf_line_id_tbl.Count
4384: LOOP

Line 4462: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

4458:
4459: PROCEDURE validate_option_indicator(
4460: p_intf_line_id_tbl IN PO_TBL_NUMBER
4461: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
4462: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4463: , x_result_type OUT NOCOPY VARCHAR2
4464: ) IS
4465:
4466: d_mod CONSTANT VARCHAR2(100) := D_validate_option_indicator;

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

4480: PO_LOG.proc_begin(d_mod,'p_clm_option_indicator_tbl',p_clm_option_indicator_tbl);
4481: END IF;
4482:
4483: IF (x_results IS NULL) THEN
4484: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4485: END IF;
4486:
4487: FOR i IN 1..p_intf_line_id_tbl.Count
4488: LOOP

Line 4528: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

4524: PROCEDURE validate_clm_base_line_num(
4525: p_intf_line_id_tbl IN PO_TBL_NUMBER
4526: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
4527: , p_clm_base_line_num_tbl IN PO_TBL_NUMBER
4528: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4529: , x_result_type OUT NOCOPY VARCHAR2
4530: ) IS
4531:
4532: d_mod CONSTANT VARCHAR2(100) := D_validate_clm_base_line_num;

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

4548: --PO_LOG.proc_begin(d_mod,'validate_clm_base_line_num',validate_clm_base_line_num);
4549: END IF;
4550:
4551: IF (x_results IS NULL) THEN
4552: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4553: END IF;
4554:
4555: FOR i IN 1..p_intf_line_id_tbl.Count
4556: LOOP

Line 4632: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

4628: p_intf_line_id_tbl IN PO_TBL_NUMBER
4629: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
4630: , p_clm_base_line_num_tbl IN PO_TBL_NUMBER
4631: , p_clm_option_num_tbl IN PO_TBL_NUMBER
4632: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4633: , x_result_type OUT NOCOPY VARCHAR2
4634: ) IS
4635:
4636: d_mod CONSTANT VARCHAR2(100) := D_validate_clm_option_num;

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

4650: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4651: --PO_LOG.proc_begin(d_mod,'validate_clm_base_line_num',validate_clm_base_line_num);
4652: END IF;
4653: IF (x_results IS NULL) THEN
4654: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4655: END IF;
4656:
4657: FOR i IN 1..p_intf_line_id_tbl.Count
4658: LOOP

Line 4726: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

4722:
4723: PROCEDURE validate_clm_idc_type(
4724: p_intf_line_id_tbl IN PO_TBL_NUMBER
4725: , p_clm_idc_type_tbl IN PO_TBL_VARCHAR240
4726: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4727: , x_result_type OUT NOCOPY VARCHAR2
4728: ) IS
4729:
4730: d_mod CONSTANT VARCHAR2(100) := D_validate_clm_idc_type;

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

4744: --PO_LOG.proc_begin(d_mod,'p_clm_option_indicator_tbl',p_clm_idc_type_tbl);
4745: END IF;
4746:
4747: IF (x_results IS NULL) THEN
4748: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4749: END IF;
4750:
4751: FOR i IN 1..p_intf_line_id_tbl.Count
4752: LOOP

Line 4801: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

4797: p_intf_line_id_tbl IN PO_TBL_NUMBER
4798: , p_line_num_disp_tbl IN PO_TBL_VARCHAR100
4799: , p_group_line_id_tbl IN PO_TBL_NUMBER
4800: , p_intf_header_id_tbl IN PO_TBL_NUMBER
4801: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4802: , x_result_type OUT NOCOPY VARCHAR2
4803: ) IS
4804:
4805: d_mod CONSTANT VARCHAR2(100) := D_validate_clin_line_num_disp;

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

4820: --PO_LOG.proc_begin(d_mod,'p_clm_option_indicator_tbl',p_clm_idc_type_tbl);
4821: END IF;
4822:
4823: IF (x_results IS NULL) THEN
4824: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4825: END IF;
4826:
4827: FOR i IN 1..p_intf_line_id_tbl.Count
4828: LOOP

Line 4883: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

4879:
4880: PROCEDURE idv_reference_equal_check(
4881: p_intf_line_id_tbl IN PO_TBL_NUMBER
4882: , p_from_header_id_tbl IN PO_TBL_NUMBER
4883: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4884: , x_result_type OUT NOCOPY VARCHAR2
4885: ) IS
4886:
4887: d_mod CONSTANT VARCHAR2(100) := D_idv_reference_equal_check;

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

4896: --PO_LOG.proc_begin(d_mod,'p_clm_option_indicator_tbl',p_clm_idc_type_tbl);
4897: END IF;
4898:
4899: IF (x_results IS NULL) THEN
4900: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4901: END IF;
4902:
4903: l_data_key := PO_CORE_S.get_session_gt_nextval();
4904:

Line 4957: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

4953:
4954: PROCEDURE validate_clm_line_type_id(
4955: p_intf_line_id_tbl IN PO_TBL_NUMBER
4956: , p_line_type_id_tbl IN PO_TBL_NUMBER
4957: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4958: , x_result_type OUT NOCOPY VARCHAR2
4959: ) IS
4960:
4961: d_mod CONSTANT VARCHAR2(100) := D_validate_clm_line_type_id;

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

4969: --PO_LOG.proc_begin(d_mod,'p_clm_option_indicator_tbl',p_clm_idc_type_tbl);
4970: END IF;
4971:
4972: IF (x_results IS NULL) THEN
4973: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4974: END IF;
4975:
4976: l_data_key := PO_CORE_S.get_session_gt_nextval();
4977:

Line 5052: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

5048: p_line_id_tbl IN PO_TBL_NUMBER
5049: , p_draft_id_tbl IN PO_TBL_NUMBER
5050: , p_draft_type_tbl IN PO_TBL_VARCHAR30
5051: , p_comments_tbl IN PO_TBL_VARCHAR2000
5052: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
5053: , x_result_type OUT NOCOPY VARCHAR2
5054: )
5055: IS
5056: d_mod CONSTANT VARCHAR2(100) := D_validate_comments_not_null;

Line 5200: x_results IN OUT nocopy PO_VALIDATION_RESULTS_TYPE,

5196: p_draft_id IN PO_TBL_NUMBER,
5197: p_undef_amount IN PO_TBL_NUMBER,
5198: p_po_line_uca_id IN PO_TBL_NUMBER,
5199: p_ucas_po_line_id IN PO_TBL_NUMBER,
5200: x_results IN OUT nocopy PO_VALIDATION_RESULTS_TYPE,
5201: x_result_type OUT nocopy VARCHAR2)
5202:
5203: IS
5204: d_mod CONSTANT VARCHAR2(100) := D_mod_undef_amt_le_line_amt;

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

5213: PO_LOG.proc_begin(d_mod,'p_po_line_uca_id',p_po_line_uca_id);
5214: END IF;
5215:
5216: IF (x_results IS NULL) THEN
5217: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
5218: END IF;
5219:
5220: l_results_count := x_results.result_type.COUNT; -- bug 16759650
5221: