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_AS_UNT_PATRN_ITM_PKG SQL Statements

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

Line: 23


    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_AS_UNT_PATRN_ITM
      WHERE    rowid = x_rowid;

Line: 41


    IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
      Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 59


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

Line: 66


    new_references.last_update_date := x_last_update_date;

Line: 67


    new_references.last_updated_by := x_last_updated_by;

Line: 68


    new_references.last_update_login := x_last_update_login;

Line: 78


  PROCEDURE BeforeRowInsertDelete1(
    p_inserting IN BOOLEAN DEFAULT FALSE,
    p_updating IN BOOLEAN DEFAULT FALSE,
    p_deleting IN BOOLEAN DEFAULT FALSE
    ) as
	v_message_name  varchar2(30);

Line: 89


		SELECT	uap.action_dt
		FROM	IGS_AS_UNTAS_PATTERN uap
		WHERE	uap.unit_cd		= cp_unit_cd 		AND
			uap.version_number	= cp_version_number	AND
			uap.cal_type		= cp_cal_type		AND
			uap.ci_sequence_number 	= cp_ci_sequence_number 	AND
			uap.ass_pattern_id		= cp_ass_pattern_id 	AND
			uap.action_dt		IS NULL
		FOR UPDATE OF uap.action_dt NOWAIT;

Line: 101


	IF  p_inserting THEN
		IF  IGS_AS_VAL_UAPI.assp_val_uapi_uoo (	new_references.unit_cd,
						new_references.version_number,
						new_references.cal_type,
						new_references.ci_sequence_number,
						new_references.ass_pattern_id,
						new_references.ass_id,
						new_references.uai_sequence_number,
						v_message_name) = FALSE THEN
                     Fnd_Message.Set_Name('IGS', v_message_name);

Line: 115


	IF p_inserting THEN
		-- Update the action date of the IGS_AS_UNTAS_PATTERN table
		FOR v_uap_rec IN c_uap(	new_references.unit_cd,
					new_references.version_number,
					new_references.cal_type,
					new_references.ci_sequence_number,
					new_references.ass_pattern_id) LOOP
			UPDATE 	IGS_AS_UNTAS_PATTERN uap
			SET	uap.action_dt = SYSDATE
			WHERE CURRENT OF c_uap;

Line: 128


		-- Update the action date of the IGS_AS_UNTAS_PATTERN table
		FOR v_uap_rec IN c_uap(	old_references.unit_cd,
					old_references.version_number,
					old_references.cal_type,
					old_references.ci_sequence_number,
					old_references.ass_pattern_id) LOOP
			UPDATE 	IGS_AS_UNTAS_PATTERN uap
			SET	uap.action_dt = SYSDATE
			WHERE CURRENT OF c_uap;

Line: 141


  END BeforeRowInsertDelete1;

Line: 169


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

Line: 194


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

Line: 277


      SELECT   rowid
      FROM     IGS_AS_UNT_PATRN_ITM
      WHERE    unit_cd = x_unit_cd
      AND      version_number = x_version_number
      AND      cal_type= x_cal_type
      AND      ci_sequence_number = x_ci_sequence_number
      AND      ass_pattern_id = x_ass_pattern_id
      AND      ass_id = x_ass_id
      AND      uai_sequence_number = x_uai_sequence_number
      FOR UPDATE NOWAIT;

Line: 314


      SELECT   rowid
      FROM     IGS_AS_UNT_PATRN_ITM
      WHERE    unit_cd = x_unit_cd
      AND      version_number = x_version_number
      AND      cal_type= x_cal_type
      AND      ci_sequence_number = x_ci_sequence_number
      AND      ass_id = x_ass_id
      AND      uai_sequence_number = x_sequence_number ;

Line: 349


      SELECT   rowid
      FROM     IGS_AS_UNT_PATRN_ITM
      WHERE    unit_cd = x_unit_cd
      AND      version_number = x_version_number
      AND      cal_type= x_cal_type
      AND      ci_sequence_number = x_ci_sequence_number
      AND      ass_pattern_id = x_ass_pattern_id ;

Line: 387


    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_unit_cd,
      x_version_number,
      x_cal_type,
      x_ci_sequence_number,
      x_ass_pattern_id,
      x_ass_id,
      x_uai_sequence_number,
      x_apportionment_percentage,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 411


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      BeforeRowInsertDelete1 ( p_inserting => TRUE );

Line: 429


    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      Null;

Line: 434


    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      BeforeRowInsertDelete1 ( p_deleting => TRUE );

Line: 437


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      IF  Get_PK_For_Validation (
             new_references.unit_cd ,
             new_references.version_number,
             new_references.cal_type ,
             new_references.ci_sequence_number,
             new_references.ass_pattern_id ,
             new_references.ass_id ,
             new_references.uai_sequence_number
		             ) THEN
        Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

Line: 452


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
	        Check_Constraints;

Line: 454


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
           NULL;

Line: 461


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_UNIT_CD in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_CAL_TYPE in VARCHAR2,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_ASS_PATTERN_ID in NUMBER,
  X_ASS_ID in NUMBER,
  X_UAI_SEQUENCE_NUMBER in NUMBER,
  X_APPORTIONMENT_PERCENTAGE in NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) as
    cursor C is select ROWID from IGS_AS_UNT_PATRN_ITM
      where UNIT_CD = X_UNIT_CD
      and VERSION_NUMBER = X_VERSION_NUMBER
      and CAL_TYPE = X_CAL_TYPE
      and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
      and ASS_PATTERN_ID = X_ASS_PATTERN_ID
      and ASS_ID = X_ASS_ID
      and UAI_SEQUENCE_NUMBER = X_UAI_SEQUENCE_NUMBER;

Line: 481


    X_LAST_UPDATE_DATE DATE;

Line: 482


    X_LAST_UPDATED_BY NUMBER;

Line: 483


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 487


    X_PROGRAM_UPDATE_DATE DATE;

Line: 490


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 492


    X_LAST_UPDATED_BY := 1;

Line: 493


    X_LAST_UPDATE_LOGIN := 0;

Line: 495


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 496


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 499


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 500


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 511


     X_PROGRAM_UPDATE_DATE := NULL;

Line: 513


     X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 522


   p_action=>'INSERT',
   x_rowid=>X_ROWID,
   x_apportionment_percentage=>X_APPORTIONMENT_PERCENTAGE,
   x_ass_id=>X_ASS_ID,
   x_ass_pattern_id=>X_ASS_PATTERN_ID,
   x_cal_type=>X_CAL_TYPE,
   x_ci_sequence_number=>X_CI_SEQUENCE_NUMBER,
   x_uai_sequence_number=>X_UAI_SEQUENCE_NUMBER,
   x_unit_cd=>X_UNIT_CD,
   x_version_number=>X_VERSION_NUMBER,
   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: 539


  insert into IGS_AS_UNT_PATRN_ITM (
    UNIT_CD,
    VERSION_NUMBER,
    CAL_TYPE,
    CI_SEQUENCE_NUMBER,
    ASS_PATTERN_ID,
    ASS_ID,
    UAI_SEQUENCE_NUMBER,
    APPORTIONMENT_PERCENTAGE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_ID,
    PROGRAM_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE

  ) values (
    NEW_REFERENCES.UNIT_CD,
    NEW_REFERENCES.VERSION_NUMBER,
    NEW_REFERENCES.CAL_TYPE,
    NEW_REFERENCES.CI_SEQUENCE_NUMBER,
    NEW_REFERENCES.ASS_PATTERN_ID,
    NEW_REFERENCES.ASS_ID,
    NEW_REFERENCES.UAI_SEQUENCE_NUMBER,
    NEW_REFERENCES.APPORTIONMENT_PERCENTAGE,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_REQUEST_ID,
    X_PROGRAM_ID,
    X_PROGRAM_APPLICATION_ID,
    X_PROGRAM_UPDATE_DATE

  );

Line: 588


end INSERT_ROW;

Line: 601


  cursor c1 is select
      APPORTIONMENT_PERCENTAGE
    from IGS_AS_UNT_PATRN_ITM
    where ROWID = X_ROWID  for update  nowait;

Line: 611


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

Line: 632


procedure UPDATE_ROW (
  X_ROWID in  VARCHAR2,
  X_UNIT_CD in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_CAL_TYPE in VARCHAR2,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_ASS_PATTERN_ID in NUMBER,
  X_ASS_ID in NUMBER,
  X_UAI_SEQUENCE_NUMBER in NUMBER,
  X_APPORTIONMENT_PERCENTAGE in NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) as
    X_LAST_UPDATE_DATE DATE;

Line: 645


    X_LAST_UPDATED_BY NUMBER;

Line: 646


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 650


    X_PROGRAM_UPDATE_DATE DATE;

Line: 652


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 654


    X_LAST_UPDATED_BY := 1;

Line: 655


    X_LAST_UPDATE_LOGIN := 0;

Line: 657


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 658


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 661


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 662


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 671


   p_action=>'UPDATE',
   x_rowid=>X_ROWID,
   x_apportionment_percentage=>X_APPORTIONMENT_PERCENTAGE,
   x_ass_id=>X_ASS_ID,
   x_ass_pattern_id=>X_ASS_PATTERN_ID,
   x_cal_type=>X_CAL_TYPE,
   x_ci_sequence_number=>X_CI_SEQUENCE_NUMBER,
   x_uai_sequence_number=>X_UAI_SEQUENCE_NUMBER,
   x_unit_cd=>X_UNIT_CD,
   x_version_number=>X_VERSION_NUMBER,
   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: 696


     X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE;

Line: 698


     X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 704


  update IGS_AS_UNT_PATRN_ITM set
    APPORTIONMENT_PERCENTAGE = NEW_REFERENCES.APPORTIONMENT_PERCENTAGE,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    REQUEST_ID = X_REQUEST_ID,
    PROGRAM_ID = X_PROGRAM_ID,
    PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
  where ROWID = X_ROWID;

Line: 719


end UPDATE_ROW;

Line: 733


  cursor c1 is select rowid from IGS_AS_UNT_PATRN_ITM
     where UNIT_CD = X_UNIT_CD
     and VERSION_NUMBER = X_VERSION_NUMBER
     and CAL_TYPE = X_CAL_TYPE
     and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
     and ASS_PATTERN_ID = X_ASS_PATTERN_ID
     and ASS_ID = X_ASS_ID
     and UAI_SEQUENCE_NUMBER = X_UAI_SEQUENCE_NUMBER
  ;

Line: 747


    INSERT_ROW (
     X_ROWID,
     X_UNIT_CD,
     X_VERSION_NUMBER,
     X_CAL_TYPE,
     X_CI_SEQUENCE_NUMBER,
     X_ASS_PATTERN_ID,
     X_ASS_ID,
     X_UAI_SEQUENCE_NUMBER,
     X_APPORTIONMENT_PERCENTAGE,
     X_MODE);

Line: 761


  UPDATE_ROW (
   X_ROWID,
   X_UNIT_CD,
   X_VERSION_NUMBER,
   X_CAL_TYPE,
   X_CI_SEQUENCE_NUMBER,
   X_ASS_PATTERN_ID,
   X_ASS_ID,
   X_UAI_SEQUENCE_NUMBER,
   X_APPORTIONMENT_PERCENTAGE,
   X_MODE);

Line: 774


procedure DELETE_ROW (
  X_ROWID in VARCHAR2) as
begin
--
 Before_DML(
  p_action => 'DELETE',
  x_rowid => X_ROWID
  );

Line: 783


  delete from IGS_AS_UNT_PATRN_ITM
 where ROWID = X_ROWID;

Line: 790


end DELETE_ROW;