DBA Data[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;