APPS.HZ_IMP_LOAD_RELATIONSHIPS_PKG dependencies on HZ_IMP_TMP_ERRORS

Line 300: insert into hz_imp_tmp_errors

296: END LOOP;
297:
298: /* insert into tmp error tables */
299: forall j in 1..l_relationship_id.count
300: insert into hz_imp_tmp_errors
301: (
302: request_id,
303: batch_id,
304: int_row_id,

Line 380: insert into hz_imp_tmp_errors

376: other_exp_val := null;
377: dup_val_exp_val := 'A';
378: end if;
379:
380: insert into hz_imp_tmp_errors
381: (
382: request_id,
383: batch_id,
384: int_row_id,

Line 916: into hz_imp_tmp_errors ( /* insert into tmp errors for any validation error */

912: ''A'',
913: created_by_module,
914: 1)
915: else
916: into hz_imp_tmp_errors ( /* insert into tmp errors for any validation error */
917: created_by,
918: creation_date,
919: last_updated_by,
920: last_update_date,

Line 1285: from hz_imp_tmp_errors e

1281: and batch_id = p_dml_record.batch_id
1282: and sub_orig_system_reference between p_dml_record.from_osr and p_dml_record.to_osr
1283: and int_row_id not in (
1284: select /*+ hash_aj */ e.int_row_id
1285: from hz_imp_tmp_errors e
1286: where e.request_id = p_dml_record.request_id
1287: AND e.interface_table_name = 'HZ_IMP_RELATIONSHIPS_INT'
1288: and e.batch_id = p_dml_record.batch_id
1289: and e.int_row_id is not null));