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_AD_ASSIGN_REVIEW_GRP SQL Statements

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

Line: 34


    SELECT appl_rev_profile_gr_cd,site_use_code,review_profile_name
    FROM igs_ad_apl_rev_prf_all
    WHERE appl_rev_profile_id = cp_appl_rev_profile_id;

Line: 41


    SELECT appl_revprof_revgr_id,revprof_revgr_cd,revprof_revgr_name
    FROM igs_ad_apl_rprf_rgr
    WHERE appl_rev_profile_id = cp_appl_rev_profile_id
    ORDER BY appl_revprof_revgr_id;

Line: 49


    SELECT *
    FROM igs_ad_rvgr_inc_exc
    WHERE appl_revprof_revgr_id = cp_appl_revprof_revgr_id
    AND incl_excl_ind = cp_incl_excl_ind;

Line: 59


    SELECT *
    FROM igs_ad_rvgr_inc_exc
    WHERE appl_revprof_revgr_id = cp_appl_revprof_revgr_id ;

Line: 67


    SELECT rowid,arp.*
    FROM igs_ad_appl_arp arp
    WHERE person_id = cp_person_id
    AND admission_appl_number = cp_admission_appl_number
    AND nominated_course_cd = cp_nominated_course_cd
    AND sequence_number = cp_sequence_number;

Line: 207


        fnd_dsql.add_text('SELECT apl.person_id,apl.admission_appl_number,apl.nominated_course_cd,apl.sequence_number ');

Line: 294


		fnd_dsql.add_text(' AND pe.person_last_name IN ( ( SELECT person_last_name ');

Line: 328


		fnd_dsql.add_text(' MINUS  ( SELECT person_last_name FROM hz_parties WHERE ');

Line: 361


		fnd_dsql.add_text(' AND pe.person_last_name IN ( SELECT person_last_name ');

Line: 417


	     -- Insert Using TableHandler
	     lv_rowid := NULL;

Line: 420


             igs_ad_appl_arp_pkg.insert_row (
		   x_rowid => lv_rowid,
		   x_appl_arp_id => lv_appl_arp_id,
		   x_person_id => l_person_id,
		   x_admission_appl_number => l_admission_appl_number,
		   x_nominated_course_cd => l_nominated_course_cd,
		   x_sequence_number     => l_sequence_number,
		   x_appl_rev_profile_id => p_appl_rev_profile_id,
                   x_appl_revprof_revgr_id => c_appl_revprof_revgr_rec.appl_revprof_revgr_id,
                   x_mode => 'R');

Line: 438


	     -- Update Using Table Handler
	     igs_ad_appl_arp_pkg.update_row (
		   x_rowid => c_arp_rec_found_rec.rowid,
		   x_appl_arp_id => c_arp_rec_found_rec.appl_arp_id,
		   x_person_id => c_arp_rec_found_rec.person_id,
		   x_admission_appl_number => c_arp_rec_found_rec.admission_appl_number,
		   x_nominated_course_cd => c_arp_rec_found_rec.nominated_course_cd,
		   x_sequence_number     => c_arp_rec_found_rec.sequence_number,
		   x_appl_rev_profile_id => p_appl_rev_profile_id,
                   x_appl_revprof_revgr_id => c_appl_revprof_revgr_rec.appl_revprof_revgr_id,
                   x_mode => 'R');

Line: 498


	fnd_dsql.add_text('SELECT apl.person_id,apl.admission_appl_number, apl.nominated_course_cd, apl.sequence_number, addr.country, addr.state ,addr.postal_code');

Line: 788


	      -- Insert Using TableHandler
	      lv_rowid := NULL;

Line: 791


	      igs_ad_appl_arp_pkg.insert_row (
		   x_rowid => lv_rowid,
		   x_appl_arp_id => lv_appl_arp_id,
		   x_person_id => l_person_id,
		   x_admission_appl_number => l_admission_appl_number,
		   x_nominated_course_cd => l_nominated_course_cd,
		   x_sequence_number     => l_sequence_number,
		   x_appl_rev_profile_id => p_appl_rev_profile_id,
                   x_appl_revprof_revgr_id => c_appl_revprof_revgr_rec.appl_revprof_revgr_id,
                   x_mode => 'R');

Line: 810


	      -- Update Using Table Handler
	      igs_ad_appl_arp_pkg.update_row (
		   x_rowid => c_arp_rec_found_rec.rowid,
		   x_appl_arp_id => c_arp_rec_found_rec.appl_arp_id,
		   x_person_id => c_arp_rec_found_rec.person_id,
		   x_admission_appl_number => c_arp_rec_found_rec.admission_appl_number,
		   x_nominated_course_cd => c_arp_rec_found_rec.nominated_course_cd,
		   x_sequence_number     => c_arp_rec_found_rec.sequence_number,
		   x_appl_rev_profile_id => p_appl_rev_profile_id,
                   x_appl_revprof_revgr_id => c_appl_revprof_revgr_rec.appl_revprof_revgr_id,
                   x_mode => 'R');

Line: 870


	fnd_dsql.add_text(' SELECT apl.person_id,apl.admission_appl_number, apl.nominated_course_cd, apl.sequence_number , addr.country_cd, addr.state, addr.postal_code ');

Line: 1160


	       -- Insert Using TableHandler
	      lv_rowid := NULL;

Line: 1163


	      igs_ad_appl_arp_pkg.insert_row (
		   x_rowid => lv_rowid,
		   x_appl_arp_id => lv_appl_arp_id,
		   x_person_id => l_person_id,
		   x_admission_appl_number => l_admission_appl_number,
		   x_nominated_course_cd => l_nominated_course_cd,
		   x_sequence_number     => l_sequence_number,
		   x_appl_rev_profile_id => p_appl_rev_profile_id,
                   x_appl_revprof_revgr_id => c_appl_revprof_revgr_rec.appl_revprof_revgr_id,
                   x_mode => 'R');

Line: 1183


	       -- Update Using Table Handler
	      igs_ad_appl_arp_pkg.update_row (
		   x_rowid => c_arp_rec_found_rec.rowid,
		   x_appl_arp_id => c_arp_rec_found_rec.appl_arp_id,
		   x_person_id => c_arp_rec_found_rec.person_id,
		   x_admission_appl_number => c_arp_rec_found_rec.admission_appl_number,
		   x_nominated_course_cd => c_arp_rec_found_rec.nominated_course_cd,
		   x_sequence_number     => c_arp_rec_found_rec.sequence_number,
		   x_appl_rev_profile_id => p_appl_rev_profile_id,
                   x_appl_revprof_revgr_id => c_appl_revprof_revgr_rec.appl_revprof_revgr_id,
                   x_mode => 'R');

Line: 1244


	fnd_dsql.add_text(' SELECT apl.person_id,apl.admission_appl_number, apl.nominated_course_cd, apl.sequence_number ');

Line: 1331


	         fnd_dsql.add_text(' AND php.inst_eps_code IN ( ( SELECT inst_eps_code ');

Line: 1365


		fnd_dsql.add_text(' MINUS  ( SELECT inst_eps_code FROM igs_pe_hz_parties WHERE ');

Line: 1398


		fnd_dsql.add_text(' AND php.inst_eps_code IN ( SELECT inst_eps_code ');

Line: 1461


	    -- Insert Using TableHandler
	      lv_rowid := NULL;

Line: 1464


	      igs_ad_appl_arp_pkg.insert_row (
	           x_rowid => lv_rowid,
	           x_appl_arp_id => lv_appl_arp_id,
		   x_person_id => l_person_id,
		   x_admission_appl_number => l_admission_appl_number,
		   x_nominated_course_cd => l_nominated_course_cd,
		   x_sequence_number     => l_sequence_number,
		   x_appl_rev_profile_id => p_appl_rev_profile_id,
                   x_appl_revprof_revgr_id => c_appl_revprof_revgr_rec.appl_revprof_revgr_id,
                   x_mode => 'R');

Line: 1483


	    -- Update Using Table Handler
	      igs_ad_appl_arp_pkg.update_row (
		   x_rowid => c_arp_rec_found_rec.rowid,
		   x_appl_arp_id => c_arp_rec_found_rec.appl_arp_id,
		   x_person_id => c_arp_rec_found_rec.person_id,
		   x_admission_appl_number => c_arp_rec_found_rec.admission_appl_number,
		   x_nominated_course_cd => c_arp_rec_found_rec.nominated_course_cd,
		   x_sequence_number     => c_arp_rec_found_rec.sequence_number,
		   x_appl_rev_profile_id => p_appl_rev_profile_id,
                   x_appl_revprof_revgr_id => c_appl_revprof_revgr_rec.appl_revprof_revgr_id,
                   x_mode => 'R');

Line: 1546


	fnd_dsql.add_text(' SELECT apl.person_id,apl.admission_appl_number, apl.nominated_course_cd, apl.sequence_number ');

Line: 1684


	    -- Insert Using TableHandler
	    lv_rowid := NULL;

Line: 1687


	    igs_ad_appl_arp_pkg.insert_row (
		   x_rowid => lv_rowid,
		   x_appl_arp_id => lv_appl_arp_id,
		   x_person_id => l_person_id,
		   x_admission_appl_number => l_admission_appl_number,
		   x_nominated_course_cd => l_nominated_course_cd,
		   x_sequence_number     => l_sequence_number,
		   x_appl_rev_profile_id => p_appl_rev_profile_id,
                   x_appl_revprof_revgr_id => c_appl_revprof_revgr_rec.appl_revprof_revgr_id,
                   x_mode => 'R');

Line: 1707


	   -- Update Using Table Handler
	   igs_ad_appl_arp_pkg.update_row (
		   x_rowid => c_arp_rec_found_rec.rowid,
		   x_appl_arp_id => c_arp_rec_found_rec.appl_arp_id,
		   x_person_id => c_arp_rec_found_rec.person_id,
		   x_admission_appl_number => c_arp_rec_found_rec.admission_appl_number,
		   x_nominated_course_cd => c_arp_rec_found_rec.nominated_course_cd,
		   x_sequence_number     => c_arp_rec_found_rec.sequence_number,
		   x_appl_rev_profile_id => p_appl_rev_profile_id,
                   x_appl_revprof_revgr_id => c_appl_revprof_revgr_rec.appl_revprof_revgr_id,
                   x_mode => 'R');

Line: 1771


	fnd_dsql.add_text('SELECT apl.person_id,apl.admission_appl_number, apl.nominated_course_cd, apl.sequence_number ' );

Line: 1903


	   -- Insert Using TableHandler
	   lv_rowid := NULL;

Line: 1906


	   igs_ad_appl_arp_pkg.insert_row (
		   x_rowid => lv_rowid,
		   x_appl_arp_id => lv_appl_arp_id,
		   x_person_id => l_person_id,
		   x_admission_appl_number => l_admission_appl_number,
		   x_nominated_course_cd => l_nominated_course_cd,
		   x_sequence_number     => l_sequence_number,
		   x_appl_rev_profile_id => p_appl_rev_profile_id,
                   x_appl_revprof_revgr_id => c_appl_revprof_revgr_rec.appl_revprof_revgr_id,
                   x_mode => 'R');

Line: 1926


	    -- Update Using Table Handler
	    igs_ad_appl_arp_pkg.update_row (
		   x_rowid => c_arp_rec_found_rec.rowid,
		   x_appl_arp_id => c_arp_rec_found_rec.appl_arp_id,
		   x_person_id => c_arp_rec_found_rec.person_id,
		   x_admission_appl_number => c_arp_rec_found_rec.admission_appl_number,
		   x_nominated_course_cd => c_arp_rec_found_rec.nominated_course_cd,
		   x_sequence_number     => c_arp_rec_found_rec.sequence_number,
		   x_appl_rev_profile_id => p_appl_rev_profile_id,
                   x_appl_revprof_revgr_id => c_appl_revprof_revgr_rec.appl_revprof_revgr_id,
                   x_mode => 'R');