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: CURSOR c_vp_cpl_csr(p_source_id NUMBER) IS

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: CURSOR c_vp_cpl_csr(p_source_id NUMBER) IS
2251: SELECT id, object_version_number, sfwt_flag,

Line 2265: FROM okc_k_party_roles_v cplv

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

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

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

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

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

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

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

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

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

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

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

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

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