APPS.IGI_IGI_EER_SETUP_PKG dependencies on IGI_EER_SETUP

Line 1: PACKAGE BODY IGI_IGI_EER_SETUP_PKG as

1: PACKAGE BODY IGI_IGI_EER_SETUP_PKG as
2: -- $Header: igihglab.pls 120.4.12000000.1 2007/09/12 10:11:39 mbremkum ship $
3: --following variables added for bug 3199481: fnd logging changes: sdixit
4: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: l_state_level number := FND_LOG.LEVEL_STATEMENT;

Line 26: CURSOR C IS SELECT rowid FROM IGI_EER_SETUP

22: X_Last_Update_Date DATE,
23: X_Last_Updated_By NUMBER,
24: X_Last_Update_Login NUMBER
25: ) IS
26: CURSOR C IS SELECT rowid FROM IGI_EER_SETUP
27: WHERE gl_set_of_books_id = X_Gl_Set_Of_Books_Id;
28: BEGIN
29: INSERT INTO IGI_EER_SETUP(
30: gl_set_of_books_id,

Line 29: INSERT INTO IGI_EER_SETUP(

25: ) IS
26: CURSOR C IS SELECT rowid FROM IGI_EER_SETUP
27: WHERE gl_set_of_books_id = X_Gl_Set_Of_Books_Id;
28: BEGIN
29: INSERT INTO IGI_EER_SETUP(
30: gl_set_of_books_id,
31: level_1,
32: level_2,
33: level_3,

Line 77: FROM IGI_EER_SETUP

73: X_Level_6 NUMBER
74: ) IS
75: CURSOR C IS
76: SELECT *
77: FROM IGI_EER_SETUP
78: WHERE rowid = X_Rowid
79: FOR UPDATE of Gl_Set_Of_Books_Id NOWAIT;
80: Recinfo C%ROWTYPE;
81:

Line 134: UPDATE IGI_EER_SETUP

130: X_Last_Updated_By NUMBER,
131: X_Last_Update_Login NUMBER
132: ) IS
133: BEGIN
134: UPDATE IGI_EER_SETUP
135: SET
136: gl_set_of_books_id = X_Gl_Set_Of_Books_Id,
137: level_1 = X_Level_1,
138: level_2 = X_Level_2,

Line 153: END IGI_IGI_EER_SETUP_PKG;

149: Raise NO_DATA_FOUND;
150: end if;
151: END Update_Row;
152:
153: END IGI_IGI_EER_SETUP_PKG;