APPS.IGS_RE_SCHOLARSHIP_PKG dependencies on IGS_SC_GEN_001

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

456: x_org_id => igs_ge_gen_003.get_org_id
457: );
458:
459: IF (x_mode = 'S') THEN
460: igs_sc_gen_001.set_ctx('R');
461: END IF;
462: insert into IGS_RE_SCHOLARSHIP_ALL (
463: PERSON_ID,
464: CA_SEQUENCE_NUMBER,

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

492: X_LAST_UPDATE_LOGIN,
493: NEW_REFERENCES.ORG_ID
494: );
495: IF (x_mode = 'S') THEN
496: igs_sc_gen_001.unset_ctx('R');
497: END IF;
498:
499:
500: open c;

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

516: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
517: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
518: fnd_message.set_token ('ERR_CD', SQLCODE);
519: igs_ge_msg_stack.add;
520: igs_sc_gen_001.unset_ctx('R');
521: app_exception.raise_exception;
522: ELSE
523: igs_sc_gen_001.unset_ctx('R');
524: RAISE;

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

519: igs_ge_msg_stack.add;
520: igs_sc_gen_001.unset_ctx('R');
521: app_exception.raise_exception;
522: ELSE
523: igs_sc_gen_001.unset_ctx('R');
524: RAISE;
525: END IF;
526:
527: end INSERT_ROW;

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

639: x_last_update_date => X_LAST_UPDATE_DATE,
640: x_last_update_login => X_LAST_UPDATE_LOGIN
641: );
642: IF (x_mode = 'S') THEN
643: igs_sc_gen_001.set_ctx('R');
644: END IF;
645: update IGS_RE_SCHOLARSHIP_ALL set
646: END_DT = NEW_REFERENCES.END_DT,
647: DOLLAR_VALUE = NEW_REFERENCES.DOLLAR_VALUE,

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

655: ;
656: if (sql%notfound) then
657: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
658: igs_ge_msg_stack.add;
659: igs_sc_gen_001.unset_ctx('R');
660: app_exception.raise_exception;
661: end if;
662: IF (x_mode = 'S') THEN
663: igs_sc_gen_001.unset_ctx('R');

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

659: igs_sc_gen_001.unset_ctx('R');
660: app_exception.raise_exception;
661: end if;
662: IF (x_mode = 'S') THEN
663: igs_sc_gen_001.unset_ctx('R');
664: END IF;
665:
666:
667: EXCEPTION

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

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

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

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

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

745: x_rowid => X_ROWID
746: );
747:
748: IF (x_mode = 'S') THEN
749: igs_sc_gen_001.set_ctx('R');
750: END IF;
751: delete from IGS_RE_SCHOLARSHIP_ALL
752: where ROWID = X_ROWID;
753: if (sql%notfound) then

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

752: where ROWID = X_ROWID;
753: if (sql%notfound) then
754: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
755: igs_ge_msg_stack.add;
756: igs_sc_gen_001.unset_ctx('R');
757: app_exception.raise_exception;
758: end if;
759: IF (x_mode = 'S') THEN
760: igs_sc_gen_001.unset_ctx('R');

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

756: igs_sc_gen_001.unset_ctx('R');
757: app_exception.raise_exception;
758: end if;
759: IF (x_mode = 'S') THEN
760: igs_sc_gen_001.unset_ctx('R');
761: END IF;
762:
763:
764: end DELETE_ROW;