1 package PA_CI_TYPES_PVT as
2 /* $Header: PACITYVS.pls 120.1 2005/08/19 16:19:32 mwasowic noship $ */
3
4 PROCEDURE create_ci_type (
5 p_api_version IN NUMBER := 1.0,
6 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7 p_commit IN VARCHAR2 := FND_API.g_false,
8 p_validate_only IN VARCHAR2 := FND_API.g_true,
9 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10 p_name IN VARCHAR2,
11 p_short_name IN VARCHAR2,
12 p_description IN VARCHAR2,
13 p_ci_type_class_code IN VARCHAR2,
14 p_auto_number_flag IN VARCHAR2,
15 p_resolution_required_flag IN VARCHAR2,
16 p_approval_required_flag IN VARCHAR2,
17 p_source_attrs_enabled_flag IN VARCHAR2,
18 p_allow_all_usage_flag IN VARCHAR2,
19 p_start_date_active IN DATE,
20 p_end_date_active IN DATE,
21 p_classification_category IN VARCHAR2,
22 p_reason_category IN VARCHAR2,
23 p_resolution_category IN VARCHAR2,
24 p_attribute_category IN VARCHAR2,
25 p_attribute1 IN VARCHAR2,
26 p_attribute2 IN VARCHAR2,
27 p_attribute3 IN VARCHAR2,
28 p_attribute4 IN VARCHAR2,
29 p_attribute5 IN VARCHAR2,
30 p_attribute6 IN VARCHAR2,
31 p_attribute7 IN VARCHAR2,
32 p_attribute8 IN VARCHAR2,
33 p_attribute9 IN VARCHAR2,
34 p_attribute10 IN VARCHAR2,
35 p_attribute11 IN VARCHAR2,
36 p_attribute12 IN VARCHAR2,
37 p_attribute13 IN VARCHAR2,
38 p_attribute14 IN VARCHAR2,
39 p_attribute15 IN VARCHAR2,
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.user_id,
43 x_ci_type_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
44 x_dist_list_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
45 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
46 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
47 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
48 p_status_list_id IN NUMBER
49 );
50
51 PROCEDURE update_ci_type (
52 p_api_version IN NUMBER := 1.0,
53 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
54 p_commit IN VARCHAR2 := FND_API.g_false,
55 p_validate_only IN VARCHAR2 := FND_API.g_true,
56 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
57 p_ci_type_id IN NUMBER,
58 p_name IN VARCHAR2,
59 p_short_name IN VARCHAR2,
60 p_description IN VARCHAR2,
61 p_ci_type_class_code IN VARCHAR2,
62 p_auto_number_flag IN VARCHAR2,
63 p_resolution_required_flag IN VARCHAR2,
64 p_approval_required_flag IN VARCHAR2,
65 p_source_attrs_enabled_flag IN VARCHAR2,
66 p_allow_all_usage_flag IN VARCHAR2,
67 p_start_date_active IN DATE,
68 p_end_date_active IN DATE,
69 p_classification_category IN VARCHAR2,
70 p_reason_category IN VARCHAR2,
71 p_resolution_category IN VARCHAR2,
72 p_attribute_category IN VARCHAR2,
73 p_attribute1 IN VARCHAR2,
74 p_attribute2 IN VARCHAR2,
75 p_attribute3 IN VARCHAR2,
76 p_attribute4 IN VARCHAR2,
77 p_attribute5 IN VARCHAR2,
78 p_attribute6 IN VARCHAR2,
79 p_attribute7 IN VARCHAR2,
80 p_attribute8 IN VARCHAR2,
81 p_attribute9 IN VARCHAR2,
82 p_attribute10 IN VARCHAR2,
83 p_attribute11 IN VARCHAR2,
84 p_attribute12 IN VARCHAR2,
85 p_attribute13 IN VARCHAR2,
86 p_attribute14 IN VARCHAR2,
87 p_attribute15 IN VARCHAR2,
88 p_last_updated_by IN NUMBER DEFAULT fnd_global.user_id,
89 p_last_update_date IN DATE DEFAULT SYSDATE,
90 p_last_update_login IN NUMBER DEFAULT fnd_global.user_id,
91 p_record_version_number IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
92 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
93 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
94 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
95 p_status_list_id IN NUMBER,
96 p_obj_status_list_id IN NUMBER
97 );
98
99 PROCEDURE delete_ci_type (
100 p_api_version IN NUMBER := 1.0,
101 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
102 p_commit IN VARCHAR2 := FND_API.g_false,
103 p_validate_only IN VARCHAR2 := FND_API.g_true,
104 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
105 p_ci_type_id IN NUMBER,
106 p_record_version_number IN NUMBER,
107 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
108 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
109 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
110 p_obj_status_list_id IN NUMBER
111 );
112
113 END pa_ci_types_pvt;