APPS.CN_GET_EXPRESSION dependencies on CN_ATTRIBUTE_RULES

Line 105: UPDATE cn_attribute_rules

101: x_expression := substr(g_rae(g_intermediate_expr),1,1900);
102: end if;
103:
104:
105: UPDATE cn_attribute_rules
106: SET expression = substr(x_expression, 1, 1900)
107: WHERE rule_id = x_rule_id and org_id=x_org_id;
108: commit;
109:

Line 115: PROCEDURE deleteExpression(x_rule_id IN cn_attribute_rules.rule_id%TYPE,

111: when no_data_found then
112: null;
113: END main;
114:
115: PROCEDURE deleteExpression(x_rule_id IN cn_attribute_rules.rule_id%TYPE,
116: x_org_id IN cn_attribute_rules.org_id%TYPE) IS
117: BEGIN
118: UPDATE cn_attribute_rules set expression = ' ' WHERE rule_id = x_rule_id and org_id=x_org_id;
119: commit;

Line 116: x_org_id IN cn_attribute_rules.org_id%TYPE) IS

112: null;
113: END main;
114:
115: PROCEDURE deleteExpression(x_rule_id IN cn_attribute_rules.rule_id%TYPE,
116: x_org_id IN cn_attribute_rules.org_id%TYPE) IS
117: BEGIN
118: UPDATE cn_attribute_rules set expression = ' ' WHERE rule_id = x_rule_id and org_id=x_org_id;
119: commit;
120: END deleteExpression;

Line 118: UPDATE cn_attribute_rules set expression = ' ' WHERE rule_id = x_rule_id and org_id=x_org_id;

114:
115: PROCEDURE deleteExpression(x_rule_id IN cn_attribute_rules.rule_id%TYPE,
116: x_org_id IN cn_attribute_rules.org_id%TYPE) IS
117: BEGIN
118: UPDATE cn_attribute_rules set expression = ' ' WHERE rule_id = x_rule_id and org_id=x_org_id;
119: commit;
120: END deleteExpression;
121:
122: END cn_get_expression;