1 PACKAGE PO_UNIT_OF_MEASURES_SV1 AS
2 /* $Header: POXPIUMS.pls 120.0.12000000.1 2007/07/27 08:30:23 grohit noship $ */
3
4 /*==================================================================
5 FUNCTION NAME: val_unit_of_measure()
6
7 DESCRIPTION: This API is used to validate x_uom_code or
8 X_unit_of_measure specified
9 is valid and active.
10
11 PARAMETERS: x_uom_code IN VARCHAR2
12 x_unit_of_measure IN VARCHAR2
13
14 DESIGN
15 REFERENCES: 832vlapl.doc
16
17 ALGORITHM: API returns TRUE if validation succeeds, FALSE
18 otherwise.
19
20 NOTES:
21
22 OPEN ISSUES:
23
24 CLOSE ISSUES:
25
26 CHANGE
27 HISTORY: Created 19-FEB-1996 DXYU
28 Modified 29-APR-96 KKCHAN
29
30
31 =======================================================================*/
32 FUNCTION val_unit_of_measure(x_unit_of_measure IN VARCHAR2,
33 x_uom_code IN VARCHAR2)
34 RETURN BOOLEAN;
35
36 /*======================================================================
37 FUNCTION NAME: val_item_unit_of_measure()
38
39 DESCRIPTION: This API is used to validate x_item_unit_of_measure
40 specified is valid and active.
41
42 PARAMETERS: x_item_unit_of_measure IN VARCHAR2,
43 x_item_id IN NUMBER,
44 x_organization_id IN NUMBER
45
46
47 DESIGN REFERENCES: 832vlapl.doc
48
49 ALGORITHM: API returns TRUE if validation succeeds, FALSE
50 otherwise.
51
52 NOTES:
53
54 OPEN ISSUES:
55
56 CLOSE ISSUES:
57
58 CHANGE HISTORY: Created 19-FEB-1996 DXYU
59 Modified 07-Jun-1996 KKCHAN
60 * changed API name to val_item_unit_of_measure
61
62 =======================================================================*/
63
64 FUNCTION val_item_unit_of_measure(x_item_unit_of_measure IN VARCHAR2,
65 x_item_id IN NUMBER,
66 x_organization_id IN NUMBER ) RETURN BOOLEAN;
67
68
69 /*======================================================================
70 FUNCTION NAME: derive_unit_of_measure()
71
72 DESCRIPTION: This API is used to derive the unit_of_measure
73 given the uom_code as an input parameter.
74
75 PARAMETERS: x_uom_code IN VARCHAR2
76
77
78 DESIGN REFERENCES: 832dvapi.dd
79
80 ALGORITHM: API returns unit_of_measure (VARCHAR2) if found,
81 NULL otherwise.
82
83 NOTES:
84
85 OPEN ISSUES:
86
87 CLOSE ISSUES:
88
89 CHANGE HISTORY: Created 19-FEB-1996 SODAYAR
90
91 =======================================================================*/
92 FUNCTION derive_unit_of_measure(X_uom_code IN VARCHAR2)
93 RETURN VARCHAR2;
94
95 END PO_UNIT_OF_MEASURES_SV1;