APPS.IGS_UC_PROC_REFERENCE_DATA dependencies on IGS_UC_CREFPOC_INTS

Line 697: FROM igs_uc_crefpoc_ints

693: ,alternativetext
694: ,alternateclass1
695: ,alternateclass2
696: ,socioeconomic
697: FROM igs_uc_crefpoc_ints
698: WHERE record_status = 'N';
699:
700: -- check whether corresponding record already exists.
701: CURSOR old_refpocc_cur (p_pocc igs_uc_crefpoc_ints.pocc%TYPE) IS

Line 701: CURSOR old_refpocc_cur (p_pocc igs_uc_crefpoc_ints.pocc%TYPE) IS

697: FROM igs_uc_crefpoc_ints
698: WHERE record_status = 'N';
699:
700: -- check whether corresponding record already exists.
701: CURSOR old_refpocc_cur (p_pocc igs_uc_crefpoc_ints.pocc%TYPE) IS
702: SELECT rowid
703: FROM igs_uc_ref_pocc
704: WHERE pocc = p_pocc ;
705:

Line 811: UPDATE igs_uc_crefpoc_ints

807:
808: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
809: -- while processing the record.
810: IF g_error_code IS NOT NULL THEN
811: UPDATE igs_uc_crefpoc_ints
812: SET error_code = g_error_code
813: WHERE rowid = new_refpocc_rec.rowid;
814:
815: -- log error message/meaning.

Line 821: UPDATE igs_uc_crefpoc_ints

817: -- update error count
818: g_error_rec_cnt := g_error_rec_cnt + 1;
819:
820: ELSE
821: UPDATE igs_uc_crefpoc_ints
822: SET record_status = 'D',
823: error_code = NULL
824: WHERE rowid = new_refpocc_rec.rowid;
825: