DBA Data[Home] [Help]

PACKAGE: APPS.CSD_REPAIR_TASK_UTIL

Source


1 PACKAGE CSD_REPAIR_TASK_UTIL 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;