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.CZ_POPULATORS_PKG dependencies on CZ_EXPRESSION_NODES

Line 231: var_field_name CZ_EXPRESSION_NODES.field_name%TYPE;

227: TYPE t_arr IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
228: t_where t_arr;
229: var_data_value_tbl t_arr;
230: var_where VARCHAR2(4000);
231: var_field_name CZ_EXPRESSION_NODES.field_name%TYPE;
232: var_data_value CZ_EXPRESSION_NODES.data_value%TYPE;
233: var_filter VARCHAR2(4000);
234: var_operator VARCHAR2(50);
235: var_counter NUMBER:=0;

Line 232: var_data_value CZ_EXPRESSION_NODES.data_value%TYPE;

228: t_where t_arr;
229: var_data_value_tbl t_arr;
230: var_where VARCHAR2(4000);
231: var_field_name CZ_EXPRESSION_NODES.field_name%TYPE;
232: var_data_value CZ_EXPRESSION_NODES.data_value%TYPE;
233: var_filter VARCHAR2(4000);
234: var_operator VARCHAR2(50);
235: var_counter NUMBER:=0;
236: BEGIN

Line 237: FOR i IN(SELECT expr_node_id,field_name,expr_subtype,seq_nbr FROM CZ_EXPRESSION_NODES

233: var_filter VARCHAR2(4000);
234: var_operator VARCHAR2(50);
235: var_counter NUMBER:=0;
236: BEGIN
237: FOR i IN(SELECT expr_node_id,field_name,expr_subtype,seq_nbr FROM CZ_EXPRESSION_NODES
238: WHERE rule_id=p_rule_id AND (field_name IS NULL AND data_value IS NULL)
239: AND deleted_flag='0' ORDER BY seq_nbr)
240: LOOP
241: BEGIN

Line 243: INTO var_field_name FROM CZ_EXPRESSION_NODES

239: AND deleted_flag='0' ORDER BY seq_nbr)
240: LOOP
241: BEGIN
242: SELECT DECODE(field_name,'ref_part_nbr','item_master_name',field_name)
243: INTO var_field_name FROM CZ_EXPRESSION_NODES
244: WHERE expr_parent_id=i.expr_node_id AND field_name IS NOT NULL;
245: BEGIN
246: SELECT REPLACE(data_value,'''','''''') BULK COLLECT INTO var_data_value_tbl FROM CZ_EXPRESSION_NODES
247: WHERE expr_parent_id=i.expr_node_id AND data_value IS NOT NULL

Line 246: SELECT REPLACE(data_value,'''','''''') BULK COLLECT INTO var_data_value_tbl FROM CZ_EXPRESSION_NODES

242: SELECT DECODE(field_name,'ref_part_nbr','item_master_name',field_name)
243: INTO var_field_name FROM CZ_EXPRESSION_NODES
244: WHERE expr_parent_id=i.expr_node_id AND field_name IS NOT NULL;
245: BEGIN
246: SELECT REPLACE(data_value,'''','''''') BULK COLLECT INTO var_data_value_tbl FROM CZ_EXPRESSION_NODES
247: WHERE expr_parent_id=i.expr_node_id AND data_value IS NOT NULL
248: AND deleted_flag='0';
249: IF var_data_value_tbl.COUNT>0 THEN
250: var_data_value := var_data_value_tbl(1);

Line 320: -- from CZ_FILTER_SETS,CZ_EXPRESSION_NODES --

316: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
317: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
318:
319: -- create sql query or view based on data --
320: -- from CZ_FILTER_SETS,CZ_EXPRESSION_NODES --
321:
322: PROCEDURE Regenerate_unsec
323: (p_populator_id IN INTEGER,
324: p_view_name IN OUT NOCOPY VARCHAR2,

Line 333: var_operator CZ_EXPRESSION_NODES.expr_subtype%TYPE;

329: var_sql CZ_POPULATORS.query_syntax%TYPE;
330: var_filter_set_id CZ_FILTER_SETS.filter_set_id%TYPE;
331: var_source_type CZ_FILTER_SETS.source_type%TYPE;
332: var_rule_id CZ_FILTER_SETS.express_id%TYPE;
333: var_operator CZ_EXPRESSION_NODES.expr_subtype%TYPE;
334: var_data_value CZ_EXPRESSION_NODES.data_value%TYPE;
335: var_name CZ_PS_NODES.name%TYPE;
336: var_pop_name CZ_POPULATORS.name%TYPE;
337: var_property_id CZ_PROPERTIES.property_id%TYPE;

Line 334: var_data_value CZ_EXPRESSION_NODES.data_value%TYPE;

330: var_filter_set_id CZ_FILTER_SETS.filter_set_id%TYPE;
331: var_source_type CZ_FILTER_SETS.source_type%TYPE;
332: var_rule_id CZ_FILTER_SETS.express_id%TYPE;
333: var_operator CZ_EXPRESSION_NODES.expr_subtype%TYPE;
334: var_data_value CZ_EXPRESSION_NODES.data_value%TYPE;
335: var_name CZ_PS_NODES.name%TYPE;
336: var_pop_name CZ_POPULATORS.name%TYPE;
337: var_property_id CZ_PROPERTIES.property_id%TYPE;
338: var_item_type_id CZ_ITEM_TYPES.item_type_id%TYPE;

Line 396: -- create Populator sql query based on data from CZ_EXPRESSION_NODES table --

392: END IF;
393: END IF;
394:
395: --
396: -- create Populator sql query based on data from CZ_EXPRESSION_NODES table --
397: --
398: IF var_based_view<>USER_VIEW THEN
399: var_sql:='select * from '||var_based_view||' where '||get_Where(var_rule_id);
400: END IF;

Line 632: SELECT LAST_UPDATE_DATE INTO var_curr_date FROM CZ_EXPRESSION_NODES

628:
629: --
630: -- find Timestamp of Populator definition --
631: --
632: SELECT LAST_UPDATE_DATE INTO var_curr_date FROM CZ_EXPRESSION_NODES
633: WHERE rule_id=var_rule_id AND expr_parent_id IS NULL AND deleted_flag='0';
634:
635: --
636: -- if definition has been changed then --

Line 642: -- properly setting of cz_expression_nodes.last_update_date

638: --
639:
640: -- the condition is commented out temporary
641: -- because of the problem in Developer with
642: -- properly setting of cz_expression_nodes.last_update_date
643: --
644: IF var_last_update<=var_curr_date OR var_last_update IS NULL OR mALWAYS_REGENERATE IN('1','Y') THEN
645: Regenerate_unsec(p_populator_id => p_populator_id,
646: p_view_name => var_view_name,