1 PACKAGE GR_VALIDATE AS
2 /* $Header: GRVALIDS.pls 120.0 2005/06/24 11:07:49 mgrosser noship $ */
3
4 G_TRUE BOOLEAN := TRUE;
5 G_FALSE BOOLEAN := FALSE;
6
7 -- M. Grosser 23-May-2005 Modified code for Inventory Convergence.
8 -- Added IN parameter p_organization_id and OUT parameter x_inventory_item_id
9 --
10 --Validate the Regulatory item.
11 FUNCTION validate_item
12 ( p_organization_id IN NUMBER,
13 p_item IN VARCHAR2,
14 x_inventory_item_id OUT NOCOPY NUMBER
15
16 ) RETURN BOOLEAN;
17
18 -- M. Grosser 23-May-2005 Modified code for Inventory Convergence.
19 -- Added IN parameter p_organization_id and OUT parameter x_inventory_item_id
20 --
21 --Validate the CAS Number and Item relation.
22 FUNCTION validate_cas_number
23 ( p_organization_id IN NUMBER,
24 p_cas_number IN VARCHAR2,
25 x_item OUT NOCOPY VARCHAR2,
26 x_inventory_item_id OUT NOCOPY NUMBER
27 ) RETURN BOOLEAN;
28
29 --Validate the document code.
30 FUNCTION validate_document_code
31 ( p_document_code IN VARCHAR2
32 ) RETURN BOOLEAN;
33
34 --Validate the disclosure code.
35 FUNCTION validate_disclosure_code
36 ( p_disclosure_code IN VARCHAR2
37 ) RETURN BOOLEAN;
38
39 --Validate the dispatch method.
40 FUNCTION validate_dispatch_method_code
41 ( p_dispatch_method_code IN VARCHAR2
42 ) RETURN BOOLEAN;
43
44 --Validate the recipient id.
45 FUNCTION validate_recipient_id
46 ( p_recipient_id IN NUMBER
47 ) RETURN BOOLEAN;
48
49 --Validate the recipient site id.
50 FUNCTION validate_recipient_site_id
51 ( p_recipient_id IN NUMBER,
52 p_recipient_site_id IN NUMBER
53 ) RETURN BOOLEAN;
54
55 END GR_VALIDATE;
[Home] [Help]