[Home] [Help]
PACKAGE: APPS.PA_CI_IMPACT_TYPE_USAGE_PUB
Source
1 PACKAGE PA_CI_IMPACT_TYPE_USAGE_PUB AUTHID CURRENT_USER AS
2 /* $Header: PACIIMPS.pls 120.1 2009/03/24 17:35:56 cklee ship $ */
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 --start:| 16-FEB-2009 cklee R12.1.2 setup ehancement
19 P_IMPACT_TYPE_CODE_ORDER IN NUMBER default null,
20 --end:| 16-FEB-2009 cklee R12.1.2 setup ehancement
21 x_ci_impact_type_usage_id OUT NOCOPY NUMBER,
22 x_return_status OUT NOCOPY VARCHAR2,
23 x_msg_count OUT NOCOPY NUMBER,
24 x_msg_data OUT NOCOPY VARCHAR2
25 ) ;
26 --start:| 16-FEB-2009 cklee R12.1.2 setup ehancement
27
28 PROCEDURE update_ci_impact_type_usage (
29 p_api_version IN NUMBER := 1.0,
30 p_init_msg_list IN VARCHAR2 := 'T',
31 p_commit IN VARCHAR2 := 'F',
32 p_validate_only IN VARCHAR2 := 'T',
33 p_max_msg_count IN NUMBER := null,
34
35 p_ci_impact_type_usage_id IN NUMBER,
36 P_IMPACT_TYPE_CODE_ORDER IN NUMBER,
37
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2
41 ) ;
42 --end:| 16-FEB-2009 cklee R12.1.2 setup ehancement
43
44
45
46 PROCEDURE delete_ci_impact_type_usage (
47 p_api_version IN NUMBER := 1.0,
48 p_init_msg_list IN VARCHAR2 := 'T',
49 p_commit IN VARCHAR2 := 'F',
50 p_validate_only IN VARCHAR2 := 'T',
51 p_max_msg_count IN NUMBER := null,
52
53 p_ci_impact_type_usage_id IN NUMBER := null,
54 p_impact_type_code IN VARCHAR2 := null,
55 p_ci_type_class_code IN VARCHAR2 := null,
56 p_ci_type_id IN NUMBER := null,
57 --start:| 16-FEB-2009 cklee R12.1.2 setup ehancement
58 P_IMPACT_TYPE_CODE_ORDER IN NUMBER default null,
59 --end:| 16-FEB-2009 cklee R12.1.2 setup ehancement
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2
63 ) ;
64
65 FUNCTION delete_impact_type_usage_ok
66 (
67 p_impact_type_code IN VARCHAR2 ,
68 p_ci_type_id IN NUMBER
69 ) RETURN VARCHAR2;
70
71 END PA_CI_IMPACT_TYPE_USAGE_PUB;