APPS.CZ_POPULATORS_PKG dependencies on CZ_FILTER_SETS

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

326: p_err OUT NOCOPY INTEGER) IS
327: var_view_name CZ_POPULATORS.view_name%TYPE;
328: var_based_view CZ_POPULATORS.view_name%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;

Line 331: var_source_type CZ_FILTER_SETS.source_type%TYPE;

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

Line 332: var_rule_id CZ_FILTER_SETS.express_id%TYPE;

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

Line 370: FROM CZ_FILTER_SETS a, CZ_POPULATORS b

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

Line 380: FROM CZ_FILTER_SETS

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

Line 511: var_filter_set_id CZ_FILTER_SETS.filter_set_id%TYPE;

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

Line 626: SELECT rule_id INTO var_rule_id FROM CZ_FILTER_SETS

622:
623: --
624: -- find express_id which corresponds with Populator definition --
625: --
626: SELECT rule_id INTO var_rule_id FROM CZ_FILTER_SETS
627: WHERE filter_set_id=var_filter_set_id;
628:
629: --
630: -- find Timestamp of Populator definition --