APPS.ARP_CMERGE_ARCPF dependencies on AR_CREDIT_HISTORIES

Line 6: --merge ar_credit_histories

2: /* $Header: ARPLCPFB.pls 120.3 2005/06/24 06:16:27 rchanamo shipped $ */
3:
4: g_count NUMBER := 0;
5:
6: --merge ar_credit_histories
7: procedure ar_ch (
8: req_id NUMBER,
9: set_num NUMBER,
10: process_mode VARCHAR2

Line 79: | merge in AR_CREDIT_HISTORIES

75: | PROCEDURE
76: | ar_ch
77: |
78: | DESCRIPTION
79: | merge in AR_CREDIT_HISTORIES
80: |
81: | SCOPE - PRIVATE
82: |
83: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 110: FROM AR_CREDIT_HISTORIES yt, ra_customer_merges m

106: ) IS
107:
108: CURSOR c1 is
109: SELECT CREDIT_HISTORY_ID
110: FROM AR_CREDIT_HISTORIES yt, ra_customer_merges m
111: WHERE yt.customer_id = m.duplicate_id
112: AND yt.site_use_id = m.duplicate_site_id
113: AND m.process_flag = 'N'
114: AND m.request_id = req_id

Line 121: FROM AR_CREDIT_HISTORIES yt, ra_customer_merges m

117: FOR UPDATE NOWAIT;
118:
119: CURSOR c2 is
120: SELECT CREDIT_HISTORY_ID
121: FROM AR_CREDIT_HISTORIES yt, ra_customer_merges m
122: WHERE yt.customer_id = m.duplicate_id
123: AND m.process_flag = 'N'
124: AND m.request_id = req_id
125: AND m.set_number = set_num

Line 150: arp_message.set_token( 'TABLE_NAME', 'AR_CREDIT_HISTORIES', FALSE );

146:
147: --site level delete
148:
149: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );
150: arp_message.set_token( 'TABLE_NAME', 'AR_CREDIT_HISTORIES', FALSE );
151:
152: --Bug 1725662: Modified 'ar_ch' to use index.
153:
154: DELETE FROM AR_CREDIT_HISTORIES yt

Line 154: DELETE FROM AR_CREDIT_HISTORIES yt

150: arp_message.set_token( 'TABLE_NAME', 'AR_CREDIT_HISTORIES', FALSE );
151:
152: --Bug 1725662: Modified 'ar_ch' to use index.
153:
154: DELETE FROM AR_CREDIT_HISTORIES yt
155: WHERE (customer_id, site_use_id) IN (
156: SELECT m.duplicate_id, m.duplicate_site_id
157: FROM ra_customer_merges m
158: WHERE m.process_flag = 'N'

Line 171: arp_message.set_token( 'TABLE_NAME', 'AR_CREDIT_HISTORIES', FALSE );

167:
168: --customer level delete
169:
170: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );
171: arp_message.set_token( 'TABLE_NAME', 'AR_CREDIT_HISTORIES', FALSE );
172:
173: DELETE FROM AR_CREDIT_HISTORIES yt
174: WHERE customer_id IN (
175: SELECT m.duplicate_id

Line 173: DELETE FROM AR_CREDIT_HISTORIES yt

169:
170: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );
171: arp_message.set_token( 'TABLE_NAME', 'AR_CREDIT_HISTORIES', FALSE );
172:
173: DELETE FROM AR_CREDIT_HISTORIES yt
174: WHERE customer_id IN (
175: SELECT m.duplicate_id
176: FROM ra_customer_merges m
177: WHERE m.process_flag = 'N'