DBA Data[Home] [Help]

APPS.WF_BES_FUNCS dependencies on USER_OBJECTS

Line 91: )v, user_objects uo

87: select queue_handler
88: from wf_agents
89: where queue_handler is not null and
90: instr(upper(name),p_agent_name)=1
91: )v, user_objects uo
92: where uo.object_name = v.queue_handler
93: and uo.object_type = 'PACKAGE BODY'
94: and uo.status = 'VALID';
95:

Line 262: ) v, user_objects uo

258: we.generate_function function
259: from wf_events we
260: where we.generate_function is not null and
261: instr(upper(we.name),p_corrid)=1
262: ) v, user_objects uo
263: where uo.object_name = nvl(v.package_name,v.function) and
264: uo.object_type = decode(v.package_name,null,'FUNCTION','PACKAGE BODY') and
265: uo.status = 'VALID';
266:

Line 278: ) v, user_objects uo

274: instr(upper(we.name),p_corrid)=1 and
275: wes.rule_function is not null and
276: upper(wes.rule_function) not like 'WF_RULE%' and
277: upper(wes.rule_function) not like 'WF_XML%'
278: ) v, user_objects uo
279: where uo.object_name = nvl(v.package_name,v.function) and
280: uo.object_type = decode(v.package_name,null,'FUNCTION','PACKAGE BODY') and
281: uo.status = 'VALID';
282:

Line 295: ) v, user_objects uo

291: (
292: upper(wes.rule_function) like 'WF_RULE%' or
293: upper(wes.rule_function) like 'WF_XML%'
294: )
295: ) v, user_objects uo
296: where uo.object_name = nvl(v.package_name,v.function) and
297: uo.object_type = decode(v.package_name,null,'FUNCTION','PACKAGE BODY') and
298: uo.status = 'VALID';
299: