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_INTERIM_CASH_RECEIPTS

Line 21: PROCEDURE FV_INTERIM_CASH_RECEIPTS (

17: req_id NUMBER,
18: set_num NUMBER,
19: process_mode VARCHAR2);
20:
21: PROCEDURE FV_INTERIM_CASH_RECEIPTS (
22: req_id NUMBER,
23: set_num NUMBER,
24: process_mode VARCHAR2);
25:

Line 478: -- Merge Routine for FV_INTERIM_CASH_RECEIPTS table

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 (
481: req_id NUMBER,
482: set_num NUMBER,

Line 480: PROCEDURE FV_INTERIM_CASH_RECEIPTS (

476: END FV_INTERAGENCY_FUNDS;
477: ------------------------------------------------------------------------------
478: -- Merge Routine for FV_INTERIM_CASH_RECEIPTS table
479: ------------------------------------------------------------------------------
480: PROCEDURE FV_INTERIM_CASH_RECEIPTS (
481: req_id NUMBER,
482: set_num NUMBER,
483: process_mode VARCHAR2) IS
484: l_module_name VARCHAR2(200) := g_module_name || 'FV_INTERIM_CASH_RECEIPTS';

Line 484: l_module_name VARCHAR2(200) := g_module_name || 'FV_INTERIM_CASH_RECEIPTS';

480: PROCEDURE FV_INTERIM_CASH_RECEIPTS (
481: req_id NUMBER,
482: set_num NUMBER,
483: process_mode VARCHAR2) IS
484: l_module_name VARCHAR2(200) := g_module_name || 'FV_INTERIM_CASH_RECEIPTS';
485: l_errbuf VARCHAR2(1024);
486:
487: TYPE MERGE_HEADER_ID_LIST_TYPE IS TABLE OF
488: RA_CUSTOMER_MERGE_HEADERS.CUSTOMER_MERGE_HEADER_ID%TYPE

Line 493: FV_INTERIM_CASH_RECEIPTS_ALL.BATCH_ID%TYPE

489: INDEX BY BINARY_INTEGER;
490: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
491:
492: TYPE BATCH_ID_LIST_TYPE IS TABLE OF
493: FV_INTERIM_CASH_RECEIPTS_ALL.BATCH_ID%TYPE
494: INDEX BY BINARY_INTEGER;
495: PRIMARY_KEY1_LIST BATCH_ID_LIST_TYPE;
496:
497: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 498: FV_INTERIM_CASH_RECEIPTS_ALL.CUSTOMER_ID%TYPE

494: INDEX BY BINARY_INTEGER;
495: PRIMARY_KEY1_LIST BATCH_ID_LIST_TYPE;
496:
497: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
498: FV_INTERIM_CASH_RECEIPTS_ALL.CUSTOMER_ID%TYPE
499: INDEX BY BINARY_INTEGER;
500: PRIMARY_KEY2_LIST CUSTOMER_ID_LIST_TYPE;
501:
502: TYPE CUSTOMER_TRX_ID_LIST_TYPE IS TABLE OF

Line 503: FV_INTERIM_CASH_RECEIPTS_ALL.CUSTOMER_TRX_ID%TYPE

499: INDEX BY BINARY_INTEGER;
500: PRIMARY_KEY2_LIST CUSTOMER_ID_LIST_TYPE;
501:
502: TYPE CUSTOMER_TRX_ID_LIST_TYPE IS TABLE OF
503: FV_INTERIM_CASH_RECEIPTS_ALL.CUSTOMER_TRX_ID%TYPE
504: INDEX BY BINARY_INTEGER;
505: PRIMARY_KEY3_LIST CUSTOMER_TRX_ID_LIST_TYPE;
506:
507: TYPE RECEIPT_NUMBER_LIST_TYPE IS TABLE OF

Line 508: FV_INTERIM_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE

504: INDEX BY BINARY_INTEGER;
505: PRIMARY_KEY3_LIST CUSTOMER_TRX_ID_LIST_TYPE;
506:
507: TYPE RECEIPT_NUMBER_LIST_TYPE IS TABLE OF
508: FV_INTERIM_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE
509: INDEX BY BINARY_INTEGER;
510: PRIMARY_KEY4_LIST RECEIPT_NUMBER_LIST_TYPE;
511:
512: TYPE CUSTOMER_ID_LIST_TYPE1 IS TABLE OF

Line 513: FV_INTERIM_CASH_RECEIPTS_ALL.CUSTOMER_ID%TYPE

509: INDEX BY BINARY_INTEGER;
510: PRIMARY_KEY4_LIST RECEIPT_NUMBER_LIST_TYPE;
511:
512: TYPE CUSTOMER_ID_LIST_TYPE1 IS TABLE OF
513: FV_INTERIM_CASH_RECEIPTS_ALL.CUSTOMER_ID%TYPE
514: INDEX BY BINARY_INTEGER;
515: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE1;
516: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE1;
517:

Line 519: FV_INTERIM_CASH_RECEIPTS_ALL.SITE_USE_ID%TYPE

515: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE1;
516: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE1;
517:
518: TYPE SITE_USE_ID_LIST_TYPE IS TABLE OF
519: FV_INTERIM_CASH_RECEIPTS_ALL.SITE_USE_ID%TYPE
520: INDEX BY BINARY_INTEGER;
521: NUM_COL2_ORIG_LIST SITE_USE_ID_LIST_TYPE;
522: NUM_COL2_NEW_LIST SITE_USE_ID_LIST_TYPE;
523:

Line 533: FROM FV_INTERIM_CASH_RECEIPTS yt, ra_customer_merges m

529: ,CUSTOMER_TRX_ID
530: ,RECEIPT_NUMBER
531: ,yt.CUSTOMER_ID
532: ,yt.SITE_USE_ID
533: FROM FV_INTERIM_CASH_RECEIPTS yt, ra_customer_merges m
534: WHERE (
535: yt.CUSTOMER_ID = m.DUPLICATE_ID
536: OR yt.SITE_USE_ID = m.DUPLICATE_SITE_ID
537: ) AND m.process_flag = 'N'

Line 547: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_INTERIM_CASH_RECEIPTS',FALSE);

543: IF process_mode='LOCK' THEN
544: NULL;
545: ELSE
546: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
547: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_INTERIM_CASH_RECEIPTS',FALSE);
548: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
549: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
550: END IF;
551: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

Line 598: 'FV_INTERIM_CASH_RECEIPTS',

594: LAST_UPDATE_LOGIN,
595: LAST_UPDATE_DATE,
596: LAST_UPDATED_BY
597: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
598: 'FV_INTERIM_CASH_RECEIPTS',
599: MERGE_HEADER_ID_LIST(I),
600: PRIMARY_KEY1_LIST(I),
601: PRIMARY_KEY2_LIST(I),
602: PRIMARY_KEY3_LIST(I),

Line 618: UPDATE FV_INTERIM_CASH_RECEIPTS yt SET

614: hz_utility_pub.LAST_UPDATED_BY
615: );
616:
617: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
618: UPDATE FV_INTERIM_CASH_RECEIPTS yt SET
619: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
620: ,SITE_USE_ID=NUM_COL2_NEW_LIST(I)
621: , LAST_UPDATE_DATE=SYSDATE
622: , last_updated_by=arp_standard.profile.user_id

Line 645: arp_message.set_line( 'FV_INTERIM_CASH_RECEIPTS');

641: EXCEPTION
642: WHEN OTHERS THEN
643: l_errbuf := SQLERRM;
644: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception', l_errbuf);
645: arp_message.set_line( 'FV_INTERIM_CASH_RECEIPTS');
646: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
647: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_ERROR, l_module_name);
648: END IF;
649: RAISE;

Line 650: END FV_INTERIM_CASH_RECEIPTS;

646: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
647: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_ERROR, l_module_name);
648: END IF;
649: RAISE;
650: END FV_INTERIM_CASH_RECEIPTS;
651:
652: ------------------------------------------------------------------------------
653: -- Merge Routine for FV_INVOICE_FINANCE_CHRGS table
654: -----------------------------------------------------------------------------

Line 945: FV_INTERIM_CASH_RECEIPTS(req_id, set_num, process_mode);

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
949: l_errbuf := SQLERRM;