APPS.ASO_MERGE_PVT dependencies on ASO_QUOTE_LINES_ALL

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

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

Line 741: | This procedure will update ASO_QUOTE_LINES_ALL table |

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

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

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

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

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

Line 830: UPDATE ASO_QUOTE_LINES_ALL SET

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

Line 859: 'on table ASO_QUOTE_LINES_ALL');

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