APPS.IGI_IGI_ITR_CHARGE_LINES_PKG dependencies on IGI_ITR_CHARGE_LINES

Line 1: PACKAGE BODY IGI_IGI_ITR_CHARGE_LINES_PKG as

1: PACKAGE BODY IGI_IGI_ITR_CHARGE_LINES_PKG as
2: -- $Header: igiitrcb.pls 120.5.12000000.1 2007/09/12 10:30:34 mbremkum ship $
3: --
4:
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 35: CURSOR C IS SELECT rowid FROM IGI_ITR_CHARGE_LINES

31: X_Last_Update_Login NUMBER,
32: X_Last_Update_Date DATE,
33: X_Last_Updated_By NUMBER
34: ) IS
35: CURSOR C IS SELECT rowid FROM IGI_ITR_CHARGE_LINES
36: WHERE it_header_id = X_It_Header_Id
37: AND it_line_num = X_It_Line_Num
38: AND set_of_books_id = X_Set_Of_Books_Id;
39:

Line 43: INSERT INTO IGI_ITR_CHARGE_LINES(

39:
40: BEGIN
41:
42:
43: INSERT INTO IGI_ITR_CHARGE_LINES(
44: it_header_id,
45: it_line_num,
46: set_of_books_id,
47: code_combination_id,

Line 112: FROM IGI_ITR_CHARGE_LINES

108: ) IS
109:
110: CURSOR C IS
111: SELECT *
112: FROM IGI_ITR_CHARGE_LINES
113: WHERE rowid = X_Rowid
114: FOR UPDATE of It_Header_Id NOWAIT;
115: Recinfo C%ROWTYPE;
116:

Line 126: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrcb.IGI_IGI_ITR_CHARGE_LINES_PKG.lock_row.msg1', FALSE);

122: CLOSE C;
123: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
124:
125: IF ( l_excep_level >= l_debug_level) THEN
126: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrcb.IGI_IGI_ITR_CHARGE_LINES_PKG.lock_row.msg1', FALSE);
127: END IF;
128:
129:
130:

Line 167: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrcb.IGI_IGI_ITR_CHARGE_LINES_PKG.lock_row.msg2', FALSE);

163: else
164: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
165:
166: IF ( l_excep_level >= l_debug_level) THEN
167: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrcb.IGI_IGI_ITR_CHARGE_LINES_PKG.lock_row.msg2', FALSE);
168: END IF;
169:
170:
171:

Line 197: UPDATE IGI_ITR_CHARGE_LINES

193: X_Last_Updated_By NUMBER
194:
195: ) IS
196: BEGIN
197: UPDATE IGI_ITR_CHARGE_LINES
198: SET
199: it_header_id = X_It_Header_Id,
200: it_line_num = X_It_Line_Num,
201: set_of_books_id = X_Set_Of_Books_Id,

Line 222: DELETE FROM IGI_ITR_CHARGE_LINES

218: end if;
219: END Update_Row;
220: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
221: BEGIN
222: DELETE FROM IGI_ITR_CHARGE_LINES
223: WHERE rowid = X_Rowid;
224:
225: if (SQL%NOTFOUND) then
226: Raise NO_DATA_FOUND;

Line 231: END IGI_IGI_ITR_CHARGE_LINES_PKG;

227: end if;
228: END Delete_Row;
229:
230:
231: END IGI_IGI_ITR_CHARGE_LINES_PKG;