DBA Data[Home] [Help]

APPS.OKL_DEAL_CREAT_PVT 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 442: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

438: l_end_date OKL_K_HEADERS_FULL_V.END_DATE%TYPE DEFAULT NULL;
439: l_start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE DEFAULT NULL;
440: l_term_duration OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE DEFAULT NULL;
441:
442: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
443: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
444: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
445: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
446:

Line 443: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

439: l_start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE DEFAULT NULL;
440: l_term_duration OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE DEFAULT NULL;
441:
442: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
443: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
444: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
445: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
446:
447: CURSOR get_k_start_date_and_term_csr(l_chr_id NUMBER) IS

Line 1143: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

1139: p_contract_number IN VARCHAR2,
1140: p_source_chr_id IN NUMBER,
1141: x_chr_id OUT NOCOPY NUMBER) AS
1142:
1143: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1144: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1145: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1146: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1147:

Line 1144: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

1140: p_source_chr_id IN NUMBER,
1141: x_chr_id OUT NOCOPY NUMBER) AS
1142:
1143: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1144: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1145: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1146: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1147:
1148: lp_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;

Line 1240: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

1236: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE := NULL;
1237: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE := NULL;
1238: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE := NULL;
1239:
1240: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
1241: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
1242:
1243: BEGIN
1244:

Line 1241: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

1237: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE := NULL;
1238: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE := NULL;
1239:
1240: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
1241: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
1242:
1243: BEGIN
1244:
1245: -- read hdr info from the quote contract and create a lease contract

Line 1367: OKL_OKC_MIGRATION_PVT.create_governance(

1363: lp_mla_gvev_rec.chr_id := l_chr_id;
1364: lp_mla_gvev_rec.chr_id_referred := l_mla_gvr_chr_id_referred;
1365: lp_mla_gvev_rec.copied_only_yn := 'N';
1366:
1367: OKL_OKC_MIGRATION_PVT.create_governance(
1368: p_api_version => p_api_version,
1369: p_init_msg_list => p_init_msg_list,
1370: x_return_status => x_return_status,
1371: x_msg_count => x_msg_count,

Line 1567: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

1563: p_contract_number IN VARCHAR2,
1564: p_source_chr_id IN NUMBER,
1565: x_chr_id OUT NOCOPY NUMBER) AS
1566:
1567: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1568: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1569: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1570: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1571:

Line 1568: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

1564: p_source_chr_id IN NUMBER,
1565: x_chr_id OUT NOCOPY NUMBER) AS
1566:
1567: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1568: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1569: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1570: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1571:
1572: BEGIN

Line 1616: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

1612: p_source_object_code IN VARCHAR2,
1613: p_source_chr_id IN NUMBER,
1614: x_chr_id OUT NOCOPY NUMBER) AS
1615:
1616: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1617: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1618: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1619: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1620:

Line 1617: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

1613: p_source_chr_id IN NUMBER,
1614: x_chr_id OUT NOCOPY NUMBER) AS
1615:
1616: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1617: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1618: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1619: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1620:
1621: p_chr_id NUMBER;

Line 1672: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

1668: x_chr_id OUT NOCOPY NUMBER,
1669: --Added by dpsingh for LE Uptake
1670: p_legal_entity_id IN NUMBER) AS
1671:
1672: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1673: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1674: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1675: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1676:

Line 1673: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

1669: --Added by dpsingh for LE Uptake
1670: p_legal_entity_id IN NUMBER) AS
1671:
1672: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1673: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1674: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1675: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1676:
1677: --Bug# 4558486

Line 1681: lp_cplv_rec1 OKL_OKC_MIGRATION_PVT.cplv_rec_type;

1677: --Bug# 4558486
1678: lp_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1679: lx_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1680:
1681: lp_cplv_rec1 OKL_OKC_MIGRATION_PVT.cplv_rec_type;
1682: lx_cplv_rec1 OKL_OKC_MIGRATION_PVT.cplv_rec_type;
1683:
1684: l_api_version CONSTANT NUMBER := 1.0;
1685: l_api_name VARCHAR2(30) := 'CREATE_NEW_DEAL';

Line 1682: lx_cplv_rec1 OKL_OKC_MIGRATION_PVT.cplv_rec_type;

1678: lp_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1679: lx_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1680:
1681: lp_cplv_rec1 OKL_OKC_MIGRATION_PVT.cplv_rec_type;
1682: lx_cplv_rec1 OKL_OKC_MIGRATION_PVT.cplv_rec_type;
1683:
1684: l_api_version CONSTANT NUMBER := 1.0;
1685: l_api_name VARCHAR2(30) := 'CREATE_NEW_DEAL';
1686:

Line 1923: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

1919: x_chr_id OUT NOCOPY NUMBER,
1920: --Added by dpsingh for LE Uptake
1921: p_legal_entity_id IN NUMBER) AS
1922:
1923: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1924: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1925: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1926: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1927:

Line 1924: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

1920: --Added by dpsingh for LE Uptake
1921: p_legal_entity_id IN NUMBER) AS
1922:
1923: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1924: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1925: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1926: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1927:
1928: --Bug# 4558486

Line 1929: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

1925: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1926: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1927:
1928: --Bug# 4558486
1929: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
1930: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
1931:
1932: l_api_version CONSTANT NUMBER := 1.0;
1933: l_api_name VARCHAR2(30) := 'CREATE_NEW_DEAL';

Line 1930: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

1926: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1927:
1928: --Bug# 4558486
1929: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
1930: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
1931:
1932: l_api_version CONSTANT NUMBER := 1.0;
1933: l_api_name VARCHAR2(30) := 'CREATE_NEW_DEAL';
1934:

Line 2198: SUBTYPE l_cplv_tbl_type is OKL_OKC_MIGRATION_PVT.cplv_tbl_type;

2194: --Added by dpsingh for LE Uptake
2195: p_legal_entity_id IN NUMBER) AS
2196:
2197: -- 5116278
2198: SUBTYPE l_cplv_tbl_type is OKL_OKC_MIGRATION_PVT.cplv_tbl_type;
2199: SUBTYPE l_kplv_tbl_type is okl_kpl_pvt.kplv_tbl_type;
2200:
2201: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2202: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 2201: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

2197: -- 5116278
2198: SUBTYPE l_cplv_tbl_type is OKL_OKC_MIGRATION_PVT.cplv_tbl_type;
2199: SUBTYPE l_kplv_tbl_type is okl_kpl_pvt.kplv_tbl_type;
2200:
2201: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2202: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2203: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2204: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2205:

Line 2202: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

2198: SUBTYPE l_cplv_tbl_type is OKL_OKC_MIGRATION_PVT.cplv_tbl_type;
2199: SUBTYPE l_kplv_tbl_type is okl_kpl_pvt.kplv_tbl_type;
2200:
2201: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2202: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2203: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2204: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2205:
2206: --Bug# 4558486

Line 2207: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

2203: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2204: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2205:
2206: --Bug# 4558486
2207: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
2208: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
2209:
2210: -- 5116278
2211: l_cplv_tbl l_cplv_tbl_type;

Line 2208: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

2204: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2205:
2206: --Bug# 4558486
2207: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
2208: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
2209:
2210: -- 5116278
2211: l_cplv_tbl l_cplv_tbl_type;
2212: l_kplv_tbl l_kplv_tbl_type;

Line 2542: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

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

Line 2543: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;

2539:
2540: lp_rgpv_rec Okl_Rule_Pub.rgpv_rec_type;
2541:
2542: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
2543: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2544:
2545: l_rgpr_id NUMBER := NULL;
2546: l_vp_tmpl_id NUMBER;
2547: l_k_cpl_id okc_k_party_roles_v.id%TYPE := NULL;

Line 2807: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;

2803: rul_seg_rec c_rule_segmnts_csr%ROWTYPE;
2804:
2805: lp_rulv_rec Okl_Rule_Pub.rulv_rec_type;
2806: lx_rulv_rec Okl_Rule_Pub.rulv_rec_type;
2807: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2808: lx_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2809:
2810: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2811: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;

Line 2808: lx_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;

2804:
2805: lp_rulv_rec Okl_Rule_Pub.rulv_rec_type;
2806: lx_rulv_rec Okl_Rule_Pub.rulv_rec_type;
2807: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2808: lx_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
2809:
2810: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2811: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2812:

Line 3526: x_new_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

3522: p_contract_number IN VARCHAR2,
3523: p_source_chr_id IN NUMBER,
3524: x_chr_id OUT NOCOPY NUMBER) AS
3525:
3526: x_new_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3527: x_new_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3528: l_old_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
3529: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
3530: l_value VARCHAR2(1) := OKL_API.G_FALSE;

Line 4183: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

4179: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4180:
4181: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4182:
4183: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4184: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4185: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4186: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4187:

Line 4184: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

4180:
4181: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4182:
4183: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4184: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4185: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4186: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4187:
4188: /*

Line 4819: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

4815: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4816:
4817: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4818:
4819: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4820: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4821: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4822: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4823: p_kpl_rec OKL_DEAL_CREAT_PVT.party_rec_type;

Line 4820: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

4816:
4817: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4818:
4819: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4820: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4821: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4822: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4823: p_kpl_rec OKL_DEAL_CREAT_PVT.party_rec_type;
4824: x_kpl_rec OKL_DEAL_CREAT_PVT.party_rec_type;

Line 4843: lp_lahdtx_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

4839: FROM okc_k_headers_all_b
4840: WHERE id = p_chr_id;
4841:
4842: l_tax_schedule_yn VARCHAR2(1);
4843: lp_lahdtx_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
4844: lx_lahdtx_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
4845: lp_lahdtx_rulv_rec Okl_Rule_Pub.rulv_rec_type;
4846: lx_lahdtx_rulv_rec Okl_Rule_Pub.rulv_rec_type;
4847: l_rgp_id NUMBER;

Line 4844: lx_lahdtx_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

4840: WHERE id = p_chr_id;
4841:
4842: l_tax_schedule_yn VARCHAR2(1);
4843: lp_lahdtx_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
4844: lx_lahdtx_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
4845: lp_lahdtx_rulv_rec Okl_Rule_Pub.rulv_rec_type;
4846: lx_lahdtx_rulv_rec Okl_Rule_Pub.rulv_rec_type;
4847: l_rgp_id NUMBER;
4848: l_rgd_code VARCHAR2(30);

Line 5908: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

5904:
5905: l_auth_org_id okc_k_headers_b.authoring_org_id%type;
5906: l_inv_org_id okc_k_headers_b.inv_organization_id%type;
5907:
5908: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5909: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5910:
5911: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5912: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

Line 5909: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

5905: l_auth_org_id okc_k_headers_b.authoring_org_id%type;
5906: l_inv_org_id okc_k_headers_b.inv_organization_id%type;
5907:
5908: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5909: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5910:
5911: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5912: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5913:

Line 5914: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

5910:
5911: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5912: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5913:
5914: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5915: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5916:
5917: lp_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
5918: lp_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

Line 5915: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

5911: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5912: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5913:
5914: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5915: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5916:
5917: lp_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
5918: lp_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
5919: lx_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

Line 5922: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

5918: lp_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
5919: lx_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
5920: lx_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
5921:
5922: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5923: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5924:
5925: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5926: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

Line 5923: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

5919: lx_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
5920: lx_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
5921:
5922: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5923: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5924:
5925: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5926: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5927:

Line 5925: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

5921:
5922: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5923: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5924:
5925: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5926: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5927:
5928: X_NO_DATA_FOUND BOOLEAN := TRUE;
5929:

Line 5926: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

5922: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5923: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5924:
5925: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5926: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5927:
5928: X_NO_DATA_FOUND BOOLEAN := TRUE;
5929:
5930: --Bug# 4558486

Line 6240: OKL_OKC_MIGRATION_PVT.update_k_party_role(

6236: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
6237: -- to update records in tables
6238: -- okc_k_party_roles_b and okl_k_party_roles
6239: /*
6240: OKL_OKC_MIGRATION_PVT.update_k_party_role(
6241: p_api_version => p_api_version,
6242: p_init_msg_list => p_init_msg_list,
6243: x_return_status => x_return_status,
6244: x_msg_count => x_msg_count,

Line 6277: OKL_OKC_MIGRATION_PVT.create_governance(

6273: lp_mla_gvev_rec.chr_id := p_chr_id;
6274: lp_mla_gvev_rec.chr_id_referred := l_mla_id;
6275: lp_mla_gvev_rec.copied_only_yn := 'N';
6276:
6277: OKL_OKC_MIGRATION_PVT.create_governance(
6278: p_api_version => p_api_version,
6279: p_init_msg_list => p_init_msg_list,
6280: x_return_status => x_return_status,
6281: x_msg_count => x_msg_count,

Line 6300: OKL_OKC_MIGRATION_PVT.update_governance(

6296: lp_mla_gvev_rec.chr_id := p_chr_id;
6297: lp_mla_gvev_rec.chr_id_referred := l_mla_id;
6298: lp_mla_gvev_rec.copied_only_yn := 'N';
6299:
6300: OKL_OKC_MIGRATION_PVT.update_governance(
6301: p_api_version => p_api_version,
6302: p_init_msg_list => p_init_msg_list,
6303: x_return_status => x_return_status,
6304: x_msg_count => x_msg_count,

Line 6320: OKL_OKC_MIGRATION_PVT.delete_governance(

6316: ELSIF (p_gvr_id_mla IS NOT NULL AND p_mla_no IS NULL ) THEN
6317:
6318: lp_mla_gvev_rec.id := p_gvr_id_mla;
6319:
6320: OKL_OKC_MIGRATION_PVT.delete_governance(
6321: p_api_version => p_api_version,
6322: p_init_msg_list => p_init_msg_list,
6323: x_return_status => x_return_status,
6324: x_msg_count => x_msg_count,

Line 6349: OKL_OKC_MIGRATION_PVT.create_governance(

6345: lp_cl_gvev_rec.chr_id := p_chr_id;
6346: lp_cl_gvev_rec.chr_id_referred := l_cl_id;
6347: lp_cl_gvev_rec.copied_only_yn := 'N';
6348:
6349: OKL_OKC_MIGRATION_PVT.create_governance(
6350: p_api_version => p_api_version,
6351: p_init_msg_list => p_init_msg_list,
6352: x_return_status => x_return_status,
6353: x_msg_count => x_msg_count,

Line 6372: OKL_OKC_MIGRATION_PVT.update_governance(

6368: lp_cl_gvev_rec.chr_id := p_chr_id;
6369: lp_cl_gvev_rec.chr_id_referred := l_cl_id;
6370: lp_cl_gvev_rec.copied_only_yn := 'N';
6371:
6372: OKL_OKC_MIGRATION_PVT.update_governance(
6373: p_api_version => p_api_version,
6374: p_init_msg_list => p_init_msg_list,
6375: x_return_status => x_return_status,
6376: x_msg_count => x_msg_count,

Line 6391: OKL_OKC_MIGRATION_PVT.delete_governance(

6387: ELSIF (p_gvr_id_cl IS NOT NULL AND p_cl_no IS NULL ) THEN
6388:
6389: lp_cl_gvev_rec.id := p_gvr_id_cl;
6390:
6391: OKL_OKC_MIGRATION_PVT.delete_governance(
6392: p_api_version => p_api_version,
6393: p_init_msg_list => p_init_msg_list,
6394: x_return_status => x_return_status,
6395: x_msg_count => x_msg_count,

Line 6602: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

6598: SELECT vers.major_version||'.'||vers.minor_version
6599: FROM okc_k_vers_numbers_v vers
6600: WHERE vers.chr_id = p_durv_rec.chr_id;
6601:
6602: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
6603: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
6604:
6605: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6606: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

Line 6603: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

6599: FROM okc_k_vers_numbers_v vers
6600: WHERE vers.chr_id = p_durv_rec.chr_id;
6601:
6602: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
6603: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
6604:
6605: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6606: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6607:

Line 6608: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

6604:
6605: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6606: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6607:
6608: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6609: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6610:
6611: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6612: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

Line 6609: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

6605: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6606: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6607:
6608: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6609: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6610:
6611: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6612: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6613: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;

Line 6611: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

6607:
6608: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6609: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6610:
6611: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6612: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6613: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6614: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6615:

Line 6612: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

6608: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6609: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6610:
6611: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6612: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6613: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6614: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6615:
6616: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

Line 6613: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;

6609: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6610:
6611: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6612: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6613: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6614: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6615:
6616: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6617: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

Line 6614: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;

6610:
6611: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6612: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6613: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6614: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6615:
6616: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6617: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6618:

Line 6616: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

6612: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6613: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6614: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6615:
6616: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6617: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6618:
6619: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6620: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

Line 6617: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

6613: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6614: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6615:
6616: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6617: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6618:
6619: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6620: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6621:

Line 6619: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

6615:
6616: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6617: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6618:
6619: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6620: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6621:
6622: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6623: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 6620: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

6616: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6617: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6618:
6619: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6620: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6621:
6622: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6623: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6624: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;

Line 6622: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6618:
6619: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6620: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6621:
6622: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6623: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6624: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6625: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6626:

Line 6623: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6619: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6620: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6621:
6622: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6623: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6624: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6625: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6626:
6627: lp_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 6627: lp_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6623: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6624: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6625: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6626:
6627: lp_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6628: lx_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6629: lp_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6630: lx_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6631:

Line 6628: lx_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6624: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6625: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6626:
6627: lp_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6628: lx_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6629: lp_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6630: lx_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6631:
6632: lp_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 6632: lp_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6628: lx_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6629: lp_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6630: lx_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6631:
6632: lp_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6633: lx_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6634: lp_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6635: lx_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6636:

Line 6633: lx_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6629: lp_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6630: lx_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6631:
6632: lp_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6633: lx_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6634: lp_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6635: lx_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6636:
6637: lp_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 6637: lp_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6633: lx_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6634: lp_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6635: lx_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6636:
6637: lp_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6638: lx_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6639: lp_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6640: lx_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6641:

Line 6638: lx_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6634: lp_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6635: lx_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6636:
6637: lp_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6638: lx_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6639: lp_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6640: lx_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6641:
6642: lp_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 6642: lp_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6638: lx_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6639: lp_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6640: lx_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6641:
6642: lp_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6643: lx_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6644: lp_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6645: lx_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6646:

Line 6643: lx_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6639: lp_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6640: lx_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6641:
6642: lp_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6643: lx_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6644: lp_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6645: lx_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6646:
6647: lp_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 6647: lp_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6643: lx_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6644: lp_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6645: lx_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6646:
6647: lp_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6648: lx_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6649: lp_LAPACT_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6650: lx_LAPACT_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6651:

Line 6648: lx_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6644: lp_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6645: lx_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6646:
6647: lp_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6648: lx_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6649: lp_LAPACT_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6650: lx_LAPACT_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6651:
6652: lp_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

Line 6657: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;

6653: lp_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
6654: lx_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
6655: lx_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
6656:
6657: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
6658: lp_klev_rec okl_kle_pvt.klev_rec_type;
6659: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
6660: lx_klev_rec okl_kle_pvt.klev_rec_type;
6661:

Line 6659: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

6655: lx_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
6656:
6657: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
6658: lp_klev_rec okl_kle_pvt.klev_rec_type;
6659: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
6660: lx_klev_rec okl_kle_pvt.klev_rec_type;
6661:
6662: --Bug# 4558486
6663: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

Line 7194: OKL_OKC_MIGRATION_PVT.create_k_party_role(

7190: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
7191: -- to create records in tables
7192: -- okc_k_party_roles_b and okl_k_party_roles
7193: /*
7194: OKL_OKC_MIGRATION_PVT.create_k_party_role(
7195: p_api_version => p_api_version,
7196: p_init_msg_list => p_init_msg_list,
7197: x_return_status => x_return_status,
7198: x_msg_count => x_msg_count,

Line 7237: OKL_OKC_MIGRATION_PVT.update_k_party_role(

7233: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
7234: -- to update records in tables
7235: -- okc_k_party_roles_b and okl_k_party_roles
7236: /*
7237: OKL_OKC_MIGRATION_PVT.update_k_party_role(
7238: p_api_version => p_api_version,
7239: p_init_msg_list => p_init_msg_list,
7240: x_return_status => x_return_status,
7241: x_msg_count => x_msg_count,

Line 7277: OKL_OKC_MIGRATION_PVT.delete_k_party_role(

7273: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
7274: -- to delete records in tables
7275: -- okc_k_party_roles_b and okl_k_party_roles
7276: /*
7277: OKL_OKC_MIGRATION_PVT.delete_k_party_role(
7278: p_api_version => p_api_version,
7279: p_init_msg_list => p_init_msg_list,
7280: x_return_status => x_return_status,
7281: x_msg_count => x_msg_count,

Line 7323: OKL_OKC_MIGRATION_PVT.create_contact(

7319: lp_ctcv_rec.object1_id2 := x_durv_rec.contact_object1_id2;
7320: lp_ctcv_rec.jtot_object1_code := p_durv_rec.contact_jtot_object1_code;
7321: lp_ctcv_rec.cro_code := 'SALESPERSON';
7322:
7323: OKL_OKC_MIGRATION_PVT.create_contact(
7324: p_api_version => p_api_version,
7325: p_init_msg_list => p_init_msg_list,
7326: x_return_status => x_return_status,
7327: x_msg_count => x_msg_count,

Line 7350: OKL_OKC_MIGRATION_PVT.update_contact(

7346: lp_ctcv_rec.object1_id2 := x_durv_rec.contact_object1_id2;
7347: lp_ctcv_rec.jtot_object1_code := p_durv_rec.contact_jtot_object1_code;
7348: lp_ctcv_rec.cro_code := 'SALESPERSON';
7349:
7350: OKL_OKC_MIGRATION_PVT.update_contact(
7351: p_api_version => p_api_version,
7352: p_init_msg_list => p_init_msg_list,
7353: x_return_status => x_return_status,
7354: x_msg_count => x_msg_count,

Line 7375: OKL_OKC_MIGRATION_PVT.delete_contact(

7371: lp_ctcv_rec.object1_id2 := x_durv_rec.contact_object1_id2;
7372: lp_ctcv_rec.jtot_object1_code := p_durv_rec.contact_jtot_object1_code;
7373: lp_ctcv_rec.cro_code := 'SALESPERSON';
7374:
7375: OKL_OKC_MIGRATION_PVT.delete_contact(
7376: p_api_version => p_api_version,
7377: p_init_msg_list => p_init_msg_list,
7378: x_return_status => x_return_status,
7379: x_msg_count => x_msg_count,

Line 7402: OKL_OKC_MIGRATION_PVT.create_governance(

7398: lp_mla_gvev_rec.chr_id := p_durv_rec.chr_id;
7399: lp_mla_gvev_rec.chr_id_referred := x_durv_rec.mla_gvr_chr_id_referred;
7400: lp_mla_gvev_rec.copied_only_yn := 'N';
7401:
7402: OKL_OKC_MIGRATION_PVT.create_governance(
7403: p_api_version => p_api_version,
7404: p_init_msg_list => p_init_msg_list,
7405: x_return_status => x_return_status,
7406: x_msg_count => x_msg_count,

Line 7427: OKL_OKC_MIGRATION_PVT.update_governance(

7423: lp_mla_gvev_rec.chr_id := p_durv_rec.chr_id;
7424: lp_mla_gvev_rec.chr_id_referred := x_durv_rec.mla_gvr_chr_id_referred;
7425: lp_mla_gvev_rec.copied_only_yn := 'N';
7426:
7427: OKL_OKC_MIGRATION_PVT.update_governance(
7428: p_api_version => p_api_version,
7429: p_init_msg_list => p_init_msg_list,
7430: x_return_status => x_return_status,
7431: x_msg_count => x_msg_count,

Line 7450: OKL_OKC_MIGRATION_PVT.delete_governance(

7446: lp_mla_gvev_rec.chr_id := p_durv_rec.chr_id;
7447: lp_mla_gvev_rec.chr_id_referred := x_durv_rec.mla_gvr_chr_id_referred;
7448: lp_mla_gvev_rec.copied_only_yn := 'N';
7449:
7450: OKL_OKC_MIGRATION_PVT.delete_governance(
7451: p_api_version => p_api_version,
7452: p_init_msg_list => p_init_msg_list,
7453: x_return_status => x_return_status,
7454: x_msg_count => x_msg_count,

Line 7477: OKL_OKC_MIGRATION_PVT.create_governance(

7473: lp_cl_gvev_rec.chr_id := p_durv_rec.chr_id;
7474: lp_cl_gvev_rec.chr_id_referred := x_durv_rec.cl_gvr_chr_id_referred;
7475: lp_cl_gvev_rec.copied_only_yn := 'N';
7476:
7477: OKL_OKC_MIGRATION_PVT.create_governance(
7478: p_api_version => p_api_version,
7479: p_init_msg_list => p_init_msg_list,
7480: x_return_status => x_return_status,
7481: x_msg_count => x_msg_count,

Line 7502: OKL_OKC_MIGRATION_PVT.update_governance(

7498: lp_cl_gvev_rec.chr_id := p_durv_rec.chr_id;
7499: lp_cl_gvev_rec.chr_id_referred := x_durv_rec.cl_gvr_chr_id_referred;
7500: lp_cl_gvev_rec.copied_only_yn := 'N';
7501:
7502: OKL_OKC_MIGRATION_PVT.update_governance(
7503: p_api_version => p_api_version,
7504: p_init_msg_list => p_init_msg_list,
7505: x_return_status => x_return_status,
7506: x_msg_count => x_msg_count,

Line 7525: OKL_OKC_MIGRATION_PVT.delete_governance(

7521: lp_cl_gvev_rec.chr_id := p_durv_rec.chr_id;
7522: lp_cl_gvev_rec.chr_id_referred := x_durv_rec.cl_gvr_chr_id_referred;
7523: lp_cl_gvev_rec.copied_only_yn := 'N';
7524:
7525: OKL_OKC_MIGRATION_PVT.delete_governance(
7526: p_api_version => p_api_version,
7527: p_init_msg_list => p_init_msg_list,
7528: x_return_status => x_return_status,
7529: x_msg_count => x_msg_count,

Line 8708: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

8704: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
8705: l_api_name CONSTANT varchar2(30) := 'create_party';
8706: l_api_version CONSTANT NUMBER := 1.0;
8707:
8708: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8709: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8710: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8711: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8712:

Line 8709: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

8705: l_api_name CONSTANT varchar2(30) := 'create_party';
8706: l_api_version CONSTANT NUMBER := 1.0;
8707:
8708: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8709: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8710: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8711: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8712:
8713: Begin

Line 8823: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

8819: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
8820: l_api_name CONSTANT varchar2(30) := 'update_party';
8821: l_api_version CONSTANT NUMBER := 1.0;
8822:
8823: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8824: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8825: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8826: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8827:

Line 8824: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

8820: l_api_name CONSTANT varchar2(30) := 'update_party';
8821: l_api_version CONSTANT NUMBER := 1.0;
8822:
8823: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8824: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8825: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8826: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8827:
8828: Begin