DBA Data[Home] [Help]

APPS.ZX_PARTY_MERGE_PKG dependencies on ZX_JURISDICTIONS_B

Line 436: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_jurisdictions_b for tax Authorities...');

432: last_update_login = G_LOGIN_ID,
433: object_version_number = object_version_number+1
434: WHERE COLL_TAX_AUTHORITY_ID = p_ptp_id_from;
435:
436: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_jurisdictions_b for tax Authorities...');
437:
438: UPDATE zx_jurisdictions_b
439: set REP_TAX_AUTHORITY_ID = p_ptp_id_to,
440: last_update_date = SYSDATE,

Line 438: UPDATE zx_jurisdictions_b

434: WHERE COLL_TAX_AUTHORITY_ID = p_ptp_id_from;
435:
436: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_jurisdictions_b for tax Authorities...');
437:
438: UPDATE zx_jurisdictions_b
439: set REP_TAX_AUTHORITY_ID = p_ptp_id_to,
440: last_update_date = SYSDATE,
441: last_updated_by = G_USER_ID,
442: last_update_login = G_LOGIN_ID,

Line 446: UPDATE zx_jurisdictions_b

442: last_update_login = G_LOGIN_ID,
443: object_version_number = object_version_number+1
444: WHERE REP_TAX_AUTHORITY_ID = p_ptp_id_from;
445:
446: UPDATE zx_jurisdictions_b
447: set COLL_TAX_AUTHORITY_ID = p_ptp_id_to,
448: last_update_date = SYSDATE,
449: last_updated_by = G_USER_ID,
450: last_update_login = G_LOGIN_ID,

Line 454: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_jurisdictions_b for tax Authorities...');

450: last_update_login = G_LOGIN_ID,
451: object_version_number = object_version_number+1
452: WHERE COLL_TAX_AUTHORITY_ID = p_ptp_id_from;
453:
454: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_jurisdictions_b for tax Authorities...');
455:
456: UPDATE zx_exemptions
457: set ISSUING_TAX_AUTHORITY_ID = p_ptp_id_to,
458: last_update_date = SYSDATE,