1 PACKAGE QA_CHAR_UPDATE_PKG AS
2 /* $Header: qacharus.pls 120.0 2005/05/24 18:31:42 appldev noship $ */
3
4 --
5 -- FILE NAME
6 -- qacharus.pls
7 --
8 -- PACKAGE NAME
9 -- QA_CHAR_UPDATE_PKG
10 --
11 -- DESCRIPTION
12 -- This package is used for Updating all instances QA Schema when a value
13 -- stored for a Collection Element has changed externally.
14 --
15 -- This package was primarily created for handling FND User Name Changes
16 -- Which are propagated to impacted products using a Workflow Business
17 -- Event Subscription ( oracle.apps.fnd.wf.ds.user.nameChanged ).
18 --
19 -- TRACKING BUG
20 -- 4305107
21 --
22 -- HISTORY
23 -- 12-APR-2005 Sivakumar Kalyanasunderam Created.
24
25
26 -- Wrapper API which is invoked by the business event subscription
27 -- when FND User Name Changes
28 FUNCTION Update_User_Name
29 (
30 p_subscription_guid IN RAW,
31 p_event IN OUT NOCOPY WF_EVENT_T
32 ) RETURN VARCHAR2;
33
34 -- Core API which would accept the element, old value and new value
35 -- and update all instances where the old value is stored
36 -- with the new value.
37 PROCEDURE Update_Element_Value
38 (
39 p_api_version IN NUMBER := NULL,
40 p_init_msg_list IN VARCHAR2 := NULL,
41 p_commit IN VARCHAR2 := NULL,
42 p_validation_level IN NUMBER := NULL,
43 p_char_id IN NUMBER,
44 p_old_value IN VARCHAR2,
45 p_new_value IN VARCHAR2,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2
49 );
50
51 END QA_CHAR_UPDATE_PKG;