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_FINNUMBERS_INT

Line 1179: UPDATE HZ_IMP_FINNUMBERS_INT

1175: AND party_orig_system_reference = l_posr(i);
1176:
1177: --Update Financial Numbers
1178: FORALL i in l_posr.FIRST..l_posr.LAST
1179: UPDATE HZ_IMP_FINNUMBERS_INT
1180: SET interface_status = 'D'
1181: WHERE batch_id = p_batch_id AND Nvl(party_id,l_pid(i)) = l_pid(i)
1182: AND party_orig_system = l_pos(i)
1183: AND party_orig_system_reference = l_posr(i);

Line 1341: update HZ_IMP_FINNUMBERS_INT

1337: where BATCH_ID = P_BATCH_ID
1338: and PARTY_ORIG_SYSTEM = P_ORIG_SYSTEM
1339: and INTERFACE_STATUS = 'C';
1340:
1341: update HZ_IMP_FINNUMBERS_INT
1342: set error_id = null,
1343: interface_status = null
1344: where BATCH_ID = P_BATCH_ID
1345: and PARTY_ORIG_SYSTEM = P_ORIG_SYSTEM

Line 1466: update HZ_IMP_FINNUMBERS_INT

1462: and batch_id = P_BATCH_ID
1463: and stage = 3
1464: and status = 'C');
1465:
1466: update HZ_IMP_FINNUMBERS_INT
1467: set error_id = null, interface_status = null
1468: where batch_id = P_BATCH_ID
1469: and party_orig_system = P_ORIG_SYSTEM
1470: and interface_status = 'C'

Line 1850: 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_FINNUMBERS_INT',

1846: into hz_imp_errors (
1847: 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,
1848: token1_name, token1_value, token2_name, token2_value)
1849: values (
1850: 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_FINNUMBERS_INT',
1851: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FINANCIAL_NUMBER_NAME',
1852: 'LOOKUP_TYPE', 'FIN_NUM_NAME')
1853: when (E2_FLAG is null) then
1854: into hz_imp_errors (

Line 1858: 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_FINNUMBERS_INT',

1854: into hz_imp_errors (
1855: 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,
1856: token1_name, token1_value, token2_name, token2_value)
1857: values (
1858: 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_FINNUMBERS_INT',
1859: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREATED_BY_MODULE', 'LOOKUP_TYPE',
1860: 'HZ_CREATED_BY_MODULES')
1861: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
1862: into hz_imp_errors (

Line 1866: 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_FINNUMBERS_INT',

1862: into hz_imp_errors (
1863: 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,
1864: token1_name, token1_value, token2_name, token2_value)
1865: values (
1866: 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_FINNUMBERS_INT',
1867: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_FINANCIAL_NUMBERS_U1', 'ENTITY',
1868: 'HZ_FINANCIAL_NUMBERS')
1869: when (DUP_VAL_IDX_EXCEP_FLAG = 'B') then
1870: into hz_imp_errors (

Line 1874: 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_FINNUMBERS_INT',

1870: into hz_imp_errors (
1871: 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,
1872: token1_name, token1_value, token2_name, token2_value)
1873: values (
1874: 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_FINNUMBERS_INT',
1875: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_FINANCIAL_NUMBERS_U2', 'ENTITY',
1876: 'HZ_FINANCIAL_NUMBERS')
1877: when (ACTION_MISMATCH_FLAG is null) then
1878: into hz_imp_errors (

Line 1881: 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_FINNUMBERS_INT',

1877: when (ACTION_MISMATCH_FLAG is null) then
1878: into hz_imp_errors (
1879: 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)
1880: values (
1881: 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_FINNUMBERS_INT',
1882: 'HZ_IMP_ACTION_MISMATCH')
1883: when (MISSING_PARENT_FLAG is null) then
1884: into hz_imp_errors (
1885: 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 1887: 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_FINNUMBERS_INT',

1883: when (MISSING_PARENT_FLAG is null) then
1884: into hz_imp_errors (
1885: 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)
1886: values (
1887: 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_FINNUMBERS_INT',
1888: 'HZ_IMP_FINREPORT_NOT_FOUND')
1889: 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,
1890: DUP_VAL_IDX_EXCEP_FLAG, ACTION_MISMATCH_FLAG, MISSING_PARENT_FLAG
1891: from hz_imp_tmp_errors e

Line 1894: and e.interface_table_name = 'HZ_IMP_FINNUMBERS_INT';

1890: DUP_VAL_IDX_EXCEP_FLAG, ACTION_MISMATCH_FLAG, MISSING_PARENT_FLAG
1891: from hz_imp_tmp_errors e
1892: where e.batch_id = P_BATCH_ID
1893: and e.request_id = P_REQUEST_ID
1894: and e.interface_table_name = 'HZ_IMP_FINNUMBERS_INT';
1895:
1896: insert all
1897: when (E1_FLAG is null) then
1898: into hz_imp_errors (

Line 3277: update hz_imp_finnumbers_int

3273: where rowid = l_row_id(i)
3274: and l_table_name(i) = 'HZ_IMP_FINREPORTS_INT';
3275:
3276: ForAll i in 1..l_row_id.count
3277: update hz_imp_finnumbers_int
3278: set interface_status = 'E',
3279: error_id = l_error_id(i)
3280: where rowid = l_row_id(i)
3281: and l_table_name(i) = 'HZ_IMP_FINNUMBERS_INT';

Line 3281: and l_table_name(i) = 'HZ_IMP_FINNUMBERS_INT';

3277: update hz_imp_finnumbers_int
3278: set interface_status = 'E',
3279: error_id = l_error_id(i)
3280: where rowid = l_row_id(i)
3281: and l_table_name(i) = 'HZ_IMP_FINNUMBERS_INT';
3282:
3283: ForAll i in 1..l_row_id.count
3284: update hz_imp_creditrtngs_int
3285: set interface_status = 'E',

Line 3952: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_INT');

3948: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_INT');
3949: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_INT');
3950: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_INT');
3951: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_INT');
3952: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_INT');
3953: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_INT');
3954: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_INT');
3955: END IF;
3956:

Line 4463: select /+ index_ffs(a,hz_imp_finnumbers_int_n1) parallel_index(a)/

4459: from hz_imp_finreports_int a
4460: where party_orig_system = :2
4461: and batch_id=:1
4462: union all -- Financial Numbers
4463: select /*+ index_ffs(a,hz_imp_finnumbers_int_n1) parallel_index(a)*/
4464: party_orig_system_reference
4465: from hz_imp_finnumbers_int a
4466: where party_orig_system = :2
4467: and batch_id=:1

Line 4465: from hz_imp_finnumbers_int a

4461: and batch_id=:1
4462: union all -- Financial Numbers
4463: select /*+ index_ffs(a,hz_imp_finnumbers_int_n1) parallel_index(a)*/
4464: party_orig_system_reference
4465: from hz_imp_finnumbers_int a
4466: where party_orig_system = :2
4467: and batch_id=:1
4468: union all -- Code Assignments
4469: select /*+ index_ffs(a,hz_imp_classifics_int_n1) parallel_index(a)*/

Line 4560: select /+ index(a,hz_imp_finnumbers_int_n1) /

4556: from hz_imp_finreports_int a
4557: where party_orig_system = :2
4558: and batch_id=:1
4559: union all -- Financial Numbers
4560: select /*+ index(a,hz_imp_finnumbers_int_n1) */
4561: party_orig_system_reference
4562: from hz_imp_finnumbers_int a
4563: where party_orig_system = :2
4564: and batch_id=:1

Line 4562: from hz_imp_finnumbers_int a

4558: and batch_id=:1
4559: union all -- Financial Numbers
4560: select /*+ index(a,hz_imp_finnumbers_int_n1) */
4561: party_orig_system_reference
4562: from hz_imp_finnumbers_int a
4563: where party_orig_system = :2
4564: and batch_id=:1
4565: union all -- Code Assignments
4566: select /*+ index(a,hz_imp_classifics_int_n1) */