APPS.IGI_RPI_LINE_DETAILS_PKG dependencies on IGI_RPI_LINE_DETAILS

Line 1: PACKAGE BODY IGI_RPI_LINE_DETAILS_PKG as

1: PACKAGE BODY IGI_RPI_LINE_DETAILS_PKG as
2: --- $Header: igirldeb.pls 120.5.12000000.1 2007/08/31 05:52:59 mbremkum ship $
3:
4: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: l_state_level number:=FND_LOG.LEVEL_STATEMENT;

Line 41: CURSOR C IS SELECT rowid FROM IGI_RPI_LINE_DETAILS

37: X_Duration NUMBER,
38: X_Legal_Entity_Id NUMBER, --Added for MOAC Impact Bug No 5905216
39: X_Org_Id NUMBER --Added for MOAC Impact Bug No 5905216
40: ) IS
41: CURSOR C IS SELECT rowid FROM IGI_RPI_LINE_DETAILS
42: WHERE line_item_id = X_Line_Item_Id;
43: CURSOR C2 IS SELECT igi_rpi_line_details_s.nextval FROM sys.dual;
44: BEGIN
45: if (X_Line_Item_Id is NULL) then

Line 43: CURSOR C2 IS SELECT igi_rpi_line_details_s.nextval FROM sys.dual;

39: X_Org_Id NUMBER --Added for MOAC Impact Bug No 5905216
40: ) IS
41: CURSOR C IS SELECT rowid FROM IGI_RPI_LINE_DETAILS
42: WHERE line_item_id = X_Line_Item_Id;
43: CURSOR C2 IS SELECT igi_rpi_line_details_s.nextval FROM sys.dual;
44: BEGIN
45: if (X_Line_Item_Id is NULL) then
46: OPEN C2;
47: FETCH C2 INTO X_Line_Item_Id;

Line 53: INSERT INTO IGI_RPI_LINE_DETAILS(

49: end if;
50:
51: /*Modified the Insert to include ORG_ID and LEGAL_ENTITY_ID for MOAC Impact R12 Uptake Bug No 5905216*/
52:
53: INSERT INTO IGI_RPI_LINE_DETAILS(
54: standing_charge_id,
55: line_item_id,
56: charge_item_number,
57: item_id,

Line 147: FROM IGI_RPI_LINE_DETAILS

143: X_Org_Id NUMBER --Added for MOAC Impact Bug No 5905216
144: ) IS
145: CURSOR C IS
146: SELECT *
147: FROM IGI_RPI_LINE_DETAILS
148: WHERE rowid = X_Rowid
149: FOR UPDATE of Line_Item_Id NOWAIT;
150: Recinfo C%ROWTYPE;
151:

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

157: CLOSE C;
158: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
159: --Bug 3199481 (start)
160: If (l_unexp_level >= l_debug_level) then
161: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_line_details_pkg.lock_row.Msg1',FALSE);
162: End if;
163: --Bug 3199481 (end)
164: APP_EXCEPTION.Raise_Exception;
165: end if;

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

216: else
217: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
218: --Bug 3199481 (start)
219: If (l_unexp_level >= l_debug_level) then
220: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_line_details_pkg.lock_row.Msg2',FALSE);
221: End if;
222: --Bug 3199481 (end)
223: APP_EXCEPTION.Raise_Exception;
224: end if;

Line 257: UPDATE IGI_RPI_LINE_DETAILS

253: X_Legal_Entity_Id NUMBER, --Added for MOAC Impact Bug No 5905216
254: X_Org_Id NUMBER --Added for MOAC Impact Bug No 5905216
255: ) IS
256: BEGIN
257: UPDATE IGI_RPI_LINE_DETAILS
258: SET
259: standing_charge_id = X_Standing_Charge_Id,
260: line_item_id = X_Line_Item_Id,
261: charge_item_number = X_Charge_Item_Number,

Line 293: DELETE FROM IGI_RPI_LINE_DETAILS

289: END Update_Row;
290:
291: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
292: BEGIN
293: DELETE FROM IGI_RPI_LINE_DETAILS
294: WHERE rowid = X_Rowid;
295:
296: if (SQL%NOTFOUND) then
297: Raise NO_DATA_FOUND;

Line 302: END IGI_RPI_LINE_DETAILS_PKG;

298: end if;
299: END Delete_Row;
300:
301:
302: END IGI_RPI_LINE_DETAILS_PKG;