DBA Data[Home] [Help]

APPS.OKS_BILL_MIGRATION dependencies on OKS_BILL_SCH

Line 662: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl; --stream_lvl_tbl;

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;

Line 663: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl; --item_bill_sch_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:

Line 936: oks_bill_sch.create_bill_sch_rules(p_billing_type => 'T',

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);

Line 1131: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

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) ;

Line 1132: l_bil_sch_out OKS_BILL_SCH.ItemBillSch_tbl;

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;

Line 1512: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl; --stream_lvl_tbl;

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;

Line 1513: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl; --item_bill_sch_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:

Line 1825: oks_bill_sch.create_bill_sch_rules(p_billing_type => 'T',

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);