ITPub博客

/*create or replace directory JACK as 'D:jack';*/DECLARE b_file BFILE; b_lob BLOB;BEGIN INSERT INTO a (a) VALUES (empty_blob()) RETURN a INTO b_lob; --为了使PL/SQL编译成功，必须先为该列插入一个empty_blob() 值，return a into b_lob将该列与一个blog类型的变量绑定在一起，以后只要为b_lob赋值，即等于将该值插入了表中。 b_file := bfilename('JACK', 'a.bmp'); --tmp是建立的文件所在的目录，filename.jpg是文件名;将文件转换为bfile类型 dbms_lob.OPEN(b_file, dbm

The instructions on this page are here for completeness, however there is an easier method to control forms recording and playback in Oracle E-Business Suite. Please ensure you have read all the steps on the Forms Playback Setup page before following the steps on this page. Only follow the setup instructions outlined below if you know what you are doing and have decided the Profile Option approach described on the Setup page is not appropriate for you.http://www.dataload.com/help/recplay/url.htm

BEGIN web_server_prefix := fnd_web_config.gfm_agent; mime_type := nvl(fnd_profile.VALUE('FND_EXPORT_MIME_TYPE'), 'text/tab-separated-values'); db_file := fnd_gfm.file_create(content_type => mime_type, program_name => 'export'); v_record_num := :system.cursor_record; go_block('PO_RULE'); first_record; LOOP EXIT WHEN system.last_query = TRUE; outstring := 输入你要的数据; fnd_gfm.file_wr

HI Follow these steps."PO:Secondary Email Address"1)Open Workflow Builder.2)Open the required workflow for which this attribute needs to be added3)Navigate to the message for which additional recipients have to be set.4)Right Click on this message and select new attribute5)Enter Internal Name as #WFM_CC (or #WFM_BCC). Enter any desired name as Display name6)Also keep Type as Text and Source as Send.7)Save the workflow.8)While Launching the workflow you enter list of the e-mail addresse

PROCEDURE Set_print_layout IS -- L_printer_name VARCHAR2(50); L_printer_bool BOOLEAN; L_output_format VARCHAR2(20); L_add_layout BOOLEAN; -- BEGIN L_printer_name := 'XXXX'; L_printer_bool := Fnd_request.Set_print_options(Printer => L_printer_name, Style => 'XXXX' Copies => 1, Save_

BEGINweb_server_prefix := fnd_web_config.gfm_agent;mime_type := nvl(fnd_profile.VALUE('FND_EXPORT_MIME_TYPE'),'text/tab-separated-values');db_file := fnd_gfm.file_create(content_type => mime_type,program_name => 'export');v_record_num := :system.cursor_record;go_block('PO_RULE');first_record;LOOPEXIT WHEN system.last_query = TRUE;outstring := 输入你要的数据;fnd_gfm.file_write_line(db_file,output_string);next_record;END LOOP;go_record(v_record_num);db_file := fnd_gfm.file_close(db_file);url

CREATE OR REPLACE PACKAGE oracle_cdh ISPROCEDURE create_party(p_party_id VARCHAR2,p_party_type VARCHAR2,p_party_name VARCHAR2,p_party_number VARCHAR2,p_person_pre_name_adjunct VARCHAR2,p_person_first_name VARCHAR2,p_person_middle_name VARCHAR2,p_person_last_name VARCHAR2,p_person_title VARCHAR2,p_created_by_module VARCHAR2,p_person_name_suffix VARCHAR2,p_person_academic_title VARCHAR2,p_person_previous_last_name VARCHAR2,p_known_as VARCHAR2,p_known_as2 VARCHAR2,p_tax_reference VARCHAR2,p_person_

Oracle Applications Interface ProgramsOrder Import Interface (Sales Order Conversion)Interface tables:· OE_HEADERS_IFACE_ALL · OE_LINES_IFACE_ALL · OE_ACTIONS_IFACE_ALL · OE_ORDER_SOURCES · OE_CUSTOMER_INFO_IFACE_ALL · OE_PRICE_ADJS_IFACE_ALL · OE_PRICE_ATTS_IFACE_ALLBase tables: · OE_ORDER_HEADERS_ALL · OE_ORDER_LINES_ALLPricing tables · QP_PRICING_ATTRIBUTESDuring import of orders, shipping tables are not populated.If importing customers together with the order, OE_ORDER_CUST_IFACE_A

比如有一个外围支持系统，用户需要在外围系统登录之后点个link就可以登录到Oracle ERP系统中，那么我们需要先把外围系统的用户创建在Oracle ERP中，并且分配职责给他。DECLAREa BOOLEAN;BEGIN---------------------------------------------------------------Change password-------------------------------------------------------------/*a := apps.fnd_user_pkg.changepassword('SIMON','oracle');IF NOT a THEN--RAISE_APPLICATION_ERROR(-20002, 'Password not updated');dbms_output.put_line('Password not updated');ELSEdbms_

WEB_SERVER_PREFIX := FND_WEB_CONFIG.GFM_AGENT; MIME_TYPE := NVL (FND_PROFILE.VALUE ('FND_EXPORT_MIME_TYPE'), 'text/tab-separated-values' ); DB_FILE := FND_GFM.FILE_CREATE (CONTENT_TYPE => MIME_TYPE, PROGRAM_NAME => 'export'); V_RECORD_NUM := :SYSTEM.CURSOR_RECORD; GO_BLOCK ('PO_RULE'); FIRST_RECORD LOOP EXIT WHEN SYSTEM.LAST_QUERY = TRUE ; OUTSTRING := 输入你要的数据 FND_GFM.FILE_WRITE_LINE (DB_FILE, OUTPUT_STRING); NEXT_RECORD; END LOOP; GO_RECORD (V_RECORD_NUM); DB_FILE := FND_GFM.FILE_C

一、模板制作：YSFOLDER.FMB打开TEMPLATE.FMB，如果打开的是APPSTAND.FMB，以下步骤省略：1、FORM级触发器：1、 在WHEN-NEW-FORM-INSTANCE后面添加以下代码：--定义文件夹数据块app_folder.define_folder_block( object_name => ' DETAILBLOCK _FOLDER' ,folder_block_name => 'DETAILBLOCK',prompt_block_name => 'DETAILBLOCK_PROMPT',folder_canvas_name => 'DETAILBLOCK_STACKED',folder_window_name => 'BLOCKNAME',disabled_functions => '');--以上参数均为VARCHAR2,长度不得超过20个字符2、 增加FORM级触发器：

DECLARE c utl_smtp.connection; PROCEDURE send_header(name IN VARCHAR2, header IN VARCHAR2) AS BEGIN utl_smtp.write_data(c, name || ': ' || header || utl_tcp.CRLF); END; BEGIN-- << 用你的SMTP服务器地址替换 'smtp.xxx.com'c := utl_smtp.open_connection('smtp.xxx.com');-- << 用你的用户名替换user1, 密码替换pass-- << 用你的SMTP服务器地址替换 'smtp.xxx.com' utl_smtp.helo(c, 'smtp.xxx.com');utl_smtp.command(c, 'AUTH LOGIN');utl_smtp.command(c, utl_raw.cast_to_varchar2(utl_encode.base64_

GL_interface要使“日记帐导入”成功地将导入数据转换为日记帐分录，您必须在要求输入值的所有 GL_INTERFACE 表列（包括所有非空列）中输入值。 请在 GL_INTERFACE 表的以下要求列中输入值：状态：输入 NEW 值，以指明您要将新数据导入总帐应用产品。 SET_OF_BOOKS_ID：输入事务处理的相应帐套标识。您可以在总帐应用产品的“帐套”表单中定义帐套。“帐套”表的 SET_OF_BOOKS_ID 列 (GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID) 中提供了有效值列表。 ERP博客群落 Blog.Erp100.CoM /MM'T5i#s7^ L4R7~建议：您可以使用以下 SQL*Statement 来访问相

http://www.xxx.comort/discwb4/html/english/netscape/start_nn.htm[@more@]