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_TR_TYPE_STEP_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,
    x_org_id IN NUMBER DEFAULT NULL
  ) AS

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     igs_tr_type_step_all
      WHERE    ROWID = x_rowid;

Line: 42


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

Line: 64


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

Line: 72


    new_references.last_update_date := x_last_update_date;

Line: 73


    new_references.last_updated_by := x_last_updated_by;

Line: 74


    new_references.last_update_login := x_last_update_login;

Line: 78


  PROCEDURE BeforeRowInsertUpdate(
    p_inserting IN BOOLEAN DEFAULT FALSE,
    p_updating IN BOOLEAN DEFAULT FALSE
    ) as
     v_message_name                  VARCHAR2(30);

Line: 85


        IF (p_inserting OR (p_updating AND (old_references.tracking_type <> new_references.tracking_type))) THEN
	 IF NOT IGS_TR_VAL_TRI.TRKP_VAL_TRI_TYPE (new_references.tracking_type,
	                                          v_message_name) THEN
             Fnd_Message.Set_Name('IGS', v_message_name);

Line: 94


	IF (p_inserting OR (p_updating AND (old_references.step_catalog_cd <> new_references.step_catalog_cd))) THEN
	 IF NOT IGS_TR_VAL_TRI.val_tr_step_ctlg (new_references.step_catalog_cd,
	                                          v_message_name) THEN
             Fnd_Message.Set_Name('IGS', v_message_name);

Line: 102


  END BeforeRowInsertUpdate;

Line: 105


  PROCEDURE beforerowinsertupdate1(
    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: 116


    IF (p_inserting OR
      (p_updating AND (NVL(old_references.s_tracking_step_type, 'NULL') <>
      NVL(new_references.s_tracking_step_type, 'NULL')))) AND
      new_references.s_tracking_step_type IS NOT NULL THEN

      IF igs_tr_val_trst.trkp_val_stst_stt(
        new_references.s_tracking_step_type,
        new_references.tracking_type,
         v_message_name) = FALSE THEN

        fnd_message.set_name('IGS',v_message_name);

Line: 132


  END beforerowinsertupdate1;

Line: 147


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

Line: 158


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

Line: 171


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

Line: 184


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

Line: 208


      SELECT   ROWID
      FROM     igs_tr_type_step_all
      WHERE    tracking_type = x_tracking_type
      AND      tracking_type_step_id = x_tracking_type_step_id
      FOR UPDATE NOWAIT;

Line: 235


      SELECT   ROWID
      FROM     igs_tr_type_step_all
      WHERE    recipient_id = x_person_id ;

Line: 261


      SELECT   ROWID
      FROM     igs_tr_type_step_all
      WHERE    s_tracking_step_type = x_s_tracking_step_type ;

Line: 369


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL,
    x_org_id IN NUMBER DEFAULT NULL
  ) AS
  BEGIN

    set_column_values (
      p_action,
      x_rowid,
      x_tracking_type,
      x_tracking_type_step_id,
      x_tracking_type_step_number,
      x_description,
      x_action_days,
      x_recipient_id,
      x_s_tracking_step_type,
      x_step_group_id,
      x_publish_ind,
      x_step_catalog_cd,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_org_id
    );

Line: 397


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

Line: 400


      beforerowinsertupdate1 ( p_inserting => TRUE );

Line: 412


    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      BeforeRowinsertUpdate ( p_updating => TRUE );

Line: 415


      beforerowinsertupdate1 ( p_updating => TRUE );

Line: 419


    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      NULL;

Line: 424


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      -- Call all the procedures related to Before Delete.
      IF get_pk_for_validation(
        new_references.tracking_type,
        new_references.tracking_type_step_id
       )THEN
        fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

Line: 436


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      -- Call all the procedures related to Before Delete.
      check_constraints;

Line: 440


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      -- Call all the procedures related to Before Delete.
      check_child_existance;

Line: 458


  PROCEDURE insert_row (
    x_rowid IN OUT NOCOPY VARCHAR2,
    x_tracking_type IN VARCHAR2,
    x_tracking_type_step_id IN NUMBER,
    x_tracking_type_step_number IN NUMBER,
    x_description IN VARCHAR2,
    x_s_tracking_step_type IN VARCHAR2,
    x_action_days IN NUMBER,
    x_recipient_id IN NUMBER,
    x_step_group_id IN NUMBER DEFAULT NULL,
    x_publish_ind IN VARCHAR2 DEFAULT 'N',
    x_step_catalog_cd IN VARCHAR2 DEFAULT NULL,
    x_mode IN VARCHAR2 DEFAULT 'R',
    x_org_id IN NUMBER
  ) AS

    CURSOR c IS
      SELECT  ROWID
      FROM    igs_tr_type_step_all
      WHERE   tracking_type = x_tracking_type
      AND     tracking_type_step_id = x_tracking_type_step_id;

Line: 480


    x_last_update_date DATE;

Line: 481


    x_last_updated_by NUMBER;

Line: 482


    x_last_update_login NUMBER;

Line: 486


    x_last_update_date := SYSDATE;

Line: 488


      x_last_updated_by := 1;

Line: 489


      x_last_update_login := 0;

Line: 491


      x_last_updated_by := fnd_global.user_id;

Line: 492


      IF x_last_updated_by IS NULL THEN
      x_last_updated_by := -1;

Line: 496


      x_last_update_login :=fnd_global.login_id;

Line: 497


      IF x_last_update_login IS NULL THEN
      x_last_update_login := -1;

Line: 507


    before_dml(p_action =>'INSERT',
      x_rowid =>x_rowid,
      x_tracking_type => x_tracking_type,
      x_tracking_type_step_id => x_tracking_type_step_id,
      x_tracking_type_step_number => x_tracking_type_step_number,
      x_description => x_description,
      x_action_days => x_action_days,
      x_recipient_id => x_recipient_id,
      x_s_tracking_step_type => x_s_tracking_step_type,
      x_step_group_id => x_step_group_id,
      x_publish_ind => x_publish_ind,
      x_step_catalog_cd => x_step_catalog_cd,
      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,
      x_org_id => igs_ge_gen_003.get_org_id
    );

Line: 527


    INSERT INTO igs_tr_type_step_all (
      tracking_type,
      tracking_type_step_id,
      tracking_type_step_number,
      description,
      s_tracking_step_type,
      action_days,
      recipient_id,
      step_group_id,
      publish_ind,
      step_catalog_cd,
      org_id,
      creation_date,
      created_by,
      last_update_date,
      last_updated_by,
      last_update_login
    ) VALUES (
      new_references.tracking_type,
      new_references.tracking_type_step_id,
      new_references.tracking_type_step_number,
      new_references.description,
      new_references.s_tracking_step_type,
      new_references.action_days,
      new_references.recipient_id,
      new_references.step_group_id,
      new_references.publish_ind,
      new_references.step_catalog_cd,
      new_references.org_id,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 572


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

Line: 576


  END insert_row;

Line: 593


      SELECT   tracking_type_step_number, description, s_tracking_step_type,  action_days,
      		recipient_id, step_group_id, publish_ind, step_catalog_cd
      FROM     igs_tr_type_step_all
      WHERE    ROWID = x_rowid
      FOR UPDATE NOWAIT;

Line: 606


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

Line: 643


  PROCEDURE update_row (
    x_rowid IN VARCHAR2,
    x_tracking_type IN VARCHAR2,
    x_tracking_type_step_id IN NUMBER,
    x_tracking_type_step_number IN NUMBER,
    x_description IN VARCHAR2,
    x_s_tracking_step_type IN VARCHAR2,
    x_action_days IN NUMBER,
    x_recipient_id IN NUMBER,
    x_step_group_id IN NUMBER DEFAULT NULL,
    x_publish_ind IN VARCHAR2 DEFAULT 'N',
    x_step_catalog_cd IN VARCHAR2 DEFAULT NULL,
    x_mode IN VARCHAR2 DEFAULT 'R'
    ) AS

      x_last_update_date DATE;

Line: 659


      x_last_updated_by NUMBER;

Line: 660


      x_last_update_login NUMBER;

Line: 664


    x_last_update_date := SYSDATE;

Line: 667


      x_last_updated_by := 1;

Line: 668


      x_last_update_login := 0;

Line: 671


      x_last_updated_by := fnd_global.user_id;

Line: 673


      IF x_last_updated_by IS NULL THEN
        x_last_updated_by := -1;

Line: 676


      x_last_update_login :=fnd_global.login_id;

Line: 678


      IF x_last_update_login IS NULL THEN
        x_last_update_login := -1;

Line: 687


    before_dml(p_action =>'UPDATE',
      x_rowid =>x_rowid,
      x_tracking_type => x_tracking_type,
      x_tracking_type_step_id => x_tracking_type_step_id,
      x_tracking_type_step_number => x_tracking_type_step_number,
      x_description => x_description,
      x_action_days => x_action_days,
      x_recipient_id => x_recipient_id,
      x_s_tracking_step_type => x_s_tracking_step_type,
      x_step_group_id => x_step_group_id,
      x_publish_ind => x_publish_ind,
      x_step_catalog_cd => x_step_catalog_cd,
      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: 706


    UPDATE igs_tr_type_step_all SET
      tracking_type_step_number = new_references.tracking_type_step_number,
      description = new_references.description,
      s_tracking_step_type = new_references.s_tracking_step_type,
      action_days = new_references.action_days,
      recipient_id = new_references.recipient_id,
      step_group_id = new_references.step_group_id,
      publish_ind = new_references.publish_ind,
      step_catalog_cd = new_references.step_catalog_cd,
      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: 725


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

Line: 729


  END update_row;

Line: 748


      SELECT ROWID
      FROM   igs_tr_type_step_all
      WHERE  tracking_type = x_tracking_type
      AND    tracking_type_step_id = x_tracking_type_step_id;

Line: 759


      insert_row (
        x_rowid,
        x_tracking_type,
        x_tracking_type_step_id,
        x_tracking_type_step_number,
        x_description,
        x_s_tracking_step_type,
        x_action_days,
        x_recipient_id,
        x_step_group_id,
        x_publish_ind,
        x_step_catalog_cd,
        x_mode,
        x_org_id
      );

Line: 777


    update_row (
      x_rowid,
      x_tracking_type,
      x_tracking_type_step_id,
      x_tracking_type_step_number,
      x_description,
      x_s_tracking_step_type,
      x_action_days,
      x_recipient_id,
      x_step_group_id,
      x_publish_ind,
      x_step_catalog_cd,
      x_mode
    );

Line: 794


  PROCEDURE delete_row (
    x_rowid IN VARCHAR2
  ) AS
  BEGIN

    before_dml(p_action =>'DELETE',
      x_rowid =>x_rowid
    );

Line: 803


    DELETE FROM igs_tr_type_step_all WHERE ROWID = x_rowid;

Line: 809


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

Line: 813


  END delete_row;