[Home] [Help]
175: )
176: IS
177: BEGIN
178:
179: PO_VALIDATION_HELPER.greater_or_equal_zero(
180: p_calling_module => D_amt_agreed_ge_zero
181: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
182: , p_value_tbl => p_committed_amount_tbl
183: , p_entity_id_tbl => p_line_id_tbl
202: )
203: IS
204: BEGIN
205:
206: PO_VALIDATION_HELPER.greater_or_equal_zero(
207: p_calling_module => D_min_rel_amt_ge_zero
208: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
209: , p_value_tbl => p_min_release_amount_tbl
210: , p_entity_id_tbl => p_line_id_tbl
230: )
231: IS
232: BEGIN
233:
234: PO_VALIDATION_HELPER.gt_zero_order_type_filter(
235: p_calling_module => D_quantity_gt_zero
236: , p_value_tbl => p_quantity_tbl
237: , p_entity_id_tbl => p_line_id_tbl
238: , p_order_type_lookup_code_tbl => p_order_type_lookup_code_tbl
518: )
519: IS
520: BEGIN
521:
522: PO_VALIDATION_HELPER.amount_notif_ctrl_warning(
523: p_calling_module => D_quantity_notif_change
524: , p_line_id_tbl => p_line_id_tbl
525: , p_quantity_tbl => p_quantity_tbl
526: , p_column_name => c_QUANTITY
545: )
546: IS
547: BEGIN
548:
549: PO_VALIDATION_HELPER.gt_zero_order_type_filter(
550: p_calling_module => D_amount_gt_zero
551: , p_value_tbl => p_amount_tbl
552: , p_entity_id_tbl => p_line_id_tbl
553: , p_order_type_lookup_code_tbl => p_order_type_lookup_code_tbl
905: )
906: IS
907: BEGIN
908:
909: PO_VALIDATION_HELPER.child_num_unique(
910: p_calling_module => D_line_num_unique
911: , p_entity_type => c_entity_type_LINE
912: , p_entity_id_tbl => p_line_id_tbl
913: , p_parent_id_tbl => p_header_id_tbl
930: )
931: IS
932: BEGIN
933:
934: PO_VALIDATION_HELPER.greater_than_zero(
935: p_calling_module => D_line_num_gt_zero
936: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
937: , p_value_tbl => p_line_num_tbl
938: , p_entity_id_tbl => p_line_id_tbl
1071: )
1072: IS
1073: BEGIN
1074:
1075: PO_VALIDATION_HELPER.start_date_le_end_date(
1076: p_calling_module => D_start_date_le_end_date
1077: , p_start_date_tbl => p_start_date_tbl
1078: , p_end_date_tbl => p_expiration_date_tbl
1079: , p_entity_id_tbl => p_line_id_tbl
1105: )
1106: IS
1107: BEGIN
1108:
1109: PO_VALIDATION_HELPER.no_timecards_exist(
1110: p_calling_module => D_otl_inv_start_date_change
1111: , p_line_id_tbl => p_line_id_tbl
1112: , p_start_date_tbl => p_start_date_tbl
1113: , p_expiration_date_tbl => NULL
1138: )
1139: IS
1140: BEGIN
1141:
1142: PO_VALIDATION_HELPER.no_timecards_exist(
1143: p_calling_module => D_otl_invalid_end_date_change
1144: , p_line_id_tbl => p_line_id_tbl
1145: , p_start_date_tbl => NULL
1146: , p_expiration_date_tbl => p_expiration_date_tbl
1199:
1200: l_line_id_tbl.trim(l_input_size-l_count);
1201: l_unit_price_tbl.trim(l_input_size-l_count);
1202:
1203: PO_VALIDATION_HELPER.greater_or_equal_zero(
1204: p_calling_module => d_mod
1205: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
1206: , p_value_tbl => l_unit_price_tbl
1207: , p_entity_id_tbl => l_line_id_tbl
1233: )
1234: IS
1235: BEGIN
1236:
1237: PO_VALIDATION_HELPER.greater_or_equal_zero(
1238: p_calling_module => D_list_price_ge_zero
1239: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
1240: , p_value_tbl => p_list_price_per_unit_tbl
1241: , p_entity_id_tbl => p_line_id_tbl
1260: )
1261: IS
1262: BEGIN
1263:
1264: PO_VALIDATION_HELPER.greater_or_equal_zero(
1265: p_calling_module => D_market_price_ge_zero
1266: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
1267: , p_value_tbl => p_market_price_tbl
1268: , p_entity_id_tbl => p_line_id_tbl
1392: )
1393: IS
1394: BEGIN
1395:
1396: PO_VALIDATION_HELPER.start_date_le_end_date(
1397: p_calling_module => D_expiration_ge_blanket_start
1398: , p_start_date_tbl => p_blanket_start_date_tbl
1399: , p_end_date_tbl => p_expiration_date_tbl
1400: , p_entity_id_tbl => p_line_id_tbl
1399: , p_end_date_tbl => p_expiration_date_tbl
1400: , p_entity_id_tbl => p_line_id_tbl
1401: , p_entity_type => c_entity_type_LINE
1402: , p_column_name => c_EXPIRATION_DATE
1403: , p_column_val_selector => PO_VALIDATION_HELPER.c_END_DATE
1404: , p_message_name => PO_MESSAGE_S.POX_EXPIRATION_DATES
1405: , x_results => x_results
1406: , x_result_type => x_result_type
1407: );
1424: )
1425: IS
1426: BEGIN
1427:
1428: PO_VALIDATION_HELPER.start_date_le_end_date(
1429: p_calling_module => D_expiration_le_blanket_end
1430: , p_start_date_tbl => p_expiration_date_tbl
1431: , p_end_date_tbl => p_blanket_end_date_tbl
1432: , p_entity_id_tbl => p_line_id_tbl
1431: , p_end_date_tbl => p_blanket_end_date_tbl
1432: , p_entity_id_tbl => p_line_id_tbl
1433: , p_entity_type => c_entity_type_LINE
1434: , p_column_name => c_EXPIRATION_DATE
1435: , p_column_val_selector => PO_VALIDATION_HELPER.c_START_DATE
1436: , p_message_name => PO_MESSAGE_S.POX_EXPIRATION_DATES
1437: , x_results => x_results
1438: , x_result_type => x_result_type
1439: );
1455: )
1456: IS
1457: BEGIN
1458:
1459: PO_VALIDATION_HELPER.within_percentage_range(
1460: p_calling_module => D_recoupment_rate_range_check
1461: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
1462: , p_value_tbl => p_recoupment_rate_tbl
1463: , p_entity_id_tbl => p_line_id_tbl
1478: )
1479: IS
1480: BEGIN
1481:
1482: PO_VALIDATION_HELPER.within_percentage_range(
1483: p_calling_module => D_retainage_rate_range_check
1484: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
1485: , p_value_tbl => p_retainage_rate_tbl
1486: , p_entity_id_tbl => p_line_id_tbl
1501: )
1502: IS
1503: BEGIN
1504:
1505: PO_VALIDATION_HELPER.within_percentage_range(
1506: p_calling_module => D_prog_pay_rate_range_check
1507: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
1508: , p_value_tbl => p_prog_pay_rate_tbl
1509: , p_entity_id_tbl => p_line_id_tbl
1778: )
1779: IS
1780: BEGIN
1781:
1782: PO_VALIDATION_HELPER.not_null(
1783: p_calling_module => D_item_description_not_null
1784: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_item_description_tbl)
1785: , p_entity_id_tbl => p_line_id_tbl
1786: , p_entity_type => c_entity_type_LINE
1804: )
1805: IS
1806: BEGIN
1807:
1808: PO_VALIDATION_HELPER.not_null(
1809: p_calling_module => D_category_id_not_null
1810: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_category_id_tbl)
1811: , p_entity_id_tbl => p_line_id_tbl
1812: , p_entity_type => c_entity_type_LINE
2061: )
2062: IS
2063: BEGIN
2064:
2065: PO_VALIDATION_HELPER.not_null(
2066: p_calling_module => D_line_type_id_not_null
2067: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_type_id_tbl)
2068: , p_entity_id_tbl => p_line_id_tbl
2069: , p_entity_type => c_entity_type_LINE
2177: FOR i IN 1 .. p_line_id_tbl.COUNT LOOP
2178: l_inv_org_id_tbl(i) := l_def_inv_org_id;
2179: END LOOP;
2180:
2181: PO_VALIDATION_HELPER.gt_zero_opm_filter(
2182: p_calling_module => D_line_sec_quantity_gt_zero
2183: , p_value_tbl => p_sec_quantity_tbl
2184: , p_entity_id_tbl => p_line_id_tbl
2185: , p_item_id_tbl => p_item_id_tbl
2243: FOR i IN 1 .. p_line_id_tbl.COUNT LOOP
2244: l_inv_org_id_tbl(i) := l_def_inv_org_id;
2245: END LOOP;
2246:
2247: PO_VALIDATION_HELPER.qtys_within_deviation (
2248: p_calling_module => D_line_qtys_within_deviation
2249: , p_entity_id_tbl => p_line_id_tbl
2250: , p_item_id_tbl => p_item_id_tbl
2251: , p_inv_org_id_tbl => l_inv_org_id_tbl
2367: )
2368: IS
2369: BEGIN
2370:
2371: PO_VALIDATION_HELPER.greater_or_equal_zero(
2372: p_calling_module => D_max_retain_amt_ge_zero
2373: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
2374: , p_value_tbl => p_max_retain_amt_tbl
2375: , p_entity_id_tbl => p_line_id_tbl