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_UC_EXPORT_TO_OSS dependencies on IGS_AD_ADMDE_INT

Line 994: p_person_id IGS_AD_ADMDE_INT.person_id%TYPE,

990:
991:
992: -- Get the admission decision import interface record for the passed admission application instace.
993: CURSOR c_dec_int( p_batch_id IGS_AD_BATC_DEF_DET_ALL.batch_id%TYPE ,
994: p_person_id IGS_AD_ADMDE_INT.person_id%TYPE,
995: p_admission_appl_number IGS_AD_ADMDE_INT.admission_appl_number%TYPE,
996: p_nominated_course_cd IGS_AD_ADMDE_INT.nominated_course_cd%TYPE,
997: p_sequence_number IGS_AD_ADMDE_INT.sequence_number%TYPE ) IS
998: SELECT error_code , status

Line 995: p_admission_appl_number IGS_AD_ADMDE_INT.admission_appl_number%TYPE,

991:
992: -- Get the admission decision import interface record for the passed admission application instace.
993: CURSOR c_dec_int( p_batch_id IGS_AD_BATC_DEF_DET_ALL.batch_id%TYPE ,
994: p_person_id IGS_AD_ADMDE_INT.person_id%TYPE,
995: p_admission_appl_number IGS_AD_ADMDE_INT.admission_appl_number%TYPE,
996: p_nominated_course_cd IGS_AD_ADMDE_INT.nominated_course_cd%TYPE,
997: p_sequence_number IGS_AD_ADMDE_INT.sequence_number%TYPE ) IS
998: SELECT error_code , status
999: FROM IGS_AD_ADMDE_INT_ALL

Line 996: p_nominated_course_cd IGS_AD_ADMDE_INT.nominated_course_cd%TYPE,

992: -- Get the admission decision import interface record for the passed admission application instace.
993: CURSOR c_dec_int( p_batch_id IGS_AD_BATC_DEF_DET_ALL.batch_id%TYPE ,
994: p_person_id IGS_AD_ADMDE_INT.person_id%TYPE,
995: p_admission_appl_number IGS_AD_ADMDE_INT.admission_appl_number%TYPE,
996: p_nominated_course_cd IGS_AD_ADMDE_INT.nominated_course_cd%TYPE,
997: p_sequence_number IGS_AD_ADMDE_INT.sequence_number%TYPE ) IS
998: SELECT error_code , status
999: FROM IGS_AD_ADMDE_INT_ALL
1000: WHERE batch_id = p_batch_id AND

Line 997: p_sequence_number IGS_AD_ADMDE_INT.sequence_number%TYPE ) IS

993: CURSOR c_dec_int( p_batch_id IGS_AD_BATC_DEF_DET_ALL.batch_id%TYPE ,
994: p_person_id IGS_AD_ADMDE_INT.person_id%TYPE,
995: p_admission_appl_number IGS_AD_ADMDE_INT.admission_appl_number%TYPE,
996: p_nominated_course_cd IGS_AD_ADMDE_INT.nominated_course_cd%TYPE,
997: p_sequence_number IGS_AD_ADMDE_INT.sequence_number%TYPE ) IS
998: SELECT error_code , status
999: FROM IGS_AD_ADMDE_INT_ALL
1000: WHERE batch_id = p_batch_id AND
1001: person_id = p_person_id AND

Line 999: FROM IGS_AD_ADMDE_INT_ALL

995: p_admission_appl_number IGS_AD_ADMDE_INT.admission_appl_number%TYPE,
996: p_nominated_course_cd IGS_AD_ADMDE_INT.nominated_course_cd%TYPE,
997: p_sequence_number IGS_AD_ADMDE_INT.sequence_number%TYPE ) IS
998: SELECT error_code , status
999: FROM IGS_AD_ADMDE_INT_ALL
1000: WHERE batch_id = p_batch_id AND
1001: person_id = p_person_id AND
1002: admission_appl_number = p_admission_appl_number AND
1003: nominated_course_cd = p_nominated_course_cd AND

Line 1547: -- 2. Populate the Admission Decision Import Interface table,IGS_AD_ADMDE_INT_ALL

1543: IF l_batch_id_loc IS NOT NULL THEN
1544: l_dec_batch_id := l_batch_id_det(l_batch_id_loc).batch_id;
1545: END IF;
1546:
1547: -- 2. Populate the Admission Decision Import Interface table,IGS_AD_ADMDE_INT_ALL
1548: /* call the insert_row of the Admission Decision Import Interface table, IGS_AD_ADMDE_INT_ALL */
1549: l_interface_run_id := NULL ;
1550: l_interface_mkdes_id := NULL ;
1551: l_error_message := NULL ;

Line 1548: /* call the insert_row of the Admission Decision Import Interface table, IGS_AD_ADMDE_INT_ALL */

1544: l_dec_batch_id := l_batch_id_det(l_batch_id_loc).batch_id;
1545: END IF;
1546:
1547: -- 2. Populate the Admission Decision Import Interface table,IGS_AD_ADMDE_INT_ALL
1548: /* call the insert_row of the Admission Decision Import Interface table, IGS_AD_ADMDE_INT_ALL */
1549: l_interface_run_id := NULL ;
1550: l_interface_mkdes_id := NULL ;
1551: l_error_message := NULL ;
1552: l_return_status := NULL ;

Line 1559: igs_ad_admde_int_pkg.insert_row (

1555: CLOSE c_interface_run_id ;
1556: l_rowid := NULL ;
1557:
1558: -- Create record in decision import interface tables for the applications which need to be voided
1559: igs_ad_admde_int_pkg.insert_row (
1560: x_rowid => l_rowid,
1561: x_interface_mkdes_id => l_interface_mkdes_id,
1562: x_interface_run_id => l_interface_run_id ,
1563: x_batch_id => l_dec_batch_id,

Line 1889: -- 2. Populate the Admission Decision Import Interface table,IGS_AD_ADMDE_INT_ALL

1885: IF l_batch_id_loc IS NOT NULL THEN
1886: l_dec_batch_id := l_batch_id_det(l_batch_id_loc).batch_id;
1887: END IF;
1888:
1889: -- 2. Populate the Admission Decision Import Interface table,IGS_AD_ADMDE_INT_ALL
1890: /* call the insert_row of the Admission Decision Import Interface table, IGS_AD_ADMDE_INT_ALL */
1891:
1892: l_interface_run_id := NULL ;
1893: l_interface_mkdes_id := NULL ;

Line 1890: /* call the insert_row of the Admission Decision Import Interface table, IGS_AD_ADMDE_INT_ALL */

1886: l_dec_batch_id := l_batch_id_det(l_batch_id_loc).batch_id;
1887: END IF;
1888:
1889: -- 2. Populate the Admission Decision Import Interface table,IGS_AD_ADMDE_INT_ALL
1890: /* call the insert_row of the Admission Decision Import Interface table, IGS_AD_ADMDE_INT_ALL */
1891:
1892: l_interface_run_id := NULL ;
1893: l_interface_mkdes_id := NULL ;
1894: l_error_message := NULL ;

Line 1902: igs_ad_admde_int_pkg.insert_row (

1898: CLOSE c_interface_run_id ;
1899: l_rowid := NULL ;
1900:
1901: -- Create record in decision import interface tables for the applications which need to be voided
1902: igs_ad_admde_int_pkg.insert_row (
1903: x_rowid => l_rowid,
1904: x_interface_mkdes_id => l_interface_mkdes_id,
1905: x_interface_run_id => l_interface_run_id ,
1906: x_batch_id => l_dec_batch_id,