2012年07月_QQ51567242

转载 UTL_MAIL.SEND

CREATE OR REPLACE PACKAGE MEW_A1_AUTO_RECEIVING_PKG IS PROCEDURE MAIN(RETCODE OUT NUMBER ,ERRBUF OUT VARCHAR ,P_CONTROL_ID NUMBER ,P_FI

2012-07-24 16:27:48 1603

转载 GL科目余额获取脚本

CREATE OR REPLACE PACKAGE BODY MEW_GET_GL_BALANCE_PKG IS FUNCTION MEW_GET_BEGIN_BALANCE_F(P_CONCATENATED_SEGMENTS IN VARCHAR2 ,P_CURRENCY_CODE IN VARCHAR2

2012-07-24 16:25:31 1177

转载请求菜单功能职责常用脚本

--如何根据职责名称找到当前职责对应的菜单SELECT MENU_NAME ,USER_MENU_NAME ,TYPE ,DESCRIPTION FROM FND_MENUS_VL WHERE MENU_ID IN (SELECT MENU_ID FROM FND_RESPONSIBILITY_VL

2012-07-24 14:46:44 648

转载 FORM中ON-INSERT ON-UPDATE ON-DELETE ON-LOCK代码生成程序

2012-07-24 14:38:14 1241

转载 HTML报表例子

CREATE OR REPLACE PACKAGE MEW_PO_PRICE_COMPARE_PKG IS PROCEDURE MAIN(RETCODE OUT NUMBER ,ERRBUF OUT VARCHAR2 ,P_ORGANIZATION_ID VARCHAR2

2012-07-24 13:52:41 1414

转载 HTML报表通用模版

create or replace package HTML_REPORT_PKG is--------------------------------------------------------------------- 生成HTML格式报表的程序包 --- 张

2012-07-24 13:52:08 10544

转载 Transaction Quantity to Primary Quantity

--Convert the transaction quantity to Primary UOM's quantityDECLARE L_PRIMARY_QTY NUMBER;BEGIN PO_UOM_S.UOM_CONVERT(100 --Transaction Quantity ,'PC' --Transaction Uom

2012-07-24 12:53:46 1132

转载采购接收检验入库接口处理例子

--PO接收DECLARE --待接收采购订单 CURSOR C1 IS SELECT PHA.VENDOR_ID ,PHA.VENDOR_SITE_ID ,PHA.CURRENCY_CODE ,PHA.RATE_TYPE ,PLA.ITEM_ID ,PLA.UN

2012-07-23 08:58:08 2973

转载子库转移杂项出入库脚本

--Subinventory Transfer BEGIN SELECT OP.ACCT_PERIOD_ID INTO V_ACCT_PERIOD_ID FROM ORG_ACCT_PERIODS OP WHERE OP.ORGANIZATION_ID = :PARAMETER.ORG_ID AND SYSDATE BETWE

2012-07-22 16:29:28 1962

转载会计期间脚本

--库存会计期SELECT STATUS ,PERIOD_NAME ,PERIOD_NUMBER ,PERIOD_YEAR ,START_DATE ,END_DATE ,CLOSE_DATE ,REC_TYPE ,ORGANIZATION_ID ,ACCT_PERIOD

2012-07-16 17:40:30 605

储藏室