eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_CLASSIFICATION_GEN dependencies on CN_RULESETS

Line 63: g_module_type cn_rulesets.module_type%type;

59:
60:
61: -- cached_org_id integer;
62: -- cached_org_append varchar2(100);
63: g_module_type cn_rulesets.module_type%type;
64: --
65: -- Private Functions and Procedures
66: --
67:

Line 94: x_ruleset_id cn_rulesets.ruleset_id%TYPE; -- RK

90:
91: x_value cn_attribute_rules.column_value%TYPE; --AE 09-18-95
92: x_high_value cn_attribute_rules.high_value%TYPE; --AE
93: x_low_value cn_attribute_rules.low_value%TYPE; --AE
94: x_ruleset_id cn_rulesets.ruleset_id%TYPE; -- RK
95:
96: cached_org_id integer;
97: cached_org_append varchar2(100);
98:

Line 304: x_ruleset_id cn_rulesets.ruleset_id%TYPE;

300: l_dummy NUMBER := '-1000';
301: first_flag VARCHAR2(1);
302: quote VARCHAR2(1);
303: default_flag VARCHAR2(1);
304: x_ruleset_id cn_rulesets.ruleset_id%TYPE;
305: buffer VARCHAR2(32000);
306: cached_org_id integer;
307: cached_org_append varchar2(100);
308: l_dummy_date VARCHAR2(60):= '01/01/1600';

Line 541: x_org_id cn_rulesets.org_id%TYPE) IS

537: name cn_objects.name%TYPE,
538: object_type cn_objects.object_type%TYPE,
539: object_id IN OUT NOCOPY cn_objects.object_id%TYPE,
540: description IN OUT NOCOPY cn_objects.description%TYPE,
541: x_org_id cn_rulesets.org_id%TYPE) IS
542: next_id NUMBER;
543: BEGIN
544:
545: next_id := cn_utils.get_repository(module_id,x_org_id);

Line 589: x_org_id cn_rulesets.org_id%TYPE) IS

585: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
586:
587: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
588: body_code IN OUT NOCOPY cn_utils.clob_code_type,
589: x_org_id cn_rulesets.org_id%TYPE) IS
590:
591: x_rowid ROWID;
592: null_id NUMBER;
593: delete_flag VARCHAR2(1) := 'Y';

Line 1398: x_ruleset_id cn_rulesets.ruleset_id%TYPE,

1394:
1395:
1396:
1397: PROCEDURE rules_recurse_gen (
1398: x_ruleset_id cn_rulesets.ruleset_id%TYPE,
1399: x_org_id cn_rulesets.org_id%TYPE,
1400: X_rule_id cn_rules_hierarchy.rule_id%TYPE,
1401: code IN OUT NOCOPY cn_utils.clob_code_type) IS
1402: first_flag VARCHAR2(1);

Line 1399: x_org_id cn_rulesets.org_id%TYPE,

1395:
1396:
1397: PROCEDURE rules_recurse_gen (
1398: x_ruleset_id cn_rulesets.ruleset_id%TYPE,
1399: x_org_id cn_rulesets.org_id%TYPE,
1400: X_rule_id cn_rules_hierarchy.rule_id%TYPE,
1401: code IN OUT NOCOPY cn_utils.clob_code_type) IS
1402: first_flag VARCHAR2(1);
1403: X_revenue_class NUMBER;

Line 1621: x_ruleset_id_in cn_rulesets.ruleset_id%TYPE,

1617: FUNCTION revenue_classes (
1618: debug_pipe VARCHAR2,
1619: debug_level NUMBER := 1,
1620: x_module_id cn_modules.module_id%TYPE,
1621: x_ruleset_id_in cn_rulesets.ruleset_id%TYPE,
1622: x_org_id_in cn_rulesets.org_id% TYPE) RETURN BOOLEAN IS
1623:
1624: -- Declare and initialize procedure variables AE 01-10-96
1625: package_name cn_obj_packages_v.name%TYPE

Line 1622: x_org_id_in cn_rulesets.org_id% TYPE) RETURN BOOLEAN IS

1618: debug_pipe VARCHAR2,
1619: debug_level NUMBER := 1,
1620: x_module_id cn_modules.module_id%TYPE,
1621: x_ruleset_id_in cn_rulesets.ruleset_id%TYPE,
1622: x_org_id_in cn_rulesets.org_id% TYPE) RETURN BOOLEAN IS
1623:
1624: -- Declare and initialize procedure variables AE 01-10-96
1625: package_name cn_obj_packages_v.name%TYPE
1626: := 'cn_clsfn' || '_' || ABS(x_ruleset_id_in);

Line 1638: x_ruleset_id cn_rulesets.ruleset_id%TYPE;

1634: x_repository_id cn_repositories.repository_id%TYPE
1635: := cn_utils.get_repository(x_module_id,x_org_id_in);
1636: x_event_id cn_events.event_id%TYPE
1637: := cn_utils.get_event(x_module_id,x_org_id_in);
1638: x_ruleset_id cn_rulesets.ruleset_id%TYPE;
1639: x_org_id cn_rulesets.org_id%TYPE;
1640: x_package_count cn_rules.package_id%TYPE;
1641: x_rule_count NUMBER(7);
1642:

Line 1639: x_org_id cn_rulesets.org_id%TYPE;

1635: := cn_utils.get_repository(x_module_id,x_org_id_in);
1636: x_event_id cn_events.event_id%TYPE
1637: := cn_utils.get_event(x_module_id,x_org_id_in);
1638: x_ruleset_id cn_rulesets.ruleset_id%TYPE;
1639: x_org_id cn_rulesets.org_id%TYPE;
1640: x_package_count cn_rules.package_id%TYPE;
1641: x_rule_count NUMBER(7);
1642:
1643: package_max NUMBER(7);

Line 1681: FROM cn_rulesets cr, cn_obj_columns_v cocv

1677: and ruleset_id = x_ruleset_id;
1678:
1679: CURSOR rulesets IS
1680: SELECT LOWER(cocv.name) dest_column, cr.ruleset_id,cr.org_id,module_type
1681: FROM cn_rulesets cr, cn_obj_columns_v cocv
1682: WHERE cr.destination_column_id = cocv.column_id
1683: AND cr.repository_id = x_repository_id
1684: AND cr.org_id = cocv.org_id
1685: AND cr.org_id=x_org_id_in

Line 2027: FROM cn_rulesets

2023: ORDER BY cs.line_no;
2024:
2025: CURSOR get_ruleset_data ( p_ruleset_id in NUMBER,p_org_id in NUMBER ) IS
2026: SELECT *
2027: FROM cn_rulesets
2028: WHERE ruleset_id = p_ruleset_id and
2029: org_id=p_org_id;
2030:
2031: l_get_ruleset_data_rec get_ruleset_data%ROWTYPE;