APPS.ASO_MERGE_PVT dependencies on ASO_SHIPMENTS

Line 416: | This is a private procedure to update ASO_SHIPMENTS |

412: /*----------------------------------------------------------------------------*
413: | PRIVATE PROCEDURE |
414: | UPDATE_SHIPMENTS |
415: | DESCRIPTION |
416: | This is a private procedure to update ASO_SHIPMENTS |
417: | table with merged to cust account id. When two cust accounts |
418: | are merged. |
419: | REQUIRES |
420: | |

Line 445: ASO_SHIPMENTS.SHIPMENT_ID%TYPE

441: INDEX BY BINARY_INTEGER;
442: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
443:
444: TYPE SHIPMENT_ID_LIST_TYPE IS TABLE OF
445: ASO_SHIPMENTS.SHIPMENT_ID%TYPE
446: INDEX BY BINARY_INTEGER;
447: PRIMARY_KEY_ID_LIST SHIPMENT_ID_LIST_TYPE;
448:
449: TYPE SHIP_TO_CUST_ACCT_ID_LIST_TYPE IS TABLE OF

Line 450: ASO_SHIPMENTS.SHIP_TO_CUST_ACCOUNT_ID%TYPE

446: INDEX BY BINARY_INTEGER;
447: PRIMARY_KEY_ID_LIST SHIPMENT_ID_LIST_TYPE;
448:
449: TYPE SHIP_TO_CUST_ACCT_ID_LIST_TYPE IS TABLE OF
450: ASO_SHIPMENTS.SHIP_TO_CUST_ACCOUNT_ID%TYPE
451: INDEX BY BINARY_INTEGER;
452: NUM_COL1_ORIG_LIST SHIP_TO_CUST_ACCT_ID_LIST_TYPE;
453: NUM_COL1_NEW_LIST SHIP_TO_CUST_ACCT_ID_LIST_TYPE;
454:

Line 461: FROM ASO_SHIPMENTS yt, ra_customer_merges m

457: CURSOR merged_records IS
458: SELECT distinct CUSTOMER_MERGE_HEADER_ID
459: ,SHIPMENT_ID
460: ,SHIP_TO_CUST_ACCOUNT_ID
461: FROM ASO_SHIPMENTS yt, ra_customer_merges m
462: WHERE (
463: yt.SHIP_TO_CUST_ACCOUNT_ID = m.DUPLICATE_ID
464: ) AND m.process_flag = 'N'
465: AND m.request_id = req_id

Line 477: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ASO_SHIPMENTS',FALSE);

473: IF process_mode='LOCK' THEN
474: NULL;
475: ELSE
476: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
477: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ASO_SHIPMENTS',FALSE);
478: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
479: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
480:
481: open merged_records;

Line 519: 'ASO_SHIPMENTS',

515: LAST_UPDATE_LOGIN,
516: LAST_UPDATE_DATE,
517: LAST_UPDATED_BY
518: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
519: 'ASO_SHIPMENTS',
520: MERGE_HEADER_ID_LIST(I),
521: PRIMARY_KEY_ID_LIST(I),
522: NUM_COL1_ORIG_LIST(I),
523: NUM_COL1_NEW_LIST(I),

Line 537: UPDATE ASO_SHIPMENTS yt SET

533:
534: END IF;
535:
536: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
537: UPDATE ASO_SHIPMENTS yt SET
538: SHIP_TO_CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
539: , LAST_UPDATE_DATE=SYSDATE
540: , last_updated_by=arp_standard.profile.user_id
541: , last_update_login=arp_standard.profile.last_update_login

Line 876: | This procedure will update ASO_SHIPMENTS table |

872: | MERGE_SHIPMENTS-- |
873: | When in ERP Parties are merged the |
874: | The Foriegn keys to party_id and other columns |
875: | should also be updated in iStore tables. |
876: | This procedure will update ASO_SHIPMENTS table |
877: | and will be called from party Merge concurrent program. |
878: | DESCRIPTION |
879: | |
880: | REQUIRES |

Line 935: arp_message.set_token('TABLE_NAME','ASO_SHIPMENTS', FALSE);

931:
932: If p_parent_entity_name = 'HZ_PARTIES' Then
933:
934: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
935: arp_message.set_token('TABLE_NAME','ASO_SHIPMENTS', FALSE);
936:
937: UPDATE ASO_SHIPMENTS SET
938: ship_to_party_id = DECODE(ship_to_party_id,p_from_fk_id,p_to_fk_id,ship_to_party_id),
939: ship_to_cust_party_id = DECODE(ship_to_cust_party_id,p_from_fk_id,p_to_fk_id,ship_to_cust_party_id),

Line 937: UPDATE ASO_SHIPMENTS SET

933:
934: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
935: arp_message.set_token('TABLE_NAME','ASO_SHIPMENTS', FALSE);
936:
937: UPDATE ASO_SHIPMENTS SET
938: ship_to_party_id = DECODE(ship_to_party_id,p_from_fk_id,p_to_fk_id,ship_to_party_id),
939: ship_to_cust_party_id = DECODE(ship_to_cust_party_id,p_from_fk_id,p_to_fk_id,ship_to_cust_party_id),
940: last_update_date = hz_utility_pub.last_update_date,
941: last_updated_by = hz_utility_pub.user_id,

Line 960: arp_message.set_token('TABLE_NAME','ASO_SHIPMENTS', FALSE);

956:
957: Elsif p_parent_entity_name = 'HZ_PARTY_SITES' Then
958:
959: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
960: arp_message.set_token('TABLE_NAME','ASO_SHIPMENTS', FALSE);
961:
962: UPDATE ASO_SHIPMENTS SET
963: ship_to_party_site_id = p_to_fk_id,
964: last_update_date = hz_utility_pub.last_update_date,

Line 962: UPDATE ASO_SHIPMENTS SET

958:
959: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
960: arp_message.set_token('TABLE_NAME','ASO_SHIPMENTS', FALSE);
961:
962: UPDATE ASO_SHIPMENTS SET
963: ship_to_party_site_id = p_to_fk_id,
964: last_update_date = hz_utility_pub.last_update_date,
965: last_updated_by = hz_utility_pub.user_id,
966: last_update_login = hz_utility_pub.last_update_login,

Line 989: 'on table ASO_SHIPMENTS');

985:
986: Exception
987: When RESOURCE_BUSY Then
988: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS; Could not obtain lock'||
989: 'on table ASO_SHIPMENTS');
990:
991: x_return_status := FND_API.G_RET_STS_ERROR;
992: raise;
993: When Others Then