DBA Data[Home] [Help]

APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_IOFFER_INTS

Line 4848: FROM igs_uc_ioffer_ints ivoff

4844:
4845: CURSOR new_ivoffer_cur IS
4846: SELECT ivoff.rowid,
4847: ivoff.*
4848: FROM igs_uc_ioffer_ints ivoff
4849: WHERE record_status = 'N';
4850:
4851:
4852: CURSOR old_offer_cur (p_appno igs_uc_app_choices.app_no%TYPE,

Line 5022: UPDATE igs_uc_ioffer_ints

5018: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
5019: -- while processing the record.
5020: IF g_error_code IS NOT NULL THEN
5021:
5022: UPDATE igs_uc_ioffer_ints
5023: SET error_code = g_error_code
5024: WHERE rowid = new_ivoffer_rec.rowid;
5025:
5026: -- log error message/meaning.

Line 5034: UPDATE igs_uc_ioffer_ints

5030: g_error_rec_cnt := g_error_rec_cnt + 1;
5031:
5032: ELSE
5033:
5034: UPDATE igs_uc_ioffer_ints
5035: SET record_status = 'D',
5036: error_code = NULL
5037: WHERE rowid = new_ivoffer_rec.rowid;
5038: