APPS.ECE_INBOUND dependencies on ECE_RULE_VIOLATIONS

Line 198: Gather table Statistics for CBO ( ece_stage , ece_rule_violations ).

194: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
195: ec_debug.pl(3,'i_run_id',i_run_id);
196: end if;
197: /**
198: Gather table Statistics for CBO ( ece_stage , ece_rule_violations ).
199: **/
200: /**
201: fnd_stats.gather_table_stats
202: (

Line 214: 'ECE_RULE_VIOLATIONS',

210: );
211: fnd_stats.gather_table_stats
212: (
213: 'EC',
214: 'ECE_RULE_VIOLATIONS',
215: 20,
216: null,
217: null,
218: null,

Line 280: delete from ece_rule_violations

276: or ec_utils.g_ext_levels(1).Status = 'NEW'
277: or ec_utils.g_ext_levels(1).Status = 'RE_PROCESS'
278: )
279: then
280: delete from ece_rule_violations
281: where document_id = c1.document_id;
282:
283: delete from ece_stage
284: where document_id = c1.document_id;

Line 694: from ece_rule_violations

690: CURSOR c_ignore_rule (
691: p_document_id IN NUMBER
692: ) IS
693: select stage_id,rule_id,interface_column_id
694: from ece_rule_violations
695: where document_id = p_document_id and
696: violation_level = 'COLUMN' and
697: nvl(ignore_flag,'N') = 'Y';
698:

Line 1498: Delete from ece_rule_violations

1494: end if;
1495: /**
1496: Delete the Old violations for this Document
1497: **/
1498: Delete from ece_rule_violations
1499: where document_id = i_document_id
1500: and ignore_flag = 'N';
1501:
1502:

Line 1505: INSERT into ece_rule_violations

1501:
1502:
1503: for i in 1..ece_rules_pkg.g_rule_violation_tbl.COUNT
1504: loop
1505: INSERT into ece_rule_violations
1506: (
1507: violation_id,
1508: document_id,
1509: stage_id,

Line 1846: delete from ece_rule_violations

1842: or ec_utils.g_ext_levels(1).Status = 'NEW'
1843: or ec_utils.g_ext_levels(1).Status = 'RE_PROCESS'
1844: )
1845: then
1846: delete from ece_rule_violations
1847: where document_id = i_document_id;
1848:
1849: delete from ece_stage
1850: where document_id = i_document_id;