150:
151: PROCEDURE restore_working_copy_req(
152: p_origHeaderId IN NUMBER,
153: p_tempHeaderId IN NUMBER,
154: p_origLineIds IN PO_TBL_NUMBER,
155: p_tempLineIds IN PO_TBL_NUMBER,
156: p_origDistIds IN PO_TBL_NUMBER,
157: p_tempDistIds IN PO_TBL_NUMBER,
158: p_origReqSupplierIds IN PO_TBL_NUMBER,
151: PROCEDURE restore_working_copy_req(
152: p_origHeaderId IN NUMBER,
153: p_tempHeaderId IN NUMBER,
154: p_origLineIds IN PO_TBL_NUMBER,
155: p_tempLineIds IN PO_TBL_NUMBER,
156: p_origDistIds IN PO_TBL_NUMBER,
157: p_tempDistIds IN PO_TBL_NUMBER,
158: p_origReqSupplierIds IN PO_TBL_NUMBER,
159: p_tempReqSupplierIds IN PO_TBL_NUMBER,
152: p_origHeaderId IN NUMBER,
153: p_tempHeaderId IN NUMBER,
154: p_origLineIds IN PO_TBL_NUMBER,
155: p_tempLineIds IN PO_TBL_NUMBER,
156: p_origDistIds IN PO_TBL_NUMBER,
157: p_tempDistIds IN PO_TBL_NUMBER,
158: p_origReqSupplierIds IN PO_TBL_NUMBER,
159: p_tempReqSupplierIds IN PO_TBL_NUMBER,
160: p_origPriceDiffIds IN PO_TBL_NUMBER,
153: p_tempHeaderId IN NUMBER,
154: p_origLineIds IN PO_TBL_NUMBER,
155: p_tempLineIds IN PO_TBL_NUMBER,
156: p_origDistIds IN PO_TBL_NUMBER,
157: p_tempDistIds IN PO_TBL_NUMBER,
158: p_origReqSupplierIds IN PO_TBL_NUMBER,
159: p_tempReqSupplierIds IN PO_TBL_NUMBER,
160: p_origPriceDiffIds IN PO_TBL_NUMBER,
161: p_tempPriceDiffIds IN PO_TBL_NUMBER);
154: p_origLineIds IN PO_TBL_NUMBER,
155: p_tempLineIds IN PO_TBL_NUMBER,
156: p_origDistIds IN PO_TBL_NUMBER,
157: p_tempDistIds IN PO_TBL_NUMBER,
158: p_origReqSupplierIds IN PO_TBL_NUMBER,
159: p_tempReqSupplierIds IN PO_TBL_NUMBER,
160: p_origPriceDiffIds IN PO_TBL_NUMBER,
161: p_tempPriceDiffIds IN PO_TBL_NUMBER);
162:
155: p_tempLineIds IN PO_TBL_NUMBER,
156: p_origDistIds IN PO_TBL_NUMBER,
157: p_tempDistIds IN PO_TBL_NUMBER,
158: p_origReqSupplierIds IN PO_TBL_NUMBER,
159: p_tempReqSupplierIds IN PO_TBL_NUMBER,
160: p_origPriceDiffIds IN PO_TBL_NUMBER,
161: p_tempPriceDiffIds IN PO_TBL_NUMBER);
162:
163: FUNCTION submitreq(
156: p_origDistIds IN PO_TBL_NUMBER,
157: p_tempDistIds IN PO_TBL_NUMBER,
158: p_origReqSupplierIds IN PO_TBL_NUMBER,
159: p_tempReqSupplierIds IN PO_TBL_NUMBER,
160: p_origPriceDiffIds IN PO_TBL_NUMBER,
161: p_tempPriceDiffIds IN PO_TBL_NUMBER);
162:
163: FUNCTION submitreq(
164: req_Header_Id IN NUMBER,
157: p_tempDistIds IN PO_TBL_NUMBER,
158: p_origReqSupplierIds IN PO_TBL_NUMBER,
159: p_tempReqSupplierIds IN PO_TBL_NUMBER,
160: p_origPriceDiffIds IN PO_TBL_NUMBER,
161: p_tempPriceDiffIds IN PO_TBL_NUMBER);
162:
163: FUNCTION submitreq(
164: req_Header_Id IN NUMBER,
165: req_num IN varchar2,
282: p_doc_type IN VARCHAR2,
283: p_doc_subtype IN VARCHAR2,
284: p_dist_data IN ICX_ENC_IN_TYPE,
285: p_doc_level IN VARCHAR2,
286: p_doc_level_id_tbl IN po_tbl_number,
287: p_override_funds IN VARCHAR2,
288: p_use_gl_date IN VARCHAR2,
289: p_override_date IN DATE,
290: p_report_successes IN VARCHAR2,
302: x_return_status OUT NOCOPY VARCHAR2,
303: p_doc_type IN VARCHAR2,
304: p_doc_subtype IN VARCHAR2,
305: p_doc_level IN VARCHAR2,
306: p_doc_level_id_tbl IN po_tbl_number,
307: p_prevent_partial_flag IN VARCHAR2,
308: p_employee_id IN NUMBER,
309: p_override_funds IN VARCHAR2,
310: p_report_successes IN VARCHAR2,
322: x_return_status OUT NOCOPY VARCHAR2,
323: p_doc_type IN VARCHAR2,
324: p_doc_subtype IN VARCHAR2,
325: p_doc_level IN VARCHAR2,
326: p_doc_level_id_tbl IN po_tbl_number,
327: p_override_funds IN VARCHAR2,
328: p_employee_id IN NUMBER,
329: p_use_gl_date IN VARCHAR2,
330: p_override_date IN DATE,