APPS.IGS_PS_TYPE_GRP_PKG dependencies on IGS_PS_TYPE_GRP

Line 1: package body IGS_PS_TYPE_GRP_PKG AS

1: package body IGS_PS_TYPE_GRP_PKG AS
2: /* $Header: IGSPI38B.pls 115.3 2002/11/29 02:23:43 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_TYPE_GRP%RowType;

Line 5: old_references IGS_PS_TYPE_GRP%RowType;

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

Line 6: new_references IGS_PS_TYPE_GRP%RowType;

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

Line 23: FROM IGS_PS_TYPE_GRP

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

Line 99: IGS_PS_TYPE_PKG.GET_FK_IGS_PS_TYPE_GRP (

95:
96: PROCEDURE Check_Child_Existance AS
97: BEGIN
98:
99: IGS_PS_TYPE_PKG.GET_FK_IGS_PS_TYPE_GRP (
100: old_references.course_type_group_cd
101: );
102:
103: IGS_AD_SBMAO_FN_CTTT_PKG.GET_FK_IGS_PS_TYPE_GRP (

Line 103: IGS_AD_SBMAO_FN_CTTT_PKG.GET_FK_IGS_PS_TYPE_GRP (

99: IGS_PS_TYPE_PKG.GET_FK_IGS_PS_TYPE_GRP (
100: old_references.course_type_group_cd
101: );
102:
103: IGS_AD_SBMAO_FN_CTTT_PKG.GET_FK_IGS_PS_TYPE_GRP (
104: old_references.course_type_group_cd
105: );
106:
107: END Check_Child_Existance;

Line 115: FROM IGS_PS_TYPE_GRP

111: ) RETURN BOOLEAN AS
112:
113: CURSOR cur_rowid IS
114: SELECT rowid
115: FROM IGS_PS_TYPE_GRP
116: WHERE course_type_group_cd = x_course_type_group_cd
117: FOR UPDATE NOWAIT;
118:
119: lv_rowid cur_rowid%RowType;

Line 213: cursor C is select ROWID from IGS_PS_TYPE_GRP

209: X_DESCRIPTION in VARCHAR2,
210: X_CLOSED_IND in VARCHAR2,
211: X_MODE in VARCHAR2 default 'R'
212: ) AS
213: cursor C is select ROWID from IGS_PS_TYPE_GRP
214: where COURSE_TYPE_GROUP_CD = X_COURSE_TYPE_GROUP_CD;
215: X_LAST_UPDATE_DATE DATE;
216: X_LAST_UPDATED_BY NUMBER;
217: X_LAST_UPDATE_LOGIN NUMBER;

Line 248: insert into IGS_PS_TYPE_GRP (

244: x_last_update_date => X_LAST_UPDATE_DATE,
245: x_last_updated_by => X_LAST_UPDATED_BY,
246: x_last_update_login => X_LAST_UPDATE_LOGIN
247: );
248: insert into IGS_PS_TYPE_GRP (
249: COURSE_TYPE_GROUP_CD,
250: DESCRIPTION,
251: CLOSED_IND,
252: CREATION_DATE,

Line 290: from IGS_PS_TYPE_GRP

286: ) AS
287: cursor c1 is select
288: DESCRIPTION,
289: CLOSED_IND
290: from IGS_PS_TYPE_GRP
291: where ROWID = X_ROWID for update nowait;
292: tlinfo c1%rowtype;
293:
294: begin

Line 357: update IGS_PS_TYPE_GRP set

353: x_last_update_date => X_LAST_UPDATE_DATE,
354: x_last_updated_by => X_LAST_UPDATED_BY,
355: x_last_update_login => X_LAST_UPDATE_LOGIN
356: );
357: update IGS_PS_TYPE_GRP set
358: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
359: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
360: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
361: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 381: cursor c1 is select rowid from IGS_PS_TYPE_GRP

377: X_DESCRIPTION in VARCHAR2,
378: X_CLOSED_IND in VARCHAR2,
379: X_MODE in VARCHAR2 default 'R'
380: ) AS
381: cursor c1 is select rowid from IGS_PS_TYPE_GRP
382: where COURSE_TYPE_GROUP_CD = X_COURSE_TYPE_GROUP_CD
383: ;
384: begin
385: open c1;

Line 413: delete from IGS_PS_TYPE_GRP

409: begin
410: Before_DML( p_action => 'DELETE',
411: x_rowid => X_ROWID
412: );
413: delete from IGS_PS_TYPE_GRP
414: where ROWID = X_ROWID;
415: if (sql%notfound) then
416: raise no_data_found;
417: end if;

Line 424: end IGS_PS_TYPE_GRP_PKG;

420: x_rowid => X_ROWID
421: );
422: end DELETE_ROW;
423:
424: end IGS_PS_TYPE_GRP_PKG;