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 dependencies on IGS_AD_PS_APPL_INST_ALL

Line 75: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

71: AND nominated_course_cd = cp_nominated_course_cd
72: AND sequence_number = cp_sequence_number;
73:
74: TYPE rec_persondetail IS RECORD (
75: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
76: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
77: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
78: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);
79:

Line 76: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

72: AND sequence_number = cp_sequence_number;
73:
74: TYPE rec_persondetail IS RECORD (
75: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
76: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
77: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
78: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);
79:
80: TYPE rec_persondet_addr IS RECORD (

Line 77: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

73:
74: TYPE rec_persondetail IS RECORD (
75: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
76: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
77: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
78: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);
79:
80: TYPE rec_persondet_addr IS RECORD (
81: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

Line 78: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);

74: TYPE rec_persondetail IS RECORD (
75: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
76: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
77: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
78: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);
79:
80: TYPE rec_persondet_addr IS RECORD (
81: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
82: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

Line 81: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

77: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
78: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);
79:
80: TYPE rec_persondet_addr IS RECORD (
81: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
82: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
83: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
84: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
85: country igs_or_inst_addr.country%TYPE,

Line 82: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

78: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);
79:
80: TYPE rec_persondet_addr IS RECORD (
81: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
82: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
83: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
84: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
85: country igs_or_inst_addr.country%TYPE,
86: state igs_or_inst_addr.state%TYPE,

Line 83: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

79:
80: TYPE rec_persondet_addr IS RECORD (
81: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
82: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
83: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
84: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
85: country igs_or_inst_addr.country%TYPE,
86: state igs_or_inst_addr.state%TYPE,
87: postal_code igs_or_inst_addr.postal_code%TYPE);

Line 84: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,

80: TYPE rec_persondet_addr IS RECORD (
81: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
82: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
83: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
84: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
85: country igs_or_inst_addr.country%TYPE,
86: state igs_or_inst_addr.state%TYPE,
87: postal_code igs_or_inst_addr.postal_code%TYPE);
88:

Line 111: l_person_id igs_ad_ps_appl_inst_all.person_id%TYPE;

107: l_count_incl_excl NUMBER :=0;
108: l_percentage_symbol CONSTANT VARCHAR2(1) :='%';
109: l_cursor_id NUMBER(15);
110: l_num_of_rows NUMBER(10);
111: l_person_id igs_ad_ps_appl_inst_all.person_id%TYPE;
112: l_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE;
113: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
114: l_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;
115: l_debug VARCHAR2(4000);

Line 112: l_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE;

108: l_percentage_symbol CONSTANT VARCHAR2(1) :='%';
109: l_cursor_id NUMBER(15);
110: l_num_of_rows NUMBER(10);
111: l_person_id igs_ad_ps_appl_inst_all.person_id%TYPE;
112: l_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE;
113: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
114: l_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;
115: l_debug VARCHAR2(4000);
116:

Line 113: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;

109: l_cursor_id NUMBER(15);
110: l_num_of_rows NUMBER(10);
111: l_person_id igs_ad_ps_appl_inst_all.person_id%TYPE;
112: l_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE;
113: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
114: l_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;
115: l_debug VARCHAR2(4000);
116:
117:

Line 114: l_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;

110: l_num_of_rows NUMBER(10);
111: l_person_id igs_ad_ps_appl_inst_all.person_id%TYPE;
112: l_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE;
113: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
114: l_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;
115: l_debug VARCHAR2(4000);
116:
117:
118: l_admission_cat igs_ad_appl_all.admission_cat%TYPE;

Line 208: fnd_dsql.add_text('FROM hz_parties pe, igs_ad_ps_appl_inst_all apl, igs_ad_appl_all app,igs_ad_doc_stat doc, igs_ad_ou_stat ou ');

204: CLOSE c_revgr_incl_excl;
205:
206: fnd_dsql.init;
207: fnd_dsql.add_text('SELECT apl.person_id,apl.admission_appl_number,apl.nominated_course_cd,apl.sequence_number ');
208: fnd_dsql.add_text('FROM hz_parties pe, igs_ad_ps_appl_inst_all apl, igs_ad_appl_all app,igs_ad_doc_stat doc, igs_ad_ou_stat ou ');
209: fnd_dsql.add_text('WHERE pe.party_id = apl.person_id AND doc.s_adm_doc_status = ');
210: fnd_dsql.add_bind(l_satisfied);
211: fnd_dsql.add_text(' AND ou.s_adm_outcome_status = ');
212: fnd_dsql.add_bind(l_pending);

Line 499: fnd_dsql.add_text(' FROM igs_pe_hz_parties hp, igs_ad_ps_appl_inst_all apl, igs_ad_appl_all app, igs_ad_doc_stat doc, igs_ad_ou_stat ou, igs_or_inst_addr addr, igs_ad_acad_history_v aah ');

495: CLOSE c_revgr_addr;
496:
497: fnd_dsql.init;
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');
499: fnd_dsql.add_text(' FROM igs_pe_hz_parties hp, igs_ad_ps_appl_inst_all apl, igs_ad_appl_all app, igs_ad_doc_stat doc, igs_ad_ou_stat ou, igs_or_inst_addr addr, igs_ad_acad_history_v aah ');
500: fnd_dsql.add_text(' WHERE hp.party_id = apl.person_id AND hp.party_id = aah.person_id AND aah.CURRENT_INST = ');
501: fnd_dsql.add_bind('Y');
502: fnd_dsql.add_text(' AND aah.institution_code = addr.institution_cd AND addr.addr_type = ' );
503: fnd_dsql.add_bind(c_appl_revprof_group_cd_rec.site_use_code);

Line 871: fnd_dsql.add_text(' FROM hz_parties hp, hz_party_site_uses psu, igs_ad_ps_appl_inst_all apl, igs_ad_appl_all app, igs_ad_doc_stat doc, igs_ad_ou_stat ou, igs_pe_addr_v addr ');

867:
868:
869: fnd_dsql.init;
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 ');
871: fnd_dsql.add_text(' FROM hz_parties hp, hz_party_site_uses psu, igs_ad_ps_appl_inst_all apl, igs_ad_appl_all app, igs_ad_doc_stat doc, igs_ad_ou_stat ou, igs_pe_addr_v addr ');
872: fnd_dsql.add_text(' WHERE hp.party_id = apl.person_id AND hp.party_id = addr.person_id AND addr.party_site_id = psu.party_site_id AND psu.site_use_type = ');
873: fnd_dsql.add_bind(c_appl_revprof_group_cd_rec.site_use_code);
874: fnd_dsql.add_text(' AND doc.s_adm_doc_status = ' );
875: fnd_dsql.add_bind(l_satisfied);

Line 1245: fnd_dsql.add_text(' FROM hz_parties hp, igs_ad_ps_appl_inst_all apl, igs_ad_appl_all app, igs_ad_doc_stat doc, igs_ad_ou_stat ou, igs_pe_hz_parties php, igs_ad_acad_history_v aah ');

1241:
1242:
1243: fnd_dsql.init;
1244: fnd_dsql.add_text(' SELECT apl.person_id,apl.admission_appl_number, apl.nominated_course_cd, apl.sequence_number ');
1245: fnd_dsql.add_text(' FROM hz_parties hp, igs_ad_ps_appl_inst_all apl, igs_ad_appl_all app, igs_ad_doc_stat doc, igs_ad_ou_stat ou, igs_pe_hz_parties php, igs_ad_acad_history_v aah ');
1246: fnd_dsql.add_text(' WHERE aah.person_id = apl.person_id AND aah.CURRENT_INST = ');
1247: fnd_dsql.add_bind('Y');
1248: fnd_dsql.add_text(' AND aah.institution_code = php.oss_org_unit_cd AND doc.s_adm_doc_status = ' );
1249: fnd_dsql.add_bind(l_satisfied);

Line 1547: fnd_dsql.add_text(' FROM igs_ad_ps_appl_inst_all apl, igs_ad_appl_all app, igs_ad_doc_stat doc, igs_ad_ou_stat ou ');

1543:
1544:
1545: fnd_dsql.init;
1546: fnd_dsql.add_text(' SELECT apl.person_id,apl.admission_appl_number, apl.nominated_course_cd, apl.sequence_number ');
1547: fnd_dsql.add_text(' FROM igs_ad_ps_appl_inst_all apl, igs_ad_appl_all app, igs_ad_doc_stat doc, igs_ad_ou_stat ou ');
1548: fnd_dsql.add_text(' WHERE doc.s_adm_doc_status = ');
1549: fnd_dsql.add_bind(l_satisfied);
1550: fnd_dsql.add_text(' AND ou.s_adm_outcome_status = ');
1551: fnd_dsql.add_bind(l_pending);

Line 1772: fnd_dsql.add_text(' FROM igs_ps_ver_all pva, igs_ad_ps_appl_inst_all apl, igs_ad_appl_all app, igs_ad_doc_stat doc, igs_ad_ou_stat ou ');

1768:
1769:
1770: fnd_dsql.init;
1771: fnd_dsql.add_text('SELECT apl.person_id,apl.admission_appl_number, apl.nominated_course_cd, apl.sequence_number ' );
1772: fnd_dsql.add_text(' FROM igs_ps_ver_all pva, igs_ad_ps_appl_inst_all apl, igs_ad_appl_all app, igs_ad_doc_stat doc, igs_ad_ou_stat ou ');
1773: fnd_dsql.add_text(' WHERE pva.course_cd = apl.nominated_course_cd AND doc.s_adm_doc_status = ' );
1774: fnd_dsql.add_bind(l_satisfied);
1775: fnd_dsql.add_text(' AND ou.s_adm_outcome_status = ' );
1776: fnd_dsql.add_bind(l_pending);