Oracle Seeker, Oracle探索者

#
# $Header: afcpprog.lct 120.2.12010000.2 2008/11/21 14:26:27 jvalenti ship $
#
# .lct -  Loader Configuration
#
# Entities -
#
#   PROGRAM 
#     INCOMPATABILITY
#
#  VALUE_SET (non-MLS)                     -- Value sets
#   |                                         - FND_FLEX_VALUE_SETS
#   +--VSET_SECURITY_RULE (MLS)            -- Value Security Rules
#   |   |                                     - FND_FLEX_VALUE_RULES
#   |   |                                     - FND_FLEX_VALUE_RULES_TL
#   |   +--VSET_SECURITY_LINE (no-TL)      -- Value Security Rule Lines
#   |   |                                     - FND_FLEX_VALUE_RULE_LINES
#   |   +--VSET_SECURITY_USAGE (no-TL)     -- Security Rule Assignments to
# ....
#
# ----------END FLEX----------
#
# -- DEFINE SECTION --
#
#
# ==================================================
# Executable
# ==================================================
DEFINE EXECUTABLE
  KEY   EXECUTABLE_NAME         VARCHAR2(30)
  KEY   APPLICATION_SHORT_NAME  VARCHAR2(50)
  CTX   OWNER                   VARCHAR2(4000)
  BASE  LAST_UPDATE_DATE	VARCHAR2(75)
  BASE  EXECUTION_METHOD_CODE   VARCHAR2(1)
  BASE  EXECUTION_FILE_NAME     VARCHAR2(61)
  BASE  SUBROUTINE_NAME         VARCHAR2(30)
  BASE  EXECUTION_FILE_PATH     VARCHAR2(510)
  TRANS USER_EXECUTABLE_NAME    VARCHAR2(240)
  TRANS DESCRIPTION             VARCHAR2(240)
END EXECUTABLE
 
DEFINE PROGRAM 
  KEY   CONCURRENT_PROGRAM_NAME      VARCHAR2(30)
  KEY   APPLICATION_SHORT_NAME	     VARCHAR2(50)
  CTX   OWNER                        VARCHAR2(4000)
  BASE  LAST_UPDATE_DATE	     VARCHAR2(75)
  TRANS USER_CONCURRENT_PROGRAM_NAME VARCHAR2(240)
  BASE  EXEC			     REFERENCES EXECUTABLE 
 
......
 
END PROGRAM 
 
#
# -- DOWNLOAD SECTION --
#
#   For each entity, specify the SQL statement to use to flesh out
#   its entity definition.  SELECT columns must be in same order and
#   datatype as the entity's attributes as defined above.
#
 
# PROGRAM 
 
DOWNLOAD PROGRAM
 "select v.CONCURRENT_PROGRAM_NAME,
  a.APPLICATION_SHORT_NAME,
  fnd_load_util.OWNER_NAME(v.LAST_UPDATED_BY) OWNER,
  to_char(v.LAST_UPDATE_DATE, 'YYYY/MM/DD') LAST_UPDATE_DATE,
  v.USER_CONCURRENT_PROGRAM_NAME,
  ....
 
  from   fnd_concurrent_programs_vl v,
         fnd_executables me,
         fnd_security_groups s,
         fnd_application mea,
         fnd_concurrent_request_class c,
         fnd_application ca,
         fnd_executables e,
         fnd_application ea,
         fnd_application a
          where ((:CONCURRENT_PROGRAM_NAME is null) or
                 ((:CONCURRENT_PROGRAM_NAME is not null) and
                  (v.CONCURRENT_PROGRAM_NAME like :CONCURRENT_PROGRAM_NAME)))
   and          ((:APPLICATION_SHORT_NAME is null) or
                 ((:APPLICATION_SHORT_NAME is not null) and
                  (a.APPLICATION_SHORT_NAME like :APPLICATION_SHORT_NAME)))
......
    "
 
UPLOAD PROGRAM 
  BEGIN
  "begin  
      if (:UPLOAD_MODE = 'NLS') then
	fnd_concurrent_programs_pkg.TRANSLATE_ROW (
	  :CONCURRENT_PROGRAM_NAME,
	  :APPLICATION_SHORT_NAME,
	  :OWNER,
	  :USER_CONCURRENT_PROGRAM_NAME,
	  :DESCRIPTION,	
	  :CUSTOM_MODE,
	  :LAST_UPDATE_DATE);
      else
        fnd_concurrent_programs_pkg.LOAD_ROW (
	  :CONCURRENT_PROGRAM_NAME,
	  :APPLICATION_SHORT_NAME,
	  :OWNER,
	  :USER_CONCURRENT_PROGRAM_NAME,
	  :EXEC_EXECUTABLE_NAME,
	  :EXEC_APPLICATION_SHORT_NAME, 
	  ......	  
	  );
 
      end if;
    end;"

--中文
NLS_LANG= "AMERICAN_AMERICA.AL32UTF8"
export NLS_LANG
 
--英文
NLS_LANG= "SIMPLIFIED CHINESE_CHINA.AL32UTF8"
export NLS_LANG

SELECT '"' || nls_language || '_' || nls_territory || '.' || VALUE || '"'  nls_lang
  FROM fnd_languages, v$nls_parameters
 WHERE language_code IN ('US', 'ZHS')
   AND parameter = 'NLS_CHARACTERSET';