APPS.IGW_INSTITUTE_RATES_PKG dependencies on IGW_INSTITUTE_RATES

Line 1: package body IGW_INSTITUTE_RATES_PKG as

1: package body IGW_INSTITUTE_RATES_PKG as
2: -- $Header: igwstrab.pls 115.4 2002/11/14 18:47:09 vmedikon ship $
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 15: cursor C is select ROWID from IGW_INSTITUTE_RATES

11: X_START_DATE in DATE,
12: X_RATE in NUMBER,
13: X_MODE in VARCHAR2 default 'R'
14: ) is
15: cursor C is select ROWID from IGW_INSTITUTE_RATES
16: where RATE_CLASS_ID = X_RATE_CLASS_ID
17: and RATE_TYPE_ID = X_RATE_TYPE_ID
18: and ACTIVITY_TYPE_CODE = X_ACTIVITY_TYPE_CODE
19: and FISCAL_YEAR = X_FISCAL_YEAR

Line 42: insert into IGW_INSTITUTE_RATES (

38: else
39: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
40: app_exception.raise_exception;
41: end if;
42: insert into IGW_INSTITUTE_RATES (
43: RATE_CLASS_ID,
44: RATE_TYPE_ID,
45: ACTIVITY_TYPE_CODE,
46: FISCAL_YEAR,

Line 91: from IGW_INSTITUTE_RATES

87: X_START_DATE in DATE,
88: X_RATE in NUMBER
89: ) is
90: cursor c1 is select *
91: from IGW_INSTITUTE_RATES
92: where ROWID = X_ROWID
93: for update of RATE_CLASS_ID, RATE_TYPE_ID, ACTIVITY_TYPE_CODE, FISCAL_YEAR, LOCATION_CODE nowait;
94: tlinfo c1%rowtype;
95:

Line 156: update IGW_INSTITUTE_RATES set

152: else
153: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
154: app_exception.raise_exception;
155: end if;
156: update IGW_INSTITUTE_RATES set
157: RATE_CLASS_ID = X_RATE_CLASS_ID,
158: RATE_TYPE_ID = X_RATE_TYPE_ID,
159: ACTIVITY_TYPE_CODE = X_ACTIVITY_TYPE_CODE,
160: FISCAL_YEAR = X_FISCAL_YEAR,

Line 228: delete from IGW_INSTITUTE_RATES

224: procedure DELETE_ROW (
225: X_ROWID in VARCHAR2
226: ) is
227: begin
228: delete from IGW_INSTITUTE_RATES
229: where ROWID = X_ROWID;
230: if (sql%notfound) then
231: raise no_data_found;
232: end if;

Line 235: end IGW_INSTITUTE_RATES_PKG;

231: raise no_data_found;
232: end if;
233: end DELETE_ROW;
234:
235: end IGW_INSTITUTE_RATES_PKG;