APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_ISTARX_INTS

Line 5074: FROM igs_uc_istarx_ints ivstx

5070:
5071: CURSOR new_ivstarx_cur IS
5072: SELECT ivstx.rowid,
5073: ivstx.*
5074: FROM igs_uc_istarx_ints ivstx
5075: WHERE ivstx.record_status = 'N';
5076:
5077: -- check for corresponding record in main table.
5078: CURSOR old_starx_cur(p_appno igs_uc_app_choices.app_no%TYPE) IS

Line 5085: CURSOR validate_ethnic (p_ethnic igs_uc_istarx_ints.ethnic%TYPE) IS

5081: FROM igs_uc_app_stats uast
5082: WHERE uast.app_no = p_appno;
5083:
5084: -- validate ethnic value
5085: CURSOR validate_ethnic (p_ethnic igs_uc_istarx_ints.ethnic%TYPE) IS
5086: SELECT 'X'
5087: FROM igs_uc_ref_codes
5088: WHERE code_type = 'ET'
5089: and code = p_ethnic;

Line 5092: CURSOR validate_socialclass (p_socialclass igs_uc_istarx_ints.socialclass%TYPE) IS

5088: WHERE code_type = 'ET'
5089: and code = p_ethnic;
5090:
5091: -- validate Socialclass value
5092: CURSOR validate_socialclass (p_socialclass igs_uc_istarx_ints.socialclass%TYPE) IS
5093: SELECT 'X'
5094: FROM igs_uc_ref_codes
5095: WHERE code_type = 'PC'
5096: AND code = p_socialclass;

Line 5331: UPDATE igs_uc_istarx_ints

5327: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
5328: -- while processing the record.
5329: IF g_error_code IS NOT NULL THEN
5330:
5331: UPDATE igs_uc_istarx_ints
5332: SET error_code = g_error_code
5333: WHERE rowid = new_ivstarx_rec.rowid;
5334:
5335: -- log error message/meaning.

Line 5343: UPDATE igs_uc_istarx_ints

5339: g_error_rec_cnt := g_error_rec_cnt + 1;
5340:
5341: ELSE
5342:
5343: UPDATE igs_uc_istarx_ints
5344: SET record_status = 'D',
5345: error_code = NULL
5346: WHERE rowid = new_ivstarx_rec.rowid;
5347: