1 PACKAGE PO_UN_NUMBERS_SV1 AS
2 /* $Header: POXPIUNS.pls 120.0.12000000.1 2007/07/27 08:35:58 grohit noship $ */
3
4 /*==================================================================
5 FUNCTION NAME: val_un_number_id()
6
7 DESCRIPTION: This API is used to validate x_un_number_id specified
8 is valid and active.
9
10 PARAMETERS: x_un_number_id IN NUMBER
11
12 DESIGN
13 REFERENCES: 832vlapl.doc
14
15 ALGORITHM: API returns TRUE if validation succeeds, FALSE
16 otherwise.
17
18 NOTES:
19
20 OPEN ISSUES:
21
22 CLOSE ISSUES:
23
24 CHANGE
25 HISTORY: Created 19-FEB-1996 DXYU
26
27
28 =======================================================================*/
29 FUNCTION val_un_number_id(x_un_number_id IN NUMBER) RETURN BOOLEAN;
30
31 /*==================================================================
32 FUNCTION NAME: derive_un_number_id()
33
34 DESCRIPTION: This API is used to derive un_number_id given
35 un_number as input parameter.
36
37 PARAMETERS: x_un_number IN VARCHAR2
38
39 DESIGN
40 REFERENCES: 832dvapl.doc
41
42 ALGORITHM: API return un_number_id (NUMBER) if found, NULL
43 otherwise.
44
45 NOTES:
46
47 OPEN ISSUES:
48
49 CLOSE ISSUES:
50
51 CHANGE
52 HISTORY: Created 19-FEB-1996 SODAYAR
53
54
55 =======================================================================*/
56 FUNCTION derive_un_number_id(X_un_number IN VARCHAR2)
57 return NUMBER;
58
59 END PO_UN_NUMBERS_SV1;
[Home] [Help]