APPS.IGS_AD_CAT_PS_TYPE_PKG dependencies on IGS_AD_CAT_PS_TYPE

Line 1: package body IGS_AD_CAT_PS_TYPE_PKG as

1: package body IGS_AD_CAT_PS_TYPE_PKG as
2: /* $Header: IGSAI13B.pls 115.7 2003/10/30 13:19:01 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_CAT_PS_TYPE%RowType;

Line 5: old_references IGS_AD_CAT_PS_TYPE%RowType;

1: package body IGS_AD_CAT_PS_TYPE_PKG as
2: /* $Header: IGSAI13B.pls 115.7 2003/10/30 13:19:01 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_CAT_PS_TYPE%RowType;
6: new_references IGS_AD_CAT_PS_TYPE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AD_CAT_PS_TYPE%RowType;

2: /* $Header: IGSAI13B.pls 115.7 2003/10/30 13:19:01 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_CAT_PS_TYPE%RowType;
6: new_references IGS_AD_CAT_PS_TYPE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 22: FROM IGS_AD_CAT_PS_TYPE

18: ) AS
19:
20: CURSOR cur_old_ref_values IS
21: SELECT *
22: FROM IGS_AD_CAT_PS_TYPE
23: WHERE rowid = x_rowid;
24:
25: BEGIN
26:

Line 147: FROM IGS_AD_CAT_PS_TYPE

143: x_course_type IN VARCHAR2 )
144: RETURN BOOLEAN AS
145: CURSOR cur_rowid IS
146: SELECT rowid
147: FROM IGS_AD_CAT_PS_TYPE
148: WHERE admission_cat = x_admission_cat
149: AND course_type = x_course_type
150: FOR UPDATE NOWAIT;
151: lv_rowid cur_rowid%RowType;

Line 170: FROM IGS_AD_CAT_PS_TYPE

166: ) AS
167:
168: CURSOR cur_rowid IS
169: SELECT rowid
170: FROM IGS_AD_CAT_PS_TYPE
171: WHERE admission_cat = x_admission_cat ;
172:
173: lv_rowid cur_rowid%RowType;
174:

Line 260: cursor C is select ROWID from IGS_AD_CAT_PS_TYPE

256: X_ADMISSION_CAT in VARCHAR2,
257: X_COURSE_TYPE in VARCHAR2,
258: X_MODE in VARCHAR2 default 'R'
259: ) AS
260: cursor C is select ROWID from IGS_AD_CAT_PS_TYPE
261: where ADMISSION_CAT = X_ADMISSION_CAT
262: and COURSE_TYPE = X_COURSE_TYPE;
263: X_LAST_UPDATE_DATE DATE;
264: X_LAST_UPDATED_BY NUMBER;

Line 298: insert into IGS_AD_CAT_PS_TYPE (

294: x_last_updated_by=>X_LAST_UPDATED_BY,
295: x_last_update_login=>X_LAST_UPDATE_LOGIN
296: );
297:
298: insert into IGS_AD_CAT_PS_TYPE (
299: ADMISSION_CAT,
300: COURSE_TYPE,
301: CREATION_DATE,
302: CREATED_BY,

Line 336: from IGS_AD_CAT_PS_TYPE

332: X_ADMISSION_CAT in VARCHAR2,
333: X_COURSE_TYPE in VARCHAR2
334: ) AS
335: cursor c1 is select ROWID
336: from IGS_AD_CAT_PS_TYPE
337: where ROWID = X_ROWID for update nowait;
338: tlinfo c1%rowtype;
339:
340: begin

Line 364: delete from IGS_AD_CAT_PS_TYPE

360: Before_DML (
361: p_action => 'DELETE',
362: x_rowid => X_ROWID);
363:
364: delete from IGS_AD_CAT_PS_TYPE
365: where ROWID = X_ROWID;
366: if (sql%notfound) then
367: raise no_data_found;
368: end if;

Line 376: end IGS_AD_CAT_PS_TYPE_PKG;

372: x_rowid => X_ROWID);
373:
374: end DELETE_ROW;
375:
376: end IGS_AD_CAT_PS_TYPE_PKG;