DBA Data[Home] [Help]

APPS.OKL_CREATE_KLE_PVT dependencies on OKL_CONTRACT_PUB

Line 5268: OKL_CONTRACT_PUB.create_contract_line(p_api_version => p_api_version,

5264: p_token1_value => l_clev_rec.sts_code);
5265: RAISE OKL_API.G_EXCEPTION_ERROR;
5266: END IF;
5267:
5268: OKL_CONTRACT_PUB.create_contract_line(p_api_version => p_api_version,
5269: p_init_msg_list => p_init_msg_list,
5270: x_return_status => x_return_status,
5271: x_msg_count => x_msg_count,
5272: x_msg_data => x_msg_data,

Line 5343: OKL_CONTRACT_PUB.update_contract_line(p_api_version => p_api_version,

5339: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5340: RAISE OKL_API.G_EXCEPTION_ERROR;
5341: END IF;
5342: -- Calling the Process
5343: OKL_CONTRACT_PUB.update_contract_line(p_api_version => p_api_version,
5344: p_init_msg_list => p_init_msg_list,
5345: x_return_status => x_return_status,
5346: x_msg_count => x_msg_count,
5347: x_msg_data => x_msg_data,

Line 5414: l_klev_rec okl_contract_pub.klev_rec_type;

5410: and msi.inventory_item_id = p_inv_item_id;
5411:
5412: l_asset_category_id mtl_system_items.asset_category_id%TYPE default NULL;
5413: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
5414: l_klev_rec okl_contract_pub.klev_rec_type;
5415: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
5416: lx_klev_rec okl_contract_pub.klev_rec_type;
5417:
5418:

Line 5416: lx_klev_rec okl_contract_pub.klev_rec_type;

5412: l_asset_category_id mtl_system_items.asset_category_id%TYPE default NULL;
5413: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
5414: l_klev_rec okl_contract_pub.klev_rec_type;
5415: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
5416: lx_klev_rec okl_contract_pub.klev_rec_type;
5417:
5418:
5419: BEGIN
5420:

Line 5450: okl_contract_pub.update_contract_line(

5446: l_clev_rec.id := p_cle_id;
5447: l_klev_rec.id := p_cle_id;
5448: l_klev_rec.item_insurance_category := l_asset_category_id;
5449:
5450: okl_contract_pub.update_contract_line(
5451: p_api_version => p_api_version,
5452: p_init_msg_list => p_init_msg_list,
5453: x_return_status => x_return_status,
5454: x_msg_count => x_msg_count,

Line 5635: OKL_CONTRACT_PUB.create_contract_line(p_api_version => p_api_version,

5631: END IF;
5632: END IF;
5633:
5634: -- Now the all the records are there we can create Model Line
5635: OKL_CONTRACT_PUB.create_contract_line(p_api_version => p_api_version,
5636: p_init_msg_list => p_init_msg_list,
5637: x_return_status => x_return_status,
5638: x_msg_count => x_msg_count,
5639: x_msg_data => x_msg_data,

Line 5794: OKL_CONTRACT_PUB.update_contract_line(p_api_version => p_api_version,

5790: RAISE OKL_API.G_EXCEPTION_ERROR;
5791: END IF;
5792: IF l_lty_code = G_FIN_LINE_LTY_CODE THEN
5793: -- Now the all the records are there we can create Model Line
5794: OKL_CONTRACT_PUB.update_contract_line(p_api_version => p_api_version,
5795: p_init_msg_list => p_init_msg_list,
5796: x_return_status => x_return_status,
5797: x_msg_count => x_msg_count,
5798: x_msg_data => x_msg_data,

Line 6050: OKL_CONTRACT_PUB.create_contract_line(p_api_version => p_api_version,

6046: RAISE OKL_API.G_EXCEPTION_ERROR;
6047: END IF;
6048: END IF;
6049: -- Now the all the records are there we can create Fixed Asset Line
6050: OKL_CONTRACT_PUB.create_contract_line(p_api_version => p_api_version,
6051: p_init_msg_list => p_init_msg_list,
6052: x_return_status => x_return_status,
6053: x_msg_count => x_msg_count,
6054: x_msg_data => x_msg_data,

Line 6293: OKL_CONTRACT_PUB.update_contract_line(p_api_version => p_api_version,

6289: END IF;
6290: -- since Fixed Assets Line is a sub line of Fin Asset line we have to check weather
6291: -- which line are creating under which line
6292: IF l_lty_code = G_FIN_LINE_LTY_CODE THEN
6293: OKL_CONTRACT_PUB.update_contract_line(p_api_version => p_api_version,
6294: p_init_msg_list => p_init_msg_list,
6295: x_return_status => x_return_status,
6296: x_msg_count => x_msg_count,
6297: x_msg_data => x_msg_data,

Line 6539: OKL_CONTRACT_PUB.create_contract_line(p_api_version => p_api_version,

6535: p_clev_rec.display_sequence = OKL_API.G_MISS_NUM) THEN
6536: r_clev_rec.display_sequence := ln_display_sequence + 1;
6537: END IF;
6538: -- Calling the Process
6539: OKL_CONTRACT_PUB.create_contract_line(p_api_version => p_api_version,
6540: p_init_msg_list => p_init_msg_list,
6541: x_return_status => x_return_status,
6542: x_msg_count => x_msg_count,
6543: x_msg_data => x_msg_data,

Line 6720: OKL_CONTRACT_PUB.update_contract_line(p_api_version => p_api_version,

6716: IF (p_clev_rec.display_sequence IS NULL OR
6717: p_clev_rec.display_sequence = OKL_API.G_MISS_NUM) THEN
6718: l_clev_rec.display_sequence := ln_display_sequence + 1;
6719: END IF;
6720: OKL_CONTRACT_PUB.update_contract_line(p_api_version => p_api_version,
6721: p_init_msg_list => p_init_msg_list,
6722: x_return_status => x_return_status,
6723: x_msg_count => x_msg_count,
6724: x_msg_data => x_msg_data,

Line 7362: OKL_CONTRACT_PUB.delete_contract_line(

7358: (l_delete_clev_rec.cle_id IS NOT NULL OR
7359: l_delete_clev_rec.cle_id <> OKL_API.G_MISS_NUM) AND
7360: l_lty_code = G_ADDON_LINE_LTY_CODE AND
7361: l_lse_type = G_SLS_TYPE THEN
7362: OKL_CONTRACT_PUB.delete_contract_line(
7363: p_api_version => p_api_version,
7364: p_init_msg_list => p_init_msg_list,
7365: x_return_status => x_return_status,
7366: x_msg_count => x_msg_count,

Line 7533: OKL_CONTRACT_PUB.create_contract_line(p_api_version => p_api_version,

7529: END IF;
7530: END IF;
7531:
7532: -- Now the all the records are there we can create Instance Line
7533: OKL_CONTRACT_PUB.create_contract_line(p_api_version => p_api_version,
7534: p_init_msg_list => p_init_msg_list,
7535: x_return_status => x_return_status,
7536: x_msg_count => x_msg_count,
7537: x_msg_data => x_msg_data,

Line 7629: OKL_CONTRACT_PUB.update_contract_line(p_api_version => p_api_version,

7625: -- since Fixed Assets Line is a sub line of Fin Asset line we have to check weather
7626: -- which line are creating under which line
7627: IF l_lty_code = G_FIN_LINE_LTY_CODE THEN
7628: -- Now the all the records are there we can create Instance Line
7629: OKL_CONTRACT_PUB.update_contract_line(p_api_version => p_api_version,
7630: p_init_msg_list => p_init_msg_list,
7631: x_return_status => x_return_status,
7632: x_msg_count => x_msg_count,
7633: x_msg_data => x_msg_data,

Line 7805: OKL_CONTRACT_PUB.create_contract_line(p_api_version => p_api_version,

7801: RAISE OKL_API.G_EXCEPTION_ERROR;
7802: END IF;
7803: END IF;
7804: -- Now the all the records are there we can create Instance Line
7805: OKL_CONTRACT_PUB.create_contract_line(p_api_version => p_api_version,
7806: p_init_msg_list => p_init_msg_list,
7807: x_return_status => x_return_status,
7808: x_msg_count => x_msg_count,
7809: x_msg_data => x_msg_data,

Line 8083: OKL_CONTRACT_PUB.update_contract_line(p_api_version => p_api_version,

8079: -- since IB Line is a sub line of instance line we have to check weather
8080: -- which line are creating under which line
8081: IF l_lty_code = G_INST_LINE_LTY_CODE THEN
8082: -- Now the all the records are there we can create Instance Line
8083: OKL_CONTRACT_PUB.update_contract_line(p_api_version => p_api_version,
8084: p_init_msg_list => p_init_msg_list,
8085: x_return_status => x_return_status,
8086: x_msg_count => x_msg_count,
8087: x_msg_data => x_msg_data,

Line 13025: OKL_CONTRACT_PUB.delete_contract_line

13021: p_chr_id => p_chr_id);
13022: Loop
13023: Fetch l_addonline_csr into l_addonline_id;
13024: Exit when l_addonline_csr%NOTFOUND;
13025: OKL_CONTRACT_PUB.delete_contract_line
13026: (p_api_version => p_api_version,
13027: p_init_msg_list => p_init_msg_list,
13028: x_return_status => x_return_status,
13029: x_msg_count => x_msg_count,

Line 13049: OKL_CONTRACT_PUB.delete_contract_line

13045: p_chr_id => p_chr_id);
13046: Loop
13047: Fetch l_subsidyline_csr into l_subsidyline_id;
13048: Exit when l_subsidyline_csr%NOTFOUND;
13049: OKL_CONTRACT_PUB.delete_contract_line
13050: (p_api_version => p_api_version,
13051: p_init_msg_list => p_init_msg_list,
13052: x_return_status => x_return_status,
13053: x_msg_count => x_msg_count,

Line 13103: okl_contract_pub.update_contract_line

13099: l_dt_clev_rec.start_date := l_hdr_rec.start_date;
13100: l_dt_clev_rec.end_date := l_hdr_rec.end_date;
13101: l_dt_clev_rec.sts_code := l_hdr_rec.sts_code;
13102:
13103: okl_contract_pub.update_contract_line
13104: (p_api_version => p_api_version,
13105: p_init_msg_list => p_init_msg_list,
13106: x_return_status => x_return_status,
13107: x_msg_count => x_msg_count,

Line 13329: okl_contract_pub.update_contract_line

13325: --BUG# End : 3569441
13326: l_cimv_rec.id := l_modelline_rec.model_cim_id;
13327: l_cimv_rec.number_of_items := l_corpbook_rec.current_units;
13328:
13329: okl_contract_pub.update_contract_line
13330: (p_api_version => p_api_version,
13331: p_init_msg_list => p_init_msg_list,
13332: x_return_status => x_return_status,
13333: x_msg_count => x_msg_count,

Line 13369: okl_contract_pub.update_contract_line

13365: --BUG : 3569441
13366: l_klev_rec.oec := l_nbv;
13367: --l_klev_rec.oec := l_corpbook_rec.depreciation_cost;
13368:
13369: okl_contract_pub.update_contract_line
13370: (p_api_version => p_api_version,
13371: p_init_msg_list => p_init_msg_list,
13372: x_return_status => x_return_status,
13373: x_msg_count => x_msg_count,

Line 14179: OKL_CONTRACT_PUB.delete_contract_line(

14175: Close l_lines_csr;
14176:
14177:
14178: --Delete old line
14179: OKL_CONTRACT_PUB.delete_contract_line(
14180: p_api_version => p_api_version,
14181: p_init_msg_list => p_init_msg_list,
14182: x_return_status => x_return_status,
14183: x_msg_count => x_msg_count,

Line 14743: OKL_CONTRACT_PUB.update_contract_line(

14739: close l_cleb_csr;
14740:
14741: If l_clev_price_tbl.COUNT > 0 then
14742:
14743: OKL_CONTRACT_PUB.update_contract_line(
14744: p_api_version => p_api_version,
14745: p_init_msg_list => p_init_msg_list,
14746: x_return_status => x_return_status,
14747: x_msg_count => x_msg_count,

Line 14874: OKL_CONTRACT_PUB.update_contract_line(p_api_version => p_api_version,

14870:
14871: l_clev_fa_rec.item_description := p_talv_fa_rec.description;
14872:
14873: l_klev_fa_rec.Year_Built := p_talv_fa_rec.year_manufactured;
14874: OKL_CONTRACT_PUB.update_contract_line(p_api_version => p_api_version,
14875: p_init_msg_list => p_init_msg_list,
14876: x_return_status => x_return_status,
14877: x_msg_count => x_msg_count,
14878: x_msg_data => x_msg_data,

Line 16545: l_klev_fin_rec2 okl_contract_pub.klev_rec_type;

16541: l_expected_cost number;
16542:
16543: l_clev_fin_rec2 okl_okc_migration_pvt.clev_rec_type;
16544: lx_clev_fin_rec2 okl_okc_migration_pvt.clev_rec_type;
16545: l_klev_fin_rec2 okl_contract_pub.klev_rec_type;
16546: lx_klev_fin_rec2 okl_contract_pub.klev_rec_type;
16547: --End Bug# 4631549
16548:
16549: --Added by bkatraga for bug 13717587

Line 16546: lx_klev_fin_rec2 okl_contract_pub.klev_rec_type;

16542:
16543: l_clev_fin_rec2 okl_okc_migration_pvt.clev_rec_type;
16544: lx_clev_fin_rec2 okl_okc_migration_pvt.clev_rec_type;
16545: l_klev_fin_rec2 okl_contract_pub.klev_rec_type;
16546: lx_klev_fin_rec2 okl_contract_pub.klev_rec_type;
16547: --End Bug# 4631549
16548:
16549: --Added by bkatraga for bug 13717587
16550: l_db_num_of_items NUMBER;

Line 16819: OKL_CONTRACT_PUB.update_contract_line

16815: l_clev_fin_rec2.id := x_clev_fin_rec.id;
16816: l_klev_fin_rec2.id := x_clev_fin_rec.id;
16817: l_klev_fin_rec2.expected_asset_cost := l_expected_cost;
16818:
16819: OKL_CONTRACT_PUB.update_contract_line
16820: (p_api_version => p_api_version,
16821: p_init_msg_list => p_init_msg_list,
16822: x_return_status => x_return_status,
16823: x_msg_count => x_msg_count,

Line 20332: OKL_CONTRACT_PUB.delete_contract_line(

20328: RAISE OKL_API.G_EXCEPTION_ERROR;
20329: END IF;
20330: --Bug# 5362977 end
20331:
20332: OKL_CONTRACT_PUB.delete_contract_line(
20333: p_api_version => p_api_version,
20334: p_init_msg_list => p_init_msg_list,
20335: x_return_status => x_return_status,
20336: x_msg_count => x_msg_count,