APPS.IGS_FI_ENCMB_TYPE_PKG dependencies on IGS_FI_ENCMB_TYPE_ALL

Line 9: old_references IGS_FI_ENCMB_TYPE_ALL%RowType;

5: /*****************************
6: Removed call to IGS_FI_FEE_ENCMB_PKG.GET_FK_IGS_FI_ENCMB_TYPE as table IGS_FI_FEE_ENCMB is obseleted as part of bug 2126091 -sykrishn -30112001
7: ****************************/
8: l_rowid VARCHAR2(25);
9: old_references IGS_FI_ENCMB_TYPE_ALL%RowType;
10: new_references IGS_FI_ENCMB_TYPE_ALL%RowType;
11: PROCEDURE Set_Column_Values (
12: p_action IN VARCHAR2,
13: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 10: new_references IGS_FI_ENCMB_TYPE_ALL%RowType;

6: Removed call to IGS_FI_FEE_ENCMB_PKG.GET_FK_IGS_FI_ENCMB_TYPE as table IGS_FI_FEE_ENCMB is obseleted as part of bug 2126091 -sykrishn -30112001
7: ****************************/
8: l_rowid VARCHAR2(25);
9: old_references IGS_FI_ENCMB_TYPE_ALL%RowType;
10: new_references IGS_FI_ENCMB_TYPE_ALL%RowType;
11: PROCEDURE Set_Column_Values (
12: p_action IN VARCHAR2,
13: x_rowid IN VARCHAR2 DEFAULT NULL,
14: x_encumbrance_type IN VARCHAR2 DEFAULT NULL,

Line 28: FROM IGS_FI_ENCMB_TYPE_ALL

24: x_last_update_login IN NUMBER DEFAULT NULL
25: ) AS
26: CURSOR cur_old_ref_values IS
27: SELECT *
28: FROM IGS_FI_ENCMB_TYPE_ALL
29: WHERE rowid = x_rowid;
30: BEGIN
31: l_rowid := x_rowid;
32: -- Code for setting the Old and New Reference Values.

Line 132: FROM IGS_FI_ENCMB_TYPE_ALL

128: ) Return Boolean
129: AS
130: CURSOR cur_rowid IS
131: SELECT rowid
132: FROM IGS_FI_ENCMB_TYPE_ALL
133: WHERE encumbrance_type = x_encumbrance_type;
134:
135: lv_rowid cur_rowid%RowType;
136: BEGIN

Line 218: cursor C is select ROWID from IGS_FI_ENCMB_TYPE_ALL

214: X_COMMENTS in VARCHAR2,
215: x_org_id in number,
216: X_MODE in VARCHAR2 default 'R'
217: ) AS
218: cursor C is select ROWID from IGS_FI_ENCMB_TYPE_ALL
219: where ENCUMBRANCE_TYPE = X_ENCUMBRANCE_TYPE;
220: X_LAST_UPDATE_DATE DATE;
221: X_LAST_UPDATED_BY NUMBER;
222: X_LAST_UPDATE_LOGIN NUMBER;

Line 257: insert into IGS_FI_ENCMB_TYPE_ALL (

253: x_last_update_date => X_LAST_UPDATE_DATE,
254: x_last_updated_by => X_LAST_UPDATED_BY,
255: x_last_update_login => X_LAST_UPDATE_LOGIN
256: );
257: insert into IGS_FI_ENCMB_TYPE_ALL (
258: ENCUMBRANCE_TYPE,
259: DESCRIPTION,
260: S_ENCUMBRANCE_CAT,
261: CLOSED_IND,

Line 303: from IGS_FI_ENCMB_TYPE_ALL

299: DESCRIPTION,
300: S_ENCUMBRANCE_CAT,
301: CLOSED_IND,
302: COMMENTS
303: from IGS_FI_ENCMB_TYPE_ALL
304: where ROWID = X_ROWID
305: for update nowait;
306: tlinfo c1%rowtype;
307: begin

Line 378: update IGS_FI_ENCMB_TYPE_ALL set

374: x_last_update_date => X_LAST_UPDATE_DATE,
375: x_last_updated_by => X_LAST_UPDATED_BY,
376: x_last_update_login => X_LAST_UPDATE_LOGIN
377: );
378: update IGS_FI_ENCMB_TYPE_ALL set
379: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
380: S_ENCUMBRANCE_CAT = NEW_REFERENCES.S_ENCUMBRANCE_CAT,
381: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
382: COMMENTS = NEW_REFERENCES.COMMENTS,

Line 401: cursor c1 is select rowid from IGS_FI_ENCMB_TYPE_ALL

397: X_COMMENTS in VARCHAR2,
398: X_ORG_ID in NUMBER,
399: X_MODE in VARCHAR2 default 'R'
400: ) AS
401: cursor c1 is select rowid from IGS_FI_ENCMB_TYPE_ALL
402: where ENCUMBRANCE_TYPE = X_ENCUMBRANCE_TYPE
403: ;
404: begin
405: open c1;