APPS.IGI_ITR_CHARGE_RANGES_SS_PKG dependencies on IGI_ITR_CHARGE_RANGES

Line 1: PACKAGE BODY IGI_ITR_CHARGE_RANGES_SS_PKG as

1: PACKAGE BODY IGI_ITR_CHARGE_RANGES_SS_PKG as
2: -- $Header: igiitrib.pls 120.5.12000000.1 2007/09/12 10:31:25 mbremkum ship $
3:
4: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: l_state_level number := FND_LOG.LEVEL_STATEMENT;

Line 84: CURSOR C IS SELECT rowid FROM IGI_ITR_CHARGE_RANGES

80: X_Last_Update_Date DATE,
81: X_Last_Updated_By NUMBER,
82: X_Last_Update_Login NUMBER
83: ) IS
84: CURSOR C IS SELECT rowid FROM IGI_ITR_CHARGE_RANGES
85: WHERE charge_range_id = X_Charge_Range_Id
86: AND charge_center_id = X_Charge_Center_Id;
87: BEGIN
88: INSERT INTO IGI_ITR_CHARGE_RANGES(

Line 88: INSERT INTO IGI_ITR_CHARGE_RANGES(

84: CURSOR C IS SELECT rowid FROM IGI_ITR_CHARGE_RANGES
85: WHERE charge_range_id = X_Charge_Range_Id
86: AND charge_center_id = X_Charge_Center_Id;
87: BEGIN
88: INSERT INTO IGI_ITR_CHARGE_RANGES(
89: charge_range_id,
90: charge_center_id,
91: authoriser_id,
92: employee_id,

Line 310: FROM IGI_ITR_CHARGE_RANGES

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

Line 323: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrib.IGI_ITR_CHARGE_RANGES_SS_PKG.lock_row.msg1', FALSE);

319: CLOSE C;
320: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
321:
322: IF( l_excep_level >= l_debug_level) THEN
323: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrib.IGI_ITR_CHARGE_RANGES_SS_PKG.lock_row.msg1', FALSE);
324: END IF;
325:
326: APP_EXCEPTION.Raise_Exception;
327: end if;

Line 403: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrib.IGI_ITR_CHARGE_RANGES_SS_PKG.lock_row.msg2', FALSE);

399: else
400: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
401:
402: IF( l_excep_level >= l_debug_level) THEN
403: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrib.IGI_ITR_CHARGE_RANGES_SS_PKG.lock_row.msg2', FALSE);
404: END IF;
405:
406: APP_EXCEPTION.Raise_Exception;
407: end if;

Line 482: UPDATE IGI_ITR_CHARGE_RANGES

478: X_Last_Updated_By NUMBER,
479: X_Last_Update_Login NUMBER
480: ) IS
481: BEGIN
482: UPDATE IGI_ITR_CHARGE_RANGES
483: SET
484: charge_range_id = X_Charge_Range_Id,
485: charge_center_id = X_Charge_Center_Id,
486: authoriser_id = X_Authoriser_Id,

Line 561: DELETE FROM IGI_ITR_CHARGE_RANGES

557: END Update_Row;
558:
559: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
560: BEGIN
561: DELETE FROM IGI_ITR_CHARGE_RANGES
562: WHERE rowid = X_Rowid;
563:
564: if (SQL%NOTFOUND) then
565: Raise NO_DATA_FOUND;

Line 569: END IGI_ITR_CHARGE_RANGES_SS_PKG;

565: Raise NO_DATA_FOUND;
566: end if;
567: END Delete_Row;
568:
569: END IGI_ITR_CHARGE_RANGES_SS_PKG;