APPS.IEC_WHERECLAUSE_PVT dependencies on IEC_G_FIELD_CRITERIA

Line 11: TYPE CRITERIA_ID_TBL IS TABLE OF iec_g_field_criteria.criteria_id%TYPE;

7: ,P_OWNER_TYPE VARCHAR2
8: ,WHERECLAUSE OUT VARCHAR2) AS
9: e_operror EXCEPTION;
10: TYPE RULE_ID_TBL IS TABLE OF iec_g_rules.rule_id%TYPE;
11: TYPE CRITERIA_ID_TBL IS TABLE OF iec_g_field_criteria.criteria_id%TYPE;
12: TYPE COMBINATION_CODE_TBL IS TABLE OF iec_g_field_criteria.combination_code%TYPE;
13: TYPE FIELD_NAME_TBL IS TABLE OF iec_g_fields.field_name%TYPE;
14: TYPE FIELD_VALUE_TBL IS TABLE OF iec_g_fields.field_value%TYPE;
15: TYPE OPERATOR_CODE_TBL IS TABLE OF iec_g_fields.operator_code%TYPE;

Line 12: TYPE COMBINATION_CODE_TBL IS TABLE OF iec_g_field_criteria.combination_code%TYPE;

8: ,WHERECLAUSE OUT VARCHAR2) AS
9: e_operror EXCEPTION;
10: TYPE RULE_ID_TBL IS TABLE OF iec_g_rules.rule_id%TYPE;
11: TYPE CRITERIA_ID_TBL IS TABLE OF iec_g_field_criteria.criteria_id%TYPE;
12: TYPE COMBINATION_CODE_TBL IS TABLE OF iec_g_field_criteria.combination_code%TYPE;
13: TYPE FIELD_NAME_TBL IS TABLE OF iec_g_fields.field_name%TYPE;
14: TYPE FIELD_VALUE_TBL IS TABLE OF iec_g_fields.field_value%TYPE;
15: TYPE OPERATOR_CODE_TBL IS TABLE OF iec_g_fields.operator_code%TYPE;
16: TYPE SQL_OPERATOR_TBL IS TABLE OF iec_o_alg_op_defs_b.sql_operator%TYPE;

Line 44: from iec_g_field_criteria where rule_id = l_rule_id_tbl(j);

40: l_rule_flag := 'N';
41: end if;
42:
43: select criteria_id, combination_code bulk collect into l_criteria_id_tbl, l_comb_code_tbl
44: from iec_g_field_criteria where rule_id = l_rule_id_tbl(j);
45: l_criteria_flag := 'Y';
46: for k in 1 .. l_criteria_id_tbl.COUNT
47: loop
48: if(l_criteria_flag <> 'Y') then