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_SUSPEND_APPL_PKG dependencies on IGS_AD_APPL_ALL

Line 28: CURSOR c_cal_abs_val(cp_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,cp_adm_ci_seq_number igs_ad_appl_all.adm_ci_sequence_number%TYPE) IS

24: Who When What
25: nshee 17-DEC-2002 changed the check, additional check to log data when program start date is in future too., bug 2630250
26: *****************************************************************************************/
27:
28: CURSOR c_cal_abs_val(cp_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,cp_adm_ci_seq_number igs_ad_appl_all.adm_ci_sequence_number%TYPE) IS
29: SELECT c.absolute_val absolute_value
30: FROM IGS_CA_DA_INST c
31: WHERE
32: c.cal_type = cp_adm_cal_type

Line 45: CURSOR c_all_records_case_2(cp_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,cp_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE) IS

41: ( SELECT adm_outcome_status
42: FROM igs_ad_ou_stat
43: WHERE s_adm_outcome_status = 'SUSPEND') ;
44:
45: CURSOR c_all_records_case_2(cp_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,cp_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE) IS
46: SELECT a.*
47: FROM IGS_AD_PS_APPL_INST a,
48: IGS_AD_APPL_ALL b
49: WHERE

Line 48: IGS_AD_APPL_ALL b

44:
45: CURSOR c_all_records_case_2(cp_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,cp_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE) IS
46: SELECT a.*
47: FROM IGS_AD_PS_APPL_INST a,
48: IGS_AD_APPL_ALL b
49: WHERE
50: a.person_id=b.person_id AND
51: a.admission_appl_number = b.admission_appl_number AND
52: b.acad_cal_type = cp_acad_cal_type AND

Line 58: CURSOR c_all_records_case_3(cp_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,

54: a.adm_outcome_status IN (SELECT adm_outcome_status
55: FROM igs_ad_ou_stat
56: WHERE s_adm_outcome_status = 'SUSPEND');
57:
58: CURSOR c_all_records_case_3(cp_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
59: cp_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,
60: cp_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,
61: cp_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE) IS
62: SELECT a.*

Line 59: cp_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,

55: FROM igs_ad_ou_stat
56: WHERE s_adm_outcome_status = 'SUSPEND');
57:
58: CURSOR c_all_records_case_3(cp_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
59: cp_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,
60: cp_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,
61: cp_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE) IS
62: SELECT a.*
63: FROM IGS_AD_PS_APPL_INST a, IGS_AD_APPL_ALL b

Line 60: cp_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,

56: WHERE s_adm_outcome_status = 'SUSPEND');
57:
58: CURSOR c_all_records_case_3(cp_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
59: cp_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,
60: cp_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,
61: cp_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE) IS
62: SELECT a.*
63: FROM IGS_AD_PS_APPL_INST a, IGS_AD_APPL_ALL b
64: WHERE a.person_id=b.person_id AND

Line 61: cp_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE) IS

57:
58: CURSOR c_all_records_case_3(cp_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
59: cp_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,
60: cp_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,
61: cp_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE) IS
62: SELECT a.*
63: FROM IGS_AD_PS_APPL_INST a, IGS_AD_APPL_ALL b
64: WHERE a.person_id=b.person_id AND
65: a.admission_appl_number = b.admission_appl_number AND

Line 63: FROM IGS_AD_PS_APPL_INST a, IGS_AD_APPL_ALL b

59: cp_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,
60: cp_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,
61: cp_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE) IS
62: SELECT a.*
63: FROM IGS_AD_PS_APPL_INST a, IGS_AD_APPL_ALL b
64: WHERE a.person_id=b.person_id AND
65: a.admission_appl_number = b.admission_appl_number AND
66: b.acad_cal_type = cp_acad_cal_type AND
67: b.acad_ci_sequence_number = cp_acad_ci_sequence_number AND

Line 74: CURSOR c_all_records_case_4(cp_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,

70: a.adm_outcome_status IN (SELECT adm_outcome_status
71: FROM igs_ad_ou_stat
72: WHERE s_adm_outcome_status = 'SUSPEND');
73:
74: CURSOR c_all_records_case_4(cp_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
75: cp_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,
76: cp_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,
77: cp_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE,
78: cp_adm_cat igs_ad_prd_ad_prc_ca.admission_cat%TYPE,

Line 75: cp_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,

71: FROM igs_ad_ou_stat
72: WHERE s_adm_outcome_status = 'SUSPEND');
73:
74: CURSOR c_all_records_case_4(cp_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
75: cp_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,
76: cp_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,
77: cp_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE,
78: cp_adm_cat igs_ad_prd_ad_prc_ca.admission_cat%TYPE,
79: cp_admission_process_type igs_ad_prd_ad_prc_ca.s_admission_process_type%TYPE) IS

Line 76: cp_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,

72: WHERE s_adm_outcome_status = 'SUSPEND');
73:
74: CURSOR c_all_records_case_4(cp_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
75: cp_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,
76: cp_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,
77: cp_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE,
78: cp_adm_cat igs_ad_prd_ad_prc_ca.admission_cat%TYPE,
79: cp_admission_process_type igs_ad_prd_ad_prc_ca.s_admission_process_type%TYPE) IS
80: SELECT a.*

Line 77: cp_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE,

73:
74: CURSOR c_all_records_case_4(cp_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
75: cp_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,
76: cp_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,
77: cp_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE,
78: cp_adm_cat igs_ad_prd_ad_prc_ca.admission_cat%TYPE,
79: cp_admission_process_type igs_ad_prd_ad_prc_ca.s_admission_process_type%TYPE) IS
80: SELECT a.*
81: FROM IGS_AD_PS_APPL_INST a, IGS_AD_APPL_ALL b

Line 81: FROM IGS_AD_PS_APPL_INST a, IGS_AD_APPL_ALL b

77: cp_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE,
78: cp_adm_cat igs_ad_prd_ad_prc_ca.admission_cat%TYPE,
79: cp_admission_process_type igs_ad_prd_ad_prc_ca.s_admission_process_type%TYPE) IS
80: SELECT a.*
81: FROM IGS_AD_PS_APPL_INST a, IGS_AD_APPL_ALL b
82: WHERE a.person_id=b.person_id AND
83: a.admission_appl_number = b.admission_appl_number AND
84: b.acad_cal_type = cp_acad_cal_type AND
85: b.acad_ci_sequence_number = cp_acad_ci_sequence_number AND

Line 102: lv_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE;

98: WHERE cal_type = cp_cal_type AND
99: sequence_number = cp_seq_no;
100:
101:
102: lv_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE;
103: lv_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE;
104: lv_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE;
105: lv_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE;
106: lv_admission_cat igs_ad_prd_ad_prc_ca.admission_cat%TYPE ;

Line 103: lv_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE;

99: sequence_number = cp_seq_no;
100:
101:
102: lv_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE;
103: lv_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE;
104: lv_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE;
105: lv_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE;
106: lv_admission_cat igs_ad_prd_ad_prc_ca.admission_cat%TYPE ;
107: lv_admission_process_type igs_ad_prd_ad_prc_ca.s_admission_process_type%TYPE;

Line 104: lv_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE;

100:
101:
102: lv_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE;
103: lv_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE;
104: lv_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE;
105: lv_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE;
106: lv_admission_cat igs_ad_prd_ad_prc_ca.admission_cat%TYPE ;
107: lv_admission_process_type igs_ad_prd_ad_prc_ca.s_admission_process_type%TYPE;
108: lv_alt_code_acad igs_ca_inst.alternate_code%TYPE;

Line 105: lv_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE;

101:
102: lv_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE;
103: lv_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE;
104: lv_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE;
105: lv_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE;
106: lv_admission_cat igs_ad_prd_ad_prc_ca.admission_cat%TYPE ;
107: lv_admission_process_type igs_ad_prd_ad_prc_ca.s_admission_process_type%TYPE;
108: lv_alt_code_acad igs_ca_inst.alternate_code%TYPE;
109: lv_alt_code_adm igs_ca_inst.alternate_code%TYPE;