APPS.IGS_RE_THS_PNL_MR_TP_PKG dependencies on IGS_RE_THS_PNL_MR_TP_ALL

Line 5: old_references IGS_RE_THS_PNL_MR_TP_ALL%RowType;

1: package body IGS_RE_THS_PNL_MR_TP_PKG as
2: /* $Header: IGSRI23B.pls 115.6 2003/02/19 12:27:23 kpadiyar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RE_THS_PNL_MR_TP_ALL%RowType;
6: new_references IGS_RE_THS_PNL_MR_TP_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_RE_THS_PNL_MR_TP_ALL%RowType;

2: /* $Header: IGSRI23B.pls 115.6 2003/02/19 12:27:23 kpadiyar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RE_THS_PNL_MR_TP_ALL%RowType;
6: new_references IGS_RE_THS_PNL_MR_TP_ALL%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_MR_TP_ALL

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

Line 167: FROM IGS_RE_THS_PNL_MR_TP_ALL

163: ) RETURN BOOLEAN AS
164:
165: CURSOR cur_rowid IS
166: SELECT rowid
167: FROM IGS_RE_THS_PNL_MR_TP_ALL
168: WHERE panel_member_type = x_panel_member_type
169: FOR UPDATE NOWAIT;
170:
171: lv_rowid cur_rowid%RowType;

Line 266: cursor C is select ROWID from IGS_RE_THS_PNL_MR_TP_ALL

262: X_TRACKING_TYPE in VARCHAR2,
263: X_MODE in VARCHAR2 default 'R',
264: x_org_id IN NUMBER
265: ) as
266: cursor C is select ROWID from IGS_RE_THS_PNL_MR_TP_ALL
267: where PANEL_MEMBER_TYPE = X_PANEL_MEMBER_TYPE;
268: X_LAST_UPDATE_DATE DATE;
269: X_LAST_UPDATED_BY NUMBER;
270: X_LAST_UPDATE_LOGIN NUMBER;

Line 307: insert into IGS_RE_THS_PNL_MR_TP_ALL (

303: x_last_update_login => X_LAST_UPDATE_LOGIN,
304: x_org_id => igs_ge_gen_003.get_org_id
305: );
306:
307: insert into IGS_RE_THS_PNL_MR_TP_ALL (
308: PANEL_MEMBER_TYPE,
309: DESCRIPTION,
310: PANEL_CHAIR_IND,
311: CLOSED_IND,

Line 356: from IGS_RE_THS_PNL_MR_TP_ALL

352: DESCRIPTION,
353: PANEL_CHAIR_IND,
354: CLOSED_IND,
355: TRACKING_TYPE
356: from IGS_RE_THS_PNL_MR_TP_ALL
357: where ROWID = X_ROWID
358: for update nowait;
359: tlinfo c1%rowtype;
360:

Line 433: update IGS_RE_THS_PNL_MR_TP_ALL set

429: x_last_updated_by => X_LAST_UPDATED_BY,
430: x_last_update_date => X_LAST_UPDATE_DATE,
431: x_last_update_login => X_LAST_UPDATE_LOGIN
432: );
433: update IGS_RE_THS_PNL_MR_TP_ALL set
434: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
435: PANEL_CHAIR_IND = NEW_REFERENCES.PANEL_CHAIR_IND,
436: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
437: TRACKING_TYPE = NEW_REFERENCES.TRACKING_TYPE,

Line 459: cursor c1 is select rowid from IGS_RE_THS_PNL_MR_TP_ALL

455: X_TRACKING_TYPE in VARCHAR2,
456: X_MODE in VARCHAR2 default 'R',
457: X_ORG_ID in NUMBER
458: ) as
459: cursor c1 is select rowid from IGS_RE_THS_PNL_MR_TP_ALL
460: where PANEL_MEMBER_TYPE = X_PANEL_MEMBER_TYPE
461: ;
462: begin
463: open c1;

Line 499: delete from IGS_RE_THS_PNL_MR_TP_ALL

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