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 212: --FV_CUST_VEND_XREFS.CUST_VEND_XREF_ID%TYPE

208: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
209:
210: -- Bug 12964038. Removed FV schema name prepended to table
211: TYPE CUST_VEND_XREF_ID_LIST_TYPE IS TABLE OF
212: --FV_CUST_VEND_XREFS.CUST_VEND_XREF_ID%TYPE
213: NUMBER(15)
214: INDEX BY BINARY_INTEGER;
215: PRIMARY_KEY_ID_LIST CUST_VEND_XREF_ID_LIST_TYPE;
216:

Line 218: --FV_CUST_VEND_XREFS.CUSTOMER_ID%TYPE

214: INDEX BY BINARY_INTEGER;
215: PRIMARY_KEY_ID_LIST CUST_VEND_XREF_ID_LIST_TYPE;
216:
217: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
218: --FV_CUST_VEND_XREFS.CUSTOMER_ID%TYPE
219: NUMBER(15)
220: INDEX BY BINARY_INTEGER;
221: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
222: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;

Line 229: FROM FV_CUST_VEND_XREFS yt, ra_customer_merges m

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

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

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

Line 251: delete from fv_cust_vend_xrefs

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

Line 254: fv_cust_vend_xrefs t

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

Line 302: 'FV_CUST_VEND_XREFS',

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

Line 317: UPDATE FV_CUST_VEND_XREFS yt SET

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

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

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

Line 345: END FV_CUST_VEND_XREFS;

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

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

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