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.OKL_SEC_AGREEMENT_PVT dependencies on OKL_POOLS

Line 1043: FROM okl_pools

1039: l_row_found BOOLEAN := FALSE;
1040:
1041: CURSOR c_pool IS
1042: SELECT 'x'
1043: FROM okl_pools
1044: WHERE id = p_secAgreement_rec.pol_id
1045: ;
1046: BEGIN
1047:

Line 1109: FROM okl_pools

1105: l_row_found BOOLEAN := FALSE;
1106:
1107: CURSOR c_pool IS
1108: SELECT 'x'
1109: FROM okl_pools
1110: WHERE khr_id IS NOT NULL
1111: AND id = p_secAgreement_rec.pol_id
1112: ;
1113:

Line 1116: FROM okl_pools

1112: ;
1113:
1114: CURSOR c_pool_upd IS
1115: SELECT 'x'
1116: FROM okl_pools
1117: WHERE khr_id IS NOT NULL
1118: AND id = p_secAgreement_rec.pol_id
1119: AND khr_id <> p_secAgreement_rec.id
1120: ;

Line 1925: -- update okl_pools

1921: --
1922: x_secAgreement_rec.trustee_party_roles_id := lx_cplv_rec.id;
1923:
1924: --
1925: -- update okl_pools
1926: --
1927: l_polv_rec.id := p_secAgreement_rec.pol_id;
1928: l_polv_rec.khr_id := x_secAgreement_rec.ID;
1929:

Line 2004: l_pol_id OKL_POOLS.ID%TYPE;

2000: IS
2001: l_api_name CONSTANT VARCHAR2(30) := 'update_sec_agreement_pvt';
2002: l_api_version CONSTANT NUMBER := 1.0;
2003: i NUMBER;
2004: l_pol_id OKL_POOLS.ID%TYPE;
2005: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2006: lp_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
2007: lx_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
2008:

Line 2024: FROM okl_pools

2020: l_kle_id okc_k_lines_b.id%TYPE;
2021:
2022: CURSOR c_pool_upd IS
2023: SELECT id
2024: FROM okl_pools
2025: WHERE khr_id = p_secAgreement_rec.id
2026: AND id <> p_secAgreement_rec.pol_id
2027: ;
2028:

Line 2275: -- update okl_pools

2271: -- ************************************************************
2272: --
2273:
2274: --
2275: -- update okl_pools
2276: --
2277:
2278: IF (p_secAgreement_rec.pol_id IS NOT NULL AND p_secAgreement_rec.pol_id <> OKL_API.G_MISS_NUM) THEN
2279: -- 1. update khr_id to null if user switch to different pol_id

Line 2497: l_pol_id OKL_POOLS.ID%TYPE;

2493: l_api_name CONSTANT VARCHAR2(30) := 'activate_sec_agreement_pvt';
2494: l_api_version CONSTANT NUMBER := 1.0;
2495: i NUMBER;
2496: l_kle_id OKC_K_LINES_B.ID%TYPE;
2497: l_pol_id OKL_POOLS.ID%TYPE;
2498: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
2499: l_org_id OKL_POOLS.ORG_ID%TYPE;
2500: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
2501: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

Line 2498: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;

2494: l_api_version CONSTANT NUMBER := 1.0;
2495: i NUMBER;
2496: l_kle_id OKC_K_LINES_B.ID%TYPE;
2497: l_pol_id OKL_POOLS.ID%TYPE;
2498: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
2499: l_org_id OKL_POOLS.ORG_ID%TYPE;
2500: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
2501: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
2502:

Line 2499: l_org_id OKL_POOLS.ORG_ID%TYPE;

2495: i NUMBER;
2496: l_kle_id OKC_K_LINES_B.ID%TYPE;
2497: l_pol_id OKL_POOLS.ID%TYPE;
2498: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
2499: l_org_id OKL_POOLS.ORG_ID%TYPE;
2500: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
2501: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
2502:
2503: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;

Line 2500: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;

2496: l_kle_id OKC_K_LINES_B.ID%TYPE;
2497: l_pol_id OKL_POOLS.ID%TYPE;
2498: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
2499: l_org_id OKL_POOLS.ORG_ID%TYPE;
2500: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
2501: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
2502:
2503: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;
2504: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;

Line 2530: FROM okl_pools pol

2526: SELECT pol.id,
2527: pol.currency_code,
2528: pol.org_id,
2529: pol.legal_entity_id
2530: FROM okl_pools pol
2531: WHERE pol.khr_id = p_khr_id
2532: ;
2533:
2534: CURSOR c_poc IS

Line 2561: FROM okl_pools polb

2557: -- mvasudev, 10/29/2003
2558: -- Cursor to check if sty is securitized ">=" effective_date
2559: CURSOR l_okl_sty_csr IS
2560: SELECT 1
2561: FROM okl_pools polb
2562: ,okl_strm_type_b styb
2563: ,okl_pool_contents pocb
2564: WHERE polb.khr_id = p_khr_id
2565: AND pocb.pol_id = polb.id

Line 3302: FROM OKL_POOLS

3298:
3299: CURSOR get_pol_id_csr(p_chr_id NUMBER)
3300: IS
3301: SELECT ID
3302: FROM OKL_POOLS
3303: WHERE KHR_ID = p_chr_id
3304: AND STATUS_CODE = 'ACTIVE';
3305:
3306: l_pol_id NUMBER;

Line 3435: l_pol_id OKL_POOLS.ID%TYPE;

3431: l_api_name CONSTANT VARCHAR2(30) := 'activate_add_request';
3432: l_api_version CONSTANT NUMBER := 1.0;
3433: i NUMBER;
3434: l_kle_id OKC_K_LINES_B.ID%TYPE;
3435: l_pol_id OKL_POOLS.ID%TYPE;
3436: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
3437: l_org_id OKL_POOLS.ORG_ID%TYPE;
3438: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
3439: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

Line 3436: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;

3432: l_api_version CONSTANT NUMBER := 1.0;
3433: i NUMBER;
3434: l_kle_id OKC_K_LINES_B.ID%TYPE;
3435: l_pol_id OKL_POOLS.ID%TYPE;
3436: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
3437: l_org_id OKL_POOLS.ORG_ID%TYPE;
3438: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
3439: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
3440:

Line 3437: l_org_id OKL_POOLS.ORG_ID%TYPE;

3433: i NUMBER;
3434: l_kle_id OKC_K_LINES_B.ID%TYPE;
3435: l_pol_id OKL_POOLS.ID%TYPE;
3436: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
3437: l_org_id OKL_POOLS.ORG_ID%TYPE;
3438: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
3439: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
3440:
3441: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;

Line 3438: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;

3434: l_kle_id OKC_K_LINES_B.ID%TYPE;
3435: l_pol_id OKL_POOLS.ID%TYPE;
3436: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
3437: l_org_id OKL_POOLS.ORG_ID%TYPE;
3438: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
3439: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
3440:
3441: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;
3442: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;

Line 3467: FROM okl_pools pol

3463:
3464: CURSOR c_pool_csr(p_khr_id NUMBER)
3465: IS
3466: SELECT pol.id
3467: FROM okl_pools pol
3468: WHERE pol.khr_id = p_khr_id;
3469:
3470: CURSOR c_pool_chr_csr(p_pol_id NUMBER)
3471: IS

Line 3486: FROM okl_pools polb

3482: -- Cursor to check if sty is securitized ">=" effective_date
3483: CURSOR l_okl_sty_csr(p_khr_id NUMBER)
3484: IS
3485: SELECT 1
3486: FROM okl_pools polb
3487: ,okl_strm_type_b styb
3488: ,okl_pool_contents pocb
3489: WHERE polb.khr_id = p_khr_id
3490: AND pocb.pol_id = polb.id

Line 4045: p_pool_id IN OKL_POOLS.ID%TYPE,

4041: x_return_status OUT NOCOPY VARCHAR2,
4042: x_msg_count OUT NOCOPY NUMBER,
4043: x_msg_data OUT NOCOPY VARCHAR2,
4044: p_agreement_id IN OKC_K_HEADERS_V.ID%TYPE,
4045: p_pool_id IN OKL_POOLS.ID%TYPE,
4046: x_pool_trx_status OUT NOCOPY OKL_POOL_TRANSACTIONS.TRANSACTION_STATUS%TYPE)
4047: IS
4048: -- Get Pool Transaction Details
4049: CURSOR c_fetch_pool_trans_id_csr(p_transaction_id OKL_POOLS.ID%TYPE)

Line 4049: CURSOR c_fetch_pool_trans_id_csr(p_transaction_id OKL_POOLS.ID%TYPE)

4045: p_pool_id IN OKL_POOLS.ID%TYPE,
4046: x_pool_trx_status OUT NOCOPY OKL_POOL_TRANSACTIONS.TRANSACTION_STATUS%TYPE)
4047: IS
4048: -- Get Pool Transaction Details
4049: CURSOR c_fetch_pool_trans_id_csr(p_transaction_id OKL_POOLS.ID%TYPE)
4050: IS
4051: SELECT pox.id
4052: FROM okl_pool_transactions pox
4053: WHERE pox.pol_id = p_pool_id

Line 4062: l_pool_id OKL_POOLS.ID%TYPE;

4058: l_parameter_list wf_parameter_list_t;
4059: l_key VARCHAR2(240);
4060: l_event_name VARCHAR2(240) := 'oracle.apps.okl.ia.approve_add_contracts_request';
4061: l_agreement_id OKC_K_HEADERS_V.ID%TYPE;
4062: l_pool_id OKL_POOLS.ID%TYPE;
4063: l_pool_trans_id OKL_POOL_TRANSACTIONS.ID%TYPE;
4064: lp_poxv_rec poxv_rec_type;
4065: lx_poxv_rec poxv_rec_type;
4066: l_approval_process fnd_lookups.lookup_code%TYPE;

Line 4275: FROM OKL_POOLS

4271:
4272: CURSOR get_pol_id_csr(p_chr_id NUMBER)
4273: IS
4274: SELECT ID
4275: FROM OKL_POOLS
4276: WHERE KHR_ID = p_chr_id
4277: AND STATUS_CODE = 'ACTIVE';
4278:
4279: CURSOR get_pox_id_csr(p_pol_id NUMBER)