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.

[Home] [Help]

APPS.HZ_IMP_LOAD_WRAPPER dependencies on HZ_IMP_CONTACTS_INT

Line 177: 'HZ_IMP_CONTACTS_INT' table_name

173: select /*+ parallel(s) */ sub_id, obj_id, int_row_id,
174: nvl(start_date, sysdate) sd, nvl(end_date,
175: to_date('31-12-4712 00:00:01', 'DD-MM-YYYY HH24:MI:SS'))
176: ed, relationship_code rc, relationship_type rt,
177: 'HZ_IMP_CONTACTS_INT' table_name
178: from hz_imp_contacts_sg s
179: where batch_id = p_batch_id
180: and batch_mode_flag = p_batch_mode_flag
181: 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 313: update HZ_IMP_CONTACTS_INT

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)
315: where rowid = l_int_row_id(j)
316: and l_table_name(j) = 'HZ_IMP_CONTACTS_INT';
317:

Line 316: and l_table_name(j) = 'HZ_IMP_CONTACTS_INT';

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)
315: where rowid = l_int_row_id(j)
316: and l_table_name(j) = 'HZ_IMP_CONTACTS_INT';
317:
318: CLOSE dup_rel;
319:
320:

Line 465: 'HZ_IMP_CONTACTS_INT', 'HZ_IMP_DUP_REL_IN_INT_ERROR',

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')
469: )

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 1123: UPDATE HZ_IMP_CONTACTS_INT

1119:
1120: -- Update child entities
1121: --Update contact records
1122: FORALL i in l_posr.FIRST..l_posr.LAST
1123: UPDATE HZ_IMP_CONTACTS_INT
1124: SET interface_status = 'D'
1125: WHERE batch_id = p_batch_id
1126: AND ((sub_orig_system = l_pos(i)
1127: AND sub_orig_system_reference = l_posr(i))

Line 1355: update HZ_IMP_CONTACTS_INT

1351: where BATCH_ID = P_BATCH_ID
1352: and SUB_ORIG_SYSTEM = P_ORIG_SYSTEM
1353: and INTERFACE_STATUS = 'C';
1354:
1355: update HZ_IMP_CONTACTS_INT
1356: set error_id = null,
1357: interface_status = null
1358: where BATCH_ID = P_BATCH_ID
1359: and SUB_ORIG_SYSTEM = P_ORIG_SYSTEM

Line 1494: update HZ_IMP_CONTACTS_INT

1490: and batch_id = P_BATCH_ID
1491: and stage = 3
1492: and status = 'C');
1493:
1494: update HZ_IMP_CONTACTS_INT
1495: set error_id = null, interface_status = null
1496: where batch_id = P_BATCH_ID
1497: and sub_orig_system = P_ORIG_SYSTEM
1498: and interface_status = 'C'

Line 2352: 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_CONTACTS_INT',

2348: into hz_imp_errors (
2349: 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,
2350: token1_name, token1_value)
2351: values (
2352: 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_CONTACTS_INT',
2353: 'HZ_IMP_REL_SUBJ_OBJ_ERROR', 'SUB_OR_OBJ', 'SUBJECT')
2354: when (E2_FLAG is null) then
2355: into hz_imp_errors (
2356: 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 2359: 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_CONTACTS_INT',

2355: into hz_imp_errors (
2356: 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,
2357: token1_name, token1_value)
2358: values (
2359: 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_CONTACTS_INT',
2360: 'HZ_IMP_REL_SUBJ_OBJ_ERROR', 'SUB_OR_OBJ', 'OBJECT')
2361: when (E3_FLAG is null) then
2362: into hz_imp_errors (
2363: 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 2366: 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_CONTACTS_INT',

2362: into hz_imp_errors (
2363: 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,
2364: token1_name, token1_value, token2_name, token2_value)
2365: values (
2366: 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_CONTACTS_INT',
2367: 'HZ_API_PARTY_NOT_PERSON', 'TABLE_NAME', 'HZ_IMP_CONTACTS_INT',
2368: 'PARTY_ID_COL', SUB_ORIG_SYSTEM_REFERENCE)
2369: when (E4_FLAG is null) then
2370: into hz_imp_errors (

Line 2367: 'HZ_API_PARTY_NOT_PERSON', 'TABLE_NAME', 'HZ_IMP_CONTACTS_INT',

2363: 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,
2364: token1_name, token1_value, token2_name, token2_value)
2365: values (
2366: 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_CONTACTS_INT',
2367: 'HZ_API_PARTY_NOT_PERSON', 'TABLE_NAME', 'HZ_IMP_CONTACTS_INT',
2368: 'PARTY_ID_COL', SUB_ORIG_SYSTEM_REFERENCE)
2369: when (E4_FLAG is null) then
2370: into hz_imp_errors (
2371: 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 2374: 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_CONTACTS_INT',

2370: into hz_imp_errors (
2371: 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,
2372: token1_name, token1_value, token2_name, token2_value)
2373: values (
2374: 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_CONTACTS_INT',
2375: 'HZ_API_PARTY_NOT_ORG', 'TABLE_NAME', 'HZ_IMP_CONTACTS_INT',
2376: 'PARTY_ID_COL', OBJ_ORIG_SYSTEM_REFERENCE)
2377: when (E5_FLAG is null) then
2378: into hz_imp_errors (

Line 2375: 'HZ_API_PARTY_NOT_ORG', 'TABLE_NAME', 'HZ_IMP_CONTACTS_INT',

2371: 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,
2372: token1_name, token1_value, token2_name, token2_value)
2373: values (
2374: 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_CONTACTS_INT',
2375: 'HZ_API_PARTY_NOT_ORG', 'TABLE_NAME', 'HZ_IMP_CONTACTS_INT',
2376: 'PARTY_ID_COL', OBJ_ORIG_SYSTEM_REFERENCE)
2377: when (E5_FLAG is null) then
2378: into hz_imp_errors (
2379: 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 2382: 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_CONTACTS_INT',

2378: into hz_imp_errors (
2379: 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,
2380: token1_name, token1_value, token2_name, token2_value)
2381: values (
2382: 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_CONTACTS_INT',
2383: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'RELATIONSHIP_CODE',
2384: 'LOOKUP_TYPE', 'PARTY_RELATIONS_TYPE')
2385: when (E6_FLAG is null) then
2386: into hz_imp_errors (

Line 2390: 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_CONTACTS_INT',

2386: into hz_imp_errors (
2387: 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,
2388: token1_name, token1_value, token2_name, token2_value)
2389: values (
2390: 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_CONTACTS_INT',
2391: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'DEPARTMENT_CODE', 'LOOKUP_TYPE',
2392: 'DEPARTMENT_CODE')
2393: when (E7_FLAG is null) then
2394: into hz_imp_errors (

Line 2398: 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_CONTACTS_INT',

2394: into hz_imp_errors (
2395: 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,
2396: token1_name, token1_value, token2_name, token2_value)
2397: values (
2398: 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_CONTACTS_INT',
2399: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'TITLE', 'LOOKUP_TYPE',
2400: 'CONTACT_TITLE')
2401: when (E8_FLAG is null) then
2402: into hz_imp_errors (

Line 2406: 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_CONTACTS_INT',

2402: into hz_imp_errors (
2403: 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,
2404: token1_name, token1_value, token2_name, token2_value)
2405: values (
2406: 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_CONTACTS_INT',
2407: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'JOB_TITLE_CODE', 'LOOKUP_TYPE',
2408: 'RESPONSIBILITY')
2409: when (E9_FLAG is null) then
2410: into hz_imp_errors (

Line 2414: 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_CONTACTS_INT',

2410: into hz_imp_errors (
2411: 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,
2412: token1_name, token1_value, token2_name, token2_value)
2413: values (
2414: 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_CONTACTS_INT',
2415: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'DECISION_MAKER_FLAG',
2416: 'LOOKUP_TYPE', 'YES/NO')
2417: when (E10_FLAG is null) then
2418: into hz_imp_errors (

Line 2422: 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_CONTACTS_INT',

2418: into hz_imp_errors (
2419: 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,
2420: token1_name, token1_value, token2_name, token2_value)
2421: values (
2422: 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_CONTACTS_INT',
2423: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'REFERENCE_USE_FLAG',
2424: 'LOOKUP_TYPE', 'YES/NO')
2425: when (E11_FLAG is null) then
2426: into hz_imp_errors (

Line 2430: 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_CONTACTS_INT',

2426: into hz_imp_errors (
2427: 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,
2428: token1_name, token1_value, token2_name, token2_value)
2429: values (
2430: 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_CONTACTS_INT',
2431: 'HZ_API_DATE_GREATER', 'DATE2', 'END_DATE', 'DATE1', 'START_DATE')
2432: when (E12_FLAG is null) then
2433: into hz_imp_errors (
2434: 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 2437: 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_CONTACTS_INT',

2433: into hz_imp_errors (
2434: 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,
2435: token1_name, token1_value)
2436: values (
2437: 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_CONTACTS_INT',
2438: 'AR_RAPI_DESC_FLEX_INVALID', 'DFF_NAME', 'HZ_ORG_CONTACTS')
2439: when (E13_FLAG is null) then
2440: into hz_imp_errors (
2441: 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 2443: 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_CONTACTS_INT',

2439: when (E13_FLAG is null) then
2440: into hz_imp_errors (
2441: 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)
2442: values (
2443: 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_CONTACTS_INT',
2444: 'HZ_IMP_HIERARCHICAL_FLAG_ERROR')
2445: when (E14_FLAG is null) then
2446: into hz_imp_errors (
2447: 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 2449: 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_CONTACTS_INT', 'HZ_IMP_DUP_REL_IN_INT_ERROR')

2445: when (E14_FLAG is null) then
2446: into hz_imp_errors (
2447: 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)
2448: values (
2449: 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_CONTACTS_INT', 'HZ_IMP_DUP_REL_IN_INT_ERROR')
2450: when (E15_FLAG is null) then
2451: into hz_imp_errors (
2452: 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,
2453: token1_name, token1_value)

Line 2455: 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_CONTACTS_INT',

2451: into hz_imp_errors (
2452: 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,
2453: token1_name, token1_value)
2454: values (
2455: 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_CONTACTS_INT',
2456: 'HZ_DSS_NO_UPDATE_PRIVILEGE', 'ENTITY_NAME', l_dss_rel_err)
2457: when (E16_FLAG is null) then
2458: into hz_imp_errors (
2459: 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 2462: 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_CONTACTS_INT',

2458: into hz_imp_errors (
2459: 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,
2460: token1_name, token1_value)
2461: values (
2462: 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_CONTACTS_INT',
2463: 'HZ_API_NONUPDATEABLE_TO_NULL', 'COLUMN', 'START_DATE')
2464: -- Bug 4156586
2465: when (E17_FLAG is null) then
2466: into hz_imp_errors (

Line 2469: 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_CONTACTS_INT', 'HZ_API_SUBJECT_OBJECT_IDS')

2465: when (E17_FLAG is null) then
2466: into hz_imp_errors (
2467: 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)
2468: values (
2469: 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_CONTACTS_INT', 'HZ_API_SUBJECT_OBJECT_IDS')
2470: when (E18_FLAG is null) then
2471: into hz_imp_errors (
2472: 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,
2473: token1_name, token1_value, token2_name, token2_value)

Line 2475: 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_CONTACTS_INT',

2471: into hz_imp_errors (
2472: 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,
2473: token1_name, token1_value, token2_name, token2_value)
2474: values (
2475: 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_CONTACTS_INT',
2476: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREATED_BY_MODULE', 'LOOKUP_TYPE',
2477: 'HZ_CREATED_BY_MODULES')
2478: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
2479: into hz_imp_errors (

Line 2483: 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_CONTACTS_INT',

2479: into hz_imp_errors (
2480: 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,
2481: token1_name, token1_value, token2_name, token2_value)
2482: values (
2483: 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_CONTACTS_INT',
2484: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_ORG_CONTACTS_U1', 'ENTITY',
2485: 'HZ_ORG_CONTACTS')
2486: when (ACTION_MISMATCH_FLAG is null) then
2487: into hz_imp_errors (

Line 2490: 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_CONTACTS_INT',

2486: when (ACTION_MISMATCH_FLAG is null) then
2487: into hz_imp_errors (
2488: 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)
2489: values (
2490: 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_CONTACTS_INT',
2491: 'HZ_IMP_ACTION_MISMATCH')
2492: 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,
2493: e.program_id, e.program_update_date, e.error_id, e.batch_id, e.request_id, e.interface_table_name, E1_FLAG, E2_FLAG,
2494: E3_FLAG, E4_FLAG, E5_FLAG, E6_FLAG, E7_FLAG, E8_FLAG, E9_FLAG,

Line 2501: HZ_IMP_CONTACTS_INT int

2497: E18_FLAG, DUP_VAL_IDX_EXCEP_FLAG, ACTION_MISMATCH_FLAG,
2498: FND_GLOBAL.USER_NAME, INT.SUB_ORIG_SYSTEM_REFERENCE,
2499: INT.OBJ_ORIG_SYSTEM_REFERENCE, INT.END_DATE, INT.START_DATE
2500: from hz_imp_tmp_errors e,
2501: HZ_IMP_CONTACTS_INT int
2502: where e.batch_id = P_BATCH_ID
2503: and e.request_id = P_REQUEST_ID
2504: and e.int_row_id = int.rowid
2505: and e.interface_table_name = 'HZ_IMP_CONTACTS_INT';

Line 2505: and e.interface_table_name = 'HZ_IMP_CONTACTS_INT';

2501: HZ_IMP_CONTACTS_INT int
2502: where e.batch_id = P_BATCH_ID
2503: and e.request_id = P_REQUEST_ID
2504: and e.int_row_id = int.rowid
2505: and e.interface_table_name = 'HZ_IMP_CONTACTS_INT';
2506:
2507: insert all
2508: when (E2_FLAG is null) then
2509: into hz_imp_errors (

Line 3249: update hz_imp_contacts_int

3245: where rowid = l_row_id(i)
3246: and l_table_name(i) = 'HZ_IMP_CONTACTPTS_INT';
3247:
3248: ForAll i in 1..l_row_id.count
3249: update hz_imp_contacts_int
3250: set interface_status = 'E',
3251: error_id = l_error_id(i)
3252: where rowid = l_row_id(i)
3253: and l_table_name(i) = 'HZ_IMP_CONTACTS_INT';

Line 3253: and l_table_name(i) = 'HZ_IMP_CONTACTS_INT';

3249: update hz_imp_contacts_int
3250: set interface_status = 'E',
3251: error_id = l_error_id(i)
3252: where rowid = l_row_id(i)
3253: and l_table_name(i) = 'HZ_IMP_CONTACTS_INT';
3254:
3255: ForAll i in 1..l_row_id.count
3256: update hz_imp_contactroles_int
3257: set interface_status = 'E',

Line 3950: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_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');
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');

Line 4481: select /+ index_ffs(a,hz_imp_contacts_int_n1) parallel_index(a)/

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)*/
4482: sub_orig_system_reference party_orig_system_reference
4483: from hz_imp_contacts_int a
4484: where sub_orig_system = :2
4485: and batch_id=:1

Line 4483: from hz_imp_contacts_int a

4479: and batch_id=:1
4480: union all -- Contacts
4481: select /*+ index_ffs(a,hz_imp_contacts_int_n1) parallel_index(a)*/
4482: sub_orig_system_reference party_orig_system_reference
4483: from hz_imp_contacts_int a
4484: where sub_orig_system = :2
4485: and batch_id=:1
4486: union all -- Contact Roles
4487: select /*+ index_ffs(a,hz_imp_contactroles_int_n1)

Line 4578: select /+ index(a,hz_imp_contacts_int_n1) /

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) */
4579: sub_orig_system_reference party_orig_system_reference
4580: from hz_imp_contacts_int a
4581: where sub_orig_system = :2
4582: and batch_id=:1

Line 4580: from hz_imp_contacts_int a

4576: and batch_id=:1
4577: union all -- Contacts
4578: select /*+ index(a,hz_imp_contacts_int_n1) */
4579: sub_orig_system_reference party_orig_system_reference
4580: from hz_imp_contacts_int a
4581: where sub_orig_system = :2
4582: and batch_id=:1
4583: union all -- Contact Roles
4584: select /*+ index(a,hz_imp_contactroles_int_n1) */