[Home] [Help]
1: package body IGS_CA_DA_OFFCNT_PKG AS
2: /* $Header: IGSCI08B.pls 120.1 2006/01/25 09:17:52 skpandey noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_OFFCNT%RowType;
5: new_references IGS_CA_DA_OFFCNT%RowType;
1: package body IGS_CA_DA_OFFCNT_PKG AS
2: /* $Header: IGSCI08B.pls 120.1 2006/01/25 09:17:52 skpandey noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_OFFCNT%RowType;
5: new_references IGS_CA_DA_OFFCNT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
1: package body IGS_CA_DA_OFFCNT_PKG AS
2: /* $Header: IGSCI08B.pls 120.1 2006/01/25 09:17:52 skpandey noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_OFFCNT%RowType;
5: new_references IGS_CA_DA_OFFCNT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,
21:
22:
23: CURSOR cur_old_ref_values IS
24: SELECT *
25: FROM IGS_CA_DA_OFFCNT
26: WHERE rowid = x_rowid;
27:
28: BEGIN
29:
63:
64: -- Trigger description :-
65: -- "OSS_TST".trg_daoc_br_iud
66: -- BEFORE INSERT OR DELETE OR UPDATE
67: -- ON IGS_CA_DA_OFFCNT
68: -- FOR EACH ROW
69:
70: PROCEDURE BeforeRowInsertUpdateDelete1(
71: p_inserting IN BOOLEAN DEFAULT FALSE,
90:
91: -- Trigger description :-
92: -- "OSS_TST".trg_daoc_as_iu
93: -- AFTER INSERT OR UPDATE
94: -- ON IGS_CA_DA_OFFCNT
95:
96: PROCEDURE AfterStmtInsertUpdate3(
97: p_inserting IN BOOLEAN DEFAULT FALSE,
98: p_updating IN BOOLEAN DEFAULT FALSE,
217: ) RETURN BOOLEAN AS
218:
219: CURSOR cur_rowid IS
220: SELECT rowid
221: FROM IGS_CA_DA_OFFCNT
222: WHERE dt_alias = x_dt_alias
223: AND offset_dt_alias = x_offset_dt_alias
224: AND s_dt_offset_constraint_type = x_s_dt_offset_constraint_type
225: FOR UPDATE NOWAIT;
255: ) AS
256:
257: CURSOR cur_rowid IS
258: SELECT rowid
259: FROM IGS_CA_DA_OFFCNT
260: WHERE dt_alias = x_dt_alias
261: AND offset_dt_alias = x_offset_dt_alias ;
262:
263: lv_rowid cur_rowid%RowType;
379: X_CONSTRAINT_CONDITION in VARCHAR2,
380: X_CONSTRAINT_RESOLUTION in NUMBER,
381: X_MODE in VARCHAR2 default 'R'
382: ) AS
383: cursor C is select ROWID from IGS_CA_DA_OFFCNT
384: where DT_ALIAS = X_DT_ALIAS
385: and OFFSET_DT_ALIAS = X_OFFSET_DT_ALIAS
386: and S_DT_OFFSET_CONSTRAINT_TYPE = X_S_DT_OFFSET_CONSTRAINT_TYPE;
387: X_LAST_UPDATE_DATE DATE;
419: x_last_update_date =>X_LAST_UPDATE_DATE,
420: x_last_updated_by =>X_LAST_UPDATED_BY,
421: x_last_update_login =>X_LAST_UPDATE_LOGIN
422: );
423: insert into IGS_CA_DA_OFFCNT (
424: DT_ALIAS,
425: OFFSET_DT_ALIAS,
426: S_DT_OFFSET_CONSTRAINT_TYPE,
427: CONSTRAINT_CONDITION,
471: OFFSET_DT_ALIAS,
472: S_DT_OFFSET_CONSTRAINT_TYPE,
473: CONSTRAINT_CONDITION,
474: CONSTRAINT_RESOLUTION
475: from IGS_CA_DA_OFFCNT
476: where ROWID = X_ROWID
477: for update nowait;
478: tlinfo c1%rowtype;
479:
548: x_last_update_date =>X_LAST_UPDATE_DATE,
549: x_last_updated_by =>X_LAST_UPDATED_BY,
550: x_last_update_login =>X_LAST_UPDATE_LOGIN
551: );
552: update IGS_CA_DA_OFFCNT set
553: CONSTRAINT_CONDITION = NEW_REFERENCES.CONSTRAINT_CONDITION,
554: CONSTRAINT_RESOLUTION = NEW_REFERENCES.CONSTRAINT_RESOLUTION,
555: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
556: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
576: X_CONSTRAINT_CONDITION in VARCHAR2,
577: X_CONSTRAINT_RESOLUTION in NUMBER,
578: X_MODE in VARCHAR2 default 'R'
579: ) AS
580: cursor c1 is select rowid from IGS_CA_DA_OFFCNT
581: where DT_ALIAS = X_DT_ALIAS
582: and OFFSET_DT_ALIAS = X_OFFSET_DT_ALIAS
583: and S_DT_OFFSET_CONSTRAINT_TYPE = X_S_DT_OFFSET_CONSTRAINT_TYPE
584: ;
615: Before_DML (
616: p_action =>'DELETE',
617: x_rowid =>X_ROWID
618: );
619: delete from IGS_CA_DA_OFFCNT
620: where ROWID = X_ROWID;
621: if (sql%notfound) then
622: raise no_data_found;
623: end if;
627: );
628:
629: end DELETE_ROW;
630:
631: end IGS_CA_DA_OFFCNT_PKG;