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 1548: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1544: -- do we really care if something is being "merged" or transferred?? i think not
1545: -- lets just update the table to reflect the new party_id
1546: UPDATE IEX_DELINQUENCIES_ALL
1547: SET party_cust_id = p_To_FK_id,
1548: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1549: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1550: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1551: request_id = HZ_UTILITY_V2PUB.request_id,
1552: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1549: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1545: -- lets just update the table to reflect the new party_id
1546: UPDATE IEX_DELINQUENCIES_ALL
1547: SET party_cust_id = p_To_FK_id,
1548: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1549: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1550: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1551: request_id = HZ_UTILITY_V2PUB.request_id,
1552: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1553: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1550: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1546: UPDATE IEX_DELINQUENCIES_ALL
1547: SET party_cust_id = p_To_FK_id,
1548: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1549: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1550: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1551: request_id = HZ_UTILITY_V2PUB.request_id,
1552: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1553: program_id = HZ_UTILITY_V2PUB.program_id,
1554: program_update_date = sysdate

Line 1551: request_id = HZ_UTILITY_V2PUB.request_id,

1547: SET party_cust_id = p_To_FK_id,
1548: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1549: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1550: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1551: request_id = HZ_UTILITY_V2PUB.request_id,
1552: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1553: program_id = HZ_UTILITY_V2PUB.program_id,
1554: program_update_date = sysdate
1555: WHERE party_cust_id = p_from_fk_id;

Line 1552: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1548: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1549: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1550: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1551: request_id = HZ_UTILITY_V2PUB.request_id,
1552: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1553: program_id = HZ_UTILITY_V2PUB.program_id,
1554: program_update_date = sysdate
1555: WHERE party_cust_id = p_from_fk_id;
1556:

Line 1553: program_id = HZ_UTILITY_V2PUB.program_id,

1549: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1550: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1551: request_id = HZ_UTILITY_V2PUB.request_id,
1552: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1553: program_id = HZ_UTILITY_V2PUB.program_id,
1554: program_update_date = sysdate
1555: WHERE party_cust_id = p_from_fk_id;
1556:
1557: -- begin raverma 10232001 -- add this to update promise table

Line 1560: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1556:
1557: -- begin raverma 10232001 -- add this to update promise table
1558: UPDATE IEX_PROMISE_DETAILS
1559: SET Promise_Made_By = p_To_FK_ID,
1560: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1561: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1562: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1563: request_id = HZ_UTILITY_V2PUB.request_id,
1564: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1561: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1557: -- begin raverma 10232001 -- add this to update promise table
1558: UPDATE IEX_PROMISE_DETAILS
1559: SET Promise_Made_By = p_To_FK_ID,
1560: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1561: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1562: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1563: request_id = HZ_UTILITY_V2PUB.request_id,
1564: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1565: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1562: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1558: UPDATE IEX_PROMISE_DETAILS
1559: SET Promise_Made_By = p_To_FK_ID,
1560: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1561: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1562: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1563: request_id = HZ_UTILITY_V2PUB.request_id,
1564: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1565: program_id = HZ_UTILITY_V2PUB.program_id,
1566: program_update_date = sysdate

Line 1563: request_id = HZ_UTILITY_V2PUB.request_id,

1559: SET Promise_Made_By = p_To_FK_ID,
1560: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1561: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1562: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1563: request_id = HZ_UTILITY_V2PUB.request_id,
1564: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1565: program_id = HZ_UTILITY_V2PUB.program_id,
1566: program_update_date = sysdate
1567: WHERE promise_made_by = p_from_fk_id;

Line 1564: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1560: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1561: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1562: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1563: request_id = HZ_UTILITY_V2PUB.request_id,
1564: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1565: program_id = HZ_UTILITY_V2PUB.program_id,
1566: program_update_date = sysdate
1567: WHERE promise_made_by = p_from_fk_id;
1568:

Line 1565: program_id = HZ_UTILITY_V2PUB.program_id,

1561: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1562: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1563: request_id = HZ_UTILITY_V2PUB.request_id,
1564: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1565: program_id = HZ_UTILITY_V2PUB.program_id,
1566: program_update_date = sysdate
1567: WHERE promise_made_by = p_from_fk_id;
1568:
1569: /* Begin raverma 02032003 add new party_merge entities

Line 1582: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1578: IEX_STRATEGIES
1579: */
1580: UPDATE IEX_STRATEGIES
1581: SET JTF_OBJECT_ID = p_To_FK_ID,
1582: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1583: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1584: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1585: request_id = HZ_UTILITY_V2PUB.request_id,
1586: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1583: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1579: */
1580: UPDATE IEX_STRATEGIES
1581: SET JTF_OBJECT_ID = p_To_FK_ID,
1582: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1583: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1584: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1585: request_id = HZ_UTILITY_V2PUB.request_id,
1586: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1587: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1584: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1580: UPDATE IEX_STRATEGIES
1581: SET JTF_OBJECT_ID = p_To_FK_ID,
1582: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1583: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1584: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1585: request_id = HZ_UTILITY_V2PUB.request_id,
1586: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1587: program_id = HZ_UTILITY_V2PUB.program_id,
1588: program_update_date = sysdate,

Line 1585: request_id = HZ_UTILITY_V2PUB.request_id,

1581: SET JTF_OBJECT_ID = p_To_FK_ID,
1582: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1583: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1584: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1585: request_id = HZ_UTILITY_V2PUB.request_id,
1586: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1587: program_id = HZ_UTILITY_V2PUB.program_id,
1588: program_update_date = sysdate,
1589: -- Begin - 10/12/2005 - Andre Araujo - Need to update party_id also

Line 1586: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1582: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1583: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1584: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1585: request_id = HZ_UTILITY_V2PUB.request_id,
1586: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1587: program_id = HZ_UTILITY_V2PUB.program_id,
1588: program_update_date = sysdate,
1589: -- Begin - 10/12/2005 - Andre Araujo - Need to update party_id also
1590: PARTY_ID = p_To_FK_ID

Line 1587: program_id = HZ_UTILITY_V2PUB.program_id,

1583: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1584: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1585: request_id = HZ_UTILITY_V2PUB.request_id,
1586: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1587: program_id = HZ_UTILITY_V2PUB.program_id,
1588: program_update_date = sysdate,
1589: -- Begin - 10/12/2005 - Andre Araujo - Need to update party_id also
1590: PARTY_ID = p_To_FK_ID
1591: -- End - 10/12/2005 - Andre Araujo - Need to update party_id also

Line 1597: SET last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1593: JTF_OBJECT_TYPE = 'PARTY';
1594:
1595: -- Begin - 10/12/2005 - Andre Araujo - Need to update party_id also
1596: UPDATE IEX_STRATEGIES
1597: SET last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1598: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1599: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1600: request_id = HZ_UTILITY_V2PUB.request_id,
1601: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1598: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1594:
1595: -- Begin - 10/12/2005 - Andre Araujo - Need to update party_id also
1596: UPDATE IEX_STRATEGIES
1597: SET last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1598: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1599: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1600: request_id = HZ_UTILITY_V2PUB.request_id,
1601: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1602: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1599: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1595: -- Begin - 10/12/2005 - Andre Araujo - Need to update party_id also
1596: UPDATE IEX_STRATEGIES
1597: SET last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1598: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1599: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1600: request_id = HZ_UTILITY_V2PUB.request_id,
1601: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1602: program_id = HZ_UTILITY_V2PUB.program_id,
1603: program_update_date = sysdate,

Line 1600: request_id = HZ_UTILITY_V2PUB.request_id,

1596: UPDATE IEX_STRATEGIES
1597: SET last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1598: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1599: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1600: request_id = HZ_UTILITY_V2PUB.request_id,
1601: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1602: program_id = HZ_UTILITY_V2PUB.program_id,
1603: program_update_date = sysdate,
1604: PARTY_ID = p_To_FK_ID

Line 1601: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1597: SET last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1598: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1599: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1600: request_id = HZ_UTILITY_V2PUB.request_id,
1601: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1602: program_id = HZ_UTILITY_V2PUB.program_id,
1603: program_update_date = sysdate,
1604: PARTY_ID = p_To_FK_ID
1605: WHERE PARTY_ID = p_from_fk_id;

Line 1602: program_id = HZ_UTILITY_V2PUB.program_id,

1598: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1599: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1600: request_id = HZ_UTILITY_V2PUB.request_id,
1601: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1602: program_id = HZ_UTILITY_V2PUB.program_id,
1603: program_update_date = sysdate,
1604: PARTY_ID = p_To_FK_ID
1605: WHERE PARTY_ID = p_from_fk_id;
1606: -- End - 10/12/2005 - Andre Araujo - Need to update party_id also

Line 1611: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1607:
1608:
1609: UPDATE IEX_SCORE_HISTORIES
1610: SET SCORE_OBJECT_ID = p_To_FK_ID,
1611: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1612: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1613: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1614: request_id = HZ_UTILITY_V2PUB.request_id,
1615: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1612: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1608:
1609: UPDATE IEX_SCORE_HISTORIES
1610: SET SCORE_OBJECT_ID = p_To_FK_ID,
1611: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1612: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1613: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1614: request_id = HZ_UTILITY_V2PUB.request_id,
1615: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1616: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1613: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1609: UPDATE IEX_SCORE_HISTORIES
1610: SET SCORE_OBJECT_ID = p_To_FK_ID,
1611: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1612: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1613: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1614: request_id = HZ_UTILITY_V2PUB.request_id,
1615: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1616: program_id = HZ_UTILITY_V2PUB.program_id,
1617: program_update_date = sysdate

Line 1614: request_id = HZ_UTILITY_V2PUB.request_id,

1610: SET SCORE_OBJECT_ID = p_To_FK_ID,
1611: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1612: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1613: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1614: request_id = HZ_UTILITY_V2PUB.request_id,
1615: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1616: program_id = HZ_UTILITY_V2PUB.program_id,
1617: program_update_date = sysdate
1618: WHERE SCORE_OBJECT_ID = p_from_fk_id AND

Line 1615: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1611: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1612: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1613: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1614: request_id = HZ_UTILITY_V2PUB.request_id,
1615: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1616: program_id = HZ_UTILITY_V2PUB.program_id,
1617: program_update_date = sysdate
1618: WHERE SCORE_OBJECT_ID = p_from_fk_id AND
1619: SCORE_OBJECT_CODE = 'PARTY';

Line 1616: program_id = HZ_UTILITY_V2PUB.program_id,

1612: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1613: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1614: request_id = HZ_UTILITY_V2PUB.request_id,
1615: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1616: program_id = HZ_UTILITY_V2PUB.program_id,
1617: program_update_date = sysdate
1618: WHERE SCORE_OBJECT_ID = p_from_fk_id AND
1619: SCORE_OBJECT_CODE = 'PARTY';
1620:

Line 1623: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1619: SCORE_OBJECT_CODE = 'PARTY';
1620:
1621: UPDATE IEX_REPOSSESSIONS
1622: SET PARTY_ID = p_To_FK_ID,
1623: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1624: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1625: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1626: request_id = HZ_UTILITY_V2PUB.request_id,
1627: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1624: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1620:
1621: UPDATE IEX_REPOSSESSIONS
1622: SET PARTY_ID = p_To_FK_ID,
1623: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1624: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1625: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1626: request_id = HZ_UTILITY_V2PUB.request_id,
1627: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1628: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1625: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1621: UPDATE IEX_REPOSSESSIONS
1622: SET PARTY_ID = p_To_FK_ID,
1623: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1624: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1625: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1626: request_id = HZ_UTILITY_V2PUB.request_id,
1627: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1628: program_id = HZ_UTILITY_V2PUB.program_id,
1629: program_update_date = sysdate

Line 1626: request_id = HZ_UTILITY_V2PUB.request_id,

1622: SET PARTY_ID = p_To_FK_ID,
1623: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1624: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1625: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1626: request_id = HZ_UTILITY_V2PUB.request_id,
1627: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1628: program_id = HZ_UTILITY_V2PUB.program_id,
1629: program_update_date = sysdate
1630: WHERE PARTY_ID = p_from_fk_id;

Line 1627: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1623: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1624: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1625: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1626: request_id = HZ_UTILITY_V2PUB.request_id,
1627: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1628: program_id = HZ_UTILITY_V2PUB.program_id,
1629: program_update_date = sysdate
1630: WHERE PARTY_ID = p_from_fk_id;
1631:

Line 1628: program_id = HZ_UTILITY_V2PUB.program_id,

1624: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1625: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1626: request_id = HZ_UTILITY_V2PUB.request_id,
1627: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1628: program_id = HZ_UTILITY_V2PUB.program_id,
1629: program_update_date = sysdate
1630: WHERE PARTY_ID = p_from_fk_id;
1631:
1632: UPDATE IEX_REPOSSESSIONS

Line 1634: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1630: WHERE PARTY_ID = p_from_fk_id;
1631:
1632: UPDATE IEX_REPOSSESSIONS
1633: SET REPLEVIN_ATTORNEY = p_To_FK_ID,
1634: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1635: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1636: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1637: request_id = HZ_UTILITY_V2PUB.request_id,
1638: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1635: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1631:
1632: UPDATE IEX_REPOSSESSIONS
1633: SET REPLEVIN_ATTORNEY = p_To_FK_ID,
1634: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1635: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1636: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1637: request_id = HZ_UTILITY_V2PUB.request_id,
1638: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1639: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1636: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1632: UPDATE IEX_REPOSSESSIONS
1633: SET REPLEVIN_ATTORNEY = p_To_FK_ID,
1634: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1635: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1636: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1637: request_id = HZ_UTILITY_V2PUB.request_id,
1638: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1639: program_id = HZ_UTILITY_V2PUB.program_id,
1640: program_update_date = sysdate

Line 1637: request_id = HZ_UTILITY_V2PUB.request_id,

1633: SET REPLEVIN_ATTORNEY = p_To_FK_ID,
1634: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1635: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1636: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1637: request_id = HZ_UTILITY_V2PUB.request_id,
1638: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1639: program_id = HZ_UTILITY_V2PUB.program_id,
1640: program_update_date = sysdate
1641: WHERE REPLEVIN_ATTORNEY = p_from_fk_id;

Line 1638: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1634: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1635: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1636: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1637: request_id = HZ_UTILITY_V2PUB.request_id,
1638: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1639: program_id = HZ_UTILITY_V2PUB.program_id,
1640: program_update_date = sysdate
1641: WHERE REPLEVIN_ATTORNEY = p_from_fk_id;
1642:

Line 1639: program_id = HZ_UTILITY_V2PUB.program_id,

1635: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1636: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1637: request_id = HZ_UTILITY_V2PUB.request_id,
1638: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1639: program_id = HZ_UTILITY_V2PUB.program_id,
1640: program_update_date = sysdate
1641: WHERE REPLEVIN_ATTORNEY = p_from_fk_id;
1642:
1643: UPDATE IEX_DEL_THIRD_PARTIES

Line 1645: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1641: WHERE REPLEVIN_ATTORNEY = p_from_fk_id;
1642:
1643: UPDATE IEX_DEL_THIRD_PARTIES
1644: SET THIRD_PARTY_ID = p_To_FK_ID,
1645: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1646: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1647: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1648: request_id = HZ_UTILITY_V2PUB.request_id,
1649: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1646: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1642:
1643: UPDATE IEX_DEL_THIRD_PARTIES
1644: SET THIRD_PARTY_ID = p_To_FK_ID,
1645: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1646: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1647: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1648: request_id = HZ_UTILITY_V2PUB.request_id,
1649: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1650: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1647: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1643: UPDATE IEX_DEL_THIRD_PARTIES
1644: SET THIRD_PARTY_ID = p_To_FK_ID,
1645: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1646: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1647: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1648: request_id = HZ_UTILITY_V2PUB.request_id,
1649: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1650: program_id = HZ_UTILITY_V2PUB.program_id,
1651: program_update_date = sysdate

Line 1648: request_id = HZ_UTILITY_V2PUB.request_id,

1644: SET THIRD_PARTY_ID = p_To_FK_ID,
1645: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1646: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1647: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1648: request_id = HZ_UTILITY_V2PUB.request_id,
1649: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1650: program_id = HZ_UTILITY_V2PUB.program_id,
1651: program_update_date = sysdate
1652: WHERE THIRD_PARTY_ID = p_from_fk_id;

Line 1649: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1645: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1646: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1647: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1648: request_id = HZ_UTILITY_V2PUB.request_id,
1649: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1650: program_id = HZ_UTILITY_V2PUB.program_id,
1651: program_update_date = sysdate
1652: WHERE THIRD_PARTY_ID = p_from_fk_id;
1653:

Line 1650: program_id = HZ_UTILITY_V2PUB.program_id,

1646: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1647: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1648: request_id = HZ_UTILITY_V2PUB.request_id,
1649: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1650: program_id = HZ_UTILITY_V2PUB.program_id,
1651: program_update_date = sysdate
1652: WHERE THIRD_PARTY_ID = p_from_fk_id;
1653:
1654: UPDATE IEX_CASE_CONTACTS

Line 1656: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1652: WHERE THIRD_PARTY_ID = p_from_fk_id;
1653:
1654: UPDATE IEX_CASE_CONTACTS
1655: SET CONTACT_PARTY_ID = p_To_FK_ID,
1656: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1657: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1658: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1659: request_id = HZ_UTILITY_V2PUB.request_id,
1660: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1657: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1653:
1654: UPDATE IEX_CASE_CONTACTS
1655: SET CONTACT_PARTY_ID = p_To_FK_ID,
1656: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1657: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1658: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1659: request_id = HZ_UTILITY_V2PUB.request_id,
1660: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1661: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1658: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1654: UPDATE IEX_CASE_CONTACTS
1655: SET CONTACT_PARTY_ID = p_To_FK_ID,
1656: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1657: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1658: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1659: request_id = HZ_UTILITY_V2PUB.request_id,
1660: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1661: program_id = HZ_UTILITY_V2PUB.program_id,
1662: program_update_date = sysdate

Line 1659: request_id = HZ_UTILITY_V2PUB.request_id,

1655: SET CONTACT_PARTY_ID = p_To_FK_ID,
1656: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1657: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1658: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1659: request_id = HZ_UTILITY_V2PUB.request_id,
1660: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1661: program_id = HZ_UTILITY_V2PUB.program_id,
1662: program_update_date = sysdate
1663: WHERE CONTACT_PARTY_ID = p_from_fk_id;

Line 1660: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1656: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1657: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1658: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1659: request_id = HZ_UTILITY_V2PUB.request_id,
1660: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1661: program_id = HZ_UTILITY_V2PUB.program_id,
1662: program_update_date = sysdate
1663: WHERE CONTACT_PARTY_ID = p_from_fk_id;
1664:

Line 1661: program_id = HZ_UTILITY_V2PUB.program_id,

1657: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1658: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1659: request_id = HZ_UTILITY_V2PUB.request_id,
1660: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1661: program_id = HZ_UTILITY_V2PUB.program_id,
1662: program_update_date = sysdate
1663: WHERE CONTACT_PARTY_ID = p_from_fk_id;
1664:
1665: UPDATE IEX_CASES_ALL_B

Line 1667: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1663: WHERE CONTACT_PARTY_ID = p_from_fk_id;
1664:
1665: UPDATE IEX_CASES_ALL_B
1666: SET PARTY_ID = p_To_FK_ID,
1667: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1668: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1669: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1670: request_id = HZ_UTILITY_V2PUB.request_id,
1671: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1668: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1664:
1665: UPDATE IEX_CASES_ALL_B
1666: SET PARTY_ID = p_To_FK_ID,
1667: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1668: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1669: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1670: request_id = HZ_UTILITY_V2PUB.request_id,
1671: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1672: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1669: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1665: UPDATE IEX_CASES_ALL_B
1666: SET PARTY_ID = p_To_FK_ID,
1667: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1668: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1669: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1670: request_id = HZ_UTILITY_V2PUB.request_id,
1671: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1672: program_id = HZ_UTILITY_V2PUB.program_id,
1673: program_update_date = sysdate

Line 1670: request_id = HZ_UTILITY_V2PUB.request_id,

1666: SET PARTY_ID = p_To_FK_ID,
1667: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1668: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1669: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1670: request_id = HZ_UTILITY_V2PUB.request_id,
1671: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1672: program_id = HZ_UTILITY_V2PUB.program_id,
1673: program_update_date = sysdate
1674: WHERE PARTY_ID = p_from_fk_id;

Line 1671: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1667: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1668: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1669: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1670: request_id = HZ_UTILITY_V2PUB.request_id,
1671: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1672: program_id = HZ_UTILITY_V2PUB.program_id,
1673: program_update_date = sysdate
1674: WHERE PARTY_ID = p_from_fk_id;
1675:

Line 1672: program_id = HZ_UTILITY_V2PUB.program_id,

1668: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1669: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1670: request_id = HZ_UTILITY_V2PUB.request_id,
1671: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1672: program_id = HZ_UTILITY_V2PUB.program_id,
1673: program_update_date = sysdate
1674: WHERE PARTY_ID = p_from_fk_id;
1675:
1676: UPDATE IEX_WRITEOFFS

Line 1678: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1674: WHERE PARTY_ID = p_from_fk_id;
1675:
1676: UPDATE IEX_WRITEOFFS
1677: SET PARTY_ID = p_To_FK_ID,
1678: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1679: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1680: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1681: request_id = HZ_UTILITY_V2PUB.request_id,
1682: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1679: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1675:
1676: UPDATE IEX_WRITEOFFS
1677: SET PARTY_ID = p_To_FK_ID,
1678: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1679: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1680: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1681: request_id = HZ_UTILITY_V2PUB.request_id,
1682: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1683: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1680: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1676: UPDATE IEX_WRITEOFFS
1677: SET PARTY_ID = p_To_FK_ID,
1678: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1679: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1680: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1681: request_id = HZ_UTILITY_V2PUB.request_id,
1682: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1683: program_id = HZ_UTILITY_V2PUB.program_id,
1684: program_update_date = sysdate

Line 1681: request_id = HZ_UTILITY_V2PUB.request_id,

1677: SET PARTY_ID = p_To_FK_ID,
1678: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1679: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1680: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1681: request_id = HZ_UTILITY_V2PUB.request_id,
1682: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1683: program_id = HZ_UTILITY_V2PUB.program_id,
1684: program_update_date = sysdate
1685: WHERE PARTY_ID = p_from_fk_id;

Line 1682: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1678: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1679: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1680: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1681: request_id = HZ_UTILITY_V2PUB.request_id,
1682: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1683: program_id = HZ_UTILITY_V2PUB.program_id,
1684: program_update_date = sysdate
1685: WHERE PARTY_ID = p_from_fk_id;
1686:

Line 1683: program_id = HZ_UTILITY_V2PUB.program_id,

1679: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1680: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1681: request_id = HZ_UTILITY_V2PUB.request_id,
1682: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1683: program_id = HZ_UTILITY_V2PUB.program_id,
1684: program_update_date = sysdate
1685: WHERE PARTY_ID = p_from_fk_id;
1686:
1687: UPDATE IEX_BANKRUPTCIES

Line 1689: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1685: WHERE PARTY_ID = p_from_fk_id;
1686:
1687: UPDATE IEX_BANKRUPTCIES
1688: SET PARTY_ID = p_To_FK_ID,
1689: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1690: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1691: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1692: request_id = HZ_UTILITY_V2PUB.request_id,
1693: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1690: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1686:
1687: UPDATE IEX_BANKRUPTCIES
1688: SET PARTY_ID = p_To_FK_ID,
1689: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1690: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1691: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1692: request_id = HZ_UTILITY_V2PUB.request_id,
1693: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1694: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1691: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1687: UPDATE IEX_BANKRUPTCIES
1688: SET PARTY_ID = p_To_FK_ID,
1689: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1690: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1691: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1692: request_id = HZ_UTILITY_V2PUB.request_id,
1693: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1694: program_id = HZ_UTILITY_V2PUB.program_id,
1695: program_update_date = sysdate

Line 1692: request_id = HZ_UTILITY_V2PUB.request_id,

1688: SET PARTY_ID = p_To_FK_ID,
1689: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1690: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1691: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1692: request_id = HZ_UTILITY_V2PUB.request_id,
1693: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1694: program_id = HZ_UTILITY_V2PUB.program_id,
1695: program_update_date = sysdate
1696: WHERE PARTY_ID = p_from_fk_id;

Line 1693: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1689: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1690: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1691: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1692: request_id = HZ_UTILITY_V2PUB.request_id,
1693: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1694: program_id = HZ_UTILITY_V2PUB.program_id,
1695: program_update_date = sysdate
1696: WHERE PARTY_ID = p_from_fk_id;
1697:

Line 1694: program_id = HZ_UTILITY_V2PUB.program_id,

1690: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1691: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1692: request_id = HZ_UTILITY_V2PUB.request_id,
1693: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1694: program_id = HZ_UTILITY_V2PUB.program_id,
1695: program_update_date = sysdate
1696: WHERE PARTY_ID = p_from_fk_id;
1697:
1698: UPDATE IEX_LITIGATIONS

Line 1700: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1696: WHERE PARTY_ID = p_from_fk_id;
1697:
1698: UPDATE IEX_LITIGATIONS
1699: SET PARTY_ID = p_To_FK_ID,
1700: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1701: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1702: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1703: request_id = HZ_UTILITY_V2PUB.request_id,
1704: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1701: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1697:
1698: UPDATE IEX_LITIGATIONS
1699: SET PARTY_ID = p_To_FK_ID,
1700: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1701: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1702: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1703: request_id = HZ_UTILITY_V2PUB.request_id,
1704: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1705: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1702: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1698: UPDATE IEX_LITIGATIONS
1699: SET PARTY_ID = p_To_FK_ID,
1700: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1701: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1702: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1703: request_id = HZ_UTILITY_V2PUB.request_id,
1704: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1705: program_id = HZ_UTILITY_V2PUB.program_id,
1706: program_update_date = sysdate

Line 1703: request_id = HZ_UTILITY_V2PUB.request_id,

1699: SET PARTY_ID = p_To_FK_ID,
1700: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1701: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1702: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1703: request_id = HZ_UTILITY_V2PUB.request_id,
1704: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1705: program_id = HZ_UTILITY_V2PUB.program_id,
1706: program_update_date = sysdate
1707: WHERE PARTY_ID = p_from_fk_id;

Line 1704: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1700: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1701: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1702: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1703: request_id = HZ_UTILITY_V2PUB.request_id,
1704: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1705: program_id = HZ_UTILITY_V2PUB.program_id,
1706: program_update_date = sysdate
1707: WHERE PARTY_ID = p_from_fk_id;
1708:

Line 1705: program_id = HZ_UTILITY_V2PUB.program_id,

1701: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1702: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1703: request_id = HZ_UTILITY_V2PUB.request_id,
1704: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1705: program_id = HZ_UTILITY_V2PUB.program_id,
1706: program_update_date = sysdate
1707: WHERE PARTY_ID = p_from_fk_id;
1708:
1709: /* end raverma 02032003 */

Line 1888: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1884: BEGIN
1885: IF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
1886: UPDATE IEX_CASE_CONTACTS
1887: set address_id = p_to_fk_id,
1888: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1889: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1890: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1891: request_id = HZ_UTILITY_V2PUB.request_id,
1892: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1889: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1885: IF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
1886: UPDATE IEX_CASE_CONTACTS
1887: set address_id = p_to_fk_id,
1888: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1889: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1890: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1891: request_id = HZ_UTILITY_V2PUB.request_id,
1892: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1893: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1890: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1886: UPDATE IEX_CASE_CONTACTS
1887: set address_id = p_to_fk_id,
1888: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1889: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1890: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1891: request_id = HZ_UTILITY_V2PUB.request_id,
1892: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1893: program_id = HZ_UTILITY_V2PUB.program_id,
1894: program_update_date = sysdate

Line 1891: request_id = HZ_UTILITY_V2PUB.request_id,

1887: set address_id = p_to_fk_id,
1888: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1889: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1890: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1891: request_id = HZ_UTILITY_V2PUB.request_id,
1892: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1893: program_id = HZ_UTILITY_V2PUB.program_id,
1894: program_update_date = sysdate
1895: where address_id = p_from_fk_id;

Line 1892: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1888: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1889: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1890: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1891: request_id = HZ_UTILITY_V2PUB.request_id,
1892: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1893: program_id = HZ_UTILITY_V2PUB.program_id,
1894: program_update_date = sysdate
1895: where address_id = p_from_fk_id;
1896: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN -- merge contact_points

Line 1893: program_id = HZ_UTILITY_V2PUB.program_id,

1889: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1890: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1891: request_id = HZ_UTILITY_V2PUB.request_id,
1892: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1893: program_id = HZ_UTILITY_V2PUB.program_id,
1894: program_update_date = sysdate
1895: where address_id = p_from_fk_id;
1896: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN -- merge contact_points
1897: UPDATE IEX_CASE_CONTACTS

Line 1899: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

1895: where address_id = p_from_fk_id;
1896: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN -- merge contact_points
1897: UPDATE IEX_CASE_CONTACTS
1898: set phone_id = p_to_fk_id,
1899: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1900: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1901: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1902: request_id = HZ_UTILITY_V2PUB.request_id,
1903: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

Line 1900: last_updated_by = HZ_UTILITY_V2PUB.user_id,

1896: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN -- merge contact_points
1897: UPDATE IEX_CASE_CONTACTS
1898: set phone_id = p_to_fk_id,
1899: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1900: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1901: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1902: request_id = HZ_UTILITY_V2PUB.request_id,
1903: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1904: program_id = HZ_UTILITY_V2PUB.program_id,

Line 1901: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

1897: UPDATE IEX_CASE_CONTACTS
1898: set phone_id = p_to_fk_id,
1899: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1900: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1901: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1902: request_id = HZ_UTILITY_V2PUB.request_id,
1903: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1904: program_id = HZ_UTILITY_V2PUB.program_id,
1905: program_update_date = sysdate

Line 1902: request_id = HZ_UTILITY_V2PUB.request_id,

1898: set phone_id = p_to_fk_id,
1899: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1900: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1901: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1902: request_id = HZ_UTILITY_V2PUB.request_id,
1903: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1904: program_id = HZ_UTILITY_V2PUB.program_id,
1905: program_update_date = sysdate
1906: where phone_id = p_from_fk_id;

Line 1903: program_application_id = HZ_UTILITY_V2PUB.program_application_id,

1899: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1900: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1901: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1902: request_id = HZ_UTILITY_V2PUB.request_id,
1903: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1904: program_id = HZ_UTILITY_V2PUB.program_id,
1905: program_update_date = sysdate
1906: where phone_id = p_from_fk_id;
1907: END IF;

Line 1904: program_id = HZ_UTILITY_V2PUB.program_id,

1900: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1901: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1902: request_id = HZ_UTILITY_V2PUB.request_id,
1903: program_application_id = HZ_UTILITY_V2PUB.program_application_id,
1904: program_id = HZ_UTILITY_V2PUB.program_id,
1905: program_update_date = sysdate
1906: where phone_id = p_from_fk_id;
1907: END IF;
1908: EXCEPTION