1 PACKAGE BOMPCOAN AS
2 /* $Header: BOMCOANS.pls 120.1 2005/06/21 12:00:41 rfarook noship $ */
3 /*==========================================================================+
4 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5 | All rights reserved. |
6 +===========================================================================+
7 | |
8 | File Name : BOMCOANS.pls |
9 | DESCRIPTION : |
10 | This file creates a packaged procedure that performs ECO |
11 | autonumbering. When passed a user id and an organization |
12 | id, it searches for a valid ECO autonumber prefix and next |
13 | available number, searching in the following order: |
14 | 1 - specific user, specific organization |
15 | 2 - specific user, across all organizations |
16 | 3 - specific organization, across all users |
17 | 4 - across all users and all organizations |
18 | INPUTS : P_USER_ID - user id |
19 | P_ORGANIZATION_ID - organization id |
20 | P_MODE - indicates whether or not to update next |
21 | available number in the ECO autonumber table |
22 | |
23 +==========================================================================*/
24
25 PROCEDURE BOM_ECO_AUTONUMBER
26 (P_USER_ID IN NUMBER,
27 P_ORGANIZATION_ID IN NUMBER,
28 P_MODE IN NUMBER,
29 P_PREFIX IN OUT NOCOPY VARCHAR2);
30
31 END BOMPCOAN;