APPS.IGS_DA_XML_PKG dependencies on IGS_DA_XML_ACADEMICPROGRAM_V

Line 1932: -- cursor to validate the record from the view IGS_DA_XML_ACADEMICPROGRAM_V

1928: FROM igs_da_xml_degreeprogram_v
1929: WHERE batch_id = cp_batch_id
1930: AND person_id = cp_person_id;
1931: */
1932: -- cursor to validate the record from the view IGS_DA_XML_ACADEMICPROGRAM_V
1933: CURSOR c_acadprg_v (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,
1934: cp_person_id igs_da_req_stdnts.person_id%TYPE) IS
1935: SELECT program_type,
1936: program_code,

Line 1938: FROM igs_da_xml_academicprogram_v

1934: cp_person_id igs_da_req_stdnts.person_id%TYPE) IS
1935: SELECT program_type,
1936: program_code,
1937: program_catalog_year
1938: FROM igs_da_xml_academicprogram_v
1939: WHERE batch_id = cp_batch_id
1940: AND person_id = cp_person_id;
1941:
1942: -- cursor to update igs_da_req_stdnts

Line 2058: -- check that the student has valid record in IGS_DA_XML_ACADEMICPROGRAM_V

2054: v_report_text := v_report_text ||' '|| ' Local Institution.
';
2055: END IF;
2056: END LOOP; --FOR rec_degprg_v IN c_degprg_v (p_batch_id,rec_list_person_id.person_id)
2057: */
2058: -- check that the student has valid record in IGS_DA_XML_ACADEMICPROGRAM_V
2059: FOR rec_acadprg_v IN c_acadprg_v (p_batch_id,rec_list_person_id.person_id)
2060: LOOP
2061: IF rec_acadprg_v.program_type IS NULL OR
2062: rec_acadprg_v.program_code IS NULL OR