APPS.IEC_WHERECLAUSE_PVT dependencies on IEC_G_RULES

Line 10: TYPE RULE_ID_TBL IS TABLE OF iec_g_rules.rule_id%TYPE;

6: (P_OWNER_ID NUMBER
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;

Line 31: select rule_id bulk collect into l_rule_id_tbl from iec_g_rules

27: l_criteria_flag CHAR(1) := 'Y';
28: l_field_flag CHAR(1) := 'Y';
29: l_where_clause VARCHAR2(4000) := NULL;
30: BEGIN
31: select rule_id bulk collect into l_rule_id_tbl from iec_g_rules
32: where owner_id = p_owner_id and owner_type_code = p_owner_type;
33:
34: for j in 1 ..l_rule_id_tbl.COUNT
35: loop

Line 124: TYPE RULE_ID_TBL IS TABLE OF iec_g_rules.rule_id%TYPE;

120: (P_OWNER_ID NUMBER
121: ,P_OWNER_TYPE VARCHAR2
122: ,WHERECLAUSE OUT VARCHAR2)AS
123: e_operror EXCEPTION;
124: TYPE RULE_ID_TBL IS TABLE OF iec_g_rules.rule_id%TYPE;
125: TYPE SUBSET_ID_TBL IS TABLE OF iec_g_list_subsets.list_subset_id%TYPE;
126: l_subset_id_tbl SUBSET_ID_TBL;
127: l_rule_id_tbl RULE_ID_TBL;
128: l_default_subset_flag VARCHAR2(1) := NULL;

Line 138: select rule_id bulk collect into l_rule_id_tbl from iec_g_rules

134:
135: if(l_default_subset_flag is null or l_default_subset_flag <>'Y') then
136: GETWHERECLAUSE(p_owner_id, p_owner_type, l_where_clause);
137: else
138: select rule_id bulk collect into l_rule_id_tbl from iec_g_rules
139: where owner_id = p_owner_id and owner_type_code = p_owner_type;
140: if(l_rule_id_tbl.COUNT >0 ) then
141: GETWHERECLAUSE(p_owner_id, p_owner_type, l_where_clause);
142: else