APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on IGS_AD_ADDR_INT_ALL

Line 2808: l_country_code IGS_AD_ADDR_INT_ALL.country%TYPE;

2804: FROM IGS_HE_CODE_MAP_VAL
2805: WHERE association_code = p_assoc
2806: AND map1 = p_map1;
2807:
2808: l_country_code IGS_AD_ADDR_INT_ALL.country%TYPE;
2809:
2810: BEGIN
2811:
2812: /* Derive Country Code */

Line 2863: IGS_AD_ADDR_INT_ALL and IGS_AD_ADDRUSAGE_INT_ALL

2859: /******************************************************************
2860: Created By : AYEDUBAT
2861: Date Created By : 16-JUN-2003
2862: Purpose : Puplate the Admission Interface Tables,
2863: IGS_AD_ADDR_INT_ALL and IGS_AD_ADDRUSAGE_INT_ALL
2864: Known limitations,enhancements,remarks:
2865:
2866: CHANGE HISTORY:
2867: WHO WHEN WHAT

Line 2874: l_country_code IGS_AD_ADDR_INT_ALL.country%TYPE;

2870: for UCAS home_address1
2871: ***************************************************************** */
2872:
2873:
2874: l_country_code IGS_AD_ADDR_INT_ALL.country%TYPE;
2875: l_interface_addr_id IGS_AD_ADDR_INT_ALL.interface_addr_id%TYPE;
2876:
2877: -- anwest Bug# 3622076 Local variable to store first line of address in
2878: l_home_address1 igs_ad_addr_int_all.addr_line_1%TYPE;

Line 2875: l_interface_addr_id IGS_AD_ADDR_INT_ALL.interface_addr_id%TYPE;

2871: ***************************************************************** */
2872:
2873:
2874: l_country_code IGS_AD_ADDR_INT_ALL.country%TYPE;
2875: l_interface_addr_id IGS_AD_ADDR_INT_ALL.interface_addr_id%TYPE;
2876:
2877: -- anwest Bug# 3622076 Local variable to store first line of address in
2878: l_home_address1 igs_ad_addr_int_all.addr_line_1%TYPE;
2879:

Line 2878: l_home_address1 igs_ad_addr_int_all.addr_line_1%TYPE;

2874: l_country_code IGS_AD_ADDR_INT_ALL.country%TYPE;
2875: l_interface_addr_id IGS_AD_ADDR_INT_ALL.interface_addr_id%TYPE;
2876:
2877: -- anwest Bug# 3622076 Local variable to store first line of address in
2878: l_home_address1 igs_ad_addr_int_all.addr_line_1%TYPE;
2879:
2880: l_home_flag BOOLEAN := TRUE;
2881: l_corr_flag BOOLEAN := TRUE;
2882: l_usage VARCHAR2(80);

Line 2923: INSERT INTO igs_ad_addr_int_all (

2919: 'CORRESPONDENCE') ;
2920:
2921: -- Populate the Address Interface table for single address, and secondary address
2922: l_interface_addr_id := NULL;
2923: INSERT INTO igs_ad_addr_int_all (
2924: interface_addr_id
2925: ,interface_id
2926: ,addr_line_1
2927: ,addr_line_2

Line 3014: INSERT INTO igs_ad_addr_int_all(

3010: l_home_address1 := p_app_address_dtls_rec.home_address1;
3011: END IF;
3012:
3013: l_interface_addr_id := NULL;
3014: INSERT INTO igs_ad_addr_int_all(
3015: interface_addr_id
3016: ,interface_id
3017: ,addr_line_1
3018: ,addr_line_2