1 PACKAGE pa_project_search_utils AUTHID CURRENT_USER AS
2 /*$Header: PAPRSUTS.pls 120.1 2006/02/28 05:05:02 dthakker noship $*/
3
4
5 PROCEDURE Convert_NameToId
6 ( p_param_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
7 ,p_param_value_tbl IN SYSTEM.pa_varchar2_240_tbl_type
8 ,p_param_value2_tbl IN SYSTEM.pa_varchar2_240_tbl_type
9 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
10 ,x_param_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
11 ,x_return_status OUT NOCOPY VARCHAR2
12 ,x_msg_count OUT NOCOPY NUMBER
13 ,x_msg_data OUT NOCOPY VARCHAR2
14 );
15
16 PROCEDURE Check_Customer_Name_Or_Id
17 ( p_customer_id IN NUMBER
18 ,p_customer_name IN VARCHAR2
19 ,x_customer_id OUT NOCOPY NUMBER
20 ,x_return_status OUT NOCOPY VARCHAR2
21 ,x_error_msg_code OUT NOCOPY VARCHAR2
22 );
23
24 PROCEDURE Check_PersonName_Or_Id(
25 p_resource_id IN NUMBER
26 ,p_resource_name IN VARCHAR2
27 ,x_resource_id OUT NOCOPY NUMBER
28 ,x_resource_type_id OUT NOCOPY NUMBER
29 ,x_return_status OUT NOCOPY VARCHAR2
30 ,x_error_msg_code OUT NOCOPY VARCHAR2
31 );
32
33
34 PROCEDURE Check_ResourceName_Or_Id(
35 p_person_id IN NUMBER
36 ,p_person_name IN VARCHAR2
37 ,x_person_id OUT NOCOPY NUMBER
38 ,x_return_status OUT NOCOPY VARCHAR2
39 ,x_error_msg_code OUT NOCOPY VARCHAR2
40 );
41
42 PROCEDURE Get_Perf_Measures
43 (
44 p_source_api IN VARCHAR2,
45 p_project_id IN NUMBER,
46 p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
47 p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL, -- added for bug4361663
48 p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL, -- added for bug4361663
49 p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL, -- added for bug4361663
50 x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
51 x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
52 -- x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE,
53 x_sec_ret_code OUT NOCOPY VARCHAR2,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2
57 );
58
59 END PA_PROJECT_SEARCH_UTILS;