145:
146: PROCEDURE restore_working_copy_req(
147: p_origHeaderId IN NUMBER,
148: p_tempHeaderId IN NUMBER,
149: p_origLineIds IN PO_TBL_NUMBER,
150: p_tempLineIds IN PO_TBL_NUMBER,
151: p_origDistIds IN PO_TBL_NUMBER,
152: p_tempDistIds IN PO_TBL_NUMBER,
153: p_origReqSupplierIds IN PO_TBL_NUMBER,
146: PROCEDURE restore_working_copy_req(
147: p_origHeaderId IN NUMBER,
148: p_tempHeaderId IN NUMBER,
149: p_origLineIds IN PO_TBL_NUMBER,
150: p_tempLineIds IN PO_TBL_NUMBER,
151: p_origDistIds IN PO_TBL_NUMBER,
152: p_tempDistIds IN PO_TBL_NUMBER,
153: p_origReqSupplierIds IN PO_TBL_NUMBER,
154: p_tempReqSupplierIds IN PO_TBL_NUMBER,
147: p_origHeaderId IN NUMBER,
148: p_tempHeaderId IN NUMBER,
149: p_origLineIds IN PO_TBL_NUMBER,
150: p_tempLineIds IN PO_TBL_NUMBER,
151: p_origDistIds IN PO_TBL_NUMBER,
152: p_tempDistIds IN PO_TBL_NUMBER,
153: p_origReqSupplierIds IN PO_TBL_NUMBER,
154: p_tempReqSupplierIds IN PO_TBL_NUMBER,
155: p_origPriceDiffIds IN PO_TBL_NUMBER,
148: p_tempHeaderId IN NUMBER,
149: p_origLineIds IN PO_TBL_NUMBER,
150: p_tempLineIds IN PO_TBL_NUMBER,
151: p_origDistIds IN PO_TBL_NUMBER,
152: p_tempDistIds IN PO_TBL_NUMBER,
153: p_origReqSupplierIds IN PO_TBL_NUMBER,
154: p_tempReqSupplierIds IN PO_TBL_NUMBER,
155: p_origPriceDiffIds IN PO_TBL_NUMBER,
156: p_tempPriceDiffIds IN PO_TBL_NUMBER);
149: p_origLineIds IN PO_TBL_NUMBER,
150: p_tempLineIds IN PO_TBL_NUMBER,
151: p_origDistIds IN PO_TBL_NUMBER,
152: p_tempDistIds IN PO_TBL_NUMBER,
153: p_origReqSupplierIds IN PO_TBL_NUMBER,
154: p_tempReqSupplierIds IN PO_TBL_NUMBER,
155: p_origPriceDiffIds IN PO_TBL_NUMBER,
156: p_tempPriceDiffIds IN PO_TBL_NUMBER);
157:
150: p_tempLineIds IN PO_TBL_NUMBER,
151: p_origDistIds IN PO_TBL_NUMBER,
152: p_tempDistIds IN PO_TBL_NUMBER,
153: p_origReqSupplierIds IN PO_TBL_NUMBER,
154: p_tempReqSupplierIds IN PO_TBL_NUMBER,
155: p_origPriceDiffIds IN PO_TBL_NUMBER,
156: p_tempPriceDiffIds IN PO_TBL_NUMBER);
157:
158: FUNCTION submitreq(
151: p_origDistIds IN PO_TBL_NUMBER,
152: p_tempDistIds IN PO_TBL_NUMBER,
153: p_origReqSupplierIds IN PO_TBL_NUMBER,
154: p_tempReqSupplierIds IN PO_TBL_NUMBER,
155: p_origPriceDiffIds IN PO_TBL_NUMBER,
156: p_tempPriceDiffIds IN PO_TBL_NUMBER);
157:
158: FUNCTION submitreq(
159: req_Header_Id IN NUMBER,
152: p_tempDistIds IN PO_TBL_NUMBER,
153: p_origReqSupplierIds IN PO_TBL_NUMBER,
154: p_tempReqSupplierIds IN PO_TBL_NUMBER,
155: p_origPriceDiffIds IN PO_TBL_NUMBER,
156: p_tempPriceDiffIds IN PO_TBL_NUMBER);
157:
158: FUNCTION submitreq(
159: req_Header_Id IN NUMBER,
160: req_num IN varchar2,
268: p_doc_type IN VARCHAR2,
269: p_doc_subtype IN VARCHAR2,
270: p_dist_data IN ICX_ENC_IN_TYPE,
271: p_doc_level IN VARCHAR2,
272: p_doc_level_id_tbl IN po_tbl_number,
273: p_override_funds IN VARCHAR2,
274: p_use_gl_date IN VARCHAR2,
275: p_override_date IN DATE,
276: p_report_successes IN VARCHAR2,
288: x_return_status OUT NOCOPY VARCHAR2,
289: p_doc_type IN VARCHAR2,
290: p_doc_subtype IN VARCHAR2,
291: p_doc_level IN VARCHAR2,
292: p_doc_level_id_tbl IN po_tbl_number,
293: p_prevent_partial_flag IN VARCHAR2,
294: p_employee_id IN NUMBER,
295: p_override_funds IN VARCHAR2,
296: p_report_successes IN VARCHAR2,
308: x_return_status OUT NOCOPY VARCHAR2,
309: p_doc_type IN VARCHAR2,
310: p_doc_subtype IN VARCHAR2,
311: p_doc_level IN VARCHAR2,
312: p_doc_level_id_tbl IN po_tbl_number,
313: p_override_funds IN VARCHAR2,
314: p_employee_id IN NUMBER,
315: p_use_gl_date IN VARCHAR2,
316: p_override_date IN DATE,