1 PACKAGE gmd_conc_replace_pkg AUTHID CURRENT_USER AS
2 /* $Header: GMDROPRS.pls 115.12 2004/07/04 02:22:14 txdaniel noship $ */
3
4
5 P_last_update_date Date := SYSDATE;
6 P_last_updated_by NUMBER := FND_PROFILE.VALUE('USER_ID');
7 P_last_update_login NUMBER := FND_PROFILE.VALUE('LOGIN_ID');
8
9 TYPE Search_Result_Rec IS RECORD (
10 object_id NUMBER
11 ,object_name VARCHAR2(240)
12 ,object_vers NUMBER
13 ,object_desc VARCHAR2(240)
14 ,object_status_desc VARCHAR2(240)
15 ,object_select_ind NUMBER
16 ,object_status_code VARCHAR2(240) );
17
18
19 TYPE Search_Result_Tbl IS TABLE OF Search_Result_Rec INDEX BY BINARY_INTEGER;
20
21 Procedure Populate_search_table(X_search_tbl OUT NOCOPY Search_Result_Tbl);
22
23 PROCEDURE Mass_Replace_Operation ( err_buf OUT NOCOPY VARCHAR2,
24 ret_code OUT NOCOPY VARCHAR2,
25 pConcurrent_id IN NUMBER DEFAULT NULL,
26 pObject_type IN VARCHAR2,
27 pReplace_type IN VARCHAR2,
28 pOld_Name IN VARCHAR2,
29 pNew_Name IN VARCHAR2,
30 pOld_Version IN VARCHAR2 DEFAULT NULL,
31 pNew_Version IN VARCHAR2 DEFAULT NULL,
32 pScale_factor IN VARCHAR2 DEFAULT '1',
33 pVersion_flag IN VARCHAR2 DEFAULT 'N',
34 pCreate_Recipe IN NUMBER DEFAULT 0
35 );
36
37 PROCEDURE Validate_All_Replace_Rows( pObject_type IN VARCHAR2,
38 pReplace_type IN VARCHAR2,
39 pOld_Name IN VARCHAR2,
40 pRows_Processed OUT NOCOPY NUMBER,
41 x_return_status OUT NOCOPY VARCHAR2
42 );
43 END GMD_CONC_REPLACE_PKG;