1 PACKAGE PA_CI_IMPACT_TYPE_USAGE_PUB AUTHID CURRENT_USER AS
2 /* $Header: PACIIMPS.pls 115.2 2002/11/23 19:22:52 syao noship $ */
3 PROCEDURE create_ci_impact_type_usage (
4 p_api_version IN NUMBER := 1.0,
5 p_init_msg_list IN VARCHAR2 := 'T',
6 p_commit IN VARCHAR2 := 'F',
7 p_validate_only IN VARCHAR2 := 'T',
8 p_max_msg_count IN NUMBER := null,
9
10 p_impact_type_code IN VARCHAR2 := null,
11 p_ci_type_class_code IN VARCHAR2 := null,
12 p_CI_TYPE_ID in NUMBER := null,
13
14 p_created_by IN NUMBER DEFAULT fnd_global.user_id,
15 p_creation_date IN DATE DEFAULT SYSDATE,
16 p_last_update_login IN NUMBER DEFAULT fnd_global.login_id,
17
18 x_ci_impact_type_usage_id OUT NOCOPY NUMBER,
19 x_return_status OUT NOCOPY VARCHAR2,
20 x_msg_count OUT NOCOPY NUMBER,
21 x_msg_data OUT NOCOPY VARCHAR2
22 ) ;
23
24 PROCEDURE delete_ci_impact_type_usage (
25 p_api_version IN NUMBER := 1.0,
26 p_init_msg_list IN VARCHAR2 := 'T',
27 p_commit IN VARCHAR2 := 'F',
28 p_validate_only IN VARCHAR2 := 'T',
29 p_max_msg_count IN NUMBER := null,
30
31 p_ci_impact_type_usage_id IN NUMBER := null,
32 p_impact_type_code IN VARCHAR2 := null,
33 p_ci_type_class_code IN VARCHAR2 := null,
34 p_ci_type_id IN NUMBER := null,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2
38 ) ;
39
40 FUNCTION delete_impact_type_usage_ok
41 (
42 p_impact_type_code IN VARCHAR2 ,
43 p_ci_type_id IN NUMBER
44 ) RETURN VARCHAR2;
45
46 END PA_CI_IMPACT_TYPE_USAGE_PUB;