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.IGF_AP_OSS_INTEGR dependencies on IGS_CA_INST_ALL

Line 224: PROCEDURE get_acad_cal_from_awd(p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,

220:
221:
222:
223:
224: PROCEDURE get_acad_cal_from_awd(p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
225: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
226: p_acad_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
227: p_acad_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
228: p_acad_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE)

Line 225: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

221:
222:
223:
224: PROCEDURE get_acad_cal_from_awd(p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
225: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
226: p_acad_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
227: p_acad_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
228: p_acad_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE)
229: IS

Line 226: p_acad_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,

222:
223:
224: PROCEDURE get_acad_cal_from_awd(p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
225: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
226: p_acad_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
227: p_acad_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
228: p_acad_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE)
229: IS
230:

Line 227: p_acad_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,

223:
224: PROCEDURE get_acad_cal_from_awd(p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
225: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
226: p_acad_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
227: p_acad_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
228: p_acad_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE)
229: IS
230:
231: /*************************************************************

Line 228: p_acad_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE)

224: PROCEDURE get_acad_cal_from_awd(p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
225: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
226: p_acad_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
227: p_acad_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
228: p_acad_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE)
229: IS
230:
231: /*************************************************************
232: Created By : adhawan

Line 274: PROCEDURE get_awd_cal_from_acad(p_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,

270:
271: END get_acad_cal_from_awd;
272:
273:
274: PROCEDURE get_awd_cal_from_acad(p_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
275: p_acad_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
276: p_awd_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
277: p_awd_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
278: p_awd_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE)

Line 275: p_acad_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

271: END get_acad_cal_from_awd;
272:
273:
274: PROCEDURE get_awd_cal_from_acad(p_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
275: p_acad_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
276: p_awd_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
277: p_awd_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
278: p_awd_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE)
279: IS

Line 276: p_awd_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,

272:
273:
274: PROCEDURE get_awd_cal_from_acad(p_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
275: p_acad_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
276: p_awd_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
277: p_awd_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
278: p_awd_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE)
279: IS
280:

Line 277: p_awd_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,

273:
274: PROCEDURE get_awd_cal_from_acad(p_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
275: p_acad_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
276: p_awd_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
277: p_awd_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
278: p_awd_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE)
279: IS
280:
281: /*************************************************************

Line 278: p_awd_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE)

274: PROCEDURE get_awd_cal_from_acad(p_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
275: p_acad_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
276: p_awd_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
277: p_awd_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
278: p_awd_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE)
279: IS
280:
281: /*************************************************************
282: Created By : adhawan

Line 329: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,

325:
326:
327:
328: PROCEDURE get_adm_appl_details( p_person_id IN hz_parties.party_id%TYPE,
329: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
330: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
331: p_ad_appl_row_id OUT NOCOPY ROWID,
332: p_ad_prog_appl_row_id OUT NOCOPY ROWID,
333: p_adm_appl_number IN OUT NOCOPY igs_ad_appl_all.admission_appl_number%TYPE,

Line 330: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

326:
327:
328: PROCEDURE get_adm_appl_details( p_person_id IN hz_parties.party_id%TYPE,
329: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
330: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
331: p_ad_appl_row_id OUT NOCOPY ROWID,
332: p_ad_prog_appl_row_id OUT NOCOPY ROWID,
333: p_adm_appl_number IN OUT NOCOPY igs_ad_appl_all.admission_appl_number%TYPE,
334: p_course_cd IN OUT NOCOPY igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

Line 380: c_cal_type igs_ca_inst_all.cal_type%TYPE ,

376: --Added the NVL clauses for check against the Application Number,Course Code and Version Number
377: --as per the FACCR001 DLD
378:
379: CURSOR c_get_adm_appl_details(p_person_id hz_parties.party_id%TYPE,
380: c_cal_type igs_ca_inst_all.cal_type%TYPE ,
381: c_sequence_number igs_ca_inst_all.sequence_number%TYPE,
382: p_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE,
383: p_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
384: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE) IS

Line 381: c_sequence_number igs_ca_inst_all.sequence_number%TYPE,

377: --as per the FACCR001 DLD
378:
379: CURSOR c_get_adm_appl_details(p_person_id hz_parties.party_id%TYPE,
380: c_cal_type igs_ca_inst_all.cal_type%TYPE ,
381: c_sequence_number igs_ca_inst_all.sequence_number%TYPE,
382: p_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE,
383: p_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
384: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE) IS
385: SELECT aav.row_id appl_inst_row_id,

Line 486: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,

482:
483: END get_adm_appl_details;
484:
485: FUNCTION get_adm_appl_val(p_person_id IN hz_parties.party_id%TYPE,
486: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
487: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE)
488: RETURN ROWID
489: IS
490:

Line 487: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE)

483: END get_adm_appl_details;
484:
485: FUNCTION get_adm_appl_val(p_person_id IN hz_parties.party_id%TYPE,
486: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
487: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE)
488: RETURN ROWID
489: IS
490:
491: /*************************************************************

Line 535: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,

531:
532:
533:
534: FUNCTION get_adm_prog_appl_val(p_person_id IN hz_parties.party_id%TYPE,
535: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
536: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE)
537: RETURN ROWID
538: IS
539:

Line 536: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE)

532:
533:
534: FUNCTION get_adm_prog_appl_val(p_person_id IN hz_parties.party_id%TYPE,
535: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
536: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE)
537: RETURN ROWID
538: IS
539:
540: /*************************************************************