APPS.OKS_BILL_MIGRATION dependencies on OKS_BILL_MIGRATION

Line 1: PACKAGE BODY OKS_BILL_MIGRATION AS

1: PACKAGE BODY OKS_BILL_MIGRATION AS
2: /* $Header: OKSBMIGB.pls 120.1 2005/10/03 07:52:21 upillai noship $ */
3:
4:
5: G_DESCRIPTIVE_FLEXFIELD_NAME CONSTANT VARCHAR2(200) := 'OKC Rule Developer DF';

Line 319: 'OKS_BILL_MIGRATION.BILL_UPGRADATION(' ||

315: l_agg_rec.stdid, l_agg_rec.total);
316:
317: for idx in 1..l_subrequests loop
318: dbms_job.submit(range_arr(idx).jobno,
319: 'OKS_BILL_MIGRATION.BILL_UPGRADATION(' ||
320: range_arr(idx).lo ||','|| range_arr(idx).hi ||');',
321: instance => get_instance_id);
322: commit;
323: end loop;

Line 416: 'OKS_BILL_MIGRATION.BILL_UPGRADATION_OM(' ||

412: l_agg_rec.stdid, l_agg_rec.total);
413:
414: for idx in 1..l_subrequests loop
415: dbms_job.submit(range_arr(idx).jobno,
416: 'OKS_BILL_MIGRATION.BILL_UPGRADATION_OM(' ||
417: range_arr(idx).lo ||','|| range_arr(idx).hi ||');',
418: instance => get_instance_id);
419: commit;
420: end loop;

Line 665: l_bill_cont_tbl OKS_BILL_MIGRATION.bill_cont_tbl;

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:
668: l_rule_id NUMBER := 0;
669: l_start_date DATE;

Line 666: l_bill_sub_tbl OKS_BILL_MIGRATION.bill_cont_tbl;

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:
668: l_rule_id NUMBER := 0;
669: l_start_date DATE;
670: l_end_date DATE;

Line 1609: OKS_BILL_MIGRATION.one_time_billing(

1605: l_rl2_flag_null := 'N';
1606:
1607: IF rules_rec.rule_information2 IS NULL THEN
1608: --Call proc one_time_billing
1609: OKS_BILL_MIGRATION.one_time_billing(
1610: p_invoice_rule_id => l_invoice_rule_id
1611: ,p_cle_id => l_id(i)
1612: ,x_return_status => l_return_status);
1613:

Line 2277: END OKS_BILL_MIGRATION;

2273:
2274: END UPDATE_OKS_LEVEL_ELEMENTS ;
2275:
2276:
2277: END OKS_BILL_MIGRATION;