eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_FEE_CAT_MAP_PKG dependencies on IGS_FI_FEE_CAT_MAP

Line 1: package body IGS_FI_FEE_CAT_MAP_PKG AS

1: package body IGS_FI_FEE_CAT_MAP_PKG AS
2: /* $Header: IGSSI25B.pls 115.6 2003/10/30 13:31:57 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FEE_CAT_MAP%RowType;
5: new_references IGS_FI_FEE_CAT_MAP%RowType;

Line 4: old_references IGS_FI_FEE_CAT_MAP%RowType;

1: package body IGS_FI_FEE_CAT_MAP_PKG AS
2: /* $Header: IGSSI25B.pls 115.6 2003/10/30 13:31:57 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FEE_CAT_MAP%RowType;
5: new_references IGS_FI_FEE_CAT_MAP%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 5: new_references IGS_FI_FEE_CAT_MAP%RowType;

1: package body IGS_FI_FEE_CAT_MAP_PKG AS
2: /* $Header: IGSSI25B.pls 115.6 2003/10/30 13:31:57 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FEE_CAT_MAP%RowType;
5: new_references IGS_FI_FEE_CAT_MAP%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_fee_cat IN VARCHAR2 DEFAULT NULL,

Line 20: FROM IGS_FI_FEE_CAT_MAP

16: x_last_update_login IN NUMBER DEFAULT NULL
17: ) AS
18: CURSOR cur_old_ref_values IS
19: SELECT *
20: FROM IGS_FI_FEE_CAT_MAP
21: WHERE rowid = x_rowid;
22: BEGIN
23: l_rowid := x_rowid;
24: -- Code for setting the Old and New Reference Values.

Line 54: -- ON IGS_FI_FEE_CAT_MAP

50: END Set_Column_Values;
51: -- Trigger description :-
52: -- "OSS_TST".trg_fcm_br_iud
53: -- BEFORE INSERT OR DELETE OR UPDATE
54: -- ON IGS_FI_FEE_CAT_MAP
55: -- FOR EACH ROW
56: PROCEDURE BeforeRowInsertUpdateDelete1(
57: p_inserting IN BOOLEAN DEFAULT FALSE,
58: p_updating IN BOOLEAN DEFAULT FALSE,

Line 61: v_admission_cat IGS_FI_FEE_CAT_MAP.admission_cat%TYPE;

57: p_inserting IN BOOLEAN DEFAULT FALSE,
58: p_updating IN BOOLEAN DEFAULT FALSE,
59: p_deleting IN BOOLEAN DEFAULT FALSE
60: ) AS
61: v_admission_cat IGS_FI_FEE_CAT_MAP.admission_cat%TYPE;
62: v_message_name varchar2(30);
63: BEGIN
64: IF p_inserting THEN
65: -- Validate the fee category closed indicator.

Line 159: FROM IGS_FI_FEE_CAT_MAP

155: x_admission_cat IN VARCHAR2
156: ) RETURN BOOLEAN AS
157: CURSOR cur_rowid IS
158: SELECT rowid
159: FROM IGS_FI_FEE_CAT_MAP
160: WHERE fee_cat = x_fee_cat
161: AND admission_cat = x_admission_cat
162: FOR UPDATE NOWAIT;
163: lv_rowid cur_rowid%RowType;

Line 181: FROM IGS_FI_FEE_CAT_MAP

177: x_admission_cat IN VARCHAR2
178: ) AS
179: CURSOR cur_rowid IS
180: SELECT rowid
181: FROM IGS_FI_FEE_CAT_MAP
182: WHERE admission_cat = x_admission_cat ;
183: lv_rowid cur_rowid%RowType;
184: BEGIN
185: Open cur_rowid;

Line 201: FROM IGS_FI_FEE_CAT_MAP

197: x_fee_cat IN VARCHAR2
198: ) AS
199: CURSOR cur_rowid IS
200: SELECT rowid
201: FROM IGS_FI_FEE_CAT_MAP
202: WHERE fee_cat = x_fee_cat ;
203: lv_rowid cur_rowid%RowType;
204: BEGIN
205: Open cur_rowid;

Line 282: cursor C is select ROWID from IGS_FI_FEE_CAT_MAP

278: X_ADMISSION_CAT in VARCHAR2,
279: X_DFLT_CAT_IND in VARCHAR2,
280: X_MODE in VARCHAR2 default 'R'
281: ) AS
282: cursor C is select ROWID from IGS_FI_FEE_CAT_MAP
283: where FEE_CAT = X_FEE_CAT
284: and ADMISSION_CAT = X_ADMISSION_CAT;
285: X_LAST_UPDATE_DATE DATE;
286: X_LAST_UPDATED_BY NUMBER;

Line 319: insert into IGS_FI_FEE_CAT_MAP (

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_FI_FEE_CAT_MAP (
320: FEE_CAT,
321: ADMISSION_CAT,
322: DFLT_CAT_IND,
323: CREATION_DATE,

Line 354: from IGS_FI_FEE_CAT_MAP

350: X_DFLT_CAT_IND in VARCHAR2
351: ) AS
352: cursor c1 is select
353: DFLT_CAT_IND
354: from IGS_FI_FEE_CAT_MAP
355: where ROWID = X_ROWID
356: for update nowait;
357: tlinfo c1%rowtype;
358: begin

Line 420: update IGS_FI_FEE_CAT_MAP set

416: x_last_update_date=>X_LAST_UPDATE_DATE,
417: x_last_updated_by=>X_LAST_UPDATED_BY,
418: x_last_update_login=>X_LAST_UPDATE_LOGIN
419: );
420: update IGS_FI_FEE_CAT_MAP set
421: DFLT_CAT_IND = NEW_REFERENCES.DFLT_CAT_IND,
422: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
423: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
424: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 437: cursor c1 is select rowid from IGS_FI_FEE_CAT_MAP

433: X_ADMISSION_CAT in VARCHAR2,
434: X_DFLT_CAT_IND in VARCHAR2,
435: X_MODE in VARCHAR2 default 'R'
436: ) AS
437: cursor c1 is select rowid from IGS_FI_FEE_CAT_MAP
438: where FEE_CAT = X_FEE_CAT
439: and ADMISSION_CAT = X_ADMISSION_CAT
440: ;
441: begin

Line 470: delete from IGS_FI_FEE_CAT_MAP

466: Before_DML (
467: p_action => 'DELETE',
468: x_rowid => X_ROWID
469: );
470: delete from IGS_FI_FEE_CAT_MAP
471: where ROWID = X_ROWID;
472: if (sql%notfound) then
473: raise no_data_found;
474: end if;

Line 476: end IGS_FI_FEE_CAT_MAP_PKG;

472: if (sql%notfound) then
473: raise no_data_found;
474: end if;
475: end DELETE_ROW;
476: end IGS_FI_FEE_CAT_MAP_PKG;