APPS.IGS_CA_DA_PAIR_PKG dependencies on IGS_CA_DA_PAIR

Line 1: package body IGS_CA_DA_PAIR_PKG AS

1: package body IGS_CA_DA_PAIR_PKG AS
2: /* $Header: IGSCI10B.pls 115.4 2002/11/28 23:01:56 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_PAIR%RowType;
5: new_references IGS_CA_DA_PAIR%RowType;

Line 4: old_references IGS_CA_DA_PAIR%RowType;

1: package body IGS_CA_DA_PAIR_PKG AS
2: /* $Header: IGSCI10B.pls 115.4 2002/11/28 23:01:56 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_PAIR%RowType;
5: new_references IGS_CA_DA_PAIR%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_CA_DA_PAIR%RowType;

1: package body IGS_CA_DA_PAIR_PKG AS
2: /* $Header: IGSCI10B.pls 115.4 2002/11/28 23:01:56 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_PAIR%RowType;
5: new_references IGS_CA_DA_PAIR%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 21: FROM IGS_CA_DA_PAIR

17: ) AS
18:
19: CURSOR cur_old_ref_values IS
20: SELECT *
21: FROM IGS_CA_DA_PAIR
22: WHERE rowid = x_rowid;
23:
24: BEGIN
25:

Line 60: -- ON IGS_CA_DA_PAIR

56:
57: -- Trigger description :-
58: -- "OSS_TST".trg_dap_br_i
59: -- BEFORE INSERT
60: -- ON IGS_CA_DA_PAIR
61: -- FOR EACH ROW
62:
63: PROCEDURE BeforeRowInsert1(
64: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 161: FROM IGS_CA_DA_PAIR

157: ) RETURN BOOLEAN AS
158:
159: CURSOR cur_rowid IS
160: SELECT rowid
161: FROM IGS_CA_DA_PAIR
162: WHERE dt_alias = x_dt_alias
163: AND related_dt_alias = x_related_dt_alias
164: FOR UPDATE NOWAIT;
165:

Line 188: FROM IGS_CA_DA_PAIR

184: ) AS
185:
186: CURSOR cur_rowid IS
187: SELECT rowid
188: FROM IGS_CA_DA_PAIR
189: WHERE dt_alias = x_dt_alias
190: OR related_dt_alias = x_dt_alias;
191:
192: lv_rowid cur_rowid%RowType;

Line 283: cursor C is select ROWID from IGS_CA_DA_PAIR

279: X_DT_ALIAS in VARCHAR2,
280: X_RELATED_DT_ALIAS in VARCHAR2,
281: X_MODE in VARCHAR2 default 'R'
282: ) AS
283: cursor C is select ROWID from IGS_CA_DA_PAIR
284: where DT_ALIAS = X_DT_ALIAS
285: and RELATED_DT_ALIAS = X_RELATED_DT_ALIAS;
286: X_LAST_UPDATE_DATE DATE;
287: X_LAST_UPDATED_BY NUMBER;

Line 319: insert into IGS_CA_DA_PAIR (

315: x_last_update_date =>X_LAST_UPDATE_DATE,
316: x_last_updated_by =>X_LAST_UPDATED_BY,
317: x_last_update_login =>X_LAST_UPDATE_LOGIN
318: );
319: insert into IGS_CA_DA_PAIR (
320: DT_ALIAS,
321: RELATED_DT_ALIAS,
322: CREATION_DATE,
323: CREATED_BY,

Line 352: from IGS_CA_DA_PAIR

348: X_DT_ALIAS in VARCHAR2,
349: X_RELATED_DT_ALIAS in VARCHAR2
350: ) AS
351: cursor c1 is select ROWID
352: from IGS_CA_DA_PAIR
353: where ROWID = X_ROWID
354: for update nowait;
355: tlinfo c1%rowtype;
356:

Line 379: delete from IGS_CA_DA_PAIR

375: Before_DML (
376: p_action =>'DELETE',
377: x_rowid =>X_ROWID
378: );
379: delete from IGS_CA_DA_PAIR
380: where ROWID = X_ROWID;
381: if (sql%notfound) then
382: raise no_data_found;
383: end if;

Line 386: end IGS_CA_DA_PAIR_PKG;

382: raise no_data_found;
383: end if;
384: end DELETE_ROW;
385:
386: end IGS_CA_DA_PAIR_PKG;