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_INT_RECONSIDER dependencies on IGS_AD_APPL

Line 4: FUNCTION copy_candidacy_records(p_new_admission_appl_number IGS_AD_APPL_ALL.admission_appl_number%TYPE,

1: PACKAGE BODY igs_ad_int_reconsider AS
2: /* $Header: IGSADD6B.pls 120.3 2006/05/26 07:17:44 pfotedar noship $ */
3:
4: FUNCTION copy_candidacy_records(p_new_admission_appl_number IGS_AD_APPL_ALL.admission_appl_number%TYPE,
5: p_new_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,
6: p_person_id HZ_PARTIES.party_id%TYPE,
7: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
8: p_old_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,

Line 7: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,

3:
4: FUNCTION copy_candidacy_records(p_new_admission_appl_number IGS_AD_APPL_ALL.admission_appl_number%TYPE,
5: p_new_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,
6: p_person_id HZ_PARTIES.party_id%TYPE,
7: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
8: p_old_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,
9: p_nominated_course_cd IGS_AD_PS_APPL_ALL.nominated_course_cd%TYPE,
10: p_start_dt DATE)
11: RETURN BOOLEAN AS

Line 420: p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,

416: END copy_candidacy_records;
417:
418:
419: FUNCTION copy_application_child_records (p_person_id HZ_PARTIES.party_id%TYPE,
420: p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
421: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
422: p_nominated_course_cd IGS_AD_PS_APPL_INST_ALL.nominated_course_cd%TYPE,
423: p_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE)
424: RETURN BOOLEAN IS

Line 421: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,

417:
418:
419: FUNCTION copy_application_child_records (p_person_id HZ_PARTIES.party_id%TYPE,
420: p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
421: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
422: p_nominated_course_cd IGS_AD_PS_APPL_INST_ALL.nominated_course_cd%TYPE,
423: p_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE)
424: RETURN BOOLEAN IS
425:

Line 457: igs_ad_appl_perstat

453: admission_appl_number ,
454: persl_stat_type ,
455: date_received
456: FROM
457: igs_ad_appl_perstat
458: WHERE
459: person_id = cp_person_id and
460: admission_appl_number = cp_admission_appl_number;
461:

Line 606: igs_ad_appl_perstat_pkg.insert_row(

602:
603: -- Personal Statements
604: FOR c_perstat_rec IN c_perstat_cur(p_person_id, p_old_admission_appl_number) LOOP
605: l_last_error := 'IGS_AD_CHILD_PER_STAT';
606: igs_ad_appl_perstat_pkg.insert_row(
607: x_rowid => l_rowid,
608: x_appl_perstat_id => c_perstat_rec.appl_perstat_id,
609: x_person_id => c_perstat_rec.person_id,
610: x_admission_appl_number => p_new_admission_appl_number,

Line 754: FUNCTION copy_instance_child_records (p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,

750:
751: RETURN FALSE;
752: END copy_application_child_records;
753:
754: FUNCTION copy_instance_child_records (p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
755: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
756: p_person_id HZ_PARTIES.party_id%TYPE,
757: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
758: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

Line 757: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,

753:
754: FUNCTION copy_instance_child_records (p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
755: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
756: p_person_id HZ_PARTIES.party_id%TYPE,
757: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
758: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
759: p_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE,
760: p_start_dt DATE)
761: RETURN BOOLEAN IS

Line 891: igs_ad_appl_pgmapprv

887: program_approval_date,
888: program_approval_status,
889: approval_notes
890: FROM
891: igs_ad_appl_pgmapprv
892: WHERE
893: person_id = cp_person_id and
894: nominated_course_cd = cp_nominated_course_cd and
895: sequence_number = cp_sequence_number and

Line 956: igs_ad_appl_notes

952: sequence_number ,
953: note_type_id ,
954: ref_notes_id
955: FROM
956: igs_ad_appl_notes
957: WHERE
958: person_id = cp_person_id and
959: nominated_course_cd = cp_nominated_course_cd and
960: sequence_number = cp_sequence_number and

Line 986: igs_ad_appl_eval

982: evaluation_sequence ,
983: rating_scale_id,
984: closed_ind -- added the closed ind check -- rghosh (bug#2871426)
985: FROM
986: igs_ad_appl_eval
987: WHERE
988: person_id = cp_person_id and
989: nominated_course_cd = cp_nominated_course_cd and
990: sequence_number = cp_sequence_number and

Line 1009: igs_ad_appl_arp

1005: sequence_number ,
1006: appl_rev_profile_id ,
1007: appl_revprof_revgr_id
1008: FROM
1009: igs_ad_appl_arp
1010: WHERE
1011: person_id = cp_person_id and
1012: nominated_course_cd = cp_nominated_course_cd and
1013: sequence_number = cp_sequence_number and

Line 1143: IGS_AD_APPL_PGMAPPRV_pkg.INSERT_ROW(

1139: -- program approval
1140:
1141: FOR c_pgmapp_rec IN c_pgmapp_cur(p_person_id, p_nominated_course_cd, p_old_admission_appl_number, p_old_sequence_number) LOOP
1142: l_last_error := 'IGS_AD_CHILD_PRG_APPR';
1143: IGS_AD_APPL_PGMAPPRV_pkg.INSERT_ROW(
1144: X_ROWID => l_rowid,
1145: X_APPL_PGMAPPRV_ID => l_primary_key,
1146: X_PERSON_ID => c_pgmapp_rec.person_id,
1147: X_ADMISSION_APPL_NUMBER => p_new_admission_appl_number,

Line 1202: igs_ad_appl_notes_pkg.INSERT_ROW(

1198:
1199: -- NOTES
1200: FOR c_notes_rec IN c_notes_cur(p_person_id, p_nominated_course_cd, p_old_admission_appl_number, p_old_sequence_number) LOOP
1201: l_last_error := 'IGS_AD_CHILD_APPL_NOTES';
1202: igs_ad_appl_notes_pkg.INSERT_ROW(
1203: X_ROWID => l_rowid,
1204: X_APPL_NOTES_ID => l_primary_key,
1205: X_PERSON_ID => c_notes_rec.person_id,
1206: X_ADMISSION_APPL_NUMBER => p_new_admission_appl_number,

Line 1220: igs_ad_appl_eval_pkg.INSERT_ROW(

1216:
1217: -- Evaluators
1218: FOR c_evaluators_rec IN c_evaluators_cur(p_person_id, p_nominated_course_cd, p_old_admission_appl_number, p_old_sequence_number) LOOP
1219: l_last_error := 'IGS_AD_CHILD_EVAL';
1220: igs_ad_appl_eval_pkg.INSERT_ROW(
1221: x_rowid => l_rowid,
1222: x_person_id => c_evaluators_rec.person_id,
1223: x_admission_appl_number => p_new_admission_appl_number,
1224: x_nominated_course_cd => c_evaluators_rec.nominated_course_cd,

Line 1246: igs_ad_appl_arp_pkg.INSERT_ROW(

1242:
1243: -- Evaluators Review group
1244: FOR c_applrep_rec IN c_applrep_cur(p_person_id, p_nominated_course_cd, p_old_admission_appl_number, p_old_sequence_number) LOOP
1245: l_last_error := 'IGS_AD_CHILD_EVAL_RGRP';
1246: igs_ad_appl_arp_pkg.INSERT_ROW(
1247: X_ROWID => l_rowid,
1248: X_PERSON_ID => c_applrep_rec.person_id,
1249: X_ADMISSION_APPL_NUMBER => p_new_admission_appl_number,
1250: X_NOMINATED_COURSE_CD => c_applrep_rec.nominated_course_cd,

Line 1449: cp_admission_cat igs_ad_appl_all.admission_cat%TYPE,

1445: cp_prev_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
1446: cp_prev_acad_cal_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
1447: cp_prev_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
1448: cp_prev_adm_cal_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
1449: cp_admission_cat igs_ad_appl_all.admission_cat%TYPE,
1450: cp_s_adm_process_type igs_ad_appl_all.s_admission_process_type%TYPE
1451: ) IS
1452: SELECT acai.*,
1453: aa.appl_dt,

Line 1450: cp_s_adm_process_type igs_ad_appl_all.s_admission_process_type%TYPE

1446: cp_prev_acad_cal_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
1447: cp_prev_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
1448: cp_prev_adm_cal_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
1449: cp_admission_cat igs_ad_appl_all.admission_cat%TYPE,
1450: cp_s_adm_process_type igs_ad_appl_all.s_admission_process_type%TYPE
1451: ) IS
1452: SELECT acai.*,
1453: aa.appl_dt,
1454: aa.admission_cat,

Line 1472: FROM igs_ad_appl aa,

1468: aprog.basis_for_admission_type,
1469: aprog.admission_cd,
1470: aprog.req_for_reconsideration_ind,
1471: aprog.req_for_adv_standing_ind
1472: FROM igs_ad_appl aa,
1473: igs_ad_ps_appl_inst acai,
1474: igs_ad_ou_stat aous,
1475: igs_ad_ps_appl aprog
1476: WHERE acai.adm_outcome_status = aous.adm_outcome_status

Line 1524: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,

1520: l_get_appl_instance c_get_appl_instance%ROWTYPE;
1521:
1522:
1523: /* This cursor will return the calenar information for a given application */
1524: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,
1525: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
1526: SELECT acad_cal_type,acad_ci_sequence_number
1527: FROM igs_ad_appl_all
1528: WHERE person_id = cp_person_id

Line 1525: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS

1521:
1522:
1523: /* This cursor will return the calenar information for a given application */
1524: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,
1525: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
1526: SELECT acad_cal_type,acad_ci_sequence_number
1527: FROM igs_ad_appl_all
1528: WHERE person_id = cp_person_id
1529: AND admission_appl_number = cp_admission_appl_number;

Line 1527: FROM igs_ad_appl_all

1523: /* This cursor will return the calenar information for a given application */
1524: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,
1525: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
1526: SELECT acad_cal_type,acad_ci_sequence_number
1527: FROM igs_ad_appl_all
1528: WHERE person_id = cp_person_id
1529: AND admission_appl_number = cp_admission_appl_number;
1530:
1531: l_get_acad_cal_info c_get_acad_cal_info%ROWTYPE;

Line 1587: l_application_type igs_ad_appl_all.application_type%TYPE;

1583: l_fut_adm_cal_type VARCHAR2(30);
1584: l_fut_adm_cal_seq_no NUMBER;
1585:
1586: l_message_name VARCHAR2(30);
1587: l_application_type igs_ad_appl_all.application_type%TYPE;
1588:
1589: l_sequence_number NUMBER;
1590:
1591: l_return_type VARCHAR2(100);