1 PACKAGE CSM_ITEM_INSTANCE_EVENT_PKG AUTHID CURRENT_USER AS
2 /* $Header: csmeibs.pls 120.2 2006/05/31 12:58:20 trajasek noship $ */
3
4
5 --
6 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
7 -- directory of SQL Navigator
8 --
9 -- Purpose: Briefly explain the functionality of the package
10 --
11 -- MODIFICATION HISTORY
12 -- Person Date Comments
13 -- --------- ------ ------------------------------------------
14 -- Enter package declarations as shown below
15
16 PROCEDURE ITEM_INSTANCE_MDIRTY_U_ECHUSER(p_instance_id IN NUMBER,
17 p_error_msg OUT NOCOPY VARCHAR2,
18 x_return_status IN OUT NOCOPY VARCHAR2);
19
20 PROCEDURE II_RELATIONSHIPS_ACC_I(p_relationship_id IN NUMBER,
21 p_user_id IN NUMBER,
22 p_error_msg OUT NOCOPY VARCHAR2,
23 x_return_status IN OUT NOCOPY VARCHAR2);
24
25 PROCEDURE ITEM_INSTANCES_ACC_PROCESSOR(p_instance_id IN NUMBER,
26 p_user_id IN NUMBER,
27 p_flowtype IN VARCHAR2,
28 p_error_msg OUT NOCOPY VARCHAR2,
29 x_return_status IN OUT NOCOPY VARCHAR2);
30
31 PROCEDURE II_RELATIONSHIPS_ACC_D(p_relationship_id IN NUMBER,
32 p_user_id IN NUMBER,
33 p_error_msg OUT NOCOPY VARCHAR2,
34 x_return_status IN OUT NOCOPY VARCHAR2);
35
36 PROCEDURE ITEM_INSTANCES_ACC_D(p_instance_id IN NUMBER,
37 p_user_id IN NUMBER,
38 p_error_msg OUT NOCOPY VARCHAR2,
39 x_return_status IN OUT NOCOPY VARCHAR2);
40
41 PROCEDURE REFRESH_INSTANCES_ACC (p_status OUT NOCOPY VARCHAR2, p_message OUT NOCOPY VARCHAR2);
42
43 PROCEDURE GET_IB_AT_LOCATION(p_instance_id IN NUMBER, p_party_site_id IN NUMBER, p_party_id IN NUMBER,
44 p_location_id IN NUMBER, p_user_id IN NUMBER, p_flow_type IN VARCHAR2);
45
46 PROCEDURE SPAWN_COUNTERS_INS (p_instance_id IN NUMBER, p_user_id IN NUMBER);
47
48 PROCEDURE DELETE_IB_AT_LOCATION(p_incident_id IN NUMBER, p_instance_id IN NUMBER, p_party_site_id IN NUMBER, p_party_id IN NUMBER,
49 p_location_id IN NUMBER, p_user_id IN NUMBER, p_flow_type IN VARCHAR2);
50
51 PROCEDURE SPAWN_COUNTERS_DEL (p_instance_id IN NUMBER, p_user_id IN NUMBER);
52
53 PROCEDURE DELETE_IB_NOTIN_INV (p_inv_item_id IN NUMBER, p_org_id IN NUMBER, p_user_id IN NUMBER);
54
55 END CSM_ITEM_INSTANCE_EVENT_PKG; -- Package spec
56
57