[Home] [Help]
141: -- validate acceptance_due_date is not null if acceptance_required_flag = Y.
142: -- Only called for Blanket and SPO.
143: -------------------------------------------------------------------------
144: PROCEDURE acceptance_due_date(p_id_tbl IN po_tbl_number,
145: p_acceptance_reqd_flag_tbl IN PO_TBL_VARCHAR1,
146: p_acceptance_due_date_tbl IN po_tbl_date,
147: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
148: x_result_type OUT NOCOPY VARCHAR2);
149:
150: -------------------------------------------------------------------------
151: -- validate cancel_flag = N. Only called for Blanket and SPO.
152: -------------------------------------------------------------------------
153: PROCEDURE cancel_flag(p_id_tbl IN po_tbl_number,
154: p_cancel_flag_tbl IN PO_TBL_VARCHAR1,
155: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
156: x_result_type OUT NOCOPY VARCHAR2);
157:
158: -------------------------------------------------------------------------
159: -- validate closed_code = OPEN. Only called for Blanket and SPO.
160: -------------------------------------------------------------------------
161: PROCEDURE closed_code(p_id_tbl IN po_tbl_number,
162: p_closed_code_tbl IN PO_TBL_VARCHAR30,
163: p_acceptance_reqd_flag_tbl IN PO_TBL_VARCHAR1,
164: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
165: x_result_type OUT NOCOPY VARCHAR2);
166:
167: -------------------------------------------------------------------------
204: -------------------------------------------------------------------------
205: PROCEDURE acceptance_required_flag
206: ( p_id_tbl IN PO_TBL_NUMBER,
207: p_type_lookup_code_tbl IN PO_TBL_VARCHAR30,
208: p_acceptance_required_flag_tbl IN PO_TBL_VARCHAR1,
209: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
210: x_result_type OUT NOCOPY VARCHAR2
211: );
212: