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.PA_FP_ELEMENTS_PUB dependencies on PA_PROJ_FP_OPTIONS

Line 64: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE

60: ,p_cost_resource_list_id IN NUMBER
61: ,p_revenue_resource_list_id IN NUMBER
62: ,p_all_resource_list_id IN NUMBER
63: /* Bug :- 2920954 start of new parameters added for post fp-K one off patch */
64: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
65: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
66: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
67: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
68: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE

Line 65: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE

61: ,p_revenue_resource_list_id IN NUMBER
62: ,p_all_resource_list_id IN NUMBER
63: /* Bug :- 2920954 start of new parameters added for post fp-K one off patch */
64: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
65: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
66: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
67: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
68: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE
69: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE

Line 66: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE

62: ,p_all_resource_list_id IN NUMBER
63: /* Bug :- 2920954 start of new parameters added for post fp-K one off patch */
64: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
65: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
66: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
67: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
68: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE
69: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE
70: /* Bug :- 2920954 end of new parameters added for post fp-K one off patch */

Line 67: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE

63: /* Bug :- 2920954 start of new parameters added for post fp-K one off patch */
64: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
65: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
66: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
67: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
68: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE
69: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE
70: /* Bug :- 2920954 end of new parameters added for post fp-K one off patch */
71: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 68: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE

64: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
65: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
66: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
67: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
68: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE
69: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE
70: /* Bug :- 2920954 end of new parameters added for post fp-K one off patch */
71: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
72: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 69: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE

65: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
66: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
67: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
68: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE
69: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE
70: /* Bug :- 2920954 end of new parameters added for post fp-K one off patch */
71: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
72: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
73: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 92: ,p_select_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE

88: ,p_element_type IN VARCHAR2
89: ,p_planning_level IN VARCHAR2
90: ,p_resource_list_id IN NUMBER
91: /* Bug :- 2920954 start of parameters added for post fp-K one off patch */
92: ,p_select_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
93: ,p_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
94: /* Bug :- 2920954 end of parameters added for post fp-K one off patch */
95: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 93: ,p_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE

89: ,p_planning_level IN VARCHAR2
90: ,p_resource_list_id IN NUMBER
91: /* Bug :- 2920954 start of parameters added for post fp-K one off patch */
92: ,p_select_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
93: ,p_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
94: /* Bug :- 2920954 end of parameters added for post fp-K one off patch */
95: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
97: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 155: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

151: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
152: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
153:
154: FUNCTION get_element_id (
155: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
156: ,p_element_type IN pa_fp_elements.element_type%TYPE
157: ,p_task_id IN pa_tasks.task_id%TYPE
158: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE)
159: RETURN pa_fp_elements.proj_fp_elements_id%TYPE;

Line 162: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

158: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE)
159: RETURN pa_fp_elements.proj_fp_elements_id%TYPE;
160:
161: FUNCTION get_element_plannable_flag (
162: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
163: ,p_element_type IN pa_fp_elements.element_type%TYPE
164: ,p_task_id IN pa_tasks.task_id%TYPE
165: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE)
166: RETURN pa_fp_elements.plannable_flag%TYPE;

Line 169: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

165: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE)
166: RETURN pa_fp_elements.plannable_flag%TYPE;
167:
168: FUNCTION get_plan_amount_exists_flag (
169: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
170: ,p_element_type IN pa_fp_elements.element_type%TYPE
171: ,p_task_id IN pa_tasks.task_id%TYPE
172: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE)
173: RETURN pa_fp_elements.plan_amount_exists_flag%TYPE;

Line 186: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

182: ,p_grouped_flag IN VARCHAR2)
183: RETURN pa_fp_elements.resource_planning_level%TYPE;
184:
185: PROCEDURE Create_elements_from_version(
186: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
187: ,p_element_type IN pa_fp_elements.element_type%TYPE
188: ,p_from_version_id IN pa_budget_versions.budget_version_id%TYPE
189: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
190: ,x_mixed_resource_planned_flag OUT NOCOPY VARCHAR2 -- new parameter for Bug :- 2625872 --File.Sql.39 bug 4440895

Line 197: p_proj_fp_options_id IN PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE

193: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
194:
195:
196: PROCEDURE refresh_res_list_changes (
197: p_proj_fp_options_id IN PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE
198: ,p_element_type IN PA_FP_ELEMENTS.ELEMENT_TYPE%TYPE /* COST,REVENUE,ALL,BOTH */
199: ,p_cost_resource_list_id IN PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE
200: ,p_rev_resource_list_id IN PA_PROJ_FP_OPTIONS.REVENUE_RESOURCE_LIST_ID%TYPE
201: ,p_all_resource_list_id IN PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE

Line 199: ,p_cost_resource_list_id IN PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE

195:
196: PROCEDURE refresh_res_list_changes (
197: p_proj_fp_options_id IN PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE
198: ,p_element_type IN PA_FP_ELEMENTS.ELEMENT_TYPE%TYPE /* COST,REVENUE,ALL,BOTH */
199: ,p_cost_resource_list_id IN PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE
200: ,p_rev_resource_list_id IN PA_PROJ_FP_OPTIONS.REVENUE_RESOURCE_LIST_ID%TYPE
201: ,p_all_resource_list_id IN PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE
202: /* Bug :- 2920954 start of new parameters added for post fp-K one off patch */
203: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE

Line 200: ,p_rev_resource_list_id IN PA_PROJ_FP_OPTIONS.REVENUE_RESOURCE_LIST_ID%TYPE

196: PROCEDURE refresh_res_list_changes (
197: p_proj_fp_options_id IN PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE
198: ,p_element_type IN PA_FP_ELEMENTS.ELEMENT_TYPE%TYPE /* COST,REVENUE,ALL,BOTH */
199: ,p_cost_resource_list_id IN PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE
200: ,p_rev_resource_list_id IN PA_PROJ_FP_OPTIONS.REVENUE_RESOURCE_LIST_ID%TYPE
201: ,p_all_resource_list_id IN PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE
202: /* Bug :- 2920954 start of new parameters added for post fp-K one off patch */
203: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
204: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE

Line 201: ,p_all_resource_list_id IN PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE

197: p_proj_fp_options_id IN PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE
198: ,p_element_type IN PA_FP_ELEMENTS.ELEMENT_TYPE%TYPE /* COST,REVENUE,ALL,BOTH */
199: ,p_cost_resource_list_id IN PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE
200: ,p_rev_resource_list_id IN PA_PROJ_FP_OPTIONS.REVENUE_RESOURCE_LIST_ID%TYPE
201: ,p_all_resource_list_id IN PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE
202: /* Bug :- 2920954 start of new parameters added for post fp-K one off patch */
203: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
204: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
205: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE

Line 203: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE

199: ,p_cost_resource_list_id IN PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID%TYPE
200: ,p_rev_resource_list_id IN PA_PROJ_FP_OPTIONS.REVENUE_RESOURCE_LIST_ID%TYPE
201: ,p_all_resource_list_id IN PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE
202: /* Bug :- 2920954 start of new parameters added for post fp-K one off patch */
203: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
204: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
205: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
206: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
207: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE

Line 204: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE

200: ,p_rev_resource_list_id IN PA_PROJ_FP_OPTIONS.REVENUE_RESOURCE_LIST_ID%TYPE
201: ,p_all_resource_list_id IN PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE
202: /* Bug :- 2920954 start of new parameters added for post fp-K one off patch */
203: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
204: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
205: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
206: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
207: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE
208: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE

Line 205: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE

201: ,p_all_resource_list_id IN PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE
202: /* Bug :- 2920954 start of new parameters added for post fp-K one off patch */
203: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
204: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
205: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
206: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
207: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE
208: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE
209: /* Bug :- 2920954 end of new parameters added for post fp-K one off patch */

Line 206: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE

202: /* Bug :- 2920954 start of new parameters added for post fp-K one off patch */
203: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
204: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
205: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
206: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
207: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE
208: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE
209: /* Bug :- 2920954 end of new parameters added for post fp-K one off patch */
210: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 207: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE

203: ,p_select_cost_res_auto_flag IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE
204: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
205: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
206: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
207: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE
208: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE
209: /* Bug :- 2920954 end of new parameters added for post fp-K one off patch */
210: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
211: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 208: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE

204: ,p_cost_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
205: ,p_select_rev_res_auto_flag IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE
206: ,p_revenue_res_planning_level IN pa_proj_fp_options.revenue_res_planning_level%TYPE
207: ,p_select_all_res_auto_flag IN pa_proj_fp_options.select_all_res_auto_flag%TYPE
208: ,p_all_res_planning_level IN pa_proj_fp_options.all_res_planning_level%TYPE
209: /* Bug :- 2920954 end of new parameters added for post fp-K one off patch */
210: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
211: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
212: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 230: ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

226: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
227: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
228:
229: PROCEDURE Add_resources_automatically
230: ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
231: ,p_element_type IN pa_fp_elements.element_type%TYPE
232: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
233: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE
234: ,p_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE

Line 232: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE

228:
229: PROCEDURE Add_resources_automatically
230: ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
231: ,p_element_type IN pa_fp_elements.element_type%TYPE
232: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
233: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE
234: ,p_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
235: ,p_entire_option IN VARCHAR2
236: ,p_element_task_id_tbl IN pa_fp_elements_pub.l_task_id_tbl_typ

Line 234: ,p_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE

230: ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
231: ,p_element_type IN pa_fp_elements.element_type%TYPE
232: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
233: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE
234: ,p_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
235: ,p_entire_option IN VARCHAR2
236: ,p_element_task_id_tbl IN pa_fp_elements_pub.l_task_id_tbl_typ
237: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
238: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895