APPS.IGS_AD_DISBL_TYPE_PKG dependencies on IGS_AD_DISBL_TYPE

Line 1: package body IGS_AD_DISBL_TYPE_PKG as

1: package body IGS_AD_DISBL_TYPE_PKG as
2: /* $Header: IGSAI34B.pls 115.5 2003/10/30 13:12:25 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_DISBL_TYPE%RowType;

Line 5: old_references IGS_AD_DISBL_TYPE%RowType;

1: package body IGS_AD_DISBL_TYPE_PKG as
2: /* $Header: IGSAI34B.pls 115.5 2003/10/30 13:12:25 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_DISBL_TYPE%RowType;
6: new_references IGS_AD_DISBL_TYPE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AD_DISBL_TYPE%RowType;

2: /* $Header: IGSAI34B.pls 115.5 2003/10/30 13:12:25 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_DISBL_TYPE%RowType;
6: new_references IGS_AD_DISBL_TYPE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_AD_DISBL_TYPE

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

Line 125: IGS_PE_PERS_DISABLTY_PKG.GET_FK_IGS_AD_DISBL_TYPE (

121:
122: PROCEDURE Check_Child_Existance as
123: BEGIN
124:
125: IGS_PE_PERS_DISABLTY_PKG.GET_FK_IGS_AD_DISBL_TYPE (
126: old_references.disability_type
127: );
128:
129: END Check_Child_Existance;

Line 139: FROM IGS_AD_DISBL_TYPE

135: as
136:
137: CURSOR cur_rowid IS
138: SELECT rowid
139: FROM IGS_AD_DISBL_TYPE
140: WHERE disability_type = x_disability_type AND
141: closed_ind = NVL(x_closed_ind,closed_ind);
142:
143: lv_rowid cur_rowid%RowType;

Line 244: cursor C is select ROWID from IGS_AD_DISBL_TYPE

240: X_DESCRIPTION in VARCHAR2,
241: X_CLOSED_IND in VARCHAR2,
242: X_MODE in VARCHAR2 default 'R'
243: ) as
244: cursor C is select ROWID from IGS_AD_DISBL_TYPE
245: where DISABILITY_TYPE = X_DISABILITY_TYPE;
246: X_LAST_UPDATE_DATE DATE;
247: X_LAST_UPDATED_BY NUMBER;
248: X_LAST_UPDATE_LOGIN NUMBER;

Line 285: insert into IGS_AD_DISBL_TYPE (

281: );
282:
283:
284:
285: insert into IGS_AD_DISBL_TYPE (
286: DISABILITY_TYPE,
287: GOVT_DISABILITY_TYPE,
288: DESCRIPTION,
289: CLOSED_IND,

Line 334: from IGS_AD_DISBL_TYPE

330: cursor c1 is select
331: GOVT_DISABILITY_TYPE,
332: DESCRIPTION,
333: CLOSED_IND
334: from IGS_AD_DISBL_TYPE
335: WHERE ROWID = X_ROWID for update nowait ;
336:
337: tlinfo c1%rowtype;
338:

Line 411: update IGS_AD_DISBL_TYPE set

407: );
408:
409:
410:
411: update IGS_AD_DISBL_TYPE set
412: GOVT_DISABILITY_TYPE = NEW_REFERENCES.GOVT_DISABILITY_TYPE,
413: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
414: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
415: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 439: cursor c1 is select rowid from IGS_AD_DISBL_TYPE

435: X_DESCRIPTION in VARCHAR2,
436: X_CLOSED_IND in VARCHAR2,
437: X_MODE in VARCHAR2 default 'R'
438: ) as
439: cursor c1 is select rowid from IGS_AD_DISBL_TYPE
440: where DISABILITY_TYPE = X_DISABILITY_TYPE
441: ;
442:
443: begin

Line 477: delete from IGS_AD_DISBL_TYPE

473: p_action=>'DELETE',
474: x_rowid=> X_ROWID
475: );
476:
477: delete from IGS_AD_DISBL_TYPE
478: WHERE ROWID = X_ROWID;
479: if (sql%notfound) then
480: raise no_data_found;
481: end if;

Line 490: end IGS_AD_DISBL_TYPE_PKG;

486: );
487:
488: end DELETE_ROW;
489:
490: end IGS_AD_DISBL_TYPE_PKG;