APPS.IGS_PR_SDT_PR_UNT_ST_PKG dependencies on IGS_SC_GEN_001

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

324: x_last_update_login => x_last_update_login
325: );
326:
327: IF (x_mode = 'S') THEN
328: igs_sc_gen_001.set_ctx('R');
329: END IF;
330: insert into IGS_PR_SDT_PR_UNT_ST (
331: PERSON_ID,
332: COURSE_CD,

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

350: X_LAST_UPDATED_BY,
351: X_LAST_UPDATE_LOGIN
352: );
353: IF (x_mode = 'S') THEN
354: igs_sc_gen_001.unset_ctx('R');
355: END IF;
356:
357:
358: open c;

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

368: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
369: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
370: fnd_message.set_token ('ERR_CD', SQLCODE);
371: igs_ge_msg_stack.add;
372: igs_sc_gen_001.unset_ctx('R');
373: app_exception.raise_exception;
374: ELSE
375: igs_sc_gen_001.unset_ctx('R');
376: RAISE;

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

371: igs_ge_msg_stack.add;
372: igs_sc_gen_001.unset_ctx('R');
373: app_exception.raise_exception;
374: ELSE
375: igs_sc_gen_001.unset_ctx('R');
376: RAISE;
377: END IF;
378: end INSERT_ROW;
379:

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

437: x_rowid => X_ROWID
438: );
439:
440: IF (x_mode = 'S') THEN
441: igs_sc_gen_001.set_ctx('R');
442: END IF;
443: delete from IGS_PR_SDT_PR_UNT_ST
444: where ROWID = X_ROWID;
445: if (sql%notfound) then

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

444: where ROWID = X_ROWID;
445: if (sql%notfound) then
446: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
447: igs_ge_msg_stack.add;
448: igs_sc_gen_001.unset_ctx('R');
449: app_exception.raise_exception;
450: end if;
451: IF (x_mode = 'S') THEN
452: igs_sc_gen_001.unset_ctx('R');

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

448: igs_sc_gen_001.unset_ctx('R');
449: app_exception.raise_exception;
450: end if;
451: IF (x_mode = 'S') THEN
452: igs_sc_gen_001.unset_ctx('R');
453: END IF;
454:
455: end DELETE_ROW;
456: