APPS.IGS_PS_UNIT_REF_HIST_PKG dependencies on IGS_PS_UNIT_REF_HIST_ALL

Line 5: old_references IGS_PS_UNIT_REF_HIST_ALL%RowType;

1: package body IGS_PS_UNIT_REF_HIST_PKG as
2: /* $Header: IGSPI89B.pls 115.7 2002/11/29 02:41:17 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_REF_HIST_ALL%RowType;
6: new_references IGS_PS_UNIT_REF_HIST_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_UNIT_REF_HIST_ALL%RowType;

2: /* $Header: IGSPI89B.pls 115.7 2002/11/29 02:41:17 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_REF_HIST_ALL%RowType;
6: new_references IGS_PS_UNIT_REF_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_UNIT_REF_HIST_ALL

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

Line 162: FROM IGS_PS_UNIT_REF_HIST_ALL

158: ) RETURN BOOLEAN AS
159:
160: CURSOR cur_rowid IS
161: SELECT rowid
162: FROM IGS_PS_UNIT_REF_HIST_ALL
163: WHERE unit_cd = x_unit_cd
164: AND version_number = x_version_number
165: AND reference_cd_type = x_reference_cd_type
166: AND reference_cd = x_reference_cd

Line 192: FROM IGS_PS_UNIT_REF_HIST_ALL

188: ) AS
189:
190: CURSOR cur_rowid IS
191: SELECT rowid
192: FROM IGS_PS_UNIT_REF_HIST_ALL
193: WHERE reference_cd_type = x_reference_cd_type ;
194:
195: lv_rowid cur_rowid%RowType;
196:

Line 219: FROM IGS_PS_UNIT_REF_HIST_ALL

215: ) AS
216:
217: CURSOR cur_rowid IS
218: SELECT rowid
219: FROM IGS_PS_UNIT_REF_HIST_ALL
220: WHERE unit_cd = x_unit_cd
221: AND version_number = x_version_number ;
222:
223: lv_rowid cur_rowid%RowType;

Line 339: cursor C is select ROWID from IGS_PS_UNIT_REF_HIST_ALL

335: X_DESCRIPTION in VARCHAR2,
336: X_MODE in VARCHAR2 default 'R',
337: X_ORG_ID in NUMBER
338: ) AS
339: cursor C is select ROWID from IGS_PS_UNIT_REF_HIST_ALL
340: where UNIT_CD = X_UNIT_CD
341: and HIST_START_DT = X_HIST_START_DT
342: and REFERENCE_CD = X_REFERENCE_CD
343: and VERSION_NUMBER = X_VERSION_NUMBER

Line 387: insert into IGS_PS_UNIT_REF_HIST_ALL (

383: x_last_update_login => X_LAST_UPDATE_LOGIN,
384: x_org_id => igs_ge_gen_003.get_org_id
385: );
386:
387: insert into IGS_PS_UNIT_REF_HIST_ALL (
388: UNIT_CD,
389: VERSION_NUMBER,
390: REFERENCE_CD_TYPE,
391: REFERENCE_CD,

Line 448: from IGS_PS_UNIT_REF_HIST_ALL

444: cursor c1 is select
445: HIST_END_DT,
446: HIST_WHO,
447: DESCRIPTION
448: from IGS_PS_UNIT_REF_HIST_ALL
449: where ROWID = X_ROWID
450: for update nowait;
451: tlinfo c1%rowtype;
452:

Line 533: update IGS_PS_UNIT_REF_HIST_ALL set

529: x_last_updated_by => X_LAST_UPDATED_BY,
530: x_last_update_login => X_LAST_UPDATE_LOGIN
531: );
532:
533: update IGS_PS_UNIT_REF_HIST_ALL set
534: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
535: HIST_WHO = NEW_REFERENCES.HIST_WHO,
536: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
537: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 564: cursor c1 is select rowid from IGS_PS_UNIT_REF_HIST_ALL

560: X_DESCRIPTION in VARCHAR2,
561: X_MODE in VARCHAR2 default 'R',
562: X_ORG_ID in NUMBER
563: ) AS
564: cursor c1 is select rowid from IGS_PS_UNIT_REF_HIST_ALL
565: where UNIT_CD = X_UNIT_CD
566: and HIST_START_DT = X_HIST_START_DT
567: and REFERENCE_CD = X_REFERENCE_CD
568: and VERSION_NUMBER = X_VERSION_NUMBER

Line 613: delete from IGS_PS_UNIT_REF_HIST_ALL

609: Before_DML (
610: p_action => 'DELETE',
611: x_rowid => X_ROWID
612: );
613: delete from IGS_PS_UNIT_REF_HIST_ALL
614: where ROWID = X_ROWID
615: ;
616: if (sql%notfound) then
617: raise no_data_found;