DBA Data[Home] [Help]

APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_ISTARW_INTS

Line 6662: FROM igs_uc_istarw_ints ivstz2

6658:
6659: CURSOR new_ivstarw_cur IS
6660: SELECT ivstz2.rowid,
6661: ivstz2.*
6662: FROM igs_uc_istarw_ints ivstz2
6663: WHERE ivstz2.record_status = 'N';
6664:
6665: -- check for corresponding record in main table.
6666: CURSOR old_starw_cur(p_appno igs_uc_wrong_app.app_no%TYPE) IS

Line 6840: UPDATE igs_uc_istarw_ints

6836: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
6837: -- while processing the record.
6838: IF g_error_code IS NOT NULL THEN
6839:
6840: UPDATE igs_uc_istarw_ints
6841: SET error_code = g_error_code
6842: WHERE rowid = new_ivstarw_rec.rowid;
6843:
6844: -- log error message/meaning.

Line 6852: UPDATE igs_uc_istarw_ints

6848: g_error_rec_cnt := g_error_rec_cnt + 1;
6849:
6850: ELSE
6851:
6852: UPDATE igs_uc_istarw_ints
6853: SET record_status = 'D',
6854: error_code = NULL
6855: WHERE rowid = new_ivstarw_rec.rowid;
6856: