APPS.CZ_UIOA_PVT dependencies on CZ_EXPRESSION_NODES

Line 3222: l_ui_cx_command_name CZ_EXPRESSION_NODES.data_value%TYPE;

3218: FUNCTION get_CX_Button_Status(p_ui_node IN CZ_UI_PAGE_ELEMENTS%ROWTYPE)
3219: RETURN VARCHAR2 IS
3220:
3221: l_model_node CZ_UITEMPLS_FOR_PSNODES_V%ROWTYPE;
3222: l_ui_cx_command_name CZ_EXPRESSION_NODES.data_value%TYPE;
3223: l_undeleted_exist BOOLEAN;
3224:
3225: BEGIN
3226:

Line 3245: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

3241:
3242: l_undeleted_exist := FALSE;
3243: FOR i IN(SELECT a.deleted_flag, a.invalid_flag, a.disabled_flag ,
3244: a.INSTANTIATION_SCOPE, b.data_value, a.name
3245: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
3246: WHERE a.devl_project_id=l_model_node.devl_project_id AND
3247: a.component_id=l_model_node.ps_node_id AND
3248: a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
3249: a.deleted_flag=G_NO_FLAG AND

Line 3270: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

3266: IF l_model_node.ps_node_type=G_REFERENCE_TYPE THEN
3267:
3268: FOR i IN(SELECT a.name, a.deleted_flag, a.invalid_flag, a.disabled_flag,
3269: a.INSTANTIATION_SCOPE, b.data_value
3270: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
3271: WHERE a.devl_project_id=l_model_node.devl_project_id AND
3272: a.component_id IN
3273: (SELECT ps_node_id FROM CZ_PS_NODES
3274: WHERE devl_project_id IN

Line 9008: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

9004: RETURN;
9005: END IF;
9006:
9007: FOR i IN(SELECT DISTINCT b.data_value, b.expr_node_id, a.INSTANTIATION_SCOPE, a.name
9008: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
9009: WHERE a.devl_project_id=p_node.devl_project_id AND
9010: a.component_id=p_node.ps_node_id AND
9011: a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
9012: a.deleted_flag=G_NO_FLAG AND

Line 9173: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

9169:
9170: IF p_node.ps_node_type=G_REFERENCE_TYPE THEN
9171:
9172: FOR i IN(SELECT a.model_ref_expl_id, b.data_value, a.component_id, b.expr_node_id, a.name, a.INSTANTIATION_SCOPE
9173: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
9174: WHERE a.devl_project_id=p_node.devl_project_id AND
9175: a.component_id IN
9176: (SELECT ps_node_id FROM CZ_PS_NODES
9177: WHERE devl_project_id IN

Line 9412: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

9408: deleted_flag NOT IN(G_YES_FLAG, G_MARK_TO_DELETE, G_LIMBO_FLAG))
9409: LOOP
9410:
9411: FOR i IN(SELECT DISTINCT b.data_value, b.expr_node_id, a.INSTANTIATION_SCOPE, a.NAME
9412: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
9413: WHERE a.devl_project_id=g_UI_Context.devl_project_id AND
9414: a.component_id=option_node.ps_node_id AND
9415: a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
9416: a.deleted_flag=G_NO_FLAG AND

Line 9618: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

9614: (SELECT persistent_node_id
9615: FROM CZ_PS_NODES
9616: WHERE devl_project_id = g_UI_Context.devl_project_id
9617: AND ps_node_id = a.component_id) persistent_node_Id
9618: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
9619: WHERE a.devl_project_id=g_UI_Context.devl_project_id AND
9620: a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
9621: b.rule_id=a.rule_id AND
9622: b.argument_signature_id=G_EVENT_ON_COMMAND_SIGID AND