DBA Data[Home] [Help]

APPS.ASO_MERGE_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 240: | This is a private procedure to update ASO_QUOTE_LINES_ALL |

236: /*----------------------------------------------------------------------------*
237: | PRIVATE PROCEDURE |
238: | UPDATE_QUOTE_LINES |
239: | DESCRIPTION |
240: | This is a private procedure to update ASO_QUOTE_LINES_ALL |
241: | table with merged to cust account id. When two cust accounts |
242: | are merged. |
243: | REQUIRES |
244: | |

Line 742: | This procedure will update ASO_QUOTE_LINES_ALL table |

738: | MERGE_QUOTE_LINES -- |
739: | When in ERP Parties are merged the |
740: | The Foriegn keys to party_id and other columns |
741: | should also be updated in iStore tables. |
742: | This procedure will update ASO_QUOTE_LINES_ALL table |
743: | and will be called from party Merge concurrent program. |
744: | DESCRIPTION |
745: | |
746: | REQUIRES |

Line 801: arp_message.set_token('TABLE_NAME','ASO_QUOTE_LINES_ALL', FALSE);

797:
798: If p_parent_entity_name = 'HZ_PARTIES' Then
799:
800: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
801: arp_message.set_token('TABLE_NAME','ASO_QUOTE_LINES_ALL', FALSE);
802:
803: UPDATE ASO_QUOTE_LINES_ALL SET
804: invoice_to_party_id = DECODE(invoice_to_party_id,p_from_fk_id,p_to_fk_id,invoice_to_party_id),
805: 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 803: UPDATE ASO_QUOTE_LINES_ALL SET

799:
800: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
801: arp_message.set_token('TABLE_NAME','ASO_QUOTE_LINES_ALL', FALSE);
802:
803: UPDATE ASO_QUOTE_LINES_ALL SET
804: invoice_to_party_id = DECODE(invoice_to_party_id,p_from_fk_id,p_to_fk_id,invoice_to_party_id),
805: invoice_to_cust_party_id = DECODE(invoice_to_cust_party_id,p_from_fk_id,p_to_fk_id,invoice_to_cust_party_id),
806: End_Customer_party_id = DECODE(End_Customer_party_id,p_from_fk_id,p_to_fk_id,End_Customer_party_id),
807: End_Customer_cust_party_id = DECODE(End_Customer_cust_party_id,p_from_fk_id,p_to_fk_id,End_Customer_cust_party_id),

Line 829: arp_message.set_token('TABLE_NAME','ASO_QUOTE_LINES_ALL', FALSE);

825:
826: Elsif p_parent_entity_name = 'HZ_PARTY_SITES' Then
827:
828: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
829: arp_message.set_token('TABLE_NAME','ASO_QUOTE_LINES_ALL', FALSE);
830:
831: UPDATE ASO_QUOTE_LINES_ALL SET
832: invoice_to_party_site_id = p_to_fk_id,
833: End_Customer_party_site_id = p_to_fk_id,

Line 831: UPDATE ASO_QUOTE_LINES_ALL SET

827:
828: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
829: arp_message.set_token('TABLE_NAME','ASO_QUOTE_LINES_ALL', FALSE);
830:
831: UPDATE ASO_QUOTE_LINES_ALL SET
832: invoice_to_party_site_id = p_to_fk_id,
833: End_Customer_party_site_id = p_to_fk_id,
834: last_update_date = hz_utility_pub.last_update_date,
835: last_updated_by = hz_utility_pub.user_id,

Line 860: 'on table ASO_QUOTE_LINES_ALL');

856:
857: Exception
858: When RESOURCE_BUSY Then
859: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES; Could not obtain lock'||
860: 'on table ASO_QUOTE_LINES_ALL');
861:
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: raise;
864: When Others Then