1 PACKAGE INV_EGO_REVISION_VALIDATE AUTHID CURRENT_USER AS
2 /* $Header: INVEGRVS.pls 120.8.12010000.2 2009/04/15 11:48:12 rmpartha ship $ */
3
4 -- ============================================================================
5 -- API Name: Check_LifeCycle
6 --
7 -- IN: Catalog Group Id
8 -- Lifecycle Id
9 --
10 -- Returns: TRUE if the lifecycle is valid for the catalog group
11 -- FALSE if the lifecycle is NOT valid for the catalog group
12 -- ============================================================================
13 FUNCTION Check_LifeCycle (p_catalog_group_id IN NUMBER,
14 p_lifecycle_id IN NUMBER)
15 RETURN BOOLEAN;
16 -- ============================================================================
17 -- API Name: Check_LifeCycle_Phase
18 --
19 -- IN: Lifecycle Id
20 -- Lifecycle Phase Id
21 --
22 -- Returns: TRUE if the lifecycle phase is valid for the lifecycle
23 -- FALSE if the lifecycle is NOT valid for the lifecycle
24 -- ============================================================================
25 FUNCTION Check_LifeCycle_Phase ( p_lifecycle_id IN NUMBER,
26 p_lifecycle_phase_id IN NUMBER)
27 RETURN BOOLEAN;
28
29
30 -- ============================================================================
31 -- API Name: Get_Initial_LifeCycle_Phase
32 --
33 -- IN: Lifecycle Id
34 --
35 -- Returns: Initial Phase Id if found for the given lifecycle
36 -- 0 if NO phases found for the given lifecycle
37 -- ============================================================================
38 FUNCTION Get_Initial_Lifecycle_Phase ( p_lifecycle_id IN NUMBER)
39 RETURN NUMBER;
40
41 -- ============================================================================
42 -- API Name : validate_items_lifecycle
43 -- Description : This function validates items lifecycle-phase-status.
44 -- Will return 0 if valid lifecycle-phase-status are attached.
45 -- Included here to avoid one more stuffed package.
46 -- ============================================================================
47
48 FUNCTION validate_items_lifecycle(
49 P_Org_Id IN NUMBER
50 ,P_All_Org IN NUMBER DEFAULT 2
51 ,P_Prog_AppId IN NUMBER DEFAULT -1
52 ,P_Prog_Id IN NUMBER DEFAULT -1
53 ,P_Request_Id IN NUMBER DEFAULT -1
54 ,P_User_Id IN NUMBER DEFAULT -1
55 ,P_Login_Id IN NUMBER DEFAULT -1
56 ,P_Set_id IN NUMBER DEFAULT -999
57 ,P_Process_Flag IN NUMBER DEFAULT 4
58 ,X_Err_Text IN OUT NOCOPY VARCHAR2)
59 RETURN INTEGER;
60
61 --Start : Check for data security and user priv.
62 FUNCTION check_data_security(
63 P_Function IN VARCHAR2
64 ,P_Object_Name IN VARCHAR2
65 ,P_Instance_PK1_Value IN VARCHAR2
66 ,P_Instance_PK2_Value IN VARCHAR2 DEFAULT NULL
67 ,P_Instance_PK3_Value IN VARCHAR2 DEFAULT NULL
68 ,P_Instance_PK4_Value IN VARCHAR2 DEFAULT NULL
69 ,P_Instance_PK5_Value IN VARCHAR2 DEFAULT NULL
70 ,P_User_Id IN NUMBER)
71 RETURN VARCHAR2;
72
73 /* Bug: 5238510
74 Added process flag parameter with a default value of 2
75 If the caller wants to pick rows other than thie process
76 flag value they can pass that value explicitly. The behavior
77 remains the same otherwise.
78 */
79 FUNCTION validate_item_user_privileges(
80 P_Org_Id IN NUMBER
81 ,P_All_Org IN NUMBER DEFAULT 2
82 ,P_Prog_AppId IN NUMBER DEFAULT -1
83 ,P_Prog_Id IN NUMBER DEFAULT -1
84 ,P_Request_Id IN NUMBER DEFAULT -1
85 ,P_User_Id IN NUMBER DEFAULT -1
86 ,P_Login_Id IN NUMBER DEFAULT -1
87 ,P_Set_id IN NUMBER DEFAULT -999
88 ,X_Err_Text IN OUT NOCOPY VARCHAR2
89 ,P_Process_flag IN NUMBER DEFAULT 2)
90 RETURN INTEGER;
91 --End : Check for data security and user priv.
92
93 -- ============================================================================
94 -- API Name : Insert_Grants_And_UserAttr
95 -- Description : This procedure will be called from IOI (INVPPROB.pls)
96 -- Will insert records in FND_GRANTS and EGO USER_ATTR table
97 -- Bug: 3033702 Moved this code from INVPPROB.pls
98 -- ============================================================================
99
100 PROCEDURE Insert_Grants_And_UserAttr(P_Set_id IN NUMBER DEFAULT -999);
101
102 -- ============================================================================
103 -- API Name : phase_change_policy
104 -- Description : This procedure will be called from IOI (INVPVALB.pls)
105 -- Stuffed version will return 'ALLOWED' through l_Policy_Code.
106 -- EGO_LIFECYCLE_USER_PUB.get_policy_for_phase_change will be called.
107 -- ============================================================================
108
109 PROCEDURE phase_change_policy(P_ORGANIZATION_ID IN NUMBER
110 ,P_INVENTORY_ITEM_ID IN NUMBER
111 ,P_CURR_PHASE_ID IN NUMBER
112 ,P_FUTURE_PHASE_ID IN NUMBER
113 ,P_PHASE_CHANGE_CODE IN VARCHAR2
114 ,P_LIFECYCLE_ID IN NUMBER
115 ,X_POLICY_CODE OUT NOCOPY VARCHAR2
116 ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
117 ,X_ERRORCODE OUT NOCOPY NUMBER
118 ,X_MSG_COUNT OUT NOCOPY NUMBER
119 ,X_MSG_DATA OUT NOCOPY VARCHAR2);
120 --Start : 2803833
121
122 FUNCTION get_default_template(p_catalog_group_id IN NUMBER) RETURN NUMBER;
123
124 --End 2803833
125
126 ----------------------------------------------------------------
127 --API Name : Sync_Template_Attribute
128 --Description : To sync up operational attribute values in mtl_item_templ_attributes
129 -- with ego_templ_attributes
130 --parameters:
131 -- p_attribute_name is the full attribute name in mtl_item_templ_attributes
132 ----------------------------------------------------------------
133
134 PROCEDURE Sync_Template_Attribute(
135 p_template_id IN NUMBER,
136 p_attribute_name IN VARCHAR2 DEFAULT NULL);
137
138 ------------------------------------------------------------------------------------------
139 --API Name : Update_Attribute_Control_Level
140 --Description : To update the control level of an attribute in EGO_FND_DF_COL_USGS_EXT
141 --Parameteres required : 1) p_control_level is a valid control level
142 -- as represented in lookup 'EGO_PC_CONTROL_LEVEL' in fnd_lookups
143 -- 2) p_application_column_name is not null and is a valid column name
144 ------------------------------------------------------------------------------------------
145 PROCEDURE Update_Attribute_Control_Level (
146 p_application_column_name IN VARCHAR2
147 ,p_control_level IN NUMBER
148 );
149
150 ------------------------------------------------------------------------------------------
151 --API Name : Pending_Eco_Check_Sync_Ids
152 --Description : Pending ECO check and sync lifecycles
153 ------------------------------------------------------------------------------------------
154 --Start : 3637854
155 PROCEDURE Pending_Eco_Check_Sync_Ids(
156 P_Prog_AppId IN NUMBER DEFAULT -1
157 ,P_Prog_Id IN NUMBER DEFAULT -1
158 ,P_Request_Id IN NUMBER DEFAULT -1
159 ,P_User_Id IN NUMBER DEFAULT -1
160 ,P_Login_Id IN NUMBER DEFAULT -1
161 ,P_Set_id IN NUMBER DEFAULT -999);
162 --End : 3637854
163
164 ------------------------------------------------------------------------------------------
165 --API Name : Upgrade_cat_User_Attrs_Data
166 --Description : Bug: 3527633 Added for EGO
167 -- There are certain extensible attribute groups that are associated with the
168 -- default category set of the product reporting functional area. When the
169 -- default category set is changed we need to call an EGO API that will
170 -- automatically associate these attribute groups with the new category set.
171 --Parameteres required : 1) p_functional_area_id is a unctional area
172 ------------------------------------------------------------------------------------------
173 PROCEDURE Upgrade_cat_User_Attrs_Data ( p_functional_area_id IN NUMBER );
174
175 ------------------------------------------------------------------------------------------
176 --API Name : Check_No_MFG_Associations
177 --Description : Bug: 3735702 Added for EGO
178 -- There are certain associations to the manufacturers which are used by EGO
179 -- So, when deleting the Manufacturer, we need to check for the associations
180 -- and flash an error if any associations exist
181 --Parameteres required : 1) p_manufacturer_id 2)p_api_version
182 --Return parameteres : 1) x_return_status = 'Y' if no associations exist
183 -- 'N' in all other cases
184 -- 2) x_message_text = valid only if x_return_status = 'N'
185 ------------------------------------------------------------------------------------------
186 PROCEDURE Check_No_MFG_Associations
187 (p_api_version IN NUMBER
188 ,p_manufacturer_id IN NUMBER
189 ,p_manufacturer_name IN VARCHAR2
190 ,x_return_status OUT NOCOPY VARCHAR2
191 ,x_message_name OUT NOCOPY VARCHAR2
192 ,x_message_text OUT NOCOPY VARCHAR2
193 );
194
195 ------------------------------------------------------------------------------------------
196 --API Name : Check_Template_Cat_Assocs
197 --Description : Bug# 3326991 Added for Delete template Operation.
198 --This procedure is used in the deletion of Item templates in the form
199 --INVIDTMP.fmb (MTL_ITEM_TEMPLATES.check_delete_row)
200
201 -- An Item Template cannot be deleted if any associations to catalog categories exist
202
203 --Parameteres required : 1) p_template_id
204 --Return parametere : 1) x_return_status = 1 if no associations exist
205 -- 0 in all other cases
206 ------------------------------------------------------------------------------------------
207 PROCEDURE CHECK_TEMPLATE_CAT_ASSOCS
208 (p_template_id IN NUMBER
209 ,x_return_status OUT NOCOPY NUMBER
210 );
211
212 -- Added for 11.5.10+ UCCnet functionality
213 ------------------------------------------------------------------------------------------
214 --API Name : Process_UCCnet_Attributes
215 --Description : Calls the method to update the REGISTRATION_UPDATE_DATE
216 -- and TP_NEUTRAL_UPDATE_DATE for each Item/GTIN, when the respective
217 -- attributes are changed
218 ------------------------------------------------------------------------------------------
219 PROCEDURE Process_UCCnet_Attributes(
220 P_Prog_AppId IN NUMBER DEFAULT -1
221 ,P_Prog_Id IN NUMBER DEFAULT -1
222 ,P_Request_Id IN NUMBER DEFAULT -1
223 ,P_User_Id IN NUMBER DEFAULT -1
224 ,P_Login_Id IN NUMBER DEFAULT -1
225 ,P_Set_id IN NUMBER DEFAULT -999);
226
227 /*------------------------------------------------------------------------------------------
228 --API Name : Create_New_Item_Request
229 --Description : Bug# 3777954
230 --This procedure is used to create new item request for an item with 'CREATE' option.
231 -- Only for EGO IOI and excel from PLM this needs to be called.
232
233 --Parameteres required : 1) p_set_process_id => request id that needs to be processed
234 ------------------------------------------------------------------------------------------*/
235 PROCEDURE Create_New_Item_Request
236 ( p_set_process_id NUMBER);
237
238 FUNCTION Get_Process_Control RETURN VARCHAR2;
239
240 /*------------------------------------------------------------------------------------------
241 --API Name : Set_Process_Control
242 --Description : Bug# 3777954
243 --This procedure is used to set the G_PROCESS_CONTROL to control teh process flow for PLM.
244 -- Only for EGO IOI and excel from PLM this needs to be called.
245
246 --Parameteres required : 1) p_process_control => "NO_NIR" means NIR will not be created.
247 => "RAISE_NO_EVENT" post event will not be fired
248 ------------------------------------------------------------------------------------------*/
249 PROCEDURE Set_Process_Control(p_process_control VARCHAR2);
250
251 -- ============================================================================
252 -- API Name : Populate_Seq_Gen_Item_Nums
253 -- Description : This procedure will be called from IOI
254 -- (after org and catalog category details are resolved)
255 -- to populate the item numbers for all the sequence generated items.
256 -- ============================================================================
257 /* Added to fix Bug#8434681: Sets the variable that tells if code flow is coming from Open API */
258 FUNCTION Get_Process_Control_HTML_API RETURN VARCHAR2;
259
260 /* Added to fix Bug#8434681: Returns the value of the variable that tells if code flow is coming from Open API */
261 PROCEDURE Set_Process_Control_HTML_API(p_process_control VARCHAR2);
262
263
264 PROCEDURE Populate_Seq_Gen_Item_Nums
265 (p_set_id IN NUMBER
266 ,p_org_id IN NUMBER
267 ,p_all_org IN NUMBER
268 ,p_rec_status IN NUMBER
269 ,x_return_status OUT NOCOPY VARCHAR2
270 ,x_msg_count OUT NOCOPY NUMBER
271 ,x_msg_data OUT NOCOPY VARCHAR2);
272
273 PROCEDURE Insert_Revision_UserAttr(P_Set_id IN NUMBER DEFAULT -999);
274
275 --Added for bug 5435229
276 PROCEDURE apply_default_uda_values(P_Set_id IN NUMBER DEFAULT -999, p_commit IN NUMBER DEFAULT 1); /* Added p_commit to fix Bug#7422423*/
277
278 -- ============================================================================
279 -- API Name : Check_Org_Access
280 -- Description : This procedure will be called from IOI to check if org_access_view
281 -- has this org
282 -- ============================================================================
283 FUNCTION Check_Org_Access (p_org_id IN NUMBER)
284 RETURN VARCHAR2;
285
286 END INV_EGO_REVISION_VALIDATE;
287