APPS.IGI_ITR_CHARGE_SERVICES_SS_PKG dependencies on IGI_ITR_CHARGE_SERVICE

Line 1: PACKAGE BODY IGI_ITR_CHARGE_SERVICES_SS_PKG as

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

Line 29: CURSOR C IS SELECT rowid FROM IGI_itr_charge_service

25: X_Last_Update_Login NUMBER,
26: X_Last_Update_Date DATE,
27: X_Last_Updated_By NUMBER
28: ) IS
29: CURSOR C IS SELECT rowid FROM IGI_itr_charge_service
30: WHERE charge_service_id = X_Charge_Service_Id;
31:
32: BEGIN
33: INSERT INTO IGI_itr_charge_service(

Line 33: INSERT INTO IGI_itr_charge_service(

29: CURSOR C IS SELECT rowid FROM IGI_itr_charge_service
30: WHERE charge_service_id = X_Charge_Service_Id;
31:
32: BEGIN
33: INSERT INTO IGI_itr_charge_service(
34: charge_center_Id,
35: charge_service_id,
36: service_id,
37: creation_ccid,

Line 83: FROM IGI_itr_charge_service

79: ) IS
80:
81: CURSOR C IS
82: SELECT *
83: FROM IGI_itr_charge_service
84: WHERE rowid = X_Rowid
85: FOR UPDATE of Charge_Service_Id NOWAIT;
86:
87: Recinfo C%ROWTYPE;

Line 100: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrkb.IGI_ITR_CHARGE_SERVICES_SS_PKG.lock_row.msg1', FALSE);

96: -- fnd_message.debug('Form Record deleted');
97: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
98:
99: IF( l_excep_level >= l_debug_level) THEN
100: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrkb.IGI_ITR_CHARGE_SERVICES_SS_PKG.lock_row.msg1', FALSE);
101: END IF;
102:
103: APP_EXCEPTION.Raise_Exception;
104: -- fnd_message.error;

Line 127: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrkb.IGI_ITR_CHARGE_SERVICES_SS_PKG.lock_row.msg2', FALSE);

123: -- fnd_message.debug('Form record changed');
124: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
125:
126: IF( l_excep_level >= l_debug_level) THEN
127: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrkb.IGI_ITR_CHARGE_SERVICES_SS_PKG.lock_row.msg2', FALSE);
128: END IF;
129:
130: APP_EXCEPTION.Raise_Exception;
131: end if;

Line 150: UPDATE IGI_itr_charge_service

146: X_Last_Updated_By NUMBER
147: ) IS
148:
149: BEGIN
150: UPDATE IGI_itr_charge_service
151: SET
152: charge_center_id = X_Charge_Center_Id,
153: service_id = X_Service_Id,
154: creation_ccid = X_Creation_Ccid,

Line 172: DELETE FROM IGI_itr_charge_service

168:
169:
170: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
171: BEGIN
172: DELETE FROM IGI_itr_charge_service
173: WHERE rowid = X_Rowid;
174: if (SQL%NOTFOUND) then
175: Raise NO_DATA_FOUND;
176: end if;

Line 181: END IGI_ITR_CHARGE_SERVICES_SS_PKG;

177: END Delete_Row;
178:
179:
180:
181: END IGI_ITR_CHARGE_SERVICES_SS_PKG;