1 PACKAGE AS_RESOURCE_MERGE_PUB AUTHID CURRENT_USER AS
2 /* $Header: asxrsmrs.pls 115.0 2004/01/23 01:31:12 ffang noship $ */
3
4 -- Start of Comments
5 -- Package name : AS_RESOURCE_MERGE_PUB
6 --
7 -- Purpose : This package should be called in event subscription of
8 -- event oracle.apps.jtf.jres.resource.update.effectdate.
9 -- It will update the salesforce_id(resource_id) column in AS
10 -- tables due to resource merge.
11 --
12 -- NOTES
13 --
14 -- HISTORY
15 -- 12/31/03 FFANG Created.
16 --
17 --
18
19 FUNCTION update_resource_enddate (
20 p_subscription_guid in raw,
21 p_event in out NOCOPY wf_event_t )
22 RETURN VARCHAR2;
23
24 END AS_RESOURCE_MERGE_PUB;