APPS.IGS_CA_DA_OFST_PKG dependencies on IGS_CA_DA_OFST

Line 1: package body IGS_CA_DA_OFST_PKG AS

1: package body IGS_CA_DA_OFST_PKG AS
2: /* $Header: IGSCI09B.pls 115.4 2002/11/28 23:01:40 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_OFST%RowType;
5: new_references IGS_CA_DA_OFST%RowType;

Line 4: old_references IGS_CA_DA_OFST%RowType;

1: package body IGS_CA_DA_OFST_PKG AS
2: /* $Header: IGSCI09B.pls 115.4 2002/11/28 23:01:40 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_OFST%RowType;
5: new_references IGS_CA_DA_OFST%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_CA_DA_OFST%RowType;

1: package body IGS_CA_DA_OFST_PKG AS
2: /* $Header: IGSCI09B.pls 115.4 2002/11/28 23:01:40 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_OFST%RowType;
5: new_references IGS_CA_DA_OFST%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 25: FROM IGS_CA_DA_OFST

21: ) AS
22:
23: CURSOR cur_old_ref_values IS
24: SELECT *
25: FROM IGS_CA_DA_OFST
26: WHERE rowid = x_rowid;
27:
28: BEGIN
29:

Line 68: -- ON IGS_CA_DA_OFST

64:
65: -- Trigger description :-
66: -- "OSS_TST".trg_dao_as_iu
67: -- AFTER INSERT OR UPDATE
68: -- ON IGS_CA_DA_OFST
69:
70: PROCEDURE AfterStmtInsertUpdate2(
71: p_inserting IN BOOLEAN DEFAULT FALSE,
72: p_updating IN BOOLEAN DEFAULT FALSE,

Line 201: IGS_CA_DA_OFFCNT_PKG.GET_FK_IGS_CA_DA_OFST (

197:
198: PROCEDURE Check_Child_Existance AS
199: BEGIN
200:
201: IGS_CA_DA_OFFCNT_PKG.GET_FK_IGS_CA_DA_OFST (
202: old_references.dt_alias,
203: old_references.offset_dt_alias
204: );
205:

Line 215: FROM IGS_CA_DA_OFST

211: ) RETURN BOOLEAN AS
212:
213: CURSOR cur_rowid IS
214: SELECT rowid
215: FROM IGS_CA_DA_OFST
216: WHERE dt_alias = x_dt_alias
217: AND offset_dt_alias = x_offset_dt_alias
218: FOR UPDATE NOWAIT;
219:

Line 242: FROM IGS_CA_DA_OFST

238: ) AS
239:
240: CURSOR cur_rowid IS
241: SELECT rowid
242: FROM IGS_CA_DA_OFST
243: WHERE dt_alias = x_dt_alias
244: OR offset_dt_alias = x_dt_alias ;
245:
246: lv_rowid cur_rowid%RowType;

Line 371: cursor C is select ROWID from IGS_CA_DA_OFST

367: X_MONTH_OFFSET in NUMBER,
368: X_YEAR_OFFSET in NUMBER,
369: X_MODE in VARCHAR2 default 'R'
370: ) AS
371: cursor C is select ROWID from IGS_CA_DA_OFST
372: where DT_ALIAS = X_DT_ALIAS
373: and OFFSET_DT_ALIAS = X_OFFSET_DT_ALIAS;
374: X_LAST_UPDATE_DATE DATE;
375: X_LAST_UPDATED_BY NUMBER;

Line 411: insert into IGS_CA_DA_OFST (

407: x_last_update_date =>X_LAST_UPDATE_DATE,
408: x_last_updated_by =>X_LAST_UPDATED_BY,
409: x_last_update_login =>X_LAST_UPDATE_LOGIN
410: );
411: insert into IGS_CA_DA_OFST (
412: DT_ALIAS,
413: OFFSET_DT_ALIAS,
414: DAY_OFFSET,
415: WEEK_OFFSET,

Line 466: from IGS_CA_DA_OFST

462: DAY_OFFSET,
463: WEEK_OFFSET,
464: MONTH_OFFSET,
465: YEAR_OFFSET
466: from IGS_CA_DA_OFST
467: where ROWID = X_ROWID
468: for update nowait;
469: tlinfo c1%rowtype;
470:

Line 552: update IGS_CA_DA_OFST set

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_OFST set
553: DAY_OFFSET = NEW_REFERENCES.DAY_OFFSET,
554: WEEK_OFFSET = NEW_REFERENCES.WEEK_OFFSET,
555: MONTH_OFFSET = NEW_REFERENCES.MONTH_OFFSET,
556: YEAR_OFFSET = NEW_REFERENCES.YEAR_OFFSET,

Line 581: cursor c1 is select rowid from IGS_CA_DA_OFST

577: X_MONTH_OFFSET in NUMBER,
578: X_YEAR_OFFSET in NUMBER,
579: X_MODE in VARCHAR2 default 'R'
580: ) AS
581: cursor c1 is select rowid from IGS_CA_DA_OFST
582: where DT_ALIAS = X_DT_ALIAS
583: and OFFSET_DT_ALIAS = X_OFFSET_DT_ALIAS
584: ;
585: begin

Line 621: delete from IGS_CA_DA_OFST

617: Before_DML (
618: p_action =>'DELETE',
619: x_rowid =>X_ROWID
620: );
621: delete from IGS_CA_DA_OFST
622: where ROWID = X_ROWID;
623: if (sql%notfound) then
624: raise no_data_found;
625: end if;

Line 632: end IGS_CA_DA_OFST_PKG;

628: x_rowid =>X_ROWID
629: );
630: end DELETE_ROW;
631:
632: end IGS_CA_DA_OFST_PKG;