APPS.IGI_ITR_CHARGE_CENTER_SS_PKG dependencies on IGI_ITR_CHARGE_CENTER

Line 1: PACKAGE BODY IGI_ITR_CHARGE_CENTER_SS_PKG as

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

Line 27: CURSOR C IS SELECT rowid FROM IGI_itr_charge_center

23: X_Last_Update_Login NUMBER,
24: X_Last_Update_Date DATE,
25: X_Last_Updated_By NUMBER
26: ) IS
27: CURSOR C IS SELECT rowid FROM IGI_itr_charge_center
28: WHERE charge_center_id = X_Charge_Center_Id;
29:
30: BEGIN
31: INSERT INTO IGI_itr_charge_center(

Line 31: INSERT INTO IGI_itr_charge_center(

27: CURSOR C IS SELECT rowid FROM IGI_itr_charge_center
28: WHERE charge_center_id = X_Charge_Center_Id;
29:
30: BEGIN
31: INSERT INTO IGI_itr_charge_center(
32: Charge_Center_Id,
33: Name,
34: Set_Of_Books_Id,
35: Start_Date_Active,

Line 77: FROM IGI_itr_charge_center

73: X_Description VARCHAR2
74: ) IS
75: CURSOR C IS
76: SELECT *
77: FROM IGI_itr_charge_center
78: WHERE rowid = X_Rowid
79: FOR UPDATE of Charge_Center_Id NOWAIT;
80: Recinfo C%ROWTYPE;
81:

Line 90: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrlb.IGI_ITR_CHARGE_CENTER_SS.lock_row.msg1', FALSE);

86: CLOSE C;
87: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
88:
89: IF( l_excep_level >= l_debug_level) THEN
90: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrlb.IGI_ITR_CHARGE_CENTER_SS.lock_row.msg1', FALSE);
91: END IF;
92:
93: APP_EXCEPTION.Raise_Exception;
94: end if;

Line 113: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrlb.IGI_ITR_CHARGE_CENTER_SS.lock_row.msg2', FALSE);

109: else
110: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
111:
112: IF( l_excep_level >= l_debug_level) THEN
113: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrlb.IGI_ITR_CHARGE_CENTER_SS.lock_row.msg2', FALSE);
114: END IF;
115:
116: APP_EXCEPTION.Raise_Exception;
117: end if;

Line 135: UPDATE IGI_itr_charge_center

131: X_Last_Updated_By NUMBER
132: ) IS
133:
134: BEGIN
135: UPDATE IGI_itr_charge_center
136: SET
137:
138: charge_center_id = X_Charge_Center_Id,
139: name = X_Name,

Line 158: DELETE FROM IGI_itr_charge_center

154:
155:
156: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
157: BEGIN
158: DELETE FROM IGI_itr_charge_center
159: WHERE rowid = X_Rowid;
160: if (SQL%NOTFOUND) then
161: Raise NO_DATA_FOUND;
162: end if;

Line 173: FROM igi_itr_charge_center cc

169: x_set_of_books_id NUMBER) IS
170:
171: CURSOR c_dup IS
172: SELECT 'Duplicate'
173: FROM igi_itr_charge_center cc
174: WHERE cc.name = x_name
175: AND cc.set_of_books_id = x_set_of_books_id
176: AND (x_rowid IS NULL
177: OR

Line 192: FND_LOG.MESSAGE(l_error_level,'igi.plsql.igiitrlb.IGI_ITR_CHARGE_CENTER_SS_PKG.check_unique_cc.msg3', FALSE);

188: CLOSE c_dup;
189: fnd_message.set_name('IGI','IGI_ITR_DPL_CC_NAME');
190:
191: IF( l_error_level >= l_debug_level) THEN
192: FND_LOG.MESSAGE(l_error_level,'igi.plsql.igiitrlb.IGI_ITR_CHARGE_CENTER_SS_PKG.check_unique_cc.msg3', FALSE);
193: END IF;
194:
195: app_exception.raise_exception;
196: END IF;

Line 202: END IGI_ITR_CHARGE_CENTER_SS_PKG;

198: CLOSE c_dup;
199:
200: END check_unique_cc;
201:
202: END IGI_ITR_CHARGE_CENTER_SS_PKG;