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.IEC_WHERECLAUSE_PVT dependencies on IEC_G_LIST_SUBSETS

Line 125: TYPE SUBSET_ID_TBL IS TABLE OF iec_g_list_subsets.list_subset_id%TYPE;

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;
129: l_where_clause VARCHAR2(4000) := NULL;

Line 132: select default_subset_flag into l_default_subset_flag from iec_g_list_subsets

128: l_default_subset_flag VARCHAR2(1) := NULL;
129: l_where_clause VARCHAR2(4000) := NULL;
130: l_where_clause_sub VARCHAR2(4000) := NULL;
131: BEGIN
132: select default_subset_flag into l_default_subset_flag from iec_g_list_subsets
133: where list_subset_id = p_owner_id ;
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);

Line 143: select list_subset_id bulk collect into l_subset_id_tbl from iec_g_list_subsets where list_header_id in

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
143: select list_subset_id bulk collect into l_subset_id_tbl from iec_g_list_subsets where list_header_id in
144: (select list_header_id from iec_g_list_subsets where list_subset_id = p_owner_id )
145: and ( default_subset_flag <>'Y' or default_subset_flag is null);
146:
147: if(l_subset_id_tbl.COUNT = 0) then

Line 144: (select list_header_id from iec_g_list_subsets where list_subset_id = p_owner_id )

140: if(l_rule_id_tbl.COUNT >0 ) then
141: GETWHERECLAUSE(p_owner_id, p_owner_type, l_where_clause);
142: else
143: select list_subset_id bulk collect into l_subset_id_tbl from iec_g_list_subsets where list_header_id in
144: (select list_header_id from iec_g_list_subsets where list_subset_id = p_owner_id )
145: and ( default_subset_flag <>'Y' or default_subset_flag is null);
146:
147: if(l_subset_id_tbl.COUNT = 0) then
148: l_where_clause := NULL;