APPS.ECE_RULES_PKG dependencies on ECE_RULE_NULL_DEP

Line 1355: l_comp_code ece_rule_null_dep.comparison_code%TYPE;

1351: x_msg_text OUT NOCOPY VARCHAR2) IS
1352:
1353: xProgress VARCHAR2(80);
1354: l_null_rule_id NUMBER;
1355: l_comp_code ece_rule_null_dep.comparison_code%TYPE;
1356: l_rule_column ece_rule_null_dep_details.interface_column%TYPE;
1357: l_column_pos NUMBER;
1358: l_detail_comp_code ece_rule_null_dep_details.comparison_code%TYPE;
1359: l_rule_value ece_rule_null_dep_details.value%TYPE;

Line 1356: l_rule_column ece_rule_null_dep_details.interface_column%TYPE;

1352:
1353: xProgress VARCHAR2(80);
1354: l_null_rule_id NUMBER;
1355: l_comp_code ece_rule_null_dep.comparison_code%TYPE;
1356: l_rule_column ece_rule_null_dep_details.interface_column%TYPE;
1357: l_column_pos NUMBER;
1358: l_detail_comp_code ece_rule_null_dep_details.comparison_code%TYPE;
1359: l_rule_value ece_rule_null_dep_details.value%TYPE;
1360: l_column_value VARCHAR2(500);

Line 1358: l_detail_comp_code ece_rule_null_dep_details.comparison_code%TYPE;

1354: l_null_rule_id NUMBER;
1355: l_comp_code ece_rule_null_dep.comparison_code%TYPE;
1356: l_rule_column ece_rule_null_dep_details.interface_column%TYPE;
1357: l_column_pos NUMBER;
1358: l_detail_comp_code ece_rule_null_dep_details.comparison_code%TYPE;
1359: l_rule_value ece_rule_null_dep_details.value%TYPE;
1360: l_column_value VARCHAR2(500);
1361: condition BOOLEAN := true;
1362:

Line 1359: l_rule_value ece_rule_null_dep_details.value%TYPE;

1355: l_comp_code ece_rule_null_dep.comparison_code%TYPE;
1356: l_rule_column ece_rule_null_dep_details.interface_column%TYPE;
1357: l_column_pos NUMBER;
1358: l_detail_comp_code ece_rule_null_dep_details.comparison_code%TYPE;
1359: l_rule_value ece_rule_null_dep_details.value%TYPE;
1360: l_column_value VARCHAR2(500);
1361: condition BOOLEAN := true;
1362:
1363: CURSOR c_null_dependency IS

Line 1365: from ece_rule_null_dep

1361: condition BOOLEAN := true;
1362:
1363: CURSOR c_null_dependency IS
1364: select null_dependency_rule_id, comparison_code
1365: from ece_rule_null_dep
1366: where column_rule_id = p_rule_id;
1367:
1368: CURSOR c_null_dependency_detail IS
1369: select interface_column, comparison_code, value

Line 1370: from ece_rule_null_dep_details

1366: where column_rule_id = p_rule_id;
1367:
1368: CURSOR c_null_dependency_detail IS
1369: select interface_column, comparison_code, value
1370: from ece_rule_null_dep_details
1371: where null_dependency_rule_id = l_null_rule_id
1372: order by null_dependency_detail_id;
1373:
1374: BEGIN