APPS.OKL_DEAL_CREATE_PUB dependencies on OKC_K_PARTY_ROLES_V

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

2243: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
2244: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
2245:
2246: --Bug#5116278 start
2247: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2248: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2249: l_chr_id okc_k_headers_b.id%type := NULL;
2250:
2251: CURSOR c_vp_cpl_csr(p_source_id NUMBER) IS

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

2244: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
2245:
2246: --Bug#5116278 start
2247: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2248: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2249: l_chr_id okc_k_headers_b.id%type := NULL;
2250:
2251: CURSOR c_vp_cpl_csr(p_source_id NUMBER) IS
2252: SELECT id, object_version_number, sfwt_flag,

Line 2266: FROM okc_k_party_roles_v cplv

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

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

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

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

2546:
2547: l_rgpr_id NUMBER := NULL;
2548: l_vp_tmpl_id NUMBER;
2549: l_k_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2550: l_k_object1_id1 okc_k_party_roles_v.object1_id1%TYPE := NULL;
2551:
2552: --Cursor to get vp template
2553: CURSOR vp_tmpl_csr(p_vp_id IN NUMBER) IS
2554: /* Modified this query to improve performance for bug#6979120

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

2590: --end modifying abhsaxen Cursor not in use
2591:
2592: --start modifying abhsaxen Cursor not in use
2593:
2594: -- CURSOR c_rg_party_csr(p_cpl_id IN NUMBER, p_object1_id1 IN okc_k_party_roles_v.object1_id1%TYPE) IS
2595: --end modifying abhsaxen Cursor not in use
2596: BEGIN
2597:
2598: OKC_CONTEXT.SET_OKC_ORG_CONTEXT(

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

2826: lx_rulv_rec Okl_Rule_Pub.rulv_rec_type;
2827: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2828: lx_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2829:
2830: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2831: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2832:
2833: l_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2834: l_rrd_id NUMBER := NULL;

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

2827: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2828: lx_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2829:
2830: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2831: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2832:
2833: l_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2834: l_rrd_id NUMBER := NULL;
2835: l_vndr_blng_rgp_id NUMBER := NULL;

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

2829:
2830: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2831: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2832:
2833: l_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2834: l_rrd_id NUMBER := NULL;
2835: l_vndr_blng_rgp_id NUMBER := NULL;
2836: --start modifying abhsaxen Cursor not in use
2837: -- CURSOR c_lse_vndr_csr IS