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

204: |
205: | PROCEDURE
206: | acc_merge_shp_lists
207: | DESCRIPTION :
208: | Account merge procedure for the table, IBE_SH_SHP_LISTS_ALL
209: |
210: |
211: |--------------------------------------------------------------*/
212: procedure acc_merge_shp_lists (

Line 225: IBE_SH_SHP_LISTS_ALL.SHP_LIST_ID%TYPE

221: INDEX BY BINARY_INTEGER;
222: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
223:
224: TYPE SHP_LIST_ID_LIST_TYPE IS TABLE OF
225: IBE_SH_SHP_LISTS_ALL.SHP_LIST_ID%TYPE
226: INDEX BY BINARY_INTEGER;
227: PRIMARY_KEY_ID_LIST SHP_LIST_ID_LIST_TYPE;
228:
229: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 230: IBE_SH_SHP_LISTS_ALL.CUST_ACCOUNT_ID%TYPE

226: INDEX BY BINARY_INTEGER;
227: PRIMARY_KEY_ID_LIST SHP_LIST_ID_LIST_TYPE;
228:
229: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
230: IBE_SH_SHP_LISTS_ALL.CUST_ACCOUNT_ID%TYPE
231: INDEX BY BINARY_INTEGER;
232: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
233: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
234:

Line 236: IBE_SH_SHP_LISTS_ALL.PARTY_ID%TYPE

232: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
233: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
234:
235: TYPE PARTY_ID_LIST_TYPE IS TABLE OF
236: IBE_SH_SHP_LISTS_ALL.PARTY_ID%TYPE
237: INDEX BY BINARY_INTEGER;
238: NUM_COL2_ORIG_LIST PARTY_ID_LIST_TYPE;
239: NUM_COL2_NEW_LIST PARTY_ID_LIST_TYPE;
240: l_acct_id number;

Line 249: FROM IBE_SH_SHP_LISTS_ALL yt, ra_customer_merges m

245: SELECT distinct CUSTOMER_MERGE_HEADER_ID
246: ,yt.SHP_LIST_ID
247: ,yt.CUST_ACCOUNT_ID
248: ,yt.party_id
249: FROM IBE_SH_SHP_LISTS_ALL yt, ra_customer_merges m
250: WHERE
251: yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
252: AND m.process_flag = 'N'
253: AND m.request_id = req_id

Line 291: UPDATE IBE_SH_SHP_LISTS_ALL yt SET

287: else
288: --B2C, partyID changes to what's tied to accountID
289: NUM_COL2_NEW_LIST(I) := find_party(NUM_COL1_NEW_LIST(I));
290: end if;
291: UPDATE IBE_SH_SHP_LISTS_ALL yt SET
292: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
293: ,PARTY_ID=NUM_COL2_NEW_LIST(I)
294: , LAST_UPDATE_DATE=SYSDATE
295: , last_updated_by=arp_standard.profile.user_id

Line 322: 'IBE_SH_SHP_LISTS_ALL',

318: LAST_UPDATE_LOGIN,
319: LAST_UPDATE_DATE,
320: LAST_UPDATED_BY
321: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
322: 'IBE_SH_SHP_LISTS_ALL',
323: MERGE_HEADER_ID_LIST(I),
324: PRIMARY_KEY_ID_LIST(I),
325: NUM_COL1_ORIG_LIST(I),
326: NUM_COL1_NEW_LIST(I),

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

783: End Loop;
784: Close C_CUST;
785:
786: arp_message.set_name('AR','AR_UPDATING_TABLE');
787: arp_message.set_token('TABLE_NAME','IBE_SH_SHP_LISTS_ALL',FALSE);
788:
789: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE - updating IBE_SH_SHP_LISTS_ALL table');
790: --2940366
791: acc_merge_shp_lists(request_id,set_number,process_mode,p_customer_type);

Line 789: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE - updating IBE_SH_SHP_LISTS_ALL table');

785:
786: arp_message.set_name('AR','AR_UPDATING_TABLE');
787: arp_message.set_token('TABLE_NAME','IBE_SH_SHP_LISTS_ALL',FALSE);
788:
789: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE - updating IBE_SH_SHP_LISTS_ALL table');
790: --2940366
791: acc_merge_shp_lists(request_id,set_number,process_mode,p_customer_type);
792: g_count := sql%rowcount;
793: arp_message.set_name('AR','AR_ROWS_UPDATED');

Line 851: | This procedure will update IBE_SH_SHP_LISTS_ALL table |

847: | MERGE_SHP_LISTS -- |
848: | When in ERP Parties are merged the |
849: | The Foriegn keys to party_id and other columns |
850: | should also be updated in iStore tables. |
851: | This procedure will update IBE_SH_SHP_LISTS_ALL table |
852: | and will be called from party Merge concurrent program. |
853: | DESCRIPTION |
854: | |
855: | REQUIRES |

Line 884: IBE_SH_SHP_LISTS_ALL

880: IS
881:
882: Cursor C1 is
883: Select 'X' from
884: IBE_SH_SHP_LISTS_ALL
885: Where party_id = p_from_fk_id
886: for update nowait;
887:
888: l_merge_reason_code VARCHAR2(30);

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

935:
936: if p_from_fk_id <> p_to_fk_id Then
937:
938: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
939: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
940:
941: Open C1;
942: Close C1;
943:

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

941: Open C1;
942: Close C1;
943:
944: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
945: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
946:
947: UPDATE IBE_SH_SHP_LISTS_ALL isl SET
948: party_id = p_to_fk_id,
949: last_update_date = hz_utility_pub.last_update_date,

Line 947: UPDATE IBE_SH_SHP_LISTS_ALL isl SET

943:
944: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
945: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
946:
947: UPDATE IBE_SH_SHP_LISTS_ALL isl SET
948: party_id = p_to_fk_id,
949: last_update_date = hz_utility_pub.last_update_date,
950: last_updated_by = hz_utility_pub.user_id,
951: last_update_login = hz_utility_pub.last_update_login,

Line 974: 'on table IBE_SH_SHP_LISTS_ALL');

970:
971: Exception
972: When RESOURCE_BUSY Then
973: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS; Could not obtain lock'||
974: 'on table IBE_SH_SHP_LISTS_ALL');
975: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SHIP_LISTS; Could not obtain lock'||
976: 'on table IBE_SH_SHP_LISTS_ALL');
977: x_return_status := FND_API.G_RET_STS_ERROR;
978: raise;

Line 976: 'on table IBE_SH_SHP_LISTS_ALL');

972: When RESOURCE_BUSY Then
973: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS; Could not obtain lock'||
974: 'on table IBE_SH_SHP_LISTS_ALL');
975: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SHIP_LISTS; Could not obtain lock'||
976: 'on table IBE_SH_SHP_LISTS_ALL');
977: x_return_status := FND_API.G_RET_STS_ERROR;
978: raise;
979: When Others Then
980:

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

1617:
1618:
1619: if p_from_fk_id <> p_to_fk_id Then
1620: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1621: arp_message.set_token('TABLE_NAME', 'IBE_SH_SHP_LISTS_ALL', FALSE);
1622: open merge_from_active;
1623: loop
1624: Fetch merge_from_active into l_quote_header_id, l_cust_account_id, l_quote_name;
1625: EXIT When merge_from_active%NOTFOUND;