APPS.HZ_IMP_LOAD_CPT_PKG dependencies on HZ_IMP_TMP_ERRORS

Line 456: insert into hz_imp_tmp_errors

452: END LOOP; -- end of loop for l_contact_point_id.count
453:
454: BEGIN -- anonymous block to insert into hz_imp_errors
455: forall j in 1..l_contact_point_id.count
456: insert into hz_imp_tmp_errors
457: ( request_id, batch_id, int_row_id,
458: interface_table_name, error_id,
459: creation_date, created_by, last_update_date,
460: last_updated_by, last_update_login,

Line 604: insert into hz_imp_tmp_errors

600: dup_val_exp_val := 'A';
601: END IF;
602: END IF;
603:
604: insert into hz_imp_tmp_errors
605: (
606: request_id,
607: batch_id,
608: int_row_id,

Line 809: into hz_imp_tmp_errors (

805: ''HZ_CONTACT_POINTS'', contact_point_id, ''A'',
806: :l_sysdate, created_by_module, 1,party_id,
807: :l_request_id, :l_program_application_id, :l_program_id, :l_sysdate)
808: else
809: into hz_imp_tmp_errors (
810: created_by, creation_date, last_updated_by,
811: last_update_date, last_update_login,
812: program_application_id,
813: program_id, program_update_date,

Line 1184: --Bug 3978485: changed where condition to use request_id in HZ_IMP_TMP_ERRORS

1180:
1181: /* DE-NORM */
1182: /* for all the failed record of primary_flag = 'Y', update the party with */
1183: /* the next available contact point */
1184: --Bug 3978485: changed where condition to use request_id in HZ_IMP_TMP_ERRORS
1185: OPEN primary_flag_err_cursor FOR
1186: 'select cpt_sg.party_id, int.contact_point_type,
1187: ( select hz_cpt.contact_point_id
1188: from hz_contact_points hz_cpt

Line 1194: from HZ_IMP_TMP_ERRORS err_table,

1190: and hz_cpt.owner_table_name= ''HZ_PARTIES''
1191: and hz_cpt.CONTACT_POINT_TYPE = int.contact_point_type
1192: and rownum = 1
1193: ) contact_point_id
1194: from HZ_IMP_TMP_ERRORS err_table,
1195: hz_imp_contactpts_int int,
1196: hz_imp_contactpts_sg cpt_sg
1197: where err_table.request_id = :request_id
1198: and cpt_sg.batch_id = :batch_id

Line 1270: from hz_imp_tmp_errors tmp_err

1266: and cpt_sg.primary_flag = ''Y''
1267: and cpt_sg.action_flag = ''I''
1268: and cpt_sg.party_action_flag = ''U''
1269: and not exists (select tmp_err.INT_ROW_ID
1270: from hz_imp_tmp_errors tmp_err
1271: where tmp_err.INT_ROW_ID = int.rowid
1272: and tmp_err.INTERFACE_TABLE_NAME = ''HZ_IMP_CONTACTPTS_INT'')
1273: '
1274: using P_DML_RECORD.BATCH_ID,