APPS.IGS_AS_SC_ATMPT_ENR_PKG dependencies on IGS_SC_GEN_001

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

345: x_last_updated_by=>X_LAST_UPDATED_BY,
346: x_last_update_login=>X_LAST_UPDATE_LOGIN
347: );
348: IF (x_mode = 'S') THEN
349: igs_sc_gen_001.set_ctx('R');
350: END IF;
351: insert into IGS_AS_SC_ATMPT_ENR (
352: PERSON_ID,
353: COURSE_CD,

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

387: X_PROGRAM_APPLICATION_ID,
388: X_PROGRAM_UPDATE_DATE
389: );
390: IF (x_mode = 'S') THEN
391: igs_sc_gen_001.unset_ctx('R');
392: END IF;
393:
394: open c;
395: fetch c into X_ROWID;

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

404: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
405: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
406: fnd_message.set_token ('ERR_CD', SQLCODE);
407: igs_ge_msg_stack.add;
408: igs_sc_gen_001.unset_ctx('R');
409: app_exception.raise_exception;
410: ELSE
411: igs_sc_gen_001.unset_ctx('R');
412: RAISE;

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

407: igs_ge_msg_stack.add;
408: igs_sc_gen_001.unset_ctx('R');
409: app_exception.raise_exception;
410: ELSE
411: igs_sc_gen_001.unset_ctx('R');
412: RAISE;
413: END IF;
414:
415: end INSERT_ROW;

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

537: X_PROGRAM_UPDATE_DATE := SYSDATE;
538: end if;
539: end if;
540: IF (x_mode = 'S') THEN
541: igs_sc_gen_001.set_ctx('R');
542: END IF;
543: update IGS_AS_SC_ATMPT_ENR set
544: ENROLMENT_CAT = NEW_REFERENCES.ENROLMENT_CAT,
545: ENROLLED_DT = NEW_REFERENCES.ENROLLED_DT,

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

556: where ROWID = X_ROWID;
557: if (sql%notfound) then
558: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
559: igs_ge_msg_stack.add;
560: igs_sc_gen_001.unset_ctx('R');
561: app_exception.raise_exception;
562: end if;
563: IF (x_mode = 'S') THEN
564: igs_sc_gen_001.unset_ctx('R');

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

560: igs_sc_gen_001.unset_ctx('R');
561: app_exception.raise_exception;
562: end if;
563: IF (x_mode = 'S') THEN
564: igs_sc_gen_001.unset_ctx('R');
565: END IF;
566:
567:
568: EXCEPTION

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

570: IF (SQLCODE = (-28115)) THEN
571: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
572: fnd_message.set_token ('ERR_CD', SQLCODE);
573: igs_ge_msg_stack.add;
574: igs_sc_gen_001.unset_ctx('R');
575: app_exception.raise_exception;
576: ELSE
577: igs_sc_gen_001.unset_ctx('R');
578: RAISE;

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

573: igs_ge_msg_stack.add;
574: igs_sc_gen_001.unset_ctx('R');
575: app_exception.raise_exception;
576: ELSE
577: igs_sc_gen_001.unset_ctx('R');
578: RAISE;
579: END IF;
580:
581: end UPDATE_ROW;

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

639: p_action => 'DELETE',
640: x_rowid => X_ROWID
641: );
642: IF (x_mode = 'S') THEN
643: igs_sc_gen_001.set_ctx('R');
644: END IF;
645: delete from IGS_AS_SC_ATMPT_ENR
646: where ROWID = X_ROWID;
647: if (sql%notfound) then

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

646: where ROWID = X_ROWID;
647: if (sql%notfound) then
648: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
649: igs_ge_msg_stack.add;
650: igs_sc_gen_001.unset_ctx('R');
651: app_exception.raise_exception;
652: end if;
653: IF (x_mode = 'S') THEN
654: igs_sc_gen_001.unset_ctx('R');

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

650: igs_sc_gen_001.unset_ctx('R');
651: app_exception.raise_exception;
652: end if;
653: IF (x_mode = 'S') THEN
654: igs_sc_gen_001.unset_ctx('R');
655: END IF;
656:
657:
658: end DELETE_ROW;