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 1061: x_procedure_name cn_objects.NAME%TYPE,

1057: -- 17-NOV-93 Devesh Khatu Created
1058: --
1059: PROCEDURE pkg_proc_end (
1060: x_table_map_id cn_table_maps.table_map_id%TYPE,
1061: x_procedure_name cn_objects.NAME%TYPE,
1062: x_event_id cn_events.event_id%TYPE,
1063: code IN OUT NOCOPY cn_utils.code_type,
1064: x_org_id IN NUMBER) IS
1065: BEGIN

Line 1152: package_name cn_objects.NAME%TYPE,

1148: -- 17-NOV-93 Devesh Khatu Created
1149: -- 08-JUN-94 Devesh Khatu Modified
1150: --+
1151: PROCEDURE collection_proc (
1152: package_name cn_objects.NAME%TYPE,
1153: package_id cn_objects.package_id%TYPE,
1154: x_table_map_id cn_table_maps.table_map_id%TYPE,
1155: module_id cn_modules.module_id%TYPE,
1156: repository_id cn_repositories.repository_id%TYPE,

Line 1153: package_id cn_objects.package_id%TYPE,

1149: -- 08-JUN-94 Devesh Khatu Modified
1150: --+
1151: PROCEDURE collection_proc (
1152: package_name cn_objects.NAME%TYPE,
1153: package_id cn_objects.package_id%TYPE,
1154: x_table_map_id cn_table_maps.table_map_id%TYPE,
1155: module_id cn_modules.module_id%TYPE,
1156: repository_id cn_repositories.repository_id%TYPE,
1157: event_id cn_events.event_id%TYPE,

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

1161: x_org_id IN NUMBER) IS
1162:
1163: -- Declare and initialize procedure variables
1164:
1165: procedure_name cn_objects.NAME%TYPE := 'collect';
1166: short_name cn_objects.NAME%TYPE := SUBSTR(package_name, 12) ;
1167: description cn_objects.description%TYPE
1168: := 'Collection procedure for ' || short_name ;
1169: parameter_list cn_objects.parameter_list%TYPE

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

1162:
1163: -- Declare and initialize procedure variables
1164:
1165: procedure_name cn_objects.NAME%TYPE := 'collect';
1166: short_name cn_objects.NAME%TYPE := SUBSTR(package_name, 12) ;
1167: description cn_objects.description%TYPE
1168: := 'Collection procedure for ' || short_name ;
1169: parameter_list cn_objects.parameter_list%TYPE
1170: := 'errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY NUMBER';

Line 1167: description cn_objects.description%TYPE

1163: -- Declare and initialize procedure variables
1164:
1165: procedure_name cn_objects.NAME%TYPE := 'collect';
1166: short_name cn_objects.NAME%TYPE := SUBSTR(package_name, 12) ;
1167: description cn_objects.description%TYPE
1168: := 'Collection procedure for ' || short_name ;
1169: parameter_list cn_objects.parameter_list%TYPE
1170: := 'errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY NUMBER';
1171:

Line 1169: parameter_list cn_objects.parameter_list%TYPE

1165: procedure_name cn_objects.NAME%TYPE := 'collect';
1166: short_name cn_objects.NAME%TYPE := SUBSTR(package_name, 12) ;
1167: description cn_objects.description%TYPE
1168: := 'Collection procedure for ' || short_name ;
1169: parameter_list cn_objects.parameter_list%TYPE
1170: := 'errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY NUMBER';
1171:
1172: BEGIN
1173:

Line 1226: package_name cn_objects.NAME%TYPE,

1222: -- History
1223: -- 12-08-95 A. Erickson Created
1224: --+
1225: PROCEDURE null_proc(
1226: package_name cn_objects.NAME%TYPE,
1227: package_id cn_obj_packages_v.package_id%TYPE,
1228: module_id cn_modules.module_id%TYPE,
1229: repository_id cn_repositories.repository_id%TYPE,
1230: event_id cn_events.event_id%TYPE,

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

1233: x_org_id IN NUMBER) IS
1234:
1235: -- Declare and initialize procedure variables
1236:
1237: procedure_name cn_objects.NAME%TYPE := 'collect';
1238: short_name cn_objects.NAME%TYPE := SUBSTR(package_name, 12) ;
1239: description cn_objects.description%TYPE
1240: := 'NULL collection procedure for ' || short_name;
1241: parameter_list cn_objects.parameter_list%TYPE

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

1234:
1235: -- Declare and initialize procedure variables
1236:
1237: procedure_name cn_objects.NAME%TYPE := 'collect';
1238: short_name cn_objects.NAME%TYPE := SUBSTR(package_name, 12) ;
1239: description cn_objects.description%TYPE
1240: := 'NULL collection procedure for ' || short_name;
1241: parameter_list cn_objects.parameter_list%TYPE
1242: := '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 1239: description cn_objects.description%TYPE

1235: -- Declare and initialize procedure variables
1236:
1237: procedure_name cn_objects.NAME%TYPE := 'collect';
1238: short_name cn_objects.NAME%TYPE := SUBSTR(package_name, 12) ;
1239: description cn_objects.description%TYPE
1240: := 'NULL collection procedure for ' || short_name;
1241: parameter_list cn_objects.parameter_list%TYPE
1242: := '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 ';
1243:

Line 1241: parameter_list cn_objects.parameter_list%TYPE

1237: procedure_name cn_objects.NAME%TYPE := 'collect';
1238: short_name cn_objects.NAME%TYPE := SUBSTR(package_name, 12) ;
1239: description cn_objects.description%TYPE
1240: := 'NULL collection procedure for ' || short_name;
1241: parameter_list cn_objects.parameter_list%TYPE
1242: := '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 ';
1243:
1244: BEGIN
1245:

Line 1307: x_package_name cn_objects.NAME%TYPE,

1303: --+
1304: PROCEDURE collection_pkg_code (
1305: debug_pipe VARCHAR2,
1306: debug_level NUMBER := 1,
1307: x_package_name cn_objects.NAME%TYPE,
1308: x_org_append VARCHAR2,
1309: x_collect_flag cn_modules.collect_flag%TYPE,
1310: x_module_id cn_modules.module_id%TYPE,
1311: x_generic BOOLEAN,

Line 1315: l_package_type cn_objects.package_type%TYPE;

1311: x_generic BOOLEAN,
1312: x_table_map_id cn_table_maps.table_map_id%TYPE,
1313: x_org_id IN NUMBER) IS
1314:
1315: l_package_type cn_objects.package_type%TYPE;
1316: l_package_spec_id cn_obj_packages_v.package_id%TYPE;
1317: l_package_body_id cn_obj_packages_v.package_id%TYPE;
1318: l_package_spec_desc cn_obj_packages_v.description%TYPE;
1319: l_package_body_desc cn_obj_packages_v.description%TYPE;

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

1359: null_proc(x_package_name, l_package_spec_id, x_module_id,
1360: l_repository_id, l_event_id, l_spec_code, l_body_code,X_org_id);
1361: END IF;
1362:
1363: -- Generate end package statements, dump code into cn_objects
1364:
1365: cn_utils.set_org_id(X_org_id);
1366: cn_utils.pkg_end(x_package_name, l_package_spec_id, l_package_body_id,
1367: l_spec_code, l_body_code);

Line 1429: l_package_name cn_objects.NAME%TYPE;

1425: x_org_id IN NUMBER) IS
1426:
1427: l_generic BOOLEAN := FALSE;
1428: l_module_id cn_modules.module_id%TYPE;
1429: l_package_name cn_objects.NAME%TYPE;
1430: l_mapping_type cn_objects.package_type%TYPE;
1431: --l_org_append VARCHAR2(100) := get_org_append;
1432: l_org_append VARCHAR2(100);
1433: BEGIN

Line 1430: l_mapping_type cn_objects.package_type%TYPE;

1426:
1427: l_generic BOOLEAN := FALSE;
1428: l_module_id cn_modules.module_id%TYPE;
1429: l_package_name cn_objects.NAME%TYPE;
1430: l_mapping_type cn_objects.package_type%TYPE;
1431: --l_org_append VARCHAR2(100) := get_org_append;
1432: l_org_append VARCHAR2(100);
1433: BEGIN
1434:

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

1497: -- +
1498: IF l_mapping_type <> 'OC' THEN
1499: l_generic := TRUE;
1500: --+
1501: -- For custom packages, the package name (as stored in CN_OBJECTS)
1502: -- is of the format cn_collect__
1503: --+
1504: l_org_append := NULL;
1505:

Line 1510: FROM cn_table_map_objects tmov, cn_objects obj

1506: END IF;
1507:
1508: SELECT OBJ.name OBJECT_NAME
1509: INTO l_package_name
1510: FROM cn_table_map_objects tmov, cn_objects obj
1511: WHERE tmov.table_map_id = x_table_map_id
1512: AND tmov.tm_object_type = 'PKS'
1513: and tmov.org_id = obj.org_id
1514: and tmov.object_id = obj.object_id

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

1578: --dbms_output.put_line('l_org_id '||l_org_id);
1579:
1580: --+
1581: -- We need to get the exact package name. For custom
1582: -- data sources, this is the same as the name stored in CN_OBJECTS. For AR and OC
1583: -- the name stored in CN_OBJECTS does not have the Org_id on it, so we must
1584: -- append this. (Also get module_id for later use)
1585: --+
1586:

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

1579:
1580: --+
1581: -- We need to get the exact package name. For custom
1582: -- data sources, this is the same as the name stored in CN_OBJECTS. For AR and OC
1583: -- the name stored in CN_OBJECTS does not have the Org_id on it, so we must
1584: -- append this. (Also get module_id for later use)
1585: --+
1586:
1587: SELECT mapping_type, module_id

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

1604:
1605: --+
1606: -- Loop for each package belonging to the source, getting
1607: -- the object_ids for the Spec and Body, plus the package
1608: -- name (from CN_OBJECTS). For AR there will
1609: -- be 4 packages, for any other source there will only be one.
1610: --+
1611:
1612: FOR rec IN

Line 1617: FROM cn_table_map_objects tmov, cn_objects obj

1613: (SELECT
1614: UPPER(OBJ.name) NAME ,
1615: MAX(DECODE(tmov.tm_object_type,'PKS',tmov.object_id,NULL)) spec_id,
1616: MAX(DECODE(tmov.tm_object_type,'PKB',tmov.object_id,NULL)) body_id
1617: FROM cn_table_map_objects tmov, cn_objects obj
1618: WHERE tmov.tm_object_type IN ('PKS','PKB')
1619: and obj.object_id = tmov.object_id
1620: and tmov.org_id = obj.org_id
1621: AND tmov.table_map_id = p_table_map_id

Line 1673: FROM cn_table_map_objects tmov, cn_objects obj

1669: --+
1670: FOR obj_rec IN
1671: (SELECT
1672: DISTINCT UPPER(OBJ.name) NAME
1673: FROM cn_table_map_objects tmov, cn_objects obj
1674: WHERE tm_object_type IN ('PKS','PKB')
1675: AND tmov.table_map_id = p_table_map_id
1676: and tmov.object_id = obj.object_id
1677: and tmov.org_id = obj.org_id

Line 1710: FROM cn_table_map_objects tmov, cn_objects obj

1706: x_org_id => X_org_id);
1707: FOR pkg_names IN
1708: (SELECT
1709: DISTINCT UPPER(OBJ.name) NAME
1710: FROM cn_table_map_objects tmov, cn_objects obj
1711: WHERE tm_object_type IN ('PKS','PKB')
1712: AND tmov.table_map_id = p_table_map_id
1713: and tmov.object_id = obj.object_id
1714: and tmov.org_id = obj.org_id

Line 1754: FROM cn_table_map_objects tmov, cn_objects obj

1750: IF p_test = 'N' and x_retcode=1 THEN
1751: FOR pkg_names IN
1752: (SELECT
1753: DISTINCT UPPER(OBJ.name) NAME
1754: FROM cn_table_map_objects tmov, cn_objects obj
1755: WHERE tm_object_type IN ('PKS','PKB')
1756: AND tmov.table_map_id = p_table_map_id
1757: and tmov.object_id = obj.object_id
1758: and tmov.org_id = obj.org_id