DBA Data[Home] [Help]

APPS.HR_WORKFLOW_UTILITY dependencies on WF_ACTIVITIES_TL

Line 47: ,p_name OUT NOCOPY wf_activities_tl.name%TYPE

43: -- p_name Activity Name
44: -- p_description Description
45: PROCEDURE get_activity_details
46: (p_actid IN wf_process_activities.instance_id%TYPE
47: ,p_name OUT NOCOPY wf_activities_tl.name%TYPE
48: ,p_display_name OUT NOCOPY wf_activities_tl.display_name%TYPE
49: ,p_description OUT NOCOPY wf_activities_tl.description%TYPE
50: ,p_instance_label OUT NOCOPY wf_process_activities.instance_label%TYPE) is
51: -- --------------------------------------------------------------------------

Line 48: ,p_display_name OUT NOCOPY wf_activities_tl.display_name%TYPE

44: -- p_description Description
45: PROCEDURE get_activity_details
46: (p_actid IN wf_process_activities.instance_id%TYPE
47: ,p_name OUT NOCOPY wf_activities_tl.name%TYPE
48: ,p_display_name OUT NOCOPY wf_activities_tl.display_name%TYPE
49: ,p_description OUT NOCOPY wf_activities_tl.description%TYPE
50: ,p_instance_label OUT NOCOPY wf_process_activities.instance_label%TYPE) is
51: -- --------------------------------------------------------------------------
52: -- local cursor definitions

Line 49: ,p_description OUT NOCOPY wf_activities_tl.description%TYPE

45: PROCEDURE get_activity_details
46: (p_actid IN wf_process_activities.instance_id%TYPE
47: ,p_name OUT NOCOPY wf_activities_tl.name%TYPE
48: ,p_display_name OUT NOCOPY wf_activities_tl.display_name%TYPE
49: ,p_description OUT NOCOPY wf_activities_tl.description%TYPE
50: ,p_instance_label OUT NOCOPY wf_process_activities.instance_label%TYPE) is
51: -- --------------------------------------------------------------------------
52: -- local cursor definitions
53: -- --------------------------------------------------------------------------

Line 110: l_display_name wf_activities_tl.display_name%TYPE;

106: -- --------------------------------------------------------------------------
107: -- Used for error messages
108: l_proc_name VARCHAR2(200) := g_package||'get_activity_name';
109: -- Variables to store the activity details
110: l_display_name wf_activities_tl.display_name%TYPE;
111: l_description wf_activities_tl.description%TYPE;
112: l_name wf_activities_tl.name%TYPE;
113: l_instance_label wf_process_activities.instance_label%TYPE;
114: BEGIN

Line 111: l_description wf_activities_tl.description%TYPE;

107: -- Used for error messages
108: l_proc_name VARCHAR2(200) := g_package||'get_activity_name';
109: -- Variables to store the activity details
110: l_display_name wf_activities_tl.display_name%TYPE;
111: l_description wf_activities_tl.description%TYPE;
112: l_name wf_activities_tl.name%TYPE;
113: l_instance_label wf_process_activities.instance_label%TYPE;
114: BEGIN
115: -- Get the activity details for the given activity

Line 112: l_name wf_activities_tl.name%TYPE;

108: l_proc_name VARCHAR2(200) := g_package||'get_activity_name';
109: -- Variables to store the activity details
110: l_display_name wf_activities_tl.display_name%TYPE;
111: l_description wf_activities_tl.description%TYPE;
112: l_name wf_activities_tl.name%TYPE;
113: l_instance_label wf_process_activities.instance_label%TYPE;
114: BEGIN
115: -- Get the activity details for the given activity
116: get_activity_details

Line 157: RETURN wf_activities_tl.name%type IS

153: -- |----------------< get_activity_name >------------------------|
154: -- ----------------------------------------------------------------------
155: FUNCTION get_activity_name
156: (p_actid IN wf_process_activities.instance_id%TYPE)
157: RETURN wf_activities_tl.name%type IS
158: --
159: -- --------------------------------------------------------------------------
160: -- declare local variables
161: -- --------------------------------------------------------------------------

Line 165: l_display_name wf_activities_tl.display_name%TYPE;

161: -- --------------------------------------------------------------------------
162: -- Used for error messages
163: l_proc_name VARCHAR2(200) := g_package||'get_activity_name';
164: -- Variables to store the activity details
165: l_display_name wf_activities_tl.display_name%TYPE;
166: l_description wf_activities_tl.description%TYPE;
167: l_name wf_activities_tl.name%TYPE;
168: l_instance_label wf_process_activities.instance_label%TYPE;
169: BEGIN

Line 166: l_description wf_activities_tl.description%TYPE;

162: -- Used for error messages
163: l_proc_name VARCHAR2(200) := g_package||'get_activity_name';
164: -- Variables to store the activity details
165: l_display_name wf_activities_tl.display_name%TYPE;
166: l_description wf_activities_tl.description%TYPE;
167: l_name wf_activities_tl.name%TYPE;
168: l_instance_label wf_process_activities.instance_label%TYPE;
169: BEGIN
170: -- Get the activity details for the given activity

Line 167: l_name wf_activities_tl.name%TYPE;

163: l_proc_name VARCHAR2(200) := g_package||'get_activity_name';
164: -- Variables to store the activity details
165: l_display_name wf_activities_tl.display_name%TYPE;
166: l_description wf_activities_tl.description%TYPE;
167: l_name wf_activities_tl.name%TYPE;
168: l_instance_label wf_process_activities.instance_label%TYPE;
169: BEGIN
170: -- Get the activity details for the given activity
171: get_activity_details