APPS.IGS_PS_STDNT_APV_ALT_PKG dependencies on IGS_SC_GEN_001

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

547: x_last_updated_by => X_LAST_UPDATED_BY,
548: x_last_update_login => X_LAST_UPDATE_LOGIN
549: );
550: IF (x_mode = 'S') THEN
551: igs_sc_gen_001.set_ctx('R');
552: END IF;
553: insert into IGS_PS_STDNT_APV_ALT (
554: PERSON_ID,
555: COURSE_CD,

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

579: X_LAST_UPDATED_BY,
580: X_LAST_UPDATE_LOGIN
581: );
582: IF (x_mode = 'S') THEN
583: igs_sc_gen_001.unset_ctx('R');
584: END IF;
585:
586:
587: open c;

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

601: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
602: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
603: fnd_message.set_token ('ERR_CD', SQLCODE);
604: igs_ge_msg_stack.add;
605: igs_sc_gen_001.unset_ctx('R');
606: app_exception.raise_exception;
607: ELSE
608: igs_sc_gen_001.unset_ctx('R');
609: RAISE;

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

604: igs_ge_msg_stack.add;
605: igs_sc_gen_001.unset_ctx('R');
606: app_exception.raise_exception;
607: ELSE
608: igs_sc_gen_001.unset_ctx('R');
609: RAISE;
610: END IF;
611:
612: end INSERT_ROW;

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

712: x_last_updated_by => X_LAST_UPDATED_BY,
713: x_last_update_login => X_LAST_UPDATE_LOGIN
714: );
715: IF (x_mode = 'S') THEN
716: igs_sc_gen_001.set_ctx('R');
717: END IF;
718: update IGS_PS_STDNT_APV_ALT set
719: VERSION_NUMBER = NEW_REFERENCES.VERSION_NUMBER,
720: RQRMNTS_COMPLETE_IND = NEW_REFERENCES.RQRMNTS_COMPLETE_IND,

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

727: ;
728: if (sql%notfound) then
729: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
730: igs_ge_msg_stack.add;
731: igs_sc_gen_001.unset_ctx('R');
732: app_exception.raise_exception;
733: end if;
734: IF (x_mode = 'S') THEN
735: igs_sc_gen_001.unset_ctx('R');

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

731: igs_sc_gen_001.unset_ctx('R');
732: app_exception.raise_exception;
733: end if;
734: IF (x_mode = 'S') THEN
735: igs_sc_gen_001.unset_ctx('R');
736: END IF;
737:
738: After_DML(
739: p_action => 'UPDATE',

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

745: IF (SQLCODE = (-28115)) THEN
746: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
747: fnd_message.set_token ('ERR_CD', SQLCODE);
748: igs_ge_msg_stack.add;
749: igs_sc_gen_001.unset_ctx('R');
750: app_exception.raise_exception;
751: ELSE
752: igs_sc_gen_001.unset_ctx('R');
753: RAISE;

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

748: igs_ge_msg_stack.add;
749: igs_sc_gen_001.unset_ctx('R');
750: app_exception.raise_exception;
751: ELSE
752: igs_sc_gen_001.unset_ctx('R');
753: RAISE;
754: END IF;
755:
756: end UPDATE_ROW;

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

813: Before_DML( p_action => 'DELETE',
814: x_rowid => X_ROWID
815: );
816: IF (x_mode = 'S') THEN
817: igs_sc_gen_001.set_ctx('R');
818: END IF;
819: delete from IGS_PS_STDNT_APV_ALT
820: where ROWID = X_ROWID;
821: if (sql%notfound) then

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

820: where ROWID = X_ROWID;
821: if (sql%notfound) then
822: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
823: igs_ge_msg_stack.add;
824: igs_sc_gen_001.unset_ctx('R');
825: app_exception.raise_exception;
826: end if;
827: IF (x_mode = 'S') THEN
828: igs_sc_gen_001.unset_ctx('R');

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

824: igs_sc_gen_001.unset_ctx('R');
825: app_exception.raise_exception;
826: end if;
827: IF (x_mode = 'S') THEN
828: igs_sc_gen_001.unset_ctx('R');
829: END IF;
830:
831: After_DML(
832: p_action => 'DELETE',