13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
16:
17: SUBTYPE rgpv_rec_type IS OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
18: SUBTYPE rulv_rec_type IS Okl_Rule_Pub.rulv_rec_type;
19: SUBTYPE rulv_tbl_type IS Okl_Rule_Pub.rulv_tbl_type;
20: SUBTYPE chrv_rec_type IS OKL_OKC_MIGRATION_PVT.chrv_rec_type;
21: SUBTYPE khrv_rec_type IS OKL_CONTRACT_PUB.khrv_rec_type;
16:
17: SUBTYPE rgpv_rec_type IS OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
18: SUBTYPE rulv_rec_type IS Okl_Rule_Pub.rulv_rec_type;
19: SUBTYPE rulv_tbl_type IS Okl_Rule_Pub.rulv_tbl_type;
20: SUBTYPE chrv_rec_type IS OKL_OKC_MIGRATION_PVT.chrv_rec_type;
21: SUBTYPE khrv_rec_type IS OKL_CONTRACT_PUB.khrv_rec_type;
22:
23: /*
24: -- mvasudev, 08/17/2004
439: l_end_date OKL_K_HEADERS_FULL_V.END_DATE%TYPE DEFAULT NULL;
440: l_start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE DEFAULT NULL;
441: l_term_duration OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE DEFAULT NULL;
442:
443: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
444: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
445: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
446: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
447:
440: l_start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE DEFAULT NULL;
441: l_term_duration OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE DEFAULT NULL;
442:
443: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
444: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
445: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
446: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
447:
448: CURSOR get_k_start_date_and_term_csr(l_chr_id NUMBER) IS
1140: p_contract_number IN VARCHAR2,
1141: p_source_chr_id IN NUMBER,
1142: x_chr_id OUT NOCOPY NUMBER) AS
1143:
1144: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1145: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1146: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1147: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1148:
1141: p_source_chr_id IN NUMBER,
1142: x_chr_id OUT NOCOPY NUMBER) AS
1143:
1144: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1145: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1146: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1147: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1148:
1149: lp_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1237: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE := NULL;
1238: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE := NULL;
1239: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE := NULL;
1240:
1241: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
1242: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
1243:
1244: BEGIN
1245:
1238: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE := NULL;
1239: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE := NULL;
1240:
1241: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
1242: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
1243:
1244: BEGIN
1245:
1246: -- read hdr info from the quote contract and create a lease contract
1364: lp_mla_gvev_rec.chr_id := l_chr_id;
1365: lp_mla_gvev_rec.chr_id_referred := l_mla_gvr_chr_id_referred;
1366: lp_mla_gvev_rec.copied_only_yn := 'N';
1367:
1368: OKL_OKC_MIGRATION_PVT.create_governance(
1369: p_api_version => p_api_version,
1370: p_init_msg_list => p_init_msg_list,
1371: x_return_status => x_return_status,
1372: x_msg_count => x_msg_count,
1564: p_contract_number IN VARCHAR2,
1565: p_source_chr_id IN NUMBER,
1566: x_chr_id OUT NOCOPY NUMBER) AS
1567:
1568: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1569: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1570: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1571: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1572:
1565: p_source_chr_id IN NUMBER,
1566: x_chr_id OUT NOCOPY NUMBER) AS
1567:
1568: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1569: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1570: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1571: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1572:
1573: BEGIN
1613: p_source_object_code IN VARCHAR2,
1614: p_source_chr_id IN NUMBER,
1615: x_chr_id OUT NOCOPY NUMBER) AS
1616:
1617: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1618: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1619: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1620: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1621:
1614: p_source_chr_id IN NUMBER,
1615: x_chr_id OUT NOCOPY NUMBER) AS
1616:
1617: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1618: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1619: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1620: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1621:
1622: p_chr_id NUMBER;
1669: x_chr_id OUT NOCOPY NUMBER,
1670: --Added by dpsingh for LE Uptake
1671: p_legal_entity_id IN NUMBER) AS
1672:
1673: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1674: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1675: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1676: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1677:
1670: --Added by dpsingh for LE Uptake
1671: p_legal_entity_id IN NUMBER) AS
1672:
1673: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1674: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1675: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1676: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1677:
1678: --Bug# 4558486
1678: --Bug# 4558486
1679: lp_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1680: lx_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1681:
1682: lp_cplv_rec1 OKL_OKC_MIGRATION_PVT.cplv_rec_type;
1683: lx_cplv_rec1 OKL_OKC_MIGRATION_PVT.cplv_rec_type;
1684:
1685: l_api_version CONSTANT NUMBER := 1.0;
1686: l_api_name VARCHAR2(30) := 'CREATE_NEW_DEAL';
1679: lp_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1680: lx_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1681:
1682: lp_cplv_rec1 OKL_OKC_MIGRATION_PVT.cplv_rec_type;
1683: lx_cplv_rec1 OKL_OKC_MIGRATION_PVT.cplv_rec_type;
1684:
1685: l_api_version CONSTANT NUMBER := 1.0;
1686: l_api_name VARCHAR2(30) := 'CREATE_NEW_DEAL';
1687:
1920: x_chr_id OUT NOCOPY NUMBER,
1921: --Added by dpsingh for LE Uptake
1922: p_legal_entity_id IN NUMBER) AS
1923:
1924: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1925: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1926: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1927: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1928:
1921: --Added by dpsingh for LE Uptake
1922: p_legal_entity_id IN NUMBER) AS
1923:
1924: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1925: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1926: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1927: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1928:
1929: --Bug# 4558486
1926: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1927: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1928:
1929: --Bug# 4558486
1930: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
1931: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
1932:
1933: l_api_version CONSTANT NUMBER := 1.0;
1934: l_api_name VARCHAR2(30) := 'CREATE_NEW_DEAL';
1927: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1928:
1929: --Bug# 4558486
1930: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
1931: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
1932:
1933: l_api_version CONSTANT NUMBER := 1.0;
1934: l_api_name VARCHAR2(30) := 'CREATE_NEW_DEAL';
1935:
2195: --Added by dpsingh for LE Uptake
2196: p_legal_entity_id IN NUMBER) AS
2197:
2198: -- 5116278
2199: SUBTYPE l_cplv_tbl_type is OKL_OKC_MIGRATION_PVT.cplv_tbl_type;
2200: SUBTYPE l_kplv_tbl_type is okl_kpl_pvt.kplv_tbl_type;
2201:
2202: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2203: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2198: -- 5116278
2199: SUBTYPE l_cplv_tbl_type is OKL_OKC_MIGRATION_PVT.cplv_tbl_type;
2200: SUBTYPE l_kplv_tbl_type is okl_kpl_pvt.kplv_tbl_type;
2201:
2202: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2203: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2204: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2205: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2206:
2199: SUBTYPE l_cplv_tbl_type is OKL_OKC_MIGRATION_PVT.cplv_tbl_type;
2200: SUBTYPE l_kplv_tbl_type is okl_kpl_pvt.kplv_tbl_type;
2201:
2202: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2203: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2204: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2205: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2206:
2207: --Bug# 4558486
2204: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2205: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2206:
2207: --Bug# 4558486
2208: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
2209: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
2210:
2211: -- 5116278
2212: l_cplv_tbl l_cplv_tbl_type;
2205: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2206:
2207: --Bug# 4558486
2208: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
2209: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
2210:
2211: -- 5116278
2212: l_cplv_tbl l_cplv_tbl_type;
2213: l_kplv_tbl l_kplv_tbl_type;
2543: l_api_version CONSTANT NUMBER := 1.0;
2544:
2545: lp_rgpv_rec Okl_Rule_Pub.rgpv_rec_type;
2546:
2547: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
2548: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2549:
2550: l_rgpr_id NUMBER := NULL;
2551: l_vp_tmpl_id NUMBER;
2544:
2545: lp_rgpv_rec Okl_Rule_Pub.rgpv_rec_type;
2546:
2547: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
2548: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2549:
2550: l_rgpr_id NUMBER := NULL;
2551: l_vp_tmpl_id NUMBER;
2552: l_k_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2826: rul_seg_rec c_rule_segmnts_csr%ROWTYPE;
2827:
2828: lp_rulv_rec Okl_Rule_Pub.rulv_rec_type;
2829: lx_rulv_rec Okl_Rule_Pub.rulv_rec_type;
2830: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2831: lx_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2832:
2833: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2834: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2827:
2828: lp_rulv_rec Okl_Rule_Pub.rulv_rec_type;
2829: lx_rulv_rec Okl_Rule_Pub.rulv_rec_type;
2830: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2831: lx_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2832:
2833: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2834: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2835:
3545: p_contract_number IN VARCHAR2,
3546: p_source_chr_id IN NUMBER,
3547: x_chr_id OUT NOCOPY NUMBER) AS
3548:
3549: x_new_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3550: x_new_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3551: l_old_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
3552: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
3553: l_value VARCHAR2(1) := OKL_API.G_FALSE;
4202: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4203:
4204: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4205:
4206: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4207: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4208: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4209: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4210:
4203:
4204: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4205:
4206: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4207: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4208: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4209: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4210:
4211: /*
4837: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4838:
4839: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4840:
4841: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4842: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4843: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4844: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4845:
4838:
4839: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4840:
4841: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4842: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4843: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4844: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4845:
4846: /*
5806:
5807: l_auth_org_id okc_k_headers_b.authoring_org_id%type;
5808: l_inv_org_id okc_k_headers_b.inv_organization_id%type;
5809:
5810: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5811: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5812:
5813: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5814: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5807: l_auth_org_id okc_k_headers_b.authoring_org_id%type;
5808: l_inv_org_id okc_k_headers_b.inv_organization_id%type;
5809:
5810: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5811: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5812:
5813: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5814: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5815:
5812:
5813: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5814: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5815:
5816: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5817: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5818:
5819: lp_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
5820: lp_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
5813: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5814: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5815:
5816: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5817: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5818:
5819: lp_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
5820: lp_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
5821: lx_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
5820: lp_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
5821: lx_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
5822: lx_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
5823:
5824: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5825: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5826:
5827: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5828: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5821: lx_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
5822: lx_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
5823:
5824: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5825: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5826:
5827: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5828: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5829:
5823:
5824: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5825: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5826:
5827: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5828: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5829:
5830: X_NO_DATA_FOUND BOOLEAN := TRUE;
5831:
5824: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5825: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5826:
5827: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5828: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5829:
5830: X_NO_DATA_FOUND BOOLEAN := TRUE;
5831:
5832: --Bug# 4558486
6119: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
6120: -- to update records in tables
6121: -- okc_k_party_roles_b and okl_k_party_roles
6122: /*
6123: OKL_OKC_MIGRATION_PVT.update_k_party_role(
6124: p_api_version => p_api_version,
6125: p_init_msg_list => p_init_msg_list,
6126: x_return_status => x_return_status,
6127: x_msg_count => x_msg_count,
6156: lp_mla_gvev_rec.chr_id := p_chr_id;
6157: lp_mla_gvev_rec.chr_id_referred := l_mla_id;
6158: lp_mla_gvev_rec.copied_only_yn := 'N';
6159:
6160: OKL_OKC_MIGRATION_PVT.create_governance(
6161: p_api_version => p_api_version,
6162: p_init_msg_list => p_init_msg_list,
6163: x_return_status => x_return_status,
6164: x_msg_count => x_msg_count,
6179: lp_mla_gvev_rec.chr_id := p_chr_id;
6180: lp_mla_gvev_rec.chr_id_referred := l_mla_id;
6181: lp_mla_gvev_rec.copied_only_yn := 'N';
6182:
6183: OKL_OKC_MIGRATION_PVT.update_governance(
6184: p_api_version => p_api_version,
6185: p_init_msg_list => p_init_msg_list,
6186: x_return_status => x_return_status,
6187: x_msg_count => x_msg_count,
6199: ELSIF (p_gvr_id_mla IS NOT NULL AND p_mla_no IS NULL ) THEN
6200:
6201: lp_mla_gvev_rec.id := p_gvr_id_mla;
6202:
6203: OKL_OKC_MIGRATION_PVT.delete_governance(
6204: p_api_version => p_api_version,
6205: p_init_msg_list => p_init_msg_list,
6206: x_return_status => x_return_status,
6207: x_msg_count => x_msg_count,
6228: lp_cl_gvev_rec.chr_id := p_chr_id;
6229: lp_cl_gvev_rec.chr_id_referred := l_cl_id;
6230: lp_cl_gvev_rec.copied_only_yn := 'N';
6231:
6232: OKL_OKC_MIGRATION_PVT.create_governance(
6233: p_api_version => p_api_version,
6234: p_init_msg_list => p_init_msg_list,
6235: x_return_status => x_return_status,
6236: x_msg_count => x_msg_count,
6251: lp_cl_gvev_rec.chr_id := p_chr_id;
6252: lp_cl_gvev_rec.chr_id_referred := l_cl_id;
6253: lp_cl_gvev_rec.copied_only_yn := 'N';
6254:
6255: OKL_OKC_MIGRATION_PVT.update_governance(
6256: p_api_version => p_api_version,
6257: p_init_msg_list => p_init_msg_list,
6258: x_return_status => x_return_status,
6259: x_msg_count => x_msg_count,
6270: ELSIF (p_gvr_id_cl IS NOT NULL AND p_cl_no IS NULL ) THEN
6271:
6272: lp_cl_gvev_rec.id := p_gvr_id_cl;
6273:
6274: OKL_OKC_MIGRATION_PVT.delete_governance(
6275: p_api_version => p_api_version,
6276: p_init_msg_list => p_init_msg_list,
6277: x_return_status => x_return_status,
6278: x_msg_count => x_msg_count,
6481: SELECT vers.major_version||'.'||vers.minor_version
6482: FROM okc_k_vers_numbers_v vers
6483: WHERE vers.chr_id = p_durv_rec.chr_id;
6484:
6485: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
6486: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
6487:
6488: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6489: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6482: FROM okc_k_vers_numbers_v vers
6483: WHERE vers.chr_id = p_durv_rec.chr_id;
6484:
6485: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
6486: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
6487:
6488: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6489: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6490:
6487:
6488: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6489: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6490:
6491: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6492: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6493:
6494: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6495: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6488: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6489: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6490:
6491: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6492: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6493:
6494: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6495: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6496: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6490:
6491: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6492: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6493:
6494: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6495: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6496: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6497: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6498:
6491: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6492: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6493:
6494: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6495: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6496: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6497: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6498:
6499: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6492: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6493:
6494: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6495: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6496: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6497: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6498:
6499: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6500: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6493:
6494: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6495: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6496: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6497: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6498:
6499: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6500: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6501:
6495: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6496: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6497: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6498:
6499: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6500: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6501:
6502: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6503: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6496: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6497: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6498:
6499: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6500: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6501:
6502: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6503: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6504:
6498:
6499: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6500: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6501:
6502: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6503: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6504:
6505: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6506: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6499: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6500: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6501:
6502: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6503: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6504:
6505: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6506: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6507: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6501:
6502: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6503: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6504:
6505: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6506: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6507: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6508: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6509:
6502: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6503: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6504:
6505: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6506: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6507: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6508: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6509:
6510: lp_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6506: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6507: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6508: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6509:
6510: lp_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6511: lx_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6512: lp_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6513: lx_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6514:
6507: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6508: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6509:
6510: lp_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6511: lx_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6512: lp_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6513: lx_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6514:
6515: lp_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6511: lx_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6512: lp_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6513: lx_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6514:
6515: lp_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6516: lx_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6517: lp_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6518: lx_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6519:
6512: lp_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6513: lx_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6514:
6515: lp_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6516: lx_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6517: lp_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6518: lx_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6519:
6520: lp_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6516: lx_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6517: lp_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6518: lx_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6519:
6520: lp_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6521: lx_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6522: lp_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6523: lx_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6524:
6517: lp_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6518: lx_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6519:
6520: lp_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6521: lx_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6522: lp_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6523: lx_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6524:
6525: lp_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6521: lx_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6522: lp_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6523: lx_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6524:
6525: lp_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6526: lx_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6527: lp_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6528: lx_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6529:
6522: lp_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6523: lx_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6524:
6525: lp_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6526: lx_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6527: lp_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6528: lx_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6529:
6530: lp_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6526: lx_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6527: lp_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6528: lx_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6529:
6530: lp_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6531: lx_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6532: lp_LAPACT_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6533: lx_LAPACT_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6534:
6527: lp_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6528: lx_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6529:
6530: lp_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6531: lx_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6532: lp_LAPACT_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6533: lx_LAPACT_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6534:
6535: lp_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
6536: lp_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
6537: lx_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
6538: lx_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
6539:
6540: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
6541: lp_klev_rec okl_kle_pvt.klev_rec_type;
6542: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
6543: lx_klev_rec okl_kle_pvt.klev_rec_type;
6544:
6538: lx_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
6539:
6540: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
6541: lp_klev_rec okl_kle_pvt.klev_rec_type;
6542: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
6543: lx_klev_rec okl_kle_pvt.klev_rec_type;
6544:
6545: --Bug# 4558486
6546: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
6992: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
6993: -- to create records in tables
6994: -- okc_k_party_roles_b and okl_k_party_roles
6995: /*
6996: OKL_OKC_MIGRATION_PVT.create_k_party_role(
6997: p_api_version => p_api_version,
6998: p_init_msg_list => p_init_msg_list,
6999: x_return_status => x_return_status,
7000: x_msg_count => x_msg_count,
7035: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
7036: -- to update records in tables
7037: -- okc_k_party_roles_b and okl_k_party_roles
7038: /*
7039: OKL_OKC_MIGRATION_PVT.update_k_party_role(
7040: p_api_version => p_api_version,
7041: p_init_msg_list => p_init_msg_list,
7042: x_return_status => x_return_status,
7043: x_msg_count => x_msg_count,
7075: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
7076: -- to delete records in tables
7077: -- okc_k_party_roles_b and okl_k_party_roles
7078: /*
7079: OKL_OKC_MIGRATION_PVT.delete_k_party_role(
7080: p_api_version => p_api_version,
7081: p_init_msg_list => p_init_msg_list,
7082: x_return_status => x_return_status,
7083: x_msg_count => x_msg_count,
7118: lp_ctcv_rec.object1_id2 := x_durv_rec.contact_object1_id2;
7119: lp_ctcv_rec.jtot_object1_code := p_durv_rec.contact_jtot_object1_code;
7120: lp_ctcv_rec.cro_code := 'SALESPERSON';
7121:
7122: OKL_OKC_MIGRATION_PVT.create_contact(
7123: p_api_version => p_api_version,
7124: p_init_msg_list => p_init_msg_list,
7125: x_return_status => x_return_status,
7126: x_msg_count => x_msg_count,
7145: lp_ctcv_rec.object1_id2 := x_durv_rec.contact_object1_id2;
7146: lp_ctcv_rec.jtot_object1_code := p_durv_rec.contact_jtot_object1_code;
7147: lp_ctcv_rec.cro_code := 'SALESPERSON';
7148:
7149: OKL_OKC_MIGRATION_PVT.update_contact(
7150: p_api_version => p_api_version,
7151: p_init_msg_list => p_init_msg_list,
7152: x_return_status => x_return_status,
7153: x_msg_count => x_msg_count,
7170: lp_ctcv_rec.object1_id2 := x_durv_rec.contact_object1_id2;
7171: lp_ctcv_rec.jtot_object1_code := p_durv_rec.contact_jtot_object1_code;
7172: lp_ctcv_rec.cro_code := 'SALESPERSON';
7173:
7174: OKL_OKC_MIGRATION_PVT.delete_contact(
7175: p_api_version => p_api_version,
7176: p_init_msg_list => p_init_msg_list,
7177: x_return_status => x_return_status,
7178: x_msg_count => x_msg_count,
7197: lp_mla_gvev_rec.chr_id := p_durv_rec.chr_id;
7198: lp_mla_gvev_rec.chr_id_referred := x_durv_rec.mla_gvr_chr_id_referred;
7199: lp_mla_gvev_rec.copied_only_yn := 'N';
7200:
7201: OKL_OKC_MIGRATION_PVT.create_governance(
7202: p_api_version => p_api_version,
7203: p_init_msg_list => p_init_msg_list,
7204: x_return_status => x_return_status,
7205: x_msg_count => x_msg_count,
7222: lp_mla_gvev_rec.chr_id := p_durv_rec.chr_id;
7223: lp_mla_gvev_rec.chr_id_referred := x_durv_rec.mla_gvr_chr_id_referred;
7224: lp_mla_gvev_rec.copied_only_yn := 'N';
7225:
7226: OKL_OKC_MIGRATION_PVT.update_governance(
7227: p_api_version => p_api_version,
7228: p_init_msg_list => p_init_msg_list,
7229: x_return_status => x_return_status,
7230: x_msg_count => x_msg_count,
7245: lp_mla_gvev_rec.chr_id := p_durv_rec.chr_id;
7246: lp_mla_gvev_rec.chr_id_referred := x_durv_rec.mla_gvr_chr_id_referred;
7247: lp_mla_gvev_rec.copied_only_yn := 'N';
7248:
7249: OKL_OKC_MIGRATION_PVT.delete_governance(
7250: p_api_version => p_api_version,
7251: p_init_msg_list => p_init_msg_list,
7252: x_return_status => x_return_status,
7253: x_msg_count => x_msg_count,
7272: lp_cl_gvev_rec.chr_id := p_durv_rec.chr_id;
7273: lp_cl_gvev_rec.chr_id_referred := x_durv_rec.cl_gvr_chr_id_referred;
7274: lp_cl_gvev_rec.copied_only_yn := 'N';
7275:
7276: OKL_OKC_MIGRATION_PVT.create_governance(
7277: p_api_version => p_api_version,
7278: p_init_msg_list => p_init_msg_list,
7279: x_return_status => x_return_status,
7280: x_msg_count => x_msg_count,
7297: lp_cl_gvev_rec.chr_id := p_durv_rec.chr_id;
7298: lp_cl_gvev_rec.chr_id_referred := x_durv_rec.cl_gvr_chr_id_referred;
7299: lp_cl_gvev_rec.copied_only_yn := 'N';
7300:
7301: OKL_OKC_MIGRATION_PVT.update_governance(
7302: p_api_version => p_api_version,
7303: p_init_msg_list => p_init_msg_list,
7304: x_return_status => x_return_status,
7305: x_msg_count => x_msg_count,
7320: lp_cl_gvev_rec.chr_id := p_durv_rec.chr_id;
7321: lp_cl_gvev_rec.chr_id_referred := x_durv_rec.cl_gvr_chr_id_referred;
7322: lp_cl_gvev_rec.copied_only_yn := 'N';
7323:
7324: OKL_OKC_MIGRATION_PVT.delete_governance(
7325: p_api_version => p_api_version,
7326: p_init_msg_list => p_init_msg_list,
7327: x_return_status => x_return_status,
7328: x_msg_count => x_msg_count,
8430: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
8431: l_api_name CONSTANT varchar2(30) := 'create_party';
8432: l_api_version CONSTANT NUMBER := 1.0;
8433:
8434: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8435: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8436: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8437: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8438:
8431: l_api_name CONSTANT varchar2(30) := 'create_party';
8432: l_api_version CONSTANT NUMBER := 1.0;
8433:
8434: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8435: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8436: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8437: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8438:
8439: Begin
8543: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
8544: l_api_name CONSTANT varchar2(30) := 'update_party';
8545: l_api_version CONSTANT NUMBER := 1.0;
8546:
8547: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8548: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8549: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8550: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8551:
8544: l_api_name CONSTANT varchar2(30) := 'update_party';
8545: l_api_version CONSTANT NUMBER := 1.0;
8546:
8547: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8548: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8549: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8550: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8551:
8552: Begin