APPS.AMW_RL_HIERARCHY_PKG dependencies on WF_ACTIVITIES_VL

Line 2314: cur_name wf_activities_vl.name%type;

2310: x_msg_data out nocopy varchar2)
2311: is
2312: iStart pls_integer := 1;
2313: iEnd pls_integer;
2314: cur_name wf_activities_vl.name%type;
2315: cur_item_type wf_activities_vl.item_type%type;
2316: cur_display_name wf_activities_vl.display_name%type;
2317: cur_description wf_activities_vl.description%type;
2318: cur_instance_id number;

Line 2315: cur_item_type wf_activities_vl.item_type%type;

2311: is
2312: iStart pls_integer := 1;
2313: iEnd pls_integer;
2314: cur_name wf_activities_vl.name%type;
2315: cur_item_type wf_activities_vl.item_type%type;
2316: cur_display_name wf_activities_vl.display_name%type;
2317: cur_description wf_activities_vl.description%type;
2318: cur_instance_id number;
2319:

Line 2316: cur_display_name wf_activities_vl.display_name%type;

2312: iStart pls_integer := 1;
2313: iEnd pls_integer;
2314: cur_name wf_activities_vl.name%type;
2315: cur_item_type wf_activities_vl.item_type%type;
2316: cur_display_name wf_activities_vl.display_name%type;
2317: cur_description wf_activities_vl.description%type;
2318: cur_instance_id number;
2319:
2320:

Line 2317: cur_description wf_activities_vl.description%type;

2313: iEnd pls_integer;
2314: cur_name wf_activities_vl.name%type;
2315: cur_item_type wf_activities_vl.item_type%type;
2316: cur_display_name wf_activities_vl.display_name%type;
2317: cur_description wf_activities_vl.description%type;
2318: cur_instance_id number;
2319:
2320:
2321: begin

Line 2354: from wf_activities_vl

2350:
2351: /* do your processing */
2352: select display_name, description, AMW_CHILD_ORDER_S.nextval
2353: into cur_display_name, cur_description, cur_instance_id
2354: from wf_activities_vl
2355: where name = cur_name
2356: and item_type = cur_item_type
2357: and end_date is null;
2358: