APPS.HZ_IMP_LOAD_CODE_ASSIGNMENTS dependencies on HZ_CODE_ASSIGNMENTS

Line 92: p_db_object_name => 'HZ_CODE_ASSIGNMENTS',

88: FOR i IN 1..l_code_assignment_id.count LOOP
89: l_dss_security_errors(i) :=
90: hz_dss_util_pub.test_instance(
91: p_operation_code => 'UPDATE',
92: p_db_object_name => 'HZ_CODE_ASSIGNMENTS',
93: p_instance_pk1_value => l_code_assignment_id(i),
94: p_user_name => fnd_global.user_name,
95: x_return_status => dss_return_status,
96: x_msg_count => dss_msg_count,

Line 284: -- 'A' indicate HZ_CODE_ASSIGNMENTS_U1 constraint violation

280: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'populate_error_table');
281:
282: -- in constraint voilation happen, DUP_VAL_IDX_EXCEP_FLAG column
283: -- in temp error table will be set
284: -- 'A' indicate HZ_CODE_ASSIGNMENTS_U1 constraint violation
285: -- 'B' indicate HZ_CODE_ASSIGNMENTS_U2 constraint violation
286:
287: if (P_DUP_VAL_EXP = 'Y') then
288: other_exp_val := null;

Line 285: -- 'B' indicate HZ_CODE_ASSIGNMENTS_U2 constraint violation

281:
282: -- in constraint voilation happen, DUP_VAL_IDX_EXCEP_FLAG column
283: -- in temp error table will be set
284: -- 'A' indicate HZ_CODE_ASSIGNMENTS_U1 constraint violation
285: -- 'B' indicate HZ_CODE_ASSIGNMENTS_U2 constraint violation
286:
287: if (P_DUP_VAL_EXP = 'Y') then
288: other_exp_val := null;
289: if(instr(P_SQL_ERRM, 'HZ_CODE_ASSIGNMENTS_U1')<>0) then

Line 289: if(instr(P_SQL_ERRM, 'HZ_CODE_ASSIGNMENTS_U1')<>0) then

285: -- 'B' indicate HZ_CODE_ASSIGNMENTS_U2 constraint violation
286:
287: if (P_DUP_VAL_EXP = 'Y') then
288: other_exp_val := null;
289: if(instr(P_SQL_ERRM, 'HZ_CODE_ASSIGNMENTS_U1')<>0) then
290: dup_val_exp_val := 'A';
291: elsif(instr(P_SQL_ERRM, 'HZ_CODE_ASSIGNMENTS_U2')<>0) then
292: dup_val_exp_val := 'B';
293: end if;

Line 291: elsif(instr(P_SQL_ERRM, 'HZ_CODE_ASSIGNMENTS_U2')<>0) then

287: if (P_DUP_VAL_EXP = 'Y') then
288: other_exp_val := null;
289: if(instr(P_SQL_ERRM, 'HZ_CODE_ASSIGNMENTS_U1')<>0) then
290: dup_val_exp_val := 'A';
291: elsif(instr(P_SQL_ERRM, 'HZ_CODE_ASSIGNMENTS_U2')<>0) then
292: dup_val_exp_val := 'B';
293: end if;
294: end if;
295:

Line 384: into hz_code_assignments (

380: and multi_assign_error is not null
381: and leaf_node_error is not null
382: and createdby_error is not null
383: and missing_parent_error is not null) then
384: into hz_code_assignments (
385: application_id,
386: actual_content_source, -- Bug 4079902
387: content_source_type,
388: created_by,

Line 536: from hz_code_assignments c

532: and createdby_l.view_application_id (+) = 222
533: and createdby_l.security_group_id (+) =
534: fnd_global.lookup_security_group(''HZ_CREATED_BY_MODULES'', 222)
535: and tc1.a = (select count(*) -- check date overlap, 0 indicates no error
536: from hz_code_assignments c
537: where c.class_category = cai.class_category
538: and c.class_code = cai.class_code
539: and c.owner_table_name = ''HZ_PARTIES''
540: and c.owner_table_id = cas.party_id

Line 550: from hz_code_assignments c_assign,

546: and c.actual_content_source = :l_content_source_type
547: and c.status = ''A''
548: and rownum = 1)
549: and tc2.a = (select count(*) -- check multi class code, 0 indicates no error
550: from hz_code_assignments c_assign,
551: hz_class_categories c_cat
552: where c_cat.class_category = c_assign.class_category
553: and c_cat.class_category = cai.class_category
554: and c_assign.owner_table_id = cas.party_id

Line 943: hz_code_assignments hca

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
947: and cls_sg.party_orig_system_reference

Line 1118: from hz_code_assignments c

1114: AND cas.party_orig_system_reference between :P_FROM_OSR and :P_TO_OSR
1115: AND cai.rowid = cas.int_row_id
1116:
1117: and tc1.a = (select count(*) -- check date overlap, 0 indicates no error
1118: from hz_code_assignments c
1119: where c.code_assignment_id <> cas.code_assignment_id
1120: and c.class_category = cas.class_category
1121: and c.class_code = cas.class_code
1122: and c.owner_table_name = ''HZ_PARTIES''

Line 1133: from hz_code_assignments c_assign,

1129: --and c.content_source_type = :l_content_source_type
1130: and c.status = ''A''
1131: and rownum = 1)
1132: and tc2.a = (select count(*) -- check multi class code, 0 indicates no error
1133: from hz_code_assignments c_assign,
1134: hz_class_categories c_cat
1135: where c_cat.class_category = c_assign.class_category
1136: and c_cat.class_category = cas.class_category
1137: and c_assign.owner_table_id = cas.party_id

Line 1224: update hz_code_assignments set

1220:
1221: BEGIN
1222:
1223: ForAll j in 1..l_code_assignment_id.count SAVE EXCEPTIONS
1224: update hz_code_assignments set
1225: /* comment out for bug fix 3546566
1226: START_DATE_ACTIVE =
1227: nvl(l_start_date_active(j), start_date_active),
1228: END_DATE_ACTIVE =