APPS.IGS_UC_PROC_REFERENCE_DATA dependencies on IGS_UC_CROFFAB_INTS

Line 861: FROM igs_uc_croffab_ints offab

857: -- Get new interface records
858: CURSOR int_refoffab_cur IS
859: SELECT offab.rowid,
860: offab.*
861: FROM igs_uc_croffab_ints offab
862: WHERE record_status = 'N';
863:
864: -- check whether corresponding record already exists.
865: CURSOR old_refoffab_cur (p_abbrev igs_uc_croffab_ints.abbrevcode%TYPE) IS

Line 865: CURSOR old_refoffab_cur (p_abbrev igs_uc_croffab_ints.abbrevcode%TYPE) IS

861: FROM igs_uc_croffab_ints offab
862: WHERE record_status = 'N';
863:
864: -- check whether corresponding record already exists.
865: CURSOR old_refoffab_cur (p_abbrev igs_uc_croffab_ints.abbrevcode%TYPE) IS
866: SELECT roab.rowid,
867: roab.*
868: FROM igs_uc_ref_off_abrv roab
869: WHERE abbrev_code = p_abbrev ;

Line 1046: UPDATE igs_uc_croffab_ints

1042:
1043: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
1044: -- while processing the record.
1045: IF g_error_code IS NOT NULL THEN
1046: UPDATE igs_uc_croffab_ints
1047: SET error_code = g_error_code
1048: WHERE rowid = new_refoffab_rec.rowid;
1049:
1050: -- log error message/meaning.

Line 1057: UPDATE igs_uc_croffab_ints

1053: g_error_rec_cnt := g_error_rec_cnt + 1;
1054:
1055:
1056: ELSE
1057: UPDATE igs_uc_croffab_ints
1058: SET record_status = 'D',
1059: error_code = NULL
1060: WHERE rowid = new_refoffab_rec.rowid;
1061: