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

Line 511: IBE_SH_QUOTE_ACCESS.QUOTE_SHAREE_ID%TYPE

507: INDEX BY BINARY_INTEGER;
508: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
509:
510: TYPE QUOTE_SHAREE_ID_LIST_TYPE IS TABLE OF
511: IBE_SH_QUOTE_ACCESS.QUOTE_SHAREE_ID%TYPE
512: INDEX BY BINARY_INTEGER;
513: PRIMARY_KEY_ID_LIST QUOTE_SHAREE_ID_LIST_TYPE;
514:
515: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 516: IBE_SH_QUOTE_ACCESS.CUST_ACCOUNT_ID%TYPE

512: INDEX BY BINARY_INTEGER;
513: PRIMARY_KEY_ID_LIST QUOTE_SHAREE_ID_LIST_TYPE;
514:
515: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
516: IBE_SH_QUOTE_ACCESS.CUST_ACCOUNT_ID%TYPE
517: INDEX BY BINARY_INTEGER;
518: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
519: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
520:

Line 522: IBE_SH_QUOTE_ACCESS.PARTY_ID%TYPE

518: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
519: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
520:
521: TYPE PARTY_ID_LIST_TYPE IS TABLE OF
522: IBE_SH_QUOTE_ACCESS.PARTY_ID%TYPE
523: INDEX BY BINARY_INTEGER;
524: NUM_COL2_ORIG_LIST PARTY_ID_LIST_TYPE;
525: NUM_COL2_NEW_LIST PARTY_ID_LIST_TYPE;
526:

Line 561: from IBE_SH_QUOTE_ACCESS i, RA_CUSTOMER_MERGES RACM

557: /*retrive account shared carts*/
558: Cursor C_SHARED_QUOTE_FROM is
559: Select distinct customer_merge_header_id,quote_header_id,
560: i.party_id, RACM.DUPLICATE_ID, RACM.CUSTOMER_ID,quote_sharee_id
561: from IBE_SH_QUOTE_ACCESS i, RA_CUSTOMER_MERGES RACM
562: Where i.cust_account_id = RACM.DUPLICATE_ID
563: AND RACM.PROCESS_FLAG='N'
564: AND RACM.REQUEST_ID = req_id
565: AND RACM.SET_NUMBER = set_num;

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

571: IF process_mode='LOCK' THEN
572: NULL;
573: ELSE
574: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
575: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
576: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
577: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
578:
579: --retrieve shared carts

Line 598: From IBE_SH_QUOTE_ACCESS

594: l_program_update_date,l_object_version_number,l_created_by,l_creation_date,
595: l_last_updated_by,l_last_update_date,l_last_update_login,l_quote_header_id,
596: l_quote_sharee_number,l_update_privilege_type_code,l_security_group_id,l_party_id,
597: l_cust_account_id,l_start_date_active,l_end_date_active,l_recipient_name,l_contact_point_id
598: From IBE_SH_QUOTE_ACCESS
599: Where quote_header_id = l_from_quote_id
600: and cust_account_id = l_to_acct_id
601: --if multiple rows exist for with same quote header ID and account ID
602: and rownum=1

Line 616: delete IBE_SH_QUOTE_ACCESS

612: --debug: need TCA profile for test
613: --actual delete
614: if l_delete_flag then
615:
616: delete IBE_SH_QUOTE_ACCESS
617: where quote_header_id = l_from_quote_id
618: and cust_account_id = l_from_acct_id;
619: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
620: insert into HZ_CUSTOMER_MERGE_LOG (

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

624: DEL_COL16,DEL_COL17,DEL_COL18,DEL_COL19,DEL_COL20,ACTION_FLAG,
625: REQUEST_ID,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
626: LAST_UPDATED_BY)
627: values(
628: HZ_CUSTOMER_MERGE_LOG_s.nextval,'IBE_SH_QUOTE_ACCESS',l_customer_merge_header_id,
629: l_from_quote_sharee_id,l_request_id,l_program_application_id,l_program_id,
630: l_program_update_date,l_object_version_number,l_created_by,l_creation_date,
631: l_last_updated_by,l_last_update_date,l_last_update_login,l_quote_header_id,
632: l_quote_sharee_number,l_update_privilege_type_code,l_security_group_id,l_party_id,

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

637: end if;
638: else
639: --if shared cart not a duplicate of , update party/account ID to merge to
640: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
641: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
642: --fix for 2940366
643: if customer_type = 'CUSTOMER_ORG' then
644: --B2B, partyID stays the same
645: l_to_party_id := l_from_party_id;

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

655: NUM_COL2_ORIG,NUM_COL2_NEW,ACTION_FLAG,REQUEST_ID,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
656: LAST_UPDATE_DATE,LAST_UPDATED_BY
657: ) VALUES (
658: HZ_CUSTOMER_MERGE_LOG_s.nextval,
659: 'IBE_SH_QUOTE_ACCESS',l_customer_merge_header_id,l_from_quote_sharee_id,l_from_acct_id,
660: l_to_acct_id, l_from_party_id, l_to_party_id,'U',req_id,hz_utility_pub.CREATED_BY,
661: hz_utility_pub.CREATION_DATE,hz_utility_pub.LAST_UPDATE_LOGIN,hz_utility_pub.LAST_UPDATE_DATE,
662: hz_utility_pub.LAST_UPDATED_BY
663: );

Line 667: UPDATE IBE_SH_QUOTE_ACCESS ISQ SET

663: );
664: end if;
665: --update shared cart
666:
667: UPDATE IBE_SH_QUOTE_ACCESS ISQ SET
668: party_id = l_to_party_id,
669: cust_account_id = l_to_acct_id,
670: last_update_date = hz_utility_pub.last_update_date,
671: last_updated_by = hz_utility_pub.user_id,

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

809: --2940366
810: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE - updating shared quote table');
811: acc_merge_shared_quote(request_id,set_number,process_mode,p_customer_type);
812: arp_message.set_name('AR','AR_UPDATING_TABLE');
813: arp_message.set_token('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
814: arp_message.set_name('AR','AR_ROWS_UPDATED');
815: arp_message.set_token('NUM_ROWS',to_char(g_count));
816:
817:

Line 1414: IBE_SH_QUOTE_ACCESS

1410:
1411: l_dummy VARCHAR2(1);
1412: Cursor MERGE_FROM_SH is
1413: Select quote_header_id, cust_account_id from
1414: IBE_SH_QUOTE_ACCESS
1415: Where party_id = p_from_fk_id
1416: for update nowait;
1417:
1418:

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

1452:
1453:
1454: if p_from_fk_id <> p_to_fk_id Then
1455: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1456: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
1457: open find_account(p_to_fk_id);
1458: fetch find_account into l_to_cust_account_id ;
1459: if p_parent_entity_name = 'HZ_PARTIES' Then
1460: Open MERGE_FROM_SH;

Line 1466: From IBE_SH_QUOTE_ACCESS

1462: Fetch MERGE_FROM_SH into l_quote_header_id, l_from_cust_account_id;
1463: EXIT When merge_from_sh%NOTFOUND;
1464: Begin
1465: Select party_id into l_party_id
1466: From IBE_SH_QUOTE_ACCESS
1467: Where party_id = p_to_fk_id
1468: and cust_account_id = l_to_cust_account_id
1469: And quote_header_id = l_quote_header_id;
1470: -- delete/end_date since it's a duplicate row in quotes table

Line 1472: delete IBE_SH_QUOTE_ACCESS

1468: and cust_account_id = l_to_cust_account_id
1469: And quote_header_id = l_quote_header_id;
1470: -- delete/end_date since it's a duplicate row in quotes table
1471:
1472: delete IBE_SH_QUOTE_ACCESS
1473: where quote_header_id = l_quote_header_id
1474: and party_id = p_from_fk_id
1475: and cust_account_id = l_from_cust_account_id;
1476: Exception

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

1476: Exception
1477: --update party ID to merge to if not a duplicate for merge to party
1478: When NO_DATA_FOUND Then
1479: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1480: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
1481:
1482: UPDATE IBE_SH_QUOTE_ACCESS SET
1483: party_id = p_to_fk_id,
1484: last_update_date = hz_utility_pub.last_update_date,

Line 1482: UPDATE IBE_SH_QUOTE_ACCESS SET

1478: When NO_DATA_FOUND Then
1479: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1480: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
1481:
1482: UPDATE IBE_SH_QUOTE_ACCESS SET
1483: party_id = p_to_fk_id,
1484: last_update_date = hz_utility_pub.last_update_date,
1485: last_updated_by = hz_utility_pub.user_id,
1486: last_update_login = hz_utility_pub.last_update_login,

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

1500: BEGIN
1501: select 1
1502: into l_dummy
1503: from hz_contact_points
1504: where contact_point_id=p_from_fk_id and owner_table_name<>'IBE_SH_QUOTE_ACCESS';
1505: UPDATE IBE_SH_QUOTE_ACCESS SET
1506: contact_point_id = p_to_fk_id,
1507: last_update_date = hz_utility_pub.last_update_date,
1508: last_updated_by = hz_utility_pub.user_id,

Line 1505: UPDATE IBE_SH_QUOTE_ACCESS SET

1501: select 1
1502: into l_dummy
1503: from hz_contact_points
1504: where contact_point_id=p_from_fk_id and owner_table_name<>'IBE_SH_QUOTE_ACCESS';
1505: UPDATE IBE_SH_QUOTE_ACCESS SET
1506: contact_point_id = p_to_fk_id,
1507: last_update_date = hz_utility_pub.last_update_date,
1508: last_updated_by = hz_utility_pub.user_id,
1509: last_update_login = hz_utility_pub.last_update_login,

Line 1537: 'on table IBE_SH_QUOTE_ACCESS');

1533:
1534: Exception
1535: When RESOURCE_BUSY Then
1536: arp_message.set_line('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS; Could not obtain lock'||
1537: 'on table IBE_SH_QUOTE_ACCESS');
1538: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS; Could not obtain lock'||
1539: 'on table IBE_SH_QUOTE_ACCESS');
1540: x_return_status := FND_API.G_RET_STS_ERROR;
1541: raise;

Line 1539: 'on table IBE_SH_QUOTE_ACCESS');

1535: When RESOURCE_BUSY Then
1536: arp_message.set_line('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS; Could not obtain lock'||
1537: 'on table IBE_SH_QUOTE_ACCESS');
1538: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS; Could not obtain lock'||
1539: 'on table IBE_SH_QUOTE_ACCESS');
1540: x_return_status := FND_API.G_RET_STS_ERROR;
1541: raise;
1542: When Others Then
1543: arp_message.set_line('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS'||sqlerrm);