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.BOM_FILTER dependencies on DBMS_SQL

Line 24: PROCEDURE applyFilter (p_ParamSortOrder dbms_sql.VARCHAR2_TABLE, p_GroupId VARCHAR2) as

20: +==========================================================================*/
21:
22: G_PARAM_LIST PARAM_LIST;
23:
24: PROCEDURE applyFilter (p_ParamSortOrder dbms_sql.VARCHAR2_TABLE, p_GroupId VARCHAR2) as
25:
26: l_st DATE := sysdate;
27: BEGIN
28:

Line 116: filter_cursor INTEGER := DBMS_SQL.OPEN_CURSOR;

112: , p_GroupId IN NUMBER
113: , p_TemplateId IN NUMBER
114: )
115: AS
116: filter_cursor INTEGER := DBMS_SQL.OPEN_CURSOR;
117: rows_processed BINARY_INTEGER;
118: --sort_order_t sort_order := sort_order();
119: ind NUMBER := 0;
120: l_sort_order VARCHAR2(2000);

Line 131: DBMS_SQL.PARSE

127: --
128: -- parse the query and get only the sort_orders
129: --
130: --sort_order_t := sort_order();
131: DBMS_SQL.PARSE
132: ( filter_cursor
133: , 'SELECT st_order
134: FROM ( ' || p_filterQuery ||
135: ' ) order by st_order'

Line 136: , DBMS_SQL.NATIVE

132: ( filter_cursor
133: , 'SELECT st_order
134: FROM ( ' || p_filterQuery ||
135: ' ) order by st_order'
136: , DBMS_SQL.NATIVE
137: );
138:
139: --DBMS_SQL.DEFINE_COLUMN(filter_cursor,1,l_sort_order,2000);
140: DBMS_SQL.DEFINE_ARRAY(filter_cursor,1,bom_filter.sort_order_t,1000,1);

Line 139: --DBMS_SQL.DEFINE_COLUMN(filter_cursor,1,l_sort_order,2000);

135: ' ) order by st_order'
136: , DBMS_SQL.NATIVE
137: );
138:
139: --DBMS_SQL.DEFINE_COLUMN(filter_cursor,1,l_sort_order,2000);
140: DBMS_SQL.DEFINE_ARRAY(filter_cursor,1,bom_filter.sort_order_t,1000,1);
141: /*
142: DBMS_SQL.PARSE
143: ( filter_cursor

Line 140: DBMS_SQL.DEFINE_ARRAY(filter_cursor,1,bom_filter.sort_order_t,1000,1);

136: , DBMS_SQL.NATIVE
137: );
138:
139: --DBMS_SQL.DEFINE_COLUMN(filter_cursor,1,l_sort_order,2000);
140: DBMS_SQL.DEFINE_ARRAY(filter_cursor,1,bom_filter.sort_order_t,1000,1);
141: /*
142: DBMS_SQL.PARSE
143: ( filter_cursor
144: , 'SELECT ST_ORDER sort_order ' ||

Line 142: DBMS_SQL.PARSE

138:
139: --DBMS_SQL.DEFINE_COLUMN(filter_cursor,1,l_sort_order,2000);
140: DBMS_SQL.DEFINE_ARRAY(filter_cursor,1,bom_filter.sort_order_t,1000,1);
141: /*
142: DBMS_SQL.PARSE
143: ( filter_cursor
144: , 'SELECT ST_ORDER sort_order ' ||
145: 'BULK COLLECT INTO ' || ':'||G_PARAM_LIST.COUNT+1 ||
146: ' FROM ' ||

Line 150: , DBMS_SQL.NATIVE

146: ' FROM ' ||
147: ' ( ' ||
148: p_FilterQuery ||
149: ' ) '
150: , DBMS_SQL.NATIVE
151: );
152: */
153: --
154: -- bind all the parameters and execute

Line 158: DBMS_SQL.BIND_VARIABLE(filter_cursor, ':'||params,G_PARAM_LIST(params));

154: -- bind all the parameters and execute
155: --
156: FOR params IN 1..G_PARAM_LIST.COUNT
157: LOOP
158: DBMS_SQL.BIND_VARIABLE(filter_cursor, ':'||params,G_PARAM_LIST(params));
159: END LOOP;
160:
161: --
162: -- Execute and fetch all components that match the criteria

Line 164: rows_processed := DBMS_SQL.EXECUTE(filter_cursor);

160:
161: --
162: -- Execute and fetch all components that match the criteria
163: --
164: rows_processed := DBMS_SQL.EXECUTE(filter_cursor);
165: LOOP
166: -- fetch a row
167: rows_processed := dbms_sql.fetch_rows(filter_cursor);
168: -- fetch columns from the row

Line 167: rows_processed := dbms_sql.fetch_rows(filter_cursor);

163: --
164: rows_processed := DBMS_SQL.EXECUTE(filter_cursor);
165: LOOP
166: -- fetch a row
167: rows_processed := dbms_sql.fetch_rows(filter_cursor);
168: -- fetch columns from the row
169: dbms_sql.column_value(filter_cursor, 1, bom_filter.sort_order_t);
170: EXIT WHEN rows_processed <> 1000;
171:

Line 169: dbms_sql.column_value(filter_cursor, 1, bom_filter.sort_order_t);

165: LOOP
166: -- fetch a row
167: rows_processed := dbms_sql.fetch_rows(filter_cursor);
168: -- fetch columns from the row
169: dbms_sql.column_value(filter_cursor, 1, bom_filter.sort_order_t);
170: EXIT WHEN rows_processed <> 1000;
171:
172: END LOOP;
173: DBMS_SQL.CLOSE_CURSOR(filter_cursor);

Line 173: DBMS_SQL.CLOSE_CURSOR(filter_cursor);

169: dbms_sql.column_value(filter_cursor, 1, bom_filter.sort_order_t);
170: EXIT WHEN rows_processed <> 1000;
171:
172: END LOOP;
173: DBMS_SQL.CLOSE_CURSOR(filter_cursor);
174: enableParents;
175: applyFilter(bom_filter.sort_order_t, p_GroupId);
176: EXCEPTION
177: WHEN OTHERS THEN

Line 178: IF (DBMS_SQL.IS_OPEN(filter_cursor))

174: enableParents;
175: applyFilter(bom_filter.sort_order_t, p_GroupId);
176: EXCEPTION
177: WHEN OTHERS THEN
178: IF (DBMS_SQL.IS_OPEN(filter_cursor))
179: THEN
180: DBMS_SQL.CLOSE_CURSOR(filter_cursor);
181: END IF;
182: RAISE;

Line 180: DBMS_SQL.CLOSE_CURSOR(filter_cursor);

176: EXCEPTION
177: WHEN OTHERS THEN
178: IF (DBMS_SQL.IS_OPEN(filter_cursor))
179: THEN
180: DBMS_SQL.CLOSE_CURSOR(filter_cursor);
181: END IF;
182: RAISE;
183: END applyFilter;
184: /* Procedure Apply filter Ends */