DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_CODE_ASSIGNMENTS dependencies on HZ_IMP_TMP_ERRORS

Line 188: insert into hz_imp_tmp_errors

184: END LOOP;
185:
186: /* insert into tmp error tables */
187: forall j in 1..l_code_assignment_id.count
188: insert into hz_imp_tmp_errors
189: (
190: request_id,
191: batch_id,
192: int_row_id,

Line 298: insert into hz_imp_tmp_errors

294: end if;
295:
296: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'dup_val_exp_val:' || dup_val_exp_val);
297:
298: insert into hz_imp_tmp_errors
299: (
300: request_id,
301: batch_id,
302: int_row_id,

Line 435: into hz_imp_tmp_errors (

431: ''A'',
432: 1, -- OBJECT_VERSION_NUMBER,
433: created_by_module)
434: else
435: into hz_imp_tmp_errors (
436: created_by,
437: creation_date,
438: last_updated_by,
439: last_update_date,

Line 855: from HZ_IMP_TMP_ERRORS err_table,

851: select cls_sg.party_id, cls_sg.class_category,
852: rank() over (partition by
853: cls_sg.party_id, cls_sg.class_category order by
854: cls_sg.code_assignment_id) r
855: from HZ_IMP_TMP_ERRORS err_table,
856: hz_imp_classifics_sg cls_sg,
857: hz_parties hp
858: where err_table.request_id = :request_id
859: and err_table.interface_table_name = ''HZ_IMP_CLASSIFICS_INT''