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 378: | Account merge procedure for the table, IBE_ACTIVE_QUOTES_ALL

Line 393: IBE_ACTIVE_QUOTES_ALL.ACTIVE_QUOTE_ID%TYPE

389: INDEX BY BINARY_INTEGER;
390: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
391:
392: TYPE ACTIVE_QUOTE_ID_LIST_TYPE IS TABLE OF
393: IBE_ACTIVE_QUOTES_ALL.ACTIVE_QUOTE_ID%TYPE
394: INDEX BY BINARY_INTEGER;
395: PRIMARY_KEY_ID_LIST ACTIVE_QUOTE_ID_LIST_TYPE;
396:
397: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 398: IBE_ACTIVE_QUOTES_ALL.CUST_ACCOUNT_ID%TYPE

394: INDEX BY BINARY_INTEGER;
395: PRIMARY_KEY_ID_LIST ACTIVE_QUOTE_ID_LIST_TYPE;
396:
397: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
398: IBE_ACTIVE_QUOTES_ALL.CUST_ACCOUNT_ID%TYPE
399: INDEX BY BINARY_INTEGER;
400: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
401: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
402:

Line 404: IBE_ACTIVE_QUOTES_ALL.PARTY_ID%TYPE

400: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
401: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
402:
403: TYPE PARTY_ID_LIST_TYPE IS TABLE OF
404: IBE_ACTIVE_QUOTES_ALL.PARTY_ID%TYPE
405: INDEX BY BINARY_INTEGER;
406: NUM_COL2_ORIG_LIST PARTY_ID_LIST_TYPE;
407: NUM_COL2_NEW_LIST PARTY_ID_LIST_TYPE;
408:

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

416:
417: --cursor to get account and party IDs, quote name and quote_header_id
418: Cursor C_ACTIVE_QUOTE_FROM is
419: Select a.quote_header_id, a.cust_account_id, a.party_id, b.quote_name, racm.customer_merge_id
420: from IBE_ACTIVE_QUOTES_ALL a, ASO_QUOTE_HEADERS_ALL b, RA_CUSTOMER_MERGES RACM
421: Where a.quote_header_id = b.quote_header_id (+)
422: and a.party_id = b.party_id (+)
423: and a.cust_account_id = b.cust_account_id (+)
424: and a.cust_account_id = racm.duplicate_id

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

470: insert into HZ_CUSTOMER_MERGE_LOG (MERGE_LOG_ID, TABLE_NAME,
471: MERGE_HEADER_ID,request_id,PRIMARY_KEY_ID,DEL_COL1,DEL_COL2,DEL_COL3,
472: DEL_COL4,DEL_COL5,DEL_COL6,DEL_COL7,DEL_COL8,DEL_COL9,DEL_COL10,DEL_COL11,ACTION_FLAG,
473: CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY)
474: select HZ_CUSTOMER_MERGE_LOG_s.nextval,'IBE_ACTIVE_QUOTES_ALL',l_customer_merge_id
475: ,req_id,ACTIVE_QUOTE_ID,PARTY_ID,CUST_ACCOUNT_ID,ORG_ID,CREATED_BY,CREATION_DATE
476: ,LAST_UPDATED_BY,LAST_UPDATE_DATE,OBJECT_VERSION_NUMBER,LAST_UPDATE_LOGIN
477: ,SECURITY_GROUP_ID,QUOTE_HEADER_ID,'D',hz_utility_pub.CREATED_BY,hz_utility_pub.CREATION_DATE,
478: hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,hz_utility_pub.LAST_UPDATED_BY

Line 479: from ibe_active_quotes_all where quote_header_id=l_from_quote_id

475: ,req_id,ACTIVE_QUOTE_ID,PARTY_ID,CUST_ACCOUNT_ID,ORG_ID,CREATED_BY,CREATION_DATE
476: ,LAST_UPDATED_BY,LAST_UPDATE_DATE,OBJECT_VERSION_NUMBER,LAST_UPDATE_LOGIN
477: ,SECURITY_GROUP_ID,QUOTE_HEADER_ID,'D',hz_utility_pub.CREATED_BY,hz_utility_pub.CREATION_DATE,
478: hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,hz_utility_pub.LAST_UPDATED_BY
479: from ibe_active_quotes_all where quote_header_id=l_from_quote_id
480: and cust_account_id = l_from_acct_id and party_id=l_from_party_id;
481:
482: end if;
483: --delete active quote row for

Line 484: delete ibe_active_quotes_all

480: and cust_account_id = l_from_acct_id and party_id=l_from_party_id;
481:
482: end if;
483: --delete active quote row for
484: delete ibe_active_quotes_all
485: where quote_header_id = l_from_quote_id
486: and cust_account_id = l_from_acct_id
487: and party_id=l_from_party_id;
488: End;

Line 773: SELECT 'X' from IBE_ACTIVE_QUOTES_ALL IAQ

769: AND RACM.SET_NUMBER = set_number)
770: FOR UPDATE NOWAIT;
771:
772: CURSOR C3 is
773: SELECT 'X' from IBE_ACTIVE_QUOTES_ALL IAQ
774: WHERE IAQ.CUST_ACCOUNT_ID IN (SELECT RACM.DUPLICATE_ID
775: FROM RA_CUSTOMER_MERGES RACM
776: WHERE RACM.PROCESS_FLAG='N'
777: AND RACM.REQUEST_ID = Request_id

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

869: 12/18/02
870: */
871: acc_merge_active_quotes(request_id,set_number,process_mode);
872: arp_message.set_name('AR','AR_UPDATING_TABLE');
873: arp_message.set_token('TABLE_NAME','IBE_ACTIVE_QUOTES_ALL',FALSE);
874: arp_message.set_name('AR','AR_ROWS_UPDATED');
875: arp_message.set_token('NUM_ROWS',to_char(g_count));
876:
877:

Line 1586: | This procedure will update IBE_ACTIVE_QUOTES_ALL table |

1582: | MERGE_ACTIVE_QUOTE -- |
1583: | When in ERP Parties are merged the |
1584: | The Foriegn keys to party_id and other columns |
1585: | should also be updated in iStore tables. |
1586: | This procedure will update IBE_ACTIVE_QUOTES_ALL table |
1587: | and will be called from party Merge concurrent program. |
1588: | DESCRIPTION |
1589: | |
1590: | REQUIRES |

Line 1628: from IBE_ACTIVE_QUOTES_ALL a, ASO_QUOTE_HEADERS_ALL b

1624: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1625:
1626: Cursor MERGE_FROM_ACTIVE is
1627: Select a.quote_header_id, a.cust_account_id, b.quote_name
1628: from IBE_ACTIVE_QUOTES_ALL a, ASO_QUOTE_HEADERS_ALL b
1629: Where a.quote_header_id = b.quote_header_id (+) and a.party_id = b.party_id (+)
1630: and a.cust_account_id=b.cust_account_id (+) and a.party_id=P_from_fk_id
1631: for update nowait;
1632:

Line 1663: delete ibe_active_quotes_all

1659: set QUOTE_NAME = 'IBE_PRMT_SC_DEFAULTNAMED'
1660: where quote_header_id = l_quote_header_id
1661: AND quote_name = 'IBE_PRMT_SC_UNNAMED';
1662:
1663: delete ibe_active_quotes_all
1664: where quote_header_id = l_quote_header_id
1665: and cust_account_id = l_cust_account_id
1666: and party_id=P_from_fk_id;
1667: /* Exception

Line 1688: 'on table IBE_ACTIVE_QUOTES_ALL');

1684:
1685: Exception
1686: When RESOURCE_BUSY Then
1687: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE; Could not obtain lock'||
1688: 'on table IBE_ACTIVE_QUOTES_ALL');
1689: x_return_status := FND_API.G_RET_STS_ERROR;
1690: raise;
1691: When Others Then
1692: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE'||sqlerrm);