APPS.IGS_AD_APLINS_ADMREQ_PKG dependencies on IGS_AD_PS_APPL_INST_ALL

Line 230: PROCEDURE get_fk_igs_ad_ps_appl_inst_all (

226:
227: END get_uk_for_validation ;
228:
229:
230: PROCEDURE get_fk_igs_ad_ps_appl_inst_all (
231: x_person_id IN NUMBER,
232: x_admission_appl_number IN NUMBER,
233: x_nominated_course_cd IN VARCHAR2,
234: x_sequence_number IN NUMBER

Line 244: || procedure get_fk_igs_ad_ps_appl_inst_all (bug #2619603)

240: || Known limitations, enhancements or remarks :
241: || Change History :
242: || Who When What
243: || rghosh 08-nov-2002 changed the message name in the
244: || procedure get_fk_igs_ad_ps_appl_inst_all (bug #2619603)
245: || (reverse chronological order - newest change first)
246: */
247: CURSOR cur_rowid IS
248: SELECT rowid

Line 271: END get_fk_igs_ad_ps_appl_inst_all;

267: RETURN;
268: END IF;
269: CLOSE cur_rowid;
270:
271: END get_fk_igs_ad_ps_appl_inst_all;
272:
273:
274: PROCEDURE get_fk_igs_tr_item_all (
275: x_tracking_id IN NUMBER

Line 327: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

323:
324: (reverse chronological order - newest change first)
325: ***************************************************************/
326: CURSOR c_get_adm_doc_status (
327: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
328: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
329: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
330: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE ) IS
331: SELECT 'X'

Line 328: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

324: (reverse chronological order - newest change first)
325: ***************************************************************/
326: CURSOR c_get_adm_doc_status (
327: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
328: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
329: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
330: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE ) IS
331: SELECT 'X'
332: FROM igs_ad_ps_appl_inst_all

Line 329: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

325: ***************************************************************/
326: CURSOR c_get_adm_doc_status (
327: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
328: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
329: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
330: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE ) IS
331: SELECT 'X'
332: FROM igs_ad_ps_appl_inst_all
333: WHERE person_id = p_person_id

Line 330: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE ) IS

326: CURSOR c_get_adm_doc_status (
327: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
328: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
329: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
330: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE ) IS
331: SELECT 'X'
332: FROM igs_ad_ps_appl_inst_all
333: WHERE person_id = p_person_id
334: AND admission_appl_number = p_admission_appl_number

Line 332: FROM igs_ad_ps_appl_inst_all

328: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
329: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
330: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE ) IS
331: SELECT 'X'
332: FROM igs_ad_ps_appl_inst_all
333: WHERE person_id = p_person_id
334: AND admission_appl_number = p_admission_appl_number
335: AND nominated_course_cd = p_nominated_course_cd
336: AND sequence_number = p_sequence_number