APPS.IBY_HZ_UNIFICATION_PKG dependencies on HZ_UTILITY_PUB

Line 63: last_update_date = hz_utility_pub.last_update_date,

59:
60: IF (l_dup_id IS NULL) THEN
61: UPDATE iby_external_payers_all
62: SET party_id = p_to_fk_id,
63: last_update_date = hz_utility_pub.last_update_date,
64: last_updated_by = hz_utility_pub.user_id,
65: last_update_login = hz_utility_pub.last_update_login
66: WHERE ext_payer_id = p_from_id;
67: p_to_id := p_from_id;

Line 64: last_updated_by = hz_utility_pub.user_id,

60: IF (l_dup_id IS NULL) THEN
61: UPDATE iby_external_payers_all
62: SET party_id = p_to_fk_id,
63: last_update_date = hz_utility_pub.last_update_date,
64: last_updated_by = hz_utility_pub.user_id,
65: last_update_login = hz_utility_pub.last_update_login
66: WHERE ext_payer_id = p_from_id;
67: p_to_id := p_from_id;
68: ELSE

Line 65: last_update_login = hz_utility_pub.last_update_login

61: UPDATE iby_external_payers_all
62: SET party_id = p_to_fk_id,
63: last_update_date = hz_utility_pub.last_update_date,
64: last_updated_by = hz_utility_pub.user_id,
65: last_update_login = hz_utility_pub.last_update_login
66: WHERE ext_payer_id = p_from_id;
67: p_to_id := p_from_id;
68: ELSE
69: p_to_id := l_dup_id;

Line 171: last_update_date = hz_utility_pub.last_update_date,

167:
168: UPDATE iby_external_payees_all
169: SET payee_party_id = DECODE(l_dup_id, NULL,p_to_fk_id, payee_party_id),
170: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
171: last_update_date = hz_utility_pub.last_update_date,
172: last_updated_by = hz_utility_pub.user_id,
173: last_update_login = hz_utility_pub.last_update_login
174: WHERE ext_payee_id = p_from_id;
175:

Line 172: last_updated_by = hz_utility_pub.user_id,

168: UPDATE iby_external_payees_all
169: SET payee_party_id = DECODE(l_dup_id, NULL,p_to_fk_id, payee_party_id),
170: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
171: last_update_date = hz_utility_pub.last_update_date,
172: last_updated_by = hz_utility_pub.user_id,
173: last_update_login = hz_utility_pub.last_update_login
174: WHERE ext_payee_id = p_from_id;
175:
176: IF (l_dup_id IS NULL) THEN

Line 173: last_update_login = hz_utility_pub.last_update_login

169: SET payee_party_id = DECODE(l_dup_id, NULL,p_to_fk_id, payee_party_id),
170: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
171: last_update_date = hz_utility_pub.last_update_date,
172: last_updated_by = hz_utility_pub.user_id,
173: last_update_login = hz_utility_pub.last_update_login
174: WHERE ext_payee_id = p_from_id;
175:
176: IF (l_dup_id IS NULL) THEN
177: p_to_id := p_from_id;

Line 198: last_update_date = hz_utility_pub.last_update_date,

194: -- case of either merge or transfer of the site
195: --
196: payee_party_id = l_new_party_id,
197: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
198: last_update_date = hz_utility_pub.last_update_date,
199: last_updated_by = hz_utility_pub.user_id,
200: last_update_login = hz_utility_pub.last_update_login
201: WHERE ext_payee_id = p_from_id;
202:

Line 199: last_updated_by = hz_utility_pub.user_id,

195: --
196: payee_party_id = l_new_party_id,
197: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
198: last_update_date = hz_utility_pub.last_update_date,
199: last_updated_by = hz_utility_pub.user_id,
200: last_update_login = hz_utility_pub.last_update_login
201: WHERE ext_payee_id = p_from_id;
202:
203: IF (l_dup_id IS NULL) THEN

Line 200: last_update_login = hz_utility_pub.last_update_login

196: payee_party_id = l_new_party_id,
197: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
198: last_update_date = hz_utility_pub.last_update_date,
199: last_updated_by = hz_utility_pub.user_id,
200: last_update_login = hz_utility_pub.last_update_login
201: WHERE ext_payee_id = p_from_id;
202:
203: IF (l_dup_id IS NULL) THEN
204: p_to_id := p_from_id;

Line 297: last_update_date = hz_utility_pub.last_update_date,

293: UPDATE iby_creditcard
294: SET card_owner_id = DECODE(l_dup_id, NULL,p_to_fk_id, card_owner_id),
295: active_flag = DECODE(l_dup_id, NULL,active_flag, 'N'),
296: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
297: last_update_date = hz_utility_pub.last_update_date,
298: last_updated_by = hz_utility_pub.user_id,
299: last_update_login = hz_utility_pub.last_update_login,
300: request_id = hz_utility_pub.request_id,
301: program_application_id = hz_utility_pub.program_application_id,

Line 298: last_updated_by = hz_utility_pub.user_id,

294: SET card_owner_id = DECODE(l_dup_id, NULL,p_to_fk_id, card_owner_id),
295: active_flag = DECODE(l_dup_id, NULL,active_flag, 'N'),
296: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
297: last_update_date = hz_utility_pub.last_update_date,
298: last_updated_by = hz_utility_pub.user_id,
299: last_update_login = hz_utility_pub.last_update_login,
300: request_id = hz_utility_pub.request_id,
301: program_application_id = hz_utility_pub.program_application_id,
302: program_id = hz_utility_pub.program_id,

Line 299: last_update_login = hz_utility_pub.last_update_login,

295: active_flag = DECODE(l_dup_id, NULL,active_flag, 'N'),
296: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
297: last_update_date = hz_utility_pub.last_update_date,
298: last_updated_by = hz_utility_pub.user_id,
299: last_update_login = hz_utility_pub.last_update_login,
300: request_id = hz_utility_pub.request_id,
301: program_application_id = hz_utility_pub.program_application_id,
302: program_id = hz_utility_pub.program_id,
303: program_update_date = sysdate

Line 300: request_id = hz_utility_pub.request_id,

296: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
297: last_update_date = hz_utility_pub.last_update_date,
298: last_updated_by = hz_utility_pub.user_id,
299: last_update_login = hz_utility_pub.last_update_login,
300: request_id = hz_utility_pub.request_id,
301: program_application_id = hz_utility_pub.program_application_id,
302: program_id = hz_utility_pub.program_id,
303: program_update_date = sysdate
304: WHERE (instrid = p_from_id);

Line 301: program_application_id = hz_utility_pub.program_application_id,

297: last_update_date = hz_utility_pub.last_update_date,
298: last_updated_by = hz_utility_pub.user_id,
299: last_update_login = hz_utility_pub.last_update_login,
300: request_id = hz_utility_pub.request_id,
301: program_application_id = hz_utility_pub.program_application_id,
302: program_id = hz_utility_pub.program_id,
303: program_update_date = sysdate
304: WHERE (instrid = p_from_id);
305:

Line 302: program_id = hz_utility_pub.program_id,

298: last_updated_by = hz_utility_pub.user_id,
299: last_update_login = hz_utility_pub.last_update_login,
300: request_id = hz_utility_pub.request_id,
301: program_application_id = hz_utility_pub.program_application_id,
302: program_id = hz_utility_pub.program_id,
303: program_update_date = sysdate
304: WHERE (instrid = p_from_id);
305:
306: p_to_id := NVL(l_dup_id,p_from_id);

Line 312: last_update_date = hz_utility_pub.last_update_date,

308: ELSIF (p_parent_entity_name = 'HZ_PARTY_SITE_USES') THEN
309:
310: UPDATE iby_creditcard
311: SET addressid = p_to_fk_id,
312: last_update_date = hz_utility_pub.last_update_date,
313: last_updated_by = hz_utility_pub.user_id,
314: last_update_login = hz_utility_pub.last_update_login,
315: request_id = hz_utility_pub.request_id,
316: program_application_id = hz_utility_pub.program_application_id,

Line 313: last_updated_by = hz_utility_pub.user_id,

309:
310: UPDATE iby_creditcard
311: SET addressid = p_to_fk_id,
312: last_update_date = hz_utility_pub.last_update_date,
313: last_updated_by = hz_utility_pub.user_id,
314: last_update_login = hz_utility_pub.last_update_login,
315: request_id = hz_utility_pub.request_id,
316: program_application_id = hz_utility_pub.program_application_id,
317: program_id = hz_utility_pub.program_id,

Line 314: last_update_login = hz_utility_pub.last_update_login,

310: UPDATE iby_creditcard
311: SET addressid = p_to_fk_id,
312: last_update_date = hz_utility_pub.last_update_date,
313: last_updated_by = hz_utility_pub.user_id,
314: last_update_login = hz_utility_pub.last_update_login,
315: request_id = hz_utility_pub.request_id,
316: program_application_id = hz_utility_pub.program_application_id,
317: program_id = hz_utility_pub.program_id,
318: program_update_date = sysdate

Line 315: request_id = hz_utility_pub.request_id,

311: SET addressid = p_to_fk_id,
312: last_update_date = hz_utility_pub.last_update_date,
313: last_updated_by = hz_utility_pub.user_id,
314: last_update_login = hz_utility_pub.last_update_login,
315: request_id = hz_utility_pub.request_id,
316: program_application_id = hz_utility_pub.program_application_id,
317: program_id = hz_utility_pub.program_id,
318: program_update_date = sysdate
319: WHERE (instrid = p_from_id);

Line 316: program_application_id = hz_utility_pub.program_application_id,

312: last_update_date = hz_utility_pub.last_update_date,
313: last_updated_by = hz_utility_pub.user_id,
314: last_update_login = hz_utility_pub.last_update_login,
315: request_id = hz_utility_pub.request_id,
316: program_application_id = hz_utility_pub.program_application_id,
317: program_id = hz_utility_pub.program_id,
318: program_update_date = sysdate
319: WHERE (instrid = p_from_id);
320:

Line 317: program_id = hz_utility_pub.program_id,

313: last_updated_by = hz_utility_pub.user_id,
314: last_update_login = hz_utility_pub.last_update_login,
315: request_id = hz_utility_pub.request_id,
316: program_application_id = hz_utility_pub.program_application_id,
317: program_id = hz_utility_pub.program_id,
318: program_update_date = sysdate
319: WHERE (instrid = p_from_id);
320:
321: p_to_id := p_from_id;

Line 411: last_update_date = hz_utility_pub.last_update_date,

407:
408: UPDATE iby_pmt_instr_uses_all
409: SET instrument_id = DECODE(l_dup_id, NULL,p_to_id, instrument_id),
410: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
411: last_update_date = hz_utility_pub.last_update_date,
412: last_updated_by = hz_utility_pub.user_id,
413: last_update_login = hz_utility_pub.last_update_login
414: WHERE (instrument_payment_use_id = p_from_id);
415:

Line 412: last_updated_by = hz_utility_pub.user_id,

408: UPDATE iby_pmt_instr_uses_all
409: SET instrument_id = DECODE(l_dup_id, NULL,p_to_id, instrument_id),
410: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
411: last_update_date = hz_utility_pub.last_update_date,
412: last_updated_by = hz_utility_pub.user_id,
413: last_update_login = hz_utility_pub.last_update_login
414: WHERE (instrument_payment_use_id = p_from_id);
415:
416: IF (l_dup_id IS NULL) THEN

Line 413: last_update_login = hz_utility_pub.last_update_login

409: SET instrument_id = DECODE(l_dup_id, NULL,p_to_id, instrument_id),
410: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
411: last_update_date = hz_utility_pub.last_update_date,
412: last_updated_by = hz_utility_pub.user_id,
413: last_update_login = hz_utility_pub.last_update_login
414: WHERE (instrument_payment_use_id = p_from_id);
415:
416: IF (l_dup_id IS NULL) THEN
417: p_to_id := p_from_id;

Line 447: last_update_date = hz_utility_pub.last_update_date,

443:
444: UPDATE iby_pmt_instr_uses_all
445: SET ext_pmt_party_id = DECODE(l_dup_id, NULL,p_to_id, ext_pmt_party_id),
446: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
447: last_update_date = hz_utility_pub.last_update_date,
448: last_updated_by = hz_utility_pub.user_id,
449: last_update_login = hz_utility_pub.last_update_login
450: WHERE (instrument_payment_use_id = p_from_id);
451:

Line 448: last_updated_by = hz_utility_pub.user_id,

444: UPDATE iby_pmt_instr_uses_all
445: SET ext_pmt_party_id = DECODE(l_dup_id, NULL,p_to_id, ext_pmt_party_id),
446: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
447: last_update_date = hz_utility_pub.last_update_date,
448: last_updated_by = hz_utility_pub.user_id,
449: last_update_login = hz_utility_pub.last_update_login
450: WHERE (instrument_payment_use_id = p_from_id);
451:
452: IF (l_dup_id IS NULL) THEN

Line 449: last_update_login = hz_utility_pub.last_update_login

445: SET ext_pmt_party_id = DECODE(l_dup_id, NULL,p_to_id, ext_pmt_party_id),
446: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
447: last_update_date = hz_utility_pub.last_update_date,
448: last_updated_by = hz_utility_pub.user_id,
449: last_update_login = hz_utility_pub.last_update_login
450: WHERE (instrument_payment_use_id = p_from_id);
451:
452: IF (l_dup_id IS NULL) THEN
453: p_to_id := p_from_id;

Line 536: last_update_date = hz_utility_pub.last_update_date,

532:
533: UPDATE iby_account_owners
534: SET account_owner_party_id = DECODE(l_dup_id, NULL,p_to_id, account_owner_party_id),
535: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
536: last_update_date = hz_utility_pub.last_update_date,
537: last_updated_by = hz_utility_pub.user_id,
538: last_update_login = hz_utility_pub.last_update_login
539: WHERE (account_owner_id = p_from_id);
540:

Line 537: last_updated_by = hz_utility_pub.user_id,

533: UPDATE iby_account_owners
534: SET account_owner_party_id = DECODE(l_dup_id, NULL,p_to_id, account_owner_party_id),
535: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
536: last_update_date = hz_utility_pub.last_update_date,
537: last_updated_by = hz_utility_pub.user_id,
538: last_update_login = hz_utility_pub.last_update_login
539: WHERE (account_owner_id = p_from_id);
540:
541: IF (l_dup_id IS NULL) THEN

Line 538: last_update_login = hz_utility_pub.last_update_login

534: SET account_owner_party_id = DECODE(l_dup_id, NULL,p_to_id, account_owner_party_id),
535: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
536: last_update_date = hz_utility_pub.last_update_date,
537: last_updated_by = hz_utility_pub.user_id,
538: last_update_login = hz_utility_pub.last_update_login
539: WHERE (account_owner_id = p_from_id);
540:
541: IF (l_dup_id IS NULL) THEN
542: p_to_id := p_from_id;

Line 616: last_update_date = hz_utility_pub.last_update_date,

612:
613: UPDATE iby_ext_party_pmt_mthds
614: SET ext_pmt_party_id = DECODE(l_dup_id, NULL,p_to_id, ext_pmt_party_id),
615: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
616: last_update_date = hz_utility_pub.last_update_date,
617: last_updated_by = hz_utility_pub.user_id,
618: last_update_login = hz_utility_pub.last_update_login
619: WHERE (ext_party_pmt_mthd_id = p_from_id);
620:

Line 617: last_updated_by = hz_utility_pub.user_id,

613: UPDATE iby_ext_party_pmt_mthds
614: SET ext_pmt_party_id = DECODE(l_dup_id, NULL,p_to_id, ext_pmt_party_id),
615: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
616: last_update_date = hz_utility_pub.last_update_date,
617: last_updated_by = hz_utility_pub.user_id,
618: last_update_login = hz_utility_pub.last_update_login
619: WHERE (ext_party_pmt_mthd_id = p_from_id);
620:
621: IF (l_dup_id IS NULL) THEN

Line 618: last_update_login = hz_utility_pub.last_update_login

614: SET ext_pmt_party_id = DECODE(l_dup_id, NULL,p_to_id, ext_pmt_party_id),
615: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
616: last_update_date = hz_utility_pub.last_update_date,
617: last_updated_by = hz_utility_pub.user_id,
618: last_update_login = hz_utility_pub.last_update_login
619: WHERE (ext_party_pmt_mthd_id = p_from_id);
620:
621: IF (l_dup_id IS NULL) THEN
622: p_to_id := p_from_id;

Line 668: last_update_date = hz_utility_pub.last_update_date,

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

Line 669: last_updated_by = hz_utility_pub.user_id,

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

Line 670: last_update_login = hz_utility_pub.last_update_login

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

Line 677: last_update_date = hz_utility_pub.last_update_date,

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

Line 678: last_updated_by = hz_utility_pub.user_id,

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

Line 679: last_update_login = hz_utility_pub.last_update_login

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

Line 725: last_update_date = hz_utility_pub.last_update_date,

721: IF (p_parent_entity_name = 'HZ_PARTIES') THEN
722:
723: UPDATE iby_trxn_summaries_all
724: SET payerid = p_to_fk_id,
725: last_update_date = hz_utility_pub.last_update_date,
726: last_updated_by = hz_utility_pub.user_id,
727: last_update_login = hz_utility_pub.last_update_login
728: WHERE (trxnmid = p_from_id);
729:

Line 726: last_updated_by = hz_utility_pub.user_id,

722:
723: UPDATE iby_trxn_summaries_all
724: SET payerid = p_to_fk_id,
725: last_update_date = hz_utility_pub.last_update_date,
726: last_updated_by = hz_utility_pub.user_id,
727: last_update_login = hz_utility_pub.last_update_login
728: WHERE (trxnmid = p_from_id);
729:
730: ELSIF (p_parent_entity_name = 'IBY_PMT_INSTR_USES_ALL') THEN

Line 727: last_update_login = hz_utility_pub.last_update_login

723: UPDATE iby_trxn_summaries_all
724: SET payerid = p_to_fk_id,
725: last_update_date = hz_utility_pub.last_update_date,
726: last_updated_by = hz_utility_pub.user_id,
727: last_update_login = hz_utility_pub.last_update_login
728: WHERE (trxnmid = p_from_id);
729:
730: ELSIF (p_parent_entity_name = 'IBY_PMT_INSTR_USES_ALL') THEN
731:

Line 734: last_update_date = hz_utility_pub.last_update_date,

730: ELSIF (p_parent_entity_name = 'IBY_PMT_INSTR_USES_ALL') THEN
731:
732: UPDATE iby_trxn_summaries_all
733: SET payer_instr_assignment_id = p_to_fk_id,
734: last_update_date = hz_utility_pub.last_update_date,
735: last_updated_by = hz_utility_pub.user_id,
736: last_update_login = hz_utility_pub.last_update_login
737: WHERE (trxnmid = p_from_id);
738:

Line 735: last_updated_by = hz_utility_pub.user_id,

731:
732: UPDATE iby_trxn_summaries_all
733: SET payer_instr_assignment_id = p_to_fk_id,
734: last_update_date = hz_utility_pub.last_update_date,
735: last_updated_by = hz_utility_pub.user_id,
736: last_update_login = hz_utility_pub.last_update_login
737: WHERE (trxnmid = p_from_id);
738:
739: ELSIF (p_parent_entity_name = 'IBY_CREDITCARD') THEN

Line 736: last_update_login = hz_utility_pub.last_update_login

732: UPDATE iby_trxn_summaries_all
733: SET payer_instr_assignment_id = p_to_fk_id,
734: last_update_date = hz_utility_pub.last_update_date,
735: last_updated_by = hz_utility_pub.user_id,
736: last_update_login = hz_utility_pub.last_update_login
737: WHERE (trxnmid = p_from_id);
738:
739: ELSIF (p_parent_entity_name = 'IBY_CREDITCARD') THEN
740:

Line 743: last_update_date = hz_utility_pub.last_update_date,

739: ELSIF (p_parent_entity_name = 'IBY_CREDITCARD') THEN
740:
741: UPDATE iby_trxn_summaries_all
742: SET payerinstrid = p_to_fk_id,
743: last_update_date = hz_utility_pub.last_update_date,
744: last_updated_by = hz_utility_pub.user_id,
745: last_update_login = hz_utility_pub.last_update_login
746: WHERE (trxnmid = p_from_id)
747: AND (instrtype = 'CREDITCARD');

Line 744: last_updated_by = hz_utility_pub.user_id,

740:
741: UPDATE iby_trxn_summaries_all
742: SET payerinstrid = p_to_fk_id,
743: last_update_date = hz_utility_pub.last_update_date,
744: last_updated_by = hz_utility_pub.user_id,
745: last_update_login = hz_utility_pub.last_update_login
746: WHERE (trxnmid = p_from_id)
747: AND (instrtype = 'CREDITCARD');
748:

Line 745: last_update_login = hz_utility_pub.last_update_login

741: UPDATE iby_trxn_summaries_all
742: SET payerinstrid = p_to_fk_id,
743: last_update_date = hz_utility_pub.last_update_date,
744: last_updated_by = hz_utility_pub.user_id,
745: last_update_login = hz_utility_pub.last_update_login
746: WHERE (trxnmid = p_from_id)
747: AND (instrtype = 'CREDITCARD');
748:
749: END IF;

Line 792: last_update_date = hz_utility_pub.last_update_date,

788: IF (p_parent_entity_name = 'HZ_PARTIES') THEN
789:
790: UPDATE iby_docs_payable_all
791: SET payee_party_id = p_to_fk_id,
792: last_update_date = hz_utility_pub.last_update_date,
793: last_updated_by = hz_utility_pub.user_id,
794: last_update_login = hz_utility_pub.last_update_login
795: WHERE (document_payable_id = p_from_id)
796: AND (payee_party_id = p_from_fk_id);

Line 793: last_updated_by = hz_utility_pub.user_id,

789:
790: UPDATE iby_docs_payable_all
791: SET payee_party_id = p_to_fk_id,
792: last_update_date = hz_utility_pub.last_update_date,
793: last_updated_by = hz_utility_pub.user_id,
794: last_update_login = hz_utility_pub.last_update_login
795: WHERE (document_payable_id = p_from_id)
796: AND (payee_party_id = p_from_fk_id);
797:

Line 794: last_update_login = hz_utility_pub.last_update_login

790: UPDATE iby_docs_payable_all
791: SET payee_party_id = p_to_fk_id,
792: last_update_date = hz_utility_pub.last_update_date,
793: last_updated_by = hz_utility_pub.user_id,
794: last_update_login = hz_utility_pub.last_update_login
795: WHERE (document_payable_id = p_from_id)
796: AND (payee_party_id = p_from_fk_id);
797:
798: UPDATE iby_docs_payable_all

Line 800: last_update_date = hz_utility_pub.last_update_date,

796: AND (payee_party_id = p_from_fk_id);
797:
798: UPDATE iby_docs_payable_all
799: SET beneficiary_party = p_to_fk_id,
800: last_update_date = hz_utility_pub.last_update_date,
801: last_updated_by = hz_utility_pub.user_id,
802: last_update_login = hz_utility_pub.last_update_login
803: WHERE (document_payable_id = p_from_id)
804: AND (beneficiary_party = p_from_fk_id);

Line 801: last_updated_by = hz_utility_pub.user_id,

797:
798: UPDATE iby_docs_payable_all
799: SET beneficiary_party = p_to_fk_id,
800: last_update_date = hz_utility_pub.last_update_date,
801: last_updated_by = hz_utility_pub.user_id,
802: last_update_login = hz_utility_pub.last_update_login
803: WHERE (document_payable_id = p_from_id)
804: AND (beneficiary_party = p_from_fk_id);
805:

Line 802: last_update_login = hz_utility_pub.last_update_login

798: UPDATE iby_docs_payable_all
799: SET beneficiary_party = p_to_fk_id,
800: last_update_date = hz_utility_pub.last_update_date,
801: last_updated_by = hz_utility_pub.user_id,
802: last_update_login = hz_utility_pub.last_update_login
803: WHERE (document_payable_id = p_from_id)
804: AND (beneficiary_party = p_from_fk_id);
805:
806: ELSIF (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL') THEN

Line 810: last_update_date = hz_utility_pub.last_update_date,

806: ELSIF (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL') THEN
807:
808: UPDATE iby_docs_payable_all
809: SET ext_payee_id = p_to_fk_id,
810: last_update_date = hz_utility_pub.last_update_date,
811: last_updated_by = hz_utility_pub.user_id,
812: last_update_login = hz_utility_pub.last_update_login
813: WHERE (document_payable_id = p_from_id);
814:

Line 811: last_updated_by = hz_utility_pub.user_id,

807:
808: UPDATE iby_docs_payable_all
809: SET ext_payee_id = p_to_fk_id,
810: last_update_date = hz_utility_pub.last_update_date,
811: last_updated_by = hz_utility_pub.user_id,
812: last_update_login = hz_utility_pub.last_update_login
813: WHERE (document_payable_id = p_from_id);
814:
815: ELSIF (p_parent_entity_name = 'HZ_PARTY_SITES') THEN

Line 812: last_update_login = hz_utility_pub.last_update_login

808: UPDATE iby_docs_payable_all
809: SET ext_payee_id = p_to_fk_id,
810: last_update_date = hz_utility_pub.last_update_date,
811: last_updated_by = hz_utility_pub.user_id,
812: last_update_login = hz_utility_pub.last_update_login
813: WHERE (document_payable_id = p_from_id);
814:
815: ELSIF (p_parent_entity_name = 'HZ_PARTY_SITES') THEN
816:

Line 824: last_update_date = hz_utility_pub.last_update_date,

820: payee_party_id =
821: DECODE(payee_party_id, NULL,payee_party_id,
822: (SELECT party_id FROM hz_party_sites
823: WHERE party_site_id = p_to_fk_id) ),
824: last_update_date = hz_utility_pub.last_update_date,
825: last_updated_by = hz_utility_pub.user_id,
826: last_update_login = hz_utility_pub.last_update_login
827: WHERE (document_payable_id = p_from_id);
828:

Line 825: last_updated_by = hz_utility_pub.user_id,

821: DECODE(payee_party_id, NULL,payee_party_id,
822: (SELECT party_id FROM hz_party_sites
823: WHERE party_site_id = p_to_fk_id) ),
824: last_update_date = hz_utility_pub.last_update_date,
825: last_updated_by = hz_utility_pub.user_id,
826: last_update_login = hz_utility_pub.last_update_login
827: WHERE (document_payable_id = p_from_id);
828:
829: END IF;

Line 826: last_update_login = hz_utility_pub.last_update_login

822: (SELECT party_id FROM hz_party_sites
823: WHERE party_site_id = p_to_fk_id) ),
824: last_update_date = hz_utility_pub.last_update_date,
825: last_updated_by = hz_utility_pub.user_id,
826: last_update_login = hz_utility_pub.last_update_login
827: WHERE (document_payable_id = p_from_id);
828:
829: END IF;
830:

Line 872: last_update_date = hz_utility_pub.last_update_date,

868: IF (p_parent_entity_name = 'HZ_PARTIES') THEN
869:
870: UPDATE iby_payments_all
871: SET payee_party_id = p_to_fk_id,
872: last_update_date = hz_utility_pub.last_update_date,
873: last_updated_by = hz_utility_pub.user_id,
874: last_update_login = hz_utility_pub.last_update_login
875: WHERE (payment_id = p_from_id)
876: AND (payee_party_id = p_from_fk_id);

Line 873: last_updated_by = hz_utility_pub.user_id,

869:
870: UPDATE iby_payments_all
871: SET payee_party_id = p_to_fk_id,
872: last_update_date = hz_utility_pub.last_update_date,
873: last_updated_by = hz_utility_pub.user_id,
874: last_update_login = hz_utility_pub.last_update_login
875: WHERE (payment_id = p_from_id)
876: AND (payee_party_id = p_from_fk_id);
877:

Line 874: last_update_login = hz_utility_pub.last_update_login

870: UPDATE iby_payments_all
871: SET payee_party_id = p_to_fk_id,
872: last_update_date = hz_utility_pub.last_update_date,
873: last_updated_by = hz_utility_pub.user_id,
874: last_update_login = hz_utility_pub.last_update_login
875: WHERE (payment_id = p_from_id)
876: AND (payee_party_id = p_from_fk_id);
877:
878: UPDATE iby_payments_all

Line 880: last_update_date = hz_utility_pub.last_update_date,

876: AND (payee_party_id = p_from_fk_id);
877:
878: UPDATE iby_payments_all
879: SET beneficiary_party = p_to_fk_id,
880: last_update_date = hz_utility_pub.last_update_date,
881: last_updated_by = hz_utility_pub.user_id,
882: last_update_login = hz_utility_pub.last_update_login
883: WHERE (payment_id = p_from_id)
884: AND (beneficiary_party = p_from_fk_id);

Line 881: last_updated_by = hz_utility_pub.user_id,

877:
878: UPDATE iby_payments_all
879: SET beneficiary_party = p_to_fk_id,
880: last_update_date = hz_utility_pub.last_update_date,
881: last_updated_by = hz_utility_pub.user_id,
882: last_update_login = hz_utility_pub.last_update_login
883: WHERE (payment_id = p_from_id)
884: AND (beneficiary_party = p_from_fk_id);
885:

Line 882: last_update_login = hz_utility_pub.last_update_login

878: UPDATE iby_payments_all
879: SET beneficiary_party = p_to_fk_id,
880: last_update_date = hz_utility_pub.last_update_date,
881: last_updated_by = hz_utility_pub.user_id,
882: last_update_login = hz_utility_pub.last_update_login
883: WHERE (payment_id = p_from_id)
884: AND (beneficiary_party = p_from_fk_id);
885:
886: UPDATE iby_payments_all

Line 888: last_update_date = hz_utility_pub.last_update_date,

884: AND (beneficiary_party = p_from_fk_id);
885:
886: UPDATE iby_payments_all
887: SET payer_party_id = p_to_fk_id,
888: last_update_date = hz_utility_pub.last_update_date,
889: last_updated_by = hz_utility_pub.user_id,
890: last_update_login = hz_utility_pub.last_update_login
891: WHERE (payment_id = p_from_id)
892: AND (payer_party_id = p_from_fk_id);

Line 889: last_updated_by = hz_utility_pub.user_id,

885:
886: UPDATE iby_payments_all
887: SET payer_party_id = p_to_fk_id,
888: last_update_date = hz_utility_pub.last_update_date,
889: last_updated_by = hz_utility_pub.user_id,
890: last_update_login = hz_utility_pub.last_update_login
891: WHERE (payment_id = p_from_id)
892: AND (payer_party_id = p_from_fk_id);
893:

Line 890: last_update_login = hz_utility_pub.last_update_login

886: UPDATE iby_payments_all
887: SET payer_party_id = p_to_fk_id,
888: last_update_date = hz_utility_pub.last_update_date,
889: last_updated_by = hz_utility_pub.user_id,
890: last_update_login = hz_utility_pub.last_update_login
891: WHERE (payment_id = p_from_id)
892: AND (payer_party_id = p_from_fk_id);
893:
894: ELSIF (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL') THEN

Line 898: last_update_date = hz_utility_pub.last_update_date,

894: ELSIF (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL') THEN
895:
896: UPDATE iby_payments_all
897: SET ext_payee_id = p_to_fk_id,
898: last_update_date = hz_utility_pub.last_update_date,
899: last_updated_by = hz_utility_pub.user_id,
900: last_update_login = hz_utility_pub.last_update_login
901: WHERE (payment_id = p_from_id);
902:

Line 899: last_updated_by = hz_utility_pub.user_id,

895:
896: UPDATE iby_payments_all
897: SET ext_payee_id = p_to_fk_id,
898: last_update_date = hz_utility_pub.last_update_date,
899: last_updated_by = hz_utility_pub.user_id,
900: last_update_login = hz_utility_pub.last_update_login
901: WHERE (payment_id = p_from_id);
902:
903: ELSIF (p_parent_entity_name = 'HZ_PARTY_SITES') THEN

Line 900: last_update_login = hz_utility_pub.last_update_login

896: UPDATE iby_payments_all
897: SET ext_payee_id = p_to_fk_id,
898: last_update_date = hz_utility_pub.last_update_date,
899: last_updated_by = hz_utility_pub.user_id,
900: last_update_login = hz_utility_pub.last_update_login
901: WHERE (payment_id = p_from_id);
902:
903: ELSIF (p_parent_entity_name = 'HZ_PARTY_SITES') THEN
904:

Line 912: last_update_date = hz_utility_pub.last_update_date,

908: payee_party_id =
909: DECODE(payee_party_id, NULL,payee_party_id,
910: (SELECT party_id FROM hz_party_sites
911: WHERE party_site_id = p_to_fk_id) ),
912: last_update_date = hz_utility_pub.last_update_date,
913: last_updated_by = hz_utility_pub.user_id,
914: last_update_login = hz_utility_pub.last_update_login
915: WHERE (payment_id = p_from_id);
916:

Line 913: last_updated_by = hz_utility_pub.user_id,

909: DECODE(payee_party_id, NULL,payee_party_id,
910: (SELECT party_id FROM hz_party_sites
911: WHERE party_site_id = p_to_fk_id) ),
912: last_update_date = hz_utility_pub.last_update_date,
913: last_updated_by = hz_utility_pub.user_id,
914: last_update_login = hz_utility_pub.last_update_login
915: WHERE (payment_id = p_from_id);
916:
917: END IF;

Line 914: last_update_login = hz_utility_pub.last_update_login

910: (SELECT party_id FROM hz_party_sites
911: WHERE party_site_id = p_to_fk_id) ),
912: last_update_date = hz_utility_pub.last_update_date,
913: last_updated_by = hz_utility_pub.user_id,
914: last_update_login = hz_utility_pub.last_update_login
915: WHERE (payment_id = p_from_id);
916:
917: END IF;
918: