APPS.FV_CMERGE dependencies on FV_INVOICE_FINANCE_CHRGS

Line 26: PROCEDURE FV_INVOICE_FINANCE_CHRGS (

22: req_id NUMBER,
23: set_num NUMBER,
24: process_mode VARCHAR2);
25:
26: PROCEDURE FV_INVOICE_FINANCE_CHRGS (
27: req_id NUMBER,
28: set_num NUMBER,
29: process_mode VARCHAR2);
30:

Line 653: -- Merge Routine for FV_INVOICE_FINANCE_CHRGS table

649: RAISE;
650: END FV_INTERIM_CASH_RECEIPTS;
651:
652: ------------------------------------------------------------------------------
653: -- Merge Routine for FV_INVOICE_FINANCE_CHRGS table
654: -----------------------------------------------------------------------------
655:
656: PROCEDURE FV_INVOICE_FINANCE_CHRGS (
657: req_id NUMBER,

Line 656: PROCEDURE FV_INVOICE_FINANCE_CHRGS (

652: ------------------------------------------------------------------------------
653: -- Merge Routine for FV_INVOICE_FINANCE_CHRGS table
654: -----------------------------------------------------------------------------
655:
656: PROCEDURE FV_INVOICE_FINANCE_CHRGS (
657: req_id NUMBER,
658: set_num NUMBER,
659: process_mode VARCHAR2) IS
660: l_module_name VARCHAR2(200) := g_module_name || 'FV_INVOICE_FINANCE_CHRGS';

Line 660: l_module_name VARCHAR2(200) := g_module_name || 'FV_INVOICE_FINANCE_CHRGS';

656: PROCEDURE FV_INVOICE_FINANCE_CHRGS (
657: req_id NUMBER,
658: set_num NUMBER,
659: process_mode VARCHAR2) IS
660: l_module_name VARCHAR2(200) := g_module_name || 'FV_INVOICE_FINANCE_CHRGS';
661: l_errbuf VARCHAR2(1024);
662:
663: TYPE MERGE_HEADER_ID_LIST_TYPE IS TABLE OF
664: RA_CUSTOMER_MERGE_HEADERS.CUSTOMER_MERGE_HEADER_ID%TYPE

Line 669: FV_INVOICE_FINANCE_CHRGS_ALL.CUSTOMER_TRX_ID%TYPE

665: INDEX BY BINARY_INTEGER;
666: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
667:
668: TYPE CUSTOMER_TRX_ID_LIST_TYPE IS TABLE OF
669: FV_INVOICE_FINANCE_CHRGS_ALL.CUSTOMER_TRX_ID%TYPE
670: INDEX BY BINARY_INTEGER;
671: PRIMARY_KEY1_LIST CUSTOMER_TRX_ID_LIST_TYPE;
672:
673: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 674: FV_INVOICE_FINANCE_CHRGS_ALL.CUSTOMER_ID%TYPE

670: INDEX BY BINARY_INTEGER;
671: PRIMARY_KEY1_LIST CUSTOMER_TRX_ID_LIST_TYPE;
672:
673: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
674: FV_INVOICE_FINANCE_CHRGS_ALL.CUSTOMER_ID%TYPE
675: INDEX BY BINARY_INTEGER;
676: PRIMARY_KEY2_LIST CUSTOMER_ID_LIST_TYPE;
677:
678: TYPE CHARGE_ID_LIST_TYPE IS TABLE OF

Line 679: FV_INVOICE_FINANCE_CHRGS_ALL.CHARGE_ID%TYPE

675: INDEX BY BINARY_INTEGER;
676: PRIMARY_KEY2_LIST CUSTOMER_ID_LIST_TYPE;
677:
678: TYPE CHARGE_ID_LIST_TYPE IS TABLE OF
679: FV_INVOICE_FINANCE_CHRGS_ALL.CHARGE_ID%TYPE
680: INDEX BY BINARY_INTEGER;
681: PRIMARY_KEY3_LIST CHARGE_ID_LIST_TYPE;
682:
683: TYPE CUSTOMER_ID_LIST_TYPE1 IS TABLE OF

Line 684: FV_INVOICE_FINANCE_CHRGS_ALL.CUSTOMER_ID%TYPE

680: INDEX BY BINARY_INTEGER;
681: PRIMARY_KEY3_LIST CHARGE_ID_LIST_TYPE;
682:
683: TYPE CUSTOMER_ID_LIST_TYPE1 IS TABLE OF
684: FV_INVOICE_FINANCE_CHRGS_ALL.CUSTOMER_ID%TYPE
685: INDEX BY BINARY_INTEGER;
686: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE1;
687: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE1;
688:

Line 696: FROM FV_INVOICE_FINANCE_CHRGS yt, ra_customer_merges m

692: ,CUSTOMER_TRX_ID
693: ,yt.CUSTOMER_ID
694: ,CHARGE_ID
695: ,yt.CUSTOMER_ID
696: FROM FV_INVOICE_FINANCE_CHRGS yt, ra_customer_merges m
697: WHERE (
698: yt.CUSTOMER_ID = m.DUPLICATE_ID
699: ) AND m.process_flag = 'N'
700: AND m.request_id = req_id

Line 709: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_INVOICE_FINANCE_CHRGS',FALSE);

705: IF process_mode='LOCK' THEN
706: NULL;
707: ELSE
708: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
709: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_INVOICE_FINANCE_CHRGS',FALSE);
710: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
711: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
712: END IF;
713: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

Line 754: 'FV_INVOICE_FINANCE_CHRGS',

750: LAST_UPDATE_LOGIN,
751: LAST_UPDATE_DATE,
752: LAST_UPDATED_BY
753: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
754: 'FV_INVOICE_FINANCE_CHRGS',
755: MERGE_HEADER_ID_LIST(I),
756: PRIMARY_KEY1_LIST(I),
757: PRIMARY_KEY2_LIST(I),
758: PRIMARY_KEY3_LIST(I),

Line 771: UPDATE FV_INVOICE_FINANCE_CHRGS yt SET

767: hz_utility_pub.LAST_UPDATED_BY
768: );
769:
770: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
771: UPDATE FV_INVOICE_FINANCE_CHRGS yt SET
772: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
773: , LAST_UPDATE_DATE=SYSDATE
774: , last_updated_by=arp_standard.profile.user_id
775: , last_update_login=arp_standard.profile.last_update_login

Line 796: arp_message.set_line( 'FV_INVOICE_FINANCE_CHRGS');

792: EXCEPTION
793: WHEN OTHERS THEN
794: l_errbuf := SQLERRM;
795: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception', l_errbuf);
796: arp_message.set_line( 'FV_INVOICE_FINANCE_CHRGS');
797: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
798: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_ERROR, l_module_name);
799: END IF;
800: RAISE;

Line 801: END FV_INVOICE_FINANCE_CHRGS;

797: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
798: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_ERROR, l_module_name);
799: END IF;
800: RAISE;
801: END FV_INVOICE_FINANCE_CHRGS;
802:
803: ------------------------------------------------------------------------------
804: -- Merge Routine for FV_IPAC_TRX table
805: -----------------------------------------------------------------------------

Line 946: FV_INVOICE_FINANCE_CHRGS(req_id, set_num, process_mode);

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;
950: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception', l_errbuf);