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.IGS_AD_OS_SEC_EDU_QF_PKG SQL Statements

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

Line: 18


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL
  ) as

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_AD_OS_SEC_EDU_QF
      WHERE    rowid = x_rowid;

Line: 36


    IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
      Close cur_old_ref_values;

Line: 38


      Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 50


    IF (p_action = 'UPDATE') THEN
      new_references.creation_date := old_references.creation_date;

Line: 57


    new_references.last_update_date := x_last_update_date;

Line: 58


    new_references.last_updated_by := x_last_updated_by;

Line: 59


    new_references.last_update_login := x_last_update_login;

Line: 113


	Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');

Line: 136


      SELECT   rowid
      FROM     IGS_AD_OS_SEC_EDU_QF
      WHERE    os_scndry_edu_qualification = x_os_scndry_edu_qualification AND
               closed_ind = NVL(x_closed_ind,closed_ind)
      FOR UPDATE NOWAIT;

Line: 163


      SELECT   rowid
      FROM     IGS_AD_OS_SEC_EDU_QF
      WHERE    country_cd = x_country_cd ;

Line: 193


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL
  ) as
  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_os_scndry_edu_qualification,
      x_description,
      x_country_cd,
      x_closed_ind,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 213


    IF (p_action = 'INSERT') THEN
	IF Get_PK_For_Validation (
		new_references.os_scndry_edu_qualification
	) THEN
		Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

Line: 223


    ELSIF (p_action = 'UPDATE') THEN
	Check_Constraints;

Line: 226


    ELSIF (p_action = 'DELETE') THEN
      Check_Child_Existance;

Line: 228


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
	IF Get_PK_For_Validation (
		new_references.os_scndry_edu_qualification
	) THEN
		Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

Line: 237


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
	Check_Constraints;

Line: 239


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Check_Child_Existance;

Line: 256


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_OS_SCNDRY_EDU_QUALIFICATION in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_COUNTRY_CD in VARCHAR2,
  X_CLOSED_IND in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) as
    cursor C is select ROWID from IGS_AD_OS_SEC_EDU_QF
      where OS_SCNDRY_EDU_QUALIFICATION = X_OS_SCNDRY_EDU_QUALIFICATION;

Line: 266


    X_LAST_UPDATE_DATE DATE;

Line: 267


    X_LAST_UPDATED_BY NUMBER;

Line: 268


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 270


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 272


    X_LAST_UPDATED_BY := 1;

Line: 273


    X_LAST_UPDATE_LOGIN := 0;

Line: 275


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 276


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 279


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 280


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 290


    p_action=>'INSERT' ,
    x_rowid=>X_ROWID ,
    x_os_scndry_edu_qualification => X_OS_SCNDRY_EDU_QUALIFICATION ,
    x_description => X_DESCRIPTION ,
    x_country_cd => X_COUNTRY_CD ,
    x_closed_ind => NVL(X_CLOSED_IND,'N') ,
    x_creation_date=>X_LAST_UPDATE_DATE ,
    x_created_by=>X_LAST_UPDATED_BY   ,
    x_last_update_date=>X_LAST_UPDATE_DATE ,
    x_last_updated_by=>X_LAST_UPDATED_BY ,
    x_last_update_login=> X_LAST_UPDATE_LOGIN
       );

Line: 304


  insert into IGS_AD_OS_SEC_EDU_QF (
    OS_SCNDRY_EDU_QUALIFICATION,
    DESCRIPTION,
    COUNTRY_CD,
    CLOSED_IND,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    NEW_REFERENCES.OS_SCNDRY_EDU_QUALIFICATION,
    NEW_REFERENCES.DESCRIPTION,
    NEW_REFERENCES.COUNTRY_CD,
    NEW_REFERENCES.CLOSED_IND,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 335


  p_action=>'INSERT',
  x_rowid=> X_ROWID
         );

Line: 340


end INSERT_ROW;

Line: 349


  cursor c1 is select
      DESCRIPTION,
      COUNTRY_CD,
      CLOSED_IND
    from IGS_AD_OS_SEC_EDU_QF
    WHERE  ROWID = X_ROWID  for update nowait ;

Line: 362


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

Line: 384


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2 ,
  X_OS_SCNDRY_EDU_QUALIFICATION in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_COUNTRY_CD in VARCHAR2,
  X_CLOSED_IND in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) as
    X_LAST_UPDATE_DATE DATE;

Line: 393


    X_LAST_UPDATED_BY NUMBER;

Line: 394


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 396


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 398


    X_LAST_UPDATED_BY := 1;

Line: 399


    X_LAST_UPDATE_LOGIN := 0;

Line: 401


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 402


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 405


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 406


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 416


    p_action=>'UPDATE' ,
    x_rowid=>X_ROWID ,
    x_os_scndry_edu_qualification => X_OS_SCNDRY_EDU_QUALIFICATION ,
    x_description => X_DESCRIPTION ,
    x_country_cd => X_COUNTRY_CD ,
    x_closed_ind => X_CLOSED_IND ,
    x_creation_date=>X_LAST_UPDATE_DATE ,
    x_created_by=>X_LAST_UPDATED_BY  ,
    x_last_update_date=>X_LAST_UPDATE_DATE ,
    x_last_updated_by=>X_LAST_UPDATED_BY ,
    x_last_update_login=> X_LAST_UPDATE_LOGIN
       );

Line: 430


  update IGS_AD_OS_SEC_EDU_QF set
    DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
    COUNTRY_CD = NEW_REFERENCES.COUNTRY_CD,
    CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where ROWID = X_ROWID
  ;

Line: 444


  p_action=>'UPDATE',
  x_rowid=> X_ROWID
         );

Line: 448


end UPDATE_ROW;

Line: 458


  cursor c1 is select rowid from IGS_AD_OS_SEC_EDU_QF
     where OS_SCNDRY_EDU_QUALIFICATION = X_OS_SCNDRY_EDU_QUALIFICATION
  ;

Line: 467


    INSERT_ROW (
     X_ROWID,
     X_OS_SCNDRY_EDU_QUALIFICATION,
     X_DESCRIPTION,
     X_COUNTRY_CD,
     X_CLOSED_IND,
     X_MODE);

Line: 477


  UPDATE_ROW (
   X_ROWID,
   X_OS_SCNDRY_EDU_QUALIFICATION,
   X_DESCRIPTION,
   X_COUNTRY_CD,
   X_CLOSED_IND,
   X_MODE);

Line: 486


procedure DELETE_ROW (
X_ROWID in VARCHAR2
) as
begin

Before_DML(
  p_action=>'DELETE',
  x_rowid=> X_ROWID
         );

Line: 496


  delete from IGS_AD_OS_SEC_EDU_QF
  where ROWID = X_ROWID;

Line: 503


  p_action=>'DELETE',
  x_rowid=> X_ROWID
         );

Line: 508


end DELETE_ROW;