1 package PA_CONTROL_API_PVT AUTHID DEFINER as
2 /*$Header: PACIAMVS.pls 120.0 2006/11/24 08:24:46 vgottimu noship $*/
3
4 G_PA_MISS_NUM CONSTANT NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
5 G_PA_MISS_DATE CONSTANT DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
6 G_PA_MISS_CHAR CONSTANT VARCHAR2(3) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
7
8
9
10 /*The update_impacts procedure will be called from Add_<impact_type>_impact and
11 update_<impact_type>_impact to create the impact, to update the details of impact and also
12 to implement the impact.*/
13 Procedure update_impacts (
14 p_ci_id IN NUMBER := G_PA_MISS_NUM,
15 x_ci_impact_id OUT NOCOPY NUMBER,
16 p_impact_type_code IN VARCHAR2 := G_PA_MISS_CHAR,
17 p_impact_description IN VARCHAR2 := G_PA_MISS_CHAR,
18 p_mode IN VARCHAR2,
19 p_commit IN VARCHAR2 := FND_API.G_FALSE,
20 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
21 p_api_version_number IN NUMBER ,
22 x_return_status OUT NOCOPY VARCHAR2,
23 x_msg_count OUT NOCOPY NUMBER,
24 x_msg_data OUT NOCOPY VARCHAR2
25 );
26
27
28
29 /*This Procedure will be called from add_supplier_impact procedure
30 to insert the details of the supplier*/
31 Procedure add_supplier_details (
32 p_ci_id IN NUMBER := G_PA_MISS_NUM,
33 p_ci_impact_id IN NUMBER ,
34 p_supplier_det_tbl IN PA_CONTROL_API_PUB.SUPP_DET_TBL_TYPE,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2
38 );
39
40
41 PROCEDURE check_create_ci_allowed
42 (
43 p_project_id IN OUT NOCOPY NUMBER,
44 p_project_name IN VARCHAR2 := null,
45 p_project_number IN VARCHAR2 := null,
46 p_ci_type_class_code IN VARCHAR2 := null,
47 p_ci_type_id IN OUT NOCOPY NUMBER,
48 x_ci_type_class_code OUT NOCOPY VARCHAR2,
49 x_auto_number_flag OUT NOCOPY VARCHAR2,
50 x_source_attrs_enabled_flag OUT NOCOPY VARCHAR2,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2
54 );
55
56 PROCEDURE validate_param_and_create(
57 p_orig_system_code IN VARCHAR2
58 ,p_orig_system_reference IN VARCHAR2
59 ,p_project_id IN NUMBER := null
60 ,p_ci_type_id IN NUMBER := null
61 ,p_auto_number_flag IN VARCHAR2 := null
62 ,p_source_attrs_enabled_flag IN VARCHAR2 := null
63 ,p_ci_type_class_code IN VARCHAR2 := null
64 ,p_summary IN VARCHAR2
65 ,p_ci_number IN VARCHAR2 := null
66 ,p_description IN VARCHAR2 := null
67 ,p_status_code IN VARCHAR2 := null
68 ,p_status IN VARCHAR2 := null
69 ,p_owner_id IN NUMBER := null
70 ,p_highlighted_flag IN VARCHAR2 := 'N'
71 ,p_progress_status_code IN VARCHAR2 := null
72 ,p_progress_as_of_date IN DATE := null
73 ,p_status_overview IN VARCHAR2 := null
74 ,p_classification_code IN NUMBER
75 ,p_reason_code IN NUMBER
76 ,p_object_id IN NUMBER := null
77 ,p_object_type IN VARCHAR2 := null
78 ,p_date_required IN DATE := null
79 ,p_date_closed IN DATE := null
80 ,p_closed_by_id IN NUMBER := null
81 ,p_resolution IN VARCHAR2 := null
82 ,p_resolution_code IN NUMBER := null
83 ,p_priority_code IN VARCHAR2 := null
84 ,p_effort_level_code IN VARCHAR2 := null
85 ,p_price IN NUMBER := null
86 ,p_price_currency_code IN VARCHAR2 := null
87 ,p_source_type_name IN VARCHAR2 := null
88 ,p_source_type_code IN VARCHAR2 := null
89 ,p_source_number IN VARCHAR2 := null
90 ,p_source_comment IN VARCHAR2 := null
91 ,p_source_date_received IN DATE := null
92 ,p_source_organization IN VARCHAR2 := null
93 ,p_source_person IN VARCHAR2 := null
94 ,p_attribute_category IN VARCHAR2 := null
95 ,p_attribute1 IN VARCHAR2 := null
96 ,p_attribute2 IN VARCHAR2 := null
97 ,p_attribute3 IN VARCHAR2 := null
98 ,p_attribute4 IN VARCHAR2 := null
99 ,p_attribute5 IN VARCHAR2 := null
100 ,p_attribute6 IN VARCHAR2 := null
101 ,p_attribute7 IN VARCHAR2 := null
102 ,p_attribute8 IN VARCHAR2 := null
103 ,p_attribute9 IN VARCHAR2 := null
104 ,p_attribute10 IN VARCHAR2 := null
105 ,p_attribute11 IN VARCHAR2 := null
106 ,p_attribute12 IN VARCHAR2 := null
107 ,p_attribute13 IN VARCHAR2 := null
108 ,p_attribute14 IN VARCHAR2 := null
109 ,p_attribute15 IN VARCHAR2 := null
110 ,x_ci_id OUT NOCOPY NUMBER
111 ,x_ci_number OUT NOCOPY NUMBER
112 ,x_return_status OUT NOCOPY VARCHAR2
113 ,x_msg_count OUT NOCOPY NUMBER
114 ,x_msg_data OUT NOCOPY VARCHAR2
115 );
116
117 procedure check_create_action_allow(
118 p_ci_id IN NUMBER := null,
119 x_project_id OUT NOCOPY NUMBER,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2);
123
124 procedure validate_assignee_id(
125 p_assignee_id IN NUMBER
126 ,p_project_id IN NUMBER
127 ,p_msg_token_num IN NUMBER DEFAULT NULL
128 ,x_assignee_id OUT NOCOPY NUMBER
129 ,x_return_status OUT NOCOPY VARCHAR2
130 ,x_msg_count OUT NOCOPY NUMBER
131 ,x_msg_data OUT NOCOPY VARCHAR2
132 );
133
134 procedure validate_action_attributes(
135 p_ci_id IN NUMBER
136 ,p_project_id IN NUMBER
137 ,p_action_tbl IN pa_control_api_pub.ci_actions_in_tbl_type
138 ,x_action_tbl OUT NOCOPY pa_control_api_pub.ci_actions_in_tbl_type
139 ,x_return_status OUT NOCOPY VARCHAR2
140 ,x_msg_count OUT NOCOPY NUMBER
141 ,x_msg_data OUT NOCOPY VARCHAR2
142 );
143
144 procedure create_action(
145 p_action_tbl IN pa_control_api_pub.ci_actions_in_tbl_type
146 ,p_ci_id IN NUMBER := null
147 ,x_action_tbl OUT NOCOPY pa_control_api_pub.ci_actions_out_tbl_type
148 ,x_return_status OUT NOCOPY VARCHAR2
149 ,x_msg_count OUT NOCOPY NUMBER
150 ,x_msg_data OUT NOCOPY VARCHAR2
151 );
152
153 procedure validate_priv_and_action(
154 p_ci_id IN NUMBER
155 ,p_action_id IN NUMBER
156 ,p_action_number IN NUMBER
157 ,x_action_id OUT NOCOPY NUMBER
158 ,x_assignee_id OUT NOCOPY NUMBER
159 ,x_project_id OUT NOCOPY NUMBER
160 ,x_return_status OUT NOCOPY VARCHAR2
161 ,x_msg_count OUT NOCOPY NUMBER
162 ,x_msg_data OUT NOCOPY VARCHAR2
163 );
164
165
166 Procedure Delete_CI (
167 p_Commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
168 , p_Init_Msg_List IN VARCHAR2 DEFAULT FND_API.G_FALSE
169 , p_Api_Version_Number IN NUMBER
170 , p_Ci_Id IN NUMBER
171 , x_Return_Status OUT NOCOPY VARCHAR2
172 , x_Msg_Count OUT NOCOPY NUMBER
173 , x_Msg_Data OUT NOCOPY VARCHAR2
174 );
175
176
177 END PA_CONTROL_API_PVT;