DBA Data[Home] [Help]

PACKAGE: APPS.HZ_MATCH_RULE_SECONDARY_PKG

Source


1 PACKAGE HZ_MATCH_RULE_SECONDARY_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHDQMSS.pls 120.2 2005/10/30 04:19:13 appldev noship $*/
3 
4 PROCEDURE Insert_Row(
5                     px_SECONDARY_ATTRIBUTE_ID IN OUT NOCOPY NUMBER,
6                     p_MATCH_RULE_ID                   NUMBER,
7                     p_ATTRIBUTE_ID                    NUMBER,
8                     p_SCORE                           NUMBER,
9                     p_ACTIVE_FLAG                     VARCHAR2,
10                     p_CREATED_BY                      NUMBER,
11                     p_CREATION_DATE                   DATE,
12                     p_LAST_UPDATE_LOGIN               NUMBER,
13                     p_LAST_UPDATE_DATE                DATE,
14                     p_LAST_UPDATED_BY                 NUMBER,
15                     p_OBJECT_VERSION_NUMBER           NUMBER,
16 		    p_DISPLAY_ORDER		      NUMBER DEFAULT NULL);
17 
18 
19 PROCEDURE Lock_Row(
20                    p_SECONDARY_ATTRIBUTE_ID  IN  OUT  NOCOPY  NUMBER,
21                    p_OBJECT_VERSION_NUMBER              NUMBER   );
22 
23 PROCEDURE Update_Row(
24                     p_SECONDARY_ATTRIBUTE_ID           NUMBER,
25                     p_MATCH_RULE_ID                   NUMBER,
26                     p_ATTRIBUTE_ID                    NUMBER,
27                     p_SCORE                           NUMBER,
28                     p_ACTIVE_FLAG                     VARCHAR2,
29                     p_CREATED_BY                      NUMBER,
30                     p_CREATION_DATE                   DATE,
31                     p_LAST_UPDATE_LOGIN               NUMBER,
32                     p_LAST_UPDATE_DATE                DATE,
33                     p_LAST_UPDATED_BY                 NUMBER,
34                     p_OBJECT_VERSION_NUMBER IN OUT  NOCOPY  NUMBER,
35 		    p_DISPLAY_ORDER		      NUMBER DEFAULT NULL);
36 
37 
38 PROCEDURE Delete_Row(p_SECONDARY_ATTRIBUTE_ID                 NUMBER);
39 
40 END HZ_MATCH_RULE_SECONDARY_PKG;