APPS.ASO_MERGE_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 578: | This procedure will update ASO_QUOTE_HEADERS_ALL table |

574: | MERGE_QUOTE_HEADERS -- |
575: | When in ERP Parties are merged the |
576: | The Foriegn keys to party_id and other columns |
577: | should also be updated in iStore tables. |
578: | This procedure will update ASO_QUOTE_HEADERS_ALL table |
579: | and will be called from party Merge concurrent program. |
580: | DESCRIPTION |
581: | |
582: | REQUIRES |

Line 637: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);

633:
634: IF p_parent_entity_name = 'HZ_PARTIES' Then
635:
636: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
637: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);
638:
639: UPDATE ASO_QUOTE_HEADERS_ALL SET
640: party_id = DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id),
641: invoice_to_party_id = DECODE(invoice_to_party_id,p_from_fk_id,p_to_fk_id,invoice_to_party_id),

Line 639: UPDATE ASO_QUOTE_HEADERS_ALL SET

635:
636: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
637: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);
638:
639: UPDATE ASO_QUOTE_HEADERS_ALL SET
640: party_id = DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id),
641: invoice_to_party_id = DECODE(invoice_to_party_id,p_from_fk_id,p_to_fk_id,invoice_to_party_id),
642: cust_party_id = DECODE(cust_party_id,p_from_fk_id,p_to_fk_id,cust_party_id),
643: invoice_to_cust_party_id = DECODE(invoice_to_cust_party_id,p_from_fk_id,p_to_fk_id,invoice_to_cust_party_id),

Line 668: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);

664:
665: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN
666:
667: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
668: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);
669:
670: UPDATE ASO_QUOTE_HEADERS_ALL SET
671: invoice_to_party_site_id = DECODE(invoice_to_party_site_id,p_from_fk_id,p_to_fk_id,invoice_to_party_site_id),
672: End_Customer_party_site_id = DECODE(End_Customer_party_site_id,p_from_fk_id,p_to_fk_id,End_Customer_party_site_id),

Line 670: UPDATE ASO_QUOTE_HEADERS_ALL SET

666:
667: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
668: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);
669:
670: UPDATE ASO_QUOTE_HEADERS_ALL SET
671: invoice_to_party_site_id = DECODE(invoice_to_party_site_id,p_from_fk_id,p_to_fk_id,invoice_to_party_site_id),
672: End_Customer_party_site_id = DECODE(End_Customer_party_site_id,p_from_fk_id,p_to_fk_id,End_Customer_party_site_id),
673: sold_to_party_site_id = DECODE(sold_to_party_site_id,p_from_fk_id,p_to_fk_id,sold_to_party_site_id),
674: last_update_date = hz_utility_pub.last_update_date,

Line 695: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);

691:
692: ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN
693:
694: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
695: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);
696:
697: UPDATE ASO_QUOTE_HEADERS_ALL SET
698: org_contact_id = p_to_fk_id,
699: last_update_date = hz_utility_pub.last_update_date,

Line 697: UPDATE ASO_QUOTE_HEADERS_ALL SET

693:
694: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
695: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);
696:
697: UPDATE ASO_QUOTE_HEADERS_ALL SET
698: org_contact_id = p_to_fk_id,
699: last_update_date = hz_utility_pub.last_update_date,
700: last_updated_by = hz_utility_pub.user_id,
701: last_update_login = hz_utility_pub.last_update_login,

Line 725: 'on table ASO_QUOTE_HEADERS_ALL');

721:
722: Exception
723: When RESOURCE_BUSY Then
724: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS; Could not obtain lock'||
725: 'on table ASO_QUOTE_HEADERS_ALL');
726:
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: raise;
729: When Others Then