APPS.IGS_AD_SUSPEND_APPL_PKG dependencies on IGS_AD_PS_APPL_INST

Line 39: FROM igs_ad_ps_appl_inst a

35: c_cal_abs_val_rec c_cal_abs_val%ROWTYPE;
36:
37: CURSOR c_all_records_case_1 IS
38: SELECT a.*
39: FROM igs_ad_ps_appl_inst a
40: WHERE a.adm_outcome_status IN
41: ( SELECT adm_outcome_status
42: FROM igs_ad_ou_stat
43: WHERE s_adm_outcome_status = 'SUSPEND') ;

Line 47: FROM IGS_AD_PS_APPL_INST a,

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
50: a.person_id=b.person_id AND
51: 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 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 117: PROCEDURE logerror(p_pid IN igs_ad_ps_appl_inst.person_id%TYPE,

113: CASE_2 BOOLEAN;
114: CASE_3 BOOLEAN;
115: CASE_4 BOOLEAN;
116:
117: PROCEDURE logerror(p_pid IN igs_ad_ps_appl_inst.person_id%TYPE,
118: p_aid IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
119: p_pc IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
120: p_seq IN igs_ad_ps_appl_inst.sequence_number%TYPE,
121: p_message IN VARCHAR2) AS

Line 118: p_aid IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,

114: CASE_3 BOOLEAN;
115: CASE_4 BOOLEAN;
116:
117: PROCEDURE logerror(p_pid IN igs_ad_ps_appl_inst.person_id%TYPE,
118: p_aid IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
119: p_pc IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
120: p_seq IN igs_ad_ps_appl_inst.sequence_number%TYPE,
121: p_message IN VARCHAR2) AS
122: /*****************************************************************************************

Line 119: p_pc IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,

115: CASE_4 BOOLEAN;
116:
117: PROCEDURE logerror(p_pid IN igs_ad_ps_appl_inst.person_id%TYPE,
118: p_aid IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
119: p_pc IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
120: p_seq IN igs_ad_ps_appl_inst.sequence_number%TYPE,
121: p_message IN VARCHAR2) AS
122: /*****************************************************************************************
123: Created By: [email protected]

Line 120: p_seq IN igs_ad_ps_appl_inst.sequence_number%TYPE,

116:
117: PROCEDURE logerror(p_pid IN igs_ad_ps_appl_inst.person_id%TYPE,
118: p_aid IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
119: p_pc IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
120: p_seq IN igs_ad_ps_appl_inst.sequence_number%TYPE,
121: p_message IN VARCHAR2) AS
122: /*****************************************************************************************
123: Created By: [email protected]
124: Date Created : 09-16-2002

Line 156: IGS_AD_PS_APPL_INST_PKG.UPDATE_ROW (

152: Who When What
153: *****************************************************************************************/
154: lv_msg VARCHAR2(2000);
155: BEGIN
156: IGS_AD_PS_APPL_INST_PKG.UPDATE_ROW (
157: X_Mode => 'R',
158: X_RowId => cp_all_records_rec.row_id,
159: X_Person_Id => cp_all_records_rec.Person_Id ,
160: X_Admission_Appl_Number => cp_all_records_rec.Admission_Appl_Number ,