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

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

Line 2546: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;

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

Line 2810: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;

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

Line 2811: lx_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;

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

Line 3529: x_new_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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

Line 4186: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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

Line 4187: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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

Line 4822: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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

Line 4823: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

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

Line 4859: lp_lahdtx_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

4855: l_rule_count NUMBER;
4856: --end bkatraga
4857:
4858: l_tax_schedule_yn VARCHAR2(1);
4859: lp_lahdtx_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
4860: lx_lahdtx_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
4861: lp_lahdtx_rulv_rec Okl_Rule_Pub.rulv_rec_type;
4862: lx_lahdtx_rulv_rec Okl_Rule_Pub.rulv_rec_type;
4863: l_rgp_id NUMBER;

Line 4860: lx_lahdtx_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

4856: --end bkatraga
4857:
4858: l_tax_schedule_yn VARCHAR2(1);
4859: lp_lahdtx_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
4860: lx_lahdtx_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
4861: lp_lahdtx_rulv_rec Okl_Rule_Pub.rulv_rec_type;
4862: lx_lahdtx_rulv_rec Okl_Rule_Pub.rulv_rec_type;
4863: l_rgp_id NUMBER;
4864: l_rgd_code VARCHAR2(30);

Line 5934: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

5930:
5931: l_auth_org_id okc_k_headers_b.authoring_org_id%type;
5932: l_inv_org_id okc_k_headers_b.inv_organization_id%type;
5933:
5934: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5935: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5936:
5937: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5938: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

Line 5935: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

5931: l_auth_org_id okc_k_headers_b.authoring_org_id%type;
5932: l_inv_org_id okc_k_headers_b.inv_organization_id%type;
5933:
5934: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5935: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5936:
5937: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5938: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5939:

Line 5940: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

5936:
5937: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5938: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5939:
5940: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5941: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5942:
5943: lp_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
5944: lp_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

Line 5941: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

5937: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5938: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5939:
5940: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5941: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5942:
5943: lp_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
5944: lp_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
5945: lx_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

Line 5948: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

5944: lp_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
5945: lx_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
5946: lx_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
5947:
5948: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5949: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5950:
5951: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5952: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

Line 5949: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

5945: lx_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
5946: lx_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
5947:
5948: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5949: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5950:
5951: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5952: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5953:

Line 5951: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

5947:
5948: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5949: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5950:
5951: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5952: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5953:
5954: X_NO_DATA_FOUND BOOLEAN := TRUE;
5955:

Line 5952: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

5948: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5949: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5950:
5951: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5952: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5953:
5954: X_NO_DATA_FOUND BOOLEAN := TRUE;
5955:
5956: --Bug# 4558486

Line 6285: OKL_OKC_MIGRATION_PVT.update_k_party_role(

6281: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
6282: -- to update records in tables
6283: -- okc_k_party_roles_b and okl_k_party_roles
6284: /*
6285: OKL_OKC_MIGRATION_PVT.update_k_party_role(
6286: p_api_version => p_api_version,
6287: p_init_msg_list => p_init_msg_list,
6288: x_return_status => x_return_status,
6289: x_msg_count => x_msg_count,

Line 6322: OKL_OKC_MIGRATION_PVT.create_governance(

6318: lp_mla_gvev_rec.chr_id := p_chr_id;
6319: lp_mla_gvev_rec.chr_id_referred := l_mla_id;
6320: lp_mla_gvev_rec.copied_only_yn := 'N';
6321:
6322: OKL_OKC_MIGRATION_PVT.create_governance(
6323: p_api_version => p_api_version,
6324: p_init_msg_list => p_init_msg_list,
6325: x_return_status => x_return_status,
6326: x_msg_count => x_msg_count,

Line 6345: OKL_OKC_MIGRATION_PVT.update_governance(

6341: lp_mla_gvev_rec.chr_id := p_chr_id;
6342: lp_mla_gvev_rec.chr_id_referred := l_mla_id;
6343: lp_mla_gvev_rec.copied_only_yn := 'N';
6344:
6345: OKL_OKC_MIGRATION_PVT.update_governance(
6346: p_api_version => p_api_version,
6347: p_init_msg_list => p_init_msg_list,
6348: x_return_status => x_return_status,
6349: x_msg_count => x_msg_count,

Line 6365: OKL_OKC_MIGRATION_PVT.delete_governance(

6361: ELSIF (p_gvr_id_mla IS NOT NULL AND p_mla_no IS NULL ) THEN
6362:
6363: lp_mla_gvev_rec.id := p_gvr_id_mla;
6364:
6365: OKL_OKC_MIGRATION_PVT.delete_governance(
6366: p_api_version => p_api_version,
6367: p_init_msg_list => p_init_msg_list,
6368: x_return_status => x_return_status,
6369: x_msg_count => x_msg_count,

Line 6394: OKL_OKC_MIGRATION_PVT.create_governance(

6390: lp_cl_gvev_rec.chr_id := p_chr_id;
6391: lp_cl_gvev_rec.chr_id_referred := l_cl_id;
6392: lp_cl_gvev_rec.copied_only_yn := 'N';
6393:
6394: OKL_OKC_MIGRATION_PVT.create_governance(
6395: p_api_version => p_api_version,
6396: p_init_msg_list => p_init_msg_list,
6397: x_return_status => x_return_status,
6398: x_msg_count => x_msg_count,

Line 6417: OKL_OKC_MIGRATION_PVT.update_governance(

6413: lp_cl_gvev_rec.chr_id := p_chr_id;
6414: lp_cl_gvev_rec.chr_id_referred := l_cl_id;
6415: lp_cl_gvev_rec.copied_only_yn := 'N';
6416:
6417: OKL_OKC_MIGRATION_PVT.update_governance(
6418: p_api_version => p_api_version,
6419: p_init_msg_list => p_init_msg_list,
6420: x_return_status => x_return_status,
6421: x_msg_count => x_msg_count,

Line 6436: OKL_OKC_MIGRATION_PVT.delete_governance(

6432: ELSIF (p_gvr_id_cl IS NOT NULL AND p_cl_no IS NULL ) THEN
6433:
6434: lp_cl_gvev_rec.id := p_gvr_id_cl;
6435:
6436: OKL_OKC_MIGRATION_PVT.delete_governance(
6437: p_api_version => p_api_version,
6438: p_init_msg_list => p_init_msg_list,
6439: x_return_status => x_return_status,
6440: x_msg_count => x_msg_count,

Line 6647: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

6643: SELECT vers.major_version||'.'||vers.minor_version
6644: FROM okc_k_vers_numbers_v vers
6645: WHERE vers.chr_id = p_durv_rec.chr_id;
6646:
6647: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
6648: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
6649:
6650: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6651: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

Line 6648: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

6644: FROM okc_k_vers_numbers_v vers
6645: WHERE vers.chr_id = p_durv_rec.chr_id;
6646:
6647: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
6648: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
6649:
6650: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6651: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6652:

Line 6653: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

6649:
6650: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6651: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6652:
6653: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6654: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6655:
6656: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6657: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

Line 6654: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

6650: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6651: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
6652:
6653: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6654: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6655:
6656: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6657: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6658: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;

Line 6656: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

6652:
6653: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6654: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6655:
6656: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6657: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6658: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6659: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6660:

Line 6657: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

6653: lp_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6654: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6655:
6656: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6657: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6658: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6659: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6660:
6661: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

Line 6658: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;

6654: lx_lessee_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6655:
6656: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6657: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6658: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6659: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6660:
6661: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6662: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

Line 6659: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;

6655:
6656: lp_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6657: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6658: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6659: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6660:
6661: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6662: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6663:

Line 6661: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

6657: lx_lessor_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
6658: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6659: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6660:
6661: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6662: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6663:
6664: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6665: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

Line 6662: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

6658: lp_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6659: lx_ctcv_rec OKL_OKC_MIGRATION_PVT.ctcv_rec_type;
6660:
6661: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6662: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6663:
6664: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6665: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6666:

Line 6664: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

6660:
6661: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6662: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6663:
6664: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6665: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6666:
6667: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6668: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 6665: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

6661: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6662: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6663:
6664: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6665: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6666:
6667: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6668: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6669: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;

Line 6667: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6663:
6664: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6665: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6666:
6667: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6668: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6669: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6670: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6671:

Line 6668: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6664: lp_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6665: lx_cl_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
6666:
6667: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6668: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6669: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6670: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6671:
6672: lp_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 6672: lp_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6668: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6669: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6670: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6671:
6672: lp_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6673: lx_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6674: lp_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6675: lx_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6676:

Line 6673: lx_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6669: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6670: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6671:
6672: lp_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6673: lx_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6674: lp_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6675: lx_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6676:
6677: lp_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 6677: lp_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6673: lx_LAREBL_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6674: lp_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6675: lx_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6676:
6677: lp_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6678: lx_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6679: lp_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6680: lx_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6681:

Line 6678: lx_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6674: lp_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6675: lx_LAREBL_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6676:
6677: lp_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6678: lx_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6679: lp_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6680: lx_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6681:
6682: lp_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 6682: lp_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6678: lx_LATOWN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6679: lp_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6680: lx_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6681:
6682: lp_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6683: lx_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6684: lp_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6685: lx_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6686:

Line 6683: lx_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6679: lp_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6680: lx_LATOWN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6681:
6682: lp_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6683: lx_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6684: lp_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6685: lx_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6686:
6687: lp_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 6687: lp_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6683: lx_LANNTF_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6684: lp_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6685: lx_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6686:
6687: lp_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6688: lx_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6689: lp_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6690: lx_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6691:

Line 6688: lx_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6684: lp_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6685: lx_LANNTF_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6686:
6687: lp_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6688: lx_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6689: lp_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6690: lx_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6691:
6692: lp_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 6692: lp_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6688: lx_LACPLN_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6689: lp_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6690: lx_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6691:
6692: lp_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6693: lx_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6694: lp_LAPACT_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6695: lx_LAPACT_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6696:

Line 6693: lx_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

6689: lp_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6690: lx_LACPLN_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6691:
6692: lp_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6693: lx_LAPACT_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
6694: lp_LAPACT_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6695: lx_LAPACT_rulv_rec Okl_Rule_Pub.rulv_rec_type;
6696:
6697: lp_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

Line 6702: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;

6698: lp_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
6699: lx_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
6700: lx_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
6701:
6702: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
6703: lp_klev_rec okl_kle_pvt.klev_rec_type;
6704: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
6705: lx_klev_rec okl_kle_pvt.klev_rec_type;
6706:

Line 6704: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

6700: lx_pdt_param_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
6701:
6702: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
6703: lp_klev_rec okl_kle_pvt.klev_rec_type;
6704: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
6705: lx_klev_rec okl_kle_pvt.klev_rec_type;
6706:
6707: --Bug# 4558486
6708: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

Line 7261: OKL_OKC_MIGRATION_PVT.create_k_party_role(

7257: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
7258: -- to create records in tables
7259: -- okc_k_party_roles_b and okl_k_party_roles
7260: /*
7261: OKL_OKC_MIGRATION_PVT.create_k_party_role(
7262: p_api_version => p_api_version,
7263: p_init_msg_list => p_init_msg_list,
7264: x_return_status => x_return_status,
7265: x_msg_count => x_msg_count,

Line 7304: OKL_OKC_MIGRATION_PVT.update_k_party_role(

7300: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
7301: -- to update records in tables
7302: -- okc_k_party_roles_b and okl_k_party_roles
7303: /*
7304: OKL_OKC_MIGRATION_PVT.update_k_party_role(
7305: p_api_version => p_api_version,
7306: p_init_msg_list => p_init_msg_list,
7307: x_return_status => x_return_status,
7308: x_msg_count => x_msg_count,

Line 7344: OKL_OKC_MIGRATION_PVT.delete_k_party_role(

7340: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
7341: -- to delete records in tables
7342: -- okc_k_party_roles_b and okl_k_party_roles
7343: /*
7344: OKL_OKC_MIGRATION_PVT.delete_k_party_role(
7345: p_api_version => p_api_version,
7346: p_init_msg_list => p_init_msg_list,
7347: x_return_status => x_return_status,
7348: x_msg_count => x_msg_count,

Line 7390: OKL_OKC_MIGRATION_PVT.create_contact(

7386: lp_ctcv_rec.object1_id2 := x_durv_rec.contact_object1_id2;
7387: lp_ctcv_rec.jtot_object1_code := p_durv_rec.contact_jtot_object1_code;
7388: lp_ctcv_rec.cro_code := 'SALESPERSON';
7389:
7390: OKL_OKC_MIGRATION_PVT.create_contact(
7391: p_api_version => p_api_version,
7392: p_init_msg_list => p_init_msg_list,
7393: x_return_status => x_return_status,
7394: x_msg_count => x_msg_count,

Line 7417: OKL_OKC_MIGRATION_PVT.update_contact(

7413: lp_ctcv_rec.object1_id2 := x_durv_rec.contact_object1_id2;
7414: lp_ctcv_rec.jtot_object1_code := p_durv_rec.contact_jtot_object1_code;
7415: lp_ctcv_rec.cro_code := 'SALESPERSON';
7416:
7417: OKL_OKC_MIGRATION_PVT.update_contact(
7418: p_api_version => p_api_version,
7419: p_init_msg_list => p_init_msg_list,
7420: x_return_status => x_return_status,
7421: x_msg_count => x_msg_count,

Line 7442: OKL_OKC_MIGRATION_PVT.delete_contact(

7438: lp_ctcv_rec.object1_id2 := x_durv_rec.contact_object1_id2;
7439: lp_ctcv_rec.jtot_object1_code := p_durv_rec.contact_jtot_object1_code;
7440: lp_ctcv_rec.cro_code := 'SALESPERSON';
7441:
7442: OKL_OKC_MIGRATION_PVT.delete_contact(
7443: p_api_version => p_api_version,
7444: p_init_msg_list => p_init_msg_list,
7445: x_return_status => x_return_status,
7446: x_msg_count => x_msg_count,

Line 7469: OKL_OKC_MIGRATION_PVT.create_governance(

7465: lp_mla_gvev_rec.chr_id := p_durv_rec.chr_id;
7466: lp_mla_gvev_rec.chr_id_referred := x_durv_rec.mla_gvr_chr_id_referred;
7467: lp_mla_gvev_rec.copied_only_yn := 'N';
7468:
7469: OKL_OKC_MIGRATION_PVT.create_governance(
7470: p_api_version => p_api_version,
7471: p_init_msg_list => p_init_msg_list,
7472: x_return_status => x_return_status,
7473: x_msg_count => x_msg_count,

Line 7494: OKL_OKC_MIGRATION_PVT.update_governance(

7490: lp_mla_gvev_rec.chr_id := p_durv_rec.chr_id;
7491: lp_mla_gvev_rec.chr_id_referred := x_durv_rec.mla_gvr_chr_id_referred;
7492: lp_mla_gvev_rec.copied_only_yn := 'N';
7493:
7494: OKL_OKC_MIGRATION_PVT.update_governance(
7495: p_api_version => p_api_version,
7496: p_init_msg_list => p_init_msg_list,
7497: x_return_status => x_return_status,
7498: x_msg_count => x_msg_count,

Line 7517: OKL_OKC_MIGRATION_PVT.delete_governance(

7513: lp_mla_gvev_rec.chr_id := p_durv_rec.chr_id;
7514: lp_mla_gvev_rec.chr_id_referred := x_durv_rec.mla_gvr_chr_id_referred;
7515: lp_mla_gvev_rec.copied_only_yn := 'N';
7516:
7517: OKL_OKC_MIGRATION_PVT.delete_governance(
7518: p_api_version => p_api_version,
7519: p_init_msg_list => p_init_msg_list,
7520: x_return_status => x_return_status,
7521: x_msg_count => x_msg_count,

Line 7544: OKL_OKC_MIGRATION_PVT.create_governance(

7540: lp_cl_gvev_rec.chr_id := p_durv_rec.chr_id;
7541: lp_cl_gvev_rec.chr_id_referred := x_durv_rec.cl_gvr_chr_id_referred;
7542: lp_cl_gvev_rec.copied_only_yn := 'N';
7543:
7544: OKL_OKC_MIGRATION_PVT.create_governance(
7545: p_api_version => p_api_version,
7546: p_init_msg_list => p_init_msg_list,
7547: x_return_status => x_return_status,
7548: x_msg_count => x_msg_count,

Line 7569: OKL_OKC_MIGRATION_PVT.update_governance(

7565: lp_cl_gvev_rec.chr_id := p_durv_rec.chr_id;
7566: lp_cl_gvev_rec.chr_id_referred := x_durv_rec.cl_gvr_chr_id_referred;
7567: lp_cl_gvev_rec.copied_only_yn := 'N';
7568:
7569: OKL_OKC_MIGRATION_PVT.update_governance(
7570: p_api_version => p_api_version,
7571: p_init_msg_list => p_init_msg_list,
7572: x_return_status => x_return_status,
7573: x_msg_count => x_msg_count,

Line 7592: OKL_OKC_MIGRATION_PVT.delete_governance(

7588: lp_cl_gvev_rec.chr_id := p_durv_rec.chr_id;
7589: lp_cl_gvev_rec.chr_id_referred := x_durv_rec.cl_gvr_chr_id_referred;
7590: lp_cl_gvev_rec.copied_only_yn := 'N';
7591:
7592: OKL_OKC_MIGRATION_PVT.delete_governance(
7593: p_api_version => p_api_version,
7594: p_init_msg_list => p_init_msg_list,
7595: x_return_status => x_return_status,
7596: x_msg_count => x_msg_count,

Line 8799: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

8795: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
8796: l_api_name CONSTANT varchar2(30) := 'create_party';
8797: l_api_version CONSTANT NUMBER := 1.0;
8798:
8799: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8800: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8801: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8802: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8803:

Line 8800: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

8796: l_api_name CONSTANT varchar2(30) := 'create_party';
8797: l_api_version CONSTANT NUMBER := 1.0;
8798:
8799: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8800: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8801: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8802: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8803:
8804: Begin

Line 8914: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

8910: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
8911: l_api_name CONSTANT varchar2(30) := 'update_party';
8912: l_api_version CONSTANT NUMBER := 1.0;
8913:
8914: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8915: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8916: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8917: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8918:

Line 8915: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

8911: l_api_name CONSTANT varchar2(30) := 'update_party';
8912: l_api_version CONSTANT NUMBER := 1.0;
8913:
8914: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8915: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
8916: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8917: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8918:
8919: Begin