APPS.CZ_UIOA_PVT dependencies on CZ_EXPRESSION_NODES

Line 3284: l_ui_cx_command_name CZ_EXPRESSION_NODES.data_value%TYPE;

3280: FUNCTION get_CX_Button_Status(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
3281: RETURN VARCHAR2 IS
3282:
3283: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
3284: l_ui_cx_command_name CZ_EXPRESSION_NODES.data_value%TYPE;
3285: l_undeleted_exist BOOLEAN;
3286:
3287: BEGIN
3288:

Line 3307: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

3303:
3304: l_undeleted_exist := FALSE;
3305: FOR i IN(SELECT a.deleted_flag, a.invalid_flag, a.disabled_flag ,
3306: a.INSTANTIATION_SCOPE, b.data_value, a.name
3307: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
3308: WHERE a.devl_project_id=l_model_node.devl_project_id AND
3309: a.component_id=l_model_node.ps_node_id AND
3310: a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
3311: a.deleted_flag=G_NO_FLAG AND

Line 3332: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

3328: IF l_model_node.ps_node_type=G_REFERENCE_TYPE THEN
3329:
3330: FOR i IN(SELECT a.name, a.deleted_flag, a.invalid_flag, a.disabled_flag,
3331: a.INSTANTIATION_SCOPE, b.data_value
3332: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
3333: WHERE a.devl_project_id=l_model_node.devl_project_id AND
3334: a.component_id IN
3335: (SELECT ps_node_id FROM CZ_PS_NODES
3336: WHERE devl_project_id IN

Line 9468: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

9464: RETURN;
9465: END IF;
9466:
9467: FOR i IN(SELECT DISTINCT b.data_value, b.expr_node_id, a.INSTANTIATION_SCOPE, a.name
9468: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
9469: WHERE a.devl_project_id=p_node.devl_project_id AND
9470: a.component_id=p_node.ps_node_id AND
9471: a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
9472: a.deleted_flag=G_NO_FLAG AND

Line 9638: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

9634:
9635: IF p_node.ps_node_type=G_REFERENCE_TYPE THEN
9636:
9637: FOR i IN(SELECT a.model_ref_expl_id, b.data_value, a.component_id, b.expr_node_id, a.name, a.INSTANTIATION_SCOPE
9638: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
9639: WHERE a.devl_project_id=p_node.devl_project_id AND
9640: a.component_id IN
9641: (SELECT ps_node_id FROM CZ_PS_NODES
9642: WHERE devl_project_id IN

Line 9882: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

9878: deleted_flag NOT IN(G_YES_FLAG, G_MARK_TO_DELETE, G_LIMBO_FLAG))
9879: LOOP
9880:
9881: FOR i IN(SELECT DISTINCT b.data_value, b.expr_node_id, a.INSTANTIATION_SCOPE, a.NAME
9882: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
9883: WHERE a.devl_project_id=g_UI_Context.devl_project_id AND
9884: a.component_id=option_node.ps_node_id AND
9885: a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
9886: a.deleted_flag=G_NO_FLAG AND

Line 10092: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

10088: (SELECT persistent_node_id
10089: FROM CZ_PS_NODES
10090: WHERE devl_project_id = g_UI_Context.devl_project_id
10091: AND ps_node_id = a.component_id) persistent_node_Id
10092: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
10093: WHERE a.devl_project_id=g_UI_Context.devl_project_id AND
10094: a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
10095: b.rule_id=a.rule_id AND
10096: b.argument_signature_id=G_EVENT_ON_COMMAND_SIGID AND