APPS.IGS_RE_THS_PNL_TYPE_PKG dependencies on IGS_RE_THS_PNL_TYPE

Line 1: package body IGS_RE_THS_PNL_TYPE_PKG as

1: package body IGS_RE_THS_PNL_TYPE_PKG as
2: /* $Header: IGSRI24B.pls 115.4 2003/02/19 12:29:40 kpadiyar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RE_THS_PNL_TYPE%RowType;

Line 5: old_references IGS_RE_THS_PNL_TYPE%RowType;

1: package body IGS_RE_THS_PNL_TYPE_PKG as
2: /* $Header: IGSRI24B.pls 115.4 2003/02/19 12:29:40 kpadiyar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RE_THS_PNL_TYPE%RowType;
6: new_references IGS_RE_THS_PNL_TYPE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_RE_THS_PNL_TYPE%RowType;

2: /* $Header: IGSRI24B.pls 115.4 2003/02/19 12:29:40 kpadiyar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RE_THS_PNL_TYPE%RowType;
6: new_references IGS_RE_THS_PNL_TYPE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 26: FROM IGS_RE_THS_PNL_TYPE

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

Line 156: IGS_RE_THESIS_EXAM_PKG.GET_FK_IGS_RE_THS_PNL_TYPE (

152:
153: PROCEDURE Check_Child_Existance AS
154: BEGIN
155:
156: IGS_RE_THESIS_EXAM_PKG.GET_FK_IGS_RE_THS_PNL_TYPE (
157: old_references.thesis_panel_type
158: );
159:
160: END Check_Child_Existance;

Line 168: FROM IGS_RE_THS_PNL_TYPE

164: ) RETURN BOOLEAN AS
165:
166: CURSOR cur_rowid IS
167: SELECT rowid
168: FROM IGS_RE_THS_PNL_TYPE
169: WHERE thesis_panel_type = x_thesis_panel_type
170: FOR UPDATE NOWAIT;
171:
172: lv_rowid cur_rowid%RowType;

Line 269: cursor C is select ROWID from IGS_RE_THS_PNL_TYPE

265: X_TRACKING_TYPE in VARCHAR2,
266: X_SELECTION_CRITERIA in VARCHAR2,
267: X_MODE in VARCHAR2 default 'R'
268: ) as
269: cursor C is select ROWID from IGS_RE_THS_PNL_TYPE
270: where THESIS_PANEL_TYPE = X_THESIS_PANEL_TYPE;
271: X_LAST_UPDATE_DATE DATE;
272: X_LAST_UPDATED_BY NUMBER;
273: X_LAST_UPDATE_LOGIN NUMBER;

Line 310: insert into IGS_RE_THS_PNL_TYPE (

306: x_last_update_date => X_LAST_UPDATE_DATE,
307: x_last_update_login => X_LAST_UPDATE_LOGIN
308: );
309:
310: insert into IGS_RE_THS_PNL_TYPE (
311: THESIS_PANEL_TYPE,
312: DESCRIPTION,
313: CLOSED_IND,
314: RECOMMENDED_PANEL_SIZE,

Line 361: from IGS_RE_THS_PNL_TYPE

357: CLOSED_IND,
358: RECOMMENDED_PANEL_SIZE,
359: TRACKING_TYPE,
360: SELECTION_CRITERIA
361: from IGS_RE_THS_PNL_TYPE
362: where ROWID = X_ROWID
363: for update nowait;
364: tlinfo c1%rowtype;
365:

Line 445: update IGS_RE_THS_PNL_TYPE set

441: x_last_updated_by => X_LAST_UPDATED_BY,
442: x_last_update_date => X_LAST_UPDATE_DATE,
443: x_last_update_login => X_LAST_UPDATE_LOGIN
444: );
445: update IGS_RE_THS_PNL_TYPE set
446: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
447: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
448: RECOMMENDED_PANEL_SIZE = NEW_REFERENCES.RECOMMENDED_PANEL_SIZE,
449: TRACKING_TYPE = NEW_REFERENCES.TRACKING_TYPE,

Line 472: cursor c1 is select rowid from IGS_RE_THS_PNL_TYPE

468: X_TRACKING_TYPE in VARCHAR2,
469: X_SELECTION_CRITERIA in VARCHAR2,
470: X_MODE in VARCHAR2 default 'R'
471: ) as
472: cursor c1 is select rowid from IGS_RE_THS_PNL_TYPE
473: where THESIS_PANEL_TYPE = X_THESIS_PANEL_TYPE
474: ;
475: begin
476: open c1;

Line 513: delete from IGS_RE_THS_PNL_TYPE

509: p_action => 'DELETE',
510: x_rowid => X_ROWID
511: );
512:
513: delete from IGS_RE_THS_PNL_TYPE
514: where ROWID = X_ROWID;
515: if (sql%notfound) then
516: raise no_data_found;
517: end if;

Line 521: end IGS_RE_THS_PNL_TYPE_PKG;

517: end if;
518:
519: end DELETE_ROW;
520:
521: end IGS_RE_THS_PNL_TYPE_PKG;