APPS.OKS_BILL_REC_PUB dependencies on OKS_BSD_PR

Line 6416: FROM Oks_bsd_pr ldtl

6412: Order By date_billed_to desc ;
6413:
6414: Cursor l_actual_counter_csr_prv (p_cle_id IN NUMBER , p_start_date IN DATE) IS
6415: SELECT nvl(end_reading,0) qty
6416: FROM Oks_bsd_pr ldtl
6417: ,oks_bsl_pr line
6418: WHERE line.cle_id = p_cle_id
6419: AND ldtl.bsl_id = line.id
6420: AND nvl(end_reading,0) > 0

Line 6437: FROM Oks_bsd_pr ldtl

6433:
6434:
6435: Cursor l_actual_csr_prv(p_cle_id IN NUMBER) Is
6436: SELECT NVL(sign(ldtl.amount)*Result,0) + nvl(base_reading,0) qty
6437: FROM Oks_bsd_pr ldtl
6438: ,oks_bsl_pr line
6439: WHERE line.cle_id = p_cle_id
6440: AND ldtl.bsl_id = line.id
6441: ORDER BY date_billed_to desc;

Line 6458: FROM Oks_bsd_pr ldtl

6454:
6455:
6456: Cursor l_ccr_id_csr_prv (p_cle_id IN NUMBER , p_start_date IN DATE) IS
6457: SELECT end_reading read,ccr_id,cgr_id
6458: FROM Oks_bsd_pr ldtl
6459: ,oks_bsl_pr line
6460: WHERE line.cle_id = p_cle_id
6461: AND ldtl.bsl_id = line.id
6462: AND trunc(line.date_billed_from) < trunc(p_start_date)

Line 7005: UPDATE oks_bsd_pr

7001: SET amount = round_amount,
7002: average = 0
7003: WHERE id = p_bsl_id;
7004:
7005: UPDATE oks_bsd_pr
7006: SET amount = round_amount
7007: WHERE bsl_id = p_bsl_id;
7008:
7009: END IF;

Line 7373: SUBTYPE l_bsd_pr_tbl_type is OKS_BSD_PRINT_PREVIEW_PVT.bsd_pr_tbl_type;

7369: l_bcl_pr_tbl_out l_bcl_pr_tbl_type;
7370: SUBTYPE l_bsl_pr_tbl_type is OKS_BSL_PRINT_PREVIEW_PVT.bsl_pr_tbl_type;
7371: l_bsl_pr_tbl_in l_bsl_pr_tbl_type;
7372: l_bsl_pr_tbl_out l_bsl_pr_tbl_type;
7373: SUBTYPE l_bsd_pr_tbl_type is OKS_BSD_PRINT_PREVIEW_PVT.bsd_pr_tbl_type;
7374: l_bsd_pr_tbl_in l_bsd_pr_tbl_type;
7375: l_bsd_pr_tbl_out l_bsd_pr_tbl_type;
7376:
7377:

Line 7615: OKS_BSD_PRV_PUB.insert_bsd_pr

7611: l_bsd_pr_tbl_in(1).attribute15 := NULL;
7612: l_bsd_pr_tbl_in(1).security_group_id := NULL;
7613:
7614:
7615: OKS_BSD_PRV_PUB.insert_bsd_pr
7616: (
7617: P_API_VERSION => 1.0,
7618: P_INIT_MSG_LIST => 'T',
7619: X_RETURN_STATUS => l_ret_stat,