APPS.IGS_TR_TYPE_PKG SQL Statements

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

Line: 21

    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_all
      WHERE    ROWID = x_rowid;

Line: 40

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

Line: 60

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

Line: 67

    new_references.last_update_date := x_last_update_date;

Line: 68

    new_references.last_updated_by := x_last_updated_by;

Line: 69

    new_references.last_update_login := x_last_update_login;

Line: 83

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

Line: 96

      SELECT   ROWID
      FROM     igs_tr_type_all
      WHERE    tracking_type = x_tracking_type;

Line: 121

      SELECT   ROWID
      FROM     igs_tr_type_all
      WHERE    s_tracking_type = x_s_tracking_type ;

Line: 270

    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_description,
      x_s_tracking_type,
      x_target_days,
      x_sequence_ind,
      x_business_days_ind,
      x_closed_ind,
      x_publish_ind,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login ,
      x_org_id
    );

Line: 297

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      NULL;

Line: 309

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

Line: 315

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

Line: 324

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

Line: 341

  PROCEDURE insert_row (
    x_rowid IN OUT NOCOPY VARCHAR2,
    x_tracking_type IN VARCHAR2,
    x_description IN VARCHAR2,
    x_s_tracking_type IN VARCHAR2,
    x_target_days IN NUMBER,
    x_sequence_ind IN VARCHAR2,
    x_business_days_ind IN VARCHAR2,
    x_closed_ind IN VARCHAR2,
    x_publish_ind IN VARCHAR2 DEFAULT 'N',
    x_mode IN VARCHAR2 DEFAULT 'R',
    x_org_id IN NUMBER
  ) AS

    CURSOR c IS
      SELECT   ROWID
      FROM     igs_tr_type_all
      WHERE    tracking_type = x_tracking_type;

Line: 360

    x_last_update_date DATE;

Line: 361

    x_last_updated_by NUMBER;

Line: 362

    x_last_update_login NUMBER;

Line: 366

    x_last_update_date := SYSDATE;

Line: 369

      x_last_updated_by := 1;

Line: 370

      x_last_update_login := 0;

Line: 373

      x_last_updated_by := fnd_global.user_id;

Line: 374

      IF x_last_updated_by IS NULL THEN
        x_last_updated_by := -1;

Line: 378

      x_last_update_login :=fnd_global.login_id;

Line: 379

      IF x_last_update_login IS NULL THEN
        x_last_update_login := -1;

Line: 390

      p_action =>'INSERT',
      x_rowid =>x_rowid,
      x_tracking_type => x_tracking_type,
      x_description => x_description,
      x_s_tracking_type => x_s_tracking_type,
      x_target_days => x_target_days,
      x_sequence_ind => NVL(x_sequence_ind,'N'),
      x_business_days_ind => NVL(x_business_days_ind,'Y'),
      x_closed_ind => NVL(x_closed_ind,'N'),
      x_publish_ind => NVL(x_publish_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,
      x_org_id => igs_ge_gen_003.get_org_id
    );

Line: 408

    INSERT INTO igs_tr_type_all (
      tracking_type,
      description,
      s_tracking_type,
      target_days,
      sequence_ind,
      business_days_ind,
      closed_ind,
      publish_ind,
      org_id,
      creation_date,
      created_by,
      last_update_date,
      last_updated_by,
      last_update_login
    ) VALUES (
      new_references.tracking_type,
      new_references.description,
      new_references.s_tracking_type,
      new_references.target_days,
      new_references.sequence_ind,
      new_references.business_days_ind,
      new_references.closed_ind,
      new_references.publish_ind,
      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: 449

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

Line: 453

  END insert_row;

Line: 468

      SELECT  description,s_tracking_type,target_days,sequence_ind,business_days_ind,
      		closed_ind, publish_ind
      FROM    igs_tr_type_all
      WHERE   ROWID = x_rowid
      FOR UPDATE NOWAIT;

Line: 480

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

Line: 507

  PROCEDURE update_row (
    x_rowid IN VARCHAR2,
    x_tracking_type IN VARCHAR2,
    x_description IN VARCHAR2,
    x_s_tracking_type IN VARCHAR2,
    x_target_days IN NUMBER,
    x_sequence_ind IN VARCHAR2,
    x_business_days_ind IN VARCHAR2,
    x_closed_ind IN VARCHAR2,
    x_publish_ind IN VARCHAR2 DEFAULT 'N',
    x_mode IN VARCHAR2 DEFAULT 'R'
  ) AS

    x_last_update_date DATE;

Line: 521

    x_last_updated_by NUMBER;

Line: 522

    x_last_update_login NUMBER;

Line: 525

    x_last_update_date := SYSDATE;

Line: 527

      x_last_updated_by := 1;

Line: 528

      x_last_update_login := 0;

Line: 530

      x_last_updated_by := fnd_global.user_id;

Line: 531

      IF x_last_updated_by IS NULL THEN
        x_last_updated_by := -1;

Line: 534

      x_last_update_login :=fnd_global.login_id;

Line: 535

      IF x_last_update_login IS NULL THEN
        x_last_update_login := -1;

Line: 544

    before_dml(p_action =>'UPDATE',
      x_rowid =>x_rowid,
      x_tracking_type => x_tracking_type,
      x_description => x_description,
      x_s_tracking_type => x_s_tracking_type,
      x_target_days => x_target_days,
      x_sequence_ind => x_sequence_ind,
      x_business_days_ind => x_business_days_ind,
      x_closed_ind => x_closed_ind,
      x_publish_ind => x_publish_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: 561

    UPDATE igs_tr_type_all SET
      description = new_references.description,
      s_tracking_type = new_references.s_tracking_type,
      target_days = new_references.target_days,
      sequence_ind = new_references.sequence_ind,
      business_days_ind = new_references.business_days_ind,
      closed_ind = new_references.closed_ind,
      publish_ind = new_references.publish_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: 579

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

Line: 583

  END update_row;

Line: 600

      SELECT ROWID
      FROM   igs_tr_type_all
      WHERE  tracking_type = x_tracking_type;

Line: 611

      insert_row (
        x_rowid,
        x_tracking_type,
        x_description,
        x_s_tracking_type,
        x_target_days,
        x_sequence_ind,
        x_business_days_ind,
        x_closed_ind,
        x_publish_ind,
        x_mode,
        x_org_id
      );

Line: 628

    update_row (
      x_rowid,
      x_tracking_type,
      x_description,
      x_s_tracking_type,
      x_target_days,
      x_sequence_ind,
      x_business_days_ind,
      x_closed_ind,
      x_publish_ind,
      x_mode);