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

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 242: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

238: Who When What
239: skoppula 2002/07/09 FACR09
240: (reverse chronological order - newest change first)
241: ***************************************************************/
242: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
243: l_acad_sequence igs_ca_inst.sequence_number%TYPE;
244:
245: CURSOR c_get_acad_cal IS
246: SELECT ci.cal_type cal_type,

Line 243: l_acad_sequence igs_ca_inst.sequence_number%TYPE;

239: skoppula 2002/07/09 FACR09
240: (reverse chronological order - newest change first)
241: ***************************************************************/
242: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
243: l_acad_sequence igs_ca_inst.sequence_number%TYPE;
244:
245: CURSOR c_get_acad_cal IS
246: SELECT ci.cal_type cal_type,
247: ci.sequence_number sequence_number,

Line 249: FROM igs_ca_inst ci

245: CURSOR c_get_acad_cal IS
246: SELECT ci.cal_type cal_type,
247: ci.sequence_number sequence_number,
248: ci.alternate_code alternate_code
249: FROM igs_ca_inst ci
250: WHERE ci.cal_type = l_acad_cal_type
251: AND ci.sequence_number = l_acad_sequence;
252:
253: l_adm_cal_type igs_ca_inst.cal_type%TYPE;

Line 253: l_adm_cal_type igs_ca_inst.cal_type%TYPE;

249: FROM igs_ca_inst ci
250: WHERE ci.cal_type = l_acad_cal_type
251: AND ci.sequence_number = l_acad_sequence;
252:
253: l_adm_cal_type igs_ca_inst.cal_type%TYPE;
254: l_adm_sequence igs_ca_inst.sequence_number%TYPE;
255: l_adm_alternate_cd igs_ca_inst.alternate_code%TYPE;
256: l_message VARCHAR2(2000);
257:

Line 254: l_adm_sequence igs_ca_inst.sequence_number%TYPE;

250: WHERE ci.cal_type = l_acad_cal_type
251: AND ci.sequence_number = l_acad_sequence;
252:
253: l_adm_cal_type igs_ca_inst.cal_type%TYPE;
254: l_adm_sequence igs_ca_inst.sequence_number%TYPE;
255: l_adm_alternate_cd igs_ca_inst.alternate_code%TYPE;
256: l_message VARCHAR2(2000);
257:
258: BEGIN

Line 255: l_adm_alternate_cd igs_ca_inst.alternate_code%TYPE;

251: AND ci.sequence_number = l_acad_sequence;
252:
253: l_adm_cal_type igs_ca_inst.cal_type%TYPE;
254: l_adm_sequence igs_ca_inst.sequence_number%TYPE;
255: l_adm_alternate_cd igs_ca_inst.alternate_code%TYPE;
256: l_message VARCHAR2(2000);
257:
258: BEGIN
259:

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 303: FROM igs_ca_inst ci,

299: CURSOR c_get_awd_cal IS
300: SELECT ci.cal_type cal_type,
301: ci.sequence_number sequence_number,
302: ci.alternate_code alternate_code
303: FROM igs_ca_inst ci,
304: igs_ca_type ct,
305: igs_ca_stat st
306: WHERE ct.s_cal_cat = 'AWARD'
307: AND ct.cal_type = ci.cal_type

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 368: lv_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL;

364:
365: (reverse chronological order - newest change first)
366: ***************************************************************/
367:
368: lv_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL;
369: lv_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL;
370: lv_alt_code igs_ca_inst.alternate_code%TYPE DEFAULT NULL;
371:
372: lv_person_id hz_parties.party_id%TYPE;

Line 369: lv_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL;

365: (reverse chronological order - newest change first)
366: ***************************************************************/
367:
368: lv_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL;
369: lv_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL;
370: lv_alt_code igs_ca_inst.alternate_code%TYPE DEFAULT NULL;
371:
372: lv_person_id hz_parties.party_id%TYPE;
373: lv_appl_sel_order VARCHAR2(30);

Line 370: lv_alt_code igs_ca_inst.alternate_code%TYPE DEFAULT NULL;

366: ***************************************************************/
367:
368: lv_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL;
369: lv_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL;
370: lv_alt_code igs_ca_inst.alternate_code%TYPE DEFAULT NULL;
371:
372: lv_person_id hz_parties.party_id%TYPE;
373: lv_appl_sel_order VARCHAR2(30);
374:

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: /*************************************************************