eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VALIDATION_HELPER dependencies on PO_TBL_NUMBER

Line 118: FUNCTION get_item_secondary_uom(p_item_id_tbl IN po_tbl_number,

114:
115: -------------------------------------------------------------------------------
116: -- Private Functions/Procedures
117: -------------------------------------------------------------------------------
118: FUNCTION get_item_secondary_uom(p_item_id_tbl IN po_tbl_number,
119: p_organization_id_tbl IN po_tbl_number)
120: RETURN PO_TBL_VARCHAR30;
121:
122: -------------------------------------------------------------------------------

Line 119: p_organization_id_tbl IN po_tbl_number)

115: -------------------------------------------------------------------------------
116: -- Private Functions/Procedures
117: -------------------------------------------------------------------------------
118: FUNCTION get_item_secondary_uom(p_item_id_tbl IN po_tbl_number,
119: p_organization_id_tbl IN po_tbl_number)
120: RETURN PO_TBL_VARCHAR30;
121:
122: -------------------------------------------------------------------------------
123: --Start of Comments

Line 160: , p_value_tbl IN PO_TBL_NUMBER

156: -------------------------------------------------------------------------------
157: PROCEDURE greater_than_zero(
158: p_calling_module IN VARCHAR2
159: , p_null_allowed_flag IN VARCHAR2 DEFAULT NULL
160: , p_value_tbl IN PO_TBL_NUMBER
161: , p_entity_id_tbl IN PO_TBL_NUMBER
162: , p_entity_type IN VARCHAR2
163: , p_column_name IN VARCHAR2
164: , p_message_name IN VARCHAR2 DEFAULT NULL

Line 161: , p_entity_id_tbl IN PO_TBL_NUMBER

157: PROCEDURE greater_than_zero(
158: p_calling_module IN VARCHAR2
159: , p_null_allowed_flag IN VARCHAR2 DEFAULT NULL
160: , p_value_tbl IN PO_TBL_NUMBER
161: , p_entity_id_tbl IN PO_TBL_NUMBER
162: , p_entity_type IN VARCHAR2
163: , p_column_name IN VARCHAR2
164: , p_message_name IN VARCHAR2 DEFAULT NULL
165: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 279: p_value_tbl IN PO_TBL_NUMBER,

275: -------------------------------------------------------------------------------
276: PROCEDURE greater_or_equal_zero(
277: p_calling_module IN VARCHAR2,
278: p_null_allowed_flag IN VARCHAR2 DEFAULT NULL,
279: p_value_tbl IN PO_TBL_NUMBER,
280: p_entity_id_tbl IN PO_TBL_NUMBER,
281: p_entity_type IN VARCHAR2,
282: p_column_name IN VARCHAR2,
283: p_message_name IN VARCHAR2 DEFAULT NULL,

Line 280: p_entity_id_tbl IN PO_TBL_NUMBER,

276: PROCEDURE greater_or_equal_zero(
277: p_calling_module IN VARCHAR2,
278: p_null_allowed_flag IN VARCHAR2 DEFAULT NULL,
279: p_value_tbl IN PO_TBL_NUMBER,
280: p_entity_id_tbl IN PO_TBL_NUMBER,
281: p_entity_type IN VARCHAR2,
282: p_column_name IN VARCHAR2,
283: p_message_name IN VARCHAR2 DEFAULT NULL,
284: p_token1_name IN VARCHAR2 DEFAULT NULL,

Line 424: , p_value_tbl IN PO_TBL_NUMBER

420: -------------------------------------------------------------------------------
421: PROCEDURE within_percentage_range(
422: p_calling_module IN VARCHAR2
423: , p_null_allowed_flag IN VARCHAR2 DEFAULT NULL
424: , p_value_tbl IN PO_TBL_NUMBER
425: , p_entity_id_tbl IN PO_TBL_NUMBER
426: , p_entity_type IN VARCHAR2
427: , p_column_name IN VARCHAR2
428: , p_message_name IN VARCHAR2 DEFAULT NULL

Line 425: , p_entity_id_tbl IN PO_TBL_NUMBER

421: PROCEDURE within_percentage_range(
422: p_calling_module IN VARCHAR2
423: , p_null_allowed_flag IN VARCHAR2 DEFAULT NULL
424: , p_value_tbl IN PO_TBL_NUMBER
425: , p_entity_id_tbl IN PO_TBL_NUMBER
426: , p_entity_type IN VARCHAR2
427: , p_column_name IN VARCHAR2
428: , p_message_name IN VARCHAR2 DEFAULT NULL
429: , p_token1_name IN VARCHAR2 DEFAULT NULL

Line 561: , p_org_id_tbl IN PO_TBL_NUMBER

557: -------------------------------------------------------------------------------
558: PROCEDURE open_period(
559: p_calling_module IN VARCHAR2
560: , p_date_tbl IN PO_TBL_DATE
561: , p_org_id_tbl IN PO_TBL_NUMBER
562: , p_entity_id_tbl IN PO_TBL_NUMBER
563: , p_entity_type IN VARCHAR2
564: , p_column_name IN VARCHAR2
565: , p_message_name IN VARCHAR2

Line 562: , p_entity_id_tbl IN PO_TBL_NUMBER

558: PROCEDURE open_period(
559: p_calling_module IN VARCHAR2
560: , p_date_tbl IN PO_TBL_DATE
561: , p_org_id_tbl IN PO_TBL_NUMBER
562: , p_entity_id_tbl IN PO_TBL_NUMBER
563: , p_entity_type IN VARCHAR2
564: , p_column_name IN VARCHAR2
565: , p_message_name IN VARCHAR2
566: -- PBWC Message Change Impact: Adding a token

Line 568: , p_token1_value IN PO_TBL_NUMBER DEFAULT NULL

564: , p_column_name IN VARCHAR2
565: , p_message_name IN VARCHAR2
566: -- PBWC Message Change Impact: Adding a token
567: , p_token1_name IN VARCHAR2 DEFAULT NULL
568: , p_token1_value IN PO_TBL_NUMBER DEFAULT NULL
569: , x_result_set_id IN OUT NOCOPY NUMBER
570: , x_result_type OUT NOCOPY VARCHAR2
571: )
572: IS

Line 711: p_entity_id_tbl IN PO_TBL_NUMBER,

707: -------------------------------------------------------------------------------
708: PROCEDURE not_null(
709: p_calling_module IN VARCHAR2,
710: p_value_tbl IN PO_TBL_VARCHAR4000,
711: p_entity_id_tbl IN PO_TBL_NUMBER,
712: p_entity_type IN VARCHAR2,
713: p_column_name IN VARCHAR2,
714: p_message_name IN VARCHAR2,
715: p_token1_name IN VARCHAR2 DEFAULT NULL,

Line 834: p_entity_id_tbl IN PO_TBL_NUMBER,

830: --End of Comments
831: -------------------------------------------------------------------------------
832: PROCEDURE ensure_null(p_calling_module IN VARCHAR2,
833: p_value_tbl IN PO_TBL_VARCHAR4000,
834: p_entity_id_tbl IN PO_TBL_NUMBER,
835: p_entity_type IN VARCHAR2,
836: p_column_name IN VARCHAR2,
837: p_message_name IN VARCHAR2,
838: p_token1_name IN VARCHAR2 DEFAULT NULL,

Line 953: p_entity_id_tbl IN PO_TBL_NUMBER,

949: --End of Comments
950: -------------------------------------------------------------------------------
951: PROCEDURE flag_value_Y_N(p_calling_module IN VARCHAR2,
952: p_flag_value_tbl IN PO_TBL_VARCHAR1,
953: p_entity_id_tbl IN PO_TBL_NUMBER,
954: p_entity_type IN VARCHAR2,
955: p_column_name IN VARCHAR2,
956: p_message_name IN VARCHAR2,
957: p_token1_name IN VARCHAR2 DEFAULT NULL,

Line 1079: , p_value_tbl IN PO_TBL_NUMBER

1075: --End of Comments
1076: -------------------------------------------------------------------------------
1077: PROCEDURE gt_zero_order_type_filter(
1078: p_calling_module IN VARCHAR2
1079: , p_value_tbl IN PO_TBL_NUMBER
1080: , p_entity_id_tbl IN PO_TBL_NUMBER
1081: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1082: , p_check_quantity_types_flag IN VARCHAR2
1083: , p_entity_type IN VARCHAR2

Line 1080: , p_entity_id_tbl IN PO_TBL_NUMBER

1076: -------------------------------------------------------------------------------
1077: PROCEDURE gt_zero_order_type_filter(
1078: p_calling_module IN VARCHAR2
1079: , p_value_tbl IN PO_TBL_NUMBER
1080: , p_entity_id_tbl IN PO_TBL_NUMBER
1081: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1082: , p_check_quantity_types_flag IN VARCHAR2
1083: , p_entity_type IN VARCHAR2
1084: , p_column_name IN VARCHAR2

Line 1096: l_entity_id_tbl PO_TBL_NUMBER;

1092: l_count NUMBER;
1093: l_keep_quantity BOOLEAN;
1094: l_quantity_type BOOLEAN;
1095:
1096: l_entity_id_tbl PO_TBL_NUMBER;
1097: l_value_tbl PO_TBL_NUMBER;
1098:
1099: BEGIN
1100:

Line 1097: l_value_tbl PO_TBL_NUMBER;

1093: l_keep_quantity BOOLEAN;
1094: l_quantity_type BOOLEAN;
1095:
1096: l_entity_id_tbl PO_TBL_NUMBER;
1097: l_value_tbl PO_TBL_NUMBER;
1098:
1099: BEGIN
1100:
1101: IF PO_LOG.d_proc THEN

Line 1120: l_entity_id_tbl := PO_TBL_NUMBER();

1116: END IF;
1117:
1118: l_input_size := p_entity_id_tbl.COUNT;
1119:
1120: l_entity_id_tbl := PO_TBL_NUMBER();
1121: l_entity_id_tbl.extend(l_input_size);
1122: l_value_tbl := PO_TBL_NUMBER();
1123: l_value_tbl.extend(l_input_size);
1124:

Line 1122: l_value_tbl := PO_TBL_NUMBER();

1118: l_input_size := p_entity_id_tbl.COUNT;
1119:
1120: l_entity_id_tbl := PO_TBL_NUMBER();
1121: l_entity_id_tbl.extend(l_input_size);
1122: l_value_tbl := PO_TBL_NUMBER();
1123: l_value_tbl.extend(l_input_size);
1124:
1125: l_count := 0;
1126:

Line 1207: , p_line_id_tbl IN PO_TBL_NUMBER

1203: --End of Comments
1204: -------------------------------------------------------------------------------
1205: PROCEDURE no_timecards_exist(
1206: p_calling_module IN VARCHAR2
1207: , p_line_id_tbl IN PO_TBL_NUMBER
1208: , p_start_date_tbl IN PO_TBL_DATE DEFAULT NULL
1209: , p_expiration_date_tbl IN PO_TBL_DATE DEFAULT NULL
1210: , p_column_name IN VARCHAR2
1211: , p_message_name IN VARCHAR2

Line 1228: l_line_id_tbl PO_TBL_NUMBER;

1224: l_start_date_tbl PO_TBL_DATE;
1225: l_expiration_date_tbl PO_TBL_DATE;
1226:
1227: l_data_key NUMBER;
1228: l_line_id_tbl PO_TBL_NUMBER;
1229: l_end_date_tbl PO_TBL_DATE;
1230:
1231: l_timecard_exists BOOLEAN;
1232: l_return_status VARCHAR2(10);

Line 1406: , p_line_id_tbl IN PO_TBL_NUMBER

1402: --End of Comments
1403: -------------------------------------------------------------------------------
1404: PROCEDURE amount_notif_ctrl_warning(
1405: p_calling_module IN VARCHAR2
1406: , p_line_id_tbl IN PO_TBL_NUMBER
1407: , p_quantity_tbl IN PO_TBL_NUMBER
1408: , p_column_name IN VARCHAR2
1409: , p_message_name IN VARCHAR2
1410: , x_result_set_id IN OUT NOCOPY NUMBER

Line 1407: , p_quantity_tbl IN PO_TBL_NUMBER

1403: -------------------------------------------------------------------------------
1404: PROCEDURE amount_notif_ctrl_warning(
1405: p_calling_module IN VARCHAR2
1406: , p_line_id_tbl IN PO_TBL_NUMBER
1407: , p_quantity_tbl IN PO_TBL_NUMBER
1408: , p_column_name IN VARCHAR2
1409: , p_message_name IN VARCHAR2
1410: , x_result_set_id IN OUT NOCOPY NUMBER
1411: , x_result_type OUT NOCOPY VARCHAR2

Line 1417: l_quantity_tbl PO_TBL_NUMBER;

1413: IS
1414: d_mod CONSTANT VARCHAR2(100) := D_amount_notif_ctrl_warning;
1415:
1416: l_quantity_flag VARCHAR2(1);
1417: l_quantity_tbl PO_TBL_NUMBER;
1418: BEGIN
1419:
1420: IF PO_LOG.d_proc THEN
1421: PO_LOG.proc_begin(p_calling_module);

Line 1435: l_quantity_tbl := PO_TBL_NUMBER();

1431: END IF;
1432:
1433: IF (p_quantity_tbl IS NULL) THEN
1434: l_quantity_flag := 'N';
1435: l_quantity_tbl := PO_TBL_NUMBER();
1436: l_quantity_tbl.extend(p_line_id_tbl.COUNT);
1437: ELSE
1438: l_quantity_flag := 'Y';
1439: l_quantity_tbl := p_quantity_tbl;

Line 1525: , p_entity_id_tbl IN PO_TBL_NUMBER

1521: -----------------------------------------------------------------------------
1522: PROCEDURE child_num_unique(
1523: p_calling_module IN VARCHAR2
1524: , p_entity_type IN VARCHAR2
1525: , p_entity_id_tbl IN PO_TBL_NUMBER
1526: , p_parent_id_tbl IN PO_TBL_NUMBER
1527: , p_entity_num_tbl IN PO_TBL_NUMBER
1528: , x_result_set_id IN OUT NOCOPY NUMBER
1529: , x_result_type OUT NOCOPY VARCHAR2

Line 1526: , p_parent_id_tbl IN PO_TBL_NUMBER

1522: PROCEDURE child_num_unique(
1523: p_calling_module IN VARCHAR2
1524: , p_entity_type IN VARCHAR2
1525: , p_entity_id_tbl IN PO_TBL_NUMBER
1526: , p_parent_id_tbl IN PO_TBL_NUMBER
1527: , p_entity_num_tbl IN PO_TBL_NUMBER
1528: , x_result_set_id IN OUT NOCOPY NUMBER
1529: , x_result_type OUT NOCOPY VARCHAR2
1530: , p_entity_type_tbl IN PO_TBL_VARCHAR30 DEFAULT NULL --

Line 1527: , p_entity_num_tbl IN PO_TBL_NUMBER

1523: p_calling_module IN VARCHAR2
1524: , p_entity_type IN VARCHAR2
1525: , p_entity_id_tbl IN PO_TBL_NUMBER
1526: , p_parent_id_tbl IN PO_TBL_NUMBER
1527: , p_entity_num_tbl IN PO_TBL_NUMBER
1528: , x_result_set_id IN OUT NOCOPY NUMBER
1529: , x_result_type OUT NOCOPY VARCHAR2
1530: , p_entity_type_tbl IN PO_TBL_VARCHAR30 DEFAULT NULL --
1531: )

Line 1536: l_parent_id_tbl PO_TBL_NUMBER;

1532: IS
1533: d_mod CONSTANT VARCHAR2(100) := D_child_num_unique;
1534:
1535: l_data_key NUMBER;
1536: l_parent_id_tbl PO_TBL_NUMBER;
1537:
1538: l_column_name VARCHAR2(30);
1539: l_message_name VARCHAR2(30);
1540:

Line 1589: l_parent_id_tbl := PO_TBL_NUMBER() MULTISET UNION DISTINCT p_parent_id_tbl;

1585: -- 3. Check the temp table for the uniqueness criteria.
1586: ----------------------------------------------------------------------
1587:
1588: -- Get a distinct list of parent ids.
1589: l_parent_id_tbl := PO_TBL_NUMBER() MULTISET UNION DISTINCT p_parent_id_tbl;
1590:
1591: -- Put the stored data for these ids into the temp table.
1592:
1593: l_data_key := PO_CORE_S.get_session_gt_nextval();

Line 1794: , p_price_diff_id_tbl IN PO_TBL_NUMBER

1790: -- to this routine in order to get accurate results.
1791: -----------------------------------------------------------------------------
1792: PROCEDURE price_diff_value_unique(
1793: p_calling_module IN VARCHAR2
1794: , p_price_diff_id_tbl IN PO_TBL_NUMBER
1795: , p_entity_id_tbl IN PO_TBL_NUMBER
1796: , p_entity_type_tbl IN PO_TBL_VARCHAR30
1797: , p_unique_value_tbl IN PO_TBL_VARCHAR4000
1798: , p_column_name IN VARCHAR2

Line 1795: , p_entity_id_tbl IN PO_TBL_NUMBER

1791: -----------------------------------------------------------------------------
1792: PROCEDURE price_diff_value_unique(
1793: p_calling_module IN VARCHAR2
1794: , p_price_diff_id_tbl IN PO_TBL_NUMBER
1795: , p_entity_id_tbl IN PO_TBL_NUMBER
1796: , p_entity_type_tbl IN PO_TBL_VARCHAR30
1797: , p_unique_value_tbl IN PO_TBL_VARCHAR4000
1798: , p_column_name IN VARCHAR2
1799: , p_message_name IN VARCHAR2

Line 1807: l_parent_id_tbl PO_TBL_NUMBER;

1803: IS
1804: d_mod CONSTANT VARCHAR2(100) := D_price_diff_value_unique;
1805:
1806: l_data_key NUMBER;
1807: l_parent_id_tbl PO_TBL_NUMBER;
1808:
1809: BEGIN
1810:
1811: IF PO_LOG.d_proc THEN

Line 1842: l_parent_id_tbl := PO_TBL_NUMBER() MULTISET UNION DISTINCT p_entity_id_tbl;

1838: --
1839: ----------------------------------------------------------------------
1840:
1841: -- Get a distinct list of parent ids.
1842: l_parent_id_tbl := PO_TBL_NUMBER() MULTISET UNION DISTINCT p_entity_id_tbl;
1843:
1844: -- Put the stored data for these ids into the temp table.
1845:
1846: l_data_key := PO_CORE_S.get_session_gt_nextval();

Line 1979: , p_entity_id_tbl IN PO_TBL_NUMBER

1975: PROCEDURE start_date_le_end_date(
1976: p_calling_module IN VARCHAR2
1977: , p_start_date_tbl IN PO_TBL_DATE
1978: , p_end_date_tbl IN PO_TBL_DATE
1979: , p_entity_id_tbl IN PO_TBL_NUMBER
1980: , p_entity_type IN VARCHAR2
1981: , p_column_name IN VARCHAR2
1982: , p_column_val_selector IN VARCHAR2
1983: , p_message_name IN VARCHAR2

Line 2064: , p_num1_tbl IN PO_TBL_NUMBER

2060: -- to num2.
2061: -------------------------------------------------------------------
2062: PROCEDURE num1_less_or_equal_num2(
2063: p_calling_module IN VARCHAR2
2064: , p_num1_tbl IN PO_TBL_NUMBER
2065: , p_num2_tbl IN PO_TBL_NUMBER
2066: , p_entity_id_tbl IN PO_TBL_NUMBER
2067: , p_entity_type IN VARCHAR2
2068: , p_column_name IN VARCHAR2

Line 2065: , p_num2_tbl IN PO_TBL_NUMBER

2061: -------------------------------------------------------------------
2062: PROCEDURE num1_less_or_equal_num2(
2063: p_calling_module IN VARCHAR2
2064: , p_num1_tbl IN PO_TBL_NUMBER
2065: , p_num2_tbl IN PO_TBL_NUMBER
2066: , p_entity_id_tbl IN PO_TBL_NUMBER
2067: , p_entity_type IN VARCHAR2
2068: , p_column_name IN VARCHAR2
2069: , p_message_name IN VARCHAR2

Line 2066: , p_entity_id_tbl IN PO_TBL_NUMBER

2062: PROCEDURE num1_less_or_equal_num2(
2063: p_calling_module IN VARCHAR2
2064: , p_num1_tbl IN PO_TBL_NUMBER
2065: , p_num2_tbl IN PO_TBL_NUMBER
2066: , p_entity_id_tbl IN PO_TBL_NUMBER
2067: , p_entity_type IN VARCHAR2
2068: , p_column_name IN VARCHAR2
2069: , p_message_name IN VARCHAR2
2070: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 2161: p_value_tbl IN PO_TBL_NUMBER,

2157: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
2158: --End of Comments
2159: -------------------------------------------------------------------------------
2160: PROCEDURE zero(p_calling_module IN VARCHAR2,
2161: p_value_tbl IN PO_TBL_NUMBER,
2162: p_entity_id_tbl IN PO_TBL_NUMBER,
2163: p_entity_type IN VARCHAR2,
2164: p_column_name IN VARCHAR2,
2165: p_message_name IN VARCHAR2,

Line 2162: p_entity_id_tbl IN PO_TBL_NUMBER,

2158: --End of Comments
2159: -------------------------------------------------------------------------------
2160: PROCEDURE zero(p_calling_module IN VARCHAR2,
2161: p_value_tbl IN PO_TBL_NUMBER,
2162: p_entity_id_tbl IN PO_TBL_NUMBER,
2163: p_entity_type IN VARCHAR2,
2164: p_column_name IN VARCHAR2,
2165: p_message_name IN VARCHAR2,
2166: p_token1_name IN VARCHAR2 DEFAULT NULL,

Line 2277: p_terms_id_tbl IN PO_TBL_NUMBER,

2273: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
2274: --End of Comments
2275: -------------------------------------------------------------------------------
2276: PROCEDURE terms_id(p_calling_module IN VARCHAR2,
2277: p_terms_id_tbl IN PO_TBL_NUMBER,
2278: p_entity_id_tbl IN PO_TBL_NUMBER,
2279: p_entity_type IN VARCHAR2,
2280: p_validation_id IN NUMBER DEFAULT NULL,
2281: x_result_set_id IN OUT NOCOPY NUMBER,

Line 2278: p_entity_id_tbl IN PO_TBL_NUMBER,

2274: --End of Comments
2275: -------------------------------------------------------------------------------
2276: PROCEDURE terms_id(p_calling_module IN VARCHAR2,
2277: p_terms_id_tbl IN PO_TBL_NUMBER,
2278: p_entity_id_tbl IN PO_TBL_NUMBER,
2279: p_entity_type IN VARCHAR2,
2280: p_validation_id IN NUMBER DEFAULT NULL,
2281: x_result_set_id IN OUT NOCOPY NUMBER,
2282: x_result_type OUT NOCOPY VARCHAR2) IS

Line 2390: , p_value_tbl IN PO_TBL_NUMBER

2386: --End of Comments
2387: -------------------------------------------------------------------------------
2388: PROCEDURE gt_zero_opm_filter(
2389: p_calling_module IN VARCHAR2
2390: , p_value_tbl IN PO_TBL_NUMBER
2391: , p_entity_id_tbl IN PO_TBL_NUMBER
2392: , p_item_id_tbl IN PO_TBL_NUMBER
2393: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2394: , p_entity_type IN VARCHAR2

Line 2391: , p_entity_id_tbl IN PO_TBL_NUMBER

2387: -------------------------------------------------------------------------------
2388: PROCEDURE gt_zero_opm_filter(
2389: p_calling_module IN VARCHAR2
2390: , p_value_tbl IN PO_TBL_NUMBER
2391: , p_entity_id_tbl IN PO_TBL_NUMBER
2392: , p_item_id_tbl IN PO_TBL_NUMBER
2393: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2394: , p_entity_type IN VARCHAR2
2395: , p_column_name IN VARCHAR2

Line 2392: , p_item_id_tbl IN PO_TBL_NUMBER

2388: PROCEDURE gt_zero_opm_filter(
2389: p_calling_module IN VARCHAR2
2390: , p_value_tbl IN PO_TBL_NUMBER
2391: , p_entity_id_tbl IN PO_TBL_NUMBER
2392: , p_item_id_tbl IN PO_TBL_NUMBER
2393: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2394: , p_entity_type IN VARCHAR2
2395: , p_column_name IN VARCHAR2
2396: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 2393: , p_inv_org_id_tbl IN PO_TBL_NUMBER

2389: p_calling_module IN VARCHAR2
2390: , p_value_tbl IN PO_TBL_NUMBER
2391: , p_entity_id_tbl IN PO_TBL_NUMBER
2392: , p_item_id_tbl IN PO_TBL_NUMBER
2393: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2394: , p_entity_type IN VARCHAR2
2395: , p_column_name IN VARCHAR2
2396: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2397: , x_result_type OUT NOCOPY VARCHAR2

Line 2404: l_entity_id_tbl PO_TBL_NUMBER;

2400: d_mod CONSTANT VARCHAR2(100) := D_gt_zero_opm_filter;
2401:
2402: l_input_size NUMBER;
2403: l_count NUMBER;
2404: l_entity_id_tbl PO_TBL_NUMBER;
2405: l_value_tbl PO_TBL_NUMBER;
2406:
2407: l_sec_default_ind VARCHAR2(1);
2408:

Line 2405: l_value_tbl PO_TBL_NUMBER;

2401:
2402: l_input_size NUMBER;
2403: l_count NUMBER;
2404: l_entity_id_tbl PO_TBL_NUMBER;
2405: l_value_tbl PO_TBL_NUMBER;
2406:
2407: l_sec_default_ind VARCHAR2(1);
2408:
2409: BEGIN

Line 2424: l_entity_id_tbl := PO_TBL_NUMBER();

2420: END IF;
2421:
2422: l_input_size := p_entity_id_tbl.COUNT;
2423:
2424: l_entity_id_tbl := PO_TBL_NUMBER();
2425: l_entity_id_tbl.extend(l_input_size);
2426: l_value_tbl := PO_TBL_NUMBER();
2427: l_value_tbl.extend(l_input_size);
2428:

Line 2426: l_value_tbl := PO_TBL_NUMBER();

2422: l_input_size := p_entity_id_tbl.COUNT;
2423:
2424: l_entity_id_tbl := PO_TBL_NUMBER();
2425: l_entity_id_tbl.extend(l_input_size);
2426: l_value_tbl := PO_TBL_NUMBER();
2427: l_value_tbl.extend(l_input_size);
2428:
2429: l_count := 0;
2430:

Line 2533: , p_entity_id_tbl IN PO_TBL_NUMBER

2529: --End of Comments
2530: -------------------------------------------------------------------------------
2531: PROCEDURE qtys_within_deviation(
2532: p_calling_module IN VARCHAR2
2533: , p_entity_id_tbl IN PO_TBL_NUMBER
2534: , p_item_id_tbl IN PO_TBL_NUMBER
2535: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2536: , p_quantity_tbl IN PO_TBL_NUMBER
2537: , p_primary_uom_tbl IN PO_TBL_VARCHAR30

Line 2534: , p_item_id_tbl IN PO_TBL_NUMBER

2530: -------------------------------------------------------------------------------
2531: PROCEDURE qtys_within_deviation(
2532: p_calling_module IN VARCHAR2
2533: , p_entity_id_tbl IN PO_TBL_NUMBER
2534: , p_item_id_tbl IN PO_TBL_NUMBER
2535: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2536: , p_quantity_tbl IN PO_TBL_NUMBER
2537: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
2538: , p_sec_quantity_tbl IN PO_TBL_NUMBER

Line 2535: , p_inv_org_id_tbl IN PO_TBL_NUMBER

2531: PROCEDURE qtys_within_deviation(
2532: p_calling_module IN VARCHAR2
2533: , p_entity_id_tbl IN PO_TBL_NUMBER
2534: , p_item_id_tbl IN PO_TBL_NUMBER
2535: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2536: , p_quantity_tbl IN PO_TBL_NUMBER
2537: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
2538: , p_sec_quantity_tbl IN PO_TBL_NUMBER
2539: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30

Line 2536: , p_quantity_tbl IN PO_TBL_NUMBER

2532: p_calling_module IN VARCHAR2
2533: , p_entity_id_tbl IN PO_TBL_NUMBER
2534: , p_item_id_tbl IN PO_TBL_NUMBER
2535: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2536: , p_quantity_tbl IN PO_TBL_NUMBER
2537: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
2538: , p_sec_quantity_tbl IN PO_TBL_NUMBER
2539: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
2540: , p_column_name IN VARCHAR2

Line 2538: , p_sec_quantity_tbl IN PO_TBL_NUMBER

2534: , p_item_id_tbl IN PO_TBL_NUMBER
2535: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2536: , p_quantity_tbl IN PO_TBL_NUMBER
2537: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
2538: , p_sec_quantity_tbl IN PO_TBL_NUMBER
2539: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
2540: , p_column_name IN VARCHAR2
2541: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2542: , x_result_type OUT NOCOPY VARCHAR2

Line 2656: p_id_tbl IN po_tbl_number,

2652: -- Validate secondary_unit_of_measure.
2653: -- To be called only for BLANKET AND STANDARD.
2654: --------------------------------------------------------------------------------------------
2655: PROCEDURE secondary_unit_of_measure(
2656: p_id_tbl IN po_tbl_number,
2657: p_entity_type IN VARCHAR2,
2658: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
2659: p_item_id_tbl IN po_tbl_number,
2660: p_item_tbl IN po_tbl_varchar2000,

Line 2659: p_item_id_tbl IN po_tbl_number,

2655: PROCEDURE secondary_unit_of_measure(
2656: p_id_tbl IN po_tbl_number,
2657: p_entity_type IN VARCHAR2,
2658: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
2659: p_item_id_tbl IN po_tbl_number,
2660: p_item_tbl IN po_tbl_varchar2000,
2661: p_organization_id_tbl IN po_tbl_number,
2662: p_doc_type IN VARCHAR2,
2663: p_create_or_update_item_flag IN VARCHAR2,

Line 2661: p_organization_id_tbl IN po_tbl_number,

2657: p_entity_type IN VARCHAR2,
2658: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
2659: p_item_id_tbl IN po_tbl_number,
2660: p_item_tbl IN po_tbl_varchar2000,
2661: p_organization_id_tbl IN po_tbl_number,
2662: p_doc_type IN VARCHAR2,
2663: p_create_or_update_item_flag IN VARCHAR2,
2664: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2665: x_result_type OUT NOCOPY VARCHAR2)

Line 2791: p_id_tbl IN po_tbl_number,

2787: -- Validate secondary_quantity.
2788: -- To be called for all doc types, but we need to pass it doc type for certain validations.
2789: --------------------------------------------------------------------------------------------
2790: PROCEDURE secondary_quantity(
2791: p_id_tbl IN po_tbl_number,
2792: p_entity_type IN VARCHAR2,
2793: p_secondary_quantity_tbl IN po_tbl_number,
2794: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2795: p_item_id_tbl IN po_tbl_number,

Line 2793: p_secondary_quantity_tbl IN po_tbl_number,

2789: --------------------------------------------------------------------------------------------
2790: PROCEDURE secondary_quantity(
2791: p_id_tbl IN po_tbl_number,
2792: p_entity_type IN VARCHAR2,
2793: p_secondary_quantity_tbl IN po_tbl_number,
2794: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2795: p_item_id_tbl IN po_tbl_number,
2796: p_item_tbl IN po_tbl_varchar2000,
2797: p_organization_id_tbl IN po_tbl_number,

Line 2795: p_item_id_tbl IN po_tbl_number,

2791: p_id_tbl IN po_tbl_number,
2792: p_entity_type IN VARCHAR2,
2793: p_secondary_quantity_tbl IN po_tbl_number,
2794: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2795: p_item_id_tbl IN po_tbl_number,
2796: p_item_tbl IN po_tbl_varchar2000,
2797: p_organization_id_tbl IN po_tbl_number,
2798: p_doc_type IN VARCHAR2,
2799: p_create_or_update_item_flag IN VARCHAR2,

Line 2797: p_organization_id_tbl IN po_tbl_number,

2793: p_secondary_quantity_tbl IN po_tbl_number,
2794: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2795: p_item_id_tbl IN po_tbl_number,
2796: p_item_tbl IN po_tbl_varchar2000,
2797: p_organization_id_tbl IN po_tbl_number,
2798: p_doc_type IN VARCHAR2,
2799: p_create_or_update_item_flag IN VARCHAR2,
2800: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2801: x_result_type OUT NOCOPY VARCHAR2)

Line 2983: p_id_tbl IN po_tbl_number,

2979: -- Validate secondary_unit_of_measure for the update case.
2980: -- To be called only for BLANKET AND STANDARD.
2981: --------------------------------------------------------------------------------------------
2982: PROCEDURE secondary_uom_update(
2983: p_id_tbl IN po_tbl_number,
2984: p_entity_type IN VARCHAR2,
2985: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
2986: p_item_id_tbl IN po_tbl_number,
2987: p_organization_id_tbl IN po_tbl_number,

Line 2986: p_item_id_tbl IN po_tbl_number,

2982: PROCEDURE secondary_uom_update(
2983: p_id_tbl IN po_tbl_number,
2984: p_entity_type IN VARCHAR2,
2985: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
2986: p_item_id_tbl IN po_tbl_number,
2987: p_organization_id_tbl IN po_tbl_number,
2988: p_create_or_update_item_flag IN VARCHAR2,
2989: x_result_set_id IN OUT NOCOPY NUMBER,
2990: x_result_type OUT NOCOPY VARCHAR2)

Line 2987: p_organization_id_tbl IN po_tbl_number,

2983: p_id_tbl IN po_tbl_number,
2984: p_entity_type IN VARCHAR2,
2985: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
2986: p_item_id_tbl IN po_tbl_number,
2987: p_organization_id_tbl IN po_tbl_number,
2988: p_create_or_update_item_flag IN VARCHAR2,
2989: x_result_set_id IN OUT NOCOPY NUMBER,
2990: x_result_type OUT NOCOPY VARCHAR2)
2991: IS

Line 3075: p_id_tbl IN po_tbl_number,

3071: -- If grade doesn't exist in the grade master table then log an exception error out.
3072: -- To be called only for BLANKET and STANDARD.
3073: --------------------------------------------------------------------------------------------
3074: PROCEDURE preferred_grade(
3075: p_id_tbl IN po_tbl_number,
3076: p_entity_type IN VARCHAR2,
3077: p_preferred_grade_tbl IN po_tbl_varchar2000,
3078: p_item_id_tbl IN po_tbl_number,
3079: p_item_tbl IN po_tbl_varchar2000,

Line 3078: p_item_id_tbl IN po_tbl_number,

3074: PROCEDURE preferred_grade(
3075: p_id_tbl IN po_tbl_number,
3076: p_entity_type IN VARCHAR2,
3077: p_preferred_grade_tbl IN po_tbl_varchar2000,
3078: p_item_id_tbl IN po_tbl_number,
3079: p_item_tbl IN po_tbl_varchar2000,
3080: p_organization_id_tbl IN po_tbl_number,
3081: p_create_or_update_item_flag IN VARCHAR2,
3082: p_validation_id IN NUMBER DEFAULT NULL,

Line 3080: p_organization_id_tbl IN po_tbl_number,

3076: p_entity_type IN VARCHAR2,
3077: p_preferred_grade_tbl IN po_tbl_varchar2000,
3078: p_item_id_tbl IN po_tbl_number,
3079: p_item_tbl IN po_tbl_varchar2000,
3080: p_organization_id_tbl IN po_tbl_number,
3081: p_create_or_update_item_flag IN VARCHAR2,
3082: p_validation_id IN NUMBER DEFAULT NULL,
3083: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3084: x_result_set_id IN OUT NOCOPY NUMBER,

Line 3216: p_id_tbl IN po_tbl_number,

3212: END preferred_grade;
3213:
3214:
3215: PROCEDURE process_enabled(
3216: p_id_tbl IN po_tbl_number,
3217: p_entity_type IN VARCHAR2,
3218: p_ship_to_organization_id_tbl IN po_tbl_number,
3219: p_item_id_tbl IN po_tbl_number,
3220: x_result_set_id IN OUT NOCOPY NUMBER,

Line 3218: p_ship_to_organization_id_tbl IN po_tbl_number,

3214:
3215: PROCEDURE process_enabled(
3216: p_id_tbl IN po_tbl_number,
3217: p_entity_type IN VARCHAR2,
3218: p_ship_to_organization_id_tbl IN po_tbl_number,
3219: p_item_id_tbl IN po_tbl_number,
3220: x_result_set_id IN OUT NOCOPY NUMBER,
3221: x_result_type OUT NOCOPY VARCHAR2)
3222: IS

Line 3219: p_item_id_tbl IN po_tbl_number,

3215: PROCEDURE process_enabled(
3216: p_id_tbl IN po_tbl_number,
3217: p_entity_type IN VARCHAR2,
3218: p_ship_to_organization_id_tbl IN po_tbl_number,
3219: p_item_id_tbl IN po_tbl_number,
3220: x_result_set_id IN OUT NOCOPY NUMBER,
3221: x_result_type OUT NOCOPY VARCHAR2)
3222: IS
3223: d_mod CONSTANT VARCHAR2(100) := d_secondary_unit_of_measure;

Line 3293: p_item_id_tbl IN po_tbl_number,

3289: --------------------------------------------------------------------------------------------
3290: -- Private function to get the converted unit of measure from mtl_system_items.
3291: --------------------------------------------------------------------------------------------
3292: FUNCTION get_item_secondary_uom(
3293: p_item_id_tbl IN po_tbl_number,
3294: p_organization_id_tbl IN po_tbl_number)
3295: RETURN PO_TBL_VARCHAR30
3296: IS
3297:

Line 3294: p_organization_id_tbl IN po_tbl_number)

3290: -- Private function to get the converted unit of measure from mtl_system_items.
3291: --------------------------------------------------------------------------------------------
3292: FUNCTION get_item_secondary_uom(
3293: p_item_id_tbl IN po_tbl_number,
3294: p_organization_id_tbl IN po_tbl_number)
3295: RETURN PO_TBL_VARCHAR30
3296: IS
3297:
3298: d_mod CONSTANT VARCHAR2(100) := d_get_item_secondary_uom;

Line 3304: l_index1_tbl PO_TBL_NUMBER;

3300:
3301: -- key value used to identify rows in po_session_gt table
3302: l_key po_session_gt.key%TYPE;
3303: l_index_tbl DBMS_SQL.NUMBER_TABLE;
3304: l_index1_tbl PO_TBL_NUMBER;
3305: l_result1_tbl PO_TBL_VARCHAR30;
3306:
3307: BEGIN
3308:

Line 3391: p_id_tbl IN po_tbl_number,

3387: --End of Comments
3388: -------------------------------------------------------------------------------
3389: PROCEDURE validate_desc_flex (
3390: p_calling_module IN VARCHAR2,
3391: p_id_tbl IN po_tbl_number,
3392: p_desc_flex_name IN fnd_descr_flex_column_usages.descriptive_flexfield_name%TYPE,
3393: p_attribute_category_tbl IN PO_TBL_VARCHAR30,
3394: p_attribute1_tbl IN PO_TBL_VARCHAR2000,
3395: p_attribute2_tbl IN PO_TBL_VARCHAR2000,