APPS.IGS_AD_WF_001 SQL Statements

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

Line: 24

      SELECT  FND_PROFILE.VALUE('IGS_WF_ENABLE') value
      FROM dual;

Line: 29

      SELECT igs_ad_acadindex_wf_s.NEXTVAL
      FROM sys.dual;

Line: 35

      SELECT person_number, full_name
      FROM igs_pe_person_base_v
      WHERE person_id = p_person_id;

Line: 40

      SELECT application_id
      FROM igs_ad_appl
      WHERE person_id = p_person_id
      AND admission_appl_number = p_admission_appl_number;

Line: 46

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 100

      l_parameter_list.DELETE;

Line: 144

      SELECT igs_ad_wf_req_submit_s.NEXTVAL
      FROM sys.dual;

Line: 149

      SELECT person_number, full_name
      FROM igs_pe_person_base_v
      WHERE person_id = p_person_id;

Line: 154

      SELECT application_id
      FROM igs_ad_appl
      WHERE person_id = p_person_id
      AND admission_appl_number = p_admission_appl_number;

Line: 160

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 228

    l_parameter_list.DELETE;

Line: 264

          SELECT
          IGS_AD_WF_TXCPT_S.NEXTVAL
          FROM     SYS.DUAL;

Line: 293

     l_parameter_list.DELETE;

Line: 316

      SELECT igs_ad_wf_tstscr_crt_s.NEXTVAL
      FROM sys.dual;

Line: 320

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 349

	l_parameter_list.DELETE;

Line: 379

      SELECT igs_ad_wf_tstseg_crt_s.NEXTVAL
      FROM sys.dual;

Line: 383

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 414

	l_parameter_list.DELETE;

Line: 446

      SELECT igs_ad_wf_tstscr_upd_s.NEXTVAL
      FROM sys.dual;

Line: 450

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 488

	l_parameter_list.DELETE;

Line: 515

      SELECT igs_ad_wf_tstseg_upd_s.NEXTVAL
      FROM sys.dual;

Line: 519

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 552

	l_parameter_list.DELETE;

Line: 578

      SELECT igs_ad_wf_acadhist_crt_s.NEXTVAL
      FROM sys.dual;

Line: 582

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 612

	l_parameter_list.DELETE;

Line: 640

      SELECT igs_ad_wf_acadhist_upd_s.NEXTVAL
      FROM sys.dual;

Line: 644

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 676

	l_parameter_list.DELETE;

Line: 704

      SELECT igs_ad_wf_txcpt_upd_s.NEXTVAL
      FROM sys.dual;

Line: 708

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 742

	l_parameter_list.DELETE;

Line: 769

      SELECT igs_ad_wf_applcomp_upd_s.NEXTVAL
      FROM sys.dual;

Line: 773

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 807

	l_parameter_list.DELETE;

Line: 833

      SELECT IGS_AD_WF_ENTQUAL_UPD_S.NEXTVAL
      FROM sys.dual;

Line: 837

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 870

	l_parameter_list.DELETE;

Line: 898

      SELECT IGS_AD_WF_LATEFEE_UPD_S.NEXTVAL
      FROM sys.dual;

Line: 902

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 937

	l_parameter_list.DELETE;

Line: 963

      SELECT IGS_AD_WF_CNDOFFER_UPD_S.NEXTVAL
      FROM sys.dual;

Line: 967

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 1001

	l_parameter_list.DELETE;

Line: 1029

      SELECT IGS_AD_WF_OFER_DEFER_UPD_S.NEXTVAL
      FROM sys.dual;

Line: 1033

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 1069

	l_parameter_list.DELETE;

Line: 1094

      SELECT IGS_AD_WF_WAITLIST_UPD_S.NEXTVAL
      FROM sys.dual;

Line: 1098

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 1133

	l_parameter_list.DELETE;

Line: 1222

      SELECT IGS_AD_WF_CRT_APPL_S.NEXTVAL
      FROM sys.dual;

Line: 1226

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 1231

      SELECT  FND_PROFILE.VALUE('IGS_WF_ENABLE') value
      FROM dual;

Line: 1263

    igs_ge_msg_stack.delete_msg(l_msg_idx_start);

Line: 1359

	l_parameter_list.DELETE;

Line: 1408

      SELECT IGS_AD_WF_ASSREQ_S.NEXTVAL
      FROM sys.dual;

Line: 1412

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 1444

	l_parameter_list.DELETE;

Line: 1468

      SELECT IGS_AD_WF_FEE_PAY_CRT_S.NEXTVAL
      FROM sys.dual;

Line: 1472

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 1505

	l_parameter_list.DELETE;

Line: 1530

      SELECT IGS_AD_WF_FEE_PAY_UPD_S.NEXTVAL
      FROM sys.dual;

Line: 1534

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 1568

	l_parameter_list.DELETE;

Line: 1591

      SELECT IGS_AD_WF_APP_PROC_STAT_UPD_S.NEXTVAL
      FROM sys.dual;

Line: 1595

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 1622

	l_parameter_list.DELETE;

Line: 1647

      SELECT IGS_AD_WF_APP_INST_STAT_UPD_S.NEXTVAL
      FROM sys.dual;

Line: 1651

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 1680

	l_parameter_list.DELETE;

Line: 1705

      SELECT IGS_AD_WF_APP_RECONS_REQ_S.NEXTVAL
      FROM sys.dual;

Line: 1709

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 1738

	l_parameter_list.DELETE;

Line: 1772

      SELECT IGS_AD_WF_APP_RECONS_REQ_S.NEXTVAL
      FROM sys.dual;

Line: 1776

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 1814

	l_parameter_list.DELETE;

Line: 1842

      SELECT IGS_AD_WF_APP_QUAL_CODE_S.NEXTVAL
      FROM sys.dual;

Line: 1846

      SELECT user_name
      FROM fnd_user
      WHERE user_id = fnd_global.user_id;

Line: 1878

	l_parameter_list.DELETE;

Line: 1901

      SELECT IGS_AD_BE_PRESUB_APPL_S.NEXTVAL
      FROM sys.dual;

Line: 1925

    l_parameter_list.DELETE;