eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_CMERGE dependencies on FV_CUST_VEND_XREFS

Line 11: PROCEDURE FV_CUST_VEND_XREFS (

7: set_num NUMBER,
8: process_mode VARCHAR2);
9:
10:
11: PROCEDURE FV_CUST_VEND_XREFS (
12: req_id NUMBER,
13: set_num NUMBER,
14: process_mode VARCHAR2);
15:

Line 195: -- Merge Routine for FV_CUST_VEND_XREFS table

191: RAISE;
192: END FV_CUST_FINANCE_CHRGS;
193:
194: ------------------------------------------------------------------------------
195: -- Merge Routine for FV_CUST_VEND_XREFS table
196: -----------------------------------------------------------------------------
197:
198: PROCEDURE FV_CUST_VEND_XREFS (
199: req_id NUMBER,

Line 198: PROCEDURE FV_CUST_VEND_XREFS (

194: ------------------------------------------------------------------------------
195: -- Merge Routine for FV_CUST_VEND_XREFS table
196: -----------------------------------------------------------------------------
197:
198: PROCEDURE FV_CUST_VEND_XREFS (
199: req_id NUMBER,
200: set_num NUMBER,
201: process_mode VARCHAR2) IS
202: l_module_name VARCHAR2(200) := g_module_name || 'FV_CUST_VEND_XREFS';

Line 202: l_module_name VARCHAR2(200) := g_module_name || 'FV_CUST_VEND_XREFS';

198: PROCEDURE FV_CUST_VEND_XREFS (
199: req_id NUMBER,
200: set_num NUMBER,
201: process_mode VARCHAR2) IS
202: l_module_name VARCHAR2(200) := g_module_name || 'FV_CUST_VEND_XREFS';
203: l_errbuf VARCHAR2(1024);
204:
205: TYPE MERGE_HEADER_ID_LIST_TYPE IS TABLE OF
206: RA_CUSTOMER_MERGE_HEADERS.CUSTOMER_MERGE_HEADER_ID%TYPE

Line 211: FV.FV_CUST_VEND_XREFS.CUST_VEND_XREF_ID%TYPE

207: INDEX BY BINARY_INTEGER;
208: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
209:
210: TYPE CUST_VEND_XREF_ID_LIST_TYPE IS TABLE OF
211: FV.FV_CUST_VEND_XREFS.CUST_VEND_XREF_ID%TYPE
212: INDEX BY BINARY_INTEGER;
213: PRIMARY_KEY_ID_LIST CUST_VEND_XREF_ID_LIST_TYPE;
214:
215: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 216: FV.FV_CUST_VEND_XREFS.CUSTOMER_ID%TYPE

212: INDEX BY BINARY_INTEGER;
213: PRIMARY_KEY_ID_LIST CUST_VEND_XREF_ID_LIST_TYPE;
214:
215: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
216: FV.FV_CUST_VEND_XREFS.CUSTOMER_ID%TYPE
217: INDEX BY BINARY_INTEGER;
218: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
219: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
220:

Line 226: FROM FV_CUST_VEND_XREFS yt, ra_customer_merges m

222: CURSOR merged_records IS
223: SELECT distinct CUSTOMER_MERGE_HEADER_ID
224: ,CUST_VEND_XREF_ID
225: ,yt.CUSTOMER_ID
226: FROM FV_CUST_VEND_XREFS yt, ra_customer_merges m
227: WHERE (
228: yt.CUSTOMER_ID = m.DUPLICATE_ID
229: ) AND m.process_flag = 'N'
230: AND m.request_id = req_id

Line 240: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_CUST_VEND_XREFS',FALSE);

236: IF process_mode='LOCK' THEN
237: NULL;
238: ELSE
239: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
240: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_CUST_VEND_XREFS',FALSE);
241: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
242: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
243: END IF;
244: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

Line 248: delete from fv_cust_vend_xrefs

244: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
245: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
246:
247: -- remove the records that will be duplicates when merged.
248: delete from fv_cust_vend_xrefs
249: where customer_id IN (select duplicate_id
250: from ra_customer_merges racm,
251: fv_cust_vend_xrefs t
252: where racm.process_flag = 'N'

Line 251: fv_cust_vend_xrefs t

247: -- remove the records that will be duplicates when merged.
248: delete from fv_cust_vend_xrefs
249: where customer_id IN (select duplicate_id
250: from ra_customer_merges racm,
251: fv_cust_vend_xrefs t
252: where racm.process_flag = 'N'
253: and racm.request_id = req_id
254: and racm.set_number = set_num
255: and racm.customer_id = t.customer_id);

Line 299: 'FV_CUST_VEND_XREFS',

295: LAST_UPDATE_LOGIN,
296: LAST_UPDATE_DATE,
297: LAST_UPDATED_BY
298: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
299: 'FV_CUST_VEND_XREFS',
300: MERGE_HEADER_ID_LIST(I),
301: PRIMARY_KEY_ID_LIST(I),
302: NUM_COL1_ORIG_LIST(I),
303: NUM_COL1_NEW_LIST(I),

Line 314: UPDATE FV_CUST_VEND_XREFS yt SET

310: hz_utility_pub.LAST_UPDATED_BY
311: );
312:
313: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
314: UPDATE FV_CUST_VEND_XREFS yt SET
315: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
316: , LAST_UPDATE_DATE=SYSDATE
317: , last_updated_by=arp_standard.profile.user_id
318: , last_update_login=arp_standard.profile.last_update_login

Line 337: arp_message.set_line( 'FV_CUST_VEND_XREFS');

333: EXCEPTION
334: WHEN OTHERS THEN
335: l_errbuf := SQLERRM;
336: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception', l_errbuf);
337: arp_message.set_line( 'FV_CUST_VEND_XREFS');
338: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
339: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_ERROR, l_module_name);
340: END IF;
341: RAISE;

Line 342: END FV_CUST_VEND_XREFS;

338: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
339: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_ERROR, l_module_name);
340: END IF;
341: RAISE;
342: END FV_CUST_VEND_XREFS;
343:
344: ------------------------------------------------------------------------------
345: -- Merge Routine for FV_INTERAGENCY_FUNDS table
346: ------------------------------------------------------------------------------

Line 940: FV_CUST_VEND_XREFS(req_id, set_num, process_mode);

936: l_errbuf VARCHAR2(1024);
937:
938: BEGIN
939: FV_CUST_FINANCE_CHRGS(req_id, set_num, process_mode);
940: FV_CUST_VEND_XREFS(req_id, set_num, process_mode);
941: FV_INTERAGENCY_FUNDS(req_id, set_num, process_mode);
942: FV_INTERIM_CASH_RECEIPTS(req_id, set_num, process_mode);
943: FV_INVOICE_FINANCE_CHRGS(req_id, set_num, process_mode);
944: FV_IPAC_TRX(req_id, set_num, process_mode);