6199: lp_rulv_tbl okl_credit_checklist_pvt.rulv_tbl_type;
6200: lx_rulv_tbl okl_credit_checklist_pvt.rulv_tbl_type;
6201: plsql_block VARCHAR2(500);
6202:
6203: lp_return_status okl_credit_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
6204: lp_fund_rst okl_credit_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
6205: lp_msg_data okl_credit_checklists_uv.FUNCTION_VALIDATE_MSG%type;
6206:
6207: -- get checklist template attributes
6200: lx_rulv_tbl okl_credit_checklist_pvt.rulv_tbl_type;
6201: plsql_block VARCHAR2(500);
6202:
6203: lp_return_status okl_credit_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
6204: lp_fund_rst okl_credit_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
6205: lp_msg_data okl_credit_checklists_uv.FUNCTION_VALIDATE_MSG%type;
6206:
6207: -- get checklist template attributes
6208: cursor c_clist_funs (p_contract_id number) is
6201: plsql_block VARCHAR2(500);
6202:
6203: lp_return_status okl_credit_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
6204: lp_fund_rst okl_credit_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
6205: lp_msg_data okl_credit_checklists_uv.FUNCTION_VALIDATE_MSG%type;
6206:
6207: -- get checklist template attributes
6208: cursor c_clist_funs (p_contract_id number) is
6209: --start modified abhsaxen for performance SQLID 20562912