APPS.IGI_IGI_ITR_CHARGE_RANGES_PKG dependencies on IGI_ITR_CHARGE_RANGES

Line 1: PACKAGE BODY IGI_IGI_ITR_CHARGE_RANGES_PKG as

1: PACKAGE BODY IGI_IGI_ITR_CHARGE_RANGES_PKG as
2: -- $Header: igiitrfb.pls 120.6.12000000.1 2007/09/12 10:30:56 mbremkum ship $
3: --
4:
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 83: CURSOR C IS SELECT rowid FROM IGI_ITR_CHARGE_RANGES

79: X_Last_Update_Date DATE,
80: X_Last_Updated_By NUMBER,
81: X_Last_Update_Login NUMBER
82: ) IS
83: CURSOR C IS SELECT rowid FROM IGI_ITR_CHARGE_RANGES
84: WHERE charge_range_id = X_Charge_Range_Id
85: AND charge_center_id = X_Charge_Center_Id;
86: CURSOR C2 IS SELECT IGI_IGI_itr_charge_ranges_s.nextval FROM sys.dual;
87: BEGIN

Line 86: CURSOR C2 IS SELECT IGI_IGI_itr_charge_ranges_s.nextval FROM sys.dual;

82: ) IS
83: CURSOR C IS SELECT rowid FROM IGI_ITR_CHARGE_RANGES
84: WHERE charge_range_id = X_Charge_Range_Id
85: AND charge_center_id = X_Charge_Center_Id;
86: CURSOR C2 IS SELECT IGI_IGI_itr_charge_ranges_s.nextval FROM sys.dual;
87: BEGIN
88: if (X_Charge_Range_Id is NULL) then
89: OPEN C2;
90: FETCH C2 INTO X_Charge_Range_Id;

Line 93: INSERT INTO IGI_ITR_CHARGE_RANGES(

89: OPEN C2;
90: FETCH C2 INTO X_Charge_Range_Id;
91: CLOSE C2;
92: end if;
93: INSERT INTO IGI_ITR_CHARGE_RANGES(
94: charge_range_id,
95: charge_center_id,
96: segment1_low,
97: segment1_high,

Line 307: FROM IGI_ITR_CHARGE_RANGES

303: ) IS
304:
305: CURSOR C IS
306: SELECT *
307: FROM IGI_ITR_CHARGE_RANGES
308: WHERE rowid = X_Rowid
309: FOR UPDATE of Charge_Range_Id NOWAIT;
310: Recinfo C%ROWTYPE;
311:

Line 320: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrfb.IGI_IGI_ITR_CHARGE_RANGES_PKG.lock_row.msg1', FALSE);

316: CLOSE C;
317: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
318:
319: IF ( l_excep_level >= l_debug_level) THEN
320: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrfb.IGI_IGI_ITR_CHARGE_RANGES_PKG.lock_row.msg1', FALSE);
321: END IF;
322:
323: APP_EXCEPTION.Raise_Exception;
324: end if;

Line 397: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrfb.IGI_IGI_ITR_CHARGE_RANGES_PKG.lock_row.msg2', FALSE);

393: else
394: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
395:
396: IF ( l_excep_level >= l_debug_level) THEN
397: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrfb.IGI_IGI_ITR_CHARGE_RANGES_PKG.lock_row.msg2', FALSE);
398: end if;
399: END IF;
400:
401: APP_EXCEPTION.Raise_Exception;

Line 473: UPDATE IGI_ITR_CHARGE_RANGES

469: X_Last_Updated_By NUMBER,
470: X_Last_Update_Login NUMBER
471: ) IS
472: BEGIN
473: UPDATE IGI_ITR_CHARGE_RANGES
474: SET
475: charge_range_id = X_Charge_Range_Id,
476: charge_center_id = X_Charge_Center_Id,
477: segment1_low = X_Segment1_Low,

Line 549: DELETE FROM IGI_ITR_CHARGE_RANGES

545: END Update_Row;
546:
547: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
548: BEGIN
549: DELETE FROM IGI_ITR_CHARGE_RANGES
550: WHERE rowid = X_Rowid;
551:
552: if (SQL%NOTFOUND) then
553: Raise NO_DATA_FOUND;

Line 557: END IGI_IGI_ITR_CHARGE_RANGES_PKG;

553: Raise NO_DATA_FOUND;
554: end if;
555: END Delete_Row;
556:
557: END IGI_IGI_ITR_CHARGE_RANGES_PKG;