658: )
659: IS
660: l_lvl_element_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;
661: l_lvl_element_tbl_out oks_bill_level_elements_pvt.letv_tbl_type;
662: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl; --stream_lvl_tbl;
663: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl; --item_bill_sch_tbl;
664: l_lvl_element_tbl oks_bill_level_elements_pvt.letv_tbl_type;
665: l_bill_cont_tbl OKS_BILL_MIGRATION.bill_cont_tbl;
666: l_bill_sub_tbl OKS_BILL_MIGRATION.bill_cont_tbl;
659: IS
660: l_lvl_element_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;
661: l_lvl_element_tbl_out oks_bill_level_elements_pvt.letv_tbl_type;
662: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl; --stream_lvl_tbl;
663: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl; --item_bill_sch_tbl;
664: l_lvl_element_tbl oks_bill_level_elements_pvt.letv_tbl_type;
665: l_bill_cont_tbl OKS_BILL_MIGRATION.bill_cont_tbl;
666: l_bill_sub_tbl OKS_BILL_MIGRATION.bill_cont_tbl;
667:
932: x_return_status := l_return_status;
933:
934: IF l_SLL_tbl_type.COUNT > 0 THEN
935: -- Call bill API
936: oks_bill_sch.create_bill_sch_rules(p_billing_type => 'T',
937: p_sll_tbl => l_SLL_tbl_type,
938: p_invoice_rule_id => p_invoice_rule_id,
939: x_bil_sch_out_tbl => l_bil_sch_out_tbl,
940: x_return_status => l_return_status);
1127: , X_Return_status OUT NOCOPY Varchar2
1128: )
1129: Is
1130:
1131: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
1132: l_bil_sch_out OKS_BILL_SCH.ItemBillSch_tbl;
1133: l_api_version CONSTANT NUMBER := 1.0 ;
1134: l_init_msg_list CONSTANT VARCHAR2(1) := 'T' ;
1135: l_return_status VARCHAR2(1) ;
1128: )
1129: Is
1130:
1131: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
1132: l_bil_sch_out OKS_BILL_SCH.ItemBillSch_tbl;
1133: l_api_version CONSTANT NUMBER := 1.0 ;
1134: l_init_msg_list CONSTANT VARCHAR2(1) := 'T' ;
1135: l_return_status VARCHAR2(1) ;
1136: l_duration Number;
1508: WHERE cle_id = p_cle_id;
1509:
1510: l_lvl_element_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;
1511: l_lvl_element_tbl_out oks_bill_level_elements_pvt.letv_tbl_type;
1512: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl; --stream_lvl_tbl;
1513: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl; --item_bill_sch_tbl;
1514: l_lvl_element_tbl oks_bill_level_elements_pvt.letv_tbl_type;
1515: l_bill_cont_tbl bill_cont_tbl;
1516: l_bill_sub_tbl bill_cont_tbl;
1509:
1510: l_lvl_element_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;
1511: l_lvl_element_tbl_out oks_bill_level_elements_pvt.letv_tbl_type;
1512: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl; --stream_lvl_tbl;
1513: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl; --item_bill_sch_tbl;
1514: l_lvl_element_tbl oks_bill_level_elements_pvt.letv_tbl_type;
1515: l_bill_cont_tbl bill_cont_tbl;
1516: l_bill_sub_tbl bill_cont_tbl;
1517:
1821:
1822: IF l_SLL_tbl_type.COUNT > 0 THEN
1823: -- Call bill API
1824:
1825: oks_bill_sch.create_bill_sch_rules(p_billing_type => 'T',
1826: p_sll_tbl => l_SLL_tbl_type,
1827: p_invoice_rule_id => l_invoice_rule_id,
1828: x_bil_sch_out_tbl => l_bil_sch_out_tbl,
1829: x_return_status => l_return_status);