APPS.IGS_PS_GRP_TYPE_PKG dependencies on IGS_PS_GRP_TYPE

Line 1: package body IGS_PS_GRP_TYPE_PKG AS

1: package body IGS_PS_GRP_TYPE_PKG AS
2: /* $Header: IGSPI18B.pls 115.3 2002/11/29 02:03:59 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_GRP_TYPE%RowType;

Line 5: old_references IGS_PS_GRP_TYPE%RowType;

1: package body IGS_PS_GRP_TYPE_PKG AS
2: /* $Header: IGSPI18B.pls 115.3 2002/11/29 02:03:59 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_GRP_TYPE%RowType;
6: new_references IGS_PS_GRP_TYPE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_GRP_TYPE%RowType;

2: /* $Header: IGSPI18B.pls 115.3 2002/11/29 02:03:59 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_GRP_TYPE%RowType;
6: new_references IGS_PS_GRP_TYPE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_PS_GRP_TYPE

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

Line 65: -- ON IGS_PS_GRP_TYPE

61:
62: -- Trigger description :-
63: -- "OSS_TST".trg_cgt_br_iu
64: -- BEFORE INSERT OR UPDATE
65: -- ON IGS_PS_GRP_TYPE
66: -- FOR EACH ROW
67:
68: PROCEDURE BeforeRowInsertUpdate1(
69: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 159: IGS_PS_GRP_PKG.GET_FK_IGS_PS_GRP_TYPE (

155:
156: PROCEDURE Check_Child_Existance AS
157: BEGIN
158:
159: IGS_PS_GRP_PKG.GET_FK_IGS_PS_GRP_TYPE (
160: old_references.course_group_type
161: );
162:
163: END Check_Child_Existance;

Line 172: FROM IGS_PS_GRP_TYPE

168: RETURN BOOLEAN AS
169:
170: CURSOR cur_rowid IS
171: SELECT rowid
172: FROM IGS_PS_GRP_TYPE
173: WHERE course_group_type = x_course_group_type
174: FOR UPDATE NOWAIT;
175:
176: lv_rowid cur_rowid%RowType;

Line 198: FROM IGS_PS_GRP_TYPE

194: ) AS
195:
196: CURSOR cur_rowid IS
197: SELECT rowid
198: FROM IGS_PS_GRP_TYPE
199: WHERE s_course_group_type = x_s_course_group_type ;
200:
201: lv_rowid cur_rowid%RowType;
202:

Line 302: cursor C is select ROWID from IGS_PS_GRP_TYPE

298: X_S_COURSE_GROUP_TYPE in VARCHAR2,
299: X_CLOSED_IND in VARCHAR2,
300: X_MODE in VARCHAR2 default 'R'
301: ) AS
302: cursor C is select ROWID from IGS_PS_GRP_TYPE
303: where COURSE_GROUP_TYPE = X_COURSE_GROUP_TYPE;
304: X_LAST_UPDATE_DATE DATE;
305: X_LAST_UPDATED_BY NUMBER;
306: X_LAST_UPDATE_LOGIN NUMBER;

Line 340: insert into IGS_PS_GRP_TYPE (

336: x_last_updated_by => X_LAST_UPDATED_BY ,
337: x_last_update_login => X_LAST_UPDATE_LOGIN
338: );
339:
340: insert into IGS_PS_GRP_TYPE (
341: COURSE_GROUP_TYPE,
342: DESCRIPTION,
343: S_COURSE_GROUP_TYPE,
344: CLOSED_IND,

Line 386: from IGS_PS_GRP_TYPE

382: cursor c1 is select
383: DESCRIPTION,
384: S_COURSE_GROUP_TYPE,
385: CLOSED_IND
386: from IGS_PS_GRP_TYPE
387: where ROWID = X_ROWID
388: for update nowait;
389: tlinfo c1%rowtype;
390:

Line 460: update IGS_PS_GRP_TYPE set

456: x_last_updated_by => X_LAST_UPDATED_BY ,
457: x_last_update_login => X_LAST_UPDATE_LOGIN
458: );
459:
460: update IGS_PS_GRP_TYPE set
461: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
462: S_COURSE_GROUP_TYPE = NEW_REFERENCES.S_COURSE_GROUP_TYPE,
463: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
464: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 486: cursor c1 is select rowid from IGS_PS_GRP_TYPE

482: X_S_COURSE_GROUP_TYPE in VARCHAR2,
483: X_CLOSED_IND in VARCHAR2,
484: X_MODE in VARCHAR2 default 'R'
485: ) AS
486: cursor c1 is select rowid from IGS_PS_GRP_TYPE
487: where COURSE_GROUP_TYPE = X_COURSE_GROUP_TYPE
488: ;
489: begin
490: open c1;

Line 521: delete from IGS_PS_GRP_TYPE

517: Before_DML (
518: p_action => 'DELETE',
519: x_rowid => X_ROWID
520: );
521: delete from IGS_PS_GRP_TYPE
522: where ROWID = X_ROWID;
523: if (sql%notfound) then
524: raise no_data_found;
525: end if;

Line 532: end IGS_PS_GRP_TYPE_PKG;

528: x_rowid => X_ROWID
529: );
530: end DELETE_ROW;
531:
532: end IGS_PS_GRP_TYPE_PKG;