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 1917: -- update okl_pools

1913: --
1914: x_secAgreement_rec.trustee_party_roles_id := lx_cplv_rec.id;
1915:
1916: --
1917: -- update okl_pools
1918: --
1919: l_polv_rec.id := p_secAgreement_rec.pol_id;
1920: l_polv_rec.khr_id := x_secAgreement_rec.ID;
1921:

Line 1996: l_pol_id OKL_POOLS.ID%TYPE;

1992: IS
1993: l_api_name CONSTANT VARCHAR2(30) := 'update_sec_agreement_pvt';
1994: l_api_version CONSTANT NUMBER := 1.0;
1995: i NUMBER;
1996: l_pol_id OKL_POOLS.ID%TYPE;
1997: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1998: lp_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1999: lx_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
2000:

Line 2016: FROM okl_pools

2012: l_kle_id okc_k_lines_b.id%TYPE;
2013:
2014: CURSOR c_pool_upd IS
2015: SELECT id
2016: FROM okl_pools
2017: WHERE khr_id = p_secAgreement_rec.id
2018: AND id <> p_secAgreement_rec.pol_id
2019: ;
2020:

Line 2258: -- update okl_pools

2254: -- ************************************************************
2255: --
2256:
2257: --
2258: -- update okl_pools
2259: --
2260:
2261: IF (p_secAgreement_rec.pol_id IS NOT NULL AND p_secAgreement_rec.pol_id <> OKL_API.G_MISS_NUM) THEN
2262: -- 1. update khr_id to null if user switch to different pol_id

Line 2480: l_pol_id OKL_POOLS.ID%TYPE;

2476: l_api_name CONSTANT VARCHAR2(30) := 'activate_sec_agreement_pvt';
2477: l_api_version CONSTANT NUMBER := 1.0;
2478: i NUMBER;
2479: l_kle_id OKC_K_LINES_B.ID%TYPE;
2480: l_pol_id OKL_POOLS.ID%TYPE;
2481: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
2482: l_org_id OKL_POOLS.ORG_ID%TYPE;
2483: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
2484: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

Line 2481: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;

2477: l_api_version CONSTANT NUMBER := 1.0;
2478: i NUMBER;
2479: l_kle_id OKC_K_LINES_B.ID%TYPE;
2480: l_pol_id OKL_POOLS.ID%TYPE;
2481: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
2482: l_org_id OKL_POOLS.ORG_ID%TYPE;
2483: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
2484: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
2485:

Line 2482: l_org_id OKL_POOLS.ORG_ID%TYPE;

2478: i NUMBER;
2479: l_kle_id OKC_K_LINES_B.ID%TYPE;
2480: l_pol_id OKL_POOLS.ID%TYPE;
2481: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
2482: l_org_id OKL_POOLS.ORG_ID%TYPE;
2483: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
2484: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
2485:
2486: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;

Line 2483: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;

2479: l_kle_id OKC_K_LINES_B.ID%TYPE;
2480: l_pol_id OKL_POOLS.ID%TYPE;
2481: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
2482: l_org_id OKL_POOLS.ORG_ID%TYPE;
2483: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
2484: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
2485:
2486: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;
2487: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;

Line 2513: FROM okl_pools pol

2509: SELECT pol.id,
2510: pol.currency_code,
2511: pol.org_id,
2512: pol.legal_entity_id
2513: FROM okl_pools pol
2514: WHERE pol.khr_id = p_khr_id
2515: ;
2516:
2517: CURSOR c_poc IS

Line 2544: FROM okl_pools polb

2540: -- mvasudev, 10/29/2003
2541: -- Cursor to check if sty is securitized ">=" effective_date
2542: CURSOR l_okl_sty_csr IS
2543: SELECT 1
2544: FROM okl_pools polb
2545: ,okl_strm_type_b styb
2546: ,okl_pool_contents pocb
2547: WHERE polb.khr_id = p_khr_id
2548: AND pocb.pol_id = polb.id

Line 3285: FROM OKL_POOLS

3281:
3282: CURSOR get_pol_id_csr(p_chr_id NUMBER)
3283: IS
3284: SELECT ID
3285: FROM OKL_POOLS
3286: WHERE KHR_ID = p_chr_id
3287: AND STATUS_CODE = 'ACTIVE';
3288:
3289: l_pol_id NUMBER;

Line 3418: l_pol_id OKL_POOLS.ID%TYPE;

3414: l_api_name CONSTANT VARCHAR2(30) := 'activate_add_request';
3415: l_api_version CONSTANT NUMBER := 1.0;
3416: i NUMBER;
3417: l_kle_id OKC_K_LINES_B.ID%TYPE;
3418: l_pol_id OKL_POOLS.ID%TYPE;
3419: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
3420: l_org_id OKL_POOLS.ORG_ID%TYPE;
3421: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
3422: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

Line 3419: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;

3415: l_api_version CONSTANT NUMBER := 1.0;
3416: i NUMBER;
3417: l_kle_id OKC_K_LINES_B.ID%TYPE;
3418: l_pol_id OKL_POOLS.ID%TYPE;
3419: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
3420: l_org_id OKL_POOLS.ORG_ID%TYPE;
3421: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
3422: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
3423:

Line 3420: l_org_id OKL_POOLS.ORG_ID%TYPE;

3416: i NUMBER;
3417: l_kle_id OKC_K_LINES_B.ID%TYPE;
3418: l_pol_id OKL_POOLS.ID%TYPE;
3419: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
3420: l_org_id OKL_POOLS.ORG_ID%TYPE;
3421: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
3422: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
3423:
3424: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;

Line 3421: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;

3417: l_kle_id OKC_K_LINES_B.ID%TYPE;
3418: l_pol_id OKL_POOLS.ID%TYPE;
3419: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
3420: l_org_id OKL_POOLS.ORG_ID%TYPE;
3421: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
3422: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
3423:
3424: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;
3425: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;

Line 3450: FROM okl_pools pol

3446:
3447: CURSOR c_pool_csr(p_khr_id NUMBER)
3448: IS
3449: SELECT pol.id
3450: FROM okl_pools pol
3451: WHERE pol.khr_id = p_khr_id;
3452:
3453: CURSOR c_pool_chr_csr(p_pol_id NUMBER)
3454: IS

Line 3469: FROM okl_pools polb

3465: -- Cursor to check if sty is securitized ">=" effective_date
3466: CURSOR l_okl_sty_csr(p_khr_id NUMBER)
3467: IS
3468: SELECT 1
3469: FROM okl_pools polb
3470: ,okl_strm_type_b styb
3471: ,okl_pool_contents pocb
3472: WHERE polb.khr_id = p_khr_id
3473: AND pocb.pol_id = polb.id

Line 4028: p_pool_id IN OKL_POOLS.ID%TYPE,

4024: x_return_status OUT NOCOPY VARCHAR2,
4025: x_msg_count OUT NOCOPY NUMBER,
4026: x_msg_data OUT NOCOPY VARCHAR2,
4027: p_agreement_id IN OKC_K_HEADERS_V.ID%TYPE,
4028: p_pool_id IN OKL_POOLS.ID%TYPE,
4029: x_pool_trx_status OUT NOCOPY OKL_POOL_TRANSACTIONS.TRANSACTION_STATUS%TYPE)
4030: IS
4031: -- Get Pool Transaction Details
4032: CURSOR c_fetch_pool_trans_id_csr(p_transaction_id OKL_POOLS.ID%TYPE)

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

4028: p_pool_id IN OKL_POOLS.ID%TYPE,
4029: x_pool_trx_status OUT NOCOPY OKL_POOL_TRANSACTIONS.TRANSACTION_STATUS%TYPE)
4030: IS
4031: -- Get Pool Transaction Details
4032: CURSOR c_fetch_pool_trans_id_csr(p_transaction_id OKL_POOLS.ID%TYPE)
4033: IS
4034: SELECT pox.id
4035: FROM okl_pool_transactions pox
4036: WHERE pox.pol_id = p_pool_id

Line 4045: l_pool_id OKL_POOLS.ID%TYPE;

4041: l_parameter_list wf_parameter_list_t;
4042: l_key VARCHAR2(240);
4043: l_event_name VARCHAR2(240) := 'oracle.apps.okl.ia.approve_add_contracts_request';
4044: l_agreement_id OKC_K_HEADERS_V.ID%TYPE;
4045: l_pool_id OKL_POOLS.ID%TYPE;
4046: l_pool_trans_id OKL_POOL_TRANSACTIONS.ID%TYPE;
4047: lp_poxv_rec poxv_rec_type;
4048: lx_poxv_rec poxv_rec_type;
4049: l_approval_process fnd_lookups.lookup_code%TYPE;

Line 4247: FROM OKL_POOLS

4243:
4244: CURSOR get_pol_id_csr(p_chr_id NUMBER)
4245: IS
4246: SELECT ID
4247: FROM OKL_POOLS
4248: WHERE KHR_ID = p_chr_id
4249: AND STATUS_CODE = 'ACTIVE';
4250:
4251: CURSOR get_pox_id_csr(p_pol_id NUMBER)