APPS.IGS_AD_CAT_PKG dependencies on IGS_AD_CAT_ALL

Line 5: old_references IGS_AD_CAT_ALL%RowType;

1: package body IGS_AD_CAT_PKG As
2: /* $Header: IGSAI07B.pls 115.11 2003/10/30 13:10:10 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_CAT_ALL%RowType;
6: new_references IGS_AD_CAT_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AD_CAT_ALL%RowType;

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

Line 25: FROM IGS_AD_CAT_ALL

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

Line 174: FROM IGS_AD_CAT_ALL

170: RETURN BOOLEAN AS
171: gv_other_detail VARCHAR2(255);
172: CURSOR cur_rowid IS
173: SELECT rowid
174: FROM IGS_AD_CAT_ALL
175: WHERE admission_cat = x_admission_cat AND
176: closed_ind = NVL(x_closed_ind,closed_ind);
177:
178: lv_rowid cur_rowid%RowType;

Line 272: cursor C is select ROWID from IGS_AD_CAT_ALL

268: X_S_CITIZENSHIP_TYPE in VARCHAR2,
269: X_CLOSED_IND in VARCHAR2,
270: X_MODE in VARCHAR2 default 'R'
271: ) AS
272: cursor C is select ROWID from IGS_AD_CAT_ALL
273: where ADMISSION_CAT = X_ADMISSION_CAT;
274: X_LAST_UPDATE_DATE DATE;
275: X_LAST_UPDATED_BY NUMBER;
276: X_LAST_UPDATE_LOGIN NUMBER;

Line 312: insert into IGS_AD_CAT_ALL (

308: x_last_updated_by=>X_LAST_UPDATED_BY,
309: x_last_update_login=>X_LAST_UPDATE_LOGIN
310: );
311:
312: insert into IGS_AD_CAT_ALL (
313: ORG_ID,
314: ADMISSION_CAT,
315: DESCRIPTION,
316: S_CITIZENSHIP_TYPE,

Line 361: from IGS_AD_CAT_ALL

357: cursor c1 is select
358: DESCRIPTION,
359: S_CITIZENSHIP_TYPE,
360: CLOSED_IND
361: from IGS_AD_CAT_ALL
362: where ROWID = X_ROWID for update nowait;
363: tlinfo c1%rowtype;
364:
365: begin

Line 435: update IGS_AD_CAT_ALL set

431: x_last_updated_by=>X_LAST_UPDATED_BY,
432: x_last_update_login=>X_LAST_UPDATE_LOGIN
433: );
434:
435: update IGS_AD_CAT_ALL set
436: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
437: S_CITIZENSHIP_TYPE = NEW_REFERENCES.S_CITIZENSHIP_TYPE,
438: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
439: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 463: cursor c1 is select rowid from IGS_AD_CAT_ALL

459: X_S_CITIZENSHIP_TYPE in VARCHAR2,
460: X_CLOSED_IND in VARCHAR2,
461: X_MODE in VARCHAR2 default 'R'
462: ) AS
463: cursor c1 is select rowid from IGS_AD_CAT_ALL
464: where ADMISSION_CAT = X_ADMISSION_CAT
465: ;
466: begin
467: open c1;

Line 500: delete from IGS_AD_CAT_ALL

496: Before_DML (
497: p_action => 'DELETE',
498: x_rowid => X_ROWID);
499:
500: delete from IGS_AD_CAT_ALL
501: where ROWID = X_ROWID;
502: if (sql%notfound) then
503: raise no_data_found;
504: end if;