APPS.IGS_RE_SPRVSR_PKG dependencies on IGS_SC_GEN_001

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

1009: x_last_update_login => X_LAST_UPDATE_LOGIN
1010: );
1011:
1012: IF (x_mode = 'S') THEN
1013: igs_sc_gen_001.set_ctx('R');
1014: END IF;
1015: insert into IGS_RE_SPRVSR (
1016: CA_PERSON_ID,
1017: CA_SEQUENCE_NUMBER,

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

1055: X_LAST_UPDATED_BY,
1056: X_LAST_UPDATE_LOGIN
1057: );
1058: IF (x_mode = 'S') THEN
1059: igs_sc_gen_001.unset_ctx('R');
1060: END IF;
1061:
1062:
1063: open c;

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

1078: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1079: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1080: fnd_message.set_token ('ERR_CD', SQLCODE);
1081: igs_ge_msg_stack.add;
1082: igs_sc_gen_001.unset_ctx('R');
1083: app_exception.raise_exception;
1084: ELSE
1085: igs_sc_gen_001.unset_ctx('R');
1086: RAISE;

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

1081: igs_ge_msg_stack.add;
1082: igs_sc_gen_001.unset_ctx('R');
1083: app_exception.raise_exception;
1084: ELSE
1085: igs_sc_gen_001.unset_ctx('R');
1086: RAISE;
1087: END IF;
1088:
1089: end INSERT_ROW;

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

1239: x_last_update_login => X_LAST_UPDATE_LOGIN
1240: );
1241:
1242: IF (x_mode = 'S') THEN
1243: igs_sc_gen_001.set_ctx('R');
1244: END IF;
1245: update IGS_RE_SPRVSR set
1246: START_DT = NEW_REFERENCES.START_DT,
1247: END_DT = NEW_REFERENCES.END_DT,

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

1261: ;
1262: if (sql%notfound) then
1263: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1264: igs_ge_msg_stack.add;
1265: igs_sc_gen_001.unset_ctx('R');
1266: app_exception.raise_exception;
1267: end if;
1268: IF (x_mode = 'S') THEN
1269: igs_sc_gen_001.unset_ctx('R');

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

1265: igs_sc_gen_001.unset_ctx('R');
1266: app_exception.raise_exception;
1267: end if;
1268: IF (x_mode = 'S') THEN
1269: igs_sc_gen_001.unset_ctx('R');
1270: END IF;
1271:
1272:
1273: After_DML (

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

1280: IF (SQLCODE = (-28115)) THEN
1281: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1282: fnd_message.set_token ('ERR_CD', SQLCODE);
1283: igs_ge_msg_stack.add;
1284: igs_sc_gen_001.unset_ctx('R');
1285: app_exception.raise_exception;
1286: ELSE
1287: igs_sc_gen_001.unset_ctx('R');
1288: RAISE;

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

1283: igs_ge_msg_stack.add;
1284: igs_sc_gen_001.unset_ctx('R');
1285: app_exception.raise_exception;
1286: ELSE
1287: igs_sc_gen_001.unset_ctx('R');
1288: RAISE;
1289: END IF;
1290:
1291: end UPDATE_ROW;

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

1373: x_rowid => X_ROWID
1374: );
1375:
1376: IF (x_mode = 'S') THEN
1377: igs_sc_gen_001.set_ctx('R');
1378: END IF;
1379: delete from IGS_RE_SPRVSR
1380: where ROWID = X_ROWID;
1381: if (sql%notfound) then

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

1380: where ROWID = X_ROWID;
1381: if (sql%notfound) then
1382: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1383: igs_ge_msg_stack.add;
1384: igs_sc_gen_001.unset_ctx('R');
1385: app_exception.raise_exception;
1386: end if;
1387: IF (x_mode = 'S') THEN
1388: igs_sc_gen_001.unset_ctx('R');

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

1384: igs_sc_gen_001.unset_ctx('R');
1385: app_exception.raise_exception;
1386: end if;
1387: IF (x_mode = 'S') THEN
1388: igs_sc_gen_001.unset_ctx('R');
1389: END IF;
1390:
1391: end DELETE_ROW;
1392: