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 234: var_field_name CZ_EXPRESSION_NODES.field_name%TYPE;

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

Line 235: var_data_value CZ_EXPRESSION_NODES.data_value%TYPE;

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

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

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

Line 246: INTO var_field_name FROM CZ_EXPRESSION_NODES

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

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

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

Line 323: -- from CZ_FILTER_SETS,CZ_EXPRESSION_NODES --

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

Line 336: var_operator CZ_EXPRESSION_NODES.expr_subtype%TYPE;

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

Line 337: var_data_value CZ_EXPRESSION_NODES.data_value%TYPE;

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

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

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

Line 636: SELECT LAST_UPDATE_DATE INTO var_curr_date FROM CZ_EXPRESSION_NODES

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

Line 646: -- properly setting of cz_expression_nodes.last_update_date

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