APPS.IGS_AD_UNIT_SETS_PKG dependencies on IGS_SC_GEN_001

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

756: x_last_update_date=>X_LAST_UPDATE_DATE,
757: x_last_updated_by=>X_LAST_UPDATED_BY,
758: x_last_update_login=>X_LAST_UPDATE_LOGIN);
759: IF (x_mode = 'S') THEN
760: igs_sc_gen_001.set_ctx('R');
761: END IF;
762: insert into IGS_AD_UNIT_SETS (
763: UNIT_SET_ID
764: ,PERSON_ID

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

796: ,X_PROGRAM_APPLICATION_ID
797: ,X_PROGRAM_UPDATE_DATE
798: )RETURNING UNIT_SET_ID INTO X_UNIT_SET_ID;
799: IF (x_mode = 'S') THEN
800: igs_sc_gen_001.unset_ctx('R');
801: END IF;
802:
803: open c;
804: fetch c into X_ROWID;

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

812: x_rowid => X_ROWID );
813: EXCEPTION
814: WHEN OTHERS THEN
815: IF (x_mode = 'S') THEN
816: igs_sc_gen_001.unset_ctx('R');
817: END IF;
818: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
819: -- Code to handle Security Policy error raised
820: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

970: end if;
971: end if;
972:
973: IF (x_mode = 'S') THEN
974: igs_sc_gen_001.set_ctx('R');
975: END IF;
976: update IGS_AD_UNIT_SETS set
977: PERSON_ID = NEW_REFERENCES.PERSON_ID,
978: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,

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

992: if (sql%notfound) then
993: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
994: igs_ge_msg_stack.add;
995: IF (x_mode = 'S') THEN
996: igs_sc_gen_001.unset_ctx('R');
997: END IF;
998: app_exception.raise_exception;
999: end if;
1000: IF (x_mode = 'S') THEN

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

997: END IF;
998: app_exception.raise_exception;
999: end if;
1000: IF (x_mode = 'S') THEN
1001: igs_sc_gen_001.unset_ctx('R');
1002: END IF;
1003:
1004:
1005: After_DML (

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

1008: );
1009: EXCEPTION
1010: WHEN OTHERS THEN
1011: IF (x_mode = 'S') THEN
1012: igs_sc_gen_001.unset_ctx('R');
1013: END IF;
1014: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
1015: -- Code to handle Security Policy error raised
1016: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

1103: p_action => 'DELETE',
1104: x_rowid => X_ROWID
1105: );
1106: IF (x_mode = 'S') THEN
1107: igs_sc_gen_001.set_ctx('R');
1108: END IF;
1109: delete from IGS_AD_UNIT_SETS
1110: where ROWID = X_ROWID;
1111: if (sql%notfound) then

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

1111: if (sql%notfound) then
1112: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1113: igs_ge_msg_stack.add;
1114: IF (x_mode = 'S') THEN
1115: igs_sc_gen_001.unset_ctx('R');
1116: END IF;
1117: app_exception.raise_exception;
1118: end if;
1119: IF (x_mode = 'S') THEN

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

1116: END IF;
1117: app_exception.raise_exception;
1118: end if;
1119: IF (x_mode = 'S') THEN
1120: igs_sc_gen_001.unset_ctx('R');
1121: END IF;
1122:
1123: After_DML (
1124: p_action => 'DELETE',

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

1126: );
1127: EXCEPTION
1128: WHEN OTHERS THEN
1129: IF (x_mode = 'S') THEN
1130: igs_sc_gen_001.unset_ctx('R');
1131: END IF;
1132: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
1133: -- Code to handle Security Policy error raised
1134: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.