APPS.IGS_PS_VAL_AM SQL Statements

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

Line: 14

  		SELECT 	closed_ind
  		FROM	IGS_PS_GOVT_ATD_MODE
  		WHERE	govt_attendance_mode = cp_govt_attendance_mode;

Line: 77

    SELECT catalog_version_id,
           catalog_version,
           description,
           closed_ind,
           catalog_schedule,
           created_by,
           creation_date,
           last_update_date,
           last_update_login,
           last_updated_by
    FROM IGS_PS_CATLG_VERS
    WHERE catalog_version = p_sch_version
    AND catalog_schedule = 'SCHEDULE';

Line: 92

    SELECT catalog_note_id,
           catalog_version_id,
           note_type_id,
           create_date,
           end_date,
           SEQUENCE,
           note_text,
           created_by,
           creation_date,
           last_update_date,
           last_update_login,
           last_updated_by
         FROM IGS_PS_CATLG_NOTES
    WHERE catalog_version_id = p_sch_version_id;

Line: 110

    SELECT ROWID,
	       catalog_note_id,
           catalog_version_id,
           note_type_id,
           create_date,
           end_date,
           SEQUENCE,
           note_text,
           created_by,
           creation_date,
           last_update_date,
           last_update_login,
           last_updated_by
    FROM IGS_PS_CATLG_NOTES
    WHERE catalog_version_id = p_sch_version_id
    AND note_type_id = p_note_type_id
    AND SEQUENCE = p_sequence
    FOR UPDATE NOWAIT;

Line: 182

	  igs_ps_catlg_vers_pkg.insert_row(
	    x_rowid               =>  lv_rowid,
	    x_catalog_version_id  =>  lv_new_sch_version_id,
	    x_catalog_version     =>  p_new_sch_version,
	    x_description         =>  v_sel_sch_vers.description,
	    x_closed_ind          =>  v_sel_sch_vers.closed_ind,
	    x_catalog_schedule    =>  v_sel_sch_vers.catalog_schedule,
	    x_mode	      	  =>  'R',
	    x_org_id              =>  p_org_id);

Line: 217

      igs_ps_catlg_notes_pkg.insert_row(
        x_rowid  => lv_rowid,
        x_catalog_note_id =>  lv_sch_note_id,
        x_catalog_version_id => lv_new_sch_version_id,
        x_note_type_id => v_sel_old_sch_notes.note_type_id,
        x_create_date => v_sel_old_sch_notes.create_date,
        x_end_date  => v_sel_old_sch_notes.end_date,
        x_sequence => v_sel_old_sch_notes.SEQUENCE,
        x_note_text => v_sel_old_sch_notes.note_text,
        x_mode => 'R',
        x_org_id  => p_org_id );

Line: 237

       igs_ps_catlg_notes_pkg.update_row(
        x_rowid  => v_sel_new_sch_notes.ROWID,
        x_catalog_note_id =>  v_sel_new_sch_notes.catalog_note_id,
        x_catalog_version_id => v_sel_new_sch_notes.catalog_version_id,
        x_note_type_id => v_sel_new_sch_notes.note_type_id,
        x_create_date => v_sel_new_sch_notes.create_date,
        x_end_date  => v_sel_new_sch_notes.end_date,
        x_sequence => v_sel_new_sch_notes.SEQUENCE,
        x_note_text => v_sel_old_sch_notes.note_text,
        x_mode => 'R');