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 801: -- Merge Routine for FV_IPAC_TRX table

797: RAISE;
798: END FV_INVOICE_FINANCE_CHRGS;
799:
800: ------------------------------------------------------------------------------
801: -- Merge Routine for FV_IPAC_TRX table
802: -----------------------------------------------------------------------------
803:
804:
805: PROCEDURE FV_IPAC_TRX (

Line 805: PROCEDURE FV_IPAC_TRX (

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

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

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

Line 818: FV_IPAC_TRX_ALL.IPAC_BILLING_ID%TYPE

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

Line 823: FV_IPAC_TRX_ALL.CUSTOMER_ID%TYPE

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

Line 833: FROM FV_IPAC_TRX yt, ra_customer_merges m

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

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

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

Line 887: 'FV_IPAC_TRX',

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

Line 902: UPDATE FV_IPAC_TRX yt SET

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

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

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

Line 930: END FV_IPAC_TRX;

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

Line 944: FV_IPAC_TRX(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;
947: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception', l_errbuf);
948: RAISE;