APPS.IGI_ITR_CHARGE_HEADERS_PKG dependencies on IGI_ITR_CHARGE_HEADERS

Line 1: PACKAGE BODY IGI_ITR_CHARGE_HEADERS_PKG as

1: PACKAGE BODY IGI_ITR_CHARGE_HEADERS_PKG as
2: -- $Header: igiitrsb.pls 120.5.12000000.1 2007/09/12 10:32:39 mbremkum ship $
3: --
4:
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 37: FROM igi_itr_charge_headers

33: X_Last_Updated_By NUMBER
34: ) IS
35:
36: CURSOR C IS SELECT rowid
37: FROM igi_itr_charge_headers
38: WHERE it_header_id = X_It_Header_Id;
39:
40: CURSOR C2 IS SELECT igi_itr_charge_headers_s.nextval FROM sys.dual;
41:

Line 40: CURSOR C2 IS SELECT igi_itr_charge_headers_s.nextval FROM sys.dual;

36: CURSOR C IS SELECT rowid
37: FROM igi_itr_charge_headers
38: WHERE it_header_id = X_It_Header_Id;
39:
40: CURSOR C2 IS SELECT igi_itr_charge_headers_s.nextval FROM sys.dual;
41:
42: BEGIN
43:
44: IF X_It_Header_Id is null THEN

Line 50: INSERT INTO igi_itr_charge_headers(

46: FETCH C2 INTO X_It_Header_Id;
47: CLOSE C2;
48: END IF;
49:
50: INSERT INTO igi_itr_charge_headers(
51: it_header_id
52: ,set_of_books_id
53: ,name
54: ,it_period_name

Line 127: FROM igi_itr_charge_headers

123: ) IS
124:
125: CURSOR C IS
126: SELECT *
127: FROM igi_itr_charge_headers
128: WHERE rowid = X_Rowid
129: FOR UPDATE of it_header_id NOWAIT;
130:
131: Recinfo C%ROWTYPE;

Line 142: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrsb.IGI_ITR_CHARGE_HEADERS_PKG.lock_row.msg1', FALSE);

138: IF (C%NOTFOUND) THEN
139: CLOSE C;
140: fnd_message.set_name('FND','FORM_RECORD_DELETED');
141: IF( l_excep_level >= l_debug_level) THEN
142: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrsb.IGI_ITR_CHARGE_HEADERS_PKG.lock_row.msg1', FALSE);
143: END IF;
144: app_exception.raise_exception;
145: END IF;
146: CLOSE C;

Line 188: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrsb.IGI_ITR_CHARGE_HEADERS_PKG.lock_row.msg2', FALSE);

184: return;
185: ELSE
186: fnd_message.set_name('FND','FORM_RECORD_CHANGED');
187: IF( l_excep_level >= l_debug_level) THEN
188: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrsb.IGI_ITR_CHARGE_HEADERS_PKG.lock_row.msg2', FALSE);
189: END IF;
190: APP_EXCEPTION.raise_exception;
191: END IF;
192:

Line 219: UPDATE igi_itr_charge_headers

215: X_Last_Updated_By NUMBER
216: ) IS
217: BEGIN
218:
219: UPDATE igi_itr_charge_headers
220: SET
221: it_header_id = X_It_Header_Id,
222: set_of_books_id = X_Set_Of_Books_Id,
223: name = X_Name,

Line 262: FROM igi_itr_charge_headers

258: -- OPSF(I) ITR Bug 1764441 22-May-2001 S Brewer Start(1)
259: CURSOR c_get_it_header_id(p_rowid VARCHAR2)
260: IS
261: SELECT it_header_id
262: FROM igi_itr_charge_headers
263: WHERE rowid = p_rowid;
264:
265: l_it_header_id NUMBER;
266: -- OPSF(I) ITR Bug 1764441 22-May-2001 S Brewer End(1)

Line 282: DELETE FROM igi_itr_charge_headers

278: CLOSE c_get_it_header_id;
279: -- OPSF(I) ITR Bug 1764441 22-May-2001 S Brewer End(2)
280:
281:
282: DELETE FROM igi_itr_charge_headers
283: WHERE rowid = X_Rowid;
284:
285: IF (SQL%NOTFOUND) THEN
286: raise NO_DATA_FOUND;

Line 297: FROM igi_itr_charge_headers ch

293: x_set_of_books_id NUMBER) IS
294:
295: CURSOR c_dup IS
296: SELECT 'Duplicate'
297: FROM igi_itr_charge_headers ch
298: WHERE ch.name = x_name
299: AND ch.set_of_books_id = x_set_of_books_id
300: AND (x_rowid IS NULL
301: OR

Line 315: FND_LOG.MESSAGE(l_error_level,'igi.plsql.igiitrqb.IGI_ITR_CHARGE_HEADERS_PKG.check_unique.msg3', FALSE);

311: IF c_dup%FOUND THEN
312: CLOSE c_dup;
313: fnd_message.set_name('IGI','IGI_ITR_DPL_ITR');
314: IF( l_error_level >= l_debug_level) THEN
315: FND_LOG.MESSAGE(l_error_level,'igi.plsql.igiitrqb.IGI_ITR_CHARGE_HEADERS_PKG.check_unique.msg3', FALSE);
316: END IF;
317: app_exception.raise_exception;
318: END IF;
319:

Line 325: END IGI_ITR_CHARGE_HEADERS_PKG;

321:
322: END check_unique;
323:
324:
325: END IGI_ITR_CHARGE_HEADERS_PKG;