APPS.HZ_DUP_SETS_PKG dependencies on HZ_DUP_SETS

Line 1: PACKAGE BODY HZ_DUP_SETS_PKG AS

1: PACKAGE BODY HZ_DUP_SETS_PKG AS
2: /*$Header: ARHDQDSB.pls 120.3 2005/06/16 21:10:48 jhuang ship $ */
3:
4: PROCEDURE Insert_Row(
5: px_DUP_SET_ID IN OUT NOCOPY NUMBER,

Line 27: INSERT INTO HZ_DUP_SETS(

23: FETCH C2 INTO px_DUP_SET_ID;
24: CLOSE C2;
25: END IF;
26:
27: INSERT INTO HZ_DUP_SETS(
28: DUP_SET_ID,
29: DUP_BATCH_ID,
30: WINNER_PARTY_ID,
31: STATUS,

Line 75: UPDATE HZ_DUP_SETS

71: p_LAST_UPDATE_DATE DATE,
72: p_LAST_UPDATED_BY NUMBER)
73: IS
74: BEGIN
75: UPDATE HZ_DUP_SETS
76: SET
77: DUP_BATCH_ID= decode(p_DUP_BATCH_ID, FND_API.G_MISS_NUM, NULL,
78: p_DUP_BATCH_ID),
79: WINNER_PARTY_ID = decode(p_WINNER_PARTY_ID,FND_API.G_MISS_NUM, NULL,

Line 95: DELETE FROM HZ_DUP_SETS

91: END Update_Row;
92:
93: PROCEDURE Delete_Row(p_DUP_SET_ID NUMBER) IS
94: BEGIN
95: DELETE FROM HZ_DUP_SETS
96: where DUP_SET_ID = p_DUP_SET_ID ;
97:
98: If (SQL%NOTFOUND) then
99: RAISE NO_DATA_FOUND;

Line 115: FROM hz_DUP_SETS

111: p_LAST_UPDATED_BY NUMBER)
112: IS
113: CURSOR C IS
114: SELECT *
115: FROM hz_DUP_SETS
116: where DUP_SET_ID = p_DUP_SET_ID
117: FOR UPDATE OF DUP_SET_ID NOWAIT;
118:
119: Recinfo C%ROWTYPE;

Line 162: END HZ_DUP_SETS_PKG;

158: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
159: APP_EXCEPTION.RAISE_EXCEPTION;
160: End If;
161: END Lock_Row;
162: END HZ_DUP_SETS_PKG;