APPS.WF_WL_RESULT_ATTRIBUTES_PKG dependencies on WF_WL_RESULT_ATTRIBUTES_TL

Line 44: insert into WF_WL_RESULT_ATTRIBUTES_TL (MESSAGE_TYPE,

40: l_luby, --LAST_UPDATED_BY,
41: 0, --LAST_UPDATE_LOGIN,
42: FND_GLOBAL.SECURITY_GROUP_ID);
43:
44: insert into WF_WL_RESULT_ATTRIBUTES_TL (MESSAGE_TYPE,
45: MESSAGE_NAME,
46: CATEGORY ,
47: LABEL ,
48: LANGUAGE ,

Line 72: from WF_WL_RESULT_ATTRIBUTES_TL TL

68: from FND_LANGUAGES L
69: where L.INSTALLED_FLAG in ('I', 'B')
70: and not exists
71: (select NULL
72: from WF_WL_RESULT_ATTRIBUTES_TL TL
73: where TL.MESSAGE_TYPE = X_MESSAGE_TYPE and
74: TL.MESSAGE_NAME = X_MESSAGE_NAME and
75: TL.CATEGORY = X_CATEGORY and
76: TL.LANGUAGE = L.LANGUAGE_CODE);

Line 131: insert into WF_WL_RESULT_ATTRIBUTES_TL (MESSAGE_TYPE,

127: end UPDATE_RESULT_ATTRIBUTE;
128:
129: procedure ADD_LANGUAGE is
130: begin
131: insert into WF_WL_RESULT_ATTRIBUTES_TL (MESSAGE_TYPE,
132: MESSAGE_NAME,
133: CATEGORY ,
134: LABEL ,
135: LANGUAGE ,

Line 155: from WF_WL_RESULT_ATTRIBUTES_TL B, FND_LANGUAGES L

151: B.LAST_UPDATE_DATE,
152: B.LAST_UPDATED_BY,
153: B.LAST_UPDATE_LOGIN,
154: B.SECURITY_GROUP_ID
155: from WF_WL_RESULT_ATTRIBUTES_TL B, FND_LANGUAGES L
156: where L.INSTALLED_FLAG in ('I', 'B')
157: and B.LANGUAGE = userenv('LANG')
158: and not exists
159: (select NULL

Line 160: from WF_WL_RESULT_ATTRIBUTES_TL TL

156: where L.INSTALLED_FLAG in ('I', 'B')
157: and B.LANGUAGE = userenv('LANG')
158: and not exists
159: (select NULL
160: from WF_WL_RESULT_ATTRIBUTES_TL TL
161: where TL.MESSAGE_TYPE = B.MESSAGE_TYPE and
162: TL.MESSAGE_NAME = B.MESSAGE_NAME and
163: TL.CATEGORY = B.CATEGORY and
164: TL.LANGUAGE = L.LANGUAGE_CODE);

Line 180: update WF_WL_RESULT_ATTRIBUTES_TL TL

176: is
177: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
178: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
179: begin
180: update WF_WL_RESULT_ATTRIBUTES_TL TL
181: set TL.LABEL = X_LABEL,
182: TL.SOURCE_LANG = userenv('LANG'),
183: TL.LAST_UPDATE_DATE = l_ludate,
184: TL.LAST_UPDATED_BY = l_luby,