eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CREDIT_PUB dependencies on OKL_OKC_MIGRATION_PVT

Line 62: subtype rgpv_rec_type is okl_okc_migration_pvt.rgpv_rec_type;

58:
59: ----------------------------------------------------------------------------
60: -- Data Structures
61: ----------------------------------------------------------------------------
62: subtype rgpv_rec_type is okl_okc_migration_pvt.rgpv_rec_type;
63: subtype rgpv_tbl_type is okl_okc_migration_pvt.rgpv_tbl_type;
64: subtype rulv_rec_type is okl_rule_pub.rulv_rec_type;
65: subtype rulv_tbl_type is okl_rule_pub.rulv_tbl_type;
66:

Line 63: subtype rgpv_tbl_type is okl_okc_migration_pvt.rgpv_tbl_type;

59: ----------------------------------------------------------------------------
60: -- Data Structures
61: ----------------------------------------------------------------------------
62: subtype rgpv_rec_type is okl_okc_migration_pvt.rgpv_rec_type;
63: subtype rgpv_tbl_type is okl_okc_migration_pvt.rgpv_tbl_type;
64: subtype rulv_rec_type is okl_rule_pub.rulv_rec_type;
65: subtype rulv_tbl_type is okl_rule_pub.rulv_tbl_type;
66:
67: ----------------------------------------------------------------------------------

Line 1361: p_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type

1357: -- Description: Check checklist templates when activate a credit line
1358: --
1359: --------------------------------------------------------------------------
1360: FUNCTION validate_credit_checklist(
1361: p_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type
1362: ,p_rulv_rec okl_rule_pub.rulv_rec_type
1363: ,p_mode VARCHAR2
1364: ) RETURN VARCHAR2
1365: IS

Line 1858: p_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type

1854: ----- only check @ create mode
1855: ----- UI will skip delete or modify the NEW LIMIT record
1856: --------------------------------------------------------------------------
1857: FUNCTION validate_credit_nature(
1858: p_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type
1859: ,p_klev_rec OKL_CONTRACT_PVT.klev_rec_type
1860: ) RETURN VARCHAR2
1861: IS
1862: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1907: p_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type

1903: --------------------------------------------------------------------------
1904: ----- Validate credit limit amount
1905: --------------------------------------------------------------------------
1906: FUNCTION validate_amount(
1907: p_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type
1908: ,p_klev_rec OKL_CONTRACT_PVT.klev_rec_type
1909: ) RETURN VARCHAR2
1910: IS
1911: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1968: p_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type

1964: --------------------------------------------------------------------------
1965: ----- Validate Credit Limit start date
1966: --------------------------------------------------------------------------
1967: FUNCTION validate_start_date(
1968: p_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type
1969: ,p_klev_rec OKL_CONTRACT_PVT.klev_rec_type
1970: ) RETURN VARCHAR2
1971: IS
1972: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2055: p_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type

2051: --------------------------------------------------------------------------
2052: ----- Validate Description
2053: --------------------------------------------------------------------------
2054: FUNCTION validate_description(
2055: p_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type
2056: ) RETURN VARCHAR2
2057: IS
2058: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2059: BEGIN

Line 2098: p_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type

2094: --------------------------------------------------------------------------
2095: ----- Validate Credit Number uniqueness check
2096: --------------------------------------------------------------------------
2097: FUNCTION validate_credit_number(
2098: p_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type
2099: ,p_mode VARCHAR2
2100: ) RETURN VARCHAR2
2101: IS
2102: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2172: p_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type

2168: --------------------------------------------------------------------------
2169: ----- Validate Effective From
2170: --------------------------------------------------------------------------
2171: FUNCTION validate_start_date(
2172: p_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type
2173: ,p_mode VARCHAR2
2174: ) RETURN VARCHAR2
2175: IS
2176: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2245: p_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type

2241: --------------------------------------------------------------------------
2242: ----- Validate Effective To
2243: --------------------------------------------------------------------------
2244: FUNCTION validate_end_date(
2245: p_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type
2246: ,p_mode VARCHAR2
2247: ) RETURN VARCHAR2
2248: IS
2249: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2331: p_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type

2327: ----- Validate Effective From and Effective To
2328: --------------------------------------------------------------------------
2329: FUNCTION validate_start_end_date(
2330:
2331: p_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type
2332: ,p_mode VARCHAR2
2333: ) RETURN VARCHAR2
2334: IS
2335: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2389: p_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type

2385: --------------------------------------------------------------------------
2386: ----- Validate Credit Amount when status change to 'Active'
2387: --------------------------------------------------------------------------
2388: FUNCTION validate_credit_amount(
2389: p_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type
2390: ) RETURN VARCHAR2
2391: IS
2392: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2393: l_amount NUMBER := 0;

Line 2457: p_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type

2453: --------------------------------------------------------------------------
2454: ----- Validate currency code
2455: --------------------------------------------------------------------------
2456: FUNCTION validate_currency_code(
2457: p_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type
2458: ,p_mode VARCHAR2
2459: ) RETURN VARCHAR2
2460: IS
2461: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2796: p_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type

2792: RETURN l_return_status;
2793: END;
2794: --------------------------------------------------------------------------
2795: FUNCTION validate_header_attributes(
2796: p_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type
2797: ,p_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type
2798: ,p_rulv_rec okl_rule_pub.rulv_rec_type
2799: ,p_mode VARCHAR2
2800: ) RETURN VARCHAR2

Line 2904: p_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type

2900: END validate_header_attributes;
2901:
2902: --------------------------------------------------------------------------
2903: FUNCTION validate_status_is_active(
2904: p_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type
2905: ,p_mode VARCHAR2
2906: ) RETURN VARCHAR2
2907: IS
2908: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 3215: l_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

3211: AS
3212: l_api_version CONSTANT NUMBER := 1.0;
3213: l_api_name VARCHAR2(30) := 'VALIDATE_CREDIT';
3214: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3215: l_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3216: l_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3217:
3218: lp_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
3219:

Line 3448: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

3444:
3445: --------------------------------------------------------------------------
3446: FUNCTION validate_line_attributes(
3447: p_mode IN VARCHAR2,
3448: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
3449: p_klev_rec IN klev_rec_type
3450: ) RETURN VARCHAR2
3451: IS
3452: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 3526: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

3522: AS
3523: l_api_version CONSTANT NUMBER := 1.0;
3524: l_api_name VARCHAR2(30) := 'VALIDATE_CREDIT_LIMIT';
3525: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3526: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
3527: l_klev_rec OKL_CONTRACT_PVT.klev_rec_type;
3528:
3529: BEGIN
3530: x_return_status := OKC_API.START_ACTIVITY(

Line 3606: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

3602: x_return_status OUT NOCOPY VARCHAR2,
3603: x_msg_count OUT NOCOPY NUMBER,
3604: x_msg_data OUT NOCOPY VARCHAR2,
3605: p_mode IN VARCHAR2,
3606: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
3607: p_klev_rec IN klev_rec_type)
3608: AS
3609: l_api_version CONSTANT NUMBER := 1.0;
3610: l_api_name VARCHAR2(30) := 'VALIDATE_CREDIT_LIMIT1';

Line 3669: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

3665: x_return_status OUT NOCOPY VARCHAR2,
3666: x_msg_count OUT NOCOPY NUMBER,
3667: x_msg_data OUT NOCOPY VARCHAR2,
3668: p_mode IN VARCHAR2,
3669: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
3670: p_klev_tbl IN klev_tbl_type)
3671: AS
3672: l_api_version CONSTANT NUMBER := 1.0;
3673: l_api_name VARCHAR2(30) := 'VALIDATE_CREDIT_LIMIT2';

Line 3675: l_clev_tbl okl_okc_migration_pvt.clev_tbl_type := p_clev_tbl;

3671: AS
3672: l_api_version CONSTANT NUMBER := 1.0;
3673: l_api_name VARCHAR2(30) := 'VALIDATE_CREDIT_LIMIT2';
3674: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3675: l_clev_tbl okl_okc_migration_pvt.clev_tbl_type := p_clev_tbl;
3676: l_klev_tbl klev_tbl_type := p_klev_tbl;
3677: i NUMBER;
3678:
3679: BEGIN

Line 3760: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,

3756: -- funding checklist enhancement
3757: p_credit_ckl_id IN NUMBER,
3758: p_funding_ckl_id IN NUMBER,
3759: -- funding checklist enhancement
3760: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
3761: p_khrv_rec IN khrv_rec_type,
3762: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
3763: x_khrv_rec OUT NOCOPY khrv_rec_type)
3764: is

Line 3762: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,

3758: p_funding_ckl_id IN NUMBER,
3759: -- funding checklist enhancement
3760: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
3761: p_khrv_rec IN khrv_rec_type,
3762: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
3763: x_khrv_rec OUT NOCOPY khrv_rec_type)
3764: is
3765: l_api_name CONSTANT VARCHAR2(30) := 'create_credit_header_pub';
3766: l_api_version CONSTANT NUMBER := 1.0;

Line 3770: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

3766: l_api_version CONSTANT NUMBER := 1.0;
3767: i NUMBER;
3768: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3769:
3770: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3771: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3772: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3773: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3774:

Line 3771: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

3767: i NUMBER;
3768: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3769:
3770: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3771: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3772: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3773: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3774:
3775: begin

Line 3860: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,

3856: p_chklst_tpl_rule_id IN NUMBER, -- LACCLT
3857: p_credit_ckl_id IN NUMBER,
3858: p_funding_ckl_id IN NUMBER,
3859: -- funding checklist enhancement
3860: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
3861: p_khrv_rec IN khrv_rec_type,
3862: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
3863: x_khrv_rec OUT NOCOPY khrv_rec_type)
3864: is

Line 3862: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,

3858: p_funding_ckl_id IN NUMBER,
3859: -- funding checklist enhancement
3860: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
3861: p_khrv_rec IN khrv_rec_type,
3862: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
3863: x_khrv_rec OUT NOCOPY khrv_rec_type)
3864: is
3865:
3866: -- vthiruva Code change to enable Business Event START

Line 3881: lp_chrv_rec okl_okc_migration_pvt.chrv_rec_type := p_chrv_rec;

3877: i NUMBER;
3878: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3879:
3880: -- multi-currency support
3881: lp_chrv_rec okl_okc_migration_pvt.chrv_rec_type := p_chrv_rec;
3882: lp_khrv_rec khrv_rec_type := p_khrv_rec;
3883: -- multi-currency support
3884:
3885: -- funding checklist enhancement for 11.5.9

Line 4169: p_clev_migr_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type)

4165: -- End of comments
4166: ----------------------------------------------------------------------------------
4167: PROCEDURE copy_clev_rec(
4168: p_clev_rec IN clev_rec_type,
4169: p_clev_migr_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type)
4170: is
4171: begin
4172: p_clev_migr_rec.id := p_clev_rec.id;
4173: p_clev_migr_rec.dnz_chr_id := p_clev_rec.dnz_chr_id;

Line 4197: p_clev_migr_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type)

4193: -- End of comments
4194: ----------------------------------------------------------------------------------
4195: PROCEDURE copy_clev_tbl(
4196: p_clev_tbl IN clev_tbl_type,
4197: p_clev_migr_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type)
4198: is
4199: i number;
4200: begin
4201:

Line 4343: -- p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

4339: p_init_msg_list IN VARCHAR2,
4340: x_return_status OUT NOCOPY VARCHAR2,
4341: x_msg_count OUT NOCOPY NUMBER,
4342: x_msg_data OUT NOCOPY VARCHAR2,
4343: -- p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
4344: p_clev_tbl IN clev_tbl_type,
4345: p_klev_tbl IN klev_tbl_type,
4346: -- x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
4347: x_clev_tbl OUT NOCOPY clev_tbl_type,

Line 4346: -- x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,

4342: x_msg_data OUT NOCOPY VARCHAR2,
4343: -- p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
4344: p_clev_tbl IN clev_tbl_type,
4345: p_klev_tbl IN klev_tbl_type,
4346: -- x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
4347: x_clev_tbl OUT NOCOPY clev_tbl_type,
4348: x_klev_tbl OUT NOCOPY klev_tbl_type)
4349: is
4350: l_api_name CONSTANT VARCHAR2(30) := 'create_credit_limit_pub';

Line 4354: lp_clev_tbl okl_okc_migration_pvt.clev_tbl_type;

4350: l_api_name CONSTANT VARCHAR2(30) := 'create_credit_limit_pub';
4351: l_api_version CONSTANT NUMBER := 1.0;
4352: i NUMBER;
4353: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4354: lp_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4355: lx_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4356:
4357: begin
4358: -- Set API savepoint

Line 4355: lx_clev_tbl okl_okc_migration_pvt.clev_tbl_type;

4351: l_api_version CONSTANT NUMBER := 1.0;
4352: i NUMBER;
4353: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4354: lp_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4355: lx_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4356:
4357: begin
4358: -- Set API savepoint
4359: SAVEPOINT create_credit_limit_pub;

Line 4637: -- p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

4633: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4634: x_return_status OUT NOCOPY VARCHAR2,
4635: x_msg_count OUT NOCOPY NUMBER,
4636: x_msg_data OUT NOCOPY VARCHAR2,
4637: -- p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
4638: p_clev_tbl IN clev_tbl_type,
4639: p_klev_tbl IN klev_tbl_type,
4640: -- x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
4641: x_clev_tbl OUT NOCOPY clev_tbl_type,

Line 4640: -- x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,

4636: x_msg_data OUT NOCOPY VARCHAR2,
4637: -- p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
4638: p_clev_tbl IN clev_tbl_type,
4639: p_klev_tbl IN klev_tbl_type,
4640: -- x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
4641: x_clev_tbl OUT NOCOPY clev_tbl_type,
4642: x_klev_tbl OUT NOCOPY klev_tbl_type)
4643: is
4644: l_api_name CONSTANT VARCHAR2(30) := 'update_credit_limit_pub';

Line 4648: lp_clev_tbl okl_okc_migration_pvt.clev_tbl_type;

4644: l_api_name CONSTANT VARCHAR2(30) := 'update_credit_limit_pub';
4645: l_api_version CONSTANT NUMBER := 1.0;
4646: i NUMBER;
4647: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4648: lp_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4649: lx_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4650:
4651: -- rabhupat bug 4435390 start (cklee okl.h Bug 4506351 (okl.g bug#4435390))
4652: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 4649: lx_clev_tbl okl_okc_migration_pvt.clev_tbl_type;

4645: l_api_version CONSTANT NUMBER := 1.0;
4646: i NUMBER;
4647: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4648: lp_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4649: lx_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4650:
4651: -- rabhupat bug 4435390 start (cklee okl.h Bug 4506351 (okl.g bug#4435390))
4652: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4653: -- rabhupat bug 4435390 end (cklee okl.h Bug 4506351 (okl.g bug#4435390))

Line 4814: -- p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

4810: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4811: x_return_status OUT NOCOPY VARCHAR2,
4812: x_msg_count OUT NOCOPY NUMBER,
4813: x_msg_data OUT NOCOPY VARCHAR2,
4814: -- p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
4815: p_clev_tbl IN clev_tbl_type,
4816: p_klev_tbl IN klev_tbl_type)
4817: is
4818:

Line 4823: lp_clev_tbl okl_okc_migration_pvt.clev_tbl_type;

4819: l_api_name CONSTANT VARCHAR2(30) := 'delete_credit_limit_pub';
4820: l_api_version CONSTANT NUMBER := 1.0;
4821: i NUMBER;
4822: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4823: lp_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4824: -- lx_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4825:
4826: begin
4827: -- Set API savepoint

Line 4824: -- lx_clev_tbl okl_okc_migration_pvt.clev_tbl_type;

4820: l_api_version CONSTANT NUMBER := 1.0;
4821: i NUMBER;
4822: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4823: lp_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4824: -- lx_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4825:
4826: begin
4827: -- Set API savepoint
4828: SAVEPOINT delete_credit_limit_pub;

Line 5282: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

5278: p_organization_id IN NUMBER,
5279: p_source_chr_id IN NUMBER,
5280: x_chr_id OUT NOCOPY NUMBER)
5281: AS
5282: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5283:
5284:
5285: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5286: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

Line 5285: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

5281: AS
5282: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5283:
5284:
5285: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5286: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5287: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5288:
5289: lp_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;

Line 6061: lp_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

6057: l_api_version CONSTANT NUMBER := 1.0;
6058: i NUMBER;
6059: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6060:
6061: lp_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
6062: lp_khrv_rec khrv_rec_type;
6063: lx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
6064: lx_khrv_rec khrv_rec_type;
6065:

Line 6063: lx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

6059: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6060:
6061: lp_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
6062: lp_khrv_rec khrv_rec_type;
6063: lx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
6064: lx_khrv_rec khrv_rec_type;
6065:
6066: begin
6067: -- Set API savepoint

Line 6436: lp_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

6432:
6433:
6434: l_credit_rec c_credit%ROWTYPE;
6435:
6436: lp_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
6437: lp_khrv_rec khrv_rec_type;
6438: lx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
6439: lx_khrv_rec khrv_rec_type;
6440:

Line 6438: lx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

6434: l_credit_rec c_credit%ROWTYPE;
6435:
6436: lp_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
6437: lp_khrv_rec khrv_rec_type;
6438: lx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
6439: lx_khrv_rec khrv_rec_type;
6440:
6441:
6442: BEGIN