APPS.IGI_IGI_ITR_CHARGE_AUTH_PKG dependencies on IGI_ITR_CHARGE_AUTH

Line 1: PACKAGE BODY IGI_IGI_ITR_CHARGE_AUTH_PKG as

1: PACKAGE BODY IGI_IGI_ITR_CHARGE_AUTH_PKG as
2: -- $Header: igiitrdb.pls 120.5.12000000.1 2007/09/12 10:30:42 mbremkum ship $
3: --
4:
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 22: CURSOR C IS SELECT rowid FROM IGI_itr_charge_auth

18: X_Last_Update_Login NUMBER,
19: X_Last_Update_Date DATE,
20: X_Last_Updated_By NUMBER
21: ) IS
22: CURSOR C IS SELECT rowid FROM IGI_itr_charge_auth
23: WHERE charge_center_id = X_Charge_Center_Id
24: AND user_id = X_User_Id;
25:
26: BEGIN

Line 28: INSERT INTO IGI_itr_charge_auth(

24: AND user_id = X_User_Id;
25:
26: BEGIN
27:
28: INSERT INTO IGI_itr_charge_auth(
29: charge_center_id,
30: user_id,
31: creation_date,
32: created_by,

Line 63: FROM IGI_itr_charge_auth

59: ) IS
60:
61: CURSOR C IS
62: SELECT *
63: FROM IGI_itr_charge_auth
64: WHERE rowid = X_Rowid
65: FOR UPDATE of Charge_Center_Id NOWAIT;
66: Recinfo C%ROWTYPE;
67:

Line 76: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrdb.IGI_IGI_ITR_CHARGE_AUTH_PKG.lock_row.msg1', FALSE);

72: CLOSE C;
73: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
74:
75: IF ( l_excep_level >= l_debug_level) THEN
76: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrdb.IGI_IGI_ITR_CHARGE_AUTH_PKG.lock_row.msg1', FALSE);
77: END IF;
78:
79: APP_EXCEPTION.Raise_Exception;
80: end if;

Line 91: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrdb.IGI_IGI_ITR_CHARGE_AUTH_PKG.lock_row.msg2', FALSE);

87: else
88: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
89:
90: IF ( l_excep_level >= l_debug_level) THEN
91: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrdb.IGI_IGI_ITR_CHARGE_AUTH_PKG.lock_row.msg2', FALSE);
92: END IF;
93:
94: APP_EXCEPTION.Raise_Exception;
95: end if;

Line 108: UPDATE IGI_itr_charge_auth

104: X_Last_Update_Date DATE,
105: X_Last_Updated_By NUMBER
106: ) IS
107: BEGIN
108: UPDATE IGI_itr_charge_auth
109: SET
110: charge_center_id = X_Charge_Center_Id,
111: user_id = X_User_Id,
112: last_update_login = X_Last_Update_Login,

Line 123: DELETE FROM IGI_itr_charge_auth

119: end if;
120: END Update_Row;
121: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
122: BEGIN
123: DELETE FROM IGI_itr_charge_auth
124: WHERE rowid = X_Rowid;
125: if (SQL%NOTFOUND) then
126: Raise NO_DATA_FOUND;
127: end if;

Line 131: END IGI_IGI_ITR_CHARGE_AUTH_PKG;

127: end if;
128: END Delete_Row;
129:
130:
131: END IGI_IGI_ITR_CHARGE_AUTH_PKG;