71: )
72: IS
73: BEGIN
74:
75: PO_VALIDATION_HELPER.greater_or_equal_zero(
76: p_calling_module => D_max_mul_ge_zero
77: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
78: , p_value_tbl => p_max_multiplier_tbl
79: , p_entity_id_tbl => p_price_differential_id_tbl
99: )
100: IS
101: BEGIN
102:
103: PO_VALIDATION_HELPER.num1_less_or_equal_num2(
104: p_calling_module => D_max_mul_ge_min_mul
105: , p_num1_tbl => p_min_multiplier_tbl
106: , p_num2_tbl => p_max_multiplier_tbl
107: , p_entity_id_tbl => p_price_differential_id_tbl
126: )
127: IS
128: BEGIN
129:
130: PO_VALIDATION_HELPER.greater_or_equal_zero(
131: p_calling_module => D_min_mul_ge_zero
132: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
133: , p_value_tbl => p_min_multiplier_tbl
134: , p_entity_id_tbl => p_price_differential_id_tbl
153: )
154: IS
155: BEGIN
156:
157: PO_VALIDATION_HELPER.greater_or_equal_zero(
158: p_calling_module => D_mul_ge_zero
159: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
160: , p_value_tbl => p_multiplier_tbl
161: , p_entity_id_tbl => p_price_differential_id_tbl
185: )
186: IS
187: BEGIN
188:
189: PO_VALIDATION_HELPER.price_diff_value_unique(
190: p_calling_module => D_unique_price_diff_num
191: , p_price_diff_id_tbl => p_price_differential_id_tbl
192: , p_entity_id_tbl => p_entity_id_tbl
193: , p_entity_type_tbl => p_entity_type_tbl
212: )
213: IS
214: BEGIN
215:
216: PO_VALIDATION_HELPER.greater_than_zero(
217: p_calling_module => D_price_diff_num_gt_zero
218: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
219: , p_value_tbl => p_price_differential_num_tbl
220: , p_entity_id_tbl => p_price_differential_id_tbl
244: )
245: IS
246: BEGIN
247:
248: PO_VALIDATION_HELPER.price_diff_value_unique(
249: p_calling_module => D_unique_price_type
250: , p_price_diff_id_tbl => p_price_differential_id_tbl
251: , p_entity_id_tbl => p_entity_id_tbl
252: , p_entity_type_tbl => p_entity_type_tbl