APPS.IGS_PS_TCH_RSOV_HIST_PKG dependencies on IGS_PS_TCH_RSOV_HIST_ALL

Line 4: old_references IGS_PS_TCH_RSOV_HIST_ALL%RowType;

1: package body IGS_PS_TCH_RSOV_HIST_PKG as
2: /* $Header: IGSPI72B.pls 115.6 2002/12/23 04:54:15 smvk ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_TCH_RSOV_HIST_ALL%RowType;
5: new_references IGS_PS_TCH_RSOV_HIST_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_PS_TCH_RSOV_HIST_ALL%RowType;

1: package body IGS_PS_TCH_RSOV_HIST_PKG as
2: /* $Header: IGSPI72B.pls 115.6 2002/12/23 04:54:15 smvk ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_TCH_RSOV_HIST_ALL%RowType;
5: new_references IGS_PS_TCH_RSOV_HIST_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 32: FROM IGS_PS_TCH_RSOV_HIST_ALL

28: ) AS
29:
30: CURSOR cur_old_ref_values IS
31: SELECT *
32: FROM IGS_PS_TCH_RSOV_HIST_ALL
33: WHERE rowid = x_rowid;
34:
35: BEGIN
36:

Line 221: FROM IGS_PS_TCH_RSOV_HIST_ALL

217: ) RETURN BOOLEAN AS
218:
219: CURSOR cur_rowid IS
220: SELECT rowid
221: FROM IGS_PS_TCH_RSOV_HIST_ALL
222: WHERE unit_cd = x_unit_cd
223: AND version_number = x_version_number
224: AND cal_type = x_cal_type
225: AND ci_sequence_number = x_ci_sequence_number

Line 255: FROM IGS_PS_TCH_RSOV_HIST_ALL

251: ) AS
252:
253: CURSOR cur_rowid IS
254: SELECT rowid
255: FROM IGS_PS_TCH_RSOV_HIST_ALL
256: WHERE org_unit_cd = x_org_unit_cd
257: AND ou_start_dt = x_start_dt ;
258:
259: lv_rowid cur_rowid%RowType;

Line 287: FROM IGS_PS_TCH_RSOV_HIST_ALL

283: ) AS
284:
285: CURSOR cur_rowid IS
286: SELECT rowid
287: FROM IGS_PS_TCH_RSOV_HIST_ALL
288: WHERE unit_cd = x_unit_cd
289: AND version_number = x_version_number
290: AND cal_type = x_cal_type
291: AND ci_sequence_number = x_ci_sequence_number

Line 436: cursor C is select ROWID from IGS_PS_TCH_RSOV_HIST_ALL

432: X_PERCENTAGE in NUMBER,
433: X_MODE in VARCHAR2 default 'R',
434: X_ORG_ID in NUMBER
435: ) as
436: cursor C is select ROWID from IGS_PS_TCH_RSOV_HIST_ALL
437: where UNIT_CD = X_UNIT_CD
438: and CAL_TYPE = X_CAL_TYPE
439: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
440: and VERSION_NUMBER = X_VERSION_NUMBER

Line 492: insert into IGS_PS_TCH_RSOV_HIST_ALL (

488: x_last_update_login => X_LAST_UPDATE_LOGIN,
489: x_org_id => igs_ge_gen_003.get_org_id
490: );
491:
492: insert into IGS_PS_TCH_RSOV_HIST_ALL (
493: UNIT_CD,
494: VERSION_NUMBER,
495: CAL_TYPE,
496: CI_SEQUENCE_NUMBER,

Line 565: from IGS_PS_TCH_RSOV_HIST_ALL

561: cursor c1 is select
562: HIST_END_DT,
563: HIST_WHO,
564: PERCENTAGE
565: from IGS_PS_TCH_RSOV_HIST_ALL
566: where ROWID = X_ROWID
567: for update nowait;
568: tlinfo c1%rowtype;
569:

Line 655: update IGS_PS_TCH_RSOV_HIST_ALL set

651: x_last_updated_by => X_LAST_UPDATED_BY,
652: x_last_update_login => X_LAST_UPDATE_LOGIN
653: );
654:
655: update IGS_PS_TCH_RSOV_HIST_ALL set
656: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
657: HIST_WHO = NEW_REFERENCES.HIST_WHO,
658: PERCENTAGE = NEW_REFERENCES.PERCENTAGE,
659: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 691: cursor c1 is select rowid from IGS_PS_TCH_RSOV_HIST_ALL

687: X_PERCENTAGE in NUMBER,
688: X_MODE in VARCHAR2 default 'R',
689: X_ORG_ID in NUMBER
690: ) as
691: cursor c1 is select rowid from IGS_PS_TCH_RSOV_HIST_ALL
692: where UNIT_CD = X_UNIT_CD
693: and CAL_TYPE = X_CAL_TYPE
694: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
695: and VERSION_NUMBER = X_VERSION_NUMBER

Line 753: delete from IGS_PS_TCH_RSOV_HIST_ALL

749: Before_DML(
750: p_action => 'DELETE',
751: x_rowid => X_ROWID
752: );
753: delete from IGS_PS_TCH_RSOV_HIST_ALL
754: where ROWID = X_ROWID;
755: if (sql%notfound) then
756: raise no_data_found;
757: end if;