APPS.HZ_IMP_LOAD_CONTACT_ROLE_PKG dependencies on HZ_IMP_CONTACTROLES_INT

Line 105: 'HZ_IMP_CONTACTROLES_INT',

101: (
102: select P_DML_RECORD.REQUEST_ID,
103: P_DML_RECORD.BATCH_ID,
104: p_sg.int_row_id,
105: 'HZ_IMP_CONTACTROLES_INT',
106: HZ_IMP_ERRORS_S.NextVal,
107: P_DML_RECORD.SYSDATE,
108: P_DML_RECORD.USER_ID,
109: P_DML_RECORD.SYSDATE,

Line 122: from hz_imp_contactroles_int int,hz_imp_contactroles_sg p_sg

118: 'Y',
119: 'Y',
120: dup_val_exp_val,
121: other_exp_val
122: from hz_imp_contactroles_int int,hz_imp_contactroles_sg p_sg
123: where int.rowid = p_sg.int_row_id
124: and p_sg.action_flag = 'I'
125: and p_sg.batch_id = P_DML_RECORD.BATCH_ID
126: and int.sub_orig_system = P_DML_RECORD.OS

Line 265: ''HZ_IMP_CONTACTROLES_INT'',

261: HZ_IMP_ERRORS_S.nextval,
262: :p_batch_id,
263: :request_id,
264: row_id,
265: ''HZ_IMP_CONTACTROLES_INT'',
266: role_type_error,
267: controle_osr_mismatch_err,
268: createdby_error,
269: action_mismatch_error,

Line 291: from hz_imp_contactroles_int cri,

287: --nvl2(nullif(mosr.party_id,mosr_party.owner_table_id),null,''Y'') controle_osr_mismatch_err
288: nvl2(nullif(mosr.orig_system_reference,cri.contact_orig_system_reference),null,''Y'') controle_osr_mismatch_err,
289: nvl2(nullif(cri.created_by_module,:p_gmiss_char),createdby_l.lookup_code,''Y'') createdby_error
290:
291: from hz_imp_contactroles_int cri,
292: hz_imp_contactroles_sg crs,
293: hz_orig_sys_references mosr,
294: --hz_orig_sys_references mosr_party,
295: hz_org_contacts org_cont,