create or replace package n_pk_lnnpl as
  function of_getcollmast (av_coopid varchar2, av_contno varchar2) return varchar2;
  function of_getpaystmt(av_coopid varchar2, av_contno varchar2, an_return number, an_mm number, an_yyyy number) return number;
  function of_diff_year_month(ld_date1 date, ld_date2 date) return number;
  function of_diff_year_month_thai(ld_date1 date, ld_date2 date) return varchar2;
  function of_getadvance_div(av_coopid varchar2, av_membno varchar2, an_followseq number) return number;
  function of_r_sum_mortgage_price(av_coopid varchar2, av_membno varchar2, an_lawtype number) return number;
  function of_r_sum_mortgage_all(av_coopid varchar2, av_lawtypes varchar2) return number;
end n_pk_lnnpl;