DBA Data[Home] [Help]

APPS.WF_CORE dependencies on WF_RESOURCES

Line 130: FROM WF_RESOURCES

126: begin
127: -- Get error message and number
128: begin
129: SELECT TEXT INTO mesg_text
130: FROM WF_RESOURCES
131: WHERE TYPE = mtype
132: and NAME = mname
133: and LANGUAGE = userenv('LANG');
134: exception

Line 185: ** in wf_resources. If the NLS_LANG is not set to US,

181: begin
182: /* mjc
183: ** WF_VERSION, WF_SYSTEM_GUID, WF_SYSTEM STATUS should
184: ** not vary by language, and should not have been stored
185: ** in wf_resources. If the NLS_LANG is not set to US,
186: ** then these values cannot be retrieved and the Event
187: ** System will error. To makes sure that the Event System
188: ** does not fail, we are including a check here so that
189: ** we always get these values from the US language.

Line 207: from WF_RESOURCES

203: 'WFBES_MAX_CACHE_SIZE', 'WF_STATUS_MONITOR_APPLET_SIZE') then
204:
205: select TEXT
206: into buf
207: from WF_RESOURCES
208: where TYPE = Get_Message.msgtype
209: and NAME = Get_Message.msgname
210: and LANGUAGE = 'US';
211:

Line 216: from WF_RESOURCES

212: else
213:
214: select TEXT
215: into buf
216: from WF_RESOURCES
217: where TYPE = Get_Message.msgtype
218: and NAME = Get_Message.msgname
219: and LANGUAGE = userenv('LANG');
220:

Line 297: FROM WF_RESOURCES

293: -- Select error number
294: begin
295: SELECT ID
296: INTO wf_core.error_number
297: FROM WF_RESOURCES
298: WHERE TYPE = 'WFERR'
299: and NAME = Raise.name
300: and LANGUAGE = userenv('LANG');
301: exception