eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_WORKFLOW_UTILITY dependencies on WF_PROCESS_ACTIVITIES

Line 46: (p_actid IN wf_process_activities.instance_id%TYPE

42: -- p_display_name Display Name
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

Line 50: ,p_instance_label OUT NOCOPY wf_process_activities.instance_label%TYPE) is

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: -- --------------------------------------------------------------------------
54: -- csr_wf_activity_details -> selects the activity details used by the

Line 63: ,wf_process_activities wpa

59: ,wav.display_name
60: ,wav.description
61: ,wpa.instance_label
62: from wf_activities_vl wav
63: ,wf_process_activities wpa
64: where wav.item_type = wpa.activity_item_type
65: and wav.name = wpa.activity_name
66: and wpa.instance_id = p_actid
67: and wav.version =

Line 101: (p_actid IN wf_process_activities.instance_id%TYPE)

97: -- ----------------------------------------------------------------------
98: -- |----------------< get_activity_instance_label >----------------------|
99: -- ----------------------------------------------------------------------
100: FUNCTION get_activity_instance_label
101: (p_actid IN wf_process_activities.instance_id%TYPE)
102: RETURN wf_process_activities.instance_label%type IS
103: --
104: -- --------------------------------------------------------------------------
105: -- declare local variables

Line 102: RETURN wf_process_activities.instance_label%type IS

98: -- |----------------< get_activity_instance_label >----------------------|
99: -- ----------------------------------------------------------------------
100: FUNCTION get_activity_instance_label
101: (p_actid IN wf_process_activities.instance_id%TYPE)
102: RETURN wf_process_activities.instance_label%type IS
103: --
104: -- --------------------------------------------------------------------------
105: -- declare local variables
106: -- --------------------------------------------------------------------------

Line 113: l_instance_label wf_process_activities.instance_label%TYPE;

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
117: (p_actid => p_actid

Line 132: ,p_actid IN wf_process_activities.instance_id%TYPE) IS

128: PROCEDURE workflow_transition
129: (p_result IN varchar2
130: ,p_item_type IN wf_items.item_type%TYPE
131: ,p_item_key IN wf_items.item_key%TYPE
132: ,p_actid IN wf_process_activities.instance_id%TYPE) IS
133: --
134: -- --------------------------------------------------------------------------
135: -- declare local variables
136: -- --------------------------------------------------------------------------

Line 140: l_instance_label wf_process_activities.instance_label%type;

136: -- --------------------------------------------------------------------------
137: -- Used for error messages
138: l_proc_name VARCHAR2(200) := g_package||'workflow_transition';
139: -- Instance label of current activity
140: l_instance_label wf_process_activities.instance_label%type;
141: begin
142: -- Get the name of the activity
143: l_instance_label := get_activity_instance_label(p_actid);
144: --

Line 156: (p_actid IN wf_process_activities.instance_id%TYPE)

152: -- ----------------------------------------------------------------------
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

Line 168: l_instance_label wf_process_activities.instance_label%TYPE;

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
172: (p_actid => p_actid