DBA Data[Home] [Help]

APPS.OKL_LA_SALES_TAX_PVT dependencies on OKL_MAINTAIN_FEE_PVT

Line 1440: l_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;

1436: x_msg_count OUT NOCOPY NUMBER,
1437: x_msg_data OUT NOCOPY VARCHAR2
1438: )
1439: IS
1440: l_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
1441: lx_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
1442:
1443: l_u_line_item_tbl OKL_CONTRACT_LINE_ITEM_PVT.line_item_tbl_type;
1444: lx_u_line_item_tbl OKL_CONTRACT_LINE_ITEM_PVT.line_item_tbl_type;

Line 1441: lx_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;

1437: x_msg_data OUT NOCOPY VARCHAR2
1438: )
1439: IS
1440: l_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
1441: lx_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
1442:
1443: l_u_line_item_tbl OKL_CONTRACT_LINE_ITEM_PVT.line_item_tbl_type;
1444: lx_u_line_item_tbl OKL_CONTRACT_LINE_ITEM_PVT.line_item_tbl_type;
1445:

Line 1599: l_del_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;

1595: AND kle.fee_type = p_fee_type
1596: AND cle.sts_code <> 'ABANDONED';
1597:
1598: l_del_fee_line_id OKC_K_LINES_B.id%TYPE;
1599: l_del_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
1600:
1601: -- Bug# 6512668: Exclude asset lines in Abandoned status
1602: CURSOR l_del_cov_asset_csr1(p_chr_id IN NUMBER,
1603: p_fee_cle_id IN NUMBER) IS

Line 1701: OKL_MAINTAIN_FEE_PVT.delete_fee_type(

1697: l_del_fee_types_rec.line_id := l_del_fee_line_id;
1698: l_del_fee_types_rec.dnz_chr_id := p_contract_id;
1699:
1700: -- delete fee line
1701: OKL_MAINTAIN_FEE_PVT.delete_fee_type(
1702: p_api_version => p_api_version,
1703: p_init_msg_list => p_init_msg_list,
1704: x_return_status => x_return_status,
1705: x_msg_count => x_msg_count,

Line 1711: 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);

1707: p_fee_types_rec => l_del_fee_types_rec
1708: );
1709:
1710: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1711: 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);
1712: END IF;
1713:
1714: -- Check if the call was successful
1715: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

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

1736: l_fee_types_rec.item_id := l_fee_rec.cim_fee_id;
1737: l_fee_types_rec.item_id1 := l_fee_rec.object1_id1;
1738:
1739: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1740: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Update Fee Procedure: before OKL_MAINTAIN_FEE_PVT.update_fee_type ');
1741: END IF;
1742:
1743: -- update fee top line
1744: OKL_MAINTAIN_FEE_PVT.update_fee_type(

Line 1744: OKL_MAINTAIN_FEE_PVT.update_fee_type(

1740: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Update Fee Procedure: before OKL_MAINTAIN_FEE_PVT.update_fee_type ');
1741: END IF;
1742:
1743: -- update fee top line
1744: OKL_MAINTAIN_FEE_PVT.update_fee_type(
1745: p_api_version => p_api_version,
1746: p_init_msg_list => p_init_msg_list,
1747: x_return_status => x_return_status,
1748: x_msg_count => x_msg_count,

Line 1755: 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);

1751: x_fee_types_rec => lx_fee_types_rec
1752: );
1753:
1754: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1755: 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);
1756: END IF;
1757:
1758: -- Check if the call was successful
1759: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

Line 2311: l_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;

2307: x_msg_count OUT NOCOPY NUMBER,
2308: x_msg_data OUT NOCOPY VARCHAR2
2309: )
2310: IS
2311: l_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
2312: lx_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
2313: l_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
2314: lx_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
2315:

Line 2312: lx_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;

2308: x_msg_data OUT NOCOPY VARCHAR2
2309: )
2310: IS
2311: l_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
2312: lx_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
2313: l_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
2314: lx_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
2315:
2316: l_rgpv_rec rgpv_rec_type;

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

2516: l_fee_types_rec.effective_from := contract_dates_csr_rec.start_date;
2517: l_fee_types_rec.effective_to := contract_dates_csr_rec.end_date;
2518:
2519: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
2520: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Create Fee Procedure: FINANCE segment: before OKL_MAINTAIN_FEE_PVT ');
2521: END IF;
2522: -- create fee top line
2523: OKL_MAINTAIN_FEE_PVT.create_fee_type(
2524: p_api_version => p_api_version,

Line 2523: OKL_MAINTAIN_FEE_PVT.create_fee_type(

2519: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
2520: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Create Fee Procedure: FINANCE segment: before OKL_MAINTAIN_FEE_PVT ');
2521: END IF;
2522: -- create fee top line
2523: OKL_MAINTAIN_FEE_PVT.create_fee_type(
2524: p_api_version => p_api_version,
2525: p_init_msg_list => p_init_msg_list,
2526: x_return_status => x_return_status,
2527: x_msg_count => x_msg_count,

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

2809: l_fee_types_rec.effective_from := contract_dates_csr_rec.start_date;
2810: l_fee_types_rec.effective_to := contract_dates_csr_rec.end_date;
2811:
2812: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
2813: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Pre Book Procedure: CAPITALIZE segment: before OKL_MAINTAIN_FEE_PVT ');
2814: END IF;
2815: -- Create Fee Top Line
2816: OKL_MAINTAIN_FEE_PVT.create_fee_type(
2817: p_api_version => p_api_version,

Line 2816: OKL_MAINTAIN_FEE_PVT.create_fee_type(

2812: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
2813: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Pre Book Procedure: CAPITALIZE segment: before OKL_MAINTAIN_FEE_PVT ');
2814: END IF;
2815: -- Create Fee Top Line
2816: OKL_MAINTAIN_FEE_PVT.create_fee_type(
2817: p_api_version => p_api_version,
2818: p_init_msg_list => p_init_msg_list,
2819: x_return_status => x_return_status,
2820: x_msg_count => x_msg_count,

Line 4256: l_del_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;

4252: AND kle.fee_type = NVL(p_fee_type,kle.fee_type)
4253: AND cle.sts_code <> 'ABANDONED';
4254:
4255: l_del_fee_line_id OKC_K_LINES_B.id%TYPE;
4256: l_del_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
4257: l_fee_type_to_delete OKL_K_LINES.fee_type%TYPE;
4258:
4259: BEGIN
4260: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 4331: OKL_MAINTAIN_FEE_PVT.delete_fee_type(

4327: l_del_fee_types_rec.line_id := l_del_fee_line_id;
4328: l_del_fee_types_rec.dnz_chr_id := p_contract_id;
4329:
4330: -- delete fee line
4331: OKL_MAINTAIN_FEE_PVT.delete_fee_type(
4332: p_api_version => p_api_version,
4333: p_init_msg_list => p_init_msg_list,
4334: x_return_status => x_return_status,
4335: x_msg_count => x_msg_count,

Line 4341: 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 );

4337: p_fee_types_rec => l_del_fee_types_rec
4338: );
4339:
4340: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4341: 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 );
4342: END IF;
4343:
4344: -- Check if the call was successful
4345: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

Line 4395: OKL_MAINTAIN_FEE_PVT.delete_fee_type(

4391: l_del_fee_types_rec.line_id := l_del_fee_line_id;
4392: l_del_fee_types_rec.dnz_chr_id := p_contract_id;
4393:
4394: -- delete fee line
4395: OKL_MAINTAIN_FEE_PVT.delete_fee_type(
4396: p_api_version => p_api_version,
4397: p_init_msg_list => p_init_msg_list,
4398: x_return_status => x_return_status,
4399: x_msg_count => x_msg_count,

Line 4405: 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 );

4401: p_fee_types_rec => l_del_fee_types_rec
4402: );
4403:
4404: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4405: 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 );
4406: END IF;
4407:
4408: -- Check if the call was successful
4409: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

Line 4497: OKL_MAINTAIN_FEE_PVT.delete_fee_type(

4493: l_del_fee_types_rec.line_id := l_del_fee_line_id;
4494: l_del_fee_types_rec.dnz_chr_id := p_contract_id;
4495:
4496: -- delete fee line
4497: OKL_MAINTAIN_FEE_PVT.delete_fee_type(
4498: p_api_version => p_api_version,
4499: p_init_msg_list => p_init_msg_list,
4500: x_return_status => x_return_status,
4501: x_msg_count => x_msg_count,

Line 4507: 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 );

4503: p_fee_types_rec => l_del_fee_types_rec
4504: );
4505:
4506: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4507: 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 );
4508: END IF;
4509:
4510: -- Check if the call was successful
4511: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

Line 4542: OKL_MAINTAIN_FEE_PVT.delete_fee_type(

4538: l_del_fee_types_rec.line_id := l_del_fee_line_id;
4539: l_del_fee_types_rec.dnz_chr_id := p_contract_id;
4540:
4541: -- delete fee line
4542: OKL_MAINTAIN_FEE_PVT.delete_fee_type(
4543: p_api_version => p_api_version,
4544: p_init_msg_list => p_init_msg_list,
4545: x_return_status => x_return_status,
4546: x_msg_count => x_msg_count,

Line 4552: 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 );

4548: p_fee_types_rec => l_del_fee_types_rec
4549: );
4550:
4551: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4552: 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 );
4553: END IF;
4554:
4555: -- Check if the call was successful
4556: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN