APPS.IGS_AD_ACAD_INTEREST_PKG dependencies on IGS_SC_GEN_001

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

506: x_last_update_date=>X_LAST_UPDATE_DATE,
507: x_last_updated_by=>X_LAST_UPDATED_BY,
508: x_last_update_login=>X_LAST_UPDATE_LOGIN);
509: IF (x_mode = 'S') THEN
510: igs_sc_gen_001.set_ctx('R');
511: END IF;
512: insert into IGS_AD_ACAD_INTEREST (
513: ACAD_INTEREST_ID
514: ,PERSON_ID

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

538: ,X_PROGRAM_APPLICATION_ID
539: ,X_PROGRAM_UPDATE_DATE
540: ) RETURNING ACAD_INTEREST_ID INTO X_ACAD_INTEREST_ID;
541: IF (x_mode = 'S') THEN
542: igs_sc_gen_001.unset_ctx('R');
543: END IF;
544:
545: open c;
546: fetch c into X_ROWID;

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

554: x_rowid => X_ROWID );
555: EXCEPTION
556: WHEN OTHERS THEN
557: IF (x_mode = 'S') THEN
558: igs_sc_gen_001.unset_ctx('R');
559: END IF;
560: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
561: -- Code to handle Security Policy error raised
562: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

693: end if;
694: end if;
695:
696: IF (x_mode = 'S') THEN
697: igs_sc_gen_001.set_ctx('R');
698: END IF;
699: update IGS_AD_ACAD_INTEREST set
700: PERSON_ID = NEW_REFERENCES.PERSON_ID,
701: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,

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

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

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

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

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

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

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

810: p_action => 'DELETE',
811: x_rowid => X_ROWID
812: );
813: IF (x_mode = 'S') THEN
814: igs_sc_gen_001.set_ctx('R');
815: END IF;
816: DELETE from IGS_AD_ACAD_INTEREST
817: WHERE ROWID = X_ROWID;
818: IF (sql%notfound) THEN

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

818: IF (sql%notfound) THEN
819: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
820: igs_ge_msg_stack.add;
821: IF (x_mode = 'S') THEN
822: igs_sc_gen_001.set_ctx('R');
823: END IF;
824: app_exception.raise_exception;
825: END IF;
826: IF (x_mode = 'S') THEN

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

823: END IF;
824: app_exception.raise_exception;
825: END IF;
826: IF (x_mode = 'S') THEN
827: igs_sc_gen_001.unset_ctx('R');
828: END IF;
829:
830: After_DML (
831: p_action => 'DELETE',

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

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