APPS.IGS_PE_RACE_PKG dependencies on IGS_SC_GEN_001

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

260: x_last_update_login => x_last_update_login
261: );
262:
263: IF (x_mode = 'S') THEN
264: igs_sc_gen_001.set_ctx('R');
265: END IF;
266: INSERT INTO igs_pe_race (
267: person_id,
268: race_cd,

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

280: x_last_updated_by,
281: x_last_update_login
282: ) RETURNING ROWID INTO x_rowid;
283: IF (x_mode = 'S') THEN
284: igs_sc_gen_001.unset_ctx('R');
285: END IF;
286:
287:
288:

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

291: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
292: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
293: fnd_message.set_token ('ERR_CD', SQLCODE);
294: igs_ge_msg_stack.add;
295: igs_sc_gen_001.unset_ctx('R');
296: app_exception.raise_exception;
297: ELSE
298: igs_sc_gen_001.unset_ctx('R');
299: RAISE;

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

294: igs_ge_msg_stack.add;
295: igs_sc_gen_001.unset_ctx('R');
296: app_exception.raise_exception;
297: ELSE
298: igs_sc_gen_001.unset_ctx('R');
299: RAISE;
300: END IF;
301: END insert_row;
302:

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

363: x_rowid => x_rowid
364: );
365:
366: IF (x_mode = 'S') THEN
367: igs_sc_gen_001.set_ctx('R');
368: END IF;
369: DELETE FROM igs_pe_race
370: WHERE rowid = x_rowid;
371:

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

371:
372: IF (SQL%NOTFOUND) THEN
373: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
374: igs_ge_msg_stack.add;
375: igs_sc_gen_001.unset_ctx('R');
376: app_exception.raise_exception;
377: END IF;
378: IF (x_mode = 'S') THEN
379: igs_sc_gen_001.unset_ctx('R');

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

375: igs_sc_gen_001.unset_ctx('R');
376: app_exception.raise_exception;
377: END IF;
378: IF (x_mode = 'S') THEN
379: igs_sc_gen_001.unset_ctx('R');
380: END IF;
381:
382:
383: END delete_row;