[Home] [Help]
4359: start_reading, end_reading,ccr_id,cgr_id,
4360: attribute_category,attribute1,attribute2,attribute3,attribute4 ,
4361: attribute5,attribute6,attribute7,attribute8,attribute9,
4362: attribute10,attribute11,attribute12,attribute13,attribute14,attribute15
4363: FROM oks_bill_sub_line_dtls
4364: WHERE bsl_id = p_bsl_id;
4365:
4366: CURSOR l_btl_csr(p_bcl_id NUMBER, p_old_bsl_id number) IS
4367: SELECT id ,btn_id, bsl_id,bcl_id,
4538: RAISE G_EXCEPTION_HALT_VALIDATION;
4539: END IF;
4540:
4541: -------update old bsd amount
4542: UPDATE oks_bill_sub_line_dtls
4543: set amount = nvl(amount,0) - p_new_cp_lvl_tbl(l_index).amount
4544: where id = l_bsd_rec.id;
4545:
4546: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN