1078: if( (length(l_return)+length(l_description)) <31999) then
1079: l_return := l_return || l_description;
1080: else
1081: IF(l_ret_clob IS NULL) THEN
1082: WF_NOTIFICATION.NewClob(l_ret_clob, l_return);
1083: ELSE
1084: WF_NOTIFICATION.WriteToClob(l_ret_clob,l_return);
1085: END IF;
1086: l_return := l_description;
1080: else
1081: IF(l_ret_clob IS NULL) THEN
1082: WF_NOTIFICATION.NewClob(l_ret_clob, l_return);
1083: ELSE
1084: WF_NOTIFICATION.WriteToClob(l_ret_clob,l_return);
1085: END IF;
1086: l_return := l_description;
1087: end if;
1088: ELSE
1089: if( (length(l_return)+length(l_column)) <31999) then
1090: l_return := l_return || l_column;
1091: else
1092: IF(l_ret_clob IS NULL) THEN
1093: WF_NOTIFICATION.NewClob(l_ret_clob, l_return);
1094: ELSE
1095: WF_NOTIFICATION.WriteToClob(l_ret_clob,l_return);
1096: END IF;
1097: l_return := l_column;
1091: else
1092: IF(l_ret_clob IS NULL) THEN
1093: WF_NOTIFICATION.NewClob(l_ret_clob, l_return);
1094: ELSE
1095: WF_NOTIFICATION.WriteToClob(l_ret_clob,l_return);
1096: END IF;
1097: l_return := l_column;
1098: end if;
1099: END IF;
1111: if( (length(l_return)+length(l_description)) <31999) then
1112: l_return := l_return || l_description;
1113: else
1114: IF(l_ret_clob IS NULL) THEN
1115: WF_NOTIFICATION.NewClob(l_ret_clob, l_return);
1116: ELSE
1117: WF_NOTIFICATION.WriteToClob(l_ret_clob,l_return);
1118: END IF;
1119: l_return := l_description;
1113: else
1114: IF(l_ret_clob IS NULL) THEN
1115: WF_NOTIFICATION.NewClob(l_ret_clob, l_return);
1116: ELSE
1117: WF_NOTIFICATION.WriteToClob(l_ret_clob,l_return);
1118: END IF;
1119: l_return := l_description;
1120: end if;
1121: ELSE
1122: if( (length(l_return)+length(l_column)) <31999) then
1123: l_return := l_return || l_column;
1124: else
1125: IF(l_ret_clob IS NULL) THEN
1126: WF_NOTIFICATION.NewClob(l_ret_clob, l_return);
1127: ELSE
1128: WF_NOTIFICATION.WriteToClob(l_ret_clob,l_return);
1129: END IF;
1130: l_return := l_column;
1124: else
1125: IF(l_ret_clob IS NULL) THEN
1126: WF_NOTIFICATION.NewClob(l_ret_clob, l_return);
1127: ELSE
1128: WF_NOTIFICATION.WriteToClob(l_ret_clob,l_return);
1129: END IF;
1130: l_return := l_column;
1131: end if;
1132: END IF;
1150: if( (length(l_return)+length(l_description)) <31999) then
1151: l_return := l_return || l_description;
1152: else
1153: IF(l_ret_clob IS NULL) THEN
1154: WF_NOTIFICATION.NewClob(l_ret_clob, l_return);
1155: ELSE
1156: WF_NOTIFICATION.WriteToClob(l_ret_clob,l_return);
1157: END IF;
1158: l_return := l_description;
1152: else
1153: IF(l_ret_clob IS NULL) THEN
1154: WF_NOTIFICATION.NewClob(l_ret_clob, l_return);
1155: ELSE
1156: WF_NOTIFICATION.WriteToClob(l_ret_clob,l_return);
1157: END IF;
1158: l_return := l_description;
1159: end if;
1160: ELSE
1161: if( (length(l_return)+length(l_column)) <31999) then
1162: l_return := l_return || l_column;
1163: else
1164: IF(l_ret_clob IS NULL) THEN
1165: WF_NOTIFICATION.NewClob(l_ret_clob, l_return);
1166: ELSE
1167: WF_NOTIFICATION.WriteToClob(l_ret_clob,l_return);
1168: END IF;
1169: l_return := l_column;
1163: else
1164: IF(l_ret_clob IS NULL) THEN
1165: WF_NOTIFICATION.NewClob(l_ret_clob, l_return);
1166: ELSE
1167: WF_NOTIFICATION.WriteToClob(l_ret_clob,l_return);
1168: END IF;
1169: l_return := l_column;
1170: end if;
1171: END IF;
1175: END IF;
1176: END IF;
1177: IF(l_return IS NOT NULL) THEN
1178: IF(l_ret_clob IS NULL) THEN
1179: WF_NOTIFICATION.NewClob(l_ret_clob, l_return);
1180: ELSE
1181: WF_NOTIFICATION.WriteToClob(l_ret_clob,l_return);
1182: END IF;
1183: END IF;
1177: IF(l_return IS NOT NULL) THEN
1178: IF(l_ret_clob IS NULL) THEN
1179: WF_NOTIFICATION.NewClob(l_ret_clob, l_return);
1180: ELSE
1181: WF_NOTIFICATION.WriteToClob(l_ret_clob,l_return);
1182: END IF;
1183: END IF;
1184: return l_ret_clob;
1185: END;