APPS.IGS_EN_ATD_TYPE_LOAD_PKG dependencies on IGS_EN_ATD_TYPE_LOAD_ALL

Line 4: old_references IGS_EN_ATD_TYPE_LOAD_ALL%RowType;

1: package body IGS_EN_ATD_TYPE_LOAD_PKG AS
2: /* $Header: IGSEI19B.pls 120.1 2005/09/08 14:28:01 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_ATD_TYPE_LOAD_ALL%RowType;
5: new_references IGS_EN_ATD_TYPE_LOAD_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 5: new_references IGS_EN_ATD_TYPE_LOAD_ALL%RowType;

1: package body IGS_EN_ATD_TYPE_LOAD_PKG AS
2: /* $Header: IGSEI19B.pls 120.1 2005/09/08 14:28:01 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_ATD_TYPE_LOAD_ALL%RowType;
5: new_references IGS_EN_ATD_TYPE_LOAD_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_org_id IN NUMBER DEFAULT NULL,

Line 24: FROM IGS_EN_ATD_TYPE_LOAD_ALL

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

Line 205: FROM IGS_EN_ATD_TYPE_LOAD_ALL

201: ) RETURN BOOLEAN AS
202:
203: CURSOR cur_rowid IS
204: SELECT rowid
205: FROM IGS_EN_ATD_TYPE_LOAD_ALL
206: WHERE cal_type = x_cal_type
207: AND attendance_type = x_attendance_type
208: FOR UPDATE NOWAIT;
209:

Line 232: FROM IGS_EN_ATD_TYPE_LOAD_ALL

228: ) AS
229:
230: CURSOR cur_rowid IS
231: SELECT rowid
232: FROM IGS_EN_ATD_TYPE_LOAD_ALL
233: WHERE attendance_type = x_attendance_type ;
234:
235: lv_rowid cur_rowid%RowType;
236:

Line 258: FROM IGS_EN_ATD_TYPE_LOAD_ALL

254: )AS
255:
256: CURSOR cur_rowid IS
257: SELECT rowid
258: FROM IGS_EN_ATD_TYPE_LOAD_ALL
259: WHERE cal_type = x_cal_type ;
260:
261: lv_rowid cur_rowid%RowType;
262:

Line 379: cursor C is select ROWID from IGS_EN_ATD_TYPE_LOAD_ALL

375: X_UPPER_ENR_LOAD_RANGE in NUMBER,
376: X_DEFAULT_EFTSU in NUMBER,
377: X_MODE in VARCHAR2 default 'R'
378: ) AS
379: cursor C is select ROWID from IGS_EN_ATD_TYPE_LOAD_ALL
380: where CAL_TYPE = X_CAL_TYPE
381: and ATTENDANCE_TYPE = X_ATTENDANCE_TYPE;
382: X_LAST_UPDATE_DATE DATE;
383: X_LAST_UPDATED_BY NUMBER;

Line 419: insert into IGS_EN_ATD_TYPE_LOAD_ALL (

415: x_last_update_date => X_LAST_UPDATE_DATE,
416: x_last_updated_by => X_LAST_UPDATED_BY,
417: x_last_update_login => X_LAST_UPDATE_LOGIN
418: );
419: insert into IGS_EN_ATD_TYPE_LOAD_ALL (
420: org_id,
421: CAL_TYPE,
422: ATTENDANCE_TYPE,
423: LOWER_ENR_LOAD_RANGE,

Line 472: from IGS_EN_ATD_TYPE_LOAD_ALL

468: cursor c1 is select
469: LOWER_ENR_LOAD_RANGE,
470: UPPER_ENR_LOAD_RANGE,
471: DEFAULT_EFTSU
472: from IGS_EN_ATD_TYPE_LOAD_ALL
473: where ROWID = X_ROWID for update nowait;
474: tlinfo c1%rowtype;
475:
476: begin

Line 548: update IGS_EN_ATD_TYPE_LOAD_ALL set

544: x_last_update_date => X_LAST_UPDATE_DATE,
545: x_last_updated_by => X_LAST_UPDATED_BY,
546: x_last_update_login => X_LAST_UPDATE_LOGIN
547: );
548: update IGS_EN_ATD_TYPE_LOAD_ALL set
549: LOWER_ENR_LOAD_RANGE = NEW_REFERENCES.LOWER_ENR_LOAD_RANGE,
550: UPPER_ENR_LOAD_RANGE = NEW_REFERENCES.UPPER_ENR_LOAD_RANGE,
551: DEFAULT_EFTSU = NEW_REFERENCES.DEFAULT_EFTSU,
552: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 577: cursor c1 is select rowid from IGS_EN_ATD_TYPE_LOAD_ALL

573: X_UPPER_ENR_LOAD_RANGE in NUMBER,
574: X_DEFAULT_EFTSU in NUMBER,
575: X_MODE in VARCHAR2 default 'R'
576: ) AS
577: cursor c1 is select rowid from IGS_EN_ATD_TYPE_LOAD_ALL
578: where CAL_TYPE = X_CAL_TYPE
579: and ATTENDANCE_TYPE = X_ATTENDANCE_TYPE
580: ;
581:

Line 616: delete from IGS_EN_ATD_TYPE_LOAD_ALL

612: Before_DML(
613: p_action => 'DELETE',
614: x_rowid => X_ROWID
615: );
616: delete from IGS_EN_ATD_TYPE_LOAD_ALL
617: where ROWID = X_ROWID;
618: if (sql%notfound) then
619: raise no_data_found;
620: end if;