[Home] [Help]
165: -- 01-26-96 Jin Cheng Created
166:
167: PROCEDURE call_start_debug(
168: procedure_name IN cn_obj_procedures_v.NAME%TYPE,
169: x_event_id IN cn_events.event_id%TYPE,
170: code IN OUT NOCOPY cn_utils.code_type,
171: x_org_id IN NUMBER)
172: IS
173:
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
257:
258: x_row_count NUMBER;
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)
380: IS
381:
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)
461: IS
462:
529: -- 17-NOV-93 Devesh Khatu Created
530:
531: PROCEDURE local_variables (
532: procedure_name VARCHAR2,
533: x_event_id cn_events.event_id%TYPE,
534: code IN OUT NOCOPY cn_utils.code_type,
535: x_org_id IN NUMBER) IS
536: BEGIN
537:
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,
752: body_code IN OUT NOCOPY cn_utils.code_type,
753: x_org_id IN NUMBER)
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,
902: x_org_id IN NUMBER) IS
903:
904: BEGIN
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
1097:
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,
1207: body_code IN OUT NOCOPY cn_utils.code_type,
1208: x_org_id IN NUMBER) IS
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,
1283: x_org_id IN NUMBER) IS
1284:
1370: l_repository_id cn_repositories.repository_id%TYPE
1371: := cn_utils.get_repository(X_MODULE_ID,x_org_id);
1372: l_spec_code cn_utils.code_type;
1373: l_body_code cn_utils.code_type;
1374: l_event_id cn_events.event_id%TYPE
1375: := cn_utils.get_event(x_module_id,x_org_id);
1376:
1377: BEGIN
1378: