APPS.IGS_AD_APPL_NOTES_PKG dependencies on IGS_SC_GEN_001

Line 598: igs_sc_gen_001.set_ctx('R');

594: x_last_update_date=>X_LAST_UPDATE_DATE,
595: x_last_updated_by=>X_LAST_UPDATED_BY,
596: x_last_update_login=>X_LAST_UPDATE_LOGIN);
597: IF (x_mode = 'S') THEN
598: igs_sc_gen_001.set_ctx('R');
599: END IF;
600: INSERT INTO IGS_AD_APPL_NOTES (
601: APPL_NOTES_ID
602: ,PERSON_ID

Line 636: igs_sc_gen_001.unset_ctx('R');

632: ,X_PROGRAM_APPLICATION_ID
633: ,X_PROGRAM_UPDATE_DATE
634: )RETURNING APPL_NOTES_ID,REF_NOTES_ID INTO X_APPL_NOTES_ID,X_REF_NOTES_ID;
635: IF (x_mode = 'S') THEN
636: igs_sc_gen_001.unset_ctx('R');
637: END IF;
638:
639: open c;
640: fetch c into X_ROWID;

Line 652: igs_sc_gen_001.unset_ctx('R');

648: x_rowid => X_ROWID );
649: EXCEPTION
650: WHEN OTHERS THEN
651: IF (x_mode = 'S') THEN
652: igs_sc_gen_001.unset_ctx('R');
653: END IF;
654: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
655: -- Code to handle Security Policy error raised
656: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

Line 807: igs_sc_gen_001.set_ctx('R');

803: end if;
804: end if;
805:
806: IF (x_mode = 'S') THEN
807: igs_sc_gen_001.set_ctx('R');
808: END IF;
809: update IGS_AD_APPL_NOTES set
810: PERSON_ID = NEW_REFERENCES.PERSON_ID,
811: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,

Line 828: igs_sc_gen_001.set_ctx('R');

824: IF (sql%notfound) THEN
825: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
826: igs_ge_msg_stack.add;
827: IF (x_mode = 'S') THEN
828: igs_sc_gen_001.set_ctx('R');
829: END IF;
830: app_exception.raise_exception;
831: END IF;
832: IF (x_mode = 'S') THEN

Line 833: igs_sc_gen_001.unset_ctx('R');

829: END IF;
830: app_exception.raise_exception;
831: END IF;
832: IF (x_mode = 'S') THEN
833: igs_sc_gen_001.unset_ctx('R');
834: END IF;
835:
836:
837: After_DML (

Line 844: igs_sc_gen_001.unset_ctx('R');

840: );
841: EXCEPTION
842: WHEN OTHERS THEN
843: IF (x_mode = 'S') THEN
844: igs_sc_gen_001.unset_ctx('R');
845: END IF;
846: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
847: -- Code to handle Security Policy error raised
848: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

Line 938: igs_sc_gen_001.set_ctx('R');

934: p_action => 'DELETE',
935: x_rowid => X_ROWID
936: );
937: IF (x_mode = 'S') THEN
938: igs_sc_gen_001.set_ctx('R');
939: END IF;
940: DELETE FROM IGS_AD_APPL_NOTES
941: WHERE ROWID = X_ROWID;
942: IF (sql%notfound) THEN

Line 945: igs_sc_gen_001.unset_ctx('R');

941: WHERE ROWID = X_ROWID;
942: IF (sql%notfound) THEN
943: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
944: igs_ge_msg_stack.add;
945: igs_sc_gen_001.unset_ctx('R');
946: app_exception.raise_exception;
947: END IF;
948: IF (x_mode = 'S') THEN
949: igs_sc_gen_001.unset_ctx('R');

Line 949: igs_sc_gen_001.unset_ctx('R');

945: igs_sc_gen_001.unset_ctx('R');
946: app_exception.raise_exception;
947: END IF;
948: IF (x_mode = 'S') THEN
949: igs_sc_gen_001.unset_ctx('R');
950: END IF;
951:
952: After_DML (
953: p_action => 'DELETE',

Line 959: igs_sc_gen_001.unset_ctx('R');

955: );
956: EXCEPTION
957: WHEN OTHERS THEN
958: IF (x_mode = 'S') THEN
959: igs_sc_gen_001.unset_ctx('R');
960: END IF;
961: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
962: -- Code to handle Security Policy error raised
963: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.