APPS.OKS_BILL_MIGRATION dependencies on OKS_BILL_LEVEL_ELEMENTS_PVT

Line 223: p_lvl_element_tbl IN oks_bill_level_elements_pvt.letv_tbl_type

219:
220:
221: PROCEDURE update_lvl_elements
222: (
223: p_lvl_element_tbl IN oks_bill_level_elements_pvt.letv_tbl_type
224: ,x_lvl_element_tbl OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type
225: ,x_return_status OUT NOCOPY Varchar2
226: ,x_msg_count OUT NOCOPY Number
227: ,x_msg_data OUT NOCOPY Varchar2

Line 224: ,x_lvl_element_tbl OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type

220:
221: PROCEDURE update_lvl_elements
222: (
223: p_lvl_element_tbl IN oks_bill_level_elements_pvt.letv_tbl_type
224: ,x_lvl_element_tbl OUT NOCOPY oks_bill_level_elements_pvt.letv_tbl_type
225: ,x_return_status OUT NOCOPY Varchar2
226: ,x_msg_count OUT NOCOPY Number
227: ,x_msg_data OUT NOCOPY Varchar2
228: )

Line 230: l_lvl_element_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;

226: ,x_msg_count OUT NOCOPY Number
227: ,x_msg_data OUT NOCOPY Varchar2
228: )
229: IS
230: l_lvl_element_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;
231: l_lvl_element_tbl_out oks_bill_level_elements_pvt.letv_tbl_type;
232: l_api_version CONSTANT NUMBER := 1.0;
233: l_init_msg_list CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
234: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 231: l_lvl_element_tbl_out oks_bill_level_elements_pvt.letv_tbl_type;

227: ,x_msg_data OUT NOCOPY Varchar2
228: )
229: IS
230: l_lvl_element_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;
231: l_lvl_element_tbl_out oks_bill_level_elements_pvt.letv_tbl_type;
232: l_api_version CONSTANT NUMBER := 1.0;
233: l_init_msg_list CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
234: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
235: l_index NUMBER;

Line 660: l_lvl_element_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;

656: p_cle_id NUMBER,
657: x_return_status OUT NOCOPY VARCHAR2
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;

Line 661: l_lvl_element_tbl_out oks_bill_level_elements_pvt.letv_tbl_type;

657: x_return_status OUT NOCOPY VARCHAR2
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;

Line 664: l_lvl_element_tbl oks_bill_level_elements_pvt.letv_tbl_type;

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

Line 1510: l_lvl_element_tbl_in oks_bill_level_elements_pvt.letv_tbl_type;

1506: amount
1507: FROM oks_bill_sub_lines
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;

Line 1511: l_lvl_element_tbl_out oks_bill_level_elements_pvt.letv_tbl_type;

1507: FROM oks_bill_sub_lines
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;

Line 1514: l_lvl_element_tbl oks_bill_level_elements_pvt.letv_tbl_type;

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:
1518: l_adv_arr VARCHAR2(40);

Line 2095: SUBTYPE LEVEL_ID_TBL IS OKS_BILL_LEVEL_ELEMENTS_PVT.letv_tbl_type ;

2091: L_GET_ORDER_NUMBER_REC L_GET_ORDER_NUMBER_CSR%ROWTYPE ;
2092:
2093: TYPE LEVEL_ID_REC IS RECORD (
2094: L_LEVEL_ID NUMBER );
2095: SUBTYPE LEVEL_ID_TBL IS OKS_BILL_LEVEL_ELEMENTS_PVT.letv_tbl_type ;
2096: L_LEVEL_ID_TBL LEVEL_ID_TBL ;
2097: L_letv_tbl LEVEL_ID_TBL ;
2098:
2099:

Line 2131: LEVEL_REC OKS_BILL_LEVEL_ELEMENTS_PVT.LETV_REC_TYPE;

2127: SUBTYPE l_bcl_tbl_type_in is OKS_bcl_PVT.bclv_tbl_type;
2128: l_bcl_tbl_in l_bcl_tbl_type_in;
2129: l_bcl_tbl_out l_bcl_tbl_type_in;
2130:
2131: LEVEL_REC OKS_BILL_LEVEL_ELEMENTS_PVT.LETV_REC_TYPE;
2132: GET_REC OKS_BILL_LEVEL_ELEMENTS_PVT.LETV_REC_TYPE;
2133:
2134: TYPE L_TOP_LINE_REC IS RECORD (
2135: TOP_LINE_ID NUMBER

Line 2132: GET_REC OKS_BILL_LEVEL_ELEMENTS_PVT.LETV_REC_TYPE;

2128: l_bcl_tbl_in l_bcl_tbl_type_in;
2129: l_bcl_tbl_out l_bcl_tbl_type_in;
2130:
2131: LEVEL_REC OKS_BILL_LEVEL_ELEMENTS_PVT.LETV_REC_TYPE;
2132: GET_REC OKS_BILL_LEVEL_ELEMENTS_PVT.LETV_REC_TYPE;
2133:
2134: TYPE L_TOP_LINE_REC IS RECORD (
2135: TOP_LINE_ID NUMBER
2136: ,UPG_ORIG_SYSTEM_REF VARCHAR2(60)