APPS.IGS_PS_FACLTY_DEGRS_PKG dependencies on IGS_SC_GEN_001

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

545: x_last_update_date=>X_LAST_UPDATE_DATE,
546: x_last_updated_by=>X_LAST_UPDATED_BY,
547: x_last_update_login=>X_LAST_UPDATE_LOGIN);
548: IF (x_mode = 'S') THEN
549: igs_sc_gen_001.set_ctx('R');
550: END IF;
551: insert into IGS_PS_FACLTY_DEGRS (
552: FACLTY_DEGRD_ID
553: ,PERSON_ID

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

573: ,X_LAST_UPDATED_BY
574: ,X_LAST_UPDATE_LOGIN
575: );
576: IF (x_mode = 'S') THEN
577: igs_sc_gen_001.unset_ctx('R');
578: END IF;
579:
580: open c;
581: fetch c into X_ROWID;

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

592: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
593: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
594: fnd_message.set_token ('ERR_CD', SQLCODE);
595: igs_ge_msg_stack.add;
596: igs_sc_gen_001.unset_ctx('R');
597: app_exception.raise_exception;
598: ELSE
599: igs_sc_gen_001.unset_ctx('R');
600: RAISE;

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

595: igs_ge_msg_stack.add;
596: igs_sc_gen_001.unset_ctx('R');
597: app_exception.raise_exception;
598: ELSE
599: igs_sc_gen_001.unset_ctx('R');
600: RAISE;
601: END IF;
602:
603: end INSERT_ROW;

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

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

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

727: where ROWID = X_ROWID;
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:
739: After_DML (

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 829: igs_sc_gen_001.set_ctx('R');

825: p_action => 'DELETE',
826: x_rowid => X_ROWID
827: );
828: IF (x_mode = 'S') THEN
829: igs_sc_gen_001.set_ctx('R');
830: END IF;
831: delete from IGS_PS_FACLTY_DEGRS
832: where ROWID = X_ROWID;
833: if (sql%notfound) then

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

832: where ROWID = X_ROWID;
833: if (sql%notfound) then
834: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
835: igs_ge_msg_stack.add;
836: igs_sc_gen_001.unset_ctx('R');
837: app_exception.raise_exception;
838: end if;
839: IF (x_mode = 'S') THEN
840: igs_sc_gen_001.unset_ctx('R');

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

836: igs_sc_gen_001.unset_ctx('R');
837: app_exception.raise_exception;
838: end if;
839: IF (x_mode = 'S') THEN
840: igs_sc_gen_001.unset_ctx('R');
841: END IF;
842:
843: After_DML (
844: p_action => 'DELETE',