eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ECE_RULES_PKG dependencies on ECE_RULE_SIMPLE_LOOKUP

Line 1073: l_column ece_rule_simple_lookup.lookup_column%TYPE;

1069: x_valid_rule OUT NOCOPY VARCHAR2,
1070: x_msg_text OUT NOCOPY VARCHAR2) IS
1071:
1072: xProgress VARCHAR2(80);
1073: l_column ece_rule_simple_lookup.lookup_column%TYPE;
1074: l_table ece_rule_simple_lookup.lookup_table%TYPE;
1075: l_where_clause ece_rule_simple_lookup.lookup_where_clause%TYPE;
1076: l_select VARCHAR2(32000);
1077: l_from VARCHAR2(32000);

Line 1074: l_table ece_rule_simple_lookup.lookup_table%TYPE;

1070: x_msg_text OUT NOCOPY VARCHAR2) IS
1071:
1072: xProgress VARCHAR2(80);
1073: l_column ece_rule_simple_lookup.lookup_column%TYPE;
1074: l_table ece_rule_simple_lookup.lookup_table%TYPE;
1075: l_where_clause ece_rule_simple_lookup.lookup_where_clause%TYPE;
1076: l_select VARCHAR2(32000);
1077: l_from VARCHAR2(32000);
1078: l_where VARCHAR2(32000);

Line 1075: l_where_clause ece_rule_simple_lookup.lookup_where_clause%TYPE;

1071:
1072: xProgress VARCHAR2(80);
1073: l_column ece_rule_simple_lookup.lookup_column%TYPE;
1074: l_table ece_rule_simple_lookup.lookup_table%TYPE;
1075: l_where_clause ece_rule_simple_lookup.lookup_where_clause%TYPE;
1076: l_select VARCHAR2(32000);
1077: l_from VARCHAR2(32000);
1078: l_where VARCHAR2(32000);
1079: l_sel_c INTEGER;

Line 1085: from ece_rule_simple_lookup

1081: l_dummy INTEGER;
1082:
1083: CURSOR c_simple_lookup_rule IS
1084: select lookup_column, lookup_table, lookup_where_clause
1085: from ece_rule_simple_lookup
1086: where column_rule_id = p_rule_id;
1087:
1088: BEGIN
1089: