APPS.IGS_PS_GOVT_ATD_TYPE_PKG dependencies on IGS_PS_GOVT_ATD_TYPE

Line 1: package body IGS_PS_GOVT_ATD_TYPE_PKG as

1: package body IGS_PS_GOVT_ATD_TYPE_PKG as
2: /* $Header: IGSPI57B.pls 115.3 2002/11/29 02:31:59 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_GOVT_ATD_TYPE%RowType;
5: new_references IGS_PS_GOVT_ATD_TYPE%RowType;

Line 4: old_references IGS_PS_GOVT_ATD_TYPE%RowType;

1: package body IGS_PS_GOVT_ATD_TYPE_PKG as
2: /* $Header: IGSPI57B.pls 115.3 2002/11/29 02:31:59 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_GOVT_ATD_TYPE%RowType;
5: new_references IGS_PS_GOVT_ATD_TYPE%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_PS_GOVT_ATD_TYPE%RowType;

1: package body IGS_PS_GOVT_ATD_TYPE_PKG as
2: /* $Header: IGSPI57B.pls 115.3 2002/11/29 02:31:59 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_GOVT_ATD_TYPE%RowType;
5: new_references IGS_PS_GOVT_ATD_TYPE%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 22: FROM IGS_PS_GOVT_ATD_TYPE

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

Line 119: IGS_EN_ATD_TYPE_PKG.GET_FK_IGS_PS_GOVT_ATD_TYPE (

115:
116: PROCEDURE Check_Child_Existance AS
117: BEGIN
118:
119: IGS_EN_ATD_TYPE_PKG.GET_FK_IGS_PS_GOVT_ATD_TYPE (
120: old_references.govt_attendance_type
121: );
122:
123: END Check_Child_Existance;

Line 131: FROM IGS_PS_GOVT_ATD_TYPE

127: ) RETURN BOOLEAN AS
128:
129: CURSOR cur_rowid IS
130: SELECT rowid
131: FROM IGS_PS_GOVT_ATD_TYPE
132: WHERE govt_attendance_type = x_govt_attendance_type
133: FOR UPDATE NOWAIT;
134:
135: lv_rowid cur_rowid%RowType;

Line 229: cursor C is select ROWID from IGS_PS_GOVT_ATD_TYPE

225: X_DESCRIPTION in VARCHAR2,
226: X_CLOSED_IND in VARCHAR2,
227: X_MODE in VARCHAR2 default 'R'
228: ) as
229: cursor C is select ROWID from IGS_PS_GOVT_ATD_TYPE
230: where GOVT_ATTENDANCE_TYPE = X_GOVT_ATTENDANCE_TYPE;
231: X_LAST_UPDATE_DATE DATE;
232: X_LAST_UPDATED_BY NUMBER;
233: X_LAST_UPDATE_LOGIN NUMBER;

Line 264: insert into IGS_PS_GOVT_ATD_TYPE (

260: x_last_update_date => X_LAST_UPDATE_DATE,
261: x_last_updated_by => X_LAST_UPDATED_BY,
262: x_last_update_login => X_LAST_UPDATE_LOGIN
263: );
264: insert into IGS_PS_GOVT_ATD_TYPE (
265: GOVT_ATTENDANCE_TYPE,
266: DESCRIPTION,
267: CLOSED_IND,
268: CREATION_DATE,

Line 306: from IGS_PS_GOVT_ATD_TYPE

302: ) as
303: cursor c1 is select
304: DESCRIPTION,
305: CLOSED_IND
306: from IGS_PS_GOVT_ATD_TYPE
307: where ROWID = X_ROWID for update nowait;
308: tlinfo c1%rowtype;
309:
310: begin

Line 374: update IGS_PS_GOVT_ATD_TYPE set

370: x_last_update_date => X_LAST_UPDATE_DATE,
371: x_last_updated_by => X_LAST_UPDATED_BY,
372: x_last_update_login => X_LAST_UPDATE_LOGIN
373: );
374: update IGS_PS_GOVT_ATD_TYPE set
375: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
376: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
377: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
378: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 397: cursor c1 is select rowid from IGS_PS_GOVT_ATD_TYPE

393: X_DESCRIPTION in VARCHAR2,
394: X_CLOSED_IND in VARCHAR2,
395: X_MODE in VARCHAR2 default 'R'
396: ) as
397: cursor c1 is select rowid from IGS_PS_GOVT_ATD_TYPE
398: where GOVT_ATTENDANCE_TYPE = X_GOVT_ATTENDANCE_TYPE
399: ;
400: begin
401: open c1;

Line 429: delete from IGS_PS_GOVT_ATD_TYPE

425: begin
426: Before_DML( p_action => 'DELETE',
427: x_rowid => X_ROWID
428: );
429: delete from IGS_PS_GOVT_ATD_TYPE
430: where ROWID = X_ROWID;
431: if (sql%notfound) then
432: raise no_data_found;
433: end if;

Line 440: end IGS_PS_GOVT_ATD_TYPE_PKG;

436: x_rowid => X_ROWID
437: );
438: end DELETE_ROW;
439:
440: end IGS_PS_GOVT_ATD_TYPE_PKG;