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

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

Line 274: ASO_QUOTE_LINES.INVOICE_TO_CUST_ACCOUNT_ID%TYPE

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

Line 280: ASO_QUOTE_LINES.END_CUSTOMER_CUST_ACCOUNT_ID%TYPE

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

Line 292: FROM ASO_QUOTE_LINES yt, ra_customer_merges m

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

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

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

Line 357: 'ASO_QUOTE_LINES',

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

Line 376: UPDATE ASO_QUOTE_LINES yt SET

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

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