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.WF_ACTIVITY dependencies on WF_CACHE

Line 76: WF_CACHE.GetProcessActivityInfo(actid, actdate, status, waIND);

72: return;
73: end if;
74:
75: -- Checking global cache.
76: WF_CACHE.GetProcessActivityInfo(actid, actdate, status, waIND);
77:
78: if (status <> WF_CACHE.task_SUCCESS) then
79: waIND := 0;
80:

Line 78: if (status <> WF_CACHE.task_SUCCESS) then

74:
75: -- Checking global cache.
76: WF_CACHE.GetProcessActivityInfo(actid, actdate, status, waIND);
77:
78: if (status <> WF_CACHE.task_SUCCESS) then
79: waIND := 0;
80:
81: select WA.ITEM_TYPE, WA.NAME, WA.VERSION, WA.TYPE, WA.RERUN,
82: WA.EXPAND_ROLE, WA.COST, WA.ERROR_ITEM_TYPE, WA.ERROR_PROCESS,

Line 90: into WF_CACHE.Activities(waIND).ITEM_TYPE,

86: WPA.ACTIVITY_NAME, WPA.INSTANCE_ID, WPA.INSTANCE_LABEL,
87: WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE, WPA.START_END,
88: WPA.DEFAULT_RESULT
89:
90: into WF_CACHE.Activities(waIND).ITEM_TYPE,
91: WF_CACHE.Activities(waIND).NAME,
92: WF_CACHE.Activities(waIND).VERSION,
93: WF_CACHE.Activities(waIND).TYPE,
94: WF_CACHE.Activities(waIND).RERUN,

Line 91: WF_CACHE.Activities(waIND).NAME,

87: WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE, WPA.START_END,
88: WPA.DEFAULT_RESULT
89:
90: into WF_CACHE.Activities(waIND).ITEM_TYPE,
91: WF_CACHE.Activities(waIND).NAME,
92: WF_CACHE.Activities(waIND).VERSION,
93: WF_CACHE.Activities(waIND).TYPE,
94: WF_CACHE.Activities(waIND).RERUN,
95: WF_CACHE.Activities(waIND).EXPAND_ROLE,

Line 92: WF_CACHE.Activities(waIND).VERSION,

88: WPA.DEFAULT_RESULT
89:
90: into WF_CACHE.Activities(waIND).ITEM_TYPE,
91: WF_CACHE.Activities(waIND).NAME,
92: WF_CACHE.Activities(waIND).VERSION,
93: WF_CACHE.Activities(waIND).TYPE,
94: WF_CACHE.Activities(waIND).RERUN,
95: WF_CACHE.Activities(waIND).EXPAND_ROLE,
96: WF_CACHE.Activities(waIND).COST,

Line 93: WF_CACHE.Activities(waIND).TYPE,

89:
90: into WF_CACHE.Activities(waIND).ITEM_TYPE,
91: WF_CACHE.Activities(waIND).NAME,
92: WF_CACHE.Activities(waIND).VERSION,
93: WF_CACHE.Activities(waIND).TYPE,
94: WF_CACHE.Activities(waIND).RERUN,
95: WF_CACHE.Activities(waIND).EXPAND_ROLE,
96: WF_CACHE.Activities(waIND).COST,
97: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,

Line 94: WF_CACHE.Activities(waIND).RERUN,

90: into WF_CACHE.Activities(waIND).ITEM_TYPE,
91: WF_CACHE.Activities(waIND).NAME,
92: WF_CACHE.Activities(waIND).VERSION,
93: WF_CACHE.Activities(waIND).TYPE,
94: WF_CACHE.Activities(waIND).RERUN,
95: WF_CACHE.Activities(waIND).EXPAND_ROLE,
96: WF_CACHE.Activities(waIND).COST,
97: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
98: WF_CACHE.Activities(waIND).ERROR_PROCESS,

Line 95: WF_CACHE.Activities(waIND).EXPAND_ROLE,

91: WF_CACHE.Activities(waIND).NAME,
92: WF_CACHE.Activities(waIND).VERSION,
93: WF_CACHE.Activities(waIND).TYPE,
94: WF_CACHE.Activities(waIND).RERUN,
95: WF_CACHE.Activities(waIND).EXPAND_ROLE,
96: WF_CACHE.Activities(waIND).COST,
97: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
98: WF_CACHE.Activities(waIND).ERROR_PROCESS,
99: WF_CACHE.Activities(waIND).FUNCTION,

Line 96: WF_CACHE.Activities(waIND).COST,

92: WF_CACHE.Activities(waIND).VERSION,
93: WF_CACHE.Activities(waIND).TYPE,
94: WF_CACHE.Activities(waIND).RERUN,
95: WF_CACHE.Activities(waIND).EXPAND_ROLE,
96: WF_CACHE.Activities(waIND).COST,
97: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
98: WF_CACHE.Activities(waIND).ERROR_PROCESS,
99: WF_CACHE.Activities(waIND).FUNCTION,
100: WF_CACHE.Activities(waIND).FUNCTION_TYPE,

Line 97: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,

93: WF_CACHE.Activities(waIND).TYPE,
94: WF_CACHE.Activities(waIND).RERUN,
95: WF_CACHE.Activities(waIND).EXPAND_ROLE,
96: WF_CACHE.Activities(waIND).COST,
97: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
98: WF_CACHE.Activities(waIND).ERROR_PROCESS,
99: WF_CACHE.Activities(waIND).FUNCTION,
100: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
101: WF_CACHE.Activities(waIND).MESSAGE,

Line 98: WF_CACHE.Activities(waIND).ERROR_PROCESS,

94: WF_CACHE.Activities(waIND).RERUN,
95: WF_CACHE.Activities(waIND).EXPAND_ROLE,
96: WF_CACHE.Activities(waIND).COST,
97: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
98: WF_CACHE.Activities(waIND).ERROR_PROCESS,
99: WF_CACHE.Activities(waIND).FUNCTION,
100: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
101: WF_CACHE.Activities(waIND).MESSAGE,
102: WF_CACHE.Activities(waIND).BEGIN_DATE,

Line 99: WF_CACHE.Activities(waIND).FUNCTION,

95: WF_CACHE.Activities(waIND).EXPAND_ROLE,
96: WF_CACHE.Activities(waIND).COST,
97: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
98: WF_CACHE.Activities(waIND).ERROR_PROCESS,
99: WF_CACHE.Activities(waIND).FUNCTION,
100: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
101: WF_CACHE.Activities(waIND).MESSAGE,
102: WF_CACHE.Activities(waIND).BEGIN_DATE,
103: WF_CACHE.Activities(waIND).END_DATE,

Line 100: WF_CACHE.Activities(waIND).FUNCTION_TYPE,

96: WF_CACHE.Activities(waIND).COST,
97: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
98: WF_CACHE.Activities(waIND).ERROR_PROCESS,
99: WF_CACHE.Activities(waIND).FUNCTION,
100: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
101: WF_CACHE.Activities(waIND).MESSAGE,
102: WF_CACHE.Activities(waIND).BEGIN_DATE,
103: WF_CACHE.Activities(waIND).END_DATE,
104: WF_CACHE.Activities(waIND).DIRECTION,

Line 101: WF_CACHE.Activities(waIND).MESSAGE,

97: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
98: WF_CACHE.Activities(waIND).ERROR_PROCESS,
99: WF_CACHE.Activities(waIND).FUNCTION,
100: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
101: WF_CACHE.Activities(waIND).MESSAGE,
102: WF_CACHE.Activities(waIND).BEGIN_DATE,
103: WF_CACHE.Activities(waIND).END_DATE,
104: WF_CACHE.Activities(waIND).DIRECTION,
105: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,

Line 102: WF_CACHE.Activities(waIND).BEGIN_DATE,

98: WF_CACHE.Activities(waIND).ERROR_PROCESS,
99: WF_CACHE.Activities(waIND).FUNCTION,
100: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
101: WF_CACHE.Activities(waIND).MESSAGE,
102: WF_CACHE.Activities(waIND).BEGIN_DATE,
103: WF_CACHE.Activities(waIND).END_DATE,
104: WF_CACHE.Activities(waIND).DIRECTION,
105: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
106: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,

Line 103: WF_CACHE.Activities(waIND).END_DATE,

99: WF_CACHE.Activities(waIND).FUNCTION,
100: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
101: WF_CACHE.Activities(waIND).MESSAGE,
102: WF_CACHE.Activities(waIND).BEGIN_DATE,
103: WF_CACHE.Activities(waIND).END_DATE,
104: WF_CACHE.Activities(waIND).DIRECTION,
105: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
106: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
107: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,

Line 104: WF_CACHE.Activities(waIND).DIRECTION,

100: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
101: WF_CACHE.Activities(waIND).MESSAGE,
102: WF_CACHE.Activities(waIND).BEGIN_DATE,
103: WF_CACHE.Activities(waIND).END_DATE,
104: WF_CACHE.Activities(waIND).DIRECTION,
105: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
106: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
107: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
108: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,

Line 105: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,

101: WF_CACHE.Activities(waIND).MESSAGE,
102: WF_CACHE.Activities(waIND).BEGIN_DATE,
103: WF_CACHE.Activities(waIND).END_DATE,
104: WF_CACHE.Activities(waIND).DIRECTION,
105: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
106: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
107: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
108: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
109: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,

Line 106: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,

102: WF_CACHE.Activities(waIND).BEGIN_DATE,
103: WF_CACHE.Activities(waIND).END_DATE,
104: WF_CACHE.Activities(waIND).DIRECTION,
105: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
106: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
107: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
108: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
109: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
110: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,

Line 107: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,

103: WF_CACHE.Activities(waIND).END_DATE,
104: WF_CACHE.Activities(waIND).DIRECTION,
105: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
106: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
107: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
108: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
109: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
110: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
111: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,

Line 108: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,

104: WF_CACHE.Activities(waIND).DIRECTION,
105: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
106: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
107: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
108: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
109: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
110: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
111: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
112: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,

Line 109: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,

105: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
106: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
107: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
108: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
109: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
110: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
111: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
112: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
113: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,

Line 110: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,

106: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
107: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
108: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
109: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
110: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
111: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
112: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
113: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
114: WF_CACHE.ProcessActivities(actid).START_END,

Line 111: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,

107: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
108: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
109: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
110: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
111: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
112: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
113: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
114: WF_CACHE.ProcessActivities(actid).START_END,
115: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT

Line 112: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,

108: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
109: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
110: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
111: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
112: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
113: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
114: WF_CACHE.ProcessActivities(actid).START_END,
115: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
116:

Line 113: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,

109: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
110: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
111: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
112: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
113: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
114: WF_CACHE.ProcessActivities(actid).START_END,
115: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
116:
117: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA

Line 114: WF_CACHE.ProcessActivities(actid).START_END,

110: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
111: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
112: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
113: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
114: WF_CACHE.ProcessActivities(actid).START_END,
115: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
116:
117: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA
118:

Line 115: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT

111: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
112: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
113: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
114: WF_CACHE.ProcessActivities(actid).START_END,
115: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
116:
117: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA
118:
119: where WPA.INSTANCE_ID = actid

Line 126: WF_CACHE.HashKey(WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE ||

122: and actdate >= WA.BEGIN_DATE
123: and actdate < NVL(WA.END_DATE, actdate+1);
124:
125: waIND :=
126: WF_CACHE.HashKey(WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE ||
127: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
128:
129: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
130:

Line 127: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);

123: and actdate < NVL(WA.END_DATE, actdate+1);
124:
125: waIND :=
126: WF_CACHE.HashKey(WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE ||
127: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
128:
129: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
130:
131: end if;

Line 129: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);

125: waIND :=
126: WF_CACHE.HashKey(WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE ||
127: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
128:
129: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
130:
131: end if;
132:
133: wf_activity.c_type := WF_CACHE.Activities(waIND).TYPE;

Line 133: wf_activity.c_type := WF_CACHE.Activities(waIND).TYPE;

129: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
130:
131: end if;
132:
133: wf_activity.c_type := WF_CACHE.Activities(waIND).TYPE;
134: wf_activity.c_rerun := WF_CACHE.Activities(waIND).RERUN;
135: wf_activity.c_cost := WF_CACHE.Activities(waIND).COST;
136: wf_activity.c_error_type := WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE;
137: wf_activity.c_error_process := WF_CACHE.Activities(waIND).ERROR_PROCESS;

Line 134: wf_activity.c_rerun := WF_CACHE.Activities(waIND).RERUN;

130:
131: end if;
132:
133: wf_activity.c_type := WF_CACHE.Activities(waIND).TYPE;
134: wf_activity.c_rerun := WF_CACHE.Activities(waIND).RERUN;
135: wf_activity.c_cost := WF_CACHE.Activities(waIND).COST;
136: wf_activity.c_error_type := WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE;
137: wf_activity.c_error_process := WF_CACHE.Activities(waIND).ERROR_PROCESS;
138: wf_activity.c_expand_role := WF_CACHE.Activities(waIND).EXPAND_ROLE;

Line 135: wf_activity.c_cost := WF_CACHE.Activities(waIND).COST;

131: end if;
132:
133: wf_activity.c_type := WF_CACHE.Activities(waIND).TYPE;
134: wf_activity.c_rerun := WF_CACHE.Activities(waIND).RERUN;
135: wf_activity.c_cost := WF_CACHE.Activities(waIND).COST;
136: wf_activity.c_error_type := WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE;
137: wf_activity.c_error_process := WF_CACHE.Activities(waIND).ERROR_PROCESS;
138: wf_activity.c_expand_role := WF_CACHE.Activities(waIND).EXPAND_ROLE;
139: wf_activity.c_function := WF_CACHE.Activities(waIND).FUNCTION;

Line 136: wf_activity.c_error_type := WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE;

132:
133: wf_activity.c_type := WF_CACHE.Activities(waIND).TYPE;
134: wf_activity.c_rerun := WF_CACHE.Activities(waIND).RERUN;
135: wf_activity.c_cost := WF_CACHE.Activities(waIND).COST;
136: wf_activity.c_error_type := WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE;
137: wf_activity.c_error_process := WF_CACHE.Activities(waIND).ERROR_PROCESS;
138: wf_activity.c_expand_role := WF_CACHE.Activities(waIND).EXPAND_ROLE;
139: wf_activity.c_function := WF_CACHE.Activities(waIND).FUNCTION;
140: wf_activity.c_function_type := nvl(WF_CACHE.Activities(waIND).FUNCTION_TYPE,

Line 137: wf_activity.c_error_process := WF_CACHE.Activities(waIND).ERROR_PROCESS;

133: wf_activity.c_type := WF_CACHE.Activities(waIND).TYPE;
134: wf_activity.c_rerun := WF_CACHE.Activities(waIND).RERUN;
135: wf_activity.c_cost := WF_CACHE.Activities(waIND).COST;
136: wf_activity.c_error_type := WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE;
137: wf_activity.c_error_process := WF_CACHE.Activities(waIND).ERROR_PROCESS;
138: wf_activity.c_expand_role := WF_CACHE.Activities(waIND).EXPAND_ROLE;
139: wf_activity.c_function := WF_CACHE.Activities(waIND).FUNCTION;
140: wf_activity.c_function_type := nvl(WF_CACHE.Activities(waIND).FUNCTION_TYPE,
141: 'PL/SQL');

Line 138: wf_activity.c_expand_role := WF_CACHE.Activities(waIND).EXPAND_ROLE;

134: wf_activity.c_rerun := WF_CACHE.Activities(waIND).RERUN;
135: wf_activity.c_cost := WF_CACHE.Activities(waIND).COST;
136: wf_activity.c_error_type := WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE;
137: wf_activity.c_error_process := WF_CACHE.Activities(waIND).ERROR_PROCESS;
138: wf_activity.c_expand_role := WF_CACHE.Activities(waIND).EXPAND_ROLE;
139: wf_activity.c_function := WF_CACHE.Activities(waIND).FUNCTION;
140: wf_activity.c_function_type := nvl(WF_CACHE.Activities(waIND).FUNCTION_TYPE,
141: 'PL/SQL');
142: wf_activity.c_message := WF_CACHE.Activities(waIND).MESSAGE;

Line 139: wf_activity.c_function := WF_CACHE.Activities(waIND).FUNCTION;

135: wf_activity.c_cost := WF_CACHE.Activities(waIND).COST;
136: wf_activity.c_error_type := WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE;
137: wf_activity.c_error_process := WF_CACHE.Activities(waIND).ERROR_PROCESS;
138: wf_activity.c_expand_role := WF_CACHE.Activities(waIND).EXPAND_ROLE;
139: wf_activity.c_function := WF_CACHE.Activities(waIND).FUNCTION;
140: wf_activity.c_function_type := nvl(WF_CACHE.Activities(waIND).FUNCTION_TYPE,
141: 'PL/SQL');
142: wf_activity.c_message := WF_CACHE.Activities(waIND).MESSAGE;
143: wf_activity.c_msgtype := WF_CACHE.Activities(waIND).ITEM_TYPE;

Line 140: wf_activity.c_function_type := nvl(WF_CACHE.Activities(waIND).FUNCTION_TYPE,

136: wf_activity.c_error_type := WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE;
137: wf_activity.c_error_process := WF_CACHE.Activities(waIND).ERROR_PROCESS;
138: wf_activity.c_expand_role := WF_CACHE.Activities(waIND).EXPAND_ROLE;
139: wf_activity.c_function := WF_CACHE.Activities(waIND).FUNCTION;
140: wf_activity.c_function_type := nvl(WF_CACHE.Activities(waIND).FUNCTION_TYPE,
141: 'PL/SQL');
142: wf_activity.c_message := WF_CACHE.Activities(waIND).MESSAGE;
143: wf_activity.c_msgtype := WF_CACHE.Activities(waIND).ITEM_TYPE;
144: wf_activity.c_event_name := WF_CACHE.Activities(waIND).EVENT_NAME;

Line 142: wf_activity.c_message := WF_CACHE.Activities(waIND).MESSAGE;

138: wf_activity.c_expand_role := WF_CACHE.Activities(waIND).EXPAND_ROLE;
139: wf_activity.c_function := WF_CACHE.Activities(waIND).FUNCTION;
140: wf_activity.c_function_type := nvl(WF_CACHE.Activities(waIND).FUNCTION_TYPE,
141: 'PL/SQL');
142: wf_activity.c_message := WF_CACHE.Activities(waIND).MESSAGE;
143: wf_activity.c_msgtype := WF_CACHE.Activities(waIND).ITEM_TYPE;
144: wf_activity.c_event_name := WF_CACHE.Activities(waIND).EVENT_NAME;
145: wf_activity.c_direction := WF_CACHE.Activities(waIND).DIRECTION;
146: wf_activity.c_prole := WF_CACHE.ProcessActivities(actid).PERFORM_ROLE;

Line 143: wf_activity.c_msgtype := WF_CACHE.Activities(waIND).ITEM_TYPE;

139: wf_activity.c_function := WF_CACHE.Activities(waIND).FUNCTION;
140: wf_activity.c_function_type := nvl(WF_CACHE.Activities(waIND).FUNCTION_TYPE,
141: 'PL/SQL');
142: wf_activity.c_message := WF_CACHE.Activities(waIND).MESSAGE;
143: wf_activity.c_msgtype := WF_CACHE.Activities(waIND).ITEM_TYPE;
144: wf_activity.c_event_name := WF_CACHE.Activities(waIND).EVENT_NAME;
145: wf_activity.c_direction := WF_CACHE.Activities(waIND).DIRECTION;
146: wf_activity.c_prole := WF_CACHE.ProcessActivities(actid).PERFORM_ROLE;
147: wf_activity.c_prole_type := WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE;

Line 144: wf_activity.c_event_name := WF_CACHE.Activities(waIND).EVENT_NAME;

140: wf_activity.c_function_type := nvl(WF_CACHE.Activities(waIND).FUNCTION_TYPE,
141: 'PL/SQL');
142: wf_activity.c_message := WF_CACHE.Activities(waIND).MESSAGE;
143: wf_activity.c_msgtype := WF_CACHE.Activities(waIND).ITEM_TYPE;
144: wf_activity.c_event_name := WF_CACHE.Activities(waIND).EVENT_NAME;
145: wf_activity.c_direction := WF_CACHE.Activities(waIND).DIRECTION;
146: wf_activity.c_prole := WF_CACHE.ProcessActivities(actid).PERFORM_ROLE;
147: wf_activity.c_prole_type := WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE;
148: wf_activity.c_start_end := WF_CACHE.ProcessActivities(actid).START_END;

Line 145: wf_activity.c_direction := WF_CACHE.Activities(waIND).DIRECTION;

141: 'PL/SQL');
142: wf_activity.c_message := WF_CACHE.Activities(waIND).MESSAGE;
143: wf_activity.c_msgtype := WF_CACHE.Activities(waIND).ITEM_TYPE;
144: wf_activity.c_event_name := WF_CACHE.Activities(waIND).EVENT_NAME;
145: wf_activity.c_direction := WF_CACHE.Activities(waIND).DIRECTION;
146: wf_activity.c_prole := WF_CACHE.ProcessActivities(actid).PERFORM_ROLE;
147: wf_activity.c_prole_type := WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE;
148: wf_activity.c_start_end := WF_CACHE.ProcessActivities(actid).START_END;
149:

Line 146: wf_activity.c_prole := WF_CACHE.ProcessActivities(actid).PERFORM_ROLE;

142: wf_activity.c_message := WF_CACHE.Activities(waIND).MESSAGE;
143: wf_activity.c_msgtype := WF_CACHE.Activities(waIND).ITEM_TYPE;
144: wf_activity.c_event_name := WF_CACHE.Activities(waIND).EVENT_NAME;
145: wf_activity.c_direction := WF_CACHE.Activities(waIND).DIRECTION;
146: wf_activity.c_prole := WF_CACHE.ProcessActivities(actid).PERFORM_ROLE;
147: wf_activity.c_prole_type := WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE;
148: wf_activity.c_start_end := WF_CACHE.ProcessActivities(actid).START_END;
149:
150: -- Save cache key values

Line 147: wf_activity.c_prole_type := WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE;

143: wf_activity.c_msgtype := WF_CACHE.Activities(waIND).ITEM_TYPE;
144: wf_activity.c_event_name := WF_CACHE.Activities(waIND).EVENT_NAME;
145: wf_activity.c_direction := WF_CACHE.Activities(waIND).DIRECTION;
146: wf_activity.c_prole := WF_CACHE.ProcessActivities(actid).PERFORM_ROLE;
147: wf_activity.c_prole_type := WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE;
148: wf_activity.c_start_end := WF_CACHE.ProcessActivities(actid).START_END;
149:
150: -- Save cache key values
151: wf_activity.c_actid := actid;

Line 148: wf_activity.c_start_end := WF_CACHE.ProcessActivities(actid).START_END;

144: wf_activity.c_event_name := WF_CACHE.Activities(waIND).EVENT_NAME;
145: wf_activity.c_direction := WF_CACHE.Activities(waIND).DIRECTION;
146: wf_activity.c_prole := WF_CACHE.ProcessActivities(actid).PERFORM_ROLE;
147: wf_activity.c_prole_type := WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE;
148: wf_activity.c_start_end := WF_CACHE.ProcessActivities(actid).START_END;
149:
150: -- Save cache key values
151: wf_activity.c_actid := actid;
152: wf_activity.c_actdate := actdate;

Line 210: WF_CACHE.GetActivity(itemtype, activity, actdate, status, waIND);

206: waIND NUMBER;
207: status PLS_INTEGER;
208:
209: begin
210: WF_CACHE.GetActivity(itemtype, activity, actdate, status, waIND);
211:
212: if (status <> WF_CACHE.task_SUCCESS) then
213:
214: select WA.ITEM_TYPE, WA.NAME, WA.VERSION, WA.TYPE, WA.RERUN,

Line 212: if (status <> WF_CACHE.task_SUCCESS) then

208:
209: begin
210: WF_CACHE.GetActivity(itemtype, activity, actdate, status, waIND);
211:
212: if (status <> WF_CACHE.task_SUCCESS) then
213:
214: select WA.ITEM_TYPE, WA.NAME, WA.VERSION, WA.TYPE, WA.RERUN,
215: WA.EXPAND_ROLE, WA.COST, WA.ERROR_ITEM_TYPE,
216: WA.ERROR_PROCESS, WA.FUNCTION, WA.FUNCTION_TYPE, WA.EVENT_NAME,

Line 219: into WF_CACHE.Activities(waIND).ITEM_TYPE,

215: WA.EXPAND_ROLE, WA.COST, WA.ERROR_ITEM_TYPE,
216: WA.ERROR_PROCESS, WA.FUNCTION, WA.FUNCTION_TYPE, WA.EVENT_NAME,
217: WA.MESSAGE, WA.BEGIN_DATE, WA.END_DATE, WA.DIRECTION
218:
219: into WF_CACHE.Activities(waIND).ITEM_TYPE,
220: WF_CACHE.Activities(waIND).NAME,
221: WF_CACHE.Activities(waIND).VERSION,
222: WF_CACHE.Activities(waIND).TYPE,
223: WF_CACHE.Activities(waIND).RERUN,

Line 220: WF_CACHE.Activities(waIND).NAME,

216: WA.ERROR_PROCESS, WA.FUNCTION, WA.FUNCTION_TYPE, WA.EVENT_NAME,
217: WA.MESSAGE, WA.BEGIN_DATE, WA.END_DATE, WA.DIRECTION
218:
219: into WF_CACHE.Activities(waIND).ITEM_TYPE,
220: WF_CACHE.Activities(waIND).NAME,
221: WF_CACHE.Activities(waIND).VERSION,
222: WF_CACHE.Activities(waIND).TYPE,
223: WF_CACHE.Activities(waIND).RERUN,
224: WF_CACHE.Activities(waIND).EXPAND_ROLE,

Line 221: WF_CACHE.Activities(waIND).VERSION,

217: WA.MESSAGE, WA.BEGIN_DATE, WA.END_DATE, WA.DIRECTION
218:
219: into WF_CACHE.Activities(waIND).ITEM_TYPE,
220: WF_CACHE.Activities(waIND).NAME,
221: WF_CACHE.Activities(waIND).VERSION,
222: WF_CACHE.Activities(waIND).TYPE,
223: WF_CACHE.Activities(waIND).RERUN,
224: WF_CACHE.Activities(waIND).EXPAND_ROLE,
225: WF_CACHE.Activities(waIND).COST,

Line 222: WF_CACHE.Activities(waIND).TYPE,

218:
219: into WF_CACHE.Activities(waIND).ITEM_TYPE,
220: WF_CACHE.Activities(waIND).NAME,
221: WF_CACHE.Activities(waIND).VERSION,
222: WF_CACHE.Activities(waIND).TYPE,
223: WF_CACHE.Activities(waIND).RERUN,
224: WF_CACHE.Activities(waIND).EXPAND_ROLE,
225: WF_CACHE.Activities(waIND).COST,
226: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,

Line 223: WF_CACHE.Activities(waIND).RERUN,

219: into WF_CACHE.Activities(waIND).ITEM_TYPE,
220: WF_CACHE.Activities(waIND).NAME,
221: WF_CACHE.Activities(waIND).VERSION,
222: WF_CACHE.Activities(waIND).TYPE,
223: WF_CACHE.Activities(waIND).RERUN,
224: WF_CACHE.Activities(waIND).EXPAND_ROLE,
225: WF_CACHE.Activities(waIND).COST,
226: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
227: WF_CACHE.Activities(waIND).ERROR_PROCESS,

Line 224: WF_CACHE.Activities(waIND).EXPAND_ROLE,

220: WF_CACHE.Activities(waIND).NAME,
221: WF_CACHE.Activities(waIND).VERSION,
222: WF_CACHE.Activities(waIND).TYPE,
223: WF_CACHE.Activities(waIND).RERUN,
224: WF_CACHE.Activities(waIND).EXPAND_ROLE,
225: WF_CACHE.Activities(waIND).COST,
226: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
227: WF_CACHE.Activities(waIND).ERROR_PROCESS,
228: WF_CACHE.Activities(waIND).FUNCTION,

Line 225: WF_CACHE.Activities(waIND).COST,

221: WF_CACHE.Activities(waIND).VERSION,
222: WF_CACHE.Activities(waIND).TYPE,
223: WF_CACHE.Activities(waIND).RERUN,
224: WF_CACHE.Activities(waIND).EXPAND_ROLE,
225: WF_CACHE.Activities(waIND).COST,
226: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
227: WF_CACHE.Activities(waIND).ERROR_PROCESS,
228: WF_CACHE.Activities(waIND).FUNCTION,
229: WF_CACHE.Activities(waIND).FUNCTION_TYPE,

Line 226: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,

222: WF_CACHE.Activities(waIND).TYPE,
223: WF_CACHE.Activities(waIND).RERUN,
224: WF_CACHE.Activities(waIND).EXPAND_ROLE,
225: WF_CACHE.Activities(waIND).COST,
226: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
227: WF_CACHE.Activities(waIND).ERROR_PROCESS,
228: WF_CACHE.Activities(waIND).FUNCTION,
229: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
230: WF_CACHE.Activities(waIND).EVENT_NAME,

Line 227: WF_CACHE.Activities(waIND).ERROR_PROCESS,

223: WF_CACHE.Activities(waIND).RERUN,
224: WF_CACHE.Activities(waIND).EXPAND_ROLE,
225: WF_CACHE.Activities(waIND).COST,
226: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
227: WF_CACHE.Activities(waIND).ERROR_PROCESS,
228: WF_CACHE.Activities(waIND).FUNCTION,
229: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
230: WF_CACHE.Activities(waIND).EVENT_NAME,
231: WF_CACHE.Activities(waIND).MESSAGE,

Line 228: WF_CACHE.Activities(waIND).FUNCTION,

224: WF_CACHE.Activities(waIND).EXPAND_ROLE,
225: WF_CACHE.Activities(waIND).COST,
226: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
227: WF_CACHE.Activities(waIND).ERROR_PROCESS,
228: WF_CACHE.Activities(waIND).FUNCTION,
229: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
230: WF_CACHE.Activities(waIND).EVENT_NAME,
231: WF_CACHE.Activities(waIND).MESSAGE,
232: WF_CACHE.Activities(waIND).BEGIN_DATE,

Line 229: WF_CACHE.Activities(waIND).FUNCTION_TYPE,

225: WF_CACHE.Activities(waIND).COST,
226: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
227: WF_CACHE.Activities(waIND).ERROR_PROCESS,
228: WF_CACHE.Activities(waIND).FUNCTION,
229: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
230: WF_CACHE.Activities(waIND).EVENT_NAME,
231: WF_CACHE.Activities(waIND).MESSAGE,
232: WF_CACHE.Activities(waIND).BEGIN_DATE,
233: WF_CACHE.Activities(waIND).END_DATE,

Line 230: WF_CACHE.Activities(waIND).EVENT_NAME,

226: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
227: WF_CACHE.Activities(waIND).ERROR_PROCESS,
228: WF_CACHE.Activities(waIND).FUNCTION,
229: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
230: WF_CACHE.Activities(waIND).EVENT_NAME,
231: WF_CACHE.Activities(waIND).MESSAGE,
232: WF_CACHE.Activities(waIND).BEGIN_DATE,
233: WF_CACHE.Activities(waIND).END_DATE,
234: WF_CACHE.Activities(waIND).DIRECTION

Line 231: WF_CACHE.Activities(waIND).MESSAGE,

227: WF_CACHE.Activities(waIND).ERROR_PROCESS,
228: WF_CACHE.Activities(waIND).FUNCTION,
229: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
230: WF_CACHE.Activities(waIND).EVENT_NAME,
231: WF_CACHE.Activities(waIND).MESSAGE,
232: WF_CACHE.Activities(waIND).BEGIN_DATE,
233: WF_CACHE.Activities(waIND).END_DATE,
234: WF_CACHE.Activities(waIND).DIRECTION
235:

Line 232: WF_CACHE.Activities(waIND).BEGIN_DATE,

228: WF_CACHE.Activities(waIND).FUNCTION,
229: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
230: WF_CACHE.Activities(waIND).EVENT_NAME,
231: WF_CACHE.Activities(waIND).MESSAGE,
232: WF_CACHE.Activities(waIND).BEGIN_DATE,
233: WF_CACHE.Activities(waIND).END_DATE,
234: WF_CACHE.Activities(waIND).DIRECTION
235:
236: from WF_ACTIVITIES WA

Line 233: WF_CACHE.Activities(waIND).END_DATE,

229: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
230: WF_CACHE.Activities(waIND).EVENT_NAME,
231: WF_CACHE.Activities(waIND).MESSAGE,
232: WF_CACHE.Activities(waIND).BEGIN_DATE,
233: WF_CACHE.Activities(waIND).END_DATE,
234: WF_CACHE.Activities(waIND).DIRECTION
235:
236: from WF_ACTIVITIES WA
237: where WA.ITEM_TYPE = itemtype

Line 234: WF_CACHE.Activities(waIND).DIRECTION

230: WF_CACHE.Activities(waIND).EVENT_NAME,
231: WF_CACHE.Activities(waIND).MESSAGE,
232: WF_CACHE.Activities(waIND).BEGIN_DATE,
233: WF_CACHE.Activities(waIND).END_DATE,
234: WF_CACHE.Activities(waIND).DIRECTION
235:
236: from WF_ACTIVITIES WA
237: where WA.ITEM_TYPE = itemtype
238: and WA.NAME = activity

Line 244: return (WF_CACHE.Activities(waIND).TYPE);

240: and actdate < nvl(WA.END_DATE, actdate+1);
241:
242: end if;
243:
244: return (WF_CACHE.Activities(waIND).TYPE);
245:
246: exception
247: when NO_DATA_FOUND then
248: return '';

Line 588: WF_CACHE.GetActivity(itemtype, activity, actdate, status, waIND);

584: waIND NUMBER;
585: status PLS_INTEGER;
586:
587: begin
588: WF_CACHE.GetActivity(itemtype, activity, actdate, status, waIND);
589:
590: if (status <> WF_CACHE.task_SUCCESS) then
591:
592: select WA.ITEM_TYPE, WA.NAME, WA.VERSION, WA.TYPE, WA.RERUN, WA.EXPAND_ROLE,

Line 590: if (status <> WF_CACHE.task_SUCCESS) then

586:
587: begin
588: WF_CACHE.GetActivity(itemtype, activity, actdate, status, waIND);
589:
590: if (status <> WF_CACHE.task_SUCCESS) then
591:
592: select WA.ITEM_TYPE, WA.NAME, WA.VERSION, WA.TYPE, WA.RERUN, WA.EXPAND_ROLE,
593: WA.COST, WA.ERROR_ITEM_TYPE, WA.ERROR_PROCESS, WA.FUNCTION,
594: WA.FUNCTION_TYPE, WA.EVENT_NAME, WA.MESSAGE, WA.BEGIN_DATE,

Line 597: into WF_CACHE.Activities(waIND).ITEM_TYPE,

593: WA.COST, WA.ERROR_ITEM_TYPE, WA.ERROR_PROCESS, WA.FUNCTION,
594: WA.FUNCTION_TYPE, WA.EVENT_NAME, WA.MESSAGE, WA.BEGIN_DATE,
595: WA.END_DATE, WA.DIRECTION
596:
597: into WF_CACHE.Activities(waIND).ITEM_TYPE,
598: WF_CACHE.Activities(waIND).NAME,
599: WF_CACHE.Activities(waIND).VERSION,
600: WF_CACHE.Activities(waIND).TYPE,
601: WF_CACHE.Activities(waIND).RERUN,

Line 598: WF_CACHE.Activities(waIND).NAME,

594: WA.FUNCTION_TYPE, WA.EVENT_NAME, WA.MESSAGE, WA.BEGIN_DATE,
595: WA.END_DATE, WA.DIRECTION
596:
597: into WF_CACHE.Activities(waIND).ITEM_TYPE,
598: WF_CACHE.Activities(waIND).NAME,
599: WF_CACHE.Activities(waIND).VERSION,
600: WF_CACHE.Activities(waIND).TYPE,
601: WF_CACHE.Activities(waIND).RERUN,
602: WF_CACHE.Activities(waIND).EXPAND_ROLE,

Line 599: WF_CACHE.Activities(waIND).VERSION,

595: WA.END_DATE, WA.DIRECTION
596:
597: into WF_CACHE.Activities(waIND).ITEM_TYPE,
598: WF_CACHE.Activities(waIND).NAME,
599: WF_CACHE.Activities(waIND).VERSION,
600: WF_CACHE.Activities(waIND).TYPE,
601: WF_CACHE.Activities(waIND).RERUN,
602: WF_CACHE.Activities(waIND).EXPAND_ROLE,
603: WF_CACHE.Activities(waIND).COST,

Line 600: WF_CACHE.Activities(waIND).TYPE,

596:
597: into WF_CACHE.Activities(waIND).ITEM_TYPE,
598: WF_CACHE.Activities(waIND).NAME,
599: WF_CACHE.Activities(waIND).VERSION,
600: WF_CACHE.Activities(waIND).TYPE,
601: WF_CACHE.Activities(waIND).RERUN,
602: WF_CACHE.Activities(waIND).EXPAND_ROLE,
603: WF_CACHE.Activities(waIND).COST,
604: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,

Line 601: WF_CACHE.Activities(waIND).RERUN,

597: into WF_CACHE.Activities(waIND).ITEM_TYPE,
598: WF_CACHE.Activities(waIND).NAME,
599: WF_CACHE.Activities(waIND).VERSION,
600: WF_CACHE.Activities(waIND).TYPE,
601: WF_CACHE.Activities(waIND).RERUN,
602: WF_CACHE.Activities(waIND).EXPAND_ROLE,
603: WF_CACHE.Activities(waIND).COST,
604: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
605: WF_CACHE.Activities(waIND).ERROR_PROCESS,

Line 602: WF_CACHE.Activities(waIND).EXPAND_ROLE,

598: WF_CACHE.Activities(waIND).NAME,
599: WF_CACHE.Activities(waIND).VERSION,
600: WF_CACHE.Activities(waIND).TYPE,
601: WF_CACHE.Activities(waIND).RERUN,
602: WF_CACHE.Activities(waIND).EXPAND_ROLE,
603: WF_CACHE.Activities(waIND).COST,
604: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
605: WF_CACHE.Activities(waIND).ERROR_PROCESS,
606: WF_CACHE.Activities(waIND).FUNCTION,

Line 603: WF_CACHE.Activities(waIND).COST,

599: WF_CACHE.Activities(waIND).VERSION,
600: WF_CACHE.Activities(waIND).TYPE,
601: WF_CACHE.Activities(waIND).RERUN,
602: WF_CACHE.Activities(waIND).EXPAND_ROLE,
603: WF_CACHE.Activities(waIND).COST,
604: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
605: WF_CACHE.Activities(waIND).ERROR_PROCESS,
606: WF_CACHE.Activities(waIND).FUNCTION,
607: WF_CACHE.Activities(waIND).FUNCTION_TYPE,

Line 604: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,

600: WF_CACHE.Activities(waIND).TYPE,
601: WF_CACHE.Activities(waIND).RERUN,
602: WF_CACHE.Activities(waIND).EXPAND_ROLE,
603: WF_CACHE.Activities(waIND).COST,
604: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
605: WF_CACHE.Activities(waIND).ERROR_PROCESS,
606: WF_CACHE.Activities(waIND).FUNCTION,
607: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
608: WF_CACHE.Activities(waIND).EVENT_NAME,

Line 605: WF_CACHE.Activities(waIND).ERROR_PROCESS,

601: WF_CACHE.Activities(waIND).RERUN,
602: WF_CACHE.Activities(waIND).EXPAND_ROLE,
603: WF_CACHE.Activities(waIND).COST,
604: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
605: WF_CACHE.Activities(waIND).ERROR_PROCESS,
606: WF_CACHE.Activities(waIND).FUNCTION,
607: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
608: WF_CACHE.Activities(waIND).EVENT_NAME,
609: WF_CACHE.Activities(waIND).MESSAGE,

Line 606: WF_CACHE.Activities(waIND).FUNCTION,

602: WF_CACHE.Activities(waIND).EXPAND_ROLE,
603: WF_CACHE.Activities(waIND).COST,
604: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
605: WF_CACHE.Activities(waIND).ERROR_PROCESS,
606: WF_CACHE.Activities(waIND).FUNCTION,
607: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
608: WF_CACHE.Activities(waIND).EVENT_NAME,
609: WF_CACHE.Activities(waIND).MESSAGE,
610: WF_CACHE.Activities(waIND).BEGIN_DATE,

Line 607: WF_CACHE.Activities(waIND).FUNCTION_TYPE,

603: WF_CACHE.Activities(waIND).COST,
604: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
605: WF_CACHE.Activities(waIND).ERROR_PROCESS,
606: WF_CACHE.Activities(waIND).FUNCTION,
607: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
608: WF_CACHE.Activities(waIND).EVENT_NAME,
609: WF_CACHE.Activities(waIND).MESSAGE,
610: WF_CACHE.Activities(waIND).BEGIN_DATE,
611: WF_CACHE.Activities(waIND).END_DATE,

Line 608: WF_CACHE.Activities(waIND).EVENT_NAME,

604: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
605: WF_CACHE.Activities(waIND).ERROR_PROCESS,
606: WF_CACHE.Activities(waIND).FUNCTION,
607: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
608: WF_CACHE.Activities(waIND).EVENT_NAME,
609: WF_CACHE.Activities(waIND).MESSAGE,
610: WF_CACHE.Activities(waIND).BEGIN_DATE,
611: WF_CACHE.Activities(waIND).END_DATE,
612: WF_CACHE.Activities(waIND).DIRECTION

Line 609: WF_CACHE.Activities(waIND).MESSAGE,

605: WF_CACHE.Activities(waIND).ERROR_PROCESS,
606: WF_CACHE.Activities(waIND).FUNCTION,
607: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
608: WF_CACHE.Activities(waIND).EVENT_NAME,
609: WF_CACHE.Activities(waIND).MESSAGE,
610: WF_CACHE.Activities(waIND).BEGIN_DATE,
611: WF_CACHE.Activities(waIND).END_DATE,
612: WF_CACHE.Activities(waIND).DIRECTION
613:

Line 610: WF_CACHE.Activities(waIND).BEGIN_DATE,

606: WF_CACHE.Activities(waIND).FUNCTION,
607: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
608: WF_CACHE.Activities(waIND).EVENT_NAME,
609: WF_CACHE.Activities(waIND).MESSAGE,
610: WF_CACHE.Activities(waIND).BEGIN_DATE,
611: WF_CACHE.Activities(waIND).END_DATE,
612: WF_CACHE.Activities(waIND).DIRECTION
613:
614: from WF_ACTIVITIES WA

Line 611: WF_CACHE.Activities(waIND).END_DATE,

607: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
608: WF_CACHE.Activities(waIND).EVENT_NAME,
609: WF_CACHE.Activities(waIND).MESSAGE,
610: WF_CACHE.Activities(waIND).BEGIN_DATE,
611: WF_CACHE.Activities(waIND).END_DATE,
612: WF_CACHE.Activities(waIND).DIRECTION
613:
614: from WF_ACTIVITIES WA
615: where WA.ITEM_TYPE = itemtype

Line 612: WF_CACHE.Activities(waIND).DIRECTION

608: WF_CACHE.Activities(waIND).EVENT_NAME,
609: WF_CACHE.Activities(waIND).MESSAGE,
610: WF_CACHE.Activities(waIND).BEGIN_DATE,
611: WF_CACHE.Activities(waIND).END_DATE,
612: WF_CACHE.Activities(waIND).DIRECTION
613:
614: from WF_ACTIVITIES WA
615: where WA.ITEM_TYPE = itemtype
616: and WA.NAME = activity

Line 622: return (WF_CACHE.Activities(waIND).VERSION);

618: and actdate < nvl(WA.END_DATE, actdate+1);
619:
620: end if;
621:
622: return (WF_CACHE.Activities(waIND).VERSION);
623:
624: exception
625: when NO_DATA_FOUND then
626: Wf_Core.Context('Wf_Activity', 'Version', itemtype, activity,