APPS.IGS_EN_UNIT_SET_HIST_PKG dependencies on IGS_EN_UNIT_SET_HIST_ALL

Line 5: old_references IGS_EN_UNIT_SET_HIST_ALL%RowType;

1: package body IGS_EN_UNIT_SET_HIST_PKG AS
2: /* $Header: IGSEI04B.pls 115.6 2003/01/27 06:53:47 nalkumar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_UNIT_SET_HIST_ALL%RowType;
6: new_references IGS_EN_UNIT_SET_HIST_ALL%RowType;
7:
8:
9: PROCEDURE Set_Column_Values (

Line 6: new_references IGS_EN_UNIT_SET_HIST_ALL%RowType;

2: /* $Header: IGSEI04B.pls 115.6 2003/01/27 06:53:47 nalkumar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_UNIT_SET_HIST_ALL%RowType;
6: new_references IGS_EN_UNIT_SET_HIST_ALL%RowType;
7:
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 41: FROM IGS_EN_UNIT_SET_HIST_ALL

37: ) AS
38:
39: CURSOR cur_old_ref_values IS
40: SELECT *
41: FROM IGS_EN_UNIT_SET_HIST_ALL
42: WHERE rowid = x_rowid;
43:
44: BEGIN
45:

Line 182: FROM IGS_EN_UNIT_SET_HIST_ALL

178: ) RETURN BOOLEAN as
179:
180: CURSOR cur_rowid IS
181: SELECT rowid
182: FROM IGS_EN_UNIT_SET_HIST_ALL
183: WHERE unit_set_cd = x_unit_set_cd
184: AND version_number = x_version_number
185: AND hist_start_dt = x_hist_start_dt
186: FOR UPDATE NOWAIT;

Line 352: cursor C is select ROWID from IGS_EN_UNIT_SET_HIST_ALL

348: X_ADMINISTRATIVE_IND in VARCHAR2,
349: X_AUTHORISATION_RQRD_IND in VARCHAR2,
350: X_MODE in VARCHAR2 default 'R'
351: ) AS
352: cursor C is select ROWID from IGS_EN_UNIT_SET_HIST_ALL
353: where UNIT_SET_CD = X_UNIT_SET_CD
354: and VERSION_NUMBER = X_VERSION_NUMBER
355: and HIST_START_DT = X_HIST_START_DT;
356: X_LAST_UPDATE_DATE DATE;

Line 409: insert into IGS_EN_UNIT_SET_HIST_ALL (

405: x_last_updated_by => x_last_updated_by ,
406: x_last_update_login => x_last_update_login
407: );
408:
409: insert into IGS_EN_UNIT_SET_HIST_ALL (
410: org_id,
411: UNIT_SET_CD,
412: VERSION_NUMBER,
413: HIST_START_DT,

Line 517: from IGS_EN_UNIT_SET_HIST_ALL

513: RESPONSIBLE_OU_START_DT,
514: OU_DESCRIPTION,
515: ADMINISTRATIVE_IND,
516: AUTHORISATION_RQRD_IND
517: from IGS_EN_UNIT_SET_HIST_ALL
518: where ROWID = X_ROWID
519: for update nowait;
520: tlinfo c1%rowtype;
521:

Line 661: update IGS_EN_UNIT_SET_HIST_ALL set

657: );
658:
659:
660:
661: update IGS_EN_UNIT_SET_HIST_ALL set
662: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
663: HIST_WHO = NEW_REFERENCES.HIST_WHO,
664: UNIT_SET_STATUS = NEW_REFERENCES.UNIT_SET_STATUS,
665: UNIT_SET_CAT = NEW_REFERENCES.UNIT_SET_CAT,

Line 718: cursor c1 is select rowid from IGS_EN_UNIT_SET_HIST_ALL

714: X_ADMINISTRATIVE_IND in VARCHAR2,
715: X_AUTHORISATION_RQRD_IND in VARCHAR2,
716: X_MODE in VARCHAR2 default 'R'
717: ) AS
718: cursor c1 is select rowid from IGS_EN_UNIT_SET_HIST_ALL
719: where UNIT_SET_CD = X_UNIT_SET_CD
720: and VERSION_NUMBER = X_VERSION_NUMBER
721: and HIST_START_DT = X_HIST_START_DT
722: ;

Line 789: delete from IGS_EN_UNIT_SET_HIST_ALL

785: p_action => 'DELETE',
786: x_rowid => X_ROWID
787: );
788:
789: delete from IGS_EN_UNIT_SET_HIST_ALL
790: where ROWID = X_ROWID;
791: if (sql%notfound) then
792: raise no_data_found;
793: end if;