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_PRECREATE_APPL_PUB dependencies on IGS_SS_ADM_APPL_STG

Line 196: l_person_id IGS_SS_ADM_APPL_STG.person_id%TYPE;

192:
193: l_apptype_rec c_apptype%ROWTYPE := NULL;
194: l_cal_rec c_cal%ROWTYPE := NULL;
195:
196: l_person_id IGS_SS_ADM_APPL_STG.person_id%TYPE;
197: l_appl_date IGS_SS_ADM_APPL_STG.appl_date%TYPE;
198: l_acad_cal_type IGS_SS_ADM_APPL_STG.acad_cal_type%TYPE;
199: l_acad_cal_seq_number IGS_SS_ADM_APPL_STG.acad_cal_seq_number%TYPE;
200: l_adm_cal_type IGS_SS_ADM_APPL_STG.adm_cal_type%TYPE;

Line 197: l_appl_date IGS_SS_ADM_APPL_STG.appl_date%TYPE;

193: l_apptype_rec c_apptype%ROWTYPE := NULL;
194: l_cal_rec c_cal%ROWTYPE := NULL;
195:
196: l_person_id IGS_SS_ADM_APPL_STG.person_id%TYPE;
197: l_appl_date IGS_SS_ADM_APPL_STG.appl_date%TYPE;
198: l_acad_cal_type IGS_SS_ADM_APPL_STG.acad_cal_type%TYPE;
199: l_acad_cal_seq_number IGS_SS_ADM_APPL_STG.acad_cal_seq_number%TYPE;
200: l_adm_cal_type IGS_SS_ADM_APPL_STG.adm_cal_type%TYPE;
201: l_adm_cal_seq_number IGS_SS_ADM_APPL_STG.adm_cal_seq_number%TYPE;

Line 198: l_acad_cal_type IGS_SS_ADM_APPL_STG.acad_cal_type%TYPE;

194: l_cal_rec c_cal%ROWTYPE := NULL;
195:
196: l_person_id IGS_SS_ADM_APPL_STG.person_id%TYPE;
197: l_appl_date IGS_SS_ADM_APPL_STG.appl_date%TYPE;
198: l_acad_cal_type IGS_SS_ADM_APPL_STG.acad_cal_type%TYPE;
199: l_acad_cal_seq_number IGS_SS_ADM_APPL_STG.acad_cal_seq_number%TYPE;
200: l_adm_cal_type IGS_SS_ADM_APPL_STG.adm_cal_type%TYPE;
201: l_adm_cal_seq_number IGS_SS_ADM_APPL_STG.adm_cal_seq_number%TYPE;
202: l_description IGS_SS_ADM_APPL_STG.description%TYPE;

Line 199: l_acad_cal_seq_number IGS_SS_ADM_APPL_STG.acad_cal_seq_number%TYPE;

195:
196: l_person_id IGS_SS_ADM_APPL_STG.person_id%TYPE;
197: l_appl_date IGS_SS_ADM_APPL_STG.appl_date%TYPE;
198: l_acad_cal_type IGS_SS_ADM_APPL_STG.acad_cal_type%TYPE;
199: l_acad_cal_seq_number IGS_SS_ADM_APPL_STG.acad_cal_seq_number%TYPE;
200: l_adm_cal_type IGS_SS_ADM_APPL_STG.adm_cal_type%TYPE;
201: l_adm_cal_seq_number IGS_SS_ADM_APPL_STG.adm_cal_seq_number%TYPE;
202: l_description IGS_SS_ADM_APPL_STG.description%TYPE;
203: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;

Line 200: l_adm_cal_type IGS_SS_ADM_APPL_STG.adm_cal_type%TYPE;

196: l_person_id IGS_SS_ADM_APPL_STG.person_id%TYPE;
197: l_appl_date IGS_SS_ADM_APPL_STG.appl_date%TYPE;
198: l_acad_cal_type IGS_SS_ADM_APPL_STG.acad_cal_type%TYPE;
199: l_acad_cal_seq_number IGS_SS_ADM_APPL_STG.acad_cal_seq_number%TYPE;
200: l_adm_cal_type IGS_SS_ADM_APPL_STG.adm_cal_type%TYPE;
201: l_adm_cal_seq_number IGS_SS_ADM_APPL_STG.adm_cal_seq_number%TYPE;
202: l_description IGS_SS_ADM_APPL_STG.description%TYPE;
203: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
204: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;

Line 201: l_adm_cal_seq_number IGS_SS_ADM_APPL_STG.adm_cal_seq_number%TYPE;

197: l_appl_date IGS_SS_ADM_APPL_STG.appl_date%TYPE;
198: l_acad_cal_type IGS_SS_ADM_APPL_STG.acad_cal_type%TYPE;
199: l_acad_cal_seq_number IGS_SS_ADM_APPL_STG.acad_cal_seq_number%TYPE;
200: l_adm_cal_type IGS_SS_ADM_APPL_STG.adm_cal_type%TYPE;
201: l_adm_cal_seq_number IGS_SS_ADM_APPL_STG.adm_cal_seq_number%TYPE;
202: l_description IGS_SS_ADM_APPL_STG.description%TYPE;
203: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
204: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
205: l_spcl_gr1 IGS_SS_ADM_APPL_STG.SPCL_GRP_1%TYPE;

Line 202: l_description IGS_SS_ADM_APPL_STG.description%TYPE;

198: l_acad_cal_type IGS_SS_ADM_APPL_STG.acad_cal_type%TYPE;
199: l_acad_cal_seq_number IGS_SS_ADM_APPL_STG.acad_cal_seq_number%TYPE;
200: l_adm_cal_type IGS_SS_ADM_APPL_STG.adm_cal_type%TYPE;
201: l_adm_cal_seq_number IGS_SS_ADM_APPL_STG.adm_cal_seq_number%TYPE;
202: l_description IGS_SS_ADM_APPL_STG.description%TYPE;
203: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
204: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
205: l_spcl_gr1 IGS_SS_ADM_APPL_STG.SPCL_GRP_1%TYPE;
206: l_spcl_gr2 IGS_SS_ADM_APPL_STG.SPCL_GRP_2%TYPE;

Line 203: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;

199: l_acad_cal_seq_number IGS_SS_ADM_APPL_STG.acad_cal_seq_number%TYPE;
200: l_adm_cal_type IGS_SS_ADM_APPL_STG.adm_cal_type%TYPE;
201: l_adm_cal_seq_number IGS_SS_ADM_APPL_STG.adm_cal_seq_number%TYPE;
202: l_description IGS_SS_ADM_APPL_STG.description%TYPE;
203: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
204: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
205: l_spcl_gr1 IGS_SS_ADM_APPL_STG.SPCL_GRP_1%TYPE;
206: l_spcl_gr2 IGS_SS_ADM_APPL_STG.SPCL_GRP_2%TYPE;
207: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;

Line 204: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;

200: l_adm_cal_type IGS_SS_ADM_APPL_STG.adm_cal_type%TYPE;
201: l_adm_cal_seq_number IGS_SS_ADM_APPL_STG.adm_cal_seq_number%TYPE;
202: l_description IGS_SS_ADM_APPL_STG.description%TYPE;
203: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
204: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
205: l_spcl_gr1 IGS_SS_ADM_APPL_STG.SPCL_GRP_1%TYPE;
206: l_spcl_gr2 IGS_SS_ADM_APPL_STG.SPCL_GRP_2%TYPE;
207: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
208: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;

Line 205: l_spcl_gr1 IGS_SS_ADM_APPL_STG.SPCL_GRP_1%TYPE;

201: l_adm_cal_seq_number IGS_SS_ADM_APPL_STG.adm_cal_seq_number%TYPE;
202: l_description IGS_SS_ADM_APPL_STG.description%TYPE;
203: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
204: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
205: l_spcl_gr1 IGS_SS_ADM_APPL_STG.SPCL_GRP_1%TYPE;
206: l_spcl_gr2 IGS_SS_ADM_APPL_STG.SPCL_GRP_2%TYPE;
207: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
208: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;
209: l_admission_application_type IGS_SS_ADM_APPL_STG.admission_application_type%TYPE;

Line 206: l_spcl_gr2 IGS_SS_ADM_APPL_STG.SPCL_GRP_2%TYPE;

202: l_description IGS_SS_ADM_APPL_STG.description%TYPE;
203: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
204: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
205: l_spcl_gr1 IGS_SS_ADM_APPL_STG.SPCL_GRP_1%TYPE;
206: l_spcl_gr2 IGS_SS_ADM_APPL_STG.SPCL_GRP_2%TYPE;
207: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
208: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;
209: l_admission_application_type IGS_SS_ADM_APPL_STG.admission_application_type%TYPE;
210: l_s_adm_process_type IGS_SS_ADM_APPL_STG.s_adm_process_type%TYPE;

Line 207: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;

203: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
204: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
205: l_spcl_gr1 IGS_SS_ADM_APPL_STG.SPCL_GRP_1%TYPE;
206: l_spcl_gr2 IGS_SS_ADM_APPL_STG.SPCL_GRP_2%TYPE;
207: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
208: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;
209: l_admission_application_type IGS_SS_ADM_APPL_STG.admission_application_type%TYPE;
210: l_s_adm_process_type IGS_SS_ADM_APPL_STG.s_adm_process_type%TYPE;
211: l_admission_cat IGS_SS_ADM_APPL_STG.admission_cat%TYPE;

Line 208: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;

204: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
205: l_spcl_gr1 IGS_SS_ADM_APPL_STG.SPCL_GRP_1%TYPE;
206: l_spcl_gr2 IGS_SS_ADM_APPL_STG.SPCL_GRP_2%TYPE;
207: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
208: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;
209: l_admission_application_type IGS_SS_ADM_APPL_STG.admission_application_type%TYPE;
210: l_s_adm_process_type IGS_SS_ADM_APPL_STG.s_adm_process_type%TYPE;
211: l_admission_cat IGS_SS_ADM_APPL_STG.admission_cat%TYPE;
212: l_apsource_id IGS_SS_ADM_APPL_STG.app_source_id%TYPE;

Line 209: l_admission_application_type IGS_SS_ADM_APPL_STG.admission_application_type%TYPE;

205: l_spcl_gr1 IGS_SS_ADM_APPL_STG.SPCL_GRP_1%TYPE;
206: l_spcl_gr2 IGS_SS_ADM_APPL_STG.SPCL_GRP_2%TYPE;
207: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
208: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;
209: l_admission_application_type IGS_SS_ADM_APPL_STG.admission_application_type%TYPE;
210: l_s_adm_process_type IGS_SS_ADM_APPL_STG.s_adm_process_type%TYPE;
211: l_admission_cat IGS_SS_ADM_APPL_STG.admission_cat%TYPE;
212: l_apsource_id IGS_SS_ADM_APPL_STG.app_source_id%TYPE;
213: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;

Line 210: l_s_adm_process_type IGS_SS_ADM_APPL_STG.s_adm_process_type%TYPE;

206: l_spcl_gr2 IGS_SS_ADM_APPL_STG.SPCL_GRP_2%TYPE;
207: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
208: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;
209: l_admission_application_type IGS_SS_ADM_APPL_STG.admission_application_type%TYPE;
210: l_s_adm_process_type IGS_SS_ADM_APPL_STG.s_adm_process_type%TYPE;
211: l_admission_cat IGS_SS_ADM_APPL_STG.admission_cat%TYPE;
212: l_apsource_id IGS_SS_ADM_APPL_STG.app_source_id%TYPE;
213: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
214: l_ss_adm_appl_id IGS_SS_ADM_APPL_STG.ss_adm_appl_id%TYPE;

Line 211: l_admission_cat IGS_SS_ADM_APPL_STG.admission_cat%TYPE;

207: l_apply_for_finaid IGS_SS_ADM_APPL_STG.apply_for_finaid%TYPE;
208: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;
209: l_admission_application_type IGS_SS_ADM_APPL_STG.admission_application_type%TYPE;
210: l_s_adm_process_type IGS_SS_ADM_APPL_STG.s_adm_process_type%TYPE;
211: l_admission_cat IGS_SS_ADM_APPL_STG.admission_cat%TYPE;
212: l_apsource_id IGS_SS_ADM_APPL_STG.app_source_id%TYPE;
213: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
214: l_ss_adm_appl_id IGS_SS_ADM_APPL_STG.ss_adm_appl_id%TYPE;
215: l_message_name VARCHAR2(2000);

Line 212: l_apsource_id IGS_SS_ADM_APPL_STG.app_source_id%TYPE;

208: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;
209: l_admission_application_type IGS_SS_ADM_APPL_STG.admission_application_type%TYPE;
210: l_s_adm_process_type IGS_SS_ADM_APPL_STG.s_adm_process_type%TYPE;
211: l_admission_cat IGS_SS_ADM_APPL_STG.admission_cat%TYPE;
212: l_apsource_id IGS_SS_ADM_APPL_STG.app_source_id%TYPE;
213: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
214: l_ss_adm_appl_id IGS_SS_ADM_APPL_STG.ss_adm_appl_id%TYPE;
215: l_message_name VARCHAR2(2000);
216:

Line 213: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;

209: l_admission_application_type IGS_SS_ADM_APPL_STG.admission_application_type%TYPE;
210: l_s_adm_process_type IGS_SS_ADM_APPL_STG.s_adm_process_type%TYPE;
211: l_admission_cat IGS_SS_ADM_APPL_STG.admission_cat%TYPE;
212: l_apsource_id IGS_SS_ADM_APPL_STG.app_source_id%TYPE;
213: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
214: l_ss_adm_appl_id IGS_SS_ADM_APPL_STG.ss_adm_appl_id%TYPE;
215: l_message_name VARCHAR2(2000);
216:
217: BEGIN

Line 214: l_ss_adm_appl_id IGS_SS_ADM_APPL_STG.ss_adm_appl_id%TYPE;

210: l_s_adm_process_type IGS_SS_ADM_APPL_STG.s_adm_process_type%TYPE;
211: l_admission_cat IGS_SS_ADM_APPL_STG.admission_cat%TYPE;
212: l_apsource_id IGS_SS_ADM_APPL_STG.app_source_id%TYPE;
213: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
214: l_ss_adm_appl_id IGS_SS_ADM_APPL_STG.ss_adm_appl_id%TYPE;
215: l_message_name VARCHAR2(2000);
216:
217: BEGIN
218: SAVEPOINT PRE_CREATE_APPLICATION_pub;

Line 238: check_length('PERSON_ID', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_person_id)));

234: -----------------------
235: -- Validate all the parameters for their length
236: -----------------------
237: -- p_person_id
238: check_length('PERSON_ID', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_person_id)));
239: -- p_acad_cal_type
240: check_length('ACAD_CAL_TYPE', 'IGS_SS_ADM_APPL_STG', length(p_acad_cal_type));
241: -- p_acad_cal_seq_number
242: check_length('ACAD_CAL_SEQ_NUMBER', 'IGS_SS_ADM_APPL_STG', length(p_acad_cal_seq_number));

Line 240: check_length('ACAD_CAL_TYPE', 'IGS_SS_ADM_APPL_STG', length(p_acad_cal_type));

236: -----------------------
237: -- p_person_id
238: check_length('PERSON_ID', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_person_id)));
239: -- p_acad_cal_type
240: check_length('ACAD_CAL_TYPE', 'IGS_SS_ADM_APPL_STG', length(p_acad_cal_type));
241: -- p_acad_cal_seq_number
242: check_length('ACAD_CAL_SEQ_NUMBER', 'IGS_SS_ADM_APPL_STG', length(p_acad_cal_seq_number));
243: -- p_adm_cal_type
244: check_length('ADM_CAL_TYPE', 'IGS_SS_ADM_APPL_STG', length(p_adm_cal_type));

Line 242: check_length('ACAD_CAL_SEQ_NUMBER', 'IGS_SS_ADM_APPL_STG', length(p_acad_cal_seq_number));

238: check_length('PERSON_ID', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_person_id)));
239: -- p_acad_cal_type
240: check_length('ACAD_CAL_TYPE', 'IGS_SS_ADM_APPL_STG', length(p_acad_cal_type));
241: -- p_acad_cal_seq_number
242: check_length('ACAD_CAL_SEQ_NUMBER', 'IGS_SS_ADM_APPL_STG', length(p_acad_cal_seq_number));
243: -- p_adm_cal_type
244: check_length('ADM_CAL_TYPE', 'IGS_SS_ADM_APPL_STG', length(p_adm_cal_type));
245: -- p_adm_cal_seq_number
246: check_length('ADM_CAL_SEQ_NUMBER', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_adm_cal_seq_number)));

Line 244: check_length('ADM_CAL_TYPE', 'IGS_SS_ADM_APPL_STG', length(p_adm_cal_type));

240: check_length('ACAD_CAL_TYPE', 'IGS_SS_ADM_APPL_STG', length(p_acad_cal_type));
241: -- p_acad_cal_seq_number
242: check_length('ACAD_CAL_SEQ_NUMBER', 'IGS_SS_ADM_APPL_STG', length(p_acad_cal_seq_number));
243: -- p_adm_cal_type
244: check_length('ADM_CAL_TYPE', 'IGS_SS_ADM_APPL_STG', length(p_adm_cal_type));
245: -- p_adm_cal_seq_number
246: check_length('ADM_CAL_SEQ_NUMBER', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_adm_cal_seq_number)));
247: -- p_entry_status
248: check_length('ENTRY_STATUS', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_entry_status)));

Line 246: check_length('ADM_CAL_SEQ_NUMBER', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_adm_cal_seq_number)));

242: check_length('ACAD_CAL_SEQ_NUMBER', 'IGS_SS_ADM_APPL_STG', length(p_acad_cal_seq_number));
243: -- p_adm_cal_type
244: check_length('ADM_CAL_TYPE', 'IGS_SS_ADM_APPL_STG', length(p_adm_cal_type));
245: -- p_adm_cal_seq_number
246: check_length('ADM_CAL_SEQ_NUMBER', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_adm_cal_seq_number)));
247: -- p_entry_status
248: check_length('ENTRY_STATUS', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_entry_status)));
249: -- p_entry_level
250: check_length('ENTRY_LEVEL', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_entry_level)));

Line 248: check_length('ENTRY_STATUS', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_entry_status)));

244: check_length('ADM_CAL_TYPE', 'IGS_SS_ADM_APPL_STG', length(p_adm_cal_type));
245: -- p_adm_cal_seq_number
246: check_length('ADM_CAL_SEQ_NUMBER', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_adm_cal_seq_number)));
247: -- p_entry_status
248: check_length('ENTRY_STATUS', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_entry_status)));
249: -- p_entry_level
250: check_length('ENTRY_LEVEL', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_entry_level)));
251: -- p_spcl_gr1
252: check_length('SPCL_GR1', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_spcl_gr1)));

Line 250: check_length('ENTRY_LEVEL', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_entry_level)));

246: check_length('ADM_CAL_SEQ_NUMBER', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_adm_cal_seq_number)));
247: -- p_entry_status
248: check_length('ENTRY_STATUS', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_entry_status)));
249: -- p_entry_level
250: check_length('ENTRY_LEVEL', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_entry_level)));
251: -- p_spcl_gr1
252: check_length('SPCL_GR1', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_spcl_gr1)));
253: -- p_spcl_gr2
254: check_length('SPCL_GR2', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_spcl_gr2)));

Line 252: check_length('SPCL_GR1', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_spcl_gr1)));

248: check_length('ENTRY_STATUS', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_entry_status)));
249: -- p_entry_level
250: check_length('ENTRY_LEVEL', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_entry_level)));
251: -- p_spcl_gr1
252: check_length('SPCL_GR1', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_spcl_gr1)));
253: -- p_spcl_gr2
254: check_length('SPCL_GR2', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_spcl_gr2)));
255: -- p_apply_for_finaid
256: check_length('APPLY_FOR_FINAID', 'IGS_SS_ADM_APPL_STG', length(p_apply_for_finaid));

Line 254: check_length('SPCL_GR2', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_spcl_gr2)));

250: check_length('ENTRY_LEVEL', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_entry_level)));
251: -- p_spcl_gr1
252: check_length('SPCL_GR1', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_spcl_gr1)));
253: -- p_spcl_gr2
254: check_length('SPCL_GR2', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_spcl_gr2)));
255: -- p_apply_for_finaid
256: check_length('APPLY_FOR_FINAID', 'IGS_SS_ADM_APPL_STG', length(p_apply_for_finaid));
257: -- p_admission_application_type
258: check_length('ADMISSION_APPLICATION_TYPE', 'IGS_SS_ADM_APPL_STG', length(p_admission_application_type));

Line 256: check_length('APPLY_FOR_FINAID', 'IGS_SS_ADM_APPL_STG', length(p_apply_for_finaid));

252: check_length('SPCL_GR1', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_spcl_gr1)));
253: -- p_spcl_gr2
254: check_length('SPCL_GR2', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_spcl_gr2)));
255: -- p_apply_for_finaid
256: check_length('APPLY_FOR_FINAID', 'IGS_SS_ADM_APPL_STG', length(p_apply_for_finaid));
257: -- p_admission_application_type
258: check_length('ADMISSION_APPLICATION_TYPE', 'IGS_SS_ADM_APPL_STG', length(p_admission_application_type));
259: -- p_apsource_id
260: check_length('APSOURCE_ID', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_apsource_id)));

Line 258: check_length('ADMISSION_APPLICATION_TYPE', 'IGS_SS_ADM_APPL_STG', length(p_admission_application_type));

254: check_length('SPCL_GR2', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_spcl_gr2)));
255: -- p_apply_for_finaid
256: check_length('APPLY_FOR_FINAID', 'IGS_SS_ADM_APPL_STG', length(p_apply_for_finaid));
257: -- p_admission_application_type
258: check_length('ADMISSION_APPLICATION_TYPE', 'IGS_SS_ADM_APPL_STG', length(p_admission_application_type));
259: -- p_apsource_id
260: check_length('APSOURCE_ID', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_apsource_id)));
261: -- p_application_fee_amount
262: check_length('APPLICATION_FEE_AMOUNT', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_application_fee_amount)));

Line 260: check_length('APSOURCE_ID', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_apsource_id)));

256: check_length('APPLY_FOR_FINAID', 'IGS_SS_ADM_APPL_STG', length(p_apply_for_finaid));
257: -- p_admission_application_type
258: check_length('ADMISSION_APPLICATION_TYPE', 'IGS_SS_ADM_APPL_STG', length(p_admission_application_type));
259: -- p_apsource_id
260: check_length('APSOURCE_ID', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_apsource_id)));
261: -- p_application_fee_amount
262: check_length('APPLICATION_FEE_AMOUNT', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_application_fee_amount)));
263:
264: -- end of parameter-lenghth validations.

Line 262: check_length('APPLICATION_FEE_AMOUNT', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_application_fee_amount)));

258: check_length('ADMISSION_APPLICATION_TYPE', 'IGS_SS_ADM_APPL_STG', length(p_admission_application_type));
259: -- p_apsource_id
260: check_length('APSOURCE_ID', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_apsource_id)));
261: -- p_application_fee_amount
262: check_length('APPLICATION_FEE_AMOUNT', 'IGS_SS_ADM_APPL_STG', length(TRUNC(p_application_fee_amount)));
263:
264: -- end of parameter-lenghth validations.
265:
266: ---------------------

Line 613: INSERT INTO IGS_SS_ADM_APPL_STG (SS_ADM_APPL_ID,

609: ---------------------
610: -- Insert the Application Record.
611: ---------------------
612:
613: INSERT INTO IGS_SS_ADM_APPL_STG (SS_ADM_APPL_ID,
614: PERSON_ID,
615: APPL_DATE,
616: ACAD_CAL_TYPE,
617: ACAD_CAL_SEQ_NUMBER,

Line 778: FROM IGS_SS_ADM_APPL_STG

774:
775: -- Cursor to validate Parent Application's Application Identifier
776: CURSOR c_admappl(p_ss_adm_appl_id NUMBER) IS
777: SELECT ss_adm_appl_id, person_id, admission_cat,s_adm_process_type, admission_application_type
778: FROM IGS_SS_ADM_APPL_STG
779: WHERE ss_adm_appl_id = p_ss_adm_appl_id;
780:
781:
782: -- Cursor to validate School Applying To

Line 1406: -- The application id should exist in the parent Table-IGS_SS_ADM_APPL_STG

1402: -- Validate the values of the parameters passed in the API
1403: ---------------------------
1404:
1405: -- validate p_ss_adm_appl_id
1406: -- The application id should exist in the parent Table-IGS_SS_ADM_APPL_STG
1407: OPEN c_admappl(l_ss_adm_appl_id);
1408: FETCH c_admappl INTO l_admappl_rec;
1409: CLOSE c_admappl;
1410: