[Home] [Help]
1: package body IGS_CA_DA_INST_OFCNT_PKG AS
2: /* $Header: IGSCI05B.pls 120.1 2006/01/25 09:17:10 skpandey noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_INST_OFCNT%RowType;
5: new_references IGS_CA_DA_INST_OFCNT%RowType;
1: package body IGS_CA_DA_INST_OFCNT_PKG AS
2: /* $Header: IGSCI05B.pls 120.1 2006/01/25 09:17:10 skpandey noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_INST_OFCNT%RowType;
5: new_references IGS_CA_DA_INST_OFCNT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
1: package body IGS_CA_DA_INST_OFCNT_PKG AS
2: /* $Header: IGSCI05B.pls 120.1 2006/01/25 09:17:10 skpandey noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_INST_OFCNT%RowType;
5: new_references IGS_CA_DA_INST_OFCNT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,
26: ) AS
27:
28: CURSOR cur_old_ref_values IS
29: SELECT *
30: FROM IGS_CA_DA_INST_OFCNT
31: WHERE rowid = x_rowid;
32:
33: BEGIN
34:
74:
75: -- Trigger description :-
76: -- "OSS_TST".trg_daioc_br_iud
77: -- BEFORE INSERT OR DELETE OR UPDATE
78: -- ON IGS_CA_DA_INST_OFCNT
79: -- FOR EACH ROW
80:
81: PROCEDURE BeforeRowInsertUpdateDelete1(
82: p_inserting IN BOOLEAN DEFAULT FALSE,
102:
103: -- Trigger description :-
104: -- "OSS_TST".trg_daioc_as_iu
105: -- AFTER INSERT OR UPDATE
106: -- ON IGS_CA_DA_INST_OFCNT
107:
108: PROCEDURE AfterStmtInsertUpdate3(
109: p_inserting IN BOOLEAN DEFAULT FALSE,
110: p_updating IN BOOLEAN DEFAULT FALSE,
312: )RETURN BOOLEAN AS
313:
314: CURSOR cur_rowid IS
315: SELECT rowid
316: FROM IGS_CA_DA_INST_OFCNT
317: WHERE cal_type = x_cal_type
318: AND ci_sequence_number = x_ci_sequence_number
319: AND dt_alias = x_dt_alias
320: AND dai_sequence_number = x_dai_sequence_number
353: ) AS
354:
355: CURSOR cur_rowid IS
356: SELECT rowid
357: FROM IGS_CA_DA_INST_OFCNT
358: WHERE dt_alias = x_dt_alias
359: AND dai_sequence_number = x_dai_sequence_number
360: AND cal_type = x_cal_type
361: AND ci_sequence_number = x_ci_sequence_number
517: X_CONSTRAINT_CONDITION in VARCHAR2,
518: X_CONSTRAINT_RESOLUTION in NUMBER,
519: X_MODE in VARCHAR2 default 'R'
520: ) AS
521: cursor C is select ROWID from IGS_CA_DA_INST_OFCNT
522: where CAL_TYPE = X_CAL_TYPE
523: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
524: and DT_ALIAS = X_DT_ALIAS
525: and DAI_SEQUENCE_NUMBER = X_DAI_SEQUENCE_NUMBER
569: x_last_update_date =>X_LAST_UPDATE_DATE,
570: x_last_updated_by =>X_LAST_UPDATED_BY,
571: x_last_update_login =>X_LAST_UPDATE_LOGIN
572: );
573: insert into IGS_CA_DA_INST_OFCNT (
574: DT_ALIAS,
575: DAI_SEQUENCE_NUMBER,
576: CAL_TYPE,
577: CI_SEQUENCE_NUMBER,
635: ) AS
636: cursor c1 is select
637: CONSTRAINT_CONDITION,
638: CONSTRAINT_RESOLUTION
639: from IGS_CA_DA_INST_OFCNT
640: where ROWID = X_ROWID
641: for update nowait;
642: tlinfo c1%rowtype;
643:
721: x_last_update_date =>X_LAST_UPDATE_DATE,
722: x_last_updated_by =>X_LAST_UPDATED_BY,
723: x_last_update_login =>X_LAST_UPDATE_LOGIN
724: );
725: update IGS_CA_DA_INST_OFCNT set
726: CONSTRAINT_CONDITION = NEW_REFERENCES.CONSTRAINT_CONDITION,
727: CONSTRAINT_RESOLUTION = NEW_REFERENCES.CONSTRAINT_RESOLUTION,
728: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
729: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
753: X_CONSTRAINT_CONDITION in VARCHAR2,
754: X_CONSTRAINT_RESOLUTION in NUMBER,
755: X_MODE in VARCHAR2 default 'R'
756: ) AS
757: cursor c1 is select rowid from IGS_CA_DA_INST_OFCNT
758: where CAL_TYPE = X_CAL_TYPE
759: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
760: and DT_ALIAS = X_DT_ALIAS
761: and DAI_SEQUENCE_NUMBER = X_DAI_SEQUENCE_NUMBER
809: Before_DML (
810: p_action =>'DELETE',
811: x_rowid =>X_ROWID
812: );
813: delete from IGS_CA_DA_INST_OFCNT
814: where ROWID = X_ROWID;
815: if (sql%notfound) then
816: raise no_data_found;
817: end if;
820: x_rowid =>X_ROWID
821: );
822: end DELETE_ROW;
823:
824: end IGS_CA_DA_INST_OFCNT_PKG;