APPS.IGS_PS_STDNT_SPL_REQ_PKG dependencies on IGS_SC_GEN_001

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

471: );
472:
473:
474: IF (x_mode = 'S') THEN
475: igs_sc_gen_001.set_ctx('R');
476: END IF;
477: insert into IGS_PS_STDNT_SPL_REQ (
478: PERSON_ID,
479: COURSE_CD,

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

501: X_LAST_UPDATED_BY,
502: X_LAST_UPDATE_LOGIN
503: );
504: IF (x_mode = 'S') THEN
505: igs_sc_gen_001.unset_ctx('R');
506: END IF;
507:
508:
509: open c;

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

524: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
525: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
526: fnd_message.set_token ('ERR_CD', SQLCODE);
527: igs_ge_msg_stack.add;
528: igs_sc_gen_001.unset_ctx('R');
529: app_exception.raise_exception;
530: ELSE
531: igs_sc_gen_001.unset_ctx('R');
532: RAISE;

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

527: igs_ge_msg_stack.add;
528: igs_sc_gen_001.unset_ctx('R');
529: app_exception.raise_exception;
530: ELSE
531: igs_sc_gen_001.unset_ctx('R');
532: RAISE;
533: END IF;
534:
535: end INSERT_ROW;

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

635: x_last_update_login => X_LAST_UPDATE_LOGIN
636: );
637:
638: IF (x_mode = 'S') THEN
639: igs_sc_gen_001.set_ctx('R');
640: END IF;
641: update IGS_PS_STDNT_SPL_REQ set
642: EXPIRY_DT = NEW_REFERENCES.EXPIRY_DT,
643: REFERENCE = NEW_REFERENCES.REFERENCE,

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

649: ;
650: if (sql%notfound) then
651: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
652: igs_ge_msg_stack.add;
653: igs_sc_gen_001.unset_ctx('R');
654: app_exception.raise_exception;
655: end if;
656: IF (x_mode = 'S') THEN
657: igs_sc_gen_001.unset_ctx('R');

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

653: igs_sc_gen_001.unset_ctx('R');
654: app_exception.raise_exception;
655: end if;
656: IF (x_mode = 'S') THEN
657: igs_sc_gen_001.unset_ctx('R');
658: END IF;
659:
660: After_DML (
661: p_action => 'UPDATE',

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

667: IF (SQLCODE = (-28115)) THEN
668: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
669: fnd_message.set_token ('ERR_CD', SQLCODE);
670: igs_ge_msg_stack.add;
671: igs_sc_gen_001.unset_ctx('R');
672: app_exception.raise_exception;
673: ELSE
674: igs_sc_gen_001.unset_ctx('R');
675: RAISE;

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

670: igs_ge_msg_stack.add;
671: igs_sc_gen_001.unset_ctx('R');
672: app_exception.raise_exception;
673: ELSE
674: igs_sc_gen_001.unset_ctx('R');
675: RAISE;
676: END IF;
677:
678: end UPDATE_ROW;

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

734: x_rowid => X_ROWID
735: );
736:
737: IF (x_mode = 'S') THEN
738: igs_sc_gen_001.set_ctx('R');
739: END IF;
740: delete from IGS_PS_STDNT_SPL_REQ
741: where ROWID = X_ROWID;
742: if (sql%notfound) then

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

741: where ROWID = X_ROWID;
742: if (sql%notfound) then
743: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
744: igs_ge_msg_stack.add;
745: igs_sc_gen_001.unset_ctx('R');
746: app_exception.raise_exception;
747: end if;
748: IF (x_mode = 'S') THEN
749: igs_sc_gen_001.unset_ctx('R');

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

745: igs_sc_gen_001.unset_ctx('R');
746: app_exception.raise_exception;
747: end if;
748: IF (x_mode = 'S') THEN
749: igs_sc_gen_001.unset_ctx('R');
750: END IF;
751:
752:
753: After_DML(