DBA Data[Home] [Help]

APPS.OKL_DEAL_CREATE_PUB dependencies on OKL_OKC_MIGRATION_PVT

Line 17: SUBTYPE rgpv_rec_type IS OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

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;

Line 20: SUBTYPE chrv_rec_type IS OKL_OKC_MIGRATION_PVT.chrv_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

Line 443: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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:

Line 444: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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

Line 1144: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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:

Line 1145: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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;

Line 1241: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_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:

Line 1242: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

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

Line 1368: OKL_OKC_MIGRATION_PVT.create_governance(

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,

Line 1568: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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:

Line 1569: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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

Line 1617: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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:

Line 1618: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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;

Line 1673: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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:

Line 1674: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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

Line 1682: lp_cplv_rec1 OKL_OKC_MIGRATION_PVT.cplv_rec_type;

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';

Line 1683: lx_cplv_rec1 OKL_OKC_MIGRATION_PVT.cplv_rec_type;

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:

Line 1924: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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:

Line 1925: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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

Line 1930: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_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
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';

Line 1931: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_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';
1935:

Line 2199: SUBTYPE l_cplv_tbl_type is OKL_OKC_MIGRATION_PVT.cplv_tbl_type;

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;

Line 2202: lp_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:

Line 2203: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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

Line 2208: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_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
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;

Line 2209: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_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;
2213: l_kplv_tbl l_kplv_tbl_type;

Line 2547: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_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;

Line 2548: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;

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;

Line 2830: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;

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;

Line 2831: lx_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;

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:

Line 3549: x_new_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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;

Line 4206: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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:

Line 4207: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_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:
4211: /*

Line 4841: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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:

Line 4842: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_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:
4846: /*

Line 5810: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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;

Line 5811: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_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:

Line 5816: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

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;

Line 5817: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_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;

Line 5824: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_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;

Line 5825: lx_mla_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:

Line 5827: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_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:
5830: X_NO_DATA_FOUND BOOLEAN := TRUE;
5831:

Line 5828: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

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

Line 6123: OKL_OKC_MIGRATION_PVT.update_k_party_role(

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,

Line 6160: OKL_OKC_MIGRATION_PVT.create_governance(

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,

Line 6183: OKL_OKC_MIGRATION_PVT.update_governance(

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,

Line 6203: OKL_OKC_MIGRATION_PVT.delete_governance(

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,

Line 6232: OKL_OKC_MIGRATION_PVT.create_governance(

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,

Line 6255: OKL_OKC_MIGRATION_PVT.update_governance(

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,

Line 6274: OKL_OKC_MIGRATION_PVT.delete_governance(

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,

Line 6485: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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;

Line 6486: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_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:

Line 6491: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

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;

Line 6492: lx_lessee_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;

Line 6494: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_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:

Line 6495: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

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;

Line 6496: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_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;

Line 6497: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_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:

Line 6499: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_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:
6502: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6503: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

Line 6500: lx_mla_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:

Line 6502: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_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:
6505: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6506: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 6503: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_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;

Line 6505: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_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:

Line 6506: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

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;

Line 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:

Line 6511: lx_LAREBL_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:
6515: lp_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 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:

Line 6516: lx_LATOWN_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:
6520: lp_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 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:

Line 6521: lx_LANNTF_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:
6525: lp_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 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:

Line 6526: lx_LACPLN_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:
6530: lp_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 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:

Line 6531: lx_LAPACT_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:
6535: lp_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

Line 6540: lp_clev_rec okl_okc_migration_pvt.clev_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:

Line 6542: lx_clev_rec okl_okc_migration_pvt.clev_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:
6545: --Bug# 4558486
6546: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

Line 6996: OKL_OKC_MIGRATION_PVT.create_k_party_role(

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,

Line 7039: OKL_OKC_MIGRATION_PVT.update_k_party_role(

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,

Line 7079: OKL_OKC_MIGRATION_PVT.delete_k_party_role(

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,

Line 7122: OKL_OKC_MIGRATION_PVT.create_contact(

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,

Line 7149: OKL_OKC_MIGRATION_PVT.update_contact(

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,

Line 7174: OKL_OKC_MIGRATION_PVT.delete_contact(

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,

Line 7201: OKL_OKC_MIGRATION_PVT.create_governance(

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,

Line 7226: OKL_OKC_MIGRATION_PVT.update_governance(

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,

Line 7249: OKL_OKC_MIGRATION_PVT.delete_governance(

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,

Line 7276: OKL_OKC_MIGRATION_PVT.create_governance(

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,

Line 7301: OKL_OKC_MIGRATION_PVT.update_governance(

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,

Line 7324: OKL_OKC_MIGRATION_PVT.delete_governance(

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,

Line 8434: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

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:

Line 8435: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

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

Line 8547: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

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:

Line 8548: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

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