-
编辑 删除
Set_print_layout
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_
-
编辑 删除
FORM Export
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
-
编辑 删除
Customer API
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_
