APPS.IGS_OR_UNIT_HIST_PKG dependencies on IGS_OR_UNIT_HIST_ALL

Line 4: old_references IGS_OR_UNIT_HIST_ALL%RowType;

1: package body IGS_OR_UNIT_HIST_PKG AS
2: /* $Header: IGSOI12B.pls 115.8 2002/11/29 01:40:03 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_OR_UNIT_HIST_ALL%RowType;
5: new_references IGS_OR_UNIT_HIST_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_OR_UNIT_HIST_ALL%RowType;

1: package body IGS_OR_UNIT_HIST_PKG AS
2: /* $Header: IGSOI12B.pls 115.8 2002/11/29 01:40:03 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_OR_UNIT_HIST_ALL%RowType;
5: new_references IGS_OR_UNIT_HIST_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 31: FROM IGS_OR_UNIT_HIST_ALL

27: X_ORG_ID in NUMBER DEFAULT NULL
28: ) AS
29: CURSOR cur_old_ref_values IS
30: SELECT *
31: FROM IGS_OR_UNIT_HIST_ALL
32: WHERE rowid = x_rowid;
33: BEGIN
34: l_rowid := x_rowid;
35: -- Code for setting the Old and New Reference Values.

Line 80: FROM IGS_OR_UNIT_HIST_ALL

76: x_hist_start_dt IN DATE
77: )RETURN BOOLEAN AS
78: CURSOR cur_rowid IS
79: SELECT rowid
80: FROM IGS_OR_UNIT_HIST_ALL
81: WHERE org_unit_cd = x_org_unit_cd
82: AND ou_start_dt = x_ou_start_dt
83: AND hist_start_dt = x_hist_start_dt
84: FOR UPDATE NOWAIT;

Line 213: cursor C is select ROWID from IGS_OR_UNIT_HIST_ALL

209: X_NAME in VARCHAR2,
210: X_MODE in VARCHAR2 default 'R',
211: X_ORG_ID in NUMBER
212: ) AS
213: cursor C is select ROWID from IGS_OR_UNIT_HIST_ALL
214: where ORG_UNIT_CD = X_ORG_UNIT_CD
215: and OU_START_DT = X_OU_START_DT
216: and HIST_START_DT = X_HIST_START_DT;
217: X_LAST_UPDATE_DATE DATE;

Line 261: insert into IGS_OR_UNIT_HIST_ALL (

257: x_last_updated_by=>X_LAST_UPDATED_BY,
258: x_last_update_login=>X_LAST_UPDATE_LOGIN,
259: x_org_id=>igs_ge_gen_003.get_org_id
260: );
261: insert into IGS_OR_UNIT_HIST_ALL (
262: ORG_UNIT_CD,
263: OU_START_DT,
264: HIST_START_DT,
265: HIST_END_DT,

Line 338: from IGS_OR_UNIT_HIST_ALL

334: ORG_TYPE,
335: MEMBER_TYPE,
336: INSTITUTION_CD,
337: NAME
338: from IGS_OR_UNIT_HIST_ALL
339: where ROWID = X_ROWID
340: for update nowait ;
341: tlinfo c1%rowtype;
342: begin

Line 444: update IGS_OR_UNIT_HIST_ALL set

440: x_last_update_date=>X_LAST_UPDATE_DATE,
441: x_last_updated_by=>X_LAST_UPDATED_BY,
442: x_last_update_login=>X_LAST_UPDATE_LOGIN
443: );
444: update IGS_OR_UNIT_HIST_ALL set
445: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
446: HIST_WHO = NEW_REFERENCES.HIST_WHO,
447: OU_END_DT = NEW_REFERENCES.OU_END_DT,
448: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,

Line 484: cursor c1 is select rowid from IGS_OR_UNIT_HIST_ALL

480: X_NAME in VARCHAR2,
481: X_MODE in VARCHAR2 default 'R',
482: X_ORG_ID in NUMBER
483: ) AS
484: cursor c1 is select rowid from IGS_OR_UNIT_HIST_ALL
485: where ORG_UNIT_CD = X_ORG_UNIT_CD
486: and OU_START_DT = X_OU_START_DT
487: and HIST_START_DT = X_HIST_START_DT
488: ;

Line 538: delete from IGS_OR_UNIT_HIST_ALL

534: Before_DML(
535: p_action=>'DELETE',
536: x_rowid=>X_ROWID
537: );
538: delete from IGS_OR_UNIT_HIST_ALL
539: where ROWID = X_ROWID ;
540: if (sql%notfound) then
541: raise no_data_found;
542: end if;