1 PACKAGE pa_ci_impact_type_usage_pvt AUTHID CURRENT_USER AS
2 /* $Header: PACIIMVS.pls 115.1 2002/11/23 19:23:12 syao noship $ */
3
4 PROCEDURE create_ci_impact_type_usage (
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_impact_type_code IN VARCHAR2 := null,
12 p_ci_type_class_code IN VARCHAR2 := null,
13 p_CI_TYPE_ID in NUMBER := null,
14
15 p_created_by IN NUMBER DEFAULT fnd_global.user_id,
16 p_creation_date IN DATE DEFAULT SYSDATE,
17 p_last_update_login IN NUMBER DEFAULT fnd_global.login_id,
18
19 x_ci_impact_type_usage_id OUT NOCOPY NUMBER,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_msg_count OUT NOCOPY NUMBER,
22 x_msg_data OUT NOCOPY VARCHAR2
23 );
24
25 PROCEDURE delete_ci_impact_type_usage (
26 p_api_version IN NUMBER := 1.0,
27 p_init_msg_list IN VARCHAR2 := 'T',
28 p_commit IN VARCHAR2 := 'F',
29 p_validate_only IN VARCHAR2 := 'T',
30 p_max_msg_count IN NUMBER := null,
31
32 p_ci_impact_type_usage_id IN NUMBER := null,
33 p_impact_type_code IN VARCHAR2 := null,
34 p_ci_type_class_code IN VARCHAR2 := null,
35 p_ci_type_id 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 END pa_ci_impact_type_usage_pvt;