APPS.AR_CMGT_PARTY_MERGE dependencies on AR_CMGT_CASE_FOLDERS

Line 150: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CMGT_CASE_FOLDERS(+)');

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;
152:
153: /* Check the Merge reason. If Merge Reason is 'Duplicate Record'
154: then no validation is performed. */

Line 192: from ar_cmgt_case_folders

188: -- a duplicate record bug 7370428
189: DELETE from ar_cmgt_cf_dtls
190: WHERE case_folder_id IN (
191: SELECT case_folder_id
192: from ar_cmgt_case_folders
193: WHERE party_id = p_from_fk_id
194: AND type = 'DATA' );
195:
196: DELETE from ar_cmgt_case_folders

Line 196: DELETE from ar_cmgt_case_folders

192: from ar_cmgt_case_folders
193: WHERE party_id = p_from_fk_id
194: AND type = 'DATA' );
195:
196: DELETE from ar_cmgt_case_folders
197: WHERE party_id = p_from_fk_id
198: AND type = 'DATA';
199:
200: UPDATE ar_cmgt_case_folders

Line 200: UPDATE ar_cmgt_case_folders

196: DELETE from ar_cmgt_case_folders
197: WHERE party_id = p_from_fk_id
198: AND type = 'DATA';
199:
200: UPDATE ar_cmgt_case_folders
201: set party_id = p_To_FK_id
202: WHERE party_id = p_from_fk_id;
203: end if;
204: end if;

Line 205: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CMGT_CASE_FOLDERS(-)');

201: set party_id = p_To_FK_id
202: WHERE party_id = p_from_fk_id;
203: end if;
204: end if;
205: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CMGT_CASE_FOLDERS(-)');
206: Exception
207: when others then
208: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
209: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);