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_SHP_LISTS_ALL

Line 222: | Account merge procedure for the table, IBE_SH_SHP_LISTS_ALL

218: |
219: | PROCEDURE
220: | acc_merge_shp_lists
221: | DESCRIPTION :
222: | Account merge procedure for the table, IBE_SH_SHP_LISTS_ALL
223: |
224: |
225: |--------------------------------------------------------------*/
226: procedure acc_merge_shp_lists (

Line 239: IBE_SH_SHP_LISTS_ALL.SHP_LIST_ID%TYPE

235: INDEX BY BINARY_INTEGER;
236: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
237:
238: TYPE SHP_LIST_ID_LIST_TYPE IS TABLE OF
239: IBE_SH_SHP_LISTS_ALL.SHP_LIST_ID%TYPE
240: INDEX BY BINARY_INTEGER;
241: PRIMARY_KEY_ID_LIST SHP_LIST_ID_LIST_TYPE;
242:
243: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 244: IBE_SH_SHP_LISTS_ALL.CUST_ACCOUNT_ID%TYPE

240: INDEX BY BINARY_INTEGER;
241: PRIMARY_KEY_ID_LIST SHP_LIST_ID_LIST_TYPE;
242:
243: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
244: IBE_SH_SHP_LISTS_ALL.CUST_ACCOUNT_ID%TYPE
245: INDEX BY BINARY_INTEGER;
246: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
247: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
248:

Line 250: IBE_SH_SHP_LISTS_ALL.PARTY_ID%TYPE

246: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
247: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
248:
249: TYPE PARTY_ID_LIST_TYPE IS TABLE OF
250: IBE_SH_SHP_LISTS_ALL.PARTY_ID%TYPE
251: INDEX BY BINARY_INTEGER;
252: NUM_COL2_ORIG_LIST PARTY_ID_LIST_TYPE;
253: NUM_COL2_NEW_LIST PARTY_ID_LIST_TYPE;
254: l_acct_id number;

Line 263: FROM IBE_SH_SHP_LISTS_ALL yt, ra_customer_merges m

259: SELECT distinct CUSTOMER_MERGE_HEADER_ID
260: ,yt.SHP_LIST_ID
261: ,yt.CUST_ACCOUNT_ID
262: ,yt.party_id
263: FROM IBE_SH_SHP_LISTS_ALL yt, ra_customer_merges m
264: WHERE
265: yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
266: AND m.process_flag = 'N'
267: AND m.request_id = req_id

Line 305: UPDATE IBE_SH_SHP_LISTS_ALL yt SET

301: else
302: --B2C, partyID changes to what's tied to accountID
303: NUM_COL2_NEW_LIST(I) := find_party(NUM_COL1_NEW_LIST(I));
304: end if;
305: UPDATE IBE_SH_SHP_LISTS_ALL yt SET
306: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
307: ,PARTY_ID=NUM_COL2_NEW_LIST(I)
308: , LAST_UPDATE_DATE=SYSDATE
309: , last_updated_by=arp_standard.profile.user_id

Line 336: 'IBE_SH_SHP_LISTS_ALL',

332: LAST_UPDATE_LOGIN,
333: LAST_UPDATE_DATE,
334: LAST_UPDATED_BY
335: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
336: 'IBE_SH_SHP_LISTS_ALL',
337: MERGE_HEADER_ID_LIST(I),
338: PRIMARY_KEY_ID_LIST(I),
339: NUM_COL1_ORIG_LIST(I),
340: NUM_COL1_NEW_LIST(I),

Line 746: SELECT 'X' from IBE_SH_SHP_LISTS_ALL ISA

742: l_set_number NUMBER := set_number;
743: MERGE_NOT_ALLOWED EXCEPTION;
744:
745: CURSOR C is
746: SELECT 'X' from IBE_SH_SHP_LISTS_ALL ISA
747: WHERE ISA.CUST_ACCOUNT_ID IN (SELECT RACM.DUPLICATE_ID
748: FROM RA_CUSTOMER_MERGES RACM
749: WHERE RACM.PROCESS_FLAG='N'
750: AND RACM.REQUEST_ID = request_id

Line 818: arp_message.set_token('TABLE_NAME','IBE_SH_SHP_LISTS_ALL',FALSE);

814: /*
815: If process_mode = 'LOCK' then
816:
817: arp_message.set_name('AR','AR_LOCKING_TABLE');
818: arp_message.set_token('TABLE_NAME','IBE_SH_SHP_LISTS_ALL',FALSE);
819:
820: open C;
821: close C;
822:

Line 838: arp_message.set_token('TABLE_NAME','IBE_SH_SHP_LISTS_ALL',FALSE);

834:
835: End If; */
836:
837: arp_message.set_name('AR','AR_UPDATING_TABLE');
838: arp_message.set_token('TABLE_NAME','IBE_SH_SHP_LISTS_ALL',FALSE);
839:
840: /* For updating IBE_SH_SHP_LISTS_ALL table*/
841: --2940366
842: acc_merge_shp_lists(request_id,set_number,process_mode,p_customer_type);

Line 840: /* For updating IBE_SH_SHP_LISTS_ALL table*/

836:
837: arp_message.set_name('AR','AR_UPDATING_TABLE');
838: arp_message.set_token('TABLE_NAME','IBE_SH_SHP_LISTS_ALL',FALSE);
839:
840: /* For updating IBE_SH_SHP_LISTS_ALL table*/
841: --2940366
842: acc_merge_shp_lists(request_id,set_number,process_mode,p_customer_type);
843: g_count := sql%rowcount;
844: arp_message.set_name('AR','AR_ROWS_UPDATED');

Line 899: | This procedure will update IBE_SH_SHP_LISTS_ALL table |

895: | MERGE_SHP_LISTS -- |
896: | When in ERP Parties are merged the |
897: | The Foriegn keys to party_id and other columns |
898: | should also be updated in iStore tables. |
899: | This procedure will update IBE_SH_SHP_LISTS_ALL table |
900: | and will be called from party Merge concurrent program. |
901: | DESCRIPTION |
902: | |
903: | REQUIRES |

Line 932: IBE_SH_SHP_LISTS_ALL

928: IS
929:
930: Cursor C1 is
931: Select 'X' from
932: IBE_SH_SHP_LISTS_ALL
933: Where party_id = p_from_fk_id
934: for update nowait;
935:
936: l_merge_reason_code VARCHAR2(30);

Line 986: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);

982:
983: if p_from_fk_id <> p_to_fk_id Then
984:
985: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
986: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
987:
988: Open C1;
989: Close C1;
990:

Line 992: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);

988: Open C1;
989: Close C1;
990:
991: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
992: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
993:
994: UPDATE IBE_SH_SHP_LISTS_ALL isl SET
995: party_id = p_to_fk_id,
996: last_update_date = hz_utility_pub.last_update_date,

Line 994: UPDATE IBE_SH_SHP_LISTS_ALL isl SET

990:
991: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
992: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
993:
994: UPDATE IBE_SH_SHP_LISTS_ALL isl SET
995: party_id = p_to_fk_id,
996: last_update_date = hz_utility_pub.last_update_date,
997: last_updated_by = hz_utility_pub.user_id,
998: last_update_login = hz_utility_pub.last_update_login,

Line 1021: 'on table IBE_SH_SHP_LISTS_ALL');

1017:
1018: Exception
1019: When RESOURCE_BUSY Then
1020: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS; Could not obtain lock'||
1021: 'on table IBE_SH_SHP_LISTS_ALL');
1022:
1023: x_return_status := FND_API.G_RET_STS_ERROR;
1024: raise;
1025: When Others Then

Line 1651: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);

1647:
1648:
1649: if p_from_fk_id <> p_to_fk_id Then
1650: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1651: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
1652: open merge_from_active;
1653: loop
1654: Fetch merge_from_active into l_quote_header_id, l_cust_account_id, l_quote_name;
1655: EXIT When merge_from_active%NOTFOUND;