APPS.MRPP_CMERGE_FCST dependencies on MRP_SR_ASSIGNMENTS

Line 710: | Account merge procedure for the table, MRP_SR_ASSIGNMENTS

706: |
707: | PROCEDURE
708: | MRP_SA
709: | DESCRIPTION :
710: | Account merge procedure for the table, MRP_SR_ASSIGNMENTS
711: |
712: | NOTES:
713: |--------------------------------------------------------------*/
714:

Line 726: MRP_SR_ASSIGNMENTS.ASSIGNMENT_ID%TYPE

722: INDEX BY BINARY_INTEGER;
723: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
724:
725: TYPE ASSIGNMENT_ID_LIST_TYPE IS TABLE OF
726: MRP_SR_ASSIGNMENTS.ASSIGNMENT_ID%TYPE
727: INDEX BY BINARY_INTEGER;
728: PRIMARY_KEY_ID_LIST ASSIGNMENT_ID_LIST_TYPE;
729:
730: TYPE customer_id_LIST_TYPE IS TABLE OF

Line 731: MRP_SR_ASSIGNMENTS.customer_id%TYPE

727: INDEX BY BINARY_INTEGER;
728: PRIMARY_KEY_ID_LIST ASSIGNMENT_ID_LIST_TYPE;
729:
730: TYPE customer_id_LIST_TYPE IS TABLE OF
731: MRP_SR_ASSIGNMENTS.customer_id%TYPE
732: INDEX BY BINARY_INTEGER;
733: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
734: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
735:

Line 737: MRP_SR_ASSIGNMENTS.ship_to_site_id%TYPE

733: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
734: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
735:
736: TYPE ship_to_site_id_LIST_TYPE IS TABLE OF
737: MRP_SR_ASSIGNMENTS.ship_to_site_id%TYPE
738: INDEX BY BINARY_INTEGER;
739: NUM_COL2_ORIG_LIST ship_to_site_id_LIST_TYPE;
740: NUM_COL2_NEW_LIST ship_to_site_id_LIST_TYPE;
741:

Line 748: FROM MRP_SR_ASSIGNMENTS yt, ra_customer_merges m

744: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
745: ,yt.ASSIGNMENT_ID
746: ,yt.customer_id
747: ,yt.ship_to_site_id
748: FROM MRP_SR_ASSIGNMENTS yt, ra_customer_merges m
749: WHERE (
750: yt.customer_id = m.DUPLICATE_ID
751: OR yt.ship_to_site_id = m.DUPLICATE_SITE_ID
752: ) AND yt.assignment_type in (4,5,6)

Line 763: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_SR_ASSIGNMENTS',FALSE);

759: IF process_mode='LOCK' THEN
760: NULL;
761: ELSE
762: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
763: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_SR_ASSIGNMENTS',FALSE);
764: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
765: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
766:
767: open merged_records;

Line 805: 'MRP_SR_ASSIGNMENTS',

801: LAST_UPDATE_LOGIN,
802: LAST_UPDATE_DATE,
803: LAST_UPDATED_BY
804: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
805: 'MRP_SR_ASSIGNMENTS',
806: MERGE_HEADER_ID_LIST(I),
807: PRIMARY_KEY_ID_LIST(I),
808: NUM_COL1_ORIG_LIST(I),
809: NUM_COL1_NEW_LIST(I),

Line 823: UPDATE MRP_SR_ASSIGNMENTS yt SET

819: );
820:
821: END IF;
822: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
823: UPDATE MRP_SR_ASSIGNMENTS yt SET
824: customer_id=NUM_COL1_NEW_LIST(I)
825: ,ship_to_site_id=NUM_COL2_NEW_LIST(I)
826: , LAST_UPDATE_DATE=SYSDATE
827: , last_updated_by=arp_standard.profile.user_id