DBA Data[Home] [Help]

APPS.CN_UTILS dependencies on CN_OBJ_PROCEDURES_V

Line 473: procedure_name cn_obj_procedures_v.name%TYPE,

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

Line 507: procedure_name cn_obj_procedures_v.name%TYPE,

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

Line 974: procedure_name cn_obj_procedures_v.name%TYPE,

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:

Line 975: description cn_obj_procedures_v.description%TYPE) IS

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

Line 996: procedure_name cn_obj_procedures_v.name%TYPE,

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:

Line 997: description cn_obj_procedures_v.description%TYPE) IS

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

Line 1017: procedure_name cn_obj_procedures_v.name%TYPE,

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,

Line 1018: description cn_obj_procedures_v.description%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,

Line 1019: parameter_list cn_obj_procedures_v.parameter_list%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,

Line 1020: procedure_type cn_obj_procedures_v.procedure_type%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,

Line 1021: return_type cn_obj_procedures_v.return_type%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

Line 1022: package_id cn_obj_procedures_v.package_id%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
1026:

Line 1023: repository_id cn_obj_procedures_v.repository_id%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:
1027: X_rowid ROWID;

Line 1064: procedure_name cn_obj_procedures_v.name%TYPE,

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,

Line 1065: description cn_obj_procedures_v.description%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,

Line 1066: parameter_list cn_obj_procedures_v.parameter_list%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,

Line 1067: procedure_type cn_obj_procedures_v.procedure_type%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,

Line 1068: return_type cn_obj_procedures_v.return_type%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

Line 1069: package_id cn_obj_procedures_v.package_id%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
1073:

Line 1070: repository_id cn_obj_procedures_v.repository_id%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:
1074: X_rowid ROWID;

Line 1113: procedure_name cn_obj_procedures_v.name%TYPE,

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

Line 1138: procedure_name cn_obj_procedures_v.name%TYPE,

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);

Line 1163: procedure_name cn_obj_procedures_v.name%TYPE,

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

Line 1187: procedure_name cn_obj_procedures_v.name%TYPE,

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