APPS.IGS_AD_EDUGOAL_PKG dependencies on IGS_SC_GEN_001

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

522: x_last_update_date=>X_LAST_UPDATE_DATE,
523: x_last_updated_by=>X_LAST_UPDATED_BY,
524: x_last_update_login=>X_LAST_UPDATE_LOGIN);
525: IF (x_mode = 'S') THEN
526: igs_sc_gen_001.set_ctx('R');
527: END IF;
528: INSERT INTO IGS_AD_EDUGOAL (
529: POST_EDUGOAL_ID
530: ,PERSON_ID

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

550: ,X_LAST_UPDATED_BY
551: ,X_LAST_UPDATE_LOGIN
552: )RETURNING POST_EDUGOAL_ID INTO X_POST_EDUGOAL_ID;
553: IF (x_mode = 'S') THEN
554: igs_sc_gen_001.unset_ctx('R');
555: END IF;
556:
557: open c;
558: fetch c into X_ROWID;

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

566: x_rowid => X_ROWID );
567: EXCEPTION
568: WHEN OTHERS THEN
569: IF (x_mode = 'S') THEN
570: igs_sc_gen_001.unset_ctx('R');
571: END IF;
572: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
573: -- Code to handle Security Policy error raised
574: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

694: x_last_update_date=>X_LAST_UPDATE_DATE,
695: x_last_updated_by=>X_LAST_UPDATED_BY,
696: x_last_update_login=>X_LAST_UPDATE_LOGIN);
697: IF (x_mode = 'S') THEN
698: igs_sc_gen_001.set_ctx('R');
699: END IF;
700: UPDATE IGS_AD_EDUGOAL set
701: PERSON_ID = NEW_REFERENCES.PERSON_ID,
702: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,

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

710: if (sql%notfound) then
711: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
712: igs_ge_msg_stack.add;
713: IF (x_mode = 'S') THEN
714: igs_sc_gen_001.unset_ctx('R');
715: END IF;
716: app_exception.raise_exception;
717: end if;
718: IF (x_mode = 'S') THEN

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

715: END IF;
716: app_exception.raise_exception;
717: end if;
718: IF (x_mode = 'S') THEN
719: igs_sc_gen_001.unset_ctx('R');
720: END IF;
721:
722:
723: After_DML (

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

726: );
727: EXCEPTION
728: WHEN OTHERS THEN
729: IF (x_mode = 'S') THEN
730: igs_sc_gen_001.unset_ctx('R');
731: END IF;
732: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
733: -- Code to handle Security Policy error raised
734: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

814: p_action => 'DELETE',
815: x_rowid => X_ROWID
816: );
817: IF (x_mode = 'S') THEN
818: igs_sc_gen_001.set_ctx('R');
819: END IF;
820: DELETE FROM IGS_AD_EDUGOAL
821: WHERE ROWID = X_ROWID;
822: if (sql%notfound) then

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

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

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

827: END IF;
828: app_exception.raise_exception;
829: END IF;
830: IF (x_mode = 'S') THEN
831: igs_sc_gen_001.unset_ctx('R');
832: END IF;
833:
834: After_DML (
835: p_action => 'DELETE',

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

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