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 534: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

530: --'N' Normal
531: --'L' Copy start and end dates on to lines
532: --'P' Violates product effictivity dates
533:
534: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
535: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
536:
537: --Cursor to find out the product from_date and to_date
538: Cursor pdt_dts_csr(p_chr_id IN NUMBER) IS

Line 535: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

531: --'L' Copy start and end dates on to lines
532: --'P' Violates product effictivity dates
533:
534: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
535: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
536:
537: --Cursor to find out the product from_date and to_date
538: Cursor pdt_dts_csr(p_chr_id IN NUMBER) IS
539: Select pdt.from_date,

Line 945: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

941:
942: l_fin_asst Varchar2(1) default 'N';
943: l_cle_id Number;
944:
945: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
946: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
947:
948: --Cursor to check asset number on txl
949: CURSOR l_txlv_csr (p_finasst_id IN NUMBER, P_Asstno IN VARCHAR2) is

Line 946: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

942: l_fin_asst Varchar2(1) default 'N';
943: l_cle_id Number;
944:
945: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
946: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
947:
948: --Cursor to check asset number on txl
949: CURSOR l_txlv_csr (p_finasst_id IN NUMBER, P_Asstno IN VARCHAR2) is
950: Select txlv.id,

Line 1040: okl_okc_migration_pvt.update_contract_line(

1036: --dbms_output.put_line(l_asset_no);
1037: --update asset number on top line
1038: l_clev_rec.id := l_cle_id;
1039: l_clev_rec.name := l_asset_no;
1040: okl_okc_migration_pvt.update_contract_line(
1041: p_api_version => p_api_version,
1042: p_init_msg_list => p_init_msg_list,
1043: x_return_status => x_return_status,
1044: x_msg_count => x_msg_count,

Line 1209: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

1205: and cim.object1_id1 = to_char(p_line_id)
1206: and cim.object1_id2 = '#';
1207:
1208: l_lnk_cle_id OKC_K_LINES_B.ID%TYPE;
1209: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
1210: l_clev_rec_out OKL_OKC_MIGRATION_PVT.clev_rec_type;
1211: l_deletion_type Varchar2(1);
1212:
1213: Begin

Line 1210: l_clev_rec_out OKL_OKC_MIGRATION_PVT.clev_rec_type;

1206: and cim.object1_id2 = '#';
1207:
1208: l_lnk_cle_id OKC_K_LINES_B.ID%TYPE;
1209: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
1210: l_clev_rec_out OKL_OKC_MIGRATION_PVT.clev_rec_type;
1211: l_deletion_type Varchar2(1);
1212:
1213: Begin
1214: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1238: okl_okc_migration_pvt.update_contract_line

1234: --do logical deletion of linked asset line
1235: l_clev_rec.id := l_lnk_cle_id;
1236: l_clev_rec.sts_code := G_OKL_CANCELLED_STS_CODE;
1237:
1238: okl_okc_migration_pvt.update_contract_line
1239: (p_api_version => p_api_version,
1240: p_init_msg_list => p_init_msg_list,
1241: x_return_status => x_return_status,
1242: x_msg_count => x_msg_count,

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

1332: -- Parameters :
1333: -- Version : 1.0
1334: -- End of comments
1335: --------------------------------------------------------------------------------
1336: Procedure get_line_dates(p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
1337: x_return_status OUT NOCOPY Varchar2,
1338: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type) is
1339:
1340: l_return_status Varchar2(1) default OKL_API.G_RET_STS_SUCCESS;

Line 1338: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type) is

1334: -- End of comments
1335: --------------------------------------------------------------------------------
1336: Procedure get_line_dates(p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
1337: x_return_status OUT NOCOPY Varchar2,
1338: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type) is
1339:
1340: l_return_status Varchar2(1) default OKL_API.G_RET_STS_SUCCESS;
1341: --cursor to get contract header dates
1342: cursor l_chr_csr (p_chr_id in number) is

Line 1380: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

1376:
1377: l_lty_code okc_line_styles_b.lty_code%TYPE;
1378: l_lse_type okc_line_styles_b.lse_type%TYPE;
1379:
1380: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
1381:
1382: l_rbk_cpy varchar2(1) default 'N';
1383:
1384: --Cursor to find out Rebook date

Line 1525: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,

1521: p_init_msg_list IN VARCHAR2,
1522: x_msg_count OUT NOCOPY NUMBER,
1523: x_msg_data OUT NOCOPY VARCHAR2,
1524: x_return_status OUT NOCOPY VARCHAR2,
1525: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
1526: p_khrv_rec IN khrv_rec_type,
1527: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
1528: x_khrv_rec OUT NOCOPY khrv_rec_type
1529: ) IS

Line 1527: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,

1523: x_msg_data OUT NOCOPY VARCHAR2,
1524: x_return_status OUT NOCOPY VARCHAR2,
1525: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
1526: p_khrv_rec IN khrv_rec_type,
1527: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
1528: x_khrv_rec OUT NOCOPY khrv_rec_type
1529: ) IS
1530:
1531: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

Line 1531: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

1527: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
1528: x_khrv_rec OUT NOCOPY khrv_rec_type
1529: ) IS
1530:
1531: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
1532: l_khrv_rec khrv_rec_type;
1533: l_func_currency GL_CURRENCIES.CURRENCY_CODE%TYPE;
1534: currency_validation_failed EXCEPTION;
1535:

Line 1737: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,

1733: p_init_msg_list IN VARCHAR2,
1734: x_return_status OUT NOCOPY VARCHAR2,
1735: x_msg_count OUT NOCOPY NUMBER,
1736: x_msg_data OUT NOCOPY VARCHAR2,
1737: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
1738: p_pdt_id IN NUMBER,
1739: x_deal_type OUT NOCOPY VARCHAR2,
1740: x_tax_owner OUT NOCOPY VARCHAR2,
1741: --bug# 3180583

Line 2432: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,

2428: p_init_msg_list IN VARCHAR2,
2429: x_return_status OUT NOCOPY VARCHAR2,
2430: x_msg_count OUT NOCOPY NUMBER,
2431: x_msg_data OUT NOCOPY VARCHAR2,
2432: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
2433: p_khrv_rec IN khrv_rec_type,
2434: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
2435: x_khrv_rec OUT NOCOPY khrv_rec_type) IS
2436:

Line 2434: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,

2430: x_msg_count OUT NOCOPY NUMBER,
2431: x_msg_data OUT NOCOPY VARCHAR2,
2432: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
2433: p_khrv_rec IN khrv_rec_type,
2434: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
2435: x_khrv_rec OUT NOCOPY khrv_rec_type) IS
2436:
2437: subtype rulv_tbl_type is OKL_RULE_PUB.rulv_tbl_type;
2438:

Line 2439: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

2435: x_khrv_rec OUT NOCOPY khrv_rec_type) IS
2436:
2437: subtype rulv_tbl_type is OKL_RULE_PUB.rulv_tbl_type;
2438:
2439: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
2440: l_khrv_rec khrv_rec_type;
2441:
2442: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_HEADER';
2443: l_api_version CONSTANT NUMBER := 1.0;

Line 2447: l_curr_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

2443: l_api_version CONSTANT NUMBER := 1.0;
2444: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2445: --Bug # : 11.5.9 Enhancement - Multi Currency changes
2446:
2447: l_curr_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
2448: l_curr_khrv_rec khrv_rec_type;
2449:
2450: --Bug # : 11.5.9 Enhancement - Defaulting from product definition
2451: l_pdt_deal_type varchar2(150);

Line 2604: okl_okc_migration_pvt.create_contract_header(

2600: -- call procedure in complex API
2601: --
2602: --OKC_CONTRACT_PUB.create_contract_header(
2603:
2604: okl_okc_migration_pvt.create_contract_header(
2605: p_api_version => p_api_version,
2606: p_init_msg_list => p_init_msg_list,
2607: x_return_status => x_return_status,
2608: x_msg_count => x_msg_count,

Line 2833: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,

2829: p_init_msg_list IN VARCHAR2,
2830: x_return_status OUT NOCOPY VARCHAR2,
2831: x_msg_count OUT NOCOPY NUMBER,
2832: x_msg_data OUT NOCOPY VARCHAR2,
2833: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
2834: p_khrv_tbl IN khrv_tbl_type,
2835: x_chrv_tbl OUT NOCOPY okl_okc_migration_pvt.chrv_tbl_type,
2836: x_khrv_tbl OUT NOCOPY khrv_tbl_type) IS
2837:

Line 2835: x_chrv_tbl OUT NOCOPY okl_okc_migration_pvt.chrv_tbl_type,

2831: x_msg_count OUT NOCOPY NUMBER,
2832: x_msg_data OUT NOCOPY VARCHAR2,
2833: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
2834: p_khrv_tbl IN khrv_tbl_type,
2835: x_chrv_tbl OUT NOCOPY okl_okc_migration_pvt.chrv_tbl_type,
2836: x_khrv_tbl OUT NOCOPY khrv_tbl_type) IS
2837:
2838: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_HEADER';
2839: l_api_version CONSTANT NUMBER := 1.0;

Line 2951: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,

2947: x_return_status OUT NOCOPY VARCHAR2,
2948: x_msg_count OUT NOCOPY NUMBER,
2949: x_msg_data OUT NOCOPY VARCHAR2,
2950: p_restricted_update IN VARCHAR2,
2951: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
2952: p_khrv_rec IN khrv_rec_type,
2953: p_edit_mode IN VARCHAR2,
2954: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
2955: x_khrv_rec OUT NOCOPY khrv_rec_type) IS

Line 2954: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,

2950: p_restricted_update IN VARCHAR2,
2951: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
2952: p_khrv_rec IN khrv_rec_type,
2953: p_edit_mode IN VARCHAR2,
2954: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
2955: x_khrv_rec OUT NOCOPY khrv_rec_type) IS
2956:
2957:
2958: subtype rulv_tbl_type is OKL_RULE_PUB.rulv_tbl_type;

Line 2959: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

2955: x_khrv_rec OUT NOCOPY khrv_rec_type) IS
2956:
2957:
2958: subtype rulv_tbl_type is OKL_RULE_PUB.rulv_tbl_type;
2959: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
2960: l_khrv_rec khrv_rec_type;
2961:
2962: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';
2963: l_api_version CONSTANT NUMBER := 1.0;

Line 3013: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

3009: --Bug#
3010: l_lse_id OKC_K_LINES_B.lse_id%TYPE;
3011:
3012:
3013: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
3014: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
3015:
3016: -------------------------------------------------------------------------
3017: --Bug# : 11.5.9 Multi-currency/product validation enhancements

Line 3014: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

3010: l_lse_id OKC_K_LINES_B.lse_id%TYPE;
3011:
3012:
3013: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
3014: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
3015:
3016: -------------------------------------------------------------------------
3017: --Bug# : 11.5.9 Multi-currency/product validation enhancements
3018: -------------------------------------------------------------------------

Line 3078: l_curr_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

3074: i number;
3075: -- Bug 7610725 end
3076:
3077:
3078: l_curr_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
3079: l_curr_khrv_rec khrv_rec_type;
3080:
3081: l_pdt_deal_type varchar2(150);
3082: l_pdt_tax_owner varchar2(150);

Line 3529: okl_okc_migration_pvt.update_contract_header(

3525: -- call procedure in complex API
3526: --
3527: -- OKC_CONTRACT_PUB.update_contract_header(
3528:
3529: okl_okc_migration_pvt.update_contract_header(
3530: p_api_version => p_api_version,
3531: p_init_msg_list => p_init_msg_list,
3532: x_return_status => x_return_status,
3533: x_msg_count => x_msg_count,

Line 3891: okl_okc_migration_pvt.update_contract_line(

3887:
3888: End If; --lty code not service fee or subsidy
3889:
3890:
3891: okl_okc_migration_pvt.update_contract_line(
3892: p_api_version => p_api_version,
3893: p_init_msg_list => p_init_msg_list,
3894: x_return_status => x_return_status,
3895: x_msg_count => x_msg_count,

Line 4098: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,

4094: x_return_status OUT NOCOPY VARCHAR2,
4095: x_msg_count OUT NOCOPY NUMBER,
4096: x_msg_data OUT NOCOPY VARCHAR2,
4097: p_restricted_update IN VARCHAR2,
4098: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
4099: p_khrv_rec IN khrv_rec_type,
4100: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
4101: x_khrv_rec OUT NOCOPY khrv_rec_type) IS
4102:

Line 4100: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,

4096: x_msg_data OUT NOCOPY VARCHAR2,
4097: p_restricted_update IN VARCHAR2,
4098: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
4099: p_khrv_rec IN khrv_rec_type,
4100: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
4101: x_khrv_rec OUT NOCOPY khrv_rec_type) IS
4102:
4103: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
4104: l_khrv_rec khrv_rec_type;

Line 4103: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

4099: p_khrv_rec IN khrv_rec_type,
4100: x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
4101: x_khrv_rec OUT NOCOPY khrv_rec_type) IS
4102:
4103: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
4104: l_khrv_rec khrv_rec_type;
4105:
4106: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';
4107: l_api_version CONSTANT NUMBER := 1.0;

Line 4205: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,

4201: x_return_status OUT NOCOPY VARCHAR2,
4202: x_msg_count OUT NOCOPY NUMBER,
4203: x_msg_data OUT NOCOPY VARCHAR2,
4204: p_restricted_update IN VARCHAR2,
4205: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
4206: p_khrv_tbl IN khrv_tbl_type,
4207: x_chrv_tbl OUT NOCOPY okl_okc_migration_pvt.chrv_tbl_type,
4208: x_khrv_tbl OUT NOCOPY khrv_tbl_type) IS
4209:

Line 4207: x_chrv_tbl OUT NOCOPY okl_okc_migration_pvt.chrv_tbl_type,

4203: x_msg_data OUT NOCOPY VARCHAR2,
4204: p_restricted_update IN VARCHAR2,
4205: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
4206: p_khrv_tbl IN khrv_tbl_type,
4207: x_chrv_tbl OUT NOCOPY okl_okc_migration_pvt.chrv_tbl_type,
4208: x_khrv_tbl OUT NOCOPY khrv_tbl_type) IS
4209:
4210: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';
4211: l_api_version CONSTANT NUMBER := 1.0;

Line 4321: SUBTYPE chrv_rec_type IS OKL_OKC_MIGRATION_PVT.CHRV_REC_TYPE;

4317: x_msg_count OUT NOCOPY NUMBER,
4318: x_msg_data OUT NOCOPY VARCHAR2,
4319: p_contract_id IN okc_k_headers_b.id%TYPE) IS
4320:
4321: SUBTYPE chrv_rec_type IS OKL_OKC_MIGRATION_PVT.CHRV_REC_TYPE;
4322: SUBTYPE khrv_rec_type IS OKL_CONTRACT_PUB.KHRV_REC_TYPE;
4323: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
4324: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
4325: G_NO_MATCHING_RECORD CONSTANT VARCHAR2(200) := 'OKL_LLA_NO_MATCHING_RECORD';

Line 4517: l_cplv_tbl_in OKL_OKC_MIGRATION_PVT.cplv_tbl_type;

4513:
4514: FUNCTION DELETE_K_PARTY_ROLES( p_chr_id number) Return varchar2 IS
4515:
4516: --Bug# 4558486
4517: l_cplv_tbl_in OKL_OKC_MIGRATION_PVT.cplv_tbl_type;
4518: l_return_status varchar2(30);
4519:
4520: CURSOR l_cplv_csr (p_id IN NUMBER) IS
4521: SELECT ID

Line 5051: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,

5047: p_init_msg_list IN VARCHAR2,
5048: x_return_status OUT NOCOPY VARCHAR2,
5049: x_msg_count OUT NOCOPY NUMBER,
5050: x_msg_data OUT NOCOPY VARCHAR2,
5051: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
5052: p_khrv_rec IN khrv_rec_type) IS
5053:
5054: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
5055: l_khrv_rec khrv_rec_type;

Line 5054: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

5050: x_msg_data OUT NOCOPY VARCHAR2,
5051: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
5052: p_khrv_rec IN khrv_rec_type) IS
5053:
5054: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
5055: l_khrv_rec khrv_rec_type;
5056:
5057: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_HEADER';
5058: l_api_version CONSTANT NUMBER := 1.0;

Line 5093: okl_okc_migration_pvt.delete_contract_header(

5089:
5090: --
5091: -- call procedure in complex API
5092: --
5093: okl_okc_migration_pvt.delete_contract_header(
5094: p_api_version => p_api_version,
5095: p_init_msg_list => p_init_msg_list,
5096: x_return_status => x_return_status,
5097: x_msg_count => x_msg_count,

Line 5169: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,

5165: p_init_msg_list IN VARCHAR2,
5166: x_return_status OUT NOCOPY VARCHAR2,
5167: x_msg_count OUT NOCOPY NUMBER,
5168: x_msg_data OUT NOCOPY VARCHAR2,
5169: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
5170: p_khrv_tbl IN khrv_tbl_type) IS
5171:
5172: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_HEADER';
5173: l_api_version CONSTANT NUMBER := 1.0;

Line 5277: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,

5273: p_init_msg_list IN VARCHAR2,
5274: x_return_status OUT NOCOPY VARCHAR2,
5275: x_msg_count OUT NOCOPY NUMBER,
5276: x_msg_data OUT NOCOPY VARCHAR2,
5277: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
5278: p_khrv_rec IN khrv_rec_type) IS
5279:
5280: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
5281: l_khrv_rec khrv_rec_type;

Line 5280: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

5276: x_msg_data OUT NOCOPY VARCHAR2,
5277: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
5278: p_khrv_rec IN khrv_rec_type) IS
5279:
5280: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
5281: l_khrv_rec khrv_rec_type;
5282:
5283: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_CONTRACT_HEADER';
5284: l_api_version CONSTANT NUMBER := 1.0;

Line 5319: okl_okc_migration_pvt.lock_contract_header(

5315:
5316: --
5317: -- call procedure in complex API
5318: --
5319: okl_okc_migration_pvt.lock_contract_header(
5320: p_api_version => p_api_version,
5321: p_init_msg_list => p_init_msg_list,
5322: x_return_status => x_return_status,
5323: x_msg_count => x_msg_count,

Line 5395: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,

5391: p_init_msg_list IN VARCHAR2,
5392: x_return_status OUT NOCOPY VARCHAR2,
5393: x_msg_count OUT NOCOPY NUMBER,
5394: x_msg_data OUT NOCOPY VARCHAR2,
5395: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
5396: p_khrv_tbl IN khrv_tbl_type) IS
5397:
5398: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_CONTRACT_HEADER';
5399: l_api_version CONSTANT NUMBER := 1.0;

Line 5504: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,

5500: p_init_msg_list IN VARCHAR2,
5501: x_return_status OUT NOCOPY VARCHAR2,
5502: x_msg_count OUT NOCOPY NUMBER,
5503: x_msg_data OUT NOCOPY VARCHAR2,
5504: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
5505: p_khrv_rec IN khrv_rec_type) IS
5506:
5507: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
5508: l_khrv_rec khrv_rec_type;

Line 5507: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

5503: x_msg_data OUT NOCOPY VARCHAR2,
5504: p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
5505: p_khrv_rec IN khrv_rec_type) IS
5506:
5507: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
5508: l_khrv_rec khrv_rec_type;
5509:
5510: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_CONTRACT_HEADER';
5511: l_api_version CONSTANT NUMBER := 1.0;

Line 5549: okl_okc_migration_pvt.validate_contract_header(

5545:
5546: --
5547: -- call procedure in complex API
5548: --
5549: okl_okc_migration_pvt.validate_contract_header(
5550: p_api_version => p_api_version,
5551: p_init_msg_list => p_init_msg_list,
5552: x_return_status => x_return_status,
5553: x_msg_count => x_msg_count,

Line 5631: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,

5627: p_init_msg_list IN VARCHAR2,
5628: x_return_status OUT NOCOPY VARCHAR2,
5629: x_msg_count OUT NOCOPY NUMBER,
5630: x_msg_data OUT NOCOPY VARCHAR2,
5631: p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
5632: p_khrv_tbl IN khrv_tbl_type) IS
5633:
5634: l_api_name CONSTANT VARCHAR2(30) := 'validate_CONTRACT_HEADER';
5635: l_api_version CONSTANT NUMBER := 1.0;

Line 5738: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

5734: PROCEDURE roundoff_line_amount(
5735: x_return_status OUT NOCOPY VARCHAR2,
5736: x_msg_count OUT NOCOPY NUMBER,
5737: x_msg_data OUT NOCOPY VARCHAR2,
5738: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
5739: p_klev_rec IN klev_rec_type,
5740: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
5741: x_klev_rec OUT NOCOPY klev_rec_type
5742: ) IS

Line 5740: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,

5736: x_msg_count OUT NOCOPY NUMBER,
5737: x_msg_data OUT NOCOPY VARCHAR2,
5738: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
5739: p_klev_rec IN klev_rec_type,
5740: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
5741: x_klev_rec OUT NOCOPY klev_rec_type
5742: ) IS
5743:
5744: --Fix Bug# 2727161

Line 6218: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

6214: p_init_msg_list IN VARCHAR2,
6215: x_return_status OUT NOCOPY VARCHAR2,
6216: x_msg_count OUT NOCOPY NUMBER,
6217: x_msg_data OUT NOCOPY VARCHAR2,
6218: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
6219: p_klev_rec IN klev_rec_type,
6220: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
6221: x_klev_rec OUT NOCOPY klev_rec_type) IS
6222:

Line 6220: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,

6216: x_msg_count OUT NOCOPY NUMBER,
6217: x_msg_data OUT NOCOPY VARCHAR2,
6218: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
6219: p_klev_rec IN klev_rec_type,
6220: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
6221: x_klev_rec OUT NOCOPY klev_rec_type) IS
6222:
6223: /*
6224: -- vthiruva, 08/19/2004

Line 6243: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

6239: /*
6240: -- vthiruva, 08/19/2004
6241: -- END, Code change to enable Business Event
6242: */
6243: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
6244: l_klev_rec klev_rec_type;
6245:
6246: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
6247: lx_klev_rec klev_rec_type;

Line 6246: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

6242: */
6243: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
6244: l_klev_rec klev_rec_type;
6245:
6246: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
6247: lx_klev_rec klev_rec_type;
6248:
6249: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_LINE';
6250: l_api_version CONSTANT NUMBER := 1.0;

Line 6254: l_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;

6250: l_api_version CONSTANT NUMBER := 1.0;
6251: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6252:
6253: --Bug# 3143522
6254: l_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6255: lx_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6256: BEGIN
6257:
6258: -- call START_ACTIVITY to create savepoint, check compatibility

Line 6255: lx_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;

6251: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6252:
6253: --Bug# 3143522
6254: l_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6255: lx_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6256: BEGIN
6257:
6258: -- call START_ACTIVITY to create savepoint, check compatibility
6259: -- and initialize message list

Line 6342: okl_okc_migration_pvt.create_contract_line(

6338:
6339: --
6340: -- call procedure in complex API
6341: --
6342: okl_okc_migration_pvt.create_contract_line(
6343: p_api_version => p_api_version,
6344: p_init_msg_list => p_init_msg_list,
6345: x_return_status => x_return_status,
6346: x_msg_count => x_msg_count,

Line 6516: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

6512: p_init_msg_list IN VARCHAR2,
6513: x_return_status OUT NOCOPY VARCHAR2,
6514: x_msg_count OUT NOCOPY NUMBER,
6515: x_msg_data OUT NOCOPY VARCHAR2,
6516: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
6517: p_klev_tbl IN klev_tbl_type,
6518: x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
6519: x_klev_tbl OUT NOCOPY klev_tbl_type) IS
6520:

Line 6518: x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,

6514: x_msg_count OUT NOCOPY NUMBER,
6515: x_msg_data OUT NOCOPY VARCHAR2,
6516: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
6517: p_klev_tbl IN klev_tbl_type,
6518: x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
6519: x_klev_tbl OUT NOCOPY klev_tbl_type) IS
6520:
6521: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_LINE';
6522: l_api_version CONSTANT NUMBER := 1.0;

Line 6634: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

6630: p_init_msg_list IN VARCHAR2,
6631: x_return_status OUT NOCOPY VARCHAR2,
6632: x_msg_count OUT NOCOPY NUMBER,
6633: x_msg_data OUT NOCOPY VARCHAR2,
6634: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
6635: p_klev_rec IN klev_rec_type,
6636: p_edit_mode IN VARCHAR2,
6637: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
6638: x_klev_rec OUT NOCOPY klev_rec_type) IS

Line 6637: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,

6633: x_msg_data OUT NOCOPY VARCHAR2,
6634: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
6635: p_klev_rec IN klev_rec_type,
6636: p_edit_mode IN VARCHAR2,
6637: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
6638: x_klev_rec OUT NOCOPY klev_rec_type) IS
6639:
6640: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
6641: l_klev_rec klev_rec_type;

Line 6640: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

6636: p_edit_mode IN VARCHAR2,
6637: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
6638: x_klev_rec OUT NOCOPY klev_rec_type) IS
6639:
6640: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
6641: l_klev_rec klev_rec_type;
6642: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
6643: lx_klev_rec klev_rec_type;
6644:

Line 6642: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

6638: x_klev_rec OUT NOCOPY klev_rec_type) IS
6639:
6640: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
6641: l_klev_rec klev_rec_type;
6642: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
6643: lx_klev_rec klev_rec_type;
6644:
6645: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_LINE';
6646: l_api_version CONSTANT NUMBER := 1.0;

Line 6681: l_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;

6677: l_orig_end_date okc_k_lines_b.end_date%TYPE;
6678: l_orig_currency_code okc_k_lines_b.currency_code%TYPE;
6679: l_orig_sts_code okc_k_lines_b.sts_code%TYPE;
6680:
6681: l_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6682: lx_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6683: --Bug# 3143522
6684:
6685: /*

Line 6682: lx_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;

6678: l_orig_currency_code okc_k_lines_b.currency_code%TYPE;
6679: l_orig_sts_code okc_k_lines_b.sts_code%TYPE;
6680:
6681: l_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6682: lx_dt_clev_rec okl_okc_migration_pvt.clev_rec_type;
6683: --Bug# 3143522
6684:
6685: /*
6686: -- vthiruva, 08/19/2004

Line 6845: okl_okc_migration_pvt.update_contract_line(

6841:
6842: --
6843: -- call procedure in complex API
6844: --
6845: okl_okc_migration_pvt.update_contract_line(
6846: p_api_version => p_api_version,
6847: p_init_msg_list => p_init_msg_list,
6848: x_return_status => x_return_status,
6849: x_msg_count => x_msg_count,

Line 7061: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

7057: p_init_msg_list IN VARCHAR2,
7058: x_return_status OUT NOCOPY VARCHAR2,
7059: x_msg_count OUT NOCOPY NUMBER,
7060: x_msg_data OUT NOCOPY VARCHAR2,
7061: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
7062: p_klev_rec IN klev_rec_type,
7063: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
7064: x_klev_rec OUT NOCOPY klev_rec_type) IS
7065:

Line 7063: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,

7059: x_msg_count OUT NOCOPY NUMBER,
7060: x_msg_data OUT NOCOPY VARCHAR2,
7061: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
7062: p_klev_rec IN klev_rec_type,
7063: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
7064: x_klev_rec OUT NOCOPY klev_rec_type) IS
7065:
7066: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
7067: l_klev_rec klev_rec_type;

Line 7066: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

7062: p_klev_rec IN klev_rec_type,
7063: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
7064: x_klev_rec OUT NOCOPY klev_rec_type) IS
7065:
7066: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
7067: l_klev_rec klev_rec_type;
7068:
7069: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_LINE';
7070: l_api_version CONSTANT NUMBER := 1.0;

Line 7171: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

7167: p_init_msg_list IN VARCHAR2,
7168: x_return_status OUT NOCOPY VARCHAR2,
7169: x_msg_count OUT NOCOPY NUMBER,
7170: x_msg_data OUT NOCOPY VARCHAR2,
7171: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
7172: p_klev_tbl IN klev_tbl_type,
7173: p_edit_mode IN VARCHAR2,
7174: x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
7175: x_klev_tbl OUT NOCOPY klev_tbl_type) IS

Line 7174: x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,

7170: x_msg_data OUT NOCOPY VARCHAR2,
7171: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
7172: p_klev_tbl IN klev_tbl_type,
7173: p_edit_mode IN VARCHAR2,
7174: x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
7175: x_klev_tbl OUT NOCOPY klev_tbl_type) IS
7176:
7177: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_LINE';
7178: l_api_version CONSTANT NUMBER := 1.0;

Line 7289: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

7285: p_init_msg_list IN VARCHAR2,
7286: x_return_status OUT NOCOPY VARCHAR2,
7287: x_msg_count OUT NOCOPY NUMBER,
7288: x_msg_data OUT NOCOPY VARCHAR2,
7289: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
7290: p_klev_tbl IN klev_tbl_type,
7291: x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
7292: x_klev_tbl OUT NOCOPY klev_tbl_type) IS
7293:

Line 7291: x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,

7287: x_msg_count OUT NOCOPY NUMBER,
7288: x_msg_data OUT NOCOPY VARCHAR2,
7289: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
7290: p_klev_tbl IN klev_tbl_type,
7291: x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
7292: x_klev_tbl OUT NOCOPY klev_tbl_type) IS
7293:
7294: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_LINE';
7295: l_api_version CONSTANT NUMBER := 1.0;

Line 7390: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

7386: p_init_msg_list IN VARCHAR2,
7387: x_return_status OUT NOCOPY VARCHAR2,
7388: x_msg_count OUT NOCOPY NUMBER,
7389: x_msg_data OUT NOCOPY VARCHAR2,
7390: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
7391: p_klev_rec IN klev_rec_type) IS
7392:
7393: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
7394: l_klev_rec klev_rec_type;

Line 7393: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

7389: x_msg_data OUT NOCOPY VARCHAR2,
7390: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
7391: p_klev_rec IN klev_rec_type) IS
7392:
7393: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
7394: l_klev_rec klev_rec_type;
7395:
7396: l_clev_rec_out okl_okc_migration_pvt.clev_rec_type;
7397: l_klev_rec_out klev_rec_type;

Line 7396: l_clev_rec_out okl_okc_migration_pvt.clev_rec_type;

7392:
7393: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
7394: l_klev_rec klev_rec_type;
7395:
7396: l_clev_rec_out okl_okc_migration_pvt.clev_rec_type;
7397: l_klev_rec_out klev_rec_type;
7398:
7399: l_deletion_type Varchar2(1);
7400:

Line 7795: okl_okc_migration_pvt.delete_contract_line(

7791:
7792: --
7793: -- call procedure in complex API
7794: --
7795: okl_okc_migration_pvt.delete_contract_line(
7796: p_api_version => p_api_version,
7797: p_init_msg_list => p_init_msg_list,
7798: x_return_status => x_return_status,
7799: x_msg_count => x_msg_count,

Line 8104: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

8100: p_init_msg_list IN VARCHAR2,
8101: x_return_status OUT NOCOPY VARCHAR2,
8102: x_msg_count OUT NOCOPY NUMBER,
8103: x_msg_data OUT NOCOPY VARCHAR2,
8104: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
8105: p_klev_tbl IN klev_tbl_type) IS
8106:
8107: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_LINE';
8108: l_api_version CONSTANT NUMBER := 1.0;

Line 8303: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

8299:
8300: --variable added for checking if okl line deletion is allowed
8301: i Number;
8302: l_deletion_type Varchar2(1) default 'P';
8303: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
8304: l_klev_rec klev_rec_type;
8305:
8306: l_clev_rec_out okl_okc_migration_pvt.clev_rec_type;
8307: l_klev_rec_out klev_rec_type;

Line 8306: l_clev_rec_out okl_okc_migration_pvt.clev_rec_type;

8302: l_deletion_type Varchar2(1) default 'P';
8303: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
8304: l_klev_rec klev_rec_type;
8305:
8306: l_clev_rec_out okl_okc_migration_pvt.clev_rec_type;
8307: l_klev_rec_out klev_rec_type;
8308: --variable added for checking if okl line deletion is allowed
8309: --Bug# 3143522 : delete supplier invoice details is line is deleted
8310: --cursor to ger supplier invoice details

Line 8516: okl_okc_migration_pvt.update_contract_line

8512: --l_klev_rec.ID := l_klev_tbl_in(i).ID;
8513: --dbms_output.put_line('going in for logical delete');
8514: --dbms_output.put_line('line:'||to_char(l_clev_rec.id));
8515:
8516: okl_okc_migration_pvt.update_contract_line
8517: (p_api_version => p_api_version,
8518: p_init_msg_list => p_init_msg_list,
8519: x_return_status => x_return_status,
8520: x_msg_count => x_msg_count,

Line 9029: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

9025: p_init_msg_list IN VARCHAR2,
9026: x_return_status OUT NOCOPY VARCHAR2,
9027: x_msg_count OUT NOCOPY NUMBER,
9028: x_msg_data OUT NOCOPY VARCHAR2,
9029: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
9030: p_klev_rec IN klev_rec_type,
9031: p_delete_cascade_yn IN VARCHAR2) IS
9032:
9033: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 9033: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

9029: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
9030: p_klev_rec IN klev_rec_type,
9031: p_delete_cascade_yn IN VARCHAR2) IS
9032:
9033: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
9034: l_klev_rec klev_rec_type;
9035:
9036: l_clev_rec_out okl_okc_migration_pvt.clev_rec_type;
9037: l_klev_rec_out klev_rec_type;

Line 9036: l_clev_rec_out okl_okc_migration_pvt.clev_rec_type;

9032:
9033: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
9034: l_klev_rec klev_rec_type;
9035:
9036: l_clev_rec_out okl_okc_migration_pvt.clev_rec_type;
9037: l_klev_rec_out klev_rec_type;
9038:
9039: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_LINE';
9040: l_api_version CONSTANT NUMBER := 1.0;

Line 9142: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

9138: p_init_msg_list IN VARCHAR2,
9139: x_return_status OUT NOCOPY VARCHAR2,
9140: x_msg_count OUT NOCOPY NUMBER,
9141: x_msg_data OUT NOCOPY VARCHAR2,
9142: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
9143: p_klev_tbl IN klev_tbl_type,
9144: p_delete_cascade_yn IN varchar2) IS
9145:
9146: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_LINE';

Line 9251: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

9247: p_init_msg_list IN VARCHAR2,
9248: x_return_status OUT NOCOPY VARCHAR2,
9249: x_msg_count OUT NOCOPY NUMBER,
9250: x_msg_data OUT NOCOPY VARCHAR2,
9251: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
9252: p_klev_rec IN klev_rec_type) IS
9253:
9254: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
9255: l_klev_rec klev_rec_type;

Line 9254: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

9250: x_msg_data OUT NOCOPY VARCHAR2,
9251: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
9252: p_klev_rec IN klev_rec_type) IS
9253:
9254: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
9255: l_klev_rec klev_rec_type;
9256:
9257: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_CONTRACT_LINE';
9258: l_api_version CONSTANT NUMBER := 1.0;

Line 9286: okl_okc_migration_pvt.lock_contract_line(

9282:
9283: --
9284: -- call procedure in complex API
9285: --
9286: okl_okc_migration_pvt.lock_contract_line(
9287: p_api_version => p_api_version,
9288: p_init_msg_list => p_init_msg_list,
9289: x_return_status => x_return_status,
9290: x_msg_count => x_msg_count,

Line 9365: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

9361: p_init_msg_list IN VARCHAR2,
9362: x_return_status OUT NOCOPY VARCHAR2,
9363: x_msg_count OUT NOCOPY NUMBER,
9364: x_msg_data OUT NOCOPY VARCHAR2,
9365: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
9366: p_klev_tbl IN klev_tbl_type) IS
9367:
9368: l_api_name CONSTANT VARCHAR2(30) := 'lock_CONTRACT_LINE';
9369: l_api_version CONSTANT NUMBER := 1.0;

Line 9473: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

9469: p_init_msg_list IN VARCHAR2,
9470: x_return_status OUT NOCOPY VARCHAR2,
9471: x_msg_count OUT NOCOPY NUMBER,
9472: x_msg_data OUT NOCOPY VARCHAR2,
9473: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
9474: p_klev_rec IN klev_rec_type) IS
9475:
9476: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
9477: l_klev_rec klev_rec_type;

Line 9476: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

9472: x_msg_data OUT NOCOPY VARCHAR2,
9473: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
9474: p_klev_rec IN klev_rec_type) IS
9475:
9476: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
9477: l_klev_rec klev_rec_type;
9478:
9479: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_CONTRACT_LINE';
9480: l_api_version CONSTANT NUMBER := 1.0;

Line 9508: okl_okc_migration_pvt.validate_contract_line(

9504:
9505: --
9506: -- call procedure in complex API
9507: --
9508: okl_okc_migration_pvt.validate_contract_line(
9509: p_api_version => p_api_version,
9510: p_init_msg_list => p_init_msg_list,
9511: x_return_status => x_return_status,
9512: x_msg_count => x_msg_count,

Line 9587: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

9583: p_init_msg_list IN VARCHAR2,
9584: x_return_status OUT NOCOPY VARCHAR2,
9585: x_msg_count OUT NOCOPY NUMBER,
9586: x_msg_data OUT NOCOPY VARCHAR2,
9587: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
9588: p_klev_tbl IN klev_tbl_type) IS
9589:
9590: l_api_name CONSTANT VARCHAR2(30) := 'validate_CONTRACT_LINE';
9591: l_api_version CONSTANT NUMBER := 1.0;

Line 9688: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type,

9684: p_init_msg_list IN VARCHAR2,
9685: x_return_status OUT NOCOPY VARCHAR2,
9686: x_msg_count OUT NOCOPY NUMBER,
9687: x_msg_data OUT NOCOPY VARCHAR2,
9688: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type,
9689: x_gvev_rec OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type) IS
9690:
9691: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
9692:

Line 9689: x_gvev_rec OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type) IS

9685: x_return_status OUT NOCOPY VARCHAR2,
9686: x_msg_count OUT NOCOPY NUMBER,
9687: x_msg_data OUT NOCOPY VARCHAR2,
9688: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type,
9689: x_gvev_rec OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type) IS
9690:
9691: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
9692:
9693: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_GOVERNANCE';

Line 9691: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;

9687: x_msg_data OUT NOCOPY VARCHAR2,
9688: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type,
9689: x_gvev_rec OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type) IS
9690:
9691: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
9692:
9693: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_GOVERNANCE';
9694: l_api_version CONSTANT NUMBER := 1.0;
9695: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 9733: okl_okc_migration_pvt.create_governance(

9729: --
9730: -- call procedure in complex API
9731: --
9732: --OKC_CONTRACT_PUB.create_contract_header(
9733: okl_okc_migration_pvt.create_governance(
9734: p_api_version => p_api_version,
9735: p_init_msg_list => p_init_msg_list,
9736: x_return_status => x_return_status,
9737: x_msg_count => x_msg_count,

Line 9812: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type,

9808: p_init_msg_list IN VARCHAR2,
9809: x_return_status OUT NOCOPY VARCHAR2,
9810: x_msg_count OUT NOCOPY NUMBER,
9811: x_msg_data OUT NOCOPY VARCHAR2,
9812: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type,
9813: x_gvev_tbl OUT NOCOPY okl_okc_migration_pvt.gvev_tbl_type) IS
9814:
9815: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_GOVERNANCE';
9816: l_api_version CONSTANT NUMBER := 1.0;

Line 9813: x_gvev_tbl OUT NOCOPY okl_okc_migration_pvt.gvev_tbl_type) IS

9809: x_return_status OUT NOCOPY VARCHAR2,
9810: x_msg_count OUT NOCOPY NUMBER,
9811: x_msg_data OUT NOCOPY VARCHAR2,
9812: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type,
9813: x_gvev_tbl OUT NOCOPY okl_okc_migration_pvt.gvev_tbl_type) IS
9814:
9815: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_GOVERNANCE';
9816: l_api_version CONSTANT NUMBER := 1.0;
9817: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 9820: l_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type := p_gvev_tbl;

9816: l_api_version CONSTANT NUMBER := 1.0;
9817: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
9818: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
9819: i NUMBER;
9820: l_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type := p_gvev_tbl;
9821: BEGIN
9822: -- call START_ACTIVITY to create savepoint, check compatibility
9823: -- and initialize message list
9824: l_return_status := OKL_API.START_ACTIVITY(

Line 9920: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type,

9916: p_init_msg_list IN VARCHAR2,
9917: x_return_status OUT NOCOPY VARCHAR2,
9918: x_msg_count OUT NOCOPY NUMBER,
9919: x_msg_data OUT NOCOPY VARCHAR2,
9920: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type,
9921: x_gvev_rec OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type) IS
9922:
9923: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
9924:

Line 9921: x_gvev_rec OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type) IS

9917: x_return_status OUT NOCOPY VARCHAR2,
9918: x_msg_count OUT NOCOPY NUMBER,
9919: x_msg_data OUT NOCOPY VARCHAR2,
9920: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type,
9921: x_gvev_rec OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type) IS
9922:
9923: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
9924:
9925: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_GOVERNANCE';

Line 9923: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;

9919: x_msg_data OUT NOCOPY VARCHAR2,
9920: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type,
9921: x_gvev_rec OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type) IS
9922:
9923: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
9924:
9925: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_GOVERNANCE';
9926: l_api_version CONSTANT NUMBER := 1.0;
9927: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 9961: okl_okc_migration_pvt.update_governance(

9957: --
9958: -- call procedure in complex API
9959: --
9960: -- OKC_CONTRACT_PUB.update_contract_header(
9961: okl_okc_migration_pvt.update_governance(
9962: p_api_version => p_api_version,
9963: p_init_msg_list => p_init_msg_list,
9964: x_return_status => x_return_status,
9965: x_msg_count => x_msg_count,

Line 10044: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type,

10040: p_init_msg_list IN VARCHAR2,
10041: x_return_status OUT NOCOPY VARCHAR2,
10042: x_msg_count OUT NOCOPY NUMBER,
10043: x_msg_data OUT NOCOPY VARCHAR2,
10044: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type,
10045: x_gvev_tbl OUT NOCOPY okl_okc_migration_pvt.gvev_tbl_type) IS
10046:
10047: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_GOVERNANCE';
10048: l_api_version CONSTANT NUMBER := 1.0;

Line 10045: x_gvev_tbl OUT NOCOPY okl_okc_migration_pvt.gvev_tbl_type) IS

10041: x_return_status OUT NOCOPY VARCHAR2,
10042: x_msg_count OUT NOCOPY NUMBER,
10043: x_msg_data OUT NOCOPY VARCHAR2,
10044: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type,
10045: x_gvev_tbl OUT NOCOPY okl_okc_migration_pvt.gvev_tbl_type) IS
10046:
10047: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_GOVERNANCE';
10048: l_api_version CONSTANT NUMBER := 1.0;
10049: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 10052: l_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type := p_gvev_tbl;

10048: l_api_version CONSTANT NUMBER := 1.0;
10049: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10050: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10051: i NUMBER;
10052: l_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type := p_gvev_tbl;
10053: BEGIN
10054: -- call START_ACTIVITY to create savepoint, check compatibility
10055: -- and initialize message list
10056: l_return_status := OKL_API.START_ACTIVITY(

Line 10152: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type) IS

10148: p_init_msg_list IN VARCHAR2,
10149: x_return_status OUT NOCOPY VARCHAR2,
10150: x_msg_count OUT NOCOPY NUMBER,
10151: x_msg_data OUT NOCOPY VARCHAR2,
10152: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type) IS
10153:
10154: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
10155:
10156: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_GOVERNANCE';

Line 10154: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;

10150: x_msg_count OUT NOCOPY NUMBER,
10151: x_msg_data OUT NOCOPY VARCHAR2,
10152: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type) IS
10153:
10154: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
10155:
10156: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_GOVERNANCE';
10157: l_api_version CONSTANT NUMBER := 1.0;
10158: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 10224: okl_okc_migration_pvt.delete_governance(

10220: End If;
10221: --
10222: -- call procedure in complex API
10223: --
10224: okl_okc_migration_pvt.delete_governance(
10225: p_api_version => p_api_version,
10226: p_init_msg_list => p_init_msg_list,
10227: x_return_status => x_return_status,
10228: x_msg_count => x_msg_count,

Line 10286: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type) IS

10282: p_init_msg_list IN VARCHAR2,
10283: x_return_status OUT NOCOPY VARCHAR2,
10284: x_msg_count OUT NOCOPY NUMBER,
10285: x_msg_data OUT NOCOPY VARCHAR2,
10286: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type) IS
10287:
10288: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_GOVERNANCE';
10289: l_api_version CONSTANT NUMBER := 1.0;
10290: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 10293: l_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type := p_gvev_tbl;

10289: l_api_version CONSTANT NUMBER := 1.0;
10290: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10291: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10292: i NUMBER;
10293: l_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type := p_gvev_tbl;
10294: BEGIN
10295: -- call START_ACTIVITY to create savepoint, check compatibility
10296: -- and initialize message list
10297: l_return_status := OKL_API.START_ACTIVITY(

Line 10392: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type) IS

10388: p_init_msg_list IN VARCHAR2,
10389: x_return_status OUT NOCOPY VARCHAR2,
10390: x_msg_count OUT NOCOPY NUMBER,
10391: x_msg_data OUT NOCOPY VARCHAR2,
10392: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type) IS
10393:
10394: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
10395:
10396: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_GOVERNANCE';

Line 10394: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;

10390: x_msg_count OUT NOCOPY NUMBER,
10391: x_msg_data OUT NOCOPY VARCHAR2,
10392: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type) IS
10393:
10394: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
10395:
10396: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_GOVERNANCE';
10397: l_api_version CONSTANT NUMBER := 1.0;
10398: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 10431: okl_okc_migration_pvt.lock_governance(

10427:
10428: --
10429: -- call procedure in complex API
10430: --
10431: okl_okc_migration_pvt.lock_governance(
10432: p_api_version => p_api_version,
10433: p_init_msg_list => p_init_msg_list,
10434: x_return_status => x_return_status,
10435: x_msg_count => x_msg_count,

Line 10492: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type) IS

10488: p_init_msg_list IN VARCHAR2,
10489: x_return_status OUT NOCOPY VARCHAR2,
10490: x_msg_count OUT NOCOPY NUMBER,
10491: x_msg_data OUT NOCOPY VARCHAR2,
10492: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type) IS
10493:
10494: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_GOVERNANCE';
10495: l_api_version CONSTANT NUMBER := 1.0;
10496: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 10499: l_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type := p_gvev_tbl;

10495: l_api_version CONSTANT NUMBER := 1.0;
10496: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10497: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10498: i NUMBER;
10499: l_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type := p_gvev_tbl;
10500: BEGIN
10501: -- call START_ACTIVITY to create savepoint, check compatibility
10502: -- and initialize message list
10503: l_return_status := OKL_API.START_ACTIVITY(

Line 10599: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type) IS

10595: p_init_msg_list IN VARCHAR2,
10596: x_return_status OUT NOCOPY VARCHAR2,
10597: x_msg_count OUT NOCOPY NUMBER,
10598: x_msg_data OUT NOCOPY VARCHAR2,
10599: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type) IS
10600:
10601: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
10602:
10603:

Line 10601: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;

10597: x_msg_count OUT NOCOPY NUMBER,
10598: x_msg_data OUT NOCOPY VARCHAR2,
10599: p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type) IS
10600:
10601: l_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
10602:
10603:
10604: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_GOVERNANCE';
10605: l_api_version CONSTANT NUMBER := 1.0;

Line 10642: okl_okc_migration_pvt.validate_governance(

10638:
10639: --
10640: -- call procedure in complex API
10641: --
10642: okl_okc_migration_pvt.validate_governance(
10643: p_api_version => p_api_version,
10644: p_init_msg_list => p_init_msg_list,
10645: x_return_status => x_return_status,
10646: x_msg_count => x_msg_count,

Line 10705: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type) IS

10701: p_init_msg_list IN VARCHAR2,
10702: x_return_status OUT NOCOPY VARCHAR2,
10703: x_msg_count OUT NOCOPY NUMBER,
10704: x_msg_data OUT NOCOPY VARCHAR2,
10705: p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type) IS
10706:
10707: l_api_name CONSTANT VARCHAR2(30) := 'validate_CONTRACT_HEADER';
10708: l_api_version CONSTANT NUMBER := 1.0;
10709: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 10712: l_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type := p_gvev_tbl;

10708: l_api_version CONSTANT NUMBER := 1.0;
10709: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10710: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10711: i NUMBER;
10712: l_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type := p_gvev_tbl;
10713: BEGIN
10714: -- call START_ACTIVITY to create savepoint, check compatibility
10715: -- and initialize message list
10716: l_return_status := OKL_API.START_ACTIVITY(