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_MODULES

Line 252: x_module_id cn_modules.module_id%TYPE,

248:
249: PROCEDURE call_notify (
250: x_package_id cn_obj_packages_v.package_id%TYPE,
251: procedure_name cn_obj_procedures_v.NAME%TYPE,
252: x_module_id cn_modules.module_id%TYPE,
253: x_repository_id cn_repositories.repository_id%TYPE,
254: x_event_id cn_events.event_id%TYPE,
255: code IN OUT NOCOPY cn_utils.code_type,
256: x_org_id IN NUMBER) IS

Line 375: x_module_id cn_modules.module_id%TYPE,

371:
372: PROCEDURE call_identify (
373: x_package_id cn_obj_packages_v.package_id%TYPE,
374: procedure_name cn_obj_procedures_v.NAME%TYPE,
375: x_module_id cn_modules.module_id%TYPE,
376: x_repository_id cn_repositories.repository_id%TYPE,
377: x_event_id cn_events.event_id%TYPE,
378: code IN OUT NOCOPY cn_utils.code_type,
379: x_org_id IN NUMBER)

Line 456: x_module_id cn_modules.module_id%TYPE,

452:
453: PROCEDURE call_negate (
454: x_package_id cn_obj_packages_v.package_id%TYPE,
455: procedure_name cn_obj_procedures_v.NAME%TYPE,
456: x_module_id cn_modules.module_id%TYPE,
457: x_repository_id cn_repositories.repository_id%TYPE,
458: x_event_id cn_events.event_id%TYPE,
459: code IN OUT NOCOPY cn_utils.code_type,
460: x_org_id IN NUMBER)

Line 747: x_module_id cn_modules.module_id%TYPE, --AE 01-26-96

743: x_procedure_name cn_obj_procedures_v.NAME%TYPE,
744: x_description cn_obj_procedures_v.description%TYPE,
745: x_parameter_list cn_obj_procedures_v.parameter_list%TYPE,
746: x_package_id cn_obj_packages_v.package_id%TYPE,
747: x_module_id cn_modules.module_id%TYPE, --AE 01-26-96
748: x_repository_id cn_repositories.repository_id%TYPE,
749: x_event_id cn_events.event_id%TYPE,
750: x_generic BOOLEAN,
751: spec_code IN OUT NOCOPY cn_utils.code_type,

Line 897: x_module_id cn_modules.module_id%TYPE,

893: PROCEDURE collect_stmts (
894: x_package_id cn_obj_packages_v.package_id%TYPE,
895: x_procedure_name cn_obj_procedures_v.NAME%TYPE,
896: x_table_map_id cn_table_maps.table_map_id%TYPE,
897: x_module_id cn_modules.module_id%TYPE,
898: x_repository_id cn_repositories.repository_id%TYPE,
899: x_generic BOOLEAN,
900: x_event_id cn_events.event_id%TYPE,
901: code IN OUT NOCOPY cn_utils.code_type,

Line 1202: module_id cn_modules.module_id%TYPE,

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,
1205: x_generic BOOLEAN,
1206: spec_code IN OUT NOCOPY cn_utils.code_type,

Line 1278: module_id cn_modules.module_id%TYPE,

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,
1281: spec_code IN OUT NOCOPY cn_utils.code_type,
1282: body_code IN OUT NOCOPY cn_utils.code_type,

Line 1359: x_collect_flag cn_modules.collect_flag%TYPE,

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,
1362: x_table_map_id cn_table_maps.table_map_id%TYPE,
1363: x_org_id IN NUMBER) IS

Line 1360: x_module_id cn_modules.module_id%TYPE,

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,
1362: x_table_map_id cn_table_maps.table_map_id%TYPE,
1363: x_org_id IN NUMBER) IS
1364:

Line 1478: l_module_id cn_modules.module_id%TYPE;

1474: x_table_map_id cn_table_maps.table_map_id%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);

Line 1521: (SELECT module_id, module_type, collect_flag FROM cn_modules

1517: -- four collection packages, depending on whether they
1518: -- are currently flagged for collection
1519: --+
1520: FOR rec IN
1521: (SELECT module_id, module_type, collect_flag FROM cn_modules
1522: WHERE module_type IN ('INV','CBK','PMT','WO','RAM') AND org_id = x_org_id)
1523: LOOP
1524: IF rec.module_type = 'INV' THEN
1525: l_package_name := 'cn_collect_invoices';

Line 1769: cn_modules_pkg.update_row(x_module_id => l_module_id,

1765:
1766: -- Update the status of the module to 'GENERATED' if we were installing
1767: -- the actual package rather than the test version.
1768: IF p_test = 'N' and x_retcode<>1 THEN
1769: cn_modules_pkg.update_row(x_module_id => l_module_id,
1770: x_module_status => 'GENERATED',
1771: x_org_id => X_org_id);
1772: FOR pkg_names IN
1773: (SELECT

Line 1791: l_context_code := 'CN_MODULES';

1787: l_context_code := 'CN_REPOSITORIES';
1788: l_context_id := x_org_id;
1789: ELSE
1790: l_pkg_name := pkg_names.NAME;
1791: l_context_code := 'CN_MODULES';
1792: l_context_id := l_module_id;
1793: END IF;
1794: -- Adding notes for Transaction Source Type
1795: FND_MESSAGE.SET_NAME('CN', 'CN_COL_PKG_GEN_SUC');

Line 1835: l_context_code := 'CN_MODULES';

1831: l_context_code := 'CN_REPOSITORIES';
1832: l_context_id := x_org_id;
1833: ELSE
1834: l_pkg_name := pkg_names.NAME;
1835: l_context_code := 'CN_MODULES';
1836: l_context_id := l_module_id;
1837: END IF;
1838: -- Adding notes for Transaction Source Type
1839: FND_MESSAGE.SET_NAME('CN', 'CN_COL_PKG_GEN_FAIL');

Line 1880: cn_modules_all_b mo

1876: tm.org_id,
1877: tm.module_id,
1878: mo.module_status
1879: FROM cn_table_maps_all tm,
1880: cn_modules_all_b mo
1881: WHERE tm.module_id = mo.module_id
1882: AND tm.org_id = mo.org_id
1883: AND mo.module_status = 'GENERATED'
1884: AND mo.org_id = nvl(p_org_id, mo.org_id)