/*插入至接口表中*/
  procedure InsertOOMINTERFACE(P_SOE_ORDERNO varchar2,
                               v_retval      out varchar2,
                               v_retmessage  out varchar2) is
    cursor cur_om_header is
    
      select *
        from edu_om_temp_header oth
       where oth.soe_order_no = P_SOE_ORDERNO
         and rownum = 1

create or replace package DEZAICN_COMMON_PAGE is

  type type_cur is ref cursor; --定义游标变量用于返回记录集

  procedure COMMONPAGE(TABLES     VARCHAR2,
                       PK         VARCHAR2,
                       SORT       in out VARCHAR2,
                       PAGENUMBER in out NUMBER,
                       PAGESIZE   NUMBER,
                       FIELDS     VARCHAR2 := '*',
                       FILTER     VARCHAR2 := null,

set serveroutput on
DECLARE
l_header_rec OE_ORDER_PUB.Header_Rec_Type;
l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
l_header_adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_Type;
l_header_scr_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
l_line_scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
l_request_rec OE_ORDER_PUB.Request_Rec_Type ;
l_return_status VARCHAR2(1000);
l_msg_count NUMBER;
l_msg_data VARCHAR2(1000);