PACKAGE: APPS.AHL_UTIL_MC_PKG

Source

1 Package AHL_UTIL_MC_PKG AUTHID CURRENT_USER AS
2 /* $Header: AHLUMCS.pls 115.6 2003/07/31 14:07:41 tamdas noship $ */
3 
4 ----------------------------------------------------
5 -- Function to validate existence of lookup code  --
6 ----------------------------------------------------
7 Function  Validate_Lookup_Code
8 (
9 	p_lookup_type  IN  VARCHAR2,
10 	p_lookup_code  IN  VARCHAR2
11 )
12 RETURN BOOLEAN;
13 
14 -------------------------------------------------------
15 -- Procedure to return lookup meaning given the code --
16 -------------------------------------------------------
17 PROCEDURE Convert_To_LookupMeaning
18 (
19 	p_lookup_type     IN   VARCHAR2,
20 	p_lookup_code     IN   VARCHAR2,
21 	x_lookup_meaning  OUT  NOCOPY VARCHAR2,
22 	x_return_val      OUT  NOCOPY BOOLEAN
23 );
24 
25 --------------------------------------------------------
26 -- Procedure to return lookup code  given the meaning --
27 --------------------------------------------------------
28 PROCEDURE Convert_To_LookupCode
29 (
30 	p_lookup_type     IN   VARCHAR2,
31 	p_lookup_meaning  IN   VARCHAR2,
32 	x_lookup_code     OUT  NOCOPY VARCHAR2,
33 	x_return_val      OUT  NOCOPY BOOLEAN
34 );
35 
36 -----------------------------------------------------
37 -- Procedure to validate existence of relationship --
38 -----------------------------------------------------
39 Procedure Validate_Relationship
40 (
41 	p_relationship_id IN   NUMBER,
42 	x_return_val      OUT  NOCOPY BOOLEAN
43 );
44 
45 ----------------------------------------------------
46 -- Procedure to check existence of a relationship --
47 -- and if found, returns the position_ref_code    --
48 ----------------------------------------------------
49 Procedure Validate_Relationship
50 (
51 	p_relationship_id    IN   NUMBER,
52 	x_position_ref_code  OUT  NOCOPY VARCHAR2,
53 	x_return_val         OUT  NOCOPY BOOLEAN
54 );
55 
56 --------------------------------------
57 -- Procedure to validate Item group --
58 --------------------------------------
59 PROCEDURE Validate_Item_Group
60 (
61 	p_item_group_id  IN  NUMBER,
62 	x_return_val     OUT NOCOPY BOOLEAN
63 );
64 
65 END AHL_UTIL_MC_PKG;