1 PACKAGE CSD_REPAIR_TASK_UTIL AUTHID CURRENT_USER as
2 /* $Header: csdvrtus.pls 120.1 2005/08/09 16:26:43 sangigup noship $ csdtacts.pls */
3
4 g_txn_number NUMBER := 2005;
5
6 TYPE number_array_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
7
8 procedure string_to_array( p_x_string IN OUT NOCOPY varchar2, x_result_ids OUT NOCOPY number_array_type);
9
10 --function to get the plan name from the plan id
11 function get_plan_name (p_plan_id IN NUMBER ) return varchar2;
12
13 --procedure to return plan ids for the collection ids. This will return all the plan ids
14 -- for which data was collected for a given collection id.
15 PROCEDURE get_planIds_for_CIds(p_local_cids_array IN number_array_type,
16 x_local_plan_ids_array out NOCOPY number_array_type);
17
18 END CSD_REPAIR_TASK_UTIL;