APPS.IGS_AD_APP_INTENT_PKG dependencies on IGS_SC_GEN_001

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

632: x_last_update_date=>X_LAST_UPDATE_DATE,
633: x_last_updated_by=>X_LAST_UPDATED_BY,
634: x_last_update_login=>X_LAST_UPDATE_LOGIN);
635: IF (x_mode = 'S') THEN
636: igs_sc_gen_001.set_ctx('R');
637: END IF;
638: insert into IGS_AD_APP_INTENT (
639: APP_INTENT_ID
640: ,PERSON_ID

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

706: ,X_PROGRAM_APPLICATION_ID
707: ,X_PROGRAM_UPDATE_DATE
708: )RETURNING APP_INTENT_ID INTO X_APP_INTENT_ID;
709: IF (x_mode = 'S') THEN
710: igs_sc_gen_001.unset_ctx('R');
711: END IF;
712:
713: open c;
714: fetch c into X_ROWID;

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

722: x_rowid => X_ROWID );
723: EXCEPTION
724: WHEN OTHERS THEN
725: IF (x_mode = 'S') THEN
726: igs_sc_gen_001.unset_ctx('R');
727: END IF;
728: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
729: -- Code to handle Security Policy error raised
730: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

1006: end if;
1007: end if;
1008:
1009: IF (x_mode = 'S') THEN
1010: igs_sc_gen_001.set_ctx('R');
1011: END IF;
1012: UPDATE IGS_AD_APP_INTENT set
1013: PERSON_ID = NEW_REFERENCES.PERSON_ID,
1014: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,

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

1045: IF (sql%notfound) THEN
1046: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1047: igs_ge_msg_stack.add;
1048: IF (x_mode = 'S') THEN
1049: igs_sc_gen_001.unset_ctx('R');
1050: END IF;
1051: app_exception.raise_exception;
1052: END IF;
1053: IF (x_mode = 'S') THEN

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

1050: END IF;
1051: app_exception.raise_exception;
1052: END IF;
1053: IF (x_mode = 'S') THEN
1054: igs_sc_gen_001.unset_ctx('R');
1055: END IF;
1056:
1057:
1058: After_DML (

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

1061: );
1062: EXCEPTION
1063: WHEN OTHERS THEN
1064: IF (x_mode = 'S') THEN
1065: igs_sc_gen_001.unset_ctx('R');
1066: END IF;
1067: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
1068: -- Code to handle Security Policy error raised
1069: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

1206: p_action => 'DELETE',
1207: x_rowid => X_ROWID
1208: );
1209: IF (x_mode = 'S') THEN
1210: igs_sc_gen_001.set_ctx('R');
1211: END IF;
1212: delete from IGS_AD_APP_INTENT
1213: where ROWID = X_ROWID;
1214: if (sql%notfound) then

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

1214: if (sql%notfound) then
1215: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1216: igs_ge_msg_stack.add;
1217: IF (x_mode = 'S') THEN
1218: igs_sc_gen_001.unset_ctx('R');
1219: END IF;
1220: app_exception.raise_exception;
1221: end if;
1222: IF (x_mode = 'S') THEN

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

1219: END IF;
1220: app_exception.raise_exception;
1221: end if;
1222: IF (x_mode = 'S') THEN
1223: igs_sc_gen_001.unset_ctx('R');
1224: END IF;
1225:
1226: After_DML (
1227: p_action => 'DELETE',

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

1229: );
1230: EXCEPTION
1231: WHEN OTHERS THEN
1232: IF (x_mode = 'S') THEN
1233: igs_sc_gen_001.unset_ctx('R');
1234: END IF;
1235: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
1236: -- Code to handle Security Policy error raised
1237: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.