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

Line 1092: x_procedure_name cn_objects.NAME%TYPE,

1088: -- 17-NOV-93 Devesh Khatu Created
1089: --
1090: PROCEDURE pkg_proc_end (
1091: x_table_map_id cn_table_maps.table_map_id%TYPE,
1092: x_procedure_name cn_objects.NAME%TYPE,
1093: x_event_id cn_events.event_id%TYPE,
1094: code IN OUT NOCOPY cn_utils.code_type,
1095: x_org_id IN NUMBER) IS
1096: BEGIN

Line 1199: package_name cn_objects.NAME%TYPE,

1195: -- 17-NOV-93 Devesh Khatu Created
1196: -- 08-JUN-94 Devesh Khatu Modified
1197: --+
1198: PROCEDURE collection_proc (
1199: package_name cn_objects.NAME%TYPE,
1200: package_id cn_objects.package_id%TYPE,
1201: x_table_map_id cn_table_maps.table_map_id%TYPE,
1202: module_id cn_modules.module_id%TYPE,
1203: repository_id cn_repositories.repository_id%TYPE,

Line 1200: package_id cn_objects.package_id%TYPE,

1196: -- 08-JUN-94 Devesh Khatu Modified
1197: --+
1198: PROCEDURE collection_proc (
1199: package_name cn_objects.NAME%TYPE,
1200: package_id cn_objects.package_id%TYPE,
1201: x_table_map_id cn_table_maps.table_map_id%TYPE,
1202: module_id cn_modules.module_id%TYPE,
1203: repository_id cn_repositories.repository_id%TYPE,
1204: event_id cn_events.event_id%TYPE,

Line 1212: procedure_name cn_objects.NAME%TYPE := 'collect';

1208: x_org_id IN NUMBER) IS
1209:
1210: -- Declare and initialize procedure variables
1211:
1212: procedure_name cn_objects.NAME%TYPE := 'collect';
1213: short_name cn_objects.NAME%TYPE := SUBSTR(package_name, 12) ;
1214: description cn_objects.description%TYPE
1215: := 'Collection procedure for ' || short_name ;
1216: parameter_list cn_objects.parameter_list%TYPE

Line 1213: short_name cn_objects.NAME%TYPE := SUBSTR(package_name, 12) ;

1209:
1210: -- Declare and initialize procedure variables
1211:
1212: procedure_name cn_objects.NAME%TYPE := 'collect';
1213: short_name cn_objects.NAME%TYPE := SUBSTR(package_name, 12) ;
1214: description cn_objects.description%TYPE
1215: := 'Collection procedure for ' || short_name ;
1216: parameter_list cn_objects.parameter_list%TYPE
1217: := 'errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY NUMBER';

Line 1214: description cn_objects.description%TYPE

1210: -- Declare and initialize procedure variables
1211:
1212: procedure_name cn_objects.NAME%TYPE := 'collect';
1213: short_name cn_objects.NAME%TYPE := SUBSTR(package_name, 12) ;
1214: description cn_objects.description%TYPE
1215: := 'Collection procedure for ' || short_name ;
1216: parameter_list cn_objects.parameter_list%TYPE
1217: := 'errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY NUMBER';
1218:

Line 1216: parameter_list cn_objects.parameter_list%TYPE

1212: procedure_name cn_objects.NAME%TYPE := 'collect';
1213: short_name cn_objects.NAME%TYPE := SUBSTR(package_name, 12) ;
1214: description cn_objects.description%TYPE
1215: := 'Collection procedure for ' || short_name ;
1216: parameter_list cn_objects.parameter_list%TYPE
1217: := 'errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY NUMBER';
1218:
1219: BEGIN
1220:

Line 1276: package_name cn_objects.NAME%TYPE,

1272: -- History
1273: -- 12-08-95 A. Erickson Created
1274: --+
1275: PROCEDURE null_proc(
1276: package_name cn_objects.NAME%TYPE,
1277: package_id cn_obj_packages_v.package_id%TYPE,
1278: module_id cn_modules.module_id%TYPE,
1279: repository_id cn_repositories.repository_id%TYPE,
1280: event_id cn_events.event_id%TYPE,

Line 1287: procedure_name cn_objects.NAME%TYPE := 'collect';

1283: x_org_id IN NUMBER) IS
1284:
1285: -- Declare and initialize procedure variables
1286:
1287: procedure_name cn_objects.NAME%TYPE := 'collect';
1288: short_name cn_objects.NAME%TYPE := SUBSTR(package_name, 12) ;
1289: description cn_objects.description%TYPE
1290: := 'NULL collection procedure for ' || short_name;
1291: parameter_list cn_objects.parameter_list%TYPE

Line 1288: short_name cn_objects.NAME%TYPE := SUBSTR(package_name, 12) ;

1284:
1285: -- Declare and initialize procedure variables
1286:
1287: procedure_name cn_objects.NAME%TYPE := 'collect';
1288: short_name cn_objects.NAME%TYPE := SUBSTR(package_name, 12) ;
1289: description cn_objects.description%TYPE
1290: := 'NULL collection procedure for ' || short_name;
1291: parameter_list cn_objects.parameter_list%TYPE
1292: := 'errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY NUMBER, x_start_period_name IN VARCHAR2, x_end_period_name IN VARCHAR2, x_org_id IN NUMBER ';

Line 1289: description cn_objects.description%TYPE

1285: -- Declare and initialize procedure variables
1286:
1287: procedure_name cn_objects.NAME%TYPE := 'collect';
1288: short_name cn_objects.NAME%TYPE := SUBSTR(package_name, 12) ;
1289: description cn_objects.description%TYPE
1290: := 'NULL collection procedure for ' || short_name;
1291: parameter_list cn_objects.parameter_list%TYPE
1292: := 'errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY NUMBER, x_start_period_name IN VARCHAR2, x_end_period_name IN VARCHAR2, x_org_id IN NUMBER ';
1293:

Line 1291: parameter_list cn_objects.parameter_list%TYPE

1287: procedure_name cn_objects.NAME%TYPE := 'collect';
1288: short_name cn_objects.NAME%TYPE := SUBSTR(package_name, 12) ;
1289: description cn_objects.description%TYPE
1290: := 'NULL collection procedure for ' || short_name;
1291: parameter_list cn_objects.parameter_list%TYPE
1292: := 'errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY NUMBER, x_start_period_name IN VARCHAR2, x_end_period_name IN VARCHAR2, x_org_id IN NUMBER ';
1293:
1294: BEGIN
1295:

Line 1357: x_package_name cn_objects.NAME%TYPE,

1353: --+
1354: PROCEDURE collection_pkg_code (
1355: debug_pipe VARCHAR2,
1356: debug_level NUMBER := 1,
1357: x_package_name cn_objects.NAME%TYPE,
1358: x_org_append VARCHAR2,
1359: x_collect_flag cn_modules.collect_flag%TYPE,
1360: x_module_id cn_modules.module_id%TYPE,
1361: x_generic BOOLEAN,

Line 1365: l_package_type cn_objects.package_type%TYPE;

1361: x_generic BOOLEAN,
1362: x_table_map_id cn_table_maps.table_map_id%TYPE,
1363: x_org_id IN NUMBER) IS
1364:
1365: l_package_type cn_objects.package_type%TYPE;
1366: l_package_spec_id cn_obj_packages_v.package_id%TYPE;
1367: l_package_body_id cn_obj_packages_v.package_id%TYPE;
1368: l_package_spec_desc cn_obj_packages_v.description%TYPE;
1369: l_package_body_desc cn_obj_packages_v.description%TYPE;

Line 1413: -- Generate end package statements, dump code into cn_objects

1409: null_proc(x_package_name, l_package_spec_id, x_module_id,
1410: l_repository_id, l_event_id, l_spec_code, l_body_code,X_org_id);
1411: END IF;
1412:
1413: -- Generate end package statements, dump code into cn_objects
1414:
1415: cn_utils.set_org_id(X_org_id);
1416: cn_utils.pkg_end(x_package_name, l_package_spec_id, l_package_body_id,
1417: l_spec_code, l_body_code);

Line 1479: l_package_name cn_objects.NAME%TYPE;

1475: x_org_id IN NUMBER) IS
1476:
1477: l_generic BOOLEAN := FALSE;
1478: l_module_id cn_modules.module_id%TYPE;
1479: l_package_name cn_objects.NAME%TYPE;
1480: l_mapping_type cn_objects.package_type%TYPE;
1481: --l_org_append VARCHAR2(100) := get_org_append;
1482: l_org_append VARCHAR2(100);
1483: l_retcode NUMBER;

Line 1480: l_mapping_type cn_objects.package_type%TYPE;

1476:
1477: l_generic BOOLEAN := FALSE;
1478: l_module_id cn_modules.module_id%TYPE;
1479: l_package_name cn_objects.NAME%TYPE;
1480: l_mapping_type cn_objects.package_type%TYPE;
1481: --l_org_append VARCHAR2(100) := get_org_append;
1482: l_org_append VARCHAR2(100);
1483: l_retcode NUMBER;
1484: l_errbuf VARCHAR2(100);

Line 1558: -- For custom packages, the package name (as stored in CN_OBJECTS)

1554: -- +
1555: IF l_mapping_type <> 'OC' THEN
1556: l_generic := TRUE;
1557: --+
1558: -- For custom packages, the package name (as stored in CN_OBJECTS)
1559: -- is of the format cn_collect__
1560: --+
1561: IF l_mapping_type <> 'AIA' and l_mapping_type <> 'AAOM' THEN
1562: l_org_append := NULL;

Line 1569: FROM cn_table_map_objects tmov, cn_objects obj

1565: END IF;
1566:
1567: SELECT OBJ.name OBJECT_NAME
1568: INTO l_package_name
1569: FROM cn_table_map_objects tmov, cn_objects obj
1570: WHERE tmov.table_map_id = x_table_map_id
1571: AND tmov.tm_object_type = 'PKS'
1572: and tmov.org_id = obj.org_id
1573: and tmov.object_id = obj.object_id

Line 1647: -- data sources, this is the same as the name stored in CN_OBJECTS. For AR and OC

1643: --dbms_output.put_line('l_org_id '||l_org_id);
1644:
1645: --+
1646: -- We need to get the exact package name. For custom
1647: -- data sources, this is the same as the name stored in CN_OBJECTS. For AR and OC
1648: -- the name stored in CN_OBJECTS does not have the Org_id on it, so we must
1649: -- append this. (Also get module_id for later use)
1650: --+
1651:

Line 1648: -- the name stored in CN_OBJECTS does not have the Org_id on it, so we must

1644:
1645: --+
1646: -- We need to get the exact package name. For custom
1647: -- data sources, this is the same as the name stored in CN_OBJECTS. For AR and OC
1648: -- the name stored in CN_OBJECTS does not have the Org_id on it, so we must
1649: -- append this. (Also get module_id for later use)
1650: --+
1651:
1652: SELECT mapping_type, module_id

Line 1673: -- name (from CN_OBJECTS). For AR there will

1669:
1670: --+
1671: -- Loop for each package belonging to the source, getting
1672: -- the object_ids for the Spec and Body, plus the package
1673: -- name (from CN_OBJECTS). For AR there will
1674: -- be 4 packages, for any other source there will only be one.
1675: --+
1676:
1677: FOR rec IN

Line 1682: FROM cn_table_map_objects tmov, cn_objects obj

1678: (SELECT
1679: UPPER(OBJ.name) NAME ,
1680: MAX(DECODE(tmov.tm_object_type,'PKS',tmov.object_id,NULL)) spec_id,
1681: MAX(DECODE(tmov.tm_object_type,'PKB',tmov.object_id,NULL)) body_id
1682: FROM cn_table_map_objects tmov, cn_objects obj
1683: WHERE tmov.tm_object_type IN ('PKS','PKB')
1684: and obj.object_id = tmov.object_id
1685: and tmov.org_id = obj.org_id
1686: AND tmov.table_map_id = p_table_map_id

Line 1738: FROM cn_table_map_objects tmov, cn_objects obj

1734: --+
1735: FOR obj_rec IN
1736: (SELECT
1737: DISTINCT UPPER(OBJ.name) NAME
1738: FROM cn_table_map_objects tmov, cn_objects obj
1739: WHERE tm_object_type IN ('PKS','PKB')
1740: AND tmov.table_map_id = p_table_map_id
1741: and tmov.object_id = obj.object_id
1742: and tmov.org_id = obj.org_id

Line 1775: FROM cn_table_map_objects tmov, cn_objects obj

1771: x_org_id => X_org_id);
1772: FOR pkg_names IN
1773: (SELECT
1774: DISTINCT UPPER(OBJ.name) NAME
1775: FROM cn_table_map_objects tmov, cn_objects obj
1776: WHERE tm_object_type IN ('PKS','PKB')
1777: AND tmov.table_map_id = p_table_map_id
1778: and tmov.object_id = obj.object_id
1779: and tmov.org_id = obj.org_id

Line 1819: FROM cn_table_map_objects tmov, cn_objects obj

1815: IF p_test = 'N' and x_retcode=1 THEN
1816: FOR pkg_names IN
1817: (SELECT
1818: DISTINCT UPPER(OBJ.name) NAME
1819: FROM cn_table_map_objects tmov, cn_objects obj
1820: WHERE tm_object_type IN ('PKS','PKB')
1821: AND tmov.table_map_id = p_table_map_id
1822: and tmov.object_id = obj.object_id
1823: and tmov.org_id = obj.org_id