APPS.IGI_IGI_ITR_CHARGE_CENTER_PKG dependencies on IGI_ITR_CHARGE_CENTER

Line 1: PACKAGE BODY IGI_IGI_ITR_CHARGE_CENTER_PKG as

1: PACKAGE BODY IGI_IGI_ITR_CHARGE_CENTER_PKG as
2: -- $Header: igiitreb.pls 120.5.12000000.1 2007/09/12 10:30:49 mbremkum ship $
3: --
4:
5:

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: AND set_of_books_id = X_Set_Of_Books_Id;
30: CURSOR C2 IS SELECT IGI_IGI_itr_charge_center_s.nextval FROM sys.dual;
31: BEGIN

Line 30: CURSOR C2 IS SELECT IGI_IGI_itr_charge_center_s.nextval FROM sys.dual;

26: ) IS
27: CURSOR C IS SELECT rowid FROM IGI_ITR_CHARGE_CENTER
28: WHERE charge_center_id = X_Charge_Center_Id
29: AND set_of_books_id = X_Set_Of_Books_Id;
30: CURSOR C2 IS SELECT IGI_IGI_itr_charge_center_s.nextval FROM sys.dual;
31: BEGIN
32: if (X_Charge_Center_Id is NULL) then
33: OPEN C2;
34: FETCH C2 INTO X_Charge_Center_Id;

Line 38: INSERT INTO IGI_ITR_CHARGE_CENTER(

34: FETCH C2 INTO X_Charge_Center_Id;
35: CLOSE C2;
36: end if;
37:
38: INSERT INTO IGI_ITR_CHARGE_CENTER(
39: charge_center_id,
40: name,
41: set_of_books_id,
42: start_date_active,

Line 82: FROM IGI_ITR_CHARGE_CENTER

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

Line 95: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitreb.IGI_IGI_ITR_CHARGE_CENTER_PKG.lock_row.msg1', FALSE);

91: CLOSE C;
92: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
93:
94: IF ( l_excep_level >= l_debug_level) THEN
95: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitreb.IGI_IGI_ITR_CHARGE_CENTER_PKG.lock_row.msg1', FALSE);
96: END IF;
97:
98:
99: APP_EXCEPTION.Raise_Exception;

Line 116: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitreb.IGI_IGI_ITR_CHARGE_CENTER_PKG.lock_row.msg2', FALSE);

112: else
113: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
114:
115: IF ( l_excep_level >= l_debug_level) THEN
116: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitreb.IGI_IGI_ITR_CHARGE_CENTER_PKG.lock_row.msg2', FALSE);
117: END IF;
118:
119: APP_EXCEPTION.Raise_Exception;
120: end if;

Line 136: UPDATE IGI_ITR_CHARGE_CENTER

132: X_Last_Update_Date DATE,
133: X_Last_Updated_By NUMBER
134: ) IS
135: BEGIN
136: UPDATE IGI_ITR_CHARGE_CENTER
137: SET
138: charge_center_id = X_Charge_Center_Id,
139: name = X_Name,
140: set_of_books_id = X_Set_Of_Books_Id,

Line 153: DELETE FROM IGI_ITR_CHARGE_CENTER

149: end if;
150: END Update_Row;
151: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
152: BEGIN
153: DELETE FROM IGI_ITR_CHARGE_CENTER
154: WHERE rowid = X_Rowid;
155: if (SQL%NOTFOUND) then
156: Raise NO_DATA_FOUND;
157: end if;

Line 161: END IGI_IGI_ITR_CHARGE_CENTER_PKG;

157: end if;
158: END Delete_Row;
159:
160:
161: END IGI_IGI_ITR_CHARGE_CENTER_PKG;