APPS.IGS_AD_SPL_TALENTS_PKG dependencies on IGS_SC_GEN_001

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

510: x_last_update_date=>X_LAST_UPDATE_DATE,
511: x_last_updated_by=>X_LAST_UPDATED_BY,
512: x_last_update_login=>X_LAST_UPDATE_LOGIN);
513: IF (x_mode = 'S') THEN
514: igs_sc_gen_001.set_ctx('R');
515: END IF;
516: INSERT INTO IGS_AD_SPL_TALENTS (
517: SPL_TALENT_ID
518: ,PERSON_ID

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

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

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

558: x_rowid => X_ROWID );
559: EXCEPTION
560: WHEN OTHERS THEN
561: IF (x_mode = 'S') THEN
562: igs_sc_gen_001.unset_ctx('R');
563: END IF;
564: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
565: -- Code to handle Security Policy error raised
566: -- 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_TALENTS set
703: PERSON_ID = NEW_REFERENCES.PERSON_ID,
704: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,

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

713: where ROWID = X_ROWID;
714: if (sql%notfound) then
715: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
716: igs_ge_msg_stack.add;
717: igs_sc_gen_001.unset_ctx('R');
718: app_exception.raise_exception;
719: end if;
720: IF (x_mode = 'S') THEN
721: igs_sc_gen_001.unset_ctx('R');

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

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

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

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

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

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

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

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

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

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

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

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