《html报表生成过程说明》由会员分享，可在线阅读，更多相关《html报表生成过程说明（18页珍藏版）》请在金锄头文库上搜索。
1、1HTML 报表生成过程说明【第一部分：PL/SQL 报表模板源码】CREATE OR REPLACE package CUX_HP_WJ_HTML_PKG is/*=* Copyright (C) SIE Consulting Co., Ltd All rights reserved * =* Program Name: CUX_SIE_TRAIN_HTML_WGL_PKG* Author : WANGJUNchinasie.con * Date : 2011-03-27* Purpose : SIE 培训 HTML 报表演示* * Update History* Version Date
2、Name Description* - - - -* V1.0 2011-03-27 WANGJUNchinasie.con Creation *=*/*=* Program Name: cux_inv_onhand_p* Author : wanggongliangchinasie.con * Date : 2011-03-27* Purpose : SIE 培训 HTML 报表演示* Parameters :* In p_organzation_id 库存组织 ID * In p_item 物料编码* In p_inv_code 仓库库别* Out errbuf ORACLE 标准需要*
3、Out retcode ORACLE 标准需要* * Update History* Version Date Name Description* - - - -* V1.0 2011-03-27 WANGJUNchinasie.con Creation Creation *=*/procedure cux_inv_onhand_p(errbuf out varchar2,retcode out varchar2, p_organzation_id number,p_item varchar2,p_inv_code varchar2);end CUX_HP_WJ_HTML_PKG;2/CREA
4、TE OR REPLACE package body CUX_HP_WJ_HTML_PKG is/*=* Copyright (C) SIE Consulting Co., Ltd All rights reserved * =* Program Name: CUX_SIE_TRAIN_HTML_WGL_PKG* Author : WANGJUNchinasie.con * Date : 2011-03-27* Purpose : SIE 培训 HTML 报表演示* * Update History* Version Date Name Description* - - - -* V1.0 2
5、011-03-27 WANGJUNchinasie.con Creation *=*/*=* Program Name: cux_inv_onhand_p* Author : wanggongliangchinasie.con * Date : 2011-03-27* Purpose : SIE 培训 HTML 报表演示* Parameters :* In p_organzation_id 库存组织 ID * In p_item 物料编码* In p_inv_code 仓库库别* Out errbuf ORACLE 标准需要* Out retcode ORACLE 标准需要* * Update
6、 History* Version Date Name Description* - - - -* V1.0 2011-03-27 WANGJUNchinasie.con Creation Creation *=*/procedure cux_inv_onhand_p(errbuf out varchar2,retcode out varchar2, p_organzation_id number,p_item varchar2,p_inv_code varchar2)is3cursor c_onhand_qtyisselect msi.organization_id,msi.segment1
7、,msi.description,sum(moq.transaction_quantity) onhand_qty,moq.subinventory_codefrom mtl_onhand_quantities_detail moq, mtl_system_items_b msiwhere moq.organization_id = msi.organization_id- and moq.inventory_item_id = nvl(msi.inventory_item_id,moq.inventory_item_id)and msi.organization_id = nvl(p_org
8、anzation_id,msi.organization_id)and msi.segment1 = nvl(p_item,msi.segment1)and moq.subinventory_code = nvl(p_inv_code,moq.subinventory_code)group by msi.organization_id, msi.segment1,msi.description, moq.subinventory_code;v_sep varchar2(20);v_line_str varchar2(3000);v_bkg_color varchar2(3000);beginH
9、TML_REPORT_WGL_PKG.v_report_output_mode := F;v_sep := ;- 定义报表和网页名称HTML_REPORT_WGL_PKG.html_title(p_program_title = 库存现有量报表,p_report_title = 库存现有量报表);- 定义报表的列名HTML_REPORT_WGL_PKG.output_line(p_output_str = );-报表的列表v_line_str := 库存组织 ID,物料编码,物料描述 ,库别,库存现有量,;HTML_REPORT_WGL_PKG.line_title(p_title_strin
10、g = v_line_str,p_with_other_attr = Y,p_attr_delimiter = *);-输出报表内容 for r_onhand in c_onhand_qty loop/*v_bkg_color := * bgcolor=rgb(200,200,200);*/-报表内容项目的值与 HTML 语言格式进行关联v_line_str := r_onhand.organization_id | v_bkg_color | v_sep |r_onhand.segment1 | v_bkg_color | v_sep |4r_onhand.description | v_bkg_color | v_sep |r_onhand.subinventory_code | v_bkg_color | v_sep |r_onhand.onhand_qty| v_bkg_color | v_sep;HTML_REPORT_WGL_PKG.line_title(p_title_string = v_line_str,p_delimiter = v_sep,p_with_other_attr = Y,p_attr_delimiter = *);end loop;
