APPS.IGS_PS_UNT_DSCP_HIST_PKG dependencies on IGS_PS_UNT_DSCP_HIST_ALL

Line 5: old_references IGS_PS_UNT_DSCP_HIST_ALL%RowType;

1: package body IGS_PS_UNT_DSCP_HIST_PKG as
2: /* $Header: IGSPI77B.pls 115.5 2002/11/29 02:37:49 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNT_DSCP_HIST_ALL%RowType;
6: new_references IGS_PS_UNT_DSCP_HIST_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_UNT_DSCP_HIST_ALL%RowType;

2: /* $Header: IGSPI77B.pls 115.5 2002/11/29 02:37:49 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNT_DSCP_HIST_ALL%RowType;
6: new_references IGS_PS_UNT_DSCP_HIST_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 28: FROM IGS_PS_UNT_DSCP_HIST_ALL

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

Line 145: FROM IGS_PS_UNT_DSCP_HIST_ALL

141: ) RETURN BOOLEAN AS
142:
143: CURSOR cur_rowid IS
144: SELECT rowid
145: FROM IGS_PS_UNT_DSCP_HIST_ALL
146: WHERE unit_cd = x_unit_cd
147: AND version_number = x_version_number
148: AND discipline_group_cd = x_discipline_group_cd
149: AND hist_start_dt = x_hist_start_dt

Line 174: FROM IGS_PS_UNT_DSCP_HIST_ALL

170: ) AS
171:
172: CURSOR cur_rowid IS
173: SELECT rowid
174: FROM IGS_PS_UNT_DSCP_HIST_ALL
175: WHERE discipline_group_cd = x_discipline_group_cd ;
176:
177: lv_rowid cur_rowid%RowType;
178:

Line 201: FROM IGS_PS_UNT_DSCP_HIST_ALL

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

Line 316: cursor C is select ROWID from IGS_PS_UNT_DSCP_HIST_ALL

312: X_PERCENTAGE in NUMBER,
313: X_MODE in VARCHAR2 default 'R',
314: X_ORG_ID in NUMBER
315: ) AS
316: cursor C is select ROWID from IGS_PS_UNT_DSCP_HIST_ALL
317: where UNIT_CD = X_UNIT_CD
318: and HIST_START_DT = X_HIST_START_DT
319: and DISCIPLINE_GROUP_CD = X_DISCIPLINE_GROUP_CD
320: and VERSION_NUMBER = X_VERSION_NUMBER;

Line 362: insert into IGS_PS_UNT_DSCP_HIST_ALL (

358: x_last_update_login => X_LAST_UPDATE_LOGIN,
359: x_org_id => igs_ge_gen_003.get_org_id
360: );
361:
362: insert into IGS_PS_UNT_DSCP_HIST_ALL (
363: UNIT_CD,
364: VERSION_NUMBER,
365: DISCIPLINE_GROUP_CD,
366: HIST_START_DT,

Line 420: from IGS_PS_UNT_DSCP_HIST_ALL

416: cursor c1 is select
417: HIST_END_DT,
418: HIST_WHO,
419: PERCENTAGE
420: from IGS_PS_UNT_DSCP_HIST_ALL
421: where ROWID = X_ROWID
422: for update nowait;
423: tlinfo c1%rowtype;
424:

Line 503: update IGS_PS_UNT_DSCP_HIST_ALL set

499: x_last_updated_by => X_LAST_UPDATED_BY,
500: x_last_update_login => X_LAST_UPDATE_LOGIN
501: );
502:
503: update IGS_PS_UNT_DSCP_HIST_ALL set
504: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
505: HIST_WHO = NEW_REFERENCES.HIST_WHO,
506: PERCENTAGE = NEW_REFERENCES.PERCENTAGE,
507: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 534: cursor c1 is select rowid from IGS_PS_UNT_DSCP_HIST_ALL

530: X_PERCENTAGE in NUMBER,
531: X_MODE in VARCHAR2 default 'R',
532: X_ORG_ID in NUMBER
533: ) AS
534: cursor c1 is select rowid from IGS_PS_UNT_DSCP_HIST_ALL
535: where UNIT_CD = X_UNIT_CD
536: and HIST_START_DT = X_HIST_START_DT
537: and DISCIPLINE_GROUP_CD = X_DISCIPLINE_GROUP_CD
538: and VERSION_NUMBER = X_VERSION_NUMBER

Line 580: delete from IGS_PS_UNT_DSCP_HIST_ALL

576: Before_DML(
577: p_action => 'DELETE',
578: x_rowid => X_ROWID
579: );
580: delete from IGS_PS_UNT_DSCP_HIST_ALL
581: where ROWID = X_ROWID;
582: if (sql%notfound) then
583: raise no_data_found;
584: end if;