PACKAGE: APPS.PO_WF_FUN

Source

1 PACKAGE PO_WF_FUN AUTHID CURRENT_USER AS
2 /* $Header: powffuns.pls 120.0 2005/06/01 20:20:29 appldev noship $ */
3 
4 cursor wf_functions_cursor(x_item_type varchar2) is
5   select distinct substr(wa.function,1,instr(wa.function,'.')-1) package_name,
6          substr(wa.function,instr(wa.function,'.')+1) procedure_name,
7          wa.item_type,
8          wa.name
9   from   wf_activities wa
10   where  wa.type='FUNCTION'
11     and  wa.function like 'PO%'
12     and  wa.item_type like x_item_type;
13 
14 --bug4025028 start
15 -- Removed the hardcoded 'APPS' for the owner and passing it as a parameter to the cursor
16 --bug4025028 end
17 cursor wf_function_codes_cursor(x_package_name  varchar2,
18                                 x_line_s       number,
19                                 x_line_e       number,
20                                 p_apps_schema_name varchar2)  is --bug4025028
21   select text, line
22     from all_source
23    where name = x_package_name
24      and owner= p_apps_schema_name --bug4025028
25      and type='PACKAGE BODY'
26      and line > x_line_s and line < x_line_e
27   and (upper(text) like '%SETITEMATTR%'
28    or  upper(text) like '%GETITEMATTR%'
29    or  upper(text) like '%SETITEMUSERKEY%'
30    or  upper(text) like '%SETITEMOWNER%'
31    or  upper(text) like '%UPDATE %'
32    or upper(text) like '%INSERT %INTO%'  );
33 
34 
35 PROCEDURE PRINT_FUNCTION(x_item_type varchar2);
36 
37 END PO_WF_FUN;