469: -- History
470: -- 22-MAR-94 Devesh Khatu Created
471: --
472: PROCEDURE record_process_exception (
473: procedure_name cn_obj_procedures_v.name%TYPE,
474: savepoint_name VARCHAR2,
475: code IN OUT NOCOPY cn_utils.code_type) IS
476: BEGIN
477: -- Generate code to handle errors
503: -- History
504: -- 22-MAR-94 Devesh Khatu Created
505: --
506: PROCEDURE record_process_exception (
507: procedure_name cn_obj_procedures_v.name%TYPE,
508: savepoint_name VARCHAR2,
509: code IN OUT NOCOPY cn_utils.clob_code_type) IS
510: BEGIN
511: -- Generate code to handle errors
970:
971:
972: PROCEDURE proc_init_boilerplate (
973: code IN OUT NOCOPY cn_utils.code_type,
974: procedure_name cn_obj_procedures_v.name%TYPE,
975: description cn_obj_procedures_v.description%TYPE) IS
976:
977: X_userid VARCHAR2(20);
978:
971:
972: PROCEDURE proc_init_boilerplate (
973: code IN OUT NOCOPY cn_utils.code_type,
974: procedure_name cn_obj_procedures_v.name%TYPE,
975: description cn_obj_procedures_v.description%TYPE) IS
976:
977: X_userid VARCHAR2(20);
978:
979: BEGIN
992:
993: --for clob
994: PROCEDURE proc_init_boilerplate (
995: code IN OUT NOCOPY cn_utils.clob_code_type,
996: procedure_name cn_obj_procedures_v.name%TYPE,
997: description cn_obj_procedures_v.description%TYPE) IS
998:
999: X_userid VARCHAR2(20);
1000:
993: --for clob
994: PROCEDURE proc_init_boilerplate (
995: code IN OUT NOCOPY cn_utils.clob_code_type,
996: procedure_name cn_obj_procedures_v.name%TYPE,
997: description cn_obj_procedures_v.description%TYPE) IS
998:
999: X_userid VARCHAR2(20);
1000:
1001: BEGIN
1013: END proc_init_boilerplate;
1014: --end clob
1015:
1016: PROCEDURE proc_init (
1017: procedure_name cn_obj_procedures_v.name%TYPE,
1018: description cn_obj_procedures_v.description%TYPE,
1019: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
1020: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
1021: return_type cn_obj_procedures_v.return_type%TYPE,
1014: --end clob
1015:
1016: PROCEDURE proc_init (
1017: procedure_name cn_obj_procedures_v.name%TYPE,
1018: description cn_obj_procedures_v.description%TYPE,
1019: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
1020: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
1021: return_type cn_obj_procedures_v.return_type%TYPE,
1022: package_id cn_obj_procedures_v.package_id%TYPE,
1015:
1016: PROCEDURE proc_init (
1017: procedure_name cn_obj_procedures_v.name%TYPE,
1018: description cn_obj_procedures_v.description%TYPE,
1019: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
1020: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
1021: return_type cn_obj_procedures_v.return_type%TYPE,
1022: package_id cn_obj_procedures_v.package_id%TYPE,
1023: repository_id cn_obj_procedures_v.repository_id%TYPE,
1016: PROCEDURE proc_init (
1017: procedure_name cn_obj_procedures_v.name%TYPE,
1018: description cn_obj_procedures_v.description%TYPE,
1019: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
1020: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
1021: return_type cn_obj_procedures_v.return_type%TYPE,
1022: package_id cn_obj_procedures_v.package_id%TYPE,
1023: repository_id cn_obj_procedures_v.repository_id%TYPE,
1024: spec_code IN OUT NOCOPY cn_utils.code_type,
1017: procedure_name cn_obj_procedures_v.name%TYPE,
1018: description cn_obj_procedures_v.description%TYPE,
1019: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
1020: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
1021: return_type cn_obj_procedures_v.return_type%TYPE,
1022: package_id cn_obj_procedures_v.package_id%TYPE,
1023: repository_id cn_obj_procedures_v.repository_id%TYPE,
1024: spec_code IN OUT NOCOPY cn_utils.code_type,
1025: body_code IN OUT NOCOPY cn_utils.code_type) IS
1018: description cn_obj_procedures_v.description%TYPE,
1019: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
1020: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
1021: return_type cn_obj_procedures_v.return_type%TYPE,
1022: package_id cn_obj_procedures_v.package_id%TYPE,
1023: repository_id cn_obj_procedures_v.repository_id%TYPE,
1024: spec_code IN OUT NOCOPY cn_utils.code_type,
1025: body_code IN OUT NOCOPY cn_utils.code_type) IS
1026:
1019: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
1020: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
1021: return_type cn_obj_procedures_v.return_type%TYPE,
1022: package_id cn_obj_procedures_v.package_id%TYPE,
1023: repository_id cn_obj_procedures_v.repository_id%TYPE,
1024: spec_code IN OUT NOCOPY cn_utils.code_type,
1025: body_code IN OUT NOCOPY cn_utils.code_type) IS
1026:
1027: X_rowid ROWID;
1060: END proc_init;
1061:
1062: --for clob
1063: PROCEDURE proc_init (
1064: procedure_name cn_obj_procedures_v.name%TYPE,
1065: description cn_obj_procedures_v.description%TYPE,
1066: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
1067: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
1068: return_type cn_obj_procedures_v.return_type%TYPE,
1061:
1062: --for clob
1063: PROCEDURE proc_init (
1064: procedure_name cn_obj_procedures_v.name%TYPE,
1065: description cn_obj_procedures_v.description%TYPE,
1066: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
1067: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
1068: return_type cn_obj_procedures_v.return_type%TYPE,
1069: package_id cn_obj_procedures_v.package_id%TYPE,
1062: --for clob
1063: PROCEDURE proc_init (
1064: procedure_name cn_obj_procedures_v.name%TYPE,
1065: description cn_obj_procedures_v.description%TYPE,
1066: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
1067: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
1068: return_type cn_obj_procedures_v.return_type%TYPE,
1069: package_id cn_obj_procedures_v.package_id%TYPE,
1070: repository_id cn_obj_procedures_v.repository_id%TYPE,
1063: PROCEDURE proc_init (
1064: procedure_name cn_obj_procedures_v.name%TYPE,
1065: description cn_obj_procedures_v.description%TYPE,
1066: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
1067: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
1068: return_type cn_obj_procedures_v.return_type%TYPE,
1069: package_id cn_obj_procedures_v.package_id%TYPE,
1070: repository_id cn_obj_procedures_v.repository_id%TYPE,
1071: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
1064: procedure_name cn_obj_procedures_v.name%TYPE,
1065: description cn_obj_procedures_v.description%TYPE,
1066: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
1067: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
1068: return_type cn_obj_procedures_v.return_type%TYPE,
1069: package_id cn_obj_procedures_v.package_id%TYPE,
1070: repository_id cn_obj_procedures_v.repository_id%TYPE,
1071: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
1072: body_code IN OUT NOCOPY cn_utils.clob_code_type) IS
1065: description cn_obj_procedures_v.description%TYPE,
1066: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
1067: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
1068: return_type cn_obj_procedures_v.return_type%TYPE,
1069: package_id cn_obj_procedures_v.package_id%TYPE,
1070: repository_id cn_obj_procedures_v.repository_id%TYPE,
1071: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
1072: body_code IN OUT NOCOPY cn_utils.clob_code_type) IS
1073:
1066: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
1067: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
1068: return_type cn_obj_procedures_v.return_type%TYPE,
1069: package_id cn_obj_procedures_v.package_id%TYPE,
1070: repository_id cn_obj_procedures_v.repository_id%TYPE,
1071: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
1072: body_code IN OUT NOCOPY cn_utils.clob_code_type) IS
1073:
1074: X_rowid ROWID;
1109: --end clob
1110:
1111:
1112: PROCEDURE proc_begin (
1113: procedure_name cn_obj_procedures_v.name%TYPE,
1114: generate_debug_pipe VARCHAR2,
1115: code IN OUT NOCOPY cn_utils.code_type) IS
1116:
1117: BEGIN
1134: END proc_begin;
1135:
1136: --for clob
1137: PROCEDURE proc_begin (
1138: procedure_name cn_obj_procedures_v.name%TYPE,
1139: generate_debug_pipe VARCHAR2,
1140: code IN OUT NOCOPY cn_utils.clob_code_type) IS
1141: BEGIN
1142: cn_debug.print_msg('proc_begin>>', 1);
1159: --end clob
1160:
1161:
1162: PROCEDURE proc_end (
1163: procedure_name cn_obj_procedures_v.name%TYPE,
1164: exception_flag VARCHAR2,
1165: code IN OUT NOCOPY cn_utils.code_type) IS
1166:
1167: BEGIN
1183: END proc_end;
1184:
1185: --for clob
1186: PROCEDURE proc_end (
1187: procedure_name cn_obj_procedures_v.name%TYPE,
1188: exception_flag VARCHAR2,
1189: code IN OUT NOCOPY cn_utils.clob_code_type) IS
1190:
1191: BEGIN