1 PACKAGE PA_UTILS_SQNUM_PKG AUTHID CURRENT_USER as
2 /* $Header: PAXGSQNS.pls 120.1.12010000.2 2008/09/27 09:27:04 bifernan ship $ */
3
4
5 /*----------------------------------------------------------+
6 | get_unique_proj_num : a procedure to get a unique number |
7 | for the automatic project number. |
8 | |
9 | unique_number : contains the returned unique number. |
10 | x_status : contains the returned status. |
11 | |
12 | x_status = 0 if it is successful. |
13 | = 1 if no data found. |
14 | = sqlcode otherwise |
15 +----------------------------------------------------------*/
16 PROCEDURE get_unique_proj_num(x_table_name IN VARCHAR2,
17 user_id IN NUMBER,
18 unique_number IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
19 x_status IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
20
21 /*----------------------------------------------------------+
22 | get_unique_invoice_num : a procedure to get a unique |
23 | number for the automatic project number. |
24 | |
25 | unique_number : contains the returned unique number. |
26 | x_status : contains the returned status. |
27 | |
28 | x_status = 0 if it is successful. |
29 | = 1 if no data found. |
30 | = sqlcode otherwise |
31 +----------------------------------------------------------*/
32 PROCEDURE get_unique_invoice_num(invoice_category IN VARCHAR2,
33 user_id IN NUMBER,
34 unique_number IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
35 x_status IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
36
37 -- Bug 7335526
38 /*--------------------------------------------------------------+
39 | revert_unique_proj_num : A procedure to revert a unique |
40 | number for the automatic project number if project |
41 | creation errors out. |
42 | |
43 | p_unique_number : contains the unique number which should |
44 | be reverted. |
45 +---------------------------------------------------------------*/
46 PROCEDURE revert_unique_proj_num(p_table_name IN VARCHAR2,
47 p_user_id IN NUMBER,
48 p_unique_number IN NUMBER) ;
49
50 END PA_UTILS_SQNUM_PKG;