APPS.IGS_EN_ATD_TYPE_PKG dependencies on IGS_EN_ATD_TYPE_ALL

Line 5: old_references IGS_EN_ATD_TYPE_ALL%RowType;

1: package body IGS_EN_ATD_TYPE_PKG as
2: /* $Header: IGSEI14B.pls 115.11 2003/02/04 08:24:39 srdirisa ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_ATD_TYPE_ALL%RowType;
6: new_references IGS_EN_ATD_TYPE_ALL%RowType;
7: PROCEDURE beforerowdelete;
8:
9: PROCEDURE Set_Column_Values (

Line 6: new_references IGS_EN_ATD_TYPE_ALL%RowType;

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

Line 29: FROM IGS_EN_ATD_TYPE_ALL

25: ) AS
26:
27: CURSOR cur_old_ref_values IS
28: SELECT *
29: FROM IGS_EN_ATD_TYPE_ALL
30: WHERE rowid = x_rowid;
31:
32: BEGIN
33:

Line 282: FROM IGS_EN_ATD_TYPE_ALL

278: ) RETURN BOOLEAN AS
279:
280: CURSOR cur_rowid IS
281: SELECT rowid
282: FROM IGS_EN_ATD_TYPE_ALL
283: WHERE attendance_type = x_attendance_type;
284:
285: lv_rowid cur_rowid%RowType;
286:

Line 307: FROM IGS_EN_ATD_TYPE_ALL

303: ) AS
304:
305: CURSOR cur_rowid IS
306: SELECT rowid
307: FROM IGS_EN_ATD_TYPE_ALL
308: WHERE govt_attendance_type = x_govt_attendance_type ;
309:
310: lv_rowid cur_rowid%RowType;
311:

Line 435: cursor C is select ROWID from IGS_EN_ATD_TYPE_ALL

431: X_RESEARCH_PERCENTAGE in NUMBER,
432: X_CLOSED_IND in VARCHAR2,
433: X_MODE in VARCHAR2 default 'R'
434: ) AS
435: cursor C is select ROWID from IGS_EN_ATD_TYPE_ALL
436: where ATTENDANCE_TYPE = X_ATTENDANCE_TYPE;
437: X_LAST_UPDATE_DATE DATE;
438: X_LAST_UPDATED_BY NUMBER;
439: X_LAST_UPDATE_LOGIN NUMBER;

Line 478: insert into IGS_EN_ATD_TYPE_ALL (

474: x_last_updated_by => X_LAST_UPDATED_BY,
475: x_last_update_login => X_LAST_UPDATE_LOGIN
476: );
477:
478: insert into IGS_EN_ATD_TYPE_ALL (
479: org_id,
480: ATTENDANCE_TYPE,
481: DESCRIPTION,
482: GOVT_ATTENDANCE_TYPE,

Line 541: from IGS_EN_ATD_TYPE_ALL

537: LOWER_ENR_LOAD_RANGE,
538: UPPER_ENR_LOAD_RANGE,
539: RESEARCH_PERCENTAGE,
540: CLOSED_IND
541: from IGS_EN_ATD_TYPE_ALL
542: where ROWID = X_ROWID
543: for update nowait;
544: tlinfo c1%rowtype;
545:

Line 627: update IGS_EN_ATD_TYPE_ALL set

623: x_last_updated_by => X_LAST_UPDATED_BY,
624: x_last_update_login => X_LAST_UPDATE_LOGIN
625: );
626:
627: update IGS_EN_ATD_TYPE_ALL set
628: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
629: GOVT_ATTENDANCE_TYPE = NEW_REFERENCES.GOVT_ATTENDANCE_TYPE,
630: LOWER_ENR_LOAD_RANGE = NEW_REFERENCES.LOWER_ENR_LOAD_RANGE,
631: UPPER_ENR_LOAD_RANGE = NEW_REFERENCES.UPPER_ENR_LOAD_RANGE,

Line 662: cursor c1 is select rowid from IGS_EN_ATD_TYPE_ALL

658: X_RESEARCH_PERCENTAGE in NUMBER,
659: X_CLOSED_IND in VARCHAR2,
660: X_MODE in VARCHAR2 default 'R'
661: ) AS
662: cursor c1 is select rowid from IGS_EN_ATD_TYPE_ALL
663: where ATTENDANCE_TYPE = X_ATTENDANCE_TYPE
664: ;
665:
666: begin

Line 707: delete from IGS_EN_ATD_TYPE_ALL

703: x_rowid => X_ROWID
704: );
705:
706:
707: delete from IGS_EN_ATD_TYPE_ALL
708: where ROWID = X_ROWID;
709: if (sql%notfound) then
710: raise no_data_found;
711: end if;