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.HZ_IMP_LOAD_WRAPPER dependencies on HZ_IMP_ADDRESSES_INT

Line 752: AND err.interface_table_name = ''HZ_IMP_ADDRESSES_INT''

748: AND NOT EXISTS
749: (SELECT 1 FROM HZ_IMP_TMP_ERRORS err
750: WHERE err.batch_id = :CP_BATCH_ID
751: AND err.request_id = :REQ_ID
752: AND err.interface_table_name = ''HZ_IMP_ADDRESSES_INT''
753: AND err.int_row_id = site_sg.int_row_id)
754: ';
755:
756: l_cleanup_ssm_cpt_qry VARCHAR2(4000) :=

Line 1086: UPDATE HZ_IMP_ADDRESSES_INT party

1082: EXIT;
1083: END IF;
1084:
1085: FORALL i in l_rowid.FIRST..l_rowid.LAST
1086: UPDATE HZ_IMP_ADDRESSES_INT party
1087: SET INTERFACE_STATUS = 'D'
1088: WHERE rowid=l_rowid(i);
1089:
1090: --Update child entities

Line 1306: update HZ_IMP_ADDRESSES_INT

1302: where BATCH_ID = P_BATCH_ID
1303: and PARTY_ORIG_SYSTEM = P_ORIG_SYSTEM
1304: and INTERFACE_STATUS = 'C';
1305:
1306: update HZ_IMP_ADDRESSES_INT
1307: set error_id = null,
1308: interface_status = null
1309: where BATCH_ID = P_BATCH_ID
1310: and PARTY_ORIG_SYSTEM = P_ORIG_SYSTEM

Line 1396: update HZ_IMP_ADDRESSES_INT

1392: and batch_id = P_BATCH_ID
1393: and stage in (2, 3)
1394: and status = 'C');
1395:
1396: update HZ_IMP_ADDRESSES_INT
1397: set error_id = null, interface_status = null
1398: where batch_id = P_BATCH_ID
1399: and party_orig_system = P_ORIG_SYSTEM
1400: and interface_status = 'C'

Line 1546: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

1542: when (E1_FLAG is null) then
1543: into hz_imp_errors (
1544: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
1545: values (
1546: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1547: 'HZ_IMP_INVALD_ADDR_ASSIGN')
1548: when (E2_FLAG is null) then
1549: into hz_imp_errors (
1550: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 1553: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

1549: into hz_imp_errors (
1550: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1551: token1_name, token1_value)
1552: values (
1553: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1554: 'HZ_API_MISSING_COLUMN', 'COLUMN', 'ADDRESS1')
1555: when (E3_FLAG is null) then
1556: into hz_imp_errors (
1557: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 1560: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

1556: into hz_imp_errors (
1557: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1558: token1_name, token1_value)
1559: values (
1560: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1561: 'HZ_API_MISSING_COLUMN', 'COLUMN', 'COUNTRY')
1562: when (E4_FLAG is null) then
1563: into hz_imp_errors (
1564: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 1568: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

1564: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1565: token1_name, token1_value, token2_name, token2_value, token3_name,
1566: token3_value)
1567: values (
1568: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1569: 'HZ_API_INVALID_FK', 'FK', 'LANGUAGE', 'COLUMN', 'LANGUAGE_CODE',
1570: 'TABLE', 'FND_LANGUAGES')
1571: when (E5_FLAG is null) then
1572: into hz_imp_errors (

Line 1577: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

1573: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1574: token1_name, token1_value, token2_name, token2_value, token3_name,
1575: token3_value)
1576: values (
1577: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1578: 'HZ_API_INVALID_FK', 'FK', 'TIMEZONE_CODE', 'COLUMN',
1579: 'TIMEZONE_CODE', 'TABLE', 'FND_TIMEZONES_B')
1580: when (E6_FLAG is null) then
1581: into hz_imp_errors (

Line 1585: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

1581: into hz_imp_errors (
1582: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1583: token1_name, token1_value)
1584: values (
1585: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1586: 'AR_RAPI_DESC_FLEX_INVALID', 'DEF_NAME', 'HZ_PARTY_SITES')
1587: when (E7_FLAG is null) then
1588: into hz_imp_errors (
1589: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)

Line 1591: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

1587: when (E7_FLAG is null) then
1588: into hz_imp_errors (
1589: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
1590: values (
1591: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1592: 'HZ_IMP_ADDR_NO_CORRECTION')
1593: when (E8_FLAG is null) then
1594: into hz_imp_errors (
1595: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 1599: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

1595: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1596: token1_name, token1_value, token2_name, token2_value, token3_name,
1597: token3_value)
1598: values (
1599: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1600: 'HZ_DSS_SECURITY_FAIL', 'USER_NAME', USER_NAME,
1601: 'OPER_NAME', 'UPDATE', 'OBJECT_NAME', 'HZ_PARTY_SITES')
1602: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
1603: into hz_imp_errors (

Line 1608: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

1604: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1605: token1_name, token1_value, token2_name,
1606: token2_value)
1607: values (
1608: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1609: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_PARTY_SITES_U1', 'ENTITY',
1610: 'HZ_PARTY_SITES')
1611: when (DUP_VAL_IDX_EXCEP_FLAG = 'B') then
1612: into hz_imp_errors (

Line 1616: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

1612: into hz_imp_errors (
1613: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1614: token1_name, token1_value, token2_name, token2_value)
1615: values (
1616: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1617: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_PARTY_SITES_U2', 'ENTITY',
1618: 'HZ_PARTY_SITES')
1619: when (DUP_VAL_IDX_EXCEP_FLAG = 'C') then
1620: into hz_imp_errors (

Line 1624: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

1620: into hz_imp_errors (
1621: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1622: token1_name, token1_value, token2_name, token2_value)
1623: values (
1624: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1625: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_LOCATIONS_U1', 'ENTITY', 'HZ_LOCATIONS')
1626: when (ACTION_MISMATCH_FLAG is null) then
1627: into hz_imp_errors (
1628: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)

Line 1630: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

1626: when (ACTION_MISMATCH_FLAG is null) then
1627: into hz_imp_errors (
1628: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
1629: values (
1630: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1631: 'HZ_IMP_ACTION_MISMATCH')
1632: when (MISSING_PARENT_FLAG is null) then
1633: into hz_imp_errors (
1634: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)

Line 1636: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

1632: when (MISSING_PARENT_FLAG is null) then
1633: into hz_imp_errors (
1634: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
1635: values (
1636: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1637: 'HZ_IMP_PARENT_PARTY_NOT_FOUND')
1638: when (E9_FLAG is null) then
1639: into hz_imp_errors (
1640: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)

Line 1642: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

1638: when (E9_FLAG is null) then
1639: into hz_imp_errors (
1640: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
1641: values (
1642: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1643: 'HZ_NOTALLOW_UPDATE_THIRD_PARTY')
1644: when (E10_FLAG is null) then
1645: into hz_imp_errors (
1646: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)

Line 1648: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

1644: when (E10_FLAG is null) then
1645: into hz_imp_errors (
1646: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
1647: values (
1648: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1649: 'HZ_IMP_PARENT_PARTY_NOT_FOUND')
1650: when (E11_FLAG is null) then
1651: into hz_imp_errors (
1652: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 1655: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

1651: into hz_imp_errors (
1652: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1653: token1_name, token1_value, token2_name, token2_value)
1654: values (
1655: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1656: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREATED_BY_MODULE', 'LOOKUP_TYPE',
1657: 'HZ_CREATED_BY_MODULES')
1658: select creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, E1_FLAG, E2_FLAG,
1659: E3_FLAG, E4_FLAG, E5_FLAG, E6_FLAG, E7_FLAG, E8_FLAG, E9_FLAG, E10_FLAG,

Line 1665: and e.interface_table_name = 'HZ_IMP_ADDRESSES_INT';

1661: ACTION_MISMATCH_FLAG, MISSING_PARENT_FLAG, FND_GLOBAL.USER_NAME
1662: from hz_imp_tmp_errors e
1663: where e.batch_id = P_BATCH_ID
1664: and e.request_id = P_REQUEST_ID
1665: and e.interface_table_name = 'HZ_IMP_ADDRESSES_INT';
1666:
1667: insert all
1668: when (E1_FLAG is null) then
1669: into hz_imp_errors (

Line 3235: update hz_imp_addresses_int

3231: where rowid = l_row_id(i)
3232: and l_table_name(i) = 'HZ_IMP_PARTIES_INT';
3233:
3234: ForAll i in 1..l_row_id.count
3235: update hz_imp_addresses_int
3236: set interface_status = 'E',
3237: error_id = l_error_id(i)
3238: where rowid = l_row_id(i)
3239: and l_table_name(i) = 'HZ_IMP_ADDRESSES_INT';

Line 3239: and l_table_name(i) = 'HZ_IMP_ADDRESSES_INT';

3235: update hz_imp_addresses_int
3236: set interface_status = 'E',
3237: error_id = l_error_id(i)
3238: where rowid = l_row_id(i)
3239: and l_table_name(i) = 'HZ_IMP_ADDRESSES_INT';
3240:
3241: ForAll i in 1..l_row_id.count
3242: update hz_imp_contactpts_int
3243: set interface_status = 'E',

Line 3945: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_INT');

3941: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Analyze all interface tables ' ||
3942: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3943:
3944: fnd_stats.gather_table_stats('AR', 'HZ_IMP_PARTIES_INT');
3945: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_INT');
3946: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_INT');
3947: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_INT');
3948: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_INT');
3949: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_INT');

Line 4439: select /+ index_ffs(a,hz_imp_addresses_int_n1) parallel_index(a)/

4435: from hz_imp_parties_int a
4436: where party_orig_system = :2
4437: and batch_id=:1
4438: union all -- Party Site
4439: select /*+ index_ffs(a,hz_imp_addresses_int_n1) parallel_index(a)*/
4440: party_orig_system_reference
4441: from hz_imp_addresses_int a
4442: where party_orig_system = :2
4443: and batch_id=:1

Line 4441: from hz_imp_addresses_int a

4437: and batch_id=:1
4438: union all -- Party Site
4439: select /*+ index_ffs(a,hz_imp_addresses_int_n1) parallel_index(a)*/
4440: party_orig_system_reference
4441: from hz_imp_addresses_int a
4442: where party_orig_system = :2
4443: and batch_id=:1
4444: union all -- Contact Points
4445: select /*+ index_ffs(a,hz_imp_contactpts_int_n1) parallel_index(a)*/

Line 4536: select /+ index(a,hz_imp_addresses_int_n1) /

4532: from hz_imp_parties_int a
4533: where party_orig_system = :2
4534: and batch_id=:1
4535: union all -- Party Site
4536: select /*+ index(a,hz_imp_addresses_int_n1) */
4537: party_orig_system_reference
4538: from hz_imp_addresses_int a
4539: where party_orig_system = :2
4540: and batch_id=:1

Line 4538: from hz_imp_addresses_int a

4534: and batch_id=:1
4535: union all -- Party Site
4536: select /*+ index(a,hz_imp_addresses_int_n1) */
4537: party_orig_system_reference
4538: from hz_imp_addresses_int a
4539: where party_orig_system = :2
4540: and batch_id=:1
4541: union all -- Contact Points
4542: select /*+ index(a,hz_imp_contactpts_int_n1) */