APPS.CZ_UI_GENERATOR dependencies on CZ_RULES

Line 2154: FOR i IN(SELECT rule_id,component_id,name FROM CZ_RULES

2150: FND_REPORT(CZ_UI_GEN_NO_BUTTONS,TOKEN_UI_NODE,TO_CHAR(var_parent_id), CZ_ERROR_URGENCY);
2151: END;
2152: END LOOP;
2153:
2154: FOR i IN(SELECT rule_id,component_id,name FROM CZ_RULES
2155: WHERE devl_project_id=in_project_id AND
2156: rule_type=CZ_EXTENTSIONS_RULE_TYPE AND deleted_flag=NO_FLAG AND
2157: disabled_flag=NO_FLAG)
2158: LOOP

Line 7946: (SELECT r.rule_id FROM CZ_RULES r WHERE r.devl_project_id=Project_id AND

7942: u.deleted_flag=NO_FLAG AND
7943: EXISTS(SELECT NULL FROM CZ_UI_NODE_PROPS p
7944: WHERE p.key_str='RuleId' AND p.ui_def_id=u.ui_def_id AND p.ui_node_id=u.ui_node_id AND p.deleted_flag=NO_FLAG AND
7945: TO_NUMBER(value_str) NOT IN
7946: (SELECT r.rule_id FROM CZ_RULES r WHERE r.devl_project_id=Project_id AND
7947: r.rule_type=CZ_EXTENTSIONS_RULE_TYPE AND r.deleted_flag=NO_FLAG));
7948:
7949: /* *** remove all UI nodes associated with unexisting PS nodes *** */
7950: