DBA Data[Home] [Help]

APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on IGS_AD_ACADHIS_INT_ALL

Line 2168: Purpose : Populate the Admission Interface Table, IGS_AD_ACADHIS_INT_ALL for

2164: p_app_valid_status IN OUT NOCOPY BOOLEAN) AS
2165: /******************************************************************
2166: Created By : JTMATHEW
2167: Date Created By : 08-APR-2005
2168: Purpose : Populate the Admission Interface Table, IGS_AD_ACADHIS_INT_ALL for
2169: importing the Academic History data and set the parameter,p_app_valid_status
2170: to FALSE if any validation is failed or an exception is raised.
2171: Known limitations,enhancements,remarks:
2172:

Line 2231: INSERT INTO igs_ad_acadhis_int_all ( interface_acadhis_id,

2227: -- When no Academic History record exists for the person and OSS Institution passed
2228: -- Create a new record in Academic History Interface table.
2229:
2230: -- Create an Academic History interface record for this person
2231: INSERT INTO igs_ad_acadhis_int_all ( interface_acadhis_id,
2232: interface_id,
2233: institution_code,
2234: current_inst,
2235: end_date,