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 475: -- Merge Routine for FV_INTERIM_CASH_RECEIPTS table

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 (
478: req_id NUMBER,
479: set_num NUMBER,

Line 477: PROCEDURE FV_INTERIM_CASH_RECEIPTS (

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

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

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

Line 490: FV_INTERIM_CASH_RECEIPTS_ALL.BATCH_ID%TYPE

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

Line 495: FV_INTERIM_CASH_RECEIPTS_ALL.CUSTOMER_ID%TYPE

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

Line 500: FV_INTERIM_CASH_RECEIPTS_ALL.CUSTOMER_TRX_ID%TYPE

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

Line 505: FV_INTERIM_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE

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

Line 510: FV_INTERIM_CASH_RECEIPTS_ALL.CUSTOMER_ID%TYPE

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

Line 516: FV_INTERIM_CASH_RECEIPTS_ALL.SITE_USE_ID%TYPE

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

Line 530: FROM FV_INTERIM_CASH_RECEIPTS yt, ra_customer_merges m

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

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

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

Line 595: 'FV_INTERIM_CASH_RECEIPTS',

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

Line 615: UPDATE FV_INTERIM_CASH_RECEIPTS yt SET

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

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

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

Line 647: END FV_INTERIM_CASH_RECEIPTS;

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

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

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