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;