APPS.HZ_IMP_LOAD_RELATIONSHIPS_PKG dependencies on HZ_IMP_RELSHIPS_INT

Line 52: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_RELSHIPS_INT.CREATED_BY_MODULE%TYPE;

48:
49: l_no_end_date DATE;
50: l_actual_content_source varchar2(100);
51:
52: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_RELSHIPS_INT.CREATED_BY_MODULE%TYPE;
53: TYPE LOOKUP_ERROR IS TABLE OF ar_lookups.lookup_code%TYPE;
54:
55: l_created_by_module CREATED_BY_MODULE;
56: l_createdby_errors LOOKUP_ERROR;

Line 414: 'HZ_IMP_RELSHIPS_INT',

410: (
411: select P_DML_RECORD.REQUEST_ID,
412: P_DML_RECORD.BATCH_ID,
413: rel_sg.int_row_id,
414: 'HZ_IMP_RELSHIPS_INT',
415: HZ_IMP_ERRORS_S.NextVal,
416: P_DML_RECORD.SYSDATE,
417: P_DML_RECORD.USER_ID,
418: P_DML_RECORD.SYSDATE,

Line 428: from hz_imp_relships_sg rel_sg, hz_imp_relships_int rel_int

424: 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',
425: 'Y','Y',
426: dup_val_exp_val,
427: other_exp_val
428: from hz_imp_relships_sg rel_sg, hz_imp_relships_int rel_int
429: where rel_sg.action_flag = 'I'
430: and rel_int.rowid = rel_sg.int_row_id
431: and rel_sg.batch_id = P_DML_RECORD.BATCH_ID
432: and rel_sg.sub_orig_system = P_DML_RECORD.OS

Line 955: ''HZ_IMP_RELSHIPS_INT'',

951: HZ_IMP_ERRORS_S.NextVal,
952: :p_batch_id,
953: :request_id,
954: row_id,
955: ''HZ_IMP_RELSHIPS_INT'',
956: nvl2(sub_pid, ''Y'', null),
957: nvl2(obj_pid, ''Y'', null),
958: decode(sub_pid, null, ''Y'',
959: decode(obj_pid, null, ''Y'', nvl2(relationship_type, ''Y'', nvl2(rel_code_error, null, ''Y'')))),

Line 1078: hz_imp_relships_int ri,

1074: null, ''Y'') action_mismatch_error,
1075: decode(tc.a, 0, ''Y'') dup_rel_error,
1076: tc.a dup_rel_count
1077: from hz_imp_relships_sg irs,
1078: hz_imp_relships_int ri,
1079: (select 0 a from dual union all select 1 a from dual) tc,
1080: hz_parties sp,
1081: hz_parties op
1082: where irs.batch_mode_flag = :p_batch_mode_flag

Line 1378: FROM HZ_IMP_RELSHIPS_INT ri, HZ_IMP_RELSHIPS_SG rs,

1374: ri.ATTRIBUTE20,
1375: decode(nvl(ri.insert_update_flag, rs.action_flag), rs.action_flag, ''Y'', null) action_mismatch_error,
1376: 0 flex_val_errors,
1377: ''T'' dss_security_error
1378: FROM HZ_IMP_RELSHIPS_INT ri, HZ_IMP_RELSHIPS_SG rs,
1379: HZ_RELATIONSHIPS r
1380: WHERE
1381: ri.rowid = rs.int_row_id
1382: AND rs.relationship_id = r.relationship_id