DBA Data[Home] [Help]

APPS.IGS_AD_IMP_ADM_DES dependencies on IGS_AD_PS_APPL_INST_ALL

Line 284: -- samaresh 02-DEC-2001 Bug # 2097333 : Impact of addition of the waitlist_status field to igs_ad_ps_appl_inst_all

280: -- Known limitations/enhancements and/or remarks:
281: --
282: -- Change History:
283: -- Who When What
284: -- samaresh 02-DEC-2001 Bug # 2097333 : Impact of addition of the waitlist_status field to igs_ad_ps_appl_inst_all
285: -- kamohan 16-SEP-2002 Bug # 2550009 Changed the procedure defnition with
286: -- addition of p_ucas_transaction parameter
287: -- rghosh 18-Jun-2003 Bug#2860852(Request for reconsideration import enhancement) added the parameter p_reconsideration
288: -- rboddu 11/17/2003 Added p_prpsd_commencement_date. Bug:3181590

Line 584: l_old_adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE;

580: AND admission_appl_number = cp_admission_appl_number
581: AND nominated_course_cd = cp_nominated_course_cd
582: AND sequence_number = cp_sequence_number;
583:
584: l_old_adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE;
585: l_error_msg fnd_new_messages.message_text%TYPE;
586:
587: BEGIN
588: DECLARE