[Home] [Help]
2605: p_app_valid_status IN OUT NOCOPY BOOLEAN) AS
2606: /******************************************************************
2607: Created By : AYEDUBAT
2608: Date Created By : 16-JUN-2003
2609: Purpose : Puplate the Admission Interface Table, IGS_AD_CONTACTS_INT_ALL
2610: and set the Parameter,p_app_valid_status to FALSE if an exception is raised
2611: Known limitations,enhancements,remarks:
2612:
2613: CHANGE HISTORY:
2614: WHO WHEN WHAT
2615: jbaber 11-Jul-05 Added mobile for UC325 - UCAS 2007 Support
2616: ***************************************************************** */
2617:
2618: --To get the Email format to populate into igs_ad_contacts_int_all table.
2619: CURSOR cur_email_format IS
2620: SELECT lookup_code
2621: FROM fnd_lookup_values
2622: WHERE lookup_type = 'EMAIL_FORMAT'
2631:
2632: -- Populate the Admission Contacts Interface Table for Primary Phone Number
2633: IF p_telephone IS NOT NULL THEN
2634:
2635: INSERT INTO igs_ad_contacts_int_all (
2636: interface_contacts_id
2637: ,interface_id
2638: ,phone_number
2639: ,status
2668: OPEN cur_email_format;
2669: FETCH cur_email_format INTO l_email_format;
2670: CLOSE cur_email_format;
2671:
2672: INSERT INTO igs_ad_contacts_int_all (
2673: interface_contacts_id
2674: ,interface_id
2675: ,email_address
2676: ,email_format
2702:
2703: -- Populate the Admission Contacts Interface Table for Home Phone Number creation
2704: IF p_home_phone IS NOT NULL THEN
2705:
2706: INSERT INTO igs_ad_contacts_int_all (
2707: interface_contacts_id
2708: ,interface_id
2709: ,phone_number
2710: ,status
2734:
2735: -- Populate the Admission Contacts Interface Table for Mobile Number creation
2736: IF p_mobile IS NOT NULL THEN
2737:
2738: INSERT INTO igs_ad_contacts_int_all (
2739: interface_contacts_id
2740: ,interface_id
2741: ,phone_number
2742: ,status