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,
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,
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,
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,
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,
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);
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:
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;
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);
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);