[Home] [Help]
PACKAGE: APPS.OEONUM
Source
1 PACKAGE OEONUM AUTHID CURRENT_USER AS
2 /* $Header: OEXONUMS.pls 115.1 99/07/16 08:13:55 porting shi $ */
3
4
5 PROCEDURE dummy;
6
7 PROCEDURE CreateSource
8 (
9 sequence_name IN VARCHAR2,
10 cache IN NUMBER,
11 min_value IN NUMBER,
12 start_with IN NUMBER,
13 return_status OUT NUMBER
14 );
15
16 PROCEDURE GetCurrentNumber
17 (
18 sequence_name IN VARCHAR2,
19 returned_sequence OUT NUMBER,
20 return_status OUT NUMBER
21 );
22
23 PROCEDURE GetNextNumber
24 (
25 sequence_name IN VARCHAR2,
26 returned_sequence OUT NUMBER,
27 return_status OUT NUMBER
28 );
29
30 PROCEDURE OrderNumberSequence
31 (
32 source_id IN NUMBER,
33 action IN NUMBER,
34 cache IN NUMBER DEFAULT 100,
35 min_value IN NUMBER DEFAULT 1,
36 start_with IN NUMBER DEFAULT 1,
37 returned_sequence OUT NUMBER,
38 return_status OUT NUMBER
39 );
40
41 PROCEDURE Raise_exception
42 (
43 Routine IN VARCHAR2,
44 Operation IN VARCHAR2,
45 Message IN VARCHAR2
46 );
47
48
49 END OEONUM;