APPS.IGS_RE_THESIS_EXAM_PKG dependencies on IGS_SC_GEN_001

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

780: x_last_update_date => X_LAST_UPDATE_DATE
781: );
782:
783: IF (x_mode = 'S') THEN
784: igs_sc_gen_001.set_ctx('R');
785: END IF;
786: insert into IGS_RE_THESIS_EXAM (
787: PERSON_ID,
788: CA_SEQUENCE_NUMBER,

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

814: X_LAST_UPDATED_BY,
815: X_LAST_UPDATE_LOGIN
816: );
817: IF (x_mode = 'S') THEN
818: igs_sc_gen_001.unset_ctx('R');
819: END IF;
820:
821:
822: open c;

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

838: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
839: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
840: fnd_message.set_token ('ERR_CD', SQLCODE);
841: igs_ge_msg_stack.add;
842: igs_sc_gen_001.unset_ctx('R');
843: app_exception.raise_exception;
844: ELSE
845: igs_sc_gen_001.unset_ctx('R');
846: RAISE;

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

841: igs_ge_msg_stack.add;
842: igs_sc_gen_001.unset_ctx('R');
843: app_exception.raise_exception;
844: ELSE
845: igs_sc_gen_001.unset_ctx('R');
846: RAISE;
847: END IF;
848:
849: end INSERT_ROW;

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

957: x_last_update_date => X_LAST_UPDATE_DATE
958: );
959:
960: IF (x_mode = 'S') THEN
961: igs_sc_gen_001.set_ctx('R');
962: END IF;
963: update IGS_RE_THESIS_EXAM set
964: SUBMISSION_DT = NEW_REFERENCES.SUBMISSION_DT,
965: THESIS_EXAM_TYPE = NEW_REFERENCES.THESIS_EXAM_TYPE,

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

973: ;
974: if (sql%notfound) then
975: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
976: igs_ge_msg_stack.add;
977: igs_sc_gen_001.unset_ctx('R');
978: app_exception.raise_exception;
979: end if;
980: IF (x_mode = 'S') THEN
981: igs_sc_gen_001.unset_ctx('R');

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

977: igs_sc_gen_001.unset_ctx('R');
978: app_exception.raise_exception;
979: end if;
980: IF (x_mode = 'S') THEN
981: igs_sc_gen_001.unset_ctx('R');
982: END IF;
983:
984:
985: After_DML (

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

992: IF (SQLCODE = (-28115)) THEN
993: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
994: fnd_message.set_token ('ERR_CD', SQLCODE);
995: igs_ge_msg_stack.add;
996: igs_sc_gen_001.unset_ctx('R');
997: app_exception.raise_exception;
998: ELSE
999: igs_sc_gen_001.unset_ctx('R');
1000: RAISE;

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

995: igs_ge_msg_stack.add;
996: igs_sc_gen_001.unset_ctx('R');
997: app_exception.raise_exception;
998: ELSE
999: igs_sc_gen_001.unset_ctx('R');
1000: RAISE;
1001: END IF;
1002:
1003: end UPDATE_ROW;

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

1066: x_rowid => X_ROWID
1067: );
1068:
1069: IF (x_mode = 'S') THEN
1070: igs_sc_gen_001.set_ctx('R');
1071: END IF;
1072: delete from IGS_RE_THESIS_EXAM
1073: where ROWID = X_ROWID;
1074: if (sql%notfound) then

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

1073: where ROWID = X_ROWID;
1074: if (sql%notfound) then
1075: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1076: igs_ge_msg_stack.add;
1077: igs_sc_gen_001.unset_ctx('R');
1078: app_exception.raise_exception;
1079: end if;
1080: IF (x_mode = 'S') THEN
1081: igs_sc_gen_001.unset_ctx('R');

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

1077: igs_sc_gen_001.unset_ctx('R');
1078: app_exception.raise_exception;
1079: end if;
1080: IF (x_mode = 'S') THEN
1081: igs_sc_gen_001.unset_ctx('R');
1082: END IF;
1083:
1084:
1085: After_DML (