APPS.ARP_CMERGE_ARTRX dependencies on RA_CUSTOMER_TRX_LINES

Line 537: RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE

533: INDEX BY BINARY_INTEGER;
534: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
535:
536: TYPE customer_trx_line_id_LIST_TYPE IS TABLE OF
537: RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE
538: INDEX BY BINARY_INTEGER;
539: PRIMARY_KEY_ID_LIST customer_trx_line_id_LIST_TYPE;
540:
541: TYPE ship_to_customer_id_LIST_TYPE IS TABLE OF

Line 542: RA_CUSTOMER_TRX_LINES.ship_to_customer_id%TYPE

538: INDEX BY BINARY_INTEGER;
539: PRIMARY_KEY_ID_LIST customer_trx_line_id_LIST_TYPE;
540:
541: TYPE ship_to_customer_id_LIST_TYPE IS TABLE OF
542: RA_CUSTOMER_TRX_LINES.ship_to_customer_id%TYPE
543: INDEX BY BINARY_INTEGER;
544: NUM_COL1_ORIG_LIST ship_to_customer_id_LIST_TYPE;
545: NUM_COL1_NEW_LIST ship_to_customer_id_LIST_TYPE;
546:

Line 548: RA_CUSTOMER_TRX_LINES.ship_to_site_use_id%TYPE

544: NUM_COL1_ORIG_LIST ship_to_customer_id_LIST_TYPE;
545: NUM_COL1_NEW_LIST ship_to_customer_id_LIST_TYPE;
546:
547: TYPE ship_to_site_use_id_LIST_TYPE IS TABLE OF
548: RA_CUSTOMER_TRX_LINES.ship_to_site_use_id%TYPE
549: INDEX BY BINARY_INTEGER;
550: NUM_COL2_ORIG_LIST ship_to_site_use_id_LIST_TYPE;
551: NUM_COL2_NEW_LIST ship_to_site_use_id_LIST_TYPE;
552:

Line 561: FROM RA_CUSTOMER_TRX_LINES yt , ra_customer_merges m

557: ,customer_trx_line_id
558: ,ship_to_customer_id
559: ,ship_to_site_use_id
560:
561: FROM RA_CUSTOMER_TRX_LINES yt , ra_customer_merges m
562: WHERE
563: yt.ship_to_customer_id = m.DUPLICATE_ID AND
564: nvl(yt.ship_to_site_use_id,m.DUPLICATE_SITE_ID) = m.DUPLICATE_SITE_ID
565:

Line 576: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RA_CUSTOMER_TRX_LINES',FALSE);

572: IF process_mode='LOCK' THEN
573: NULL;
574: ELSE
575: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
576: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RA_CUSTOMER_TRX_LINES',FALSE);
577: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
578: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
579:
580: open merged_records;

Line 620: 'RA_CUSTOMER_TRX_LINES',

616: LAST_UPDATE_LOGIN,
617: LAST_UPDATE_DATE,
618: LAST_UPDATED_BY
619: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
620: 'RA_CUSTOMER_TRX_LINES',
621: MERGE_HEADER_ID_LIST(I),
622: PRIMARY_KEY_ID_LIST(I),
623: NUM_COL1_ORIG_LIST(I),
624: NUM_COL1_NEW_LIST(I),

Line 636: UPDATE RA_CUSTOMER_TRX_LINES yt SET

632: hz_utility_pub.LAST_UPDATE_DATE,
633: hz_utility_pub.LAST_UPDATED_BY
634: );
635: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
636: UPDATE RA_CUSTOMER_TRX_LINES yt SET
637:
638: ship_to_customer_id=NUM_COL1_NEW_LIST(I)
639: ,ship_to_site_use_id=NUM_COL2_NEW_LIST(I)
640: , LAST_UPDATE_DATE=SYSDATE