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_CONTRACT_PVT dependencies on OKL_OKC_MIGRATION_PVT

Line 520: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

516: --'N' Normal
517: --'L' Copy start and end dates on to lines
518: --'P' Violates product effictivity dates
519:
520: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
521: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
522:
523: --Cursor to find out the product from_date and to_date
524: Cursor pdt_dts_csr(p_chr_id IN NUMBER) IS

Line 521: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

517: --'L' Copy start and end dates on to lines
518: --'P' Violates product effictivity dates
519:
520: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
521: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
522:
523: --Cursor to find out the product from_date and to_date
524: Cursor pdt_dts_csr(p_chr_id IN NUMBER) IS
525: Select pdt.from_date,

Line 913: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

909:
910: l_fin_asst Varchar2(1) default 'N';
911: l_cle_id Number;
912:
913: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
914: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
915:
916: --Cursor to check asset number on txl
917: CURSOR l_txlv_csr (p_finasst_id IN NUMBER, P_Asstno IN VARCHAR2) is

Line 914: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

910: l_fin_asst Varchar2(1) default 'N';
911: l_cle_id Number;
912:
913: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
914: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
915:
916: --Cursor to check asset number on txl
917: CURSOR l_txlv_csr (p_finasst_id IN NUMBER, P_Asstno IN VARCHAR2) is
918: Select txlv.id,

Line 1008: okl_okc_migration_pvt.update_contract_line(

1004: --dbms_output.put_line(l_asset_no);
1005: --update asset number on top line
1006: l_clev_rec.id := l_cle_id;
1007: l_clev_rec.name := l_asset_no;
1008: okl_okc_migration_pvt.update_contract_line(
1009: p_api_version => p_api_version,
1010: p_init_msg_list => p_init_msg_list,
1011: x_return_status => x_return_status,
1012: x_msg_count => x_msg_count,

Line 1177: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

1173: and cim.object1_id1 = to_char(p_line_id)
1174: and cim.object1_id2 = '#';
1175:
1176: l_lnk_cle_id OKC_K_LINES_B.ID%TYPE;
1177: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
1178: l_clev_rec_out OKL_OKC_MIGRATION_PVT.clev_rec_type;
1179: l_deletion_type Varchar2(1);
1180:
1181: Begin

Line 1178: l_clev_rec_out OKL_OKC_MIGRATION_PVT.clev_rec_type;

1174: and cim.object1_id2 = '#';
1175:
1176: l_lnk_cle_id OKC_K_LINES_B.ID%TYPE;
1177: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
1178: l_clev_rec_out OKL_OKC_MIGRATION_PVT.clev_rec_type;
1179: l_deletion_type Varchar2(1);
1180:
1181: Begin
1182: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1206: okl_okc_migration_pvt.update_contract_line

1202: --do logical deletion of linked asset line
1203: l_clev_rec.id := l_lnk_cle_id;
1204: l_clev_rec.sts_code := G_OKL_CANCELLED_STS_CODE;
1205:
1206: okl_okc_migration_pvt.update_contract_line
1207: (p_api_version => p_api_version,
1208: p_init_msg_list => p_init_msg_list,
1209: x_return_status => x_return_status,
1210: x_msg_count => x_msg_count,

Line 1304: Procedure get_line_dates(p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

1300: -- Parameters :
1301: -- Version : 1.0
1302: -- End of comments
1303: --------------------------------------------------------------------------------
1304: Procedure get_line_dates(p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
1305: x_return_status OUT NOCOPY Varchar2,
1306: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type) is
1307:
1308: l_return_status Varchar2(1) default OKL_API.G_RET_STS_SUCCESS;

Line 1306: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type) is

1302: -- End of comments
1303: --------------------------------------------------------------------------------
1304: Procedure get_line_dates(p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
1305: x_return_status OUT NOCOPY Varchar2,
1306: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type) is
1307:
1308: l_return_status Varchar2(1) default OKL_API.G_RET_STS_SUCCESS;
1309: --cursor to get contract header dates
1310: cursor l_chr_csr (p_chr_id in number) is

Line 1348: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

1344:
1345: l_lty_code okc_line_styles_b.lty_code%TYPE;
1346: l_lse_type okc_line_styles_b.lse_type%TYPE;
1347:
1348: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
1349:
1350: l_rbk_cpy varchar2(1) default 'N';
1351:
1352: --Cursor to find out Rebook date

Line 1493: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,

1489: p_init_msg_list IN VARCHAR2,
1490: x_msg_count OUT NOCOPY NUMBER,
1491: x_msg_data OUT NOCOPY VARCHAR2,
1492: x_return_status OUT NOCOPY VARCHAR2,
1493: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
1494: p_khrv_rec IN khrv_rec_type,
1495: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
1496: x_khrv_rec OUT NOCOPY khrv_rec_type
1497: ) IS

Line 1495: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,

1491: x_msg_data OUT NOCOPY VARCHAR2,
1492: x_return_status OUT NOCOPY VARCHAR2,
1493: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
1494: p_khrv_rec IN khrv_rec_type,
1495: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
1496: x_khrv_rec OUT NOCOPY khrv_rec_type
1497: ) IS
1498:
1499: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

Line 1499: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

1495: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
1496: x_khrv_rec OUT NOCOPY khrv_rec_type
1497: ) IS
1498:
1499: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
1500: l_khrv_rec khrv_rec_type;
1501: l_func_currency GL_CURRENCIES.CURRENCY_CODE%TYPE;
1502: currency_validation_failed EXCEPTION;
1503:

Line 1705: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,

1701: p_init_msg_list IN VARCHAR2,
1702: x_return_status OUT NOCOPY VARCHAR2,
1703: x_msg_count OUT NOCOPY NUMBER,
1704: x_msg_data OUT NOCOPY VARCHAR2,
1705: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
1706: p_pdt_id IN NUMBER,
1707: x_deal_type OUT NOCOPY VARCHAR2,
1708: x_tax_owner OUT NOCOPY VARCHAR2,
1709: --bug# 3180583

Line 2365: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,

2361: p_init_msg_list IN VARCHAR2,
2362: x_return_status OUT NOCOPY VARCHAR2,
2363: x_msg_count OUT NOCOPY NUMBER,
2364: x_msg_data OUT NOCOPY VARCHAR2,
2365: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
2366: p_khrv_rec IN khrv_rec_type,
2367: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
2368: x_khrv_rec OUT NOCOPY khrv_rec_type) IS
2369:

Line 2367: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,

2363: x_msg_count OUT NOCOPY NUMBER,
2364: x_msg_data OUT NOCOPY VARCHAR2,
2365: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
2366: p_khrv_rec IN khrv_rec_type,
2367: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
2368: x_khrv_rec OUT NOCOPY khrv_rec_type) IS
2369:
2370: subtype rulv_tbl_type is OKL_RULE_PUB.rulv_tbl_type;
2371:

Line 2372: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

2368: x_khrv_rec OUT NOCOPY khrv_rec_type) IS
2369:
2370: subtype rulv_tbl_type is OKL_RULE_PUB.rulv_tbl_type;
2371:
2372: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
2373: l_khrv_rec khrv_rec_type;
2374:
2375: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_HEADER';
2376: l_api_version CONSTANT NUMBER := 1.0;

Line 2380: l_curr_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

2376: l_api_version CONSTANT NUMBER := 1.0;
2377: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2378: --Bug # : 11.5.9 Enhancement - Multi Currency changes
2379:
2380: l_curr_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
2381: l_curr_khrv_rec khrv_rec_type;
2382:
2383: --Bug # : 11.5.9 Enhancement - Defaulting from product definition
2384: l_pdt_deal_type varchar2(150);

Line 2537: okl_okc_migration_pvt.create_contract_header(

2533: -- call procedure in complex API
2534: --
2535: --OKC_CONTRACT_PUB.create_contract_header(
2536:
2537: okl_okc_migration_pvt.create_contract_header(
2538: p_api_version => p_api_version,
2539: p_init_msg_list => p_init_msg_list,
2540: x_return_status => x_return_status,
2541: x_msg_count => x_msg_count,

Line 2754: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,

2750: p_init_msg_list IN VARCHAR2,
2751: x_return_status OUT NOCOPY VARCHAR2,
2752: x_msg_count OUT NOCOPY NUMBER,
2753: x_msg_data OUT NOCOPY VARCHAR2,
2754: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
2755: p_khrv_tbl IN khrv_tbl_type,
2756: x_chrv_tbl OUT NOCOPY okl_okc_migration_pvt.chrv_tbl_type,
2757: x_khrv_tbl OUT NOCOPY khrv_tbl_type) IS
2758:

Line 2756: x_chrv_tbl OUT NOCOPY okl_okc_migration_pvt.chrv_tbl_type,

2752: x_msg_count OUT NOCOPY NUMBER,
2753: x_msg_data OUT NOCOPY VARCHAR2,
2754: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
2755: p_khrv_tbl IN khrv_tbl_type,
2756: x_chrv_tbl OUT NOCOPY okl_okc_migration_pvt.chrv_tbl_type,
2757: x_khrv_tbl OUT NOCOPY khrv_tbl_type) IS
2758:
2759: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_HEADER';
2760: l_api_version CONSTANT NUMBER := 1.0;

Line 2872: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,

2868: x_return_status OUT NOCOPY VARCHAR2,
2869: x_msg_count OUT NOCOPY NUMBER,
2870: x_msg_data OUT NOCOPY VARCHAR2,
2871: p_restricted_update IN VARCHAR2,
2872: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
2873: p_khrv_rec IN khrv_rec_type,
2874: p_edit_mode IN VARCHAR2,
2875: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
2876: x_khrv_rec OUT NOCOPY khrv_rec_type) IS

Line 2875: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,

2871: p_restricted_update IN VARCHAR2,
2872: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
2873: p_khrv_rec IN khrv_rec_type,
2874: p_edit_mode IN VARCHAR2,
2875: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
2876: x_khrv_rec OUT NOCOPY khrv_rec_type) IS
2877:
2878:
2879: subtype rulv_tbl_type is OKL_RULE_PUB.rulv_tbl_type;

Line 2880: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

2876: x_khrv_rec OUT NOCOPY khrv_rec_type) IS
2877:
2878:
2879: subtype rulv_tbl_type is OKL_RULE_PUB.rulv_tbl_type;
2880: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
2881: l_khrv_rec khrv_rec_type;
2882:
2883: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';
2884: l_api_version CONSTANT NUMBER := 1.0;

Line 2934: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

2930: --Bug#
2931: l_lse_id OKC_K_LINES_B.lse_id%TYPE;
2932:
2933:
2934: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
2935: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
2936:
2937: -------------------------------------------------------------------------
2938: --Bug# : 11.5.9 Multi-currency/product validation enhancements

Line 2935: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

2931: l_lse_id OKC_K_LINES_B.lse_id%TYPE;
2932:
2933:
2934: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
2935: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
2936:
2937: -------------------------------------------------------------------------
2938: --Bug# : 11.5.9 Multi-currency/product validation enhancements
2939: -------------------------------------------------------------------------

Line 2999: l_curr_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

2995: i number;
2996: -- Bug 7610725 end
2997:
2998:
2999: l_curr_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
3000: l_curr_khrv_rec khrv_rec_type;
3001:
3002: l_pdt_deal_type varchar2(150);
3003: l_pdt_tax_owner varchar2(150);

Line 3449: okl_okc_migration_pvt.update_contract_header(

3445: -- call procedure in complex API
3446: --
3447: -- OKC_CONTRACT_PUB.update_contract_header(
3448:
3449: okl_okc_migration_pvt.update_contract_header(
3450: p_api_version => p_api_version,
3451: p_init_msg_list => p_init_msg_list,
3452: x_return_status => x_return_status,
3453: x_msg_count => x_msg_count,

Line 3811: okl_okc_migration_pvt.update_contract_line(

3807:
3808: End If; --lty code not service fee or subsidy
3809:
3810:
3811: okl_okc_migration_pvt.update_contract_line(
3812: p_api_version => p_api_version,
3813: p_init_msg_list => p_init_msg_list,
3814: x_return_status => x_return_status,
3815: x_msg_count => x_msg_count,

Line 4013: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,

4009: x_return_status OUT NOCOPY VARCHAR2,
4010: x_msg_count OUT NOCOPY NUMBER,
4011: x_msg_data OUT NOCOPY VARCHAR2,
4012: p_restricted_update IN VARCHAR2,
4013: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
4014: p_khrv_rec IN khrv_rec_type,
4015: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
4016: x_khrv_rec OUT NOCOPY khrv_rec_type) IS
4017:

Line 4015: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,

4011: x_msg_data OUT NOCOPY VARCHAR2,
4012: p_restricted_update IN VARCHAR2,
4013: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
4014: p_khrv_rec IN khrv_rec_type,
4015: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
4016: x_khrv_rec OUT NOCOPY khrv_rec_type) IS
4017:
4018: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
4019: l_khrv_rec khrv_rec_type;

Line 4018: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

4014: p_khrv_rec IN khrv_rec_type,
4015: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
4016: x_khrv_rec OUT NOCOPY khrv_rec_type) IS
4017:
4018: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
4019: l_khrv_rec khrv_rec_type;
4020:
4021: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';
4022: l_api_version CONSTANT NUMBER := 1.0;

Line 4120: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,

4116: x_return_status OUT NOCOPY VARCHAR2,
4117: x_msg_count OUT NOCOPY NUMBER,
4118: x_msg_data OUT NOCOPY VARCHAR2,
4119: p_restricted_update IN VARCHAR2,
4120: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
4121: p_khrv_tbl IN khrv_tbl_type,
4122: x_chrv_tbl OUT NOCOPY okl_okc_migration_pvt.chrv_tbl_type,
4123: x_khrv_tbl OUT NOCOPY khrv_tbl_type) IS
4124:

Line 4122: x_chrv_tbl OUT NOCOPY okl_okc_migration_pvt.chrv_tbl_type,

4118: x_msg_data OUT NOCOPY VARCHAR2,
4119: p_restricted_update IN VARCHAR2,
4120: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
4121: p_khrv_tbl IN khrv_tbl_type,
4122: x_chrv_tbl OUT NOCOPY okl_okc_migration_pvt.chrv_tbl_type,
4123: x_khrv_tbl OUT NOCOPY khrv_tbl_type) IS
4124:
4125: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';
4126: l_api_version CONSTANT NUMBER := 1.0;

Line 4236: SUBTYPE chrv_rec_type IS OKL_OKC_MIGRATION_PVT.CHRV_REC_TYPE;

4232: x_msg_count OUT NOCOPY NUMBER,
4233: x_msg_data OUT NOCOPY VARCHAR2,
4234: p_contract_id IN okc_k_headers_b.id%TYPE) IS
4235:
4236: SUBTYPE chrv_rec_type IS OKL_OKC_MIGRATION_PVT.CHRV_REC_TYPE;
4237: SUBTYPE khrv_rec_type IS OKL_CONTRACT_PUB.KHRV_REC_TYPE;
4238: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
4239: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
4240: G_NO_MATCHING_RECORD CONSTANT VARCHAR2(200) := 'OKL_LLA_NO_MATCHING_RECORD';

Line 4432: l_cplv_tbl_in OKL_OKC_MIGRATION_PVT.cplv_tbl_type;

4428:
4429: FUNCTION DELETE_K_PARTY_ROLES( p_chr_id number) Return varchar2 IS
4430:
4431: --Bug# 4558486
4432: l_cplv_tbl_in OKL_OKC_MIGRATION_PVT.cplv_tbl_type;
4433: l_return_status varchar2(30);
4434:
4435: CURSOR l_cplv_csr (p_id IN NUMBER) IS
4436: SELECT ID

Line 4966: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,

4962: p_init_msg_list IN VARCHAR2,
4963: x_return_status OUT NOCOPY VARCHAR2,
4964: x_msg_count OUT NOCOPY NUMBER,
4965: x_msg_data OUT NOCOPY VARCHAR2,
4966: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
4967: p_khrv_rec IN khrv_rec_type) IS
4968:
4969: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
4970: l_khrv_rec khrv_rec_type;

Line 4969: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

4965: x_msg_data OUT NOCOPY VARCHAR2,
4966: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
4967: p_khrv_rec IN khrv_rec_type) IS
4968:
4969: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
4970: l_khrv_rec khrv_rec_type;
4971:
4972: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_HEADER';
4973: l_api_version CONSTANT NUMBER := 1.0;

Line 5008: okl_okc_migration_pvt.delete_contract_header(

5004:
5005: --
5006: -- call procedure in complex API
5007: --
5008: okl_okc_migration_pvt.delete_contract_header(
5009: p_api_version => p_api_version,
5010: p_init_msg_list => p_init_msg_list,
5011: x_return_status => x_return_status,
5012: x_msg_count => x_msg_count,

Line 5084: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,

5080: p_init_msg_list IN VARCHAR2,
5081: x_return_status OUT NOCOPY VARCHAR2,
5082: x_msg_count OUT NOCOPY NUMBER,
5083: x_msg_data OUT NOCOPY VARCHAR2,
5084: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
5085: p_khrv_tbl IN khrv_tbl_type) IS
5086:
5087: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_HEADER';
5088: l_api_version CONSTANT NUMBER := 1.0;

Line 5192: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,

5188: p_init_msg_list IN VARCHAR2,
5189: x_return_status OUT NOCOPY VARCHAR2,
5190: x_msg_count OUT NOCOPY NUMBER,
5191: x_msg_data OUT NOCOPY VARCHAR2,
5192: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
5193: p_khrv_rec IN khrv_rec_type) IS
5194:
5195: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
5196: l_khrv_rec khrv_rec_type;

Line 5195: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

5191: x_msg_data OUT NOCOPY VARCHAR2,
5192: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
5193: p_khrv_rec IN khrv_rec_type) IS
5194:
5195: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
5196: l_khrv_rec khrv_rec_type;
5197:
5198: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_CONTRACT_HEADER';
5199: l_api_version CONSTANT NUMBER := 1.0;

Line 5234: okl_okc_migration_pvt.lock_contract_header(

5230:
5231: --
5232: -- call procedure in complex API
5233: --
5234: okl_okc_migration_pvt.lock_contract_header(
5235: p_api_version => p_api_version,
5236: p_init_msg_list => p_init_msg_list,
5237: x_return_status => x_return_status,
5238: x_msg_count => x_msg_count,

Line 5310: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,

5306: p_init_msg_list IN VARCHAR2,
5307: x_return_status OUT NOCOPY VARCHAR2,
5308: x_msg_count OUT NOCOPY NUMBER,
5309: x_msg_data OUT NOCOPY VARCHAR2,
5310: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
5311: p_khrv_tbl IN khrv_tbl_type) IS
5312:
5313: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_CONTRACT_HEADER';
5314: l_api_version CONSTANT NUMBER := 1.0;

Line 5419: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,

5415: p_init_msg_list IN VARCHAR2,
5416: x_return_status OUT NOCOPY VARCHAR2,
5417: x_msg_count OUT NOCOPY NUMBER,
5418: x_msg_data OUT NOCOPY VARCHAR2,
5419: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
5420: p_khrv_rec IN khrv_rec_type) IS
5421:
5422: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
5423: l_khrv_rec khrv_rec_type;

Line 5422: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

5418: x_msg_data OUT NOCOPY VARCHAR2,
5419: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
5420: p_khrv_rec IN khrv_rec_type) IS
5421:
5422: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
5423: l_khrv_rec khrv_rec_type;
5424:
5425: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_CONTRACT_HEADER';
5426: l_api_version CONSTANT NUMBER := 1.0;

Line 5464: okl_okc_migration_pvt.validate_contract_header(

5460:
5461: --
5462: -- call procedure in complex API
5463: --
5464: okl_okc_migration_pvt.validate_contract_header(
5465: p_api_version => p_api_version,
5466: p_init_msg_list => p_init_msg_list,
5467: x_return_status => x_return_status,
5468: x_msg_count => x_msg_count,

Line 5546: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,

5542: p_init_msg_list IN VARCHAR2,
5543: x_return_status OUT NOCOPY VARCHAR2,
5544: x_msg_count OUT NOCOPY NUMBER,
5545: x_msg_data OUT NOCOPY VARCHAR2,
5546: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
5547: p_khrv_tbl IN khrv_tbl_type) IS
5548:
5549: l_api_name CONSTANT VARCHAR2(30) := 'validate_CONTRACT_HEADER';
5550: l_api_version CONSTANT NUMBER := 1.0;

Line 5653: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

5649: PROCEDURE roundoff_line_amount(
5650: x_return_status OUT NOCOPY VARCHAR2,
5651: x_msg_count OUT NOCOPY NUMBER,
5652: x_msg_data OUT NOCOPY VARCHAR2,
5653: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
5654: p_klev_rec IN klev_rec_type,
5655: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
5656: x_klev_rec OUT NOCOPY klev_rec_type
5657: ) IS

Line 5655: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,

5651: x_msg_count OUT NOCOPY NUMBER,
5652: x_msg_data OUT NOCOPY VARCHAR2,
5653: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
5654: p_klev_rec IN klev_rec_type,
5655: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
5656: x_klev_rec OUT NOCOPY klev_rec_type
5657: ) IS
5658:
5659: --Fix Bug# 2727161

Line 6116: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

6112: p_init_msg_list IN VARCHAR2,
6113: x_return_status OUT NOCOPY VARCHAR2,
6114: x_msg_count OUT NOCOPY NUMBER,
6115: x_msg_data OUT NOCOPY VARCHAR2,
6116: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
6117: p_klev_rec IN klev_rec_type,
6118: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
6119: x_klev_rec OUT NOCOPY klev_rec_type) IS
6120:

Line 6118: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,

6114: x_msg_count OUT NOCOPY NUMBER,
6115: x_msg_data OUT NOCOPY VARCHAR2,
6116: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
6117: p_klev_rec IN klev_rec_type,
6118: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
6119: x_klev_rec OUT NOCOPY klev_rec_type) IS
6120:
6121: /*
6122: -- vthiruva, 08/19/2004

Line 6141: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

6137: /*
6138: -- vthiruva, 08/19/2004
6139: -- END, Code change to enable Business Event
6140: */
6141: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
6142: l_klev_rec klev_rec_type;
6143:
6144: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
6145: lx_klev_rec klev_rec_type;

Line 6144: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

6140: */
6141: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
6142: l_klev_rec klev_rec_type;
6143:
6144: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
6145: lx_klev_rec klev_rec_type;
6146:
6147: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_LINE';
6148: l_api_version CONSTANT NUMBER := 1.0;

Line 6152: l_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;

6148: l_api_version CONSTANT NUMBER := 1.0;
6149: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6150:
6151: --Bug# 3143522
6152: l_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6153: lx_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6154: BEGIN
6155:
6156: -- call START_ACTIVITY to create savepoint, check compatibility

Line 6153: lx_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;

6149: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6150:
6151: --Bug# 3143522
6152: l_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6153: lx_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6154: BEGIN
6155:
6156: -- call START_ACTIVITY to create savepoint, check compatibility
6157: -- and initialize message list

Line 6240: okl_okc_migration_pvt.create_contract_line(

6236:
6237: --
6238: -- call procedure in complex API
6239: --
6240: okl_okc_migration_pvt.create_contract_line(
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 6414: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

6410: p_init_msg_list IN VARCHAR2,
6411: x_return_status OUT NOCOPY VARCHAR2,
6412: x_msg_count OUT NOCOPY NUMBER,
6413: x_msg_data OUT NOCOPY VARCHAR2,
6414: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
6415: p_klev_tbl IN klev_tbl_type,
6416: x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
6417: x_klev_tbl OUT NOCOPY klev_tbl_type) IS
6418:

Line 6416: x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,

6412: x_msg_count OUT NOCOPY NUMBER,
6413: x_msg_data OUT NOCOPY VARCHAR2,
6414: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
6415: p_klev_tbl IN klev_tbl_type,
6416: x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
6417: x_klev_tbl OUT NOCOPY klev_tbl_type) IS
6418:
6419: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_LINE';
6420: l_api_version CONSTANT NUMBER := 1.0;

Line 6532: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

6528: p_init_msg_list IN VARCHAR2,
6529: x_return_status OUT NOCOPY VARCHAR2,
6530: x_msg_count OUT NOCOPY NUMBER,
6531: x_msg_data OUT NOCOPY VARCHAR2,
6532: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
6533: p_klev_rec IN klev_rec_type,
6534: p_edit_mode IN VARCHAR2,
6535: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
6536: x_klev_rec OUT NOCOPY klev_rec_type) IS

Line 6535: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,

6531: x_msg_data OUT NOCOPY VARCHAR2,
6532: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
6533: p_klev_rec IN klev_rec_type,
6534: p_edit_mode IN VARCHAR2,
6535: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
6536: x_klev_rec OUT NOCOPY klev_rec_type) IS
6537:
6538: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
6539: l_klev_rec klev_rec_type;

Line 6538: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

6534: p_edit_mode IN VARCHAR2,
6535: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
6536: x_klev_rec OUT NOCOPY klev_rec_type) IS
6537:
6538: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
6539: l_klev_rec klev_rec_type;
6540: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
6541: lx_klev_rec klev_rec_type;
6542:

Line 6540: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

6536: x_klev_rec OUT NOCOPY klev_rec_type) IS
6537:
6538: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
6539: l_klev_rec klev_rec_type;
6540: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
6541: lx_klev_rec klev_rec_type;
6542:
6543: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_LINE';
6544: l_api_version CONSTANT NUMBER := 1.0;

Line 6579: l_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;

6575: l_orig_end_date okc_k_lines_b.end_date%TYPE;
6576: l_orig_currency_code okc_k_lines_b.currency_code%TYPE;
6577: l_orig_sts_code okc_k_lines_b.sts_code%TYPE;
6578:
6579: l_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6580: lx_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6581: --Bug# 3143522
6582:
6583: /*

Line 6580: lx_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;

6576: l_orig_currency_code okc_k_lines_b.currency_code%TYPE;
6577: l_orig_sts_code okc_k_lines_b.sts_code%TYPE;
6578:
6579: l_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6580: lx_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6581: --Bug# 3143522
6582:
6583: /*
6584: -- vthiruva, 08/19/2004

Line 6743: okl_okc_migration_pvt.update_contract_line(

6739:
6740: --
6741: -- call procedure in complex API
6742: --
6743: okl_okc_migration_pvt.update_contract_line(
6744: p_api_version => p_api_version,
6745: p_init_msg_list => p_init_msg_list,
6746: x_return_status => x_return_status,
6747: x_msg_count => x_msg_count,

Line 6959: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

6955: p_init_msg_list IN VARCHAR2,
6956: x_return_status OUT NOCOPY VARCHAR2,
6957: x_msg_count OUT NOCOPY NUMBER,
6958: x_msg_data OUT NOCOPY VARCHAR2,
6959: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
6960: p_klev_rec IN klev_rec_type,
6961: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
6962: x_klev_rec OUT NOCOPY klev_rec_type) IS
6963:

Line 6961: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,

6957: x_msg_count OUT NOCOPY NUMBER,
6958: x_msg_data OUT NOCOPY VARCHAR2,
6959: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
6960: p_klev_rec IN klev_rec_type,
6961: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
6962: x_klev_rec OUT NOCOPY klev_rec_type) IS
6963:
6964: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
6965: l_klev_rec klev_rec_type;

Line 6964: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

6960: p_klev_rec IN klev_rec_type,
6961: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
6962: x_klev_rec OUT NOCOPY klev_rec_type) IS
6963:
6964: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
6965: l_klev_rec klev_rec_type;
6966:
6967: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_LINE';
6968: l_api_version CONSTANT NUMBER := 1.0;

Line 7069: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

7065: p_init_msg_list IN VARCHAR2,
7066: x_return_status OUT NOCOPY VARCHAR2,
7067: x_msg_count OUT NOCOPY NUMBER,
7068: x_msg_data OUT NOCOPY VARCHAR2,
7069: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
7070: p_klev_tbl IN klev_tbl_type,
7071: p_edit_mode IN VARCHAR2,
7072: x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
7073: x_klev_tbl OUT NOCOPY klev_tbl_type) IS

Line 7072: x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,

7068: x_msg_data OUT NOCOPY VARCHAR2,
7069: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
7070: p_klev_tbl IN klev_tbl_type,
7071: p_edit_mode IN VARCHAR2,
7072: x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
7073: x_klev_tbl OUT NOCOPY klev_tbl_type) IS
7074:
7075: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_LINE';
7076: l_api_version CONSTANT NUMBER := 1.0;

Line 7187: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

7183: p_init_msg_list IN VARCHAR2,
7184: x_return_status OUT NOCOPY VARCHAR2,
7185: x_msg_count OUT NOCOPY NUMBER,
7186: x_msg_data OUT NOCOPY VARCHAR2,
7187: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
7188: p_klev_tbl IN klev_tbl_type,
7189: x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
7190: x_klev_tbl OUT NOCOPY klev_tbl_type) IS
7191:

Line 7189: x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,

7185: x_msg_count OUT NOCOPY NUMBER,
7186: x_msg_data OUT NOCOPY VARCHAR2,
7187: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
7188: p_klev_tbl IN klev_tbl_type,
7189: x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
7190: x_klev_tbl OUT NOCOPY klev_tbl_type) IS
7191:
7192: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_LINE';
7193: l_api_version CONSTANT NUMBER := 1.0;

Line 7288: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

7284: p_init_msg_list IN VARCHAR2,
7285: x_return_status OUT NOCOPY VARCHAR2,
7286: x_msg_count OUT NOCOPY NUMBER,
7287: x_msg_data OUT NOCOPY VARCHAR2,
7288: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
7289: p_klev_rec IN klev_rec_type) IS
7290:
7291: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
7292: l_klev_rec klev_rec_type;

Line 7291: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

7287: x_msg_data OUT NOCOPY VARCHAR2,
7288: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
7289: p_klev_rec IN klev_rec_type) IS
7290:
7291: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
7292: l_klev_rec klev_rec_type;
7293:
7294: l_clev_rec_out okl_okc_migration_pvt.clev_rec_type;
7295: l_klev_rec_out klev_rec_type;

Line 7294: l_clev_rec_out okl_okc_migration_pvt.clev_rec_type;

7290:
7291: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
7292: l_klev_rec klev_rec_type;
7293:
7294: l_clev_rec_out okl_okc_migration_pvt.clev_rec_type;
7295: l_klev_rec_out klev_rec_type;
7296:
7297: l_deletion_type Varchar2(1);
7298:

Line 7693: okl_okc_migration_pvt.delete_contract_line(

7689:
7690: --
7691: -- call procedure in complex API
7692: --
7693: okl_okc_migration_pvt.delete_contract_line(
7694: p_api_version => p_api_version,
7695: p_init_msg_list => p_init_msg_list,
7696: x_return_status => x_return_status,
7697: x_msg_count => x_msg_count,

Line 8002: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

7998: p_init_msg_list IN VARCHAR2,
7999: x_return_status OUT NOCOPY VARCHAR2,
8000: x_msg_count OUT NOCOPY NUMBER,
8001: x_msg_data OUT NOCOPY VARCHAR2,
8002: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
8003: p_klev_tbl IN klev_tbl_type) IS
8004:
8005: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_LINE';
8006: l_api_version CONSTANT NUMBER := 1.0;

Line 8201: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

8197:
8198: --variable added for checking if okl line deletion is allowed
8199: i Number;
8200: l_deletion_type Varchar2(1) default 'P';
8201: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
8202: l_klev_rec klev_rec_type;
8203:
8204: l_clev_rec_out okl_okc_migration_pvt.clev_rec_type;
8205: l_klev_rec_out klev_rec_type;

Line 8204: l_clev_rec_out okl_okc_migration_pvt.clev_rec_type;

8200: l_deletion_type Varchar2(1) default 'P';
8201: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
8202: l_klev_rec klev_rec_type;
8203:
8204: l_clev_rec_out okl_okc_migration_pvt.clev_rec_type;
8205: l_klev_rec_out klev_rec_type;
8206: --variable added for checking if okl line deletion is allowed
8207: --Bug# 3143522 : delete supplier invoice details is line is deleted
8208: --cursor to ger supplier invoice details

Line 8414: okl_okc_migration_pvt.update_contract_line

8410: --l_klev_rec.ID := l_klev_tbl_in(i).ID;
8411: --dbms_output.put_line('going in for logical delete');
8412: --dbms_output.put_line('line:'||to_char(l_clev_rec.id));
8413:
8414: okl_okc_migration_pvt.update_contract_line
8415: (p_api_version => p_api_version,
8416: p_init_msg_list => p_init_msg_list,
8417: x_return_status => x_return_status,
8418: x_msg_count => x_msg_count,

Line 8927: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

8923: p_init_msg_list IN VARCHAR2,
8924: x_return_status OUT NOCOPY VARCHAR2,
8925: x_msg_count OUT NOCOPY NUMBER,
8926: x_msg_data OUT NOCOPY VARCHAR2,
8927: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
8928: p_klev_rec IN klev_rec_type,
8929: p_delete_cascade_yn IN VARCHAR2) IS
8930:
8931: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 8931: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

8927: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
8928: p_klev_rec IN klev_rec_type,
8929: p_delete_cascade_yn IN VARCHAR2) IS
8930:
8931: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
8932: l_klev_rec klev_rec_type;
8933:
8934: l_clev_rec_out okl_okc_migration_pvt.clev_rec_type;
8935: l_klev_rec_out klev_rec_type;

Line 8934: l_clev_rec_out okl_okc_migration_pvt.clev_rec_type;

8930:
8931: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
8932: l_klev_rec klev_rec_type;
8933:
8934: l_clev_rec_out okl_okc_migration_pvt.clev_rec_type;
8935: l_klev_rec_out klev_rec_type;
8936:
8937: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_LINE';
8938: l_api_version CONSTANT NUMBER := 1.0;

Line 9040: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

9036: p_init_msg_list IN VARCHAR2,
9037: x_return_status OUT NOCOPY VARCHAR2,
9038: x_msg_count OUT NOCOPY NUMBER,
9039: x_msg_data OUT NOCOPY VARCHAR2,
9040: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
9041: p_klev_tbl IN klev_tbl_type,
9042: p_delete_cascade_yn IN varchar2) IS
9043:
9044: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_LINE';

Line 9149: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

9145: p_init_msg_list IN VARCHAR2,
9146: x_return_status OUT NOCOPY VARCHAR2,
9147: x_msg_count OUT NOCOPY NUMBER,
9148: x_msg_data OUT NOCOPY VARCHAR2,
9149: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
9150: p_klev_rec IN klev_rec_type) IS
9151:
9152: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
9153: l_klev_rec klev_rec_type;

Line 9152: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

9148: x_msg_data OUT NOCOPY VARCHAR2,
9149: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
9150: p_klev_rec IN klev_rec_type) IS
9151:
9152: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
9153: l_klev_rec klev_rec_type;
9154:
9155: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_CONTRACT_LINE';
9156: l_api_version CONSTANT NUMBER := 1.0;

Line 9184: okl_okc_migration_pvt.lock_contract_line(

9180:
9181: --
9182: -- call procedure in complex API
9183: --
9184: okl_okc_migration_pvt.lock_contract_line(
9185: p_api_version => p_api_version,
9186: p_init_msg_list => p_init_msg_list,
9187: x_return_status => x_return_status,
9188: x_msg_count => x_msg_count,

Line 9263: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

9259: p_init_msg_list IN VARCHAR2,
9260: x_return_status OUT NOCOPY VARCHAR2,
9261: x_msg_count OUT NOCOPY NUMBER,
9262: x_msg_data OUT NOCOPY VARCHAR2,
9263: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
9264: p_klev_tbl IN klev_tbl_type) IS
9265:
9266: l_api_name CONSTANT VARCHAR2(30) := 'lock_CONTRACT_LINE';
9267: l_api_version CONSTANT NUMBER := 1.0;

Line 9371: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

9367: p_init_msg_list IN VARCHAR2,
9368: x_return_status OUT NOCOPY VARCHAR2,
9369: x_msg_count OUT NOCOPY NUMBER,
9370: x_msg_data OUT NOCOPY VARCHAR2,
9371: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
9372: p_klev_rec IN klev_rec_type) IS
9373:
9374: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
9375: l_klev_rec klev_rec_type;

Line 9374: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

9370: x_msg_data OUT NOCOPY VARCHAR2,
9371: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
9372: p_klev_rec IN klev_rec_type) IS
9373:
9374: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
9375: l_klev_rec klev_rec_type;
9376:
9377: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_CONTRACT_LINE';
9378: l_api_version CONSTANT NUMBER := 1.0;

Line 9406: okl_okc_migration_pvt.validate_contract_line(

9402:
9403: --
9404: -- call procedure in complex API
9405: --
9406: okl_okc_migration_pvt.validate_contract_line(
9407: p_api_version => p_api_version,
9408: p_init_msg_list => p_init_msg_list,
9409: x_return_status => x_return_status,
9410: x_msg_count => x_msg_count,

Line 9485: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

9481: p_init_msg_list IN VARCHAR2,
9482: x_return_status OUT NOCOPY VARCHAR2,
9483: x_msg_count OUT NOCOPY NUMBER,
9484: x_msg_data OUT NOCOPY VARCHAR2,
9485: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
9486: p_klev_tbl IN klev_tbl_type) IS
9487:
9488: l_api_name CONSTANT VARCHAR2(30) := 'validate_CONTRACT_LINE';
9489: l_api_version CONSTANT NUMBER := 1.0;

Line 9586: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type,

9582: p_init_msg_list IN VARCHAR2,
9583: x_return_status OUT NOCOPY VARCHAR2,
9584: x_msg_count OUT NOCOPY NUMBER,
9585: x_msg_data OUT NOCOPY VARCHAR2,
9586: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type,
9587: x_gvev_rec OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type) IS
9588:
9589: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
9590:

Line 9587: x_gvev_rec OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type) IS

9583: x_return_status OUT NOCOPY VARCHAR2,
9584: x_msg_count OUT NOCOPY NUMBER,
9585: x_msg_data OUT NOCOPY VARCHAR2,
9586: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type,
9587: x_gvev_rec OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type) IS
9588:
9589: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
9590:
9591: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_GOVERNANCE';

Line 9589: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;

9585: x_msg_data OUT NOCOPY VARCHAR2,
9586: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type,
9587: x_gvev_rec OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type) IS
9588:
9589: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
9590:
9591: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_GOVERNANCE';
9592: l_api_version CONSTANT NUMBER := 1.0;
9593: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 9631: okl_okc_migration_pvt.create_governance(

9627: --
9628: -- call procedure in complex API
9629: --
9630: --OKC_CONTRACT_PUB.create_contract_header(
9631: okl_okc_migration_pvt.create_governance(
9632: p_api_version => p_api_version,
9633: p_init_msg_list => p_init_msg_list,
9634: x_return_status => x_return_status,
9635: x_msg_count => x_msg_count,

Line 9710: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type,

9706: p_init_msg_list IN VARCHAR2,
9707: x_return_status OUT NOCOPY VARCHAR2,
9708: x_msg_count OUT NOCOPY NUMBER,
9709: x_msg_data OUT NOCOPY VARCHAR2,
9710: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type,
9711: x_gvev_tbl OUT NOCOPY okl_okc_migration_pvt.gvev_tbl_type) IS
9712:
9713: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_GOVERNANCE';
9714: l_api_version CONSTANT NUMBER := 1.0;

Line 9711: x_gvev_tbl OUT NOCOPY okl_okc_migration_pvt.gvev_tbl_type) IS

9707: x_return_status OUT NOCOPY VARCHAR2,
9708: x_msg_count OUT NOCOPY NUMBER,
9709: x_msg_data OUT NOCOPY VARCHAR2,
9710: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type,
9711: x_gvev_tbl OUT NOCOPY okl_okc_migration_pvt.gvev_tbl_type) IS
9712:
9713: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_GOVERNANCE';
9714: l_api_version CONSTANT NUMBER := 1.0;
9715: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 9718: l_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type := p_gvev_tbl;

9714: l_api_version CONSTANT NUMBER := 1.0;
9715: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
9716: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
9717: i NUMBER;
9718: l_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type := p_gvev_tbl;
9719: BEGIN
9720: -- call START_ACTIVITY to create savepoint, check compatibility
9721: -- and initialize message list
9722: l_return_status := OKL_API.START_ACTIVITY(

Line 9818: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type,

9814: p_init_msg_list IN VARCHAR2,
9815: x_return_status OUT NOCOPY VARCHAR2,
9816: x_msg_count OUT NOCOPY NUMBER,
9817: x_msg_data OUT NOCOPY VARCHAR2,
9818: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type,
9819: x_gvev_rec OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type) IS
9820:
9821: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
9822:

Line 9819: x_gvev_rec OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type) IS

9815: x_return_status OUT NOCOPY VARCHAR2,
9816: x_msg_count OUT NOCOPY NUMBER,
9817: x_msg_data OUT NOCOPY VARCHAR2,
9818: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type,
9819: x_gvev_rec OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type) IS
9820:
9821: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
9822:
9823: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_GOVERNANCE';

Line 9821: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;

9817: x_msg_data OUT NOCOPY VARCHAR2,
9818: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type,
9819: x_gvev_rec OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type) IS
9820:
9821: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
9822:
9823: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_GOVERNANCE';
9824: l_api_version CONSTANT NUMBER := 1.0;
9825: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 9859: okl_okc_migration_pvt.update_governance(

9855: --
9856: -- call procedure in complex API
9857: --
9858: -- OKC_CONTRACT_PUB.update_contract_header(
9859: okl_okc_migration_pvt.update_governance(
9860: p_api_version => p_api_version,
9861: p_init_msg_list => p_init_msg_list,
9862: x_return_status => x_return_status,
9863: x_msg_count => x_msg_count,

Line 9942: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type,

9938: p_init_msg_list IN VARCHAR2,
9939: x_return_status OUT NOCOPY VARCHAR2,
9940: x_msg_count OUT NOCOPY NUMBER,
9941: x_msg_data OUT NOCOPY VARCHAR2,
9942: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type,
9943: x_gvev_tbl OUT NOCOPY okl_okc_migration_pvt.gvev_tbl_type) IS
9944:
9945: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_GOVERNANCE';
9946: l_api_version CONSTANT NUMBER := 1.0;

Line 9943: x_gvev_tbl OUT NOCOPY okl_okc_migration_pvt.gvev_tbl_type) IS

9939: x_return_status OUT NOCOPY VARCHAR2,
9940: x_msg_count OUT NOCOPY NUMBER,
9941: x_msg_data OUT NOCOPY VARCHAR2,
9942: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type,
9943: x_gvev_tbl OUT NOCOPY okl_okc_migration_pvt.gvev_tbl_type) IS
9944:
9945: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_GOVERNANCE';
9946: l_api_version CONSTANT NUMBER := 1.0;
9947: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 9950: l_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type := p_gvev_tbl;

9946: l_api_version CONSTANT NUMBER := 1.0;
9947: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
9948: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
9949: i NUMBER;
9950: l_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type := p_gvev_tbl;
9951: BEGIN
9952: -- call START_ACTIVITY to create savepoint, check compatibility
9953: -- and initialize message list
9954: l_return_status := OKL_API.START_ACTIVITY(

Line 10050: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type) IS

10046: p_init_msg_list IN VARCHAR2,
10047: x_return_status OUT NOCOPY VARCHAR2,
10048: x_msg_count OUT NOCOPY NUMBER,
10049: x_msg_data OUT NOCOPY VARCHAR2,
10050: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type) IS
10051:
10052: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
10053:
10054: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_GOVERNANCE';

Line 10052: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;

10048: x_msg_count OUT NOCOPY NUMBER,
10049: x_msg_data OUT NOCOPY VARCHAR2,
10050: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type) IS
10051:
10052: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
10053:
10054: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_GOVERNANCE';
10055: l_api_version CONSTANT NUMBER := 1.0;
10056: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 10122: okl_okc_migration_pvt.delete_governance(

10118: End If;
10119: --
10120: -- call procedure in complex API
10121: --
10122: okl_okc_migration_pvt.delete_governance(
10123: p_api_version => p_api_version,
10124: p_init_msg_list => p_init_msg_list,
10125: x_return_status => x_return_status,
10126: x_msg_count => x_msg_count,

Line 10184: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type) IS

10180: p_init_msg_list IN VARCHAR2,
10181: x_return_status OUT NOCOPY VARCHAR2,
10182: x_msg_count OUT NOCOPY NUMBER,
10183: x_msg_data OUT NOCOPY VARCHAR2,
10184: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type) IS
10185:
10186: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_GOVERNANCE';
10187: l_api_version CONSTANT NUMBER := 1.0;
10188: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 10191: l_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type := p_gvev_tbl;

10187: l_api_version CONSTANT NUMBER := 1.0;
10188: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10189: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10190: i NUMBER;
10191: l_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type := p_gvev_tbl;
10192: BEGIN
10193: -- call START_ACTIVITY to create savepoint, check compatibility
10194: -- and initialize message list
10195: l_return_status := OKL_API.START_ACTIVITY(

Line 10290: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type) IS

10286: p_init_msg_list IN VARCHAR2,
10287: x_return_status OUT NOCOPY VARCHAR2,
10288: x_msg_count OUT NOCOPY NUMBER,
10289: x_msg_data OUT NOCOPY VARCHAR2,
10290: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type) IS
10291:
10292: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
10293:
10294: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_GOVERNANCE';

Line 10292: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;

10288: x_msg_count OUT NOCOPY NUMBER,
10289: x_msg_data OUT NOCOPY VARCHAR2,
10290: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type) IS
10291:
10292: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
10293:
10294: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_GOVERNANCE';
10295: l_api_version CONSTANT NUMBER := 1.0;
10296: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 10329: okl_okc_migration_pvt.lock_governance(

10325:
10326: --
10327: -- call procedure in complex API
10328: --
10329: okl_okc_migration_pvt.lock_governance(
10330: p_api_version => p_api_version,
10331: p_init_msg_list => p_init_msg_list,
10332: x_return_status => x_return_status,
10333: x_msg_count => x_msg_count,

Line 10390: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type) IS

10386: p_init_msg_list IN VARCHAR2,
10387: x_return_status OUT NOCOPY VARCHAR2,
10388: x_msg_count OUT NOCOPY NUMBER,
10389: x_msg_data OUT NOCOPY VARCHAR2,
10390: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type) IS
10391:
10392: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_GOVERNANCE';
10393: l_api_version CONSTANT NUMBER := 1.0;
10394: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 10397: l_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type := p_gvev_tbl;

10393: l_api_version CONSTANT NUMBER := 1.0;
10394: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10395: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10396: i NUMBER;
10397: l_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type := p_gvev_tbl;
10398: BEGIN
10399: -- call START_ACTIVITY to create savepoint, check compatibility
10400: -- and initialize message list
10401: l_return_status := OKL_API.START_ACTIVITY(

Line 10497: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type) IS

10493: p_init_msg_list IN VARCHAR2,
10494: x_return_status OUT NOCOPY VARCHAR2,
10495: x_msg_count OUT NOCOPY NUMBER,
10496: x_msg_data OUT NOCOPY VARCHAR2,
10497: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type) IS
10498:
10499: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
10500:
10501:

Line 10499: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;

10495: x_msg_count OUT NOCOPY NUMBER,
10496: x_msg_data OUT NOCOPY VARCHAR2,
10497: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type) IS
10498:
10499: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
10500:
10501:
10502: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_GOVERNANCE';
10503: l_api_version CONSTANT NUMBER := 1.0;

Line 10540: okl_okc_migration_pvt.validate_governance(

10536:
10537: --
10538: -- call procedure in complex API
10539: --
10540: okl_okc_migration_pvt.validate_governance(
10541: p_api_version => p_api_version,
10542: p_init_msg_list => p_init_msg_list,
10543: x_return_status => x_return_status,
10544: x_msg_count => x_msg_count,

Line 10603: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type) IS

10599: p_init_msg_list IN VARCHAR2,
10600: x_return_status OUT NOCOPY VARCHAR2,
10601: x_msg_count OUT NOCOPY NUMBER,
10602: x_msg_data OUT NOCOPY VARCHAR2,
10603: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type) IS
10604:
10605: l_api_name CONSTANT VARCHAR2(30) := 'validate_CONTRACT_HEADER';
10606: l_api_version CONSTANT NUMBER := 1.0;
10607: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 10610: l_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type := p_gvev_tbl;

10606: l_api_version CONSTANT NUMBER := 1.0;
10607: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10608: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10609: i NUMBER;
10610: l_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type := p_gvev_tbl;
10611: BEGIN
10612: -- call START_ACTIVITY to create savepoint, check compatibility
10613: -- and initialize message list
10614: l_return_status := OKL_API.START_ACTIVITY(