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 250: x_module_id cn_modules.module_id%TYPE,

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

Line 368: x_module_id cn_modules.module_id%TYPE,

364:
365: PROCEDURE call_identify (
366: x_package_id cn_obj_packages_v.package_id%TYPE,
367: procedure_name cn_obj_procedures_v.NAME%TYPE,
368: x_module_id cn_modules.module_id%TYPE,
369: x_repository_id cn_repositories.repository_id%TYPE,
370: x_event_id cn_events.event_id%TYPE,
371: code IN OUT NOCOPY cn_utils.code_type,
372: x_org_id IN NUMBER)

Line 449: x_module_id cn_modules.module_id%TYPE,

445:
446: PROCEDURE call_negate (
447: x_package_id cn_obj_packages_v.package_id%TYPE,
448: procedure_name cn_obj_procedures_v.NAME%TYPE,
449: x_module_id cn_modules.module_id%TYPE,
450: x_repository_id cn_repositories.repository_id%TYPE,
451: x_event_id cn_events.event_id%TYPE,
452: code IN OUT NOCOPY cn_utils.code_type,
453: x_org_id IN NUMBER)

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

724: x_procedure_name cn_obj_procedures_v.NAME%TYPE,
725: x_description cn_obj_procedures_v.description%TYPE,
726: x_parameter_list cn_obj_procedures_v.parameter_list%TYPE,
727: x_package_id cn_obj_packages_v.package_id%TYPE,
728: x_module_id cn_modules.module_id%TYPE, --AE 01-26-96
729: x_repository_id cn_repositories.repository_id%TYPE,
730: x_event_id cn_events.event_id%TYPE,
731: x_generic BOOLEAN,
732: spec_code IN OUT NOCOPY cn_utils.code_type,

Line 866: x_module_id cn_modules.module_id%TYPE,

862: PROCEDURE collect_stmts (
863: x_package_id cn_obj_packages_v.package_id%TYPE,
864: x_procedure_name cn_obj_procedures_v.NAME%TYPE,
865: x_table_map_id cn_table_maps.table_map_id%TYPE,
866: x_module_id cn_modules.module_id%TYPE,
867: x_repository_id cn_repositories.repository_id%TYPE,
868: x_generic BOOLEAN,
869: x_event_id cn_events.event_id%TYPE,
870: code IN OUT NOCOPY cn_utils.code_type,

Line 1155: module_id cn_modules.module_id%TYPE,

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

Line 1228: module_id cn_modules.module_id%TYPE,

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

Line 1309: x_collect_flag cn_modules.collect_flag%TYPE,

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

Line 1310: x_module_id cn_modules.module_id%TYPE,

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

Line 1428: l_module_id cn_modules.module_id%TYPE;

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

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

1460: -- four collection packages, depending on whether they
1461: -- are currently flagged for collection
1462: --+
1463: FOR rec IN
1464: (SELECT module_id, module_type, collect_flag FROM cn_modules
1465: WHERE module_type IN ('INV','CBK','PMT','WO','RAM') AND org_id = x_org_id)
1466: LOOP
1467: IF rec.module_type = 'INV' THEN
1468: l_package_name := 'cn_collect_invoices';

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

1700:
1701: -- Update the status of the module to 'GENERATED' if we were installing
1702: -- the actual package rather than the test version.
1703: IF p_test = 'N' and x_retcode<>1 THEN
1704: cn_modules_pkg.update_row(x_module_id => l_module_id,
1705: x_module_status => 'GENERATED',
1706: x_org_id => X_org_id);
1707: FOR pkg_names IN
1708: (SELECT

Line 1726: l_context_code := 'CN_MODULES';

1722: l_context_code := 'CN_REPOSITORIES';
1723: l_context_id := x_org_id;
1724: ELSE
1725: l_pkg_name := pkg_names.NAME;
1726: l_context_code := 'CN_MODULES';
1727: l_context_id := l_module_id;
1728: END IF;
1729: -- Adding notes for Transaction Source Type
1730: FND_MESSAGE.SET_NAME('CN', 'CN_COL_PKG_GEN_SUC');

Line 1770: l_context_code := 'CN_MODULES';

1766: l_context_code := 'CN_REPOSITORIES';
1767: l_context_id := x_org_id;
1768: ELSE
1769: l_pkg_name := pkg_names.NAME;
1770: l_context_code := 'CN_MODULES';
1771: l_context_id := l_module_id;
1772: END IF;
1773: -- Adding notes for Transaction Source Type
1774: FND_MESSAGE.SET_NAME('CN', 'CN_COL_PKG_GEN_FAIL');

Line 1815: cn_modules_all_b mo

1811: tm.org_id,
1812: tm.module_id,
1813: mo.module_status
1814: FROM cn_table_maps_all tm,
1815: cn_modules_all_b mo
1816: WHERE tm.module_id = mo.module_id
1817: AND tm.org_id = mo.org_id
1818: AND mo.module_status = 'GENERATED'
1819: AND mo.org_id = nvl(p_org_id, mo.org_id)