1 PACKAGE pa_ci_impacts_pvt AUTHID CURRENT_USER AS
2 /* $Header: PACIIPVS.pls 115.3 2002/11/23 19:23:05 syao noship $ */
3
4 PROCEDURE create_ci_impact (
5 p_api_version IN NUMBER := 1.0,
6 p_init_msg_list IN VARCHAR2 := 'T',
7 p_commit IN VARCHAR2 := 'F',
8 p_validate_only IN VARCHAR2 := 'T',
9 p_max_msg_count IN NUMBER := null,
10
11 p_ci_id IN NUMBER := null,
12 p_impact_type_code IN VARCHAR2 := null,
13
14 p_status_code IN VARCHAR2 := null,
15 p_description IN VARCHAR2 := null,
16 p_implementation_date IN DATE := null,
17 p_implemented_by IN NUMBER := null,
18 p_implementation_comment IN VARCHAR2 := null,
19 p_impacted_task_id IN NUMBER := null,
20 x_ci_impact_id OUT NOCOPY NUMBER,
21 x_return_status OUT NOCOPY VARCHAR2,
22 x_msg_count OUT NOCOPY NUMBER,
23 x_msg_data OUT NOCOPY VARCHAR2
24 ) ;
25
26
27 PROCEDURE delete_ci_impact (
28 p_api_version IN NUMBER := 1.0,
29 p_init_msg_list IN VARCHAR2 := 'T',
30 p_commit IN VARCHAR2 := 'F',
31 p_validate_only IN VARCHAR2 := 'T',
32 p_max_msg_count IN NUMBER := null,
33
34 p_ci_impact_id IN NUMBER := null,
35 p_record_version_number IN NUMBER := null,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2
39 ) ;
40
41
42 PROCEDURE update_ci_impact (
43 p_api_version IN NUMBER := 1.0,
44 p_init_msg_list IN VARCHAR2 := 'T',
45 p_commit IN VARCHAR2 := 'F',
46 p_validate_only IN VARCHAR2 := 'T',
47 p_max_msg_count IN NUMBER := null,
48 p_ci_impact_id IN NUMBER:= null,
49 p_ci_id IN NUMBER := null,
50 p_impact_type_code IN VARCHAR2 := null,
51 p_status_code IN VARCHAR2 := null,
52 p_description IN VARCHAR2 := null,
53 p_implementation_date IN DATE := null,
54 p_implemented_by IN NUMBER := null,
55 p_impby_name IN VARCHAR2 := null,
56 p_impby_type_id IN NUMBER := null,
57 p_implementation_comment IN VARCHAR2 := null,
58 p_record_version_number IN NUMBER := null,
59 p_impacted_task_id IN NUMBER := null,
60
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2
64 ) ;
65
66
67 END pa_ci_impacts_pvt;