APPS.CN_CLASSIFICATION_GEN dependencies on CN_RULE_ATTR_EXPRESSION

Line 291: -- a complex expression using the cn_rule_attr_expression table when

287: -- create_attribute_rules_expr
288: -- Purpose
289: -- This function generates a conditional expression by ANDing all the
290: -- attribute rules for the rule X_rule_id as default and by creating
291: -- a complex expression using the cn_rule_attr_expression table when
292: -- such data is available
293: -- History
294: -- 06/22/98 Ramkarthik Kalyanasundaram Created
295: --

Line 311: TYPE intermediate_expr_type IS RECORD ( id cn_rule_attr_expression.rule_attr_expression_id%TYPE,

307: cached_org_append varchar2(100);
308: l_dummy_date VARCHAR2(60):= '01/01/1600';
309:
310:
311: TYPE intermediate_expr_type IS RECORD ( id cn_rule_attr_expression.rule_attr_expression_id%TYPE,
312: expr_id cn_rule_attr_expression.operand_expression_id%TYPE,
313: expr CLOB);
314: TYPE expr_type IS TABLE OF intermediate_expr_type INDEX BY BINARY_INTEGER;
315: expr_table expr_type;

Line 312: expr_id cn_rule_attr_expression.operand_expression_id%TYPE,

308: l_dummy_date VARCHAR2(60):= '01/01/1600';
309:
310:
311: TYPE intermediate_expr_type IS RECORD ( id cn_rule_attr_expression.rule_attr_expression_id%TYPE,
312: expr_id cn_rule_attr_expression.operand_expression_id%TYPE,
313: expr CLOB);
314: TYPE expr_type IS TABLE OF intermediate_expr_type INDEX BY BINARY_INTEGER;
315: expr_table expr_type;
316: table_index NUMBER := 0;

Line 328: FROM cn_rule_attr_expression

324: and car.org_id= cocv.org_id
325: AND cocv.column_id = car.column_id;
326: CURSOR rule_attr_expr_cursor IS
327: SELECT *
328: FROM cn_rule_attr_expression
329: WHERE rule_id = X_rule_id
330: ORDER BY rule_attr_expression_id;
331: BEGIN
332: cn_debug.print_msg('attribute_rules>>', 1);