APPS.OKS_BILL_REC_PUB dependencies on OKS_BSD_PR

Line 6442: FROM Oks_bsd_pr ldtl

6438: Order By date_billed_to desc ;
6439:
6440: Cursor l_actual_counter_csr_prv (p_cle_id IN NUMBER , p_start_date IN DATE) IS
6441: SELECT nvl(end_reading,0) qty
6442: FROM Oks_bsd_pr ldtl
6443: ,oks_bsl_pr line
6444: WHERE line.cle_id = p_cle_id
6445: AND ldtl.bsl_id = line.id
6446: AND nvl(end_reading,0) > 0

Line 6463: FROM Oks_bsd_pr ldtl

6459:
6460:
6461: Cursor l_actual_csr_prv(p_cle_id IN NUMBER) Is
6462: SELECT NVL(sign(ldtl.amount)*Result,0) + nvl(base_reading,0) qty
6463: FROM Oks_bsd_pr ldtl
6464: ,oks_bsl_pr line
6465: WHERE line.cle_id = p_cle_id
6466: AND ldtl.bsl_id = line.id
6467: ORDER BY date_billed_to desc;

Line 6484: FROM Oks_bsd_pr ldtl

6480:
6481:
6482: Cursor l_ccr_id_csr_prv (p_cle_id IN NUMBER , p_start_date IN DATE) IS
6483: SELECT end_reading read,ccr_id,cgr_id
6484: FROM Oks_bsd_pr ldtl
6485: ,oks_bsl_pr line
6486: WHERE line.cle_id = p_cle_id
6487: AND ldtl.bsl_id = line.id
6488: AND trunc(line.date_billed_from) < trunc(p_start_date)

Line 7037: UPDATE oks_bsd_pr

7033: SET amount = round_amount,
7034: average = 0
7035: WHERE id = p_bsl_id;
7036:
7037: UPDATE oks_bsd_pr
7038: SET amount = round_amount
7039: WHERE bsl_id = p_bsl_id;
7040:
7041: END IF;

Line 7405: SUBTYPE l_bsd_pr_tbl_type is OKS_BSD_PRINT_PREVIEW_PVT.bsd_pr_tbl_type;

7401: l_bcl_pr_tbl_out l_bcl_pr_tbl_type;
7402: SUBTYPE l_bsl_pr_tbl_type is OKS_BSL_PRINT_PREVIEW_PVT.bsl_pr_tbl_type;
7403: l_bsl_pr_tbl_in l_bsl_pr_tbl_type;
7404: l_bsl_pr_tbl_out l_bsl_pr_tbl_type;
7405: SUBTYPE l_bsd_pr_tbl_type is OKS_BSD_PRINT_PREVIEW_PVT.bsd_pr_tbl_type;
7406: l_bsd_pr_tbl_in l_bsd_pr_tbl_type;
7407: l_bsd_pr_tbl_out l_bsd_pr_tbl_type;
7408:
7409:

Line 7647: OKS_BSD_PRV_PUB.insert_bsd_pr

7643: l_bsd_pr_tbl_in(1).attribute15 := NULL;
7644: l_bsd_pr_tbl_in(1).security_group_id := NULL;
7645:
7646:
7647: OKS_BSD_PRV_PUB.insert_bsd_pr
7648: (
7649: P_API_VERSION => 1.0,
7650: P_INIT_MSG_LIST => 'T',
7651: X_RETURN_STATUS => l_ret_stat,