APPS.IGS_OR_INST_HIST_PKG dependencies on IGS_OR_INST_HIST_ALL

Line 5: old_references IGS_OR_INST_HIST_ALL%RowType;

1: package body IGS_OR_INST_HIST_PKG AS
2: /* $Header: IGSOI04B.pls 115.12 2002/11/29 01:39:15 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_OR_INST_HIST_ALL%RowType;
6: new_references IGS_OR_INST_HIST_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_OR_INST_HIST_ALL%RowType;

2: /* $Header: IGSOI04B.pls 115.12 2002/11/29 01:39:15 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_OR_INST_HIST_ALL%RowType;
6: new_references IGS_OR_INST_HIST_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 37: FROM IGS_OR_INST_HIST_ALL

33: X_ORG_ID in NUMBER
34: ) AS
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM IGS_OR_INST_HIST_ALL
38: WHERE rowid = x_rowid;
39: BEGIN
40: l_rowid := x_rowid;
41: -- Code for setting the Old and New Reference Values.

Line 97: FROM IGS_OR_INST_HIST_ALL

93: RETURN BOOLEAN
94: AS
95: CURSOR cur_rowid IS
96: SELECT rowid
97: FROM IGS_OR_INST_HIST_ALL
98: WHERE institution_cd = x_institution_cd
99: AND hist_start_dt = x_hist_start_dt
100: FOR UPDATE NOWAIT;
101: lv_rowid cur_rowid%RowType;

Line 244: cursor C is select ROWID from IGS_OR_INST_HIST_ALL

240: X_INST_CONTROL_TYPE in VARCHAR2,
241: X_MODE in VARCHAR2,
242: X_ORG_ID in NUMBER
243: ) AS
244: cursor C is select ROWID from IGS_OR_INST_HIST_ALL
245: where INSTITUTION_CD = X_INSTITUTION_CD
246: and HIST_START_DT = X_HIST_START_DT;
247: X_LAST_UPDATE_DATE DATE;
248: X_LAST_UPDATED_BY NUMBER;

Line 300: insert into IGS_OR_INST_HIST_ALL (

296: x_last_updated_by=>X_LAST_UPDATED_BY,
297: x_last_update_login=>X_LAST_UPDATE_LOGIN,
298: x_org_id=>igs_ge_gen_003.get_org_id
299: );
300: insert into IGS_OR_INST_HIST_ALL (
301: INSTITUTION_CD,
302: HIST_START_DT,
303: HIST_END_DT,
304: HIST_WHO,

Line 411: from IGS_OR_INST_HIST_ALL

407: GOVT_INSTITUTION_CD,
408: INSTITUTION_TYPE,
409: DESCRIPTION,
410: INST_CONTROL_TYPE
411: from IGS_OR_INST_HIST_ALL
412: where ROWID = X_ROWID
413: for update nowait ;
414: tlinfo c1%rowtype;
415: begin

Line 550: update IGS_OR_INST_HIST_ALL set

546: x_last_update_date=>X_LAST_UPDATE_DATE,
547: x_last_updated_by=>X_LAST_UPDATED_BY,
548: x_last_update_login=>X_LAST_UPDATE_LOGIN
549: );
550: update IGS_OR_INST_HIST_ALL set
551: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
552: HIST_WHO = NEW_REFERENCES.HIST_WHO,
553: NAME = NEW_REFERENCES.NAME,
554:

Line 606: cursor c1 is select rowid from IGS_OR_INST_HIST_ALL

602: X_INST_CONTROL_TYPE in VARCHAR2,
603: X_MODE in VARCHAR2,
604: X_ORG_ID in NUMBER
605: ) AS
606: cursor c1 is select rowid from IGS_OR_INST_HIST_ALL
607: where INSTITUTION_CD = X_INSTITUTION_CD
608: and HIST_START_DT = X_HIST_START_DT
609: ;
610: begin

Line 673: delete from IGS_OR_INST_HIST_ALL

669: Before_DML(
670: p_action=>'DELETE',
671: x_rowid=>X_ROWID
672: );
673: delete from IGS_OR_INST_HIST_ALL
674: where ROWID = X_ROWID ;
675: After_DML(
676: p_action=>'DELETE',
677: x_rowid=>X_ROWID