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_CUST_FINANCE_CHRGS

Line 5: PROCEDURE FV_CUST_FINANCE_CHRGS (

1: package body FV_CMERGE AS
2: -- $Header: FVARCMGB.pls 120.12 2011/09/09 13:29:31 snama ship $
3: g_module_name VARCHAR2(100) := 'fv.plsql.FV_CMERGE.';
4:
5: PROCEDURE FV_CUST_FINANCE_CHRGS (
6: req_id NUMBER,
7: set_num NUMBER,
8: process_mode VARCHAR2);
9:

Line 39: -- Merge Routine for FV_CUST_FINANCE_CHRGS table

35:
36:
37:
38: ------------------------------------------------------------------------------
39: -- Merge Routine for FV_CUST_FINANCE_CHRGS table
40: ------------------------------------------------------------------------------
41: PROCEDURE FV_CUST_FINANCE_CHRGS (
42: req_id NUMBER,
43: set_num NUMBER,

Line 41: PROCEDURE FV_CUST_FINANCE_CHRGS (

37:
38: ------------------------------------------------------------------------------
39: -- Merge Routine for FV_CUST_FINANCE_CHRGS table
40: ------------------------------------------------------------------------------
41: PROCEDURE FV_CUST_FINANCE_CHRGS (
42: req_id NUMBER,
43: set_num NUMBER,
44: process_mode VARCHAR2) IS
45: l_module_name VARCHAR2(200) := g_module_name || 'FV_CUST_FINANCE_CHRGS';

Line 45: l_module_name VARCHAR2(200) := g_module_name || 'FV_CUST_FINANCE_CHRGS';

41: PROCEDURE FV_CUST_FINANCE_CHRGS (
42: req_id NUMBER,
43: set_num NUMBER,
44: process_mode VARCHAR2) IS
45: l_module_name VARCHAR2(200) := g_module_name || 'FV_CUST_FINANCE_CHRGS';
46: l_errbuf VARCHAR2(1024);
47:
48: TYPE MERGE_HEADER_ID_LIST_TYPE IS TABLE OF
49: RA_CUSTOMER_MERGE_HEADERS.CUSTOMER_MERGE_HEADER_ID%TYPE

Line 54: FV_CUST_FINANCE_CHRGS_ALL.CUSTOMER_ID%TYPE

50: INDEX BY BINARY_INTEGER;
51: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
52:
53: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
54: FV_CUST_FINANCE_CHRGS_ALL.CUSTOMER_ID%TYPE
55: INDEX BY BINARY_INTEGER;
56: PRIMARY_KEY1_LIST CUSTOMER_ID_LIST_TYPE;
57:
58: TYPE CHARGE_ID_LIST_TYPE IS TABLE OF

Line 59: FV_CUST_FINANCE_CHRGS_ALL.CHARGE_ID%TYPE

55: INDEX BY BINARY_INTEGER;
56: PRIMARY_KEY1_LIST CUSTOMER_ID_LIST_TYPE;
57:
58: TYPE CHARGE_ID_LIST_TYPE IS TABLE OF
59: FV_CUST_FINANCE_CHRGS_ALL.CHARGE_ID%TYPE
60: INDEX BY BINARY_INTEGER;
61: PRIMARY_KEY2_LIST CHARGE_ID_LIST_TYPE;
62:
63: TYPE CUSTOMER_ID_LIST_TYPE1 IS TABLE OF

Line 64: FV_CUST_FINANCE_CHRGS_ALL.CUSTOMER_ID%TYPE

60: INDEX BY BINARY_INTEGER;
61: PRIMARY_KEY2_LIST CHARGE_ID_LIST_TYPE;
62:
63: TYPE CUSTOMER_ID_LIST_TYPE1 IS TABLE OF
64: FV_CUST_FINANCE_CHRGS_ALL.CUSTOMER_ID%TYPE
65: INDEX BY BINARY_INTEGER;
66: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE1;
67: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE1;
68:

Line 75: FROM FV_CUST_FINANCE_CHRGS yt, ra_customer_merges m

71: SELECT distinct CUSTOMER_MERGE_HEADER_ID
72: ,yt.CUSTOMER_ID
73: ,yt.CHARGE_ID
74: ,yt.CUSTOMER_ID
75: FROM FV_CUST_FINANCE_CHRGS yt, ra_customer_merges m
76: WHERE (
77: yt.CUSTOMER_ID = m.DUPLICATE_ID
78: ) AND m.process_flag = 'N'
79: AND m.request_id = req_id

Line 88: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_CUST_FINANCE_CHRGS',FALSE);

84: IF process_mode='LOCK' THEN
85: NULL;
86: ELSE
87: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
88: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_CUST_FINANCE_CHRGS',FALSE);
89: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
90: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
91: END IF;
92:

Line 97: delete from fv_cust_finance_chrgs

93: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
94: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
95:
96: --remove records from table that will be duplicates when merged.
97: delete from fv_cust_finance_chrgs
98: where (customer_id, charge_id) in
99: (select duplicate_id, charge_id
100: from ra_customer_merges racm,
101: fv_cust_finance_chrgs fcfc

Line 101: fv_cust_finance_chrgs fcfc

97: delete from fv_cust_finance_chrgs
98: where (customer_id, charge_id) in
99: (select duplicate_id, charge_id
100: from ra_customer_merges racm,
101: fv_cust_finance_chrgs fcfc
102: where racm.process_flag = 'N'
103: and racm.request_id = req_id
104: and racm.set_number = set_num
105: and racm.customer_id = fcfc.customer_id

Line 108: from fv_cust_finance_chrgs

104: and racm.set_number = set_num
105: and racm.customer_id = fcfc.customer_id
106: and fcfc.charge_id in
107: (select charge_id
108: from fv_cust_finance_chrgs
109: where customer_id = racm.duplicate_id));
110:
111: open merged_records;
112: LOOP

Line 147: 'FV_CUST_FINANCE_CHRGS',

143: LAST_UPDATE_LOGIN,
144: LAST_UPDATE_DATE,
145: LAST_UPDATED_BY
146: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
147: 'FV_CUST_FINANCE_CHRGS',
148: MERGE_HEADER_ID_LIST(I),
149: PRIMARY_KEY1_LIST(I),
150: PRIMARY_KEY2_LIST(I),
151: NUM_COL1_ORIG_LIST(I),

Line 163: UPDATE FV_CUST_FINANCE_CHRGS yt SET

159: hz_utility_pub.LAST_UPDATED_BY
160: );
161:
162: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
163: UPDATE FV_CUST_FINANCE_CHRGS yt SET
164: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
165: , LAST_UPDATE_DATE=SYSDATE
166: , last_updated_by=arp_standard.profile.user_id
167: , last_update_login=arp_standard.profile.last_update_login

Line 187: arp_message.set_line( 'FV_CUST_FINANCE_CHRGS');

183: EXCEPTION
184: WHEN OTHERS THEN
185: l_errbuf := SQLERRM;
186: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception', l_errbuf);
187: arp_message.set_line( 'FV_CUST_FINANCE_CHRGS');
188: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
189: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_ERROR, l_module_name);
190: END IF;
191: RAISE;

Line 192: END FV_CUST_FINANCE_CHRGS;

188: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
189: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_ERROR, l_module_name);
190: END IF;
191: RAISE;
192: END FV_CUST_FINANCE_CHRGS;
193:
194: ------------------------------------------------------------------------------
195: -- Merge Routine for FV_CUST_VEND_XREFS table
196: -----------------------------------------------------------------------------

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

938: l_module_name VARCHAR2(200) := g_module_name || 'merge';
939: l_errbuf VARCHAR2(1024);
940:
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);