APPS.IGS_RE_THESIS_PKG dependencies on IGS_SC_GEN_001

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

730: x_last_update_login => X_LAST_UPDATE_LOGIN,
731: x_org_id => igs_ge_gen_003.get_org_id
732: );
733: IF (x_mode = 'S') THEN
734: igs_sc_gen_001.set_ctx('R');
735: END IF;
736: insert into IGS_RE_THESIS_ALL (
737: PERSON_ID,
738: CA_SEQUENCE_NUMBER,

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

784: X_LAST_UPDATE_LOGIN,
785: NEW_REFERENCES.ORG_ID
786: );
787: IF (x_mode = 'S') THEN
788: igs_sc_gen_001.unset_ctx('R');
789: END IF;
790:
791: open c;
792: fetch c into X_ROWID;

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

807: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
808: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
809: fnd_message.set_token ('ERR_CD', SQLCODE);
810: igs_ge_msg_stack.add;
811: igs_sc_gen_001.unset_ctx('R');
812: app_exception.raise_exception;
813: ELSE
814: igs_sc_gen_001.unset_ctx('R');
815: RAISE;

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

810: igs_ge_msg_stack.add;
811: igs_sc_gen_001.unset_ctx('R');
812: app_exception.raise_exception;
813: ELSE
814: igs_sc_gen_001.unset_ctx('R');
815: RAISE;
816: END IF;
817:
818: end INSERT_ROW;

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

988: x_last_update_date => X_LAST_UPDATE_DATE,
989: x_last_update_login => X_LAST_UPDATE_LOGIN
990: );
991: IF (x_mode = 'S') THEN
992: igs_sc_gen_001.set_ctx('R');
993: END IF;
994: update IGS_RE_THESIS_ALL set
995: TITLE = NEW_REFERENCES.TITLE,
996: FINAL_TITLE_IND = NEW_REFERENCES.FINAL_TITLE_IND,

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

1014: ;
1015: if (sql%notfound) then
1016: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1017: igs_ge_msg_stack.add;
1018: igs_sc_gen_001.unset_ctx('R');
1019: app_exception.raise_exception;
1020: end if;
1021: IF (x_mode = 'S') THEN
1022: igs_sc_gen_001.unset_ctx('R');

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

1018: igs_sc_gen_001.unset_ctx('R');
1019: app_exception.raise_exception;
1020: end if;
1021: IF (x_mode = 'S') THEN
1022: igs_sc_gen_001.unset_ctx('R');
1023: END IF;
1024:
1025: After_DML (
1026: p_action => 'UPDATE',

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

1031: IF (SQLCODE = (-28115)) THEN
1032: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1033: fnd_message.set_token ('ERR_CD', SQLCODE);
1034: igs_ge_msg_stack.add;
1035: igs_sc_gen_001.unset_ctx('R');
1036: app_exception.raise_exception;
1037: ELSE
1038: igs_sc_gen_001.unset_ctx('R');
1039: RAISE;

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

1034: igs_ge_msg_stack.add;
1035: igs_sc_gen_001.unset_ctx('R');
1036: app_exception.raise_exception;
1037: ELSE
1038: igs_sc_gen_001.unset_ctx('R');
1039: RAISE;
1040: END IF;
1041:
1042: end UPDATE_ROW;

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

1129: p_action => 'DELETE',
1130: x_rowid => X_ROWID
1131: );
1132: IF (x_mode = 'S') THEN
1133: igs_sc_gen_001.set_ctx('R');
1134: END IF;
1135: delete from IGS_RE_THESIS_ALL
1136: where ROWID = X_ROWID;
1137: if (sql%notfound) then

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

1136: where ROWID = X_ROWID;
1137: if (sql%notfound) then
1138: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1139: igs_ge_msg_stack.add;
1140: igs_sc_gen_001.unset_ctx('R');
1141: app_exception.raise_exception;
1142: end if;
1143: IF (x_mode = 'S') THEN
1144: igs_sc_gen_001.unset_ctx('R');

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

1140: igs_sc_gen_001.unset_ctx('R');
1141: app_exception.raise_exception;
1142: end if;
1143: IF (x_mode = 'S') THEN
1144: igs_sc_gen_001.unset_ctx('R');
1145: END IF;
1146:
1147: After_DML (
1148: p_action => 'DELETE',