78: , p_value_tbl => p_max_multiplier_tbl
79: , p_entity_id_tbl => p_price_differential_id_tbl
80: , p_entity_type => c_entity_type_PRICE_DIFF
81: , p_column_name => c_MAX_MULTIPLIER
82: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
83: , x_results => x_results
84: , x_result_type => x_result_type
85: );
86:
106: , p_num2_tbl => p_max_multiplier_tbl
107: , p_entity_id_tbl => p_price_differential_id_tbl
108: , p_entity_type => c_entity_type_PRICE_DIFF
109: , p_column_name => NULL
110: , p_message_name => PO_MESSAGE_S.PO_SVC_MAX_LT_MIN_MULTIPLIER
111: , x_results => x_results
112: , x_result_type => x_result_type
113: );
114:
133: , p_value_tbl => p_min_multiplier_tbl
134: , p_entity_id_tbl => p_price_differential_id_tbl
135: , p_entity_type => c_entity_type_PRICE_DIFF
136: , p_column_name => c_MIN_MULTIPLIER
137: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
138: , x_results => x_results
139: , x_result_type => x_result_type
140: );
141:
160: , p_value_tbl => p_multiplier_tbl
161: , p_entity_id_tbl => p_price_differential_id_tbl
162: , p_entity_type => c_entity_type_PRICE_DIFF
163: , p_column_name => c_MULTIPLIER
164: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
165: , x_results => x_results
166: , x_result_type => x_result_type
167: );
168:
192: , p_entity_id_tbl => p_entity_id_tbl
193: , p_entity_type_tbl => p_entity_type_tbl
194: , p_unique_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_price_differential_num_tbl)
195: , p_column_name => c_PRICE_DIFFERENTIAL_NUM
196: , p_message_name => PO_MESSAGE_S.PO_SVC_NON_UNIQUE_PRC_DIFF_NUM
197: , x_result_set_id => x_result_set_id
198: , x_result_type => x_result_type
199: );
200:
219: , p_value_tbl => p_price_differential_num_tbl
220: , p_entity_id_tbl => p_price_differential_id_tbl
221: , p_entity_type => c_entity_type_PRICE_DIFF
222: , p_column_name => c_PRICE_DIFFERENTIAL_NUM
223: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO
224: , x_results => x_results
225: , x_result_type => x_result_type
226: );
227:
251: , p_entity_id_tbl => p_entity_id_tbl
252: , p_entity_type_tbl => p_entity_type_tbl
253: , p_unique_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_price_type_tbl)
254: , p_column_name => c_PRICE_TYPE
255: , p_message_name => PO_MESSAGE_S.PO_SVC_NON_UNIQUE_PRICE_TYPE
256: , x_result_set_id => x_result_set_id
257: , x_result_type => x_result_type
258: );
259:
304: , c_entity_type_PRICE_DIFF
305: , p_price_differential_id_tbl(i)
306: , c_PRICE_TYPE
307: , p_price_type_tbl(i)
308: , PO_MESSAGE_S.PO_SVC_PRC_TYPE_NOT_ON_SRC_DOC
309: FROM DUAL
310: WHERE
311: p_entity_type_tbl(i) = c_PO_LINE
312: AND EXISTS
397: , c_entity_type_PRICE_DIFF
398: , p_price_differential_id_tbl(i)
399: , c_MULTIPLIER
400: , p_multiplier_tbl(i)
401: , PO_MESSAGE_S.PO_SVC_MULTIPLIER_BTWN_MIN_MAX
402: --
403: , c_MIN
404: , SRC_PRICE_DIFF.min_multiplier
405: , c_MAX
492: , c_entity_type_PRICE_DIFF
493: , p_price_differential_id_tbl(i)
494: , c_MULTIPLIER
495: , p_multiplier_tbl(i)
496: , PO_MESSAGE_S.PO_SVC_MULTIPLIER_GT_MIN
497: --
498: , c_MIN
499: , SRC_PRICE_DIFF.min_multiplier
500: FROM PO_PRICE_DIFFERENTIALS SRC_PRICE_DIFF