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_SH_QUOTE_ACCESS

Line 507: | Account merge procedure for the table, IBE_SH_QUOTE_ACCESS

Line 523: IBE_SH_QUOTE_ACCESS.QUOTE_SHAREE_ID%TYPE

519: INDEX BY BINARY_INTEGER;
520: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
521:
522: TYPE QUOTE_SHAREE_ID_LIST_TYPE IS TABLE OF
523: IBE_SH_QUOTE_ACCESS.QUOTE_SHAREE_ID%TYPE
524: INDEX BY BINARY_INTEGER;
525: PRIMARY_KEY_ID_LIST QUOTE_SHAREE_ID_LIST_TYPE;
526:
527: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 528: IBE_SH_QUOTE_ACCESS.CUST_ACCOUNT_ID%TYPE

524: INDEX BY BINARY_INTEGER;
525: PRIMARY_KEY_ID_LIST QUOTE_SHAREE_ID_LIST_TYPE;
526:
527: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
528: IBE_SH_QUOTE_ACCESS.CUST_ACCOUNT_ID%TYPE
529: INDEX BY BINARY_INTEGER;
530: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
531: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
532:

Line 534: IBE_SH_QUOTE_ACCESS.PARTY_ID%TYPE

530: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
531: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
532:
533: TYPE PARTY_ID_LIST_TYPE IS TABLE OF
534: IBE_SH_QUOTE_ACCESS.PARTY_ID%TYPE
535: INDEX BY BINARY_INTEGER;
536: NUM_COL2_ORIG_LIST PARTY_ID_LIST_TYPE;
537: NUM_COL2_NEW_LIST PARTY_ID_LIST_TYPE;
538:

Line 573: from IBE_SH_QUOTE_ACCESS i, RA_CUSTOMER_MERGES RACM

569: /*retrive account shared carts*/
570: Cursor C_SHARED_QUOTE_FROM is
571: Select distinct customer_merge_header_id,quote_header_id,
572: i.party_id, RACM.DUPLICATE_ID, RACM.CUSTOMER_ID,quote_sharee_id
573: from IBE_SH_QUOTE_ACCESS i, RA_CUSTOMER_MERGES RACM
574: Where i.cust_account_id = RACM.DUPLICATE_ID
575: AND RACM.PROCESS_FLAG='N'
576: AND RACM.REQUEST_ID = req_id
577: AND RACM.SET_NUMBER = set_num;

Line 587: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);

583: IF process_mode='LOCK' THEN
584: NULL;
585: ELSE
586: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
587: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
588: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
589: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
590:
591: --retrieve shared carts

Line 610: From IBE_SH_QUOTE_ACCESS

606: l_program_update_date,l_object_version_number,l_created_by,l_creation_date,
607: l_last_updated_by,l_last_update_date,l_last_update_login,l_quote_header_id,
608: l_quote_sharee_number,l_update_privilege_type_code,l_security_group_id,l_party_id,
609: l_cust_account_id,l_start_date_active,l_end_date_active,l_recipient_name,l_contact_point_id
610: From IBE_SH_QUOTE_ACCESS
611: Where quote_header_id = l_from_quote_id
612: and cust_account_id = l_to_acct_id
613: --if multiple rows exist for with same quote header ID and account ID
614: and rownum=1

Line 628: delete IBE_SH_QUOTE_ACCESS

624: --debug: need TCA profile for test
625: --actual delete
626: if l_delete_flag then
627:
628: delete IBE_SH_QUOTE_ACCESS
629: where quote_header_id = l_from_quote_id
630: and cust_account_id = l_from_acct_id;
631: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
632: insert into HZ_CUSTOMER_MERGE_LOG (

Line 640: HZ_CUSTOMER_MERGE_LOG_s.nextval,'IBE_SH_QUOTE_ACCESS',l_customer_merge_header_id,

636: DEL_COL16,DEL_COL17,DEL_COL18,DEL_COL19,DEL_COL20,ACTION_FLAG,
637: REQUEST_ID,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
638: LAST_UPDATED_BY)
639: values(
640: HZ_CUSTOMER_MERGE_LOG_s.nextval,'IBE_SH_QUOTE_ACCESS',l_customer_merge_header_id,
641: l_from_quote_sharee_id,l_request_id,l_program_application_id,l_program_id,
642: l_program_update_date,l_object_version_number,l_created_by,l_creation_date,
643: l_last_updated_by,l_last_update_date,l_last_update_login,l_quote_header_id,
644: l_quote_sharee_number,l_update_privilege_type_code,l_security_group_id,l_party_id,

Line 653: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);

649: end if;
650: else
651: --if shared cart not a duplicate of , update party/account ID to merge to
652: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
653: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
654: --fix for 2940366
655: if customer_type = 'CUSTOMER_ORG' then
656: --B2B, partyID stays the same
657: l_to_party_id := l_from_party_id;

Line 671: 'IBE_SH_QUOTE_ACCESS',l_customer_merge_header_id,l_from_quote_sharee_id,l_from_acct_id,

667: NUM_COL2_ORIG,NUM_COL2_NEW,ACTION_FLAG,REQUEST_ID,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
668: LAST_UPDATE_DATE,LAST_UPDATED_BY
669: ) VALUES (
670: HZ_CUSTOMER_MERGE_LOG_s.nextval,
671: 'IBE_SH_QUOTE_ACCESS',l_customer_merge_header_id,l_from_quote_sharee_id,l_from_acct_id,
672: l_to_acct_id, l_from_party_id, l_to_party_id,'U',req_id,hz_utility_pub.CREATED_BY,
673: hz_utility_pub.CREATION_DATE,hz_utility_pub.LAST_UPDATE_LOGIN,hz_utility_pub.LAST_UPDATE_DATE,
674: hz_utility_pub.LAST_UPDATED_BY
675: );

Line 679: UPDATE IBE_SH_QUOTE_ACCESS ISQ SET

675: );
676: end if;
677: --update shared cart
678:
679: UPDATE IBE_SH_QUOTE_ACCESS ISQ SET
680: party_id = l_to_party_id,
681: cust_account_id = l_to_acct_id,
682: last_update_date = hz_utility_pub.last_update_date,
683: last_updated_by = hz_utility_pub.user_id,

Line 764: SELECT 'X' from IBE_SH_QUOTE_ACCESS ISQ

760: AND RACM.SET_NUMBER = set_number)
761: FOR UPDATE NOWAIT;
762:
763: CURSOR C2 is
764: SELECT 'X' from IBE_SH_QUOTE_ACCESS ISQ
765: WHERE ISQ.CUST_ACCOUNT_ID IN (SELECT RACM.DUPLICATE_ID
766: FROM RA_CUSTOMER_MERGES RACM
767: WHERE RACM.PROCESS_FLAG='N'
768: AND RACM.REQUEST_ID = request_id

Line 830: arp_message.set_token('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);

826: open C1;
827: close C1;
828:
829: arp_message.set_name('AR','AR_LOCKING_TABLE');
830: arp_message.set_token('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
831:
832: open C2;
833: close C2;
834:

Line 863: arp_message.set_token('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);

859: */
860: --2940366
861: acc_merge_shared_quote(request_id,set_number,process_mode,p_customer_type);
862: arp_message.set_name('AR','AR_UPDATING_TABLE');
863: arp_message.set_token('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
864: arp_message.set_name('AR','AR_ROWS_UPDATED');
865: arp_message.set_token('NUM_ROWS',to_char(g_count));
866:
867:

Line 1449: IBE_SH_QUOTE_ACCESS

1445:
1446: l_dummy VARCHAR2(1);
1447: Cursor MERGE_FROM_SH is
1448: Select quote_header_id, cust_account_id from
1449: IBE_SH_QUOTE_ACCESS
1450: Where party_id = p_from_fk_id
1451: for update nowait;
1452:
1453:

Line 1490: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);

1486:
1487:
1488: if p_from_fk_id <> p_to_fk_id Then
1489: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1490: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
1491: open find_account(p_to_fk_id);
1492: fetch find_account into l_to_cust_account_id ;
1493: if p_parent_entity_name = 'HZ_PARTIES' Then
1494: Open MERGE_FROM_SH;

Line 1500: From IBE_SH_QUOTE_ACCESS

1496: Fetch MERGE_FROM_SH into l_quote_header_id, l_from_cust_account_id;
1497: EXIT When merge_from_sh%NOTFOUND;
1498: Begin
1499: Select party_id into l_party_id
1500: From IBE_SH_QUOTE_ACCESS
1501: Where party_id = p_to_fk_id
1502: and cust_account_id = l_to_cust_account_id
1503: And quote_header_id = l_quote_header_id;
1504: -- delete/end_date since it's a duplicate row in quotes table

Line 1506: delete IBE_SH_QUOTE_ACCESS

1502: and cust_account_id = l_to_cust_account_id
1503: And quote_header_id = l_quote_header_id;
1504: -- delete/end_date since it's a duplicate row in quotes table
1505:
1506: delete IBE_SH_QUOTE_ACCESS
1507: where quote_header_id = l_quote_header_id
1508: and party_id = p_from_fk_id
1509: and cust_account_id = l_from_cust_account_id;
1510: Exception

Line 1514: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);

1510: Exception
1511: --update party ID to merge to if not a duplicate for merge to party
1512: When NO_DATA_FOUND Then
1513: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1514: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
1515:
1516: UPDATE IBE_SH_QUOTE_ACCESS SET
1517: party_id = p_to_fk_id,
1518: last_update_date = hz_utility_pub.last_update_date,

Line 1516: UPDATE IBE_SH_QUOTE_ACCESS SET

1512: When NO_DATA_FOUND Then
1513: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1514: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
1515:
1516: UPDATE IBE_SH_QUOTE_ACCESS SET
1517: party_id = p_to_fk_id,
1518: last_update_date = hz_utility_pub.last_update_date,
1519: last_updated_by = hz_utility_pub.user_id,
1520: last_update_login = hz_utility_pub.last_update_login,

Line 1538: where contact_point_id=p_from_fk_id and owner_table_name<>'IBE_SH_QUOTE_ACCESS';

1534: BEGIN
1535: select 1
1536: into l_dummy
1537: from hz_contact_points
1538: where contact_point_id=p_from_fk_id and owner_table_name<>'IBE_SH_QUOTE_ACCESS';
1539: UPDATE IBE_SH_QUOTE_ACCESS SET
1540: contact_point_id = p_to_fk_id,
1541: last_update_date = hz_utility_pub.last_update_date,
1542: last_updated_by = hz_utility_pub.user_id,

Line 1539: UPDATE IBE_SH_QUOTE_ACCESS SET

1535: select 1
1536: into l_dummy
1537: from hz_contact_points
1538: where contact_point_id=p_from_fk_id and owner_table_name<>'IBE_SH_QUOTE_ACCESS';
1539: UPDATE IBE_SH_QUOTE_ACCESS SET
1540: contact_point_id = p_to_fk_id,
1541: last_update_date = hz_utility_pub.last_update_date,
1542: last_updated_by = hz_utility_pub.user_id,
1543: last_update_login = hz_utility_pub.last_update_login,

Line 1571: 'on table IBE_SH_QUOTE_ACCESS');

1567:
1568: Exception
1569: When RESOURCE_BUSY Then
1570: arp_message.set_line('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS; Could not obtain lock'||
1571: 'on table IBE_SH_QUOTE_ACCESS');
1572: x_return_status := FND_API.G_RET_STS_ERROR;
1573: raise;
1574: When Others Then
1575: arp_message.set_line('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS'||sqlerrm);