DBA Data[Home] [Help]

APPS.OKS_AUTH_UTIL_PVT dependencies on OKS_BILL_SCH

Line 4632: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

4628: SELECT inv_rule_id
4629: FROM okc_k_lines_b
4630: WHERE id = p_id;
4631:
4632: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
4633: l_bill_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
4634: l_bill_type OKS_K_LINES_V.billing_schedule_type%TYPE;
4635:
4636:

Line 4633: l_bill_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;

4629: FROM okc_k_lines_b
4630: WHERE id = p_id;
4631:
4632: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
4633: l_bill_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
4634: l_bill_type OKS_K_LINES_V.billing_schedule_type%TYPE;
4635:
4636:
4637: PROCEDURE Populate_Sll_Table(p_cle_id IN NUMBER, x_sll_tbl OUT NOCOPY OKS_BILL_SCH.StreamLvl_tbl, x_bill_type OUT NOCOPY OKS_K_LINES_V.billing_schedule_type%TYPE)

Line 4637: PROCEDURE Populate_Sll_Table(p_cle_id IN NUMBER, x_sll_tbl OUT NOCOPY OKS_BILL_SCH.StreamLvl_tbl, x_bill_type OUT NOCOPY OKS_K_LINES_V.billing_schedule_type%TYPE)

4633: l_bill_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
4634: l_bill_type OKS_K_LINES_V.billing_schedule_type%TYPE;
4635:
4636:
4637: PROCEDURE Populate_Sll_Table(p_cle_id IN NUMBER, x_sll_tbl OUT NOCOPY OKS_BILL_SCH.StreamLvl_tbl, x_bill_type OUT NOCOPY OKS_K_LINES_V.billing_schedule_type%TYPE)
4638: IS
4639: tbl_index NUMBER := 1;
4640: CURSOR sll_cur(p_cle_id IN NUMBER) IS
4641: SELECT id

Line 4710: OKS_BILL_SCH.Create_Bill_Sch_Rules

4706:
4707:
4708: populate_sll_table (p_cle_id, l_sll_tbl, l_bill_type);
4709:
4710: OKS_BILL_SCH.Create_Bill_Sch_Rules
4711: (p_billing_type => l_bill_type,
4712: p_sll_tbl => l_sll_tbl,
4713: p_invoice_rule_id => l_inv_rule_id,
4714: x_bil_sch_out_tbl => l_bill_sch_out_tbl,

Line 7912: oks_bill_sch.Create_Bill_Sch_CP

7908: --refresh schedule
7909: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
7910: RAISE G_ERROR;
7911: END IF;
7912: oks_bill_sch.Create_Bill_Sch_CP
7913: (
7914: p_top_line_id => p_cle_id,
7915: p_cp_line_id => get_all_instances_rec.id,
7916: p_cp_new => 'N',