eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_MERGE_PVT dependencies on ASO_SHIPMENTS

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

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

Line 446: ASO_SHIPMENTS.SHIPMENT_ID%TYPE

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

Line 451: ASO_SHIPMENTS.SHIP_TO_CUST_ACCOUNT_ID%TYPE

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

Line 462: FROM ASO_SHIPMENTS yt, ra_customer_merges m

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

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

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

Line 520: 'ASO_SHIPMENTS',

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

Line 538: UPDATE ASO_SHIPMENTS yt SET

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

Line 877: | This procedure will update ASO_SHIPMENTS table |

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

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

932:
933: If p_parent_entity_name = 'HZ_PARTIES' Then
934:
935: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
936: arp_message.set_token('TABLE_NAME','ASO_SHIPMENTS', FALSE);
937:
938: UPDATE ASO_SHIPMENTS SET
939: ship_to_party_id = DECODE(ship_to_party_id,p_from_fk_id,p_to_fk_id,ship_to_party_id),
940: 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 938: UPDATE ASO_SHIPMENTS SET

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

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

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

Line 963: UPDATE ASO_SHIPMENTS SET

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

Line 990: 'on table ASO_SHIPMENTS');

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