APPS.IGS_PR_STDNT_PR_AWD_PKG dependencies on IGS_SC_GEN_001

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

332: x_last_update_login => x_last_update_login
333: );
334:
335: IF (x_mode = 'S') THEN
336: igs_sc_gen_001.set_ctx('R');
337: END IF;
338: INSERT INTO igs_pr_stdnt_pr_awd (
339: person_id,
340: course_cd,

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

356: x_last_updated_by,
357: x_last_update_login
358: );
359: IF (x_mode = 'S') THEN
360: igs_sc_gen_001.unset_ctx('R');
361: END IF;
362:
363:
364: OPEN c;

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

375: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
376: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
377: fnd_message.set_token ('ERR_CD', SQLCODE);
378: igs_ge_msg_stack.add;
379: igs_sc_gen_001.unset_ctx('R');
380: app_exception.raise_exception;
381: ELSE
382: igs_sc_gen_001.unset_ctx('R');
383: RAISE;

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

378: igs_ge_msg_stack.add;
379: igs_sc_gen_001.unset_ctx('R');
380: app_exception.raise_exception;
381: ELSE
382: igs_sc_gen_001.unset_ctx('R');
383: RAISE;
384: END IF;
385: END insert_row;
386:

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

449: x_rowid => x_rowid
450: );
451:
452: IF (x_mode = 'S') THEN
453: igs_sc_gen_001.set_ctx('R');
454: END IF;
455: DELETE FROM igs_pr_stdnt_pr_awd
456: WHERE rowid = x_rowid;
457:

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

457:
458: IF (SQL%NOTFOUND) THEN
459: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
460: igs_ge_msg_stack.add;
461: igs_sc_gen_001.unset_ctx('R');
462: app_exception.raise_exception;
463: END IF;
464: IF (x_mode = 'S') THEN
465: igs_sc_gen_001.unset_ctx('R');

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

461: igs_sc_gen_001.unset_ctx('R');
462: app_exception.raise_exception;
463: END IF;
464: IF (x_mode = 'S') THEN
465: igs_sc_gen_001.unset_ctx('R');
466: END IF;
467:
468:
469: END delete_row;