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.IEX_MERGE_PVT dependencies on HZ_UTILITY_V2PUB

Line 1670: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1666: -- do we really care if something is being "merged" or transferred?? i think not
1667: -- lets just update the table to reflect the new party_id
1668: UPDATE IEX_DELINQUENCIES_ALL
1669: SET party_cust_id = p_To_FK_id,
1670: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1671: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1672: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1673: request_id = HZ_UTILITY_V2PUB.request_id,
1674: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1671: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1667: -- lets just update the table to reflect the new party_id
1668: UPDATE IEX_DELINQUENCIES_ALL
1669: SET party_cust_id = p_To_FK_id,
1670: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1671: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1672: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1673: request_id = HZ_UTILITY_V2PUB.request_id,
1674: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1675: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1672: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1668: UPDATE IEX_DELINQUENCIES_ALL
1669: SET party_cust_id = p_To_FK_id,
1670: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1671: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1672: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1673: request_id = HZ_UTILITY_V2PUB.request_id,
1674: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1675: program_id = HZ_UTILITY_V2PUB.program_id,
1676: program_update_date = sysdate

Line 1673: request_id = HZ_UTILITY_V2PUB.request_id,

1669: SET party_cust_id = p_To_FK_id,
1670: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1671: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1672: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1673: request_id = HZ_UTILITY_V2PUB.request_id,
1674: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1675: program_id = HZ_UTILITY_V2PUB.program_id,
1676: program_update_date = sysdate
1677: WHERE party_cust_id = p_from_fk_id;

Line 1674: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1670: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1671: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1672: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1673: request_id = HZ_UTILITY_V2PUB.request_id,
1674: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1675: program_id = HZ_UTILITY_V2PUB.program_id,
1676: program_update_date = sysdate
1677: WHERE party_cust_id = p_from_fk_id;
1678:

Line 1675: program_id = HZ_UTILITY_V2PUB.program_id,

1671: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1672: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1673: request_id = HZ_UTILITY_V2PUB.request_id,
1674: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1675: program_id = HZ_UTILITY_V2PUB.program_id,
1676: program_update_date = sysdate
1677: WHERE party_cust_id = p_from_fk_id;
1678:
1679: -- begin raverma 10232001 -- add this to update promise table

Line 1682: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1678:
1679: -- begin raverma 10232001 -- add this to update promise table
1680: UPDATE IEX_PROMISE_DETAILS
1681: SET Promise_Made_By = p_To_FK_ID,
1682: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1683: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1684: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1685: request_id = HZ_UTILITY_V2PUB.request_id,
1686: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1683: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1679: -- begin raverma 10232001 -- add this to update promise table
1680: UPDATE IEX_PROMISE_DETAILS
1681: SET Promise_Made_By = p_To_FK_ID,
1682: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1683: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1684: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1685: request_id = HZ_UTILITY_V2PUB.request_id,
1686: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1687: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1684: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1680: UPDATE IEX_PROMISE_DETAILS
1681: SET Promise_Made_By = p_To_FK_ID,
1682: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1683: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1684: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1685: request_id = HZ_UTILITY_V2PUB.request_id,
1686: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1687: program_id = HZ_UTILITY_V2PUB.program_id,
1688: program_update_date = sysdate

Line 1685: request_id = HZ_UTILITY_V2PUB.request_id,

1681: SET Promise_Made_By = p_To_FK_ID,
1682: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1683: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1684: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1685: request_id = HZ_UTILITY_V2PUB.request_id,
1686: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1687: program_id = HZ_UTILITY_V2PUB.program_id,
1688: program_update_date = sysdate
1689: WHERE promise_made_by = p_from_fk_id;

Line 1686: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1682: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1683: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1684: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1685: request_id = HZ_UTILITY_V2PUB.request_id,
1686: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1687: program_id = HZ_UTILITY_V2PUB.program_id,
1688: program_update_date = sysdate
1689: WHERE promise_made_by = p_from_fk_id;
1690:

Line 1687: program_id = HZ_UTILITY_V2PUB.program_id,

1683: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1684: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1685: request_id = HZ_UTILITY_V2PUB.request_id,
1686: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1687: program_id = HZ_UTILITY_V2PUB.program_id,
1688: program_update_date = sysdate
1689: WHERE promise_made_by = p_from_fk_id;
1690:
1691: /* Begin raverma 02032003 add new party_merge entities

Line 1704: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1700: IEX_STRATEGIES
1701: */
1702: UPDATE IEX_STRATEGIES
1703: SET JTF_OBJECT_ID = p_To_FK_ID,
1704: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1705: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1706: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1707: request_id = HZ_UTILITY_V2PUB.request_id,
1708: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1705: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1701: */
1702: UPDATE IEX_STRATEGIES
1703: SET JTF_OBJECT_ID = p_To_FK_ID,
1704: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1705: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1706: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1707: request_id = HZ_UTILITY_V2PUB.request_id,
1708: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1709: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1706: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1702: UPDATE IEX_STRATEGIES
1703: SET JTF_OBJECT_ID = p_To_FK_ID,
1704: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1705: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1706: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1707: request_id = HZ_UTILITY_V2PUB.request_id,
1708: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1709: program_id = HZ_UTILITY_V2PUB.program_id,
1710: program_update_date = sysdate,

Line 1707: request_id = HZ_UTILITY_V2PUB.request_id,

1703: SET JTF_OBJECT_ID = p_To_FK_ID,
1704: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1705: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1706: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1707: request_id = HZ_UTILITY_V2PUB.request_id,
1708: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1709: program_id = HZ_UTILITY_V2PUB.program_id,
1710: program_update_date = sysdate,
1711: -- Begin - 10/12/2005 - Andre Araujo - Need to update party_id also

Line 1708: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1704: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1705: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1706: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1707: request_id = HZ_UTILITY_V2PUB.request_id,
1708: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1709: program_id = HZ_UTILITY_V2PUB.program_id,
1710: program_update_date = sysdate,
1711: -- Begin - 10/12/2005 - Andre Araujo - Need to update party_id also
1712: PARTY_ID = p_To_FK_ID

Line 1709: program_id = HZ_UTILITY_V2PUB.program_id,

1705: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1706: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1707: request_id = HZ_UTILITY_V2PUB.request_id,
1708: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1709: program_id = HZ_UTILITY_V2PUB.program_id,
1710: program_update_date = sysdate,
1711: -- Begin - 10/12/2005 - Andre Araujo - Need to update party_id also
1712: PARTY_ID = p_To_FK_ID
1713: -- End - 10/12/2005 - Andre Araujo - Need to update party_id also

Line 1719: SET last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1715: JTF_OBJECT_TYPE = 'PARTY';
1716:
1717: -- Begin - 10/12/2005 - Andre Araujo - Need to update party_id also
1718: UPDATE IEX_STRATEGIES
1719: SET last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1720: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1721: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1722: request_id = HZ_UTILITY_V2PUB.request_id,
1723: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1720: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1716:
1717: -- Begin - 10/12/2005 - Andre Araujo - Need to update party_id also
1718: UPDATE IEX_STRATEGIES
1719: SET last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1720: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1721: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1722: request_id = HZ_UTILITY_V2PUB.request_id,
1723: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1724: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1721: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1717: -- Begin - 10/12/2005 - Andre Araujo - Need to update party_id also
1718: UPDATE IEX_STRATEGIES
1719: SET last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1720: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1721: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1722: request_id = HZ_UTILITY_V2PUB.request_id,
1723: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1724: program_id = HZ_UTILITY_V2PUB.program_id,
1725: program_update_date = sysdate,

Line 1722: request_id = HZ_UTILITY_V2PUB.request_id,

1718: UPDATE IEX_STRATEGIES
1719: SET last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1720: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1721: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1722: request_id = HZ_UTILITY_V2PUB.request_id,
1723: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1724: program_id = HZ_UTILITY_V2PUB.program_id,
1725: program_update_date = sysdate,
1726: PARTY_ID = p_To_FK_ID

Line 1723: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1719: SET last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1720: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1721: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1722: request_id = HZ_UTILITY_V2PUB.request_id,
1723: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1724: program_id = HZ_UTILITY_V2PUB.program_id,
1725: program_update_date = sysdate,
1726: PARTY_ID = p_To_FK_ID
1727: WHERE PARTY_ID = p_from_fk_id;

Line 1724: program_id = HZ_UTILITY_V2PUB.program_id,

1720: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1721: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1722: request_id = HZ_UTILITY_V2PUB.request_id,
1723: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1724: program_id = HZ_UTILITY_V2PUB.program_id,
1725: program_update_date = sysdate,
1726: PARTY_ID = p_To_FK_ID
1727: WHERE PARTY_ID = p_from_fk_id;
1728: -- End - 10/12/2005 - Andre Araujo - Need to update party_id also

Line 1733: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1729:
1730:
1731: UPDATE IEX_SCORE_HISTORIES
1732: SET SCORE_OBJECT_ID = p_To_FK_ID,
1733: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1734: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1735: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1736: request_id = HZ_UTILITY_V2PUB.request_id,
1737: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1734: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1730:
1731: UPDATE IEX_SCORE_HISTORIES
1732: SET SCORE_OBJECT_ID = p_To_FK_ID,
1733: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1734: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1735: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1736: request_id = HZ_UTILITY_V2PUB.request_id,
1737: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1738: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1735: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1731: UPDATE IEX_SCORE_HISTORIES
1732: SET SCORE_OBJECT_ID = p_To_FK_ID,
1733: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1734: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1735: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1736: request_id = HZ_UTILITY_V2PUB.request_id,
1737: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1738: program_id = HZ_UTILITY_V2PUB.program_id,
1739: program_update_date = sysdate

Line 1736: request_id = HZ_UTILITY_V2PUB.request_id,

1732: SET SCORE_OBJECT_ID = p_To_FK_ID,
1733: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1734: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1735: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1736: request_id = HZ_UTILITY_V2PUB.request_id,
1737: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1738: program_id = HZ_UTILITY_V2PUB.program_id,
1739: program_update_date = sysdate
1740: WHERE SCORE_OBJECT_ID = p_from_fk_id AND

Line 1737: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1733: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1734: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1735: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1736: request_id = HZ_UTILITY_V2PUB.request_id,
1737: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1738: program_id = HZ_UTILITY_V2PUB.program_id,
1739: program_update_date = sysdate
1740: WHERE SCORE_OBJECT_ID = p_from_fk_id AND
1741: SCORE_OBJECT_CODE = 'PARTY';

Line 1738: program_id = HZ_UTILITY_V2PUB.program_id,

1734: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1735: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1736: request_id = HZ_UTILITY_V2PUB.request_id,
1737: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1738: program_id = HZ_UTILITY_V2PUB.program_id,
1739: program_update_date = sysdate
1740: WHERE SCORE_OBJECT_ID = p_from_fk_id AND
1741: SCORE_OBJECT_CODE = 'PARTY';
1742:

Line 1745: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1741: SCORE_OBJECT_CODE = 'PARTY';
1742:
1743: UPDATE IEX_REPOSSESSIONS
1744: SET PARTY_ID = p_To_FK_ID,
1745: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1746: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1747: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1748: request_id = HZ_UTILITY_V2PUB.request_id,
1749: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1746: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1742:
1743: UPDATE IEX_REPOSSESSIONS
1744: SET PARTY_ID = p_To_FK_ID,
1745: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1746: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1747: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1748: request_id = HZ_UTILITY_V2PUB.request_id,
1749: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1750: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1747: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1743: UPDATE IEX_REPOSSESSIONS
1744: SET PARTY_ID = p_To_FK_ID,
1745: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1746: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1747: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1748: request_id = HZ_UTILITY_V2PUB.request_id,
1749: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1750: program_id = HZ_UTILITY_V2PUB.program_id,
1751: program_update_date = sysdate

Line 1748: request_id = HZ_UTILITY_V2PUB.request_id,

1744: SET PARTY_ID = p_To_FK_ID,
1745: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1746: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1747: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1748: request_id = HZ_UTILITY_V2PUB.request_id,
1749: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1750: program_id = HZ_UTILITY_V2PUB.program_id,
1751: program_update_date = sysdate
1752: WHERE PARTY_ID = p_from_fk_id;

Line 1749: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1745: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1746: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1747: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1748: request_id = HZ_UTILITY_V2PUB.request_id,
1749: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1750: program_id = HZ_UTILITY_V2PUB.program_id,
1751: program_update_date = sysdate
1752: WHERE PARTY_ID = p_from_fk_id;
1753:

Line 1750: program_id = HZ_UTILITY_V2PUB.program_id,

1746: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1747: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1748: request_id = HZ_UTILITY_V2PUB.request_id,
1749: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1750: program_id = HZ_UTILITY_V2PUB.program_id,
1751: program_update_date = sysdate
1752: WHERE PARTY_ID = p_from_fk_id;
1753:
1754: UPDATE IEX_REPOSSESSIONS

Line 1756: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1752: WHERE PARTY_ID = p_from_fk_id;
1753:
1754: UPDATE IEX_REPOSSESSIONS
1755: SET REPLEVIN_ATTORNEY = p_To_FK_ID,
1756: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1757: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1758: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1759: request_id = HZ_UTILITY_V2PUB.request_id,
1760: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1757: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1753:
1754: UPDATE IEX_REPOSSESSIONS
1755: SET REPLEVIN_ATTORNEY = p_To_FK_ID,
1756: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1757: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1758: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1759: request_id = HZ_UTILITY_V2PUB.request_id,
1760: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1761: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1758: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1754: UPDATE IEX_REPOSSESSIONS
1755: SET REPLEVIN_ATTORNEY = p_To_FK_ID,
1756: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1757: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1758: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1759: request_id = HZ_UTILITY_V2PUB.request_id,
1760: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1761: program_id = HZ_UTILITY_V2PUB.program_id,
1762: program_update_date = sysdate

Line 1759: request_id = HZ_UTILITY_V2PUB.request_id,

1755: SET REPLEVIN_ATTORNEY = p_To_FK_ID,
1756: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1757: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1758: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1759: request_id = HZ_UTILITY_V2PUB.request_id,
1760: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1761: program_id = HZ_UTILITY_V2PUB.program_id,
1762: program_update_date = sysdate
1763: WHERE REPLEVIN_ATTORNEY = p_from_fk_id;

Line 1760: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1756: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1757: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1758: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1759: request_id = HZ_UTILITY_V2PUB.request_id,
1760: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1761: program_id = HZ_UTILITY_V2PUB.program_id,
1762: program_update_date = sysdate
1763: WHERE REPLEVIN_ATTORNEY = p_from_fk_id;
1764:

Line 1761: program_id = HZ_UTILITY_V2PUB.program_id,

1757: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1758: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1759: request_id = HZ_UTILITY_V2PUB.request_id,
1760: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1761: program_id = HZ_UTILITY_V2PUB.program_id,
1762: program_update_date = sysdate
1763: WHERE REPLEVIN_ATTORNEY = p_from_fk_id;
1764:
1765: UPDATE IEX_DEL_THIRD_PARTIES

Line 1767: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1763: WHERE REPLEVIN_ATTORNEY = p_from_fk_id;
1764:
1765: UPDATE IEX_DEL_THIRD_PARTIES
1766: SET THIRD_PARTY_ID = p_To_FK_ID,
1767: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1768: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1769: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1770: request_id = HZ_UTILITY_V2PUB.request_id,
1771: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1768: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1764:
1765: UPDATE IEX_DEL_THIRD_PARTIES
1766: SET THIRD_PARTY_ID = p_To_FK_ID,
1767: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1768: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1769: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1770: request_id = HZ_UTILITY_V2PUB.request_id,
1771: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1772: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1769: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1765: UPDATE IEX_DEL_THIRD_PARTIES
1766: SET THIRD_PARTY_ID = p_To_FK_ID,
1767: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1768: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1769: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1770: request_id = HZ_UTILITY_V2PUB.request_id,
1771: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1772: program_id = HZ_UTILITY_V2PUB.program_id,
1773: program_update_date = sysdate

Line 1770: request_id = HZ_UTILITY_V2PUB.request_id,

1766: SET THIRD_PARTY_ID = p_To_FK_ID,
1767: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1768: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1769: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1770: request_id = HZ_UTILITY_V2PUB.request_id,
1771: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1772: program_id = HZ_UTILITY_V2PUB.program_id,
1773: program_update_date = sysdate
1774: WHERE THIRD_PARTY_ID = p_from_fk_id;

Line 1771: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1767: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1768: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1769: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1770: request_id = HZ_UTILITY_V2PUB.request_id,
1771: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1772: program_id = HZ_UTILITY_V2PUB.program_id,
1773: program_update_date = sysdate
1774: WHERE THIRD_PARTY_ID = p_from_fk_id;
1775:

Line 1772: program_id = HZ_UTILITY_V2PUB.program_id,

1768: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1769: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1770: request_id = HZ_UTILITY_V2PUB.request_id,
1771: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1772: program_id = HZ_UTILITY_V2PUB.program_id,
1773: program_update_date = sysdate
1774: WHERE THIRD_PARTY_ID = p_from_fk_id;
1775:
1776: UPDATE IEX_CASE_CONTACTS

Line 1778: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1774: WHERE THIRD_PARTY_ID = p_from_fk_id;
1775:
1776: UPDATE IEX_CASE_CONTACTS
1777: SET CONTACT_PARTY_ID = p_To_FK_ID,
1778: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1779: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1780: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1781: request_id = HZ_UTILITY_V2PUB.request_id,
1782: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1779: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1775:
1776: UPDATE IEX_CASE_CONTACTS
1777: SET CONTACT_PARTY_ID = p_To_FK_ID,
1778: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1779: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1780: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1781: request_id = HZ_UTILITY_V2PUB.request_id,
1782: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1783: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1780: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1776: UPDATE IEX_CASE_CONTACTS
1777: SET CONTACT_PARTY_ID = p_To_FK_ID,
1778: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1779: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1780: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1781: request_id = HZ_UTILITY_V2PUB.request_id,
1782: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1783: program_id = HZ_UTILITY_V2PUB.program_id,
1784: program_update_date = sysdate

Line 1781: request_id = HZ_UTILITY_V2PUB.request_id,

1777: SET CONTACT_PARTY_ID = p_To_FK_ID,
1778: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1779: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1780: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1781: request_id = HZ_UTILITY_V2PUB.request_id,
1782: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1783: program_id = HZ_UTILITY_V2PUB.program_id,
1784: program_update_date = sysdate
1785: WHERE CONTACT_PARTY_ID = p_from_fk_id;

Line 1782: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1778: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1779: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1780: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1781: request_id = HZ_UTILITY_V2PUB.request_id,
1782: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1783: program_id = HZ_UTILITY_V2PUB.program_id,
1784: program_update_date = sysdate
1785: WHERE CONTACT_PARTY_ID = p_from_fk_id;
1786:

Line 1783: program_id = HZ_UTILITY_V2PUB.program_id,

1779: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1780: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1781: request_id = HZ_UTILITY_V2PUB.request_id,
1782: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1783: program_id = HZ_UTILITY_V2PUB.program_id,
1784: program_update_date = sysdate
1785: WHERE CONTACT_PARTY_ID = p_from_fk_id;
1786:
1787: UPDATE IEX_CASES_ALL_B

Line 1789: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1785: WHERE CONTACT_PARTY_ID = p_from_fk_id;
1786:
1787: UPDATE IEX_CASES_ALL_B
1788: SET PARTY_ID = p_To_FK_ID,
1789: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1790: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1791: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1792: request_id = HZ_UTILITY_V2PUB.request_id,
1793: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1790: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1786:
1787: UPDATE IEX_CASES_ALL_B
1788: SET PARTY_ID = p_To_FK_ID,
1789: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1790: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1791: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1792: request_id = HZ_UTILITY_V2PUB.request_id,
1793: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1794: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1791: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1787: UPDATE IEX_CASES_ALL_B
1788: SET PARTY_ID = p_To_FK_ID,
1789: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1790: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1791: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1792: request_id = HZ_UTILITY_V2PUB.request_id,
1793: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1794: program_id = HZ_UTILITY_V2PUB.program_id,
1795: program_update_date = sysdate

Line 1792: request_id = HZ_UTILITY_V2PUB.request_id,

1788: SET PARTY_ID = p_To_FK_ID,
1789: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1790: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1791: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1792: request_id = HZ_UTILITY_V2PUB.request_id,
1793: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1794: program_id = HZ_UTILITY_V2PUB.program_id,
1795: program_update_date = sysdate
1796: WHERE PARTY_ID = p_from_fk_id;

Line 1793: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1789: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1790: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1791: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1792: request_id = HZ_UTILITY_V2PUB.request_id,
1793: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1794: program_id = HZ_UTILITY_V2PUB.program_id,
1795: program_update_date = sysdate
1796: WHERE PARTY_ID = p_from_fk_id;
1797:

Line 1794: program_id = HZ_UTILITY_V2PUB.program_id,

1790: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1791: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1792: request_id = HZ_UTILITY_V2PUB.request_id,
1793: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1794: program_id = HZ_UTILITY_V2PUB.program_id,
1795: program_update_date = sysdate
1796: WHERE PARTY_ID = p_from_fk_id;
1797:
1798: UPDATE IEX_WRITEOFFS

Line 1800: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1796: WHERE PARTY_ID = p_from_fk_id;
1797:
1798: UPDATE IEX_WRITEOFFS
1799: SET PARTY_ID = p_To_FK_ID,
1800: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1801: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1802: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1803: request_id = HZ_UTILITY_V2PUB.request_id,
1804: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1801: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1797:
1798: UPDATE IEX_WRITEOFFS
1799: SET PARTY_ID = p_To_FK_ID,
1800: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1801: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1802: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1803: request_id = HZ_UTILITY_V2PUB.request_id,
1804: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1805: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1802: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1798: UPDATE IEX_WRITEOFFS
1799: SET PARTY_ID = p_To_FK_ID,
1800: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1801: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1802: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1803: request_id = HZ_UTILITY_V2PUB.request_id,
1804: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1805: program_id = HZ_UTILITY_V2PUB.program_id,
1806: program_update_date = sysdate

Line 1803: request_id = HZ_UTILITY_V2PUB.request_id,

1799: SET PARTY_ID = p_To_FK_ID,
1800: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1801: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1802: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1803: request_id = HZ_UTILITY_V2PUB.request_id,
1804: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1805: program_id = HZ_UTILITY_V2PUB.program_id,
1806: program_update_date = sysdate
1807: WHERE PARTY_ID = p_from_fk_id;

Line 1804: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1800: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1801: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1802: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1803: request_id = HZ_UTILITY_V2PUB.request_id,
1804: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1805: program_id = HZ_UTILITY_V2PUB.program_id,
1806: program_update_date = sysdate
1807: WHERE PARTY_ID = p_from_fk_id;
1808:

Line 1805: program_id = HZ_UTILITY_V2PUB.program_id,

1801: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1802: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1803: request_id = HZ_UTILITY_V2PUB.request_id,
1804: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1805: program_id = HZ_UTILITY_V2PUB.program_id,
1806: program_update_date = sysdate
1807: WHERE PARTY_ID = p_from_fk_id;
1808:
1809: UPDATE IEX_BANKRUPTCIES

Line 1811: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1807: WHERE PARTY_ID = p_from_fk_id;
1808:
1809: UPDATE IEX_BANKRUPTCIES
1810: SET PARTY_ID = p_To_FK_ID,
1811: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1812: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1813: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1814: request_id = HZ_UTILITY_V2PUB.request_id,
1815: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1812: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1808:
1809: UPDATE IEX_BANKRUPTCIES
1810: SET PARTY_ID = p_To_FK_ID,
1811: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1812: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1813: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1814: request_id = HZ_UTILITY_V2PUB.request_id,
1815: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1816: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1813: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1809: UPDATE IEX_BANKRUPTCIES
1810: SET PARTY_ID = p_To_FK_ID,
1811: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1812: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1813: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1814: request_id = HZ_UTILITY_V2PUB.request_id,
1815: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1816: program_id = HZ_UTILITY_V2PUB.program_id,
1817: program_update_date = sysdate

Line 1814: request_id = HZ_UTILITY_V2PUB.request_id,

1810: SET PARTY_ID = p_To_FK_ID,
1811: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1812: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1813: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1814: request_id = HZ_UTILITY_V2PUB.request_id,
1815: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1816: program_id = HZ_UTILITY_V2PUB.program_id,
1817: program_update_date = sysdate
1818: WHERE PARTY_ID = p_from_fk_id;

Line 1815: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1811: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1812: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1813: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1814: request_id = HZ_UTILITY_V2PUB.request_id,
1815: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1816: program_id = HZ_UTILITY_V2PUB.program_id,
1817: program_update_date = sysdate
1818: WHERE PARTY_ID = p_from_fk_id;
1819:

Line 1816: program_id = HZ_UTILITY_V2PUB.program_id,

1812: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1813: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1814: request_id = HZ_UTILITY_V2PUB.request_id,
1815: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1816: program_id = HZ_UTILITY_V2PUB.program_id,
1817: program_update_date = sysdate
1818: WHERE PARTY_ID = p_from_fk_id;
1819:
1820: UPDATE IEX_LITIGATIONS

Line 1822: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1818: WHERE PARTY_ID = p_from_fk_id;
1819:
1820: UPDATE IEX_LITIGATIONS
1821: SET PARTY_ID = p_To_FK_ID,
1822: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1823: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1824: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1825: request_id = HZ_UTILITY_V2PUB.request_id,
1826: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1823: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1819:
1820: UPDATE IEX_LITIGATIONS
1821: SET PARTY_ID = p_To_FK_ID,
1822: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1823: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1824: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1825: request_id = HZ_UTILITY_V2PUB.request_id,
1826: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1827: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1824: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1820: UPDATE IEX_LITIGATIONS
1821: SET PARTY_ID = p_To_FK_ID,
1822: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1823: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1824: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1825: request_id = HZ_UTILITY_V2PUB.request_id,
1826: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1827: program_id = HZ_UTILITY_V2PUB.program_id,
1828: program_update_date = sysdate

Line 1825: request_id = HZ_UTILITY_V2PUB.request_id,

1821: SET PARTY_ID = p_To_FK_ID,
1822: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1823: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1824: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1825: request_id = HZ_UTILITY_V2PUB.request_id,
1826: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1827: program_id = HZ_UTILITY_V2PUB.program_id,
1828: program_update_date = sysdate
1829: WHERE PARTY_ID = p_from_fk_id;

Line 1826: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1822: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1823: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1824: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1825: request_id = HZ_UTILITY_V2PUB.request_id,
1826: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1827: program_id = HZ_UTILITY_V2PUB.program_id,
1828: program_update_date = sysdate
1829: WHERE PARTY_ID = p_from_fk_id;
1830:

Line 1827: program_id = HZ_UTILITY_V2PUB.program_id,

1823: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1824: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1825: request_id = HZ_UTILITY_V2PUB.request_id,
1826: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1827: program_id = HZ_UTILITY_V2PUB.program_id,
1828: program_update_date = sysdate
1829: WHERE PARTY_ID = p_from_fk_id;
1830:
1831: /* end raverma 02032003 */

Line 2010: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

2006: BEGIN
2007: IF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
2008: UPDATE IEX_CASE_CONTACTS
2009: set address_id = p_to_fk_id,
2010: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
2011: last_updated_by = HZ_UTILITY_V2PUB.user_id,
2012: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
2013: request_id = HZ_UTILITY_V2PUB.request_id,
2014: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 2011: last_updated_by = HZ_UTILITY_V2PUB.user_id,

2007: IF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
2008: UPDATE IEX_CASE_CONTACTS
2009: set address_id = p_to_fk_id,
2010: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
2011: last_updated_by = HZ_UTILITY_V2PUB.user_id,
2012: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
2013: request_id = HZ_UTILITY_V2PUB.request_id,
2014: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
2015: program_id = HZ_UTILITY_V2PUB.program_id,

Line 2012: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

2008: UPDATE IEX_CASE_CONTACTS
2009: set address_id = p_to_fk_id,
2010: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
2011: last_updated_by = HZ_UTILITY_V2PUB.user_id,
2012: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
2013: request_id = HZ_UTILITY_V2PUB.request_id,
2014: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
2015: program_id = HZ_UTILITY_V2PUB.program_id,
2016: program_update_date = sysdate

Line 2013: request_id = HZ_UTILITY_V2PUB.request_id,

2009: set address_id = p_to_fk_id,
2010: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
2011: last_updated_by = HZ_UTILITY_V2PUB.user_id,
2012: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
2013: request_id = HZ_UTILITY_V2PUB.request_id,
2014: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
2015: program_id = HZ_UTILITY_V2PUB.program_id,
2016: program_update_date = sysdate
2017: where address_id = p_from_fk_id;

Line 2014: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

2010: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
2011: last_updated_by = HZ_UTILITY_V2PUB.user_id,
2012: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
2013: request_id = HZ_UTILITY_V2PUB.request_id,
2014: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
2015: program_id = HZ_UTILITY_V2PUB.program_id,
2016: program_update_date = sysdate
2017: where address_id = p_from_fk_id;
2018: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN -- merge contact_points

Line 2015: program_id = HZ_UTILITY_V2PUB.program_id,

2011: last_updated_by = HZ_UTILITY_V2PUB.user_id,
2012: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
2013: request_id = HZ_UTILITY_V2PUB.request_id,
2014: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
2015: program_id = HZ_UTILITY_V2PUB.program_id,
2016: program_update_date = sysdate
2017: where address_id = p_from_fk_id;
2018: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN -- merge contact_points
2019: UPDATE IEX_CASE_CONTACTS

Line 2021: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

2017: where address_id = p_from_fk_id;
2018: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN -- merge contact_points
2019: UPDATE IEX_CASE_CONTACTS
2020: set phone_id = p_to_fk_id,
2021: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
2022: last_updated_by = HZ_UTILITY_V2PUB.user_id,
2023: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
2024: request_id = HZ_UTILITY_V2PUB.request_id,
2025: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 2022: last_updated_by = HZ_UTILITY_V2PUB.user_id,

2018: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN -- merge contact_points
2019: UPDATE IEX_CASE_CONTACTS
2020: set phone_id = p_to_fk_id,
2021: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
2022: last_updated_by = HZ_UTILITY_V2PUB.user_id,
2023: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
2024: request_id = HZ_UTILITY_V2PUB.request_id,
2025: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
2026: program_id = HZ_UTILITY_V2PUB.program_id,

Line 2023: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

2019: UPDATE IEX_CASE_CONTACTS
2020: set phone_id = p_to_fk_id,
2021: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
2022: last_updated_by = HZ_UTILITY_V2PUB.user_id,
2023: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
2024: request_id = HZ_UTILITY_V2PUB.request_id,
2025: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
2026: program_id = HZ_UTILITY_V2PUB.program_id,
2027: program_update_date = sysdate

Line 2024: request_id = HZ_UTILITY_V2PUB.request_id,

2020: set phone_id = p_to_fk_id,
2021: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
2022: last_updated_by = HZ_UTILITY_V2PUB.user_id,
2023: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
2024: request_id = HZ_UTILITY_V2PUB.request_id,
2025: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
2026: program_id = HZ_UTILITY_V2PUB.program_id,
2027: program_update_date = sysdate
2028: where phone_id = p_from_fk_id;

Line 2025: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

2021: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
2022: last_updated_by = HZ_UTILITY_V2PUB.user_id,
2023: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
2024: request_id = HZ_UTILITY_V2PUB.request_id,
2025: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
2026: program_id = HZ_UTILITY_V2PUB.program_id,
2027: program_update_date = sysdate
2028: where phone_id = p_from_fk_id;
2029: END IF;

Line 2026: program_id = HZ_UTILITY_V2PUB.program_id,

2022: last_updated_by = HZ_UTILITY_V2PUB.user_id,
2023: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
2024: request_id = HZ_UTILITY_V2PUB.request_id,
2025: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
2026: program_id = HZ_UTILITY_V2PUB.program_id,
2027: program_update_date = sysdate
2028: where phone_id = p_from_fk_id;
2029: END IF;
2030: EXCEPTION