APPS.IGS_EN_SPA_AWD_AIM_PKG dependencies on IGS_SC_GEN_001

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

996: x_gs_version_number => x_gs_version_number
997: );
998:
999: IF (x_mode = 'S') THEN
1000: igs_sc_gen_001.set_ctx('R');
1001: END IF;
1002: INSERT INTO igs_en_spa_awd_aim (
1003: person_id,
1004: course_cd,

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

1035: new_references.grading_schema_cd,
1036: new_references.gs_version_number
1037: );
1038: IF (x_mode = 'S') THEN
1039: igs_sc_gen_001.unset_ctx('R');
1040: END IF;
1041:
1042: OPEN c;
1043: FETCH c INTO x_rowid;

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

1053: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1054: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1055: fnd_message.set_token ('ERR_CD', SQLCODE);
1056: igs_ge_msg_stack.add;
1057: igs_sc_gen_001.unset_ctx('R');
1058: app_exception.raise_exception;
1059: ELSE
1060: igs_sc_gen_001.unset_ctx('R');
1061: RAISE;

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

1056: igs_ge_msg_stack.add;
1057: igs_sc_gen_001.unset_ctx('R');
1058: app_exception.raise_exception;
1059: ELSE
1060: igs_sc_gen_001.unset_ctx('R');
1061: RAISE;
1062: END IF;
1063: END insert_row;
1064:

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

1205:
1206: );
1207:
1208: IF (x_mode = 'S') THEN
1209: igs_sc_gen_001.set_ctx('R');
1210: END IF;
1211: UPDATE igs_en_spa_awd_aim
1212: SET
1213: award_cd = new_references.award_cd,

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

1226:
1227: IF (SQL%NOTFOUND) THEN
1228: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1229: igs_ge_msg_stack.add;
1230: igs_sc_gen_001.unset_ctx('R');
1231: app_exception.raise_exception;
1232: END IF;
1233: IF (x_mode = 'S') THEN
1234: igs_sc_gen_001.unset_ctx('R');

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

1230: igs_sc_gen_001.unset_ctx('R');
1231: app_exception.raise_exception;
1232: END IF;
1233: IF (x_mode = 'S') THEN
1234: igs_sc_gen_001.unset_ctx('R');
1235: END IF;
1236:
1237: After_DML(
1238: p_action => 'UPDATE',

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

1246: IF (SQLCODE = (-28115)) THEN
1247: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1248: fnd_message.set_token ('ERR_CD', SQLCODE);
1249: igs_ge_msg_stack.add;
1250: igs_sc_gen_001.unset_ctx('R');
1251: app_exception.raise_exception;
1252: ELSE
1253: igs_sc_gen_001.unset_ctx('R');
1254: RAISE;

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

1249: igs_ge_msg_stack.add;
1250: igs_sc_gen_001.unset_ctx('R');
1251: app_exception.raise_exception;
1252: ELSE
1253: igs_sc_gen_001.unset_ctx('R');
1254: RAISE;
1255: END IF;
1256: END update_row;
1257:

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

1353: x_rowid => x_rowid
1354: );
1355:
1356: IF (x_mode = 'S') THEN
1357: igs_sc_gen_001.set_ctx('R');
1358: END IF;
1359: DELETE FROM igs_en_spa_awd_aim
1360: WHERE rowid = x_rowid;
1361:

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

1361:
1362: IF (SQL%NOTFOUND) THEN
1363: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1364: igs_ge_msg_stack.add;
1365: igs_sc_gen_001.unset_ctx('R');
1366: app_exception.raise_exception;
1367: END IF;
1368: IF (x_mode = 'S') THEN
1369: igs_sc_gen_001.unset_ctx('R');

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

1365: igs_sc_gen_001.unset_ctx('R');
1366: app_exception.raise_exception;
1367: END IF;
1368: IF (x_mode = 'S') THEN
1369: igs_sc_gen_001.unset_ctx('R');
1370: END IF;
1371:
1372:
1373: END delete_row;