APPS.ARP_CMERGE_ARTRX dependencies on AR_PAYMENT_SCHEDULES

Line 152: AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE

148: INDEX BY BINARY_INTEGER;
149: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
150:
151: TYPE payment_schedule_id_LIST_TYPE IS TABLE OF
152: AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE
153: INDEX BY BINARY_INTEGER;
154: PRIMARY_KEY_ID_LIST payment_schedule_id_LIST_TYPE;
155:
156: TYPE customer_id_LIST_TYPE IS TABLE OF

Line 157: AR_PAYMENT_SCHEDULES.customer_id%TYPE

153: INDEX BY BINARY_INTEGER;
154: PRIMARY_KEY_ID_LIST payment_schedule_id_LIST_TYPE;
155:
156: TYPE customer_id_LIST_TYPE IS TABLE OF
157: AR_PAYMENT_SCHEDULES.customer_id%TYPE
158: INDEX BY BINARY_INTEGER;
159: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
160: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
161:

Line 163: AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE

159: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
160: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
161:
162: TYPE customer_site_use_id_LIST_TYPE IS TABLE OF
163: AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE
164: INDEX BY BINARY_INTEGER;
165: NUM_COL2_ORIG_LIST customer_site_use_id_LIST_TYPE;
166: NUM_COL2_NEW_LIST customer_site_use_id_LIST_TYPE;
167:

Line 174: FROM AR_PAYMENT_SCHEDULES yt, ra_customer_merges m

170: SELECT distinct CUSTOMER_MERGE_HEADER_ID
171: ,payment_schedule_id
172: ,yt.customer_id
173: ,customer_site_use_id
174: FROM AR_PAYMENT_SCHEDULES yt, ra_customer_merges m
175: WHERE ( yt.customer_id = m.DUPLICATE_ID AND
176: nvl(yt.customer_site_use_id, m.DUPLICATE_SITE_ID) = m.DUPLICATE_SITE_ID)
177: AND m.process_flag = 'N'
178: AND m.request_id = req_id

Line 187: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_PAYMENT_SCHEDULES',FALSE);

183: IF process_mode='LOCK' THEN
184: NULL;
185: ELSE
186: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
187: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_PAYMENT_SCHEDULES',FALSE);
188: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
189: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
190:
191: open merged_records;

Line 228: 'AR_PAYMENT_SCHEDULES',

224: LAST_UPDATE_LOGIN,
225: LAST_UPDATE_DATE,
226: LAST_UPDATED_BY
227: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
228: 'AR_PAYMENT_SCHEDULES',
229: MERGE_HEADER_ID_LIST(I),
230: PRIMARY_KEY_ID_LIST(I),
231: NUM_COL1_ORIG_LIST(I),
232: NUM_COL1_NEW_LIST(I),

Line 245: UPDATE AR_PAYMENT_SCHEDULES yt SET

241: hz_utility_pub.LAST_UPDATED_BY
242: );
243:
244: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
245: UPDATE AR_PAYMENT_SCHEDULES yt SET
246: customer_id=NUM_COL1_NEW_LIST(I)
247: ,customer_site_use_id=NUM_COL2_NEW_LIST(I)
248: , LAST_UPDATE_DATE=SYSDATE
249: , last_updated_by=arp_standard.profile.user_id