eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_SPL_INTERESTS_PKG dependencies on IGS_SC_GEN_001

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

509: x_last_update_date=>X_LAST_UPDATE_DATE,
510: x_last_updated_by=>X_LAST_UPDATED_BY,
511: x_last_update_login=>X_LAST_UPDATE_LOGIN);
512: IF (x_mode = 'S') THEN
513: igs_sc_gen_001.set_ctx('R');
514: END IF;
515: insert into IGS_AD_SPL_INTERESTS (
516: SPL_INTEREST_ID
517: ,PERSON_ID

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

541: ,X_PROGRAM_APPLICATION_ID
542: ,X_PROGRAM_UPDATE_DATE
543: )RETURNING SPL_INTEREST_ID INTO X_SPL_INTEREST_ID;
544: IF (x_mode = 'S') THEN
545: igs_sc_gen_001.unset_ctx('R');
546: END IF;
547:
548: open c;
549: fetch c into X_ROWID;

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

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

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

696: end if;
697: end if;
698:
699: IF (x_mode = 'S') THEN
700: igs_sc_gen_001.set_ctx('R');
701: END IF;
702: update IGS_AD_SPL_INTERESTS set
703: PERSON_ID = NEW_REFERENCES.PERSON_ID,
704: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,

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

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

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

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

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_SPL_INTERESTS
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.