DBA Data[Home] [Help]

APPS.WF_CORE dependencies on WF_RESOURCES

Line 128: FROM WF_RESOURCES

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

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

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

Line 200: from WF_RESOURCES

196: 'WFBES_MAX_CACHE_SIZE') then
197:
198: select TEXT
199: into buf
200: from WF_RESOURCES
201: where TYPE = Get_Message.msgtype
202: and NAME = Get_Message.msgname
203: and LANGUAGE = 'US';
204:

Line 209: from WF_RESOURCES

205: else
206:
207: select TEXT
208: into buf
209: from WF_RESOURCES
210: where TYPE = Get_Message.msgtype
211: and NAME = Get_Message.msgname
212: and LANGUAGE = userenv('LANG');
213:

Line 290: FROM WF_RESOURCES

286: -- Select error number
287: begin
288: SELECT ID
289: INTO wf_core.error_number
290: FROM WF_RESOURCES
291: WHERE TYPE = 'WFERR'
292: and NAME = Raise.name
293: and LANGUAGE = userenv('LANG');
294: exception