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 2544: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

2540: l_api_version CONSTANT NUMBER := 1.0;
2541:
2542: lp_rgpv_rec Okl_Rule_Pub.rgpv_rec_type;
2543:
2544: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
2545: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2546:
2547: l_rgpr_id NUMBER := NULL;
2548: l_vp_tmpl_id NUMBER;

Line 2545: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;

2541:
2542: lp_rgpv_rec Okl_Rule_Pub.rgpv_rec_type;
2543:
2544: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
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;

Line 2827: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;

2823: rul_seg_rec c_rule_segmnts_csr%ROWTYPE;
2824:
2825: lp_rulv_rec Okl_Rule_Pub.rulv_rec_type;
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;

Line 2828: lx_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;

2824:
2825: lp_rulv_rec Okl_Rule_Pub.rulv_rec_type;
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:

Line 3546: x_new_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

3542: p_contract_number IN VARCHAR2,
3543: p_source_chr_id IN NUMBER,
3544: x_chr_id OUT NOCOPY NUMBER) AS
3545:
3546: x_new_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3547: x_new_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3548: l_old_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
3549: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
3550: l_value VARCHAR2(1) := OKL_API.G_FALSE;

Line 4203: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

4199: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4200:
4201: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4202:
4203: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4204: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4205: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4206: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4207:

Line 4204: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

4200:
4201: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4202:
4203: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4204: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4205: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4206: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4207:
4208: /*

Line 4838: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

4834: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4835:
4836: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4837:
4838: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4839: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4840: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4841: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4842:

Line 4839: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

4835:
4836: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4837:
4838: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4839: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4840: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4841: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4842:
4843: /*

Line 5807: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

5803:
5804: l_auth_org_id okc_k_headers_b.authoring_org_id%type;
5805: l_inv_org_id okc_k_headers_b.inv_organization_id%type;
5806:
5807: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5808: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5809:
5810: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5811: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

Line 5808: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

5804: l_auth_org_id okc_k_headers_b.authoring_org_id%type;
5805: l_inv_org_id okc_k_headers_b.inv_organization_id%type;
5806:
5807: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5808: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5809:
5810: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5811: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5812:

Line 5813: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

5809:
5810: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5811: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5812:
5813: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5814: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5815:
5816: lp_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
5817: lp_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

Line 5814: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

5810: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5811: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5812:
5813: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5814: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5815:
5816: lp_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
5817: lp_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
5818: lx_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

Line 5821: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

5817: lp_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
5818: lx_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
5819: lx_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
5820:
5821: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5822: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5823:
5824: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5825: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

Line 5822: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

5818: lx_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
5819: lx_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
5820:
5821: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5822: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5823:
5824: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5825: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5826:

Line 5824: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

5820:
5821: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5822: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5823:
5824: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5825: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5826:
5827: X_NO_DATA_FOUND BOOLEAN := TRUE;
5828:

Line 5825: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

5821: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5822: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5823:
5824: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5825: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5826:
5827: X_NO_DATA_FOUND BOOLEAN := TRUE;
5828:
5829: --Bug# 4558486

Line 6120: OKL_OKC_MIGRATION_PVT.update_k_party_role(

6116: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
6117: -- to update records in tables
6118: -- okc_k_party_roles_b and okl_k_party_roles
6119: /*
6120: OKL_OKC_MIGRATION_PVT.update_k_party_role(
6121: p_api_version => p_api_version,
6122: p_init_msg_list => p_init_msg_list,
6123: x_return_status => x_return_status,
6124: x_msg_count => x_msg_count,

Line 6157: OKL_OKC_MIGRATION_PVT.create_governance(

6153: lp_mla_gvev_rec.chr_id := p_chr_id;
6154: lp_mla_gvev_rec.chr_id_referred := l_mla_id;
6155: lp_mla_gvev_rec.copied_only_yn := 'N';
6156:
6157: OKL_OKC_MIGRATION_PVT.create_governance(
6158: p_api_version => p_api_version,
6159: p_init_msg_list => p_init_msg_list,
6160: x_return_status => x_return_status,
6161: x_msg_count => x_msg_count,

Line 6180: OKL_OKC_MIGRATION_PVT.update_governance(

6176: lp_mla_gvev_rec.chr_id := p_chr_id;
6177: lp_mla_gvev_rec.chr_id_referred := l_mla_id;
6178: lp_mla_gvev_rec.copied_only_yn := 'N';
6179:
6180: OKL_OKC_MIGRATION_PVT.update_governance(
6181: p_api_version => p_api_version,
6182: p_init_msg_list => p_init_msg_list,
6183: x_return_status => x_return_status,
6184: x_msg_count => x_msg_count,

Line 6200: OKL_OKC_MIGRATION_PVT.delete_governance(

6196: ELSIF (p_gvr_id_mla IS NOT NULL AND p_mla_no IS NULL ) THEN
6197:
6198: lp_mla_gvev_rec.id := p_gvr_id_mla;
6199:
6200: OKL_OKC_MIGRATION_PVT.delete_governance(
6201: p_api_version => p_api_version,
6202: p_init_msg_list => p_init_msg_list,
6203: x_return_status => x_return_status,
6204: x_msg_count => x_msg_count,

Line 6229: OKL_OKC_MIGRATION_PVT.create_governance(

6225: lp_cl_gvev_rec.chr_id := p_chr_id;
6226: lp_cl_gvev_rec.chr_id_referred := l_cl_id;
6227: lp_cl_gvev_rec.copied_only_yn := 'N';
6228:
6229: OKL_OKC_MIGRATION_PVT.create_governance(
6230: p_api_version => p_api_version,
6231: p_init_msg_list => p_init_msg_list,
6232: x_return_status => x_return_status,
6233: x_msg_count => x_msg_count,

Line 6252: OKL_OKC_MIGRATION_PVT.update_governance(

6248: lp_cl_gvev_rec.chr_id := p_chr_id;
6249: lp_cl_gvev_rec.chr_id_referred := l_cl_id;
6250: lp_cl_gvev_rec.copied_only_yn := 'N';
6251:
6252: OKL_OKC_MIGRATION_PVT.update_governance(
6253: p_api_version => p_api_version,
6254: p_init_msg_list => p_init_msg_list,
6255: x_return_status => x_return_status,
6256: x_msg_count => x_msg_count,

Line 6271: OKL_OKC_MIGRATION_PVT.delete_governance(

6267: ELSIF (p_gvr_id_cl IS NOT NULL AND p_cl_no IS NULL ) THEN
6268:
6269: lp_cl_gvev_rec.id := p_gvr_id_cl;
6270:
6271: OKL_OKC_MIGRATION_PVT.delete_governance(
6272: p_api_version => p_api_version,
6273: p_init_msg_list => p_init_msg_list,
6274: x_return_status => x_return_status,
6275: x_msg_count => x_msg_count,

Line 6482: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

6478: SELECT vers.major_version||'.'||vers.minor_version
6479: FROM okc_k_vers_numbers_v vers
6480: WHERE vers.chr_id = p_durv_rec.chr_id;
6481:
6482: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
6483: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
6484:
6485: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6486: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

Line 6483: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

6479: FROM okc_k_vers_numbers_v vers
6480: WHERE vers.chr_id = p_durv_rec.chr_id;
6481:
6482: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
6483: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
6484:
6485: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6486: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6487:

Line 6488: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

6484:
6485: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6486: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6487:
6488: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6489: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6490:
6491: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6492: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

Line 6489: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

6485: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6486: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6487:
6488: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6489: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6490:
6491: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6492: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6493: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;

Line 6491: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

6487:
6488: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6489: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6490:
6491: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6492: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6493: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6494: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6495:

Line 6492: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

6488: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6489: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6490:
6491: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6492: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6493: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6494: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6495:
6496: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

Line 6493: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;

6489: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6490:
6491: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6492: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6493: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6494: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6495:
6496: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6497: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

Line 6494: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;

6490:
6491: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6492: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6493: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6494: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6495:
6496: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6497: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6498:

Line 6496: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

6492: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6493: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6494: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6495:
6496: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6497: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6498:
6499: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6500: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

Line 6497: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

6493: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6494: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6495:
6496: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6497: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6498:
6499: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6500: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6501:

Line 6499: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

6495:
6496: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6497: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6498:
6499: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6500: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6501:
6502: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6503: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 6500: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

6496: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6497: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6498:
6499: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6500: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6501:
6502: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6503: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6504: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;

Line 6502: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6498:
6499: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6500: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6501:
6502: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6503: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6504: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6505: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6506:

Line 6503: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6499: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6500: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6501:
6502: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6503: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6504: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6505: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6506:
6507: lp_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 6507: lp_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6503: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6504: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6505: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6506:
6507: lp_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6508: lx_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6509: lp_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6510: lx_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6511:

Line 6508: lx_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6504: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6505: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6506:
6507: lp_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6508: lx_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6509: lp_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6510: lx_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6511:
6512: lp_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 6512: lp_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6508: lx_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6509: lp_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6510: lx_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6511:
6512: lp_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6513: lx_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6514: lp_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6515: lx_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6516:

Line 6513: lx_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6509: lp_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6510: lx_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6511:
6512: lp_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6513: lx_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6514: lp_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6515: lx_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6516:
6517: lp_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 6517: lp_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6513: lx_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6514: lp_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6515: lx_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6516:
6517: lp_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6518: lx_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6519: lp_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6520: lx_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6521:

Line 6518: lx_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6514: lp_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6515: lx_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6516:
6517: lp_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6518: lx_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6519: lp_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6520: lx_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6521:
6522: lp_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 6522: lp_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6518: lx_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6519: lp_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6520: lx_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6521:
6522: lp_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6523: lx_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6524: lp_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6525: lx_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6526:

Line 6523: lx_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6519: lp_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6520: lx_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6521:
6522: lp_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6523: lx_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6524: lp_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6525: lx_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6526:
6527: lp_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 6527: lp_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6523: lx_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6524: lp_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6525: lx_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6526:
6527: lp_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6528: lx_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6529: lp_LAPACT_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6530: lx_LAPACT_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6531:

Line 6528: lx_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6524: lp_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6525: lx_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6526:
6527: lp_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6528: lx_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6529: lp_LAPACT_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6530: lx_LAPACT_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6531:
6532: lp_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

Line 6537: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;

6533: lp_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
6534: lx_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
6535: lx_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
6536:
6537: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
6538: lp_klev_rec okl_kle_pvt.klev_rec_type;
6539: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
6540: lx_klev_rec okl_kle_pvt.klev_rec_type;
6541:

Line 6539: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

6535: lx_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
6536:
6537: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
6538: lp_klev_rec okl_kle_pvt.klev_rec_type;
6539: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
6540: lx_klev_rec okl_kle_pvt.klev_rec_type;
6541:
6542: --Bug# 4558486
6543: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

Line 6993: OKL_OKC_MIGRATION_PVT.create_k_party_role(

6989: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
6990: -- to create records in tables
6991: -- okc_k_party_roles_b and okl_k_party_roles
6992: /*
6993: OKL_OKC_MIGRATION_PVT.create_k_party_role(
6994: p_api_version => p_api_version,
6995: p_init_msg_list => p_init_msg_list,
6996: x_return_status => x_return_status,
6997: x_msg_count => x_msg_count,

Line 7036: OKL_OKC_MIGRATION_PVT.update_k_party_role(

7032: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
7033: -- to update records in tables
7034: -- okc_k_party_roles_b and okl_k_party_roles
7035: /*
7036: OKL_OKC_MIGRATION_PVT.update_k_party_role(
7037: p_api_version => p_api_version,
7038: p_init_msg_list => p_init_msg_list,
7039: x_return_status => x_return_status,
7040: x_msg_count => x_msg_count,

Line 7076: OKL_OKC_MIGRATION_PVT.delete_k_party_role(

7072: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
7073: -- to delete records in tables
7074: -- okc_k_party_roles_b and okl_k_party_roles
7075: /*
7076: OKL_OKC_MIGRATION_PVT.delete_k_party_role(
7077: p_api_version => p_api_version,
7078: p_init_msg_list => p_init_msg_list,
7079: x_return_status => x_return_status,
7080: x_msg_count => x_msg_count,

Line 7119: OKL_OKC_MIGRATION_PVT.create_contact(

7115: lp_ctcv_rec.object1_id2 := x_durv_rec.contact_object1_id2;
7116: lp_ctcv_rec.jtot_object1_code := p_durv_rec.contact_jtot_object1_code;
7117: lp_ctcv_rec.cro_code := 'SALESPERSON';
7118:
7119: OKL_OKC_MIGRATION_PVT.create_contact(
7120: p_api_version => p_api_version,
7121: p_init_msg_list => p_init_msg_list,
7122: x_return_status => x_return_status,
7123: x_msg_count => x_msg_count,

Line 7146: OKL_OKC_MIGRATION_PVT.update_contact(

7142: lp_ctcv_rec.object1_id2 := x_durv_rec.contact_object1_id2;
7143: lp_ctcv_rec.jtot_object1_code := p_durv_rec.contact_jtot_object1_code;
7144: lp_ctcv_rec.cro_code := 'SALESPERSON';
7145:
7146: OKL_OKC_MIGRATION_PVT.update_contact(
7147: p_api_version => p_api_version,
7148: p_init_msg_list => p_init_msg_list,
7149: x_return_status => x_return_status,
7150: x_msg_count => x_msg_count,

Line 7171: OKL_OKC_MIGRATION_PVT.delete_contact(

7167: lp_ctcv_rec.object1_id2 := x_durv_rec.contact_object1_id2;
7168: lp_ctcv_rec.jtot_object1_code := p_durv_rec.contact_jtot_object1_code;
7169: lp_ctcv_rec.cro_code := 'SALESPERSON';
7170:
7171: OKL_OKC_MIGRATION_PVT.delete_contact(
7172: p_api_version => p_api_version,
7173: p_init_msg_list => p_init_msg_list,
7174: x_return_status => x_return_status,
7175: x_msg_count => x_msg_count,

Line 7198: OKL_OKC_MIGRATION_PVT.create_governance(

7194: lp_mla_gvev_rec.chr_id := p_durv_rec.chr_id;
7195: lp_mla_gvev_rec.chr_id_referred := x_durv_rec.mla_gvr_chr_id_referred;
7196: lp_mla_gvev_rec.copied_only_yn := 'N';
7197:
7198: OKL_OKC_MIGRATION_PVT.create_governance(
7199: p_api_version => p_api_version,
7200: p_init_msg_list => p_init_msg_list,
7201: x_return_status => x_return_status,
7202: x_msg_count => x_msg_count,

Line 7223: OKL_OKC_MIGRATION_PVT.update_governance(

7219: lp_mla_gvev_rec.chr_id := p_durv_rec.chr_id;
7220: lp_mla_gvev_rec.chr_id_referred := x_durv_rec.mla_gvr_chr_id_referred;
7221: lp_mla_gvev_rec.copied_only_yn := 'N';
7222:
7223: OKL_OKC_MIGRATION_PVT.update_governance(
7224: p_api_version => p_api_version,
7225: p_init_msg_list => p_init_msg_list,
7226: x_return_status => x_return_status,
7227: x_msg_count => x_msg_count,

Line 7246: OKL_OKC_MIGRATION_PVT.delete_governance(

7242: lp_mla_gvev_rec.chr_id := p_durv_rec.chr_id;
7243: lp_mla_gvev_rec.chr_id_referred := x_durv_rec.mla_gvr_chr_id_referred;
7244: lp_mla_gvev_rec.copied_only_yn := 'N';
7245:
7246: OKL_OKC_MIGRATION_PVT.delete_governance(
7247: p_api_version => p_api_version,
7248: p_init_msg_list => p_init_msg_list,
7249: x_return_status => x_return_status,
7250: x_msg_count => x_msg_count,

Line 7273: OKL_OKC_MIGRATION_PVT.create_governance(

7269: lp_cl_gvev_rec.chr_id := p_durv_rec.chr_id;
7270: lp_cl_gvev_rec.chr_id_referred := x_durv_rec.cl_gvr_chr_id_referred;
7271: lp_cl_gvev_rec.copied_only_yn := 'N';
7272:
7273: OKL_OKC_MIGRATION_PVT.create_governance(
7274: p_api_version => p_api_version,
7275: p_init_msg_list => p_init_msg_list,
7276: x_return_status => x_return_status,
7277: x_msg_count => x_msg_count,

Line 7298: OKL_OKC_MIGRATION_PVT.update_governance(

7294: lp_cl_gvev_rec.chr_id := p_durv_rec.chr_id;
7295: lp_cl_gvev_rec.chr_id_referred := x_durv_rec.cl_gvr_chr_id_referred;
7296: lp_cl_gvev_rec.copied_only_yn := 'N';
7297:
7298: OKL_OKC_MIGRATION_PVT.update_governance(
7299: p_api_version => p_api_version,
7300: p_init_msg_list => p_init_msg_list,
7301: x_return_status => x_return_status,
7302: x_msg_count => x_msg_count,

Line 7321: OKL_OKC_MIGRATION_PVT.delete_governance(

7317: lp_cl_gvev_rec.chr_id := p_durv_rec.chr_id;
7318: lp_cl_gvev_rec.chr_id_referred := x_durv_rec.cl_gvr_chr_id_referred;
7319: lp_cl_gvev_rec.copied_only_yn := 'N';
7320:
7321: OKL_OKC_MIGRATION_PVT.delete_governance(
7322: p_api_version => p_api_version,
7323: p_init_msg_list => p_init_msg_list,
7324: x_return_status => x_return_status,
7325: x_msg_count => x_msg_count,

Line 8425: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

8421: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
8422: l_api_name CONSTANT varchar2(30) := 'create_party';
8423: l_api_version CONSTANT NUMBER := 1.0;
8424:
8425: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8426: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8427: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8428: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8429:

Line 8426: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

8422: l_api_name CONSTANT varchar2(30) := 'create_party';
8423: l_api_version CONSTANT NUMBER := 1.0;
8424:
8425: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8426: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8427: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8428: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8429:
8430: Begin

Line 8538: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

8534: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
8535: l_api_name CONSTANT varchar2(30) := 'update_party';
8536: l_api_version CONSTANT NUMBER := 1.0;
8537:
8538: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8539: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8540: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8541: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8542:

Line 8539: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

8535: l_api_name CONSTANT varchar2(30) := 'update_party';
8536: l_api_version CONSTANT NUMBER := 1.0;
8537:
8538: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8539: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8540: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8541: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8542:
8543: Begin