APPS.IGS_GE_S_DSB_TAB_TRG_PKG dependencies on IGS_GE_S_DSB_TAB_TRG

Line 1: package body IGS_GE_S_DSB_TAB_TRG_PKG as

1: package body IGS_GE_S_DSB_TAB_TRG_PKG as
2: /* $Header: IGSMI13B.pls 115.3 2002/11/29 01:12:22 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_GE_S_DSB_TAB_TRG%RowType;

Line 5: old_references IGS_GE_S_DSB_TAB_TRG%RowType;

1: package body IGS_GE_S_DSB_TAB_TRG_PKG as
2: /* $Header: IGSMI13B.pls 115.3 2002/11/29 01:12:22 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_GE_S_DSB_TAB_TRG%RowType;
6: new_references IGS_GE_S_DSB_TAB_TRG%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_GE_S_DSB_TAB_TRG%RowType;

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

Line 22: FROM IGS_GE_S_DSB_TAB_TRG

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

Line 84: FROM IGS_GE_S_DSB_TAB_TRG

80: ) RETURN BOOLEAN as
81:
82: CURSOR cur_rowid IS
83: SELECT rowid
84: FROM IGS_GE_S_DSB_TAB_TRG
85: WHERE table_name = x_table_name
86: AND session_id = x_session_id
87: FOR UPDATE NOWAIT;
88:

Line 199: cursor C is select ROWID from IGS_GE_S_DSB_TAB_TRG

195: X_MODE in VARCHAR2 default 'R'
196: ) as
197: gv_other_detail varchar2(255);
198:
199: cursor C is select ROWID from IGS_GE_S_DSB_TAB_TRG
200: where TABLE_NAME = X_TABLE_NAME
201: and SESSION_ID = X_SESSION_ID;
202: X_LAST_UPDATE_DATE DATE;
203: X_LAST_UPDATED_BY NUMBER;

Line 236: insert into IGS_GE_S_DSB_TAB_TRG (

232: x_last_updated_by => X_LAST_UPDATED_BY,
233: x_last_update_login => X_LAST_UPDATE_LOGIN
234: );
235:
236: insert into IGS_GE_S_DSB_TAB_TRG (
237: TABLE_NAME,
238: SESSION_ID,
239: CREATION_DATE,
240: CREATED_BY,

Line 279: from IGS_GE_S_DSB_TAB_TRG

275: X_TABLE_NAME in VARCHAR2,
276: X_SESSION_ID in NUMBER
277: ) as
278: cursor c1 is select *
279: from IGS_GE_S_DSB_TAB_TRG
280: for update of TABLE_NAME nowait;
281: tlinfo c1%rowtype;
282:
283: begin

Line 306: delete from IGS_GE_S_DSB_TAB_TRG

302: p_action => 'DELETE',
303: x_rowid => X_ROWID
304: );
305:
306: delete from IGS_GE_S_DSB_TAB_TRG
307: where ROWID = X_ROWID ;
308: if (sql%notfound) then
309: raise no_data_found;
310: end if;

Line 319: end IGS_GE_S_DSB_TAB_TRG_PKG;

315: );
316:
317: end DELETE_ROW;
318:
319: end IGS_GE_S_DSB_TAB_TRG_PKG;