APPS.OKL_SEC_AGREEMENT_PVT dependencies on FND_PROFILE

Line 130: l_fnd_profile VARCHAR2(256);

126: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
127: l_msg_count NUMBER;
128: l_msg_data VARCHAR2(2000);
129: l_currency_code okl_txl_cntrct_lns.currency_code%TYPE;
130: l_fnd_profile VARCHAR2(256);
131: l_cust_trx_type_id NUMBER;
132:
133: l_msg_index_out NUMBER; --TBR
134:

Line 136: SELECT mo_global.get_current_org_id() l_fnd_profile

132:
133: l_msg_index_out NUMBER; --TBR
134:
135: CURSOR fnd_pro_csr IS
136: SELECT mo_global.get_current_org_id() l_fnd_profile
137: FROM dual;
138: fnd_pro_rec fnd_pro_csr%ROWTYPE;
139: /*
140: Cursor ra_cust_csr IS

Line 4097: l_approval_process := fnd_profile.value('OKL_IA_ADD_KHR_APPR_PROCESS');

4093: END IF;
4094: -- fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.submit_add_khr_request.debug', 'Okl_Sec_Agreement_Pvt.submit_add_khr_request x_return_status :' || x_return_status);
4095:
4096: -- read the profile OKL: Investor Add Contracts Approval Process
4097: l_approval_process := fnd_profile.value('OKL_IA_ADD_KHR_APPR_PROCESS');
4098:
4099: -- get the pool transaction id which needs to be updated, since we can have only one transaction in 'NEW' status
4100: OPEN c_fetch_pool_trans_id_csr(p_pool_id);
4101: FETCH c_fetch_pool_trans_id_csr into l_pool_trans_id;