APPS.IGS_RE_THS_EXAM_HIST_PKG dependencies on IGS_RE_THS_EXAM_HIST_ALL

Line 5: old_references IGS_RE_THS_EXAM_HIST_ALL%RowType;

1: package body IGS_RE_THS_EXAM_HIST_PKG as
2: /* $Header: IGSRI19B.pls 115.5 2002/11/29 03:36:43 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RE_THS_EXAM_HIST_ALL%RowType;
6: new_references IGS_RE_THS_EXAM_HIST_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_RE_THS_EXAM_HIST_ALL%RowType;

2: /* $Header: IGSRI19B.pls 115.5 2002/11/29 03:36:43 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RE_THS_EXAM_HIST_ALL%RowType;
6: new_references IGS_RE_THS_EXAM_HIST_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM IGS_RE_THS_EXAM_HIST_ALL

29: ) AS
30:
31: CURSOR cur_old_ref_values IS
32: SELECT *
33: FROM IGS_RE_THS_EXAM_HIST_ALL
34: WHERE rowid = x_rowid;
35:
36: BEGIN
37:

Line 154: FROM IGS_RE_THS_EXAM_HIST_ALL

150: AS
151:
152: CURSOR cur_rowid IS
153: SELECT rowid
154: FROM IGS_RE_THS_EXAM_HIST_ALL
155: WHERE person_id = x_person_id
156: AND ca_sequence_number = x_ca_sequence_number
157: AND the_sequence_number = x_the_sequence_number
158: AND creation_dt = x_creation_dt

Line 277: cursor C is select ROWID from IGS_RE_THS_EXAM_HIST_ALL

273: X_THESIS_RESULT_CD in VARCHAR2,
274: X_MODE in VARCHAR2 default 'R',
275: X_ORG_ID in NUMBER
276: ) as
277: cursor C is select ROWID from IGS_RE_THS_EXAM_HIST_ALL
278: where PERSON_ID = X_PERSON_ID
279: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
280: and THE_SEQUENCE_NUMBER = X_THE_SEQUENCE_NUMBER
281: and CREATION_DT = X_CREATION_DT

Line 328: insert into IGS_RE_THS_EXAM_HIST_ALL (

324: x_last_update_date => X_LAST_UPDATE_DATE,
325: x_last_update_login => X_LAST_UPDATE_LOGIN,
326: x_org_id => igs_ge_gen_003.get_org_id
327: );
328: insert into IGS_RE_THS_EXAM_HIST_ALL (
329: PERSON_ID,
330: CA_SEQUENCE_NUMBER,
331: THE_SEQUENCE_NUMBER,
332: CREATION_DT,

Line 401: from IGS_RE_THS_EXAM_HIST_ALL

397: THESIS_EXAM_TYPE,
398: THESIS_PANEL_TYPE,
399: TRACKING_ID,
400: THESIS_RESULT_CD
401: from IGS_RE_THS_EXAM_HIST_ALL
402: where ROWID = X_ROWID
403: for update nowait;
404: tlinfo c1%rowtype;
405:

Line 504: update IGS_RE_THS_EXAM_HIST_ALL set

500: x_last_update_date => X_LAST_UPDATE_DATE,
501: x_last_update_login => X_LAST_UPDATE_LOGIN
502: );
503:
504: update IGS_RE_THS_EXAM_HIST_ALL set
505: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
506: HIST_WHO = NEW_REFERENCES.HIST_WHO,
507: SUBMISSION_DT = NEW_REFERENCES.SUBMISSION_DT,
508: THESIS_EXAM_TYPE = NEW_REFERENCES.THESIS_EXAM_TYPE,

Line 541: cursor c1 is select rowid from IGS_RE_THS_EXAM_HIST_ALL

537: X_THESIS_RESULT_CD in VARCHAR2,
538: X_MODE in VARCHAR2 default 'R',
539: X_ORG_ID in NUMBER
540: ) as
541: cursor c1 is select rowid from IGS_RE_THS_EXAM_HIST_ALL
542: where PERSON_ID = X_PERSON_ID
543: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
544: and THE_SEQUENCE_NUMBER = X_THE_SEQUENCE_NUMBER
545: and CREATION_DT = X_CREATION_DT

Line 599: delete from IGS_RE_THS_EXAM_HIST_ALL

595: p_action => 'DELETE',
596: x_rowid => X_ROWID
597: );
598:
599: delete from IGS_RE_THS_EXAM_HIST_ALL
600: where ROWID = X_ROWID;
601:
602: if (sql%notfound) then
603: raise no_data_found;