APPS.IGS_CA_ARTS_TC_CA_CD_PKG dependencies on IGS_CA_ARTS_TC_CA_CD

Line 1: package body IGS_CA_ARTS_TC_CA_CD_PKG AS

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

Line 4: old_references IGS_CA_ARTS_TC_CA_CD%RowType;

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

Line 5: new_references IGS_CA_ARTS_TC_CA_CD%RowType;

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

Line 22: FROM IGS_CA_ARTS_TC_CA_CD

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

Line 63: IGS_CA_TYPE_PKG.GET_FK_IGS_CA_ARTS_TC_CA_CD (

59:
60: PROCEDURE Check_Child_Existance AS
61: BEGIN
62:
63: IGS_CA_TYPE_PKG.GET_FK_IGS_CA_ARTS_TC_CA_CD (
64: old_references.arts_teaching_cal_type_cd
65: );
66:
67: END Check_Child_Existance;

Line 75: FROM IGS_CA_ARTS_TC_CA_CD

71: ) RETURN BOOLEAN AS
72:
73: CURSOR cur_rowid IS
74: SELECT rowid
75: FROM IGS_CA_ARTS_TC_CA_CD
76: WHERE arts_teaching_cal_type_cd = x_arts_teaching_cal_type_cd
77: FOR UPDATE NOWAIT;
78:
79: lv_rowid cur_rowid%RowType;

Line 189: cursor C is select ROWID from IGS_CA_ARTS_TC_CA_CD

185: X_DESCRIPTION in VARCHAR2,
186: X_CLOSED_IND in VARCHAR2,
187: X_MODE in VARCHAR2 default 'R'
188: ) AS
189: cursor C is select ROWID from IGS_CA_ARTS_TC_CA_CD
190: where ARTS_TEACHING_CAL_TYPE_CD = X_ARTS_TEACHING_CAL_TYPE_CD;
191: X_LAST_UPDATE_DATE DATE;
192: X_LAST_UPDATED_BY NUMBER;
193: X_LAST_UPDATE_LOGIN NUMBER;

Line 225: insert into IGS_CA_ARTS_TC_CA_CD (

221: x_last_update_date =>X_LAST_UPDATE_DATE,
222: x_last_updated_by =>X_LAST_UPDATED_BY,
223: x_last_update_login =>X_LAST_UPDATE_LOGIN
224: );
225: insert into IGS_CA_ARTS_TC_CA_CD (
226: ARTS_TEACHING_CAL_TYPE_CD,
227: DESCRIPTION,
228: CLOSED_IND,
229: CREATION_DATE,

Line 264: from IGS_CA_ARTS_TC_CA_CD

260: ) AS
261: cursor c1 is select
262: DESCRIPTION,
263: CLOSED_IND
264: from IGS_CA_ARTS_TC_CA_CD
265: where ROWID = X_ROWID
266: for update nowait;
267: tlinfo c1%rowtype;
268:

Line 336: update IGS_CA_ARTS_TC_CA_CD set

332: x_last_updated_by =>X_LAST_UPDATED_BY,
333: x_last_update_login =>X_LAST_UPDATE_LOGIN
334: );
335:
336: update IGS_CA_ARTS_TC_CA_CD set
337: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
338: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
339: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
340: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 356: cursor c1 is select rowid from IGS_CA_ARTS_TC_CA_CD

352: X_DESCRIPTION in VARCHAR2,
353: X_CLOSED_IND in VARCHAR2,
354: X_MODE in VARCHAR2 default 'R'
355: ) AS
356: cursor c1 is select rowid from IGS_CA_ARTS_TC_CA_CD
357: where ARTS_TEACHING_CAL_TYPE_CD = X_ARTS_TEACHING_CAL_TYPE_CD
358: ;
359: begin
360: open c1;

Line 387: delete from IGS_CA_ARTS_TC_CA_CD

383: Before_DML (
384: p_action =>'DELETE',
385: x_rowid =>X_ROWID
386: );
387: delete from IGS_CA_ARTS_TC_CA_CD
388: where ROWID = X_ROWID;
389: if (sql%notfound) then
390: raise no_data_found;
391: end if;

Line 394: end IGS_CA_ARTS_TC_CA_CD_PKG;

390: raise no_data_found;
391: end if;
392: end DELETE_ROW;
393:
394: end IGS_CA_ARTS_TC_CA_CD_PKG;