APPS.PO_VAL_NOTIFICATION_CONTROLS dependencies on PO_TBL_NUMBER

Line 48: p_notification_id_tbl IN PO_TBL_NUMBER

44: -------------------------------------------------------------------------
45: -- Check if the start date is less than the end date.
46: -------------------------------------------------------------------------
47: PROCEDURE start_date_le_end_date(
48: p_notification_id_tbl IN PO_TBL_NUMBER
49: , p_start_date_active_tbl IN PO_TBL_DATE
50: , p_end_date_active_tbl IN PO_TBL_DATE
51: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
52: , x_result_type OUT NOCOPY VARCHAR2

Line 76: p_notification_id_tbl IN PO_TBL_NUMBER

72: -------------------------------------------------------------------------
73: -- Check if the notification quantity percentage is less than one hundred
74: -------------------------------------------------------------------------
75: PROCEDURE percent_le_one_hundred(
76: p_notification_id_tbl IN PO_TBL_NUMBER
77: , p_notif_qty_percentage_tbl IN PO_TBL_NUMBER
78: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
79: , x_result_type OUT NOCOPY VARCHAR2
80: )

Line 77: , p_notif_qty_percentage_tbl IN PO_TBL_NUMBER

73: -- Check if the notification quantity percentage is less than one hundred
74: -------------------------------------------------------------------------
75: PROCEDURE percent_le_one_hundred(
76: p_notification_id_tbl IN PO_TBL_NUMBER
77: , p_notif_qty_percentage_tbl IN PO_TBL_NUMBER
78: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
79: , x_result_type OUT NOCOPY VARCHAR2
80: )
81: IS

Line 136: p_notification_id_tbl IN PO_TBL_NUMBER

132: -------------------------------------------------------------------------
133: -- Check if the notification amount is greater than zero
134: -------------------------------------------------------------------------
135: PROCEDURE amount_gt_zero(
136: p_notification_id_tbl IN PO_TBL_NUMBER
137: , p_notification_amount_tbl IN PO_TBL_NUMBER
138: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
139: , x_result_type OUT NOCOPY VARCHAR2
140: )

Line 137: , p_notification_amount_tbl IN PO_TBL_NUMBER

133: -- Check if the notification amount is greater than zero
134: -------------------------------------------------------------------------
135: PROCEDURE amount_gt_zero(
136: p_notification_id_tbl IN PO_TBL_NUMBER
137: , p_notification_amount_tbl IN PO_TBL_NUMBER
138: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
139: , x_result_type OUT NOCOPY VARCHAR2
140: )
141: IS

Line 163: p_notif_id_tbl IN PO_TBL_NUMBER

159: -------------------------------------------------------------------------
160: -- Checks that the Amount is entered for a non-EXPIRATION control.
161: -------------------------------------------------------------------------
162: PROCEDURE amount_not_null(
163: p_notif_id_tbl IN PO_TBL_NUMBER
164: , p_notif_amount_tbl IN PO_TBL_NUMBER
165: , p_notif_condition_code_tbl IN PO_TBL_VARCHAR30
166: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
167: , x_result_type OUT NOCOPY VARCHAR2

Line 164: , p_notif_amount_tbl IN PO_TBL_NUMBER

160: -- Checks that the Amount is entered for a non-EXPIRATION control.
161: -------------------------------------------------------------------------
162: PROCEDURE amount_not_null(
163: p_notif_id_tbl IN PO_TBL_NUMBER
164: , p_notif_amount_tbl IN PO_TBL_NUMBER
165: , p_notif_condition_code_tbl IN PO_TBL_VARCHAR30
166: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
167: , x_result_type OUT NOCOPY VARCHAR2
168: )

Line 226: p_notif_id_tbl IN PO_TBL_NUMBER

222: -------------------------------------------------------------------------
223: -- Checks that the Start Date Active is entered for an EXPIRATION control.
224: -------------------------------------------------------------------------
225: PROCEDURE start_date_active_not_null(
226: p_notif_id_tbl IN PO_TBL_NUMBER
227: , p_start_date_active_tbl IN PO_TBL_DATE
228: , p_notif_condition_code_tbl IN PO_TBL_VARCHAR30
229: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
230: , x_result_type OUT NOCOPY VARCHAR2