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

Line 1: PACKAGE igs_ad_ps_appl_inst_pkg AS

1: PACKAGE igs_ad_ps_appl_inst_pkg AS
2: /* $Header: IGSAI18S.pls 120.1 2005/08/11 09:56:53 appldev ship $ */
3:
4: PROCEDURE insert_row (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 822: PROCEDURE ucas_user_hook (p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,

818: x_ais_reason IN VARCHAR2 DEFAULT NULL,
819: x_decline_ofr_reason IN VARCHAR2 DEFAULT NULL
820: );
821:
822: PROCEDURE ucas_user_hook (p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
823: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
824: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
825: p_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
826: p_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,

Line 823: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,

819: x_decline_ofr_reason IN VARCHAR2 DEFAULT NULL
820: );
821:
822: PROCEDURE ucas_user_hook (p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
823: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
824: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
825: p_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
826: p_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
827: p_adm_outcome_status_old igs_ad_ps_appl_inst.adm_outcome_status%TYPE,

Line 824: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,

820: );
821:
822: PROCEDURE ucas_user_hook (p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
823: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
824: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
825: p_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
826: p_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
827: p_adm_outcome_status_old igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
828: p_cond_offer_status_old igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,

Line 825: p_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE,

821:
822: PROCEDURE ucas_user_hook (p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
823: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
824: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
825: p_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
826: p_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
827: p_adm_outcome_status_old igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
828: p_cond_offer_status_old igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
829: p_person_id igs_pe_person.person_id%TYPE,

Line 826: p_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,

822: PROCEDURE ucas_user_hook (p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
823: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
824: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
825: p_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
826: p_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
827: p_adm_outcome_status_old igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
828: p_cond_offer_status_old igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
829: p_person_id igs_pe_person.person_id%TYPE,
830: p_condition_category IN igs_uc_offer_conds.condition_category%TYPE,

Line 827: p_adm_outcome_status_old igs_ad_ps_appl_inst.adm_outcome_status%TYPE,

823: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
824: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
825: p_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
826: p_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
827: p_adm_outcome_status_old igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
828: p_cond_offer_status_old igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
829: p_person_id igs_pe_person.person_id%TYPE,
830: p_condition_category IN igs_uc_offer_conds.condition_category%TYPE,
831: p_condition_name IN igs_uc_offer_conds.condition_name%TYPE,

Line 828: p_cond_offer_status_old igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,

824: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
825: p_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
826: p_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
827: p_adm_outcome_status_old igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
828: p_cond_offer_status_old igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
829: p_person_id igs_pe_person.person_id%TYPE,
830: p_condition_category IN igs_uc_offer_conds.condition_category%TYPE,
831: p_condition_name IN igs_uc_offer_conds.condition_name%TYPE,
832: p_uc_tran_id OUT NOCOPY NUMBER );

Line 836: END igs_ad_ps_appl_inst_pkg;

832: p_uc_tran_id OUT NOCOPY NUMBER );
833:
834: FUNCTION check_non_updateable_list RETURN BOOLEAN; --arvsrini igsm
835:
836: END igs_ad_ps_appl_inst_pkg;