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_QUOTE_LINES

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 268: ASO_QUOTE_LINES.QUOTE_LINE_ID%TYPE

264: INDEX BY BINARY_INTEGER;
265: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
266:
267: TYPE QUOTE_LINE_ID_LIST_TYPE IS TABLE OF
268: ASO_QUOTE_LINES.QUOTE_LINE_ID%TYPE
269: INDEX BY BINARY_INTEGER;
270: PRIMARY_KEY_ID_LIST QUOTE_LINE_ID_LIST_TYPE;
271:
272: TYPE INV_TO_CUST_ACCT_ID_LIST_TYPE IS TABLE OF

Line 273: ASO_QUOTE_LINES.INVOICE_TO_CUST_ACCOUNT_ID%TYPE

269: INDEX BY BINARY_INTEGER;
270: PRIMARY_KEY_ID_LIST QUOTE_LINE_ID_LIST_TYPE;
271:
272: TYPE INV_TO_CUST_ACCT_ID_LIST_TYPE IS TABLE OF
273: ASO_QUOTE_LINES.INVOICE_TO_CUST_ACCOUNT_ID%TYPE
274: INDEX BY BINARY_INTEGER;
275: NUM_COL1_ORIG_LIST INV_TO_CUST_ACCT_ID_LIST_TYPE;
276: NUM_COL1_NEW_LIST INV_TO_CUST_ACCT_ID_LIST_TYPE;
277:

Line 279: ASO_QUOTE_LINES.END_CUSTOMER_CUST_ACCOUNT_ID%TYPE

275: NUM_COL1_ORIG_LIST INV_TO_CUST_ACCT_ID_LIST_TYPE;
276: NUM_COL1_NEW_LIST INV_TO_CUST_ACCT_ID_LIST_TYPE;
277:
278: TYPE END_CUST_ACCT_ID_LIST_TYPE IS TABLE OF
279: ASO_QUOTE_LINES.END_CUSTOMER_CUST_ACCOUNT_ID%TYPE
280: INDEX BY BINARY_INTEGER;
281: NUM_COL2_ORIG_LIST END_CUST_ACCT_ID_LIST_TYPE;
282: NUM_COL2_NEW_LIST END_CUST_ACCT_ID_LIST_TYPE;
283:

Line 291: FROM ASO_QUOTE_LINES yt, ra_customer_merges m

287: SELECT distinct CUSTOMER_MERGE_HEADER_ID
288: ,QUOTE_LINE_ID
289: ,INVOICE_TO_CUST_ACCOUNT_ID
290: ,END_CUSTOMER_CUST_ACCOUNT_ID
291: FROM ASO_QUOTE_LINES yt, ra_customer_merges m
292: WHERE (
293: yt.INVOICE_TO_CUST_ACCOUNT_ID = m.DUPLICATE_ID
294: OR yt.END_CUSTOMER_CUST_ACCOUNT_ID = m.DUPLICATE_ID
295: ) AND m.process_flag = 'N'

Line 309: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ASO_QUOTE_LINES',FALSE);

305: NULL;
306: ELSE
307:
308: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
309: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ASO_QUOTE_LINES',FALSE);
310: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
311: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
312:
313: open merged_records;

Line 356: 'ASO_QUOTE_LINES',

352: LAST_UPDATE_LOGIN,
353: LAST_UPDATE_DATE,
354: LAST_UPDATED_BY
355: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
356: 'ASO_QUOTE_LINES',
357: MERGE_HEADER_ID_LIST(I),
358: PRIMARY_KEY_ID_LIST(I),
359: NUM_COL1_ORIG_LIST(I),
360: NUM_COL1_NEW_LIST(I),

Line 375: UPDATE ASO_QUOTE_LINES yt SET

371:
372: END IF;
373:
374: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
375: UPDATE ASO_QUOTE_LINES yt SET
376: INVOICE_TO_CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
377: , END_CUSTOMER_CUST_ACCOUNT_ID=NUM_COL2_NEW_LIST(I)
378: , LAST_UPDATE_DATE=SYSDATE
379: , last_updated_by=arp_standard.profile.user_id

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