APPS.OKS_BILL_REC_PUB dependencies on OKS_BCL_PR

Line 7027: UPDATE oks_bcl_pr

7023: WHERE bsl_id = p_bsl_id;
7024:
7025: ELSIF (P_PRV = 2) THEN
7026:
7027: UPDATE oks_bcl_pr
7028: SET amount = nvl(amount,0) + round_amount,
7029: currency_code = l_cur_holder
7030: WHERE id = p_bcl_id;
7031:

Line 7072: SUBTYPE l_bcl_pr_tbl_type is OKS_BCL_PRINT_PREVIEW_PVT.bcl_pr_tbl_type;

7068: SUBTYPE l_bclv_tbl_type_in is OKS_bcl_PVT.bclv_tbl_type;
7069: l_bclv_tbl_in l_bclv_tbl_type_in;
7070: l_bclv_tbl_out l_bclv_tbl_type_in;
7071:
7072: SUBTYPE l_bcl_pr_tbl_type is OKS_BCL_PRINT_PREVIEW_PVT.bcl_pr_tbl_type;
7073: l_bcl_pr_tbl_in l_bcl_pr_tbl_type;
7074: l_bcl_pr_tbl_out l_bcl_pr_tbl_type;
7075:
7076: l_ret_stat Varchar2(20);

Line 7118: UPDATE oks_bcl_pr

7114: IF (p_sent_yn IS not Null) THEN
7115: l_bcl_pr_tbl_in(1).sent_yn := p_sent_yn;
7116: END If;
7117:
7118: UPDATE oks_bcl_pr
7119: SET amount = nvl(p_amount,0) + nvl(amount,0),
7120: bill_Action = nvl(p_bill_action,bill_action) ,
7121: currency_code = p_currency_code,
7122: sent_yn = nvl(p_sent_yn , sent_yn)

Line 7158: SUBTYPE l_bcl_pr_tbl_type is OKS_BCL_PRINT_PREVIEW_PVT.bcl_pr_tbl_type;

7154: SUBTYPE l_bclv_tbl_type_in is OKS_bcl_PVT.bclv_tbl_type;
7155: l_bclv_tbl_in l_bclv_tbl_type_in;
7156: l_bclv_tbl_out l_bclv_tbl_type_in;
7157:
7158: SUBTYPE l_bcl_pr_tbl_type is OKS_BCL_PRINT_PREVIEW_PVT.bcl_pr_tbl_type;
7159: l_bcl_pr_tbl_in l_bcl_pr_tbl_type;
7160: l_bcl_pr_tbl_out l_bcl_pr_tbl_type;
7161:
7162: l_ret_stat Varchar2(20);

Line 7181: From Oks_bcl_pr

7177: Order by Date_billed_from desc;
7178:
7179: Cursor l_bcl_pr_csr(p_cle_id_in Number,p_date_billed_from_in date,p_date_billed_to_in date) Is
7180: Select Id
7181: From Oks_bcl_pr
7182: Where Cle_id = p_cle_id_in
7183: And trunc(date_billed_from) = trunc(p_date_billed_from_in)
7184: And trunc(date_billed_to) = trunc(p_date_billed_to_in)
7185: And bill_action = p_bill_action

Line 7266: OKS_BCL_PRINT_PREVIEW_PUB.insert_bcl_pr(

7262: OPEN l_bcl_pr_csr(p_cle_id ,p_date_billed_from ,p_date_billed_to );
7263: FETCH l_bcl_pr_csr into l_bcl_id;
7264:
7265: IF (l_bcl_pr_csr%NOTFOUND) THEN
7266: OKS_BCL_PRINT_PREVIEW_PUB.insert_bcl_pr(
7267: P_API_VERSION => 1.0,
7268: P_INIT_MSG_LIST => 'T',
7269: X_RETURN_STATUS => l_ret_stat,
7270: X_MSG_COUNT => l_msg_cnt,

Line 7313: SUBTYPE l_bcl_pr_tbl_type is OKS_BCL_PRINT_PREVIEW_PVT.bcl_pr_tbl_type;

7309: SUBTYPE l_bclv_tbl_type_in is OKS_bcl_PVT.bclv_tbl_type;
7310: l_bclv_tbl_in l_bclv_tbl_type_in;
7311: l_bclv_tbl_out l_bclv_tbl_type_in;
7312:
7313: SUBTYPE l_bcl_pr_tbl_type is OKS_BCL_PRINT_PREVIEW_PVT.bcl_pr_tbl_type;
7314: l_bcl_pr_tbl_in l_bcl_pr_tbl_type;
7315: l_bcl_pr_tbl_out l_bcl_pr_tbl_type;
7316:
7317: l_ret_stat Varchar2(20);

Line 7333: From Oks_bcl_pr

7329: Order by Date_billed_from desc;
7330:
7331: Cursor l_bcl_pr_csr(p_cle_id_in Number,p_date_billed_from_in date,p_date_billed_to_in date) Is
7332: Select Id,amount
7333: From Oks_bcl_pr
7334: Where Cle_id = p_cle_id_in
7335: And trunc(date_billed_from) = trunc(p_date_billed_from_in)
7336: And trunc(date_billed_to) = trunc(p_date_billed_to_in)
7337: And bill_Action = p_bill_action

Line 7399: SUBTYPE l_bcl_pr_tbl_type is OKS_BCL_PRINT_PREVIEW_PVT.bcl_pr_tbl_type;

7395: l_bsdv_tbl_in l_bsdv_tbl_type_in;
7396: l_bsdv_tbl_out l_bsdv_tbl_type_in;
7397:
7398:
7399: SUBTYPE l_bcl_pr_tbl_type is OKS_BCL_PRINT_PREVIEW_PVT.bcl_pr_tbl_type;
7400: l_bcl_pr_tbl_in l_bcl_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;