PACKAGE: APPS.HZ_MERGE_BATCH_PKG

Source

1 PACKAGE HZ_MERGE_BATCH_PKG as
2 /* $Header: ARHMBTBS.pls 120.2 2005/06/16 21:12:24 jhuang noship $ */
3 -- Start of Comments
4 -- Package name     : HZ_MERGE_BATCH_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           px_BATCH_ID   IN OUT NOCOPY NUMBER,
12           p_RULE_SET_NAME    VARCHAR2,
13           p_BATCH_NAME    VARCHAR2,
14           p_REQUEST_ID    NUMBER,
15           p_BATCH_STATUS    VARCHAR2,
16           p_BATCH_COMMIT    VARCHAR2,
17           p_BATCH_DELETE    VARCHAR2,
18           p_MERGE_REASON_CODE    VARCHAR2,
19           p_CREATED_BY    NUMBER,
20           p_CREATION_DATE    DATE,
21           p_LAST_UPDATE_LOGIN    NUMBER,
22           p_LAST_UPDATE_DATE    DATE,
23           p_LAST_UPDATED_BY    NUMBER);
24 
25 PROCEDURE Update_Row(
26           p_BATCH_ID    NUMBER,
27           p_RULE_SET_NAME    VARCHAR2,
28           p_BATCH_NAME    VARCHAR2,
29           p_REQUEST_ID    NUMBER,
30           p_BATCH_STATUS    VARCHAR2,
31           p_BATCH_COMMIT    VARCHAR2,
32           p_BATCH_DELETE    VARCHAR2,
33           p_MERGE_REASON_CODE    VARCHAR2,
34           p_CREATED_BY    NUMBER,
35           p_CREATION_DATE    DATE,
36           p_LAST_UPDATE_LOGIN    NUMBER,
37           p_LAST_UPDATE_DATE    DATE,
38           p_LAST_UPDATED_BY    NUMBER);
39 
40 PROCEDURE Lock_Row(
41           p_BATCH_ID    NUMBER,
42           p_RULE_SET_NAME    VARCHAR2,
43           p_BATCH_NAME    VARCHAR2,
44           p_REQUEST_ID    NUMBER,
45           p_BATCH_STATUS    VARCHAR2,
46           p_BATCH_COMMIT    VARCHAR2,
47           p_BATCH_DELETE    VARCHAR2,
48           p_MERGE_REASON_CODE    VARCHAR2,
49           p_CREATED_BY    NUMBER,
50           p_CREATION_DATE    DATE,
51           p_LAST_UPDATE_LOGIN    NUMBER,
52           p_LAST_UPDATE_DATE    DATE,
53           p_LAST_UPDATED_BY    NUMBER);
54 
55 PROCEDURE Delete_Row(
56     p_BATCH_ID  NUMBER);
57 End HZ_MERGE_BATCH_PKG;