APPS.IGS_FI_ACC_PKG dependencies on IGS_FI_ACC_ALL

Line 4: old_references IGS_FI_ACC_ALL%RowType;

1: package body IGS_FI_ACC_PKG AS
2: /* $Header: IGSSI02B.pls 115.20 2003/02/17 05:22:31 pathipat ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_ACC_ALL%RowType;
5: new_references IGS_FI_ACC_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_FI_ACC_ALL%RowType;

1: package body IGS_FI_ACC_PKG AS
2: /* $Header: IGSSI02B.pls 115.20 2003/02/17 05:22:31 pathipat ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_ACC_ALL%RowType;
5: new_references IGS_FI_ACC_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 21: FROM IGS_FI_ACC_ALL

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

Line 101: FROM IGS_FI_ACC_ALL

97: ----------------------------------------------------------------------*/
98:
99: CURSOR cur_rowid IS
100: SELECT rowid
101: FROM IGS_FI_ACC_ALL
102: WHERE account_cd = x_account_cd;
103:
104: lv_rowid cur_rowid%RowType;
105:

Line 189: cursor C is select ROWID from IGS_FI_ACC_ALL

185: X_CLOSED_IND in VARCHAR2,
186: X_ORG_ID in NUMBER ,
187: X_MODE in VARCHAR2
188: ) AS
189: cursor C is select ROWID from IGS_FI_ACC_ALL
190: where ACCOUNT_CD = X_ACCOUNT_CD;
191: X_LAST_UPDATE_DATE DATE;
192: X_LAST_UPDATED_BY NUMBER;
193: X_LAST_UPDATE_LOGIN NUMBER;

Line 226: insert into IGS_FI_ACC_ALL (

222: x_last_update_date => X_LAST_UPDATE_DATE,
223: x_last_updated_by => X_LAST_UPDATED_BY,
224: x_last_update_login => X_LAST_UPDATE_LOGIN
225: );
226: insert into IGS_FI_ACC_ALL (
227: ACCOUNT_CD,
228: DESCRIPTION,
229: CLOSED_IND,
230: ORG_ID,

Line 265: from IGS_FI_ACC_ALL

261: ) AS
262: cursor c1 is select
263: DESCRIPTION,
264: CLOSED_IND
265: from IGS_FI_ACC_ALL
266: where ROWID = X_ROWID
267: for update nowait;
268: tlinfo c1%rowtype;
269: BEGIN

Line 334: update IGS_FI_ACC_ALL set

330: x_last_update_date => X_LAST_UPDATE_DATE,
331: x_last_updated_by => X_LAST_UPDATED_BY,
332: x_last_update_login => X_LAST_UPDATE_LOGIN
333: );
334: update IGS_FI_ACC_ALL set
335: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
336: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
337: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
338: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 355: cursor c1 is select rowid from IGS_FI_ACC_ALL

351: X_CLOSED_IND in VARCHAR2,
352: X_ORG_ID in NUMBER ,
353: X_MODE in VARCHAR2
354: ) AS
355: cursor c1 is select rowid from IGS_FI_ACC_ALL
356: where ACCOUNT_CD = X_ACCOUNT_CD
357: ;
358: begin
359: open c1;