[Home] [Help]
PACKAGE: APPS.PA_CI_IMPACT_TYPE_USAGE_PVT
Source
1 PACKAGE pa_ci_impact_type_usage_pvt AUTHID CURRENT_USER AS
2 /* $Header: PACIIMVS.pls 120.1 2009/04/21 18:11:00 cklee ship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL CONSTANTS
6 ---------------------------------------------------------------------------
7 G_CREATE CONSTANT VARCHAR2(10) := 'CREATE';
8 G_UPDATE CONSTANT VARCHAR2(10) := 'UPDATE';
9 G_VIEW CONSTANT VARCHAR2(10) := 'INSERT';
10 G_ISSUE CONSTANT VARCHAR2(10) := 'ISSUE';
11 G_CHANGE_ORDER CONSTANT VARCHAR2(15) := 'CHANGE_ORDER';
12 G_CHANGE_REQUEST CONSTANT VARCHAR2(15) := 'CHANGE_REQUEST';
13 --------------------------------------------------------------------------------
14 -- ERRORS AND EXCEPTIONS
15 --------------------------------------------------------------------------------
16
17 G_EXCEPTION_ERROR EXCEPTION;
18 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
19
20 TYPE impact_rec_type is RECORD
21 (--ci_impact_type_usage_id pa_ci_impact_type_usage.ci_impact_type_usage_id%type := OKL_API.G_MISS_NUM,
22 impact_type_code pa_ci_impact_type_usage.IMPACT_TYPE_CODE%type)
23 --impact_type_code_order pa_ci_impact_type_usage.IMPACT_TYPE_CODE_ORDER%type := OKL_API.G_MISS_NUM)
24 ;
25 TYPE impact_tbl_type IS TABLE OF impact_rec_type
26 INDEX BY BINARY_INTEGER;
27
28
29 PROCEDURE create_ci_impact_type_usage (
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_impact_type_code IN VARCHAR2 := null,
37 p_ci_type_class_code IN VARCHAR2 := null,
38 p_CI_TYPE_ID in NUMBER := null,
39
40 p_created_by IN NUMBER DEFAULT fnd_global.user_id,
41 p_creation_date IN DATE DEFAULT SYSDATE,
42 p_last_update_login IN NUMBER DEFAULT fnd_global.login_id,
43 --start:| 16-FEB-2009 cklee R12.1.2 setup ehancement
44 P_IMPACT_TYPE_CODE_ORDER IN NUMBER default null,
45 --end:| 16-FEB-2009 cklee R12.1.2 setup ehancement
46
47 x_ci_impact_type_usage_id OUT NOCOPY NUMBER,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2
51 );
52
53 --start:| 16-FEB-2009 cklee R12.1.2 setup ehancement
54
55 PROCEDURE apply_ci_impact_type_usage (
56 p_api_version IN NUMBER := 1.0,
57 p_init_msg_list IN VARCHAR2 := 'T',
58 p_commit IN VARCHAR2 := 'F',
59 p_validate_only IN VARCHAR2 := 'T',
60 p_max_msg_count IN NUMBER := null,
61
62 p_ui_mode IN VARCHAR2,
63 p_ci_class_code IN VARCHAR2,
64 p_ci_type_id IN NUMBER,
65 p_impact_tbl IN impact_tbl_type,
66
67 -- x_impact_tbl OUT NOCOPY impact_tbl_type,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2
71 );
72 --end:| 16-FEB-2009 cklee R12.1.2 setup ehancement
73
74 --start:| 16-FEB-2009 cklee R12.1.2 setup ehancement
75
76 PROCEDURE update_ci_impact_type_usage (
77 p_api_version IN NUMBER := 1.0,
78 p_init_msg_list IN VARCHAR2 := 'T',
79 p_commit IN VARCHAR2 := 'F',
80 p_validate_only IN VARCHAR2 := 'T',
81 p_max_msg_count IN NUMBER := null,
82
83 P_IMPACT_TYPE_CODE_ORDER IN NUMBER,
84 p_ci_impact_type_usage_id IN NUMBER,
85
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2
89 );
90 --end:| 16-FEB-2009 cklee R12.1.2 setup ehancement
91
92 PROCEDURE delete_ci_impact_type_usage (
93 p_api_version IN NUMBER := 1.0,
94 p_init_msg_list IN VARCHAR2 := 'T',
95 p_commit IN VARCHAR2 := 'F',
96 p_validate_only IN VARCHAR2 := 'T',
97 p_max_msg_count IN NUMBER := null,
98
99 p_ci_impact_type_usage_id IN NUMBER := null,
100 p_impact_type_code IN VARCHAR2 := null,
101 p_ci_type_class_code IN VARCHAR2 := null,
102 p_ci_type_id IN NUMBER := null,
103 --start:| 16-FEB-2009 cklee R12.1.2 setup ehancement
104 P_IMPACT_TYPE_CODE_ORDER IN NUMBER default null,
105 --end:| 16-FEB-2009 cklee R12.1.2 setup ehancement
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2
109 ) ;
110
111 END pa_ci_impact_type_usage_pvt;