APPS.IGS_CA_DA_INST_OFST_PKG dependencies on IGS_CA_DA_INST_OFST

Line 1: package body IGS_CA_DA_INST_OFST_PKG AS

1: package body IGS_CA_DA_INST_OFST_PKG AS
2: /* $Header: IGSCI06B.pls 120.0 2005/06/02 03:28:57 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_INST_OFST%RowType;
5: new_references IGS_CA_DA_INST_OFST%RowType;

Line 4: old_references IGS_CA_DA_INST_OFST%RowType;

1: package body IGS_CA_DA_INST_OFST_PKG AS
2: /* $Header: IGSCI06B.pls 120.0 2005/06/02 03:28:57 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_INST_OFST%RowType;
5: new_references IGS_CA_DA_INST_OFST%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_CA_DA_INST_OFST%RowType;

1: package body IGS_CA_DA_INST_OFST_PKG AS
2: /* $Header: IGSCI06B.pls 120.0 2005/06/02 03:28:57 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_INST_OFST%RowType;
5: new_references IGS_CA_DA_INST_OFST%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 32: FROM IGS_CA_DA_INST_OFST

28: ) AS
29:
30: CURSOR cur_old_ref_values IS
31: SELECT *
32: FROM IGS_CA_DA_INST_OFST
33: WHERE rowid = x_rowid;
34:
35: BEGIN
36:

Line 82: -- ON IGS_CA_DA_INST_OFST

78:
79: -- Trigger description :-
80: -- "OSS_TST".trg_daio_br_iud
81: -- BEFORE INSERT OR DELETE OR UPDATE
82: -- ON IGS_CA_DA_INST_OFST
83: -- FOR EACH ROW
84:
85: PROCEDURE BeforeRowInsertUpdateDelete1(
86: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 116: -- ON IGS_CA_DA_INST_OFST

112:
113: -- Trigger description :-
114: -- "OSS_TST".trg_daio_as_iud
115: -- AFTER INSERT OR DELETE OR UPDATE
116: -- ON IGS_CA_DA_INST_OFST
117:
118: PROCEDURE AfterStmtInsertUpdateDelete3(
119: p_inserting IN BOOLEAN DEFAULT FALSE,
120: p_updating IN BOOLEAN DEFAULT FALSE,

Line 289: IGS_CA_DA_INST_OFCNT_PKG.GET_FK_IGS_CA_DA_INST_OFST (

285:
286: PROCEDURE Check_Child_Existance AS
287: BEGIN
288:
289: IGS_CA_DA_INST_OFCNT_PKG.GET_FK_IGS_CA_DA_INST_OFST (
290: old_references.dt_alias,
291: old_references.dai_sequence_number,
292: old_references.cal_type,
293: old_references.ci_sequence_number,

Line 315: FROM IGS_CA_DA_INST_OFST

311: )RETURN BOOLEAN AS
312:
313: CURSOR cur_rowid IS
314: SELECT rowid
315: FROM IGS_CA_DA_INST_OFST
316: WHERE dt_alias = x_dt_alias
317: AND dai_sequence_number = x_dai_sequence_number
318: AND cal_type = x_cal_type
319: AND ci_sequence_number = x_ci_sequence_number

Line 350: FROM IGS_CA_DA_INST_OFST

346: ) AS
347:
348: CURSOR cur_rowid IS
349: SELECT rowid
350: FROM IGS_CA_DA_INST_OFST
351:
352: WHERE (dt_alias = x_dt_alias
353: AND dai_sequence_number = x_sequence_number
354: AND cal_type = x_cal_type

Line 516: cursor C is select ROWID from IGS_CA_DA_INST_OFST

512: X_YEAR_OFFSET in NUMBER,
513: X_OFST_OVERRIDE in VARCHAR2,
514: X_MODE in VARCHAR2 default 'R'
515: ) AS
516: cursor C is select ROWID from IGS_CA_DA_INST_OFST
517: where DT_ALIAS = X_DT_ALIAS
518: and DAI_SEQUENCE_NUMBER = X_DAI_SEQUENCE_NUMBER
519: and CAL_TYPE = X_CAL_TYPE
520: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER

Line 569: insert into IGS_CA_DA_INST_OFST (

565: x_last_update_date =>X_LAST_UPDATE_DATE,
566: x_last_updated_by =>X_LAST_UPDATED_BY,
567: x_last_update_login =>X_LAST_UPDATE_LOGIN
568: );
569: insert into IGS_CA_DA_INST_OFST (
570: DT_ALIAS,
571: DAI_SEQUENCE_NUMBER,
572: CAL_TYPE,
573: CI_SEQUENCE_NUMBER,

Line 645: from IGS_CA_DA_INST_OFST

641: WEEK_OFFSET,
642: MONTH_OFFSET,
643: YEAR_OFFSET,
644: OFST_OVERRIDE
645: from IGS_CA_DA_INST_OFST
646: where ROWID = X_ROWID
647: for update nowait;
648: tlinfo c1%rowtype;
649:

Line 748: update IGS_CA_DA_INST_OFST set

744: x_last_update_date =>X_LAST_UPDATE_DATE,
745: x_last_updated_by =>X_LAST_UPDATED_BY,
746: x_last_update_login =>X_LAST_UPDATE_LOGIN
747: );
748: update IGS_CA_DA_INST_OFST set
749: DAY_OFFSET = NEW_REFERENCES.DAY_OFFSET,
750: WEEK_OFFSET = NEW_REFERENCES.WEEK_OFFSET,
751: MONTH_OFFSET = NEW_REFERENCES.MONTH_OFFSET,
752: YEAR_OFFSET = NEW_REFERENCES.YEAR_OFFSET,

Line 785: cursor c1 is select rowid from IGS_CA_DA_INST_OFST

781: X_YEAR_OFFSET in NUMBER,
782: X_OFST_OVERRIDE in VARCHAR2,
783: X_MODE in VARCHAR2 default 'R'
784: ) AS
785: cursor c1 is select rowid from IGS_CA_DA_INST_OFST
786: where DT_ALIAS = X_DT_ALIAS
787: and DAI_SEQUENCE_NUMBER = X_DAI_SEQUENCE_NUMBER
788: and CAL_TYPE = X_CAL_TYPE
789: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER

Line 845: delete from IGS_CA_DA_INST_OFST

841: Before_DML (
842: p_action =>'DELETE',
843: x_rowid =>X_ROWID
844: );
845: delete from IGS_CA_DA_INST_OFST
846: where ROWID = X_ROWID;
847: if (sql%notfound) then
848: raise no_data_found;
849: end if;

Line 856: end IGS_CA_DA_INST_OFST_PKG;

852: x_rowid =>X_ROWID
853: );
854: end DELETE_ROW;
855:
856: end IGS_CA_DA_INST_OFST_PKG;