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.IBY_PARTY_MERGE dependencies on HZ_UTILITY_PUB

Line 97: last_update_date = hz_utility_pub.last_update_date,

93:
94: UPDATE iby_account_owners
95: SET account_owner_party_id = DECODE(l_dup_id, NULL,p_to_fk_id, account_owner_party_id),
96: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
97: last_update_date = hz_utility_pub.last_update_date,
98: last_updated_by = hz_utility_pub.user_id,
99: last_update_login = hz_utility_pub.last_update_login
100: WHERE (account_owner_id = p_from_id);
101:

Line 98: last_updated_by = hz_utility_pub.user_id,

94: UPDATE iby_account_owners
95: SET account_owner_party_id = DECODE(l_dup_id, NULL,p_to_fk_id, account_owner_party_id),
96: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
97: last_update_date = hz_utility_pub.last_update_date,
98: last_updated_by = hz_utility_pub.user_id,
99: last_update_login = hz_utility_pub.last_update_login
100: WHERE (account_owner_id = p_from_id);
101:
102: IF (l_dup_id IS NULL) THEN

Line 99: last_update_login = hz_utility_pub.last_update_login

95: SET account_owner_party_id = DECODE(l_dup_id, NULL,p_to_fk_id, account_owner_party_id),
96: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
97: last_update_date = hz_utility_pub.last_update_date,
98: last_updated_by = hz_utility_pub.user_id,
99: last_update_login = hz_utility_pub.last_update_login
100: WHERE (account_owner_id = p_from_id);
101:
102: IF (l_dup_id IS NULL) THEN
103: p_to_id := p_from_id;

Line 222: last_update_date = hz_utility_pub.last_update_date,

218: UPDATE iby_creditcard
219: SET card_owner_id = DECODE(l_dup_id, NULL,p_to_fk_id, card_owner_id),
220: active_flag = DECODE(l_dup_id, NULL,active_flag, 'N'),
221: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
222: last_update_date = hz_utility_pub.last_update_date,
223: last_updated_by = hz_utility_pub.user_id,
224: last_update_login = hz_utility_pub.last_update_login,
225: request_id = hz_utility_pub.request_id,
226: program_application_id = hz_utility_pub.program_application_id,

Line 223: last_updated_by = hz_utility_pub.user_id,

219: SET card_owner_id = DECODE(l_dup_id, NULL,p_to_fk_id, card_owner_id),
220: active_flag = DECODE(l_dup_id, NULL,active_flag, 'N'),
221: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
222: last_update_date = hz_utility_pub.last_update_date,
223: last_updated_by = hz_utility_pub.user_id,
224: last_update_login = hz_utility_pub.last_update_login,
225: request_id = hz_utility_pub.request_id,
226: program_application_id = hz_utility_pub.program_application_id,
227: program_id = hz_utility_pub.program_id,

Line 224: last_update_login = hz_utility_pub.last_update_login,

220: active_flag = DECODE(l_dup_id, NULL,active_flag, 'N'),
221: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
222: last_update_date = hz_utility_pub.last_update_date,
223: last_updated_by = hz_utility_pub.user_id,
224: last_update_login = hz_utility_pub.last_update_login,
225: request_id = hz_utility_pub.request_id,
226: program_application_id = hz_utility_pub.program_application_id,
227: program_id = hz_utility_pub.program_id,
228: program_update_date = sysdate

Line 225: request_id = hz_utility_pub.request_id,

221: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
222: last_update_date = hz_utility_pub.last_update_date,
223: last_updated_by = hz_utility_pub.user_id,
224: last_update_login = hz_utility_pub.last_update_login,
225: request_id = hz_utility_pub.request_id,
226: program_application_id = hz_utility_pub.program_application_id,
227: program_id = hz_utility_pub.program_id,
228: program_update_date = sysdate
229: WHERE (instrid = p_from_id);

Line 226: program_application_id = hz_utility_pub.program_application_id,

222: last_update_date = hz_utility_pub.last_update_date,
223: last_updated_by = hz_utility_pub.user_id,
224: last_update_login = hz_utility_pub.last_update_login,
225: request_id = hz_utility_pub.request_id,
226: program_application_id = hz_utility_pub.program_application_id,
227: program_id = hz_utility_pub.program_id,
228: program_update_date = sysdate
229: WHERE (instrid = p_from_id);
230:

Line 227: program_id = hz_utility_pub.program_id,

223: last_updated_by = hz_utility_pub.user_id,
224: last_update_login = hz_utility_pub.last_update_login,
225: request_id = hz_utility_pub.request_id,
226: program_application_id = hz_utility_pub.program_application_id,
227: program_id = hz_utility_pub.program_id,
228: program_update_date = sysdate
229: WHERE (instrid = p_from_id);
230:
231: p_to_id := NVL(l_dup_id,p_from_id);

Line 237: last_update_date = hz_utility_pub.last_update_date,

233: ELSIF (p_parent_entity_name = 'HZ_PARTY_SITE_USES') THEN
234:
235: UPDATE iby_creditcard
236: SET addressid = p_to_fk_id,
237: last_update_date = hz_utility_pub.last_update_date,
238: last_updated_by = hz_utility_pub.user_id,
239: last_update_login = hz_utility_pub.last_update_login,
240: request_id = hz_utility_pub.request_id,
241: program_application_id = hz_utility_pub.program_application_id,

Line 238: last_updated_by = hz_utility_pub.user_id,

234:
235: UPDATE iby_creditcard
236: SET addressid = p_to_fk_id,
237: last_update_date = hz_utility_pub.last_update_date,
238: last_updated_by = hz_utility_pub.user_id,
239: last_update_login = hz_utility_pub.last_update_login,
240: request_id = hz_utility_pub.request_id,
241: program_application_id = hz_utility_pub.program_application_id,
242: program_id = hz_utility_pub.program_id,

Line 239: last_update_login = hz_utility_pub.last_update_login,

235: UPDATE iby_creditcard
236: SET addressid = p_to_fk_id,
237: last_update_date = hz_utility_pub.last_update_date,
238: last_updated_by = hz_utility_pub.user_id,
239: last_update_login = hz_utility_pub.last_update_login,
240: request_id = hz_utility_pub.request_id,
241: program_application_id = hz_utility_pub.program_application_id,
242: program_id = hz_utility_pub.program_id,
243: program_update_date = sysdate

Line 240: request_id = hz_utility_pub.request_id,

236: SET addressid = p_to_fk_id,
237: last_update_date = hz_utility_pub.last_update_date,
238: last_updated_by = hz_utility_pub.user_id,
239: last_update_login = hz_utility_pub.last_update_login,
240: request_id = hz_utility_pub.request_id,
241: program_application_id = hz_utility_pub.program_application_id,
242: program_id = hz_utility_pub.program_id,
243: program_update_date = sysdate
244: WHERE (instrid = p_from_id);

Line 241: program_application_id = hz_utility_pub.program_application_id,

237: last_update_date = hz_utility_pub.last_update_date,
238: last_updated_by = hz_utility_pub.user_id,
239: last_update_login = hz_utility_pub.last_update_login,
240: request_id = hz_utility_pub.request_id,
241: program_application_id = hz_utility_pub.program_application_id,
242: program_id = hz_utility_pub.program_id,
243: program_update_date = sysdate
244: WHERE (instrid = p_from_id);
245:

Line 242: program_id = hz_utility_pub.program_id,

238: last_updated_by = hz_utility_pub.user_id,
239: last_update_login = hz_utility_pub.last_update_login,
240: request_id = hz_utility_pub.request_id,
241: program_application_id = hz_utility_pub.program_application_id,
242: program_id = hz_utility_pub.program_id,
243: program_update_date = sysdate
244: WHERE (instrid = p_from_id);
245:
246: p_to_id := p_from_id;

Line 343: last_update_date = hz_utility_pub.last_update_date,

339:
340: IF (l_dup_id IS NULL) THEN
341: UPDATE iby_external_payers_all
342: SET party_id = p_to_fk_id,
343: last_update_date = hz_utility_pub.last_update_date,
344: last_updated_by = hz_utility_pub.user_id,
345: last_update_login = hz_utility_pub.last_update_login
346: WHERE ext_payer_id = p_from_id;
347: p_to_id := p_from_id;

Line 344: last_updated_by = hz_utility_pub.user_id,

340: IF (l_dup_id IS NULL) THEN
341: UPDATE iby_external_payers_all
342: SET party_id = p_to_fk_id,
343: last_update_date = hz_utility_pub.last_update_date,
344: last_updated_by = hz_utility_pub.user_id,
345: last_update_login = hz_utility_pub.last_update_login
346: WHERE ext_payer_id = p_from_id;
347: p_to_id := p_from_id;
348: ELSE

Line 345: last_update_login = hz_utility_pub.last_update_login

341: UPDATE iby_external_payers_all
342: SET party_id = p_to_fk_id,
343: last_update_date = hz_utility_pub.last_update_date,
344: last_updated_by = hz_utility_pub.user_id,
345: last_update_login = hz_utility_pub.last_update_login
346: WHERE ext_payer_id = p_from_id;
347: p_to_id := p_from_id;
348: ELSE
349: p_to_id := l_dup_id;

Line 463: last_update_date = hz_utility_pub.last_update_date,

459:
460: UPDATE iby_pmt_instr_uses_all
461: SET instrument_id = DECODE(l_dup_id, NULL,p_to_fk_id, instrument_id),
462: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
463: last_update_date = hz_utility_pub.last_update_date,
464: last_updated_by = hz_utility_pub.user_id,
465: last_update_login = hz_utility_pub.last_update_login
466: WHERE (instrument_payment_use_id = p_from_id);
467:

Line 464: last_updated_by = hz_utility_pub.user_id,

460: UPDATE iby_pmt_instr_uses_all
461: SET instrument_id = DECODE(l_dup_id, NULL,p_to_fk_id, instrument_id),
462: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
463: last_update_date = hz_utility_pub.last_update_date,
464: last_updated_by = hz_utility_pub.user_id,
465: last_update_login = hz_utility_pub.last_update_login
466: WHERE (instrument_payment_use_id = p_from_id);
467:
468: IF (l_dup_id IS NULL) THEN

Line 465: last_update_login = hz_utility_pub.last_update_login

461: SET instrument_id = DECODE(l_dup_id, NULL,p_to_fk_id, instrument_id),
462: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
463: last_update_date = hz_utility_pub.last_update_date,
464: last_updated_by = hz_utility_pub.user_id,
465: last_update_login = hz_utility_pub.last_update_login
466: WHERE (instrument_payment_use_id = p_from_id);
467:
468: IF (l_dup_id IS NULL) THEN
469: p_to_id := p_from_id;

Line 494: last_update_date = hz_utility_pub.last_update_date,

490:
491: UPDATE iby_pmt_instr_uses_all
492: SET ext_pmt_party_id = DECODE(l_dup_id, NULL,p_to_fk_id, ext_pmt_party_id),
493: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
494: last_update_date = hz_utility_pub.last_update_date,
495: last_updated_by = hz_utility_pub.user_id,
496: last_update_login = hz_utility_pub.last_update_login
497: WHERE (instrument_payment_use_id = p_from_id);
498:

Line 495: last_updated_by = hz_utility_pub.user_id,

491: UPDATE iby_pmt_instr_uses_all
492: SET ext_pmt_party_id = DECODE(l_dup_id, NULL,p_to_fk_id, ext_pmt_party_id),
493: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
494: last_update_date = hz_utility_pub.last_update_date,
495: last_updated_by = hz_utility_pub.user_id,
496: last_update_login = hz_utility_pub.last_update_login
497: WHERE (instrument_payment_use_id = p_from_id);
498:
499: IF (l_dup_id IS NULL) THEN

Line 496: last_update_login = hz_utility_pub.last_update_login

492: SET ext_pmt_party_id = DECODE(l_dup_id, NULL,p_to_fk_id, ext_pmt_party_id),
493: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
494: last_update_date = hz_utility_pub.last_update_date,
495: last_updated_by = hz_utility_pub.user_id,
496: last_update_login = hz_utility_pub.last_update_login
497: WHERE (instrument_payment_use_id = p_from_id);
498:
499: IF (l_dup_id IS NULL) THEN
500: p_to_id := p_from_id;

Line 596: last_update_date = hz_utility_pub.last_update_date,

592:
593: UPDATE iby_ext_party_pmt_mthds
594: SET ext_pmt_party_id = DECODE(l_dup_id, NULL,p_to_fk_id, ext_pmt_party_id),
595: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
596: last_update_date = hz_utility_pub.last_update_date,
597: last_updated_by = hz_utility_pub.user_id,
598: last_update_login = hz_utility_pub.last_update_login
599: WHERE (ext_party_pmt_mthd_id = p_from_id);
600:

Line 597: last_updated_by = hz_utility_pub.user_id,

593: UPDATE iby_ext_party_pmt_mthds
594: SET ext_pmt_party_id = DECODE(l_dup_id, NULL,p_to_fk_id, ext_pmt_party_id),
595: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
596: last_update_date = hz_utility_pub.last_update_date,
597: last_updated_by = hz_utility_pub.user_id,
598: last_update_login = hz_utility_pub.last_update_login
599: WHERE (ext_party_pmt_mthd_id = p_from_id);
600:
601: IF (l_dup_id IS NULL) THEN

Line 598: last_update_login = hz_utility_pub.last_update_login

594: SET ext_pmt_party_id = DECODE(l_dup_id, NULL,p_to_fk_id, ext_pmt_party_id),
595: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
596: last_update_date = hz_utility_pub.last_update_date,
597: last_updated_by = hz_utility_pub.user_id,
598: last_update_login = hz_utility_pub.last_update_login
599: WHERE (ext_party_pmt_mthd_id = p_from_id);
600:
601: IF (l_dup_id IS NULL) THEN
602: p_to_id := p_from_id;

Line 671: last_update_date = hz_utility_pub.last_update_date,

667: IF (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL') THEN
668:
669: UPDATE iby_fndcpt_tx_extensions
670: SET ext_payer_id = p_to_fk_id,
671: last_update_date = hz_utility_pub.last_update_date,
672: last_updated_by = hz_utility_pub.user_id,
673: last_update_login = hz_utility_pub.last_update_login
674: WHERE (trxn_extension_id = p_from_id);
675:

Line 672: last_updated_by = hz_utility_pub.user_id,

668:
669: UPDATE iby_fndcpt_tx_extensions
670: SET ext_payer_id = p_to_fk_id,
671: last_update_date = hz_utility_pub.last_update_date,
672: last_updated_by = hz_utility_pub.user_id,
673: last_update_login = hz_utility_pub.last_update_login
674: WHERE (trxn_extension_id = p_from_id);
675:
676: ELSIF (p_parent_entity_name = 'IBY_PMT_INSTR_USES_ALL') THEN

Line 673: last_update_login = hz_utility_pub.last_update_login

669: UPDATE iby_fndcpt_tx_extensions
670: SET ext_payer_id = p_to_fk_id,
671: last_update_date = hz_utility_pub.last_update_date,
672: last_updated_by = hz_utility_pub.user_id,
673: last_update_login = hz_utility_pub.last_update_login
674: WHERE (trxn_extension_id = p_from_id);
675:
676: ELSIF (p_parent_entity_name = 'IBY_PMT_INSTR_USES_ALL') THEN
677:

Line 680: last_update_date = hz_utility_pub.last_update_date,

676: ELSIF (p_parent_entity_name = 'IBY_PMT_INSTR_USES_ALL') THEN
677:
678: UPDATE iby_fndcpt_tx_extensions
679: SET instr_assignment_id = p_to_fk_id,
680: last_update_date = hz_utility_pub.last_update_date,
681: last_updated_by = hz_utility_pub.user_id,
682: last_update_login = hz_utility_pub.last_update_login
683: WHERE (trxn_extension_id = p_from_id);
684:

Line 681: last_updated_by = hz_utility_pub.user_id,

677:
678: UPDATE iby_fndcpt_tx_extensions
679: SET instr_assignment_id = p_to_fk_id,
680: last_update_date = hz_utility_pub.last_update_date,
681: last_updated_by = hz_utility_pub.user_id,
682: last_update_login = hz_utility_pub.last_update_login
683: WHERE (trxn_extension_id = p_from_id);
684:
685: END IF;

Line 682: last_update_login = hz_utility_pub.last_update_login

678: UPDATE iby_fndcpt_tx_extensions
679: SET instr_assignment_id = p_to_fk_id,
680: last_update_date = hz_utility_pub.last_update_date,
681: last_updated_by = hz_utility_pub.user_id,
682: last_update_login = hz_utility_pub.last_update_login
683: WHERE (trxn_extension_id = p_from_id);
684:
685: END IF;
686:

Line 750: last_update_date = hz_utility_pub.last_update_date,

746: IF (p_parent_entity_name = 'HZ_PARTIES') THEN
747:
748: UPDATE iby_trxn_summaries_all
749: SET payerid = p_to_fk_id,
750: last_update_date = hz_utility_pub.last_update_date,
751: last_updated_by = hz_utility_pub.user_id,
752: last_update_login = hz_utility_pub.last_update_login
753: WHERE (trxnmid = p_from_id);
754:

Line 751: last_updated_by = hz_utility_pub.user_id,

747:
748: UPDATE iby_trxn_summaries_all
749: SET payerid = p_to_fk_id,
750: last_update_date = hz_utility_pub.last_update_date,
751: last_updated_by = hz_utility_pub.user_id,
752: last_update_login = hz_utility_pub.last_update_login
753: WHERE (trxnmid = p_from_id);
754:
755: ELSIF (p_parent_entity_name = 'IBY_PMT_INSTR_USES_ALL') THEN

Line 752: last_update_login = hz_utility_pub.last_update_login

748: UPDATE iby_trxn_summaries_all
749: SET payerid = p_to_fk_id,
750: last_update_date = hz_utility_pub.last_update_date,
751: last_updated_by = hz_utility_pub.user_id,
752: last_update_login = hz_utility_pub.last_update_login
753: WHERE (trxnmid = p_from_id);
754:
755: ELSIF (p_parent_entity_name = 'IBY_PMT_INSTR_USES_ALL') THEN
756:

Line 759: last_update_date = hz_utility_pub.last_update_date,

755: ELSIF (p_parent_entity_name = 'IBY_PMT_INSTR_USES_ALL') THEN
756:
757: UPDATE iby_trxn_summaries_all
758: SET payer_instr_assignment_id = p_to_fk_id,
759: last_update_date = hz_utility_pub.last_update_date,
760: last_updated_by = hz_utility_pub.user_id,
761: last_update_login = hz_utility_pub.last_update_login
762: WHERE (trxnmid = p_from_id);
763:

Line 760: last_updated_by = hz_utility_pub.user_id,

756:
757: UPDATE iby_trxn_summaries_all
758: SET payer_instr_assignment_id = p_to_fk_id,
759: last_update_date = hz_utility_pub.last_update_date,
760: last_updated_by = hz_utility_pub.user_id,
761: last_update_login = hz_utility_pub.last_update_login
762: WHERE (trxnmid = p_from_id);
763:
764: ELSIF (p_parent_entity_name = 'IBY_CREDITCARD') THEN

Line 761: last_update_login = hz_utility_pub.last_update_login

757: UPDATE iby_trxn_summaries_all
758: SET payer_instr_assignment_id = p_to_fk_id,
759: last_update_date = hz_utility_pub.last_update_date,
760: last_updated_by = hz_utility_pub.user_id,
761: last_update_login = hz_utility_pub.last_update_login
762: WHERE (trxnmid = p_from_id);
763:
764: ELSIF (p_parent_entity_name = 'IBY_CREDITCARD') THEN
765:

Line 768: last_update_date = hz_utility_pub.last_update_date,

764: ELSIF (p_parent_entity_name = 'IBY_CREDITCARD') THEN
765:
766: UPDATE iby_trxn_summaries_all
767: SET payerinstrid = p_to_fk_id,
768: last_update_date = hz_utility_pub.last_update_date,
769: last_updated_by = hz_utility_pub.user_id,
770: last_update_login = hz_utility_pub.last_update_login
771: WHERE (trxnmid = p_from_id)
772: AND (instrtype = 'CREDITCARD');

Line 769: last_updated_by = hz_utility_pub.user_id,

765:
766: UPDATE iby_trxn_summaries_all
767: SET payerinstrid = p_to_fk_id,
768: last_update_date = hz_utility_pub.last_update_date,
769: last_updated_by = hz_utility_pub.user_id,
770: last_update_login = hz_utility_pub.last_update_login
771: WHERE (trxnmid = p_from_id)
772: AND (instrtype = 'CREDITCARD');
773:

Line 770: last_update_login = hz_utility_pub.last_update_login

766: UPDATE iby_trxn_summaries_all
767: SET payerinstrid = p_to_fk_id,
768: last_update_date = hz_utility_pub.last_update_date,
769: last_updated_by = hz_utility_pub.user_id,
770: last_update_login = hz_utility_pub.last_update_login
771: WHERE (trxnmid = p_from_id)
772: AND (instrtype = 'CREDITCARD');
773:
774: END IF;