3004: ---------------------------------------------------------------------------------------------------------
3005: CURSOR c_chklst_chk(p_req_id okl_trx_ap_invoices_b.id%type)
3006: IS
3007: select 1
3008: from okl_funding_checklists_uv chk
3009: where fund_req_id = TO_CHAR(p_req_id) -- cklee: 11/04/2004
3010: ;
3011:
3012: ---------------------------------------------------------------------------------------------------------
9148: lp_rulv_tbl okl_funding_checklist_pvt.rulv_tbl_type;
9149: lx_rulv_tbl okl_funding_checklist_pvt.rulv_tbl_type;
9150: plsql_block VARCHAR2(500);
9151:
9152: lp_return_status okl_funding_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
9153: lp_fund_rst okl_funding_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
9154: lp_msg_data okl_funding_checklists_uv.FUNCTION_VALIDATE_MSG%type;
9155: l_contract_id okl_funding_checklists_uv.KHR_ID%type;
9156:
9149: lx_rulv_tbl okl_funding_checklist_pvt.rulv_tbl_type;
9150: plsql_block VARCHAR2(500);
9151:
9152: lp_return_status okl_funding_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
9153: lp_fund_rst okl_funding_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
9154: lp_msg_data okl_funding_checklists_uv.FUNCTION_VALIDATE_MSG%type;
9155: l_contract_id okl_funding_checklists_uv.KHR_ID%type;
9156:
9157: -- get checklist template attributes
9150: plsql_block VARCHAR2(500);
9151:
9152: lp_return_status okl_funding_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
9153: lp_fund_rst okl_funding_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
9154: lp_msg_data okl_funding_checklists_uv.FUNCTION_VALIDATE_MSG%type;
9155: l_contract_id okl_funding_checklists_uv.KHR_ID%type;
9156:
9157: -- get checklist template attributes
9158: cursor c_clist_funs (p_fund_req_id varchar2) is
9151:
9152: lp_return_status okl_funding_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
9153: lp_fund_rst okl_funding_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
9154: lp_msg_data okl_funding_checklists_uv.FUNCTION_VALIDATE_MSG%type;
9155: l_contract_id okl_funding_checklists_uv.KHR_ID%type;
9156:
9157: -- get checklist template attributes
9158: cursor c_clist_funs (p_fund_req_id varchar2) is
9159: --start modified abhsaxen for performance SQLID 20562504