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_DEAL_CREAT_PVT dependencies on OKC_K_PARTY_ROLES_V

Line 2246: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;

2242: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
2243: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
2244:
2245: --Bug#5116278 start
2246: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2247: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2248: l_chr_id okc_k_headers_b.id%type := NULL;
2249:
2250: --Bug# 12780638: Removed cust_acct_id and bill_to_site_use_id

Line 2247: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;

2243: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
2244:
2245: --Bug#5116278 start
2246: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2247: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2248: l_chr_id okc_k_headers_b.id%type := NULL;
2249:
2250: --Bug# 12780638: Removed cust_acct_id and bill_to_site_use_id
2251: -- from this cursor as we are not copying

Line 2268: FROM okc_k_party_roles_v cplv

2264: attribute12, attribute13, attribute14,
2265: attribute15, created_by, creation_date,
2266: last_updated_by, last_update_date, last_update_login,
2267: NULL cust_acct_id, NULL bill_to_site_use_id
2268: FROM okc_k_party_roles_v cplv
2269: WHERE cplv.rle_code = G_LEASE_VENDOR
2270: AND cplv.chr_id = p_source_id; -- vendor program id
2271:
2272: --Bug#5116278 end

Line 2550: l_k_cpl_id okc_k_party_roles_v.id%TYPE := NULL;

2546: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2547:
2548: l_rgpr_id NUMBER := NULL;
2549: l_vp_tmpl_id NUMBER;
2550: l_k_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2551: l_k_object1_id1 okc_k_party_roles_v.object1_id1%TYPE := NULL;
2552:
2553: --Cursor to get vp template
2554: CURSOR vp_tmpl_csr(p_vp_id IN NUMBER) IS

Line 2551: l_k_object1_id1 okc_k_party_roles_v.object1_id1%TYPE := NULL;

2547:
2548: l_rgpr_id NUMBER := NULL;
2549: l_vp_tmpl_id NUMBER;
2550: l_k_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2551: l_k_object1_id1 okc_k_party_roles_v.object1_id1%TYPE := NULL;
2552:
2553: --Cursor to get vp template
2554: CURSOR vp_tmpl_csr(p_vp_id IN NUMBER) IS
2555: SELECT id

Line 2586: -- CURSOR c_rg_party_csr(p_cpl_id IN NUMBER, p_object1_id1 IN okc_k_party_roles_v.object1_id1%TYPE) IS

2582: --end modifying abhsaxen Cursor not in use
2583:
2584: --start modifying abhsaxen Cursor not in use
2585:
2586: -- CURSOR c_rg_party_csr(p_cpl_id IN NUMBER, p_object1_id1 IN okc_k_party_roles_v.object1_id1%TYPE) IS
2587: --end modifying abhsaxen Cursor not in use
2588: BEGIN
2589:
2590: OKC_CONTEXT.SET_OKC_ORG_CONTEXT(

Line 2813: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;

2809: lx_rulv_rec Okl_Rule_Pub.rulv_rec_type;
2810: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2811: lx_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2812:
2813: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2814: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2815:
2816: l_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2817: l_rrd_id NUMBER := NULL;

Line 2814: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;

2810: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2811: lx_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2812:
2813: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2814: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2815:
2816: l_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2817: l_rrd_id NUMBER := NULL;
2818: l_vndr_blng_rgp_id NUMBER := NULL;

Line 2816: l_cpl_id okc_k_party_roles_v.id%TYPE := NULL;

2812:
2813: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2814: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2815:
2816: l_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2817: l_rrd_id NUMBER := NULL;
2818: l_vndr_blng_rgp_id NUMBER := NULL;
2819: --start modifying abhsaxen Cursor not in use
2820: -- CURSOR c_lse_vndr_csr IS