DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_ADDRESSES_PKG dependencies on HZ_IMP_TMP_ERRORS

Line 807: into hz_imp_tmp_errors (

803: :8,
804: :7,
805: :5)
806: else
807: into hz_imp_tmp_errors (
808: created_by,
809: creation_date,
810: last_updated_by,
811: last_update_date,

Line 1046: from HZ_IMP_TMP_ERRORS err_table,

1042: from
1043: (
1044: select addr_sg.party_id,
1045: hz_ps.party_site_id
1046: from HZ_IMP_TMP_ERRORS err_table,
1047: hz_imp_addresses_sg addr_sg,
1048: hz_party_sites hz_ps
1049: where err_table.request_id = :request_id
1050: and interface_table_name = ''HZ_IMP_ADDRESSES_INT''

Line 1242: insert into hz_imp_tmp_errors

1238: dup_val_exp_val := 'C';
1239: end if;
1240: end if;
1241:
1242: insert into hz_imp_tmp_errors
1243: (
1244: request_id,
1245: batch_id,
1246: int_row_id,

Line 3090: insert into hz_imp_tmp_errors

3086: END LOOP;
3087: /* insert into tmp error tables */
3088:
3089: forall j in 1..l_site_id.count
3090: insert into hz_imp_tmp_errors
3091: ( request_id,
3092: batch_id,
3093: int_row_id,
3094: interface_table_name,