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 345: -- Merge Routine for FV_INTERAGENCY_FUNDS table

341: RAISE;
342: END FV_CUST_VEND_XREFS;
343:
344: ------------------------------------------------------------------------------
345: -- Merge Routine for FV_INTERAGENCY_FUNDS table
346: ------------------------------------------------------------------------------
347:
348: PROCEDURE FV_INTERAGENCY_FUNDS (
349: req_id NUMBER,

Line 348: PROCEDURE FV_INTERAGENCY_FUNDS (

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

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

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

Line 361: FV_INTERAGENCY_FUNDS_ALL.INTERAGENCY_FUND_ID%TYPE

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

Line 366: FV_INTERAGENCY_FUNDS_ALL.CUSTOMER_ID%TYPE

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

Line 376: FROM FV_INTERAGENCY_FUNDS yt, ra_customer_merges m

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

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

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

Line 430: 'FV_INTERAGENCY_FUNDS',

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

Line 445: UPDATE FV_INTERAGENCY_FUNDS yt SET

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

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

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

Line 473: END FV_INTERAGENCY_FUNDS;

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

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

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