APPS.IGW_EXP_CATEGORIES_PKG dependencies on IGW_EXPENDITURE_CATEGORIES

Line 13: cursor C is select ROWID from IGW_EXPENDITURE_CATEGORIES

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

Line 36: insert into IGW_EXPENDITURE_CATEGORIES (

32: else
33: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
34: app_exception.raise_exception;
35: end if;
36: insert into IGW_EXPENDITURE_CATEGORIES (
37: EXPENDITURE_CATEGORY,
38: DESCRIPTION,
39: BUDGET_CATEGORY_CODE,
40: PERSONNEL_ATTACHED_FLAG,

Line 82: from IGW_EXPENDITURE_CATEGORIES

78: X_START_DATE_ACTIVE in DATE,
79: X_END_DATE_ACTIVE in DATE
80: ) is
81: cursor c1 is select *
82: from IGW_EXPENDITURE_CATEGORIES
83: where ROWID = X_ROWID
84: for update of EXPENDITURE_CATEGORY nowait;
85: tlinfo c1%rowtype;
86:

Line 148: update IGW_EXPENDITURE_CATEGORIES set

144: else
145: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
146: app_exception.raise_exception;
147: end if;
148: update IGW_EXPENDITURE_CATEGORIES set
149: EXPENDITURE_CATEGORY = X_EXPENDITURE_CATEGORY,
150: DESCRIPTION = decode(igw_security.gms_enabled, 'N', X_DESCRIPTION, null),
151: BUDGET_CATEGORY_CODE = X_BUDGET_CATEGORY_CODE,
152: PERSONNEL_ATTACHED_FLAG = X_PERSONNEL_ATTACHED_FLAG,

Line 219: delete from IGW_EXPENDITURE_CATEGORIES

215: procedure DELETE_ROW (
216: X_ROWID in VARCHAR2
217: ) is
218: begin
219: delete from IGW_EXPENDITURE_CATEGORIES
220: where ROWID = X_ROWID;
221: if (sql%notfound) then
222: raise no_data_found;
223: end if;