DBA Data[Home] [Help]

APPS.IGS_AD_GEN_003 dependencies on IGS_AD_APPL_ALL

Line 154: p_person_id igs_ad_appl_all.person_id%TYPE,

150: l_adm_doc_status OUT NOCOPY IGS_AD_PS_APPL_INST_ALL.adm_doc_status%TYPE,
151: l_adm_entr_qual_status OUT NOCOPY IGS_AD_PS_APPL_INST_ALL.adm_entry_qual_status%TYPE);
152:
153: FUNCTION get_core_or_optional_unit (
154: p_person_id igs_ad_appl_all.person_id%TYPE,
155: p_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE)
156: RETURN VARCHAR2; -- (Y, CORE_ONLY, N)
157:
158: -- anwest 22-Jul-05 Created get_apc_step for the

Line 155: p_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE)

151: l_adm_entr_qual_status OUT NOCOPY IGS_AD_PS_APPL_INST_ALL.adm_entry_qual_status%TYPE);
152:
153: FUNCTION get_core_or_optional_unit (
154: p_person_id igs_ad_appl_all.person_id%TYPE,
155: p_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE)
156: RETURN VARCHAR2; -- (Y, CORE_ONLY, N)
157:
158: -- anwest 22-Jul-05 Created get_apc_step for the
159: -- Submitted Applications Reusuable