1 PACKAGE pa_ci_impacts_pub AUTHID CURRENT_USER AS
2 /* $Header: PACIIPPS.pls 115.4 2002/11/23 19:23:00 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 p_impacted_task_name IN VARCHAR2 := NULL,
21
22 x_ci_impact_id OUT NOCOPY NUMBER,
23 x_return_status OUT NOCOPY VARCHAR2,
24 x_msg_count OUT NOCOPY NUMBER,
25 x_msg_data OUT NOCOPY VARCHAR2
26 ) ;
27
28
29 PROCEDURE delete_ci_impact (
30 p_api_version IN NUMBER := 1.0,
31 p_init_msg_list IN VARCHAR2 := 'T',
32 p_commit IN VARCHAR2 := 'F',
33 p_validate_only IN VARCHAR2 := 'T',
34 p_max_msg_count IN NUMBER := null,
35
36 p_ci_impact_id IN NUMBER := null,
37 p_record_version_number IN NUMBER := null,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2
41 ) ;
42
43
44
45 PROCEDURE update_ci_impact (
46 p_api_version IN NUMBER := 1.0,
47 p_init_msg_list IN VARCHAR2 := 'T',
48 p_commit IN VARCHAR2 := 'F',
49 p_validate_only IN VARCHAR2 := 'T',
50 p_max_msg_count IN NUMBER := null,
51 p_ci_impact_id IN NUMBER:= null,
52 p_ci_id IN NUMBER := null,
53 p_impact_type_code IN VARCHAR2 := null,
54 p_status_code IN VARCHAR2 := null,
55 p_description IN VARCHAR2 := FND_API.g_miss_char,
56 p_implementation_date IN DATE := FND_API.g_miss_date,
57 p_implemented_by IN NUMBER := FND_API.g_miss_num,
58 p_impby_name IN VARCHAR2 := NULL,
59 p_impby_type_id IN NUMBER := null,
60 p_implementation_comment IN VARCHAR2 := FND_API.g_miss_char,
61 p_record_version_number IN NUMBER := null,
62 p_impacted_task_id IN NUMBER := FND_API.g_miss_num,
63 p_impacted_task_name IN VARCHAR2 := NULL,
64
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2
68 );
69
70
71 END pa_ci_impacts_pub;