PACKAGE: APPS.HZ_MERGE_DICTIONARY_PKG

Source

1 PACKAGE HZ_MERGE_DICTIONARY_PKG AUTHID CURRENT_USER as
2 /* $Header: ARHMDTBS.pls 120.5 2006/04/26 09:36:20 vsegu noship $ */
3 -- Start of Comments
4 -- Package name     : HZ_MERGE_DICTIONARY_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Validate_Parent_Entity(
11           p_parent_entity  VARCHAR2,
12           p_owner IN VARCHAR2,
13           p_error_text OUT NOCOPY VARCHAR2,
14           p_return_status OUT NOCOPY VARCHAR2);
15 PROCEDURE Validate_Primary_Key(
16           p_primary_key VARCHAR2,
17           p_owner IN VARCHAR2,
18           p_entity_name VARCHAR2,
19           p_error_message OUT NOCOPY VARCHAR2,
20           p_return_status OUT NOCOPY VARCHAR2);
21 PROCEDURE Validate_Foreign_Key(
22           p_foreign_key IN VARCHAR2,
23           p_owner IN VARCHAR2,
24           p_entity_name IN VARCHAR2,
25           p_error_message OUT NOCOPY VARCHAR2,
26           p_return_status OUT NOCOPY VARCHAR2);
27 PROCEDURE Validate_Entity(
28   p_entity_name IN VARCHAR2,
29   p_owner IN VARCHAR2,
30   p_error_message OUT NOCOPY VARCHAR2,
31   p_return_status OUT NOCOPY VARCHAR2);
32 
33 
34 PROCEDURE Insert_Row(
35           px_MERGE_DICT_ID   IN OUT NOCOPY NUMBER,
36           p_RULE_SET_NAME    VARCHAR2,
37           p_ENTITY_NAME    VARCHAR2,
38           p_PARENT_ENTITY_NAME    VARCHAR2,
39           p_PK_COLUMN_NAME    VARCHAR2,
40           p_FK_COLUMN_NAME    VARCHAR2,
41           p_DESC_COLUMN_NAME    VARCHAR2,
42           p_PROCEDURE_TYPE    VARCHAR2,
43           p_PROCEDURE_NAME    VARCHAR2,
44           p_JOIN_CLAUSE    VARCHAR2,
45           p_DICT_APPLICATION_ID    NUMBER,
46           p_DESCRIPTION    VARCHAR2,
47           px_SEQUENCE_NO    IN OUT NOCOPY NUMBER,
48           p_BULK_FLAG    VARCHAR2,
49 	  p_BATCH_MERGE_FLAG VARCHAR2, --4634891
50 	  p_VALIDATE_PURGE_FLAG VARCHAR2, --5125968
51           p_CREATED_BY    NUMBER,
52           p_CREATION_DATE    DATE,
53           p_LAST_UPDATE_LOGIN    NUMBER,
54           p_LAST_UPDATE_DATE    DATE,
55           p_LAST_UPDATED_BY    NUMBER);
56 
57 PROCEDURE Update_Row(
58           p_MERGE_DICT_ID    NUMBER,
59           p_RULE_SET_NAME    VARCHAR2,
60           p_ENTITY_NAME    VARCHAR2,
61           p_PARENT_ENTITY_NAME    VARCHAR2,
62           p_PK_COLUMN_NAME    VARCHAR2,
63           p_FK_COLUMN_NAME    VARCHAR2,
64           p_DESC_COLUMN_NAME    VARCHAR2,
65           p_PROCEDURE_TYPE    VARCHAR2,
66           p_PROCEDURE_NAME    VARCHAR2,
67           p_JOIN_CLAUSE    VARCHAR2,
68           p_DICT_APPLICATION_ID    NUMBER,
69           p_DESCRIPTION    VARCHAR2,
70           px_SEQUENCE_NO    IN OUT NOCOPY NUMBER,
71           p_BULK_FLAG    VARCHAR2,
72 	  p_BATCH_MERGE_FLAG VARCHAR2, --4634891
73 	  p_VALIDATE_PURGE_FLAG VARCHAR2, --5125968
74           p_CREATED_BY    NUMBER,
75           p_CREATION_DATE    DATE,
76           p_LAST_UPDATE_LOGIN    NUMBER,
77           p_LAST_UPDATE_DATE    DATE,
78           p_LAST_UPDATED_BY    NUMBER);
79 
80 PROCEDURE Lock_Row(
81           p_MERGE_DICT_ID    NUMBER,
82           p_RULE_SET_NAME    VARCHAR2,
83           p_ENTITY_NAME    VARCHAR2,
84           p_PARENT_ENTITY_NAME    VARCHAR2,
85           p_PK_COLUMN_NAME    VARCHAR2,
86           p_FK_COLUMN_NAME    VARCHAR2,
87           p_DESC_COLUMN_NAME    VARCHAR2,
88           p_PROCEDURE_TYPE    VARCHAR2,
89           p_PROCEDURE_NAME    VARCHAR2,
90           p_JOIN_CLAUSE    VARCHAR2,
91           p_DICT_APPLICATION_ID    NUMBER,
92           p_DESCRIPTION    VARCHAR2,
93           p_SEQUENCE_NO    NUMBER,
94           p_BULK_FLAG    VARCHAR2,
95 	  p_BATCH_MERGE_FLAG VARCHAR2, --4634891
96 	  p_VALIDATE_PURGE_FLAG VARCHAR2, --5125968
97           p_CREATED_BY    NUMBER,
98           p_CREATION_DATE    DATE,
99           p_LAST_UPDATE_LOGIN    NUMBER,
100           p_LAST_UPDATE_DATE    DATE,
101           p_LAST_UPDATED_BY    NUMBER);
102 
103 PROCEDURE Delete_Row(
104     p_MERGE_DICT_ID  NUMBER);
105 End HZ_MERGE_DICTIONARY_PKG;