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_OBJECTS

Line 49: -- Delete the cn_objects record before process the classification

45: -- 07-NOV-01 Kumar Sivasankaran, Modified Added the GENERATED status at the
46: -- end of Classification Install.
47: -- Added INSTFAIL at the end of classification Install package.
48: -- 13-FEB-02 Kumar Sivasankaran, Modified Added to check the rulesets exists
49: -- Delete the cn_objects record before process the classification
50: -- 31-Oct-02 Introduced clob to accomodate large expression. To fix the bug# 2579204
51: -- methods got updated - attribute_rules,create_attribute_rules_expr,file_header
52: -- - package_header,proc_init,rules_recurse_call,rules_recurse_gen
53: -- - rules_recurse_assign, revenue_classes

Line 537: name cn_objects.name%TYPE,

533:
534: END pkg_init_boilerplate;
535:
536: PROCEDURE create_object( module_id cn_modules.module_id%TYPE,
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

Line 538: object_type cn_objects.object_type%TYPE,

534: END pkg_init_boilerplate;
535:
536: PROCEDURE create_object( module_id cn_modules.module_id%TYPE,
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;

Line 539: object_id IN OUT NOCOPY cn_objects.object_id%TYPE,

535:
536: PROCEDURE create_object( module_id cn_modules.module_id%TYPE,
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

Line 540: description IN OUT NOCOPY cn_objects.description%TYPE,

536: PROCEDURE create_object( module_id cn_modules.module_id%TYPE,
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:

Line 546: SELECT cn_objects_s.NEXTVAL

542: next_id NUMBER;
543: BEGIN
544:
545: next_id := cn_utils.get_repository(module_id,x_org_id);
546: SELECT cn_objects_s.NEXTVAL
547: INTO object_id
548: FROM dual;
549: insert into CN_OBJECTS (
550: OBJECT_ID, DEPENDENCY_MAP_COMPLETE, NAME, OBJECT_TYPE, REPOSITORY_ID,

Line 549: insert into CN_OBJECTS (

545: next_id := cn_utils.get_repository(module_id,x_org_id);
546: SELECT cn_objects_s.NEXTVAL
547: INTO object_id
548: FROM dual;
549: insert into CN_OBJECTS (
550: OBJECT_ID, DEPENDENCY_MAP_COMPLETE, NAME, OBJECT_TYPE, REPOSITORY_ID,
551: OBJECT_STATUS, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,
552: LAST_UPDATE_LOGIN, DESCRIPTION, NEXT_SYNCHRONIZATION_DATE,
553: SYNCHRONIZATION_FREQUENCY, DATA_LENGTH, DATA_TYPE, NULLABLE, PRIMARY_KEY,

Line 598: delete from cn_objects where name = package_name and object_type = 'PKS';

594: l_count NUMBER;
595:
596: BEGIN
597: --cn_utils.set_org_id(x_org_id);
598: delete from cn_objects where name = package_name and object_type = 'PKS';
599: delete from cn_objects where name = package_name and object_type = 'PKB';
600:
601: -- Find the package objects AE 01-08-96
602: cn_utils.find_object(package_name,'PKS',package_spec_id, package_spec_desc,x_org_id);

Line 599: delete from cn_objects where name = package_name and object_type = 'PKB';

595:
596: BEGIN
597: --cn_utils.set_org_id(x_org_id);
598: delete from cn_objects where name = package_name and object_type = 'PKS';
599: delete from cn_objects where name = package_name and object_type = 'PKB';
600:
601: -- Find the package objects AE 01-08-96
602: cn_utils.find_object(package_name,'PKS',package_spec_id, package_spec_desc,x_org_id);
603: cn_utils.find_object(package_name,'PKB',package_body_id, package_body_desc,x_org_id);

Line 2042: FROM cn_objects co

2038: BEGIN
2039: cn_utils.set_org_id(x_org_id);
2040: SELECT co.object_id
2041: INTO l_pks_object_id
2042: FROM cn_objects co
2043: WHERE co.name = 'cn_clsfn_'||x_ruleset_id||'_'||x_org_id
2044: AND co.org_id=x_org_id
2045: AND co.object_type = 'PKS';
2046:

Line 2049: FROM cn_objects co

2045: AND co.object_type = 'PKS';
2046:
2047: SELECT co.object_id
2048: INTO l_pkb_object_id
2049: FROM cn_objects co
2050: WHERE co.name = 'cn_clsfn_'||x_ruleset_id||'_'||x_org_id
2051: AND co.org_id=x_org_id
2052: AND co.object_type = 'PKB';
2053: