DBA Data[Home] [Help]

APPS.OKL_LA_SALES_TAX_PVT dependencies on OKL_MAINTAIN_FEE_PVT

Line 1626: l_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;

1622: x_msg_count OUT NOCOPY NUMBER,
1623: x_msg_data OUT NOCOPY VARCHAR2
1624: )
1625: IS
1626: l_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
1627: lx_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
1628:
1629: l_u_line_item_tbl OKL_CONTRACT_LINE_ITEM_PVT.line_item_tbl_type;
1630: lx_u_line_item_tbl OKL_CONTRACT_LINE_ITEM_PVT.line_item_tbl_type;

Line 1627: lx_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;

1623: x_msg_data OUT NOCOPY VARCHAR2
1624: )
1625: IS
1626: l_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
1627: lx_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
1628:
1629: l_u_line_item_tbl OKL_CONTRACT_LINE_ITEM_PVT.line_item_tbl_type;
1630: lx_u_line_item_tbl OKL_CONTRACT_LINE_ITEM_PVT.line_item_tbl_type;
1631:

Line 1794: l_del_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;

1790: AND kle.fee_type = p_fee_type
1791: AND cle.sts_code <> 'ABANDONED';
1792:
1793: l_del_fee_line_id OKC_K_LINES_B.id%TYPE;
1794: l_del_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
1795:
1796: -- Bug# 6512668: Exclude asset lines in Abandoned status
1797: CURSOR l_del_cov_asset_csr1(p_chr_id IN NUMBER,
1798: p_fee_cle_id IN NUMBER) IS

Line 1896: OKL_MAINTAIN_FEE_PVT.delete_fee_type(

1892: l_del_fee_types_rec.line_id := l_del_fee_line_id;
1893: l_del_fee_types_rec.dnz_chr_id := p_contract_id;
1894:
1895: -- delete fee line
1896: OKL_MAINTAIN_FEE_PVT.delete_fee_type(
1897: p_api_version => p_api_version,
1898: p_init_msg_list => p_init_msg_list,
1899: x_return_status => x_return_status,
1900: x_msg_count => x_msg_count,

Line 1906: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Update Fee Procedure: after OKL_MAINTAIN_FEE_PVT.delete_fee_type: x_return_status '||x_return_status);

1902: p_fee_types_rec => l_del_fee_types_rec
1903: );
1904:
1905: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1906: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Update Fee Procedure: after OKL_MAINTAIN_FEE_PVT.delete_fee_type: x_return_status '||x_return_status);
1907: END IF;
1908:
1909: -- Check if the call was successful
1910: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

Line 1943: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Update Fee Procedure: before OKL_MAINTAIN_FEE_PVT.update_fee_type ');

1939:
1940: l_fee_types_rec.item_name := l_strm_type_name;
1941:
1942: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1943: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Update Fee Procedure: before OKL_MAINTAIN_FEE_PVT.update_fee_type ');
1944: END IF;
1945:
1946: -- update fee top line
1947: OKL_MAINTAIN_FEE_PVT.update_fee_type(

Line 1947: OKL_MAINTAIN_FEE_PVT.update_fee_type(

1943: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Update Fee Procedure: before OKL_MAINTAIN_FEE_PVT.update_fee_type ');
1944: END IF;
1945:
1946: -- update fee top line
1947: OKL_MAINTAIN_FEE_PVT.update_fee_type(
1948: p_api_version => p_api_version,
1949: p_init_msg_list => p_init_msg_list,
1950: x_return_status => x_return_status,
1951: x_msg_count => x_msg_count,

Line 1958: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Update Fee Procedure: after OKL_MAINTAIN_FEE_PVT.update_fee_type: x_return_status '||x_return_status);

1954: x_fee_types_rec => lx_fee_types_rec
1955: );
1956:
1957: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1958: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Update Fee Procedure: after OKL_MAINTAIN_FEE_PVT.update_fee_type: x_return_status '||x_return_status);
1959: END IF;
1960:
1961: -- Check if the call was successful
1962: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

Line 2514: l_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;

2510: x_msg_count OUT NOCOPY NUMBER,
2511: x_msg_data OUT NOCOPY VARCHAR2
2512: )
2513: IS
2514: l_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
2515: lx_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
2516: l_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
2517: lx_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
2518:

Line 2515: lx_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;

2511: x_msg_data OUT NOCOPY VARCHAR2
2512: )
2513: IS
2514: l_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
2515: lx_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
2516: l_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
2517: lx_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
2518:
2519: l_rgpv_rec rgpv_rec_type;

Line 2724: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Create Fee Procedure: FINANCE segment: before OKL_MAINTAIN_FEE_PVT ');

2720: l_fee_types_rec.effective_from := contract_dates_csr_rec.start_date;
2721: l_fee_types_rec.effective_to := contract_dates_csr_rec.end_date;
2722:
2723: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
2724: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Create Fee Procedure: FINANCE segment: before OKL_MAINTAIN_FEE_PVT ');
2725: END IF;
2726: -- create fee top line
2727: OKL_MAINTAIN_FEE_PVT.create_fee_type(
2728: p_api_version => p_api_version,

Line 2727: OKL_MAINTAIN_FEE_PVT.create_fee_type(

2723: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
2724: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Create Fee Procedure: FINANCE segment: before OKL_MAINTAIN_FEE_PVT ');
2725: END IF;
2726: -- create fee top line
2727: OKL_MAINTAIN_FEE_PVT.create_fee_type(
2728: p_api_version => p_api_version,
2729: p_init_msg_list => p_init_msg_list,
2730: x_return_status => x_return_status,
2731: x_msg_count => x_msg_count,

Line 3017: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Pre Book Procedure: CAPITALIZE segment: before OKL_MAINTAIN_FEE_PVT ');

3013: l_fee_types_rec.effective_from := contract_dates_csr_rec.start_date;
3014: l_fee_types_rec.effective_to := contract_dates_csr_rec.end_date;
3015:
3016: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
3017: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Pre Book Procedure: CAPITALIZE segment: before OKL_MAINTAIN_FEE_PVT ');
3018: END IF;
3019: -- Create Fee Top Line
3020: OKL_MAINTAIN_FEE_PVT.create_fee_type(
3021: p_api_version => p_api_version,

Line 3020: OKL_MAINTAIN_FEE_PVT.create_fee_type(

3016: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
3017: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Pre Book Procedure: CAPITALIZE segment: before OKL_MAINTAIN_FEE_PVT ');
3018: END IF;
3019: -- Create Fee Top Line
3020: OKL_MAINTAIN_FEE_PVT.create_fee_type(
3021: p_api_version => p_api_version,
3022: p_init_msg_list => p_init_msg_list,
3023: x_return_status => x_return_status,
3024: x_msg_count => x_msg_count,

Line 4460: l_del_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;

4456: AND kle.fee_type = NVL(p_fee_type,kle.fee_type)
4457: AND cle.sts_code <> 'ABANDONED';
4458:
4459: l_del_fee_line_id OKC_K_LINES_B.id%TYPE;
4460: l_del_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
4461: l_fee_type_to_delete OKL_K_LINES.fee_type%TYPE;
4462:
4463: BEGIN
4464: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 4535: OKL_MAINTAIN_FEE_PVT.delete_fee_type(

4531: l_del_fee_types_rec.line_id := l_del_fee_line_id;
4532: l_del_fee_types_rec.dnz_chr_id := p_contract_id;
4533:
4534: -- delete fee line
4535: OKL_MAINTAIN_FEE_PVT.delete_fee_type(
4536: p_api_version => p_api_version,
4537: p_init_msg_list => p_init_msg_list,
4538: x_return_status => x_return_status,
4539: x_msg_count => x_msg_count,

Line 4545: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: '||p_transaction_type||' Procedure: after calling OKL_MAINTAIN_FEE_PVT.delete_fee_type: x_return_status '|| x_return_status );

4541: p_fee_types_rec => l_del_fee_types_rec
4542: );
4543:
4544: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4545: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: '||p_transaction_type||' Procedure: after calling OKL_MAINTAIN_FEE_PVT.delete_fee_type: x_return_status '|| x_return_status );
4546: END IF;
4547:
4548: -- Check if the call was successful
4549: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

Line 4599: OKL_MAINTAIN_FEE_PVT.delete_fee_type(

4595: l_del_fee_types_rec.line_id := l_del_fee_line_id;
4596: l_del_fee_types_rec.dnz_chr_id := p_contract_id;
4597:
4598: -- delete fee line
4599: OKL_MAINTAIN_FEE_PVT.delete_fee_type(
4600: p_api_version => p_api_version,
4601: p_init_msg_list => p_init_msg_list,
4602: x_return_status => x_return_status,
4603: x_msg_count => x_msg_count,

Line 4609: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: '||p_transaction_type||' Procedure: after calling OKL_MAINTAIN_FEE_PVT.delete_fee_type: x_return_status '|| x_return_status );

4605: p_fee_types_rec => l_del_fee_types_rec
4606: );
4607:
4608: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4609: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: '||p_transaction_type||' Procedure: after calling OKL_MAINTAIN_FEE_PVT.delete_fee_type: x_return_status '|| x_return_status );
4610: END IF;
4611:
4612: -- Check if the call was successful
4613: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

Line 4701: OKL_MAINTAIN_FEE_PVT.delete_fee_type(

4697: l_del_fee_types_rec.line_id := l_del_fee_line_id;
4698: l_del_fee_types_rec.dnz_chr_id := p_contract_id;
4699:
4700: -- delete fee line
4701: OKL_MAINTAIN_FEE_PVT.delete_fee_type(
4702: p_api_version => p_api_version,
4703: p_init_msg_list => p_init_msg_list,
4704: x_return_status => x_return_status,
4705: x_msg_count => x_msg_count,

Line 4711: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: '||p_transaction_type||' Procedure: after calling OKL_MAINTAIN_FEE_PVT.delete_fee_type: x_return_status '|| x_return_status );

4707: p_fee_types_rec => l_del_fee_types_rec
4708: );
4709:
4710: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4711: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: '||p_transaction_type||' Procedure: after calling OKL_MAINTAIN_FEE_PVT.delete_fee_type: x_return_status '|| x_return_status );
4712: END IF;
4713:
4714: -- Check if the call was successful
4715: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

Line 4746: OKL_MAINTAIN_FEE_PVT.delete_fee_type(

4742: l_del_fee_types_rec.line_id := l_del_fee_line_id;
4743: l_del_fee_types_rec.dnz_chr_id := p_contract_id;
4744:
4745: -- delete fee line
4746: OKL_MAINTAIN_FEE_PVT.delete_fee_type(
4747: p_api_version => p_api_version,
4748: p_init_msg_list => p_init_msg_list,
4749: x_return_status => x_return_status,
4750: x_msg_count => x_msg_count,

Line 4756: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: '||p_transaction_type||' Procedure: after calling OKL_MAINTAIN_FEE_PVT.delete_fee_type: x_return_status '|| x_return_status );

4752: p_fee_types_rec => l_del_fee_types_rec
4753: );
4754:
4755: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4756: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: '||p_transaction_type||' Procedure: after calling OKL_MAINTAIN_FEE_PVT.delete_fee_type: x_return_status '|| x_return_status );
4757: END IF;
4758:
4759: -- Check if the call was successful
4760: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN