APPS.IGS_FI_FEE_CAT_PKG dependencies on IGS_FI_FEE_CAT_ALL

Line 4: old_references IGS_FI_FEE_CAT_ALL%RowType;

1: PACKAGE BODY igs_fi_fee_cat_pkg AS
2: /* $Header: IGSSI23B.pls 115.19 2003/12/05 05:45:48 ckasu ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FEE_CAT_ALL%RowType;
5: new_references IGS_FI_FEE_CAT_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_FI_FEE_CAT_ALL%RowType;

1: PACKAGE BODY igs_fi_fee_cat_pkg AS
2: /* $Header: IGSSI23B.pls 115.19 2003/12/05 05:45:48 ckasu ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FEE_CAT_ALL%RowType;
5: new_references IGS_FI_FEE_CAT_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 23: FROM IGS_FI_FEE_CAT_ALL

19: x_last_update_login IN NUMBER
20: ) AS
21: CURSOR cur_old_ref_values IS
22: SELECT *
23: FROM IGS_FI_FEE_CAT_ALL
24: WHERE rowid = x_rowid;
25: BEGIN
26: l_rowid := x_rowid;
27: -- Code for setting the Old and New Reference Values.

Line 59: -- ON IGS_FI_FEE_CAT_ALL

55: END Set_Column_Values;
56: -- Trigger description :-
57: -- "OSS_TST".trg_fc_br_iud
58: -- BEFORE INSERT OR DELETE OR UPDATE
59: -- ON IGS_FI_FEE_CAT_ALL
60: -- FOR EACH ROW
61: PROCEDURE BeforeRowInsertUpdateDelete1(
62: p_inserting IN BOOLEAN ,
63: p_updating IN BOOLEAN ,

Line 170: FROM IGS_FI_FEE_CAT_ALL

166: ) RETURN BOOLEAN AS
167: -- Bug# 2729919, removed 'FOR UPDATE NOWAIT' clause is removed from the cursor.
168: CURSOR cur_rowid IS
169: SELECT rowid
170: FROM IGS_FI_FEE_CAT_ALL
171: WHERE fee_cat = x_fee_cat;
172: lv_rowid cur_rowid%RowType;
173: BEGIN
174: Open cur_rowid;

Line 279: cursor C is select ROWID from IGS_FI_FEE_CAT_ALL

275: X_CLOSED_IND in VARCHAR2,
276: X_ORG_ID in NUMBER ,
277: X_MODE in VARCHAR2
278: ) AS
279: cursor C is select ROWID from IGS_FI_FEE_CAT_ALL
280: where FEE_CAT = X_FEE_CAT;
281: X_LAST_UPDATE_DATE DATE;
282: X_LAST_UPDATED_BY NUMBER;
283: X_LAST_UPDATE_LOGIN NUMBER;

Line 317: insert into IGS_FI_FEE_CAT_ALL (

313: x_last_update_date=>X_LAST_UPDATE_DATE,
314: x_last_updated_by=>X_LAST_UPDATED_BY,
315: x_last_update_login=>X_LAST_UPDATE_LOGIN
316: );
317: insert into IGS_FI_FEE_CAT_ALL (
318: FEE_CAT,
319: DESCRIPTION,
320: CURRENCY_CD,
321: CLOSED_IND,

Line 359: from IGS_FI_FEE_CAT_ALL

355: cursor c1 is select
356: DESCRIPTION,
357: CURRENCY_CD,
358: CLOSED_IND
359: from IGS_FI_FEE_CAT_ALL
360: where ROWID = X_ROWID
361: for update nowait;
362: tlinfo c1%rowtype;
363: begin

Line 432: update IGS_FI_FEE_CAT_ALL set

428: x_last_update_date=>X_LAST_UPDATE_DATE,
429: x_last_updated_by=>X_LAST_UPDATED_BY,
430: x_last_update_login=>X_LAST_UPDATE_LOGIN
431: );
432: update IGS_FI_FEE_CAT_ALL set
433: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
434: CURRENCY_CD = NEW_REFERENCES.CURRENCY_CD,
435: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
436: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 454: cursor c1 is select rowid from IGS_FI_FEE_CAT_ALL

450: X_ORG_ID in NUMBER ,
451: X_MODE in VARCHAR2
452:
453: ) AS
454: cursor c1 is select rowid from IGS_FI_FEE_CAT_ALL
455: where FEE_CAT = X_FEE_CAT
456: ;
457: begin
458: open c1;

Line 491: delete from IGS_FI_FEE_CAT_ALL

487: BEfore_DML (
488: p_action => 'DELETE',
489: x_rowid => X_ROWID
490: );
491: delete from IGS_FI_FEE_CAT_ALL
492: where ROWID = X_ROWID;
493: if (sql%notfound) then
494: raise no_data_found;
495: end if;