APPS.MRPP_CMERGE_FCST dependencies on MRP_SALES_ORDER_UPDATES

Line 507: | Account merge procedure for the table, MRP_SALES_ORDER_UPDATES

503: |
504: | PROCEDURE
505: | MRP_SOU
506: | DESCRIPTION :
507: | Account merge procedure for the table, MRP_SALES_ORDER_UPDATES
508: |
509: |
510: |--------------------------------------------------------------*/
511:

Line 523: MRP_SALES_ORDER_UPDATES.UPDATE_SEQ_NUM%TYPE

519: INDEX BY BINARY_INTEGER;
520: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
521:
522: TYPE UPDATE_SEQ_NUM_LIST_TYPE IS TABLE OF
523: MRP_SALES_ORDER_UPDATES.UPDATE_SEQ_NUM%TYPE
524: INDEX BY BINARY_INTEGER;
525: PRIMARY_KEY_ID_LIST UPDATE_SEQ_NUM_LIST_TYPE;
526:
527: TYPE current_customer_id_LIST_TYPE IS TABLE OF

Line 528: MRP_SALES_ORDER_UPDATES.current_customer_id%TYPE

524: INDEX BY BINARY_INTEGER;
525: PRIMARY_KEY_ID_LIST UPDATE_SEQ_NUM_LIST_TYPE;
526:
527: TYPE current_customer_id_LIST_TYPE IS TABLE OF
528: MRP_SALES_ORDER_UPDATES.current_customer_id%TYPE
529: INDEX BY BINARY_INTEGER;
530: NUM_COL1_ORIG_LIST current_customer_id_LIST_TYPE;
531: NUM_COL1_NEW_LIST current_customer_id_LIST_TYPE;
532:

Line 534: MRP_SALES_ORDER_UPDATES.current_ship_id%TYPE

530: NUM_COL1_ORIG_LIST current_customer_id_LIST_TYPE;
531: NUM_COL1_NEW_LIST current_customer_id_LIST_TYPE;
532:
533: TYPE current_ship_id_LIST_TYPE IS TABLE OF
534: MRP_SALES_ORDER_UPDATES.current_ship_id%TYPE
535: INDEX BY BINARY_INTEGER;
536: NUM_COL2_ORIG_LIST current_ship_id_LIST_TYPE;
537: NUM_COL2_NEW_LIST current_ship_id_LIST_TYPE;
538:

Line 540: MRP_SALES_ORDER_UPDATES.current_bill_id%TYPE

536: NUM_COL2_ORIG_LIST current_ship_id_LIST_TYPE;
537: NUM_COL2_NEW_LIST current_ship_id_LIST_TYPE;
538:
539: TYPE current_bill_id_LIST_TYPE IS TABLE OF
540: MRP_SALES_ORDER_UPDATES.current_bill_id%TYPE
541: INDEX BY BINARY_INTEGER;
542: NUM_COL3_ORIG_LIST current_bill_id_LIST_TYPE;
543: NUM_COL3_NEW_LIST current_bill_id_LIST_TYPE;
544:

Line 546: MRP_SALES_ORDER_UPDATES.previous_customer_id%TYPE

542: NUM_COL3_ORIG_LIST current_bill_id_LIST_TYPE;
543: NUM_COL3_NEW_LIST current_bill_id_LIST_TYPE;
544:
545: TYPE previous_customer_id_LIST_TYPE IS TABLE OF
546: MRP_SALES_ORDER_UPDATES.previous_customer_id%TYPE
547: INDEX BY BINARY_INTEGER;
548: NUM_COL4_ORIG_LIST previous_customer_id_LIST_TYPE;
549: NUM_COL4_NEW_LIST previous_customer_id_LIST_TYPE;
550:

Line 552: MRP_SALES_ORDER_UPDATES.previous_bill_id%TYPE

548: NUM_COL4_ORIG_LIST previous_customer_id_LIST_TYPE;
549: NUM_COL4_NEW_LIST previous_customer_id_LIST_TYPE;
550:
551: TYPE previous_bill_id_LIST_TYPE IS TABLE OF
552: MRP_SALES_ORDER_UPDATES.previous_bill_id%TYPE
553: INDEX BY BINARY_INTEGER;
554: NUM_COL5_ORIG_LIST previous_bill_id_LIST_TYPE;
555: NUM_COL5_NEW_LIST previous_bill_id_LIST_TYPE;
556:

Line 558: MRP_SALES_ORDER_UPDATES.previous_ship_id%TYPE

554: NUM_COL5_ORIG_LIST previous_bill_id_LIST_TYPE;
555: NUM_COL5_NEW_LIST previous_bill_id_LIST_TYPE;
556:
557: TYPE previous_ship_id_LIST_TYPE IS TABLE OF
558: MRP_SALES_ORDER_UPDATES.previous_ship_id%TYPE
559: INDEX BY BINARY_INTEGER;
560: NUM_COL6_ORIG_LIST previous_ship_id_LIST_TYPE;
561: NUM_COL6_NEW_LIST previous_ship_id_LIST_TYPE;
562:

Line 573: FROM MRP_SALES_ORDER_UPDATES yt, ra_customer_merges m

569: ,current_bill_id
570: ,previous_customer_id
571: ,previous_bill_id
572: ,previous_ship_id
573: FROM MRP_SALES_ORDER_UPDATES yt, ra_customer_merges m
574: WHERE (
575: yt.current_customer_id = m.DUPLICATE_ID
576: OR yt.current_ship_id = m.DUPLICATE_SITE_ID
577: OR yt.current_bill_id = m.DUPLICATE_SITE_ID

Line 591: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_SALES_ORDER_UPDATES',FALSE);

587: IF process_mode='LOCK' THEN
588: NULL;
589: ELSE
590: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
591: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_SALES_ORDER_UPDATES',FALSE);
592: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
593: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
594:
595: open merged_records;

Line 649: 'MRP_SALES_ORDER_UPDATES',

645: LAST_UPDATE_LOGIN,
646: LAST_UPDATE_DATE,
647: LAST_UPDATED_BY
648: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
649: 'MRP_SALES_ORDER_UPDATES',
650: MERGE_HEADER_ID_LIST(I),
651: PRIMARY_KEY_ID_LIST(I),
652: NUM_COL1_ORIG_LIST(I),
653: NUM_COL1_NEW_LIST(I),

Line 674: UPDATE MRP_SALES_ORDER_UPDATES yt SET

670: hz_utility_pub.LAST_UPDATED_BY
671: );
672:
673: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
674: UPDATE MRP_SALES_ORDER_UPDATES yt SET
675: current_customer_id=NUM_COL1_NEW_LIST(I)
676: ,current_ship_id=NUM_COL2_NEW_LIST(I)
677: ,current_bill_id=NUM_COL3_NEW_LIST(I)
678: ,previous_customer_id=NUM_COL4_NEW_LIST(I)