APPS.IGS_UC_EXPORT_TO_OSS dependencies on IGS_AD_ADMDE_INT_ALL

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 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 ;