1: PACKAGE BODY PO_VAL_NOTIFICATION_CONTROLS AS
2: -- $Header: PO_VAL_NOTIFICATION_CONTROLS.plb 120.1 2005/08/12 17:55:05 sbull noship $
3:
4: c_entity_type_NOTIF_CTRL CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_entity_type_NOTIF_CTRL;
5:
6: -- Constants for columns.
7: c_START_DATE_ACTIVE CONSTANT VARCHAR2(30) := 'START_DATE_ACTIVE';
8: c_NOTIFICATION_QTY_PERCENTAGE CONSTANT VARCHAR2(30) := 'NOTIFICATION_QTY_PERCENTAGE';
109: END IF;
110: END LOOP;
111:
112: IF (l_results_count < x_results.result_type.COUNT) THEN
113: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
114: ELSE
115: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
116: END IF;
117:
111:
112: IF (l_results_count < x_results.result_type.COUNT) THEN
113: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
114: ELSE
115: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
116: END IF;
117:
118: IF PO_LOG.d_proc THEN
119: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
198: END IF;
199: END LOOP;
200:
201: IF (l_results_count < x_results.result_type.COUNT) THEN
202: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
203: ELSE
204: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
205: END IF;
206:
200:
201: IF (l_results_count < x_results.result_type.COUNT) THEN
202: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
203: ELSE
204: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
205: END IF;
206:
207: IF PO_LOG.d_proc THEN
208: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
261: END IF;
262: END LOOP;
263:
264: IF (l_results_count < x_results.result_type.COUNT) THEN
265: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
266: ELSE
267: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
268: END IF;
269:
263:
264: IF (l_results_count < x_results.result_type.COUNT) THEN
265: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
266: ELSE
267: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
268: END IF;
269:
270: IF PO_LOG.d_proc THEN
271: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);