APPS.IGS_AD_PS_APPL_INST_PKG dependencies on IGS_SC_GEN_001

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

5278: x_ais_reason => x_ais_reason,
5279: x_decline_ofr_reason => x_decline_ofr_reason
5280: );
5281: IF (x_mode = 'S') THEN
5282: igs_sc_gen_001.set_ctx('R');
5283: END IF;
5284: insert into IGS_AD_PS_APPL_INST_ALL (
5285: ORG_ID,
5286: PERSON_ID

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

5562: ,new_references.ais_reason
5563: ,new_references.decline_ofr_reason
5564: );
5565: IF (x_mode = 'S') THEN
5566: igs_sc_gen_001.unset_ctx('R');
5567: END IF;
5568:
5569: open c;
5570: fetch c into X_ROWID;

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

5578: x_rowid => X_ROWID );
5579: EXCEPTION
5580: WHEN OTHERS THEN
5581: IF (x_mode = 'S') THEN
5582: igs_sc_gen_001.unset_ctx('R');
5583: END IF;
5584: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
5585: -- Code to handle Security Policy error raised
5586: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

6359: X_PROGRAM_UPDATE_DATE := SYSDATE;
6360: end if;
6361: end if;
6362: IF (x_mode = 'S') THEN
6363: igs_sc_gen_001.set_ctx('R');
6364: END IF;
6365:
6366: update IGS_AD_PS_APPL_INST_ALL set
6367: PREDICTED_GPA = NEW_REFERENCES.PREDICTED_GPA,

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

6502:
6503: IF (sql%notfound) THEN
6504: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
6505: igs_ge_msg_stack.add;
6506: igs_sc_gen_001.unset_ctx('R');
6507: app_exception.raise_exception;
6508: END IF;
6509: IF (x_mode = 'S') THEN
6510: igs_sc_gen_001.unset_ctx('R');

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

6506: igs_sc_gen_001.unset_ctx('R');
6507: app_exception.raise_exception;
6508: END IF;
6509: IF (x_mode = 'S') THEN
6510: igs_sc_gen_001.unset_ctx('R');
6511: END IF;
6512:
6513: After_DML (
6514: p_action => 'UPDATE' ,

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

6517:
6518: EXCEPTION
6519: WHEN OTHERS THEN
6520: IF (x_mode = 'S') THEN
6521: igs_sc_gen_001.unset_ctx('R');
6522: END IF;
6523: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
6524: -- Code to handle Security Policy error raised
6525: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

6978: p_action => 'DELETE',
6979: x_rowid => X_ROWID
6980: );
6981: IF (x_mode = 'S') THEN
6982: igs_sc_gen_001.set_ctx('R');
6983: END IF;
6984: delete from IGS_AD_PS_APPL_INST_ALL
6985: where ROWID = X_ROWID;
6986: if (sql%notfound) then

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

6985: where ROWID = X_ROWID;
6986: if (sql%notfound) then
6987: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
6988: igs_ge_msg_stack.add;
6989: igs_sc_gen_001.unset_ctx('R');
6990: app_exception.raise_exception;
6991: end if;
6992: IF (x_mode = 'S') THEN
6993: igs_sc_gen_001.unset_ctx('R');

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

6989: igs_sc_gen_001.unset_ctx('R');
6990: app_exception.raise_exception;
6991: end if;
6992: IF (x_mode = 'S') THEN
6993: igs_sc_gen_001.unset_ctx('R');
6994: END IF;
6995:
6996: After_DML (
6997: p_action => 'DELETE',

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

6999: );
7000: EXCEPTION
7001: WHEN OTHERS THEN
7002: IF (x_mode = 'S') THEN
7003: igs_sc_gen_001.unset_ctx('R');
7004: END IF;
7005: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
7006: -- Code to handle Security Policy error raised
7007: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.