APPS.IGI_RPI_UPDATE_LINES_D_PKG dependencies on IGI_RPI_UPDATE_LINES

Line 1: PACKAGE BODY IGI_RPI_UPDATE_LINES_D_PKG as

1: PACKAGE BODY IGI_RPI_UPDATE_LINES_D_PKG as
2: --- $Header: igiruldb.pls 120.4.12000000.1 2007/08/31 05:53:52 mbremkum ship $
3:
4: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:

Line 33: CURSOR C IS SELECT rowid FROM igi_rpi_update_lines

29: X_Last_Updated_By NUMBER,
30: X_Last_Update_Date DATE,
31: X_Last_Update_Login NUMBER
32: ) IS
33: CURSOR C IS SELECT rowid FROM igi_rpi_update_lines
34: WHERE run_id = X_run_id
35: and item_id = X_item_id
36: and standing_charge_id is not null;
37: BEGIN

Line 40: INSERT INTO igi_rpi_update_lines (

36: and standing_charge_id is not null;
37: BEGIN
38:
39:
40: INSERT INTO igi_rpi_update_lines (
41: run_id,
42: standing_charge_id,
43: line_item_id,
44: item_id,

Line 104: FROM igi_rpi_update_lines

100: X_select_flag VARCHAR2
101: ) IS
102: CURSOR C IS
103: SELECT *
104: FROM igi_rpi_update_lines
105: WHERE rowid = X_Rowid
106: FOR UPDATE of run_id NOWAIT;
107: Recinfo C%ROWTYPE;
108: BEGIN

Line 116: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_update_lines_d_pkg.lock_row.Msg1',FALSE);

112: CLOSE C;
113: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
114: --Bug 3199481 (start)
115: If (l_unexp_level >= l_debug_level) then
116: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_update_lines_d_pkg.lock_row.Msg1',FALSE);
117: End if;
118: --Bug 3199481 (end)
119: APP_EXCEPTION.Raise_Exception;
120: end if;

Line 157: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_update_lines_d_pkg.lock_row.Msg2',FALSE);

153: else
154: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
155: --Bug 3199481 (start)
156: If (l_unexp_level >= l_debug_level) then
157: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_update_lines_d_pkg.lock_row.Msg2',FALSE);
158: End if;
159: --Bug 3199481 (end)
160: APP_EXCEPTION.Raise_Exception;
161: end if;

Line 183: UPDATE igi_rpi_update_lines

179: X_Last_Update_Date DATE,
180: X_Last_Update_Login NUMBER
181: ) IS
182: BEGIN
183: UPDATE igi_rpi_update_lines
184: SET
185: run_id = X_run_id,
186: standing_charge_id = X_standing_charge_id,
187: line_item_id = X_line_item_id,

Line 208: DELETE FROM igi_rpi_update_lines

204: END Update_Row;
205:
206: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
207: BEGIN
208: DELETE FROM igi_rpi_update_lines
209: WHERE rowid = X_Rowid;
210:
211: if (SQL%NOTFOUND) then
212: Raise NO_DATA_FOUND;

Line 217: END IGI_RPI_UPDATE_LINES_D_PKG;

213: end if;
214: END Delete_Row;
215:
216:
217: END IGI_RPI_UPDATE_LINES_D_PKG;