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