APPS.CN_GET_EXPRESSION dependencies on CN_RULE_ATTR_EXPRESSION

Line 7: PROCEDURE build_table (x_rule_id IN cn_rule_attr_expression.rule_id%TYPE,

3: --==========================================================================
4: -- Procedure Name: BUILD_TABLE
5: -- Purpose
6: --==========================================================================
7: PROCEDURE build_table (x_rule_id IN cn_rule_attr_expression.rule_id%TYPE,
8: x_usage IN VARCHAR2,
9: x_org_id IN cn_rule_attr_expression.org_id%TYPE) IS
10:
11:

Line 9: x_org_id IN cn_rule_attr_expression.org_id%TYPE) IS

5: -- Purpose
6: --==========================================================================
7: PROCEDURE build_table (x_rule_id IN cn_rule_attr_expression.rule_id%TYPE,
8: x_usage IN VARCHAR2,
9: x_org_id IN cn_rule_attr_expression.org_id%TYPE) IS
10:
11:
12: CURSOR get_rae (x_rule_id NUMBER,x_org_id NUMBER) IS
13: SELECT operand1, operand1_ra_rae_flag,

Line 16: FROM cn_rule_attr_expression

12: CURSOR get_rae (x_rule_id NUMBER,x_org_id NUMBER) IS
13: SELECT operand1, operand1_ra_rae_flag,
14: operand2, operand2_ra_rae_flag,
15: operator
16: FROM cn_rule_attr_expression
17: WHERE rule_id = x_rule_id and org_id=x_org_id
18: ORDER BY operand_expression_id;
19:
20: CURSOR get_ra_descriptive (x_ra_id NUMBER,x_org_id NUMBER) IS

Line 90: PROCEDURE main(x_rule_id IN cn_rule_attr_expression.rule_id%TYPE,

86: --=======================================================================
87: -- Procedure Name: MAIN
88: -- Purpose
89: --=======================================================================
90: PROCEDURE main(x_rule_id IN cn_rule_attr_expression.rule_id%TYPE,
91: x_org_id IN cn_rule_attr_expression.org_id%TYPE,
92: x_usage IN VARCHAR2,
93: x_expression OUT NOCOPY VARCHAR2) IS
94: BEGIN

Line 91: x_org_id IN cn_rule_attr_expression.org_id%TYPE,

87: -- Procedure Name: MAIN
88: -- Purpose
89: --=======================================================================
90: PROCEDURE main(x_rule_id IN cn_rule_attr_expression.rule_id%TYPE,
91: x_org_id IN cn_rule_attr_expression.org_id%TYPE,
92: x_usage IN VARCHAR2,
93: x_expression OUT NOCOPY VARCHAR2) IS
94: BEGIN
95: --Call build_table procedure to build a PL/SQL table of intermediate