APPS.CZ_POPULATORS_PKG dependencies on CZ_FILTER_SETS

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 333: var_filter_set_id CZ_FILTER_SETS.filter_set_id%TYPE;

329: p_err OUT NOCOPY INTEGER) IS
330: var_view_name CZ_POPULATORS.view_name%TYPE;
331: var_based_view CZ_POPULATORS.view_name%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;

Line 334: var_source_type CZ_FILTER_SETS.source_type%TYPE;

330: var_view_name CZ_POPULATORS.view_name%TYPE;
331: var_based_view CZ_POPULATORS.view_name%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;

Line 335: var_rule_id CZ_FILTER_SETS.express_id%TYPE;

331: var_based_view CZ_POPULATORS.view_name%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;

Line 373: FROM CZ_FILTER_SETS a, CZ_POPULATORS b

369:
370: BEGIN
371: SELECT a.source_type,a.rule_id,b.view_name
372: INTO var_source_type,var_rule_id,var_based_view
373: FROM CZ_FILTER_SETS a, CZ_POPULATORS b
374: WHERE a.filter_set_id=var_filter_set_id AND a.source_type=b.populator_id;
375: EXCEPTION
376: WHEN OTHERS THEN
377: there_is_no_seed_data:=TRUE;

Line 383: FROM CZ_FILTER_SETS

379:
380: IF there_is_no_seed_data THEN
381: SELECT source_type,rule_id
382: INTO var_source_type,var_rule_id
383: FROM CZ_FILTER_SETS
384: WHERE filter_set_id=var_filter_set_id;
385: IF var_source_type=1 THEN
386: var_based_view:='CZ_ITEM_ITEM_POP_V';
387: ELSIF var_source_type=2 THEN

Line 514: var_filter_set_id CZ_FILTER_SETS.filter_set_id%TYPE;

510: var_has_level CZ_POPULATORS.has_level%TYPE;
511: var_has_item CZ_POPULATORS.has_item%TYPE;
512: var_has_item_type CZ_POPULATORS.has_item_type%TYPE;
513: var_has_property CZ_POPULATORS.has_property%TYPE;
514: var_filter_set_id CZ_FILTER_SETS.filter_set_id%TYPE;
515: var_express_id CZ_EXPRESSIONS.express_id%TYPE;
516: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
517: var_project_id CZ_PS_NODES.devl_project_id%TYPE;
518: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;

Line 630: SELECT rule_id INTO var_rule_id FROM CZ_FILTER_SETS

626:
627: --
628: -- find express_id which corresponds with Populator definition --
629: --
630: SELECT rule_id INTO var_rule_id FROM CZ_FILTER_SETS
631: WHERE filter_set_id=var_filter_set_id;
632:
633: --
634: -- find Timestamp of Populator definition --