APPS.IGS_PE_PRIV_LEVEL_PKG dependencies on IGS_GE_NOTE

Line 166: ELSIF NOT Igs_Ge_Note_Pkg.Get_PK_For_Validation (

162: END IF;
163: IF (((old_references.ref_notes_id = new_references.ref_notes_id)) OR
164: ((new_references.ref_notes_id IS NULL))) THEN
165: NULL;
166: ELSIF NOT Igs_Ge_Note_Pkg.Get_PK_For_Validation (
167: new_references.ref_notes_id
168: ) THEN
169: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
170: IGS_GE_MSG_STACK.ADD;

Line 255: FROM igs_ge_note

251: PROCEDURE BeforeDeletePrivLevel
252: IS
253: CURSOR ref_notes IS
254: SELECT rowid
255: FROM igs_ge_note
256: WHERE reference_number = old_references.ref_notes_id;
257: BEGIN
258: FOR ref_rec IN ref_notes LOOP
259: igs_ge_note_pkg.delete_row (ref_rec.rowid);

Line 259: igs_ge_note_pkg.delete_row (ref_rec.rowid);

255: FROM igs_ge_note
256: WHERE reference_number = old_references.ref_notes_id;
257: BEGIN
258: FOR ref_rec IN ref_notes LOOP
259: igs_ge_note_pkg.delete_row (ref_rec.rowid);
260: END LOOP;
261:
262: END BeforeDeletePrivLevel;
263: