1 PACKAGE CSM_PARTY_SITE_EVENT_PKG AUTHID CURRENT_USER AS
2 /* $Header: csmeptss.pls 120.1 2005/07/25 00:18:34 trajasek noship $ */
3
4 --
5 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
6 -- directory of SQL Navigator
7 --
8 -- Purpose: Briefly explain the functionality of the package
9 --
10 -- MODIFICATION HISTORY
11 -- Person Date Comments
12 -- --------- ------ ------------------------------------------
13 -- Enter package declarations as shown below
14
15 PROCEDURE PARTY_SITES_ACC_I (p_party_site_id IN NUMBER,
16 p_user_id IN NUMBER,
17 p_flowtype IN VARCHAR2,
18 p_error_msg OUT NOCOPY VARCHAR2,
19 x_return_status IN OUT NOCOPY VARCHAR2
20 );
21
22 PROCEDURE PARTY_SITES_ACC_D (p_party_site_id IN NUMBER,
23 p_user_id IN NUMBER,
24 p_flowtype IN VARCHAR2,
25 p_error_msg OUT NOCOPY VARCHAR2,
26 x_return_status IN OUT NOCOPY VARCHAR2
27 );
28
29 PROCEDURE PARTY_SITES_ACC_U (p_party_site_id IN NUMBER,
30 p_user_id IN NUMBER,
31 p_error_msg OUT NOCOPY VARCHAR2,
32 x_return_status IN OUT NOCOPY VARCHAR2
33 );
34
35 FUNCTION LOCATION_UPD_WF_EVENT_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)
36 RETURN VARCHAR2;
37
38 FUNCTION PARTY_SITE_UPD_WF_EVENT_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)
39 RETURN VARCHAR2;
40
41 END CSM_PARTY_SITE_EVENT_PKG; -- Package spec
42
43
44