DBA Data[Home] [Help]

APPS.ECE_RULES_PKG dependencies on ECE_RULE_LIST

Line 1509: l_comp_code ece_rule_list.comparison_code%TYPE;

1505: x_msg_text OUT NOCOPY VARCHAR2) IS
1506:
1507: xProgress VARCHAR2(80);
1508: l_list_rule_id NUMBER;
1509: l_comp_code ece_rule_list.comparison_code%TYPE;
1510: l_match NUMBER;
1511:
1512: CURSOR c_predefined_list IS
1513: select list_rule_id, comparison_code

Line 1514: from ece_rule_list

1510: l_match NUMBER;
1511:
1512: CURSOR c_predefined_list IS
1513: select list_rule_id, comparison_code
1514: from ece_rule_list
1515: where column_rule_id = p_rule_id;
1516:
1517: CURSOR c_list_count IS
1518: select count(*)

Line 1519: from ece_rule_list_details

1515: where column_rule_id = p_rule_id;
1516:
1517: CURSOR c_list_count IS
1518: select count(*)
1519: from ece_rule_list_details
1520: where list_rule_id = l_list_rule_id and
1521: value = p_column_value;
1522:
1523: BEGIN