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_PS_APLINSTUNT_PKG dependencies on IGS_AD_PS_APPL_INST

Line 100: v_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE;

96: v_message_name varchar2(30);
97: v_return_type VARCHAR2(1);
98: v_person_id IGS_AD_APPL.person_id%TYPE;
99: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
100: v_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE;
101: v_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE;
102: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
103: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
104: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;

Line 101: v_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE;

97: v_return_type VARCHAR2(1);
98: v_person_id IGS_AD_APPL.person_id%TYPE;
99: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
100: v_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE;
101: v_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE;
102: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
103: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
104: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
105: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;

Line 114: v_acai_adm_cal_type IGS_AD_PS_APPL_INST.adm_cal_type%TYPE;

110: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
111: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
112: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
113: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
114: v_acai_adm_cal_type IGS_AD_PS_APPL_INST.adm_cal_type%TYPE;
115: v_acai_adm_ci_sequence_number
116: IGS_AD_PS_APPL_INST.adm_ci_sequence_number%TYPE;
117: v_offer_ind VARCHAR2(1);
118: v_unit_encmb_chk_ind VARCHAR2(1);

Line 116: IGS_AD_PS_APPL_INST.adm_ci_sequence_number%TYPE;

112: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
113: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
114: v_acai_adm_cal_type IGS_AD_PS_APPL_INST.adm_cal_type%TYPE;
115: v_acai_adm_ci_sequence_number
116: IGS_AD_PS_APPL_INST.adm_ci_sequence_number%TYPE;
117: v_offer_ind VARCHAR2(1);
118: v_unit_encmb_chk_ind VARCHAR2(1);
119: v_unit_restr_ind VARCHAR2(1);
120: cst_error CONSTANT VARCHAR2(1):= 'E';

Line 130: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,

126: WHERE admission_cat = cp_admission_cat AND
127: s_admission_process_type = cp_s_admission_process_type AND
128: step_group_type <> 'TRACK'; --2402377
129: CURSOR c_acai (
130: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
131: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
132: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
133: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) IS
134: SELECT adm_cal_type,

Line 131: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

127: s_admission_process_type = cp_s_admission_process_type AND
128: step_group_type <> 'TRACK'; --2402377
129: CURSOR c_acai (
130: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
131: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
132: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
133: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) IS
134: SELECT adm_cal_type,
135: adm_ci_sequence_number,

Line 132: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,

128: step_group_type <> 'TRACK'; --2402377
129: CURSOR c_acai (
130: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
131: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
132: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
133: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) IS
134: SELECT adm_cal_type,
135: adm_ci_sequence_number,
136: course_cd

Line 133: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) IS

129: CURSOR c_acai (
130: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
131: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
132: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
133: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) IS
134: SELECT adm_cal_type,
135: adm_ci_sequence_number,
136: course_cd
137: FROM IGS_AD_PS_APPL_INST

Line 137: FROM IGS_AD_PS_APPL_INST

133: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) IS
134: SELECT adm_cal_type,
135: adm_ci_sequence_number,
136: course_cd
137: FROM IGS_AD_PS_APPL_INST
138: WHERE person_id = cp_person_id AND
139: admission_appl_number = cp_admission_appl_number AND
140: nominated_course_cd = cp_nominated_course_cd AND
141: sequence_number = cp_sequence_number;

Line 568: IF NOT IGS_AD_PS_APPL_INST_PKG.Get_PK_For_Validation (

564: (new_references.acai_sequence_number IS NULL))) THEN
565: NULL;
566: ELSE
567:
568: IF NOT IGS_AD_PS_APPL_INST_PKG.Get_PK_For_Validation (
569: new_references.person_id,
570: new_references.admission_appl_number,
571: new_references.nominated_course_cd,
572: new_references.acai_sequence_number

Line 899: PROCEDURE GET_FK_IGS_AD_PS_APPL_INST (

895: Return (FALSE);
896: END IF;
897: END Get_UK_For_Validation;
898:
899: PROCEDURE GET_FK_IGS_AD_PS_APPL_INST (
900: x_person_id IN NUMBER,
901: x_admission_appl_number IN NUMBER,
902: x_nominated_course_cd IN VARCHAR2,
903: x_sequence_number IN NUMBER

Line 929: END GET_FK_IGS_AD_PS_APPL_INST;

925: Return;
926: END IF;
927: Close cur_rowid;
928:
929: END GET_FK_IGS_AD_PS_APPL_INST;
930:
931: PROCEDURE GET_FK_IGS_AD_UNIT_OU_STAT (
932: x_adm_unit_outcome_status IN VARCHAR2
933: ) AS