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 128: FUNCTION get_item_secondary_uom(p_item_id_tbl IN po_tbl_number,

124:
125: -------------------------------------------------------------------------------
126: -- Private Functions/Procedures
127: -------------------------------------------------------------------------------
128: FUNCTION get_item_secondary_uom(p_item_id_tbl IN po_tbl_number,
129: p_organization_id_tbl IN po_tbl_number)
130: RETURN PO_TBL_VARCHAR30;
131:
132: -------------------------------------------------------------------------------

Line 129: p_organization_id_tbl IN po_tbl_number)

125: -------------------------------------------------------------------------------
126: -- Private Functions/Procedures
127: -------------------------------------------------------------------------------
128: FUNCTION get_item_secondary_uom(p_item_id_tbl IN po_tbl_number,
129: p_organization_id_tbl IN po_tbl_number)
130: RETURN PO_TBL_VARCHAR30;
131:
132: -------------------------------------------------------------------------------
133: --Start of Comments

Line 170: , p_value_tbl IN PO_TBL_NUMBER

166: -------------------------------------------------------------------------------
167: PROCEDURE greater_than_zero(
168: p_calling_module IN VARCHAR2
169: , p_null_allowed_flag IN VARCHAR2 DEFAULT NULL
170: , p_value_tbl IN PO_TBL_NUMBER
171: , p_entity_id_tbl IN PO_TBL_NUMBER
172: , p_entity_type IN VARCHAR2
173: , p_column_name IN VARCHAR2
174: , p_message_name IN VARCHAR2 DEFAULT NULL

Line 171: , p_entity_id_tbl IN PO_TBL_NUMBER

167: PROCEDURE greater_than_zero(
168: p_calling_module IN VARCHAR2
169: , p_null_allowed_flag IN VARCHAR2 DEFAULT NULL
170: , p_value_tbl IN PO_TBL_NUMBER
171: , p_entity_id_tbl IN PO_TBL_NUMBER
172: , p_entity_type IN VARCHAR2
173: , p_column_name IN VARCHAR2
174: , p_message_name IN VARCHAR2 DEFAULT NULL
175: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 289: p_value_tbl IN PO_TBL_NUMBER,

285: -------------------------------------------------------------------------------
286: PROCEDURE greater_or_equal_zero(
287: p_calling_module IN VARCHAR2,
288: p_null_allowed_flag IN VARCHAR2 DEFAULT NULL,
289: p_value_tbl IN PO_TBL_NUMBER,
290: p_entity_id_tbl IN PO_TBL_NUMBER,
291: p_entity_type IN VARCHAR2,
292: p_column_name IN VARCHAR2,
293: p_message_name IN VARCHAR2 DEFAULT NULL,

Line 290: p_entity_id_tbl IN PO_TBL_NUMBER,

286: PROCEDURE greater_or_equal_zero(
287: p_calling_module IN VARCHAR2,
288: p_null_allowed_flag IN VARCHAR2 DEFAULT NULL,
289: p_value_tbl IN PO_TBL_NUMBER,
290: p_entity_id_tbl IN PO_TBL_NUMBER,
291: p_entity_type IN VARCHAR2,
292: p_column_name IN VARCHAR2,
293: p_message_name IN VARCHAR2 DEFAULT NULL,
294: p_token1_name IN VARCHAR2 DEFAULT NULL,

Line 434: , p_value_tbl IN PO_TBL_NUMBER

430: -------------------------------------------------------------------------------
431: PROCEDURE within_percentage_range(
432: p_calling_module IN VARCHAR2
433: , p_null_allowed_flag IN VARCHAR2 DEFAULT NULL
434: , p_value_tbl IN PO_TBL_NUMBER
435: , p_entity_id_tbl IN PO_TBL_NUMBER
436: , p_entity_type IN VARCHAR2
437: , p_column_name IN VARCHAR2
438: , p_message_name IN VARCHAR2 DEFAULT NULL

Line 435: , p_entity_id_tbl IN PO_TBL_NUMBER

431: PROCEDURE within_percentage_range(
432: p_calling_module IN VARCHAR2
433: , p_null_allowed_flag IN VARCHAR2 DEFAULT NULL
434: , p_value_tbl IN PO_TBL_NUMBER
435: , p_entity_id_tbl IN PO_TBL_NUMBER
436: , p_entity_type IN VARCHAR2
437: , p_column_name IN VARCHAR2
438: , p_message_name IN VARCHAR2 DEFAULT NULL
439: , p_token1_name IN VARCHAR2 DEFAULT NULL

Line 571: , p_org_id_tbl IN PO_TBL_NUMBER

567: -------------------------------------------------------------------------------
568: PROCEDURE open_period(
569: p_calling_module IN VARCHAR2
570: , p_date_tbl IN PO_TBL_DATE
571: , p_org_id_tbl IN PO_TBL_NUMBER
572: , p_entity_id_tbl IN PO_TBL_NUMBER
573: , p_entity_type IN VARCHAR2
574: , p_column_name IN VARCHAR2
575: , p_message_name IN VARCHAR2

Line 572: , p_entity_id_tbl IN PO_TBL_NUMBER

568: PROCEDURE open_period(
569: p_calling_module IN VARCHAR2
570: , p_date_tbl IN PO_TBL_DATE
571: , p_org_id_tbl IN PO_TBL_NUMBER
572: , p_entity_id_tbl IN PO_TBL_NUMBER
573: , p_entity_type IN VARCHAR2
574: , p_column_name IN VARCHAR2
575: , p_message_name IN VARCHAR2
576: -- PBWC Message Change Impact: Adding a token

Line 578: , p_token1_value IN PO_TBL_NUMBER DEFAULT NULL

574: , p_column_name IN VARCHAR2
575: , p_message_name IN VARCHAR2
576: -- PBWC Message Change Impact: Adding a token
577: , p_token1_name IN VARCHAR2 DEFAULT NULL
578: , p_token1_value IN PO_TBL_NUMBER DEFAULT NULL
579: , x_result_set_id IN OUT NOCOPY NUMBER
580: , x_result_type OUT NOCOPY VARCHAR2
581: )
582: IS

Line 721: p_entity_id_tbl IN PO_TBL_NUMBER,

717: -------------------------------------------------------------------------------
718: PROCEDURE not_null(
719: p_calling_module IN VARCHAR2,
720: p_value_tbl IN PO_TBL_VARCHAR4000,
721: p_entity_id_tbl IN PO_TBL_NUMBER,
722: p_entity_type IN VARCHAR2,
723: p_column_name IN VARCHAR2,
724: p_message_name IN VARCHAR2,
725: p_token1_name IN VARCHAR2 DEFAULT NULL,

Line 844: p_entity_id_tbl IN PO_TBL_NUMBER,

840: --End of Comments
841: -------------------------------------------------------------------------------
842: PROCEDURE ensure_null(p_calling_module IN VARCHAR2,
843: p_value_tbl IN PO_TBL_VARCHAR4000,
844: p_entity_id_tbl IN PO_TBL_NUMBER,
845: p_entity_type IN VARCHAR2,
846: p_column_name IN VARCHAR2,
847: p_message_name IN VARCHAR2,
848: p_token1_name IN VARCHAR2 DEFAULT NULL,

Line 963: p_entity_id_tbl IN PO_TBL_NUMBER,

959: --End of Comments
960: -------------------------------------------------------------------------------
961: PROCEDURE flag_value_Y_N(p_calling_module IN VARCHAR2,
962: p_flag_value_tbl IN PO_TBL_VARCHAR1,
963: p_entity_id_tbl IN PO_TBL_NUMBER,
964: p_entity_type IN VARCHAR2,
965: p_column_name IN VARCHAR2,
966: p_message_name IN VARCHAR2,
967: p_token1_name IN VARCHAR2 DEFAULT NULL,

Line 1089: , p_value_tbl IN PO_TBL_NUMBER

1085: --End of Comments
1086: -------------------------------------------------------------------------------
1087: PROCEDURE gt_zero_order_type_filter(
1088: p_calling_module IN VARCHAR2
1089: , p_value_tbl IN PO_TBL_NUMBER
1090: , p_entity_id_tbl IN PO_TBL_NUMBER
1091: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1092: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1
1093: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30

Line 1090: , p_entity_id_tbl IN PO_TBL_NUMBER

1086: -------------------------------------------------------------------------------
1087: PROCEDURE gt_zero_order_type_filter(
1088: p_calling_module IN VARCHAR2
1089: , p_value_tbl IN PO_TBL_NUMBER
1090: , p_entity_id_tbl IN PO_TBL_NUMBER
1091: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1092: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1
1093: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
1094: , p_check_quantity_types_flag IN VARCHAR2

Line 1099: , p_header_id_tbl IN PO_TBL_NUMBER --

1095: , p_entity_type IN VARCHAR2
1096: , p_column_name IN VARCHAR2
1097: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1098: , x_result_type OUT NOCOPY VARCHAR2
1099: , p_header_id_tbl IN PO_TBL_NUMBER --
1100: )
1101: IS
1102: d_mod CONSTANT VARCHAR2(100) := D_gt_zero_order_type_filter;
1103:

Line 1109: l_entity_id_tbl PO_TBL_NUMBER;

1105: l_count NUMBER;
1106: l_keep_quantity BOOLEAN;
1107: l_quantity_type BOOLEAN;
1108:
1109: l_entity_id_tbl PO_TBL_NUMBER;
1110: l_value_tbl PO_TBL_NUMBER;
1111:
1112: --
1113: l_is_clm_po VARCHAR2(1) := 'N';

Line 1110: l_value_tbl PO_TBL_NUMBER;

1106: l_keep_quantity BOOLEAN;
1107: l_quantity_type BOOLEAN;
1108:
1109: l_entity_id_tbl PO_TBL_NUMBER;
1110: l_value_tbl PO_TBL_NUMBER;
1111:
1112: --
1113: l_is_clm_po VARCHAR2(1) := 'N';
1114: l_entity_id NUMBER;

Line 1137: l_entity_id_tbl := PO_TBL_NUMBER();

1133: END IF;
1134:
1135: l_input_size := p_entity_id_tbl.COUNT;
1136:
1137: l_entity_id_tbl := PO_TBL_NUMBER();
1138: l_entity_id_tbl.extend(l_input_size);
1139: l_value_tbl := PO_TBL_NUMBER();
1140: l_value_tbl.extend(l_input_size);
1141:

Line 1139: l_value_tbl := PO_TBL_NUMBER();

1135: l_input_size := p_entity_id_tbl.COUNT;
1136:
1137: l_entity_id_tbl := PO_TBL_NUMBER();
1138: l_entity_id_tbl.extend(l_input_size);
1139: l_value_tbl := PO_TBL_NUMBER();
1140: l_value_tbl.extend(l_input_size);
1141:
1142: l_count := 0;
1143:

Line 1233: , p_value_tbl IN PO_TBL_NUMBER

1229: END gt_zero_order_type_filter;
1230:
1231: PROCEDURE gt_zero_order_type_filter(
1232: p_calling_module IN VARCHAR2
1233: , p_value_tbl IN PO_TBL_NUMBER
1234: , p_entity_id_tbl IN PO_TBL_NUMBER
1235: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1236: , p_check_quantity_types_flag IN VARCHAR2
1237: , p_entity_type IN VARCHAR2

Line 1234: , p_entity_id_tbl IN PO_TBL_NUMBER

1230:
1231: PROCEDURE gt_zero_order_type_filter(
1232: p_calling_module IN VARCHAR2
1233: , p_value_tbl IN PO_TBL_NUMBER
1234: , p_entity_id_tbl IN PO_TBL_NUMBER
1235: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1236: , p_check_quantity_types_flag IN VARCHAR2
1237: , p_entity_type IN VARCHAR2
1238: , p_column_name IN VARCHAR2

Line 1250: l_entity_id_tbl PO_TBL_NUMBER;

1246: l_count NUMBER;
1247: l_keep_quantity BOOLEAN;
1248: l_quantity_type BOOLEAN;
1249:
1250: l_entity_id_tbl PO_TBL_NUMBER;
1251: l_value_tbl PO_TBL_NUMBER;
1252:
1253: BEGIN
1254:

Line 1251: l_value_tbl PO_TBL_NUMBER;

1247: l_keep_quantity BOOLEAN;
1248: l_quantity_type BOOLEAN;
1249:
1250: l_entity_id_tbl PO_TBL_NUMBER;
1251: l_value_tbl PO_TBL_NUMBER;
1252:
1253: BEGIN
1254:
1255: IF PO_LOG.d_proc THEN

Line 1274: l_entity_id_tbl := PO_TBL_NUMBER();

1270: END IF;
1271:
1272: l_input_size := p_entity_id_tbl.COUNT;
1273:
1274: l_entity_id_tbl := PO_TBL_NUMBER();
1275: l_entity_id_tbl.extend(l_input_size);
1276: l_value_tbl := PO_TBL_NUMBER();
1277: l_value_tbl.extend(l_input_size);
1278:

Line 1276: l_value_tbl := PO_TBL_NUMBER();

1272: l_input_size := p_entity_id_tbl.COUNT;
1273:
1274: l_entity_id_tbl := PO_TBL_NUMBER();
1275: l_entity_id_tbl.extend(l_input_size);
1276: l_value_tbl := PO_TBL_NUMBER();
1277: l_value_tbl.extend(l_input_size);
1278:
1279: l_count := 0;
1280:

Line 1361: , p_line_id_tbl IN PO_TBL_NUMBER

1357: --End of Comments
1358: -------------------------------------------------------------------------------
1359: PROCEDURE no_timecards_exist(
1360: p_calling_module IN VARCHAR2
1361: , p_line_id_tbl IN PO_TBL_NUMBER
1362: , p_start_date_tbl IN PO_TBL_DATE DEFAULT NULL
1363: , p_expiration_date_tbl IN PO_TBL_DATE DEFAULT NULL
1364: , p_column_name IN VARCHAR2
1365: , p_message_name IN VARCHAR2

Line 1382: l_line_id_tbl PO_TBL_NUMBER;

1378: l_start_date_tbl PO_TBL_DATE;
1379: l_expiration_date_tbl PO_TBL_DATE;
1380:
1381: l_data_key NUMBER;
1382: l_line_id_tbl PO_TBL_NUMBER;
1383: l_end_date_tbl PO_TBL_DATE;
1384:
1385: l_timecard_exists BOOLEAN;
1386: l_return_status VARCHAR2(10);

Line 1560: , p_line_id_tbl IN PO_TBL_NUMBER

1556: --End of Comments
1557: -------------------------------------------------------------------------------
1558: PROCEDURE amount_notif_ctrl_warning(
1559: p_calling_module IN VARCHAR2
1560: , p_line_id_tbl IN PO_TBL_NUMBER
1561: , p_quantity_tbl IN PO_TBL_NUMBER
1562: , p_column_name IN VARCHAR2
1563: , p_message_name IN VARCHAR2
1564: , x_result_set_id IN OUT NOCOPY NUMBER

Line 1561: , p_quantity_tbl IN PO_TBL_NUMBER

1557: -------------------------------------------------------------------------------
1558: PROCEDURE amount_notif_ctrl_warning(
1559: p_calling_module IN VARCHAR2
1560: , p_line_id_tbl IN PO_TBL_NUMBER
1561: , p_quantity_tbl IN PO_TBL_NUMBER
1562: , p_column_name IN VARCHAR2
1563: , p_message_name IN VARCHAR2
1564: , x_result_set_id IN OUT NOCOPY NUMBER
1565: , x_result_type OUT NOCOPY VARCHAR2

Line 1571: l_quantity_tbl PO_TBL_NUMBER;

1567: IS
1568: d_mod CONSTANT VARCHAR2(100) := D_amount_notif_ctrl_warning;
1569:
1570: l_quantity_flag VARCHAR2(1);
1571: l_quantity_tbl PO_TBL_NUMBER;
1572: BEGIN
1573:
1574: IF PO_LOG.d_proc THEN
1575: PO_LOG.proc_begin(p_calling_module);

Line 1589: l_quantity_tbl := PO_TBL_NUMBER();

1585: END IF;
1586:
1587: IF (p_quantity_tbl IS NULL) THEN
1588: l_quantity_flag := 'N';
1589: l_quantity_tbl := PO_TBL_NUMBER();
1590: l_quantity_tbl.extend(p_line_id_tbl.COUNT);
1591: ELSE
1592: l_quantity_flag := 'Y';
1593: l_quantity_tbl := p_quantity_tbl;

Line 1679: , p_entity_id_tbl IN PO_TBL_NUMBER

1675: -----------------------------------------------------------------------------
1676: PROCEDURE child_num_unique(
1677: p_calling_module IN VARCHAR2
1678: , p_entity_type IN VARCHAR2
1679: , p_entity_id_tbl IN PO_TBL_NUMBER
1680: , p_parent_id_tbl IN PO_TBL_NUMBER
1681: , p_entity_num_tbl IN PO_TBL_NUMBER
1682: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
1683: , p_draft_id_tbl IN PO_TBL_NUMBER

Line 1680: , p_parent_id_tbl IN PO_TBL_NUMBER

1676: PROCEDURE child_num_unique(
1677: p_calling_module IN VARCHAR2
1678: , p_entity_type IN VARCHAR2
1679: , p_entity_id_tbl IN PO_TBL_NUMBER
1680: , p_parent_id_tbl IN PO_TBL_NUMBER
1681: , p_entity_num_tbl IN PO_TBL_NUMBER
1682: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
1683: , p_draft_id_tbl IN PO_TBL_NUMBER
1684: , x_result_set_id IN OUT NOCOPY NUMBER

Line 1681: , p_entity_num_tbl IN PO_TBL_NUMBER

1677: p_calling_module IN VARCHAR2
1678: , p_entity_type IN VARCHAR2
1679: , p_entity_id_tbl IN PO_TBL_NUMBER
1680: , p_parent_id_tbl IN PO_TBL_NUMBER
1681: , p_entity_num_tbl IN PO_TBL_NUMBER
1682: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
1683: , p_draft_id_tbl IN PO_TBL_NUMBER
1684: , x_result_set_id IN OUT NOCOPY NUMBER
1685: , x_result_type OUT NOCOPY VARCHAR2

Line 1683: , p_draft_id_tbl IN PO_TBL_NUMBER

1679: , p_entity_id_tbl IN PO_TBL_NUMBER
1680: , p_parent_id_tbl IN PO_TBL_NUMBER
1681: , p_entity_num_tbl IN PO_TBL_NUMBER
1682: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
1683: , p_draft_id_tbl IN PO_TBL_NUMBER
1684: , x_result_set_id IN OUT NOCOPY NUMBER
1685: , x_result_type OUT NOCOPY VARCHAR2
1686: , p_entity_type_tbl IN PO_TBL_VARCHAR30 DEFAULT NULL --
1687: )

Line 1692: l_parent_id_tbl PO_TBL_NUMBER;

1688: IS
1689: d_mod CONSTANT VARCHAR2(100) := D_child_num_unique;
1690:
1691: l_data_key NUMBER;
1692: l_parent_id_tbl PO_TBL_NUMBER;
1693: l_par_draft_id_tbl PO_TBL_NUMBER;
1694:
1695: l_column_name VARCHAR2(30);
1696: l_message_name VARCHAR2(30);

Line 1693: l_par_draft_id_tbl PO_TBL_NUMBER;

1689: d_mod CONSTANT VARCHAR2(100) := D_child_num_unique;
1690:
1691: l_data_key NUMBER;
1692: l_parent_id_tbl PO_TBL_NUMBER;
1693: l_par_draft_id_tbl PO_TBL_NUMBER;
1694:
1695: l_column_name VARCHAR2(30);
1696: l_message_name VARCHAR2(30);
1697:

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

1742: -- 3. Check the temp table for the uniqueness criteria.
1743: ----------------------------------------------------------------------
1744:
1745: -- Get a distinct list of parent ids.
1746: l_parent_id_tbl := PO_TBL_NUMBER() MULTISET UNION DISTINCT p_parent_id_tbl;
1747:
1748: -- Put the stored data for these ids into the temp table.
1749:
1750: l_data_key := PO_CORE_S.get_session_gt_nextval();

Line 1979: , p_price_diff_id_tbl IN PO_TBL_NUMBER

1975: -- to this routine in order to get accurate results.
1976: -----------------------------------------------------------------------------
1977: PROCEDURE price_diff_value_unique(
1978: p_calling_module IN VARCHAR2
1979: , p_price_diff_id_tbl IN PO_TBL_NUMBER
1980: , p_entity_id_tbl IN PO_TBL_NUMBER
1981: , p_entity_type_tbl IN PO_TBL_VARCHAR30
1982: , p_unique_value_tbl IN PO_TBL_VARCHAR4000
1983: , p_column_name IN VARCHAR2

Line 1980: , p_entity_id_tbl IN PO_TBL_NUMBER

1976: -----------------------------------------------------------------------------
1977: PROCEDURE price_diff_value_unique(
1978: p_calling_module IN VARCHAR2
1979: , p_price_diff_id_tbl IN PO_TBL_NUMBER
1980: , p_entity_id_tbl IN PO_TBL_NUMBER
1981: , p_entity_type_tbl IN PO_TBL_VARCHAR30
1982: , p_unique_value_tbl IN PO_TBL_VARCHAR4000
1983: , p_column_name IN VARCHAR2
1984: , p_message_name IN VARCHAR2

Line 1992: l_parent_id_tbl PO_TBL_NUMBER;

1988: IS
1989: d_mod CONSTANT VARCHAR2(100) := D_price_diff_value_unique;
1990:
1991: l_data_key NUMBER;
1992: l_parent_id_tbl PO_TBL_NUMBER;
1993:
1994: BEGIN
1995:
1996: IF PO_LOG.d_proc THEN

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

2023: --
2024: ----------------------------------------------------------------------
2025:
2026: -- Get a distinct list of parent ids.
2027: l_parent_id_tbl := PO_TBL_NUMBER() MULTISET UNION DISTINCT p_entity_id_tbl;
2028:
2029: -- Put the stored data for these ids into the temp table.
2030:
2031: l_data_key := PO_CORE_S.get_session_gt_nextval();

Line 2164: , p_entity_id_tbl IN PO_TBL_NUMBER

2160: PROCEDURE start_date_le_end_date(
2161: p_calling_module IN VARCHAR2
2162: , p_start_date_tbl IN PO_TBL_DATE
2163: , p_end_date_tbl IN PO_TBL_DATE
2164: , p_entity_id_tbl IN PO_TBL_NUMBER
2165: , p_entity_type IN VARCHAR2
2166: , p_column_name IN VARCHAR2
2167: , p_column_val_selector IN VARCHAR2
2168: , p_message_name IN VARCHAR2

Line 2249: , p_num1_tbl IN PO_TBL_NUMBER

2245: -- to num2.
2246: -------------------------------------------------------------------
2247: PROCEDURE num1_less_or_equal_num2(
2248: p_calling_module IN VARCHAR2
2249: , p_num1_tbl IN PO_TBL_NUMBER
2250: , p_num2_tbl IN PO_TBL_NUMBER
2251: , p_entity_id_tbl IN PO_TBL_NUMBER
2252: , p_entity_type IN VARCHAR2
2253: , p_column_name IN VARCHAR2

Line 2250: , p_num2_tbl IN PO_TBL_NUMBER

2246: -------------------------------------------------------------------
2247: PROCEDURE num1_less_or_equal_num2(
2248: p_calling_module IN VARCHAR2
2249: , p_num1_tbl IN PO_TBL_NUMBER
2250: , p_num2_tbl IN PO_TBL_NUMBER
2251: , p_entity_id_tbl IN PO_TBL_NUMBER
2252: , p_entity_type IN VARCHAR2
2253: , p_column_name IN VARCHAR2
2254: , p_message_name IN VARCHAR2

Line 2251: , p_entity_id_tbl IN PO_TBL_NUMBER

2247: PROCEDURE num1_less_or_equal_num2(
2248: p_calling_module IN VARCHAR2
2249: , p_num1_tbl IN PO_TBL_NUMBER
2250: , p_num2_tbl IN PO_TBL_NUMBER
2251: , p_entity_id_tbl IN PO_TBL_NUMBER
2252: , p_entity_type IN VARCHAR2
2253: , p_column_name IN VARCHAR2
2254: , p_message_name IN VARCHAR2
2255: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 2346: p_value_tbl IN PO_TBL_NUMBER,

2342: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
2343: --End of Comments
2344: -------------------------------------------------------------------------------
2345: PROCEDURE zero(p_calling_module IN VARCHAR2,
2346: p_value_tbl IN PO_TBL_NUMBER,
2347: p_entity_id_tbl IN PO_TBL_NUMBER,
2348: p_entity_type IN VARCHAR2,
2349: p_column_name IN VARCHAR2,
2350: p_message_name IN VARCHAR2,

Line 2347: p_entity_id_tbl IN PO_TBL_NUMBER,

2343: --End of Comments
2344: -------------------------------------------------------------------------------
2345: PROCEDURE zero(p_calling_module IN VARCHAR2,
2346: p_value_tbl IN PO_TBL_NUMBER,
2347: p_entity_id_tbl IN PO_TBL_NUMBER,
2348: p_entity_type IN VARCHAR2,
2349: p_column_name IN VARCHAR2,
2350: p_message_name IN VARCHAR2,
2351: p_token1_name IN VARCHAR2 DEFAULT NULL,

Line 2462: p_terms_id_tbl IN PO_TBL_NUMBER,

2458: -- PO_VALIDATIONS.c_result_type_FAILURE - failures.
2459: --End of Comments
2460: -------------------------------------------------------------------------------
2461: PROCEDURE terms_id(p_calling_module IN VARCHAR2,
2462: p_terms_id_tbl IN PO_TBL_NUMBER,
2463: p_entity_id_tbl IN PO_TBL_NUMBER,
2464: p_entity_type IN VARCHAR2,
2465: p_validation_id IN NUMBER DEFAULT NULL,
2466: x_result_set_id IN OUT NOCOPY NUMBER,

Line 2463: p_entity_id_tbl IN PO_TBL_NUMBER,

2459: --End of Comments
2460: -------------------------------------------------------------------------------
2461: PROCEDURE terms_id(p_calling_module IN VARCHAR2,
2462: p_terms_id_tbl IN PO_TBL_NUMBER,
2463: p_entity_id_tbl IN PO_TBL_NUMBER,
2464: p_entity_type IN VARCHAR2,
2465: p_validation_id IN NUMBER DEFAULT NULL,
2466: x_result_set_id IN OUT NOCOPY NUMBER,
2467: x_result_type OUT NOCOPY VARCHAR2) IS

Line 2575: , p_value_tbl IN PO_TBL_NUMBER

2571: --End of Comments
2572: -------------------------------------------------------------------------------
2573: PROCEDURE gt_zero_opm_filter(
2574: p_calling_module IN VARCHAR2
2575: , p_value_tbl IN PO_TBL_NUMBER
2576: , p_entity_id_tbl IN PO_TBL_NUMBER
2577: , p_item_id_tbl IN PO_TBL_NUMBER
2578: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2579: , p_entity_type IN VARCHAR2

Line 2576: , p_entity_id_tbl IN PO_TBL_NUMBER

2572: -------------------------------------------------------------------------------
2573: PROCEDURE gt_zero_opm_filter(
2574: p_calling_module IN VARCHAR2
2575: , p_value_tbl IN PO_TBL_NUMBER
2576: , p_entity_id_tbl IN PO_TBL_NUMBER
2577: , p_item_id_tbl IN PO_TBL_NUMBER
2578: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2579: , p_entity_type IN VARCHAR2
2580: , p_column_name IN VARCHAR2

Line 2577: , p_item_id_tbl IN PO_TBL_NUMBER

2573: PROCEDURE gt_zero_opm_filter(
2574: p_calling_module IN VARCHAR2
2575: , p_value_tbl IN PO_TBL_NUMBER
2576: , p_entity_id_tbl IN PO_TBL_NUMBER
2577: , p_item_id_tbl IN PO_TBL_NUMBER
2578: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2579: , p_entity_type IN VARCHAR2
2580: , p_column_name IN VARCHAR2
2581: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 2578: , p_inv_org_id_tbl IN PO_TBL_NUMBER

2574: p_calling_module IN VARCHAR2
2575: , p_value_tbl IN PO_TBL_NUMBER
2576: , p_entity_id_tbl IN PO_TBL_NUMBER
2577: , p_item_id_tbl IN PO_TBL_NUMBER
2578: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2579: , p_entity_type IN VARCHAR2
2580: , p_column_name IN VARCHAR2
2581: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2582: , x_result_type OUT NOCOPY VARCHAR2

Line 2589: l_entity_id_tbl PO_TBL_NUMBER;

2585: d_mod CONSTANT VARCHAR2(100) := D_gt_zero_opm_filter;
2586:
2587: l_input_size NUMBER;
2588: l_count NUMBER;
2589: l_entity_id_tbl PO_TBL_NUMBER;
2590: l_value_tbl PO_TBL_NUMBER;
2591:
2592: l_sec_default_ind VARCHAR2(1);
2593:

Line 2590: l_value_tbl PO_TBL_NUMBER;

2586:
2587: l_input_size NUMBER;
2588: l_count NUMBER;
2589: l_entity_id_tbl PO_TBL_NUMBER;
2590: l_value_tbl PO_TBL_NUMBER;
2591:
2592: l_sec_default_ind VARCHAR2(1);
2593:
2594: BEGIN

Line 2609: l_entity_id_tbl := PO_TBL_NUMBER();

2605: END IF;
2606:
2607: l_input_size := p_entity_id_tbl.COUNT;
2608:
2609: l_entity_id_tbl := PO_TBL_NUMBER();
2610: l_entity_id_tbl.extend(l_input_size);
2611: l_value_tbl := PO_TBL_NUMBER();
2612: l_value_tbl.extend(l_input_size);
2613:

Line 2611: l_value_tbl := PO_TBL_NUMBER();

2607: l_input_size := p_entity_id_tbl.COUNT;
2608:
2609: l_entity_id_tbl := PO_TBL_NUMBER();
2610: l_entity_id_tbl.extend(l_input_size);
2611: l_value_tbl := PO_TBL_NUMBER();
2612: l_value_tbl.extend(l_input_size);
2613:
2614: l_count := 0;
2615:

Line 2718: , p_entity_id_tbl IN PO_TBL_NUMBER

2714: --End of Comments
2715: -------------------------------------------------------------------------------
2716: PROCEDURE qtys_within_deviation(
2717: p_calling_module IN VARCHAR2
2718: , p_entity_id_tbl IN PO_TBL_NUMBER
2719: , p_item_id_tbl IN PO_TBL_NUMBER
2720: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2721: , p_quantity_tbl IN PO_TBL_NUMBER
2722: , p_primary_uom_tbl IN PO_TBL_VARCHAR30

Line 2719: , p_item_id_tbl IN PO_TBL_NUMBER

2715: -------------------------------------------------------------------------------
2716: PROCEDURE qtys_within_deviation(
2717: p_calling_module IN VARCHAR2
2718: , p_entity_id_tbl IN PO_TBL_NUMBER
2719: , p_item_id_tbl IN PO_TBL_NUMBER
2720: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2721: , p_quantity_tbl IN PO_TBL_NUMBER
2722: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
2723: , p_sec_quantity_tbl IN PO_TBL_NUMBER

Line 2720: , p_inv_org_id_tbl IN PO_TBL_NUMBER

2716: PROCEDURE qtys_within_deviation(
2717: p_calling_module IN VARCHAR2
2718: , p_entity_id_tbl IN PO_TBL_NUMBER
2719: , p_item_id_tbl IN PO_TBL_NUMBER
2720: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2721: , p_quantity_tbl IN PO_TBL_NUMBER
2722: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
2723: , p_sec_quantity_tbl IN PO_TBL_NUMBER
2724: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30

Line 2721: , p_quantity_tbl IN PO_TBL_NUMBER

2717: p_calling_module IN VARCHAR2
2718: , p_entity_id_tbl IN PO_TBL_NUMBER
2719: , p_item_id_tbl IN PO_TBL_NUMBER
2720: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2721: , p_quantity_tbl IN PO_TBL_NUMBER
2722: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
2723: , p_sec_quantity_tbl IN PO_TBL_NUMBER
2724: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
2725: , p_column_name IN VARCHAR2

Line 2723: , p_sec_quantity_tbl IN PO_TBL_NUMBER

2719: , p_item_id_tbl IN PO_TBL_NUMBER
2720: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2721: , p_quantity_tbl IN PO_TBL_NUMBER
2722: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
2723: , p_sec_quantity_tbl IN PO_TBL_NUMBER
2724: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
2725: , p_column_name IN VARCHAR2
2726: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2727: , x_result_type OUT NOCOPY VARCHAR2

Line 2843: p_id_tbl IN po_tbl_number,

2839: -- Validate secondary_unit_of_measure.
2840: -- To be called only for BLANKET AND STANDARD.
2841: --------------------------------------------------------------------------------------------
2842: PROCEDURE secondary_unit_of_measure(
2843: p_id_tbl IN po_tbl_number,
2844: p_entity_type IN VARCHAR2,
2845: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
2846: p_item_id_tbl IN po_tbl_number,
2847: p_item_tbl IN po_tbl_varchar2000,

Line 2846: p_item_id_tbl IN po_tbl_number,

2842: PROCEDURE secondary_unit_of_measure(
2843: p_id_tbl IN po_tbl_number,
2844: p_entity_type IN VARCHAR2,
2845: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
2846: p_item_id_tbl IN po_tbl_number,
2847: p_item_tbl IN po_tbl_varchar2000,
2848: p_organization_id_tbl IN po_tbl_number,
2849: p_doc_type IN VARCHAR2,
2850: p_create_or_update_item_flag IN VARCHAR2,

Line 2848: p_organization_id_tbl IN po_tbl_number,

2844: p_entity_type IN VARCHAR2,
2845: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
2846: p_item_id_tbl IN po_tbl_number,
2847: p_item_tbl IN po_tbl_varchar2000,
2848: p_organization_id_tbl IN po_tbl_number,
2849: p_doc_type IN VARCHAR2,
2850: p_create_or_update_item_flag IN VARCHAR2,
2851: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2852: x_result_type OUT NOCOPY VARCHAR2)

Line 2978: p_id_tbl IN po_tbl_number,

2974: -- Validate secondary_quantity.
2975: -- To be called for all doc types, but we need to pass it doc type for certain validations.
2976: --------------------------------------------------------------------------------------------
2977: PROCEDURE secondary_quantity(
2978: p_id_tbl IN po_tbl_number,
2979: p_entity_type IN VARCHAR2,
2980: p_secondary_quantity_tbl IN po_tbl_number,
2981: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2982: p_item_id_tbl IN po_tbl_number,

Line 2980: p_secondary_quantity_tbl IN po_tbl_number,

2976: --------------------------------------------------------------------------------------------
2977: PROCEDURE secondary_quantity(
2978: p_id_tbl IN po_tbl_number,
2979: p_entity_type IN VARCHAR2,
2980: p_secondary_quantity_tbl IN po_tbl_number,
2981: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2982: p_item_id_tbl IN po_tbl_number,
2983: p_item_tbl IN po_tbl_varchar2000,
2984: p_organization_id_tbl IN po_tbl_number,

Line 2982: p_item_id_tbl IN po_tbl_number,

2978: p_id_tbl IN po_tbl_number,
2979: p_entity_type IN VARCHAR2,
2980: p_secondary_quantity_tbl IN po_tbl_number,
2981: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2982: p_item_id_tbl IN po_tbl_number,
2983: p_item_tbl IN po_tbl_varchar2000,
2984: p_organization_id_tbl IN po_tbl_number,
2985: p_doc_type IN VARCHAR2,
2986: p_create_or_update_item_flag IN VARCHAR2,

Line 2984: p_organization_id_tbl IN po_tbl_number,

2980: p_secondary_quantity_tbl IN po_tbl_number,
2981: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2982: p_item_id_tbl IN po_tbl_number,
2983: p_item_tbl IN po_tbl_varchar2000,
2984: p_organization_id_tbl IN po_tbl_number,
2985: p_doc_type IN VARCHAR2,
2986: p_create_or_update_item_flag IN VARCHAR2,
2987: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2988: x_result_type OUT NOCOPY VARCHAR2)

Line 3170: p_id_tbl IN po_tbl_number,

3166: -- Validate secondary_unit_of_measure for the update case.
3167: -- To be called only for BLANKET AND STANDARD.
3168: --------------------------------------------------------------------------------------------
3169: PROCEDURE secondary_uom_update(
3170: p_id_tbl IN po_tbl_number,
3171: p_entity_type IN VARCHAR2,
3172: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
3173: p_item_id_tbl IN po_tbl_number,
3174: p_organization_id_tbl IN po_tbl_number,

Line 3173: p_item_id_tbl IN po_tbl_number,

3169: PROCEDURE secondary_uom_update(
3170: p_id_tbl IN po_tbl_number,
3171: p_entity_type IN VARCHAR2,
3172: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
3173: p_item_id_tbl IN po_tbl_number,
3174: p_organization_id_tbl IN po_tbl_number,
3175: p_create_or_update_item_flag IN VARCHAR2,
3176: x_result_set_id IN OUT NOCOPY NUMBER,
3177: x_result_type OUT NOCOPY VARCHAR2)

Line 3174: p_organization_id_tbl IN po_tbl_number,

3170: p_id_tbl IN po_tbl_number,
3171: p_entity_type IN VARCHAR2,
3172: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
3173: p_item_id_tbl IN po_tbl_number,
3174: p_organization_id_tbl IN po_tbl_number,
3175: p_create_or_update_item_flag IN VARCHAR2,
3176: x_result_set_id IN OUT NOCOPY NUMBER,
3177: x_result_type OUT NOCOPY VARCHAR2)
3178: IS

Line 3262: p_id_tbl IN po_tbl_number,

3258: -- If grade doesn't exist in the grade master table then log an exception error out.
3259: -- To be called only for BLANKET and STANDARD.
3260: --------------------------------------------------------------------------------------------
3261: PROCEDURE preferred_grade(
3262: p_id_tbl IN po_tbl_number,
3263: p_entity_type IN VARCHAR2,
3264: p_preferred_grade_tbl IN po_tbl_varchar2000,
3265: p_item_id_tbl IN po_tbl_number,
3266: p_item_tbl IN po_tbl_varchar2000,

Line 3265: p_item_id_tbl IN po_tbl_number,

3261: PROCEDURE preferred_grade(
3262: p_id_tbl IN po_tbl_number,
3263: p_entity_type IN VARCHAR2,
3264: p_preferred_grade_tbl IN po_tbl_varchar2000,
3265: p_item_id_tbl IN po_tbl_number,
3266: p_item_tbl IN po_tbl_varchar2000,
3267: p_organization_id_tbl IN po_tbl_number,
3268: p_create_or_update_item_flag IN VARCHAR2,
3269: p_validation_id IN NUMBER DEFAULT NULL,

Line 3267: p_organization_id_tbl IN po_tbl_number,

3263: p_entity_type IN VARCHAR2,
3264: p_preferred_grade_tbl IN po_tbl_varchar2000,
3265: p_item_id_tbl IN po_tbl_number,
3266: p_item_tbl IN po_tbl_varchar2000,
3267: p_organization_id_tbl IN po_tbl_number,
3268: p_create_or_update_item_flag IN VARCHAR2,
3269: p_validation_id IN NUMBER DEFAULT NULL,
3270: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3271: x_result_set_id IN OUT NOCOPY NUMBER,

Line 3403: p_id_tbl IN po_tbl_number,

3399: END preferred_grade;
3400:
3401:
3402: PROCEDURE process_enabled(
3403: p_id_tbl IN po_tbl_number,
3404: p_entity_type IN VARCHAR2,
3405: p_ship_to_organization_id_tbl IN po_tbl_number,
3406: p_item_id_tbl IN po_tbl_number,
3407: x_result_set_id IN OUT NOCOPY NUMBER,

Line 3405: p_ship_to_organization_id_tbl IN po_tbl_number,

3401:
3402: PROCEDURE process_enabled(
3403: p_id_tbl IN po_tbl_number,
3404: p_entity_type IN VARCHAR2,
3405: p_ship_to_organization_id_tbl IN po_tbl_number,
3406: p_item_id_tbl IN po_tbl_number,
3407: x_result_set_id IN OUT NOCOPY NUMBER,
3408: x_result_type OUT NOCOPY VARCHAR2)
3409: IS

Line 3406: p_item_id_tbl IN po_tbl_number,

3402: PROCEDURE process_enabled(
3403: p_id_tbl IN po_tbl_number,
3404: p_entity_type IN VARCHAR2,
3405: p_ship_to_organization_id_tbl IN po_tbl_number,
3406: p_item_id_tbl IN po_tbl_number,
3407: x_result_set_id IN OUT NOCOPY NUMBER,
3408: x_result_type OUT NOCOPY VARCHAR2)
3409: IS
3410: d_mod CONSTANT VARCHAR2(100) := d_secondary_unit_of_measure;

Line 3480: p_item_id_tbl IN po_tbl_number,

3476: --------------------------------------------------------------------------------------------
3477: -- Private function to get the converted unit of measure from mtl_system_items.
3478: --------------------------------------------------------------------------------------------
3479: FUNCTION get_item_secondary_uom(
3480: p_item_id_tbl IN po_tbl_number,
3481: p_organization_id_tbl IN po_tbl_number)
3482: RETURN PO_TBL_VARCHAR30
3483: IS
3484:

Line 3481: p_organization_id_tbl IN po_tbl_number)

3477: -- Private function to get the converted unit of measure from mtl_system_items.
3478: --------------------------------------------------------------------------------------------
3479: FUNCTION get_item_secondary_uom(
3480: p_item_id_tbl IN po_tbl_number,
3481: p_organization_id_tbl IN po_tbl_number)
3482: RETURN PO_TBL_VARCHAR30
3483: IS
3484:
3485: d_mod CONSTANT VARCHAR2(100) := d_get_item_secondary_uom;

Line 3491: l_index1_tbl PO_TBL_NUMBER;

3487:
3488: -- key value used to identify rows in po_session_gt table
3489: l_key po_session_gt.key%TYPE;
3490: l_index_tbl DBMS_SQL.NUMBER_TABLE;
3491: l_index1_tbl PO_TBL_NUMBER;
3492: l_result1_tbl PO_TBL_VARCHAR30;
3493:
3494: BEGIN
3495:

Line 3572: , p_entity_id_tbl IN PO_TBL_NUMBER

3568:
3569: PROCEDURE start_date_ge_sys_date(
3570: p_calling_module IN VARCHAR2
3571: , p_start_date_tbl IN PO_TBL_DATE
3572: , p_entity_id_tbl IN PO_TBL_NUMBER
3573: , p_entity_type IN VARCHAR2
3574: , p_column_name IN VARCHAR2
3575: , p_message_name IN VARCHAR2
3576: , p_validation_id IN NUMBER DEFAULT NULL

Line 3648: -- This procedure will split the par draft id and returns a PO_TBL_NUMBER

3644: --Name: extract_par_draft_id_tbl
3645: -- CLM Phase 4 - PAR Project
3646: --Procedure:
3647: -- The par draft id of a line is passed as comma seperated string.
3648: -- This procedure will split the par draft id and returns a PO_TBL_NUMBER
3649: --Parameters:
3650: --IN:
3651: --p_par_draft_id:
3652: -- comma seperated pardraft id list.

Line 3656: -- PO_TBL_NUMBER of par draft id.

3652: -- comma seperated pardraft id list.
3653: --IN OUT:
3654: --OUT:
3655: --l_par_draft_id_tbl:
3656: -- PO_TBL_NUMBER of par draft id.
3657: --Notes:
3658: --End of Comments
3659: --------------------------------------------------------------------------------
3660: PROCEDURE extract_par_draft_id_tbl(p_par_draft_id IN VARCHAR2,

Line 3661: l_par_draft_id_tbl OUT NOCOPY po_tbl_number)

3657: --Notes:
3658: --End of Comments
3659: --------------------------------------------------------------------------------
3660: PROCEDURE extract_par_draft_id_tbl(p_par_draft_id IN VARCHAR2,
3661: l_par_draft_id_tbl OUT NOCOPY po_tbl_number)
3662: IS
3663:
3664: d_mod CONSTANT VARCHAR2(100) := D_extract_par_draft_id_tbl;
3665:

Line 3671: l_par_draft_id_tbl := po_tbl_number();

3667: IF PO_LOG.d_proc THEN
3668: PO_LOG.proc_begin(d_mod,'p_par_draft_id ',p_par_draft_id);
3669: END IF;
3670:
3671: l_par_draft_id_tbl := po_tbl_number();
3672: FOR context_cur IN
3673: (
3674: select REGEXP_SUBSTR(p_par_draft_id ,'[^,]+', 1, LEVEL) l_par_draft_id FROM dual
3675: CONNECT BY regexp_substr(p_par_draft_id, '[^,]+', 1, LEVEL) IS NOT NULL