APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_ISTARZ2_INTS

Line 6262: FROM igs_uc_istarz2_ints ivstz2

6258:
6259: CURSOR new_ivstarz2_cur IS
6260: SELECT ivstz2.rowid,
6261: ivstz2.*
6262: FROM igs_uc_istarz2_ints ivstz2
6263: WHERE ivstz2.record_status = 'N';
6264:
6265: -- check for corresponding record in main table.
6266: CURSOR old_starz2_cur(p_appno igs_uc_app_clr_rnd.app_no%TYPE,

Line 6306: CURSOR validate_Course (p_course igs_uc_istarz2_ints.course%TYPE,

6302: WHERE inst = p_inst;
6303:
6304:
6305: -- validate Course value/get OSS Program details
6306: CURSOR validate_Course (p_course igs_uc_istarz2_ints.course%TYPE,
6307: p_campus igs_uc_istarz2_ints.campus%TYPE,
6308: p_inst igs_uc_istarz2_ints.inst%TYPE,
6309: p_system igs_uc_crse_dets.system_code%TYPE) IS
6310: SELECT oss_program_code,

Line 6307: p_campus igs_uc_istarz2_ints.campus%TYPE,

6303:
6304:
6305: -- validate Course value/get OSS Program details
6306: CURSOR validate_Course (p_course igs_uc_istarz2_ints.course%TYPE,
6307: p_campus igs_uc_istarz2_ints.campus%TYPE,
6308: p_inst igs_uc_istarz2_ints.inst%TYPE,
6309: p_system igs_uc_crse_dets.system_code%TYPE) IS
6310: SELECT oss_program_code,
6311: oss_program_version,

Line 6308: p_inst igs_uc_istarz2_ints.inst%TYPE,

6304:
6305: -- validate Course value/get OSS Program details
6306: CURSOR validate_Course (p_course igs_uc_istarz2_ints.course%TYPE,
6307: p_campus igs_uc_istarz2_ints.campus%TYPE,
6308: p_inst igs_uc_istarz2_ints.inst%TYPE,
6309: p_system igs_uc_crse_dets.system_code%TYPE) IS
6310: SELECT oss_program_code,
6311: oss_program_version,
6312: oss_attendance_type,

Line 6609: UPDATE igs_uc_istarz2_ints

6605: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
6606: -- while processing the record.
6607: IF g_error_code IS NOT NULL THEN
6608:
6609: UPDATE igs_uc_istarz2_ints
6610: SET error_code = g_error_code
6611: WHERE rowid = new_ivstarz2_rec.rowid;
6612:
6613: -- log error message/meaning.

Line 6621: UPDATE igs_uc_istarz2_ints

6617: g_error_rec_cnt := g_error_rec_cnt + 1;
6618:
6619: ELSE
6620:
6621: UPDATE igs_uc_istarz2_ints
6622: SET record_status = 'D',
6623: error_code = NULL
6624: WHERE rowid = new_ivstarz2_rec.rowid;
6625: