DBA Data[Home] [Help]

APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKS_BILLING_PROFILES_PUB

Line 2624: l_rec OKS_BILLING_PROFILES_PUB.billing_profile_rec;

2620: l_bsch_typ_tbl chr_tbl_type;
2621: l_lse_id_tbl num_tbl_type;
2622: l_usage_typ_tbl chr_tbl_type;
2623:
2624: l_rec OKS_BILLING_PROFILES_PUB.billing_profile_rec;
2625: l_sll_tbl_out OKS_BILLING_PROFILES_PUB.stream_level_tbl;
2626:
2627: l_sll_tbl OKS_BILL_SCH.streamlvl_tbl;
2628: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;

Line 2625: l_sll_tbl_out OKS_BILLING_PROFILES_PUB.stream_level_tbl;

2621: l_lse_id_tbl num_tbl_type;
2622: l_usage_typ_tbl chr_tbl_type;
2623:
2624: l_rec OKS_BILLING_PROFILES_PUB.billing_profile_rec;
2625: l_sll_tbl_out OKS_BILLING_PROFILES_PUB.stream_level_tbl;
2626:
2627: l_sll_tbl OKS_BILL_SCH.streamlvl_tbl;
2628: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
2629:

Line 2666: ' calling OKS_BILLING_PROFILES_PUB.get_billing_schedule, l_rec.cle_id='||l_rec.cle_id||

2662:
2663: --get the billing profile based sll
2664: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2665: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'get_tl_bill_sch : i='||i||
2666: ' calling OKS_BILLING_PROFILES_PUB.get_billing_schedule, l_rec.cle_id='||l_rec.cle_id||
2667: ' ,l_rec.start_date='||l_rec.start_date||' ,l_rec.end_date='||l_rec.end_date);
2668: END IF;
2669:
2670: OKS_BILLING_PROFILES_PUB.get_billing_schedule(

Line 2670: OKS_BILLING_PROFILES_PUB.get_billing_schedule(

2666: ' calling OKS_BILLING_PROFILES_PUB.get_billing_schedule, l_rec.cle_id='||l_rec.cle_id||
2667: ' ,l_rec.start_date='||l_rec.start_date||' ,l_rec.end_date='||l_rec.end_date);
2668: END IF;
2669:
2670: OKS_BILLING_PROFILES_PUB.get_billing_schedule(
2671: p_api_version => 1.0,
2672: p_init_msg_list => FND_API.G_FALSE,
2673: p_billing_profile_rec => l_rec,
2674: x_sll_tbl_out => l_sll_tbl_out,

Line 2680: FND_LOG.string(FND_LOG.level_statement, l_mod_name,' get_tl_bill_sch: i='||i||' after call to OKS_BILLING_PROFILES_PUB.get_billing_schedule, x_return_status='||x_return_status||' ,l_sll_tbl_out.count='||l_sll_tbl_out.count);

2676: x_msg_count => x_msg_count,
2677: x_msg_data => x_msg_data);
2678:
2679: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2680: FND_LOG.string(FND_LOG.level_statement, l_mod_name,' get_tl_bill_sch: i='||i||' after call to OKS_BILLING_PROFILES_PUB.get_billing_schedule, x_return_status='||x_return_status||' ,l_sll_tbl_out.count='||l_sll_tbl_out.count);
2681: END IF;
2682:
2683: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2684: RAISE FND_API.g_exc_unexpected_error;

Line 2689: --note OKS_BILLING_PROFILES_PUB.get_billing_schedule always returns

2685: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
2686: RAISE FND_API.g_exc_error;
2687: END IF;
2688:
2689: --note OKS_BILLING_PROFILES_PUB.get_billing_schedule always returns
2690: --one row and the values for invoice_rule_id/account_rule_id don't change for
2691: --every line, they are the same for a given billing profile.
2692: --we can therefore validate and update invoice_rule_id/account_rule_id only once
2693: IF l_sll_tbl_out.COUNT > 0 THEN