APPS.IGI_IGI_INT_BK_ID_MAP_PKG dependencies on IGI_INT_BK_ID_MAP

Line 1: PACKAGE BODY IGI_IGI_INT_BK_ID_MAP_PKG as

1: PACKAGE BODY IGI_IGI_INT_BK_ID_MAP_PKG as
2: -- $Header: igiintcb.pls 120.7.12000000.1 2007/09/12 09:37:33 mbremkum ship $
3: --
4: l_debug_level number;
5: l_state_level number;

Line 21: CURSOR C IS SELECT rowid FROM igi_int_bk_id_map

17: X_Last_Update_Date DATE,
18: X_Last_Updated_By NUMBER,
19: X_Last_Update_Login NUMBER
20: ) IS
21: CURSOR C IS SELECT rowid FROM igi_int_bk_id_map
22: WHERE feeder_book_id = X_Feeder_Book_Id;
23:
24: BEGIN
25:

Line 27: INSERT INTO igi_int_bk_id_map(

23:
24: BEGIN
25:
26:
27: INSERT INTO igi_int_bk_id_map(
28:
29: feeder_book_id,
30: set_of_books_id,
31: creation_date,

Line 61: FROM igi_int_bk_id_map

57: X_Set_Of_Books_Id NUMBER
58: ) IS
59: CURSOR C IS
60: SELECT *
61: FROM igi_int_bk_id_map
62: WHERE rowid = X_Rowid
63: FOR UPDATE of Feeder_Book_Id NOWAIT;
64: Recinfo C%ROWTYPE;
65:

Line 75: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_igi_int_bk_id_map_pkg.lock_row.Msg1',FALSE);

71: CLOSE C;
72: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
73: -- bug 3199481, start block
74: IF (l_unexp_level >= l_debug_level) THEN
75: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_igi_int_bk_id_map_pkg.lock_row.Msg1',FALSE);
76: END IF;
77: -- bug 3199481, end block
78: APP_EXCEPTION.Raise_Exception;
79: end if;

Line 90: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_igi_int_bk_id_map_pkg.lock_row.Msg2',FALSE);

86: else
87: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
88: -- bug 3199481, start block
89: IF (l_unexp_level >= l_debug_level) THEN
90: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_igi_int_bk_id_map_pkg.lock_row.Msg2',FALSE);
91: END IF;
92: -- bug 3199481, end block
93: APP_EXCEPTION.Raise_Exception;
94: end if;

Line 108: UPDATE igi_int_bk_id_map

104: X_Last_Update_Login NUMBER
105:
106: ) IS
107: BEGIN
108: UPDATE igi_int_bk_id_map
109: SET
110: feeder_book_id = X_Feeder_Book_Id,
111: set_of_books_id = X_Set_Of_Books_Id,
112: last_update_date = X_Last_Update_Date,

Line 123: DELETE FROM igi_int_bk_id_map

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

Line 140: END IGI_IGI_INT_BK_ID_MAP_PKG;

136: l_excep_level := FND_LOG.LEVEL_EXCEPTION ;
137: l_error_level := FND_LOG.LEVEL_ERROR ;
138: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED ;
139:
140: END IGI_IGI_INT_BK_ID_MAP_PKG;