1 PACKAGE ASO_DEPENDENCY_MAPPINGS_PKG AUTHID CURRENT_USER as
2 /* $Header: asotdeps.pls 120.1 2005/06/29 12:38:46 appldev noship $ */
3 -- Start of Comments
4 -- Package name : ASO_DEPENDENCY_MAPPINGS_PKG
5 -- Purpose :
6 -- History :
7 -- 01-28-2005 hyang - created
8 -- NOTE :
9 -- End of Comments
10
11 PROCEDURE Insert_Row(
12 PX_DEPENDENCY_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER
13 , P_TRIGGER_ATTRIBUTE_ID IN NUMBER
14 , P_DEPENDENT_ATTRIBUTE_ID IN NUMBER
15 , P_ENABLED_FLAG IN VARCHAR2
16 , P_DATABASE_OBJECT_NAME IN VARCHAR2
17 , P_APPLICATION_ID IN NUMBER
18 , P_SEED_TAG IN VARCHAR2
19 , P_CREATION_DATE IN DATE
20 , P_CREATED_BY IN NUMBER
21 , P_LAST_UPDATE_DATE IN DATE
22 , P_LAST_UPDATE_LOGIN IN NUMBER
23 , P_LAST_UPDATED_BY IN NUMBER
24 , P_REQUEST_ID IN NUMBER
25 , P_PROGRAM_APPLICATION_ID IN NUMBER
26 , P_PROGRAM_ID IN NUMBER
27 , P_PROGRAM_UPDATE_DATE IN DATE
28 );
29
30 PROCEDURE Update_Row(
31 P_DEPENDENCY_ID IN NUMBER
32 , P_TRIGGER_ATTRIBUTE_ID IN NUMBER
33 , P_DEPENDENT_ATTRIBUTE_ID IN NUMBER
34 , P_ENABLED_FLAG IN VARCHAR2
35 , P_DATABASE_OBJECT_NAME IN VARCHAR2
36 , P_APPLICATION_ID IN NUMBER
37 , P_SEED_TAG IN VARCHAR2
38 , P_CREATION_DATE IN DATE
39 , P_CREATED_BY IN NUMBER
40 , P_LAST_UPDATE_DATE IN DATE
41 , P_LAST_UPDATE_LOGIN IN NUMBER
42 , P_LAST_UPDATED_BY IN NUMBER
43 , P_REQUEST_ID IN NUMBER
44 , P_PROGRAM_APPLICATION_ID IN NUMBER
45 , P_PROGRAM_ID IN NUMBER
46 , P_PROGRAM_UPDATE_DATE IN DATE
47 );
48
49 PROCEDURE Lock_Row(
50 P_DEPENDENCY_ID IN NUMBER
51 , P_TRIGGER_ATTRIBUTE_ID IN NUMBER
52 , P_DEPENDENT_ATTRIBUTE_ID IN NUMBER
53 , P_ENABLED_FLAG IN VARCHAR2
54 , P_DATABASE_OBJECT_NAME IN VARCHAR2
55 , P_APPLICATION_ID IN NUMBER
56 , P_SEED_TAG IN VARCHAR2
57 , P_CREATION_DATE IN DATE
58 , P_CREATED_BY IN NUMBER
59 , P_LAST_UPDATE_DATE IN DATE
60 , P_LAST_UPDATE_LOGIN IN NUMBER
61 , P_LAST_UPDATED_BY IN NUMBER
62 , P_REQUEST_ID IN NUMBER
63 , P_PROGRAM_APPLICATION_ID IN NUMBER
64 , P_PROGRAM_ID IN NUMBER
65 , P_PROGRAM_UPDATE_DATE IN DATE
66 );
67
68 PROCEDURE Delete_Row(
69 P_DEPENDENCY_ID IN NUMBER);
70
71 PROCEDURE Load_Row (
72 X_DEPENDENCY_ID IN NUMBER
73 , X_TRIGGER_ATTRIBUTE_ID IN NUMBER
74 , X_DEPENDENT_ATTRIBUTE_ID IN NUMBER
75 , X_ENABLED_FLAG IN VARCHAR2
76 , X_DATABASE_OBJECT_NAME IN VARCHAR2
77 , X_APPLICATION_ID IN NUMBER
78 , X_SEED_TAG IN VARCHAR2
79 , X_OWNER IN VARCHAR2
80 );
81
82
83 End ASO_DEPENDENCY_MAPPINGS_PKG;
84