1: PACKAGE PO_VAL_NOTIFICATION_CONTROLS AS
2: -- $Header: PO_VAL_NOTIFICATION_CONTROLS.pls 120.1 2005/08/12 17:55:35 sbull noship $
3:
4: PROCEDURE start_date_le_end_date(
5: p_notification_id_tbl IN PO_TBL_NUMBER
6: , p_start_date_active_tbl IN PO_TBL_DATE
7: , p_end_date_active_tbl IN PO_TBL_DATE
8: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
9: , x_result_type OUT NOCOPY VARCHAR2
9: , x_result_type OUT NOCOPY VARCHAR2
10: );
11:
12: PROCEDURE percent_le_one_hundred(
13: p_notification_id_tbl IN PO_TBL_NUMBER
14: , p_notif_qty_percentage_tbl IN PO_TBL_NUMBER
15: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
16: , x_result_type OUT NOCOPY VARCHAR2
17: );
10: );
11:
12: PROCEDURE percent_le_one_hundred(
13: p_notification_id_tbl IN PO_TBL_NUMBER
14: , p_notif_qty_percentage_tbl IN PO_TBL_NUMBER
15: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
16: , x_result_type OUT NOCOPY VARCHAR2
17: );
18:
16: , x_result_type OUT NOCOPY VARCHAR2
17: );
18:
19: PROCEDURE amount_gt_zero(
20: p_notification_id_tbl IN PO_TBL_NUMBER
21: , p_notification_amount_tbl IN PO_TBL_NUMBER
22: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
23: , x_result_type OUT NOCOPY VARCHAR2
24: );
17: );
18:
19: PROCEDURE amount_gt_zero(
20: p_notification_id_tbl IN PO_TBL_NUMBER
21: , p_notification_amount_tbl IN PO_TBL_NUMBER
22: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
23: , x_result_type OUT NOCOPY VARCHAR2
24: );
25:
23: , x_result_type OUT NOCOPY VARCHAR2
24: );
25:
26: PROCEDURE amount_not_null(
27: p_notif_id_tbl IN PO_TBL_NUMBER
28: , p_notif_amount_tbl IN PO_TBL_NUMBER
29: , p_notif_condition_code_tbl IN PO_TBL_VARCHAR30
30: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
31: , x_result_type OUT NOCOPY VARCHAR2
24: );
25:
26: PROCEDURE amount_not_null(
27: p_notif_id_tbl IN PO_TBL_NUMBER
28: , p_notif_amount_tbl IN PO_TBL_NUMBER
29: , p_notif_condition_code_tbl IN PO_TBL_VARCHAR30
30: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
31: , x_result_type OUT NOCOPY VARCHAR2
32: );
31: , x_result_type OUT NOCOPY VARCHAR2
32: );
33:
34: PROCEDURE start_date_active_not_null(
35: p_notif_id_tbl IN PO_TBL_NUMBER
36: , p_start_date_active_tbl IN PO_TBL_DATE
37: , p_notif_condition_code_tbl IN PO_TBL_VARCHAR30
38: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
39: , x_result_type OUT NOCOPY VARCHAR2