APPS.FND_SIF_DEFINITIONS_PKG dependencies on FND_SIF_DEFINITIONS_TL

Line 59: insert into FND_SIF_DEFINITIONS_TL (

55: 0,
56: FND_GLOBAL.SECURITY_GROUP_ID
57: );
58:
59: insert into FND_SIF_DEFINITIONS_TL (
60: DEFINITION_NAME,
61: DISPLAY_NAME,
62: DESCRIPTION,
63: LANGUAGE,

Line 87: from FND_SIF_DEFINITIONS_TL T

83: from FND_LANGUAGES L
84: where L.INSTALLED_FLAG in ('I', 'B')
85: and not exists
86: (select NULL
87: from FND_SIF_DEFINITIONS_TL T
88: where T.DEFINITION_NAME = X_DEFINITION_NAME
89: and T.LANGUAGE = L.LANGUAGE_CODE);
90:
91: open c;

Line 110: update FND_SIF_DEFINITIONS_TL

106: ) is
107: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
108: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
109: begin
110: update FND_SIF_DEFINITIONS_TL
111: set DISPLAY_NAME = X_DISPLAY_NAME,
112: DESCRIPTION = X_DESCRIPTION,
113: LAST_UPDATE_DATE = l_ludate,
114: LAST_UPDATED_BY = l_luby,

Line 180: insert into FND_SIF_DEFINITIONS_TL (

176: end UPDATE_ROW;
177:
178: procedure ADD_LANGUAGE is
179: begin
180: insert into FND_SIF_DEFINITIONS_TL (
181: DEFINITION_NAME,
182: DISPLAY_NAME,
183: DESCRIPTION,
184: LANGUAGE,

Line 203: from FND_SIF_DEFINITIONS_TL B, FND_LANGUAGES L

199: B.LAST_UPDATE_DATE,
200: B.LAST_UPDATED_BY,
201: B.LAST_UPDATE_LOGIN,
202: B.SECURITY_GROUP_ID
203: from FND_SIF_DEFINITIONS_TL B, FND_LANGUAGES L
204: where L.INSTALLED_FLAG in ('I', 'B')
205: and B.LANGUAGE=userenv('LANG')
206: and not exists
207: (select NULL

Line 208: from FND_SIF_DEFINITIONS_TL T

204: where L.INSTALLED_FLAG in ('I', 'B')
205: and B.LANGUAGE=userenv('LANG')
206: and not exists
207: (select NULL
208: from FND_SIF_DEFINITIONS_TL T
209: where T.DEFINITION_NAME = B.DEFINITION_NAME
210: and T.LANGUAGE = L.LANGUAGE_CODE);
211: end ADD_LANGUAGE;
212: end FND_SIF_DEFINITIONS_PKG;