APPS.HZ_DUP_EXCLUSIONS_PKG dependencies on HZ_DUP_EXCLUSIONS

Line 1: PACKAGE BODY HZ_DUP_EXCLUSIONS_PKG AS

1: PACKAGE BODY HZ_DUP_EXCLUSIONS_PKG AS
2: /*$Header: ARHDQDEB.pls 120.5 2005/06/16 21:10:30 jhuang noship $ */
3:
4: PROCEDURE Insert_Row(
5: px_DUP_EXCLUSION_ID IN OUT NOCOPY NUMBER,

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

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

Line 24: INSERT INTO HZ_DUP_EXCLUSIONS(

20: FETCH C2 INTO px_DUP_EXCLUSION_ID;
21: CLOSE C2;
22: END IF;
23:
24: INSERT INTO HZ_DUP_EXCLUSIONS(
25: DUP_EXCLUSION_ID,
26: PARTY_ID,
27: DUP_PARTY_ID,
28: FROM_DATE,

Line 68: UPDATE HZ_DUP_EXCLUSIONS

64: p_LAST_UPDATE_DATE DATE,
65: p_LAST_UPDATED_BY NUMBER
66: ) IS
67: BEGIN
68: UPDATE HZ_DUP_EXCLUSIONS
69: SET
70: PARTY_ID = decode(p_PARTY_ID, FND_API.G_MISS_NUM, NULL,
71: p_PARTY_ID),
72: DUP_PARTY_ID = decode(p_DUP_PARTY_ID, FND_API.G_MISS_NUM, NULL,

Line 93: DELETE FROM hz_DUP_exclusions

89: END Update_Row;
90:
91: PROCEDURE Delete_Row(p_DUP_exclusion_id NUMBER) IS
92: BEGIN
93: DELETE FROM hz_DUP_exclusions
94: where DUP_exclusion_id = p_DUP_exclusion_id ;
95:
96: If (SQL%NOTFOUND) then
97: RAISE NO_DATA_FOUND;

Line 115: FROM hz_DUP_exclusions

111: p_LAST_UPDATED_BY NUMBER
112: ) IS
113: CURSOR C IS
114: SELECT *
115: FROM hz_DUP_exclusions
116: WHERE DUP_exclusion_id = p_DUP_exclusion_id
117: FOR UPDATE OF DUP_exclusion_id NOWAIT;
118: Recinfo C%ROWTYPE;
119: BEGIN

Line 167: END HZ_DUP_EXCLUSIONS_PKG;

163: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
164: APP_EXCEPTION.RAISE_EXCEPTION;
165: End If;
166: END Lock_Row;
167: END HZ_DUP_EXCLUSIONS_PKG;