APPS.HZ_DUP_BATCH_PKG dependencies on HZ_DUP_BATCH

Line 1: PACKAGE BODY HZ_DUP_BATCH_PKG AS

1: PACKAGE BODY HZ_DUP_BATCH_PKG AS
2: /*$Header: ARHDQDBB.pls 115.8 2004/01/09 20:09:51 acng ship $ */
3:
4: PROCEDURE Insert_Row(
5: px_DUP_BATCH_ID IN OUT NOCOPY NUMBER,

Line 16: CURSOR C2 IS SELECT HZ_DUP_BATCH_s.nextval FROM sys.dual;

12: p_LAST_UPDATE_LOGIN NUMBER,
13: p_LAST_UPDATE_DATE DATE,
14: p_LAST_UPDATED_BY NUMBER) IS
15:
16: CURSOR C2 IS SELECT HZ_DUP_BATCH_s.nextval FROM sys.dual;
17:
18: BEGIN
19:
20: IF (px_DUP_BATCH_ID IS NULL) OR (px_DUP_BATCH_ID = 0) OR (px_DUP_BATCH_ID = FND_API.G_MISS_NUM) THEN

Line 27: INSERT INTO HZ_DUP_BATCH(

23: CLOSE C2;
24:
25: END IF;
26:
27: INSERT INTO HZ_DUP_BATCH(
28: DUP_BATCH_ID,
29: DUP_BATCH_NAME,
30: MATCH_RULE_ID,
31: APPLICATION_ID,

Line 68: UPDATE HZ_DUP_BATCH

64: p_LAST_UPDATE_DATE DATE,
65: p_LAST_UPDATED_BY NUMBER
66: ) IS
67: BEGIN
68: UPDATE HZ_DUP_BATCH
69: SET
70: DUP_BATCH_NAME = decode(p_DUP_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,
71: p_DUP_BATCH_NAME),
72: CREATED_BY = CREATED_BY,

Line 87: DELETE FROM hz_DUP_batch

83: END Update_Row;
84:
85: PROCEDURE Delete_Row(p_DUP_batch_id NUMBER) IS
86: BEGIN
87: DELETE FROM hz_DUP_batch
88: where DUP_batch_id = p_DUP_batch_id ;
89:
90: If (SQL%NOTFOUND) then
91: RAISE NO_DATA_FOUND;

Line 106: FROM hz_DUP_batch

102: p_LAST_UPDATED_BY NUMBER
103: ) IS
104: CURSOR C IS
105: SELECT *
106: FROM hz_DUP_batch
107: WHERE DUP_batch_id = p_DUP_batch_id
108: FOR UPDATE OF DUP_batch_id NOWAIT;
109: Recinfo C%ROWTYPE;
110: BEGIN

Line 149: END HZ_DUP_BATCH_PKG;

145: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
146: APP_EXCEPTION.RAISE_EXCEPTION;
147: End If;
148: END Lock_Row;
149: END HZ_DUP_BATCH_PKG;