APPS.IGI_ITR_CHARGE_ORIG_SS_PKG dependencies on IGI_ITR_CHARGE_ORIG

Line 1: PACKAGE BODY IGI_ITR_CHARGE_ORIG_SS_PKG as

1: PACKAGE BODY IGI_ITR_CHARGE_ORIG_SS_PKG as
2: -- $Header: igiitrjb.pls 120.5.12000000.1 2007/09/12 10:31:32 mbremkum ship $
3: --
4:
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 59: CURSOR C IS SELECT rowid FROM IGI_ITR_CHARGE_ORIG

55: X_Segment28 VARCHAR2,
56: X_Segment29 VARCHAR2,
57: X_Segment30 VARCHAR2
58: ) IS
59: CURSOR C IS SELECT rowid FROM IGI_ITR_CHARGE_ORIG
60: WHERE charge_orig_id = X_Charge_Orig_Id;
61: BEGIN
62:
63: INSERT INTO IGI_ITR_CHARGE_ORIG(

Line 63: INSERT INTO IGI_ITR_CHARGE_ORIG(

59: CURSOR C IS SELECT rowid FROM IGI_ITR_CHARGE_ORIG
60: WHERE charge_orig_id = X_Charge_Orig_Id;
61: BEGIN
62:
63: INSERT INTO IGI_ITR_CHARGE_ORIG(
64: charge_orig_id,
65: charge_center_id,
66: originator_id,
67: start_date,

Line 205: FROM IGI_ITR_CHARGE_ORIG

201: ) IS
202:
203: CURSOR C IS
204: SELECT *
205: FROM IGI_ITR_CHARGE_ORIG
206: WHERE rowid = X_Rowid
207: FOR UPDATE of Charge_Orig_Id NOWAIT;
208: Recinfo C%ROWTYPE;
209:

Line 218: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrjb.IGI_ITR_CHARGE_ORIG_SS_PKG .lock_row.msg1', FALSE);

214: CLOSE C;
215: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
216:
217: IF( l_excep_level >= l_debug_level) THEN
218: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrjb.IGI_ITR_CHARGE_ORIG_SS_PKG .lock_row.msg1', FALSE);
219: END IF;
220:
221: APP_EXCEPTION.Raise_Exception;
222: end if;

Line 330: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrjb.IGI_ITR_CHARGE_ORIG_SS_PKG .lock_row.msg2', FALSE);

326: else
327: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
328:
329: IF( l_excep_level >= l_debug_level) THEN
330: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrjb.IGI_ITR_CHARGE_ORIG_SS_PKG .lock_row.msg2', FALSE);
331: END IF;
332:
333: APP_EXCEPTION.Raise_Exception;
334: end if;

Line 383: UPDATE IGI_ITR_CHARGE_ORIG

379: X_Segment29 VARCHAR2,
380: X_Segment30 VARCHAR2
381: ) IS
382: BEGIN
383: UPDATE IGI_ITR_CHARGE_ORIG
384: SET
385: charge_orig_id = X_Charge_Orig_Id,
386: charge_center_id = X_Charge_Center_Id,
387: originator_id = X_Originator_Id,

Line 435: DELETE FROM IGI_ITR_CHARGE_ORIG

431: END Update_Row;
432:
433: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
434: BEGIN
435: DELETE FROM IGI_ITR_CHARGE_ORIG
436: WHERE rowid = X_Rowid;
437:
438: if (SQL%NOTFOUND) then
439: Raise NO_DATA_FOUND;

Line 443: END IGI_ITR_CHARGE_ORIG_SS_PKG;

439: Raise NO_DATA_FOUND;
440: end if;
441: END Delete_Row;
442:
443: END IGI_ITR_CHARGE_ORIG_SS_PKG;