eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_FEE_ENGINE_W SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 603


  procedure updatefeeschedule(p_init_msg_list  VARCHAR2
    , p_commit  VARCHAR2
    , p_loan_id  NUMBER
    , p3_a0 JTF_NUMBER_TABLE
    , p3_a1 JTF_VARCHAR2_TABLE_100
    , p3_a2 JTF_VARCHAR2_TABLE_100
    , p3_a3 JTF_VARCHAR2_TABLE_100
    , p3_a4 JTF_NUMBER_TABLE
    , p3_a5 JTF_NUMBER_TABLE
    , p3_a6 JTF_VARCHAR2_TABLE_300
    , p3_a7 JTF_NUMBER_TABLE
    , p3_a8 JTF_VARCHAR2_TABLE_100
    , p3_a9 JTF_VARCHAR2_TABLE_100
    , p3_a10 JTF_VARCHAR2_TABLE_100
    , p3_a11 JTF_NUMBER_TABLE
    , p3_a12 JTF_VARCHAR2_TABLE_100
    , p3_a13 JTF_VARCHAR2_TABLE_100
    , p3_a14 JTF_NUMBER_TABLE
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_fees_tbl lns_fee_engine.fee_calc_tbl;

Line: 656


    lns_fee_engine.updatefeeschedule(p_init_msg_list,
      p_commit,
      p_loan_id,
      ddp_fees_tbl,
      x_return_status,
      x_msg_count,
      x_msg_data);