1 PACKAGE PA_SYSTEM_NUMBERS_PKG AUTHID CURRENT_USER AS
2 --$Header: PASNUMTS.pls 115.4 2002/12/21 00:24:38 mwasowic noship $
3
4 procedure GET_NEXT_NUMBER (
5 p_system_number_id IN NUMBER := NULL
6 ,p_object1_pk1_value IN NUMBER := NULL
7 ,p_object1_type IN VARCHAR2 := NULL
8 ,p_object2_pk1_value IN NUMBER := NULL
9 ,p_object2_type IN VARCHAR2 := NULL
10
11 ,x_system_number_id OUT NOCOPY NUMBER
12 ,x_next_number OUT NOCOPY NUMBER
13 ,x_return_status OUT NOCOPY VARCHAR2
14 ,x_msg_count OUT NOCOPY NUMBER
15 ,x_msg_data OUT NOCOPY VARCHAR2
16 );
17
18 procedure INSERT_ROW (
19 p_object1_pk1_value IN NUMBER
20 ,p_object1_type IN VARCHAR2
21
22 ,p_object2_pk1_value IN NUMBER := NULL
23 ,p_object2_type IN VARCHAR2 := NULL
24 ,p_next_number IN NUMBER := NULL
25
26 ,x_next_number OUT NOCOPY NUMBER
27 ,x_system_number_id OUT NOCOPY NUMBER
28 ,x_return_status OUT NOCOPY VARCHAR2
29 ,x_msg_count OUT NOCOPY NUMBER
30 ,x_msg_data OUT NOCOPY VARCHAR2
31
32 );
33
34 procedure UPDATE_ROW (
35 p_system_number_id IN NUMBER := NULL
36 ,p_object1_pk1_value IN NUMBER := NULL
37 ,p_object1_type IN VARCHAR2 := NULL
38
39 ,p_object2_pk1_value IN NUMBER := NULL
40 ,p_object2_type IN VARCHAR2 := NULL
41 ,p_next_number IN NUMBER := NULL
42
43 ,x_return_status OUT NOCOPY VARCHAR2
44 ,x_msg_count OUT NOCOPY NUMBER
45 ,x_msg_data OUT NOCOPY VARCHAR2
46
47
48 );
49
50 procedure DELETE_ROW (
51 p_system_number_id IN NUMBER := NULL
52 ,p_object1_pk1_value IN NUMBER := NULL
53 ,p_object1_type IN VARCHAR2 := NULL
54 ,p_object2_pk1_value IN NUMBER := NULL
55 ,p_object2_type IN VARCHAR2 := NULL
56
57 ,x_return_status OUT NOCOPY VARCHAR2
58 ,x_msg_count OUT NOCOPY NUMBER
59 ,x_msg_data OUT NOCOPY VARCHAR2
60 );
61
62 END PA_SYSTEM_NUMBERS_PKG;