APPS.IGS_PS_OWN_HIST_PKG dependencies on IGS_PS_OWN_HIST_ALL

Line 5: old_references IGS_PS_OWN_HIST_ALL%RowType;

1: package body IGS_PS_OWN_HIST_PKG AS
2: /* $Header: IGSPI28B.pls 115.6 2002/12/23 04:48:12 smvk ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_OWN_HIST_ALL%RowType;
6: new_references IGS_PS_OWN_HIST_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_OWN_HIST_ALL%RowType;

2: /* $Header: IGSPI28B.pls 115.6 2002/12/23 04:48:12 smvk ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_OWN_HIST_ALL%RowType;
6: new_references IGS_PS_OWN_HIST_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 29: FROM IGS_PS_OWN_HIST_ALL

25: ) AS
26:
27: CURSOR cur_old_ref_values IS
28: SELECT *
29: FROM IGS_PS_OWN_HIST_ALL
30: WHERE rowid = x_rowid;
31:
32: BEGIN
33:

Line 144: FROM IGS_PS_OWN_HIST_ALL

140: )RETURN BOOLEAN AS
141:
142: CURSOR cur_rowid IS
143: SELECT rowid
144: FROM IGS_PS_OWN_HIST_ALL
145: WHERE course_cd = x_course_cd
146: AND version_number = x_version_number
147: AND org_unit_cd = x_org_unit_cd
148: AND ou_start_dt = x_ou_start_dt

Line 175: FROM IGS_PS_OWN_HIST_ALL

171: ) AS
172:
173: CURSOR cur_rowid IS
174: SELECT rowid
175: FROM IGS_PS_OWN_HIST_ALL
176: WHERE course_cd = x_course_cd
177: AND version_number = x_version_number ;
178:
179: lv_rowid cur_rowid%RowType;

Line 203: FROM IGS_PS_OWN_HIST_ALL

199: ) AS
200:
201: CURSOR cur_rowid IS
202: SELECT rowid
203: FROM IGS_PS_OWN_HIST_ALL
204: WHERE org_unit_cd = x_org_unit_cd
205: AND ou_start_dt = x_start_dt ;
206:
207: lv_rowid cur_rowid%RowType;

Line 327: cursor C is select ROWID from IGS_PS_OWN_HIST_ALL

323: X_PERCENTAGE in NUMBER,
324: X_MODE in VARCHAR2 default 'R',
325: X_ORG_ID in NUMBER
326: ) AS
327: cursor C is select ROWID from IGS_PS_OWN_HIST_ALL
328: where COURSE_CD = X_COURSE_CD
329: and HIST_START_DT = X_HIST_START_DT
330: and OU_START_DT = X_OU_START_DT
331: and VERSION_NUMBER = X_VERSION_NUMBER

Line 373: insert into IGS_PS_OWN_HIST_ALL (

369: x_last_updated_by => X_LAST_UPDATED_BY ,
370: x_last_update_login => X_LAST_UPDATE_LOGIN,
371: x_org_id => igs_ge_gen_003.get_org_id
372: );
373: insert into IGS_PS_OWN_HIST_ALL (
374: COURSE_CD,
375: VERSION_NUMBER,
376: ORG_UNIT_CD,
377: OU_START_DT,

Line 433: from IGS_PS_OWN_HIST_ALL

429: cursor c1 is select
430: HIST_END_DT,
431: HIST_WHO,
432: PERCENTAGE
433: from IGS_PS_OWN_HIST_ALL
434: where ROWID = X_ROWID
435: for update nowait;
436: tlinfo c1%rowtype;
437:

Line 517: update IGS_PS_OWN_HIST_ALL set

513: x_last_update_date => X_LAST_UPDATE_DATE ,
514: x_last_updated_by => X_LAST_UPDATED_BY ,
515: x_last_update_login => X_LAST_UPDATE_LOGIN
516: );
517: update IGS_PS_OWN_HIST_ALL set
518: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
519: HIST_WHO = NEW_REFERENCES.HIST_WHO,
520: PERCENTAGE = NEW_REFERENCES.PERCENTAGE,
521: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 548: cursor c1 is select rowid from IGS_PS_OWN_HIST_ALL

544: X_PERCENTAGE in NUMBER,
545: X_MODE in VARCHAR2 default 'R',
546: X_ORG_ID IN NUMBER
547: ) AS
548: cursor c1 is select rowid from IGS_PS_OWN_HIST_ALL
549: where COURSE_CD = X_COURSE_CD
550: and HIST_START_DT = X_HIST_START_DT
551: and OU_START_DT = X_OU_START_DT
552: and VERSION_NUMBER = X_VERSION_NUMBER

Line 597: delete from IGS_PS_OWN_HIST_ALL

593: Before_DML (
594: p_action => 'DELETE',
595: x_rowid => X_ROWID
596: );
597: delete from IGS_PS_OWN_HIST_ALL
598: where ROWID = X_ROWID;
599: if (sql%notfound) then
600: raise no_data_found;
601: end if;