APPS.IGS_EN_ATD_MODE_PKG dependencies on IGS_EN_ATD_MODE_ALL

Line 5: old_references IGS_EN_ATD_MODE_ALL%RowType;

1: package body IGS_EN_ATD_MODE_PKG as
2: /* $Header: IGSEI13B.pls 115.8 2003/02/04 08:24:00 srdirisa ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_ATD_MODE_ALL%RowType;
6: new_references IGS_EN_ATD_MODE_ALL%RowType;
7: PROCEDURE beforerowdelete;
8:
9: PROCEDURE Set_Column_Values (

Line 6: new_references IGS_EN_ATD_MODE_ALL%RowType;

2: /* $Header: IGSEI13B.pls 115.8 2003/02/04 08:24:00 srdirisa ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_ATD_MODE_ALL%RowType;
6: new_references IGS_EN_ATD_MODE_ALL%RowType;
7: PROCEDURE beforerowdelete;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 26: FROM IGS_EN_ATD_MODE_ALL

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

Line 217: FROM IGS_EN_ATD_MODE_ALL

213: ) RETURN BOOLEAN AS
214:
215: CURSOR cur_rowid IS
216: SELECT rowid
217: FROM IGS_EN_ATD_MODE_ALL
218: WHERE attendance_mode = x_attendance_mode;
219:
220: lv_rowid cur_rowid%RowType;
221:

Line 242: FROM IGS_EN_ATD_MODE_ALL

238: ) AS
239:
240: CURSOR cur_rowid IS
241: SELECT rowid
242: FROM IGS_EN_ATD_MODE_ALL
243: WHERE govt_attendance_mode = x_govt_attendance_mode ;
244:
245: lv_rowid cur_rowid%RowType;
246:

Line 362: cursor C is select ROWID from IGS_EN_ATD_MODE_ALL

358: X_GOVT_ATTENDANCE_MODE in VARCHAR2,
359: X_CLOSED_IND in VARCHAR2,
360: X_MODE in VARCHAR2 default 'R'
361: ) AS
362: cursor C is select ROWID from IGS_EN_ATD_MODE_ALL
363: where ATTENDANCE_MODE = X_ATTENDANCE_MODE;
364: X_LAST_UPDATE_DATE DATE;
365: X_LAST_UPDATED_BY NUMBER;
366: X_LAST_UPDATE_LOGIN NUMBER;

Line 402: insert into IGS_EN_ATD_MODE_ALL (

398: x_last_updated_by => X_LAST_UPDATED_BY,
399: x_last_update_login => X_LAST_UPDATE_LOGIN
400: );
401:
402: insert into IGS_EN_ATD_MODE_ALL (
403: org_id,
404: ATTENDANCE_MODE,
405: DESCRIPTION,
406: GOVT_ATTENDANCE_MODE,

Line 454: from IGS_EN_ATD_MODE_ALL

450: cursor c1 is select
451: DESCRIPTION,
452: GOVT_ATTENDANCE_MODE,
453: CLOSED_IND
454: from IGS_EN_ATD_MODE_ALL
455: where ROWID = X_ROWID
456: for update nowait;
457: tlinfo c1%rowtype;
458:

Line 529: update IGS_EN_ATD_MODE_ALL set

525: x_last_updated_by => X_LAST_UPDATED_BY,
526: x_last_update_login => X_LAST_UPDATE_LOGIN
527: );
528:
529: update IGS_EN_ATD_MODE_ALL set
530: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
531: GOVT_ATTENDANCE_MODE = NEW_REFERENCES.GOVT_ATTENDANCE_MODE,
532: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
533: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 559: cursor c1 is select rowid from IGS_EN_ATD_MODE_ALL

555: X_GOVT_ATTENDANCE_MODE in VARCHAR2,
556: X_CLOSED_IND in VARCHAR2,
557: X_MODE in VARCHAR2 default 'R'
558: ) AS
559: cursor c1 is select rowid from IGS_EN_ATD_MODE_ALL
560: where ATTENDANCE_MODE = X_ATTENDANCE_MODE
561: ;
562:
563: begin

Line 599: delete from IGS_EN_ATD_MODE_ALL

595: x_rowid => X_ROWID
596: );
597:
598:
599: delete from IGS_EN_ATD_MODE_ALL
600: where ROWID = X_ROWID;
601: if (sql%notfound) then
602: raise no_data_found;
603: end if;