1 PACKAGE GMO_DOCUMENT_NUMBERS_PVT
2 /* $Header: GMOVDNMS.pls 120.3 2006/01/19 09:22 swasubra noship $ */
3
4 AS
5
6 --The package name
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMO_DOCUMENT_NUMBERS_PVT';
8
9 --This PROCEDURE is used to obtain the document number type associated with the
10 --specified organization ID and transaction type.
11 PROCEDURE GET_DOCUMENT_NUMBER_TYPE
12 (P_ORGANIZATION_ID IN NUMBER,
13 P_TRANSACTION_TYPE IN VARCHAR2,
14 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
15 X_DOCUMENT_NUMBER_TYPE OUT NOCOPY VARCHAR2,
16 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
17 X_MSG_COUNT OUT NOCOPY NUMBER,
18 X_MSG_DATA OUT NOCOPY VARCHAR2);
19
20
21 --This PROCEDURE is used to obtain the next document number in sequence associated with the
22 --specified organization ID and transaction type.
23 PROCEDURE GET_NEXT_VALUE
24 (P_ORGANIZATION_ID IN NUMBER,
25 P_TRANSACTION_TYPE IN VARCHAR2,
26 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27 X_VALUE OUT NOCOPY VARCHAR2,
28 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
29 X_MSG_COUNT OUT NOCOPY NUMBER,
30 X_MSG_DATA OUT NOCOPY VARCHAR2);
31
32 --This procedure is used to check if a document number entry exists for the specified
33 --organization and transaction type.
34 PROCEDURE DOES_DOCUMENT_NUMBER_EXIST
35 (P_ORGANIZATION_ID IN NUMBER,
36 P_TRANSACTION_TYPE IN VARCHAR2,
37 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38 X_DOCUMENT_NUMBER_EXISTS OUT NOCOPY VARCHAR2,
39 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
40 X_MSG_COUNT OUT NOCOPY NUMBER,
41 X_MSG_DATA OUT NOCOPY VARCHAR2);
42
43 END GMO_DOCUMENT_NUMBERS_PVT;