APPS.HZ_DUP_SET_PARTIES_PKG dependencies on HZ_DUP_SET_PARTIES

Line 1: PACKAGE BODY HZ_DUP_SET_PARTIES_PKG AS

1: PACKAGE BODY HZ_DUP_SET_PARTIES_PKG AS
2: /*$Header: ARHDQDPB.pls 120.5 2005/07/08 04:37:45 rchanamo noship $ */
3:
4: PROCEDURE Insert_Row(
5: p_DUP_PARTY_ID IN OUT NOCOPY NUMBER,

Line 34: INSERT INTO HZ_DUP_SET_PARTIES(

30: APP_EXCEPTION.RAISE_EXCEPTION;
31: END IF;
32: CLOSE c_dup_batch;
33: --End of Bug No: 4244529
34: INSERT INTO HZ_DUP_SET_PARTIES(
35: DUP_PARTY_ID,
36: DUP_SET_ID,
37: MERGE_FLAG,
38: NOT_DUP,

Line 91: UPDATE HZ_DUP_SET_PARTIES

87: p_LAST_UPDATE_DATE DATE,
88: p_LAST_UPDATED_BY NUMBER)
89: IS
90: BEGIN
91: UPDATE HZ_DUP_SET_PARTIES
92: SET
93: MERGE_FLAG = decode(p_MERGE_FLAG, FND_API.G_MISS_CHAR, MERGE_FLAG,
94: p_MERGE_FLAG),
95: NOT_DUP = decode(p_NOT_DUP, FND_API.G_MISS_CHAR, NOT_DUP,

Line 120: DELETE FROM hz_dup_set_parties

116: END Update_Row;
117:
118: PROCEDURE Delete_Row(p_DUP_PARTY_ID NUMBER, p_DUP_SET_ID NUMBER) IS
119: BEGIN
120: DELETE FROM hz_dup_set_parties
121: where DUP_PARTY_ID = p_DUP_PARTY_ID
122: and DUP_SET_ID = p_DUP_SET_ID;
123:
124: If (SQL%NOTFOUND) then

Line 147: FROM hz_dup_set_parties

143: p_LAST_UPDATED_BY NUMBER)
144: IS
145: CURSOR C IS
146: SELECT *
147: FROM hz_dup_set_parties
148: where DUP_PARTY_ID = p_DUP_PARTY_ID
149: and DUP_SET_ID = p_DUP_SET_ID
150: FOR UPDATE OF dup_party_id , dup_set_id NOWAIT;
151: Recinfo C%ROWTYPE;

Line 205: END HZ_DUP_SET_PARTIES_PKG;

201: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
202: APP_EXCEPTION.RAISE_EXCEPTION;
203: End If;
204: END Lock_Row;
205: END HZ_DUP_SET_PARTIES_PKG;