APPS.ASO_MERGE_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 579: | This procedure will update ASO_QUOTE_HEADERS_ALL table |

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

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

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

Line 640: UPDATE ASO_QUOTE_HEADERS_ALL SET

636:
637: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
638: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);
639:
640: UPDATE ASO_QUOTE_HEADERS_ALL SET
641: party_id = DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id),
642: invoice_to_party_id = DECODE(invoice_to_party_id,p_from_fk_id,p_to_fk_id,invoice_to_party_id),
643: cust_party_id = DECODE(cust_party_id,p_from_fk_id,p_to_fk_id,cust_party_id),
644: 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 669: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);

665:
666: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN
667:
668: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
669: arp_message.set_token('TABLE_NAME','ASO_QUOTE_HEADERS_ALL', FALSE);
670:
671: UPDATE ASO_QUOTE_HEADERS_ALL SET
672: invoice_to_party_site_id = DECODE(invoice_to_party_site_id,p_from_fk_id,p_to_fk_id,invoice_to_party_site_id),
673: 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 671: UPDATE ASO_QUOTE_HEADERS_ALL SET

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

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

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

Line 698: UPDATE ASO_QUOTE_HEADERS_ALL SET

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

Line 726: 'on table ASO_QUOTE_HEADERS_ALL');

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