APPS.IGI_RPI_STANDING_CHARGES_PKG dependencies on IGI_RPI_STANDING_CHARGES

Line 1: PACKAGE BODY IGI_RPI_STANDING_CHARGES_PKG as

1: PACKAGE BODY IGI_RPI_STANDING_CHARGES_PKG as
2: --- $Header: igirstcb.pls 120.7.12000000.1 2007/08/31 05:53:44 mbremkum ship $
3:
4: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: l_state_level number:=FND_LOG.LEVEL_STATEMENT;

Line 57: CURSOR C IS SELECT rowid FROM IGI_RPI_STANDING_CHARGES

53: X_Legal_Entity_Id NUMBER,
54: X_Payment_Trxn_Extension_Id NUMBER
55: /*MOAC Impact Bug No 5905216 - End*/
56: ) IS
57: CURSOR C IS SELECT rowid FROM IGI_RPI_STANDING_CHARGES
58: WHERE standing_charge_id = X_Standing_Charge_Id;
59: CURSOR C2 IS SELECT igi_rpi_standing_charges_s.nextval FROM sys.dual;
60: BEGIN
61: if (X_Standing_Charge_Id is NULL) then

Line 59: CURSOR C2 IS SELECT igi_rpi_standing_charges_s.nextval FROM sys.dual;

55: /*MOAC Impact Bug No 5905216 - End*/
56: ) IS
57: CURSOR C IS SELECT rowid FROM IGI_RPI_STANDING_CHARGES
58: WHERE standing_charge_id = X_Standing_Charge_Id;
59: CURSOR C2 IS SELECT igi_rpi_standing_charges_s.nextval FROM sys.dual;
60: BEGIN
61: if (X_Standing_Charge_Id is NULL) then
62: OPEN C2;
63: FETCH C2 INTO X_Standing_Charge_Id;

Line 66: INSERT INTO IGI_RPI_STANDING_CHARGES(

62: OPEN C2;
63: FETCH C2 INTO X_Standing_Charge_Id;
64: CLOSE C2;
65: end if;
66: INSERT INTO IGI_RPI_STANDING_CHARGES(
67: standing_charge_id,
68: charge_reference,
69: set_of_books_id,
70: standing_charge_date,

Line 207: FROM IGI_RPI_STANDING_CHARGES

203: /*MOAC Impact Bug No 5905216 - End*/
204: ) IS
205: CURSOR C IS
206: SELECT *
207: FROM IGI_RPI_STANDING_CHARGES
208: WHERE rowid = X_Rowid
209: FOR UPDATE of Standing_Charge_Id NOWAIT;
210: Recinfo C%ROWTYPE;
211:

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

218: CLOSE C;
219: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
220: --Bug 3199481 (start)
221: If (l_unexp_level >= l_debug_level) then
222: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_standing_charges_pkg.lock_row.Msg1',FALSE);
223: End if;
224: --Bug 3199481 (end)
225: APP_EXCEPTION.Raise_Exception;
226: end if;

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

314: else
315: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
316: --Bug 3199481 (start)
317: If (l_unexp_level >= l_debug_level) then
318: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_standing_charges_pkg.lock_row.Msg2',FALSE);
319: End if;
320: --Bug 3199481 (end)
321: APP_EXCEPTION.Raise_Exception;
322: end if;

Line 370: UPDATE IGI_RPI_STANDING_CHARGES

366: X_Payment_Trxn_Extension_Id NUMBER
367: /*MOAC Impact Bug No 5905216 - End*/
368: ) IS
369: BEGIN
370: UPDATE IGI_RPI_STANDING_CHARGES
371: SET
372: standing_charge_id = X_Standing_Charge_Id,
373: charge_reference = X_Charge_Reference,
374: set_of_books_id = X_Set_Of_Books_Id,

Line 420: DELETE FROM IGI_RPI_STANDING_CHARGES

416: END Update_Row;
417:
418: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
419: BEGIN
420: DELETE FROM IGI_RPI_STANDING_CHARGES
421: WHERE rowid = X_Rowid;
422:
423: if (SQL%NOTFOUND) then
424: Raise NO_DATA_FOUND;

Line 429: END IGI_RPI_STANDING_CHARGES_PKG;

425: end if;
426: END Delete_Row;
427:
428:
429: END IGI_RPI_STANDING_CHARGES_PKG;