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_CLASSIFICS_INT

Line 230: hz_imp_classifics_int c_int

226: s.end_date_active nulls last, s.primary_flag desc) lsd2,
227: c_cat.allow_multi_assign_flag
228: from hz_imp_classifics_sg s,
229: hz_class_categories c_cat,
230: hz_imp_classifics_int c_int
231: where s.batch_id = p_batch_id
232: and s.batch_mode_flag = p_batch_mode_flag
233: and s.action_flag = 'I'
234: and c_cat.class_category = s.class_category

Line 399: 'HZ_IMP_CLASSIFICS_INT',

395: (
396: P_REQUEST_ID,
397: P_BATCH_ID,
398: l_int_row_id(j),
399: 'HZ_IMP_CLASSIFICS_INT',
400: l_err_id(j),
401: P_SYSDATE,
402: P_USER_ID,
403: P_SYSDATE,

Line 415: update HZ_IMP_CLASSIFICS_INT

411: l_err(j)
412: );
413:
414: ForAll j in 1..l_int_row_id.count
415: update HZ_IMP_CLASSIFICS_INT
416: set interface_status = 'E', error_id = l_err_id(j)
417: where rowid = l_int_row_id(j);
418:
419: CLOSE dup_code_assignments;

Line 467: 'HZ_IMP_CLASSIFICS_INT', decode(e38_flag, 'M', 'HZ_API_ALLOW_MUL_ASSIGN_FG',

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: )
470: from hz_imp_tmp_errors
471: where batch_id = P_BATCH_ID

Line 474: 'HZ_IMP_ADDRESSUSES_INT', 'HZ_IMP_CLASSIFICS_INT');

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
478: hz_utility_v2pub.debug(p_message=>'WRP:ident_dup_within_int()-',

Line 1163: UPDATE HZ_IMP_CLASSIFICS_INT

1159: );
1160:
1161: --Update Classifications
1162: FORALL i in l_posr.FIRST..l_posr.LAST
1163: UPDATE HZ_IMP_CLASSIFICS_INT
1164: SET interface_status = 'D'
1165: WHERE batch_id = p_batch_id AND Nvl(party_id,l_pid(i)) = l_pid(i)
1166: AND party_orig_system = l_pos(i)
1167: AND party_orig_system_reference = l_posr(i);

Line 1327: update HZ_IMP_CLASSIFICS_INT

1323: where BATCH_ID = P_BATCH_ID
1324: and PARTY_ORIG_SYSTEM = P_ORIG_SYSTEM
1325: and INTERFACE_STATUS = 'C';
1326:
1327: update HZ_IMP_CLASSIFICS_INT
1328: set error_id = null,
1329: interface_status = null
1330: where BATCH_ID = P_BATCH_ID
1331: and PARTY_ORIG_SYSTEM = P_ORIG_SYSTEM

Line 1438: update HZ_IMP_CLASSIFICS_INT

1434: and batch_id = P_BATCH_ID
1435: and stage = 3
1436: and status = 'C');
1437:
1438: update HZ_IMP_CLASSIFICS_INT
1439: set error_id = null, interface_status = null
1440: where batch_id = P_BATCH_ID
1441: and party_orig_system = P_ORIG_SYSTEM
1442: and interface_status = 'C'

Line 2514: 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_CLASSIFICS_INT',

2510: 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,
2511: token1_name, token1_value, token2_name, token2_value, token3_name,
2512: token3_value)
2513: values (
2514: 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_CLASSIFICS_INT',
2515: 'HZ_API_INVALID_FK', 'FK', 'CLASS_CATEGORY', 'COLUMN',
2516: 'CLASS_CATEGORY', 'TABLE', 'HZ_CLASS_CATEGORIES')
2517: when (E3_FLAG is null) then
2518: into hz_imp_errors (

Line 2522: 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_CLASSIFICS_INT',

2518: into hz_imp_errors (
2519: 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,
2520: token1_name, token1_value, token2_name, token2_value)
2521: values (
2522: 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_CLASSIFICS_INT',
2523: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CLASS_CODE', 'LOOKUP_TYPE',
2524: 'HZ_IMP_CLASSIFICS_INT.CLASS_CATEGORY')
2525: when (E4_FLAG is null) then
2526: into hz_imp_errors (

Line 2524: 'HZ_IMP_CLASSIFICS_INT.CLASS_CATEGORY')

2520: token1_name, token1_value, token2_name, token2_value)
2521: values (
2522: 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_CLASSIFICS_INT',
2523: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CLASS_CODE', 'LOOKUP_TYPE',
2524: 'HZ_IMP_CLASSIFICS_INT.CLASS_CATEGORY')
2525: when (E4_FLAG is null) then
2526: into hz_imp_errors (
2527: 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,
2528: token1_name, token1_value, token2_name, token2_value)

Line 2530: 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_CLASSIFICS_INT',

2526: into hz_imp_errors (
2527: 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,
2528: token1_name, token1_value, token2_name, token2_value)
2529: values (
2530: 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_CLASSIFICS_INT',
2531: 'HZ_API_DATE_GREATER', 'DATE2', 'END_DATE_ACTIVE', 'DATE1',
2532: 'START_DATE_ACTIVE')
2533: when (E5_FLAG is null) then
2534: into hz_imp_errors (

Line 2537: 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_CLASSIFICS_INT',

2533: when (E5_FLAG is null) then
2534: into hz_imp_errors (
2535: 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)
2536: values (
2537: 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_CLASSIFICS_INT',
2538: 'HZ_IMP_CODE_ASSG_DATE_OVERLAP')
2539: when (E6_FLAG is null) then
2540: into hz_imp_errors (
2541: 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 2543: 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_CLASSIFICS_INT',

2539: when (E6_FLAG is null) then
2540: into hz_imp_errors (
2541: 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)
2542: values (
2543: 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_CLASSIFICS_INT',
2544: 'HZ_API_ALLOW_MUL_ASSIGN_FG')
2545: when (E7_FLAG is null) then
2546: into hz_imp_errors (
2547: 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 2549: 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_CLASSIFICS_INT',

2545: when (E7_FLAG is null) then
2546: into hz_imp_errors (
2547: 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)
2548: values (
2549: 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_CLASSIFICS_INT',
2550: 'HZ_API_LEAFNODE_FLAG')
2551: when (E8_FLAG is null) then
2552: into hz_imp_errors (
2553: 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 2556: 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_CLASSIFICS_INT',

2552: into hz_imp_errors (
2553: 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,
2554: token1_name, token1_value)
2555: values (
2556: 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_CLASSIFICS_INT',
2557: 'HZ_API_NONUPDATEABLE_TO_NULL', 'COLUMN', 'START_DATE')
2558: when (E9_FLAG is null) then
2559: into hz_imp_errors (
2560: 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 2563: 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_CLASSIFICS_INT',

2559: into hz_imp_errors (
2560: 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,
2561: token1_name, token1_value)
2562: values (
2563: 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_CLASSIFICS_INT',
2564: 'HZ_DSS_NO_UPDATE_PRIVILEGE', 'ENTITY_NAME', l_dss_ca_err)
2565: when (E10_FLAG is null) then
2566: into hz_imp_errors (
2567: 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 2570: 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_CLASSIFICS_INT',

2566: into hz_imp_errors (
2567: 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,
2568: token1_name, token1_value, token2_name, token2_value)
2569: values (
2570: 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_CLASSIFICS_INT',
2571: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREATED_BY_MODULE', 'LOOKUP_TYPE',
2572: 'HZ_CREATED_BY_MODULES')
2573: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
2574: into hz_imp_errors (

Line 2578: 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_CLASSIFICS_INT',

2574: into hz_imp_errors (
2575: 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,
2576: token1_name, token1_value, token2_name, token2_value)
2577: values (
2578: 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_CLASSIFICS_INT',
2579: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_CODE_ASSIGNMENTS_U1', 'ENTITY',
2580: 'HZ_CODE_ASSIGNMENTS')
2581: when (DUP_VAL_IDX_EXCEP_FLAG = 'B') then
2582: into hz_imp_errors (

Line 2586: 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_CLASSIFICS_INT',

2582: into hz_imp_errors (
2583: 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,
2584: token1_name, token1_value, token2_name, token2_value)
2585: values (
2586: 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_CLASSIFICS_INT',
2587: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_CODE_ASSIGNMENTS_U2', 'ENTITY',
2588: 'HZ_CODE_ASSIGNMENTS')
2589: when (ACTION_MISMATCH_FLAG is null) then
2590: into hz_imp_errors (

Line 2593: 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_CLASSIFICS_INT',

2589: when (ACTION_MISMATCH_FLAG is null) then
2590: into hz_imp_errors (
2591: 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)
2592: values (
2593: 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_CLASSIFICS_INT',
2594: 'HZ_IMP_ACTION_MISMATCH')
2595: when (MISSING_PARENT_FLAG is null) then -- Bug 4403736
2596: into hz_imp_errors (
2597: 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 2599: 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_CLASSIFICS_INT',

2595: when (MISSING_PARENT_FLAG is null) then -- Bug 4403736
2596: into hz_imp_errors (
2597: 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)
2598: values (
2599: 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_CLASSIFICS_INT',
2600: 'HZ_IMP_PARENT_PARTY_NOT_FOUND')
2601: 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,
2602: e.program_id, e.program_update_date, e.error_id, e.batch_id, e.request_id, e.interface_table_name, E2_FLAG, E3_FLAG,
2603: E4_FLAG, E5_FLAG, E6_FLAG, E7_FLAG, E8_FLAG, E9_FLAG, E10_FLAG,

Line 2607: HZ_IMP_CLASSIFICS_INT int

2603: E4_FLAG, E5_FLAG, E6_FLAG, E7_FLAG, E8_FLAG, E9_FLAG, E10_FLAG,
2604: DUP_VAL_IDX_EXCEP_FLAG, ACTION_MISMATCH_FLAG, MISSING_PARENT_FLAG, FND_GLOBAL.USER_NAME,
2605: INT.END_DATE_ACTIVE, INT.START_DATE_ACTIVE
2606: from hz_imp_tmp_errors e,
2607: HZ_IMP_CLASSIFICS_INT int
2608: where e.batch_id = P_BATCH_ID
2609: and e.request_id = P_REQUEST_ID
2610: and e.int_row_id = int.rowid
2611: and e.interface_table_name = 'HZ_IMP_CLASSIFICS_INT';

Line 2611: and e.interface_table_name = 'HZ_IMP_CLASSIFICS_INT';

2607: HZ_IMP_CLASSIFICS_INT int
2608: where e.batch_id = P_BATCH_ID
2609: and e.request_id = P_REQUEST_ID
2610: and e.int_row_id = int.rowid
2611: and e.interface_table_name = 'HZ_IMP_CLASSIFICS_INT';
2612:
2613: insert all
2614: when (E1_FLAG is null) then
2615: into hz_imp_errors (

Line 3291: update hz_imp_classifics_int

3287: where rowid = l_row_id(i)
3288: and l_table_name(i) = 'HZ_IMP_CREDITRTNGS_INT';
3289:
3290: ForAll i in 1..l_row_id.count
3291: update hz_imp_classifics_int
3292: set interface_status = 'E',
3293: error_id = l_error_id(i)
3294: where rowid = l_row_id(i)
3295: and l_table_name(i) = 'HZ_IMP_CLASSIFICS_INT';

Line 3295: and l_table_name(i) = 'HZ_IMP_CLASSIFICS_INT';

3291: update hz_imp_classifics_int
3292: set interface_status = 'E',
3293: error_id = l_error_id(i)
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',

Line 3947: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_INT');

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');
3950: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_INT');
3951: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_INT');

Line 4469: select /+ index_ffs(a,hz_imp_classifics_int_n1) parallel_index(a)/

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)*/
4470: party_orig_system_reference
4471: from hz_imp_classifics_int a
4472: where party_orig_system = :2
4473: and batch_id=:1

Line 4471: from hz_imp_classifics_int a

4467: and batch_id=:1
4468: union all -- Code Assignments
4469: select /*+ index_ffs(a,hz_imp_classifics_int_n1) parallel_index(a)*/
4470: party_orig_system_reference
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)*/

Line 4566: select /+ index(a,hz_imp_classifics_int_n1) /

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) */
4567: party_orig_system_reference
4568: from hz_imp_classifics_int a
4569: where party_orig_system = :2
4570: and batch_id=:1

Line 4568: from hz_imp_classifics_int a

4564: and batch_id=:1
4565: union all -- Code Assignments
4566: select /*+ index(a,hz_imp_classifics_int_n1) */
4567: party_orig_system_reference
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) */