APPS.IGS_RE_THESIS_HIST_PKG dependencies on IGS_RE_THESIS_HIST_ALL

Line 5: old_references IGS_RE_THESIS_HIST_ALL%RowType;

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

Line 6: new_references IGS_RE_THESIS_HIST_ALL%RowType;

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

Line 42: FROM IGS_RE_THESIS_HIST_ALL

38: ) AS
39:
40: CURSOR cur_old_ref_values IS
41: SELECT *
42: FROM IGS_RE_THESIS_HIST_ALL
43: WHERE rowid = x_rowid;
44:
45: BEGIN
46:

Line 177: FROM IGS_RE_THESIS_HIST_ALL

173: AS
174:
175: CURSOR cur_rowid IS
176: SELECT rowid
177: FROM IGS_RE_THESIS_HIST_ALL
178: WHERE person_id = x_person_id
179: AND ca_sequence_number = x_ca_sequence_number
180: AND sequence_number = x_sequence_number
181: AND hist_start_dt = x_hist_start_dt

Line 324: cursor C is select ROWID from IGS_RE_THESIS_HIST_ALL

320: X_COMMENTS in VARCHAR2,
321: X_MODE in VARCHAR2 default 'R',
322: X_ORG_ID in NUMBER
323: ) as
324: cursor C is select ROWID from IGS_RE_THESIS_HIST_ALL
325: where PERSON_ID = X_PERSON_ID
326: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
327: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
328: and HIST_START_DT = X_HIST_START_DT;

Line 385: insert into IGS_RE_THESIS_HIST_ALL (

381: x_org_id => igs_ge_gen_003.get_org_id
382: );
383:
384:
385: insert into IGS_RE_THESIS_HIST_ALL (
386: PERSON_ID,
387: CA_SEQUENCE_NUMBER,
388: SEQUENCE_NUMBER,
389: HIST_START_DT,

Line 494: from IGS_RE_THESIS_HIST_ALL

490: EMBARGO_DETAILS,
491: THESIS_TOPIC,
492: CITATION,
493: COMMENTS
494: from IGS_RE_THESIS_HIST_ALL
495: where ROWID = X_ROWID
496: for update nowait;
497: tlinfo c1%rowtype;
498:

Line 646: update IGS_RE_THESIS_HIST_ALL set

642: x_last_update_date => X_LAST_UPDATE_DATE,
643: x_last_update_login => X_LAST_UPDATE_LOGIN
644: );
645:
646: update IGS_RE_THESIS_HIST_ALL set
647: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
648: HIST_WHO = NEW_REFERENCES.HIST_WHO,
649: TITLE = NEW_REFERENCES.TITLE,
650: FINAL_TITLE_IND = NEW_REFERENCES.FINAL_TITLE_IND,

Line 701: cursor c1 is select rowid from IGS_RE_THESIS_HIST_ALL

697: X_COMMENTS in VARCHAR2,
698: X_MODE in VARCHAR2 default 'R',
699: X_ORG_ID in NUMBER
700: ) as
701: cursor c1 is select rowid from IGS_RE_THESIS_HIST_ALL
702: where PERSON_ID = X_PERSON_ID
703: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
704: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
705: and HIST_START_DT = X_HIST_START_DT

Line 776: delete from IGS_RE_THESIS_HIST_ALL

772: p_action => 'DELETE',
773: x_rowid => X_ROWID
774: );
775:
776: delete from IGS_RE_THESIS_HIST_ALL
777: where ROWID = X_ROWID;
778: if (sql%notfound) then
779: raise no_data_found;
780: end if;