APPS.PER_QUALIFICATION_TYPES_PKG SQL Statements

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

Line: 8

  X_LAST_UPDATE_DATE out nocopy DATE,
  X_LAST_UPDATED_BY out nocopy NUMBER,
  X_LAST_UPDATE_LOGIN out nocopy NUMBER
) is
begin
  if X_OWNER = 'SEED' then
    X_CREATED_BY := 1;

Line: 15

    X_LAST_UPDATED_BY := 1;

Line: 18

    X_LAST_UPDATED_BY := 0;

Line: 21

  X_LAST_UPDATE_DATE := sysdate;

Line: 22

  X_LAST_UPDATE_LOGIN := 0;

Line: 30

   	select QUALIFICATION_TYPE_ID
   	from per_qualification_types
   	where name = X_NAME;

Line: 34

   	select per_qualification_types_s.nextval
   	from dual;

Line: 47

procedure insert_row(
	X_ROWID in out nocopy VARCHAR2,
	X_QUALIFICATION_TYPE_ID IN NUMBER,
	X_NAME	IN VARCHAR2,
	X_CATEGORY IN VARCHAR2,
	X_RANK in number,
	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_ATTRIBUTE16  IN VARCHAR2,
	X_ATTRIBUTE17  IN VARCHAR2,
	X_ATTRIBUTE18  IN VARCHAR2,
	X_ATTRIBUTE19  IN VARCHAR2,
	X_ATTRIBUTE20  IN VARCHAR2,
	X_INFORMATION1  IN VARCHAR2,
	X_INFORMATION2  IN VARCHAR2,
	X_INFORMATION3  IN VARCHAR2,
	X_INFORMATION4  IN VARCHAR2,
	X_INFORMATION5  IN VARCHAR2,
	X_INFORMATION6  IN VARCHAR2,
	X_INFORMATION7  IN VARCHAR2,
	X_INFORMATION8  IN VARCHAR2,
	X_INFORMATION9  IN VARCHAR2,
	X_INFORMATION10  IN VARCHAR2,
	X_INFORMATION11  IN VARCHAR2,
	X_INFORMATION12  IN VARCHAR2,
	X_INFORMATION13  IN VARCHAR2,
	X_INFORMATION14  IN VARCHAR2,
	X_INFORMATION15  IN VARCHAR2,
	X_INFORMATION16  IN VARCHAR2,
	X_INFORMATION17  IN VARCHAR2,
	X_INFORMATION18  IN VARCHAR2,
	X_INFORMATION19  IN VARCHAR2,
	X_INFORMATION20  IN VARCHAR2,
	X_INFORMATION21  IN VARCHAR2,
	X_INFORMATION22  IN VARCHAR2,
	X_INFORMATION23  IN VARCHAR2,
	X_INFORMATION24  IN VARCHAR2,
	X_INFORMATION25  IN VARCHAR2,
	X_INFORMATION26  IN VARCHAR2,
	X_INFORMATION27  IN VARCHAR2,
	X_INFORMATION28  IN VARCHAR2,
	X_INFORMATION29  IN VARCHAR2,
	X_INFORMATION30  IN VARCHAR2,
	X_INFORMATION_CATEGORY  IN VARCHAR2,
	X_QUAL_FRAMEWORK_ID in number,
	X_QUALIFICATION_TYPE in varchar2,
	X_CREDIT_TYPE in varchar2,
	X_CREDITS in number,
	X_LEVEL_TYPE in varchar2,
	X_LEVEL_NUMBER in varchar2,
	X_FIELD   IN VARCHAR2,
	X_SUB_FIELD  IN VARCHAR2,
	X_PROVIDER  IN VARCHAR2,
        X_QA_ORGANIZATION IN VARCHAR2,
        X_OBJECT_VERSION_NUMBER IN VARCHAR2,
	X_USER_NAME IN VARCHAR2,
	X_CREATION_DATE in DATE,
	X_CREATED_BY in NUMBER,
	X_LAST_UPDATE_DATE in DATE,
	X_LAST_UPDATED_BY in NUMBER,
        X_LAST_UPDATE_LOGIN in NUMBER
	) is

Cursor C is
	select rowid
	from PER_QUALIFICATION_TYPES
	where QUALIFICATION_TYPE_ID = X_QUALIFICATION_TYPE_ID;

Line: 132

insert into PER_QUALIFICATION_TYPES
(
 QUALIFICATION_TYPE_ID,
 NAME,
 CATEGORY,
 RANK,
 ATTRIBUTE_CATEGORY,
 ATTRIBUTE1,
 ATTRIBUTE2,
 ATTRIBUTE3,
 ATTRIBUTE4,
 ATTRIBUTE5,
 ATTRIBUTE6,
 ATTRIBUTE7,
 ATTRIBUTE8,
 ATTRIBUTE9,
 ATTRIBUTE10,
 ATTRIBUTE11,
 ATTRIBUTE12,
 ATTRIBUTE13,
 ATTRIBUTE14,
 ATTRIBUTE15,
 ATTRIBUTE16,
 ATTRIBUTE17,
 ATTRIBUTE18,
 ATTRIBUTE19,
 ATTRIBUTE20,
 INFORMATION1,
 INFORMATION2,
 INFORMATION3,
 INFORMATION4,
 INFORMATION5,
 INFORMATION6,
 INFORMATION7,
 INFORMATION8,
 INFORMATION9,
 INFORMATION10,
 INFORMATION11,
 INFORMATION12,
 INFORMATION13,
 INFORMATION14,
 INFORMATION15,
 INFORMATION16,
 INFORMATION17,
 INFORMATION18,
 INFORMATION19,
 INFORMATION20,
 INFORMATION21,
 INFORMATION22,
 INFORMATION23,
 INFORMATION24,
 INFORMATION25,
 INFORMATION26,
 INFORMATION27,
 INFORMATION28,
 INFORMATION29,
 INFORMATION30,
 INFORMATION_CATEGORY,
 QUAL_FRAMEWORK_ID,
 QUALIFICATION_TYPE,
 CREDIT_TYPE,
 CREDITS,
 LEVEL_TYPE,
 LEVEL_NUMBER,
 FIELD,
 SUB_FIELD,
 PROVIDER,
 QA_ORGANIZATION,
 OBJECT_VERSION_NUMBER,
 CREATION_DATE,
 CREATED_BY,
 LAST_UPDATE_DATE,
 LAST_UPDATED_BY,
 LAST_UPDATE_LOGIN
 )
 values
 (
 X_QUALIFICATION_TYPE_ID,
 X_NAME,
 X_CATEGORY,
 X_RANK,
 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_ATTRIBUTE16,
 X_ATTRIBUTE17,
 X_ATTRIBUTE18,
 X_ATTRIBUTE19,
 X_ATTRIBUTE20,
 X_INFORMATION1,
 X_INFORMATION2,
 X_INFORMATION3,
 X_INFORMATION4,
 X_INFORMATION5,
 X_INFORMATION6,
 X_INFORMATION7,
 X_INFORMATION8,
 X_INFORMATION9,
 X_INFORMATION10,
 X_INFORMATION11,
 X_INFORMATION12,
 X_INFORMATION13,
 X_INFORMATION14,
 X_INFORMATION15,
 X_INFORMATION16,
 X_INFORMATION17,
 X_INFORMATION18,
 X_INFORMATION19,
 X_INFORMATION20,
 X_INFORMATION21,
 X_INFORMATION22,
 X_INFORMATION23,
 X_INFORMATION24,
 X_INFORMATION25,
 X_INFORMATION26,
 X_INFORMATION27,
 X_INFORMATION28,
 X_INFORMATION29,
 X_INFORMATION30,
 X_INFORMATION_CATEGORY,
 X_QUAL_FRAMEWORK_ID,
 X_QUALIFICATION_TYPE,
 X_CREDIT_TYPE,
 X_CREDITS,
 X_LEVEL_TYPE,
 X_LEVEL_NUMBER,
 X_FIELD,
 X_SUB_FIELD,
 X_PROVIDER,
 X_QA_ORGANIZATION,
 X_OBJECT_VERSION_NUMBER,
 X_CREATION_DATE,
 X_CREATED_BY,
 X_LAST_UPDATE_DATE,
 X_LAST_UPDATED_BY,
 X_LAST_UPDATE_LOGIN
 );

Line: 299

 insert into PER_QUALIFICATION_TYPES_TL
 (
  QUALIFICATION_TYPE_ID,
  NAME,
  LAST_UPDATE_DATE,
  LAST_UPDATED_BY,
  LAST_UPDATE_LOGIN,
  CREATED_BY,
  CREATION_DATE,
  LANGUAGE,
  SOURCE_LANG
  ) select
    X_QUALIFICATION_TYPE_ID,
    X_USER_NAME,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_CREATED_BY,
    X_CREATION_DATE,
    L.LANGUAGE_CODE,
    userenv('LANG')
    from FND_LANGUAGES L
    where L.INSTALLED_FLAG in ('I', 'B')
    and not exists
        (select NULL
         from PER_QUALIFICATION_TYPES_TL T
         where T.QUALIFICATION_TYPE_ID = X_QUALIFICATION_TYPE_ID
         AND T.LANGUAGE = L.LANGUAGE_CODE);

Line: 336

end INSERT_ROW;

Line: 339

procedure update_row(
	X_QUALIFICATION_TYPE_ID IN NUMBER,
	X_NAME	IN VARCHAR2,
	X_CATEGORY IN VARCHAR2,
	X_RANK in number,
	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_ATTRIBUTE16  IN VARCHAR2,
	X_ATTRIBUTE17  IN VARCHAR2,
	X_ATTRIBUTE18  IN VARCHAR2,
	X_ATTRIBUTE19  IN VARCHAR2,
	X_ATTRIBUTE20  IN VARCHAR2,
	X_INFORMATION1  IN VARCHAR2,
	X_INFORMATION2  IN VARCHAR2,
	X_INFORMATION3  IN VARCHAR2,
	X_INFORMATION4  IN VARCHAR2,
	X_INFORMATION5  IN VARCHAR2,
	X_INFORMATION6  IN VARCHAR2,
	X_INFORMATION7  IN VARCHAR2,
	X_INFORMATION8  IN VARCHAR2,
	X_INFORMATION9  IN VARCHAR2,
	X_INFORMATION10  IN VARCHAR2,
	X_INFORMATION11  IN VARCHAR2,
	X_INFORMATION12  IN VARCHAR2,
	X_INFORMATION13  IN VARCHAR2,
	X_INFORMATION14  IN VARCHAR2,
	X_INFORMATION15  IN VARCHAR2,
	X_INFORMATION16  IN VARCHAR2,
	X_INFORMATION17  IN VARCHAR2,
	X_INFORMATION18  IN VARCHAR2,
	X_INFORMATION19  IN VARCHAR2,
	X_INFORMATION20  IN VARCHAR2,
	X_INFORMATION21  IN VARCHAR2,
	X_INFORMATION22  IN VARCHAR2,
	X_INFORMATION23  IN VARCHAR2,
	X_INFORMATION24  IN VARCHAR2,
	X_INFORMATION25  IN VARCHAR2,
	X_INFORMATION26  IN VARCHAR2,
	X_INFORMATION27  IN VARCHAR2,
	X_INFORMATION28  IN VARCHAR2,
	X_INFORMATION29  IN VARCHAR2,
	X_INFORMATION30  IN VARCHAR2,
	X_INFORMATION_CATEGORY  IN VARCHAR2,
	X_QUAL_FRAMEWORK_ID in number,
	X_QUALIFICATION_TYPE in varchar2,
	X_CREDIT_TYPE in varchar2,
	X_CREDITS in number,
	X_LEVEL_TYPE in varchar2,
	X_LEVEL_NUMBER in varchar2,
	X_FIELD   IN VARCHAR2,
	X_SUB_FIELD  IN VARCHAR2,
	X_PROVIDER  IN VARCHAR2,
    X_QA_ORGANIZATION IN VARCHAR2,
    X_OBJECT_VERSION_NUMBER IN VARCHAR2,
	X_USER_NAME IN VARCHAR2,
	X_CREATION_DATE in DATE,
	X_CREATED_BY in NUMBER,
	X_LAST_UPDATE_DATE in DATE,
	X_LAST_UPDATED_BY in NUMBER,
        X_LAST_UPDATE_LOGIN in NUMBER
	) is


begin

	update per_qualification_types
	set NAME                  =   X_NAME,
	    CATEGORY              =   X_CATEGORY,
	    RANK                  =   X_RANK,
	    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,
	    ATTRIBUTE16           =   X_ATTRIBUTE16,
	    ATTRIBUTE17           =   X_ATTRIBUTE17,
	    ATTRIBUTE18           =   X_ATTRIBUTE18,
	    ATTRIBUTE19           =   X_ATTRIBUTE19,
	    ATTRIBUTE20           =   X_ATTRIBUTE20,
	    INFORMATION1          =   X_INFORMATION1,
	    INFORMATION2          =   X_INFORMATION2,
	    INFORMATION3          =   X_INFORMATION3,
	    INFORMATION4          =   X_INFORMATION4,
	    INFORMATION5          =   X_INFORMATION5,
	    INFORMATION6          =   X_INFORMATION6,
	    INFORMATION7          =   X_INFORMATION7,
	    INFORMATION8          =   X_INFORMATION8,
	    INFORMATION9          =   X_INFORMATION9,
	    INFORMATION10         =   X_INFORMATION10,
	    INFORMATION11         =   X_INFORMATION11,
	    INFORMATION12         =   X_INFORMATION12,
	    INFORMATION13         =   X_INFORMATION13,
	    INFORMATION14         =   X_INFORMATION14,
	    INFORMATION15         =   X_INFORMATION15,
	    INFORMATION16         =   X_INFORMATION16,
	    INFORMATION17         =   X_INFORMATION17,
	    INFORMATION18         =   X_INFORMATION18,
	    INFORMATION19         =   X_INFORMATION19,
	    INFORMATION20         =   X_INFORMATION20,
	    INFORMATION21         =   X_INFORMATION21,
	    INFORMATION22         =   X_INFORMATION22,
	    INFORMATION23         =   X_INFORMATION23,
	    INFORMATION24         =   X_INFORMATION24,
	    INFORMATION25         =   X_INFORMATION25,
	    INFORMATION26         =   X_INFORMATION26,
	    INFORMATION27         =   X_INFORMATION27,
	    INFORMATION28         =   X_INFORMATION28,
	    INFORMATION29         =   X_INFORMATION29,
	    INFORMATION30         =   X_INFORMATION30,
	    INFORMATION_CATEGORY  =   X_INFORMATION_CATEGORY,
	    QUAL_FRAMEWORK_ID     =   X_QUAL_FRAMEWORK_ID,
	    QUALIFICATION_TYPE    =   X_QUALIFICATION_TYPE,
	    CREDIT_TYPE           =   X_CREDIT_TYPE,
	    CREDITS               =   X_CREDITS,
	    LEVEL_TYPE		  =   X_LEVEL_TYPE,
	    LEVEL_NUMBER	  =   X_LEVEL_NUMBER,
	    FIELD		  =   X_FIELD,
	    SUB_FIELD		  =   X_SUB_FIELD,
	    PROVIDER          	  =   X_PROVIDER,
	    QA_ORGANIZATION	  =   X_QA_ORGANIZATION,
        OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
	    CREATION_DATE	  =   X_CREATION_DATE,
	    CREATED_BY		  =   X_CREATED_BY,
	    LAST_UPDATE_DATE	  =   X_LAST_UPDATE_DATE,
	    LAST_UPDATED_BY	  =   X_LAST_UPDATED_BY,
	    LAST_UPDATE_LOGIN	  =   X_LAST_UPDATE_LOGIN
	where  	QUALIFICATION_TYPE_ID =   X_QUALIFICATION_TYPE_ID;

Line: 496

        update per_qualification_types_tl
        set NAME                  =   X_USER_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 QUALIFICATION_TYPE_ID =   X_QUALIFICATION_TYPE_ID
    	AND   userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 509

end update_row;

Line: 579

	X_LAST_UPDATE_DATE IN VARCHAR2 default sysdate,
        X_CUSTOM_MODE IN VARCHAR2 default null) IS

  X_ROWID ROWID;

Line: 587

  X_LAST_UPDATED_BY NUMBER;

Line: 588

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 590

  f_ludate  date;    -- entity update date in file

Line: 592

  db_ludate date;    -- entity update date in db

Line: 609

      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN
  ); */

Line: 617

   f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);

Line: 618

     select LAST_UPDATED_BY, LAST_UPDATE_DATE
     into db_luby, db_ludate
     from PER_QUALIFICATION_TYPES
     where QUALIFICATION_TYPE_ID = X_QUALIFICATION_TYPE_ID;

Line: 628

    UPDATE_ROW (
    		X_QUALIFICATION_TYPE_ID,
    		X_NAME,
    		X_CATEGORY,
		X_RANK,
		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_ATTRIBUTE16,
		X_ATTRIBUTE17,
		X_ATTRIBUTE18,
		X_ATTRIBUTE19,
		X_ATTRIBUTE20,
		X_INFORMATION1,
		X_INFORMATION2,
		X_INFORMATION3,
		X_INFORMATION4,
		X_INFORMATION5,
		X_INFORMATION6,
		X_INFORMATION7,
		X_INFORMATION8,
		X_INFORMATION9,
		X_INFORMATION10,
		X_INFORMATION11,
		X_INFORMATION12,
		X_INFORMATION13,
		X_INFORMATION14,
		X_INFORMATION15,
		X_INFORMATION16,
		X_INFORMATION17,
		X_INFORMATION18,
		X_INFORMATION19,
		X_INFORMATION20,
		X_INFORMATION21,
		X_INFORMATION22,
		X_INFORMATION23,
		X_INFORMATION24,
		X_INFORMATION25,
		X_INFORMATION26,
		X_INFORMATION27,
		X_INFORMATION28,
		X_INFORMATION29,
		X_INFORMATION30,
		X_INFORMATION_CATEGORY,
		X_QUAL_FRAMEWORK_ID,
		X_QUALIFICATION_TYPE,
		X_CREDIT_TYPE,
		X_CREDITS,
		X_LEVEL_TYPE,
		X_LEVEL_NUMBER,
		X_FIELD,
		X_SUB_FIELD,
		X_PROVIDER,
		X_QA_ORGANIZATION,
                X_OBJECT_VERSION_NUMBER,
		X_USER_NAME,
		X_CREATION_DATE,
		X_CREATED_BY,
		f_ludate,
		f_luby,
		0 );

Line: 705

      	 INSERT_ROW( X_ROWID,
      	             X_QUALIFICATION_TYPE_ID,
		     X_NAME,
		     X_CATEGORY,
		     X_RANK,
		     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_ATTRIBUTE16,
		     X_ATTRIBUTE17,
		     X_ATTRIBUTE18,
		     X_ATTRIBUTE19,
		     X_ATTRIBUTE20,
		     X_INFORMATION1,
		     X_INFORMATION2,
		     X_INFORMATION3,
		     X_INFORMATION4,
		     X_INFORMATION5,
		     X_INFORMATION6,
		     X_INFORMATION7,
		     X_INFORMATION8,
		     X_INFORMATION9,
		     X_INFORMATION10,
		     X_INFORMATION11,
		     X_INFORMATION12,
		     X_INFORMATION13,
		     X_INFORMATION14,
		     X_INFORMATION15,
		     X_INFORMATION16,
		     X_INFORMATION17,
		     X_INFORMATION18,
		     X_INFORMATION19,
		     X_INFORMATION20,
		     X_INFORMATION21,
		     X_INFORMATION22,
		     X_INFORMATION23,
		     X_INFORMATION24,
		     X_INFORMATION25,
		     X_INFORMATION26,
		     X_INFORMATION27,
		     X_INFORMATION28,
		     X_INFORMATION29,
		     X_INFORMATION30,
		     X_INFORMATION_CATEGORY,
		     X_QUAL_FRAMEWORK_ID,
		     X_QUALIFICATION_TYPE,
		     X_CREDIT_TYPE,
		     X_CREDITS,
		     X_LEVEL_TYPE,
		     X_LEVEL_NUMBER,
		     X_FIELD,
		     X_SUB_FIELD,
		     X_PROVIDER,
		     X_QA_ORGANIZATION,
                     X_OBJECT_VERSION_NUMBER,
		     X_USER_NAME,
		     X_CREATION_DATE,
		     X_CREATED_BY,
		     f_ludate,
		     f_luby,
		     0 );

Line: 786

              	  X_LAST_UPDATE_DATE IN VARCHAR2 default sysdate,
                  X_CUSTOM_MODE IN VARCHAR2 default null
		  ) IS

  X_QUALIFICATION_TYPE_ID NUMBER;

Line: 794

  X_LAST_UPDATED_BY NUMBER;

Line: 795

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 797

  f_ludate  date;    -- entity update date in file

Line: 799

  db_ludate date;    -- entity update date in db

Line: 810

      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN
  );*/

Line: 819

  f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 820

      select LAST_UPDATED_BY, LAST_UPDATE_DATE
      into db_luby, db_ludate
      from PER_QUALIFICATION_TYPES_TL
      where QUALIFICATION_TYPE_ID = TO_NUMBER(X_QUALIFICATION_TYPE_ID)
      and LANGUAGE=userenv('LANG');

Line: 829

  update per_qualification_types_tl
  set NAME                  =   X_USER_NAME,
      LAST_UPDATE_DATE = db_ludate,
      LAST_UPDATED_BY = db_luby,
      LAST_UPDATE_LOGIN = 0,
      SOURCE_LANG = userenv('LANG')
  where QUALIFICATION_TYPE_ID =   X_QUALIFICATION_TYPE_ID
  AND   userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 840

procedure delete_row(
		X_QUALIFICATION_TYPE_ID IN NUMBER
		) is
begin

    delete from PER_QUALIFICATION_TYPES_TL
    where qualification_type_id =X_QUALIFICATION_TYPE_ID;

Line: 848

end delete_row;

Line: 854

  delete from PER_QUALIFICATION_TYPES_TL T
  where not exists
    (select NULL
    from PER_QUALIFICATION_TYPES B
    where B.QUALIFICATION_TYPE_ID = T.QUALIFICATION_TYPE_ID
    );

Line: 861

  update PER_QUALIFICATION_TYPES_TL T set (
      NAME
    ) = (select
      B.NAME
    from PER_QUALIFICATION_TYPES_TL B
    where B.QUALIFICATION_TYPE_ID = T.QUALIFICATION_TYPE_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.QUALIFICATION_TYPE_ID,
      T.LANGUAGE
  ) in (select
      SUBT.QUALIFICATION_TYPE_ID,
      SUBT.LANGUAGE
    from PER_QUALIFICATION_TYPES_TL SUBB, PER_QUALIFICATION_TYPES_TL SUBT
    where SUBB.QUALIFICATION_TYPE_ID = SUBT.QUALIFICATION_TYPE_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.NAME <> SUBT.NAME
  ));

Line: 880

  insert into PER_QUALIFICATION_TYPES_TL (
    QUALIFICATION_TYPE_ID,
    NAME,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    CREATED_BY,
    CREATION_DATE,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.QUALIFICATION_TYPE_ID,
    B.NAME,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.CREATED_BY,
    B.CREATION_DATE,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from PER_QUALIFICATION_TYPES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from PER_QUALIFICATION_TYPES_TL T
    where T.QUALIFICATION_TYPE_ID = B.QUALIFICATION_TYPE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);