APPS.IGI_IGI_ITR_CHARGE_HEADERS_PKG dependencies on IGI_ITR_CHARGE_HEADERS

Line 1: PACKAGE BODY IGI_IGI_ITR_CHARGE_HEADERS_PKG as

1: PACKAGE BODY IGI_IGI_ITR_CHARGE_HEADERS_PKG as
2: -- $Header: igiitrab.pls 120.5.12000000.1 2007/09/12 10:30:18 mbremkum ship $
3: --
4:
5:

Line 38: CURSOR C IS SELECT rowid FROM IGI_itr_charge_headers

34: X_Last_Update_Login NUMBER,
35: X_Last_Update_Date DATE,
36: X_Last_Updated_By NUMBER
37: ) IS
38: CURSOR C IS SELECT rowid FROM IGI_itr_charge_headers
39: WHERE it_header_id = X_It_Header_Id;
40: CURSOR C2 IS SELECT IGI_IGI_itr_charge_headers_s.nextval FROM sys.dual;
41: BEGIN
42: if (X_It_Header_Id is NULL) then

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

36: X_Last_Updated_By NUMBER
37: ) IS
38: CURSOR C IS SELECT rowid FROM IGI_itr_charge_headers
39: WHERE it_header_id = X_It_Header_Id;
40: CURSOR C2 IS SELECT IGI_IGI_itr_charge_headers_s.nextval FROM sys.dual;
41: BEGIN
42: if (X_It_Header_Id is NULL) then
43: OPEN C2;
44: FETCH C2 INTO X_It_Header_Id;

Line 48: INSERT INTO IGI_itr_charge_headers(

44: FETCH C2 INTO X_It_Header_Id;
45: CLOSE C2;
46: end if;
47:
48: INSERT INTO IGI_itr_charge_headers(
49: it_header_id,
50: set_of_books_id,
51: name,
52: description,

Line 125: FROM IGI_itr_charge_headers

121: ) IS
122:
123: CURSOR C IS
124: SELECT *
125: FROM IGI_itr_charge_headers
126: WHERE rowid = X_Rowid
127: FOR UPDATE of It_Header_Id NOWAIT;
128: Recinfo C%ROWTYPE;
129:

Line 139: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrab.IGI_IGI_ITR_CHARGE_HEADERS_PKG.lock_row.msg1', FALSE);

135: CLOSE C;
136: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
137:
138: IF( l_excep_level >= l_debug_level) THEN
139: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrab.IGI_IGI_ITR_CHARGE_HEADERS_PKG.lock_row.msg1', FALSE);
140: END IF;
141:
142: APP_EXCEPTION.Raise_Exception;
143: end if;

Line 177: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrab.IGI_IGI_ITR_CHARGE_HEADERS_PKG.lock_row.msg2', FALSE);

173: else
174: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
175:
176: IF( l_excep_level >= l_debug_level) THEN
177: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrab.IGI_IGI_ITR_CHARGE_HEADERS_PKG.lock_row.msg2', FALSE);
178: END IF;
179:
180: APP_EXCEPTION.Raise_Exception;
181: end if;

Line 208: UPDATE IGI_itr_charge_headers

204: X_Last_Update_Date DATE,
205: X_Last_Updated_By NUMBER
206: ) IS
207: BEGIN
208: UPDATE IGI_itr_charge_headers
209: SET
210: it_header_id = X_It_Header_Id,
211: set_of_books_id = X_Set_Of_Books_Id,
212: name = X_Name,

Line 237: DELETE FROM IGI_itr_charge_headers

233: end if;
234: END Update_Row;
235: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
236: BEGIN
237: DELETE FROM IGI_itr_charge_headers
238: WHERE rowid = X_Rowid;
239:
240: if (SQL%NOTFOUND) then
241: Raise NO_DATA_FOUND;

Line 246: END IGI_IGI_ITR_CHARGE_HEADERS_PKG;

242: end if;
243: END Delete_Row;
244:
245:
246: END IGI_IGI_ITR_CHARGE_HEADERS_PKG;