eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_CREDIT_TYPES_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_CREDIT_TYPE_ID in NUMBER,
  X_ORG_ID in NUMBER,
  X_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_MONETARY_FLAG in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_CREATED_BY in NUMBER,
  X_CREATION_DATE in DATE,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_PRECISION in NUMBER,
  X_EXTENDED_PRECISION in NUMBER
) is
  cursor C is select ROWID from CN_CREDIT_TYPES_ALL_B
    where CREDIT_TYPE_ID = X_CREDIT_TYPE_ID
    ;

Line: 39


  insert into CN_CREDIT_TYPES_ALL_B (
    CREDIT_TYPE_ID,
    ORG_ID,
    DESCRIPTION,
    MONETARY_FLAG,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATE_LOGIN,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    PRECISION,
    EXTENDED_PRECISION
  ) VALUES(
    X_CREDIT_TYPE_ID,
    X_ORG_ID,
    X_DESCRIPTION,
    X_MONETARY_FLAG,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATE_LOGIN,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_PRECISION,
    X_EXTENDED_PRECISION
);

Line: 97


  insert into CN_CREDIT_TYPES_ALL_TL (
    CREDIT_TYPE_ID,
    ORG_ID,
    NAME,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    CREATION_DATE,
    CREATED_BY,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_CREDIT_TYPE_ID,
    X_ORG_ID,
    X_NAME,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_CREATION_DATE,
    X_CREATED_BY,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from CN_CREDIT_TYPES_ALL_TL T
    where T.CREDIT_TYPE_ID = X_CREDIT_TYPE_ID
    and T.LANGUAGE = L.language_code AND
        T.ORG_ID = X_ORG_ID
     );

Line: 137


end INSERT_ROW;

Line: 163


  cursor c is select
      DESCRIPTION,
      MONETARY_FLAG,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      PRECISION,
      EXTENDED_PRECISION
    from CN_CREDIT_TYPES_ALL_B
    where CREDIT_TYPE_ID = X_CREDIT_TYPE_ID AND
     NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
    for update of CREDIT_TYPE_ID nowait;

Line: 190


  cursor c1 is select
      NAME,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from CN_CREDIT_TYPES_ALL_TL
    where CREDIT_TYPE_ID = X_CREDIT_TYPE_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG) AND
     NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
    for update of CREDIT_TYPE_ID nowait;

Line: 205


    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 270


procedure UPDATE_ROW (
  X_CREDIT_TYPE_ID in NUMBER,
  X_ORG_ID in NUMBER,
  X_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_MONETARY_FLAG in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_PRECISION in NUMBER,
  X_EXTENDED_PRECISION in NUMBER
) is
begin
  update CN_CREDIT_TYPES_ALL_B set
    DESCRIPTION = X_DESCRIPTION,
    MONETARY_FLAG = X_MONETARY_FLAG,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    PRECISION = X_PRECISION,
    EXTENDED_PRECISION = X_EXTENDED_PRECISION,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where CREDIT_TYPE_ID = X_CREDIT_TYPE_ID AND
        ORG_ID = X_ORG_ID;

Line: 330


  update CN_CREDIT_TYPES_ALL_TL set
    NAME = X_NAME,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where CREDIT_TYPE_ID = X_CREDIT_TYPE_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG) AND
             ORG_ID = X_ORG_ID;

Line: 344


end UPDATE_ROW;

Line: 346


procedure DELETE_ROW (
  X_CREDIT_TYPE_ID in NUMBER,
  X_ORG_ID in NUMBER
) is
begin
  delete from CN_CREDIT_TYPES_ALL_TL
  where CREDIT_TYPE_ID = X_CREDIT_TYPE_ID AND
        ORG_ID = X_ORG_ID;

Line: 359


  delete from CN_CREDIT_TYPES_ALL_B
  where CREDIT_TYPE_ID = X_CREDIT_TYPE_ID AND
        ORG_ID = X_ORG_ID;

Line: 367


end DELETE_ROW;

Line: 372


  delete from CN_CREDIT_TYPES_ALL_TL T
  where not exists
    (select NULL
    from CN_CREDIT_TYPES_ALL_B B
     where B.CREDIT_TYPE_ID = T.credit_type_id
    and   B.org_id = T.org_id
    );

Line: 380


  update CN_CREDIT_TYPES_ALL_TL T set (
      NAME
    ) = (select
      B.NAME
    from CN_CREDIT_TYPES_ALL_TL B
    where B.CREDIT_TYPE_ID = T.CREDIT_TYPE_ID
    and B.LANGUAGE = T.source_lang
    and   B.org_id = T.org_id)
  where (
      T.CREDIT_TYPE_ID,
      T.LANGUAGE
  ) in (select
      SUBT.CREDIT_TYPE_ID,
      SUBT.LANGUAGE
    from CN_CREDIT_TYPES_ALL_TL SUBB, CN_CREDIT_TYPES_ALL_TL SUBT
    where SUBB.CREDIT_TYPE_ID = SUBT.CREDIT_TYPE_ID
    and SUBB.LANGUAGE = SUBT.source_lang
    and   SUBB.org_id = SUBT.org_id
    and (SUBB.NAME <> SUBT.name
      or (SUBB.NAME is null and SUBT.NAME is not null)
      or (SUBB.NAME is not null and SUBT.NAME is null)
  ));

Line: 403


  insert into CN_CREDIT_TYPES_ALL_TL (
    ORG_ID,
    CREDIT_TYPE_ID,
    NAME,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    CREATION_DATE,
    CREATED_BY,
    LANGUAGE,
    SOURCE_LANG
  ) SELECT
    b.org_id,
    B.CREDIT_TYPE_ID,
    B.NAME,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.CREATION_DATE,
    B.CREATED_BY,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from CN_CREDIT_TYPES_ALL_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from CN_CREDIT_TYPES_ALL_TL T
    where T.CREDIT_TYPE_ID = B.CREDIT_TYPE_ID
     and T.LANGUAGE = L.language_code
    and   T.org_id = B.org_id);

Line: 482


   UPDATE  cn_credit_types_all_b SET
     DESCRIPTION = X_DESCRIPTION,
     MONETARY_FLAG = X_MONETARY_FLAG,
     ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
     ATTRIBUTE1 = X_ATTRIBUTE1,
     ATTRIBUTE2 = X_ATTRIBUTE2,
     ATTRIBUTE3 = X_ATTRIBUTE3,
     ATTRIBUTE4 = X_ATTRIBUTE4,
     ATTRIBUTE5 = X_ATTRIBUTE5,
     ATTRIBUTE6 = X_ATTRIBUTE6,
     ATTRIBUTE7 = X_ATTRIBUTE7,
     ATTRIBUTE8 = X_ATTRIBUTE8,
     ATTRIBUTE9 = X_ATTRIBUTE9,
     ATTRIBUTE10 = X_ATTRIBUTE10,
     ATTRIBUTE11 = X_ATTRIBUTE11,
     ATTRIBUTE12 = X_ATTRIBUTE12,
     ATTRIBUTE13 = X_ATTRIBUTE13,
     ATTRIBUTE14 = X_ATTRIBUTE14,
     ATTRIBUTE15 = X_ATTRIBUTE15,
     PRECISION = X_PRECISION,
     EXTENDED_PRECISION = X_EXTENDED_PRECISION,
     last_update_date = sysdate,
     last_updated_by = user_id,
     last_update_login = 0
     WHERE credit_type_id = x_credit_type_id;

Line: 510


      INSERT INTO cn_credit_types_all_b
	(
         CREDIT_TYPE_ID,
         ORG_ID,
         DESCRIPTION,
         MONETARY_FLAG,
         ATTRIBUTE_CATEGORY,
         ATTRIBUTE1,
         ATTRIBUTE2,
         ATTRIBUTE3,
         ATTRIBUTE4,
         ATTRIBUTE5,
         ATTRIBUTE6,
         ATTRIBUTE7,
         ATTRIBUTE8,
         ATTRIBUTE9,
         ATTRIBUTE10,
         ATTRIBUTE11,
         ATTRIBUTE12,
         ATTRIBUTE13,
         ATTRIBUTE14,
         ATTRIBUTE15,
         PRECISION,
         EXTENDED_PRECISION,
	 creation_date,
	 created_by,
	 last_update_date,
	 last_updated_by,
	 last_update_login
	 ) VALUES
	(X_CREDIT_TYPE_ID,
	     X_ORG_ID,
         X_DESCRIPTION,
         X_MONETARY_FLAG,
         X_ATTRIBUTE_CATEGORY,
         X_ATTRIBUTE1,
         X_ATTRIBUTE2,
         X_ATTRIBUTE3,
         X_ATTRIBUTE4,
         X_ATTRIBUTE5,
         X_ATTRIBUTE6,
         X_ATTRIBUTE7,
         X_ATTRIBUTE8,
         X_ATTRIBUTE9,
         X_ATTRIBUTE10,
         X_ATTRIBUTE11,
         X_ATTRIBUTE12,
         X_ATTRIBUTE13,
         X_ATTRIBUTE14,
         X_ATTRIBUTE15,
         X_PRECISION,
         X_EXTENDED_PRECISION,
	 sysdate,
	 user_id,
	 sysdate,
	 user_id,
	 0
	 );

Line: 570


   UPDATE cn_credit_types_all_tl SET
     name = x_name,
     last_update_date = sysdate,
     last_updated_by = user_id,
     last_update_login = 0,
     source_lang = userenv('LANG')
     WHERE credit_type_id = x_credit_type_id
     AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 581


      INSERT INTO cn_credit_types_all_tl
	(credit_type_id,
	 org_id,
	 name,
	 creation_date,
	 created_by,
	 last_update_date,
	 last_updated_by,
	 last_update_login,
	 language,
	 source_lang)
	SELECT
	x_credit_type_id,
	x_org_id,
	x_name,
	sysdate,
	user_id,
	sysdate,
	user_id,
	0,
	l.language_code,
	userenv('LANG')
	FROM fnd_languages l
	WHERE l.installed_flag IN ('I', 'B')
	AND NOT EXISTS
	(SELECT NULL
	 FROM cn_credit_types_all_tl t
	 WHERE t.credit_type_id = x_credit_type_id
	 AND t.language = l.language_code
     AND org_id = x_org_id);

Line: 638


   UPDATE cn_credit_types_all_tl SET
     name = x_name,
     last_update_date = sysdate,
     last_updated_by = user_id,
     last_update_login = 0,
     source_lang = userenv('LANG')
     WHERE credit_type_id = x_credit_type_id
     AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);