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.IBE_MERGE_PVT dependencies on IBE_ACTIVE_QUOTES_ALL

Line 365: | Account merge procedure for the table, IBE_ACTIVE_QUOTES_ALL

Line 380: IBE_ACTIVE_QUOTES_ALL.ACTIVE_QUOTE_ID%TYPE

376: INDEX BY BINARY_INTEGER;
377: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
378:
379: TYPE ACTIVE_QUOTE_ID_LIST_TYPE IS TABLE OF
380: IBE_ACTIVE_QUOTES_ALL.ACTIVE_QUOTE_ID%TYPE
381: INDEX BY BINARY_INTEGER;
382: PRIMARY_KEY_ID_LIST ACTIVE_QUOTE_ID_LIST_TYPE;
383:
384: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 385: IBE_ACTIVE_QUOTES_ALL.CUST_ACCOUNT_ID%TYPE

381: INDEX BY BINARY_INTEGER;
382: PRIMARY_KEY_ID_LIST ACTIVE_QUOTE_ID_LIST_TYPE;
383:
384: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
385: IBE_ACTIVE_QUOTES_ALL.CUST_ACCOUNT_ID%TYPE
386: INDEX BY BINARY_INTEGER;
387: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
388: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
389:

Line 391: IBE_ACTIVE_QUOTES_ALL.PARTY_ID%TYPE

387: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
388: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
389:
390: TYPE PARTY_ID_LIST_TYPE IS TABLE OF
391: IBE_ACTIVE_QUOTES_ALL.PARTY_ID%TYPE
392: INDEX BY BINARY_INTEGER;
393: NUM_COL2_ORIG_LIST PARTY_ID_LIST_TYPE;
394: NUM_COL2_NEW_LIST PARTY_ID_LIST_TYPE;
395:

Line 407: from IBE_ACTIVE_QUOTES_ALL a, ASO_QUOTE_HEADERS_ALL b, RA_CUSTOMER_MERGES RACM

403:
404: --cursor to get account and party IDs, quote name and quote_header_id
405: Cursor C_ACTIVE_QUOTE_FROM is
406: Select a.quote_header_id, a.cust_account_id, a.party_id, b.quote_name, racm.customer_merge_id
407: from IBE_ACTIVE_QUOTES_ALL a, ASO_QUOTE_HEADERS_ALL b, RA_CUSTOMER_MERGES RACM
408: Where a.quote_header_id = b.quote_header_id (+)
409: and a.party_id = b.party_id (+)
410: and a.cust_account_id = b.cust_account_id (+)
411: and a.cust_account_id = racm.duplicate_id

Line 461: select HZ_CUSTOMER_MERGE_LOG_s.nextval,'IBE_ACTIVE_QUOTES_ALL',l_customer_merge_id

457: insert into HZ_CUSTOMER_MERGE_LOG (MERGE_LOG_ID, TABLE_NAME,
458: MERGE_HEADER_ID,request_id,PRIMARY_KEY_ID,DEL_COL1,DEL_COL2,DEL_COL3,
459: DEL_COL4,DEL_COL5,DEL_COL6,DEL_COL7,DEL_COL8,DEL_COL9,DEL_COL10,DEL_COL11,ACTION_FLAG,
460: CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY)
461: select HZ_CUSTOMER_MERGE_LOG_s.nextval,'IBE_ACTIVE_QUOTES_ALL',l_customer_merge_id
462: ,req_id,ACTIVE_QUOTE_ID,PARTY_ID,CUST_ACCOUNT_ID,ORG_ID,CREATED_BY,CREATION_DATE
463: ,LAST_UPDATED_BY,LAST_UPDATE_DATE,OBJECT_VERSION_NUMBER,LAST_UPDATE_LOGIN
464: ,SECURITY_GROUP_ID,QUOTE_HEADER_ID,'D',hz_utility_pub.CREATED_BY,hz_utility_pub.CREATION_DATE,
465: hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,hz_utility_pub.LAST_UPDATED_BY

Line 466: from ibe_active_quotes_all where quote_header_id=l_from_quote_id

462: ,req_id,ACTIVE_QUOTE_ID,PARTY_ID,CUST_ACCOUNT_ID,ORG_ID,CREATED_BY,CREATION_DATE
463: ,LAST_UPDATED_BY,LAST_UPDATE_DATE,OBJECT_VERSION_NUMBER,LAST_UPDATE_LOGIN
464: ,SECURITY_GROUP_ID,QUOTE_HEADER_ID,'D',hz_utility_pub.CREATED_BY,hz_utility_pub.CREATION_DATE,
465: hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,hz_utility_pub.LAST_UPDATED_BY
466: from ibe_active_quotes_all where quote_header_id=l_from_quote_id
467: and cust_account_id = l_from_acct_id and party_id=l_from_party_id;
468:
469: end if;
470: --delete active quote row for

Line 471: delete ibe_active_quotes_all

467: and cust_account_id = l_from_acct_id and party_id=l_from_party_id;
468:
469: end if;
470: --delete active quote row for
471: delete ibe_active_quotes_all
472: where quote_header_id = l_from_quote_id
473: and cust_account_id = l_from_acct_id
474: and party_id=l_from_party_id;
475: End;

Line 824: arp_message.set_token('TABLE_NAME','IBE_ACTIVE_QUOTES_ALL',FALSE);

820: */
821: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE - updating active cart table');
822: acc_merge_active_quotes(request_id,set_number,process_mode);
823: arp_message.set_name('AR','AR_UPDATING_TABLE');
824: arp_message.set_token('TABLE_NAME','IBE_ACTIVE_QUOTES_ALL',FALSE);
825: arp_message.set_name('AR','AR_ROWS_UPDATED');
826: arp_message.set_token('NUM_ROWS',to_char(g_count));
827:
828:

Line 1555: | This procedure will update IBE_ACTIVE_QUOTES_ALL table |

1551: | MERGE_ACTIVE_QUOTE -- |
1552: | When in ERP Parties are merged the |
1553: | The Foriegn keys to party_id and other columns |
1554: | should also be updated in iStore tables. |
1555: | This procedure will update IBE_ACTIVE_QUOTES_ALL table |
1556: | and will be called from party Merge concurrent program. |
1557: | DESCRIPTION |
1558: | |
1559: | REQUIRES |

Line 1597: from IBE_ACTIVE_QUOTES_ALL a, ASO_QUOTE_HEADERS_ALL b

1593: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1594:
1595: Cursor MERGE_FROM_ACTIVE is
1596: Select a.quote_header_id, a.cust_account_id, b.quote_name
1597: from IBE_ACTIVE_QUOTES_ALL a, ASO_QUOTE_HEADERS_ALL b
1598: Where a.quote_header_id = b.quote_header_id (+) and a.party_id = b.party_id (+)
1599: and a.cust_account_id=b.cust_account_id (+) and a.party_id=P_from_fk_id
1600: for update nowait;
1601:

Line 1633: delete ibe_active_quotes_all

1629: set QUOTE_NAME = 'IBE_PRMT_SC_DEFAULTNAMED'
1630: where quote_header_id = l_quote_header_id
1631: AND quote_name = 'IBE_PRMT_SC_UNNAMED';
1632:
1633: delete ibe_active_quotes_all
1634: where quote_header_id = l_quote_header_id
1635: and cust_account_id = l_cust_account_id
1636: and party_id=P_from_fk_id;
1637: /* Exception

Line 1658: 'on table IBE_ACTIVE_QUOTES_ALL');

1654:
1655: Exception
1656: When RESOURCE_BUSY Then
1657: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE; Could not obtain lock'||
1658: 'on table IBE_ACTIVE_QUOTES_ALL');
1659: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE; Could not obtain lock'||
1660: 'on table IBE_ACTIVE_QUOTES_ALL');
1661: x_return_status := FND_API.G_RET_STS_ERROR;
1662: raise;

Line 1660: 'on table IBE_ACTIVE_QUOTES_ALL');

1656: When RESOURCE_BUSY Then
1657: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE; Could not obtain lock'||
1658: 'on table IBE_ACTIVE_QUOTES_ALL');
1659: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE; Could not obtain lock'||
1660: 'on table IBE_ACTIVE_QUOTES_ALL');
1661: x_return_status := FND_API.G_RET_STS_ERROR;
1662: raise;
1663: When Others Then
1664: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE'||sqlerrm);