APPS.IGS_CA_DA_CAT_PKG dependencies on IGS_CA_DA_CAT

Line 1: package body IGS_CA_DA_CAT_PKG AS

1: package body IGS_CA_DA_CAT_PKG AS
2: /* $Header: IGSCI03B.pls 115.3 2002/11/28 22:59:53 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_CAT%RowType;
5: new_references IGS_CA_DA_CAT%RowType;

Line 4: old_references IGS_CA_DA_CAT%RowType;

1: package body IGS_CA_DA_CAT_PKG AS
2: /* $Header: IGSCI03B.pls 115.3 2002/11/28 22:59:53 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_CAT%RowType;
5: new_references IGS_CA_DA_CAT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_CA_DA_CAT%RowType;

1: package body IGS_CA_DA_CAT_PKG AS
2: /* $Header: IGSCI03B.pls 115.3 2002/11/28 22:59:53 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_CAT%RowType;
5: new_references IGS_CA_DA_CAT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 21: FROM IGS_CA_DA_CAT

17: ) AS
18:
19: CURSOR cur_old_ref_values IS
20: SELECT *
21: FROM IGS_CA_DA_CAT
22: WHERE rowid = x_rowid;
23:
24: BEGIN
25:

Line 81: IGS_CA_DA_PKG.GET_FK_IGS_CA_DA_CAT (

77:
78: PROCEDURE Check_Child_Existance AS
79: BEGIN
80:
81: IGS_CA_DA_PKG.GET_FK_IGS_CA_DA_CAT (
82: old_references.dt_cat
83: );
84:
85: END Check_Child_Existance;

Line 93: FROM IGS_CA_DA_CAT

89: )RETURN BOOLEAN AS
90:
91: CURSOR cur_rowid IS
92: SELECT rowid
93: FROM IGS_CA_DA_CAT
94: WHERE dt_cat = x_dt_cat
95: FOR UPDATE NOWAIT;
96:
97: lv_rowid cur_rowid%RowType;

Line 176: cursor C is select ROWID from IGS_CA_DA_CAT

172: X_DT_CAT in VARCHAR2,
173: X_DESCRIPTION in VARCHAR2,
174: X_MODE in VARCHAR2 default 'R'
175: ) AS
176: cursor C is select ROWID from IGS_CA_DA_CAT
177: where DT_CAT = X_DT_CAT;
178: X_LAST_UPDATE_DATE DATE;
179: X_LAST_UPDATED_BY NUMBER;
180: X_LAST_UPDATE_LOGIN NUMBER;

Line 212: insert into IGS_CA_DA_CAT (

208: x_last_updated_by =>X_LAST_UPDATED_BY,
209: x_last_update_login =>X_LAST_UPDATE_LOGIN
210: );
211:
212: insert into IGS_CA_DA_CAT (
213: DT_CAT,
214: DESCRIPTION,
215: CREATION_DATE,
216: CREATED_BY,

Line 246: from IGS_CA_DA_CAT

242: X_DESCRIPTION in VARCHAR2
243: ) AS
244: cursor c1 is select
245: DESCRIPTION
246: from IGS_CA_DA_CAT
247: where ROWID = X_ROWID
248: for update nowait;
249: tlinfo c1%rowtype;
250:

Line 315: update IGS_CA_DA_CAT set

311: x_last_updated_by =>X_LAST_UPDATED_BY,
312: x_last_update_login =>X_LAST_UPDATE_LOGIN
313: );
314:
315: update IGS_CA_DA_CAT set
316: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
317: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
318: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
319: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 333: cursor c1 is select rowid from IGS_CA_DA_CAT

329: X_DT_CAT in VARCHAR2,
330: X_DESCRIPTION in VARCHAR2,
331: X_MODE in VARCHAR2 default 'R'
332: ) AS
333: cursor c1 is select rowid from IGS_CA_DA_CAT
334: where ROWID = X_ROWID
335: ;
336: begin
337: open c1;

Line 365: delete from IGS_CA_DA_CAT

361: p_action =>'DELETE',
362: x_rowid =>X_ROWID
363: );
364:
365: delete from IGS_CA_DA_CAT
366: where ROWID = X_ROWID;
367: if (sql%notfound) then
368: raise no_data_found;
369: end if;

Line 372: end IGS_CA_DA_CAT_PKG;

368: raise no_data_found;
369: end if;
370: end DELETE_ROW;
371:
372: end IGS_CA_DA_CAT_PKG;