APPS.IGS_AS_SPCL_CONS_CAT_PKG dependencies on IGS_AS_SPCL_CONS_CAT

Line 1: package body IGS_AS_SPCL_CONS_CAT_PKG as

1: package body IGS_AS_SPCL_CONS_CAT_PKG as
2: /* $Header: IGSDI47B.pls 115.7 2003/05/19 04:44:12 ijeddy ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_SPCL_CONS_CAT%RowType;

Line 5: old_references IGS_AS_SPCL_CONS_CAT%RowType;

1: package body IGS_AS_SPCL_CONS_CAT_PKG as
2: /* $Header: IGSDI47B.pls 115.7 2003/05/19 04:44:12 ijeddy ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_SPCL_CONS_CAT%RowType;
6: new_references IGS_AS_SPCL_CONS_CAT%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AS_SPCL_CONS_CAT%RowType;

2: /* $Header: IGSDI47B.pls 115.7 2003/05/19 04:44:12 ijeddy ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_SPCL_CONS_CAT%RowType;
6: new_references IGS_AS_SPCL_CONS_CAT%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_AS_SPCL_CONS_CAT

20: ) as
21:
22: CURSOR cur_old_ref_values IS
23: SELECT *
24: FROM IGS_AS_SPCL_CONS_CAT
25: WHERE rowid = x_rowid;
26:
27: BEGIN
28:

Line 77: FROM IGS_AS_SPCL_CONS_CAT

73: x_spcl_consideration_cat IN VARCHAR2
74: ) RETURN BOOLEAN AS
75: CURSOR cur_rowid IS
76: SELECT rowid
77: FROM IGS_AS_SPCL_CONS_CAT
78: WHERE spcl_consideration_cat= x_spcl_consideration_cat
79: FOR UPDATE NOWAIT;
80:
81: lv_rowid cur_rowid%RowType;

Line 211: cursor C is select ROWID from IGS_AS_SPCL_CONS_CAT

207: X_EXPLANATION in VARCHAR2,
208: X_CLOSED_IND in VARCHAR2,
209: X_MODE in VARCHAR2 default 'R'
210: ) as
211: cursor C is select ROWID from IGS_AS_SPCL_CONS_CAT
212: where SPCL_CONSIDERATION_CAT = X_SPCL_CONSIDERATION_CAT;
213: X_LAST_UPDATE_DATE DATE;
214: X_LAST_UPDATED_BY NUMBER;
215: X_LAST_UPDATE_LOGIN NUMBER;

Line 249: insert into IGS_AS_SPCL_CONS_CAT (

245: x_last_updated_by=>X_LAST_UPDATED_BY,
246: x_last_update_login=>X_LAST_UPDATE_LOGIN
247: );
248:
249: insert into IGS_AS_SPCL_CONS_CAT (
250: SPCL_CONSIDERATION_CAT,
251: DESCRIPTION,
252: EXPLANATION,
253: CLOSED_IND,

Line 291: from IGS_AS_SPCL_CONS_CAT

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

Line 364: update IGS_AS_SPCL_CONS_CAT set

360: x_last_updated_by=>X_LAST_UPDATED_BY,
361: x_last_update_login=>X_LAST_UPDATE_LOGIN
362: );
363:
364: update IGS_AS_SPCL_CONS_CAT set
365: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
366: EXPLANATION = NEW_REFERENCES.EXPLANATION,
367: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
368: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 387: cursor c1 is select rowid from IGS_AS_SPCL_CONS_CAT

383: X_EXPLANATION in VARCHAR2,
384: X_CLOSED_IND in VARCHAR2,
385: X_MODE in VARCHAR2 default 'R'
386: ) as
387: cursor c1 is select rowid from IGS_AS_SPCL_CONS_CAT
388: where SPCL_CONSIDERATION_CAT = X_SPCL_CONSIDERATION_CAT
389: ;
390: begin
391: open c1;

Line 421: delete from IGS_AS_SPCL_CONS_CAT

417: Before_DML(
418: p_action => 'DELETE',
419: x_rowid => X_ROWID
420: );
421: delete from IGS_AS_SPCL_CONS_CAT
422: where ROWID = X_ROWID;
423: if (sql%notfound) then
424: raise no_data_found;
425: end if;

Line 428: end IGS_AS_SPCL_CONS_CAT_PKG;

424: raise no_data_found;
425: end if;
426: end DELETE_ROW;
427:
428: end IGS_AS_SPCL_CONS_CAT_PKG;