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 3094: insert into hz_imp_tmp_errors

3090: END LOOP;
3091: /* insert into tmp error tables */
3092:
3093: forall j in 1..l_site_id.count
3094: insert into hz_imp_tmp_errors
3095: ( request_id,
3096: batch_id,
3097: int_row_id,
3098: interface_table_name,