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_RELSHIPS_INT

Line 167: 'HZ_IMP_RELSHIPS_INT' table_name

163: select /*+ parallel(s) */ sub_id, obj_id, int_row_id,
164: nvl(start_date, sysdate) sd, nvl(end_date,
165: to_date('31-12-4712 00:00:01', 'DD-MM-YYYY HH24:MI:SS'))
166: ed, relationship_code rc, relationship_type rt,
167: 'HZ_IMP_RELSHIPS_INT' table_name
168: from hz_imp_relships_sg s
169: where batch_id = p_batch_id
170: and batch_mode_flag = p_batch_mode_flag
171: and action_flag = 'I'

Line 301: /* Dup rel may come from HZ_IMP_RELSHIPS_INT or HZ_IMP_CONTACTS_INT.

297: 'E'
298: );
299:
300:
301: /* Dup rel may come from HZ_IMP_RELSHIPS_INT or HZ_IMP_CONTACTS_INT.
302: So update both tables. Update interface_status to 'E' so that
303: these records will not be picked up during V+DML. Error_id column
304: in interface table will be updated later when records are
305: copied from tmp error table to error table. */

Line 307: update HZ_IMP_RELSHIPS_INT

303: these records will not be picked up during V+DML. Error_id column
304: in interface table will be updated later when records are
305: copied from tmp error table to error table. */
306: ForAll j in 1..l_int_row_id.count
307: update HZ_IMP_RELSHIPS_INT
308: set interface_status = 'E', error_id = l_err_id(j)
309: where rowid = l_int_row_id(j)
310: and l_table_name(j) = 'HZ_IMP_RELSHIPS_INT';
311:

Line 310: and l_table_name(j) = 'HZ_IMP_RELSHIPS_INT';

306: ForAll j in 1..l_int_row_id.count
307: update HZ_IMP_RELSHIPS_INT
308: set interface_status = 'E', error_id = l_err_id(j)
309: where rowid = l_int_row_id(j)
310: and l_table_name(j) = 'HZ_IMP_RELSHIPS_INT';
311:
312: ForAll j in 1..l_int_row_id.count
313: update HZ_IMP_CONTACTS_INT
314: set interface_status = 'E', error_id = l_err_id(j)

Line 464: decode(interface_table_name, 'HZ_IMP_RELSHIPS_INT', 'HZ_IMP_DUP_REL_IN_INT_ERROR',

460: insert into hz_imp_errors (
461: error_id, batch_id, request_id, interface_table_name, message_name
462: )
463: select error_id, batch_id, request_id, interface_table_name,
464: decode(interface_table_name, 'HZ_IMP_RELSHIPS_INT', 'HZ_IMP_DUP_REL_IN_INT_ERROR',
465: 'HZ_IMP_CONTACTS_INT', 'HZ_IMP_DUP_REL_IN_INT_ERROR',
466: 'HZ_IMP_ADDRESSUSES_INT', 'HZ_IMP_DUP_ADDRUSE_IN_INT',
467: 'HZ_IMP_CLASSIFICS_INT', decode(e38_flag, 'M', 'HZ_API_ALLOW_MUL_ASSIGN_FG',
468: 'HZ_IMP_DUP_CLASSIFIC_IN_INT')

Line 473: and interface_table_name in ('HZ_IMP_RELSHIPS_INT', 'HZ_IMP_CONTACTS_INT',

469: )
470: from hz_imp_tmp_errors
471: where batch_id = P_BATCH_ID
472: and request_id = P_REQUEST_ID
473: and interface_table_name in ('HZ_IMP_RELSHIPS_INT', 'HZ_IMP_CONTACTS_INT',
474: 'HZ_IMP_ADDRESSUSES_INT', 'HZ_IMP_CLASSIFICS_INT');
475:
476: COMMIT;
477: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1150: UPDATE HZ_IMP_RELSHIPS_INT

1146: AND party_orig_system_reference = l_posr(i);
1147:
1148: -- Update relationship records
1149: FORALL i in l_posr.FIRST..l_posr.LAST
1150: UPDATE HZ_IMP_RELSHIPS_INT
1151: SET interface_status = 'D'
1152: WHERE batch_id = p_batch_id
1153: AND ((sub_orig_system = l_pos(i)
1154: AND sub_orig_system_reference = l_posr(i))

Line 1348: update HZ_IMP_RELSHIPS_INT

1344: where BATCH_ID = P_BATCH_ID
1345: and PARTY_ORIG_SYSTEM = P_ORIG_SYSTEM
1346: and INTERFACE_STATUS = 'C';
1347:
1348: update HZ_IMP_RELSHIPS_INT
1349: set error_id = null,
1350: interface_status = null
1351: where BATCH_ID = P_BATCH_ID
1352: and SUB_ORIG_SYSTEM = P_ORIG_SYSTEM

Line 1480: update HZ_IMP_RELSHIPS_INT

1476: and batch_id = P_BATCH_ID
1477: and stage = 3
1478: and status = 'C');
1479:
1480: update HZ_IMP_RELSHIPS_INT
1481: set error_id = null, interface_status = null
1482: where batch_id = P_BATCH_ID
1483: and sub_orig_system = P_ORIG_SYSTEM
1484: and interface_status = 'C'

Line 2250: 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_RELSHIPS_INT',

2246: into hz_imp_errors (
2247: 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,
2248: token1_name, token1_value)
2249: values (
2250: 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_RELSHIPS_INT',
2251: 'HZ_IMP_REL_SUBJ_OBJ_ERROR', 'SUB_OR_OBJ', 'SUBJECT')
2252: when (E2_FLAG is null) then
2253: into hz_imp_errors (
2254: 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 2257: 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_RELSHIPS_INT',

2253: into hz_imp_errors (
2254: 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,
2255: token1_name, token1_value)
2256: values (
2257: 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_RELSHIPS_INT',
2258: 'HZ_IMP_REL_SUBJ_OBJ_ERROR', 'SUB_OR_OBJ', 'OBJECT')
2259: when (E3_FLAG is null) then
2260: into hz_imp_errors (
2261: 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 2263: 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_RELSHIPS_INT',

2259: when (E3_FLAG is null) then
2260: into hz_imp_errors (
2261: 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)
2262: values (
2263: 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_RELSHIPS_INT',
2264: 'HZ_IMP_REL_TYPE_ERROR')
2265: when (E4_FLAG is null) then
2266: into hz_imp_errors (
2267: 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 2270: 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_RELSHIPS_INT',

2266: into hz_imp_errors (
2267: 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,
2268: token1_name, token1_value, token2_name, token2_value)
2269: values (
2270: 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_RELSHIPS_INT',
2271: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'RELATIONSHIP_CODE',
2272: 'LOOKUP_TYPE', 'PARTY_RELATIONS_TYPE')
2273: when (E5_FLAG is null) then
2274: into hz_imp_errors (

Line 2278: 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_RELSHIPS_INT',

2274: into hz_imp_errors (
2275: 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,
2276: token1_name, token1_value, token2_name, token2_value)
2277: values (
2278: 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_RELSHIPS_INT',
2279: 'HZ_API_DATE_GREATER', 'DATE2', 'END_DATE', 'DATE1', 'START_DATE')
2280: when (E6_FLAG is null) then
2281: into hz_imp_errors (
2282: 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 2284: 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_RELSHIPS_INT',

2280: when (E6_FLAG is null) then
2281: into hz_imp_errors (
2282: 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)
2283: values (
2284: 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_RELSHIPS_INT',
2285: 'HZ_IMP_HIERARCHICAL_FLAG_ERROR')
2286: when (E7_FLAG is null) then
2287: into hz_imp_errors (
2288: 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 2290: 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_RELSHIPS_INT',

2286: when (E7_FLAG is null) then
2287: into hz_imp_errors (
2288: 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)
2289: values (
2290: 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_RELSHIPS_INT',
2291: 'HZ_API_SUBJECT_OBJECT_IDS')
2292: when (E8_FLAG is null) then
2293: into hz_imp_errors (
2294: 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 2296: 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_RELSHIPS_INT',

2292: when (E8_FLAG is null) then
2293: into hz_imp_errors (
2294: 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)
2295: values (
2296: 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_RELSHIPS_INT',
2297: 'HZ_RELATIONSHIP_DATE_OVERLAP')
2298: when (E9_FLAG is null) then
2299: into hz_imp_errors (
2300: 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 2303: 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_RELSHIPS_INT',

2299: into hz_imp_errors (
2300: 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,
2301: token1_name, token1_value)
2302: values (
2303: 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_RELSHIPS_INT',
2304: 'AR_RAPI_DESC_FLEX_INVALID', 'DFF_NAME', 'HZ_RELATIONSHIPS')
2305: when (E10_FLAG is null) then
2306: into hz_imp_errors (
2307: 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 2310: 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_RELSHIPS_INT',

2306: into hz_imp_errors (
2307: 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,
2308: token1_name, token1_value)
2309: values (
2310: 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_RELSHIPS_INT',
2311: 'HZ_DSS_NO_UPDATE_PRIVILEGE', 'ENTITY_NAME', l_dss_rel_err)
2312: when (E11_FLAG is null) then
2313: into hz_imp_errors (
2314: 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 2317: 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_RELSHIPS_INT',

2313: into hz_imp_errors (
2314: 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,
2315: token1_name, token1_value, token2_name, token2_value)
2316: values (
2317: 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_RELSHIPS_INT',
2318: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREATED_BY_MODULE', 'LOOKUP_TYPE',
2319: 'HZ_CREATED_BY_MODULES')
2320: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
2321: into hz_imp_errors (

Line 2325: 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_RELSHIPS_INT',

2321: into hz_imp_errors (
2322: 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,
2323: token1_name, token1_value, token2_name, token2_value)
2324: values (
2325: 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_RELSHIPS_INT',
2326: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_RELATIONSHIPS_U1', 'ENTITY',
2327: 'HZ_RELATIONSHIPS')
2328: when (ACTION_MISMATCH_FLAG is null) then
2329: into hz_imp_errors (

Line 2332: 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_RELSHIPS_INT',

2328: when (ACTION_MISMATCH_FLAG is null) then
2329: into hz_imp_errors (
2330: 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)
2331: values (
2332: 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_RELSHIPS_INT',
2333: 'HZ_IMP_ACTION_MISMATCH')
2334: select /*+ leading(e) use_nl(int) rowid(int) */ e.creation_date, e.created_by, e.last_update_date, e.last_updated_by, e.last_update_login, e.program_application_id,
2335: e.program_id, e.program_update_date, e.error_id, e.batch_id, e.request_id, e.interface_table_name, E1_FLAG, E2_FLAG,
2336: E3_FLAG, E4_FLAG, E5_FLAG, E6_FLAG, E7_FLAG, E8_FLAG, E9_FLAG,

Line 2340: HZ_IMP_RELSHIPS_INT int

2336: E3_FLAG, E4_FLAG, E5_FLAG, E6_FLAG, E7_FLAG, E8_FLAG, E9_FLAG,
2337: E10_FLAG, E11_FLAG, DUP_VAL_IDX_EXCEP_FLAG, ACTION_MISMATCH_FLAG,
2338: FND_GLOBAL.USER_NAME, INT.START_DATE, INT.END_DATE
2339: from hz_imp_tmp_errors e,
2340: HZ_IMP_RELSHIPS_INT int
2341: where e.batch_id = P_BATCH_ID
2342: and e.request_id = P_REQUEST_ID
2343: and e.int_row_id = int.rowid
2344: and e.interface_table_name = 'HZ_IMP_RELSHIPS_INT';

Line 2344: and e.interface_table_name = 'HZ_IMP_RELSHIPS_INT';

2340: HZ_IMP_RELSHIPS_INT int
2341: where e.batch_id = P_BATCH_ID
2342: and e.request_id = P_REQUEST_ID
2343: and e.int_row_id = int.rowid
2344: and e.interface_table_name = 'HZ_IMP_RELSHIPS_INT';
2345:
2346: insert all
2347: when (E1_FLAG is null) then
2348: into hz_imp_errors (

Line 3298: update hz_imp_relships_int

3294: where rowid = l_row_id(i)
3295: and l_table_name(i) = 'HZ_IMP_CLASSIFICS_INT';
3296:
3297: ForAll i in 1..l_row_id.count
3298: update hz_imp_relships_int
3299: set interface_status = 'E',
3300: error_id = l_error_id(i)
3301: where rowid = l_row_id(i)
3302: and l_table_name(i) = 'HZ_IMP_RELSHIPS_INT';

Line 3302: and l_table_name(i) = 'HZ_IMP_RELSHIPS_INT';

3298: update hz_imp_relships_int
3299: set interface_status = 'E',
3300: error_id = l_error_id(i)
3301: where rowid = l_row_id(i)
3302: and l_table_name(i) = 'HZ_IMP_RELSHIPS_INT';
3303:
3304: COMMIT;
3305:
3306: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 3954: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_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:
3957: /* Stage 1 preprocess before calling parties matching */
3958: IF P_RERUN_FLAG = 'U' OR P_RERUN_FLAG = 'L' THEN

Line 4475: select /+ index_ffs(a,hz_imp_relships_int_n1) parallel_index(a)/

4471: from hz_imp_classifics_int a
4472: where party_orig_system = :2
4473: and batch_id=:1
4474: union all -- Relationships
4475: select /*+ index_ffs(a,hz_imp_relships_int_n1) parallel_index(a)*/
4476: sub_orig_system_reference party_orig_system_reference
4477: from hz_imp_relships_int a
4478: where sub_orig_system = :2
4479: and batch_id=:1

Line 4477: from hz_imp_relships_int a

4473: and batch_id=:1
4474: union all -- Relationships
4475: select /*+ index_ffs(a,hz_imp_relships_int_n1) parallel_index(a)*/
4476: sub_orig_system_reference party_orig_system_reference
4477: from hz_imp_relships_int a
4478: where sub_orig_system = :2
4479: and batch_id=:1
4480: union all -- Contacts
4481: select /*+ index_ffs(a,hz_imp_contacts_int_n1) parallel_index(a)*/

Line 4572: select /+ index(a,hz_imp_relships_int_n1) /

4568: from hz_imp_classifics_int a
4569: where party_orig_system = :2
4570: and batch_id=:1
4571: union all -- Relationships
4572: select /*+ index(a,hz_imp_relships_int_n1) */
4573: sub_orig_system_reference party_orig_system_reference
4574: from hz_imp_relships_int a
4575: where sub_orig_system = :2
4576: and batch_id=:1

Line 4574: from hz_imp_relships_int a

4570: and batch_id=:1
4571: union all -- Relationships
4572: select /*+ index(a,hz_imp_relships_int_n1) */
4573: sub_orig_system_reference party_orig_system_reference
4574: from hz_imp_relships_int a
4575: where sub_orig_system = :2
4576: and batch_id=:1
4577: union all -- Contacts
4578: select /*+ index(a,hz_imp_contacts_int_n1) */