APPS.IGS_LOOKUPS_VIEW_PKG SQL Statements

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

Line: 35

    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_system_mandatory_ind IN VARCHAR2 DEFAULT NULL,
    x_default_display_seq IN NUMBER DEFAULT NULL
  ) AS

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

Line: 55

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

Line: 57

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

Line: 86

    new_references.last_updated_by := x_last_updated_by;

Line: 87

    new_references.last_update_date := x_last_update_date;

Line: 88

    new_references.last_update_login := x_last_update_login;

Line: 89

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

Line: 96

    new_references.last_update_date := x_last_update_date;

Line: 97

    new_references.last_updated_by := x_last_updated_by;

Line: 98

    new_references.last_update_login := x_last_update_login;

Line: 475

      SELECT    1
      FROM     IGS_LOOKUPS_VIEW
      WHERE    LOOKUP_TYPE = x_LOOKUP_TYPE
      AND      LOOKUP_CODE = x_LOOKUP_CODE;

Line: 520

  cursor cur_rowid is SELECT rowid row_id
    FROM IGS_LOOKUPS_VAL
    WHERE LOOKUP_TYPE = X_LOOKUP_TYPE
    AND LOOKUP_CODE = X_LOOKUP_CODE;

Line: 558

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

Line: 563

  PROCEDURE update_row (
    x_rowid                             IN     VARCHAR2,
    x_lookup_type                       IN     VARCHAR2,
    x_lookup_code                       IN     VARCHAR2,
    x_closed_ind                        IN     VARCHAR2,
    x_security_allowed_ind              IN     VARCHAR2,
    x_step_type_restriction_num_in     IN     VARCHAR2,
    x_unit_outcome_ind                  IN     VARCHAR2,
    x_display_name                      IN     VARCHAR2,
    x_display_order                     IN     NUMBER,
    x_step_order_applicable_ind         IN     VARCHAR2,
    x_academic_transcript_ind           IN     VARCHAR2,
    x_cmpltn_requirements_ind           IN     VARCHAR2,
    x_fee_ass_ind                       IN     VARCHAR2,
    x_step_group_type                   IN     VARCHAR2,
    x_final_result_ind                  IN     VARCHAR2,
    x_system_generated_ind              IN     VARCHAR2,
    x_transaction_cat                   IN     VARCHAR2,
    x_encumbrance_level                 IN     NUMBER,
    x_open_for_enrollments              IN     VARCHAR2,
    x_system_calculated                 IN     VARCHAR2,
    x_system_mandatory_ind              IN     VARCHAR2,
    x_default_display_seq               IN     NUMBER,
    x_av_transcript_disp_options        IN     VARCHAR2,
    x_mode                              IN     VARCHAR2
  ) as

/*
  History
  who        when         what
  smvk       28-Aug-2002  Removed the default value of x_mode parameter as it gives 'File.Pkg.22' gscc warning.
			  as a part of SFCR005_Cleanup_Build (Enhancement Bug # 2531390).
*/


  cursor cur_rowid is SELECT rowid row_id
    FROM IGS_LOOKUPS_VAL
    WHERE LOOKUP_TYPE = X_LOOKUP_TYPE
    AND LOOKUP_CODE = X_LOOKUP_CODE;

Line: 609

      igs_lookups_val_pkg.update_row(
          x_rowid                             =>  row_val,
          x_lookup_type                       =>  x_lookup_type,
          x_lookup_code                       =>  x_lookup_code,
          x_closed_ind                        =>  x_closed_ind,
          x_security_allowed_ind              =>  x_security_allowed_ind,
          x_step_type_restriction_num_in     =>  x_step_type_restriction_num_in,
          x_unit_outcome_ind                  =>  x_unit_outcome_ind,
          x_display_name                      =>  x_display_name,
          x_display_order                     =>  x_display_order,
          x_step_order_applicable_ind         =>  x_step_order_applicable_ind,
          x_academic_transcript_ind           =>  x_academic_transcript_ind,
          x_cmpltn_requirements_ind           =>  x_cmpltn_requirements_ind,
          x_fee_ass_ind                       =>  x_fee_ass_ind,
          x_step_group_type                   =>  x_step_group_type,
          x_final_result_ind                  =>  x_final_result_ind,
          x_system_generated_ind              =>  x_system_generated_ind,
          x_transaction_cat                   =>  x_transaction_cat,
          x_encumbrance_level                 =>  x_encumbrance_level,
          x_open_for_enrollments              =>  x_open_for_enrollments,
          x_system_calculated                 =>  x_system_calculated,
          x_system_mandatory_ind              =>  x_system_mandatory_ind,
          x_default_display_seq               =>  x_default_display_seq,
          x_av_transcript_disp_options        =>  x_av_transcript_disp_options ,
          x_mode                              =>  'R' );

Line: 638

END UPDATE_ROW;