APPS.FV_CMERGE dependencies on FV_IPAC_TRX

Line 31: PROCEDURE FV_IPAC_TRX (

27: req_id NUMBER,
28: set_num NUMBER,
29: process_mode VARCHAR2);
30:
31: PROCEDURE FV_IPAC_TRX (
32: req_id NUMBER,
33: set_num NUMBER,
34: process_mode VARCHAR2);
35:

Line 804: -- Merge Routine for FV_IPAC_TRX table

800: RAISE;
801: END FV_INVOICE_FINANCE_CHRGS;
802:
803: ------------------------------------------------------------------------------
804: -- Merge Routine for FV_IPAC_TRX table
805: -----------------------------------------------------------------------------
806:
807:
808: PROCEDURE FV_IPAC_TRX (

Line 808: PROCEDURE FV_IPAC_TRX (

804: -- Merge Routine for FV_IPAC_TRX table
805: -----------------------------------------------------------------------------
806:
807:
808: PROCEDURE FV_IPAC_TRX (
809: req_id NUMBER,
810: set_num NUMBER,
811: process_mode VARCHAR2) IS
812: l_module_name VARCHAR2(200) := g_module_name || 'FV_IPAC_TRX';

Line 812: l_module_name VARCHAR2(200) := g_module_name || 'FV_IPAC_TRX';

808: PROCEDURE FV_IPAC_TRX (
809: req_id NUMBER,
810: set_num NUMBER,
811: process_mode VARCHAR2) IS
812: l_module_name VARCHAR2(200) := g_module_name || 'FV_IPAC_TRX';
813: l_errbuf VARCHAR2(1024);
814:
815: TYPE MERGE_HEADER_ID_LIST_TYPE IS TABLE OF
816: RA_CUSTOMER_MERGE_HEADERS.CUSTOMER_MERGE_HEADER_ID%TYPE

Line 821: FV_IPAC_TRX_ALL.IPAC_BILLING_ID%TYPE

817: INDEX BY BINARY_INTEGER;
818: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
819:
820: TYPE IPAC_BILLING_ID_LIST_TYPE IS TABLE OF
821: FV_IPAC_TRX_ALL.IPAC_BILLING_ID%TYPE
822: INDEX BY BINARY_INTEGER;
823: PRIMARY_KEY1_LIST IPAC_BILLING_ID_LIST_TYPE;
824:
825: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 826: FV_IPAC_TRX_ALL.CUSTOMER_ID%TYPE

822: INDEX BY BINARY_INTEGER;
823: PRIMARY_KEY1_LIST IPAC_BILLING_ID_LIST_TYPE;
824:
825: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
826: FV_IPAC_TRX_ALL.CUSTOMER_ID%TYPE
827: INDEX BY BINARY_INTEGER;
828: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
829: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
830:

Line 836: FROM FV_IPAC_TRX yt, ra_customer_merges m

832: CURSOR merged_records IS
833: SELECT distinct CUSTOMER_MERGE_HEADER_ID
834: ,IPAC_BILLING_ID
835: ,yt.CUSTOMER_ID
836: FROM FV_IPAC_TRX yt, ra_customer_merges m
837: WHERE (
838: yt.CUSTOMER_ID = m.DUPLICATE_ID
839: ) AND m.process_flag = 'N'
840: AND m.request_id = req_id

Line 849: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_IPAC_TRX',FALSE);

845: IF process_mode='LOCK' THEN
846: NULL;
847: ELSE
848: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
849: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_IPAC_TRX',FALSE);
850: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
851: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
852: END IF;
853: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

Line 890: 'FV_IPAC_TRX',

886: LAST_UPDATE_LOGIN,
887: LAST_UPDATE_DATE,
888: LAST_UPDATED_BY
889: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
890: 'FV_IPAC_TRX',
891: MERGE_HEADER_ID_LIST(I),
892: PRIMARY_KEY1_LIST(I),
893: NUM_COL1_ORIG_LIST(I),
894: NUM_COL1_NEW_LIST(I),

Line 905: UPDATE FV_IPAC_TRX yt SET

901: hz_utility_pub.LAST_UPDATED_BY
902: );
903:
904: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
905: UPDATE FV_IPAC_TRX yt SET
906: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
907: , LAST_UPDATE_DATE=SYSDATE
908: , last_updated_by=arp_standard.profile.user_id
909: , last_update_login=arp_standard.profile.last_update_login

Line 928: arp_message.set_line( 'FV_IPAC_TRX');

924: EXCEPTION
925: WHEN OTHERS THEN
926: l_errbuf := SQLERRM;
927: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception', l_errbuf);
928: arp_message.set_line( 'FV_IPAC_TRX');
929: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
930: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_ERROR, l_module_name);
931: END IF;
932: RAISE;

Line 933: END FV_IPAC_TRX;

929: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
930: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_ERROR, l_module_name);
931: END IF;
932: RAISE;
933: END FV_IPAC_TRX;
934:
935: PROCEDURE merge(req_id IN Number,
936: set_num IN NUMBER,
937: process_mode IN VARCHAR2) IS

Line 947: FV_IPAC_TRX(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);
951: RAISE;