DBA Data[Home] [Help]

APPS.OKS_AUTH_UTIL_PVT dependencies on OKS_BILL_SCH

Line 4092: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

4088: SELECT inv_rule_id
4089: FROM okc_k_lines_b
4090: WHERE id = p_id;
4091:
4092: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
4093: l_bill_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
4094: l_bill_type OKS_K_LINES_V.billing_schedule_type%TYPE;
4095:
4096:

Line 4093: l_bill_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;

4089: FROM okc_k_lines_b
4090: WHERE id = p_id;
4091:
4092: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
4093: l_bill_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
4094: l_bill_type OKS_K_LINES_V.billing_schedule_type%TYPE;
4095:
4096:
4097: 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 4097: 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)

4093: l_bill_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
4094: l_bill_type OKS_K_LINES_V.billing_schedule_type%TYPE;
4095:
4096:
4097: 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)
4098: IS
4099: tbl_index NUMBER := 1;
4100: CURSOR sll_cur(p_cle_id IN NUMBER) IS
4101: SELECT id

Line 4170: OKS_BILL_SCH.Create_Bill_Sch_Rules

4166:
4167:
4168: populate_sll_table (p_cle_id, l_sll_tbl, l_bill_type);
4169:
4170: OKS_BILL_SCH.Create_Bill_Sch_Rules
4171: (p_billing_type => l_bill_type,
4172: p_sll_tbl => l_sll_tbl,
4173: p_invoice_rule_id => l_inv_rule_id,
4174: x_bil_sch_out_tbl => l_bill_sch_out_tbl,

Line 7248: oks_bill_sch.Create_Bill_Sch_CP

7244: --refresh schedule
7245: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
7246: RAISE G_ERROR;
7247: END IF;
7248: oks_bill_sch.Create_Bill_Sch_CP
7249: (
7250: p_top_line_id => p_cle_id,
7251: p_cp_line_id => get_all_instances_rec.id,
7252: p_cp_new => 'N',