DBA Data[Home] [Help]

APPS.ECE_RULES_PKG dependencies on ECE_RULE_VIOLATIONS

Line 37: violation_id ece_rule_violations.violation_id%TYPE,

33: g_supplier CONSTANT VARCHAR2(15) := 'SUPPLIER';
34: g_hr_location CONSTANT VARCHAR2(15) := 'HR_LOCATION';
35:
36: TYPE rule_violation_record_type is RECORD (
37: violation_id ece_rule_violations.violation_id%TYPE,
38: document_id ece_rule_violations.document_id%TYPE,
39: stage_id ece_rule_violations.stage_id%TYPE,
40: interface_column_id ece_rule_violations.interface_column_id%TYPE,
41: rule_id ece_rule_violations.rule_id%TYPE,

Line 38: document_id ece_rule_violations.document_id%TYPE,

34: g_hr_location CONSTANT VARCHAR2(15) := 'HR_LOCATION';
35:
36: TYPE rule_violation_record_type is RECORD (
37: violation_id ece_rule_violations.violation_id%TYPE,
38: document_id ece_rule_violations.document_id%TYPE,
39: stage_id ece_rule_violations.stage_id%TYPE,
40: interface_column_id ece_rule_violations.interface_column_id%TYPE,
41: rule_id ece_rule_violations.rule_id%TYPE,
42: transaction_type ece_rule_violations.transaction_type%TYPE,

Line 39: stage_id ece_rule_violations.stage_id%TYPE,

35:
36: TYPE rule_violation_record_type is RECORD (
37: violation_id ece_rule_violations.violation_id%TYPE,
38: document_id ece_rule_violations.document_id%TYPE,
39: stage_id ece_rule_violations.stage_id%TYPE,
40: interface_column_id ece_rule_violations.interface_column_id%TYPE,
41: rule_id ece_rule_violations.rule_id%TYPE,
42: transaction_type ece_rule_violations.transaction_type%TYPE,
43: document_number ece_rule_violations.document_number%TYPE,

Line 40: interface_column_id ece_rule_violations.interface_column_id%TYPE,

36: TYPE rule_violation_record_type is RECORD (
37: violation_id ece_rule_violations.violation_id%TYPE,
38: document_id ece_rule_violations.document_id%TYPE,
39: stage_id ece_rule_violations.stage_id%TYPE,
40: interface_column_id ece_rule_violations.interface_column_id%TYPE,
41: rule_id ece_rule_violations.rule_id%TYPE,
42: transaction_type ece_rule_violations.transaction_type%TYPE,
43: document_number ece_rule_violations.document_number%TYPE,
44: violation_level ece_rule_violations.violation_level%TYPE,

Line 41: rule_id ece_rule_violations.rule_id%TYPE,

37: violation_id ece_rule_violations.violation_id%TYPE,
38: document_id ece_rule_violations.document_id%TYPE,
39: stage_id ece_rule_violations.stage_id%TYPE,
40: interface_column_id ece_rule_violations.interface_column_id%TYPE,
41: rule_id ece_rule_violations.rule_id%TYPE,
42: transaction_type ece_rule_violations.transaction_type%TYPE,
43: document_number ece_rule_violations.document_number%TYPE,
44: violation_level ece_rule_violations.violation_level%TYPE,
45: ignore_flag ece_rule_violations.ignore_flag%TYPE,

Line 42: transaction_type ece_rule_violations.transaction_type%TYPE,

38: document_id ece_rule_violations.document_id%TYPE,
39: stage_id ece_rule_violations.stage_id%TYPE,
40: interface_column_id ece_rule_violations.interface_column_id%TYPE,
41: rule_id ece_rule_violations.rule_id%TYPE,
42: transaction_type ece_rule_violations.transaction_type%TYPE,
43: document_number ece_rule_violations.document_number%TYPE,
44: violation_level ece_rule_violations.violation_level%TYPE,
45: ignore_flag ece_rule_violations.ignore_flag%TYPE,
46: message_text ece_rule_violations.message_text%TYPE);

Line 43: document_number ece_rule_violations.document_number%TYPE,

39: stage_id ece_rule_violations.stage_id%TYPE,
40: interface_column_id ece_rule_violations.interface_column_id%TYPE,
41: rule_id ece_rule_violations.rule_id%TYPE,
42: transaction_type ece_rule_violations.transaction_type%TYPE,
43: document_number ece_rule_violations.document_number%TYPE,
44: violation_level ece_rule_violations.violation_level%TYPE,
45: ignore_flag ece_rule_violations.ignore_flag%TYPE,
46: message_text ece_rule_violations.message_text%TYPE);
47:

Line 44: violation_level ece_rule_violations.violation_level%TYPE,

40: interface_column_id ece_rule_violations.interface_column_id%TYPE,
41: rule_id ece_rule_violations.rule_id%TYPE,
42: transaction_type ece_rule_violations.transaction_type%TYPE,
43: document_number ece_rule_violations.document_number%TYPE,
44: violation_level ece_rule_violations.violation_level%TYPE,
45: ignore_flag ece_rule_violations.ignore_flag%TYPE,
46: message_text ece_rule_violations.message_text%TYPE);
47:
48: TYPE Rule_Violation_Table is TABLE of rule_violation_record_type index by BINARY_INTEGER;

Line 45: ignore_flag ece_rule_violations.ignore_flag%TYPE,

41: rule_id ece_rule_violations.rule_id%TYPE,
42: transaction_type ece_rule_violations.transaction_type%TYPE,
43: document_number ece_rule_violations.document_number%TYPE,
44: violation_level ece_rule_violations.violation_level%TYPE,
45: ignore_flag ece_rule_violations.ignore_flag%TYPE,
46: message_text ece_rule_violations.message_text%TYPE);
47:
48: TYPE Rule_Violation_Table is TABLE of rule_violation_record_type index by BINARY_INTEGER;
49: g_party_name varchar2(32767);

Line 46: message_text ece_rule_violations.message_text%TYPE);

42: transaction_type ece_rule_violations.transaction_type%TYPE,
43: document_number ece_rule_violations.document_number%TYPE,
44: violation_level ece_rule_violations.violation_level%TYPE,
45: ignore_flag ece_rule_violations.ignore_flag%TYPE,
46: message_text ece_rule_violations.message_text%TYPE);
47:
48: TYPE Rule_Violation_Table is TABLE of rule_violation_record_type index by BINARY_INTEGER;
49: g_party_name varchar2(32767);
50: g_party_number varchar2(32767);