APPS.HZ_IMP_LOAD_CODE_ASSIGNMENTS dependencies on HZ_IMP_CLASSIFICS_INT

Line 131: l_error_id HZ_IMP_CLASSIFICS_INT.ERROR_ID%TYPE;

127: P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
128: P_ACTION IN VARCHAR2,
129: P_DML_EXCEPTION IN VARCHAR2
130: ) IS
131: l_error_id HZ_IMP_CLASSIFICS_INT.ERROR_ID%TYPE;
132: m NUMBER := 1;
133: n NUMBER := 1;
134: num_exp NUMBER;
135: exp_ind NUMBER := 1;

Line 216: 'HZ_IMP_CLASSIFICS_INT',

212: (
213: select P_DML_RECORD.REQUEST_ID,
214: P_DML_RECORD.BATCH_ID,
215: l_row_id(j),
216: 'HZ_IMP_CLASSIFICS_INT',
217: HZ_IMP_ERRORS_S.NextVal,
218: P_DML_RECORD.SYSDATE,
219: P_DML_RECORD.USER_ID,
220: P_DML_RECORD.SYSDATE,

Line 331: 'HZ_IMP_CLASSIFICS_INT',

327: (
328: select P_DML_RECORD.REQUEST_ID,
329: P_DML_RECORD.BATCH_ID,
330: clsf_sg.int_row_id,
331: 'HZ_IMP_CLASSIFICS_INT',
332: HZ_IMP_ERRORS_S.NextVal,
333: P_DML_RECORD.SYSDATE,
334: P_DML_RECORD.USER_ID,
335: P_DML_RECORD.SYSDATE,

Line 345: from hz_imp_classifics_sg clsf_sg, hz_imp_classifics_int clsf_int

341: 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',
342: dup_val_exp_val,
343: other_exp_val,
344: 'Y','Y'
345: from hz_imp_classifics_sg clsf_sg, hz_imp_classifics_int clsf_int
346: where clsf_sg.action_flag = 'I'
347: and clsf_int.rowid = clsf_sg.int_row_id
348: and clsf_int.batch_id = P_DML_RECORD.BATCH_ID
349: and clsf_int.party_orig_system = P_DML_RECORD.OS

Line 474: ''HZ_IMP_CLASSIFICS_INT'',

470: hz_imp_errors_s.nextval,
471: :p_batch_id,
472: :request_id,
473: row_id,
474: ''HZ_IMP_CLASSIFICS_INT'',
475: action_mismatch_error,
476: missing_parent_error,
477: --error_flag,
478: classcat_foreignkey_error,

Line 509: hz_imp_classifics_int cai,

505: decode(tc2.a, 0, ''Y'') multi_assign_error,
506: decode(tc3.a, 0, ''Y'') leaf_node_error,
507: decode(cai.created_by_module, :p_gmiss_char, ''Y'', null, ''Y'', nvl2(createdby_l.lookup_code,''Y'',null)) createdby_error
508: from hz_imp_classifics_sg cas,
509: hz_imp_classifics_int cai,
510: fnd_lookup_values class_code_lookups,
511: hz_class_categories class_cat,
512: tc tc1, tc tc2, tc tc3,
513: hz_parties hp,

Line 859: and err_table.interface_table_name = ''HZ_IMP_CLASSIFICS_INT''

855: from HZ_IMP_TMP_ERRORS err_table,
856: hz_imp_classifics_sg cls_sg,
857: hz_parties hp
858: where err_table.request_id = :request_id
859: and err_table.interface_table_name = ''HZ_IMP_CLASSIFICS_INT''
860: and cls_sg.batch_id = :batch_id
861: and cls_sg.batch_mode_flag = :batch_mode_flag
862: and cls_sg.party_orig_system = :orig_system
863: and cls_sg.party_orig_system_reference between :from_osr and :to_osr

Line 942: hz_imp_classifics_int cls_int,

938: cls_sg.class_code,
939: cls_int.class_category
940: from hz_imp_classifics_sg cls_sg,
941: hz_imp_parties_sg p_sg,
942: hz_imp_classifics_int cls_int,
943: hz_code_assignments hca
944: where cls_sg.batch_id = :batch_id
945: and cls_sg.batch_mode_flag = :batch_mode_flag
946: and cls_sg.party_orig_system = :orig_system

Line 1106: FROM HZ_IMP_CLASSIFICS_INT cai,

1102: decode(cai.START_DATE_ACTIVE, :G_MISS_DATE, null, ''Y'') start_date_error,
1103:
1104: decode(tc1.a, 0, ''Y'') identical_classcode_error,
1105: decode(tc2.a, 0, ''Y'') multi_assign_error
1106: FROM HZ_IMP_CLASSIFICS_INT cai,
1107: HZ_IMP_CLASSIFICS_SG cas,
1108: (select 0 a from dual union all select 1 a from dual) tc1,
1109: (select 0 a from dual union all select 1 a from dual) tc2
1110: WHERE