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_UTILS dependencies on CN_OBJECTS

Line 66: x_package_spec_id cn_objects.object_id%TYPE,

62: g_org_id := null;
63: END;
64:
65: PROCEDURE delete_module (x_module_id cn_modules.module_id%TYPE,
66: x_package_spec_id cn_objects.object_id%TYPE,
67: x_package_body_id cn_objects.object_id%TYPE,
68: p_org_id IN NUMBER) IS
69: BEGIN
70: DELETE FROM cn_source_all

Line 67: x_package_body_id cn_objects.object_id%TYPE,

63: END;
64:
65: PROCEDURE delete_module (x_module_id cn_modules.module_id%TYPE,
66: x_package_spec_id cn_objects.object_id%TYPE,
67: x_package_body_id cn_objects.object_id%TYPE,
68: p_org_id IN NUMBER) IS
69: BEGIN
70: DELETE FROM cn_source_all
71: WHERE (object_id = x_package_spec_id

Line 79: X_object_id cn_objects.object_id%TYPE,

75: END delete_module;
76:
77:
78: PROCEDURE init_code (
79: X_object_id cn_objects.object_id%TYPE,
80: code IN OUT NOCOPY cn_utils.code_type) IS
81: BEGIN
82: code.object_id := X_object_id;
83: code.line := 1;

Line 90: X_object_id cn_objects.object_id%TYPE,

86: END init_code;
87:
88: -- for clob
89: PROCEDURE init_code (
90: X_object_id cn_objects.object_id%TYPE,
91: code IN OUT NOCOPY cn_utils.clob_code_type) IS
92: BEGIN
93:
94: code.object_id := X_object_id;

Line 1407: X_object_id cn_objects.object_id%TYPE,

1403: -- History
1404: -- 18-NOV-93 Devesh Khatu Created
1405: --+
1406: PROCEDURE gen_create_subprogram (
1407: X_object_id cn_objects.object_id%TYPE,
1408: code IN OUT NOCOPY cn_utils.code_type) IS
1409:
1410: X_statement_text cn_obj_packages_v.statement_text%TYPE;
1411: BEGIN

Line 1416: FROM cn_objects co

1412: cn_debug.print_msg('gen_create_subprogram>>', 1);
1413:
1414: SELECT statement_text
1415: INTO X_statement_text
1416: FROM cn_objects co
1417: WHERE co.object_id = X_object_id;
1418:
1419: cn_utils.init_code( X_object_id, code);
1420: cn_utils.appendcr(code, 'CREATE OR REPLACE ' || X_statement_text);

Line 1436: X_object_id cn_objects.object_id%TYPE,

1432: -- 18-NOV-93 Devesh Khatu Created
1433: -- 16-MAR-94 Devesh Khatu Modified
1434: --+
1435: PROCEDURE gen_create_package (
1436: X_object_id cn_objects.object_id%TYPE,
1437: dump_to_file VARCHAR2,
1438: code IN OUT NOCOPY cn_utils.code_type) IS
1439:
1440: X_statement_text cn_obj_packages_v.statement_text%TYPE;

Line 1450: FROM cn_objects co

1446: cn_debug.print_msg('gen_create_package>>', 1);
1447:
1448: SELECT statement_text, object_type, name, description
1449: INTO X_statement_text, X_object_type, X_name, X_description
1450: FROM cn_objects co
1451: WHERE co.object_id = X_object_id;
1452:
1453: cn_utils.init_code( X_object_id, code);
1454:

Line 1537: X_object_id cn_objects.object_id%TYPE,

1533: END gen_create_trigger;
1534:
1535:
1536: PROCEDURE gen_instantiation_code (
1537: X_object_id cn_objects.object_id%TYPE,
1538: dump_to_file VARCHAR2,
1539: code_text IN OUT NOCOPY VARCHAR2) IS
1540:
1541: code cn_utils.code_type;

Line 1542: X_object_type cn_objects.object_type%TYPE;

1538: dump_to_file VARCHAR2,
1539: code_text IN OUT NOCOPY VARCHAR2) IS
1540:
1541: code cn_utils.code_type;
1542: X_object_type cn_objects.object_type%TYPE;
1543:
1544: BEGIN
1545: cn_debug.print_msg('gen_instantiation_code>>', 1);
1546: cn_debug.print_msg('gen_instantiation_code: X_object_id = ' || X_object_id, 1);

Line 1549: FROM cn_objects co

1545: cn_debug.print_msg('gen_instantiation_code>>', 1);
1546: cn_debug.print_msg('gen_instantiation_code: X_object_id = ' || X_object_id, 1);
1547:
1548: SELECT object_type INTO X_object_type
1549: FROM cn_objects co
1550: WHERE co.object_id = X_object_id;
1551:
1552: IF (X_object_type = 'TBL') THEN -- table
1553: gen_create_table(X_object_id, code);

Line 1592: RETURN cn_objects.object_id%TYPE IS

1588: END get_proc_audit_id;
1589:
1590:
1591: FUNCTION get_object_id
1592: RETURN cn_objects.object_id%TYPE IS
1593: x_object_id cn_objects.object_id%TYPE;
1594: BEGIN
1595: SELECT cn_objects_s.NEXTVAL
1596: INTO x_object_id

Line 1593: x_object_id cn_objects.object_id%TYPE;

1589:
1590:
1591: FUNCTION get_object_id
1592: RETURN cn_objects.object_id%TYPE IS
1593: x_object_id cn_objects.object_id%TYPE;
1594: BEGIN
1595: SELECT cn_objects_s.NEXTVAL
1596: INTO x_object_id
1597: FROM sys.dual;

Line 1595: SELECT cn_objects_s.NEXTVAL

1591: FUNCTION get_object_id
1592: RETURN cn_objects.object_id%TYPE IS
1593: x_object_id cn_objects.object_id%TYPE;
1594: BEGIN
1595: SELECT cn_objects_s.NEXTVAL
1596: INTO x_object_id
1597: FROM sys.dual;
1598: RETURN x_object_id;
1599: END get_object_id;

Line 1613: FUNCTION get_object_name (X_object_id cn_objects.object_id%TYPE, p_org_id IN NUMBER)

1609: RETURN x_mod_obj_depends_id;
1610: END get_mod_obj_depends_id;
1611:
1612:
1613: FUNCTION get_object_name (X_object_id cn_objects.object_id%TYPE, p_org_id IN NUMBER)
1614: RETURN cn_objects.name%TYPE IS
1615: X_name cn_objects.name%TYPE;
1616: BEGIN
1617: SELECT name INTO X_name

Line 1614: RETURN cn_objects.name%TYPE IS

1610: END get_mod_obj_depends_id;
1611:
1612:
1613: FUNCTION get_object_name (X_object_id cn_objects.object_id%TYPE, p_org_id IN NUMBER)
1614: RETURN cn_objects.name%TYPE IS
1615: X_name cn_objects.name%TYPE;
1616: BEGIN
1617: SELECT name INTO X_name
1618: FROM cn_objects

Line 1615: X_name cn_objects.name%TYPE;

1611:
1612:
1613: FUNCTION get_object_name (X_object_id cn_objects.object_id%TYPE, p_org_id IN NUMBER)
1614: RETURN cn_objects.name%TYPE IS
1615: X_name cn_objects.name%TYPE;
1616: BEGIN
1617: SELECT name INTO X_name
1618: FROM cn_objects
1619: WHERE object_id = X_object_id

Line 1618: FROM cn_objects

1614: RETURN cn_objects.name%TYPE IS
1615: X_name cn_objects.name%TYPE;
1616: BEGIN
1617: SELECT name INTO X_name
1618: FROM cn_objects
1619: WHERE object_id = X_object_id
1620: AND org_id = p_org_id;
1621: RETURN X_name;
1622: END get_object_name;

Line 1651: x_name cn_objects.name%TYPE,

1647: END get_event;
1648:
1649:
1650: PROCEDURE find_object (
1651: x_name cn_objects.name%TYPE,
1652: x_object_type cn_objects.object_type%TYPE,
1653: x_object_id IN OUT NOCOPY cn_objects.object_id%TYPE,
1654: x_description IN OUT NOCOPY cn_objects.description%TYPE,
1655: p_org_id IN NUMBER ) IS

Line 1652: x_object_type cn_objects.object_type%TYPE,

1648:
1649:
1650: PROCEDURE find_object (
1651: x_name cn_objects.name%TYPE,
1652: x_object_type cn_objects.object_type%TYPE,
1653: x_object_id IN OUT NOCOPY cn_objects.object_id%TYPE,
1654: x_description IN OUT NOCOPY cn_objects.description%TYPE,
1655: p_org_id IN NUMBER ) IS
1656:

Line 1653: x_object_id IN OUT NOCOPY cn_objects.object_id%TYPE,

1649:
1650: PROCEDURE find_object (
1651: x_name cn_objects.name%TYPE,
1652: x_object_type cn_objects.object_type%TYPE,
1653: x_object_id IN OUT NOCOPY cn_objects.object_id%TYPE,
1654: x_description IN OUT NOCOPY cn_objects.description%TYPE,
1655: p_org_id IN NUMBER ) IS
1656:
1657: BEGIN

Line 1654: x_description IN OUT NOCOPY cn_objects.description%TYPE,

1650: PROCEDURE find_object (
1651: x_name cn_objects.name%TYPE,
1652: x_object_type cn_objects.object_type%TYPE,
1653: x_object_id IN OUT NOCOPY cn_objects.object_id%TYPE,
1654: x_description IN OUT NOCOPY cn_objects.description%TYPE,
1655: p_org_id IN NUMBER ) IS
1656:
1657: BEGIN
1658: SELECT object_id, description

Line 1660: FROM cn_objects

1656:
1657: BEGIN
1658: SELECT object_id, description
1659: INTO x_object_id, x_description
1660: FROM cn_objects
1661: WHERE name = x_name
1662: AND object_type = x_object_type
1663: AND org_id = p_org_id ;
1664: END find_object;