APPS.HZ_IMP_LOAD_ORG_CONTACT_PKG dependencies on HZ_IMP_CONTACTS_INT

Line 327: l_error_id HZ_IMP_CONTACTS_INT.ERROR_ID%TYPE;

323: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
324: P_ACTION IN VARCHAR2,
325: P_DML_EXCEPTION IN VARCHAR2
326: ) IS
327: l_error_id HZ_IMP_CONTACTS_INT.ERROR_ID%TYPE;
328: m NUMBER := 1;
329: n NUMBER := 1;
330: num_exp NUMBER;
331: exp_ind NUMBER := 1;

Line 412: 'HZ_IMP_CONTACTS_INT',

408: (
409: select P_DML_RECORD.REQUEST_ID,
410: P_DML_RECORD.BATCH_ID,
411: l_row_id(j),
412: 'HZ_IMP_CONTACTS_INT',
413: HZ_IMP_ERRORS_S.NextVal,
414: P_DML_RECORD.SYSDATE,
415: P_DML_RECORD.USER_ID,
416: P_DML_RECORD.SYSDATE,

Line 528: 'HZ_IMP_CONTACTS_INT',

524: (
525: select P_DML_RECORD.REQUEST_ID,
526: P_DML_RECORD.BATCH_ID,
527: cnt_sg.int_row_id,
528: 'HZ_IMP_CONTACTS_INT',
529: HZ_IMP_ERRORS_S.NextVal,
530: P_DML_RECORD.SYSDATE,
531: P_DML_RECORD.USER_ID,
532: P_DML_RECORD.SYSDATE,

Line 542: from hz_imp_contacts_sg cnt_sg, hz_imp_contacts_int cnt_int

538: 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',
539: 'Y',
540: dup_val_exp_val,
541: other_exp_val
542: from hz_imp_contacts_sg cnt_sg, hz_imp_contacts_int cnt_int
543: where cnt_sg.action_flag = 'I'
544: and cnt_int.rowid = cnt_sg.int_row_id
545: and cnt_int.batch_id = P_DML_RECORD.BATCH_ID
546: and cnt_int.sub_orig_system = P_DML_RECORD.OS

Line 1002: ''HZ_IMP_CONTACTS_INT'',

998: hz_imp_errors_s.nextval,
999: :p_batch_id,
1000: :request_id,
1001: row_id,
1002: ''HZ_IMP_CONTACTS_INT'',
1003: action_mismatch_error,
1004: nvl2(sub_id, ''Y'', null),
1005: nvl2(obj_id, ''Y'', null),
1006: sbj_person_type_error,

Line 1157: hz_imp_contacts_int ocint,

1153: decode(tc.a, 0, ''Y'') dup_rel_error,
1154: nvl2(nullif(ocint.created_by_module, :p_gmiss_char), nvl2(createdby_l.lookup_code, ''Y'', null), ''Y'') createdby_error
1155:
1156: from hz_imp_contacts_sg ocsg,
1157: hz_imp_contacts_int ocint,
1158: (select 0 a from dual union all select 1 a from dual) tc,
1159: hz_parties sp,
1160: hz_parties op,
1161: fnd_lookup_values party_rel_type_l,

Line 1558: FROM HZ_IMP_CONTACTS_INT ci,

1554: and r1.relationship_id <> r.relationship_id
1555: and rownum = 1
1556: ) identical_rel
1557: */
1558: FROM HZ_IMP_CONTACTS_INT ci,
1559: HZ_IMP_CONTACTS_SG cs,
1560: HZ_RELATIONSHIPS r,
1561: HZ_ORG_CONTACTS oc,
1562: AR_LOOKUPS dept_l,