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_INTERAGENCY_FUNDS

Line 16: PROCEDURE FV_INTERAGENCY_FUNDS (

12: req_id NUMBER,
13: set_num NUMBER,
14: process_mode VARCHAR2);
15:
16: PROCEDURE FV_INTERAGENCY_FUNDS (
17: req_id NUMBER,
18: set_num NUMBER,
19: process_mode VARCHAR2);
20:

Line 348: -- Merge Routine for FV_INTERAGENCY_FUNDS table

344: RAISE;
345: END FV_CUST_VEND_XREFS;
346:
347: ------------------------------------------------------------------------------
348: -- Merge Routine for FV_INTERAGENCY_FUNDS table
349: ------------------------------------------------------------------------------
350:
351: PROCEDURE FV_INTERAGENCY_FUNDS (
352: req_id NUMBER,

Line 351: PROCEDURE FV_INTERAGENCY_FUNDS (

347: ------------------------------------------------------------------------------
348: -- Merge Routine for FV_INTERAGENCY_FUNDS table
349: ------------------------------------------------------------------------------
350:
351: PROCEDURE FV_INTERAGENCY_FUNDS (
352: req_id NUMBER,
353: set_num NUMBER,
354: process_mode VARCHAR2) IS
355: l_module_name VARCHAR2(200) := g_module_name || 'FV_INTERAGENCY_FUNDS';

Line 355: l_module_name VARCHAR2(200) := g_module_name || 'FV_INTERAGENCY_FUNDS';

351: PROCEDURE FV_INTERAGENCY_FUNDS (
352: req_id NUMBER,
353: set_num NUMBER,
354: process_mode VARCHAR2) IS
355: l_module_name VARCHAR2(200) := g_module_name || 'FV_INTERAGENCY_FUNDS';
356: l_errbuf VARCHAR2(1024);
357:
358: TYPE MERGE_HEADER_ID_LIST_TYPE IS TABLE OF
359: RA_CUSTOMER_MERGE_HEADERS.CUSTOMER_MERGE_HEADER_ID%TYPE

Line 364: FV_INTERAGENCY_FUNDS_ALL.INTERAGENCY_FUND_ID%TYPE

360: INDEX BY BINARY_INTEGER;
361: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
362:
363: TYPE INTERAGENCY_FUND_ID_LIST_TYPE IS TABLE OF
364: FV_INTERAGENCY_FUNDS_ALL.INTERAGENCY_FUND_ID%TYPE
365: INDEX BY BINARY_INTEGER;
366: PRIMARY_KEY_ID_LIST INTERAGENCY_FUND_ID_LIST_TYPE;
367:
368: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 369: FV_INTERAGENCY_FUNDS_ALL.CUSTOMER_ID%TYPE

365: INDEX BY BINARY_INTEGER;
366: PRIMARY_KEY_ID_LIST INTERAGENCY_FUND_ID_LIST_TYPE;
367:
368: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
369: FV_INTERAGENCY_FUNDS_ALL.CUSTOMER_ID%TYPE
370: INDEX BY BINARY_INTEGER;
371: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
372: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
373:

Line 379: FROM FV_INTERAGENCY_FUNDS yt, ra_customer_merges m

375: CURSOR merged_records IS
376: SELECT distinct CUSTOMER_MERGE_HEADER_ID
377: ,INTERAGENCY_FUND_ID
378: ,yt.CUSTOMER_ID
379: FROM FV_INTERAGENCY_FUNDS yt, ra_customer_merges m
380: WHERE (
381: yt.CUSTOMER_ID = m.DUPLICATE_ID
382: ) AND m.process_flag = 'N'
383: AND m.request_id = req_id

Line 392: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_INTERAGENCY_FUNDS',FALSE);

388: IF process_mode='LOCK' THEN
389: NULL;
390: ELSE
391: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
392: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_INTERAGENCY_FUNDS',FALSE);
393: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
394: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
395: END IF;
396: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

Line 433: 'FV_INTERAGENCY_FUNDS',

429: LAST_UPDATE_LOGIN,
430: LAST_UPDATE_DATE,
431: LAST_UPDATED_BY
432: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
433: 'FV_INTERAGENCY_FUNDS',
434: MERGE_HEADER_ID_LIST(I),
435: PRIMARY_KEY_ID_LIST(I),
436: NUM_COL1_ORIG_LIST(I),
437: NUM_COL1_NEW_LIST(I),

Line 448: UPDATE FV_INTERAGENCY_FUNDS yt SET

444: hz_utility_pub.LAST_UPDATED_BY
445: );
446:
447: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
448: UPDATE FV_INTERAGENCY_FUNDS yt SET
449: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
450: , LAST_UPDATE_DATE=SYSDATE
451: , last_updated_by=arp_standard.profile.user_id
452: , last_update_login=arp_standard.profile.last_update_login

Line 471: arp_message.set_line( 'FV_INTERAGENCY_FUNDS');

467: EXCEPTION
468: WHEN OTHERS THEN
469: l_errbuf := SQLERRM;
470: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception', l_errbuf);
471: arp_message.set_line( 'FV_INTERAGENCY_FUNDS');
472: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
473: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_ERROR, l_module_name);
474: END IF;
475: RAISE;

Line 476: END FV_INTERAGENCY_FUNDS;

472: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
473: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_ERROR, l_module_name);
474: END IF;
475: RAISE;
476: END FV_INTERAGENCY_FUNDS;
477: ------------------------------------------------------------------------------
478: -- Merge Routine for FV_INTERIM_CASH_RECEIPTS table
479: ------------------------------------------------------------------------------
480: PROCEDURE FV_INTERIM_CASH_RECEIPTS (

Line 944: FV_INTERAGENCY_FUNDS(req_id, set_num, process_mode);

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);
948: EXCEPTION WHEN OTHERS THEN