APPS.AR_CMGT_PARTY_MERGE dependencies on HZ_MERGE_BATCH

Line 15: l_merge_reason_code hz_merge_batch.merge_reason_code%type;

11: p_batch_id IN NUMBER,
12: p_batch_party_id IN NUMBER,
13: x_return_status OUT NOCOPY VARCHAR2) AS
14:
15: l_merge_reason_code hz_merge_batch.merge_reason_code%type;
16:
17: Begin
18: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CMGT_CREDIT_REQUEST(+)');
19: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 26: from hz_merge_batch

22: then no validation is performed. */
23:
24: select merge_reason_code
25: into l_merge_reason_code
26: from hz_merge_batch
27: where batch_id = p_batch_id;
28:
29: FND_FILE.PUT_LINE(FND_FILE.LOG,'Merge Reason Code '||l_merge_reason_code);
30:

Line 81: l_merge_reason_code hz_merge_batch.merge_reason_code%type;

77: p_batch_id IN NUMBER,
78: p_batch_party_id IN NUMBER,
79: x_return_status OUT NOCOPY VARCHAR2) AS
80:
81: l_merge_reason_code hz_merge_batch.merge_reason_code%type;
82:
83: Begin
84: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Contact Merge for AR_CMGT_CREDIT_REQUEST(+)');
85:

Line 93: from hz_merge_batch

89: then no validation is performed. */
90:
91: select merge_reason_code
92: into l_merge_reason_code
93: from hz_merge_batch
94: where batch_id = p_batch_id;
95:
96: if l_merge_reason_code = 'DUPLICATE' then
97: null;

Line 147: l_merge_reason_code hz_merge_batch.merge_reason_code%type;

143: p_batch_id IN NUMBER,
144: p_batch_party_id IN NUMBER,
145: x_return_status OUT NOCOPY VARCHAR2) AS
146:
147: l_merge_reason_code hz_merge_batch.merge_reason_code%type;
148:
149: Begin
150: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CMGT_CASE_FOLDERS(+)');
151: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 158: from hz_merge_batch

154: then no validation is performed. */
155:
156: select merge_reason_code
157: into l_merge_reason_code
158: from hz_merge_batch
159: where batch_id = p_batch_id;
160:
161: if l_merge_reason_code = 'DUPLICATE' then
162: null;

Line 230: from hz_merge_batch

226: l_merge_reason_code VARCHAR2(30);
227:
228: Cursor c_duplicate Is
229: select merge_reason_code
230: from hz_merge_batch
231: where batch_id = p_batch_id;
232:
233:
234: BEGIN

Line 317: from hz_merge_batch

313: l_merge_reason_code VARCHAR2(30);
314:
315: Cursor c_duplicate Is
316: select merge_reason_code
317: from hz_merge_batch
318: where batch_id = p_batch_id;
319:
320:
321: BEGIN