APPS.OKS_BILL_REC_PUB dependencies on OKS_BCL_PR

Line 6995: UPDATE oks_bcl_pr

6991: WHERE bsl_id = p_bsl_id;
6992:
6993: ELSIF (P_PRV = 2) THEN
6994:
6995: UPDATE oks_bcl_pr
6996: SET amount = nvl(amount,0) + round_amount,
6997: currency_code = l_cur_holder
6998: WHERE id = p_bcl_id;
6999:

Line 7040: SUBTYPE l_bcl_pr_tbl_type is OKS_BCL_PRINT_PREVIEW_PVT.bcl_pr_tbl_type;

7036: SUBTYPE l_bclv_tbl_type_in is OKS_bcl_PVT.bclv_tbl_type;
7037: l_bclv_tbl_in l_bclv_tbl_type_in;
7038: l_bclv_tbl_out l_bclv_tbl_type_in;
7039:
7040: SUBTYPE l_bcl_pr_tbl_type is OKS_BCL_PRINT_PREVIEW_PVT.bcl_pr_tbl_type;
7041: l_bcl_pr_tbl_in l_bcl_pr_tbl_type;
7042: l_bcl_pr_tbl_out l_bcl_pr_tbl_type;
7043:
7044: l_ret_stat Varchar2(20);

Line 7086: UPDATE oks_bcl_pr

7082: IF (p_sent_yn IS not Null) THEN
7083: l_bcl_pr_tbl_in(1).sent_yn := p_sent_yn;
7084: END If;
7085:
7086: UPDATE oks_bcl_pr
7087: SET amount = nvl(p_amount,0) + nvl(amount,0),
7088: bill_Action = nvl(p_bill_action,bill_action) ,
7089: currency_code = p_currency_code,
7090: sent_yn = nvl(p_sent_yn , sent_yn)

Line 7126: SUBTYPE l_bcl_pr_tbl_type is OKS_BCL_PRINT_PREVIEW_PVT.bcl_pr_tbl_type;

7122: SUBTYPE l_bclv_tbl_type_in is OKS_bcl_PVT.bclv_tbl_type;
7123: l_bclv_tbl_in l_bclv_tbl_type_in;
7124: l_bclv_tbl_out l_bclv_tbl_type_in;
7125:
7126: SUBTYPE l_bcl_pr_tbl_type is OKS_BCL_PRINT_PREVIEW_PVT.bcl_pr_tbl_type;
7127: l_bcl_pr_tbl_in l_bcl_pr_tbl_type;
7128: l_bcl_pr_tbl_out l_bcl_pr_tbl_type;
7129:
7130: l_ret_stat Varchar2(20);

Line 7149: From Oks_bcl_pr

7145: Order by Date_billed_from desc;
7146:
7147: Cursor l_bcl_pr_csr(p_cle_id_in Number,p_date_billed_from_in date,p_date_billed_to_in date) Is
7148: Select Id
7149: From Oks_bcl_pr
7150: Where Cle_id = p_cle_id_in
7151: And trunc(date_billed_from) = trunc(p_date_billed_from_in)
7152: And trunc(date_billed_to) = trunc(p_date_billed_to_in)
7153: And bill_action = p_bill_action

Line 7234: OKS_BCL_PRINT_PREVIEW_PUB.insert_bcl_pr(

7230: OPEN l_bcl_pr_csr(p_cle_id ,p_date_billed_from ,p_date_billed_to );
7231: FETCH l_bcl_pr_csr into l_bcl_id;
7232:
7233: IF (l_bcl_pr_csr%NOTFOUND) THEN
7234: OKS_BCL_PRINT_PREVIEW_PUB.insert_bcl_pr(
7235: P_API_VERSION => 1.0,
7236: P_INIT_MSG_LIST => 'T',
7237: X_RETURN_STATUS => l_ret_stat,
7238: X_MSG_COUNT => l_msg_cnt,

Line 7281: SUBTYPE l_bcl_pr_tbl_type is OKS_BCL_PRINT_PREVIEW_PVT.bcl_pr_tbl_type;

7277: SUBTYPE l_bclv_tbl_type_in is OKS_bcl_PVT.bclv_tbl_type;
7278: l_bclv_tbl_in l_bclv_tbl_type_in;
7279: l_bclv_tbl_out l_bclv_tbl_type_in;
7280:
7281: SUBTYPE l_bcl_pr_tbl_type is OKS_BCL_PRINT_PREVIEW_PVT.bcl_pr_tbl_type;
7282: l_bcl_pr_tbl_in l_bcl_pr_tbl_type;
7283: l_bcl_pr_tbl_out l_bcl_pr_tbl_type;
7284:
7285: l_ret_stat Varchar2(20);

Line 7301: From Oks_bcl_pr

7297: Order by Date_billed_from desc;
7298:
7299: Cursor l_bcl_pr_csr(p_cle_id_in Number,p_date_billed_from_in date,p_date_billed_to_in date) Is
7300: Select Id,amount
7301: From Oks_bcl_pr
7302: Where Cle_id = p_cle_id_in
7303: And trunc(date_billed_from) = trunc(p_date_billed_from_in)
7304: And trunc(date_billed_to) = trunc(p_date_billed_to_in)
7305: And bill_Action = p_bill_action

Line 7367: SUBTYPE l_bcl_pr_tbl_type is OKS_BCL_PRINT_PREVIEW_PVT.bcl_pr_tbl_type;

7363: l_bsdv_tbl_in l_bsdv_tbl_type_in;
7364: l_bsdv_tbl_out l_bsdv_tbl_type_in;
7365:
7366:
7367: SUBTYPE l_bcl_pr_tbl_type is OKS_BCL_PRINT_PREVIEW_PVT.bcl_pr_tbl_type;
7368: l_bcl_pr_tbl_in l_bcl_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;