DBA Data[Home] [Help]

PACKAGE: APPS.ASO_DEPENDENCY_UTIL

Source


1 PACKAGE ASO_DEPENDENCY_UTIL AS
2 /* $Header: asovdpus.pls 120.1 2005/06/29 12:41:38 appldev noship $ */
3 -- Package name     : ASO_DEPENDENCY_UTIL
4 -- Purpose          :
5 -- History          :
6 -- NOTE             :
7 -- End of Comments
8 
9 --  Max number of dependent attributes.
10 
11 G_MAX               NUMBER := 1000;
12 
13 g_schema			      VARCHAR2(30);
14 
15 --  Global table holding attribute dependencies.
16 
17 TYPE Dep_Rec_Type IS RECORD
18 (attribute               NUMBER
19 );
20 
21 TYPE Dep_Tbl_TYPE IS TABLE OF Dep_Rec_Type
22 INDEX BY BINARY_INTEGER;
23 
24 g_dep_tbl          Dep_Tbl_Type;
25 g_dep_chain_tbl    Dep_Tbl_Type;
26 
27 
28 --  Generic table types
29 TYPE Boolean_Tbl_Type IS TABLE OF BOOLEAN
30     INDEX BY BINARY_INTEGER;
31 
32 TYPE Number_Tbl_Type IS TABLE OF NUMBER
33     INDEX BY BINARY_INTEGER;
34 
35 PROCEDURE Make_Dependency_Engine_Body (
36   Errbuf                  OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
37   RetCode                 OUT NOCOPY /* file.sql.39 change */ NUMBER,
38   p_database_object_name  IN  VARCHAR2,
39   p_primary_key_name      IN  VARCHAR2,
40   p_last_update_date_name IN  VARCHAR2);
41 
42 PROCEDURE Attribute_Code_To_Id
43 (   P_ATTRIBUTE_CODES_TBL           IN  ASO_DEFAULTING_INT.attribute_Codes_Tbl_Type
44   , P_DATABASE_OBJECT_NAME          IN  VARCHAR2
45   , X_ATTRIBUTE_IDS_TBL             OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type
46 );
47 
48 END ASO_DEPENDENCY_UTIL;