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.OKS_PARTY_MERGE_PKG dependencies on OKS_SERV_AVAIL_EXCEPTS

Line 221: /* Merge the records in OKS_SERV_AVAIL_EXCEPTS */

217: END;
218: end if;
219: END OKS_DEFAULTS;
220:
221: /* Merge the records in OKS_SERV_AVAIL_EXCEPTS */
222: --chkrishn 04/16/03 modify code to delete service avail exceptions of both from and to parties during merge
223: PROCEDURE OKS_SERVICE_EXCEPTS(
224: p_entity_name in hz_merge_dictionary.entity_name%type,
225: p_from_id in oks_serv_avail_excepts.id%type,

Line 225: p_from_id in oks_serv_avail_excepts.id%type,

221: /* Merge the records in OKS_SERV_AVAIL_EXCEPTS */
222: --chkrishn 04/16/03 modify code to delete service avail exceptions of both from and to parties during merge
223: PROCEDURE OKS_SERVICE_EXCEPTS(
224: p_entity_name in hz_merge_dictionary.entity_name%type,
225: p_from_id in oks_serv_avail_excepts.id%type,
226: x_to_id in out nocopy oks_serv_avail_excepts.id%type,
227: p_from_fk_id in hz_merge_parties.from_party_id%type,
228: p_to_fk_id in hz_merge_parties.to_party_id%type,
229: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,

Line 226: x_to_id in out nocopy oks_serv_avail_excepts.id%type,

222: --chkrishn 04/16/03 modify code to delete service avail exceptions of both from and to parties during merge
223: PROCEDURE OKS_SERVICE_EXCEPTS(
224: p_entity_name in hz_merge_dictionary.entity_name%type,
225: p_from_id in oks_serv_avail_excepts.id%type,
226: x_to_id in out nocopy oks_serv_avail_excepts.id%type,
227: p_from_fk_id in hz_merge_parties.from_party_id%type,
228: p_to_fk_id in hz_merge_parties.to_party_id%type,
229: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
230: p_batch_id in hz_merge_batch.batch_id%type,

Line 255: /* original code arp_message.set_line('Updating OKS_SERV_AVAIL_EXCEPTS...');

251:
252: if p_from_fk_id <> p_to_fk_id then
253: BEGIN
254:
255: /* original code arp_message.set_line('Updating OKS_SERV_AVAIL_EXCEPTS...');
256:
257: update oks_serv_avail_excepts
258: set object1_id1 = p_to_fk_id,
259: last_update_date = sysdate,

Line 257: update oks_serv_avail_excepts

253: BEGIN
254:
255: /* original code arp_message.set_line('Updating OKS_SERV_AVAIL_EXCEPTS...');
256:
257: update oks_serv_avail_excepts
258: set object1_id1 = p_to_fk_id,
259: last_update_date = sysdate,
260: last_updated_by = g_user_id,
261: last_update_login = g_login_id,

Line 270: arp_message.set_line('Deleting OKS_SERV_AVAIL_EXCEPTS...');

266: l_count := sql%rowcount;
267: arp_message.set_name('AR','AR_ROWS_UPDATED');
268: arp_message.set_token('NUM_ROWS',to_char(l_count));*/
269:
270: arp_message.set_line('Deleting OKS_SERV_AVAIL_EXCEPTS...');
271:
272: delete from oks_serv_avail_excepts
273: where object1_id1 in (p_from_fk_id,p_to_fk_id)
274: and jtot_object1_code = 'OKX_PARTY';

Line 272: delete from oks_serv_avail_excepts

268: arp_message.set_token('NUM_ROWS',to_char(l_count));*/
269:
270: arp_message.set_line('Deleting OKS_SERV_AVAIL_EXCEPTS...');
271:
272: delete from oks_serv_avail_excepts
273: where object1_id1 in (p_from_fk_id,p_to_fk_id)
274: and jtot_object1_code = 'OKX_PARTY';
275:
276: l_count := sql%rowcount;