[Home] [Help]
1343: END IF;
1344: RETURN(x_return_status);
1345: END get_rec_itiv;
1346: -----------------------------------------------------------------------------------------------------
1347: FUNCTION get_rec_cplv(p_cplv_id IN OKC_K_PARTY_ROLES_B.ID%TYPE,
1348: x_cplv_rec OUT NOCOPY cplv_rec_type)
1349: RETURN VARCHAR2 IS
1350: CURSOR okc_cplv_pk_csr (p_cplv_id OKC_K_PARTY_ROLES_B.ID%TYPE) IS
1351: SELECT ID,
1346: -----------------------------------------------------------------------------------------------------
1347: FUNCTION get_rec_cplv(p_cplv_id IN OKC_K_PARTY_ROLES_B.ID%TYPE,
1348: x_cplv_rec OUT NOCOPY cplv_rec_type)
1349: RETURN VARCHAR2 IS
1350: CURSOR okc_cplv_pk_csr (p_cplv_id OKC_K_PARTY_ROLES_B.ID%TYPE) IS
1351: SELECT ID,
1352: OBJECT_VERSION_NUMBER,
1353: SFWT_FLAG,
1354: CPL_ID,
11778: l_cplv_rec.chr_id := null;
11779: -- Creation of Party Item Record for the above record information
11780: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
11781: -- to create records in tables
11782: -- okc_k_party_roles_b and okl_k_party_roles
11783: /*
11784: OKL_OKC_MIGRATION_PVT.create_k_party_role(p_api_version => p_api_version,
11785: p_init_msg_list => p_init_msg_list,
11786: x_return_status => x_return_status,
11969: l_cplv_rec.object1_id2 := p_cplv_rec.object1_id2;
11970: -- Creation of Party Item Record for the above record information
11971: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
11972: -- to update records in tables
11973: -- okc_k_party_roles_b and okl_k_party_roles
11974: /*
11975: OKL_OKC_MIGRATION_PVT.update_k_party_role(p_api_version => p_api_version,
11976: p_init_msg_list => p_init_msg_list,
11977: x_return_status => x_return_status,
12590: --cursor to get party roles attached to copied line
12591: CURSOR l_cpl_csr (p_cle_id in number,
12592: p_chr_id in number) IS
12593: select cplb.id
12594: from okc_k_party_roles_b cplb
12595: where cle_id = p_cle_id
12596: and dnz_chr_id = p_chr_id;
12597:
12598: l_cpl_id OKC_K_PARTY_ROLES_B.ID%TYPE;
12594: from okc_k_party_roles_b cplb
12595: where cle_id = p_cle_id
12596: and dnz_chr_id = p_chr_id;
12597:
12598: l_cpl_id OKC_K_PARTY_ROLES_B.ID%TYPE;
12599: l_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
12600:
12601:
12602: --cursor to get supplier invoice details
13108: --delete cplv rec
13109: l_cplv_rec.id := l_cpl_id;
13110: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
13111: -- to delete records in tables
13112: -- okc_k_party_roles_b and okl_k_party_roles
13113: /*
13114: OKL_OKC_MIGRATION_PVT.delete_k_party_role
13115: ( p_api_version => p_api_version,
13116: p_init_msg_list => p_init_msg_list,
13562: CURSOR l_cpl_csr (p_orig_cle_id in number,
13563: p_chr_id in number) is
13564: SELECT cplb.id,
13565: cplb.rle_code
13566: FROM okc_k_party_roles_b cplb
13567: WHERE cplb.cle_id = p_orig_cle_id
13568: AND cplb.dnz_chr_id = p_chr_id;
13569:
13570: l_cpl_rec l_cpl_csr%ROWTYPE;
13567: WHERE cplb.cle_id = p_orig_cle_id
13568: AND cplb.dnz_chr_id = p_chr_id;
13569:
13570: l_cpl_rec l_cpl_csr%ROWTYPE;
13571: lx_cpl_id OKC_K_PARTY_ROLES_B.ID%TYPE;
13572:
13573: --cursor to get any covered asset lines where old line was referenced
13574: CURSOR l_lnk_ast_csr (p_orig_cle_id in NUMBER,
13575: p_chr_id in NUMBER) is
13654: from
13655: okl_subsidies_b subb,
13656: okl_subsidies_tl subt,
13657: po_vendors pov,
13658: okc_k_party_roles_b sub_cplb,
13659: okl_k_lines sub_kle,
13660: okc_k_lines_b sub_cleb,
13661: okc_line_styles_b sub_lseb
13662: where subt.id = subb.id