APPS.IGS_PE_TEACH_PERIODS_PKG dependencies on IGS_SC_GEN_001

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

507: x_org_id=>igs_ge_gen_003.get_org_id
508: );
509:
510: IF (x_mode = 'S') THEN
511: igs_sc_gen_001.set_ctx('R');
512: END IF;
513: INSERT INTO igs_pe_teach_periods_all (
514: TEACHING_PERIOD_ID
515: ,PERSON_ID

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

535: ,X_LAST_UPDATE_LOGIN
536: ,NEW_REFERENCES.ORG_ID
537: );
538: IF (x_mode = 'S') THEN
539: igs_sc_gen_001.unset_ctx('R');
540: END IF;
541:
542: OPEN c;
543: FETCH c INTO X_ROWID;

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

554: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
555: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
556: fnd_message.set_token ('ERR_CD', SQLCODE);
557: igs_ge_msg_stack.add;
558: igs_sc_gen_001.unset_ctx('R');
559: app_exception.raise_exception;
560: ELSE
561: igs_sc_gen_001.unset_ctx('R');
562: RAISE;

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

557: igs_ge_msg_stack.add;
558: igs_sc_gen_001.unset_ctx('R');
559: app_exception.raise_exception;
560: ELSE
561: igs_sc_gen_001.unset_ctx('R');
562: RAISE;
563: END IF;
564:
565: END INSERT_ROW;

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

682: x_last_updated_by=>X_LAST_UPDATED_BY,
683: x_last_update_login=>X_LAST_UPDATE_LOGIN);
684:
685: IF (x_mode = 'S') THEN
686: igs_sc_gen_001.set_ctx('R');
687: END IF;
688: UPDATE igs_pe_teach_periods_all
689: SET PERSON_ID = NEW_REFERENCES.PERSON_ID,
690: TEACH_PERIOD_RESID_STAT_CD = NEW_REFERENCES.TEACH_PERIOD_RESID_STAT_CD,

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

697:
698: IF (SQL%NOTFOUND) THEN
699: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
700: igs_ge_msg_stack.add;
701: igs_sc_gen_001.unset_ctx('R');
702: app_exception.raise_exception;
703: END IF;
704: IF (x_mode = 'S') THEN
705: igs_sc_gen_001.unset_ctx('R');

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

701: igs_sc_gen_001.unset_ctx('R');
702: app_exception.raise_exception;
703: END IF;
704: IF (x_mode = 'S') THEN
705: igs_sc_gen_001.unset_ctx('R');
706: END IF;
707:
708:
709: After_DML (

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

715: IF (SQLCODE = (-28115)) THEN
716: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
717: fnd_message.set_token ('ERR_CD', SQLCODE);
718: igs_ge_msg_stack.add;
719: igs_sc_gen_001.unset_ctx('R');
720: app_exception.raise_exception;
721: ELSE
722: igs_sc_gen_001.unset_ctx('R');
723: RAISE;

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

718: igs_ge_msg_stack.add;
719: igs_sc_gen_001.unset_ctx('R');
720: app_exception.raise_exception;
721: ELSE
722: igs_sc_gen_001.unset_ctx('R');
723: RAISE;
724: END IF;
725:
726: END UPDATE_ROW;

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

797: p_action => 'DELETE',
798: x_rowid => X_ROWID
799: );
800: IF (x_mode = 'S') THEN
801: igs_sc_gen_001.set_ctx('R');
802: END IF;
803: delete from igs_pe_teach_periods_all
804: where ROWID = X_ROWID;
805: if (sql%notfound) then

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

804: where ROWID = X_ROWID;
805: if (sql%notfound) then
806: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
807: igs_ge_msg_stack.add;
808: igs_sc_gen_001.unset_ctx('R');
809: app_exception.raise_exception;
810: end if;
811: IF (x_mode = 'S') THEN
812: igs_sc_gen_001.unset_ctx('R');

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

808: igs_sc_gen_001.unset_ctx('R');
809: app_exception.raise_exception;
810: end if;
811: IF (x_mode = 'S') THEN
812: igs_sc_gen_001.unset_ctx('R');
813: END IF;
814:
815: After_DML (
816: p_action => 'DELETE',