APPS.OKL_FUNDING_PVT dependencies on OKL_FUNDING_CHECKLISTS_UV

Line 2878: from okl_funding_checklists_uv chk

2874: ---------------------------------------------------------------------------------------------------------
2875: CURSOR c_chklst_chk(p_req_id okl_trx_ap_invoices_b.id%type)
2876: IS
2877: select 1
2878: from okl_funding_checklists_uv chk
2879: where fund_req_id = TO_CHAR(p_req_id) -- cklee: 11/04/2004
2880: ;
2881:
2882: ---------------------------------------------------------------------------------------------------------

Line 8930: lp_return_status okl_funding_checklists_uv.FUNCTION_VALIDATE_RSTS%type;

8926: lp_rulv_tbl okl_funding_checklist_pvt.rulv_tbl_type;
8927: lx_rulv_tbl okl_funding_checklist_pvt.rulv_tbl_type;
8928: plsql_block VARCHAR2(500);
8929:
8930: lp_return_status okl_funding_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
8931: lp_fund_rst okl_funding_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
8932: lp_msg_data okl_funding_checklists_uv.FUNCTION_VALIDATE_MSG%type;
8933: l_contract_id okl_funding_checklists_uv.KHR_ID%type;
8934:

Line 8931: lp_fund_rst okl_funding_checklists_uv.FUNCTION_VALIDATE_RSTS%type;

8927: lx_rulv_tbl okl_funding_checklist_pvt.rulv_tbl_type;
8928: plsql_block VARCHAR2(500);
8929:
8930: lp_return_status okl_funding_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
8931: lp_fund_rst okl_funding_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
8932: lp_msg_data okl_funding_checklists_uv.FUNCTION_VALIDATE_MSG%type;
8933: l_contract_id okl_funding_checklists_uv.KHR_ID%type;
8934:
8935: -- get checklist template attributes

Line 8932: lp_msg_data okl_funding_checklists_uv.FUNCTION_VALIDATE_MSG%type;

8928: plsql_block VARCHAR2(500);
8929:
8930: lp_return_status okl_funding_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
8931: lp_fund_rst okl_funding_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
8932: lp_msg_data okl_funding_checklists_uv.FUNCTION_VALIDATE_MSG%type;
8933: l_contract_id okl_funding_checklists_uv.KHR_ID%type;
8934:
8935: -- get checklist template attributes
8936: cursor c_clist_funs (p_fund_req_id varchar2) is

Line 8933: l_contract_id okl_funding_checklists_uv.KHR_ID%type;

8929:
8930: lp_return_status okl_funding_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
8931: lp_fund_rst okl_funding_checklists_uv.FUNCTION_VALIDATE_RSTS%type;
8932: lp_msg_data okl_funding_checklists_uv.FUNCTION_VALIDATE_MSG%type;
8933: l_contract_id okl_funding_checklists_uv.KHR_ID%type;
8934:
8935: -- get checklist template attributes
8936: cursor c_clist_funs (p_fund_req_id varchar2) is
8937: --start modified abhsaxen for performance SQLID 20562504