APPS.IGW_EXP_TYPES_PKG dependencies on IGW_EXPENDITURE_TYPES

Line 12: cursor C is select ROWID from IGW_EXPENDITURE_TYPES

8: X_START_DATE_ACTIVE in DATE,
9: X_END_DATE_ACTIVE in DATE,
10: X_MODE in VARCHAR2 default 'R'
11: ) is
12: cursor C is select ROWID from IGW_EXPENDITURE_TYPES
13: where EXPENDITURE_TYPE = X_EXPENDITURE_TYPE;
14: X_LAST_UPDATE_DATE DATE;
15: X_LAST_UPDATED_BY NUMBER;
16: X_LAST_UPDATE_LOGIN NUMBER;

Line 35: insert into IGW_EXPENDITURE_TYPES (

31: else
32: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
33: app_exception.raise_exception;
34: end if;
35: insert into IGW_EXPENDITURE_TYPES (
36: EXPENDITURE_CATEGORY,
37: EXPENDITURE_TYPE,
38: DESCRIPTION,
39: START_DATE_ACTIVE,

Line 78: from IGW_EXPENDITURE_TYPES

74: X_START_DATE_ACTIVE in DATE,
75: X_END_DATE_ACTIVE in DATE
76: ) is
77: cursor c1 is select *
78: from IGW_EXPENDITURE_TYPES
79: where ROWID = X_ROWID
80: for update of EXPENDITURE_TYPE nowait;
81: tlinfo c1%rowtype;
82:

Line 140: update IGW_EXPENDITURE_TYPES set

136: else
137: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
138: app_exception.raise_exception;
139: end if;
140: update IGW_EXPENDITURE_TYPES set
141: EXPENDITURE_CATEGORY = X_EXPENDITURE_CATEGORY,
142: EXPENDITURE_TYPE = X_EXPENDITURE_TYPE,
143: DESCRIPTION = X_DESCRIPTION,
144: START_DATE_ACTIVE = X_START_DATE_ACTIVE,

Line 210: delete from IGW_EXPENDITURE_TYPES

206: procedure DELETE_ROW (
207: X_ROWID in VARCHAR2
208: ) is
209: begin
210: delete from IGW_EXPENDITURE_TYPES
211: where ROWID = X_ROWID;
212: if (sql%notfound) then
213: raise no_data_found;
214: end if;