APPS.IGS_AD_SPL_ADM_CAT_PKG dependencies on IGS_SC_GEN_001

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

518: x_last_update_date=>X_LAST_UPDATE_DATE,
519: x_last_updated_by=>X_LAST_UPDATED_BY,
520: x_last_update_login=>X_LAST_UPDATE_LOGIN);
521: IF (x_mode = 'S') THEN
522: igs_sc_gen_001.set_ctx('R');
523: END IF;
524: insert into IGS_AD_SPL_ADM_CAT (
525: SPL_ADM_CAT_ID
526: ,PERSON_ID

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

546: ,X_LAST_UPDATED_BY
547: ,X_LAST_UPDATE_LOGIN
548: )RETURNING SPL_ADM_CAT_ID INTO X_SPL_ADM_CAT_ID;
549: IF (x_mode = 'S') THEN
550: igs_sc_gen_001.unset_ctx('R');
551: END IF;
552:
553: open c;
554: fetch c into X_ROWID;

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

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

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

691: x_last_update_date=>X_LAST_UPDATE_DATE,
692: x_last_updated_by=>X_LAST_UPDATED_BY,
693: x_last_update_login=>X_LAST_UPDATE_LOGIN);
694: IF (x_mode = 'S') THEN
695: igs_sc_gen_001.set_ctx('R');
696: END IF;
697: update IGS_AD_SPL_ADM_CAT set
698: PERSON_ID = NEW_REFERENCES.PERSON_ID,
699: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,

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

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

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

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

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

723: );
724: EXCEPTION
725: WHEN OTHERS THEN
726: IF (x_mode = 'S') THEN
727: igs_sc_gen_001.unset_ctx('R');
728: END IF;
729: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
730: -- Code to handle Security Policy error raised
731: -- 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_ADM_CAT
818: where ROWID = X_ROWID;
819: if (sql%notfound) then

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

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

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

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

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

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