APPS.ARP_CMERGE_ARTRX dependencies on AR_DISTRIBUTIONS

Line 1298: AR_DISTRIBUTIONS.line_id%TYPE

1294: INDEX BY BINARY_INTEGER;
1295: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1296:
1297: TYPE line_id_LIST_TYPE IS TABLE OF
1298: AR_DISTRIBUTIONS.line_id%TYPE
1299: INDEX BY BINARY_INTEGER;
1300: PRIMARY_KEY_ID_LIST line_id_LIST_TYPE;
1301:
1302: TYPE third_party_id_LIST_TYPE IS TABLE OF

Line 1303: AR_DISTRIBUTIONS.third_party_id%TYPE

1299: INDEX BY BINARY_INTEGER;
1300: PRIMARY_KEY_ID_LIST line_id_LIST_TYPE;
1301:
1302: TYPE third_party_id_LIST_TYPE IS TABLE OF
1303: AR_DISTRIBUTIONS.third_party_id%TYPE
1304: INDEX BY BINARY_INTEGER;
1305: NUM_COL1_ORIG_LIST third_party_id_LIST_TYPE;
1306: NUM_COL1_NEW_LIST third_party_id_LIST_TYPE;
1307:

Line 1309: AR_DISTRIBUTIONS.third_party_sub_id%TYPE

1305: NUM_COL1_ORIG_LIST third_party_id_LIST_TYPE;
1306: NUM_COL1_NEW_LIST third_party_id_LIST_TYPE;
1307:
1308: TYPE third_party_sub_id_LIST_TYPE IS TABLE OF
1309: AR_DISTRIBUTIONS.third_party_sub_id%TYPE
1310: INDEX BY BINARY_INTEGER;
1311: NUM_COL2_ORIG_LIST third_party_sub_id_LIST_TYPE;
1312: NUM_COL2_NEW_LIST third_party_sub_id_LIST_TYPE;
1313:

Line 1320: FROM AR_DISTRIBUTIONS yt, ra_customer_merges m

1316: SELECT distinct CUSTOMER_MERGE_HEADER_ID
1317: ,line_id
1318: ,third_party_id
1319: ,third_party_sub_id
1320: FROM AR_DISTRIBUTIONS yt, ra_customer_merges m
1321: WHERE ( (yt.third_party_id = m.DUPLICATE_ID AND
1322: nvl(yt.third_party_sub_id,m.DUPLICATE_SITE_ID) = m.DUPLICATE_SITE_ID))
1323: AND m.process_flag = 'N'
1324: AND m.request_id = req_id

Line 1333: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_DISTRIBUTIONS',FALSE);

1329: IF process_mode='LOCK' THEN
1330: NULL;
1331: ELSE
1332: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1333: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_DISTRIBUTIONS',FALSE);
1334: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1335: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1336:
1337: open merged_records;

Line 1374: 'AR_DISTRIBUTIONS',

1370: LAST_UPDATE_LOGIN,
1371: LAST_UPDATE_DATE,
1372: LAST_UPDATED_BY
1373: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1374: 'AR_DISTRIBUTIONS',
1375: MERGE_HEADER_ID_LIST(I),
1376: PRIMARY_KEY_ID_LIST(I),
1377: NUM_COL1_ORIG_LIST(I),
1378: NUM_COL1_NEW_LIST(I),

Line 1391: UPDATE AR_DISTRIBUTIONS yt SET

1387: hz_utility_pub.LAST_UPDATED_BY
1388: );
1389:
1390: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1391: UPDATE AR_DISTRIBUTIONS yt SET
1392: third_party_id=NUM_COL1_NEW_LIST(I)
1393: ,third_party_sub_id=NUM_COL2_NEW_LIST(I)
1394: , LAST_UPDATE_DATE=SYSDATE
1395: , last_updated_by=arp_standard.profile.user_id