APPS.IGS_PS_TCH_RESP_HIST_PKG dependencies on IGS_PS_TCH_RESP_HIST_ALL

Line 4: old_references IGS_PS_TCH_RESP_HIST_ALL%RowType;

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

Line 5: new_references IGS_PS_TCH_RESP_HIST_ALL%RowType;

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

Line 28: FROM IGS_PS_TCH_RESP_HIST_ALL

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

Line 141: FROM IGS_PS_TCH_RESP_HIST_ALL

137: ) RETURN BOOLEAN AS
138:
139: CURSOR cur_rowid IS
140: SELECT rowid
141: FROM IGS_PS_TCH_RESP_HIST_ALL
142: WHERE unit_cd = x_unit_cd
143: AND version_number = x_version_number
144: AND org_unit_cd = x_org_unit_cd
145: AND ou_start_dt = x_ou_start_dt

Line 171: FROM IGS_PS_TCH_RESP_HIST_ALL

167: ) AS
168:
169: CURSOR cur_rowid IS
170: SELECT rowid
171: FROM IGS_PS_TCH_RESP_HIST_ALL
172: WHERE org_unit_cd = x_org_unit_cd
173: AND ou_start_dt = x_start_dt ;
174:
175: lv_rowid cur_rowid%RowType;

Line 199: FROM IGS_PS_TCH_RESP_HIST_ALL

195: ) AS
196:
197: CURSOR cur_rowid IS
198: SELECT rowid
199: FROM IGS_PS_TCH_RESP_HIST_ALL
200: WHERE unit_cd = x_unit_cd
201: AND version_number = x_version_number ;
202:
203: lv_rowid cur_rowid%RowType;

Line 323: cursor C is select ROWID from IGS_PS_TCH_RESP_HIST_ALL

319: X_PERCENTAGE in NUMBER,
320: X_MODE in VARCHAR2 default 'R',
321: X_ORG_ID in NUMBER
322: ) as
323: cursor C is select ROWID from IGS_PS_TCH_RESP_HIST_ALL
324: where UNIT_CD = X_UNIT_CD
325: and VERSION_NUMBER = X_VERSION_NUMBER
326: and OU_START_DT = X_OU_START_DT
327: and HIST_START_DT = X_HIST_START_DT

Line 370: insert into IGS_PS_TCH_RESP_HIST_ALL (

366: x_last_updated_by => X_LAST_UPDATED_BY,
367: x_last_update_login => X_LAST_UPDATE_LOGIN,
368: x_org_id => igs_ge_gen_003.get_org_id
369: );
370: insert into IGS_PS_TCH_RESP_HIST_ALL (
371: UNIT_CD,
372: VERSION_NUMBER,
373: ORG_UNIT_CD,
374: OU_START_DT,

Line 430: from IGS_PS_TCH_RESP_HIST_ALL

426: cursor c1 is select
427: HIST_END_DT,
428: HIST_WHO,
429: PERCENTAGE
430: from IGS_PS_TCH_RESP_HIST_ALL
431: where ROWID = X_ROWID
432: for update nowait;
433: tlinfo c1%rowtype;
434:

Line 514: update IGS_PS_TCH_RESP_HIST_ALL set

510: x_last_update_date => X_LAST_UPDATE_DATE,
511: x_last_updated_by => X_LAST_UPDATED_BY,
512: x_last_update_login => X_LAST_UPDATE_LOGIN
513: );
514: update IGS_PS_TCH_RESP_HIST_ALL set
515: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
516: HIST_WHO = NEW_REFERENCES.HIST_WHO,
517: PERCENTAGE = NEW_REFERENCES.PERCENTAGE,
518: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 545: cursor c1 is select rowid from IGS_PS_TCH_RESP_HIST_ALL

541: X_PERCENTAGE in NUMBER,
542: X_MODE in VARCHAR2 default 'R',
543: X_ORG_ID in NUMBER
544: ) as
545: cursor c1 is select rowid from IGS_PS_TCH_RESP_HIST_ALL
546: where UNIT_CD = X_UNIT_CD
547: and VERSION_NUMBER = X_VERSION_NUMBER
548: and OU_START_DT = X_OU_START_DT
549: and HIST_START_DT = X_HIST_START_DT

Line 594: delete from IGS_PS_TCH_RESP_HIST_ALL

590: Before_DML(
591: p_action => 'DELETE',
592: x_rowid => X_ROWID
593: );
594: delete from IGS_PS_TCH_RESP_HIST_ALL
595: where ROWID = X_ROWID;
596: if (sql%notfound) then
597: raise no_data_found;
598: end if;