APPS.IGS_FI_ENC_DFLT_EFT_PKG dependencies on IGS_FI_ENC_DFLT_EFT

Line 1: package body IGS_FI_ENC_DFLT_EFT_PKG AS

1: package body IGS_FI_ENC_DFLT_EFT_PKG AS
2: /* $Header: IGSSI16B.pls 115.6 2003/10/15 09:38:50 ssaleem ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_FI_ENC_DFLT_EFT%RowType;

Line 5: old_references IGS_FI_ENC_DFLT_EFT%RowType;

1: package body IGS_FI_ENC_DFLT_EFT_PKG AS
2: /* $Header: IGSSI16B.pls 115.6 2003/10/15 09:38:50 ssaleem ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_FI_ENC_DFLT_EFT%RowType;
6: new_references IGS_FI_ENC_DFLT_EFT%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 6: new_references IGS_FI_ENC_DFLT_EFT%RowType;

2: /* $Header: IGSSI16B.pls 115.6 2003/10/15 09:38:50 ssaleem ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_FI_ENC_DFLT_EFT%RowType;
6: new_references IGS_FI_ENC_DFLT_EFT%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,
10: x_encumbrance_type IN VARCHAR2 DEFAULT NULL,

Line 21: FROM IGS_FI_ENC_DFLT_EFT

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

Line 55: -- ON IGS_FI_ENC_DFLT_EFT

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

Line 155: FROM IGS_FI_ENC_DFLT_EFT

151: x_encumbrance_type IN VARCHAR2
152: ) AS
153: CURSOR cur_rowid IS
154: SELECT rowid
155: FROM IGS_FI_ENC_DFLT_EFT
156: WHERE encumbrance_type = x_encumbrance_type ;
157: lv_rowid cur_rowid%RowType;
158: BEGIN
159: Open cur_rowid;

Line 178: FROM IGS_FI_ENC_DFLT_EFT

174: ) Return Boolean
175: AS
176: CURSOR cur_rowid IS
177: SELECT rowid
178: FROM IGS_FI_ENC_DFLT_EFT
179: WHERE encumbrance_type = x_encumbrance_type
180: AND s_encmb_effect_type = x_s_encmb_effect_type
181: FOR UPDATE NOWAIT;
182: lv_rowid cur_rowid%RowType;

Line 265: cursor C is select ROWID from IGS_FI_ENC_DFLT_EFT

261: X_S_ENCMB_EFFECT_TYPE in VARCHAR2,
262: X_COMMENTS in VARCHAR2,
263: X_MODE in VARCHAR2 default 'R'
264: ) AS
265: cursor C is select ROWID from IGS_FI_ENC_DFLT_EFT
266: where ENCUMBRANCE_TYPE = X_ENCUMBRANCE_TYPE
267: and S_ENCMB_EFFECT_TYPE = X_S_ENCMB_EFFECT_TYPE;
268: X_LAST_UPDATE_DATE DATE;
269: X_LAST_UPDATED_BY NUMBER;

Line 302: insert into IGS_FI_ENC_DFLT_EFT (

298: x_last_update_date => X_LAST_UPDATE_DATE,
299: x_last_updated_by => X_LAST_UPDATED_BY,
300: x_last_update_login => X_LAST_UPDATE_LOGIN
301: );
302: insert into IGS_FI_ENC_DFLT_EFT (
303: ENCUMBRANCE_TYPE,
304: S_ENCMB_EFFECT_TYPE,
305: COMMENTS,
306: CREATION_DATE,

Line 337: from IGS_FI_ENC_DFLT_EFT

333: X_COMMENTS in VARCHAR2
334: ) AS
335: cursor c1 is select
336: COMMENTS
337: from IGS_FI_ENC_DFLT_EFT
338: where ROWID = X_ROWID
339: for update nowait;
340: tlinfo c1%rowtype;
341: begin

Line 405: update IGS_FI_ENC_DFLT_EFT set

401: x_last_update_date => X_LAST_UPDATE_DATE,
402: x_last_updated_by => X_LAST_UPDATED_BY,
403: x_last_update_login => X_LAST_UPDATE_LOGIN
404: );
405: update IGS_FI_ENC_DFLT_EFT set
406: COMMENTS = NEW_REFERENCES.COMMENTS,
407: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
408: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
409: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 422: cursor c1 is select rowid from IGS_FI_ENC_DFLT_EFT

418: X_S_ENCMB_EFFECT_TYPE in VARCHAR2,
419: X_COMMENTS in VARCHAR2,
420: X_MODE in VARCHAR2 default 'R'
421: ) AS
422: cursor c1 is select rowid from IGS_FI_ENC_DFLT_EFT
423: where ENCUMBRANCE_TYPE = X_ENCUMBRANCE_TYPE
424: and S_ENCMB_EFFECT_TYPE = X_S_ENCMB_EFFECT_TYPE
425: ;
426: begin

Line 455: delete from IGS_FI_ENC_DFLT_EFT

451: Before_DML(
452: p_action => 'DELETE',
453: x_rowid => X_ROWID
454: );
455: delete from IGS_FI_ENC_DFLT_EFT
456: where ROWID = X_ROWID;
457: if (sql%notfound) then
458: raise no_data_found;
459: end if;

Line 461: end IGS_FI_ENC_DFLT_EFT_PKG;

457: if (sql%notfound) then
458: raise no_data_found;
459: end if;
460: end DELETE_ROW;
461: end IGS_FI_ENC_DFLT_EFT_PKG;