DBA Data[Home] [Help]

APPS.ZX_PARTY_MERGE_PKG dependencies on ZX_JURISDICTIONS_B

Line 468: arp_message.set_line('Updating zx_jurisdictions_b for tax Authorities...');

464: last_update_login = g_login_id,
465: object_version_number = object_version_number+1
466: where COLL_TAX_AUTHORITY_ID = p_ptp_id_from;
467:
468: arp_message.set_line('Updating zx_jurisdictions_b for tax Authorities...');
469:
470: update zx_jurisdictions_b
471: set REP_TAX_AUTHORITY_ID = p_ptp_id_to,
472: last_update_date = sysdate,

Line 470: update zx_jurisdictions_b

466: where COLL_TAX_AUTHORITY_ID = p_ptp_id_from;
467:
468: arp_message.set_line('Updating zx_jurisdictions_b for tax Authorities...');
469:
470: update zx_jurisdictions_b
471: set REP_TAX_AUTHORITY_ID = p_ptp_id_to,
472: last_update_date = sysdate,
473: last_updated_by = g_user_id,
474: last_update_login = g_login_id,

Line 478: update zx_jurisdictions_b

474: last_update_login = g_login_id,
475: object_version_number = object_version_number+1
476: where REP_TAX_AUTHORITY_ID = p_ptp_id_from;
477:
478: update zx_jurisdictions_b
479: set COLL_TAX_AUTHORITY_ID = p_ptp_id_to,
480: last_update_date = sysdate,
481: last_updated_by = g_user_id,
482: last_update_login = g_login_id,

Line 486: arp_message.set_line('Updating zx_jurisdictions_b for tax Authorities...');

482: last_update_login = g_login_id,
483: object_version_number = object_version_number+1
484: where COLL_TAX_AUTHORITY_ID = p_ptp_id_from;
485:
486: arp_message.set_line('Updating zx_jurisdictions_b for tax Authorities...');
487:
488: update zx_exemptions
489: set ISSUING_TAX_AUTHORITY_ID = p_ptp_id_to,
490: last_update_date = sysdate,